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,10577,10675,10272,10275,10575,10629,10630,10906,9743,9508,9562,8034,10007,7077,9261,9564,9581,11059,10689,7108,9580,10855,8087,10854,7153,10965,10887,10881,8046,10888,8086,11034,7279,10890,10506,11211,11035,10507,9443,10508,7261,8364,8644,8961,10404,10449,8057,8368,8443,8050,7289,11276,11061,10509,10274,8472,11331,11411,11278,11065,10511,10889,8767,8207,9738,11536,9057,8414,8474,7150,7666,11210,11674,11668,9148,10941,10943,10947,10942,10623,10944,10624,9821,9956,8450,10945,8468,8646,8428,8415,11630,9997,11262,10946,11760,10625,11712,9095,11211,9957,10573,8929,9744,11335,11841,11866,11839,11840,7079,7273,9189,7111,7121,7084,8401,7286,7244,7280,7986,8395,7262,7109,7714,9314,8577,7713,9082,9623,9370,9199,9743,8772,7096,8086,8722,7671,8207,9793,8712,9446,8423,9441,7251,8049,8034,9816,8766,8041,8791,8770,7275,8537,9819,9457,9818,9205,9508,8383,9738,10030,9560,9563,8439,10077,9053,8406,8386,9817,8767,8203,8085,9083,7715,10026,10186,9999,8394,10789,11631,11376,11045,11508,11555,9509,11654,8081,11746,8087,11712,8424,8740,8568,7268,7245,7088,10575,8413,8720,11531,9057,11096,11692,11693,7264,9095,11668,11188,11189,8470,8383,11225,11332,3336,11101,10687,11214,324,11305,10941,10773,10889,5995,4659,10770,11763,11632,11224,11794,11628,11629,11778,10890,11607,713,11926,11946,11754,11711,9865,9540,11632,11754,7671,8450,11778,11753,10881,11793,11062,11794,8460,11925,11955,12009,3165,8257,7874,7970,2473,2915,4784,4701,9079,5380,9365,7218,4639,217,9904,9938,9937,1257,7903,9525,2658,9647,9900,9666,9922,9959,10000,9931,9366,9052,8948,2033,7143,5647,3830,9027,8793,1766,9829,4405,8087,10835,7106,10629,10919,10965,10992,11020,11068,11092,8792,10625,9082,10659,10694,8414,10572,7289,10692,10773,10689,11274,11276,11277,10906,11629,11628,11632,11652,11631,11633,11712,11630,11631,11712,11630,11685,11711,9509,11758,11743,11713,11528,7930,11518,11654,11651,11653,11779,11780,11782,11777,11778,11797,8202,11793,11795,10770,11632,11671,11798,8460,11756,8080,11802,11801,11333,11865,11469,9095,11675,11368,11794,11369,11781,11883,11674,11335,7275,11376,11917,11888,11803,11805,11925,11411,11868,11926,11553,11884,11526,11892,11958,11916,11634,12002,11861,11806,6687,11804,11918) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC