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
Teibit
.
Along with other useful statistics.
Toggle Highlighting
SQL
SELECT cl_from AS Page_ID, cl_to AS Category, CASE WHEN cl_to LIKE "%List%Class%" THEN 1 ELSE 0 END AS 'List', CASE WHEN cl_to LIKE "%FL%Class%" THEN 1 ELSE 0 END AS FL, CASE WHEN cl_to LIKE "%Future%Class%" THEN 1 ELSE 0 END AS Future, CASE WHEN cl_to LIKE "%Current%Class%" THEN 1 ELSE 0 END AS 'Current', CASE WHEN cl_to LIKE "%Stub%Class%" THEN 1 ELSE 0 END AS Stub, CASE WHEN cl_to LIKE "%Start%Class%" THEN 1 ELSE 0 END AS 'Start', CASE WHEN cl_to LIKE "%C%Class%" THEN 1 ELSE 0 END AS C, CASE WHEN cl_to LIKE "%B%Class%" THEN 1 ELSE 0 END AS B, CASE WHEN cl_to LIKE "%GA%Class%" THEN 1 ELSE 0 END AS GA, CASE WHEN cl_to LIKE "%FA%Class%" THEN 1 ELSE 0 END AS FA, COUNT(DISTINCT rev_id) AS Edit_count, COUNT(DISTINCT rev_user) AS Editors FROM enwiki_p.categorylinks INNER JOIN enwiki_p.revision ON revision.rev_page = cl_from WHERE cl_to LIKE "%List%Class%" OR cl_to LIKE "%FL%Class%" OR cl_to LIKE "%Future%Class%" OR cl_to LIKE "%Current%Class%" OR cl_to LIKE "%Stub%Class%" OR cl_to LIKE "%Start%Class%" OR cl_to LIKE "%C%Class%" OR cl_to LIKE "%B%Class%" OR cl_to LIKE "%GA%Class%" OR cl_to LIKE "%FA%Class%" GROUP BY cl_from limit 20 #testing
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...