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,10342,9950,6392,6276,4563,10704,6843,10676,10687,7804,9857,9513,9006,10539,2157,5000,9062,9803,6239,3609,6237,10539,10566,6291,8256,10107,10250,9300,9300,10649,9951,9386,10505,10826,10676,10742,10802,6613,11752,10579,11238,11885,11101,10599,10983,7388,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,8926,10872,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,10992,220,228,11025,10758,10940,9823,9972,8005,2526,11201,6774,1969,2169,9342,11074,7966,11572,6984,11489,9951,6822,10966,5435,9418,10892,10984,11485,10932,6242,11285,11342,7976,11455,10141,11477,9950,11328,11101,10731,11215,10343,10278,947,1207,7641,9655,10505,9533,11289,10566,8169,11272,10687,4779,11226,6004,4574,8109,2342,11303,9389,10339,11900,11363,11302,10380,423,396,11101,10344,11217,10116,9386,10056,9993,1215,10239,8358,10247,10238,10212,4121,1988,990,7135,8780,7134,10229,952,10836,10466,2261,10149,4778,4512,11022,10733,11646,501,28,9031,5609,10818,11644,9985,7610,11792,840,11873,8780,11495,11784,10092,11303) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC