wd pagelinks - Quarry

pl_from = page_id


use wikidatawiki_p; 
select CONCAT("Q",ips_item_id), CONCAT("Llv"), CONCAT('"',ips_site_page,'"')
from wb_items_per_site i
#join wb_terms on ips_item_id = term_entity_id and term_type = "label"
where i.ips_site_id='lvwiki' and i.ips_item_id not in
(select term_entity_id from wb_terms where# ips_item_id = term_entity_id and 
 term_type = "label" and term_language='lv')
group by ips_item_id
limit 1000;
----------------------------------------------------
USE wikidatawiki_p;
SELECT *
FROM pagelinks
WHERE #pl_namespace = 0 AND
pl_from=23133519
limit 15;
--------------------------------
use wikidatawiki_p; 
select *#CONCAT("Q",ips_item_id), CONCAT("Llv"), CONCAT('"',ips_site_page,'"')
from wb_items_per_site i
join pagelinks on pl_from=23133519 and 
#join wb_terms on ips_item_id = term_entity_id and term_type = "label"
where i.ips_site_id='lvwiki'
group by ips_item_id
limit 19;
------------------------------------------
use wikidatawiki_p; 
select *#CONCAT("Q",ips_item_id), CONCAT("Llv"), CONCAT('"',ips_site_page,'"')
from pagelinks
left join wb_items_per_site i on pl_from=23133519 and pl_title=ips_item_id
#join wb_terms on ips_item_id = term_entity_id and term_type = "label"
where i.ips_site_id='lvwiki'
group by ips_item_id
limit 19;

SQL

use wikidatawiki_p; 
select *#CONCAT("Q",ips_item_id), CONCAT("Llv"), CONCAT('"',ips_site_page,'"')
from wb_items_per_site i
#join wb_terms on ips_item_id = term_entity_id and term_type = "label"
where i.ips_item_id in (20558232, 1954332)
      and not exists (select 1 from wb_items_per_site i2 where i.ips_row_id=i2.ips_row_id and i2.ips_site_id='lvwiki')


#i.ips_site_id='lvwiki'
#group by i.ips_item_id
limit 19;/*


20558232 - alslēbens
1954332 - ārents


select count(*) AS count, p.page_title
                      from page p, langlinks l1 ".$catfrom." ".$tplfrom."
                      where ".$catwhere." ".$tplwhere."
                      and p.page_id = l1.ll_from
                      and not exists (select 1 from wb_items_per_site i2 where i.ips_row_id=i2.ips_row_id and i2.ips_site_id='lvwiki')
                      group by p.page_id, p.page_title
                      order by count(*) desc, p.page_title 
                      limit 0,500
                      */

SQL

Checking query status...