All articles with zwnj followed by space with redirect target

All page titles  which contain undesired ZWNJ ( 0xE2808C) followed by space or at the end of string excl. redirects with redirect name removing the pattern,
zwnj at end is not converted, needs further edits outside.

SQL

SELECT 
    actor_name,
    page_id,
    REPLACE(page_title, '_', ' ') as pagename,
#    CONVERT(nvarchar(100),REPLACE(HEX(page_title),'%E2808C5F%', '')) as target_title
    UNHEX(REPLACE(HEX(page_title),'%E2808C5F%', '')) as target_title
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%' AND actor_user !=0
ORDER BY actor_name ASC
LIMIT 20000

SQL

Checking query status...