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