Object picker field error due to SQL field list ambiguous

Description

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

Environment

None

Activity

Show:
Dominic Watson
July 25, 2016, 1:33 PM

Duplicate of

Duplicate

Assignee

Unassigned

Reporter

Johnson Cheng

Labels

Accepted

No

Priority

Highest
Configure