SQL
x
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.
All SQL code is licensed under CC0 License.