thisMySQL 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,5947,8471,7670,6870,8046,7665,8461,4566,4337,7599,8423,168,9134,9835,8742,8031,9950,9300,9910,9554,9749,4767,9984,3698,1738,3197,1210,7265,7111,734,7250,7249,7250,2261,7086,6785,7114,7077,7286,7239,3131,1461,6644,4405,7285,2360,7665,7658,7069,7641,4527,7115,6842,455,7283,7278,464,217,7878,7068,7655,7899,7020,7665,7671,8044,7939,7659,396,7102,7675,8087,4405,8393,4696,8046,4406,7684,7287,5763,7661,8033,2398,5131,2530,8063,8282,7879,7717,8389,842,8430,7089,8767,7085,8064,8282,2192,6646,1131,8394,1029,8770,7662,7917,8475,8397,8722,7112,1163,7660,8282,8398,5362,1057,7661,7662,217,5907,8391,7760,6808,1718,4653,2187,8537,3134,8055,7943,7657,9225,405,8426,8077,8418,7271,8472,8396,8067,8419,8368,8086,8712,8427,7285,7085,7280,8741,8206,8658,8282,7102,8711,8794,7931,7097,8740,8567,8891,7114,8742,8892,8052,8079,7655,7092,7281,9058,9059,8206,8891,9091,9140,9158,9160,9056,8467,9157,8045,9204,9205,8059,9247,9261,9148,9225,7248,9302,9262,9264,9313,9141,9138,8415,8768,9368,9367,9401,9443,9445,9400,7931,9529,9530,9133,9572,9132,8240,9577,9619,9621,9650,9622,9620,9370,3860,9662,7671,9660,8417,8644,9815,9816,9581,7291,7291,8361,8577,8449,7266,9205,7103,7103,8262,7291,7291,7291,7079,7273,9189,7111,7121,7084,8401,7286,7244,7280,7986,8395,7262,7109,7714,9314,8577,7713,9082,9623,9370,9199,9743,8772,7096,8086,8722,7671,8207,9793,8712,9446,8423,7251,8049,8034,9816,8766,8041,8791,8770,7275,8537,9819,9457,9818,9205,9508,8383,9738,10030,9560,9563,8439,10077,9053,8406,8386,9817,8767,8203,8085,9083,7715,10026,10186,9999,8394,10789,11631,11376,11045,11508,11555,9509,11654,8081,11746,8087,11712,8424,8740,8568,7268,7245,7088,10575,8413,8720,11367,11531,9057,11096,11692,11693,7264,9095,11668,11188,11189,8470,8383,11225,11332,7293,7087,7104,7269,7279,7108,7273,7116,7281,7119,7276,7154,7244,7289,6925,7703,7262,8395,7654,7071,7241,7241,8644,8425,8425,8576,8402,7599,7599,8400,1557,6388,6191,7106,8404,8401,7152,8576,6191,6151,8268,8085,9308,8407,8782,8782,9593,7666,7659,6928,9734,7655,6656,6656,7268,9816,11060,8439,8425,9057,9508,8462,8928,8081,9286,9995,9560,10449,9082,8444,7113,8459,9998,8794,8438,8207,8571,9370,10030,8740,8424,9530,8468,8427,10007,8086,7080,8063,8426,8720,7574,8205,10888,222,2387,3625,4362,1257,6104,223,5995,7083,7078,435,5251,1207,7143,7833,5371,1533,4784,4046,7966,4983,7751,7972,7972,7599,7973,7973,4791,7033,7033,5143,1439,2989,7261,8377,7659,8406,8406,7100,7644,7266,8288,7076,7091,8404,3327,3327,6609,6609,6616,6603,6603,6603,7655,8251,7089,10406,9793,7715,8791,8646,8412,8428,10851,8462,7077,8721,8206,8537,10615,3702,8475,6740,126,7265,8220,7265,8220,10449,8377,8413,7077,8429,7717,10029,10575,8639,8712,9816,8367,10617,8383,7262,7256,8394,7655,7944,8413,9442,8767,7264,10008,9960,10769,8767,10757,10617,11187,8773,10614,979,9049,9259,10854,10292,1662,10855,8577,8290,8628,9767,8782,7646,9508,6701,9072,10272,10400,10834,10891,8202,8922,7944,4607,7655,10399,11514,10625,11534,7655,11601,11602,5484,10292,4510,8303,4784,10039,9258,8949,7376,9007,7806,4557,7218,10000,10811,9649,1016,7505,6547,10768,9866,11373,11661,10687,11385,3582,9603,10836,10056,11402,10707,8517,6870,10187,10702) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC