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,801,4185,2179,5790,6181,788,2085,4683,6633,5209,2288,6240,3197,3169,2302,6175,6896,6832,3250,7154,7086,1271,7081,6890,6361,7297,7285,949,2113,3172,7572,5564,359,7589,4639,1185,7254,2775,7971,324,4684,6769,2266,1381,3732,7944,916,4765,6367,5691,8,5951,6817,2156,6129,6396,1886,3531,6561,6223,6497,6138,7775,6223,6841,1207,8151,8435,3070,3071,7881,3071,7753,8088,7881,8467,7660,7268,7084,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,7906,1439,7263,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,7261,8408,7150,7713,7900,8577,7297,7275,7597,8170,7653,7298,8092,1569,4019,8144,8772,8279,8456,8282,8206,8456,7733,7734,8071,8648,7641,8089,2989,7920,8358,7019,4652,7761,4639,9245,9557,9444,9329,9401,9443,9399,9400,9446,9447,9445,9398,9367,9448,9917,7661,9918,9926,9889,9759,9919,9542,1085,508,1371,6957,5956,582,582,582,582,176,1769,1769,6548,1662,1662,3598,8372,6139,6195,840,840,840,6963,10037,7773,1369,6584,6402,6069,1272,9376,8689,9405,6715,8389,5995,801,156,3236,7869,5795,3525,4913,5639,6311,9788,9497,9857,9951,4156,2453,9959,9778,9543,9637,9543,9637,9868,6010,9868,6010,9868,6010,5269,754,5269,754,3878,6173,10036,11660,8585,7870,10731,11714,10687,8586,7546,11493,5770,4503,8624,10579,8682,11658,8816,11673,11770,9920,11657,10868,11656,365,11716,8339,26,8885,11759,8,11306,9507,10331,10323,10326,10325,11677,10333,10279,10327,10330,11242,10324,9482,11241,10328,8880,381) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC