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 'ORDER BY SORTREIT,AZ_NAME,AZ_SORT asc LIMIT 30,15' at line 1
Çàïðîñ aka StrQuery: select dd.*, 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 *, NULL as hidden, FALSE as user_id, AZ_KOD as id, AZ_FLCOLOR as fl FROM ATOV WHERE AZ_PR_GR=0 and REITING=1 union SELECT a.*, a.AZ_KOD as id, a.AZ_FLCOLOR as fl FROM ATOV2 a WHERE REITING=1 and user_id='' ) dd LEFT JOIN MarginFullByClient on MCPartnerId = ORDER BY SORTREIT,AZ_NAME,AZ_SORT asc LIMIT 30,15;