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, 
	"Len", 		# "Lnb" sets the label for the language with language code "nb" (change here and below)
	CONCAT('"', term_text, '"') As NewLabel,
    GROUP_CONCAT (term_language) AS sourceLang

from wb_terms 
WHERE term_entity_type = 'item' # 'item' not 'property'
and term_type = 'label'         # 'label', 'description', 'alias'
AND term_language IN ('en','de','fr','it','es','af','an','ast','bar','br','ca','co','cs','cy','da',
                      'de-at','de-ch','en-ca','en-gb','eo','et','eu','fi','frp','fur','ga','gd','gl',
                      'gsw','hr','hu','ia','id','ie','is','io','kg','lb','li','lij','mg','min','ms',
                      'nap','nb','nds','nds-nl','nl','nn','nrm','oc','pcd','pl','pms','pt','pt-br',
                      'rm','ro','sc','scn','sco','sk','sl','sr-el','sv','sw','vec','vi','vls','vo','wa','wo','zu')
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 = 'label'        # 'label', 'description', 'alias'
				AND term_language in ('en')    # 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...
