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,4671,1462,6700,8710,9394,9030,8544,9481,9879,8801,9386,9386,9915,8922,9915,8922,228,10056,8048,8041,7261,9930,9929,9921,4798,7068,8071,8439,8368,9931,10244,10227,9817,4178,9543,10476,10149,9961,7086,8837,8793,446,9661,9195,5995,9160,7258,1349,11028,1350,9542,10063,2594,11021,11219,766,1215,6842,1257,2706,2033,2632,9453,2932,501,10375,4234,5148,3989,4796,5070,5799,10878,9648,9634,6117,8543,11838,1917,1461,9993,9661,11324,1145,6632,7580,6023,2677,7760,388,4563,7815,6986,2776,7599,272,6642,7605,637,7751,947,6871,6315,3803,7759,7972,7938,7354,4519,4558,7973,7837,1234,7834,7835,3189,5143,7836,5142,5251,8089,3066,8140,5936,8150,8111,5094,7920,4731,6713,8215,6691,8222,8193,5431,5536,8304,6810,7016,5817,1349,7005,2451,5947,4325,8390,7642,7105,3026,8281,840,8358,6732,8547,7246,8514,320,6693,8305,3913,8548,1738,5763,6354,8816,6595,5334,8802,8213,6726,4652,665,8730,8839,6778,8910,4730,8885,7903,8629,8220,8932,4936,9049,3542,4944,1886,36,4945,4941,7126,4940,4943,1521,4942,3775,4460,4939,4938,3449,1176,9300,8478,5841,180,1177,2657,9466,4950,3080,1042,7772,510,7770,7771,511,512,7637,7592,7755,7756,7927,8509,9880,8999,7019,8222,8793,9195,9925,9552,177,178,179,10229,10292,10056,10063,10227,9769,10528,10526,10548,10543,9406,10358,5756,6659,9533,9675,9879,10964,10836,9383,4834,9867,10232,10278,10938,254,9220,8904,11121,10626,9677,7928,8688,9196,8547,9636,11171,10397,10315,11219,6857,11439,11361,11324,11455,10748,9929,11397,10476,10149,10784,11396,7581,6117,9347,6731,9648,4536,2873,11374,6730,4329,6692,11416,4882,6776,7473,6721,9118,9118,9118,9118,9462,9462,207,207,207,207,207,3376,9615,9808,9750,9809,9807,9811,10300,6723,6722,6724,659,659,6720,4156,11235,10530,9050,2590,9348,6861,5,11492,10734,10046,107,10879,9500,9501,9782,7354,4566,6683,10770,5596,9377,8808,10674,5431,1234,173,4432,10226,10079,8927,9900,6397,10272,11262,11187,10146,5513,145,11335,11381,9922,6278,1775,3368,9338,11287,5247,7250,11108,5236,28,9464,7876,10397,11225,7662,7661,4023,6679,10893,1145,9888,8568,8424,8740,9977,5175,4023,4061,4969,3989,6595,228,4233,9968,1398,11630,7143,11652,11633,7671,9560,8812,9251,10168,8813,11517,10748,10472,10675,11684,9417,10904,9036,8517,11703,11658,11442,9874,9873,9876,9875,1173,713,2995,923,11388,172,8474,1970,10577,8929,7655,8081,9205,10854,10855,9503,8889,11609,11385,6635,9980,9896,10869,11398,9246,8140,3558,10078,11753,8139,6548,11795,11473,11689,11794,10624,9220,10860,9638,252,10042,11822,9904,11838,11130,9401,7670) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC