Symphony Fatal Database Error: Column 'id' in order clause is ambiguous
An error occurred while attempting to execute the following query
-
SELECT SQL_CACHE SQL_CALC_FOUND_ROWS `e`.id as id, `e`.section_id, e.`author_id`, UNIX_TIMESTAMP(e.`creation_date`) AS `creation_date`, UNIX_TIMESTAMP(e.`modification_date`) AS `modification_date`, `e`.`id`
FROM `sym_entries` AS `e`
LEFT JOIN `sym_entries_data_81` AS `t81` ON (`e`.`id` = `t81`.entry_id)
WHERE `e`.`section_id` = 12
AND (`t81`.relation_id IN ('54') )
UNION DISTINCT
SELECT `e`.id as id, `e`.section_id, e.`author_id`, UNIX_TIMESTAMP(e.`creation_date`) AS `creation_date`, UNIX_TIMESTAMP(e.`modification_date`) AS `modification_date`, `e`.`id`
FROM `sym_entries` AS `e`
LEFT JOIN `sym_entries_data_135` AS `t135` ON (`e`.`id` = `t135`.entry_id) LEFT JOIN `sym_entries_data_140` AS `t140_0` ON (`e`.`id` = `t140_0`.entry_id)
WHERE `e`.`section_id` = 21
AND (`t135`.relation_id IN ('54') ) AND (
t140_0.value IN ('Zichtbaar voor iedereen', 'Zichtbaar en tip van de week')
OR t140_0.handle IN ('Zichtbaar voor iedereen', 'Zichtbaar en tip van de week')
)
UNION DISTINCT
SELECT `e`.id as id, `e`.section_id, e.`author_id`, UNIX_TIMESTAMP(e.`creation_date`) AS `creation_date`, UNIX_TIMESTAMP(e.`modification_date`) AS `modification_date`, `e`.`id`
FROM `sym_entries` AS `e`
LEFT JOIN `sym_entries_data_107` AS `t107` ON (`e`.`id` = `t107`.entry_id)
WHERE `e`.`section_id` = 20
AND (`t107`.relation_id IN ('54') ) ORDER BY `id` asc