Most used Wikidata properties without label in Latvian

SELECT pl_title, count(*)
FROM pagelinks
WHERE pl_from_namespace=0 and pl_namespace=120
and pl_title in ---
GROUP BY pl_title
ORDER BY count(*) DESC;


use wikidatawiki_p;
select term_entity_id
from wb_terms where# ips_item_id = term_entity_id and 
 term_type = "label" and term_language='lv'
 and term_entity_type<>'item'
 limit 100;

use wikidatawiki_p;
SELECT pl_title, pl_title, count(*)
FROM pagelinks
WHERE pl_from_namespace=0 and pl_namespace=120
and  not exists (select *
from wb_terms where concat('P',term_entity_id)=pl_title and
 term_type = "label" and term_language='lv'
 and term_entity_type="property")
GROUP BY pl_title
ORDER BY count(*) DESC
limit 1000;


use wikidatawiki_p;
SELECT pl_title, pl_title, count(*)
FROM pagelinks
WHERE pl_from_namespace=0 and pl_namespace=120
and pl_title not in (select concat('P',term_entity_id)
from wb_terms where term_language='lv' and term_type = "label"
 and term_entity_type="property")
GROUP BY pl_title
ORDER BY count(*) DESC
limit 10000;

SQL

use wikidatawiki_p;
SELECT pl_title, count(*)
FROM pagelinks
WHERE pl_from_namespace=0 and pl_namespace=120
and pl_title not in (select concat('P',term_entity_id)
from wb_terms where term_language='lv' and term_type = "label"
 and term_entity_type="property")
GROUP BY pl_title
ORDER BY count(*) DESC
limit 10000;

SQL

Checking query status...