General-Elections-2019

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 (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