Column 'datecreated' in field list is ambiguous
select old_site_slug, logo, must_read_title, color, right_column_1, right_column_2, right_column_3, subscription_restriction, page, datecreated, datemodified, page.title as label, magazine.id from `pobj_magazine` `magazine` inner join `psys_page` `page` on (`page`.`id` = `magazine`.`page`) order by label asc limit 0, 100
all page field should just add page.xxx. e.g. page.datecreated
Duplicate of