Mo Yan

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 '' at line 13
in:
[select p.products_image, pd.products_name, p.products_quantity, pme.products_id, p.products_type, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status = 1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping from products p, products_description pd, product_book_extra pme left join specials s on pme.products_id = s.products_id, book_authors a, book_authors_info ad, books_to_authors bta where a.book_authors_id = '710' and ad.book_authors_id = '710' and ad.language_id = '1' and bta.book_authors_id = '710' and bta.products_id = p.products_id and pme.products_id = p.products_id and pme.products_id = pd.products_id and p.products_status = 1 and pd.language_id = '1' order by ]