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,6766,7160,4320,4535,4535,7833,7833,6971,7833,840,840,6715,6715,7388,7388,4500,4500,8863,9030,9030,7833,2729,8947,8947,3327,3327,3327,3338,9830,9830,9830,223,5148,2706,5996,2992,3860,4769,6188,1462,1453,6813,6588,7130,358,6001,7304,6856,1402,6812,5909,4801,6140,6122,7246,7099,5915,840,8473,2473,7833,7232,7232,7223,7297,7297,7987,9030,8547,8091,3395,7890,6170,6364,1209,4535,4251,3148,2946,6209,7775,4724,1385,2521,8027,9118,8425,223,9299,9234,4774,3783,156,5245,6788,1324,2266,9557,9741,7245,8400,9978,9652,7548,233,182,7599,2849,1300,7261,4199,7118,2261,3702,4199,8623,8767,4405,375,382,389,7298,7150,7297,8236,9132,9132,2474,3247,7106,3874,4146,4146,3874,3874,3874,3874,9770,8922,7903,7833,7143,7019,8793,7761,7761,7761,7761,2169,6631,8809,7147,9049,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,7587,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,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,11748,6103,11385,7610,11052,7311,11365,11251,11421,11130,11419,11422,7892,11013,7697,3997,10981,7696,5635,1927,9555,10906,11187,11463,3997,11116,11269,6653,11063,11376,788,4386,7172,11402,3442,7186,7286,10272,8228,7715,10980,10850,8364,7176,11370,11431,11515,9082,9473,4558,11539,11497,9500,10433,11556,7890,5763,7269,9959,11496,6873,8965,10655,176,2145,10655,176,2145,10655,10805,7178,10480,11365,11795,1016,11780,2791,7179,11150,11768,10526,11746,7374,1327,7893,1327,7893,1327,7893) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC