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,6588,2672,5647,3302,6618,840,7962,7962,7962,7962,1738,8684,8842,3216,9012,8914,8869,7897,8781,8960,4395,5602,8512,8841,8232,7359,9078,7847,6432,788,788,3966,3966,3966,3966,3966,3966,3966,6357,6209,6205,1380,6715,6548,8281,3913,8255,9300,5995,4671,6865,6569,5769,8710,8710,8710,9340,5484,3327,7211,5788,6892,2467,2349,8137,9946,4435,3336,3336,9791,778,7076,7094,5996,5996,3863,3863,3863,7111,3863,3863,3863,7258,7258,6799,8064,8354,8354,4317,6616,8780,8816,1993,6367,8520,6548,6715,924,8388,5717,2399,4769,6621,104,1142,240,8970,6700,6631,9215,840,6006,9229,5484,1591,6264,2644,7144,8821,5052,7871,6774,5371,217,9390,9281,3327,5770,2253,8515,7838,2029,9468,9027,9322,2117,1371,6131,9162,9513,2006,7861,4435,9538,2005,2085,1052,4395,7923,7976,1242,2989,9480,7992,6642,9524,9479,6103,6004,906,9603,3428,9629,317,754,9306,6691,4079,8685,8815,8814,8826,7576,9704,3598,156,1153,9678,8659,9559,9546,9760,1912,3236,6905,4913,7599,9390,9480,4154,9754,6102,2342,8508,2467,6176,9763,9770,9783,120,6977,9782,6602,9014,7640,9344,4563,6652,9762,6623,8352,9812,2843,9830,8685,6841,8292,8544,9006,9879,9865,9866,207,9872,9918,4216,5419,9926,6819,4320,4900,6843,7374,5647,7561,1993,8966,8481,8481,9667,9667,6548,6548,9529,9148,9259,7288,7288,7288,7288,7288,3327,8739,10670,11101,6700,8290,381,9704,9704,9704,9704,9704,6420,2282,6911,3036,6967,389,6961,6966,1730,7897,1303,6951,3896,7266,8831,6197,8529,6743,8165,979,8585,3702,3702,10539,8715,4671,9857,10309,5068,7380,10250,5996,526,2056,391,7270,3860,4199,3896,1458,7300,6768,7300,6962,7286,4544,4860,7899,545,550,548,539,4684,3554,3554,1398,7175,7032,1662,549,6477,525,2706,778,551,864,1366,8356,8530,546,8880,979,6394,6842,8212,7472,9030,578,547,2847,3337,1777,7178,8438,4500,4500,9076,9778,9494,9494,9791,9745,9858,8575,8575,6648,9488,9879,6583,6583,8434,8434,9547,9547,10638,6579,8063,10731,8428,9853,9785,6400,10695,10579,10649,11121,11232,3327,9543,9543,11226,11373,10940,10836,4568) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC