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,3878,6383,8355,675,7157,7992,8358,217,4563,8091,7546,6700,8613,4435,6801,8544,6316,6631,4979,6715,5568,8217,3598,915,8292,7912,5681,6733,7711,6774,5380,7840,8581,1770,1536,8278,8193,1765,3933,1771,1767,7592,2998,1511,3712,1485,924,3744,1769,5656,1768,1766,1762,5551,5020,8108,867,1886,8579,6958,8621,1984,6738,7204,8650,5439,8196,8623,6648,2643,8435,6701,8633,8130,6820,8542,6959,8622,6960,8624,6687,6972,6973,6974,8112,2775,8579,6357,6209,6205,8833,1380,6715,6548,8281,3913,9300,5995,4671,6865,6569,5769,8710,8710,8710,9340,5484,3327,7211,5788,6892,2467,2349,8137,9946,4435,3336,3336,9791,778,8358,223,7374,9125,5484,8780,6891,3949,6642,9340,6367,4801,9300,1349,4450,3784,4259,3531,5400,4405,2658,6855,222,6740,4259,3784,4450,8358,10627,6010,2033,10056,8535,2932,4639,9603,10836,7738,1666,3784,4450,11101,5371,3783,4259,4535,3428,7374,9340,8491,4395,2389,2399,4519,5602,7374,10649,8683,5070,10649,10764,10892,8714,2594,5484,10257,1398,2594,11402,11497,10257,11324,11315,11281,11497,9320,964,8917,8884,6795,4558,8220,7207,9300,5516,7906,7572,1591,6102,3457,4769,8268,8202,8399,6264,8425,8200,5994,4362,7280,4218,7897,358,7548,2399,6819,5380,4320,4320,7597,1371,156,8223,7281,7655,458,8947,461,4900,9292,5784,6578,7204,1380,8580,8404,9584,9582,9583,9585,9650,2913,2253,455,6843,7114,7547,8614,1492,7664,9737,7953,6953,5371,104,8869,6181,9135,9049,7774,4395,4146,10349,9543,2897,10228,9405,1770,9758,10339,788,10309,11010,120,10754,10985,9543,4659,9340,4568,1782,10000,9770,9714,9753,9863,9701,4435,11298,10649,6548,11347,10892,2467,2989,11454,10780,11622,3327,11623,11227,9765,5269,11497,156,11621,10455,11752,11751,11101,11748,11325,713,10670,7374,1398,6678,7270,7251,7251,1126,6595,6447,2849,7856,6595,7296,7856,3595,6795,7296,7904,7714,7879,7271,7101,8053,8058,8034,8076,8040,7119,7931,8046,7878,7548,6155,7946,8284,8209,6235,7273,8373,8418,7840,7878,7879,7115,8481,8573,5320,8220,7280,4878,5320,8720,7971,7275,7297,7971,8761,7298,8419,7670,182,8683,7761,7547,182,3895,2522,8682,8618,6936,6938,7675,8698,8739,8933,9030,7124,3080,8412,8908,8580,7103,7083,4258,2605,8847,9134,8358,6354,9336,9134,8042,9244,9329,3070,9322,3073,1349,4460,9071,7087,9449,7239,8064,8458,6514,6514,8405,6986,9312,8832,6700,9367,9093,9777,1381,3760,8436,4299,3541,4160,8681,9958,9874,4178,2253,6619,9143,7368,1770,1765,9932,10109,10087,9603,8724,7113,9603,7649,9200,10008,1767,1771,7692,7690,7686,3172,5837,8896,1609,4805,3071,3875,8220,7020,3590,1766,6740,1688,9963,3282,9769,10008,6828,1787,6642,7752,2261,8220,7973,7751,9146,2915,10379,2349,4847,4847,4728,675,1785,169,9951,9486,7368,5245,9951,9082,9026,6658,9932,2474,8956,9009,3908,2337,9384,814,4330,7203,4234,7059,6624,9879,1357,7203,814,8856,8855,8761,1698,1308,1776,6030,3250,1766,9873,9833,3893,8793,1461,9344,6715,7235,2784,7246,9893,6427,9052,9115,9052,4566,1165,7903,3380,1215,446,8942,7823,9824,10742,4535,10475,4535,10475,8742,10228,10965,6728,6700,8080,10737,3860,9676,8669,576,9496,10929,4947,7598,9547,6416,10422,10381,6764,10264,6751,544,6151,6763,8160,6493,7705,573,8158,9859,1664,7605,2605,10416,2270,10742,8394,5484,10356,7751,10789,11289,6776,5487,9368,9367,8323,4730,93,11268,10836,10056,9300,8082,10768,10767,11719,11781,8910,8514,10722,10722,11670,7895,10543,9406,11846,6768,2658,7897,947,6658,2005,8866,8866,7420,7535,7535,4769,5770,5567,5024,5484,4094,5769,587,6631,8196,7256,10731,5858,3043,5068,9442,1993,378,11328,10348,11400,1153,9817,9819,9820,9818,10095,8229,8371,8712,8571,7261,461,8721,7287,7861,7088,7086,8040,6702,9946,7048,8715,7535,9340,4996,6482,11101,10056,5567,10531,7987,10840,8191,3890,7987,7808,11209,5297,8682,3896,11215,11307,10646,9129,3358,8244,6688,11322,8897,10520,11049,7176,8874,11013,8618,11015,7632,11432,11414,11463,9865,10932,10984,11204,11147,10326,11205,5635,11418,9524,9863,8963,9268,10932,11101,10716,10670) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC