Untitled query #82293

Fork of Most interwikis with no interwiki to hr by GregorB

This query is marked as a draft This query has been published by Bjarki S.

SQL

use dewiki;

select concat("# [[:de:", pa.page_title, "|", pa.page_title, "]]") as wl, count(*) as n
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 
group by ll_from
having count(*) >= 100
)
group by pa.page_id, pa.page_title
having count(case when ll.ll_lang = "is" then 1 end) = 0
order by n desc
limit 100;

SQL

Checking query status...