立陶宛專題待撰條目（B級以上）

SQL

use enwiki_p;
select REPLACE(l.ll_title, '_', ' '), REPLACE(p.page_title, '_', ' '), page_len
from langlinks l
join page p on p.page_id=l.ll_from
where p.page_namespace=0 and page_len<200000 and page_len>800 and p.page_title in (select pla.page_title
       from categorylinks cla
       join page pla on cla.cl_from=pla.page_id
       where pla.page_namespace=1 and cla.cl_type="page" and
            (          
               (cla.cl_to="Top-importance Lithuania articles" or cla.cl_to="High-importance Lithuania articles"
               or cla.cl_to="Mid-importance Lithuania articles") 
              and
               (cla.cl_to="FA-Class Lithuania articles" or cla.cl_to="GA-Class Lithuania articles" or
               cla.cl_to="A-Class Lithuania articles" or cla.cl_to="B-Class Lithuania articles" or
               cla.cl_to="FL-Class Lithuania articles")
           )       
) 
and l.ll_from in (select m.ll_from from langlinks m where m.ll_lang="zh")
and l.ll_lang="zh"
group by l.ll_from
SQL

Checking query status...
