All articles which redirect to page with unnecessary zwnj

SQL

SELECT 
     p2.page_title,
     rdp.rd_title_f
     CASE 'rd_title_fn' WHEN  HEX(rdp.rd_title_f) NOT LIKE "%E2808C" THEN UNHEX(LEFT(HEX(rdp.rd_title_f), LEN(HEX(rdp.rd_title_f) -6 ))
     END 'rd_title_fn'
#     END 'rd_title_fn'
#    ELSE UNHEX(LEFT(HEX(rdp.rd_title_f), LEN(HEX(rdp.rd_title_f) -6 )) as rd_title_f2
FROM page p2
           
JOIN  (SELECT 
      page_id, 
      UNHEX(REPLACE(HEX(rd_title),'E2808C5F', '5F')) as rd_title_f
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 )  rdp ON rdp.page_id=p2.page_id
ORDER BY  p2.page_title ASC
LIMIT 20000

SQL

Checking query status...