wikidata: counts of all de descriptions without uk description

SQL

SELECT DISTINCT CONCAT('http://www.wikidata.org/entity/Q', wbt_item_terms.wbit_item_id) as Q_id
FROM wbt_item_terms
JOIN wbt_term_in_lang on wbt_item_terms.wbit_term_in_lang_id = wbt_term_in_lang.wbtl_id
                     AND wbtl_type_id = 2  # 1 label
JOIN wbt_text_in_lang on wbt_term_in_lang.wbtl_text_in_lang_id = wbt_text_in_lang.wbxl_id
                     AND wbxl_language = 'en'
JOIN wbt_text         ON wbt_text_in_lang.wbxl_text_id = wbt_text.wbx_id
#                     AND wbx_text = 'street in Cherkasy, Ukraine'
#WHERE wbx_text LIKE "college basketball player (%" 
#WHERE wbx_text LIKE "townland in %" AND wbx_text LIKE "%, County Carlow, Ireland"
# townland in ..., County Cork, Ireland
#WHERE wbx_text LIKE "village in %" AND wbx_text LIKE "%, Cherkasy Oblast, Ukraine" #, Ivano-Frankivsk
#WHERE wbx_text LIKE "English association football player (born ____)"
#WHERE wbx_text LIKE "hotel in %" AND wbx_text LIKE "%, India"
WHERE wbx_text LIKE "ship built in ____"
#WHERE wbx_text LIKE "scientific article published in 1___" 
#WHERE wbx_text LIKE "October ____" 
#WHERE wbx_text LIKE "painting by anonymous"
  AND wbit_item_id NOT IN (
  SELECT DISTINCT wbit_item_id
  FROM wbt_item_terms
  JOIN wbt_term_in_lang on wbt_item_terms.wbit_term_in_lang_id = wbt_term_in_lang.wbtl_id
                       AND wbtl_type_id = 2 
  JOIN wbt_text_in_lang on wbt_term_in_lang.wbtl_text_in_lang_id = wbt_text_in_lang.wbxl_id
  WHERE wbxl_language = 'uk'
)
LIMIT 1000000;
SQL

Checking query status...
