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,8222,7579,7837,4079,1210,7834,4639,7835,7836,6740,7143,4087,8358,7238,223,8220,8517,3282,7989,8306,8547,8480,2117,8610,435,8610,3014,8629,8214,5143,4218,7923,3850,8842,1207,8905,8912,6599,1127,8916,9000,665,1345,8578,8780,9046,9130,9195,9017,1461,9072,3062,4625,8933,8706,5154,9200,9242,984,9254,7907,5536,9300,3761,8495,9322,9332,9333,9334,5732,9308,9289,9291,8103,9337,1057,179,8150,3595,2135,9456,3059,9419,9290,8688,7803,9196,9347,9541,8543,8306,9552,8306,9353,8306,7581,8306,6117,9607,9603,9604,7143,6857,1890,9641,9634,9654,9643,9668,9642,9644,2360,9377,4240,9680,107,9616,9761,9234,8805,9648,4219,9676,9769,9766,9780,9800,7856,772,9798,3844,4800,3303,2299,9116,2294,5515,5765,3590,2398,9258,1416,9913,9916,9938,9942,8913,9635,5841,780,9961,3844,9543,9945,129,9471,3159,3788,444,5692,1834,8870,8844,972,10047,10049,6848,1727,1822,360,10056,734,7615,10104,6681,5812,7016,2674,6827,1181,10128,10129,9086,3181,10141,10149,3437,10119,10120,8925,10048,10061,967,9472,1522,9963,1906,10093,220,4126,9116,5821,2743,1485,1000,152,10229,10242,10241,180,148,958,1461,2135,2192,3585,2299,10131,10282,10284,8884,4947,7019,10273,2687,2642,1826,3561,10283,9936,2421,4656,4566,4972,2571,10338,10246,9348,115,10300,10380,10373,8146,3715,6713,8902,4082,5142,8089,8901,9086,2337,7550,8837,9638,9454,9348,7016,7016,7761,8222,9195,9925,9552,9925,10042,9983,36,10002,6010,10244,1955,3625,10229,3542,8175,9038,9036,9258,9402,9439,9366,9278,8925,9406,9372,8999,7874,9220,8999,9273,9086,6642,9627,9552,9554,9614,9543,9249,9937,8089,1699,10003,10042,10050,3990,9904,10063,10145,10039,10056,10212,10265,10229,10246,10243,10127,10355,10278,10306,9833,9807,9831,10341,10247) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC