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

SQL

SELECT distinct catarlan.ll_title, catar.page_namespace, cl_to
FROM enwiki_p.langlinks AS catarlan
JOIN enwiki_p.page AS catar ON ll_from = page_id 
JOIN enwiki_p.categorylinks ON page_id = cl_from
JOIN enwiki_p.page AS cat ON cat.page_title = cl_to
JOIN enwiki_p.langlinks AS catlan ON cat.page_title = cl_to

WHERE (
  catar.page_namespace = 14
  OR catar.page_namespace = 0
)
AND catar.page_is_redirect = 0
AND V.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...