An Error Was Encountered
Error Number: 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 23
SELECT p.id, p.header_code as header_code, p.prodcode, p.prodname, p.name_en as name, p.price_listing_export as price, p.main_brand, b.name as full_name_brand, p.promo_export as promo, p.sale_export as sale, dl.value as discount_lynka FROM products p LEFT JOIN products_categories pc ON (p.prodcode = pc.prodcode) LEFT JOIN products_brands pb ON (p.prodcode = pb.prodcode) LEFT JOIN products_options po ON (p.prodcode = po.prodcode) LEFT JOIN products_discounts_lynka dl ON (po.id = dl.opt_id) LEFT JOIN brands b ON (p.main_brand = b.abbr) LEFT JOIN top_export ON (p.prodcode = top_export.prodcode) WHERE show_export = 1 AND category_id = 88 GROUP BY p.prodcode ORDER BY top_export.order ASC LIMIT -10, 10