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, 0' at line 24
-- includes/modules/default listing_sql
SELECT
p.*,
pd.products_name, pd.products_short_description, pd.products_description
FROM
(SELECT
p.products_id, p.products_model, p.products_ean,
p.products_quantity, p.products_weight, p.products_image,
p.products_price,
s.specials_new_products_price,
if(s.specials_new_products_price < IFNULL(p2cs.personal_offer, p.products_price), s.specials_new_products_price, IFNULL(p2cs.personal_offer, p.products_price)) best_price,
p.products_vpe, p.products_vpe_status, p.products_vpe_value,
p.products_discount_allowed, p.products_tax_class_id,
p.products_fsk18, p.products_shippingtime, p.products_sort,
p.manufacturers_id, m.manufacturers_name,
p.products_date_added, s.specials_date_added
FROM products p
JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id AND m.manufacturers_id = 20
LEFT JOIN specials s ON p.products_id = s.products_id
LEFT JOIN products_to_customers_status p2cs ON p.products_id=p2cs.products_id AND p2cs.customers_status = 1
WHERE p.products_status = 1
) p
JOIN products_description pd on p.products_id = pd.products_id and pd.language_id = 2
ORDER BY pd.products_name ASC LIMIT -0, 0
[ECB SQL Error]