Untitled query #6046

SQL

USE enwiki_p;
SELECT p.page_id,p.page_title FROM page p
INNER JOIN categorylinks c ON c.cl_from = p.page_id AND c.cl_to = 'Files_with_no_machine-readable_description'
LEFT JOIN templatelinks t ON t.tl_from = p.page_id AND t.tl_namespace = 10 AND t.tl_title IN
  ( 
    ## Commons related 
    'Convert_to_SVG_and_copy_to_Wikimedia_Commons', 'Copy_to_Wikimedia_Commons', 'ShadowsCommons', 'Now_Commons', 
    ## Keep local
    'Keep_local', 'Keep_local_high-risk',
    ## 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',
    ## Files that are deemed to be self-made
    'Self','self','PD-self', 'GFDL-self', 'GFDL-self-with-disclaimers', 'Multilicense_replacing_placeholder_new', 
    ## 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',  
    ## 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 license tags"
    'badimage', 'Soft_redirect',         
    ## 'License tags needing manual review                                             
    'PD-Russia', 
    ## Misc    
    'Esoteric_file', 'Example_files', 'Information','Google_Art_Project', 'M-cropped', 
    'Split_media',
    'Uploaded_from_Commons',
    'DYKfiles')
WHERE t.tl_from IS NULL
AND p.page_is_redirect = FALSE
AND p.page_namespace = 6
SQL

Checking query status...
