Difference between revisions of "Articles by 2"
Line 10: | Line 10: | ||
|addpagecounter = true | |addpagecounter = true | ||
}} | }} | ||
− | + | =Articles with ''2'' somewhere in the middle of title= | |
{{#dpl: | {{#dpl: | ||
Line 33: | Line 33: | ||
|addpagecounter = true | |addpagecounter = true | ||
}} | }} | ||
− | + | =Articles with word ''two'' somewhere in the middle of title= | |
{{#dpl: | {{#dpl: | ||
Line 55: | Line 55: | ||
|addpagecounter = true | |addpagecounter = true | ||
}} | }} | ||
− | + | =Articles with word ''Twenty'' somewhere in the middle of title= | |
{{#dpl: | {{#dpl: | ||
Line 77: | Line 77: | ||
|addpagecounter = true | |addpagecounter = true | ||
}} | }} | ||
− | + | =Articles with word ''Second'' somewhere in the middle of title= | |
{{#dpl: | {{#dpl: |
Revision as of 19:07, 6 December 2015
Contents
2
The DPL extension (version 2.3.0) produced a SQL statement which lead to a Database error.
The reason may be an internal error of DPL or an error which you made,
especially when using DPL options like titleregexp.
Query text is:
SELECT DISTINCT `page`.page_namespace AS page_namespace,`page`.page_title AS page_title,`page`.page_id AS page_id, `page`.page_title AS sortkey, `page`.page_counter AS page_counter, GROUP_CONCAT(DISTINCT cl_gc.cl_to ORDER BY cl_gc.cl_to ASC SEPARATOR ' | ') AS cats FROM `page` LEFT OUTER JOIN `categorylinks` AS cl_gc ON (page_id=cl_gc.cl_from) WHERE 1=1 AND `page`.page_namespace IN ('0') AND (`page`.page_title LIKE '2%') GROUP BY `page`.page_id ORDER BY page_title ASC
Error message is:
Unknown column 'page.page_counter' in 'field list' (localhost)
Articles with 2 somewhere in the middle of title
The DPL extension (version 2.3.0) produced a SQL statement which lead to a Database error.
The reason may be an internal error of DPL or an error which you made,
especially when using DPL options like titleregexp.
Query text is:
SELECT DISTINCT `page`.page_namespace AS page_namespace,`page`.page_title AS page_title,`page`.page_id AS page_id, `page`.page_title AS sortkey, `page`.page_counter AS page_counter, GROUP_CONCAT(DISTINCT cl_gc.cl_to ORDER BY cl_gc.cl_to ASC SEPARATOR ' | ') AS cats FROM `page` LEFT OUTER JOIN `categorylinks` AS cl_gc ON (page_id=cl_gc.cl_from) WHERE 1=1 AND `page`.page_namespace IN ('0') AND (`page`.page_title LIKE '%2%') GROUP BY `page`.page_id ORDER BY page_title ASC
Error message is:
Unknown column 'page.page_counter' in 'field list' (localhost)
Two
The DPL extension (version 2.3.0) produced a SQL statement which lead to a Database error.
The reason may be an internal error of DPL or an error which you made,
especially when using DPL options like titleregexp.
Query text is:
SELECT DISTINCT `page`.page_namespace AS page_namespace,`page`.page_title AS page_title,`page`.page_id AS page_id, `page`.page_title AS sortkey, `page`.page_counter AS page_counter, GROUP_CONCAT(DISTINCT cl_gc.cl_to ORDER BY cl_gc.cl_to ASC SEPARATOR ' | ') AS cats FROM `page` LEFT OUTER JOIN `categorylinks` AS cl_gc ON (page_id=cl_gc.cl_from) WHERE 1=1 AND `page`.page_namespace IN ('0') AND (`page`.page_title LIKE 'Two%') GROUP BY `page`.page_id ORDER BY page_title ASC
Error message is:
Unknown column 'page.page_counter' in 'field list' (localhost)
Articles with word two somewhere in the middle of title
The DPL extension (version 2.3.0) produced a SQL statement which lead to a Database error.
The reason may be an internal error of DPL or an error which you made,
especially when using DPL options like titleregexp.
Query text is:
SELECT DISTINCT `page`.page_namespace AS page_namespace,`page`.page_title AS page_title,`page`.page_id AS page_id, `page`.page_title AS sortkey, `page`.page_counter AS page_counter, GROUP_CONCAT(DISTINCT cl_gc.cl_to ORDER BY cl_gc.cl_to ASC SEPARATOR ' | ') AS cats FROM `page` LEFT OUTER JOIN `categorylinks` AS cl_gc ON (page_id=cl_gc.cl_from) WHERE 1=1 AND `page`.page_namespace IN ('0') AND (`page`.page_title LIKE '%Two%') GROUP BY `page`.page_id ORDER BY page_title ASC
Error message is:
Unknown column 'page.page_counter' in 'field list' (localhost)
Twenty
The DPL extension (version 2.3.0) produced a SQL statement which lead to a Database error.
The reason may be an internal error of DPL or an error which you made,
especially when using DPL options like titleregexp.
Query text is:
SELECT DISTINCT `page`.page_namespace AS page_namespace,`page`.page_title AS page_title,`page`.page_id AS page_id, `page`.page_title AS sortkey, `page`.page_counter AS page_counter, GROUP_CONCAT(DISTINCT cl_gc.cl_to ORDER BY cl_gc.cl_to ASC SEPARATOR ' | ') AS cats FROM `page` LEFT OUTER JOIN `categorylinks` AS cl_gc ON (page_id=cl_gc.cl_from) WHERE 1=1 AND `page`.page_namespace IN ('0') AND (`page`.page_title LIKE 'Twenty%') GROUP BY `page`.page_id ORDER BY page_title ASC
Error message is:
Unknown column 'page.page_counter' in 'field list' (localhost)
Articles with word Twenty somewhere in the middle of title
The DPL extension (version 2.3.0) produced a SQL statement which lead to a Database error.
The reason may be an internal error of DPL or an error which you made,
especially when using DPL options like titleregexp.
Query text is:
SELECT DISTINCT `page`.page_namespace AS page_namespace,`page`.page_title AS page_title,`page`.page_id AS page_id, `page`.page_title AS sortkey, `page`.page_counter AS page_counter, GROUP_CONCAT(DISTINCT cl_gc.cl_to ORDER BY cl_gc.cl_to ASC SEPARATOR ' | ') AS cats FROM `page` LEFT OUTER JOIN `categorylinks` AS cl_gc ON (page_id=cl_gc.cl_from) WHERE 1=1 AND `page`.page_namespace IN ('0') AND (`page`.page_title LIKE '%Twenty%') GROUP BY `page`.page_id ORDER BY page_title ASC
Error message is:
Unknown column 'page.page_counter' in 'field list' (localhost)
Second
The DPL extension (version 2.3.0) produced a SQL statement which lead to a Database error.
The reason may be an internal error of DPL or an error which you made,
especially when using DPL options like titleregexp.
Query text is:
SELECT DISTINCT `page`.page_namespace AS page_namespace,`page`.page_title AS page_title,`page`.page_id AS page_id, `page`.page_title AS sortkey, `page`.page_counter AS page_counter, GROUP_CONCAT(DISTINCT cl_gc.cl_to ORDER BY cl_gc.cl_to ASC SEPARATOR ' | ') AS cats FROM `page` LEFT OUTER JOIN `categorylinks` AS cl_gc ON (page_id=cl_gc.cl_from) WHERE 1=1 AND `page`.page_namespace IN ('0') AND (`page`.page_title LIKE 'Second%') GROUP BY `page`.page_id ORDER BY page_title ASC
Error message is:
Unknown column 'page.page_counter' in 'field list' (localhost)
Articles with word Second somewhere in the middle of title
The DPL extension (version 2.3.0) produced a SQL statement which lead to a Database error.
The reason may be an internal error of DPL or an error which you made,
especially when using DPL options like titleregexp.
Query text is:
SELECT DISTINCT `page`.page_namespace AS page_namespace,`page`.page_title AS page_title,`page`.page_id AS page_id, `page`.page_title AS sortkey, `page`.page_counter AS page_counter, GROUP_CONCAT(DISTINCT cl_gc.cl_to ORDER BY cl_gc.cl_to ASC SEPARATOR ' | ') AS cats FROM `page` LEFT OUTER JOIN `categorylinks` AS cl_gc ON (page_id=cl_gc.cl_from) WHERE 1=1 AND `page`.page_namespace IN ('0') AND (`page`.page_title LIKE '%Second%') GROUP BY `page`.page_id ORDER BY page_title ASC
Error message is:
Unknown column 'page.page_counter' in 'field list' (localhost)