All articles with zwnj followed by space per user (excl.redirects)

Fork of All page titles in article name space with zwnj per user by Arjunaraoc

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

All page titles  which contain ZWNJ ( 0xE2808C) followed by space per logged in user with count of 5 or more (excl. redirects)

SQL

SELECT 
    CONCAT('[[User:',actor_name,'|',actor_name,']]') as creator,
    COUNT(*) AS titles_zwnj_count
from  page p
join revision ON     rev_page = p.page_id AND  rev_parent_id = 0 AND p.page_namespace=0 AND page_is_redirect =0
join actor ON    actor_id=rev_actor
# where page_title ='బిశ్వ_భూషణ్‌_హరిచందన్‌‌'
where (HEX(page_title) LIKE '%E2808C5F%'  OR HEX(page_title) LIKE '%E2808C' ) AND actor_user != 0
GROUP BY actor_name
HAVING titles_zwnj_count  > 4
ORDER BY COUNT(*) DESC
LIMIT 20000

SQL

Checking query status...