this
MySQL returned error
Error Description :
Error No : 1064
Description : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,act' at line 1
SQL Query
SELECT COUNT(`book`.id) AS CNT FROM `book` WHERE id!=0 AND book.id<>0 and book.active='yes' and city_id!='' and book.id in(0,7115,7906,8063,7068,8712,7085,8048,8368,9083,7080,9053,9148,7244,9057,7944,7287,7287,7111,9259,7282,8404,8713,8044,7152,7671,8080,7935,8460,8709,9398,8652,9225,9225,9560,7279,7279,8364,8364,9755,9225,7080,8408,9199,10030,8364,10023,8363,8232,8232,7266,9956,9302,10076,9999,10024,10024,9956,9956,8229,10046,10278,9421,4624,9980,8782,7654,9813,9878,9755,10577,10811,10768,9794,9561,10767,10769,10869,9316,10833,10854,10757,10855,10770,10675,10890,10854,11210,11210,11262,9739,9875,9874,11335,10623,9873,9873,11225,11514,11331,8205,10572,8063,9739,11692,8087,11305,8034,11309,7254,7088,7086,11196,11218,10906,11278,11368,7662,10573,11337,9225,9338,7715,4234,8063,9082,9362,8644,3884,7121,8615,6134,8412,9264,7280,9398,2677,7984,7932,8306,8423,9662,9382,7661,7759,9658,9464,7662,9148,9659,5179,9844,7108,4947,7023,1533,3493,9563,1461,2995,2417,7986,4046,4769,10076,3863,8891,6781,8449,10026,10051,9220,10212,10077,10126,9821,2644,2455,10025,5454,10185,6209,3875,10270,6986,1370,7280,10275,10273,4906,956,7149,9444,10436,10063,9787,10506,9325,10149,10314,8782,9543,10523,9741,450,9533,10271,10578,9822,9747,180,4724,8972,8762,10768,9492,3891,1370,10767,7985,4762,10257,10890,8071,10854,9373,10882,9993,10888,10302,10881,8783,6102,10554,9608,6876,10887,7251,10190,3863,10789,10702,11130,9793,10078,10938,5251,8743,10965,10991,11025,11027,11188,11224,10823,5331,11212,11268,11189,4778,11278,11196,11281,10670,10701,11262,11329,11187,11337,5454,11108,11376,9795,10274,10412,10187,11402,11336,7913,8474,11215,10862,11455,9199,8423,11228,11524,9417,9308,11331,10839,4645,7261,7792,4791,10615,11449,10072,11511,4355,11633,8721,11302,7986,9817,9481,11628,11484,11700,9993,9649,8366,7363,7094,11117,10818,11629,11760,4401,11797,3883,11758,11444,10891,11776,1371,2677,10360,11553,5331,11793,11327,2658,11105,11763,11101,9398,6904,721,11712,9554,585,8460,10716,10481,11743,2989,8388,11794,1198,8260,11957,11755,223,11622,173,11626,11801,3564,11884,11771,2894,11312,11915,11034,6367,10617,8055,7268,11034,11035,10675,7276,10588,11337,7674,10757,7256,9509,10757,8457,5251,9676,9557,9325,7981,9526,10080,7909,1823,3856,10061,10081,7807,8737,8175,8206,4770,9503,2032,9968,4230,1487,7150,10270,3511,3564,104,3189,10275,9547,3896,10274,8767,8467,10008,10965,8063,10271,7297,8641,7298,8712,8046,9203,10789,8394,7262,10356,10449,8205,8468,8202,11553,11634,9095,11683,11362,9782,10768,9797) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC