SELECT *
FROM
(SELECT
id, titel_nl, titel_de, titel_en, titel_fr, `all_items_site`.`cat_id_int` AS category,
ROUND( 6371000 * acos(
cos(radians(51.4413095+0.00000001)) * cos(radians(map_latitude)) * cos(radians(map_longitude) - radians(3.5777985)) + sin(radians(51.4413095+0.00000001)) * sin(radians(map_latitude))
) ) AS distance_meter, all_category_url.name_single
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 = 'en'
WHERE
map_latitude > 51.3913095 AND
map_latitude < 51.4913095 AND
map_longitude > 3.5277985 AND
map_longitude < 3.6277985 AND
all_items.type >= 1 AND
all_items_site.type_id >= 4 AND
`all_items_site`.`cat_id_int` = 21 AND
all_items_site.site_id = 2 AND
all_items_site.item_id != 9082
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(691): Database->getRows()
#2 /data/www/myrs.net/public_html/site_item_moreinfo.php(723): Accos->DichtstbijzijndeBezienswaardigheid()
#3 /data/www/domburg.com/public_html/en/item.php(1): include_once('...')
#4 {main}
thrown in /data/www/myrs.net/public_html/classes/database.php on line 31