User:NaomiAmethyst/WikiProject Professional wrestling/Member activity check

Query

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

• .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

1 row in set (1 min 12.54 sec)