Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Wurgl
.
Alle Seiten mit Vorlage Personendaten (also alle Biographien) mit einem Seitenvorschaubild, das eine Signatur sein könnte
Toggle Highlighting
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 '%utogrammkarte%' AND pp_value NOT LIKE '%utogrammfoto%' AND pp_value NOT LIKE '%utogrammstunde%' AND pp_value NOT LIKE '%mit__nterschrift%' AND pp_value NOT LIKE '%with__ignature%' 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', 'Signature_of_three_financing_agreements_between_the_EEC_and_Mali_(Heinrich_Hendus).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', 'Signature_of_Eanmund_(Kent).jpg', 'Signatur_von_Friedrich_Adolf_Sötebier.jpg', 'Gottfried_Renn_Speyer,_Signatur.JPG', 'Malgorzata_Chodakowska_Signatur.JPG', 'Unterschriften_von_Tamenend_Häuptling_der_Delaware_Indianer.jpg', 'Karl_Friedrich_Haug_Unterschrift.JPG', 'Praha,_Maxiautogramiáda_2014_-_Markéta_Hejkalová.jpg', 'Heilbronn,_Blick_auf_den_Rosenberg_mit_Zuckerfabrik,_um_1900_Archivsignatur_F003-M_0324-4935.jpg', 'JuAn_Bakkers_Signaturbeispiel.jpg', 'Essen-Möller,_Elis_-_porträtt_med_signatur_-_AF.jpg', "INF3-62_A_V_Alexander_Artist's_signature_E_A_B.jpg", 'StettinPeacesignatures.png', 'Signatur_J._Hansmann.JPG', 'Signatur_Mannebach.jpg', 'Hinsche_Max_m._Unterschrift.jpg', 'Signatur_Konrad_Schmid-Meil_-_KSM_003.jpg', 'Georg_Kaulbach,_Signatur.jpg', 'Richard_Henry_Savage_-_signature.jpg', 'Egbert_Friedrich_von_Mülinen_-_Burgerbibliothek_Bern_-_Signatur_FP.B.261.jpg', 'WilliamThompsonNHINosignature.jpg', 'Unterschrift_v._G._Donadio.JPG', 'Jakub_Svoboda_autogramiáda.jpg', 'Porträt_Anton_Klingler_(1649-1713)_-_Burgerbibliothek_Bern_-_Signatur_Mss.Mül.Gr.B.199.JPG', 'Upplands_runinskrifter_873_Balle_signatur.jpg', 'Malin_Steffen_Autogramme_cropped.jpg', 'Öpir-signatur.jpg', 'Reinhold_Rost,_Porträt_mit_Signatur,_um_1890.jpg', 'Ruth_Elias_-_Signature._Title_page_of_-_Die_Hoffnung_erhielt_mich_am_Leben._München,_Zürich_1988.jpg', 'Federskizze,_die_wohl_Leopold_Sokrates_von_Riecke_abbilder,_UB_Tübingen_Signatur_Mh_II_115_(cropped).jpg', 'General_Carl_Lorenz_Auler_und_Unterschrift.jpg', 'Signatur_Wilhelm_Martini.jpg', 'Signatur_Hermanus_(Harmanus)_Smit.jpg', 'Praha,_Maxiautogramiáda_2014_-_Miriam_Kantorková_(1).jpg', 'Miletus_spiegel_unterschrift.jpg', 'Luba_Skorepova_na_autogramiade_v_Brne_1._brezna_2010.jpg', 'Dirtl_Fritz_mit_Autogramm_0000381256-Content-Large-Width.jpg', 'William_Still_portrait_and_signature.png' ) AND tl_from = page_id AND tl_namespace = 10 AND tl_title = 'Personendaten';
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...