Untitled query #87953

SQL

SELECT distinct
    u.user_name AS user_name,
    SUM(CASE WHEN p.page_namespace = 828 AND p.page_is_redirect = 0 
        AND p.page_title NOT REGEXP '^.*?\/(ملعب|مختبر|شرح)/*.*?%'
        THEN 1 ELSE 0 END) AS portals_created,
    SUM(CASE WHEN p.page_namespace = 0 AND p.page_is_redirect = 1 THEN 1 ELSE 0 END) AS module_created
FROM user u
JOIN actor a ON a.actor_user = u.user_id
JOIN revision rev ON rev.rev_actor = a.actor_id
JOIN page p ON rev.rev_page = p.page_id
WHERE
    ucase(a.actor_name) NOT LIKE ucase('%BOT')
    AND a.actor_name NOT LIKE '%بوت%'
    AND a.actor_name NOT IN (SELECT u2.user_name FROM user_groups ug JOIN user u2 ON ug.ug_user = u2.user_id WHERE ug.ug_group = 'bot')
    AND u.user_name NOT IN ('Mr. Ibrahem')
    AND rev.rev_parent_id = 0
GROUP BY u.user_name
ORDER BY pages_created DESC
LIMIT 5
;
SQL

Checking query status...
