پیش نویس با رده

SQL

USE fawiki_p;
SELECT draft.page_title AS draftname, cl_to AS categoryname
FROM categorylinks
JOIN page AS draft ON draft.page_id = cl_from
LEFT JOIN page AS catpage ON catpage.page_namespace = 14 AND catpage.page_title = cl_to
LEFT JOIN page_props ON pp_page = catpage.page_id AND pp_propname = 'hiddencat'
LEFT JOIN templatelinks ON tl_from = catpage.page_id
LEFT JOIN linktarget ON lt_id = tl_target_id AND lt_namespace = 10 AND lt_title = 'Maintenance_category'
WHERE draft.page_namespace = 118
  AND pp_page IS NULL
  AND tl_from IS NULL
  AND cl_to NOT LIKE 'Drafts\_about\_%'
  AND cl_to NOT LIKE '%\_drafts'
  AND cl_to != 'Namespace_example_pages'
LIMIT 1000;
|wikilinks= 1:118, 2:14
|interval= 1
SQL

Checking query status...
