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,8470,7656,8443,8444,8444,8072,8227,8268,8721,8723,7670,7670,7101,7241,7123,7123,8537,7672,8269,7664,7081,8740,8740,8424,8568,7292,7292,8040,8200,8203,8203,8228,8228,8459,7280,8445,9205,7112,8040,8050,8048,4683,7111,8036,8369,7123,8033,7675,8034,7278,7113,7118,7082,7649,7647,8378,8472,7261,7283,7265,7081,8792,8431,7574,8036,7287,8253,7266,7250,7572,8361,8429,8473,8385,7245,8452,8456,7105,8055,7244,8455,8444,8393,8768,8080,8446,7943,8769,8084,8414,8474,7069,8741,8998,7268,8461,8415,8743,7080,8712,8721,8474,8086,8722,8426,7111,9204,8908,8635,9207,9187,8045,7096,8366,8930,8641,7663,8070,7093,9225,8269,9201,8642,9139,7264,9148,7931,8652,7975,9444,9445,9447,9446,9398,9443,9400,9401,9446,7097,9560,8044,8058,9580,9203,8363,8642,8046,7262,9247,8470,9583,7266,7294,7253,4558,7152,7091,6962,7125,7095,7276,7707,3090,7123,7805,7665,7093,7296,7096,7671,7278,7271,7115,8048,8033,7280,7272,8412,8477,8645,8473,8709,7941,788,7291,7291,7124,8852,7083,7092,7106,8405,7103,8064,8393,8398,8354,8349,7068,7666,1558,8475,1667,9201,7244,8465,7088,7093,7099,6969,3926,8093,7109,3090,3926,6984,9574,9573,8208,8576,7666,8577,8412,8475,9148,7346,9745,9314,9076,9583,6719,8468,1990,9873,9470,9818,8644,9207,8410,9973,9956,7574,9055,9577,8574,8439,9956,9583,9583,9583,7096,7082,7112,7093,7294,7106,8049,7119,7087,7116,8211,8208,5996,8033,8209,8144,7664,7268,7072,7152,7273,8069,7117,8040,7266,8047,7897,7943,8077,8055,8061,8057,8085,8076,8081,8369,8370,8268,7258,7245,7659,8652,8050,8461,7574,8394,8463,7975,8465,8792,8476,8083,7114,8282,7273,7661,7662,8050,7124,7096,7943,8385,9160,8285,8652,8724,7293,5995,5279,9055,8462,8048,7731,8739,7293,8468) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC