thisMySQL 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,6658,2005,3863,5742,3334,1973,5717,2145,6593,6814,3334,3338,7012,7238,3248,2069,1302,3402,3402,3402,1270,5770,5770,5806,5806,2643,2643,6815,2555,2384,2384,6865,6865,582,9324,582,6183,2635,9865,6484,9866,7238,546,6658,857,5742,4716,4437,2041,3863,550,8220,6381,553,7539,529,7149,8440,532,539,323,313,397,860,6386,549,8542,5853,6769,526,7704,538,528,525,7704,5853,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,808,6769,6809,6710,1345,6644,6645,550,3184,5996,3131,6381,3561,3580,3554,4140,736,1523,7574,1349,1311,6120,6157,6175,6767,726,7962,8024,7304,4916,4985,6818,4923,8361,8199,8762,4302,8434,9037,8629,8049,9134,9055,7903,2005,2005,1973,2183,6740,931,6715,766,2473,915,915,915,1591,1591,9358,9357,9357,9357,10382,4923,6658) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC