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 '-0, MAX_DISPLAY_NEW_PRODUCT' at line 14
SELECT DISTINCT * FROM
products p,
products_description pd,
products_to_categories p2c,
categories c,
products_details ps
where c.categories_status='1'
and p.products_id = p2c.products_id and p.products_id=pd.products_id and p.products_id = ps.products_id
and ps.details_name = 'type'
and ps.value_id = '3-12'
and p2c.categories_id = c.categories_id
and c.parent_id = '602'
and p.products_status = '1' and pd.language_id = '2'
GROUP BY p.products_id ORDER BY p.art DESC LIMIT -0, MAX_DISPLAY_NEW_PRODUCT
[XT SQL Error]