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,7677,7169,11349,8943,8944,11235,10895,7881,7752,10568,8627,11237,9922,8945,11361,8585,10975,11314,10354,9249,10747,11423,11272,11458,11396,11488,11287,11456,11495,11493,11492,11372,11377,6442,11476,11599,11549,11521,3549,11123,11435,11443,11489,11412,11595,11414,11498,11661,11604,11027,8088,11552,11288,11678,10532,11690,11655,11722,11724,11646,11598,11456,11465,11420,11498,11481,11488,11293,6561,11549,10245,8951,10221,1116,10085,10350,9096,10267,10219,10042,9033,9220,10246,8022,148,9758,10127,2337,9086,3625,10464,9934,10523,10548,9136,9543,9283,9200,10568,10569,10244,9283,5373,9904,675,9212,9377,10787,1626,10842,5895,9258,10892,10663,4199,10895,4046,4355,6734,10899,8610,10749,10938,9763,11020,11018,11021,11018,9548,11084,11106,9763,7655,11028,10870,8282,36,11126,8370,9053,1253,2294,11196,11172,11171,11108,11237,11235,11237,11288,11285,11349,961,9928,8799,11396,3244,11423,4537,30,11281,5795,11397,10879,11100,11377,11488,11517,10741,11455,11142,10784,7581,11489,11491,11521,11613,4258,3964,11379,10002,11681,11689,11644,11670,11816,9325,11838,11870,11783,11785,11871,11901,9657,11921,11873,1439,7268,2776,5143,5764,2160,6981,4061,501,2706,8031,1038,7919,2976,466,4901,5247,1207,4730,5837,3803,3037,5543,2381,4766,4624,6809,6845,6104,2882,5251,739,3368,2590,2419,8146,36,1298,3396,7036,4648,6861,8514,7839,5739,1127,8910,8687,4460,6862,7896,4665,8010,5997,7981,946,7920,2294,3080,5339,5545,4258,1347,1253,6945,661,254,6136,6314,7025,5215,4886,4950,4969,6397,9366,180,6595,2933,8629,9402,9079,9554,9639,9725,9290,9807,748,9811,7760,9925,9945,9769,9448,9459,9677,9730,9680,9768,9764,9421,9930,9933,9045,9910,10003,9038,9779,9675,9749,7883,8999,10212,7839,10668,90,7632,10685,6243,6250,6256,7617,7618,8502,5066,6872,6898,5247,7719,7023,7206,7816,7815,8714,10894,9824,9933,10061,10821,10840,1699,11021,11122,11028,11106,11089,11126,11123,11020,5693,5854,6095,6248,6252,11426,11442,11443,11107,10679,5988,11455,11458,11460,11461,11436,11136,11314,11645,11423,11774,11775,10935,11816,11135,10784,7149,3043,4512,2520,8305,6642,3728,6780,5484,4936,6138,452,222,1181,8933,6364,8995,9104,8960,4944,8962,665,2998,8999,8182,4901,8306,1245,8141,7852,8613,8910,455,1912,9208,8970,8231,1738,2974,2151,7920,1055,1727,6855,9389,5623,2299,2639,955,5765,9223,9222,8844,9224,9255,9250,9402,3303,8965,9623,8960,4969,4128,254,5516,4656,9011,9290,9556,8812,8151,4049,9275,9344,4046,6986,9397,9766,4061,9777,9464,9951,9959,9827,8554,9910,9931,1016,10012,5236,10040,10014,3908,5046,10017,10015,10019,10004,10109,10110,9243,9981,9250,8762,10056,10090,7759,4099,3936,6766,9758,6571,10013,8889,10086,10242,8031,10018,9482,9541,162,4566,6876,10104,9538,9652,10021,9926,3590,10039,8844,8870,1568,10361,10397,10055,10241,2639,3415,10267,10355,10358,5839,10547,4056,9402,10480,9243,10619,10620,10621,5039,9273,8019,6681,8305,9647,10227,10711,10718,10063,2639,3844,1055,2299,3585,10720,10785,10350,10895,9558,10003,10619,10783,10784,5193,10734,10856,10380,10966,1485,10439,10440,8193,10805,10552,10820,7760,9749,10895,9968,10857,11028,9798,10149,10476,10715,10878,2954,9634,9929,10364,10131,10283,10284,7581,9648,9930,10648,10711,10990,11142,9961,10895,10964,11018,10135,11123,9347,6857,11220,2506,36,11234,11302,2446,129,9471,8543,6117,10476,11272,10935,11314,9961,11383,11382,10413,10786,228,11287,10748,10749,10397,11106,11395,11424,10870,5877,11304,10129,11302,11473,10934,11446,11423,3964,11396,10785,11171,11602,11608,11442,11443,9347,11599,9961,10413,10608,8441,7835,10719,11353,8441,7835,11655,10819,10911,10672,11344,11646,2160,6117,271,4886,6981,4901,4730,5245,7837,1645,4767,423,7834,7836,7919,7903,6205,7835,7821,7143,7833,7761,6478,1461,1325,1970,6595,1433,8222,2992,2029,4160,7760,7760,5542,3080,7130,7130,8812,8813,7852,3169,8250,6397,3913,6876,8098,8098,9222,9223,9224,9250,1536,9300,9017,61,9275,6870,6870,4346,9243,5286,5286,5997,9073,9614,9366,9552,9769,9477,324,9478,9641,9118,2660,8610,8184,5252,9925,9925,9921,4510,10088,10087,10090,10089,10056,10086,10210,10079,2137,2137,3936,3525,10227,10229,9624,8705,9766,9968,9959,5763,10375,10212,7149,4178,4178,10608,8441,10523,9376,6103,9297,10434,7972,10548,7973,10382,7585,10397,6264,10711,10056,10315,7218,10748,10702,5567,7889,10870,10127,10749,10127,10350,11093,9255,11324,11455,11396,3059,4739,11105,11489,10754,11517,11302,10012,11130,11741,8812,958,4741,11789,9777,4987,10832,9929,11423,11134,10784,11454,9634,7719,10019,11679,2761,11315,7592,9767,3493,7554,7755,7756,7754,8509,7927,8922,178,177,179,6117,3549,8305,6857,5334,11271,7581,6780,8543,9648,9347,9798,10149,10476,1767,1771,1767,9931,10711,9327,10780,10569,6181,5188,10741,11324,10609,10820,10617,8520,5576,11396,9737,11849,11774,11342,11765,11266,10692,7019,8222,7761,8845,4109,9195,1662,4796,7837,7834,7835,7836,8441,9297,9552,7003,8851,9614,9300,9030,9960,9925,7641,8617,9548,9879,9897,10056,9525,9463,8296,3989,7634,6726,6849,6971,9890,2164,8281,9488,10526,9085,10265,8948,186,2632,10836,10302,10471,8962,8726,10549,2261,10480,8816,10531,1461,11121,10464,1645,11128,11230,9951,9000,11325,7909,11304,176,9814,8995,10064,8109,6712,650,8512,3849,10656,6571,11089,10636,11494,10040,11644,9993,11741,11219,10938,11324,11455,10548,3595,9993,6876,8388,9634,11302,6894) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC