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,5516,1425,1307,5915,446,4788,2451,5995,5371,1145,1681,1485,5719,6316,375,386,6082,377,7076,7094,7118,7072,7124,7113,7150,7109,254,1572,1981,6140,7286,7086,7115,7252,7647,7297,7297,7297,7297,585,7238,182,1145,4947,7124,7083,7122,7666,7115,7268,7115,7100,7094,7152,7119,7072,6432,4399,7493,7476,7476,7535,7420,7977,8514,8514,6575,6855,2029,6768,714,6768,6733,7140,7144,6367,1537,7304,850,2024,445,587,317,6003,7118,4923,3864,7915,8349,7245,7286,7666,7806,8614,1782,8745,2712,3073,8951,2522,5995,7164,9078,7833,9244,8048,6971,9055,9055,7976,1349,8146,9614,9541,9600,9327,9942,8900,10026,9220,10076,9134,9054,435,10614,10479,10319,10778,7118,7295,7100,7294,7082,7075,7076,7665,7647,7666,7109,7266,7124,7647,7122,7094,7092,7155,8063,7281,6832,446,7151,51,6178,8084,7083,8402,8212,7928,8042,7250,8404,8569,4178,8706,8408,7251,8576,8403,8208,8361,8083,8576,7671,8407,8365,8818,7270,8425,7153,8228,8942,7277,8939,8939,8832,8832,8782,1257,9189,8412,9138,7118,7647,4301,8395,365,7834,7812,7879,7836,7878,3131,3428,6521,7663,7764,7762,5091,7568,3520,7570,7569,1656,8071,1770,7151,6531,7650,7649,4301,4293,4289,4299,4286,4305,4287,4294,4292,7643,4302,7963,4297,4298,2766,800,5024,7079,1085,6103,6780,972,8300,5371,8531,1086,7599,3519,979,7906,8587,7568,6532,4804,8836,8814,1667,6306,8520,9038,8816,6618,9030,8092,801,7808,223,5148,2706,5996,2992,3860,4769,6188,1462,1453,6813,6588,7130,358,6001,7304,6856,1402,6812,5909,4801,6140,6122,7099,5915,840,8280,8473,2473,7833,7232,7232,7223,7297,7297,7987,9030,8547,51,7113,7665,7291,8080,8080,8080,7155,7120,7150,7105,7650,7650,7646,7646,7647,7647,7104,7118,7118,7642,7291,7291,7096,7270,7107,7150,7104,7150,7118,7120,7297,7099,7155,7105,7107,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,3874,4682,7120,7297,7642,6261,5995,7967,4337,6364,4022,7012,6315,1215,1215,802,7266,7967,7252,231,7075,1257,7666,3860,5996,6714,7473,7096,446,8412,7270,6728,3341,7967,7083,7270,7075,7151,8741,3760,8409,8395,8064,8407,8820,7120,7294,1145,6632,7580,6023,2677,7760,388,4563,7815,6986,2776,7599,272,6642,7605,637,7751,947,6871,6315,3803,7759,7972,7938,7354,4519,4558,7973,7837,1234,7834,7835,3189,5143,7836,5142,5251,8089,3066,8140,5936,8150,8111,5094,7920,4731,6713,8215,6691,8222,8193,5431,5536,8304,6810,7016,5817,1349,7005,2451,5947,4325,8390,7642,7105,3026,8281,840,8358,6732,8547,8514,320,6693,8305,3913,8548,1738,5763,6354,8816,6595,5334,8802,8213,6726,4652,665,8730,8839,6778,8910,4730,8885,7903,8629,8220,8932,4936,9049,3542,4944,1886,36,4945,4941,7126,4940,4943,1521,4942,3775,4460,4939,4938,3449,1176,9300,8478,5841,180,1177,2657,9466,4950,3080,1042,7772,510,7770,7771,511,512,7637,7592,7755,7756,7927,8509,9880,8999,7019,8222,8793,9195,9925,9552,177,178,179,10229,10292,10056,9461,10063,10227,9769,10528,10526,10548,10543,9406,10358,5756,6659,9533,9675,9879,10964,10836,9383,4834,9867,10232,10278,10938,254,9220,8904,11121,10626,9677,7928,8688,9196,8547,9636,11171,10397,10315,11219,6857,11439,11361,11324,11455,10748,9929,11397,10476,10149,10784,11396,7581,6117,9347,6731,9648,4536,2873,11374,6730,4329,6692,11416,4882,6776,6214,7151,7283,7078,7261,7118,2992,6212,1704,4289,4293,6880,7116,7096,7152,3830,7289,7245,7106,7272,7119,7117,8269,7097,2932,7296,7089,5148,7271,7906,7268,8056,4860,7572,8385,8395,7258,8086,7104,7151,8287,7276,7675,7115,7068,7094,7084,4796,7124,8282,8361,7107,7304,7943,2992,7714,3860,1537,8230,7646,8365,7118,8450,7083,7671,8058,8055,8473,7151,7295,7897,7647,8463,7675,7967,7107,8526,8109,7288,8903,7118,7663,7291,7666,7124,8365,7104,7096,8083,7277,7089,7155,7083,8739,8064,7083,7840,7878,7879,7104,7715,7099,7082,6110,7096,7278,7249,7107,8065,7110,8049,7094,5770,8070,7960,2635,6544,8452,8384,8381,8393,7931,7895,8406,6131,7105,7654,7247,8407,7112,8349,7124,8041,7266,7106,7261,7717,8084,7100,8461,8464,6968,8409,8407,7670,8408,8644,8641,8394,7277,8396,7153,8083,7266,8203,7251,7112,9053,7286,7666,8406,7258,8430,8404,8782,8473,8072,1343,2658,8683,9247,7082,8470,8644,8047,7085,9259,8034,8460,9225,8398,8462,7252,7095,9205,8832,8431,7943,7115,8475,7084,8395,8082,9573,9578,9579,7253,7272,8033,8473,8370,7589,8635,9204,7147,7655,7123,8066,7093,7076,7254,7280,5947,2934,5719,7708,8909,8053,10659,10586,8407,10675,10690,9386,11124,10573,10859,1990,10773,8781,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,7120,6656,7116,7295,7151,7105,8365,8070,7096,9081,8064,7081,7102,8798,1765,1769,6642,7661,7661,7756,524,7903,7903,7903,7903,7085,7089,7125,7081,7928,1089,8933,8071,8468,8446,8050,28,28,7089,8211,7666,8055,8055,7106,389,8460,7261,8084,7266,7075,7241,7713,7151,7665,7100,8395,7094,8065,7273,7096,4178,7109,7268,7268,7080,7654,7654,8034,7076,8438,9620,9611,9745,8401,9622,9746,9621,9748,9744,9719,9259,9675,9980,8358,5484,5602,5995,9258,8047,6539,681,10024,8450,9874,9956,9877,5053,9957,9876,3380,9148,7150,8450,7266,5995,840,4146,5419,1768,9820,9933,9933,3874,3874,5064,5064,5056,10272,4146,2253,2253,8449,8449,10024,9999,9878,9844,9747,8071,5376,5376,4512,7238,11225,11225,7110,4349,10022,1770,10212,3165,11452,9574,8087,2658,4395,3863,8524,11438,7714,8071,7713,8577,7280,8087,7079,8034,8067,7944,7243,7074,7092,6190,7280,7269,1242,7122,7113,7574,7091,7118,7109,8087,8909,7085,7572,7095,7666,7252,8401,7241,8213,8080,7245,7281,8384,7654,8452,8909,7251,8362,8208,7713,7243,8772,8736,8736,9133,7714,8782,9132,9622,9747,8395,9620,9621,8768,9610,9058,9059,8419,8087,8085,9611,7280,9205,7275,8240,8081,9458,9748,9876,9875,10029,10077,10030,10075,6750,7124,2992,1988,8580,6740,6740,9139,8743,8743,8415,8415,8050,7288,7288,7111,7111,7115,7115,7664,9401,8771,7113,7117,7263,7263,7505,7505,9877,8460,9873,9874,9874,9856,9856,9821,9821,11515,11525,11525,9398,6006,1740,3875,372,9053,6977,8220,7903,9029,6740,9300,7238,7833,7833,7143,8141,4544,7905,582,4503,7885,7666,7096,7118,8111,9747,8368,7292,8212,7069,9933,5052,5052,8743,9400,9205,9205,5066,5066,8885,7671,4019,10272,7653,9844,9048,8410,8071,9739,8404,130,10510,9563,8204,9539,5961,458,9399,9444,9148,8370,8651,8450,7277,9443,8637,6181,10623,9367,9056,8373,10026,2761,10029,9445,9447,9083,9719,8438,10095,7650,7388,7388,9148,7272,3874,7125,1993,9204,7110,9797,9563,7111,1398,6678,7270,7251,7251,1126,6595,6447,2849,7856,6595,7296,7856,3595,6795,7296,7904,7714,7879,7271,7101,8053,8058,8034,8076,8040,7119,7931,8046,7878,7548,6155,7946,8284,8209,6235,7273,8373,8418,7840,7878,7879,7115,8481,8573,5320,8220,7280,4878,5320,8720,7971,7275,7297,7971,8761,7298,8419,7670,182,8683,7761,7547,182,3895,2522,8682,8618,6936,6938,7675,8698,8739,8933,9030,7124,3080,8412,8908,8580,7103,7083,4258,2605,8847,9134,8358,6354,9336,9134,8042,9244,9329,3070,9322,3073,1349,4460,9071,7087,9449,7239,8064,8458,6514,6514,8405,6986,9312,8832,6700,9367,9093,9777,1381,3760,8436,4299,3541,4160,8681,9958,9874,4178,2253,6619,9143,7368,1770,1765,9932,10109,10087,9603,8724,7113,9603,7649,9200,10008,1767,1771,7692,7690,7686,3172,5837,8896,1609,4805,3071,3875,8220,7020,3590,1766,6740,1688,9963,3282,9769,10008,6828,1787,6642,7752,2261,8220,7973,7751,9146,2915,10379,2349,4847,4847,4728,675,1785,169,9951,9486,7368,5245,9951,9082,9026,8255,6658,9932,2474,8956,9009,3908,2337,9384,814,4330,7203,4234,7059,6624,9879,1357,7203,814,8856,8855,8761,1698,1308,1776,6030,3250,1766,9873,9833,3893,8793,1461,9344,6715,7235,2784,9893,6427,9052,9115,9052,4566,1165,7903,3380,1215,446,8942,7823,9824,10742,4535,10475,4535,10475,8742,10228,10965,6728,6700,8080,10737,3860,9676,8669,576,9496,10929,4947,7598,9547,6416,10422,10381,6764,10264,6751,544,6151,6763,8160,6493,7705,573,8158,9859,1664,7605,2605,10416,2270,10742,8394,5484,10356,7751,10789,11289,6776,5487,9368,9367,8323,4730,93,11268,10836,10056,9300,8082,10768,10767,11719,11781,8910,8514,10722,10722,11670,7895,10543,9406,11846,11686,11890,10702,11211,11772,7127,10664,8764,1766,10291,10292) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC