Special:WantedCategories replica

Fork of Categories categorized in red-linked categories by Le Deluge

This query is marked as a draft This query has been published by Le Deluge.

SQL

    use enwiki_p;
    SELECT 
  page_title,
  cl_to
FROM page
JOIN
(SELECT DISTINCT
     cl_to , cl_from 
 	
 FROM categorylinks
 LEFT JOIN page
 	ON cl_to = page_title 
 		AND page_namespace = 14
 	WHERE page_title IS NULL 
 		AND cl_to <> "Wikipedians_with_red-linked_categories_on_their_user_page" 
  		AND cl_to <> "Wikipedians_with_red-linked_categories_on_their_userpage" 
  		AND cl_to <> "Wikipedians_with_a_red-linked_category_on_their_user_talk_page" 
  		AND cl_to <> "Wikipedians_with_red-linked_categories_on_their_user_talk_page" 
  		AND cl_to not like "%articles%" 

  		/* AND cl_to not like "%topics_of_unclear_notability%" */
 ) AS cattmp
ON cattmp.cl_from = page_id


LIMIT 20;

SQL

Checking query status...