All articles which redirect to page with unnecessary zwnj

SQL

SELECT 
     page_title,
     rd_title_f1,
     case when HEX(rd_title_f1) NOT LIKE "%E2808C" THEN UNHEX(rd_title)
    ELSE UNHEX(LEFT(HEX(rd_title_f1), LEN(HEX(rd_title_1) -6 )) as rd_title_f2

FROM (SELECT 
      page_title,
      REPLACE(UNHEX(REPLACE(HEX(rd_title),'E2808C5F', '5F')) as rd_title_f1
from  page p
join redirect ON  rd_from=p.page_id
# where page_title ='బిశ్వ_భూషణ్‌_హరిచందన్‌‌'
where ( HEX(rd_title) LIKE '%E2808C5F%' OR HEX(rd_title) LIKE '%E2808C') AND rd_namespace=0 ) as rdp
ORDER BY  page_title ASC
LIMIT 20000

SQL

Checking query status...