this
MySQL 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,5252,2117,4417,1318,2117,3250,423,3520,5305,2985,6845,6104,2780,2785,6996,3070,2518,3555,2342,2374,6999,243,219,1245,5088,6390,7785,7926,7870,6633,7761,4931,7796,6982,7774,8351,4395,7989,7830,7713,7115,7116,7152,6971,501,7878,8048,6261,8503,5795,1461,7761,8222,3059,2709,8924,9362,9374,9374,8584,2706,4861,8506,9831,7107,8251,8948,10265,10306,9748,9890,10555,10479,10577,10862,10937,11325,8208,11497,779,810,578,730,4639,645,4405,6809,6845,6104,6805,2615,4659,1603,5484,5904,7146,6979,4774,5116,7303,1764,1460,6687,3492,5276,7144,3797,4854,4316,4964,423,5298,5003,7756,1272,510,4985,6953,7882,7874,4512,2989,5400,470,5763,3358,6559,7981,7988,952,1092,3856,665,2331,7994,2913,3719,7956,3893,8135,5889,3878,4087,7287,4652,1184,3136,5995,7807,5332,7937,6732,7971,549,5965,4616,3824,8483,8484,6560,3169,5252,8257,4784,4830,8514,8573,8169,1872,8471,2024,6192,1349,7985,8305,2989,7251,3580,6255,6829,8713,5148,4234,4121,4121,6571,5719,2706,735,1257,6152,6151,3359,4305,6596,261,314,3074,3702,5996,7915,3334,7722,7938,1811,567,8250,7992,1783,8316,3883,8411,8732,2520,4296,8892,546,9152,8683,8475,8627,9037,7666,9300,7174,8648,8948,7967,2331,1245,4964,6221,4178,8324,6740,7238,6270,1557,1380,8220,8247,5763,7300,217,6508,8345,8490,6512,6510,6103,6199,6533,2467,6373,6768,8244,2989,7923,1303,6831,2374,735,9001,8151,6880,9243,6855,7594,510,9505,8869,9921,1052,9450,5839,9900,10228,4405,452,4800,10305,8135,2164,1557,2164,9931,11134,8435,8257,10086,8922,11352,9871,8262,11437,5997,1049,10741,11101,4362,8377,11519,4720,6806,11670,1803,3824,1016,10366) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC