All articles which are redirects to zwnj-fix -exp2

Fork of All articles which are redirects to zwnj-fix -exp by Arjunaraoc

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

SQL

SELECT
     rdc.page_title,
     p3.page_title
FROM page p3
JOIN (
SELECT 
     p2.page_title,   
     CASE WHEN  HEX(rdp.rd_title_f) LIKE "%E2808C" THEN UNHEX(REVERSE(SUBSTRING(REVERSE(HEX(rdp.rd_title_f)),7)))
     ELSE      rdp.rd_title_f
     END as rd_title_fn
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) rdc
ON p3.page_title = rdc.rd_title_fn and p3.page_namespace=0

ORDER BY  rdc.page_title ASC
LIMIT 1000

SQL

Checking query status...