Untitled query #1276

SQL

# For given names, set missing labels in language "nb" based on label in "en" (if available)
#
# See also https://upload.wikimedia.org/wikipedia/commons/f/f7/MediaWiki_1.24.1_database_schema.svg
#
use wikidatawiki_p; 

SELECT 
	
#	output for 	Quickstatement tool
	CONCAT('Q', term_entity_id) AS item, 
	"Abe", 		# "Lnb" sets the label for the language with language code "nb" (change here and below)
	CONCAT('"', term_text, '"') As NewLabel

from wb_terms 
WHERE term_entity_type = 'item' # 'item' not 'property'
and term_type = 'label'         # 'label', 'description', 'alias'
and term_language in ('en') 
and term_entity_id IN 
	( 
	SELECT epp_entity_id AS itemID
	#
	FROM pagelinks, page, wb_entity_per_page
	#
	LEFT JOIN  	( SELECT term_entity_id FROM wb_terms
				WHERE term_entity_type = 'item'  # 'item' not 'property'
				AND term_type = 'alias'        # 'label', 'description', 'alias'
				AND term_language in ('be')    # set language with missing labels here (sample with language code "nb"
                ) AS wbt       
	ON epp_entity_id = wbt.term_entity_id 
	WHERE wbt.term_entity_id IS NULL

	AND pl_from = 21293912  # id of page [[d:User:Jura1/first names/items (P31: ok, label: tbd)]]
	AND pl_namespace = 0
	AND pl_title = page_title
	AND page_id = epp_page_id
	)
GROUP BY term_text, term_entity_id
SQL

Checking query status...
