Inexistent Articles 2

SQL

USE enwiki_p;
SELECT page_title , COUNT(*), page_len, cl_to FROM langlinks  
JOIN categorylinks ON ll_from = cl_from 
JOIN page on ll_from = page_id   
WHERE page_namespace = 0 AND page_is_redirect = 0 
AND cl_to IN (SELECT cl_to FROM categorylinks 
WHERE cl_to LIKE "Death of women"
OR cl_to LIKE "Death_of_women"
OR cl_to LIKE "Crimes_against_women"
OR cl_to LIKE "Wartime_sexual_violence "
OR cl_to LIKE "Ethnic_empowerment "
OR cl_to LIKE "Marital_rape"
OR cl_to LIKE "Victims_of_domestic_abuse"
OR cl_to LIKE "Domestic_violence_awareness"
OR cl_to LIKE "Gender_studies "
OR cl_to LIKE "Public_health"
OR cl_to LIKE "Food_safety"
OR cl_to LIKE "Sustainable_development"
OR cl_to LIKE "Women%27s_rights"
OR cl_to LIKE "Child_abuse"
OR cl_to LIKE "Social_inequality"
OR cl_to LIKE "Preteen_pregnancy"
OR cl_to LIKE "Unnecessary_health_care"
OR cl_to LIKE "Gender_pay_gap"
OR cl_to LIKE "Employment_discrimination"
OR cl_to LIKE "Social_stigma"
OR cl_to LIKE "Gender_equality"
OR cl_to LIKE "Men%27s_rights"
OR cl_to LIKE "Mythological_rape_victims"
 
GROUP BY ll_from ORDER BY COUNT(*) DESC, page_title;
SQL

Checking query status...
