Untitled query #6052

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_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'
                                                                     )
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',
                                             ## Keep local
                                             'Keep_local',
                                             'Keep_local_high-risk',
                                             'No_Commons-requested', 
                                             ## Missing license data
                                             'Somewebsite', 
                                             'No_copyright_information', 
                                             'No_copyright_holder',
                                             'Untagged',
                                             'Wrong-license',
    ## 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',
                                             'Restricted_use','badimage',
                                             'soft_redirect',
    ## featured content
                                             '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', 
                                             'Self',                                     
    ## Misc    
                                             'Esoteric_file', 
                                             'Example_files', 
                                             'Information',
                                             'Google_Art_Project',                                              
                                             'M-cropped', 
                                             '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 < 67
AND p.page_namespace = 6
SQL

Checking query status...
