970601 mp1 # of DAB pages

SQL

USE enwiki_p;
SELECT  catarlan.ll_title a, catar.page_namespace b, concat('OR page_title LIKE "',cl_to,'"') c, catlan.ll_title d
FROM langlinks AS catarlan
JOIN 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 categorylinks ON page_id = cl_from
JOIN page AS cat ON cat.page_title = cl_to AND cat.page_is_redirect = 0 AND cat.page_namespace = 14
JOIN langlinks AS catlan ON catlan.ll_from = cat.page_id AND catlan.ll_lang = 'fa'

WHERE (cl_to LIKE "Philippine_psychological_horror_films"
#------------------------------------------------------
)
ORDER BY cl_to;
SQL

Checking query status...
