( ! ) Fatal error: Uncaught exception 'Exception' with message '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 ' in /home/pancer/sites/pancer.com.ua/system/library/db/mysqli.php on line 40
( ! ) Exception: 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.product_id ORDER BY total DESC ' at line 12<br />Error No: 1064<br /> SELECT COUNT(total) as total FROM ( SELECT COUNT(DISTINCT op.product_id) AS total FROM oc_order_product op LEFT JOIN `oc_order` o ON (op.order_id = o.order_id) LEFT JOIN `oc_product` p ON (op.product_id = p.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE o.order_status_id > '0' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND (p.date_added >= NOW() - INTERVAL MONTH AND p.date_added <= NOW()) GROUP BY op.product_id ORDER BY total DESC ) bp in /home/pancer/sites/pancer.com.ua/system/library/db/mysqli.php on line 40
Call Stack
#	Time	Memory	Function	Location
1	0.0001	236416	{main}( )	.../index.php:0
2	0.0012	268368	start( )	.../index.php:24
3	0.0012	270168	require_once( '/home/pancer/sites/pancer.com.ua/system/framework.php' )	.../startup.php:105
4	0.0143	1274464	Front->dispatch( )	.../framework.php:105
5	0.1416	14528880	Front->execute( )	.../front.php:29
6	0.1416	14528880	Action->execute( )	.../front.php:34
7	0.1554	14583032	call_user_func_array:{/home/pancer/sites/pancer.com.ua/system/storage/modification/system/engine/action.php:51} ( )	.../action.php:51
8	0.1554	14583664	ControllerProductBestseller->index( )	.../action.php:51
9	0.1557	14585184	getTotalBestSellers ( )	.../bestseller.php:17
10	0.1557	14585624	Proxy->__call( )	.../bestseller.php:17
11	0.1557	14586848	call_user_func_array:{/home/pancer/sites/pancer.com.ua/system/engine/proxy.php:25} ( )	.../proxy.php:25
12	0.1557	14588208	Loader->{closure:/home/pancer/sites/pancer.com.ua/system/storage/modification/system/engine/loader.php:147-191}( )	.../proxy.php:25
13	0.1566	14590288	call_user_func_array:{/home/pancer/sites/pancer.com.ua/system/storage/modification/system/engine/loader.php:178} ( )	.../loader.php:178
14	0.1566	14590968	ModelModuleAdditionalPages->getTotalBestSellers( )	.../loader.php:178
15	0.1582	14593728	DB->query( )	.../additional_pages.php:232
16	0.1582	14593864	DB\MySQLi->query( )	.../db.php:16