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,5996,6940,7020,5657,7812,7943,8109,8223,6971,7160,7548,6726,8296,8230,8049,8526,8526,8064,2992,8357,8357,2473,7110,8512,8033,6773,7669,8503,8503,7074,7304,8903,7714,8051,7714,7272,9030,8960,9040,7903,8420,8020,7897,7897,9525,8961,8961,8961,3217,2573,6618,1609,6623,6143,6332,6371,6149,6221,5430,5756,313,2995,6215,1210,6443,1487,2917,640,4419,6550,6636,340,267,754,6486,7131,7873,947,1663,2270,2135,3882,2446,1783,8480,8561,8559,8771,52,8910,7837,7899,7772,7150,7167,4464,3860,9406,4395,6104,2117,4834,8739,9983,4029,7962,2632,7103,9833,9300,8062,7143,7869,10865,11485,8545,11271,11782,8514,8175,8910,9317,4639,8903,8512,9406,6726,9128,9405,8436,4144,8436,4144,8436,4144,1371,1917,9052,3241,9453,2261,9525,8903,6971,7922,8841,9525,9939,9039,8526,9983,6726,7878,7879,7879,7840,7840,7878,9990,9372,9990,9372,7427,11121,8220,11296,11299,3913,11601,9890,8512,6082,8168,7548,7632,10056,11656,11101) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC