Untitled query #51555

SQL

use enwiki_p;
select count(pa.page_title)
-- select concat("# [[:en:", pa.page_title, "|", pa.page_title, "]]") as wl
from page pa
inner join langlinks ll on ll.ll_from = pa.page_id
where pa.page_namespace = 0 /* and
pa.page_title in 
(
select pt.page_title
from page pt
inner join categorylinks cl on cl.cl_from = pt.page_id
where pt.page_namespace = 1 and cl.cl_to = "WikiProject_Croatia_articles"
) */ and
pa.page_id in 
(
select ll_from
from langlinks 
  where ll.ll_lang in ("ta" and "bn")
)
-- order by pa.page_title
-- limit 100;
SQL

Checking query status...
