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
    u.user_name IN ('Mr. Ibrahem')
    AND rev.rev_parent_id = 0
    AND p.page_namespace = 828
GROUP BY u.user_name
LIMIT 5
;
SQL

Checking query status...
