Special:WantedCategories replica 2

Fork of Special:WantedCategories replica 2 by BrownHairedGirl

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

SQL

    use rowiki_p;
    SELECT 
cl_to , count(cl_to) AS cnt

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 "%topics_of_unclear_notability%" */
 ) AS cattmp
ON cattmp.cl_from = page_id
GROUP BY cl_to
ORDER BY cnt

;

SQL

Checking query status...