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 'AND shop_id = WHERE AZ_PR_GR=0 and REITING=1 AND a.AZ_FLCO' at line 1
Çàïðîñ aka StrQuery: SELECT dd.*, IFNULL(dd.nacenka,p.percent) AS nac, AZ_FLCOLOR AS fl, FALSE AS user_id, NULL AS hidden, CASE WHEN IFNULL(MCMarkupPercent,0) = 0 THEN AZ_ZO WHEN IFNULL(MCMarkupPercent,0) > 0 THEN AZ_ZO+AZ_ZO/100*IFNULL(MCMarkupPercent,0) END AS cost FROM ( SELECT *, CASE WHEN brendID > 0 AND groupID = GR_KOD THEN 4 WHEN brendID = 0 AND groupID = GR_KOD THEN 3 WHEN brendID > 0 AND groupID = GR1_KOD THEN 2 WHEN brendID = 0 AND groupID = GR1_KOD THEN 1 ELSE 0 END AS reit, MAX(brendID) FROM ATOV a LEFT JOIN nacenka n ON GR_KOD = n.groupID and n.user_id = AND shop_id = WHERE AZ_PR_GR=0 and REITING=1 AND a.AZ_FLCOLOR = 1 GROUP BY a.AZ_KOD,reit UNION SELECT *, CASE WHEN brendID > 0 AND groupID = GR_KOD THEN 4 WHEN brendID = 0 AND groupID = GR_KOD THEN 3 WHEN brendID > 0 AND groupID = GR1_KOD THEN 2 WHEN brendID = 0 AND groupID = GR1_KOD THEN 1 ELSE 0 END AS reit, MAX(brendID) FROM ATOV a LEFT JOIN nacenka n ON GR1_KOD = n.groupID and n.user_id = AND shop_id = WHERE AZ_PR_GR=0 and REITING=1 AND a.AZ_FLCOLOR = 1 GROUP BY a.AZ_KOD,reit ) dd LEFT JOIN MarginFullByClient on MCPartnerId = 0 LEFT JOIN pokupateli p ON p.lc = AND p.id = inner JOIN ( SELECT MAX(maxreit) AS maxreit, bb.AZ_KOD FROM ( SELECT AZ_KOD, AZ_NAME, CASE WHEN brendID > 0 AND groupID = GR_KOD THEN 4 WHEN brendID = 0 AND groupID = GR_KOD THEN 3 WHEN brendID > 0 AND groupID = GR1_KOD THEN 2 WHEN brendID = 0 AND groupID = GR1_KOD THEN 1 ELSE 0 END AS maxreit, groupID, MAX(brendID), nacenka FROM ATOV a LEFT JOIN nacenka n ON GR_KOD = n.groupID and n.user_id = AND shop_id = WHERE AZ_PR_GR=0 and REITING=1 AND a.AZ_FLCOLOR = 1 GROUP BY a.AZ_KOD,maxreit UNION SELECT AZ_KOD, AZ_NAME, CASE WHEN brendID > 0 AND groupID = GR_KOD THEN 4 WHEN brendID = 0 AND groupID = GR_KOD THEN 3 WHEN brendID > 0 AND groupID = GR1_KOD THEN 2 WHEN brendID = 0 AND groupID = GR1_KOD THEN 1 ELSE 0 END AS maxreit, groupID, MAX(brendID), nacenka FROM ATOV a LEFT JOIN nacenka n ON GR1_KOD = n.groupID and n.user_id = AND shop_id = WHERE AZ_PR_GR=0 and REITING=1 AND a.AZ_FLCOLOR = 1 GROUP BY a.AZ_KOD,maxreit ) bb GROUP BY bb.AZ_KOD ) mr ON dd.AZ_KOD = mr.AZ_KOD AND dd.reit = maxreit ORDER BY SORTREIT,AZ_NAME,AZ_SORT asc LIMIT 30,15 ;