Wikidata items with Turkish labels and without English labels

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 = 'tr' 
        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 in ('de','es','it','sv')
                    )
group by ww.term_entity_id
order by ww.term_weight desc

LIMIT 500;

SQL

Checking query status...