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,5995,741,5091,1834,1559,1766,1313,1159,470,1744,663,444,4178,222,446,4860,1398,4796,2776,5799,5070,1586,734,6192,1461,6117,5236,2915,947,3392,3465,3059,228,233,4029,2473,1371,975,5995,5362,3014,1520,5286,766,6249,2632,501,2594,3989,2932,2706,4767,6556,4769,6250,4045,458,459,28,4950,5081,3415,5623,1727,1647,3850,3500,2380,1313,319,772,986,6564,3136,2151,463,6562,3585,1727,1237,4021,1098,1277,3610,5552,732,955,6644,6677,6599,1856,3454,447,780,1915,1160,5170,645,1460,2760,2707,2912,2270,2271,219,6779,1441,6709,2469,3351,1159,3482,3417,243,341,360,2685,652,2653,2654,2671,2454,3304,3447,1834,2602,3341,6827,2639,3844,943,2518,2298,5657,1871,3657,1869,231,2592,2477,2919,3843,5509,2974,2299,1822,1829,1297,3714,2334,4217,3787,3778,3760,5735,2456,231,2477,4796,4806,4808,3159,6828,5331,3035,6192,396,5692,2873,3437,975,6992,3447,4798,3825,699,944,2446,2387,1416,4855,1893,2864,4722,3788,2934,1228,922,2723,7003,836,4008,6852,1561,6901,6998,5247,925,5743,6663,675,1038,255,1521,5078,5142,2698,5631,6902,1131,6117,5764,2337,455,2160,3625,6188,462,7016,7224,7221,7234,7047,7237,7230,6769,6809,6710,1345,6644,6645,550,3184,5996,3131,6381,3561,3580,3554,4140,736,1523,7574,1349,1311,6120,6157,6175,6767,726,7962,8024,7304,4916,4985,6818,4923,8361,8199,8762,4302,5733,8434,9037,8629,8049,9134,9055,7903,6588,358,6189,5915,6122,2677,319,1425,3860,463,6168,6172,344,2183,2876,3217,3264,3557,3828,6075,1586,661,7033,1318,1407,7117,7117,3216,222,2200,501,341,358,6595,6751,341,4291,6104,1297,6644,344,2518,2974,5996,3359,2151,2933,3080,1645,525,550,601,933,1589,2390,1070,3264,5848,3557,3828,3302,5305,5552,2876,4218,529,3610,3392,4454,3048,3803,1928,1927,6950,6122,5915,6350,713,5256,6725,3754,663,1200,1313,358,6169,6162,2576,6588,6590,1000,1453,725,6159,3216,6645,6168,510,1250,6160,4512,2997,2873,2170,4038,2723,2934,1444,2573,6772,3850,6660,3522,3521,3520,6590,6159,4218,6539,6845,933,6790,6104,358,7286,8069,7089,8063,8063,8288,8213,8213,8569,8569) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC