mysql:research@dbstore1005.eqiad.wmnet [wikidatawiki]> SELECT DISTINCT wbpt_property_id FROM wbt_property_terms LEFT JOIN wbt_term_in_lang ON wbpt_term_in_lang_id = wbtl_id LEFT JOIN wbt_type ON wbtl_ty pe_id = wby_id LEFT JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id LEFT JOIN wbt_text ON wbxl_text_id = wbx_id WHERE wby_name = 'label' AND wbx_text IS NULL ORDER BY wbpt_property_id;
+------------------+
| wbpt_property_id |
+------------------+
|               39 |
|               84 |
|               86 |
|              163 |
|              175 |
|              225 |
|              287 |
|              361 |
|              433 |
|              503 |
|              512 |
|              585 |
|              634 |
|              642 |
|              812 |
|              892 |
|              951 |
|             1056 |
|             1594 |
|             1705 |
|             1885 |
|             1951 |
|             2176 |
|             2358 |
|             2359 |
|             2561 |
|             2579 |
|             2634 |
|             2827 |
|             3113 |
|             4155 |
|             4329 |
|             4552 |
|             4970 |
+------------------+
34 rows in set (0.69 sec)