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,8314,8246,8316,8315,8318,8334,8244,8322,6743,8326,8330,8307,8649,8313,8311,8319,8335,8331,8249,8308,8873,8872,8585,8586,8682,7546,7631,8585,8584,7870,8247,8335,8317,8329,8332,8339,9114,9111,9154,9156,8308,8309,9119,9120,8583,8618,9113,9115,8341,9112,8598,9183,9114,8699,8340,8342,1411,9137,979,8824,8329,810,9154,9151,9155,9084,9407,9433,9432,9431,9411,8328,8339,8583,8618,9416,9410,9520,9434,7187,9521,6151,1327,458,6616,3549,6103,464,3428,5334,3997,5882,6798,6840,6763,1663,6157,2998,3449,3069,6427,3389,6491,3898,452,222,4913,6600,6855,6388,2507,4765,3254,3169,6151,2684,6905,6129,464,4659,6181,2164,735,393,6894,379,6146,2737,1049,397,7195,7199,8656,9088,6523,3327,8387,6545,8305,6604,8592,6616,6719,6700,9151,3879,8097,6521,7400,9502,9647,9502,7195,3898,9156,8988,7199,9409,8882,6928,9173,9172,8700,9408,9176,9536,6768,8971,1730,8387,8858,9146,9145,9147,9144,9143,8881,9150,9191,240,9411,9151,8987,9192,9767,8986,8654,8656,9592,8530,8529,536,535,7694,7695,7696,7697,3881,3884,3888,7868,3890,3883,8531,3882,3895,3893,7196,7198,7702,6937,7196,7198,8655,8665,8581,9993,8879,9088,9178,7705,6270,9633,3896,3894,9177,9175,1765,5386,6656,6985,9217,8168,2856,7870,9154,9892,10100,9155,9792,392,386,9891,10097,10099,9894,9906,9891,4305,8242,9903,9951,8274,3887,3885,10136,10147,10102,9909,9908,9950,379,10193,3889,3892,9535,8329,9535,8329,8267,6743,3036,6937,6933,6931,857,6545,8984,2594,2005,9488,2005,858,6922,6934,6935,6938,6744,2276,6912,2275,7134,8725,2274,9111,9891,8881,8340,8882,990,6757,6936,6758,6746,6426,10328,10329,9149,6422,6523,6381,9386,524,10098,10961,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,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,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,6042,573,526,553,541,539,7772,510,1765,7770,524,551,532,528,7771,1769,6876,533,512,511,9792,7772,7580,7637,546,9911,7638,6100,7596,9147,9155,9150,9154,9156,9231,548,529,9145,9144,9146,9151,9217,9192,3719,9143,10604,6420,11617,11616,9538,10454,8132,1300,10487,380,376,9830,8292,1685,2605,8824,378,9192,10098,9191,9156,385,810,10828,10546,9149,6759,6762,10649,10417,10487,10488,10813,6754,860,10431,10390,10388,6761,6760,10382,10387,10386,857,6913,7162,6840,6926,6925,9735,10445,6381,6391,6914,6763,6915,9165,8693,8156,8267,7200,7199,7196,7198,7194,10996,10797,7195,6917,6988,6922,8267,10599,10600,10598,9087,10505,11077,10445,11078,11079,6935,11080,10603,11075,6916,6933,6936,11077,3277,6928,6929,6934,7190,7191,7192,6937,6918,6385,673,9178,10597,10593,6421,6423,6920,7042,6424,6425,11103,6426,10486,7055,10389,10426,10428,10381,10957,10222,10264,10421,9176,9177,10167,10384,10420,10423,10425,8987,6491,6417,6517) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC