SELECT distinct
concat(g4a, ' (',g4b, ')') as title,
'' as 'field_contact_name:title',
trim(substring_index(g4a,',',-1)) as 'field_contact_name:given',
substring_index(g4a,',',1) as 'field_contact_name:family',
'' as field_telephone,
g4c as 'field_contact_email:email', g4b as field_institution 
FROM genomos_general g 
where g4a is not null
