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 '-10, 10' at line 14
SELECT DISTINCT * FROM
products p,
products_description pd,
products_to_categories p2c,
products_details ps
WHERE
p.products_id = p2c.products_id
and p.products_id=pd.products_id
and p.products_id = ps.products_id
and ps.details_name = 'thema'
and ps.value_id = '46'
and (p2c.categories_id = 472 OR p2c.categories_id = 511 OR p2c.categories_id = 551)
and p.products_status = '1' and pd.language_id = '2'
GROUP BY p.products_id ORDER BY p.art DESC LIMIT -10, 10
[XT SQL Error]