User:Steinsplitter/WLM2017D

USE commonswiki_p;
# Get all users who uploaded files to WLM in 2016
SELECT 
 DISTINCT CONCAT("{{#target:User talk:", img_user_text, "}}") AS user
FROM page
JOIN categorylinks
 ON cl_from = page_id
LEFT JOIN image
 ON page_title = img_name
WHERE cl_to = "Images_from_Wiki_Loves_Monuments_2016_in_Germany"
# Exclude users who uploaded stuff yet
AND img_user_text NOT IN
	(SELECT 
 DISTINCT img_user_text AS user2
FROM page
JOIN categorylinks
 ON cl_from = page_id
INNER JOIN image
 ON page_title = img_name
WHERE cl_to = "Images_from_Wiki_Loves_Monuments_2017_in_Germany"
GROUP BY img_user_text
    )
GROUP BY img_user_text
;

User talk:+Gerry41
User talk:1970gemini
User talk:1971markus
User talk:3D-Puzzle
User talk:5n31d3R
User talk:8caroro
User talk:Achim04
User talk:AchimSchreck
User talk:Acuareladelmundo
User talk:Adamdaley
User talk:Adler35
User talk:Adrian Eißler
User talk:Ahmad aak
User talk:Ahmedahmedov
User talk:Aidexxx
User talk:Aineias
User talk:Aislewolf
User talk:Albgoess
User talk:Aldebaraner
User talk:AlesiA
User talk:Alex schlotter
User talk:Alexander Sayn-Wittgenstein
User talk:Algensan
User talk:Ali sohrabpour2000
User talk:Aliciarguezlopez
User talk:Allskyter
User talk:Alpenadam
User talk:Alter Fritz
User talk:Alx&r
User talk:AmBergsee
User talk:Andraszy
User talk:Andrewssi2
User talk:Andy king50
User talk:AndyCorbley
User talk:Anfangen
User talk:Angel-marie
User talk:Annett 07570
User talk:Anny29190
User talk:Anomac
User talk:Anton Gausepohl
User talk:Antoniocastello
User talk:Approbe
User talk:Arensburger Schloss
User talk:ArishG
User talk:Arlene
User talk:Arnolsch
User talk:Artur Andrzej
User talk:Aseemdua
User talk:Ash912
User talk:Askara07
User talk:Asperatus
User talk:Astra4321
User talk:Auliyati
User talk:Avda
User talk:Awer20
User talk:Awernado
User talk:Axel.Mauruszat
User talk:Azgheer
User talk:BCS Mainz
User talk:BFotography
User talk:Babannup
User talk:Badior hj
User talk:Balkhovitin
User talk:Balkonhuf
User talk:Balticvelo
User talk:Balungi7
User talk:Bana Sh
User talk:Banffy
User talk:BansheeBat
User talk:Barmenda
User talk:Barockaner
User talk:Barockspot
User talk:Baumfreund-FFM
User talk:BeaVS
User talk:Beetroot87
User talk:Ben Frenklin
User talk:Benjamin 2006
User talk:Benreis
User talk:Bergknappe
User talk:Bernausche
User talk:Bernhard Uff dem Sand
User talk:Best Air Pictures
User talk:Bilderrätsel
User talk:Bjs
User talk:Blauer elephant
User talk:Bliggiqu
User talk:Bluestorm2807
User talk:Blumenfee57
User talk:Blutgretchen
User talk:Bobbydraper5
User talk:Bodo B.
User talk:Bodo Kubrak
User talk:Bohdan Mezei
User talk:BohunkaNika
User talk:BonAlex
User talk:BorisSpasov
User talk:Boschfoto
User talk:Boytho
User talk:Brandt-ch60
User talk:Brotschrift
User talk:Brunoteddy
User talk:Brutosius
User talk:Bual.sukhjot1
User talk:Budelmütze
User talk:Burkhardt Ed Rump
User talk:Bybbisch94
User talk:Bytfisch
User talk:C.Suthorn
User talk:C.pyrrek
User talk:CB1000RBiker
User talk:CDCA1989
User talk:CKY91
User talk:Caliandroid
User talk:Canon55D
User talk:CarlCE
User talk:Caronna
User talk:Carosara1989
User talk:Carsten Naber
User talk:Catalinarzpl
User talk:CatalpaSpirit
User talk:Cchiaruttini
User talk:Ccsepulveda
User talk:Cdwelte
User talk:Cellboy74
User talk:Charles S. Lima
User talk:Charning
User talk:Chepok71
User talk:Cherubino
User talk:CherylHeatherMason
User talk:Chiaramazzocchi
User talk:Chr. Schmidt
User talk:ChrisFessel
User talk:Christallkeks
User talk:Christian Karch
User talk:Christian btg
User talk:Christian1163
User talk:Christiane Höltschl
User talk:Christiangebler
User talk:ChristiansFotos
User talk:Chumwa
User talk:Cjanusch
User talk:ClaudiaN16
User talk:Clip-fx
User talk:Clown522
User talk:Code
User talk:Coekzvvb
User talk:Contradictioned
User talk:Cosmic42
User talk:Crepuscolo
User talk:Croesch
User talk:Cruppellarius
User talk:Ct2034
User talk:D3rmulle
User talk:DCB
User talk:DSalazar
User talk:DSpe
User talk:DXR
User talk:Dahle322
User talk:Dalllkirch
User talk:DanMo231
User talk:Danden20000
User talk:Daniel Walprecht
User talk:Dansch79
User talk:David Levy
User talk:Davidh820
User talk:Davidjosephgoteiner
User talk:De charrue
User talk:Dean
User talk:Deda2
User talk:Den man tau
User talk:Denkmalaktiv
User talk:Denkmalfotograf
User talk:Denkmalist
User talk:Der.soean
User talk:DerLangeFrank
User talk:DerNeustadter
User talk:Derbaum
User talk:Derbrauni
User talk:Dester~dewiki
User talk:Det56
User talk:Detlef1234
User talk:Devital
User talk:Dguendel
User talk:Dhanalaila
User talk:Dheeraj.sakaray
User talk:DiBase
User talk:Dianakranert
User talk:DieLachendeMehrheit
User talk:Dieter Matthe
User talk:Dieter66007
User talk:Dietmar Schmid1953
User talk:Digital cat
User talk:Dobbelquerlenker
User talk:Doersamm
User talk:DomWestcliff
User talk:Dominik Asi
User talk:Dontworry
User talk:Dornfeldenkel9
User talk:Dorothea Witter-Rieder
User talk:Dr. Bernd Gross
User talk:Dr. Petra Knapp
User talk:Dreas
User talk:Dreizung
User talk:Drusenthal
User talk:Dsiniatubskawz
User talk:Dung1802
User talk:Duschan1944
User talk:ETRS89UTM
User talk:Ecelan
User talk:Eine.Wiekeine
User talk:Ekkek
User talk:Ela'sRoses
User talk:Elisabeth N
User talk:Elisauer
User talk:Emanuellonz
User talk:Ennaenrettam
User talk:Enter
User talk:Ephra667
User talk:EpsilonEridani
User talk:Erell
User talk:Eributz
User talk:Erich-Jörg Stephani
User talk:Errorflash
User talk:Ersterdomo
User talk:EveryBitDothAlmostTellMyName
User talk:Fanny88 und Sheepy86
User talk:Farmbruster2012
User talk:Fay-s
User talk:Fdiederich
User talk:Fdkirchner
User talk:Feldstein
User talk:Felix Baumgarten
User talk:Felix Schade
User talk:Fenoms
User talk:Ffokcuf1
User talk:Filmgärtner
User talk:Filou456
User talk:Floerio
User talk:Flominator
User talk:Florian Furtner
User talk:Florian838
User talk:FlorianManuel
User talk:Flyingkangaroo76
User talk:Fonihozar
User talk:Fotobusy
User talk:Francoboldi
User talk:Franconia
User talk:Frank Bohland
User talk:Frank H. aus B.
User talk:Frank.Doe
User talk:FrankBothe
User talk:Franroy90
User talk:Franz Fabian
User talk:Friedel Herten
User talk:FrkSft
User talk:Fundador
User talk:G3R4L7
User talk:GEORGGREG
User talk:Gauravchingale
User talk:Genusus
User talk:Geolina163
User talk:Georg.schmidt
User talk:Georg5259
User talk:Gerd Eichmann
User talk:GerdNRW
User talk:Ghada almagerhy
User talk:Gliwi
User talk:Global Fish
User talk:Godlwood
User talk:Godot13
User talk:Gonruvogup
User talk:Goosi
User talk:Gordon d
User talk:Gorlum85
User talk:Gowipzurr
User talk:Gradic
User talk:Grafruebe
User talk:Grebehcneum
User talk:Gremlin456
User talk:Grimflayer
User talk:Grimmi59 rade
User talk:Grugerio
User talk:Guitar head
User talk:GummiLöffel
User talk:Gunter R. Shyster
User talk:HBX55
User talk:HJFeller
User talk:HMacGregor
User talk:HMay
User talk:HP-Feuchtenberger
User talk:Habicht911
User talk:Haeferl
User talk:Hagia.sophia
User talk:Hahyejin
User talk:Hamali314
User talk:Hannes275
User talk:HannesvB
User talk:Hans Kreul
User talk:Harald Krichel
User talk:Harald1952
User talk:Harishmakaram
User talk:Harley Bernie
User talk:Haros
User talk:Hatzfeld
User talk:Hausforscherunterwegs
User talk:Hbrech
User talk:Hdeisch
User talk:HeRuBn
User talk:Heikm
User talk:Hein221
User talk:Heinsau58
User talk:Heinz-Bernd
User talk:Hejkal
User talk:Helmutvoss.de
User talk:Henny.B
User talk:Henrikrause
User talk:Henry 09
User talk:Herdipedia
User talk:Herr Commonsense
User talk:HerrAdams
User talk:Herzenssache
User talk:HiDrNic
User talk:Hiddenhauser
User talk:Hilarmont
User talk:Hildefonz
User talk:Hinterhofagentur
User talk:Hjvl
User talk:HoJoThe
User talk:Hoch2wo
User talk:Hoi klokje
User talk:Homkin
User talk:HorHus
User talk:Horx321
User talk:Hotte03
User talk:Hugreznuk
User talk:Huhu Uet
User talk:Ikar.us
User talk:Imperator Gaius Octavius
User talk:Ingesgui
User talk:Instmann
User talk:IoanaSchmalle
User talk:Irlandmann
User talk:Isie31303
User talk:Itelchan
User talk:Ivanhercaz
User talk:Ivi h
User talk:J.Eggers
User talk:J.rossmanith
User talk:JGPro
User talk:Jade von Schlösschen
User talk:Jainav 46
User talk:Jan Künzel
User talk:Jan-Philipp Litza
User talk:JaneDoe83
User talk:Janobi
User talk:Janwn
User talk:Jaz886
User talk:Jazonte
User talk:Jbergner
User talk:Jeneopak
User talk:Jensinho10
User talk:Johannes.Ady
User talk:Joinsi
User talk:Jolandrian
User talk:Jonas Ruangthong
User talk:Joni084
User talk:Josef Dehenn
User talk:Josef Streichholz
User talk:Jsikorra
User talk:Judith Richmann
User talk:Julius 07
User talk:Julius Jonathan
User talk:Julubecka
User talk:Jungfried
User talk:Jutta77
User talk:Juwiwi16
User talk:Jürgen Elisabeth Heinrich Ludwig
User talk:Jürgen Lindenburger
User talk:KH2016
User talk:KPKelber
User talk:KUGerhardt
User talk:Kabaeh49
User talk:KaetheVomDach
User talk:Kajebi II.
User talk:Kaptantino
User talk:Karl-Heinz Jansen
User talk:Karla.Koopmann
User talk:Ke1207
User talk:Keivan1371
User talk:Kereul
User talk:Keshavofgod
User talk:KickerKati
User talk:Kim Tkocz
User talk:Kirschgrün
User talk:Klaro195i
User talk:KlausPC
User talk:Kleiner Tümmler
User talk:KlennThies
User talk:Klmu
User talk:Kloppstock22
User talk:Konrad Conrad
User talk:KreatorLA
User talk:Kreuz und quer durch deutschland
User talk:Kristallwyvern
User talk:Kurkais
User talk:Kurt ** unterwegs
User talk:Kyl0e
User talk:Kyriondaniel
User talk:L0st4k
User talk:LSS3408
User talk:Labspy
User talk:Ladiszlai
User talk:Lakkot
User talk:Landschaft im Licht
User talk:Laserlicht
User talk:Lax366
User talk:Leeno-polo
User talk:Legacy1702
User talk:LegenderVC
User talk:Leipzigstegi
User talk:Lemke, Martin
User talk:Lena vom Land
User talk:Lenaversum
User talk:LennierMo
User talk:Lespin
User talk:Lester289
User talk:Lievrée
User talk:Lifecoach69
User talk:Lin 4Jahreszeiten
User talk:LoKiLeCh
User talk:Losch
User talk:Lpmip
User talk:LuayAS
User talk:LuciAmanda
User talk:Luciezielinski
User talk:Ludwig, Silvio
User talk:Luftschloss69
User talk:LuniSky
User talk:Lupus in Saxonia
User talk:M.Schupke
User talk:M.Sheikho
User talk:MLaker
User talk:MRRaum
User talk:Ma114bu
User talk:MacLeod1976
User talk:Maddin74
User talk:Maechty
User talk:Magnoid
User talk:Maiwi
User talk:Malefixjan
User talk:Mandes Rupp
User talk:Manuel Meyr
User talk:Marc Rentschler
User talk:Marcel Dunkelberg
User talk:MarcoWischumerski
User talk:Marcusjaenichen
User talk:Marek Heise
User talk:MarieE
User talk:Marit Berg
User talk:Markus Gögelein
User talk:Markus Sturzbecher
User talk:Marlexpictures
User talk:Marsupi1ami
User talk:Martin Gräßle
User talk:Martin Helmer
User talk:Martin Maubach
User talk:Martin Welp
User talk:MartinMMx
User talk:Martina Schrenk
User talk:Maryam.rezaei
User talk:Maschinenjunge
User talk:Masterofpuppets103
User talk:Mattes
User talk:Mattesosterode
User talk:Mattis.robowski
User talk:Mautzedun
User talk:Max Siegmayer
User talk:Maya Uhde
User talk:McGrummel
User talk:McReiner
User talk:Mduesi
User talk:Medici1982
User talk:Meine Heimat 2016
User talk:Memento79
User talk:MercyfulRelease
User talk:Mhebel
User talk:MiSt
User talk:Michael Clemens
User talk:Michael KR
User talk:Michael Krause88
User talk:Michael Richmann
User talk:Michael Wittwer
User talk:Michael14111
User talk:Michaelis Alt Jabel
User talk:Michaelkiel1103
User talk:Mighelone
User talk:Mikkoh
User talk:Mingo713
User talk:Mirko Anczok
User talk:Misburg3014
User talk:Missal
User talk:MitDemWind
User talk:Mk063
User talk:Mlisowsk
User talk:MoSchle
User talk:Mogadir
User talk:Mohamed-Nadjib-Mami
User talk:Mohneye
User talk:Moramaso
User talk:Morbec
User talk:MoritzEt
User talk:Moritzgrebe
User talk:Mousepad0210
User talk:Mr.Nutt
User talk:Mripp de
User talk:Muck50
User talk:Mueslie300
User talk:Muhsinocal
User talk:Muns
User talk:Mura40
User talk:Muse duco
User talk:Mutantram
User talk:Mvo
User talk:My view
User talk:N. Burkart
User talk:N8eule78
User talk:NIckyh80
User talk:Nafets fpohcs
User talk:Nanadeniki
User talk:Nanga99
User talk:Nattulgepp
User talk:Nature1505
User talk:Naturgucker Illtal
User talk:Naturliebhaberin
User talk:Naum303
User talk:Nehawane14
User talk:Neitram
User talk:Nelk
User talk:Nerhut n
User talk:Nethawk
User talk:Nickburg
User talk:Nicoe25
User talk:NielsFahrenkrog
User talk:Nielssander
User talk:Nine1000
User talk:Nizarras
User talk:Nobvonriedern
User talk:Nocobe
User talk:Noe.pierre
User talk:Norbert Hübsch
User talk:Norden06
User talk:Nordenfan
User talk:Nordseewellen
User talk:Noxa2013
User talk:Nyshan013
User talk:Nyx696
User talk:OC1959
User talk:Octobrist
User talk:Odo101
User talk:Ohndo
User talk:Oisín
User talk:Okki guzl
User talk:OlegA2016
User talk:OlesyaV
User talk:Olhoffm
User talk:Oliver911!
User talk:Omerbashir
User talk:Onnola
User talk:OpaHaHa
User talk:Oppitum humiste
User talk:Orzm
User talk:Oscar 0711
User talk:Osingar
User talk:P. Fendrich
User talk:PXR5
User talk:Pagewerbung
User talk:Palastwache
User talk:Papa-alfa85
User talk:Pappnaas666
User talk:Parcero113
User talk:Pascauli
User talk:Passer novus
User talk:PawełMM
User talk:Peal1903
User talk:Peggy68
User talk:Pelikana
User talk:Pelot
User talk:Pepito Sbazzeguti
User talk:Peter Hakenjos
User talk:Peter000retep
User talk:PeterJschmid
User talk:Petra Schlierf
User talk:Phantom3Pix
User talk:Phdreu
User talk:PhilEOS
User talk:Phila-Viktoria
User talk:Philippfreudenberg
User talk:Photography.by.samy
User talk:Pictures by H.
User talk:Piobatsohol16
User talk:Plasmaflori
User talk:Plbg
User talk:Pneuska
User talk:Poldy2000
User talk:Polimorph
User talk:PooleyF
User talk:Poyekhali
User talk:Prajwalshinde
User talk:Prekvojg
User talk:ProfSK
User talk:Profdrmoll
User talk:Pudelek
User talk:Pulvermaar
User talk:Pzeggopov
User talk:Queryzo
User talk:Quinqopoqo
User talk:R.kaelcke
User talk:RJFF
User talk:RS1978
User talk:RSchreg
User talk:Rabax63
User talk:Rafael Rodrigues Camargo
User talk:Raik Schröter, Berga
User talk:Rainer Halama
User talk:Ralf Laub
User talk:RalfHuels
User talk:RalfN
User talk:Ras67
User talk:Raycer
User talk:Raymond
User talk:Razinken
User talk:Rebecca Leisten
User talk:RedSonja57
User talk:Rehma
User talk:Reiner Brode
User talk:ReinerausH
User talk:Reinhard Stolzenbach
User talk:Renate Bomm
User talk:Rhmaster
User talk:Ribbeck73
User talk:Richard he
User talk:RichardJi
User talk:Robin Ho Fotos
User talk:Robvdn17
User talk:RodEnberg
User talk:Rodrigorm2
User talk:Rolfader
User talk:Rolfcosar
User talk:Rolohauck
User talk:Ron-mueller
User talk:Rubenanruben
User talk:Ruderruedi
User talk:Ruedi33a
User talk:Rufmich
User talk:Ruinenjunkie
User talk:Rvuboglopp
User talk:Rübenkopf
User talk:SBT
User talk:Sabine Hinrichs
User talk:Sable147
User talk:Sabrinaluana
User talk:Sachsenbaer
User talk:Sairamnivedita
User talk:Sakkarre3
User talk:Sann001
User talk:Sari1983
User talk:SaschaKerling
User talk:Sch09385
User talk:Schmeily
User talk:Schmidkerstin
User talk:Schnute22
User talk:Schottland77
User talk:Schulhofpassage
User talk:Sebastian Wallroth
User talk:Shardulde
User talk:ShurperMario
User talk:Siegi ZZ
User talk:Silbitzer
User talk:SilkeKir
User talk:SimonCiminski
User talk:Sinus1949
User talk:Sir Gawain
User talk:Sitacuisses
User talk:Sm49
User talk:Smial
User talk:Snoopy1964
User talk:Sohaera
User talk:Sokrates2609
User talk:Solid80
User talk:Soma-bay
User talk:Somegoodname
User talk:Sonalideo
User talk:Staubi59
User talk:Stefan Weil
User talk:Steffen Löwe Gera
User talk:Steffenmalte
User talk:Stein53
User talk:Steinbrecher67
User talk:Steinsplitter
User talk:StephanErnst
User talk:Stoeppke
User talk:SunShineXXX
User talk:Superbass
User talk:Supratim.gre2014
User talk:Surajknrao
User talk:Susanne Wi
User talk:Sven.oujla
User talk:SvenG80
User talk:SybilKaesedick
User talk:SylvesterCologne
User talk:TK-HH
User talk:TOTO=0
User talk:Taesg
User talk:Tamma 2009
User talk:Tanja Esser
User talk:Tarbeker
User talk:Tatzl
User talk:TeWeBs
User talk:Thcilnegeg
User talk:The Photographer
User talk:Themistokles112
User talk:Theo Noll
User talk:Thom-hh
User talk:Thonberger
User talk:Thor-Black
User talk:ThoralfSchade
User talk:Thowiki54
User talk:Thyralon
User talk:Tidusor
User talk:TieR0815
User talk:Tim Alex
User talk:Tim Rademacher
User talk:Tirthajyoti
User talk:Tkarcher
User talk:Tmhpr
User talk:Tobidau
User talk:Tobiiii96
User talk:Tom Brox
User talk:Toscana 2016
User talk:Tuchklaus
User talk:Tueftelnix
User talk:Tugendhueter
User talk:Turnbeutelvergesser
User talk:Twein
User talk:Ubahnverleih
User talk:Uemmi67
User talk:Ujudo
User talk:Ulamm
User talk:Ulf Lautenbach
User talk:Uli gründ
User talk:Ulibeiwiki
User talk:Ulla Fleu
User talk:Ulmara
User talk:Una0612
User talk:Ursus minor
User talk:Usclaus
User talk:Utausb
User talk:UuMUfQ
User talk:Uwe Pilz, Leipzig
User talk:Uwe4321
User talk:Varsharsw
User talk:Varus111
User talk:Vector444
User talk:Vieruebereins
User talk:VikSid
User talk:Viktoriia Saveleva
User talk:Vitavia
User talk:Vitold Muratov
User talk:Volatus
User talk:VolkerHäck
User talk:VolkerInTheField
User talk:Vossi5000
User talk:Vuxi
User talk:W. kipper
User talk:Waldemar L
User talk:Wdwdbot
User talk:WebFax
User talk:Weinig1
User talk:Weiserle
User talk:Whorf
User talk:Wicotw
User talk:Wiener.one
User talk:Wiki05
User talk:Wikimatze
User talk:Wilhelm Zimmerling PAR
User talk:Willma bs
User talk:Winfried Kalbitzer
User talk:Wohage
User talk:Wolfgang Vogt
User talk:Worfeva
User talk:Wschuppi
User talk:WstoddenWCo
User talk:Wueber
User talk:Xocolatl
User talk:Yazan. bk
User talk:Yoursmile
User talk:YuliaLim
User talk:Zeromancer85
User talk:Zorigaiztoko
User talk:Zv0486~commonswiki
User talk:Zzzx
User talk:Öppel
User talk:Überdenwolken
User talk:นวดี

Navigation menu

Search