Wikidata - given names - en descriptions non std

SQL

# Non standard descriptions in given name items
use wikidatawiki_p; 

SELECT 
pl_title as Qid, 
'Den', 
/*
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_7890, 
CONCAT('<tr><td>{{Q|', pl_title, '}}<td> ', pl_title, '<td>', term_text) AS simplelist_for_copy_and_paste

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')
#AND term_language = 'it' AND term_text not in ('prenome maschile', 'prenome femminile', 'prenome')
GROUP BY term_text, pl_title
SQL

Checking query status...
