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,6364,501,470,1098,6572,4510,744,6562,467,1474,2571,4796,1568,2331,2033,423,645,5454,2457,6574,6571,6576,4126,4019,5089,5112,261,5623,1487,6644,6767,322,466,6766,511,360,215,1160,1441,5143,2912,3590,6539,6544,444,652,955,1561,1834,6040,6542,1371,1070,6660,5719,6030,3302,1439,1645,525,550,601,933,1589,2390,1070,3264,5848,3557,3828,808,3302,5305,5552,4218,529,3610,3392,4454,3048,3803,1928,1927,6950,6122,5915,6350,713,5256,6725,3754,663,1200,1313,358,6169,6162,2576,6588,6590,1000,1453,725,6159,3216,6645,6168,510,1250,6160,4512,2997,2873,2170,4038,2723,2934,1444,2573,6772,3850,6660,1110,447,1277,6852,2654,6643,5552,2576,1313,2685,463,3825,231,4982,3217,3447,5735,2518,1277,7003,802,2698,6999,1915,5371,4219,6990,7051,2469,5631,2592,6562,2685,7222,7221,1822,943,6397,341,3778,1829,3181,6993,3843,4126,396,6122,2590,7304,3195,6172,1568,308,1127,6590,1453,6104,1647,2299,6950,1432,7858,3447,7784,7865,7803,6998,7864,6853,836,6793,6001,6942,1313,2390,7991,1200,5339,6677,6350,231,1228,3610,6856,3657,5091,3521,3522,5305,5421,933,7130,6168,6160,7023,358,6169,341,6811,675,6904,5994,1327,2869,5572,3070,725,470,645,4008,6564,6565,6572,6575,1461,1593,6562,3797,4165,1092,744,6568,3645,7063,6998,467,7119,7095,4164,1600,6521,4423,7089,7093,4964,6527,1474,7121,6522,1098,6504,6735,7115,6576,7115,6902,7125,7029,6503,6901,7047,6523,6996,7223,7235,7001,7029,1460,2456,7233,6675,3418,7013,652,2917,2696,7112,2956,1425,7249,7276,341,3447,943,1869,7231,3760,2446,3454,7234,2456,2454,3610,1893,1765,944,7034,2151,1829,7089,2974,6588,7272,7271,6168,7272,6350,7271,7273,3417,7296,2334,6530,2671,7280,2653,5371,6365,7241,6676,7258,6993,7057,7106,397,4021,6678,6726,6518,6512,6371,726,6528,6530,6529,6531,7691,7689,4305,860,7692,650,7686,7699,7681,4224,6530,313,810,7753,272,7275,5066,7844,3784,7661,7670,7602,7662,7108,7084,7265,7268,7170,7168,7599,1771,1767,1207,1769,1765,1768,6669,808,6588,358,6189,5915,6122,2677,319,1425,3860,463,6168,6172,344,2183,3217,3264,3557,3828,6075,1586,661,7033,1318,1407,7117,7117,7307,2183,6223,2824,6212,344,3828,6167,2795,2164,1765,1770,1767,1771,1768,1769,4944,4936,4941,4945,4943,4940,4942,4939,6658,6644,319,663,2808,4938,6215,7551,6501,6216,7258,8062,5995,2491,3069,2658,6272,3384,5295,4795,1656,3385,2491,3401,5717,5175,6118,952,6103,3184,2998,2696,6453,5996,6474,6472,6460,6465,6475,6740,6468,222,156,6800,6390,6873,7104,2946,2453,7639,7938,7595,665,8281,7239,5545,7773,6493,8558,7674,7846,8724,8700,6498,8740,8682,8583,7840,9109,9054,8240,435,8913,9249,9249,3850,7647,9529,9619,5512,8953,8953,1350,645,3370,975,1181,4160,2192,4423,396,3797,1738,455,734,1131,6192,744,5877,5362,766,4972,2674,5179,5764,4696,4861,2632,5247,1038,5764,2381,4730,1152,2882,4766,1057,1890,1439,1532,5543,2192,2331,2360,4240,3761,1042,4830,1835,1176,2657,5321,1177,7156,1826,1190,3062,3775,1461,6848,6780,1600,5321,467,1176,7761,5487,470,3059,1092,3590,3303,1098,4964,3844,5765,7019,1600,1416,4947,2261,1460,2760,3136,4164,5218,3493,4984,3830,4348,6981,6104,5995,7834,1522,1869,2639,7837,7995,7836,8150,8146,8135,8000,7354,8087,665,7919,1416,1038,3303,5764,3590,3989,5623,8183,2033,215,5179,3844,6824,219,243,261,360,3067,3303,3341,3415,341,3418,3482,3778,8150,3788,4217,4722,5306,5509,6827,7835,6632,8089,4652,3941,5362,1257,1253,1318,1432,1325,8306,6154,3368,446,3830,4337,6713,1349,5576,1521,6595,1532,4652,3761,4460,1461,1038,1690,6684,5545,5719,7708,1369,7920,4395,4131,7812,7138,7239,3542,7839,3941,4082,7783,4209,6117,4566,6793,7919,4258,4796,7020,8305,4983,7836,8222,308,5997,7821,7760,1347,5657,7803,8025,6849,8020,7835,6780,6156,7212,7147,6813,8923,8869,8890,4131,8925,8901,8900,8846,7839,4209,9054,8055,8080,7110,8044,665,7582,1253,6154,6315,6639,585,606,736,6674,8911,6942,6694,7712,1690,2025,2135,7602,8089,8306,6782,7138,3904,6863,4355,4220,8019,8615,8222,1461,9195,2590,7106,7096,223,5020,2933,6010,4023,7857,734,6785,6673,8025,7138,7005,7859,5286,228,3933,6792,4801,5148,5373,5349,5339,6901,8543,7837,7835,7834,7836,8441,9376,9073,9528,834,4900,4405,6875,5371,446,1766,1145,2261,1765,5995,6845,1769,4886,1520,5647,6552,7304,7019,7158,2029,906,6689,4144,3728,840,217,7359,344,5915,600,6365,2706,3216,6940,319,6740,4947,319,7837,6981,182,7879,7751,7834,215,1439,1257,7836,7835,7972,7974,2006,1038,7636,7919,6103,3059,233,4178,7605,4320,8250,7634,8222,4406,7833,7634,8304,1559,8343,961,8441,4338,7973,7374,7635,7846,8358,8611,4061,4566,228,4652,6986,7759,8629,4128,5046,4635,4656,3936,450,8730,1345,3100,10121,9936,10142,9321,2389,1250,6122,5848,5188,725,2157,6159,6177,6001,3850,1271,6189,186,6155,7878,7879,7594,6365,7146,7883,7882,3131,6644,6953,6366,7995,341,8150,8223,7938,3241,5995,5623,2151,1681,405,4234,6645,732,319,1110,1371,5764,3731,5247,1572,802,3368,4538,6861,5692,1536,6639,739,2419,3550,4796,219,6075,3396,3037,4217,5460,2698,5743,3159,3437,2381,922,6862,3754,322,4445,606,2590,5179,3698,1915,447,1313,1298,1688,3625,4199,2934,1038,3447,1647,2723,2298,2446,4861,1461,2863,2387,2944,3482,1576,2183,1159,1416,3396,3264,7709,5631,7036,2419,1830,2518,2653,3217,3558,943,955,7228,6124,3788,739,4801,2299,1575,6858,1522,7126,4722,2639,3989,3304,36,7003,5175,4021,5807,8306,4460,7221,5215,4194,5995,6740,7238,7283,7641,7238,834,1371,933,3302,2530,2183,2594,6842,8142,7635,567,1070,2632,8306,8306,223,2033,4861,5070,2932,2706,4860,766,5179,5148,7020,5799,7635,4109,567,4986,8617,8845,2889,5551,446,7634,8358,3216,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,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,3828,8343,8602,8601,7293,6075,8547,3264,8389,7080,1126,7985,4454,3557,8526,6645,528,545,7079,531,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,6521,6719,6761,864,5691,6527,1165,6522,6518,6538,6520,6218,4282,397,6985,6719,1767,1704,4298,1685,7576,1084,979,6656,3442,2951,6800,4121,6376,6768,4296,858,397,3875,4286,4289,1967,3863,4121,857,6985,5297,1411,735,8245,6521,6527,397,7201,7599,8243,6261,6512,8314,8318,8317,6359,8334,8320,3875,8582,4931,8249,8490,7365,3510,7751,8729,8694,8692,2779,7300,2828,5635,2783,2826,2827,8597,2815,4804,7180,7184,2803,2805,2806,2808,6222,8654,8655,8816,8696,6521,3828,6542,6381,344,8531,681,6376,8355,8353,9343,8874,9129,6444,6409,8698,2218,1266,6276,9041,8324,7721,810,2208,3337,6540,8882,382,1084,3327,9949,10037,10034,7721,10032,10263,7204,2169,7697,1704,7693,7840,10696,3327,8490,8507,10698,10579,6925,8156,1084,7721,7966,10983,6988,6922,582,6929,6925,11406,11407,10324,11677,10742,11427) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC