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,5995,6167,455,734,463,3585,319,663,6660,3850,4218,3184,3217,6364,5070,772,5765,5623,6599,3844,360,3521,3522,743,3520,6644,2033,5956,3519,3302,447,5839,4057,6947,1416,2390,1371,6641,601,2170,3557,567,6645,7023,3264,1345,2602,944,2911,1257,780,6731,1257,4046,4536,7304,2873,4986,3465,7238,1379,1826,650,6565,7147,1085,1086,3850,358,5915,7160,840,7240,7548,6589,6130,4597,2117,975,2555,3525,7869,8223,734,5419,3760,8095,8094,8488,6740,7034,396,743,7594,5602,8587,7783,6712,7910,8358,5334,665,6780,2117,3549,446,4765,7840,8556,7879,7878,215,4574,7641,5839,3850,6785,5484,6723,4570,3479,7607,4178,8,7607,8306,6569,8912,9321,217,8305,4152,8491,6174,8296,2925,7634,4834,8142,8617,1974,1993,1974,1993,7840,7879,7840,7879,6728,587,6728,587,8683,1308,8683,1308,6770,9403,7048,7847,3926,450,2627,3949,4178,8565,8831,4716,9865,4716,9865,3913,6869,3913,6869,3913,6869,576,5484,1765,4639,3282,7299,11451,8151,8151,10672,3165,8095,4985,10937,4405,9116,239,2490,8095,6119,10955,2063,10285,10092,10093,4144,8922,8628,10165,10133,10786,10552,10287,9547,10913,10286,8952,130,8995,2469,144,8008,2653,3304,4722,10702,2671,9349,10626,10830,3165,2467,6325,8870,8844,2454,9828,10805,2753,3908,4659,10257,9767,8995,10165,2490,3590,10865,8933,10836,3465,10241,2334,4164,5839,3646,7234,9983,9864,1185,3282,10715,6780,3549,4423,11271,2253,8706,311,11435,10260,11453,7785,7586,11134,11383,8304,11302,3415,10714,8169,9895,1232,665,9538,11669,8955,1052,11609,7824) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC