User:NaomiAmethyst/WikiProject Professional wrestling/Member activity check
Appearance
Query
[edit]SET group_concat_max_len = 102400;
SELECT
GROUP_CONCAT(
CONCAT(
'* [[User:',
`user_name`,
'|]] — ',
`status`
)
SEPARATOR '\n'
) AS `wikitext`
FROM
(
SELECT
`user_name`,
IF(
`user_editcount` = 0,
"Has never edited",
IF(
`user_editcount` < 25,
"Has less than 25 edits",
IF(
`lastedit` < UNIX_TIMESTAMP() - 60*60*24*365,
"Has not edited within the last year",
IF(
`lastedit` < UNIX_TIMESTAMP() - 60*60*24*365/2,
"Has not edited within the last 6 months",
"Active"
)
)
)
) AS `status`
FROM
(
SELECT
`user_id`,
`user_name`,
`user_editcount`,
(
SELECT
UNIX_TIMESTAMP(`rev_timestamp`) AS `lastedit`
FROM
`revision`
WHERE
`rev_user` = `user_id`
ORDER BY
`rev_timestamp` DESC
LIMIT 1
) AS `lastedit`
FROM
`user` AS `u`,
(
SELECT
`pl_title`
FROM
`pagelinks`
WHERE
`pl_namespace` = 2
AND `pl_from` = (
SELECT
`page_id`
FROM
`page`
WHERE
`page_namespace` = 4
AND `page_title` = 'WikiProject_Professional_wrestling/Members_list'
)
) AS `p`
WHERE
`p`.`pl_title` = `u`.`user_name`
) AS `userdata`
) AS `stuff`
;
Results
[edit]- .mdk. — Active
- 3bulletproof16 — Active
- 3pointswish — Active
- Adster95 — Active
- Altenhofen — Active
- AndarielHalo — Active
- Apsouthern — Active
- ArcAngel — Active
- BBoy — Active
- Baycore — Active
- Bedford — Active
- Bencey — Active
- Bigkhrisdogg — Active
- Black6989 — Active
- Blazzeee — Active
- Bmg916 — Active
- Budd16 — Active
- CJMiller — Active
- CMJMEM — Active
- CMPunkster — Active
- CWSensation — Active
- Caleson — Active
- Camelglue22 — Active
- Chad1m — Active
- Chandlerjoeyross — Active
- Crazy4metallica — Active
- D.M.N. — Active
- DaChosenWon — Active
- Dahumorist — Active
- Dangelo82 — Active
- DanteAgusta — Active
- Darrenhusted — Active
- David57437 — Active
- Derrty2033 — Active
- Dingyv03 — Active
- Don.-.J — Active
- DoomsDay349 — Active
- Drwarpmind — Active
- Dubhagan — Active
- Edgehead5150 — Active
- Ekedolphin — Active
- Endlessdan — Active
- Ericystephi — Active
- Evie317 — Active
- FPAtl — Active
- FridayNitro — Active
- GIGGAS2 — Active
- Geoffg — Active
- Giovnni — Active
- GuffasBorgz7 — Active
- Gwalla — Active
- Hack-Man — Active
- Hezekiah957 — Active
- HidyHoTim — Active
- Inhumer — Active
- Insanityinc — Active
- JakeDHS07 — Active
- Java7837 — Active
- Johnissoevil — Active
- KBD5196 — Active
- KaceCC — Active
- Kelan — Active
- KingMorpheus — Active
- KingOfDX — Active
- Kitch — Active
- L0W3R1D3R — Active
- LAX — Active
- Lafraisne — Active
- Lakers244805 — Active
- Lakes — Active
- Ldeffinbaugh — Active
- Leclaird — Active
- Leobarudi — Active
- LessThanClippers — Active
- Loosie — Active
- MC511 — Active
- MDB913 — Active
- Madbassist — Active
- MarcK — Active
- Mas0playa — Active
- McJeff — Active
- McPhail — Active
- Me — Active
- Michaelbueza — Active
- Miztahrogers — Active
- Mshake3 — Active
- N78 — Active
- Nbalivetwothousandandthree — Has less than 25 edits
- NiciVampireHeart — Active
- NickSparrow — Active
- Nikki311 — Active
- Niteshift36 — Active
- Normy132 — Active
- Numyht — Active
- Oakster — Active
- Olliewiththeface — Active
- OutRider2003 — Active
- Overlordneo — Active
- Parsonsburg — Active
- Patriot174 — Active
- Paulley — Active
- Pavlen666 — Active
- PepsiPlunge13 — Active
- Perry8331 — Active
- Phbasketball6 — Active
- Phoenix917 — Active
- PlaguedKiller — Active
- Pookeo9 — Active
- Princekong2 — Active
- ProtoWolf — Active
- Rabbethan — Active
- Raderick — Active
- Rakez — Active
- Reallmmablogger — Active
- RedvBlue — Active
- RingWars2007 — Active
- RkOrton — Active
- Roninbk — Active
- SChaos1701 — Active
- SFrank85 — Active
- SRX — Active
- Sawdichtel — Active
- Scca8704 — Active
- Scorpion0422 — Active
- Sdegner — Active
- Shabe0mac — Active
- Shatterzer0 — Active
- SilentRage — Active
- SimonKSK — Active
- Skitzouk — Active
- Spike7000 — Active
- Spikeleefan — Active
- Sub619 — Active
- Sundogs — Active
- SuperSilver901 — Active
- Superslammin — Active
- Swampfire — Active
- Technogreek43 — Active
- Tenspeeder — Active
- ThinkBlue — Active
- ThisDude62 — Active
- Tony2Times — Active
- UTboy25 — Active
- UzEE — Active
- Vetes — Active
- Vic729 — Active
- Virakhvar321 — Active
- Vjmlhds — Active
- VladamireSteelwolf — Active
- WTGDMan1986 — Active
- WWEFAN99 — Active
- WWEFreak666 — Active
- Welshy1791 — Active
- WestJet — Active
- Wrestlinglover — Active
- Wweisreal — Active
- Xbox6 — Active
- Xvxaderynxvx — Has less than 25 edits
- Zdunne — Active
- Zeppy1968 — Active
- Zlrussell — Active
Time
[edit]1 row in set (1 min 12.54 sec)