SELECT t0.id AS pid,t0.pk AS pk,t0.pkb AS pkb,t0.cck AS cck,t0.storage_location AS loc,tt.id AS type_id,tt.alias AS type_alias,(((acos(sin((43.124228*pi()/180)) * sin((t1.latitude_p*pi()/180))+cos((43.124228*pi()/180)) * cos((t1.latitude_p*pi()/180)) * cos(((5.928- t1.longitude_p)*pi()/180))))*180/pi())*60*1.1515*1.609344) AS distance
FROM `#__cck_core` AS t0
LEFT JOIN `#__cck_store_form_piece` AS t1 ON t1.id = t0.pk
LEFT JOIN `#__content` AS t2 ON t2.id = t0.pk
LEFT JOIN `#__cck_core_types` AS tt ON tt.name = t0.cck
WHERE t2.state = 1 AND t2.access IN (1,1,2,3,6) AND ( t2.publish_up = '0000-00-00 00:00:00' OR t2.publish_up <= '2015-01-07 12:43:10' ) AND ( t2.publish_down = '0000-00-00 00:00:00' OR t2.publish_down >= '2015-01-07 12:43:10' ) AND t0.cck = 'piece' GROUP BY t0.pk HAVING distance < 10
ORDER BY t1.date_event ASC

0.011 seconds (0.011); 14.29 MB (14.295) - afterSearch [Cache=OFF] = 1 result.
0.109 seconds (0.098); 18.44 MB (4.143) - afterRender [Cache=OFF]