string(618) "SELECT p.products_id, p.products_image, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_quantity, pd.products_name, pd.products_description, pd.book_author, pd.book_binding, pd.book_publication_date, pd.book_alternate_versions, pd.book_isbn_10 FROM products_description pd LEFT JOIN products p ON pd.products_id = p.products_id LEFT JOIN products_to_categories p2c ON pd.products_id = p2c.products_id WHERE p.products_status = 1 AND p.products_quantity > 0 AND pd.book_ranking != 0 AND p2c.categories_id = 143 AND pd.language_id = '1' order by pd.book_ranking asc"