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,1453,6350,6162,6588,5996,2576,4218,1181,5091,6122,7995,6941,7840,7787,7879,6726,7548,8032,6971,5362,5362,1313,8093,9078,9047,9092,9074,9085,7795,8903,8526,8836,8230,1181,9321,1057,396,8093,9420,9386,9990,7130,9916,4079,7783,6740,7147,6177,3760,5996,7146,7812,7548,7602,8519,2573,2573,2473,2473,6633,1371,7863,7787,4834,4834,1029,6001,7878,7878,7878,6589,6589,6589,4990,1738,8196,4983,8292,8745,3159,223,8515,8223,6631,8547,5339,5729,5545,8802,1559,5817,1349,2023,6588,6371,7840,8489,6218,1738,6569,7674,7932,6377,8230,8585,7870,7086,7631,8586,7086,8719,8213,8583,5068,3702,3913,4563,8306,947,1215,8350,7160,3515,6715,7012,6971,6209,8400,5995,8220,7108,7108,7842,8063,7084,376,8354,8765,8765,5996,8387,8387,7975,8093,7714,3860,9010,8983,8371,8071,9056,8982,8878,9049,5371,6190,358,6833,6162,2635,52,6312,801,6843,3966,6794,6588,464,6644,6366,6135,6130,6168,6155,6177,6177,5881,2658,7238,7238,3262,2520,3550,6740,6349,7238,7238,8220,4597,6813,6725,7775,3395,714,714,6766,7783,7783,2029,4801,4801,217,4432,6667,1624,6593,7304,5331,6367,1653,6131,6439,4209,1571,4355,3904,6863,585,8195,8171,6691,4860,8781,176,1516,3892,9069,3989,8055,186,3896,186,3896,7287,7121,2063,5763,6845,4405,7084,7069,8084,7276,6223,6740,6223,6740,8109,8109,1327,7143,7143,1738,3582,6642,7837,7837,6103,6103,5799,4860,5995,5995,8109,3647,3647,2029,2029,7995,4395,4395,7037,7239,867,867,867,1645,2006,1215,2041,2041,6971,6971,8230,2729,2729,2729,3913,2992,9306,9976,9976,9976,9976,9976,2989,8547,8810,6904,2117,40,6870,9547,7218,417,5822,7597,4801,4985,4405,9460,6979,4563,6264,2467,2761,450,6205,9556,7926,6895,9926,4598,8482,9871,1327,9890,7974,2113,1662,452,8626,223,7890,5,7872,5,10060,9787,2658,8135,10267,5763,2644,124,8648,9553,4607,11025,10240,9546,10976,2032,1823,11127,217,10900,5262,8206,11256,8169,10986,10977,9557,8967,222,9046,130,10080,2200,3536,934,11621,10448,4144,7773,4860,7995,6971,9010,7143,8093,9468,9614,9354,9334,9629,9890,9525,9939,9814,8903,8109,8526) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC