blank - Quarry

use lvwiki_p;
select tl_namespace, tl_title, COUNT(*)
from templatelinks
left join page on page_namespace = tl_namespace and page_title = tl_title
where page_title IS NULL and tl_from_namespace=0
GROUP BY tl_namespace, tl_title
order by COUNT(*) desc

select p.page_title, cla.cl_to
from page p
join categorylinks cla on cla.cl_from=p.page_id and cla.cl_type="page"
where p.page_namespace=0 and p.page_is_redirect=0
		and p.page_id in (select p2.page_id from pagelinks pl
						join page p2 on p2.page_title=pl.pl_title and pl.pl_namespace=p2.page_namespace
						where pl.pl_from=37800389 and pl.pl_namespace=0) and cla.cl_to like "%births"
                        limit 50000;
                        
      

use lvwiki_p;
select CONCAT("Diskusija:",page_title) from page where page_is_redirect=1 and page_namespace=1
limit 100
SQL

Checking query status...
