# For given names, set missing labels in language "el" 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, 

    "Lnb",      # "Lnb" sets the label for the language with language code "nb" (change here and below)

    CONCAT('"', term_text, '"') As NewLabel,

​

    CURRENT_DATE

​

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 = 'label'        # 'label', 'description', 'alias'

                AND term_language in ('el')    # 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