Most users that uses AWB, and Cat-a lot Gadget

Fork of Most users that uses AWB, and Cat-a lot Gadget by ASammour

This query is marked as a draft This query has been published by Mr. Ibrahem.

SQL

use arwiki_p;
SELECT rev_comment 
   # CONCAT(rev_comment) AS "USER",
   # COUNT(rev_id) AS "AWB & CAT-ALOT EDITS"
    FROM user INNER JOIN revision
    ON revision.rev_user = user.user_id
    WHERE  (revision.rev_comment like  (_utf8"% باستخدام [[ويكيبيديا:أوب|أوب]]%") collate utf8_general_ci
    OR revision.rev_comment like  (_utf8"%باستخدام [[Project:أوب|أوب]]%") collate utf8_general_ci
    OR revision.rev_comment like  (_utf8"%[[ميدياويكي:Gadget-Cat-a-lot|تعديل تصنيفات]]%") collate utf8_general_ci )
    and ucase (user_name) not like ucase (_utf8"%BOT") COLLATE utf8_general_ci
    and user_name like  'Mr._Ibrahem'
    GROUP BY rev_comment
    ORDER BY user_editcount DESC
    LIMIT 20;

SQL

Checking query status...