Wikidata - given names - en descriptions non std

SQL

# Non standard descriptions in given name items
use wikidatawiki_p; 

SELECT 
pl_title as Qid, 
UPPERCASE(Left(term_type, 1)) As asdf,
CONCAT('D',term_language) As Lang, 
/*
CONCAT('"', 
       REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(term_text
        , 'Given ', 'given ')
        , 'First ', 'given ')
  		, 'first ', 'given ')
		, 'Feminine ', 'female ')
		, 'feminine ', 'female ')
		, 'masculine ', 'male '),
       '"') As desc2_possible_replacement,
# */
CONCAT('"', term_text, '"') As desc1_original_long_header_to_stretch_colum_wide_123_456_78901,
CONCAT('','') As Asdf1,
CONCAT('"', term_text, '"') As current_desc,
# CONCAT('<tr><td>{{Q|', pl_title, '}}<td> ', pl_title, '<td>', term_text) AS simplelist_for_copy_and_paste
CURRENT_DATE As date

FROM pagelinks, page, wb_entity_per_page, wb_terms

WHERE pl_from = 21293912
AND pl_namespace = 0
AND pl_title = page_title
AND page_id = epp_page_id
AND epp_entity_id = term_entity_id
AND term_entity_type = 'item'  		# 'item' not 'property'
AND term_type = 'description'       # 'label', 'description', 'alias'
#AND term_language = 'en' AND term_text not in ('male given name', 'female given name', 'given name', 'unisex given name')
#AND term_language = 'it' AND term_text not in ('prenome maschile', 'prenome femminile', 'prenome')
AND term_language = 'nn' AND term_text = 'Mannsnamn'
#AND term_language = 'ca' AND term_text not in ('prenom masculí', 'prenom femení', 'prenom')

GROUP BY term_text, pl_title
SQL

Checking query status...
