Untitled query #51554

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 = "ta"
  and ll.ll_lang = "bn"
  and ll.ll_lang <> "te"
  and ll.ll_lang = "kn"
  and ll.ll_lang = "ml"
  and ll.ll_lang = "mr"
  and ll.ll_lang = "hi"
  and ll.ll_lang = "as"
  and ll.ll_lang = "pa"
)

-- order by pa.page_title
-- limit 100;
SQL

Checking query status...
