X - Quarry

SQL

USE enwiki_p;
SELECT DISTINCT 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 IN
('Copy_to_Wikimedia_Commons_reviewed_by_Sfan00_IMG',
 'Copy_to_Wikimedia_Commons',
 'Copy_to_Wikimedia_Commons_(bot-assessed)',
 'Copy_to_Wikimedia_Commons_reviewed_by_Yann',
 'Copy_to_Wikimedia_Commons_reviewed_by_Czar' 
)
 
INNER 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', 
    ## 'ShadowsCommons', 
    ## 'Now_Commons', 
   
    ## Keep local
    'Non-free_media',
    'Non-free_use_rationale',  
    'Deleted_on_Commons',
    'Keep_local', 
    'Do_not_move_to_Commons',
    'No_Commons_requested',
    ##
    ## local deltion process
  'Db-meta', 
  'Deletable_file',
  'Duplicate','Ffd', 
  'File_at_CCI', 
    ##'Wrong-license',
    ##'Wrong_license',
    ## 'Hidden-delete-reason',
    ## Protected 
    ##'Pp', 
    ##'Pp-template', 
    ##'Protected_generic_image_name', 
    ##'Protected_sister_project_logo',
    ##'Pp-semi-indef',
    ##'Pp-move-indef',
    ##'Pp-upload',
    
    ## featured content
    ## 'FeaturedPicture', 
    ## 'Featured_Picture', 
    ## 'Former_featured_picture', 
    ## 'Featured_sound', 
    ## OTRS
    'OTRS_pending', 
    'OTRS_received',
    
    'NFUR_not_needed', 
    'Non-free_media',  
    ## 'Out_of_copyright_in',
    'Esoteric_file',
    ## Misc    
    ## 'DYKfile',  
    ## 'Example_files', 
    ##'Information',
    ##'Painting',
    ##'Spoken_article_entry',
    ##'Google_Art_Project', 
    'Split_media'
    ## 'Wikipedia-screenshot'
    )
WHERE t.tl_from IS NOT NULL
AND p.page_namespace = 6
SQL

Checking query status...
