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 = '22'
and (p2c.categories_id = 895 OR p2c.categories_id = 898 OR p2c.categories_id = 571 OR p2c.categories_id = 896 OR p2c.categories_id = 573 OR p2c.categories_id = 568)
and p.products_status = '1' and pd.language_id = '2'
GROUP BY p.products_id ORDER BY p.art DESC, p.products_image DESC LIMIT -10, 10
[XT SQL Error]