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
Cheetah90
.
Toggle Highlighting
SQL
use commonswiki_p; select count(distinct gil_page) from globalimagelinks where gil_page_namespace_id = 6 and gil_wiki LIKE '%wiki' and not (gil_wiki LIKE '%test%') and not (gil_wiki LIKE '%commons%') and not (gil_wiki LIKE '%wikimania%') and not (gil_wiki LIKE '%copyright%') and not (gil_wiki LIKE '%media%') and not (gil_wiki LIKE '%foundation%') and not (gil_wiki LIKE '%donate%') and not (gil_wiki LIKE '%outreach%') and not (gil_wiki LIKE '%incubat%') and not (gil_wiki LIKE '%map_%') and not (gil_wiki LIKE '%wikidata%') and not (gil_wiki LIKE '%usability%') and not (gil_wiki LIKE '%be_x_old%') and not (gil_wiki LIKE '%source%') and not (gil_wiki LIKE '%species%') and not (gil_wiki LIKE '%source%') and not (gil_wiki LIKE '%strategy%');
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...