thisMySQL 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,458,6177,4218,714,408,1084,6349,6642,1881,6710,6741,5953,4765,6709,5949,931,6779,186,867,4597,2520,6789,579,5093,431,6813,6986,4898,5923,6561,6832,6622,6348,7019,452,5769,850,6842,2458,1616,2490,7239,405,698,1151,617,3395,3046,739,5088,5647,6004,6804,7359,3609,7547,1308,6193,7374,7759,1461,7760,7776,7872,431,7899,6312,7790,7889,7908,8031,7871,8103,7907,1265,698,7889,2521,8110,8222,8214,7962,7953,8183,8388,8195,8182,5455,446,1815,8483,8547,8358,7547,8390,7022,961,8629,8611,8725,8765,2006,2029,8793,7128,1052,8835,2989,2310,6622,6115,6190,6193,7790,5998,2093,8947,8918,2156,9027,5484,244,9038,6130,3702,7832,3029,7906,2753,7160,6588,6157,6177,5420,4140,5908,7144,7088,8041,6740,6641,2029,7276,8384,6633,8082,6118,6349,7238,1516,7941,5582,7101,8049,6780,5884,7911,9139,7589,8305,6141,7634,7929,9611,9610,8947,8628,9235,9031,5908,1085,508,1371,6957,5956,176,1769,1769,6548,1662,1662,3598,8372,6139,1885,6195,840,840,840,6963,10037,6583,8764,5915,1699,6102,5995,6104,4395,5339,5817,4639,6364,5906,6103,5916,5688,1016,6713,4800,4827,3542,3625,3474,5764,4784,4087,6858,6691,6782,6829,3554,5175,5965,4424,1755,1764,104,3574,6951,576,609,2849,5763,4510,4087,4046,1345,6809,6979,2300,6731,458,6845,7358,5961,1988,3719,1993,7214,7019,3704,6795,7839,4224,7605,7890,3823,4774,7810,3908,4659,7920,2643,2658,8196,233,1511,1984,8548,7883,7216,8144,8031,8514,8089,2294,4258,222,2989,6006,7804,5252,1984,1458,1084,8999,8108,4452,1490,3492,1823,9028,9212,9213,9079,3712,8224,4613,4704,1300,2849,9116,4082,4136,9372,8559,2491,8358,5961,9258,9375,5636,207,8274,3890,3891,3893,539,542,3896,8271,3882,3892,3894,8273,3884,5567,9937,1253,2933,5545,4178,446,3889,9377,9799,9212,535,3244,6642,6891,4082,10000,6858,10228,539,10243,9438,9437,10181,10568,385,389,8858,8789,8515,2356,380,10354,8787,8005,4087,3401,3990,4613,8534,3474,9439,9214,9930,9648,10120,9680,9764,4046,4411,1490,4049,4050,1973,6738,9823,3493,6876,11027,10114,5175,11298,11020,11235,10674,6591,11339,5207,9243,11495,640,5732,2023,6023,2221,6034,8941,9405,7374,11359,984,11413,538,390,6066,540,532,528,11353,6894,5262,608,7810,6006,1740,3875,372,9053,6977,8220,7903,9029,6740,9300,7238,7833,7833,7143,8141,4544,7905,4503,7885,7666,7096,7118,7246,3863,5742,3334,1973,5717,2145,5733,6593,6814,3334,3338,7012,7238,3248,2069,1302,3402,3402,3402,1270,5770,5770,5806,5806,2643,2643,6815,2555,2384,2384,6865,6865,9324,6183,2635,9865,6484,9866,6642,6103,6642,6103,9392,5454,9392,5454,5995,6845,5454,7910,5454,7910,4769,4769,6648,6648,9968,9968,9968,9968,9968,10431,10382,8171,7304,8880,10056,7998,1772,1772,10233,10063,6134,9220,10079,6104,10473,10300,10397,10065,9290,10569,10050,10683,587,10472,10646,8517,9752,9984,2555,10739,10918,5858,2998,4923,8388,8388,3327,3327,10687,10339,10687,10339,11400,8388,11101,11327,10472,4923,9524,9865,1993,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,2876,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,6929,6925,11406,11407,10324,11677,10742,11427,9543,4639,7953,11661,11497,4788,11101,11631,11632,8087,11754,1755,9386,10394,4405,9936,993,7135,10505,2117,8947,9463,10339,10653,10649,7003,9536,10683,10518,10002,9900,10368,4769,5770,4801,7160,2521,2522,5647,10526,11266,8223,9116,5839,10368,10974,9983,10904,11443,11442,9669,9670,3849,3564,10719,11101,10316,10736,2164,3282,11657,11673,10093,11451,11659,11658,11660,10375,11714,11314,11681,11703,11494,9471,41,9897,11620,10886,11346,9868,9942,7027,11486,10840,8108,9338) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC