Untitled query #7224

SQL

use plwikisource_p;
select count(distinct tl_from) as with_scans 
from templatelinks left join page on page_id=tl_from 
where tl_namespace=100 and page_namespace=0;
select count(distinct page_id) as all_texts from page where page_namespace=0 and page_is_redirect=0;
select count(page_title) as disamb from page left join templatelinks on page_id=tl_from where page_namespace=0 and tl_namespace=10 and tl_title in ( select pl_title from page left join pagelinks on page_id=pl_from where pl_namespace=10 and page_namespace=8 and page_title='Disambiguationspage' )
SQL

Checking query status...
