کد خطا : 0
توضیح : MySQL Query fail: SELECT DISTINCT products.id,products.title,FORMAT(products.price,0) AS price,FORMAT(products.price_naghdi/10,0) AS price,IFNULL(SUM(orders_list.qty),0) as total_sells FROM orders_list INNER JOIN orders ON orders.id = orders_list.order_id AND orders.date > CURDATE() - INTERVAL 30 DAY RIGHT JOIN products ON products.id = orders_list.product_id INNER JOIN products_cats ON products.id=products_cats.product_id AND products_cats.cat_id IN (163,145,146,78,117,80,114,116,115,81,82,157,83,79,111,113,120,130,135,131,134,133,84,159,85,86,87,112,150,151,152,138,139,71,72,73,74,76,105,107,108,103,102,101,20,30,22,23,25,26,27,29,39,109,40,41,42,43,44,45,58,59,60,63,68,69,67,66,110,70,48,57,55,) WHERE products.stock>0 AND products.status=1 AND products.stock>0 GROUP BY products.id ORDER BY total_sells DESC, id DESC LIMIT 0,5
Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') WHERE products.stock>0 AND products.status=1 AND products.stock>0 GROUP BY ...' at line 1

بازگشت