Mysql SELECT DISTINCT itdesc.*, ((itdesc.latitude-48.8461)*(itdesc.latitude-48.8461)+(itdesc.longitude-2.34833)*(itdesc.longitude-2.34833)) AS km FROM joo_sobi2_fields_data AS dt, joo_sobi2_cat_items_relations AS rel, joo_sobi2_item AS itdesc, joo_sobi2_cats_relations AS catrel WHERE ((itdesc.longitude IS NOT NULL) AND (itdesc.published=1) AND (rel.itemid=dt.itemid) AND (((rel.catid=catrel.catid) AND (catrel.parentid=36)) OR ( rel.catid=36 )) AND (dt.itemid=itdesc.itemid )) ORDER BY km ASC LIMIT 51; failed