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,4316,5298,5003,958,3059,5175,7021,7016,5379,6809,7374,1645,6774,5279,7307,2342,4574,6006,7837,7834,7835,6845,2261,6104,7836,2644,1307,4979,6880,5236,5373,6713,6368,7020,2944,2387,7238,6821,4624,4901,6658,5131,4406,8222,6348,3440,3647,3647,659,7828,1183,7008,6770,9274,4068,7213,7374,7374,5965,6821,4774,4724,9975,9417,8144,8144,3647,7834,7882,1371,215,2117,2117,2160,7781,7783,186,7238,2467,8097,5763,6364,8093,6785,1183,8358,8358,8281,452,4079,4079,6588,8850,4535,2328,2328,8889,2911,2615,7900,9080,4983,6139,4985,9286,7037,8554,8778,9213,9403,7020,3908,9959,9368,9367,7670,9954,8648,10933,9161,4800,9649,10077,4401,4079,7874,10655,10702,9135,10976,10187,10768,10891,207,6953,10000,10771,9889,8639,10769,9955,10172,10185,1209,11108,721,10171,7250,9736,8446,10226,8444,8740,8424,8568,8447,9199,8737,9658,9053,8741,10816,8962,7284,8445,10834,8061,8073,7890,7264,8575,8641,130,5961,7833,9561,7714,1343,11025,9968,1378,7283,8144,10550,7639,2079,11305,8144,6138,9245,11170,7280,11433,8098,10861,7279,11332,9247,11195,9674,7286,11280,7084,10655,10191,1970,11225,1173,7251,7269,8653,8279,7037,7587,11654,11434,11675,6831,11654,11800,6831,2506,7288,6102,8370,9158,11626,11692,11693,11468,11674,6805,10944,10945,10584,10583) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC