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,6139,2882,5997,6155,1108,314,5908,6102,5256,2113,3037,4730,4766,6104,5995,2324,5247,5088,6829,931,4412,1825,5883,2156,6633,1052,4898,5962,6825,1038,6006,3358,6364,7878,4555,7276,2845,6741,8095,8064,7262,8022,4130,2594,8078,1010,8403,7719,4770,2182,8141,8306,1645,4728,4254,1257,4767,4233,8578,1559,5373,8722,8552,8289,8639,2989,8,3989,6154,7374,8841,8095,934,8587,8915,3262,5763,3297,8144,4337,8615,2381,7919,5837,8484,6907,8836,7904,5065,5066,7834,8580,7836,9058,4670,9305,9318,9269,9254,9333,9387,8220,5267,9421,9322,9365,9459,9509,9338,9479,9403,233,7928,6103,8628,4800,9366,9526,9641,9656,9763,9770,9028,9136,9527,9406,9798,6857,9648,9347,9634,9871,9930,9942,9750,9947,2985,9030,3479,9968,10008,9950,9935,6738,8776,10060,9978,10011,61,5477,3933,10061,10079,320,1268,1536,3162,3612,10108,10172,10128,2093,9951,9954,609,9439,9045,9032,7833,2137,10210,10228,9998,10221,1815,10303,1816,9214,9059,8891,3701,10354,10338,10307,10366,10375,9832,10351,8139,10482,9245,9807,8828,10523,10481,9373,2025,10615,585,3904,9043,10666,10648,5795,10258,6700,6548,10569,10244,10568,9904,8900,9831,8837,10548,8925,6713,10870,10880,10895,8888,8901,8902,10857,10767,9086,8089,10702,8800,10911,7828,10619,10620,10705,10621,10899,10142,10903,10935,7807,8970,3598,8613,3823,1988,1988,7861,6103,675,6831,3409,5947,169,6740,7238,8220,8220,7913,7913,8733,1380,8563,9338,9784,7874,9762,9846,9488,8302,9322,435,4784,6174,9951,4788,4788,1207,8885,5251,6752,9049,1425,8171,1198,10235,8171,1533,6691,2467,6691,2447,7396,2294,1253,5817,5545,5817,1347,4258,7883,608,1699,7126,7920,8999,9937,7849,10065,10292,5339,10065,5295,6691,6691,8171,10568,8111,6691,10296,10211,10671,1296,10664,7591,9812,2294,1253,850,414,850,414,6129,6129,6129,6129,6129,6129,9951,9386,9389,3282,9387,9959,2753,10041,8933,3878,10121,7131,7019,7904,10072,7761,9334,9967,10247,8554,9969,8995,9936,9931,9052,10297,9453,10375,9872,10394,10492,10353,10314,10395,10320,10396,10663,10495,9215,10518,10093,10505,9107,10712,9295,10894,10820,10974,10819,6527,7592,7554,1990,6687,10914,10971,7754,9193,10754,7640,10679,11201,10830,10548,10892,10649,10912,11226,10236,10145,11169,11348,11199,11234,11272,11388,10566,10234,10875,11436,10940,11266,10721,10537,7808,11291,11347,11446,10832,10041,11438,7374,10464,11551,11663,11741,11612,10328,10329,9120,9119,9431,10323,10647,11320,9433,9432,8316,10330,8649,8872,11407,11723,11386,11203,11677,11931,11523,11845,6800,11207,8154,11071,8585,11067,1645,2447,186,10142,9136,8962,1381,9296,9915,2847,4076,431,10219,1327,9959,126,1765,6510,6212,6530,6509,6223,6531,6511,6512,6529,6538,6537,6533,6515,6508,6535,5386,6528,6523,6514,6198,6200,6382,6390,6066,377,979,726,810,6513,1165,6223,1461,5995,5691,313,5996,7019,1038,3384,3385,3702,6872,7299,6364,3428,7239,1524,7761,2824,5691,1349,4136,6214,7149,7981,8031,6216,6496,1704,7608,7698,1767,1766,2989,7753,1769,1770,1765,5763,1771,1767,8178,8362,7890,4258,5362,7083,7973,1769,5142,5339,8548,8240,7919,7126,5817,5912,5817,6903,8716,8773,1016,8773,8805,8846,5763,8547,8900,2967,8900,8220,2023,1970,659,6205,5373,8716,1327,8902,6953,9086,9372,7804,7790,7584,9552,126,6629,7926,9348,9374,10000,9378,9639,9648,6163,9937,10146,10187,10065,9945,311,2913,9281,10350,10130,10416,10315,10212,10568,10115,9548,10528,10749,10895,7893,10904,8214,10667,10721,11025,10566,8871,7024,7077,10816,10210,10413,11197,11200,11034,11063,10787,10820,4901,10914,1576,11201,11347,11324,1886,958,11130,11402,11278,11488,11376,11117,10039,10494,10885,11115,10687,2266,11495,11449,11497,11455,4154,4520,11782,8937,8299,8144,8468,1385,11272,11234,10720,9277,11776,11187,11843,11840,7804,7893,11704,10269,9007,9757,10869,10854,7069,2989,8547,7149,4659,7115,7654,8306,7252,8092,7253,2117,9701,4563,2658,6264,9538,2761,2467,7940,5912,4399,8629,7946,4566,5193,5236,4656,6986,1327,8031,4061,4405,6560,6559,778,10060,9751,9758,9221,9750,7106,8395,10211,10233,7254,1349,10227,10237,9257,8391,10244,10236,9132,1521,8089,9353,7017,10245,10226,10315,9935,773,8777,10359,2261,10541,10550,10587,10567,10588,10586,2079,10666,7121,10524,7716,9870,10743,10807,9831,8211,7932,10820,10239,3542,5763,3715,7895,10976,7125,11021,11025,9259,7125,10977,7087,10904,7252,9900,10749,8047,10899,223,7265,10747,11126,10765,6845,11115,8030,6104,6870,11122,8741,2294,1253,5545,5339,1347,5817,3080,4258,7883,4460,608,2933,6858,7126,10246,10869,1699,1830,8500,8668,8206,4395,7920,7839,10350,10692,6832,10690,7280,11679,9206,10659,11540,9959,11558,11785,7792,11402,11496,7778,9889,10949,10366,10585,11528,8891,10702,11704,8477,10027,10863,10212,8892,8610,11918,11573,9204,10591,9055,5567,5602,9103,4405) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC