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
Sfan00 IMG
.
Toggle Highlighting
SQL
USE enwiki_p; SELECT p.page_id,p.page_title FROM page p LEFT JOIN categorylinks c2 ON c2.cl_from = p.page_id AND c2.cl_to IN ('DYK_images','Featured_pictures', 'Wikipedia_restricted_images') ## LEFT JOIN templatelinks t ON t.tl_from = p.page_id ## AND t.tl_namespace = 10 ## AND t.tl_title IN ('Non-free_use_rationale', 'Non-free_use_rationale_2', 'Non-free media rationale', ## ## Commons related ## 'Convert_to_SVG_and_copy_to_Wikimedia_Commons', 'Copy_to_Wikimedia_Commons', 'ShadowsCommons', 'Now_Commons', ## ## Keep local ## 'Keep_local', ## ## Missing license data ## 'Somewebsite', 'No_copyright_information', 'No_copyright_holder' ## ## local deltion process ## 'Db-meta', 'Deletable_file','Duplicate','Ffd', 'File_at_CCI', 'Puf', ## ## Protected ## 'Pp', 'Pp-template', 'Protected_generic_image_name', 'Protected_sister_project_logo','protected_image' ## ## Files that are deemed to be self-made ## 'Self','PD-self', 'GFDL-self', 'GFDL-self-with-disclaimers', 'Multilicense_replacing_placeholder_new', ## ## featured content ## 'Featured_picture', 'Former_featured_picture', 'Featured_sound', 'Gujarat selected picture','FPCold','Thailandportal' ## ## OTRS ## 'OTRS_pending', 'OTRS_received', ## ## Non-free media ## 'NFUR_not_needed', 'Non-free_media', 'Out_of_copyright_in', ## ## "Problem license tags" ## 'PD-Russia', 'untagged','badimage' ## ## Misc ## 'DYKfile', 'Esoteric_file', 'Example_files', 'Information','Google_Art_Project', 'M-cropped', ## 'Split_media', ## 'Uploaded_from_Commons') WHERE c2.cl_from IS NULL AND p.page_len < 5 AND p.page_namespace = 6
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...