970601 mp1 # of DAB pages with redirected link (pages)

SQL

SELECT DISTINCT catarlan.ll_title, catar.page_namespace, cl_to, catlan.ll_title
FROM enwiki_p.langlinks AS catarlan
JOIN enwiki_p.page AS catar ON ll_from = page_id AND catar.page_is_redirect = 0 AND catarlan.ll_lang = 'fa' AND catar.page_namespace = 0 # or 14
JOIN enwiki_p.categorylinks ON page_id = cl_from
JOIN enwiki_p.page AS cat ON cat.page_title = cl_to AND cat.page_is_redirect = 0 AND cat.page_namespace = 14
JOIN enwiki_p.langlinks AS catlan ON catlan.ll_title = cl_to AND catlan.ll_lang = 'fa'

AND (
cl_to LIKE "Disestablishments_in_Antarctica_by_century"
OR cl_to LIKE "Railway_stations_in_Berkshire"
);

SQL

Checking query status...