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

use lvwiki_p;
SELECT p.page_title#concat('* [[Veidne:',p.page_title,']]')
from page p
where p.page_id not in (SELECT  eu_page_id
					from wbc_entity_usage wb
					GROUP BY eu_page_id)
and p.page_title not like "%/%"
and p.page_namespace=0 and p.page_is_redirect=0# and p.page_id not in (select cl_from
												#				from categorylinks
												#				where cl_to="Nozīmju_atdalīšana")
and p.page_id not in (select ll_from from langlinks ll )
order by p.page_title asc
#limit 800;
/*
use lvwiki_p;
SELECT
  *
FROM pagelinks pl
join page p ON pl.pl_title = p.page_title
join wbc_entity_usage wb on p.page_id = wb.eu_page_id
#JOIN pagelinks pl ON pl.pl_from = p.page_id
WHERE  pl.pl_namespace = 0 AND p.page_namespace=0 and
pl.pl_from = 290249
GROUP BY eu_page_id
limit 10;
*/

SQL

Checking query status...