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,4178,858,6545,6840,6763,6764,6765,3090,6144,6761,6762,6759,6760,6840,6424,6752,6719,3609,6750,6742,6391,6746,6744,6749,6745,6911,6910,6914,6913,3926,6422,6758,6421,6935,6424,6425,6932,6938,6925,6926,6912,6427,6423,6763,6764,6988,6934,6937,6928,6758,6911,6757,6756,6391,3247,6917,6719,6763,6764,6765,6762,6761,6414,2282,6932,6754,6752,6423,6935,6759,6925,6760,6427,6757,6918,6912,2274,6910,6938,6423,6424,6926,2275,6426,2282,6756,6191,6911,6758,6763,6756,6932,6926,2274,6757,6935,2275,6423,2071,7743,6750,6742,6381,7386,7386,7877,8917,8917,8531,6938,6382,8168,2282,6385,6418,8203,7703,3247,6754,8055,8387,8401,7674,7069,8400,9609,7680,6754,2506,6752,7680,10423,7680,863,6920,10812,6919,10423,11091,6916,6918,6760,6913,8882,10813,857,6762,11101,6761,10390,10387,10389,8983,8982,6914,10489,10167,368,10457,10601,6917,5508,860,858,863,6919,6920,857,6913,6918,10384,6919,6917,10384,10387,10423,11342,6585,6544,533,783,7926,7391,7476,7459,7493,6429,860,9020,8980,367,6752,5508,6762,6761,6759,10487,6926,6761,6760,6915,6920,9726) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC