Benutzer:Peterlustig/Personenartikell

aus Wikipedia, der freien Enzyklopädie
Zur Navigation springen Zur Suche springen
mysql dewiki_p -B -e "
SELECT CONCAT('|-|', '[[',page.page_title,']] || ')
FROM page, (SELECT categorylinks.cl_from AS kat_id, Count(*) AS Anzahl 
           FROM categorylinks, (SELECT cl_from
                                FROM categorylinks
                                WHERE cl_to IN ('Mann', 'Frau')) AS ArtikelID

           WHERE 
              categorylinks.cl_from = ArtikelID.cl_from
           GROUP BY categorylinks.cl_from HAVING Count(*) < 2) AS KategorieID
WHERE 
  page.page_id = KategorieID.kat_id
LIMIT 5000;
"
Artikel Laenge Bearbeitungshinweise
Kinuye_Hitomi
Abdallah_al-Akbar
An_Wang
Oskar_Hammelsbeck
Nantechild
George_Balfour
Mademoiselle
Johannes_Hyrkanos_II.
John_Norum
Edward_Hitchcock
Abd_al-Muttalib
Shen_Congweng
Martin_Fischer_(Sportler)
Henrik_Rabien
Vojtech_Saudek
Werner_Gregoritsch
Kurt_Wildhagen
Rolf_Fischer
Guido_della_Torre
Seth_MacFarlane
Amand_Goegg
Denise_Cronenberg
Johann_Baptist_de_Wendt
Oskar_Hoffmann_(Politiker,_1838)
Victor_Bockris
Botho_Sigwart_zu_Eulenburg
Tony_Fadell
Hermann_von_Württemberg
Franz_von_Zeiller
Rick_Gates
Renatus_Schenkel
Kaspar_Sturm_(Reichsherold)
Tony_Clarke
Marie-Louise_von_Franz
Walram_(Arlon)
Howard_Lotsof
Jean_Errard_de_Bar-le-Duc
Iwan_Sirko
Louis_Bourdaloue
Johann_Sebastian_Schützenbach
Heinrich_Frings
Maria_Pia_von_Neapel-Sizilien
Leopold_Schwarzschild
Lorenz_Krach
Alfred_Dundas_Taylor
Victor_Tourjansky
Mathilde_von_Bayern
Dionýs_Stur
Dedi
Chloderich
Blondine
Heinric_de_Planchinbere
Abû_l-A’lâ_al-Maudûdî
Camillo_Marcolini
Rorgon_I._(Maine)
Christian_Schreiber (Philosoph)
Diogenes_von_Oinoanda
Irmgard_von_Kleve
Bessarion_der_Große
Donato_Acciaiuoli
Arthur_Dobbs
Marina_von_Kent
Laura_Biagiotti
Paul_Sahli
Marcus_Acilius_Caninus
Cajetan_Anton_von_Notthaft
Winthir
Raquel_Velasco
Zainab_bint_Chuzaima
Werner_von_Gunzenreith
Reinhard_Scheffer
Muniruddin_Ahmed
Suheil_Bushrui
Alexander_Onassis
Wilfred_Owen
Karl_Freiherr_von_Leoprechting
Werner_Erhard
Brian_Paul
Leopold_II._(Habsburg)
Katharina_von_Teschen
Heinrich_Karl_Friedrich_Levin_von_Wintzingerode
Jay_C._Levinson
Paul_Debevec
August_Lösch
Eufrosia_Siracusa_Valdaura
Nikolaus_Hieronymus_Gundling
Stephan_van_Zenger
Pomponius_Porphyrio
Urbain_Grandier
Johann_George_von_Einsiedel
Antonio_Spinelli
Heinrich_I._von_Hartenstein
Georg_von_Trapezunt
Karl_Anton_Prinz_Rohan
Johann_von_Mengede
Joseph_Marie_Terray
Diether_Noll
Thomas_Gundacker_von_Starhemberg
Johann_II._von_Saarwerden
Kraft-Alexander_zu_Hohenlohe-Oehringen
Vera_Bohle
Margarethe_von_Blois
Charles_Leconte_de_Lisle
Abel_Foullon
Gerd_Willamowski
Anselm_Franz_Freiherr_von_Ritter_zu_Groenesteyn
Johann_Woyssel
Dietrich_von_Harras
Hermann_von_Harras
Wenrich_von_Trier
Christian_Günther_von_Bernstorff
Franz_Philipp_Florinus
Wilhelm_Reiffenstein
Amalafried
Morris_Ketchum_Jesup
Mary_Anne_Clarke
Christoph_Klauck
Felix.plog
Heinrich_von_Kastilien
Francesco_II._Gattilusio
Rolf_Axen
Ann_Faraday
John_Brockman
Henriette_Amalie_von_Reuß
Emil_Graf_zu_Rantzau
Sidonie_von_Böhmen
Hans_Vollmer
John_Eliot_(Missionar)
Dorino_II._Gattilusio
Theophylakt_I._von_Tusculum
Joop_van_den_Ende
Heinrich_Haubold_von_Einsiedel
Theodora_I._von_Tusculum
Petronella_von_Aragón
Nuno_Sanchez_von_Roussillon
Melisende_(Tripolis)
Marcabru
William_Arrowsmith
Jürgen_B._Harder
Adelheid_von_Wassel
Adelheid_von_Loccum-Hallermund
Ludolf_V._von_Dassel
Jean_Baptiste_Schwilgué
Marguerite_von_Anjou-Sizilien
Robert_I._(Artois)
Segimundus
Margarete_(Burgund-Tonnerre)
Rainou_(Sabran)
Heinrich_von_Randow
Otto_von_Voß
Eberhard_Im_Thurn
Guigues_VIII._(Viennois)
Louis-Bertrand_Castel
Oliver_Vujovic
Hans_Ulrich_Krafft_von_Dellmensingen
Wilhelm_Ludwig
Charles_Ruys_de_Beerenbrouck
Eldon_L._Knuth
Konrad_II._von_Wassel
Reinold_I._von_Dassel
Manoel_Maria_de_Barbosa_du_Bocage
Richenza_von_Schwaben
Richenza_von_Boyneburg
Poppo_I._von_Blankenburg
Sophia_von_Mecklenburg-Schwerin
Jaime_de_Marichalar
Zanobi_da_Strada
Niccolò_Acciaiuoli
Egeno_von_Konradsburg
Jean_Jouvenel
Peter_von_Grünenberg
Peter_von_Thorberg
Burchard_Ratepilate
Hugues_Aubriot
Guillaume_Juvénal_des_Ursins
Hillel_II.
Jean_Louis_Armand_de_Quatrefages_de_Bréau
Eleuterio_Fernández_Huidobro
Frederick_Cavendish
Dmitri_Skljarow
Georg_Kestel
Adalgot_von_Veltheim
Wigand_von_Marburg
Dedo_von_Krosigk_(Adliger,_um_1040)
Joy_Paul_Guilford
Pierre_Le_Moyne_d'Iberville
Franz-Ernst_von_Platen
Herleva
Herluin_von_Conteville
Johann_Heinrich_August_von_Duncker
Robert_von_Mortain
Paul_von_Griechenland
Hiltrud_Schröter
Jean-Pierre_Louis_de_Fontanes
Karl_Theodor_von_Buseck
Johann_Joachim_Ewald
Reichard_Streun_von_Schwarzenau
Paul_W_Klipsch
Karl_August_von_Heigel
Gopinath_Bordoloi
Valerio_Massimo_Manfredi
Michael_Newdow
Asit_Biswas
Julie_von_Bechtolsheim
Rick_Perry