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,7078,1511,7456,7421,7563,7421,7506,7493,7560,7385,7496,8865,7155,7150,7105,7650,7650,7646,7646,7647,7647,7104,7118,7118,7642,7291,7291,7246,7096,7270,5853,7406,7443,7406,7472,7456,7070,7642,7648,7645,7652,3874,7298,7674,2635,8048,8047,6003,906,6691,7406,2795,7076,7248,7270,3874,4682,7297,7642,6261,5995,7967,4337,6364,4022,7012,6315,1215,1215,802,7266,7967,7252,231,7075,7246,1257,7666,3860,5996,6714,7473,7096,446,8412,7270,6728,3341,7967,7083,7270,7075,7151,8741,3760,8409,8395,8064,8407,8820,7294,7264,4079,4769,10116,7105,7272,7107,7121,7288,7282,7282,7967,7272,7275,8363,7155,7032,8240,8474,7298,7298,8395,7671,8384,8736,8386,8386,8771,8034,8083,7112,8792,8443,7574,8033,8253,8047,8082,8040,9259,8048,3254,377,7304,7643,3891,7251,3896,7076,6382,7092,323,3581,1557,6984,3076,6396,6962,8881,5718,7109,8228,8439,7107,7150,7104,7150,7118,7297,7099,7155,7105,7107,7246,7103,7298,7151,7118,7083,7107,7094,7650,7671,7298,7297,7671,8240,8450,7649,7715,7650,7654,7291,8961,8269,4224,8645,9032,7935,8048,8064,8430,7115,8450,9189,9148,9132,9132,7671,7671,7666,8240,5995,2294,3725,7280,7118,5066,7648,7671,6905,8449,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,7263,7675,7675,8049,7089,6385,7300,7106,7069,7276,7125,7117,7117,7117,1927,6656,7116,7295,7151,7105,7246,8365,8070,7096,9081,8064,7081,7102,8798,7252,7253,4752,7644,7643,8080,8080,8080,7104,7124,7648,8081,7261,7088,7088,7088,7658,7286,7975,8041,8041,8574,8713,7078,7261,7150,7077,7109,7655,7099,7155,8832,7295,7661,7662,8771,8771,7111,9542,9578,26,6768,2555,7258,7115,1988,6578,7551,1296,6984,1085,9469,9467,9784,3169,9633,9847,9524,9845,9494,8200,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,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,6354,3070,3073,8727,9679,8946,3071,6688,9665,10053,510,7772,7770,10544,7753,7637,8816,8730,7813,8088,10367,1895,8681,8698,8817,7751,7972,7973,9129,8815,10463,8780,9720,9215,10643,10544,8815,9720,9722,730,8172,9074,223,8933,9721,6953,8306,9492,5995,9281,10868) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC