thisMySQL 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,6710,5371,6779,752,435,249,6842,6766,3884,6986,6981,7019,7219,6809,6650,3888,4406,6845,7209,1268,698,4788,6104,3542,3561,3625,7036,4082,7304,1095,2157,7760,2160,3368,3368,1038,1253,7238,7987,6740,7238,6861,4131,8220,6493,3890,3897,8222,4209,1461,1461,7875,8793,3493,1038,1038,4566,4566,3896,320,7138,8683,9195,7920,4805,6842,8183,8535,9195,9552,4656,4656,6115,7592,7592,7554,7554,9052,9904,9910,9925,9049,9049,9614,9614,9951,10056,10063,501,3241,3644,5516,228,1762,3744,4325,5460,4770,3046,640,4801,1490,3201,5732,4452,2023,2117,4411,946,3491,5602,3550,3698,3754,4535,3428,1029,2052,637,6561,6006,6000,1425,6658,3555,3949,6595,5995,1591,6587,6583,6978,6962,6586,6588,7019,2145,6120,6103,6264,2473,6710,7258,6445,7093,501,6713,7166,2658,6098,7871,4209,3904,6785,3604,3595,8349,8537,8342,8620,8620,8683,6583,2992,7753,8514,9104,5052,8088,4652,8413,9339,9130,9348,9563,9579,8053,9539,9366,223,6971,10212,9741,10307,3904,8739,10513,9945,10691,10690,10689,10588,9054,7675,8910,10629,11025,9198,9162,1232,11222,36,3830,4796,5236,455,464,4234,4128,4178,5279,6431,1453,6400,1537,3337,766,6195,4178,5995,6001,754,6587,5996,2158,6008,3644,223,4566,1343,6381,323,3860,397,2594,4656,6766,1826,975,6394,3964,6593,858,6986,990,3989,1591,6842,6947,6140,6941,6010,6985,1402,2261,766,5070,6349,6793,5882,1461,5331,6757,6779,6812,2374,6115,6631,6658,4099,4656,6779,6971,7003,217,6850,1029,2474,5530,2000,6951,1371,6996,958,5371,7019,675,3100,230,6312,7034,7148,6569,1917,6168,924,3595,6103,2915,3059,834,239,7226,4947,6813,3493,1461,4796,1520,6141,836,850,3860,233,1785,1537,6431,6951,1776,6275,7739,182,2932,2000,6445,1084,5339,1521,3625,7156,4995,797,2446,1462,1779,1785,6400,3037,2387,2117,7761,4529,4659,8222,8232,8128,3542,1070,7897,4639,3521,7050,1490,2029,4079,7783,8097,4405,4834,4259,8558,1890,6818,2117,8518,8611,8109,6631,1349,8535,8388,8629,5552,4218,1811,3850,8793,7976,2737,8839,8852,7918,734,3823,3966,6667,8305,6814,8889,7602,7147,8183,7307,7795,1772,186,1774,6715,3302,8684,933,4991,314,6366,8281,9340,5769,2009,6583,6438,8561,3519,3554,5305,8978,9344,9290,9197,6700,7903,6255,6552,9453,8781,7048,6631,3520,6642,344,9776,8089,3557,9776,4849,2390,4087,9248,5046,9922,2122,9900,9910,9661,7759,9776,9928,7825,9308,36,9986,7998,10229,9798,1303,10063,6113,2989,9449,5891,2170,8816,6641,10346,10280,9552,9538,8586,10001,9602,9916,10469,10127,576,10292,10500,10375,9513,4349,2158,7173,10548,10526,10654,8956,10579,10652,10775,10652,10747,6562,10719,10894,10227,10297,10871,1765,1767,1771,1768,1769,1766,9154,9518,10670,6354,7922,3883,8272,779,10354,11041,10314,3073,6689,3071,8316,7557,8627,8088,11021,9037,7170,9945,7174,8241,9665,8333,8946,8244,10742,10924,10528,9665,7912,11239,5994,61,11104,10578,11364,10454,6154,6794,5996,3860,391,387,6151,6159,1126,6562,7238,6140,377,2005,6578,2635,7576,7576,2635,6386,6646,3327,3890,5435,5435,5435,382,382,388,388,3337,3337,3337,3337,6388,6386,7702,3334,3334,3334,3334,3334,3334,380,6854,4614,8884,8788,8817,6386,8580,7266,7294,7253,4558,7152,7091,6962,7125,7095,7276,7707,3090,7123,7805,7665,7093,7296,7096,7671,7278,7271,7115,8048,8033,7280,7272,8412,8477,8645,8473,8709,7941,788,7291,7291,7124,8852,7083,7092,7106,8405,7103,8064,8393,8398,8466,8354,8349,7068,7666,8475,1667,9201,7244,8465,7088,7093,7099,6969,3926,8093,7109,3090,3926,6984,9574,9573,8208,8576,7666,8577,8412,8475,9148,7346,9745,9314,9076,9583,6719,8468,1990,9873,9470,9818,8644,9207,8410,9973,9956,7574,9055,9577,8574,8439,9956,9583,9583,9583,9263,9204,8689,9058,8230,7081,7898,8439,7646) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC