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
Nemo bis
.
Toggle Highlighting
SQL
USE commonswiki_p; SELECT c.cl_to AS category, COUNT(DISTINCT file.page_id) AS total FROM page AS file INNER JOIN categorylinks AS c ON file.page_id=c.cl_from AND c.cl_to NOT IN ("Photographs_by_Paolo_Monti") INNER JOIN categorylinks AS cc ON file.page_id=cc.cl_from AND cc.cl_to IN ("Photographs_by_Paolo_Monti") LEFT JOIN page AS p ON p.page_namespace = 14 AND p.page_title = c.cl_to WHERE c.cl_to NOT REGEXP "Media_from_BEIC|Files_from|CC-BY|Files_with|test_|Uploaded_with|Self-pub|Items_with_OTRS|GFDL|FAL|PD-|PD_Old|uploaded_by_|Flickr_images_reviewed|Flickr_images_uploaded" AND p.page_id IS NULL GROUP BY c.cl_to HAVING total<2 AND CHAR_LENGTH(c.cl_to) > 75 ORDER BY COUNT(file.page_id) DESC;
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...