@ - Duisburg Tonight

Mai 2012

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(location_lat)) * COS(RADIANS()) * COS(RADIANS(locat' at line 17SQL-Server meldet: 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(location_lat)) * COS(RADIANS()) * COS(RADIANS(locat' at line 17
SQL: SELECT SQL_CALC_FOUND_ROWS modul_locations.* ,( SELECT COUNT(a.event_id) AS count FROM modul_events AS a LEFT JOIN modul_location_event_helper AS b USING(event_id) WHERE a.event_public = 1 AND (UNIX_TIMESTAMP(a.event_end) > UNIX_TIMESTAMP(NOW())) AND b.location_id = modul_locations.location_id ) AS events_count ,( SELECT COUNT(ma.id) AS count FROM modul_location_event_helper AS leh LEFT JOIN modul_mediagallery_albums AS ma ON ma.event_id = leh.event_id WHERE leh.location_id = modul_locations.location_id GROUP BY leh.location_id ) AS gallery_count ,ACOS( SIN(RADIANS(location_lat)) * SIN(RADIANS()) + COS(RADIANS(location_lat)) * COS(RADIANS()) * COS(RADIANS(location_long) - RADIANS()) ) * 6380 AS distance , media.name AS logo_name, media.folder AS logo_folder, media.filename AS logo_filename, REPLACE( CONCAT( '/projects/', location_project_id, '/files/userfiles', media.folder, media.filename ), '//', '/') AS logo_uri FROM modul_locations LEFT JOIN media ON (media.id = modul_locations.location_logo) WHERE 1=1 AND location_project_id = 3 AND modul_locations.location_public = 1 AND location_lat !='' AND location_long!='' AND ACOS( SIN(RADIANS(location_lat)) * SIN(RADIANS()) + COS(RADIANS(location_lat)) * COS(RADIANS()) * COS(RADIANS(location_long) - RADIANS()) ) * 6380 < 55 ORDER BY distance DESC LIMIT 0, 10

Events Galerien