User:NaomiAmethyst/WikiProject Ohio/Member activity check
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_Ohio/Participants'
)
) AS `p`
WHERE
`p`.`pl_title` = `u`.`user_name`
) AS `userdata`
) AS `stuff`
;
Results[edit]
- 08milluz — Active
- 09er — Active
- AAARanger5 — Has not edited within the last year
- AJHalliwell — Active
- Adrift* — Active
- AffirmationChick — Active
- Ajwebb — Active
- Akmarch — Active
- Akronohio00 — Active
- Akronpow — Has not edited within the last 6 months
- Alex43223 — Active
- Altosax456 — Has not edited within the last 6 months
- Amr8r4 — Has less than 25 edits
- Aquamelli — Active
- BFDhD — Active
- Backburner001 — Active
- Bhockey10 — Active
- BillyMassie — Active
- Bopher1 — Has not edited within the last year
- Bwryan2006 — Active
- CL8 — Active
- CRKingston — Has not edited within the last year
- Captadam — Active
- CardinalDan — Active
- ClairSamoht — Active
- Clariosophic — Active
- Clevelander96 — Active
- Cookiejuran — Has not edited within the last 6 months
- CoppBob — Active
- DangApricot — Active
- DeathLoofah — Active
- DvdBengals — Has not edited within the last year
- Ender78 — Active
- ErinLeighC — Has less than 25 edits
- ExSpectator — Has not edited within the last 6 months
- ExplorerCY — Active
- Ezsaias — Has not edited within the last 6 months
- Fisheromen — Has not edited within the last year
- Frank12 — Active
- FrixFrixFrix — Has less than 25 edits
- Furik — Active
- Garonyldas — Active
- Godlord2 — Active
- Highland1 — Has less than 25 edits
- Historymike — Active
- Hmwith — Active
- Hornandsoccer — Has not edited within the last 6 months
- Iamheredude — Active
- IlGreven — Active
- JacquiBuschor — Has less than 25 edits
- Jap4mu07 — Has less than 25 edits
- JeffBillman — Active
- JeffreyAlphaOne — Active
- JimmB — Active
- Jon99UT — Has not edited within the last 6 months
- JonRidinger — Active
- Knightrojen — Has not edited within the last year
- Late1 — Active
- LeheckaG — Active
- Lesserm — Active
- LucasHistorian — Has less than 25 edits
- Malekish — Has not edited within the last 6 months
- Malepheasant — Active
- MarkDonna — Active
- Mdedmonds — Has less than 25 edits
- Metatinara — Active
- Mordicaiyoung — Has less than 25 edits
- Morhange — Active
- Mxn — Active
- Navie05 — Active
- Nerguy — Active
- NintendoNerd777 — Active
- Nyttend — Active
- OHWiki — Active
- OhioVanguard — Has not edited within the last year
- Oldiesmann — Active
- Patricknoddy — Has not edited within the last year
- Paultyng — Has not edited within the last year
- Pepsi2786 — Active
- Polypmaster — Active
- Prinzwilhelm — Active
- Pronounciator — Has less than 25 edits
- RJCraig — Active
- RiSK — Active
- Rkitko — Active
- Robbie0513 — Active
- Rovership27 — Active
- Royalmate1 — Active
- Ryecatcher773 — Active
- Seth71 — Active
- Sixes — Has less than 25 edits
- Spencer — Active
- Spongefan — Active
- Sportman2 — Active
- SteelRat02 — Has not edited within the last 6 months
- Stepshep — Active
- Stubbleboy — Active
- Suitmonster — Active
- Tarpy — Active
- Tcjoe1985 — Has not edited within the last 6 months
- Teala1 — Active
- Thatvoiceagain — Has less than 25 edits
- TheShadow0105 — Active
- Toadwildride — Active
- Toledo47 — Active
- Twelsht — Active
- Tylerp9p — Active
- Vbofficial — Active
- WTGDMan1986 — Active
- Westonjoe — Active
- Wickb55 — Active
- Wizardman — Active
- Woostergoodwill — Has less than 25 edits
- Xexeter — Active
- Zagsa — Active
- Zars — Active