You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) + COS(RADIANS(lat_annonce)) * COS(RADIANS()) * COS(RADIANS(lon_annonce - )))' at line 1 - SELECT id_annonce, REPLACE(nom_annonce, "''", "'") AS nom_annonce, tel_annonce, adresse_annonce, code_postal, REPLACE(ville_fr, "''", "'") AS ville, id_ville_annonce, id_ville_affichee_annonce, ref_annonce, tarif_mini, tarif_maxi, tarif_mini_nuit, tarif_maxi_nuit, tarif_mini_weekend, tarif_maxi_weekend, nb_pieces_location, nb_etoiles_camping, nb_empl_camping, nb_chambres, nb_personnes, desc_type_annonces_fr, rep_type_annonce_fr AS rep_type_annonce, lat_annonce, lon_annonce, id_ville_proche_annonce, ville_id, situation_ville_proche, id_annonce_assoc, MIN(ordre_photo) AS min_ordre, LEFT(numero_officiel, 2) AS numero_officiel, DEGREES(ACOS(SIN(RADIANS(lat_annonce)) * SIN(RADIANS()) + COS(RADIANS(lat_annonce)) * COS(RADIANS()) * COS(RADIANS(lon_annonce - )))) * 60 * 1.1515 * 1.609344 AS distance, id_type_annonce, ('2012-05-28' BETWEEN date_boost AND DATE_ADD(date_boost, INTERVAL duree_boost MONTH) AND valid_boost='1') AS is_boost, superficie_gite, date_autorisation, nb_clevacances, nb_epis_gdf FROM geo_cp, geo_departements, annonces_types, annonces LEFT JOIN annonces_photos ON id_annonce_photo=id_annonce WHERE id_hotel_copy=0 AND dept_id=depart_id AND id_type_annonces=id_type_annonce AND id_type_annonce=2 AND autorisation_annonce='1' AND id_ville_affichee_annonce=id_code AND dept_id IN () GROUP BY id_annonce HAVING (ville_id<>4804 AND distance<=20) OR (ville_id=4804) ORDER BY is_boost DESC, date_autorisation<>'0000-00-00' DESC, DEGREES(ACOS(SIN(RADIANS(lat_annonce)) * SIN(RADIANS()) + COS(RADIANS(lat_annonce)) * COS(RADIANS()) * COS(RADIANS(lon_annonce - )))) * 60 * 1.1515 * 1.609344 ASC
|
