User:Chzz/feed
User Last edit date RFF summary RFF edit time Edit count
*AUburnTiger (talk · contribs) 201005 /* Auburn Tigers swimming and diving */ new section 200901 699
*Addihockey10 (talk · contribs) 201006 /* Hello Time Bomb */ new section 200909 3045
*AirCombat (talk · contribs) 201005 /* User:AirCombat/VANDU */ new section 200904 162
*Aldinuc (talk · contribs) 201005 /* Fastflow (computing) */ new section 200912 170
*AlexPlante (talk · contribs) 201005 /* Infrastructure */ new section 200901 173
*AlexandrDmitri (talk · contribs) 201006 /* Sans aucun doute */ new section 200910 5239
*Alexthepuffin (talk · contribs) 201005 /* Frank D'Angelo */ new section 200905 322
*Anandkharebsnl (talk · contribs) 201004 /* principle of no-work-no-pay (dies non) */ new section 200909 322
*Andremun (talk · contribs) 200912 /* University of Valle */ new section 200902 1089
*Andremun (talk · contribs) 200912 /* University of Valle */ new section 200907 1089
*Annalise (talk · contribs) 201006 /* Virginity test */ new section 200903 1092
*Balkanian`s word (talk · contribs) 201006 /* Cham Albanians */ new section 200903 4319
*Bamse (talk · contribs) 201006 /* Jesuit Missions of the Chiquitos */ new section 200902 10837
*Bcjordan (talk · contribs) 201001 /* Sonja_Lyubomirsky */ new section 200910 325
*Bigroger27509 (talk · contribs) 201006 /* Shakori */ new section 200911 211
*Bigroger27509 (talk · contribs) 201006 /* Shakori */ new section 200911 211
*Blueelectricstorm (talk · contribs) 201005 /* New Industrial Revolution */ new section 200912 505
*Btilm (talk · contribs) 201003 /* Kent Plantation House */ new section 200908 5731
*Canuck100 (talk · contribs) 201004 /* Major revision of Aurora (astronomy) */ new section 200911 486
*Canuck100 (talk · contribs) 201004 /* Energetic neutral atom */ new section 200911 486
*Champmasters (talk · contribs) 201005 /* User:Champmasters/James_M._Masters_Sr. */ new section 200912 430
*Cmadler (talk · contribs) 201006 /* Mount Hope Estate */ new section 200908 6735
*Cmadler (talk · contribs) 201006 /* Pennsylvania Renaissance Faire */ new section 200908 6735
*Countercanter (talk · contribs) 201003 /* Dominant white */ new section 200906 1183
*DD2K (talk · contribs) 201006 /* Larry Coon */ new section 200911 1904
*DanielR235 (talk · contribs) 201005 /* Whether and if. */ new section 200909 324
*Dcs002 (talk · contribs) 201005 /* Morris Katz */ new section 200909 378
*DeFaultRyan (talk · contribs) 201006 /* Utah State Route 143 */ new section 200907 11452
*Die4Dixie (talk · contribs) 201005 /* Pinochet and Fascism portal */ new section 200909 3544
*Djflem (talk · contribs) 201006 /* New Netherland */ new section 200903 14084
*Dodgerblue777 (talk · contribs) 201006 /* Los Angeles Police Department */ new section 200901 3128
*Dvornicsek (talk · contribs) 200909 /* new user needs help */ new section 200908 224
*Dvornicsek (talk · contribs) 200909 /* http://en.wikipedia.org/wiki/L%C3%A1szl%C3%B3_Marton */ new section 200908 224
*Dvornicsek (talk · contribs) 200909 /* http://en.wikipedia.org/wiki/L%C3%A1szl%C3%B3_Marton */ new section 200908 224
*Dylanus (talk · contribs) 200912 /* RK Gorenje ; request for feedback. */ new section 200905 468
*Ecragg (talk · contribs) 201006 /* Woolly Mammoth Theatre Company */ new section 200906 692
*Eddaido (talk · contribs) 201006 /* Boyd's Marriage Index */ new section 200910 564
*Edward130603 (talk · contribs) 201006 /* Nocturnes Op. 37 (Chopin) */ new section 200905 1322
*Edward130603 (talk · contribs) 201006 /* Toxic encephalopathy */ new section 200904 1322
*Eldustado (talk · contribs) 201003 /* Clarinda */ new section 200910 394
*Etnier (talk · contribs) 201005 /* John Etnier */ new section 200901 244
*Fightonfortroy (talk · contribs) 201005 /* Tongal */ new section 200912 182
*Forgottendelights (talk · contribs) 201002 /* Zenos Frudakis */ new section 200912 326
*Gabagool (talk · contribs) 201006 /* Progress Party (Norway) */ new section 200912 3831
*Gbern3 (talk · contribs) 201006 /* Hip hop dance */ new section 200909 1513
*GeorgeLouis (talk · contribs) 201006 /* Introduction to quantum mechanics */ new section 200905 13511
*Gerda Arendt (talk · contribs) 201006 /* http://en.wikipedia.org/wiki/User:Gerda_Arendt */ new section 200908 6340
*Glenfarclas (talk · contribs) 201006 /* Your Notice of Electronic Filing reversion */ new section 200912 11518
*Havis1 (talk · contribs) 201001 /* User:Havis1/International Montessori Society */ new section 200911 266
*Havis1 (talk · contribs) 201001 /* Montessori Method - major revamp */ new section 200912 266
*Hayward Tenney (talk · contribs) 200912 /* Famous Smoke Shop */ new section 200912 204
*HelioSmith (talk · contribs) 201006 /* Redgrave and Lopham Fen */ new section 200901 655
*Hezimmerman (talk · contribs) 201006 /* Request for comments on User:Hezimmerman/new article name */ new section 200912 384
*Inbody (talk · contribs) 201005 /* Proposed New Entry for Civil-military Relations */ new section 200906 347
*InproperinLA (talk · contribs) 201001 /* NEF (Notice of Electronic Filing) seeking feedback */ new section 200912 355
*InproperinLA (talk · contribs) 201001 /* Rampart-FIPs (Falsely Imprisoned Persons) */ new section 200912 355
*InproperinLA (talk · contribs) 201001 /* Richard Isaac Fine */ new section 200912 355
*Intelligentsium (talk · contribs) 201006 /* Reviewers needed urgently */ new section 200911 10516
*JTBX (talk · contribs) 201006 /* Cultural Impact of Michael Jackson */ new section 200910 1948
*Jalwikip (talk · contribs) 201005 /* Nicolas Peyrac */ new section 200911 648
*JeremeK (talk · contribs) 201005 /* Shadowgraphy */ new section 200912 283
*Jerzeykydd (talk · contribs) 201006 /* US Cable News: My first Created Article */ new section 200901 5918
*Jerzeykydd (talk · contribs) 201006 /* US Cable News */ new section 200901 5918
*Jimpeoples (talk · contribs) 200904 /* User:Jimpeoples/Example/John_p_Healey */ new section 200904 210
*JohnTheSupercargo (talk · contribs) 200905 /* Margaret Bryan */ new section 200904 158
*Johncmorley (talk · contribs) 200912 /* Please provide feedback and formatting suggestions */ new section 200909 200
*Jsgoodrich (talk · contribs) 201006 /* Review of Kenwood Towne Place */ new section 200912 283
*July271997 (talk · contribs) 200910 /* feedback please? */ new section 200908 151
*Jxc5 (talk · contribs) 201003 /* http://en.wikipedia.org/wiki/User:Jxc5/Charles_Lockwood */ new section 200901 695
*Jxc5 (talk · contribs) 201003 /* http://en.wikipedia.org/wiki/User:Jxc5/Charles_Lockwood */ new section 200901 695
*Kan8eDie (talk · contribs) 201004 /* arg (mathematics) */ new section 200902 1740
*Kannaphon (talk · contribs) 201004 /* Royal Cliff Beach Resort */ new section 200903 200
*Kbaughan1 (talk · contribs) 201005 /* User:Kbaughan1/Hamilton Road Cemetery, Deal, Kent */ new section 200911 390
*Kenchikuben (talk · contribs) 201005 /* Junzo Sakakura */ new section 200911 225
*Kevinbrogers (talk · contribs) 201006 /* Covert Affairs */ new section 200912 2804
*Koliber (talk · contribs) 201001 /* Educational Assignment: History of the Family */ new section 200907 472
*Krrush (talk · contribs) 201003 /* Ayodele Awojobi */ new section 200912 246
*Ks0stm (talk · contribs) 201006 /* User:Ks0stm/Mesovortices */ new section 200911 4820
*LSmok3 (talk · contribs) 201004 /* Ian Miller (illustrator), John Blanche, Confounding Factor (games company) */ new section 200909 971
*LirazSiri (talk · contribs) 201003 /* Requesting feedback on proposed TurnKey Linux article */ new section 200903 595
*LookingYourBest (talk · contribs) 201004 /* Request for feedback on article Crazy Bones */ new section 200904 797
*LynnSGrubb (talk · contribs) 201006 /* Jehu Grubb */ new section 200911 1007
*LynnSGrubb (talk · contribs) 201006 /* Peter Grubb, Jr. */ new section 200911 1007
*LynnSGrubb (talk · contribs) 201006 /* Curtis Grubb */ new section 200911 1007
*LynnSGrubb (talk · contribs) 201006 /* Firman R. Grubb */ new section 200911 1007
*MLauba (talk · contribs) 201006 /* Wizard101 */ new section 200908 8685
*Marcia Wright (talk · contribs) 201005 /* King Range Wilderness */ new section 200908 3287
*Marjieruthhadad (talk · contribs) 201003 /* Yossi Gross */ new section 200906 298
*Mark Shaw (talk · contribs) 201006 /* Lung Flute */ new section 200911 2964
*Mattymatt (talk · contribs) 201006 /* Gordon Muir Giles */ new section 200912 218
*MorganaFiolett (talk · contribs) 201005 /* Morecambe Winter Gardens */ new section 200912 968
*Mynameinc (talk · contribs) 201004 /* New York City ethnic enclaves */ new section 200905 3293
*NeoGenPT (talk · contribs) 201004 /* Formula One (1985 video game) */ new section 200912 2359
*Nkf31 (talk · contribs) 201004 /* NANO */ new section 200912 381
*Nkf31 (talk · contribs) 201004 /* NANO */ new section 200912 381
*Nmcmurdo (talk · contribs) 200910 /* Mikhail Shufutinsky */ new section 200909 402
*Nosper (talk · contribs) 200912 /* Female sexual arousal and orgasm */ new section 200911 1202
*OlEnglish (talk · contribs) 201006 /* Barnston Island Ferry */ new section 200906 33514
*Osarius (talk · contribs) 201006 /* Bamford Youth Club */ new section 200912 2676
*Peter Napkin Dance Party (talk · contribs) 201006 /* Dog sex */ new section 200910 582
*Phantomsteve (talk · contribs) 201006 /* William Stanley (Victorian inventor) */ new section 200909 22651
*Puzl bustr (talk · contribs) 201005 /* Carbon burning process */ new section 200910 657
*Richard Nowell (talk · contribs) 201005 /* Peas_(Astronomy) */ new section 200912 894
*Rm125 (talk · contribs) 200909 /* Dispute with biased Wikipedian */ new section 200908 962
*Sadads (talk · contribs) 201006 /* International Foudation for Electoral Systems */ new section 200908 8136
*Sadads (talk · contribs) 201006 /* Good Governance */ new section 200910 8136
*SamUK (talk · contribs) 201005 /* Politics of Bristol */ new section 200904 271
*Sinequaoui (talk · contribs) 200909 /* Okay now to remove the BLP banner on the Robert Conley page? */ new section 200909 256
*Smf77 (talk · contribs) 201003 /* Schloss Eggenberg (Graz) */ new section 200909 274
*Smf77 (talk · contribs) 201003 /* [[Schloss Eggenberg (Graz) */ new section 200909 274
*South Bay (talk · contribs) 201003 /* The free ecnyclopedia */ new section 200908 4190
*SpacemanSpiff (talk · contribs) 201006 /* Adyar */ new section 200905 18648
*Speakwise (talk · contribs) 201004 /* Education in Guyana */ new section 200904 179
*Stonnman (talk · contribs) 201006 /* Margaret Holland Sargent */ new section 200911 306
*Strickja (talk · contribs) 201006 /* Népouite */ new section 200912 213
*Strom (talk · contribs) 201006 /* Wlad Godzich */ new section 200910 918
*SummerWithMorons (talk · contribs) 201006 /* Article: Situationist International - from Start to C-Class */ new section 200903 5225
*Teeninvestor (talk · contribs) 201006 /* Economic history of China(Pre-1911) */ new section 200905 6225
*The Wordsmith (talk · contribs) 201006 /* White Night Riots */ new section 200905 5697
*Thelema12 (talk · contribs) 201005 /* User:Thelema12/Utah Education Association */ new section 200910 432
*Tim Song (talk · contribs) 201006 /* Test */ new section 200912 20442
*Tntdj (talk · contribs) 201006 /* RFF - Jake Edwards */ new section 200907 791
*Tntdj (talk · contribs) 201006 /* RFF User:Tntdj/"Bridging chipset" */ new section 200907 791
*Turqoise127 (talk · contribs) 201006 /* Kresimir Chris Kunej */ new section 200912 593
*U5K0 (talk · contribs) 201005 /* ESRO */ new section 200908 1372
*Ukexpat (talk · contribs) 201006 /* User:Acrompton/multifaith spaces */ new section 200912 63546
*Viciouslies (talk · contribs) 201006 /* In re: Gill */ new section 200908 342
*Wassupwestcoast (talk · contribs) 201006 /* Bog turtle */ new section 200911 11188
*Welshentag (talk · contribs) 201004 /* University Church, Freiburg */ new section 200909 300
*Wikilost (talk · contribs) 201005 /* David I. Shapiro */ new section 200910 513
*Wikilost (talk · contribs) 201005 /* Bank War */ new section 200910 513
*ΙΣΧΣΝΙΚΑ-888 (talk · contribs) 201005 /* Byzantine calendar */ new section 200907 540
Source
Many thanks to stwalkerster (talk · contribs) Chzz ► 21:10, 8 June 2010 (UTC)
SELECT CONCAT("<br>*{{user|",u.user_name,"}}") as "User", MAX(LEFT(rlast.rev_timestamp,6)) as "Last edit date", CONCAT("[http://en.wikipedia.org/enwiki/w/index.php?diff=prev&oldid=",r.rev_id, "&title=Wikipedia:Requests_for_feedback ", r.rev_comment, "]") AS "RFF summary", LEFT(r.rev_timestamp,6) AS "RFF edit time", u.user_editcount AS "Edit count" -- from the tables: revision, page, and user, using the primary keys as indices FROM revision r INNER JOIN page p ON p.page_id = r.rev_page INNER JOIN user u ON u.user_id = r.rev_user -- join revision back in so we can look for the largest timestamp for the user in question. Note that rev_user_text is indexed, whereas rev_user isn't. Dunno why. INNER JOIN revision rlast ON rlast.rev_user_text = u.user_name -- Get the right page, should reduce the revision count a lot. WHERE p.page_namespace = 4 AND p.page_title = "Requests_for_feedback" -- Get the right edit summary AND r.rev_comment LIKE "/* % */ new section" -- 2009 or later AND r.rev_timestamp >= 20090000000000 -- but after 2010 AND r.rev_timestamp < 20100000000000 -- experienced users only! AND u.user_editcount > 150 -- Group by something unique to each RFF edit, the rev_id (because we've got that aggregate function (MAX) in the select) GROUP BY r.rev_id -- order by the username ORDER BY u.user_name ASC