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,7116,7278,7108,7092,7093,7084,7276,7282,7290,7247,7089,7086,7081,7117,7291,7102,7273,7076,7075,7249,7095,7245,7077,7272,7264,7281,7279,7119,7241,7108,7125,7112,7117,7271,7280,7262,7292,7121,7293,8060,7071,7278,7152,7247,8044,8066,7268,7106,8065,8069,7984,8051,8081,8071,7086,7125,7070,7672,7244,8381,8046,7106,7281,8268,7084,8084,7089,7082,8425,8400,7292,7088,7241,7280,7971,7092,8401,7943,7280,8201,7262,7119,7121,7272,7125,7278,7110,7245,7276,7125,7097,7106,7276,7249,7095,7119,1302,7117,7123,7089,7101,8053,7241,8048,8047,7936,8057,8055,7102,7096,7943,7574,8041,7243,8062,8045,7245,7068,7116,7659,8368,8040,8040,8202,8202,8202,8071,8429,9158,7110,7112,7668,7672,7241,7656,8269,7675,9206,7269,7269,8471,7101,7657,8082,8053,7081,7152,7152,8735,8735,8735,8735,8735,7095,7115,7270,7247,7100,7074,7153,7119,1198,2995,7152,3392,6659,4519,7102,7109,1533,5777,1145,7243,956,7092,7089,7266,466,7716,1885,7906,1439,7096,7249,7068,7154,7277,7106,7294,7110,7295,7268,7250,7281,7275,7093,7241,7666,7249,7265,7292,7088,374,7293,7125,7281,8408,8425,7288,8201,8220,7282,8577,8404,6138,7279,7080,2079,7280,8406,8400,6138,7704,8361,7266,1245,7264,6879,9302,7671,8782,7967,8034,8049,9289,4580,8402,8450,9581,9148,9315,9259,7092,8645,7089,431,6771,244,8398,9573,9039,9939,9630,8080,409,1740,6151,215,6152,5996,3263,3277,6719,6763,6764,4614,6656,7100,7072,7122,6612,6751,7091,7109,6744,7075,7294,653,6521,6388,6391,1746,2992,240,7087,7258,8087,7675,7675,8049,7089,6385,7300,7106,7069,7276,7125,7117,7117,7117,1927,7120,6656,7116,7295,7151,7105,7246,8365,8070,7096,9081,8064,7081,7102,8798,358,1453,236,6813,6104,6831,6366,3247,6645,6189,319,663,447,7124,7115,7063,7219,8047,7109,6774,6733,2029,6547,223,6795,6562,6575,1016,7110,7125,7087,7086,7088,7117,7123,7101,7116,7124,7079,7153,7069,7121,7258,7249,7106,7276,7074,7096,6712,7252,7247,7253,7084,7278,7272,7291,7096,7247,7275,7091,933,3302,7840,7878,7241,8056,5305,8070,7879,7937,7254,3860,7279,8055,7147,7289,7245,3698,7238,6740,7943,7913,7238,7097,7572,4216,2399,7280,7992,6559,8386,7270,3550,906,7932,3380,8670,6832,8471,8408,8087,714,8770,8053,8681,8736,7106,8698,8045,5098,6239,5435,6819,1616,2024,3384,8063,8473,3385,4555,8439,9578,7654,8402,1511,7279,272,7107,7280,7097,8066,7086,7096,8055,8065,7932,7077,7154,7931,8076,8087,7941,8064,7943,8053,8077,8208,8063,7081,7071,7121,8453,7106,7664,7115,7250,7250,7262,7656,7084,8450,7092,7671,1559,4217,4624,5148,3989,254,5516,585,6250,4220,3613,6255,1498,1439,2954,1073,1954,4005,1830,6117,5764,6635,3904,4046,4128,3368,6155,1113,1163,1681,1690,2915,1038,4050,4049,4045,4233,7262,7244,8206,8206,7661,7662,8063,8087,7099,7068,7284,7282,7264,7286,7288,7106,7268,7089,4209,6863,7984,7654,7108,7656,7660,7085,8230,8230,7152,7574,7100,6971,8058,7647,7082,7671,7671,6726,8066,7271,7271,7271,7117,7102,7121,7906,8576,7936,6740,6740,8574,8065,7091,7150,7125,8109,1371,7095,7572,7118,7108,3860,7967,6832,6832,7213,7897,7897,5996,5996,7661,7661,6523,389,5165,2992,8268,1537,7104,8055,7602,8033,7258,8087,8087,6388,7082,7252,7076,7079,7705,6521,6212,6223,7698,9781,9591,9592,6656,7844,9312,9590,6220,6497,6498,6222,6496,6216,6501,6215,6218,6221,6214,6499,1770,1765,1771,1767,1769,6750,7124,2992,1988,8580,6740,6740,9139,8743,8743,8415,8415,8050,7288,7288,7111,7111,7115,7115,7664,9401,8771,7113,7246,7117,7505,7505,9877,8460,9873,9874,9874,9856,9856,9821,9821,11515,11525,11525,9398) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC