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,7304,6967,6376,7143,7023,3380,539,7904,7270,6349,4079,7249,7247,8400,8201,8198,8199,8201,377,6066,8576,8568,2635,2635,553,544,1462,1462,6763,3449,5718,5718,6381,9189,8082,8443,8253,9312,7090,7090,7278,9300,9864,8995,7266,10056,9573,7585,7585,9304,9560,9560,9577,9577,8542,8542,8542,10265,8168,6925,8986,10026,8782,10572,10272,4080,9148,9561,10836,9076,8451,9949,381,6754,2506,6753,6752,6753,10423,6918,6840,10381,6146,6151,6916,6426,9165,10432,7870,8157,10695,10136,857,858,3926,10423,10417,10579,10491,10676,10681,10402,10730,10436,10731,10874,3889,7986,7987,10384,10382,6752,6760,6759,6916,6926,10417,6754,10423,10381,6920,7055,858,860,10488,8156,863,6920,10812,6919,10423,11091,6916,6918,6753,6760,6913,8882,10813,857,6762,11101,6761,10390,10387,10389,8983,8982,6914,10489,10167,368,7977,6762,11101,9829,6919,10386,6762,857,4435,9863,4716,1993,7079,7111,7294,7124,2706,1398,7270,3891,3892,7295,7291,4178,7082,3884,446,7281,7666,5066,7286,8205,8085,8078,1257,1215,5995,7154,1656,8438,7548,8223,8306,8208,3895,3888,3894,7987,7986,7967,8390,4639,223,223,8412,7985,7160,7967,8358,6740,7238,8220,2117,2117,4701,4801,8409,5602,5602,7251,8204,7089,7076,3884,8547,1371,7243,7971,7249,7702,8164,8166,8167,9735,9176,9165,9300,9745,9873,9874,9030,7897,9875,9744,6382,9876,8654,8989,7198,7195,7199,9877,7162,9878,9879,8451,10056,10056,10056,10056,6763,7194,7194,9172,10026,9302,10264,10272,9581,9132,9133,7190,9619,9620,7196,10185,8208,8656,9748,9622,9621,9746,9747,10887,9177,10390,10421,10419,11059,10881,10833,8267,7245,6388,10947,8469,8470,7671,11187,7268,10051,10575,10575,7665,7703,8585,10891,8468,10888,9378,8413,8383,11713,11587,9738,9259,10623,10630,10384,6919,6926,6754,6759,6925,6762,10486,10487,11045,11022) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC