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 = 'fr'

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 "group of stereoisomers with the chemical formula C%" 

#WHERE wbx_text LIKE "scholarly article in %" AND wbx_text LIKE "%, 1___"

#    WHERE wbx_text LIKE "Village Development Committee in %" AND wbx_text LIKE "% in Nepal"

# townland in ..., County Cork, Ireland

#WHERE wbx_text LIKE "village in %" AND wbx_text LIKE "%, Cherkasy Oblast, Ukraine" #, Ivano-Frankivsk

#WHERE wbx_text LIKE "____ documentary film"

#WHERE wbx_text LIKE "cultural property in %" AND wbx_text LIKE "%, Spain"

#WHERE wbx_text LIKE "____ - ____"

#WHERE wbx_text LIKE "____ - ____"

#WHERE wbx_text LIKE "scientific article published in 1___" 

WHERE wbx_text LIKE "article scientifique publié en 1___"

#WHERE wbx_text LIKE "____ American film"

#WHERE wbx_text LIKE "Schiff, Baujahr ____" 

#WHERE wbx_text LIKE "US patent %"

  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;