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,6740,2530,6792,510,1349,2389,4338,2766,972,1245,6354,6849,6858,7238,2137,320,1095,2253,6644,1070,6732,5142,5134,5707,6730,5837,7304,1268,4983,4128,3701,6693,6857,6315,252,2253,4099,2244,5657,4401,6962,6364,7303,3046,1000,6190,3244,322,7239,5582,2467,7146,223,5582,7598,7600,1073,5602,464,6633,1029,7631,4079,4432,5678,6671,4349,3595,5995,5623,2151,1681,405,4234,6645,732,319,1110,1371,5764,3731,5247,1572,802,3368,4538,6861,5692,1536,6639,739,2419,3550,4796,219,6075,3396,3037,4217,5460,2698,5743,3159,3437,2381,922,6862,3754,322,4445,606,2590,5179,3698,1915,447,1313,1298,1688,3625,4199,2934,1038,3447,1647,2723,2298,2446,4861,1461,2863,2387,3482,1576,2183,1159,1416,3396,3264,7709,5631,7036,2876,2419,1830,2518,2653,3217,3558,943,955,7228,6124,3788,739,4801,2299,1575,6858,1522,7126,4722,2639,3989,3304,36,7003,5175,4021,5807,8306,4460,7221,5215,4194,2387,1576,6731,922,4798,7920,7839,5543,5543,5247,4766,4806,8945,7753,3037,8088,9045,9045,9045,9045,9045,9045,9045,1699,5995,6117,3041,2705,5999,5328,6315,4131,2514,6314,4023,5180,6595,4682,6639,6674,6560,2590,6635,3368,6686,1113,6793,6792,2337,1298,252,3396,3542,3413,3055,2419,6713,4082,5373,3715,2967,6710,6857,6700,4136,1521,5596,6862,6863,3376,1992,6861,1698,2737,5812,6478,5379,6779,5142,739,6595,5739,4886,361,2046,3962,3135,1299,7016,3625,6782,5875,5349,3041,1164,4209,3534,3195,4805,3139,6979,7025,4553,6699,6734,6697,4048,7156,5047,5246,6694,6397,3941,6337,1698,7209,7005,6986,4875,5536,1067,5222,4570,1992,6661,5885,2737,7356,7558,7559,7582,7156,7550,6711,7709,3376,7593,6665,7143,3976,7857,7815,507,7875,7821,6694,7760,7896,6697,7876,7920,7581,7777,8016,7774,1432,5536,2294,6673,8089,8102,8140,8184,8215,1559,3904,2894,3195,4432,8291,5817,3775,4355,1835,4625,4740,5545,1347,3976,5081,4460,4741,6707,6478,1698,3941,8306,4739,8224,8543,8547,7025,8016,8104,7615,6858,1432,8480,5545,8175,8174,8629,3559,7016,5013,5875,8632,8687,5807,5328,8561,1347,2294,5543,504,3431,3474,7251,1521,7140,8782,8777,8809,6732,8819,4613,8812,4766,8801,8846,8813,8904,8905,8911,8208,4553,8916,4773,3244,8979,8978,8224,8104,3139,6665,4741,6699,1300,8974,7815,5906,9052,9072,9122,9017,9036,8888,9195,9196,9197,9200,9038,8704,9212,8231,2092,9220,9222,9223,9224,9255,9250,9273,9289,9291,9300,9301,9298,9242,9308,9317,8110,9278,9334,9347,9335,9337,9352,4049,4539,9363,9365,4316,5298,5003,958,3059,5175,7021,7016,5379,6809,7374,1645,6774,5279,7307,2342,4574,6006,7837,7834,7835,6845,2261,6104,7836,2644,1307,4979,6880,5236,5373,6713,6368,7020,2387,7238,6821,4624,7951,4901,6658,5131,4406,8222,4136,7582,2337,7016,1920,3625,5005,5286,1257,6713,7759,4741,5081,1521,6866,7875,4258,4739,6707,1895,4131,2703,3936,784,7839,3129,3542,5614,4082,6986,2294,4209,4596,748,3080,4566,1134,1439,3413,4656,3117,5817,1347,5732,3134,7005,3913,4460,3115,3976,6117,6793,1738,6595,608,4100,6639,5339,1253,5545,1215,6684,7126,3341,6858,5812,1347,6314,2933,7138,7156,4652,6713,608,6635,7559,6858,222,1349,7581,222,6857,7550,836,6679,2023,3454,797,4088,6792,7839,6674,8220,6703,7354,2875,4773,5025,5541,3368,8031,6686,8548,6337,6942,8548,3080,6986,2737,7875,4513,8134,4194,7615,5379,3263,1127,3162,4432,3195,2419,5629,6732,3201,3701,4740,4613,8543,1432,5477,8224,2387,8615,5175,8006,1532,1298,4539,8146,8587,1089,4875,4023,1698,609,2446,8535,8105,2594,3003,7896,6861,7709,5807,6124,6809,4411,5215,7362,5536,3558,8089,3244,3391,5020,6704,6595,2018,3559,8175,507,1439,36,6845,3139,3288,6821,6880,4538,6610,4258,8999,8900,8837,922,8101,466,4788,1303,3511,1215,156,1250,1498,6130,4767,5400,2029,2736,4558,1425,450,5995,3026,4791,1210,752,5729,1762,2743,5431,6490,6561,435,1398,5922,1461,4128,3936,916,5936,964,1497,3558,5251,5629,2054,5924,6986,6710,1433,1537,1917,7100,6632,104,254,1089,1215,4796,2337,501,7113,4861,7102,4762,1349,4216,5322,7280,4199,714,4220,7054,6707,4519,4401,1371,7304,5371,7097,1145,2023,6264,7072,6104,5535,934,6365,609,4983,7938,4233,52,5430,6561,8306,3244,223,2677,4639,7238,6740,8590,8183,1439,7875,8615,7023,5373,7546,2986,5143,3014,3581,5484,1126,1645,3018,3941,4510,8783,322,766,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,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,3613,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) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC