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,2417,2035,7132,6130,5996,5782,458,6177,4218,714,408,1084,6349,6642,1881,6710,6741,5953,4765,6709,5949,931,6779,186,867,4597,2520,6789,579,5093,431,6813,6986,4898,5923,6561,6832,6622,6348,7019,452,5769,850,6842,2458,1616,2490,7239,405,698,1151,617,3395,3046,739,5088,5647,6004,6804,7359,3609,7547,6193,7374,7759,582,1461,7760,7776,7872,582,431,7899,6312,7790,7889,7908,8031,7871,8103,7907,1265,698,7889,2521,8110,8222,8214,7962,7953,8183,8388,8195,8182,5455,446,1815,8483,8547,8358,7547,8390,7022,961,8629,8611,8725,8765,2006,2029,8793,7128,1052,8835,2989,2310,6622,6115,6190,6193,7790,5998,2093,8947,8918,2156,9027,5484,244,9038,2374,1982,8060,7576,1086,6817,220,6975,1511,8110,2169,2157,5959,4769,7657,2643,7123,5024,6139,850,226,6972,7846,2384,6139,3247,2787,2998,1084,7286,2117,5996,3863,7256,7068,7261,7304,7661,7662,3327,3327,7655,7655,8081,7655,3896,1973,1973,8951,8951,8951,7985,3895,8273,3892,7655,7655,7655,7655,7655,6646,6394,358,7288,8768,6962,6383,8523,1664,6110,8523,186,5965,8831,7912,6715,6832,6402,1296,3823,3865,1380,7912,6383,8356,8355,7805,7918,9498,7541,7541,6367,7918,9065,26,4437,1345,7505,6897,8659,2635,9762,8005,9729,7711,9467,2384,6394,7917,1726,6174,9729,9856,9975,9975,9737,9737,10056,10035,7966,7966,8130,7917,8491,6174,8296,2925,7634,4834,8142,8617,1974,1993,1974,1993,7840,7879,7840,7879,6728,587,6728,587,8683,8683,6770,9403,7048,7847,3926,450,2627,3949,2628,4178,8565,8831,4716,9865,4716,9865,3913,6869,3913,6869,3913,6869,576,5484,993,6806,1215,5995,1215,5995,5435,8292,5435,8292,6619,1609,6618,8196,6618,8196,7912,2005,7912,2005,8290,7266,8290,7266,108,108,5421,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,9916,9916,9916,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,8255,6658,9932,2474,8956,9009,3908,2337,9384,814,4330,7203,4234,7059,6624,9879,1357,7203,814,8856,8855,8761,1698,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,9771,320,10292,4862,10072,10219,10273,10294,10211,9338,10142,10061,10291,10041,6633,10291,10320,10164,10078,10319,9822,9277,10397,10548,10060,10548,8610,6870,8951,8248,8314,8339,8320,8336,8313,8598,8338,8271,8272,8335,5297,8088,8727,8003,7881,8627,8260,8873,8872,8946,9115,9113,9112,9111,9114,9119,9120,8872,8088,3719,3115,3559,8705,8704,8174,3115,3719,3559,8946,8003,8333,8309,6371,8699,6372,8317,8332,8330,8328,8312,3559,8704,8174,3719,9625,5995,9592,8306,9411,8088,1257,9410,4947,3493,2033,2915,9383,6710,9661,6986,6876,9910,10102,10101,8031,6779,1881,9749,10227,10229,1520,8681,8698,8817,1626,1215,7953,6209,9949,9186,10269,6,10494,9649,6550,2447,10302,6870,9300,10873,9547,10212,10060,6550,7788,10211,10116,5913,1097,7910,5810,7869,10736,1458,10707,8541,10649,4659,10296,8290,2458,5567,5402,7828,2913,7775,916,9934,10986,6700,4639,3334,3358,3385,1250,10649,10826,2164,4827,2989,9557,8780,2749,1487,10321,6170,9883,2986,1764,7299,6855,10093,6806,7587,10781,5402,6832,6691,8968,2328,5371,1521,6645,5582,3346,850,4362,6831,1371,5996,421,6795,7602,4798,223,6890,5927,9694,6785,7214,7639,9900,9386,6687,5543,5142,8876,9244,9362,9389,9387,7144,3728,10129,9497,10116,9951,10001,3081,10313,6130,10312,6889,1453,8828,10956,10517,10240,9959,7783,6633,3414,4834,4399,10818,10131,5947,9354,2467,3878,9545,104,156,7613,8219,11102,7920,2447,9828,10850,11365,10269,10649,11290,3908,10666,4984,4424,11136,11454,9838,10955,661,1145,11588,11523,10934,11603,1460,1318,8539,6831,11300,8610,10888,10720,10976,6870,11189,8144,8030,7149,10011,7910,8208,4254,8892,5763,8891,5371,10768,11386,8370,11384,9557,8482,7280,1049,10869,1343,7277,9757,1016,5988,10007,10649,9739,9959,6103,28,7208,7247,9740,10854,10855,11188,4598,11471,7641,11277,8400,11402,11553,10906,450,10011,10694,11271,10510,11572,8577,8471,8547,10818,9136,11676,3908,10483,9563,10884,10372,8,11707,11634,11706,10275,7273,7248,11709,11743,8279,10270,10977,11746,11771,7088,11776,11376,10965,2447,11704,10789,8178,11818,11839,6264,8022,11840,11283,8891,11879,10051,4659,7281,9609,3967,11337,2847,9303,11927) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC