SELECT
sta.head_content_it AS head_content_,
sta.body_content_it AS body_content_,
sta.form_it AS form_,
sta.js_jq_it AS js_jq_,
sta.breadcrumbs,
(SELECT COALESCE(GROUP_CONCAT(IF(COALESCE(trad_varchar,'')='',
CONCAT_WS('==>>',field_ref, COALESCE(trad_text,'')),
CONCAT_WS('==>>',field_ref, COALESCE(trad_varchar,''))) SEPARATOR ':===:'), '') AS trads
FROM ana_traduzioni
WHERE (table_ref='1vol_statics' AND iso_lang='it' AND id_value=sta.id_sta AND (field_ref='head_content_en' OR field_ref='body_content_en' OR field_ref='form_en' OR field_ref='js_jq_en' )))
AS trads
FROM 1vol_statics sta
WHERE visible AND (iso_country_avail='' OR FIND_IN_SET('it', iso_country_avail) > 0) AND id_sta=16