User:Aramachus/Regional Tables
| Region | Goods | Bastok Merchant | San d'Oria Merchant | Windurst Merchant | |||||
|---|---|---|---|---|---|---|---|---|---|
| Elshimo Uplands |
Extension:DynamicPageList4 (DPL4), version 4.0.0: Error: MediaWiki\Extension\DynamicPageList4\Query::buildAndSelect - User:Aramachus-Regional_Tables: The DynamicPageList4 extension (version 4.0.0) produced a SQL statement which led to a Database error.<br/>The reason may be an internal error of DynamicPageList4 or an error that you made; especially when using parameters like 'categoryregexp' or 'titleregexp'. Usage of non-greedy <code>*?</code> matching patterns are not supported.<br/>The error message was:<br/><code>Error 1054: Unknown column 'cl_head.cl_to' in 'SELECT' Function: MediaWiki\Extension\DynamicPageList4\Query::buildAndSelect - User:Aramachus-Regional_Tables Query: SET STATEMENT max_statement_time=10 FOR SELECT DISTINCT cl_head.cl_to,p.page_namespace AS `page_namespace`,p.page_id AS `page_id`,p.page_title AS `page_title` FROM `linktarget` `lt`,`pagelinks` `pl`,`page` `p` JOIN `categorylinks` `cl1` ON (((p.page_id = cl1.cl_from) AND (cl1.cl_to = 'Regional_Merchants'))) JOIN `categorylinks` `cl2` ON (((p.page_id = cl2.cl_from) AND ((cl2.cl_to = 'Windurst/NPCs') OR (cl2.cl_to = 'Bastok/NPCs') OR (cl2.cl_to = 'San_d\'Oria/NPCs')))) LEFT JOIN `categorylinks` `cl_head` ON ((p.page_id = cl_head.cl_from)) WHERE p.page_is_redirect = 0 AND (pl.pl_target_id = lt.lt_id) AND (p.page_id = pl.pl_from) AND (((lt.lt_namespace = 0) AND (lt.lt_title = 'Elshimo_Uplands'))) ORDER BY cl_head.cl_to ASC LIMIT 500 </code> | ||||||||
| Elshimo Lowlands |
Extension:DynamicPageList4 (DPL4), version 4.0.0: Error: MediaWiki\Extension\DynamicPageList4\Query::buildAndSelect - User:Aramachus-Regional_Tables: The DynamicPageList4 extension (version 4.0.0) produced a SQL statement which led to a Database error.<br/>The reason may be an internal error of DynamicPageList4 or an error that you made; especially when using parameters like 'categoryregexp' or 'titleregexp'. Usage of non-greedy <code>*?</code> matching patterns are not supported.<br/>The error message was:<br/><code>Error 1054: Unknown column 'cl_head.cl_to' in 'SELECT' Function: MediaWiki\Extension\DynamicPageList4\Query::buildAndSelect - User:Aramachus-Regional_Tables Query: SET STATEMENT max_statement_time=10 FOR SELECT DISTINCT cl_head.cl_to,p.page_namespace AS `page_namespace`,p.page_id AS `page_id`,p.page_title AS `page_title` FROM `linktarget` `lt`,`pagelinks` `pl`,`page` `p` JOIN `categorylinks` `cl1` ON (((p.page_id = cl1.cl_from) AND (cl1.cl_to = 'Regional_Merchants'))) JOIN `categorylinks` `cl2` ON (((p.page_id = cl2.cl_from) AND ((cl2.cl_to = 'Windurst/NPCs') OR (cl2.cl_to = 'Bastok/NPCs') OR (cl2.cl_to = 'San_d\'Oria/NPCs')))) LEFT JOIN `categorylinks` `cl_head` ON ((p.page_id = cl_head.cl_from)) WHERE p.page_is_redirect = 0 AND (pl.pl_target_id = lt.lt_id) AND (p.page_id = pl.pl_from) AND (((lt.lt_namespace = 0) AND (lt.lt_title = 'Elshimo_Lowlands'))) ORDER BY cl_head.cl_to ASC LIMIT 500 </code> | ||||||||
| Derfland |
Extension:DynamicPageList4 (DPL4), version 4.0.0: Error: MediaWiki\Extension\DynamicPageList4\Query::buildAndSelect - User:Aramachus-Regional_Tables: The DynamicPageList4 extension (version 4.0.0) produced a SQL statement which led to a Database error.<br/>The reason may be an internal error of DynamicPageList4 or an error that you made; especially when using parameters like 'categoryregexp' or 'titleregexp'. Usage of non-greedy <code>*?</code> matching patterns are not supported.<br/>The error message was:<br/><code>Error 1054: Unknown column 'cl_head.cl_to' in 'SELECT' Function: MediaWiki\Extension\DynamicPageList4\Query::buildAndSelect - User:Aramachus-Regional_Tables Query: SET STATEMENT max_statement_time=10 FOR SELECT DISTINCT cl_head.cl_to,p.page_namespace AS `page_namespace`,p.page_id AS `page_id`,p.page_title AS `page_title` FROM `linktarget` `lt`,`pagelinks` `pl`,`page` `p` JOIN `categorylinks` `cl1` ON (((p.page_id = cl1.cl_from) AND (cl1.cl_to = 'Regional_Merchants'))) JOIN `categorylinks` `cl2` ON (((p.page_id = cl2.cl_from) AND ((cl2.cl_to = 'Windurst/NPCs') OR (cl2.cl_to = 'Bastok/NPCs') OR (cl2.cl_to = 'San_d\'Oria/NPCs')))) LEFT JOIN `categorylinks` `cl_head` ON ((p.page_id = cl_head.cl_from)) WHERE p.page_is_redirect = 0 AND (pl.pl_target_id = lt.lt_id) AND (p.page_id = pl.pl_from) AND (((lt.lt_namespace = 0) AND (lt.lt_title = 'Derfland'))) ORDER BY cl_head.cl_to ASC LIMIT 500 </code> |
