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,223,6190,4178,5068,233,2706,1371,840,1257,5995,4985,446,508,1152,6632,4185,3059,3714,5995,3913,1084,5322,576,6364,4701,2989,1379,5380,6528,4535,5609,4842,1724,3860,6855,1398,2951,2071,228,2627,5371,6740,2530,6792,510,1349,2389,4338,2766,2944,972,1245,6354,6849,6858,7238,2137,320,1095,2253,6644,1070,6732,5142,5134,5707,6730,5837,7304,1268,4983,4128,3701,6693,6857,6315,252,2253,4099,2244,5657,4401,6962,6364,7303,3046,1000,6190,3244,322,7239,5582,2467,7146,223,5582,7598,7600,1073,5602,464,6633,1029,7631,4079,4432,5678,6671,3595,3368,6740,7304,3957,6586,4762,7975,3351,24,2419,7019,223,7759,1653,6890,2117,6650,6861,1773,8010,1586,1774,3913,30,1774,7238,1774,7761,743,7872,743,1127,2118,3609,1127,7126,3609,4860,7126,2192,7547,7896,5327,2265,8809,6710,3429,3159,2265,7576,5536,6695,5536,6613,5536,6579,5435,5536,8220,1772,9000,1298,6861,6282,3957,9030,7977,7615,1159,3376,3327,8900,5188,7830,36,8284,9081,6858,7929,6832,9346,9346,6171,8103,8193,7640,2554,8193,6809,9811,6591,7138,6809,444,8827,9338,4320,7718,6713,8628,261,8628,5046,10342,8358,6981,8305,8195,8521,10056,7839,8140,7839,7304,8140,7614,3698,8915,7156,8915,11331,8617,1416,9604,6775,9803,8620,9476,1250,8620,9476,11491,6980,8927,9648,10734,10892,11703,8620,4056,11670,4639,4406,5995,7840,7775,8547,4405,223,3913,3878,3878,6953,3646,8306,7022,1215,9479,5763,8388,3957,450,450,450,10121,2749,961,2093,7218,7149,1537,435,5995,1257,3029,5770,6809,6740,7238,8514,8910,2932,8382,8377,1807,4346,3989,8683,8547,8547,8547,947,3549,5334,1371,4796,5148,6644,1439,6780,766,2706,1145,5421,4131,4860,1461,6986,2261,947,435,1398,6691,2023,2023,2023,4452,4765,4765,8684,1766,6509,6511,6514,6515,6538,6537,6536,6535,6505,6533,6532,7843,7592,6354,3070,3073,3071,6689,6688,8324,8323,9590,8325,9588,9589,9430,9601,9555,4100,4513,6595,1872,6102,566,7138,2590,1812,5544,7833,4131,2658,4983,7156,6635,2261,7016,8031,4220,2393,617,8442,7250,7250,7840,2761,7064,675,1487,3392,3803,5094,7069,8902,8900,8514,3957,4872,9036,7998,7654,8175,4510,3715,9220,9214,7985,2393,9278,9279,9049,6154,9258,9258,7563,7563,9406,9377,9444,9444,9527,9363,5545,7655,7655,7655,6774,6774,9614,6686,9730,9258,9800,9656,4800,4405,223,8816,5484,7708,7965,8354,6316,3732,3732,3732,6138,4923,8024,1307,1307,1307,1307,1307,2643,8137,6738,8250,8250,8250,5995,520,5098,4503,8108,7916,4920,4920,4920,7953,7953,7953,6606,6249,1954,9300,3860,6255,4234,8142,5995,4362,3860,4406,9321,4406,9321,2635,7953,2706,6259,1894,8222,7641,4325,3029,6618,3744,5484,1609,322,8434,8628,6256,5669,7635,5693,5854,2033,6252,4109,5799,1954,6248,1954,6248,5995,9125,7084,8648,5267,7982,8279,5872,4985,2029,4983,10061,7640,7249,9674,2261,7970,4566,10267,1142,8046,7374,10543,8209,10121,10547,10236,10674,8087,10814,10649,10269,10228,10978,10021,10976,9094,9762,10281,8069,576,10566,10609,5913,11127,11024,1371,10768,9926,6119,11201,8290,11200,2897,11344,3908,6103,10682,11272,11134,10404,11232,10505,7937,9083,8763,11376,8713,7670,11468,3646,11225,4086,8947,6774,1371,3531,5269,8613,7576,9951,6426,9394,397,2029,8938,10810,6631,10670,979,7300,2889,6365,10296,41,11019,7912,7870,10649,7631,8027,7840,11295,3327,2627,6693,7307,3830,4796,5236,455,464,4234,4128,4178,5279,6431,1453,6400,1537,3337,766,6195,4178,5995,6001,754,6587,5996,2158,6008,3644,223,4566,1343,6381,323,3860,397,2594,4656,6766,1826,975,6394,3964,6593,858,6986,990,3989,1591,6842,6947,6140,6941,6010,6985,1402,2261,766,5070,6349,6793,5882,1461,5331,6757,6779,6812,2374,6115,6631,6658,4099,4656,6779,6971,7003,217,6850,1029,2474,5530,2000,6951,1371,6996,958,5371,7019,675,3100,230,6312,7034,7148,6569,1917,6168,924,3595,6103,2915,3059,834,239,7226,4947,6813,3493,1461,4796,1558,1520,6141,836,850,3860,233,1785,1537,6431,6951,1776,6275,7739,182,2932,2000,6445,1084,5339,1521,3625,7156,4995,797,2446,1462,1779,1785,6400,3037,2387,2117,7761,4529,4659,8222,8232,8128,3542,1070,7897,4639,3521,7050,1490,2029,4079,7783,8097,4405,4834,4259,8558,1890,6818,2117,8518,8611,8109,6631,1349,8535,8388,8629,5552,4218,1811,3850,8793,7976,2737,8839,8852,7918,734,3823,3966,6667,1558,8305,6814,8889,7602,7147,8183,7307,7795,1772,186,1774,6715,3302,8684,933,4991,314,6366,8281,9340,5769,2009,6583,6438,8561,3519,3554,5305,8978,9344,9290,9197,6700,7903,6255,6552,9453,8781,7048,6631,3520,6642,344,9776,8089,3557,9776,4849,2390,4087,9248,5046,9922,2122,9900,9910,9661,7759,9776,9928,7825,9308,36,9986,7998,10229,9798,1303,10063,6113,2989,9449,5891,2170,8816,6641,10346,10280,9552,9538,8586,10001,9602,9916,10469,10127,576,10292,10500,10375,9513,2158,7173,10548,10526,10654,8956,10579,10652,10775,10652,10747,6562,10719,10894,10227,10297,10871,1765,1767,1771,1768,1769,1766,9154,9518,10670,6354,7922,3883,8272,779,10354,11041,10314,3073,6689,3071,8316,7557,8627,8088,11021,9037,7170,9945,7174,8241,9665,8333,8946,8244,10742,10924,10528,9665,7912,11239,5994,61,11104,10578,11364,10454,6371,6175,2467,6151,1738,4289,7741,5691,5904,6526,1462,6212,7913,6742,391,3885,4512,8700,5386,6953,2164,8388,2455,4701,8780,4769,9391,3515,1116,8247,8980,4424,6832,735,8896,2989,222,7178,6181,3036,223,8899,2389,8242,5567,7186,6444,961,6377,452,6523,9692,6652,8825,7189,9559,9631,7764,8279,8816,2778,9996,7762,7570,4437,9949,9970,9338,9792,9880,1245,7725,9763,9665,9616,1770,9950,9492,52,1765,7,9906,9951,1771,9480,9880,10219,6115,9424,3913,10102,10199,9835,5484,8432,450,10154,8257,8727,1250,9669,9782,2780,4701,10188,10110,7751,8151,4639,10155,7972,7973,9670,9892,10155,961,9671,9033,9131,8822,9672,9673,5175,576,9168,6119,9473,6003,1766,4500,5769,2605,4338,979,5678,10156,151,9473,4800,9720,3081,9722,4901,10281,2467,10071,8566,8967,10655,11097,10187,10991,11025,11116,11105,11135,10974,11104,9,4424,11052,11072,10554,9959,8173,10886,11092,6181,7205,2079,6820,8507,11306,10550,1774,7048,5531,4510,11118,11260,8970,10718,2169,11045,10483,11053,11279,11482,8565,8721,2056,11099,11449,10941,1887,10947,11283,11253,6267,6118,10133,8946,9846,3327,7888,961,11638,11886,10477,11622,10682,11328,9390,11908,1265,11853,3105,3081,6821,10886,11749,4580,11744,11603,9505,11854,7214,8303,11439,10211,12001,11676,788,2748,11776,11720,9062,11452,9649,2652,1272,2490,2490,2490,2490,2490,5380,4401,5371,10938,7953,3241,10228,8290,2555,2555,1993,10339,11380,10971,10825,4424,8050,28,28,7089,8211,7666,8055,8055,7106,389,8460,7261,8084,7266,7075,7241,7246,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,10022,1770,10212,3165,11452,9574,8087,2658,4395,3863,8524,11438,6730,10212,1257,4178,4178,5995,10518,8306,6712,7972,2989,2658,6894,2913,11468,6831,4405,4770,11195,10785,10294,7147,5827,8520,5255,6622,11364,11398,10892,10653,2847,10940,9889) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC