"File:Screen shot YYYY-MM-DD at hh:mm:ss"

SQL

USE commonswiki_p;
SELECT p.page_title FROM page p
LEFT JOIN categorylinks c ON p.page_id = c.cl_from AND c.cl_to IN ('Screenshots_with_bad_file_names',
                                                                   'Screenshots_of_PD_files_with_bad_file_names_needing_rename',
                                                                   'Screenshots_of_PD-old_files_with_bad_file_names_needing_rename',
                                                                   'Screenshots_with_bad_file_names_needing_review',
                                                                   'Screenshots_with_bad_file_names_with_deletion_requests',
                                                                   'Screenshots_with_bad_file_names_with_licence_problems',
                                                                   'Screenshots_with_bad_file_names_with_permission_problems',
                                                                   'Screenshots_with_bad_file_names_with_source_information_problems')
WHERE c.cl_from IS NULL
AND p.page_is_redirect != 1
AND p.page_namespace = 6
AND (p.page_title LIKE 'Screen_shot_%_at_%' OR p.page_title LIKE 'Screen_Shot_%_at_%' OR # English
     p.page_title LIKE 'Skärmavbild_%_kl._%' OR # Swedish
     p.page_title LIKE 'Näyttökuva_%_kello_%' OR # Finnish
     p.page_title LIKE 'スクリーンショット_%_%' OR # Japanese
     p.page_title LIKE 'Bildschirmfoto_%_um_%' OR # German
     p.page_title LIKE '스크린샷_%_%' OR # Korean, 오전 and 오후 is AM/PM
     p.page_title LIKE 'Captura_de_pantalla_%_%' OR # Castilian and Catalonian, sometimes with a + definite article between date and time
     p.page_title LIKE 'Capture_d\'écran_de_%' OR p.page_title LIKE 'Capture_d’écran_%' OR # French, two different apostrophes
     p.page_title LIKE 'Snímek_obrazovky_%_v_%' OR # Czech
     p.page_title LIKE 'Captura_de_ecrã_%' OR p.page_title LIKE 'Captura_de_Tela_%_às_%' OR # Portuguese
     p.page_title LIKE 'Снимок_экрана_%_в_%' OR # Russian
     p.page_title LIKE 'Schermafbeelding_%_om_%' OR # Dutch
     p.page_title LIKE 'Schermata_%_a%' OR # Italian, sometimes indefinite a, sometimes definite plura alle, never seen definite singular
     p.page_title LIKE 'لقطة_الشاشة_%_في_%_%' OR # Arabic
     p.page_title LIKE 'Skærmbillede_%' OR # Danish
     p.page_title LIKE 'Στιγμιότυπο_%' OR # Modern Greek
     p.page_title LIKE 'Skjermbilde_%_kl._%' OR # Bokmål
     p.page_title LIKE 'Zrzut_ekranu_%' OR # Polish
     p.page_title LIKE 'Ekran_Resmi_#' OR # Turkish
     p.page_title LIKE 'Знімок_екрана_з_%' OR # Ukrainian
     p.page_title LIKE '屏幕快照_%__午%' OR p.page_title LIKE '螢幕快照_%__午%' # Chinese
     # Additional languages with currently no hits:
     # https://commons.wikimedia.org/wiki/Commons_talk:File_renaming#.22Screen_shot_YYYY-MM-DD_at_hh.mm.ss.22
    )
SQL

Checking query status...
