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 'Autogrammstunde%'
   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',
                        'Engelbert_Kliemstein_mit_Unterschrift.jpg',
                        'Dubois_mit_Unterschrift.jpg',
                        'Annemarie_von_nathusius,_Foto_Sessel,_Unterschrift.JPG'
                       )
   AND tl_from = page_id
   AND tl_namespace = 10
   AND tl_title = 'Personendaten';
SQL

Checking query status...
