Unterschrift als Seitenvorschaubild

SQL

SELECT CONCAT('* [[:Datei:', REPLACE(pp_value, '_', ' '), ']] aus [[', REPLACE(page_title, '_', ' '), ']]') AS "Eintrag in MediaWiki_Diskussion:Pageimages-denylist"
  FROM page, page_props, templatelinks
 WHERE page_namespace = 0
   AND pp_page = page_id
   AND pp_propname = 'page_image_free'
   AND (pp_value LIKE '%nterschrift%'
     OR pp_value LIKE '%ignatur%'
     OR pp_value LIKE '%utogram%'
       )
   AND pp_value NOT LIKE '%utogrammstunde%'
   AND pp_value NOT LIKE '%utogrammbild%'
   AND pp_value NOT LIKE 'Autogrammkarte%'
   AND pp_value NOT LIKE 'Autogrammfoto%'
   AND pp_value NOT LIKE 'Autogrammstunde%'
   AND pp_value NOT LIKE 'mit_Unterschrift%'
   AND pp_value NOT LIKE '%with_signature%'
   AND pp_value NOT IN ('Ho_Chi_Minh_1946_and_signature.jpg',
                        'Rankine_William_signature.jpg',
                        'Bundesarchiv_B_145_Bild-F054905-0019,_Bonn,_Walter_und_Mildred_Scheel_geben_Autogramme_cropped.jpg',
                        'Knothe_Autogramm_1954.jpg',
                        'Autogramm_Ekkehard_Schall.jpg',
                        'Dorothea_Schenck_schreibt_Autogramme.jpg',
                        'Annemarie_von_nathusius,_Foto_Sessel,_Unterschrift.JPG',
                        'Flautogramm.jpg',
                        'Strandberg,_CVA_-_litografi_med_signatur_-_AF.jpg',
                        "Richard_de_Saint-Victor_(détails_d'une_mignature_de_Giovanni_di_Paolo,_XVe_siècle).png",
                        'Ernst_Porträt_&_Autogramm.jpg',
                        'Jiřina_Prekopová_-_autogram.JPG',
                        'Friedrich_Kranke_Portraitmedaillon_Gartenfriedhof_Hannover_Künstlersignatur_am_Hals.jpg',
                        'Konnanautogramm2.jpg',
                        'Brno,_Joštova,_knihkupectví_Dobrovský,_autogramiáda_Martiny_Sáblíkové_(04).jpg',
                        'Mickey_Hardt_und_Constantin_Lücke_schreiben_Autogramme_(3)_(cropped).jpg',
                        'Signature_of_three_financing_agreements_between_the_EEC_and_Mali_(Robert_Lemaignen).tif',
                        'Delaval_Signatur.JPG',
                        'Heilbronn-babel-signatur.jpg',
                        'Kristin_Boese_KB_signature_board.jpg',
                        'Schuster_Arthur_signature.jpg',
                        'Miloslav_Stingl_na_autogramiade_v_Brne_04.jpg',
                        'Signature_Marcellus_Louvre_Ma1207.jpg',
                        'Obersteiner_klein_Unterschrift.jpg',
                        'Philipp_Gottfried_Schaudt_Portrait_Unterschrift.jpg',
                        'Ullman,_Gustaf_-_porträtt_med_signatur_-_AF.jpg',
                        'Signature_à_Reims_95460.jpg',
                        'Cornelius_Rost_signature.jpg',
                        'Blix,_Magnus_-_profil_med_signatur_-_AF_resize_resize.jpg',
                        'Autogramm_katen_pic.jpg',
                        'Hyperbolos_signature_Louvre_Myr428.jpg',
                        'Sedlec_Ossuary_signature_of_Frantisek_Rint.JPG',
                        'Aline-focken-autogramm_(cropped).jpg',
                        'Ludwig_Hemmer_PC_0012_Hannover._Ernst-August-Denkmal._Herzlichen_Glückwunsch_zum_neuen_Jahre._Bildseite.Unterschrift_Ludwig_Hemmer_u._Frau,_geb._Buerschaper,_Arnswaldstraße_13.jpg',
                        'Kolocová_autogramiáda_Blanka_2012.JPG',
                        'Sluková_autogramiáda_Blanka_2012.JPG'
                       )
   AND tl_from = page_id
   AND tl_namespace = 10
   AND tl_title = 'Personendaten';
SQL

Checking query status...
