- Problem
Query: SELECT page.page_id AS value,page.page_namespace AS namespace,page.page_title AS title FROM `rnw_page`,`rnw_page_props` WHERE (page_id = pp_page) AND pp_propname = 'disambiguation' AND (page_namespace != 10) ORDER BY namespace,title LIMIT 1001
Results in
Error: 1054 Unknown column 'page.page_id' in 'field list' (***servername***)
- Fix
SQL: …`rnw_page` as page, …