sort by: Popular Price: Low to High Price: High to Low
    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 (26, 27, 34, 56, 63, 121, 141, 156, 189, 226, 259, 442, 478, 507, 688, 860, 864, 932, 933, 934, 952, 1082, 1135, 1288, 1388, 1434, 1569, 1670, 1746, 1983, 2084, 2169, 2279, 2282, 2285, 2286, 2438, 2850, 2878, 2984, 3060, 3083, 3152, 3184, 3282, 3289, 3307, 3323, 3325, 3361, 3443, 3462, 3511, 3517, 3522, 3611, 3620, 3659, 3660, 3712, 3715, 3720, 3747, 3778, 3812, 3824, 3827, 3828, 3829, 3872, 3873, 3895, 3918, 3927, 3934, 3937, 3941, 4000, 4074, 4106, 4123, 4166, 4167, 4180, 4622, 4738, 4914, 5055, 5272, 5321, 5521, 7851, 7852, 7853, 7866, 7876, 7877, 7883, 7889, 7890, 7896, 7899, 7906, 7929, 7948, 8013, 8046, 8063, 8114, 8117, 8123, 8125, 8146, 8161, 8165, 8182, 21175, 21185, 21553, 21554, 21584, 21698, 24156, 24390, 24819, 26844, 27291, 27416, 27421, 27424, 27426, 27429, 27433, 27571, 27658, 27699, 27779, 27798, 27811, 27824, 27870, 27970, 28003, 28186, 28187, 28290, 28315, 28325, 28367, 28489, 28492, 28607, 28640, 28679, 28764, 28766, 28767, 28798, 28818, 28871, 28881, 28929, 28941, 29016, 29210, 29398, 29418, 29729, 29737, 29752, 29767, 29781, 29785, 29810, 29814, 29818, 29820, 30013, 30043, 32573, 32820, 32821, 32831, 32855, 32862, 32879, 32896, 32934, 32962, 32977, 32980, 32994, 32997, 33235, 33248, 33252, 33359, 33484, 33536, 33540, 33697, 33709, 33764, 34358, 34359, 34593, 34609, 34677, 34682, 34998, 35008, 35038, 35311, 35318, 35359, 35384, 35431, 39347, 39354, 39356, 39420, 39437, 39493, 39494, 39668, 39934, 40025, 40072, 40075, 40135, 40156, 40238, 40374, 40401, 40504, 40645, 40860, 41011, 44537, 47101, 47530, 48072, 48177, 48185, 48515, 48599, 48618, 48620, 48621, 48636, 48672, 48681, 48686, 49083, 49102, 49107, 49325, 49633, 49634, 49635, 49905, 50031, 50073, 54162, 54179, 54188, 54214, 54248, 54286, 54337, 54466, 54470, 54650, 56769, 56865, 57335, 57489, 57524, 57649, 57655, 57659, 57708, 57827, 57928, 57955, 57972, 57973, 57976, 59179, 59188, 59198, 59221, 59280, 59306, 59466, 59474, 59493, 59507, 62271, 62275, 62300, 62369, 62785, 62851, 62861, 62884, 62912, 62916, 62932, 62937, 63113, 63121, 63181, 63184, 63225, 63232, 63311, 63337, 63424, 63484, 63524, 63561, 63601, 63607, 63712, 63768, 63783, 63827, 64855, 64873, 65676, 65677, 65678, 65679, 65681, 65682, 65768, 65769, 65772, 65783, 66037, 66144, 66807, 67172, 67563, 67564, 67565, 67566, 67567, 67568, 67569, 67570, 67571, 67572, 67573, 67574, 67575, 67576, 67577, 67578, 67579, 67580, 67581, 67582, 67583, 67584, 67585, 67586, 67587, 67588, 67589, 67590, 67591, 67592, 67593, 67594, 67595, 67596, 67597, 67598, 67599, 67600, 67601, 67665, 67835, 72087, 72089, 72152, 72274, 72466, 75027, 75102, 75118, 75188, 75189, 75190, 75191, 82505, 86262, 86346, 86361, 86494, 86495, 86503, 86514, 86516, 86531, 86535, 86641, 86647, 86672, 86675, 86676, 86681, 86775, 86794, 86804, 86856, 86861, 86895, 86943, 87093, 87107, 87234, 87241, 87242, 87244, 87245, 87246, 87247, 87248, 87249, 87250, 87390, 87391, 87392, 87399, 87525, 87541, 87555, 87632, 87799, 87805, 135394, 135452, 136581, 136657, 136988, 137207, 137489, 137492, 385148, 385149, 385150, 385151, 385152, 385153, 385154, 385155, 385156, 385157, 385158, 385159, 385160, 385299, 385350, 582821, 583404, 583405, 583406, 583407, 583408, 583409, 583410, 583411, 583412, 583413, 583414, 583415, 583416, 583578, 583579, 583580, 583581, 583582, 583583, 583584, 583585, 583586, 583587, 583770, 583771, 583772, 583773, 583774, 583775, 583776, 583777, 583778, 583779, 584746, 584854, 584855, 584856, 584857, 584858, 584859, 584860, 584861, 584862, 584863, 584864, 584865, 584866, 584867, 584896, 584897, 584907, 584916, 584937, 584938, 584945, 584946, 584947) 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, 8003, 8004, 8005, 8006, 9000, 9001, 9002, 9003, 9004, 9005, 9006, 10000, 10001, 10002, 10003, 11000, 11001, 11002, 11003, 12000, 12001, 12002, 12003, 13000, 13001, 13002, 13003, 13004, 13005, 13006, 14000, 14001, 14002, 14003, 14004, 14005, 15000, 15001, 15002, 15003, 16000, 16001, 16002, 16003, 16004, 16005) and b.book_language != '' and b.publishing_house != '' GROUP BY b.book_isbn order by FIELD(a.book_id ,584746,584896,584897,584907,584916,584937,584938,48636,87107,86514,86804,29820,27824,136988) DESC, a.book_id DESC limit 0, 20
Bookshelves
Festival Offers Jawahar Lal Nehru Junior's Library Pre Order Vani Prakashan Books Amar Chitra Katha Vallabhbhai Patel In trend Taaza Tareen Hindi Classics Popular Authors Selfhelp & Philosophy