Template:chapComponents
Syntax
{{chapComponents|ref=...|category1=...|category2=...|notcategory1=...|notcategory2=...}}
Parameters
| Parameter | Value | Required | Default |
|---|---|---|---|
| ref | Text | no (Default value) | {{PAGENAME}} |
| category1, category2 | Text | no | - |
| notcategory1, notcategory2 | Text | no | - |
Usage
Code
{{chapComponents|ref=Perl|notcategory1=Editor|notcategory2=Add-on}}
Result
Components
Extension:DynamicPageList3 (DPL3), version 3.6.4: Error: Error 1054: Unknown column 'ecl1.cl_to' in 'where clause' Function: MediaWiki\Extension\DynamicPageList3\Query::buildAndSelect - Template:chapComponents Query: SET STATEMENT max_statement_time=10 FOR SELECT DISTINCT IFNULL(cl1.cl_sortkey, REPLACE(CONCAT(CASE `wp_page`.page_namespace WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User_talk:' WHEN 4 THEN 'RaySoft:' WHEN 5 THEN 'RaySoft_talk:' WHEN 6 THEN 'File:' WHEN 7 THEN 'File_talk:' WHEN 8 THEN 'MediaWiki:' WHEN 9 THEN 'MediaWiki_talk:' WHEN 10 THEN 'Template:' WHEN 11 THEN 'Template_talk:' WHEN 12 THEN 'Help:' WHEN 13 THEN 'Help_talk:' WHEN 14 THEN 'Category:' WHEN 15 THEN 'Category_talk:' END, `wp_page`.page_title), '_', ' ')) AS `sortkey`,`wp_page`.page_namespace AS `page_namespace`,`wp_page`.page_id AS `page_id`,`wp_page`.page_title AS `page_title` FROM `wp_page` `wp_page` JOIN `wp_categorylinks` `cl1` ON ((`wp_page`.page_id = cl1.cl_from AND cl1.cl_to = 'Perl')) JOIN `wp_categorylinks` `cl2` ON ((`wp_page`.page_id = cl2.cl_from AND cl2.cl_to = 'Component')) LEFT OUTER JOIN `wp_categorylinks` `ecl1` ON ((`wp_page`.page_id = ecl1.cl_from AND ecl1.cl_to ='Editor')) LEFT OUTER JOIN `wp_categorylinks` `ecl2` ON ((`wp_page`.page_id = ecl2.cl_from AND ecl2.cl_to ='Add-on')) WHERE `wp_page`.page_is_redirect = 0 AND `wp_page`.page_namespace = 0 AND ecl1.cl_to IS NULL AND ecl2.cl_to IS NULL ORDER BY sortkey ASC LIMIT 500