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,6544,2894,840,2576,3029,186,176,6710,5887,1379,6383,7019,446,446,6408,2079,1788,2349,6738,7139,7149,7215,6006,5995,7605,3337,7213,7966,6183,7218,6003,6583,6131,7217,6368,6799,6102,7008,7008,4227,4227,1786,1786,7012,7012,5000,5000,7012,7505,7437,6138,5576,5331,4566,6639,5286,7138,4652,6845,7219,1029,3413,5420,417,7084,7100,7102,7068,7072,7116,7077,7069,7123,1398,1398,6663,6133,6310,1085,7096,7272,7106,7106,7269,7241,7114,7250,7076,7280,7275,7125,7122,1662,6004,6402,820,6700,7304,6801,7976,3184,6403,6803,7219,7491,7537,1499,659,659,7501,7501,7422,7422,7422,7472,7385,7385,7385,7385,7385,8211,9132,6348,8269,7656,9053,7660,7658,7091,9813,7077,8044,7661,8721,7662,7287,7238,6740,7903,1609,6623,8225,4598,969,7143,6172,1586,5371,6971,788,1085,8759,8611,1084,1085,1086,8763,5495,842,8757,7841,5914,3913,226,217,6806,3169,6195,6003,2079,6715,4248,7905,2643,6618,1609,3402,1604,2555,6619,4918,226,1662,8389,8434,9422,8449,445,7961,6592,9547,8019,7912,6879,6000,9042,8178,7897,7846,1563,7846,9759,9889,4338,7921,9879,9754,3874,4682,7120,7297,7642,6261,5995,7967,4337,6364,4022,7012,6315,1215,1215,802,7266,7967,7252,231,7075,7246,1257,7666,3860,5996,7473,7096,446,8412,7270,6728,3341,7967,7083,7270,7075,7151,8741,3760,8409,8395,8064,8407,8820,7120,7294,8185,5719,4178,8287,6003,7974,8361,8223,8390,8741,8390,7073,8771,8771,7713,6744,1742,7995,9085,8168,9096,9134,3702,8980,9204,6367,6700,8171,9128,6700,8526,8526,6402,6402,8612,4769,7711,8793,6691,8831,8831,8128,1296,1296,7974,7976,6609,10309,4923,7977,3957,6775,10248,10698,10438,2157) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC