 | Nekome - nekokiss - noir - taille s -soldes |
| 10.00€ |
 | Hero - film simple |
| 6.00€ |
 | Guns and talks |
| 8.99€ |
Warning: implode(): Invalid arguments passed in /data/vhosts/discountmanga.fr/httpdocs/tpl/zemanga/customsfiles/cat_bestsellers.php on line 19
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 ')
GROUP BY op.products_id
ORDER BY total DESC
' at line 23
SELECT op.products_id,
sum(op.products_quantity) as total,
p.products_cust_vol,
pd.products_sous_titre,
pd.products_name,
p.products_image,
p.products_price_zemanga,
p.products_tax_class_id,
p.products_club_zemanga,
p.products_price_club_zemanga,
p.products_cust_aut
FROM products p
LEFT JOIN products_description pd ON (p.products_id = pd.products_id)
LEFT JOIN products_to_categories p2c ON (pd.products_id = p2c.products_id)
LEFT JOIN orders_products op ON (p2c.products_id = op.products_id)
LEFT JOIN orders o ON (op.orders_id = o.orders_id)
WHERE p.products_status = 1
AND p.products_cust_isserie = 0
AND ((p.products_quantity > 0 and p.products_outstock != 0) OR p.products_outstock=0)
AND pd.language_id = '4'
AND o.date_purchased > date_sub(now() , interval 7 day)
AND p.products_id NOT IN (SELECT og_products_id FROM order_gift WHERE og_status=1)
AND p2c.categories_id IN()
GROUP BY op.products_id
ORDER BY total DESC
LIMIT 0,10
[TEP STOP]