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_len,p.page_title FROM page p LEFT JOIN categorylinks c2 ON c2.cl_from = p.page_id AND c2.cl_to IN ('DYK_images', 'Wikipedia Did you know images', 'Wikipedia_image_placeholders', 'Wikipedia_restricted_images' 'Featured_pictures', 'Wikipedia_restricted_images', 'Featured_pictures_on_Mathematics_Portal', 'Featured_pictures_of_Star_Portal', 'Wikipedia_Picture_of_the_day_files', 'Protected_images', 'Self-published work' ) 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', 'Do_not_move_to_Commons', 'M-cropped', ## Keep local 'Keep_local', 'Keep_local_high-risk', 'No_Commons-requested', ## Missing license data 'Somewebsite', 'No_copyright_information', 'No_copyright_holder', 'Untagged', 'no copyright holder', 'no copyright information', 'Wrong-license', ## local deltion process 'Db-meta', 'Db-redircommons', 'Deletable_file', 'Duplicate','Ffd', 'File_at_CCI', 'Ffd', 'Deletable_file', ## Protected 'Pp', 'Pp-template', 'Protected_generic_image_name', 'Protected_sister_project_logo', 'protected_image', 'Restricted_use','badimage', 'Soft_redirect', 'Pp-semi-indef', 'pp-move-indef', 'Pp-upload', ## featured content 'FeaturedPicture', 'Featured_picture', 'Former_featured_picture', 'Featured_sound', 'Former_featured_sound', 'FSC', 'Gujarat_selected_picture', 'FPCold', 'VPCold', 'Thailandportal', 'Asian_Games_selected_picture', 'picture_of_the_day', 'SP_Massachusetts', 'SP_India_UP', 'Nanotech_selected', 'Portal:Star/Selected_picture/template', 'Fishportal', 'Brazilian_selected_picture', 'USMCportal', 'PISPC', ## Other local tags for files at Commons (and eslewhere) 'Qxz-adnavbox', 'DYKfile', 'Football_kit_template', 'Wikipedia-adnavbox', ## OTRS 'OTRS_pending', 'OTRS_received', ## Non-free media 'NFUR_not_needed', 'Non-free_media', 'Out_of_copyright_in', ## Free in US media 'Free_in_US_media', ## "Problem" tags 'Badimage', 'Soft_redirect', ## 'License tags needing manual review ## 'PD-Russia', ## Self## 'PD-self', 'GFDL-self', 'GFDL-self-with-disclaimers', 'Self', 'Multilicense_replacing_placeholder_new', ## Wikimedia ## ## Misc 'Example_files', 'Information', 'Google_Art_Project', 'Split_media', 'Uploaded_from_Commons') WHERE t.tl_from IS NULL AND c2.cl_from IS NULL AND p.page_is_redirect = FALSE AND p.page_len < 440 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...