Untitled query #18909

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 = 'All_free_in_US_media'
LEFT JOIN templatelinks t ON t.tl_from = p.page_id AND t.tl_namespace = 10 AND t.tl_title IN
  ( 
    ## Commons related 
    #'ShadowsCommons', 
    'Now_Commons', 
    ## Keep local
    # 'Keep_local',
    ## 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',
    ## Files that are deemed to be self-made
    'Self','PD-self', 'GFDL-self', 'GFDL-self-with-disclaimers', 'Multilicense_replacing_placeholder_new', 
    ## featured content
    'FeaturedPicture', 'Featured_Picture', 'Former_featured_picture', 'Featured_sound', 
    ## OTRS
    'OTRS_pending', 'OTRS_received',
    ## Non-free media
    'NFUR_not_needed', 'Non-free_media',  
    ## "What we want, No 6." 
    'Information','Image_information_art','Google_Art_Project', 'Painting',    
    ## Misc    
    'DYKfile',  
    #'Esoteric_file', 
    #'Example_files', 
    'Uploaded_from_Commons',  
    'M-cropped', 
    'Split_media' 
    ## 'Wikipedia-screenshot'
  ## For Manual review.
  # 'Out_of_copyright_in',
  #'PD-US-1923-abroad',
  #'PD-ineligible-USonly'
  )
WHERE t.tl_from IS NULL
AND p.page_namespace = 6
SQL

Checking query status...
