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,7032,5996,7118,6485,6438,7390,1783,6303,7459,7505,7391,1461,4061,6631,7437,7389,778,1732,7467,4996,4999,5872,6619,1571,6275,4991,4991,6586,6715,6715,6715,3555,3555,3555,3555,3555,6295,6295,6295,3105,6402,6402,6402,6548,6400,6400,6400,6400,6400,2005,7120,7078,1511,7456,7421,7563,7421,7506,7560,7385,7496,8865,952,952,952,7110,7895,7566,7392,7265,7121,7152,7589,8047,8082,7675,7123,7071,7096,7088,8048,7068,8067,7117,8087,7069,8384,7125,7114,8040,7115,7116,8053,7249,585,7238,182,1145,4947,7124,7083,7122,7666,7115,7268,7115,7100,7094,7152,7246,7119,7072,6432,4399,7476,7476,7535,7420,7977,8514,8514,1770,1767,7642,4720,2627,6809,6718,3913,4146,1662,2520,7391,7391,2122,3874,7501,8290,7077,2520,6585,6544,533,783,7926,7391,7476,7459,6429,860,9020,8980,367,6753,6752,1268,6691,3941,778,2294,1776,5927,4996,4568,1774,7270,7217,7153,7374,4432,6584,6664,7285,322,7277,3455,5020,7842,1325,3162,7834,7261,7287,7287,7287,7287,7287,7287,7287,7287,8050,6270,6954,2029,1645,8063,6718,7834,698,7836,6349,6365,217,6620,7208,8938,7563,7563,9027,2520,8782,7654,8358,6980,9949,8864,6774,6715,6715,10208,10208,9,9,8299,1571,4996,1953,8830,1624,7837,1571,10891,9866,8047,5066,5056,10717,5064,5053,8108,8831,4544,6583,4399,6396,7917,6394,6402,9616,10731,1765,9949,7437,9090,8497,7388,7390,8389,4316,4512,7422,2520,6715,8290,1970,9361,6700,6383,7521,9020,9020,9020,7390,8864,8864,7048,8544,8303,7854,6547,9899,10696,10032,7708,9386,11101,4923,9976,11519,6854,653,10386,1990,3327,10940,10731,10731,5810,6966,4769,6715,10695) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC