Query runs very sloooow

[Johan Thorvaldsson]

I need help to optimize this following query. It runs very slow and I cant
find any direct errors in it.
SELECT
1 * t1.termfreq as viktatantal,
t1.tag, t1.url FROM tag_keys t1
LEFT JOIN tag_ad_map tm1 ON t1.id = tm1.tag_id
LEFT JOIN tag_ad_map tm2 ON tm1.ad_id = tm2.ad_id
LEFT JOIN tag_keys t2 ON t2.id = tm2.tag_id
 WHERE
 t2.url = 'motor' AND t1.url != 'motor'
GROUP BY t1.id
ORDER BY viktatantal DESC, RAND()
LIMIT 80

Any help would be very appriciated!