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
XXN
.
Toggle Highlighting
SQL
use enwiki_p; # SELECT page_title # FROM /*image, */page#, categorylinks # WHERE page.page_id=categorylinks.cl_from SELECT img_user_text AS Uploader, COUNT(page_title) AS Files FROM image, page, categorylinks WHERE page.page_id=categorylinks.cl_from AND image.img_name = page.page_title and page.page_namespace = 6 AND categorylinks.cl_to = "All_free_media"#like "GFDL_files" AND page_title like "Kit%" GROUP BY Uploader having Files > 5 ORDER BY Files DESC; /*WHERE page_namespace = 6 AND page_is_redirect = 0 # AND image.img_name = page.page_title # AND categorylinks.cl_to like "Media_needing_categories%" AND page_title like "Kit%"*/ /*AND (page_title like "%home%" or page_title like "%away%" or page_title like "%left%" or page_title like "%right%")*/ # group by page_title
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...