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,5956,2635,6565,6678,6576,6569,6568,6564,6574,8033,7094,7998,7096,7100,7082,3830,5148,7252,186,1662,7840,7840,7879,7878,7160,8095,8095,6740,7238,7238,8094,8220,7649,1537,1537,8109,8903,6726,6971,8816,8230,2374,9030,9321,6365,2029,2530,249,4144,5995,6003,7374,1537,1038,6693,2992,1163,341,1906,6122,6493,3897,176,2157,3337,3897,6582,6140,863,864,6752,6780,397,6883,6493,388,6204,5956,1121,6986,6561,6006,6000,1425,6658,3555,3949,6595,5995,1591,6587,6978,6962,6586,6588,7019,2145,6120,6103,6264,1558,2473,6710,7258,6445,7093,501,6713,7166,2658,6098,7871,4209,3904,6785,3604,3595,8349,8537,8342,8620,8620,8683,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,6369,6190,6368,6402,1788,1788,6110,6962,6794,6984,1726,1108,6964,1085,6548,6369,5576,1207,6656,3385,3384,8693,8694,7599,4784,1967,4714,7187,5046,8665,1685,9137,3037,8071,7273,7660,8429,8034,10007,9795,9563,9873,7280,7278,8709,9225,8386,7674,8909,7265,9053,7272,7278,9611,9610,3883,7244,6550,6719,6807,4437,1983,1153,3850,6658,990,3865,3863,408,2795,7119,2781,7276,7111,7121,7096,7125,7249,7521,7541,3863,3863,4769,9024,1988,3574,6648,6383,6176,3967,6984,6947,7032,7033,1153,1983,4923,1380,1296,6316,5719,2889,4362,587,2399,7641,6726,7158,5769,8230,8109,1070,6366,3302,1988,5719,5719,3449,6428,6428,3522,8352,8352,7976,7976,7918,1526,6702,4694,9030,6122,7874,834,5961,2503,6428,2503,2503,6428,970,4639,8358,9258,6738,7139,7149,6714,7215,6006,5995,7605,3337,7213,7966,6183,7218,6003,6131,7217,7264,3704,1380,7068,8182,8182,8182,8740,8424,8201,7245,6631,8573,8573,8384,7666,7284,7284,7284,8204,9574,7931,7639,9765,582,8764,5915,6631,6631,6631,6725,1296,8139,8193,3368,6861,2005,7896,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,1558,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,1558,8305,6814,8889,7602,7147,8183,7307,7795,1772,186,1774,6715,3302,8684,933,4991,314,6366,8281,9340,5769,2009,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,1324,2041,6561,8115,8115,9169,9169,5484,6004,7979,7493,8108,8831,4544,4399,6396,7917,6394,6402,9616,10731,1765,7493,9949,5996,526,2056,391,7270,3860,4199,3896,1458,7300,6768,7300,6962,7286,4544,4860,7899,545,550,548,539,4684,3554,3554,1398,7175,7032,1662,549,6477,525,2706,778,551,864,1366,8356,8530,546,8880,979,6394,6842,8212,7472,9030,578,547,2847,3337,1777,7178,8438,4500,4500,9076,9778,9494,9494,9791,9745,9858,8575,8575,6648,9488,9879,8434,8434,9547,9547,10638,6579,8063,8833,10731,8428,9853,9785,6400,10695,4500,1783,7574,7084,7093,8580,7297,7486,6482,8460,7268,9264,7674,9264,9022,9022,7420,9022,6367,6367,7083,6691,6691,8,5947,5947,7654,9999,9999,7273,7273,7273,7084,8700,344,9990,11233,10527,10533,9163,9985,11213) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC