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,808,1159,470,1744,444,3216,2986,463,319,2151,2985,5891,5552,6354,3073,3070,4849,2170,5995,6167,455,734,463,3585,319,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,2628,7023,3264,1345,2602,944,2911,1257,780,6731,1257,4046,4536,7304,2873,4986,3465,7238,1379,4131,6255,3828,176,4454,4796,1645,525,550,601,933,1589,2390,1070,3264,5848,3557,3828,808,3302,5305,5552,2876,4218,529,3610,3392,4454,3048,3803,1928,1927,6950,6122,5915,6350,713,5256,6725,3754,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,3913,1245,2778,6804,3926,1770,1771,1085,1771,1070,1769,1767,5148,1561,6964,6110,1768,4426,6966,6961,4164,6471,4165,6504,511,510,2469,3216,1370,6383,6415,470,467,2605,3702,858,4788,1741,3771,2035,5821,344,1165,979,3989,1770,1765,2706,3830,3370,4943,6371,4423,6354,1600,744,1381,455,3761,2331,1232,2183,3610,3172,1474,3172,2615,3131,1185,1738,3217,7752,567,7748,7964,4218,5576,7779,2869,8000,1351,834,3541,2334,344,6660,3250,5091,4701,2671,7604,2653,3136,3417,6413,4972,645,7033,7896,6940,3645,1098,1593,1407,4964,4984,1561,1460,3797,4008,4830,5218,8095,1070,5091,1738,8150,358,1453,236,6813,6104,6831,6366,3247,6645,6189,319,447,7124,7115,7063,7219,8047,7263,7109,7307,2183,6223,2824,6212,344,3828,2876,6167,2795,2164,1765,1770,1767,1771,1768,1769,4944,4936,4941,4945,4943,4940,4942,4939,6658,6644,319,2808,4938,6215,7551,6501,6216,7258,8062) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC