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 a.book_id in (2706, 3377, 3926, 3937, 4402, 4737, 6502, 6613, 7187, 8254, 8650, 8795, 12431, 13710, 14210, 14234, 15009, 15387, 20994, 21133, 24942, 25024, 25213, 26492, 26538, 28770, 29864, 30477, 30562, 31993, 32642, 32758, 33580, 33589, 35418, 40091, 40671, 44652, 45656, 47370, 47371, 47728, 57152, 58368, 60652, 60711, 65624, 67830, 71100, 86424, 87088, 90126, 113100, 135287, 583298, 583472, 584834, 585363, 585654, 586403, 586993, 587173,67830,40607) and b.category_id in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 999, 5000, 5001, 5002, 5003, 5004, 6000, 6001, 6002, 6003, 6004, 6005, 6006, 6007, 6008, 6009, 6010, 6011, 6012, 6013, 6014, 6015, 6016, 6017, 6018, 6019, 6020, 7000, 7001, 7002, 7003, 7004, 7005, 7006, 7007, 7008, 7009, 7010, 7011, 7012, 7013, 7014, 7015, 8000, 8001, 8002, 80) and b.book_language != '' and b.publishing_house != '' GROUP BY b.book_isbn order by STR_TO_DATE(a.publication_date, '%d-%m-%Y') DESC, a.book_id DESC limit 0, 20
₹416
16% off
₹584
16% off
₹175
13% off
₹349
31% off
Special Price ₹520
Special Price ₹1999
Special Price ₹300
Special Price ₹310
Special Price ₹90
Special Price ₹125
₹479
21% off
₹320
20% off
Special Price ₹699
Special Price ₹35
Special Price ₹35
Special Price ₹30
₹200
20% off
₹320
20% off
₹350
30% off
₹319
21% off