SQL Error: 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 ') GROUP by op.grp_id ORDER by o.dt_insert DESC LIMIT 0,15' at line 11 at /var/www/opt/data/www/opt.auto-help.ru/adm/lib/php/cms_sql/class_order.php line 87
Array
(
    [code] => 1064
    [message] => 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 ')		
		GROUP by op.grp_id
		ORDER by o.dt_insert DESC LIMIT 0,15' at line 11
    [query] => 
		SELECT op.1c_id, op.grp_id, o.id as order_id, DATE_FORMAT(o.dt_insert,'%d.%m.%Y %H:%i') as dt, DATE_FORMAT(o.dt_delivery,'%d.%m') as dt_delivery, o.memo,
		(SELECT round(sum(orderproduct.price*orderproduct.cnt)/100,2) from cms_order_product orderproduct LEFT JOIN cms_order ord ON orderproduct.order_id = ord.id WHERE orderproduct.grp_id=op.grp_id and ord.user_id=NULL) as sum,
		IF (o.addr_id>0,(SELECT name from cms_user_addr WHERE id=o.addr_id),'самовывоз') as address,
		IF ((SELECT count(*) from cms_order_product orderproduct LEFT JOIN cms_order ord ON orderproduct.order_id = ord.id WHERE orderproduct.grp_id=op.grp_id and ord.user_id=NULL)=1,(SELECT product.article from cms_order_product orderproduct LEFT JOIN cms_order ord ON orderproduct.order_id = ord.id LEFT JOIN cms_product product ON orderproduct.product_id = product.id WHERE orderproduct.grp_id=op.grp_id and ord.user_id=NULL),(SELECT count(*) from cms_order_product orderproduct LEFT JOIN cms_order ord ON orderproduct.order_id = ord.id WHERE orderproduct.grp_id=op.grp_id and ord.user_id=NULL)) as article,
		(SELECT sum(orderproduct.cnt) from cms_order_product orderproduct LEFT JOIN cms_order ord ON orderproduct.order_id = ord.id WHERE orderproduct.grp_id=op.grp_id and ord.user_id=NULL) as article_cnt,
		IF ((SELECT count(*) from cms_order_product orderproduct LEFT JOIN cms_order ord ON orderproduct.order_id = ord.id WHERE orderproduct.grp_id=op.grp_id and ord.user_id=NULL)=1,(SELECT product.name from cms_order_product orderproduct LEFT JOIN cms_order ord ON orderproduct.order_id = ord.id LEFT JOIN cms_product product ON orderproduct.product_id = product.id WHERE orderproduct.grp_id=op.grp_id and ord.user_id=NULL),'') as product_name,
		(SELECT count(*) from cms_order_product orderproduct LEFT JOIN cms_order ord ON orderproduct.order_id = ord.id WHERE orderproduct.grp_id=op.grp_id and ord.user_id=NULL) as prod_cnt		
		FROM cms_order_product op 
		LEFT JOIN cms_order o ON op.order_id = o.id 
		LEFT JOIN cms_product prod ON op.product_id = prod.id 
		WHERE TRUE AND (o.user_id=)		
		GROUP by op.grp_id
		ORDER by o.dt_insert DESC LIMIT 0,15
		
    [context] => /var/www/opt/data/www/opt.auto-help.ru/adm/lib/php/cms_sql/class_order.php line 87
)