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,5769,8266,3863,6151,7304,8866,2992,5516,7906,7572,1591,6102,3457,4769,8268,8202,8399,6264,8425,5994,4362,7280,4218,7897,358,7548,2399,6819,5380,4320,4320,7597,1371,156,8223,7281,7655,458,8947,461,4900,9292,5784,6578,7204,1380,8580,8404,9584,9582,9583,9585,8255,8255,9650,2913,2253,455,6843,7114,7547,8614,1492,7664,9737,7953,6719,2474,3875,1411,1266,1266,979,979,979,979,7968,8203,6377,7599,529,7654,7663,7076,6197,6197,6197,6197,6197,7094,7104,7068,7070,7124,7107,8212,6740,8085,7292,7292,8471,8471,7286,7261,7261,7150,7150,7079,7079,5053,5053,7643,7643,1126,2520,2520,28,28,28,28,8376,8376,8376,8167,5053,3380,5051,8517,1029,8306,6785,8151,7143,2729,8721,4983,8389,6155,7287,7089,7285,8399,8206,8447,8446,7268,8444,7766,7672,8425,7668,6123,6633,7112,8361,8141,8050,7273,9297,7835,9422,7834,8362,8639,36,8741,8055,9543,9275,7261,7096,7287,8640,8207,7245,7574,8059,7984,7941,7939,7940,7943,8061,8066,8253,9719,8475,7666,8643,8419,8202,8722,8427,10056,9444,7085,7249,8469,8086,8792,10008,9959,8431,8426,10089,10090,8468,10087,7585,10190,6821,6205,6907,8071,8741,8737,9658,6133,10002,7792,10088,10808,10815,126,10786,10777,9199,10855,10864,10836,10870,10876,10875,10807,7008,7785,3440,11095,11131,10583,10584,10494,10011,10854,8470,7656,8443,8444,8444,8072,8227,8268,8721,8466,8723,7670,7670,7101,7241,7123,7123,8537,7672,8269,7664,7081,8740,8740,8424,8568,7292,7292,8040,8203,8203,8228,8228,8459,7280,8445,9205,26,6768,2555,7258,7115,1988,6578,7551,1296,6984,1085,9469,9467,9784,3169,9633,9847,9524,9845,9494,8365,7642,9451,9843,9796,9846,8266,9995,9972,9665,9129,3071,9842,9350,9855,8203,314,9806,8228,7105,7104,7107,7103,6689,9854,9867,7155,9794,9580,9498,7070,9632,10238,10053,6242,9880,9622,9205,10176,7120,9563,10254,8450,10256,10095,4121,9134,8732,9621,1768,10232,9259,1616,9204,10077,7632,9539,8047,3358,10037,9933,7121,6898,6272,7111,3889,7125,5769,9529,6613,6582,8048,6579,7256,5051,8965,7119,9084,9578,8201,7152,7117,7116,8739,8053,993,9975,10510,10571,7895,9563,7675,10239,10544,10590,10612,10640,512,7087,10587,10659,10690,510,8824,10592,8770,9054,8644,9134,9563,9055,10586,8053,9055,9134,7088,7096,7086,8055,7106,7083,8034,7297,11212,11189,7243,8240,9622,11187,9746,11188,11196,7298,8499,9206,10588,9563,9620,8407,10272,10692,8438,8404,8208,10614,11150,8928,8236,10615,10689,10587,8410,9813,10869,7122,11108,8782,9609,9608,7668,7669,9611,10565,10328,10975,9610,7247,7672,11096,8573,9748,9900,6971,9879,9879,8781,9949,8877,8878,9755,8880,8880,7898,9537,9885,7304,9853,9890,1770,1770,10526,10526,8880,6845,6845,3029,6845,7297,6845,7297,7897,8498,7897,8498,10615,10614,10615,10614,8882,8371,8882,8371,10898,10579,9797,10858,10346,11215,10346,11215,6216,10240,4399,11069,6925,8154,6922,8002,8267,11067,10390,11071,9088,6800,6426,11068,8156,11182,11183,11184,4558,11181,8943,8944,6932,6354,3070,3073,3071,7881,8945,6689,6688,7753,8946,7752,8088,8627,9037,9665,10053,8946,6689,10544,10975,6768,11221,1303,6926,11355,11354,11356,11461,11357,4785,11082,9383,9867,11085,9473,10232,8203,9633,9632,8362,11357,11356,11109,6198,2779,6443,2806,6197,9669,6200,8693,4512,4316,8692,11581,8694,8656,8654,8696,8695,11578,8203,8655,4645,11579,3719,11582,3115,11580,11583,3559,11354,6520,11355,8203,11356,8656,11357,8696,8306,10331,1257,10332,5995,10328,10327,8241,9624,10326,8705,10323,507,11242,9626,10330,8704,11759,10333,8174,4046,10325,4512,11677,11320,11050,10326,10637,10646,7808,8943,10641,10645,8944,3894,11376,1685,11376,4301,11318,11376,7610,11181,11427,11375,11037,8586,11375,11268,9084,11179,4386,9407,9903,10811,11254,11297,7186,11418,9920,11251,7870,7188,10821,6200,9632,4463,11493,7267,10890,7546,11431,10565,11462,11192,8451,7182,11321,11016,10642,10639,11245,11218,7185,11320,10646,11463,10752,11422,9633,11191,11193,10643,10612,10644,7176,7172,11570,11650,11019,1557,11011,11032,11354,11723,11252,8362,735,6596,10502,8253,11183,7698,8885,8566,11697,11519,11797,8436,11176,3066,11099,11799,10877,11801) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC