SELECT a.* , (((acos(sin((*pi()/180)) * sin((`lat`*pi()/180))+cos((*pi()/180)) * cos((`lat`*pi()/180)) * cos((( - `long`)*pi()/180))))*180/pi())*60*1.1515) AS distance,b.title as category, b.parent_id,c.title as maincategory FROM #__echteritaliener_kunden as a LEFT JOIN #__categories AS b on b.id = a.cid LEFT JOIN #__categories AS c on c.id = b.parent_id WHERE a.f_premium = 1 AND a.state = 1 HAVING distance < 100000 ORDER BY distance ASC