MYSQL ERROR: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'THEN 1 ELSE 0 end) AS flRa FROM RetailAssortment GROUP BY RAProductCode) AS RA O' at line 1

Запрос aka StrQuery:   SELECT   AZ_KOD,  AZ_NAME,  AZ_SORT,  AZ_PR_GR,  AZ_BREN,  XA_XA,  AZ_ZO,  REITING,  OBVEM,  id_brend,  f_press,  hidden,  user_id,  groupID,  groupPID,  id,  fl,  IFNULL(PmProductValue,1) AS PmProductValue,  PImgPath,  who_goods FROM  ( SELECT    a1.AZ_KOD,  a1.AZ_NAME,  a1.AZ_SORT,  a1.AZ_PR_GR,  a1.AZ_BREN,  a1.XA_XA,  a1.AZ_ZO,  a1.REITING,  a1.OBVEM,  a1.id_brend,  a1.f_press,  NULL as hidden,  FALSE as user_id,  a1.GR_KOD as groupID,  a1.GR1_KOD as groupPID,  a1.AZ_KOD as id,  a1.AZ_FLCOLOR as fl,  a1.PImgPath,  1 as who_goods FROM ATOV a1 WHERE AZ_PR_GR = 0 AND (GR_KOD=1074370)  AND AZ_FLCOLOR < 4   UNION SELECT   a.AZ_KOD,  a.AZ_NAME,  a.AZ_SORT,  a.AZ_PR_GR,  a.AZ_BREN,  a.XA_XA,  a.AZ_ZO,  a.REITING,  a.OBVEM,  a.id_brend,  a.f_press,  hidden,  a.user_id,  a.GR_KOD as groupID,  a.GR1_KOD as groupPID,  a.AZ_KOD as id,  a.AZ_FLCOLOR as fl,  a.PImgPath,  0 FROM ATOV2 a , products_to_shop p WHERE a.user_id = ''   AND AZ_FLCOLOR < 4  AND (a.GR_KOD=1074370)    ) dd   LEFT JOIN MultiplicityProducts ON dd.AZ_KOD = PmProductCode   LEFT JOIN (SELECT RAProductCode, MAX(CASE WHEN RAClientCode =  THEN 1 ELSE 0 end) AS flRa FROM RetailAssortment GROUP BY RAProductCode) AS RA ON dd.AZ_KOD=RA.RAProductCode WHERE IFNULL(RA.flRa,1)=1  ORDER BY AZ_NAME  LIMIT 0,0 ;