User:MZMcBride/Sandbox
select distinct concat('# https://en.wikipedia.org/wiki/Special:Log?page=User:', log_title) from logging_userindex where log_type = 'rights' and log_action = 'rights' and log_timestamp like '202%' and replace(log_title, '_', ' ') in (select user_name from ipblocks join user on user_id = ipb_user);
- https://en.wikipedia.org/wiki/Special:Log?page=User:ST47Bot
- https://en.wikipedia.org/wiki/Special:Log?page=User:Isaacsorry
- https://en.wikipedia.org/wiki/Special:Log?page=User:Lapablo
- https://en.wikipedia.org/wiki/Special:Log?page=User:Biografer
- https://en.wikipedia.org/wiki/Special:Log?page=User:PunjabCinema07
- https://en.wikipedia.org/wiki/Special:Log?page=User:Swagtugs
- https://en.wikipedia.org/wiki/Special:Log?page=User:Mark_Sublette
- https://en.wikipedia.org/wiki/Special:Log?page=User:Mrspaceowl
- https://en.wikipedia.org/wiki/Special:Log?page=User:Miraclepine_Amour
- https://en.wikipedia.org/wiki/Special:Log?page=User:Miraclepine_Amour_II
- https://en.wikipedia.org/wiki/Special:Log?page=User:King_of_Scorpions
- https://en.wikipedia.org/wiki/Special:Log?page=User:Seraphim_System
- https://en.wikipedia.org/wiki/Special:Log?page=User:Jai49
- https://en.wikipedia.org/wiki/Special:Log?page=User:Jytdog2
- https://en.wikipedia.org/wiki/Special:Log?page=User:KartikeyaS343
- https://en.wikipedia.org/wiki/Special:Log?page=User:Vivek_ji123
- https://en.wikipedia.org/wiki/Special:Log?page=User:Olaf_Kosinsky
- https://en.wikipedia.org/wiki/Special:Log?page=User:Flix11
- https://en.wikipedia.org/wiki/Special:Log?page=User:Sri_Harsha_191817
- https://en.wikipedia.org/wiki/Special:Log?page=User:HaughtonBrit
- https://en.wikipedia.org/wiki/Special:Log?page=User:Woerich
- https://en.wikipedia.org/wiki/Special:Log?page=User:Antila
- https://en.wikipedia.org/wiki/Special:Log?page=User:Amkgp
- https://en.wikipedia.org/wiki/Special:Log?page=User:Galendalia
- https://en.wikipedia.org/wiki/Special:Log?page=User:Ugbedeg
- https://en.wikipedia.org/wiki/Special:Log?page=User:DAP388
- https://en.wikipedia.org/wiki/Special:Log?page=User:Juliette_Han
- https://en.wikipedia.org/wiki/Special:Log?page=User:Prahlad_balaji
- https://en.wikipedia.org/wiki/Special:Log?page=User:Eostrix
- https://en.wikipedia.org/wiki/Special:Log?page=User:Ashiyura
- https://en.wikipedia.org/wiki/Special:Log?page=User:Total_Eclipse_2017
- https://en.wikipedia.org/wiki/Special:Log?page=User:ErfgoedBot
- https://en.wikipedia.org/wiki/Special:Log?page=User:KoshVorlon
- https://en.wikipedia.org/wiki/Special:Log?page=User:Mar11
- https://en.wikipedia.org/wiki/Special:Log?page=User:Lord_Valton
- https://en.wikipedia.org/wiki/Special:Log?page=User:Landihan
- https://en.wikipedia.org/wiki/Special:Log?page=User:Starzoner
- https://en.wikipedia.org/wiki/Special:Log?page=User:FR30799386
- https://en.wikipedia.org/wiki/Special:Log?page=User:Legacypac
- https://en.wikipedia.org/wiki/Special:Log?page=User:MC_SeonWoo
- https://en.wikipedia.org/wiki/Special:Log?page=User:Total_Eclipse_2017_(AWB_editing)
- https://en.wikipedia.org/wiki/Special:Log?page=User:PythonSwarm
- https://en.wikipedia.org/wiki/Special:Log?page=User:HSaurab
- https://en.wikipedia.org/wiki/Special:Log?page=User:Lihaas
- https://en.wikipedia.org/wiki/Special:Log?page=User:CAPTAIN_MEDUSA
- https://en.wikipedia.org/wiki/Special:Log?page=User:Empire_AS
- https://en.wikipedia.org/wiki/Special:Log?page=User:S_Marshall
- https://en.wikipedia.org/wiki/Special:Log?page=User:CallMeByYourMane
- https://en.wikipedia.org/wiki/Special:Log?page=User:Isingness
- https://en.wikipedia.org/wiki/Special:Log?page=User:Santhosh_Wiki_Edit
- https://en.wikipedia.org/wiki/Special:Log?page=User:Samaine
- https://en.wikipedia.org/wiki/Special:Log?page=User:[email protected]
- https://en.wikipedia.org/wiki/Special:Log?page=User:Factfanatic1
- https://en.wikipedia.org/wiki/Special:Log?page=User:EurovisionNim
- https://en.wikipedia.org/wiki/Special:Log?page=User:CaradhrasAiguo
- https://en.wikipedia.org/wiki/Special:Log?page=User:CLCStudent
- https://en.wikipedia.org/wiki/Special:Log?page=User:Greenock125
- https://en.wikipedia.org/wiki/Special:Log?page=User:Cesdeva
- https://en.wikipedia.org/wiki/Special:Log?page=User:Lmmnhn
- https://en.wikipedia.org/wiki/Special:Log?page=User:Soul_Crusher
- https://en.wikipedia.org/wiki/Special:Log?page=User:Tktru
- https://en.wikipedia.org/wiki/Special:Log?page=User:Jiv_arshu
- https://en.wikipedia.org/wiki/Special:Log?page=User:Plucas58
- https://en.wikipedia.org/wiki/Special:Log?page=User:Moscowdreams
- https://en.wikipedia.org/wiki/Special:Log?page=User:Apollo1203
- https://en.wikipedia.org/wiki/Special:Log?page=User:Lordpermaximum
- https://en.wikipedia.org/wiki/Special:Log?page=User:IHateAccounts
- https://en.wikipedia.org/wiki/Special:Log?page=User:Minhaj_Arfin_Milon
- https://en.wikipedia.org/wiki/Special:Log?page=User:Arran_Arts_Heritage_Trail
- https://en.wikipedia.org/wiki/Special:Log?page=User:Davidwr
- https://en.wikipedia.org/wiki/Special:Log?page=User:Danloud
- https://en.wikipedia.org/wiki/Special:Log?page=User:Elmssuper
- https://en.wikipedia.org/wiki/Special:Log?page=User:Wumbolo
- https://en.wikipedia.org/wiki/Special:Log?page=User:TXttx4xttXT
- https://en.wikipedia.org/wiki/Special:Log?page=User:Pulisi
- https://en.wikipedia.org/wiki/Special:Log?page=User:Nalbarian2
- https://en.wikipedia.org/wiki/Special:Log?page=User:KIENGIR
- https://en.wikipedia.org/wiki/Special:Log?page=User:Cydebot
- https://en.wikipedia.org/wiki/Special:Log?page=User:Noidaabc
- https://en.wikipedia.org/wiki/Special:Log?page=User:Alextwa
- https://en.wikipedia.org/wiki/Special:Log?page=User:Kashmorwiki
- https://en.wikipedia.org/wiki/Special:Log?page=User:Wahhid
- https://en.wikipedia.org/wiki/Special:Log?page=User:TheGracefulSlick
- https://en.wikipedia.org/wiki/Special:Log?page=User:CommanderWaterford
- https://en.wikipedia.org/wiki/Special:Log?page=User:EGL1234
- https://en.wikipedia.org/wiki/Special:Log?page=User:Hulged
- https://en.wikipedia.org/wiki/Special:Log?page=User:A1Cafel
- https://en.wikipedia.org/wiki/Special:Log?page=User:Ruigeroeland
- https://en.wikipedia.org/wiki/Special:Log?page=User:Luciapop
- https://en.wikipedia.org/wiki/Special:Log?page=User:Tenebrae
- https://en.wikipedia.org/wiki/Special:Log?page=User:Whatsupkarren
- https://en.wikipedia.org/wiki/Special:Log?page=User:Jikaoli_Kol
- https://en.wikipedia.org/wiki/Special:Log?page=User:Amber1028
- https://en.wikipedia.org/wiki/Special:Log?page=User:Govercon
- https://en.wikipedia.org/wiki/Special:Log?page=User:Cupcake547_(alt)
- https://en.wikipedia.org/wiki/Special:Log?page=User:Jjaey
- https://en.wikipedia.org/wiki/Special:Log?page=User:Hockeycatcat
- https://en.wikipedia.org/wiki/Special:Log?page=User:Sthacker21
- https://en.wikipedia.org/wiki/Special:Log?page=User:Ujjwal_20
- https://en.wikipedia.org/wiki/Special:Log?page=User:HurricaneParrot
- https://en.wikipedia.org/wiki/Special:Log?page=User:Devopam
- https://en.wikipedia.org/wiki/Special:Log?page=User:Unitedman97
- https://en.wikipedia.org/wiki/Special:Log?page=User:Epiphyta
- https://en.wikipedia.org/wiki/Special:Log?page=User:GermanKity
- https://en.wikipedia.org/wiki/Special:Log?page=User:Princepratap1234
- https://en.wikipedia.org/wiki/Special:Log?page=User:Nobodyfornow
- https://en.wikipedia.org/wiki/Special:Log?page=User:Vedbas
- https://en.wikipedia.org/wiki/Special:Log?page=User:LaceyUF
- https://en.wikipedia.org/wiki/Special:Log?page=User:Bsskchaitanya
- https://en.wikipedia.org/wiki/Special:Log?page=User:Renamed_user_5097696514
- https://en.wikipedia.org/wiki/Special:Log?page=User:Riteboke
- https://en.wikipedia.org/wiki/Special:Log?page=User:AmirahBreen
- https://en.wikipedia.org/wiki/Special:Log?page=User:GalactosemiaAtaxia
- https://en.wikipedia.org/wiki/Special:Log?page=User:Menu_maharaj
- https://en.wikipedia.org/wiki/Special:Log?page=User:Imjha1
- https://en.wikipedia.org/wiki/Special:Log?page=User:TheChronium
- https://en.wikipedia.org/wiki/Special:Log?page=User:Agnihothri_Sharath
- https://en.wikipedia.org/wiki/Special:Log?page=User:NagalimNE
- https://en.wikipedia.org/wiki/Special:Log?page=User:John_from_Idegon
- https://en.wikipedia.org/wiki/Special:Log?page=User:Krishnavilasom_Bhageerathan_Pilla
- https://en.wikipedia.org/wiki/Special:Log?page=User:Lazy_Maniik
- https://en.wikipedia.org/wiki/Special:Log?page=User:Amir_Khanas_Forever
- https://en.wikipedia.org/wiki/Special:Log?page=User:Memorable_Dance
- https://en.wikipedia.org/wiki/Special:Log?page=User:Span_Calari
- https://en.wikipedia.org/wiki/Special:Log?page=User:Petruccio_Salema
- https://en.wikipedia.org/wiki/Special:Log?page=User:Herry3999
- https://en.wikipedia.org/wiki/Special:Log?page=User:YT0
- https://en.wikipedia.org/wiki/Special:Log?page=User:Sniper_65k
- https://en.wikipedia.org/wiki/Special:Log?page=User:Jannizzero1
- https://en.wikipedia.org/wiki/Special:Log?page=User:Aslanshou
- https://en.wikipedia.org/wiki/Special:Log?page=User:Epbr123
- https://en.wikipedia.org/wiki/Special:Log?page=User:IlluminatingTrooper
- https://en.wikipedia.org/wiki/Special:Log?page=User:GraniteSand
- https://en.wikipedia.org/wiki/Special:Log?page=User:Richard_Michael_William
- https://en.wikipedia.org/wiki/Special:Log?page=User:AustralianRupert
- https://en.wikipedia.org/wiki/Special:Log?page=User:HickoryOughtShirt
- https://en.wikipedia.org/wiki/Special:Log?page=User:Knopfler56
- https://en.wikipedia.org/wiki/Special:Log?page=User:CD_2022
- https://en.wikipedia.org/wiki/Special:Log?page=User:VanteMY7
- https://en.wikipedia.org/wiki/Special:Log?page=User:SamridhTmrk
- https://en.wikipedia.org/wiki/Special:Log?page=User:Septrillion
- https://en.wikipedia.org/wiki/Special:Log?page=User:FRadical_Bot
- https://en.wikipedia.org/wiki/Special:Log?page=User:Masterknighted
- https://en.wikipedia.org/wiki/Special:Log?page=User:Legobot_II