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
Jean-Frédéric
.
Files on Wikimedia Commons not using an {{Information}} style template Actually taken from <https://tools.wmflabs.org/add-information/no_information.php>/<https://bitbucket.org/magnusmanske/add_information/src/575756d260678494859fffec72583ee333922393/public_html/no_information.php?at=master> List : ('Information', 'Artwork', 'Book', 'Art_Photo', 'Photograph', 'Book', 'Map', 'Musical_work', 'Specimen')
Toggle Highlighting
SQL
use commonswiki_p; SELECT /* SLOW_OK */ DISTINCT count(page_title) FROM page JOIN templatelinks WHERE page.page_namespace = 6 AND page.page_id = templatelinks.tl_from AND templatelinks.tl_namespace = 10 AND templatelinks.tl_title != "Specimen";
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...