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,2594,3913,6971,5915,8519,6809,9069,9071,8661,3989,8841,7995,501,9185,2261,8547,3830,2487,5179,5070,766,1453,6350,6162,6588,5996,2576,4218,1181,5091,8143,6122,7995,6941,7840,7787,7879,6726,7548,8032,6971,5362,5362,1313,8093,9047,9092,9074,9085,7795,8903,8526,8836,8230,1181,9321,1057,396,8093,9420,9386,9990,7130,9916,6575,6855,2029,6768,714,6768,6733,7140,7144,6367,1537,7304,850,2024,445,587,317,6003,7118,7246,4923,3864,7915,8349,7245,7286,7666,7806,8614,1782,8745,2712,3073,8951,2522,5995,7164,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,8914,8833,8869,7897,8781,8960,4395,5602,8512,8841,8232,7359,3957,4701,7303,7026,4995,576,4185,5542,5906,2889,254,5247,5322,3216,5837,6315,320,5331,6796,3026,464,6700,6866,5331,1462,508,6121,1230,924,4218,5994,922,6364,6382,5956,3542,6130,1645,7304,5996,5909,3037,4109,567,4834,1557,5088,6891,1325,4450,405,2117,1998,421,324,4029,7547,7143,4690,2729,4432,3054,5763,5735,4986,450,4320,4659,4722,2246,6809,7834,5904,1073,8093,7592,7837,7835,7836,1461,8103,8151,7907,6828,4765,3549,7910,7359,637,3014,501,6838,5602,1327,7919,8092,3872,4901,3904,358,435,4056,1119,1121,7861,1215,4983,1029,7812,7783,8617,4731,8629,8793,8745,6642,8555,8837,8836,8869,4566,8919,8840,7037,1461,4730,6397,4950,36,768,8169,9030,9075,9073,8933,9074,9072,9164,9163,8841,9096,9072,9074,9216,9244,9243,9242,7815,4395,8441,5088,5236,9281,7899,9344,2253,6310,5046,4061,6986,1038,4339,2847,8839,8031,8547,7559,9460,9456,9459,9464,9455,9454,7354,7587,6713,3261,6782,8089,2882,1516,504,9497,7833,9479,9546,9757,9647,9463,9814,9635,2989,7804,8970,9810,5881,5885,7548,7873,6842,8280,8291,8818,9038,9334,9614,5915,7140,3395,9345,8978,10004,8504,9990,9637,9888,9897,9910,10113,9900,10114,6002,6981,9967,9603,10046,2446,9753,9788,409,9319,10039,9828,10064,9558,10060,10088,10182,10087,10261,9987,1385,10109,10104,10260,10267,9354,10237,10358,9769,10258,10183,1142,9180,9185,9299,9506,9801,10063,10259,9389,10229,8910,9406,9275,10210,10528,10121,10547,10549,10297,10343,10364,10380,10320,10319,10318,10564,10699,9959,10090,10480,10187,9919,10820,10700,10471,10505,10741,10847,10569,7131,10655,10668,10712,10977,10967,10972,10893,10702,10935,10679,10538,10119,11044,11090,11041,10971,10416,10715,10719,11021,9336,11103,11104,11042,9615,10174,9969,10440,10780,10785,10737,11106,10754,10734,9617,10778,11028,10749,11129,11135,11162,11163,11134,11089,11237,10536,10842,11126,10876,11258,11230,10261,10875,10878,10865,10086,11282,11220,11272,11315,11339,3493,11372,11382,11361,11121,11397,11234,11127,11446,11450,11381,11131,11386,11271,10236,5795,10837,11487,11423,11213,11377,11359,10938,11621,11551,11606,11379,11612,11703,11698,11646,11724,11440,11230,10663,11593,9896,11800,11669,11678,11850,11872,11363,7144,11838,11748,9420,10020,7938,9913,9879,7221,9772,665,6852,9987,10141,3850,9130,8912,8842,10286,10285,10439,8781,9938,8514,9467,10543,10543,9897,9897,41,41,4405,8781,7640,9603,9951,5810,8489,10466,10032,10305,8292,8659,10436,9467,10515,10542,5769,6843,8690,10649,10742,10533,8781,7791,6278,10534,3327,7916,1296,5435,10010,7194,5389,1993,9863,4302,11028,4301,11228,10751,4297,4286,8816,4305,9257,4294,9483,9258,11085,2998,4639,4296,4287,10764,3913,11082,10672,6354,8933,3070,8681,3073,11439,3071,11438,6689,7753,10039,11476,7752,11324,8088,173,8627,10236,9037,10053,11477,9665,11101,10892,9037,9665,8816,11658,10053,10975,10544,11221,11359,2989,9383,3327,6616,3898,4199,4512,9116,11822,510,4316,10893,8489,10526,10649,10758,9349,9950,8541,8765,2009,7910,10937,8973,11134,7144,8171,11120,9031,9838,9005,10500,7869,10702,186,9198,10314,8828,9951,6771,8816,11325,11283,11303,8922,11289,10875,3523,11351,11409,8434,11296,11167,11238,11247,11448,4076,9864,11213,10751,10533,10535,5782,11301,11294,9915,11121,11608,10056,10724,10951,1969,11742,5402,10531,11768,9972,2389,11497,9985,3254,11809,8745,11304,324,4659,10966,11051,11238,10302,11101) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC