SELECT t_kongre_attrs.*, t_dovizs.Sembol, COALESCE((SELECT Ad FROM t_kongre_attr_lang WHERE LangAydi = '2' AND DataAydi = t_kongre_attrs.Aydi), t_kongre_attrs.Kod) AS dataAd, (SELECT Baslik FROM t_kongre_attr_lang WHERE LangAydi = '2' AND DataAydi = t_kongre_attrs.Aydi) AS dataBaslik, (SELECT Yazi FROM t_kongre_attr_lang WHERE LangAydi = '2' AND DataAydi = t_kongre_attrs.Aydi) AS dataYazi, (SELECT Yazi2 FROM t_kongre_attr_lang WHERE LangAydi = '2' AND DataAydi = t_kongre_attrs.Aydi) AS dataYazi2 FROM t_kongre_attrs INNER JOIN t_kongre_props ON t_kongre_props.Aydi = t_kongre_attrs.PropAydi INNER JOIN t_dovizs ON t_dovizs.Aydi = t_kongre_attrs.DovizAydi WHERE t_kongre_attrs.Aktifmi = 1 AND t_kongre_props.Aktifmi = 1 AND t_kongre_props.KongreAydi = '31' AND (t_kongre_attrs.VarUlkeTur = 0 OR t_kongre_attrs.VarUlkeTur = '') AND (t_kongre_attrs.YokUlkeTur = 0 OR t_kongre_attrs.YokUlkeTur != '') AND (t_kongre_attrs.VarIlTur = 0 OR t_kongre_attrs.VarIlTur = '') AND (t_kongre_attrs.YokIlTur = 0 OR t_kongre_attrs.YokIlTur != '') AND ( (t_kongre_attrs.JsonOzel IS NULL AND t_kongre_attrs.Ozel IS NULL) OR (t_kongre_attrs.JsonOzel IS NULL AND t_kongre_attrs.Ozel = '1') OR JSON_CONTAINS(t_kongre_attrs.JsonOzel, '"1"', '$') ) AND t_kongre_attrs.KuponTur2Aydi IS NULL ORDER BY t_kongre_props.Sira, t_kongre_props.Aydi, t_kongre_attrs.Sira, t_kongre_attrs.Aydi
15th Istanbul Apperal Conference

 

15th İstanbul Apparel Conference registration has been closed.
Thank you very much for your great interest.