Wikidata items with Latvian labels and without English labels

Fork of Wikidata items with Turkish labels and without English labels by Bulgu

This query is marked as a draft This query has been published by Edgars2007.

SQL

use wikidatawiki_p; 
select now();

select  concat("www.wikidata.org/wiki/Q", ww.term_entity_id) as url, ww.term_text, max(ww.term_weight), count(*)
from 	wb_terms ww
WHERE 	ww.term_entity_type = 'item' 
		AND ww.term_type = 'label'    # 'label', 'description', 'alias'
		AND ww.term_language = 'lv' 
        AND not exists (select ww2.term_entity_id from wb_terms ww2 where ww2.term_entity_id = ww.term_entity_id and ww2.term_language = 'en')
        #AND exists (select ww3.term_entity_id from wb_terms ww3 where ww3.term_entity_id = ww.term_entity_id and ww3.term_language = 'de')
group by ww.term_entity_id
order by ww.term_weight desc

LIMIT 500;

SQL

Checking query status...