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
.
Toggle Highlighting
SQL
SELECT DISTINCT cl_from AS Categories FROM enwiki_p.categorylinks WHERE # lists UPPER(en.cl_from) LIKE "%LIST%CLASS%" OR UPPER(en.cl_from) LIKE "%CL%CLASS%" OR UPPER(en.cl_from) LIKE "%BL%CLASS%" OR UPPER(en.cl_from) LIKE "%AL%CLASS%" OR UPPER(en.cl_from) LIKE "%FL%CLASS%" OR # articles UPPER(en.cl_from) LIKE "%UNASSESSED%CLASS%" OR UPPER(en.cl_from) LIKE "%STUB%CLASS%" OR UPPER(en.cl_from) LIKE "%START%CLASS%" OR UPPER(en.cl_from) LIKE "%C%CLASS%" OR UPPER(en.cl_from) LIKE "%B%CLASS%" OR UPPER(en.cl_from) LIKE "%FA%CLASS%" OR UPPER(en.cl_from) LIKE "%GA%CLASS%" OR UPPER(en.cl_from) LIKE "%A%CLASS%" OR # miscellaneous UPPER(en.cl_from) LIKE "%FUTURE%CLASS%" OR UPPER(en.cl_from) LIKE "%CURRENT%CLASS%"
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...