SELECT t_kongre_attrs.*, t_dovizs.Sembol,
COALESCE((SELECT Ad FROM t_kongre_attr_lang WHERE LangAydi = '3' AND DataAydi = t_kongre_attrs.Aydi), t_kongre_attrs.Kod) AS dataAd,
(SELECT Baslik FROM t_kongre_attr_lang WHERE LangAydi = '3' AND DataAydi = t_kongre_attrs.Aydi) AS dataBaslik,
(SELECT Yazi FROM t_kongre_attr_lang WHERE LangAydi = '3' AND DataAydi = t_kongre_attrs.Aydi) AS dataYazi,
(SELECT Yazi2 FROM t_kongre_attr_lang WHERE LangAydi = '3' 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 = '11'
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