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,511,6155,2766,5915,5371,5322,5996,4985,311,6391,864,6255,5386,3997,6261,6382,6385,5331,6652,6559,435,427,6177,5148,6653,6391,6785,665,6364,228,3337,3336,6130,5956,4419,4769,1271,5882,2992,1163,341,1906,6122,6493,3897,176,2157,3337,3897,6582,863,864,6583,6752,6780,397,6883,6493,388,6204,5956,1121,6986,3830,4796,5236,455,464,4234,4128,4178,5279,6431,1453,6400,1537,3337,766,6195,4178,5995,6001,754,6587,5996,2158,6008,3644,223,4566,1343,6381,323,3860,397,2594,4656,6766,1826,975,6394,3964,6593,858,6986,990,3989,1591,6842,6947,6941,6010,6985,1402,2261,766,5070,6349,6793,5882,1461,5331,6757,6779,6812,2374,6115,6631,6658,4099,4656,6779,6971,7003,217,6850,1029,2474,5530,2000,6951,1371,6996,958,5371,7019,675,3100,230,6312,7034,7148,6569,1917,6168,924,3595,6103,2915,3059,834,239,7226,4947,6813,3493,1461,4796,1558,1520,6141,836,850,3860,233,1785,1537,6431,6951,1776,6275,7739,182,2932,2000,6445,1084,5339,1521,3625,7156,4995,797,2446,1462,1779,1785,6400,3037,2387,2117,7761,4529,4659,8222,8232,8128,3542,1070,7897,4639,3521,7050,1490,2029,4079,7783,8097,4405,4834,4259,8558,1890,6818,2117,8518,8611,8109,6631,1349,8535,8388,8629,5552,4218,1811,3850,8793,7976,2737,8839,8852,7918,734,3823,3966,6667,1558,8305,6814,8889,7602,7147,8183,7307,7795,1772,186,1774,6715,3302,8684,933,4991,314,6366,8281,9340,5769,2009,6583,6438,8561,3519,3554,5305,8978,9344,9290,9197,6700,7903,6255,6552,9453,8781,7048,6631,3520,6642,344,9776,8089,3557,9776,4849,2390,4087,9248,5046,9922,2122,9900,9910,9661,7759,9776,9928,7825,9308,36,9986,7998,10229,9798,1303,10063,6113,2989,9449,5891,2170,8816,6641,10346,10280,9552,9538,8586,10001,9602,9916,10469,10127,576,10292,10500,10375,9513,4349,2158,7173,10548,10526,10654,8956,10579,10652,10775,10652,10747,6562,10719,10894,10227,10297,10871,1765,1767,1771,1768,1769,1766,9154,9518,10670,6354,7922,3883,8272,779,10354,11041,10314,3073,6689,3071,8316,7557,8627,8088,11021,9037,7170,9945,7174,8241,9665,8333,8946,8244,10742,10924,10528,9665,7912,11239,5994,61,11104,10578,11364,10454,1085,358,6740,6138,6548,5371,5996,6364,6642,6975,5142,7304,6831,6870,5995,2473,1325,7241,6381,524,7363,6383,6175,7651,3550,501,8142,8097,8115,6362,6110,8305,8305,8019,8019,6157,240,961,961,961,961,8223,8223,7863,1402,7900,6780,8706,8706,6310,8967,8514,8514,7911,1052,1126,6118,1371,8290,8151,5334,435,5251,7658,1379,8628,8628,5956,5467,2009,2257,1462,5882,6593,1887,1327,6312,6377,5742,3704,2474,7048,6127,6810,1981,6816,7547,2554,6593,3865,3327,6131,1462,310,3248,5782,2635,2643,3402,7363,2843,7599,2507,4154,5068,6905,6721,1990,6618,1990,6618,2967,5567,7958,4079,6127,8110,8607,4338,6829,3531,8768,6710,3561,3029,7641,3761,7632,2455,1051,4535,6807,5602,156,6364,46,6264,8924,4339,8482,6961,2447,5484,5376,9603,8716,9552,3059,8812,4682,4682,8955,4765,5647,8019,6642,6780,9936,2491,4987,6362,4362,5322,4320,10107,9931,4580,1172,10457,7643,1272,10267,4983,10649,924,7037,6806,6958,6959,6960,6973,6972,6974,5165,458,10504,10229,10267,207,1051,265,7815,6059,265,10495,7882,10704,1992,11342,9336,9967,6767,10314,8518,11120,9423,8960,8839,4360,10860,11376,10608,9757,11131,11115,11676,3428,11112,9403,9234,223,5148,2706,5996,2992,3860,4769,6188,1462,1453,6813,6588,7130,358,6001,7304,6856,1402,6812,5909,4801,6122,7246,7099,5915,840,8280,8473,2473,7833,7232,7232,7223,7297,7297,7987,9030,8547,2331,6540,1453,6539,6588,7783,7840,6813,4570,358,5602,2635,6544,4801,7023,933,7003,8390,6034,5305,3522,2573,6785,6036,1967,7639,6039,6038,6030,3521,1070,186,2262,6121,8281,9049,3520,6023,3519,3197,7897,6031,7083,7155,7119,7097,7110,7085,7112,7096,7266,7211,7115,7572,6631,2005,7086,8405,8468,8468,8211,8450,7289,7289,7096,8398,8398,8236,8404,7662,7273,7634,5551,358,6780,2889,6177,5915,2029,7783,5956,6154,6794,5996,3860,391,387,6151,6159,1126,6562,7238,377,1558,2005,6578,2635,7576,7576,5719,7304,4769,2474,5718,5718,5718,8563,8353,8353,8725,7903,6183,6183,6183,6183,6183,2658,7840,7840,6740,6740,7238,7238,8220,8220,4639,4639,4178,7976,1591,4395,4395,8816,7879,9300,5516,1425,1307,5915,446,4788,2451,5995,5371,1145,1681,1485,5719,6316,375,386,6082,377,7076,7094,7118,7072,7124,7113,7150,7109,7246,254,1572,1981,186,9989,6763,6761,6396,6394,2635) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC