Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Elph
.
With and Without Articles in Arabic Wikipedia
Toggle Highlighting
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;
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...