SELECT a.book_id, a.seller_id, b.book_image1, b.book_mrp, a.book_selling_price, a.is_enble, a.is_instock, b.is_forthcoming, b.book_name, b.publishing_house, b.author_id, b.book_language FROM publishers_database b INNER JOIN
books a
ON a.book_isbn = b.book_isbn WHERE a.is_enble = 1 and a.book_isbn != ''
and b.category_id in (11, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 152, 999) GROUP BY b.book_isbn order by a.is_instock DESC, b.is_forthcoming desc, b.is_newrelease desc, b.is_bestseller desc, a.book_id DESC limit 0, 20
₹239
21% off
₹559
21% off
₹319
21% off
₹319
21% off
₹239
21% off
₹399
21% off
₹479
21% off
₹479
21% off
Special Price ₹599
₹455
25% off
₹239
21% off
OFFERS
₹245
30% off
₹210
30% off
₹280
30% off
₹140
30% off
₹280
30% off
₹115
29% off
₹303
25% off
OFFERS
29% off
