Frans Hals Museum

Frans Hals Museum - 1 Frans Hals Museum (July 2024) - #2Frans Hals Museum (July 2024) - #3Frans Hals Museum (July 2024) - #4
SELECT all_items.*, all_category_url.name_single FROM (SELECT id, titel_nl, titel_de, titel_en, titel_fr, `all_items_site`.`cat_id_int` AS category, ROUND( 6371000 * acos( cos(radians(52.3766055+0.00000001)) * cos(radians(map_latitude)) * cos(radians(map_longitude) - radians(4.6336855)) + sin(radians(52.3766055+0.00000001)) * sin(radians(map_latitude)) ) ) AS distance_meter FROM all_items LEFT JOIN all_items_site ON all_items.id = all_items_site.item_id JOIN all_category_url ON `all_items_site`.`cat_id` = all_category_url.id AND all_category_url.lang = 'de' WHERE `map_latitude` > 52.3266055 AND `map_latitude` < 52.4266055 AND `map_longitude` > 4.5836855 AND `map_longitude` < 4.6836855 AND `type` >= 1 AND `all_items_site`.`type_id` >= 4 AND `all_items_site`.`cat_id_int` = 21 AND `all_items_site`.`site_id` = 15 AND `all_items_site`.`item_id` != 9357 GROUP BY all_items_site.item_id ORDER BY distance_meter ASC LIMIT 5) AS all_nearby_beziens WHERE distance_meter < '4000' ORDER BY category
Fatal error: Uncaught mysqli_sql_exception: Column 'id' in field list is ambiguous in /data/www/myrs.net/public_html/classes/database.php:31 Stack trace: #0 /data/www/myrs.net/public_html/classes/database.php(31): mysqli_query() #1 /data/www/myrs.net/public_html/classes/accos.php(693): Database->getRows() #2 /data/www/myrs.net/public_html/site_item_moreinfo.php(723): Accos->DichtstbijzijndeBezienswaardigheid() #3 /data/www/wijkaanzee.net/public_html/de/item.php(1): include_once('...') #4 {main} thrown in /data/www/myrs.net/public_html/classes/database.php on line 31