Untitled query #5647

SQL

USE enwiki_p;
SELECT p.page_id,p.page_len,p.page_title FROM page p
INNER JOIN categorylinks c ON c.cl_from = p.page_id AND c.cl_to = 'All_free_media'
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'
                                                                      'Wikipedia fully-protected main page files'
                                                                     )
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', 
    'Do_not_move_to_Commons',
    'No_Commons_requested',
    ## local process
    'Db-meta', 
    'Deletable_file',
    'Duplicate',
    'Ffd', 
    'File_at_CCI', 
    'Wrong-license',
    'Wrong_license',
    'Presumed_self',
    ## Protected 
    'Pp', 
    'Pp-template', 
    'Protected_generic_image_name', 
    'Protected_sister_project_logo',
    'Pp-semi-indef',
    'pp-move-indef',
    'pp-upload',
    ## Files that are deemed to be self-made
    'Self',
    'PD-self', 
    'GFDL-self', 
    'GFDL-self-with-disclaimers', 
    'Multilicense_replacing_placeholder_new',
    'Media by uploader',
    ## featured content
    'FeaturedPicture', 
    'Featured_Picture', 
    'Former_featured_picture', 
    'Featured_sound', 
    ## OTRS
    'OTRS_received',
    ## Non-free media
    'NFUR_not_needed', 
    'Non-free_media',  
    'Out_of_copyright_in',
    ## Misc    
    'DYKfile',  
    'Example_files', 
    'Information',
    'Google_Art_Project', 
    'Split_media')
WHERE t.tl_from IS NULL
AND c2.cl_from IS NULL
AND p.page_namespace = 6
SQL

Checking query status...
