16

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