Seine-Maritime (76) : salles à louer, salles de mariages, salles de réunion, salles de réception
/var/www/vhosts/123-location-salle.fr/httpdocs/scripts/details.php129SELECT *, (6371 * acos( cos( radians('49.6054187') ) * cos( radians( lat ) ) * cos( radians( lng ) - radians('0.9748439')) + sin( radians('49.6054187') ) * sin( radians( lat ) ) ) ) AS distance,
IF (photo1='',0,1) AS photos
FROM annonces
WHERE (type LIKE 'communales')
AND (etat=1)
AND ((assis=0) OR (assis >= 0) AND (assis <= 10000))
AND ((debout=0) OR (debout >= 0) AND (debout <= 10000))
AND (hebgt LIKE '%')
AND (handicap LIKE '%')
AND (wifi LIKE '%')
AND (dPiscine LIKE '%')
AND (dTennis LIKE '%')
AND (dSpa LIKE '%')
HAVING distance < '5'
ORDER BY mode ASC, photos DESC, distance LIMIT 0 , 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 '' at line 15