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,3913,1245,2778,6804,3926,1770,1771,1085,1771,1070,1769,1767,5148,1561,6964,6110,1768,4426,6961,4164,6471,4165,6504,511,510,2469,3216,1370,6383,6415,470,467,2605,3702,858,4788,1741,3771,2035,5821,344,1165,663,979,3989,1770,1765,2706,3830,3370,4943,6371,4423,6354,1600,744,1381,455,3761,2331,1232,2183,3610,3172,1474,3172,2615,3131,1185,1738,3217,7752,567,7748,663,7964,4218,5576,7779,2869,8000,1351,834,3541,2334,344,6660,3250,5091,4701,2671,7604,2653,3136,3417,6413,4972,645,7033,7896,6940,3645,1098,1593,1407,4964,4984,1561,1460,3797,4008,4830,5218,8095,1070,5091,1738,8150,1769,1767,5576,6940,1098,6970,6967,3216,840,1351,6394,1600,834,943,6965,6883,2331,467,1092,3883,3884,4301,3885,4297,3896,3893,3889,3897,3891,3892,3895,3890,3882,1245,1303,3895,3888,6493,4386,4291,6414,6964,4290,550,549,548,539,537,2473,6570,1537,6901,546,501,6593,6420,2282,6911,3036,6967,389,6961,1730,7897,1303,6951,3896,7266,8831,6197,8529,6743,8165,979,8585,8833,8833,3702,3702,2706,645,3954,1593,6965,6110,6969,6968,7805,6970,3029,4944,6383,8349,8523,6621,8352,8357,8354,8523,8356,6969,6609,6815,4146,1052,8839,4460,9017,6808,5719,9851,9620,6578,5402,5402,6962,8352,6968,7805,8354,8354,6969,6969,8351,8357,6970,6970,6970,8356,8356,8352,8352,4716,4716,7576,5371,2635,8349,8349,8355,6962,6968,8354,8353,8352,6969,7805,7805,6965,6965,8490,8349,6794,6391,8314,8245,8350,8316,2474,8317,8320,8315,6965,6396,8246,8249,8334,8243,6512,1726,8244,8319,8331,8335,6512,8356,6393,6939,8351,6807,7546,6967,6510,8357,6383,8354,6174,6961,3248,6607,1738,6527,8884,6984,7964,6221,6511,8336,9159,8245,8328,9112,9119,6497,6216,9052,9145,6110,3076,6396,6965,8349,6962,9113,9111,9156,1726,9120,9143,9150,9030,6646,9144,6383,7157,6961,1828,6963,8306,6806,9482,9407,1886,8785,9084,8682,1084,8618,8786,8788,8542,8389,1662,6787,8290,7027,1884,9507,3169,9547,9374,9090,9386,8435,8196,9729,9497,6520,9713,6171,6533,1770,1766,5692,1767,6263,1770,5743,124,9482,9868,9668,6538,6967,4779,4791,6963,1741,466,566,1056,4788,4788,7708,6316,5719,2995,6962,6396,4029,4029,1207,1207,2776,2520,5996,5996,6386,6386,8596,6719,8345,8345,3172,6444,7721,4298,4304,6928,6932,6934,6938,6936,6935,6604,9088,7195,7199,7198,7162,7191,8825,1730,6596,5961,4292,9067,4259,2084,8168,6491,8387,8582,8352,6967,4614,6970,7966,6965,6415,6968,1557,6272,6385,14,6450,3380,8831,3247,5882,8490,4501,7816,6396,6656,6383,6076,7904,8232,1663,8821,9631,1616,3358,7632,9767,6787,8542,1360,7457,6242,6242,6183,6409,391,376,6968,6962,10925,2856,6740,6191,6931,6928,6938,9089,6936,653,6388,8387,9733,7703,6271,9734,6414,8349,9932,9735,6517,9850,6375,9852,6989,9729,9811,6234,6191,6531,8523,6519,2720,6372,726,6396,6995,6376,9408,8244,6518,7196,9165,6371,7200,9909,9903,7845,6968,6604,9520,10194,7190,6383,10201,9905,10218,10264,9734,6937,6934,6423,6359,1616,979,8824,9892,6422,6519,6768,1266,7808,5297,1165,1411,810,2720,6518,5864,9149,10045,9165,9500,10044,6372,9432,1967,4714,9120,9119,6656,10336,10332,3625,10323,6146,1730,8243,10324,8341,9175,6151,7191,7610,10115,3542,1521,7610,7311,6371,5691,7697,7694,9499,10419,10431,6989,7567,6271,7569,10330,10426,7614,9904,9220,10244,7985,10323,3885,3884,3893,3897,6493,3894,7695,10325,9592,10147,7696,10327,6740,24,9593,10333,6519,6372,7868,10645,6518,6371,10642,3442,6517,10103,10647,10328,10330,3515,4282,10563,6234,6375,7238,10637,10728,1704,10726,7608,8881,7693,6989,8464,8464,7493,10696,10032,7708,9386,11101,4923,9976,11519,6854,653,10386,1990,3327,10940,10731,10731,5810,4769) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC