A Database Error Occurred

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 'page LIMIT 24' at line 11

SELECT products.*, @pdbd:=IF(product_discount_begin_date>0, `product_discount_begin_date`, "0"), @pded:=IF(product_discount_end_date>0, `product_discount_end_date`, "4102437600"), @pd:=IF(@pdbd<=1714165200 && @pded>=1714165200, `product_discount`, "0") AS product_discount, @pds:=IF(@pdbd<=1714165200 && @pded>=1714165200, `product_status`, "") AS product_status, products_stocs.stoc_value, (SELECT count(*) FROM products_comments pc WHERE pc.product_id = products.product_id) as comment_number, (SELECT count(*) FROM products_questions pc WHERE pc.product_id = products.product_id) as questions_number, (select file_name from products_files pf where pf.product_id=products.product_id and pf.file_ext in ('jpg', 'JPG', 'jpeg', 'JPEG', 'gif', 'GIF', 'png', 'PNG') order by pf.file_order asc LIMIT 1) as file_name, products.product_price*(1+products.product_tva/100)*(categories.procent/100)*(currencies_archive.archive_value/1.0000) as pret_no_discount, products.product_price*(categories.procent/100)*(currencies_archive.archive_value/1.0000) as pret_no_discount_no_tva, products.product_price*(1+products.product_tva/100)*(categories.procent/100)*(1-@pd/100)*(currencies_archive.archive_value/1.0000) as pret, products.product_price*(categories.procent/100)*(1-@pd/100)*(currencies_archive.archive_value/1.0000) as pret_no_tva, products.product_taxa_verde*(currencies_archive.archive_value/1.0000) as taxa_verde, currencies_archive.archive_value/1.0000 as raport, products_details.*, categories_details.url_key as category_url_key, categories_details.category_title, categories.*, categories_details2.url_key as parent_url_key, categories_details2.category_id as parent_category_id, categories_details2.category_title as parent_category_title, categories_details.full_url_key as full_url_key, currencies.currency_code FROM (`products`) LEFT JOIN `products_details` ON products.product_id=products_details.product_id AND products_details.language_id = 1 LEFT JOIN `products_stocs` ON products.product_id=products_stocs.product_id LEFT JOIN `categories` ON products.category_id=categories.category_id LEFT JOIN `categories_details` ON categories.category_id=categories_details.category_id AND categories_details.language_id = 1 LEFT JOIN `currencies` ON products.currency_id=currencies.currency_id LEFT JOIN `categories_details` as categories_details2 ON categories.parent_id=categories_details2.category_id AND categories_details2.language_id = 1 LEFT JOIN `currencies_archive` ON (currencies_archive.currency_id=currencies.currency_id AND currencies_archive.archive_date="2016-11-11") WHERE products.active='1' AND products.category_id IN( 9) ORDER BY `pret` page LIMIT 24