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

SQL

SELECT ll_title, page_namespace, cl_to
FROM enwiki_p.langlinks
JOIN enwiki_p.page AS catar ON ll_from = page_id RIGHT JOIN enwiki_p.categorylinks ON page_id = cl_from
JOIN enwiki_p.page AS cat ON page_title=cl_to#LEFT JOIN fawiki_p.categorylinks ON cl_from = page_id
WHERE (
  catarpage_namespace = 14
  OR catarpage_namespace = 0
)
AND catarpage_is_redirect = 0
AND ll_lang = 'fa'
#AND ll_lang = "en"
AND (
cl_to LIKE "Disestablishments_in_Antarctica_by_century"
OR cl_to LIKE "Railway_stations_in_Berkshire"
);

SQL

Checking query status...