Untitled query #43474

SQL

## Get property ids of properties with a label or alias starting with 'hell' across languages
USE wikidatawiki_p; 

SELECT DISTINCT ( CONCAT( 'P', wbpt_property_id ) ) as term_full_entity_id
FROM wbt_property_terms
    INNER JOIN wbt_term_in_lang ON wbpt_term_in_lang_id = wbtl_id
    INNER JOIN wbt_type         ON wbtl_type_id = wby_id
    INNER JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id
    INNER JOIN wbt_text         ON wbxl_text_id = wbx_id
WHERE
    wby_name       IN ( 'label', 'alias' )
    AND wbx_text LIKE 'فيلم%'
;
SQL

Checking query status...
