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 (15000, 35413, 40843, 63113, 68905, 68913, 72385, 75027, 86345, 86422, 86531, 86587, 86589, 86895, 86931, 87112, 87388, 88154, 135355, 135390, 135396, 135417, 135436, 135467, 135603, 135642, 135651, 135678, 135682, 135683, 136565, 136569, 136579, 136580, 136582, 136583, 136647, 136648, 136654, 136659, 136671, 136672, 137116, 137168, 137169, 137172, 137175, 137207, 137208, 137210, 137212, 137213, 137216, 137225, 137226) 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 FIELD(a.book_id ,135467,135603,136582,136580,136583,137116,136671,136672,137212,137213,137225,137226,86931,135651,135436,137216,86531,86895,136565,137208) DESC, a.book_id DESC limit 0, 20
₹400
20% off
₹360
20% off
₹796
20% off
₹639
21% off
Special Price ₹599
₹209
31% off
₹419
31% off
₹419
31% off
Special Price ₹699
Special Price ₹899
Special Price ₹499
Special Price ₹799
Special Price ₹599
₹419
31% off
Special Price ₹399
₹239
21% off
₹319
21% off
₹559
21% off
₹236
20% off
Special Price ₹799