Deleted edits of a user

This query is marked as a draft This query has been published by Chlod.
SQL

SELECT
    `ipb_timestamp` AS "Timestamp",
	`user_name` AS "Username",
    `actor_name` AS "Performer",
    `comment_text` AS "Reason"
FROM `user`
LEFT JOIN ipblocks ON user_id = ipb_user
JOIN `actor_ipblocks` ON `actor_id` = `ipb_by_actor`
JOIN `comment_ipblocks` ON `comment_id` = `ipb_reason_id`
LEFT JOIN `logging_userindex` ON (`log_action` = `user_id` AND `ug_group` = "extendedconfirmed")
WHERE
	user_name IN ("Cusptrek","Leunghochingtimothy1234","Roje Vala","GoldMiner24","Santasa99","Ak-eater06","Qiushufang","Sid54126","CNMall41","Ravensfire","Alpha Piscis Austrini","Megaking23","Rusted AutoParts","Donmccullen","संजीव कुमार","Prong$31","Kugan1997","Юрій Пазій","Sauraved","GenoV84","BlueGhast","Dreamer14513181","Dusti","Bobherry","Hemantha","JayBeeEll","TheAafi","A08jemah","Shikagami03","Adelere13","Autograph84","Aardwolf68","ChasePFree","Sakiv","Incredible93","খাঁটি বাঙালি","Pixelninja2000","Steve7c8","YoungForever","Contribuidorconta","Abhisekh basu","Sleyece","Amaury","IJBall","Moxy","Lightiggy","Hajoon0102","GadgetsGuy","Hemant Shesh","Sportsfan 1234","Eothan","My Pants Metal","Larry Hockett","RomaniaRugbyFan","Shark2433086","Stryn","Apparition11","Jingiby","Kautilya3","\"Jaymark 215","FyzixFighter","Washington Lincoln","SeanMoulton1997","Onmyway22","Williamgregory213","Xx elv","BoxxyBoy","AnkurPl","Wispyrainon","Векочел","Cr7fromTUN","Morce Library","FlightTime","FDW777","Diptyajit","Jgstokes","MrOllie","Ruling party","Geraldo Perez","Advofspec","Yujoong","Whippy7","A.A Ghatge","Sundayclose","Inebranlable92","Kaustubh42","Dabean","BaldiBasicsFan","EverestMachine 4001","JJNito197","Sideshow Bob","DaDeadzombie","Talal Bin Hasan","Davidsousa1","JimmyCrow","Neocon1","Mvbaron","Inspectormusic","Basedch","Zacharyalejandro","GPL93","Sgweirdo","Nishānt Omm","Giraffer","ਰਵੀ ਸਹਿਗਲ","Legitimus","Serols","Nvtuil","SCD0392","Controlrabbit","SS Edits","Dealmaces","AndLikeThings","TheXuitts","Poolietrev","TG11TG15","CRS-20","Janiclett","Seasider53","Magnum5051","GoBlackhawksGo","Thibbs","Abd Moh","Crashed greek","Agon Mustafa","Black roses124","Blu30Top","Xa Sancle","Jjfun3695","Benjamin112","Soumyadip2005","Pax85","GalaxyFighter55","YborCityJohn","RafaelHP","Echo1Charlie","Mortaylor26","Sahil193319","Lord Stephenson","KigToons","Jonnyspeed20","APPU","Saad Mujtaba","Vermont helper","BosnianBeast60","Krillzyx","Gontle Galefite","Omniscientmoose42","Markuss86","Thecorrector21","Scribetastic","Wojak6","Aakash Singh India","Rastinition","Greataussiewallaby","P J Chatterjee","Pirhayati","M.Bitton","Ali17082001","Notfrompedro","Hyperion82","Masry684","Lawikitejana","Ultima the Hedgehog","শৌমেন মান্না","Ppdallo","Tobby72","Pennsylvania2","Pagwghd33","Hoopstercat","Αθλητικά","Vitopavlovivit","TimSmit","Onghai1929","Hjk1106","Flix11","力","SeanJ 2007","MQobad","KapamilyaAdventurer","Davidkenarovcska","Nabasile","Skyshifter","Johnjoshua1","Eostrix","TheAmazingPeanuts","Visnelma","Bravefencer365","Menia97!","The Supermind","Nforystek","RealIK17","POWERStarz2004 the 2nd","Γεώργιος Τερζής 2","Mirkyton","Johnbod","Ratnahastin","MikiSollo","ThesePicklesLoveSosa","Chrissteel34","JugulatorJJ","0mtwb9gd5wx","Hind ji","Russel641","Tomcat7","Category adder","Toddst1","Anshsaini0304","Newimpartial","Amishai GG","Outlander07","Terry g. bishop","VNC200","Baba Mica","Boschanot","Seaeffel","Pleasureme23","Raymarcbadz","Rdp060707","Darkphantom007","Ram Dhaneesh","Jeeputer","Tnays20","Walter Görlitz","Nediyakala Vasavan","Punkyfish3000","SiddhaAS","Thomas Paine1776","10mmsocket","Coldplay48","L33tm4n","Jomart Allaguliyev","Haxxorsid","Olivia ben","Kishmish Hu Main Ok","Grandpallama","RunTonyShells","ConnorAmy","Lordsoffire001","Shafiq Nadim","Woovee","Abbasulu","N1234567","Stuv3","Editorforwiki15","Bhushan m bhandari")
	AND ipb_sitewide = 1
    AND ipb_expiry > DATE_FORMAT(NOW(), "%Y%m%d%H%i%s")
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.
SQL

Checking query status...
