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,2029,6000,4769,56,2343,7039,2263,6850,3574,1825,6139,2009,5959,8284,9042,7828,6794,7148,2263,8299,5790,5810,5952,5962,2343,6870,7640,4302,6842,3976,2118,7761,6842,6010,3532,3595,3169,8093,6713,6505,8185,2933,3542,219,8220,6314,1347,6264,8547,387,3823,7151,7019,7761,8222,7647,7151,8793,7109,7125,6192,7082,8365,8816,8727,7080,7663,7550,2337,4455,4234,8923,8888,9038,9030,4566,2976,8222,8220,7879,8450,7258,7953,7879,8250,8615,8995,8823,8990,421,8082,7953,9270,9271,7239,7281,9054,8084,7594,8361,9321,8083,7910,9315,9277,8222,8406,9469,9470,734,6168,8220,7238,6740,8998,931,8458,9527,9526,7070,7238,8401,6740,6740,8220,7238,7106,9552,8208,8891,8434,9302,9278,6386,3395,8439,1563,7022,3395,7904,8201,7256,3541,7944,8423,6731,1663,1663,1765,1769,5544,6740,1385,814,8423,10095,9261,9647,7907,179,3590,6828,178,10190,3380,5252,7094,10109,1645,8460,9571,3864,10584,4861,576,9058,6183,8219,8830,8219,8830,9822,9910,9811,9677,9654,9769,9614,9440,8979,9335,9953,8978,431,2093,1881,9950,9481,9951,5883,186,3625,9680,10046,10173,10116,3493,4947,7992,1520,10142,9392,10142,9392,5541,8022,5541,8022,5541,8022,9279,9290,9910,6616,10227,4185,9879,10720,10649,10412,6769,10839,207,8517,10831,6133,9762,10985,10991,9405,10072,10220,4401,9028,4337,9296,4432,8389,7218,6740,7828,8145,9382,3169,3532,9392,1230,9543,9389,9066,3574,3581,7882,8661,10056,7877,10031,1044,10258,9953,6141,4156,7632,10273,9090,9507,10032,10113,9972,10484,10514,10476,10471,10776,10474,10414,10836,10905,8991,9136,10751,8185,10935,11082,8175,2867,10111,10884,9976,11325,2171,8962,9011,8289,4906,8102,10170,11361,11690,10622,11742,11101,11402,6134,10667,9472,3417,10416,6633,3647,10242,6795,2454,2956,3418,10627,341,10650,10651,190,10241,9959,8534,5596,228,3474,8629,10532,10611,10649,2671,10697,9202,9273,9403,10872,10909,10951,10758,10839,10879,11126,1727,8870,1647,11121,11028,11072,10786,11140,2334,2454,4722,5765,10651,10718,10242,10798,11226,11214,11239,11018,11303,11104,9551,9569,9570,931,10915,6361,10951,10128,11325,11351,11237,10739,4219,11095,9417,10836,4136,11409,11349,11363,2151,123,11678,11202,11690,11377,943,11736,11661,10730,11752,11724,11523,10698,2145,9887,5566,11854,11904,10494) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC