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,5995,1038,3428,5996,2160,6103,5321,233,4355,228,6315,5837,4056,2194,1998,6361,1453,6633,358,6100,5885,1591,6709,6769,6312,3921,5914,1402,6718,6588,4088,5081,5371,5770,4144,5910,5853,8683,8683,2635,5091,3521,3522,5305,933,7130,2876,6168,6160,7023,358,6169,341,6811,675,6904,5994,1327,2869,5572,3070,4735,725,6631,698,4046,906,7130,7143,714,4801,2117,6940,4419,6588,6167,217,7137,421,5848,947,3549,5334,1371,4796,5148,6644,1439,6780,766,2706,1145,4131,4860,1461,6986,2261,947,435,1398,6691,2023,2023,2023,4452,4765,4765,8684,4349,4349,1766,6509,6511,6514,6515,6538,6537,6536,6535,6505,6533,6532,7843,7592,6354,3070,3073,3071,6689,6688,8324,8323,9590,8325,9588,9589,9430,9601,9555,4437,6122,4218,5770,5371,5576,1462,2342,1343,4570,3863,2455,1461,5576,2269,7307,6981,2869,6809,1351,4535,6809,7020,834,501,7020,5657,3850,6709,2269,1764,7359,4446,934,7546,1038,6599,698,4566,452,3492,6845,6721,156,1271,6723,446,5419,7604,924,5647,1973,4178,2932,1200,4362,5148,766,2932,4860,2006,7160,7631,1993,3830,1439,4901,713,5995,1453,4796,6367,6103,5837,754,2029,5269,7840,6168,5376,6981,7592,6740,7554,7833,6155,7754,1345,7751,7756,6131,5484,6633,358,6891,7143,5915,6102,7146,7144,7238,6947,7130,5912,4154,6364,6863,5331,6831,3428,4983,698,4765,6712,7127,1184,7239,3647,7773,7781,7751,6348,3346,3728,7592,6687,7554,7754,7755,7756,7068,7761,7840,7879,8222,7878,7910,5997,7363,7288,6113,5175,665,6141,1533,1073,4199,1051,6158,2913,1050,186,2530,5576,6633,435,3904,6001,1145,2182,2261,176,4154,6962,446,1370,466,2490,3989,1272,1770,1126,7607,6785,6845,1038,6986,6158,8358,8547,431,7265,7661,8947,6130,8047,8034,4068,5142,7605,9558,9652,7143,9959,10060,1769,970,9053,7164,4464,8282,3872,134,10238,2736,9378,10531,9920,9264,7607,7913,2467,8714,8876,9607,9824,8828,11201,7655,7674,10315,7661,6119,9608,11363,11713,11117,11631,11632,7252,11674,11312,10506,11683,6843,3702,6809,2753,7158,1516,6785,2328,6941,6001,5995,3550,2389,1029,6947,308,2932,4337,217,4639,4769,7101,3261,7548,1351,6740,5576,834,3197,7022,7238,4109,1461,223,501,5454,308,6780,4701,7837,7903,7835,7775,7836,7761,7827,7938,2658,3549,5334,3698,7838,3647,8222,1662,7019,223,3346,358,3754,4535,7239,8390,2029,5763,8547,8611,2006,6365,3554,8358,8561,9300,9297,9880,5719,8828,8768,10008,4395,396,567,464,6782,6891,5551,1029,231,1834,6365,7146,2753,6809,3029,1738,6845,6831,2467,7634,6785,6364,2029,6813,6644,1402,7593,7838,7592,3850,1755,6175,6700,1462,3169,958,3646,6967,6383,2253,6366,2913,7149,6642,5376,6644,2261,5046,311,7872,3428,6548,7605,1998,6130,6104,5484,6845,6809,4412,7022,2490,8178,665,7871,7994,7982,1116,6364,6979,7981,2761,4079,4405,8220,840,7992,4860,446,501,4178,5996,7548,5371,7840,7878,7879,7635,4834,7787,3850,2009,1453,850,6563,6568,3913,8526,6726,8903,8816,8814,9030,223,463,9085,8094,8095,8488,9052,223,6740,7238,8220,9379,9321,1738,6809,9422,9198,8241,7374,186,7681,1215,3217,7806,6588,6599,358,7840,7878,7928,7869,7214,3465,5810,3519,4570,725,7938,6160,2342,8628,840,6843,1126,8109,8935,5484,1398,5770,7505,7505,7301,7301,4639,6239,7374,7374,820,820,6613,5996,8306,8828,8828,8828,8828,8828,8828,8828,8828,7130,8973,8973,8973,8973,8973,9471,1771,1770,10041,1771,1767,1767,1767,1767,1767,8864,4199,6809,9391,10892,10543,5376,8515,7222,1116,9295,8919,156,8919,156,2698,8763,6855,2331,4395,7855,3549,5334,9546,6780,9546,6780,8192,1915,9827,7865,9647,8290,9386,9835,1308,9916,1308,9916,1308,9916,9299,9195,840,6621,8685,6726,4769,8668,8793,8668,8793,7910,7205,7761,8222,7761,8222,7130,3989,7130,3989,7130,3989,7102,916,7899,358,3647,176,7908,915,1385,1385,5947,1565,8220,7974,8110,7904,7605,2063,3250,7032,6175,800,5915,6832,8393,6210,8055,8055,7833,5848,6588,7903,1662,7023,2269,5688,8942,6618,2182,8948,1385,8554,6785,6785,126,8940,7585,7175,7130,8547,9295,4834,8933,9295,9295,7130,7130,6726,9602,173,4029,4779,4779,5431,28,4762,4762,9295,4218,4218,1771,1769,7238,1767,1769,1769,1768,1766,8220,8220,6364,3884,3926,382,374,7069,7298,2009,8166,1537,7879,7104,8390,7878,1537,7078,6740,7238,2843,7290,8095,8094,8488,8587,186,7155,7649,8741,6754,5576,2869,1351,834,8381,8886,7932,8698,8580,7089,8816,8966,9092,7781,8479,8836,6381,5362,8745,8109,9321,3029,1152,1532,9300,7266,7674,9386,8230,9001,9300,9463,2467,4109,7635,7289,6971,9897,8401,9948,9783,8526,9879,7928,9349,2033,6842,9319,1834,9879,9552,9936,9552,8555,444,9925,9931,61,3241,6069,10272,8828,176,9295,8165,7235,7721,650,7001,6565,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,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,9378,961,5995,10188,4029,1770,1765,9951,9258,10056,10212,3014,7921,8967,8257,6367,9116,10526,9418,10669,4406,10039,9418,223,10518,10935,6831,10919,3913,10375,1371,2594,1988,11228,10892,10665,10649,9904,223,10518,9897,8774,10386,7130,10381) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC