(An Untitled Masterwork)
ActivePublic
Actions

Authored by Addshore on Dec 17 2019, 10:29 AM.

Tags

None

Referenced Files

	F31478812: raw.txt
	Dec 17 2019, 10:30 AM

	F31478807: raw.txt
	Dec 17 2019, 10:29 AM

Subscribers

None

	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)

Addshore edited the content of this paste. (Show Details)

	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)

(An Untitled Masterwork)ActivePublicActions