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,6806,6805,3967,6354,6689,3531,524,525,526,548,539,537,528,573,544,541,531,538,4437,5770,5068,1462,543,553,6042,536,542,7046,6740,3863,3864,6212,6212,8207,8207,6539,7713,7713,8034,8034,553,3891,524,542,533,3890,3890,6493,8383,8207,8395,7840,8109,7879,7879,7878,7878,6726,501,3989,8947,9055,7115,1371,8047,9032,5148,8770,8770,9134,9321,8048,9186,6842,4671,4923,2417,5782,6578,1726,6794,1296,2729,1153,1988,6962,4920,5853,1973,317,1732,6003,1462,1380,4437,4437,2749,2749,1357,7134,5279,3702,834,3029,6715,5995,1492,6631,3029,4834,4437,7635,7953,1296,2635,4438,7995,7840,5782,1357,3863,5380,5567,5769,7641,4769,3823,2041,7879,567,6621,6843,5784,1526,6658,8358,1371,7840,8690,7962,7953,1153,3913,4405,6377,6743,6066,6371,6152,6190,6530,6506,5996,801,1537,3860,6869,6531,6989,6527,7239,6528,5770,6529,2635,8306,7846,8629,8695,2605,6261,7019,7019,7019,7019,8593,7024,9149,9149,2520,6359,5297,810,7632,5332,8719,8717,7599,1245,9424,8246,8318,6510,6511,6513,6514,7117,7650,7104,7150,2811,2789,2791,6010,7869,8109,501,1461,2658,6726,223,8358,6733,6190,3337,8485,6740,7238,8220,8514,4061,6690,8659,4401,322,1591,1070,4983,2145,3850,7546,2933,7904,6768,1917,2546,8512,3070,7840,1462,6394,6804,1215,1609,3719,8219,8298,6619,5887,1726,6619,8145,445,1609,6393,3913,6658,8355,8353,6817,7920,7833,6444,2294,1825,7888,6548,8793,6984,8887,8196,5858,5863,6578,6006,6631,3266) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC