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,6583,2635,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,2590,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,2889,361,567,6540,7691,8094,6539,7635,4834,8142,7047,6212,1266,8244,470,645,4008,6564,6572,6575,1461,1593,6562,3797,4165,1092,744,6568,3645,7063,6998,467,7119,7095,4164,1600,6521,4423,7089,7093,4964,6527,1474,7121,6522,1098,6504,6735,7115,6576,7115,6902,7125,7029,6503,6901,7047,6523,6996,7223,7235,7001,7029,1460,2456,7233,6675,3418,7013,652,2917,2696,7112,2956,1425,7249,7276,341,3447,943,1869,7231,3760,2446,3454,7234,2456,2454,3610,1893,1765,944,7034,2151,1829,7089,2974,6588,7272,7271,6168,7272,6350,7271,7273,3417,7296,2334,6530,2671,7280,2653,5371,6365,7241,6676,7258,6993,2876,7057,7106,397,4021,6678,6726,6518,6512,6371,726,6528,6530,6529,6531,7691,7689,4305,860,7692,650,7686,7699,7681,4224,6530,313,810,7753,272,7275,5066,7844,3784,7661,7670,7602,7662,7108,7084,7265,7268,7170,7168,7599,1771,1767,1207,1769,1765,1768,6669,6564,6568,6570,6571,6576,834,734,1057,2398,2672,3035,5362,1350,1906,6069,1907,971,2329,4005,405,1163,5460,1532,6574,396,1718,6566,6735,6576,6572,4735,2360,1856,6166,1826,650,7147,1085,1086,3850,358,5915,7160,840,7240,7548,6589,6130,4597,2117,2628,975,2555,3525,7869,8223,734,5419,3760,8095,8094,8488,6740,7034,396,743,7594,5602,8587,7783,6712,7910,6678,6569,6570,7228,6993,7001,7052,6997,7231,6736,6996,6562,6574,6675,6575,6564,7234,7227,7226,6994,6563,7685,6576,7691,7684,5897,6799,6804,3744,1270,6727,5068,5998,6977,7149,7374,2967,4985,7155,7416,7937,8094,2864,6860,1271,6365,2748,6130,1727,3892,7290,8523,4385,9095,7677,372,9300,9381,9374,9621,9890,650,7840,652,7783,3760,3418,7803,2956,7995,2706,2956,8094,7685,8095,7691,6562,8147,6678,7224,7230,7690,8289,6882,6571,6570,6575,6574,8488,6736,6990,2469,6567,4086,4086,4086,4086,4086,4086,4086,4086,4086,4086,9947,7699,9002,8993,8997,8997,8997,9003,9003,9003,4079,6870,6740,7238,9033,8220,8165,7235,7721,650,7001,6076,6544,6669,377,7230,5996,6122,3879,4714,7855,6998,5735,943,6031,2571,6993,1537,2473,7237,6444,8168,2530,7231,772,6675,743,6678,6575,7051,6827,8230,7232,1829,7034,7224,6571,3843,8512,8541,6421,6882,6422,3778,6425,2469,7779,6424,4219,652,7758,7635,567,986,7228,8142,3429,6191,3351,6937,6726,6933,1967,7856,8290,6023,539,3892,6562,3891,3883,1461,313,533,6736,272,223,8542,3885,41,7019,7986,8434,7985,7813,8324,7024,6354,7568,9300,9936,5421,10032,8003,3877,8585,8883,7870,10214,8682,10099,10158,8618,6034,10238,7588,6386,510,7772,10041,173,1160,1441,10344,3825,10519,5096,10644,10607,10325,10563,9521,9520,10555,9515,10551,10640,10797,10836,10828,10796,10545,10794,10795,10793,10791,9386,10522,10790,10829,8717,9191,10750,4302,4463,3890,8273,10846,8260,9192,11019,566,57,3760,231,6942,1869,2446,3454,3787,1738,501,1461,1228,836,3657,6570,802,1055,1160,1568,943,772,743,1441,1277,1727,1915,7864,7858,6852,2592,6827,1110,6845,7856,7758,3590,7221,3844,5623,5765,2654,3303,7034,1577,1822,2685,463,7232,3181,6853,219,5509,8488,1416,2864,3844,3418,360,8094,944,1522,2653,243,341,2469,1575,2334,3482,2956,7803,3788,1313,2571,4219,3989,2723,5148,2671,3843,3304,319,470,3417,1829,3584,7779,4722,5552,4021,986,3351,3778,6643,5735,7784,6849,5170,6570,8616,5070,2454,2706,1893,6573,2456,6562,652,8707,6574,6571,6567,6998,8684,7224,650,7031,7229,7232,7221,6675,7227,3540,6676,5088,6564,444,7063,6563,6568,6575,6576,6883,6574,6735,7228,6678,6882,7013,7690,3415,1856,6996,7757,7687,6999,6997,7688,8726,6992,7689,8147,6990,7223,7231,6994,7681,8148,7001,7059,7235,7225,6736,7057,7692,8993,6885,7684,7685,6669,7052,7234,6902,7682,7683,7226,7699,7233,7691,8919,7237,9003,6007,1834,8994,2151,6676,9002,9068,6860,8997,8996,8814,6544,7003,947,947,7232,1738,6564,7681) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC