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,8400,5995,8220,7108,7108,7842,8063,7084,376,8354,8765,8765,5996,7975,8093,7714,3860,8143,9010,8983,8371,8071,9056,8982,8878,9049,6517,2997,7138,6420,4037,435,3612,1490,5142,3201,4452,6523,7981,4282,7919,3159,4600,9275,1536,7985,5321,4645,4301,6215,1349,8146,6364,9248,4199,2594,5251,8795,6595,4798,8598,8317,8336,1704,4289,8874,5691,7693,6376,8241,6517,6375,6989,6995,6234,6419,6388,7610,7697,7694,7695,7696,3442,7608,3515,8244,1665,6175,7054,3891,1765,6270,8246,382,6995,8788,388,6076,6768,3892,6223,381,379,391,387,6376,6375,378,8878,376,387,392,393,385,6271,726,5864,6373,6527,6522,9182,8340,8325,6529,6530,8324,8242,8599,8322,8335,8334,6534,6536,6538,6532,8300,5827,6266,8315,8320,8319,8317,8318,8248,8971,6533,6505,3883,3885,9137,8651,1973,8899,6727,6843,6667,520,1380,6938,6753,6382,8168,2282,6385,6418,8203,7703,3247,6754,8055,8401,7674,7069,8400,9609,6151,1327,458,6616,3549,6103,464,3428,5334,3997,5882,6798,6840,6763,1663,6157,2998,3449,3069,6427,3389,6491,3898,452,222,4913,6600,6855,6388,2507,4765,3254,3169,6151,2684,6905,6129,464,4659,6181,2164,735,393,6894,379,6146,2737,1049,397,7195,7199,8656,9088,6523,3327,6545,8305,6604,8592,6616,6719,6700,9151,9190,3879,8097,6521,7400,9502,9647,9502,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,8582,8352,6967,6966,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,6740,6191,6931,6928,6938,9089,6936,653,6388,9733,7703,6271,9734,6414,8349,9932,9735,6517,9850,6375,9852,6989,9729,9811,6234,6191,6531,8523,6519,2720,6372,726,6396,6966,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,7195,3898,9156,8988,7199,9409,8882,6928,9173,9172,8700,9408,9176,9536,6768,8971,1730,8858,9146,9145,9147,9144,9143,8881,9150,9190,9191,240,9411,9151,8987,9192,9767,8986,8654,8656,9592,8530,8529,536,535,7694,7695,7696,7697,3881,3884,3888,7868,3890,3883,8531,3882,3895,3893,7196,7198,7702,6937,7196,7198,8655,8665,8581,9993,8879,9088,9178,7705,6270,9633,3896,3894,9177,9175,1765,5386,6656,6985,9217,8168,2856,7870,9154,9892,10100,9155,9792,392,386,9891,10097,10099,9894,9906,9891,4305,8242,9903,9951,8274,3887,3885,10136,10147,10102,9909,9908,9950,379,10193,3889,3892,9535,8329,9535,8329,9535,10200,10139,10201,10197,10215,1768,381,380,10199,375,7188,394,372,376,10217,176,9430,10322,4390,10545,1411,9137,4512,10521,10562,9587,10556,9589,9588,1266,8334,8337,10559,8342,10558,10557,10607,9429,10463,14,8341,10555,9593,10194,10561,9431,6066,9426,9436,10552,10551,10218,384,10330,10332,10331,4304,390,4684,9424,9425,9483,9433,9427,10563,4302,10606,4286,4287,4291,4305,10728,7963,10519,1557,7698,7844,7311,7608,7610,6498,9631,7693,7694,7695,7845,7843,7696,7868,9536,4804,6653,7176,7179,7180,7182,7187,6652,7176,7178,7179,7181,11015,11014,7183,11013,7189,4386,6654,7184,7185,7186,11016,5635,8899,10796,10797,10926,10975,10930,7600,11109,10928,10927,7676,11082,10931,8681,6221,8698,6223,9536,8665,6381,8731,8654,10257,6505,6533,6536,6534,324,788,8770,11124,11798,8055,10920,8747,6879,11611,4297,2778,2816,2823,2787,7222,9270,10086,10094,10056,5170,3904,6354,3073,2698,3070,10134,9603,9475,2271,986,3351,3429,5631,10132,10133,2707,1159,4901,5837,10210,10018,780,743,772,4406,10277,5131,4653,10285,10286,802,1441,1160,1110,10205,3825,10287,7758,7858,6852,7865,9353,7864,1915,2654,1277,9607,732,10207,10241,10242,10104,7856,7855,7221,3731,10130,10209,10148,10344,10345,2912,10374,8946,10376,8919,10358,6902,141,10243,10373,6163,10065,9406,9511,3731,8910,8095,10416,10543,10400,9910,8813,10399,8812,9252,10401,10479,6901,9929,10120,9937,10362,10476,10530,9769,10046,10660,10661,10662,10112,9386,10633,9748,10119,10118,9761,4240,802,5321,2657,10709,10708,8687,10710,9253,9251,1835,1190,1177,9466,1176,7554,7754,7755,7756,7927,8509,10528,10062,9770,9222,9253,9251,10787,10857,10523,10395,10836,10814,10870,10396,10358,10569,9614,10632,10244,10634,10917,10918,10568,10635,10584,10583,10636,7029,10919,2912,7674,141,3351,7856,9512,9531,9532,2658,9551,9566,9569,9570,4199,9568,11028,8615,9528,4624,4730,8902,446,10212,10895,8888,8278,8276,8275,10657,10913,10911,9981,8799,9987,10141,7221,10205,10207,9277,3428,7239,10066,10165,10236,9402,8031,1253,5545,10413,4969,9454,11027,10414,7636,8095,608,1368,10549,10837,848,10512,7580,4766,9391,9982,4233,9571,8252,3100,10649,11112,6163,11141,8842,5013,5154,10113,10114,8629,8837,3029,228,10063,11142,9904,10967,11102,9543,217,10087,11219,11126,10938,11217,4337,6863,11202,11122,11220,11100,11084,11123,28,11106,11268,9638,7550,10397,11180,4984,645,1917,9950,11219,10784,661,10127,744,6731,57,467,1092,89,4785,4536,2873,11374,2871,6730,4329,6692,4882,6776,3100,2317,6185,11330,5131,4406,11228,4046,4048,4045,10377,8147,7057,7857,7003,6736,4049,4050,6741,2033,8517,6705,4136,7016,9251,8812,8813,9252,9464,11302,11235,2639) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC