prod.php - L-48   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 done=1) GROUP BY prod_id) t2 ON (t1.id=t2.prod_id)
            LEFT JOIN (S' at line 20  SQL:SELECT id, CONCAT(code, '-', name) as name , LOWER(name) as name2, unit_name, cat_id, grp_id, '' as code,
                (SELECT name FROM dic_cat WHERE id=cat_id) as cat_name,
                (SELECT name FROM dic_grp WHERE id=grp_id) as grp_name,
                ROUND(IFNULL(t2.ost,0),2) as ost,
                ROUND(IFNULL(t22.ost,0),2) as ost2,
                IFNULL(IF(price_in_usd=0, round(price / IF(IFNULL(t1.cur_rate_index,0)=0, t3.rate, t3.rate_max),1), price),0) as price,
                IFNULL(IF(price_in_usd=0, round(price2 / IF(IFNULL(t1.cur_rate_index,0)=0, t3.rate, t3.rate_max),1), price2),0) as price2,
                IFNULL(IF(price_in_usd=0, round(price3 / IF(IFNULL(t1.cur_rate_index,0)=0, t3.rate, t3.rate_max),1)   , price3),0) as price3,
                IFNULL(IF(price_in_usd=0, round(price4 / IF(IFNULL(t1.cur_rate_index,0)=0, t3.rate, t3.rate_max),1), price4),0) as price4,
                0 as in_price,
                0.0 as price5,
                0.0 as price6,
                IFNULL((SELECT discount_type FROM dic_settings),0) as discount_type,
                IFNULL(not_discount,0) as not_discount,
                IFNULL(coeff,1) as coeff,
                IFNULL(inc_search,'') as inc_search,
                IFNULL(tsoni.soni,0) as har_soni
            FROM dic_prod t1 
            LEFT JOIN (SELECT prod_id, COUNT(*) as soni FROM doc_ord_list WHERE curdate>=DATE_SUB(CURDATE(), INTERVAL 30 DAY) GROUP BY prod_id) tsoni ON (t1.id=tsoni.prod_id)
            LEFT JOIN (SELECT prod_id, SUM(qty) as ost FROM trs_wh WHERE wh_id=1 OR wh_id IN (SELECT wh_id FROM dic_user_wh WHERE user_id= AND done=1) GROUP BY prod_id) t2 ON (t1.id=t2.prod_id)
            LEFT JOIN (SELECT prod_id, SUM(qty) as ost FROM trs_wh WHERE wh_id=1 GROUP BY prod_id) t22 ON (t1.id=t22.prod_id)
            LEFT JOIN (SELECT prod_id, is_currency, sebprice FROM (SELECT * FROM trs_wh WHERE type_id=1 ORDER BY prod_id, curdate DESC, id DESC) t1
                        GROUP BY prod_id) tin ON (t1.id=tin.prod_id)

            ,
            (SELECT rate, rate_max FROM doc_rate ORDER BY curdate DESC LIMIT 1) t3            
            WHERE grp_id IN (SELECT grp_id FROM dic_user_grp WHERE user_id= AND done=1)
            ORDER BY cat_name, grp_name, name;