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 (2876, 3011, 3163, 3166, 3167, 3170, 3171, 3270, 3271, 3272, 3465, 3467, 3469, 3470, 3471, 3472, 3473, 3475, 3791, 3794, 3795, 3990, 4080, 4257, 4258, 4267, 4276, 4287, 4294, 4295, 4301, 4322, 8266, 8324, 11119, 11234, 11314, 11358, 11532, 11534, 11536, 12069, 12070, 12263, 12306, 13596, 13597, 13620, 13625, 13626, 13627, 13628, 13629, 13630, 13631, 13632, 13633, 13634, 13683, 13684, 13686, 13687, 13688, 13689, 13690, 13691, 13744, 13745, 13746, 13747, 13748, 13749, 13750, 13751, 13865, 13866, 13867, 13868, 13869, 13870, 13871, 13872, 13873, 13874, 13875, 13876, 13877, 13878, 13879, 13880, 13881, 14105, 14106, 14107, 14108, 14109, 14110, 14111, 14112, 14113, 14114, 14115, 14434, 14435, 14436, 14438, 14439, 14441, 14442, 14443, 14444, 14445, 14446, 14693, 14694, 14695, 14696, 14697, 14760, 14874, 14875, 14876, 14877, 14878, 14879, 15094, 15194, 15423, 18316, 19265, 19266, 19267, 19269, 19271, 19272, 19274, 19275, 19276, 19277, 19278, 19279, 23751, 25430, 31269, 31285, 31304, 31305, 31320, 31332, 31350, 31351, 3) 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 ,72442,75099,86598,34359,72442,586195,586269,584767,583727,135534,86351,75108,63567,63565,63149,63263,63147,63077,54660,135427,583349,583328,586798,584657,86411,63567,63147,46589,15194,14441,14111,13748,18316,584321,585881,588733,585084,586197,585698) DESC, a.book_id DESC limit 0, 20
Special Price ₹175
Special Price ₹199
Special Price ₹250
Special Price ₹299
₹279
31% off
Special Price ₹250
₹175
30% off
Special Price ₹250
Special Price ₹250
Special Price ₹250
Special Price ₹250
₹209
31% off
Special Price ₹225
Special Price ₹495
Special Price ₹265
Special Price ₹325
Special Price ₹325
Special Price ₹325
Special Price ₹325
Special Price ₹325