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,4185,5542,5906,254,5247,5322,3216,5837,6315,320,5331,6796,3026,464,6700,6866,5331,1462,508,6121,1230,924,4218,5994,922,6364,6382,5956,3542,6130,1645,7304,5996,5909,3037,4109,567,4834,1557,5088,6891,1325,4450,405,2117,1998,421,324,4029,7547,7143,4690,2729,4432,3054,5763,5735,4986,450,4320,4659,4722,2246,6809,7834,5904,1073,8093,7592,7837,7835,7836,1461,8103,8151,7907,6828,4765,3549,7910,7359,637,3014,501,6838,5602,1327,7919,8092,3872,4901,3904,358,435,4056,1119,1121,7861,1215,4983,1029,7812,7783,8617,4731,8629,8793,8745,6642,8555,8837,8836,8869,4566,8919,8840,7037,1461,4730,6397,4950,36,768,8169,9030,9075,9073,8933,9074,9072,9164,9163,8841,9096,9072,9074,9216,9244,9243,9242,7815,4395,8441,5088,5236,9281,7899,9344,2253,6310,5046,4061,6986,1038,4339,2847,8839,8031,8547,7559,9460,9456,9459,9464,9455,9454,7354,7587,6713,3261,6782,8089,2882,1516,504,9497,7833,9479,9546,9757,9647,9463,9814,9635,2989,7804,8970,9810,5881,5885,7548,7873,6842,8280,8291,8818,9038,9334,9078,9614,5915,7140,3395,9345,8978,10004,8504,9990,9637,9888,9897,9910,10113,9900,10114,6002,6981,9967,9603,10046,2446,9753,9788,409,9319,10039,9828,10064,9558,10060,10088,10182,10087,10261,9987,1385,10109,10104,10260,10267,9354,10237,10358,9769,10258,10183,1142,9180,9185,9299,9506,9801,10063,10259,9389,10229,8910,9406,9275,10210,10528,10121,10547,10549,10297,10343,10364,10380,10320,10319,10318,10564,10699,9959,10090,10480,10187,9919,10820,10700,10471,10505,10741,10847,10569,7131,10655,10668,10712,10977,10967,10972,10893,10702,10935,10679,10538,10119,11044,11090,11041,10971,10416,10715,10719,11021,9336,11103,11104,11042,9615,10174,9969,10440,10780,10785,10737,11106,10754,10734,9617,10778,11028,10749,11129,11135,11162,11163,11134,11089,11237,10536,10842,11126,10876,11258,11230,10261,10875,10878,10865,10086,11282,11220,11272,11315,11339,3493,11372,11382,11361,11121,11397,11234,11127,11446,11450,11381,11131,11386,11271,10236,5795,10837,11487,11423,11213,11377,11359,10938,11621,11551,11606,11379,11612,11703,11698,11646,11724,11440,11230,10663,11593,9896,11800,11669,11678,11850,11872,11363,7144,11838,867,6001,1954,1345,4178,240,458,1982,1085,4985,4900,2766,6788,5907,972,4109,5252,2989,2324,464,1402,3712,5782,360,1575,4021,567,6712,4109,1522,3304,2183,1988,3574,6648,6383,6176,3967,6984,6947,7032,7033,1153,1983,4923,1380,1296,6316,5719,4362,587,2399,6583,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,2590,6565,396,36,1532,1127,6882,2419,6569,975,6669,6736,6566,455,6563,6675,3368,5576,2869,1351,6883,601,6676,6993,6994,7001,739,6675,6779,6998,6996,6999,6842,6947,6795,6562,6544,6564,7003,6990,7063,6574,186,6676,6678,6571,6997,7059,6986,1521,7228,1856,650,7229,6992,7232,3029,7231,7225,7227,455,1057,7003,7234,1532,1131,7230,2187,7057,7224,6669,7223,3850,7233,7226,7237,7157,7231,734,1181,1890,2192,810,6359,726,7299,2398,6512,6538,4362,7230,6940,6790,6797,6537,7681,6536,4796,7692,7699,7233,7229,567,6573,7681,7684,7685,6735,7013,7184,7234,7687,7634,4109,6542,361,567,6540,7691,8094,6539,7635,4834,8142,7047,6212,1266,8244,7634,5551,358,6780,6177,5915,2029,7783,5956,6140,1766,1768,2932,1351,5996,3860,6366,6725,7840,6189,7570,7762,3913,6726,8109,7635,8142,5551,4986,8390,7635,7020,8297,7840,8109,3029,7879,1770,1765,8815,8730,8183,9030,8109,4986,8147,6971,6068,8390,7681,6725,8816,4422,8129,567,8851,6726,5551,8147,7879,5995,7548,7878,1461,3754,233,4109,1520,231,1738,1228,1532,186,8222,358,4185,8390,223,2727,4639,8358,6842,6155,8306,6589,8103,6588,8109,6639,8514,6366,567,6726,4131,3754,2706,2029,6178,7992,4796,8222,2989,7995,8816,8910,5362,8230,5996,3604,2253,6971,3850,5691,6599,567,7635,567,7677,7634,8617,5551,8826,2390,5995,6740,7238,7283,7641,7238,834,1371,933,3302,2530,2183,2594,6842,8142,7635,567,1070,2632,8306,8306,223,2876,2033,4861,5070,2932,2706,4860,766,5179,5148,7020,5799,7635,4109,567,4986,8617,8845,5551,446,7634,8358,3216,1439,6793,743,5088,7290,6901,2863,4217,7047,7837,7275,1895,2677,6902,5623,4432,1954,3590,6901,1826,6553,419,7063,2677,7029,341,6860,2956,3760,7879,7840,341,8502,6718,7674,8171,8436,470,8587,8488,8095,8616,8094,8587,8886,2956,3788,6562,6563,2334,5222,3417,3282,743,9002,8997,8993,8994,9003,9001,7233,6990,7783,7029,8617,1416,8870,5765,1577,3029,2766,6824,5692,2331,7034,9002,8587,8993,2957,6790,8004,3590,9321,6780,1568,7712,6902,7029,8488,8095,8780,7619,3564,1131,444,2331,2334,2592,955,9390,2956,2446,9363,1834,971,3418,3479,8923,1893,9463,7787,2454,9511,9512,9531,9532,9528,9551,9568,9571,9570,9566,9002,9001,8094,8095,7000,9531,9419,1532,9321,8996,8094,8834,2680,9783,1163,7618,6882,2698,9981,9982,10005,10004,10012,10013,10014,10017,10015,4422,7907,10019,6828,10109,10110,9947,9982,10108,9948,10118,10165,10112,7830,9570,9226,8845,8461,7674,6556,6557,7618,926,6095,2923,6551,6555,1278,1815,6068,5856,9987,10267,10221,7792,6205,9987,10413,10414,9620,9619,8083,8034,5066,3358,7605,10397,2329,9532,10345,6555,6551,6248,6552,7829,10266,10141,10127,10632,10635,10395,10266,10621,10620,10619,773,9200,9116,8978,9290,6635,9798,8431,9650,7272,9742,10571,10574,10585,10772,6139,5188,3595,8169,1738,2467,322,675,186,8358,9030,9130,4834,7635,7839,8851,8845,567,3197,2156,8554,5962,7872,6810,8292,9394,9504,9525,4338,7023,7632,7815,9647,6172,9379,9732,8389,1307,7966,18,9046,2384,41,9897,9758,6725,8110,9864,9814,8995,8714,9754,9532,9468,9467,9506,7222,10174,10085,123,10173,10143,10035,2171,10040,8434,10054,9972,8112,4005,178,5362,179,971,9661,2329,1906,752,2709,1163,9897,4710,5460,5460,4005,9875,8923,9878,9956,840,9877,9873,9876,9874,7362,41,9552,8829,9925,5551,7905,3402,7634,3059,1520,8617,8851,4109,4986,567,10116,9808,10048,10245,10283,9420,9831,10128,9780,9668,9913,10273,9602,10127,10284,9456,10265,10173,8948,7833,7903,7143,10233,10246,8953,10302,10531,3457,5516,3523,6867,6874,8193,10554,4086,8947,6774,1371,3531,5269,8613,7576,9951,4349,6426,9394,397,2029,8938,10810,6631,10670,979,7300,6365,10296,41,11019,7912,7870,10649,7631,8027,7840,11295,3327,2627,6693,7307) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC