thisMySQL 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,7072,3897,3893,3883,7270,3885,3884,3895,7655,3882,3888,7094,7123,6740,3896,7987,7903,7088,8063,1770,1765,1771,1767,1769,1766,2183,4936,4944,4945,4941,4940,4943,4942,4939,4938,6644,6644,8081,539,8080,8384,8478,8288,7840,529,6493,7879,3894,7672,8273,7903,7019,7663,4801,8361,8306,4801,8306,8358,6971,2876,3828,8343,8602,8601,7293,6075,8547,3264,8389,7080,1126,7985,4454,3557,8526,6645,528,545,7079,531,544,1461,553,8401,8793,546,524,4512,4046,344,215,8425,4316,4046,4316,4316,4046,5298,3913,6710,7253,7254,233,6809,8401,8425,7089,8438,8213,8909,8213,8909,8213,8909,9055,9794,9741,9054,6104,9358,9829,9880,9361,3511,3510,3511,3510,3511,3510,7252,9608,9594,5576,9610,2869,9611,834,8229,9609,8832,3510,2473,2530,446,8306,7903,8290,8579,1359,867,1772,1772,7505,7977,7505,7977,7505,7977,7505,7977,6214,4299,4293,4287,5718,1616,4291,1770,9951,4300,4289,7173,7170,858,10505,10526,10527,6197,10522,10534,10436,10502,9632,6499,6220,10296,9838,6200,10563,9631,10440,6199,10438,3883,4804,7762,7567,313,2696,272,9892,9493,10612,10045,4769,10645,10643,10640,10536,8717,5769,10644,10607,10641,1153,10639,5068,7570,10637,10335,4614,6010,4224,6332,10552,10647,3884,10677,7764,10339,10486,10371,2005,10424,10161,6752,9829,10444,7917,10208,10579,10290,10515,7600,10696,10797,10750,9523,10821,10796,9903,10794,10795,10793,4144,10790,10239,1351,10678,7894,10649,7888,8563,9882,9192,10695,10382,5718,6961,6926,8156,11091,5508,6762,6761,6759,10487,6926,6761,6760,6915,6920,6753) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC