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,958,5995,5995,6833,6710,8456,8456,8452,8181,8229,587,8782,4769,4769,3864,867,1886,8579,6958,8621,1984,6738,7204,8650,5439,8196,8623,6648,2643,8435,6701,8633,8255,8130,6820,8542,6959,8622,6960,8624,6687,6972,6973,6974,8112,2775,8579,6693,7861,8196,8196,6138,6138,7999,7998,6173,5548,5548,5548,10000,9865,1787,1699,6102,5995,6104,4395,5339,5817,4639,6364,5906,6103,5916,5688,1016,6713,4800,4827,3542,3625,3474,5764,4784,4087,6858,6691,6782,6829,3554,5175,5965,4424,1755,1764,104,3574,6951,576,609,2849,5763,4510,4087,4046,1345,6809,6979,2300,6731,458,6845,7358,5961,1988,3719,1993,7214,7019,3704,6795,7839,4224,7605,7890,3823,4774,7810,3908,4659,7920,2643,2658,8196,233,1511,1984,8548,7883,7216,8144,8031,8514,8089,2294,4258,222,2989,6006,7804,5252,1984,1458,1084,8999,4452,1490,582,3492,1823,9028,9212,9213,9079,3712,8224,4613,4704,1300,2849,9116,4082,4136,9372,8559,2491,8358,582,5961,9258,9375,5636,207,8274,3890,3891,3893,539,542,3896,8271,3882,3892,3894,8273,3884,5567,9937,1253,2933,5545,4178,446,3889,9377,9799,9212,535,3244,6642,6891,4082,10000,6858,10228,539,10243,9438,9437,10181,10568,385,389,8858,8789,8515,2356,380,10354,8787,8005,4087,3401,3990,4613,8534,3474,9439,9214,9930,9648,10120,9680,9764,4046,4411,1490,4049,4050,1973,6738,9823,3493,6876,11027,10114,5175,11298,11020,11235,10674,6591,11339,5207,9243,11495,640,5732,2023,6023,2221,6034,8941,9405,7374,11359,984,11413,538,390,6066,540,532,528,11353,6894,5262,608,7810,924,6740,7238,5927,6190,511,7213,6979,801,958,6725,6270,372,6004,7872,6349,7828,464,2897,7912,1151,408,3647,7861,5965,7994,223,6593,7599,7605,4395,6364,4320,7982,4535,8626,5959,8947,7874,8969,2253,9014,5763,8281,8991,5952,7128,7148,8836,6891,7146,7773,4362,6715,2594,3581,7499,3337,5251,1126,5331,6138,4923,8024,1307,1307,1307,1307,1307,2643,8137,6738,8250,8250,8250,5995,520,5098,4503,7916,4920,4920,4920,4349,7953,7953,7953,6606,7493,8831,4544,6583,4399,6396,7917,6394,6402,9616,10731,1765,7493,9949,748,958,6710,3989,1953,6593,1038,6779,6103,6947,3550,4131,6804,6842,6986,2261,6858,6863,6691,5142,6315,5995,6981,1461,7126,5046,7019,6548,7005,7214,7036,228,7138,6890,6632,6693,3702,7156,7221,7304,7050,6633,7143,7354,6104,3561,739,1521,7758,7760,7582,7718,7614,7759,7596,7709,6856,7830,7795,7869,7359,7883,7804,7871,7880,3625,7896,3609,7875,7751,7897,7995,7992,8031,361,714,8109,8032,7991,8183,8089,7839,8096,8102,6792,7559,8146,8222,8300,7938,8185,7920,8150,8293,8390,8230,8103,8299,1345,840,6642,8483,215,8302,8226,8548,2473,2467,8306,8526,8305,8358,8554,8611,6076,1815,8561,8535,8547,8514,8615,8629,8687,8659,8614,8479,8688,8802,8801,8632,8759,8744,8776,1920,8829,8807,8809,8902,8888,8901,8793,8999,8918,8911,9030,8841,8846,8900,8916,8925,8923,8781,2005,7912,4716,8686,9153,6715,1462,9086,9195,9220,1296,9296,9308,9198,3823,4671,9322,9324,9202,9200,9363,9348,9289,9291,9454,9420,9419,9258,9480,9453,9402,9372,9614,9335,9637,9376,9680,1380,3337,9524,9552,9751,9763,5784,7849,9479,9810,9812,9674,186,9616,5956,9543,9062,9386,9829,9934,9879,9925,9668,9951,9904,9916,9482,9931,10041,10114,9913,9990,10142,9941,10042,10125,10149,10063,10128,10126,10115,10174,10020,10188,10245,10246,10236,10131,10248,10229,10208,10227,10211,10282,10148,10243,10244,10212,10065,10305,10319,10265,10279,9936,10269,10268,10338,10342,9603,10293,10436,10466,10290,10505,2635,10438,10491,10375,10488,10535,10526,10485,10127,10548,10528,10527,10569,10273,10627,10676,10631,5769,10339,10681,6658,10731,10760,1979,10775,10649,10841,3327,10294,10721,10698,10826,10839,10955,10940,10895,10687,10932,10766,10938,10802,11024,10992,10872,10987,10416,10894,10402,9925,2913,6131,10541,10664,10279,10491,6715,7849,10759,11074,10989,9386,10394,4405,9936,993,7135,10505,2117,8947,9463,10339,10653,10649,7003,9536,10683,10518,10002,9900,10368,4769,5770,4801,7160,2521,2522,5647,10526,11266,8223,9116,5839,10368,10974,9983,10904,11443,11442,9669,9670,3849,3564,10719,11101,10316,10736,2164,3282,11657,11673,10093,11451,11659,11658,11660,10375,11714,11314,11681,11703,11494,9471,41,9897,582,11620,10886,11346,9868,9942,7027,11486,10840) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC