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,6966,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,511,3715,6786,5719,6393,1970,6969,3997,7238,3719,6413,223,5994,1351,6642,834,3165,5331,6967,6544,4570,3760,6901,7029,1738,1461,3181,1568,925,1145,466,1461,2261,4209,2706,1366,6691,6110,6968,6650,6381,7238,2785,6110,673,2778,2783,5882,2782,6751,7238,2781,3913,2789,6373,358,6396,6726,6517,7160,1416,2787,6749,6375,7304,6622,6393,6965,6962,7658,7121,2473,2473,4639,4639,7953,223,223,7088,7088,8438,223,223,8282,8358,6420,2282,6911,3036,6967,389,6966,1730,7897,1303,6951,3896,7266,8831,6197,8529,6743,8165,979,8585,8833,8833,3702,3702,7209,6633,6964,7133,7025,6315,6632,6635,6779,4950,7157,1038,6713,1126,6785,8031,8543,744,6117,1869,1600,6857,3941,24,7581,30,6679,28,2590,423,9347,9376,9333,6639,5247,6683,9634,4131,93,9648,585,2882,4355,2160,2381,7156,5764,7615,2419,361,9769,9768,467,9569,9868,9807,661,9824,10004,10048,9471,9942,6171,10055,3048,9421,36,10080,5692,3437,6848,3775,9945,6797,1237,3197,9951,9950,10149,10129,10041,8902,6857,6117,6845,6104,9798,10047,3368,9930,5379,9988,9945,3100,178,179,1461,9661,9648,4136,10063,9928,10229,9914,9634,7354,2018,836,3115,6942,9929,7900,8904,360,10289,10314,773,3341,3787,231,107,9961,606,3657,188,10467,7616,8796,8803,10048,10287,10286,10285,10319,10376,10660,10662,10661,802,10374,4023,10288,10266,10313,10737,10734,6171,10469,10300,4791,5143,5112,9220,10373,10569,5777,10476,10878,10244,8936,5956,6383,7917,4320,5371,6984,6110,3702,7879,6354,7918,7878,4501,3115,446,3071,3074,1108,7636,6967,7753,7998,7999,8349,6984,6962,6967,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,3248,6607,1738,6527,8884,6966,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,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,9063,6656,665,6382,8744,6151,223,3090,6197,452,9453,452,9453,452,9453,6469,372,9883,860,2490,9989,1296,8683,5956,5467,2009,2257,1462,5882,6593,1887,1327,6312,6377,5742,3704,2474,7048,6127,6810,1981,6816,7547,2554,6593,3865,3327,6140,6131,1462,310,3248,5782,2635,2643,3402,7363,2843,7599,2507,4154,5068,6905,6721,1990,6618,1990,6618,2967,5567,7958,4079,6127,8110,8607,4338,6829,3531,8768,6710,3561,3029,7641,3761,7632,2455,1051,4535,6807,5602,156,6364,46,6264,8924,4339,8482,2447,5484,5376,9603,8716,9552,3059,8812,4682,4682,8955,4765,5647,8019,6642,6780,9936,2491,4987,6362,4362,5322,4320,10107,9931,4580,1172,10457,7643,1272,10267,4983,10649,924,7037,6806,6958,6959,6960,6973,6972,6974,5165,458,10504,10229,10267,207,1051,265,7815,6059,265,10495,7882,10704,1992,11342,9336,9967,6767,10314,8518,11120,9423,8960,8839,4360,10860,11376,10608,9757,11131,11115,11676,3428,11112,9403,9234,7662,7906,7663,8071,8113,8439,7666,7266,8167,8164,8206,6796,4716,6728,7661,7642,7662,7286,8461,8363,7287,1250,8712,7096,8408,8425,6596,8386,7082,7109,7075,8412,8208,7294,8052,8767,8251,8721,8741,7647,7644,8891,8892,8950,8471,8832,8768,7290,7986,7125,7152,9148,3564,7107,8439,8406,6908,7280,7079,1983,8129,9620,9189,9141,7241,7088,8283,9076,8386,9729,8365,9492,9730,9481,4029,9537,7124,7107,9785,9698,9697,10247,358,9950,9386,7917,10382,5718,9726,6926,8156,11091,4535,1095,7773,4395,5996,3428,4395,2932,4209,4079,8902,9630,8092,526,546,4796,4769,5995,4860,9761,9746,1439,9785,10002,9808,7920,9750,840,608,7839,9668,3941,9925,9638,9220,10173,10165,10149,6632,10243,10115,10135,10245,10233,10229,10244,9993,10042,107,10148,10188,10243,10246,10284,9406,5647,9453,10266,840,5419,10440,1461,10080,10258,10380,665,10283,10439,10141,1215,10212,10268,3913,10314,10375,3989,4861,5148,9052,5799,1257,10062,10227,3241,2706,8893,6842,5070,9602,8514,9420,4234,2632,766,10787,4861,4901,2894,2594,8517,10879,10894,501,396,10128,10895,10315,6842,10375,10306,9453,11028,10020,9780,10569,7614,7615,7550,6713,8837,4082,7017,8888,11237,9454,8925,11488,2706,10856,11349,5373,252,3542,1521,9220,10375,11593,9904,5739,9374,9615,4455,4739,10857,4455,4739,10857,1490,640,4411,2023,9987,779,11644,10798,10300,8049,7906,10342,10530,11595,11678,11594,8548,9850,9348,6557,739,11492,1127,10131,7135,7965,7964,9785,4716,9361,5719) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC