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,4671,4923,2417,5782,6578,1726,6794,1296,2729,1153,1988,6962,4920,1973,6844,317,1732,6003,1462,1380,4437,4437,2749,2749,7406,7443,7406,7472,7456,7070,7120,7642,7648,7645,7652,3874,7298,7674,2635,8048,8047,6003,906,6691,7406,2795,5770,4144,5421,5910,8683,8683,2635,7238,546,6658,857,5742,5733,4716,4437,2041,3863,550,8220,6381,553,7539,529,7149,8440,532,539,323,313,397,860,6386,549,8542,6769,526,7704,538,528,525,7704,540,551,864,544,1730,545,531,543,391,535,541,387,536,382,1271,4769,376,524,377,365,376,374,6270,384,2856,8787,368,6066,6082,385,394,6197,8858,372,6076,317,3913,317,3913,6382,6523,8165,375,6526,8496,3879,7588,8989,8530,8160,1380,3823,6854,6391,8159,8157,7300,7605,4701,8785,6144,9437,9435,8244,9438,8340,3879,8699,8874,5770,8316,9146,9414,9409,8700,8245,9436,9425,9408,9184,8883,8329,8247,9182,9415,8332,8318,8324,8326,8319,8241,9592,9183,9428,8248,9431,9894,9150,9143,9534,9190,9908,10045,6768,9300,7632,9154,6396,4501,10056,9792,9891,9155,9156,9217,10202,9156,10198,9854,9217,9502,10193,9502,10193,10197,10195,9147,8333,8335,10099,10102,9151,8330,10218,10147,10333,10322,10323,10217,9412,10102,10336,10332,10334,10101,10331,10100,10324,10140,9433,10213,8220,4920,8893,1981,5770,2033,2261,2915,6564,1371,3860,993,3337,3337,3337,3337,3337,3337,3337,8946,9410,8329,8627,9426,8088,8944,7881,10099,6740,10101,1932,5995,7903,7143,446,1215,7833,3474,7304,6188,1537,7837,10010,10010,1770,1765,1771,10212,3784,1380,3863,8491,2594,4234,5371,3702,501,9030,3989,5148,6740,7238,8220,7975,1371,7143,7833,7903,5995,9614,5322,5070,4796,766,7019,8948,10148,10173,9300,10187,10146,10056,9378,10526,10892,10836,10964,8435,11121,11027,2253,4791,11089,10149,11018,11101,5567,10491,1993,11733,11690,10716,8438,1974,11788,10228,11497,11028,10934,1988,582) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC