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,397,271,233,4362,6191,967,784,3036,6234,3997,5508,6427,6474,6426,6381,6388,233,6375,6390,6391,858,6191,6527,6146,6152,6377,6517,6151,6144,6750,6388,673,653,275,6607,6191,6381,4614,7018,323,394,8307,8584,6270,6531,6529,7610,7870,7697,6652,6216,5691,6528,7695,7868,7696,3442,1704,7693,6654,8719,7189,8586,7546,4302,8897,8618,3515,8682,1770,2783,8896,6197,8728,7188,6023,1765,7187,7568,7567,7569,7570,7762,5719,397,714,6798,6390,713,6381,377,3036,6082,386,392,6381,3841,382,323,4906,388,372,6380,374,2701,2474,7238,3860,378,4199,6740,3933,6809,7833,8215,7903,1984,5995,4878,2992,1163,341,1906,6122,6493,3897,176,2157,3337,3897,6582,6140,864,6583,6752,6780,397,6883,6493,388,6204,5956,1121,6986,2780,2785,6491,6489,1245,860,6546,2696,2917,4426,6600,566,4490,1210,466,4752,4788,6719,3564,6539,541,6985,313,6200,6199,4121,4029,6201,6198,1533,550,801,1207,4788,28,8316,8313,8338,8333,8328,8341,8342,8317,8339,8325,8314,8324,8340,8335,1245,3883,3892,3889,3890,1770,1767,4301,4286,7180,7184,7698,6223,4219,6902,8252,8873,8340,8649,8872,6390,323,8665,324,8787,8785,375,8788,388,8786,6270,382,391,394,9111,9114,365,8858,3719,382,365,1245,6381,6743,323,6388,5386,388,6656,3515,858,6503,7107,5909,7654,7654,7713,7072,7155,7105,7644,7650,6796,380,7020,726,1250,1165,979,8085,4490,391,6066,384,377,6082,382,374,544,573,528,539,548,525,549,272,6381,6066,393,386,6082,6742,6796,6204,6220,6533,4146,372,375,673,6750,6751,6744,6749,6745,365,6270,387,378,376,389,6076,381,368,388,388,391,6066,384,386,6082,6082,390,6750,6751,6751,3882,6197,6743,9088,8984,9176,9089,6377,6367,5269,9087,6386,9174,8857,3926,860,9233,8788,8899,8987,7190,7194,9137,9172,8982,6794,6189,1738,5877,6971,7240,3277,1057,6145,2530,3131,3754,6563,6350,6596,2477,2571,4834,4769,6578,6727,1707,4422,9112,8873,4437,9111,8872,9113,4860,8649,8872,9049,4920,7299,9195,546,979,380,528,532,9,542,553,539,538,525,8761,3884,3875,6359,3892,3891,5602,543,573,2328,6493,8272,6593,3893,10638,3896,10645,10637,3887,524,10647,6042,9137,3891,544,3894,10646,7704,8566,7966,275,6743,858,6751,7680,6920,10812,6919,10423,11091,6916,6918,6753,6760,6913,8882,10813,857,6762,11101,6761,10390,10387,10389,8983,8982,6914,10489,10167,368,10457,10601,6917,5508,860,858,6919,6920,857,6913,6918,6753,10384,6919,6917,10384,6753,10387,10423) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC