Untitled query #55868

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 
 		
 	WHERE page_title  like "%Category:%"
 		/*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  like "%technology%" 
   		/* AND cl_to not like "%topics_of_unclear_notability%" */
 ) AS cattmp
ON cattmp.cl_from = page_id


;
SQL

Checking query status...
