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,524,525,526,548,539,537,528,573,544,541,538,3221,3220,4437,5770,5068,6844,1462,543,553,6042,536,542,7046,6740,3863,3864,6212,6212,8207,8207,6539,7713,7713,8034,8034,553,3891,524,542,533,3890,3890,6493,8383,8207,8395,7840,8109,7879,7879,7878,7878,6726,501,3989,8947,4735,9055,7115,1371,8047,9032,5148,8770,8770,9134,9321,8048,9186,6842,549,526,548,535,546,6042,536,545,537,540,542,543,551,533,553,532,524,525,528,3882,549,545,537,546,541,6042,532,538,1521,3715,5373,6695,6986,1253,4659,231,1016,36,6001,1559,5719,311,6780,7354,228,4716,6740,540,529,528,538,539,573,553,526,525,544,524,537,532,542,543,554,533,551,2324,536,9016,7251,9543,9543,542,535,1215,536,548,539,4769,573,538,532,2520,156,156,537,5262,7390,7238,7671,7647,3875,6163,6163,6809,553,547,524,6042,529,549,533,543,532,545,528,550,548,1645,547,7849,3865,4931,6798,551,510,6491,3071,7676,1324,2374,1732,8003,532,546,1807,3883,3892,7045,6303,545,524,8338,8342,8247,528,3220,6270,539,381,1198,553,544,551,526,392,385,6523,7238,546,6658,857,5742,5733,4716,4437,2041,3863,550,8220,6381,553,7539,529,7149,8440,532,539,323,313,397,860,6386,549,8542,5853,6769,526,7704,538,528,525,7704,5853,540,551,864,544,1730,545,543,391,535,541,387,536,382,1271,4769,376,524,377,365,376,374,6270,384,2856,8787,368,6066,6082,385,394,6197,8858,372,6076,317,3913,317,3913,6382,6523,8165,375,6526,8496,3879,7588,8989,8530,8163,8160,1380,3823,6854,6391,8159,8157,7300,7605,4701,8785,6144,6784,9437,9435,8244,9438,8340,3879,8699,8874,5770,8316,9146,9414,9409,8700,8245,9436,9425,9408,9184,8883,8329,8247,9182,9415,8332,8318,8324,8326,8319,8241,9592,9183,9428,8248,9431,9894,9150,9143,9534,9190,9908,10045,6768,9300,7632,9154,6396,4501,10056,9792,9891,9155,9156,9217,10202,9156,10198,9854,9217,9502,10193,9502,10193,10197,10195,9147,8333,8335,10099,10102,9151,8330,10218,10147,10333,10322,10323,10217,9412,10102,10336,10332,10334,10101,10331,10100,10324,10140,9433,10213,3885,7143,7143,538,546,529,6621,543,533,544,7833,547,520,7976,541,528,6042,532,536,573,6646,7966,6610,550,7815,4607,4906,524,553,4716,540,1726,6394,8081,8080,7270,546,525,9132,9132,548,8917,8447,7576,7576,7576,10169,3893,543,528,538,8425,788,2023,7174,551,540,8404,532,6382,546,541,553,545,544,536,533,6493,542,6031,550,548,8212,8240,8529,7985,8771,547,391,2218,8832,2521,537,526,3881,3894,535,6204,6042,3889,7833,539,7816,8917,529,6788,2573,8274,8271,6650,6880,8273,8462,2521,546,2843,7815,529,542,3883,536,7075,7076,7666,4566,8839,7109,7118,8231,3908,7804,3829,9144,5732,9048,8716,9076,7175,573,3882,7647,540,526,7935,7150,7671,9132,3883,1557,2087,9744,9138,7642,7642,9794,9950,8365,8365,8365,7649,9875,10026,9797,7082,7599,6042,6740,4798,526,3849,3849,3849,7286,7286,528,541,8763,8763,553,540,543,1029,524,2776,2776,4510,4510,7385,7385,4788,7383,7383,7072,3897,3893,3883,7270,3885,3884,3895,7655,3882,3888,7094,7123,6740,3896,7987,7903,7088,8063,1770,1765,1771,1767,1769,1766,2183,8155,4936,4944,4945,4941,4940,4943,4942,4939,4938,6644,6644,8081,539,8080,8384,8478,8288,7840,529,6493,7879,3894,7672,8273,7903,7019,7663,4801,8361,8306,4801,8306,8358,6971,2876,3828,8343,8602,8601,7293,6075,8547,3264,8389,7080,1126,7985,4454,3557,8526,6645,528,545,7079,544,1461,553,8401,8793,546,524,4512,4046,344,215,8425,4316,4046,4316,4316,4046,5298,3913,6710,7253,7254,233,6809,8401,8425,7089,8438,8213,8909,8213,8909,8213,8909,9055,9794,9741,9054,6104,9726,9358,9829,9880,9361,3511,3510,3511,3510,3511,3510,7252,9608,9594,5576,9610,2869,9611,834,8229,9609,8832,3510,2473,2530,2632,7080,8055,8047,8033,8289,1645,3647,2992,6817,6366,2467,7795,2117,8027,7986,6870,7987,8272,553,524,526,545,540,536,528,543,544,551,537,533,550,6042,541,548,573,549,538,535,546,539,547,529,532,542,525,377,381,6270,6750,372,545,374,374,544,551,2520,3890,3890,3891,3891,8877,385,387,391,6391,3884,6493,3896,3895,3888,3894,3882,3888,3883,7261,8251,8368,7294,8366,8366,7661,7661,8434,8434,2555,3402,7747,2171,2643,3409,9095,8295,8241,8243,3898,3898,6596,536,545,549,524,547,3884,397,3890,9622,551,6139,553,1704,5454,3891,2520,2520,9612,7297,1084,6493,8242,546,6768,4512,9679,8945,9867,9665,8679,9439,510,10053,7772,7770,10232,7771,511,512,7637,7638,7596,535,549,548,541,542,538,540,539,537,536,543,533,532,529,10544,3719,10354,3115,8559,3559,9624,8705,7751,7972,507,2018,7973,9626,8704,8174,10646,9137,8174,9625,10642,5484,10647,10840,8155,8015,10228,10229,7695,1303,7693,8002,10251,653,10389,14,7702,7752,9589,10139,6688,9588,9429,10432,8946,653,9037,8627,10200,9383,3070,10199,9587,8290,8088,6212,9430,8945,8946,8325,8944,8323,7881,9593,2342,9181,10562,1771,10558,1770,10559,1768,1769,10201,10557,1766,8668,9215,8885,10556,10161,7696,8436,10560,6689,8324,10640,10641,9535,6600,8946,10638,10645,10726,8175,9631,10643,9632,3511,9493,7881,8945,8944,9665,10555,10336,10975,9679,8088,8946,8945,7881,9031,8727,9587,9430,7134,9867,4714,10544,11009,10975,8946,10940,1967,7869,2506,9985,8489,8662,10927,10926,11046,10929,538,539,10335,10930,7881,8946,5810,510,8489,9867,9679,10544,9665,6354,10975,8946,3071,735,2951,9378,4405,6441,554,7300,3073,9418,7024,8627,8088,6688,3883,573,3884,10228,10336,7985,549,550,6386,539,551,6784,9483,7987,10072,10649,1765,8971,1771,5839,1767,7704,7706,1765,9949,2605,1769,11028,3877,10607,1768,1766,10044,9502,2822,6489,10963,2779,2785,2786,2791,2778,3359,2799,8192,2816,2522,7698,6596,510,4146,10067,9633,10922,10923,10924,10433,11017) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC