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,7127,8111,1089,7754,7554,7037,8358,3744,217,8434,8523,6521,8438,7568,6691,5965,8535,6805,4784,8439,8435,6349,6349,7835,8306,7561,7561,7561,7561,7561,5143,8093,5056,8737,9258,8514,4512,5909,9466,8175,9278,1198,9212,4784,4510,7599,9767,6171,9725,9730,9839,9888,9888,9924,8933,5066,4185,5542,5906,2889,254,5247,5322,3216,5837,6315,320,5331,6796,3026,464,6700,6866,5331,1462,508,6121,1230,924,4218,5994,922,6364,6382,5956,3542,6130,1645,7304,5996,5909,3037,4109,567,4834,1557,5088,6891,1325,4450,405,2117,1998,421,324,4029,7547,7143,4690,2729,4432,3054,5763,5735,4986,450,4320,4659,4722,2246,6809,7834,5904,1073,8093,7592,7837,7835,7836,1461,8103,8151,7907,6828,4765,3549,7910,7359,637,3014,501,6838,5602,1327,7919,8092,3872,4901,3904,358,435,4056,1119,1121,7861,1215,4983,1029,7812,7783,8617,4731,8629,8793,8745,6642,8555,8837,8836,8869,4566,8919,8840,7037,1461,4730,6397,4950,36,768,8169,9030,9075,9073,8933,9074,9072,9164,9163,8841,9096,9072,9074,9216,9244,9243,9242,7815,4395,8441,5088,5236,9281,7899,9344,2253,6310,5046,4061,6986,1038,4339,2847,8839,8031,8547,7559,9460,9456,9459,9464,9455,9454,7354,6713,3261,6782,8089,2882,1516,504,9497,7833,9479,9546,9757,9647,9463,9814,9635,2989,7804,8970,9810,5881,5885,7548,7873,6842,8280,8291,8818,9038,9334,9078,9614,5915,7140,3395,9345,8978,10004,8504,9990,9637,9888,9897,9910,10113,9900,10114,6002,6981,9967,9603,10046,2446,9753,9788,409,9319,10039,9828,10064,9558,10060,10088,10182,10087,10261,9987,1385,10109,10104,10260,10267,9354,10237,10358,9769,10258,10183,1142,9180,9185,9299,9506,9801,10063,10259,9389,10229,8910,9406,9275,10210,10528,10121,10547,10549,10297,10343,10364,10380,10320,10319,10318,10564,10699,9959,10090,10480,10187,9919,10820,10700,10471,10505,10741,10847,10569,7131,10655,10668,10712,10977,10967,10972,10893,10702,10935,10679,10538,10119,11044,11090,11041,10971,10416,10715,10719,11021,9336,11103,11104,11042,9615,10174,9969,10440,10780,10785,10737,11106,10754,10734,9617,10778,11028,10749,11129,11135,11162,11163,11134,11089,11237,10536,10842,11126,10876,11258,11230,10261,10875,10878,10865,10086,11282,11220,11272,11315,11339,3493,11372,11382,11361,11121,11397,11234,11127,11446,11450,11381,11131,11386,11271,10236,5795,10837,11487,11423,11213,11377,11359,10938,11621,11551,11606,11379,11612,11703,11698,11646,11724,11440,11230,10663,11593,9896,11800,11669,11678,11850,11872,11363,7144,11838,385,8882,380,8878,378,8329,6204,6517,382,393,379,8858,8788,9767,389,7588,372,375,8435,9882,384,390,386,8542,7388,381,9899,10054,1666,7037,9229,9229,391,9856,391,9856,391,9856,4827,2989,9557,8780,2749,1487,10321,6170,9883,2986,1764,7299,6855,10093,6806,10781,1308,10672,7546,2989,7604,8154,7165,6181,9375,7206,10970,1667,850,10510,7283,1257,7175,11133,6650,8882,11052,6794,6769,11102,10892,10291,6459,5913,6042,9367,9368,10522,6621,4473,9028,10671,10829,10546,9738,2856,7080,9816,7584,10185,9405,8939,8574,9710,9258,10023,11222,11101,11286,3913,7088,8771,6806,8419,11315,8689,11291,11331,10188,11351,8520,11300,11345,10767,8822,9083,11344,9669,7273,9305,6076,9670,9671,10839,8092,11347,11409,11449,9671,9954,10672,7046,9955,984,10686,10761,10220,10675,10767,2085,10869,10947,5922,3346,3908,9959,9368,9367,7670,9954,8648,10933,9161,4800,9649,10077,4401,4079,7874,10655,10702,9135,10976,10187,10768,10891,207,6953,10000,10771,9889,8639,10769,9955,10172,10185,1209,11108,721,10171,7250,9736,8446,10226,8444,8740,8424,8568,8447,9199,8737,9658,9053,8741,10816,8962,7284,8445,10834,8061,8073,7890,7264,8575,8641,130,5961,7833,9561,7714,1343,11025,9968,1378,7283,8144,10550,7639,2079,11305,8144,6138,9245,11170,7280,11433,8098,10861,7279,7951,11332,9247,11195,9674,7286,11280,7084,10655,10191,1970,11225,1173,7251,7269,8653,8279,7037,11654,11434,11675,6831,11654,11800,6831,2506,7288,6102,8370,9158,11626,11692,11693,11468,11674,6805,10944,10945,10584,10583) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC