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,6710,4121,1351,1126,1257,6010,3878,1210,28,2995,3896,6642,182,4653,2342,2753,3889,3884,3893,435,2530,958,6842,1080,2123,5251,6818,3872,923,1056,1198,1207,1533,2451,2725,2736,3014,3803,4645,4779,7288,4784,4872,4791,5431,1370,1370,956,947,7245,4785,7840,5516,7110,1425,233,7112,7114,7096,1119,1119,7115,7276,1121,7244,7280,7106,8033,7282,7249,7243,7081,7241,7101,7281,7281,7117,7278,1559,4217,4624,5148,3989,254,5516,585,6250,4220,6255,1498,1439,2954,1073,1954,4005,1830,6117,5764,6635,3904,4046,4128,3368,6155,1113,1163,1681,1690,2915,1038,4050,4049,4045,4233,7262,7244,8206,7263,8206,7263,7661,7662,8063,8087,7099,7068,7284,7282,7264,7286,7288,7106,7268,7089,4209,6863,7984,7654,675,6263,6167,6663,3029,3585,5179,446,6439,801,1070,820,1498,975,396,6635,501,6766,6766,2706,5148,7238,7238,585,5536,249,5331,2025,2118,1681,2123,3023,7003,834,6189,7022,5947,3913,7387,5070,4796,501,576,6763,7707,7119,1116,6925,2282,2283,6764,6765,6763,7101,7275,7241,7280,7290,7276,1917,7153,5516,6710,1738,4061,4411,7830,1439,176,7992,3493,7869,1681,2669,2123,8193,7019,7938,1487,6633,7920,8193,3904,739,7759,7839,4950,254,4411,4258,4209,5542,4234,6104,5339,5286,1253,7857,501,233,5331,5286,2976,3830,8183,231,6858,2294,338,1461,8183,4355,7304,3080,1347,4460,5545,2933,231,1520,1461,5516,640,254,1119,6632,3080,1681,6248,7126,4796,1119,1762,7883,6245,6256,8548,6248,6255,8502,3976,1699,5543,6249,5732,7839,419,6250,9372,1485,8819,739,3850,5331,1433,3368,320,5764,3715,3542,6792,1559,6117,5373,6635,4131,5331,6559,6782,4185,2294,5349,5542,5142,3625,5717,3368,6713,1038,1299,512,2160,5215,511,1521,6315,5020,6639,1347,3037,6693,6595,6548,3080,5339,2933,6858,922,608,6154,24,6700,5247,223,5885,6367,3026,3904,5875,36,5837,6584,30,239,6674,748,1536,1576,736,585,104,510,6713,6560,1253,6792,504,754,3474,6862,3863,2387,768,1067,1113,1347,1872,6793,1523,7138,4028,1526,1569,2381,4194,321,2660,2419,7005,2639,1055,5331,4126,511,4061,6188,2299,1647,5764,3413,1727,5614,5817,4362,6845,955,7358,6809,6104,4923,1568,741,3419,1823,3561,3933,2976,3701,6699,3936,967,5236,2590,7839,4553,7012,1134,7025,7883,784,1920,7759,3117,7780,3134,7840,3129,7876,7760,7712,7859,7879,7821,7858,7855,6981,6315,4624,7865,7856,7719,5543,6734,2882,6697,7920,7896,6679,4258,4460,6986,5545,4566,7126,252,1268,4969,7354,2244,7919,8089,3100,4128,8000,7156,4901,6684,4082,6337,6314,4730,1073,5047,1439,1127,1298,7550,8543,6131,4886,7840,6740,7238,8220,8215,8225,7827,5739,7559,6117,6365,7981,7138,8900,1311,6945,3195,6478,4432,8888,8902,6136,2018,360,1698,8901,3542,7605,8146,1521,156,9036,969,9200,9279,36,9116,739,2387,6792,6713,9329,9244,9372,9322,9374,2944,3542,9273,7580,7138,1349,9258,1215,8306,6337,1521,6942,8925,7038,8681,9018,9051,8698,9050,8687,9109,4023,1432,8031,1257,9406,7005,6663,6664,4652,8514,8795,8805,9363,9454,8910,9402,9391,9333,9421,9335,8978,9346,9366,9308,9197,8934,9248,7839,2514,8817,5180,9041,2841,2246,4679,4504,609,7354,8254,1005,9249,1586,8935,9471,3549,5334,8794,7910,8547,8955,4765,6780,4194,5215,1576,2117,8915,752,2387,8193,8019,254,5516,4538,6684,6642,5121,9459,2709,4405,2669,428,9600,2123,5602,2118,1762,9604,9606,5379,1681,1572,1498,6874,9627,5640,4099,6867,4056,3457,3964,228,8629,1080,9038,3023,9638,2743,162,9455,1121,9634,7581,1119,9335,5046,9653,9657,6663,9635,9383,9677,9665,9345,186,9296,10072,9052,1881,10449,10394,176,9915,9868,4233,4659,9887,2925,2123,5640,10016,9931,9548,666,9005,10566,10013,10015,10017,10018,10108,10109,10110,10619,5955,5959,9950,10315,10086,10620,9403,10621,10648,9481,10012,10726,10728,10555,8244,11042,2709,9416,8917,11082,11085,2743,8260,11050,10522,6600,1762,1681,11050,8336,9792,10606,9231,5656,10970,10607,8319,8874,7370,6485,5516,8599,11050,10324,8875,10799,11055,8598,11139,8699,9112,11009,10963,8193,11008,11137,11149,11048,11047,11151,2826,6442,11054,11157,2827,2825,11057,8242,11160,11159,9409,11138,11161,6489,2815,2823,9184,9410,11158,2822,2821,2824,11156,11240,2816,2817,2820,2818,9407,10565,11218,2806,2808,2807,2812,8219,2009,9543,9134,7671,9647,10272,1461,10532,9453,8240,10229,10274,1237,10548,9745,6261,180,10024,9675,3059,10528,6983,10733,10362,7064,10914,10904,5252,9554,8925,11027,10114,9373,9045,10938,5764,107,11123,11105,10127,11020,10904,11044,10870,11180,11136,9325,11136,9991,10935,9374,8557,10148,8093,11338,11339,36,11262,10934,2160,10048,11353,11442,10469,11172,10685,11289,11436,8955,10467,10738,9471,9942,9945,3159,5692,10129,11423,10915,11202,10312,10733,11439,11388,10719,10244,11620,11669,11377,11288,7910,11271,11018,7362,9352,9290,11658,11717,11455,2590,9081,10938,9050,3396,3368,4131,11492,11717,10554,24,10832,11775,9353,11787,11703,11681,11838,9221,11819) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC