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,6364,501,470,1098,6572,4510,744,6562,467,1474,2571,4796,1568,2331,2033,423,645,5454,2457,6574,6571,6576,4126,4019,5089,5112,5623,1487,6644,6767,322,466,6766,511,360,215,1160,1441,5143,2912,3590,6539,6544,444,652,955,1561,1834,6040,6542,1371,1070,6660,2876,5719,6030,3302,1439,5148,4234,4121,4121,6571,5719,2706,735,1257,6152,6151,3359,4305,6596,314,3074,3702,5996,7915,3334,7722,7938,1811,1831,567,8250,7992,1783,8316,3883,8411,8732,2520,4296,8892,546,9152,8683,8475,8627,9037,7666,9300,7174,8648,8948,7967,1350,645,3370,975,1181,4160,2192,4423,396,3797,1738,455,734,1131,6192,744,5877,5362,766,4972,2674,5179,5764,4696,4861,2632,5247,1038,5764,2381,4730,1152,2882,4766,1057,1890,1439,1532,5543,2192,2331,2360,4240,3761,1042,4830,1835,1176,2657,5321,1177,7156,1826,1190,3062,3775,1461,6848,6780,1600,5321,2876,467,1176,7761,5487,470,3059,1092,3590,3303,1098,4964,3844,5765,7019,1600,1416,4947,2261,1460,2760,3136,4164,5218,3493,4984,3830,4348,6981,6104,5995,7834,1522,1869,2639,7837,7995,7836,8150,8146,8135,8000,7354,8087,665,7919,1416,1038,3303,5764,3590,3989,5623,8183,2033,215,5179,3844,6824,219,243,360,3067,3303,3341,3415,341,3418,3482,3778,8150,3788,4217,4722,5306,5509,6827,7835,6632,8089,4652,3941,5362,1257,1253,1318,1432,1325,8306,6154,3368,446,3830,4337,6713,1349,5576,1521,6595,1532,4652,3761,4460,1461,1038,1690,6684,5545,5719,7708,1369,7920,4395,4131,7812,7138,7239,3542,7839,3941,4082,7783,4209,6117,4566,6793,7919,4258,4796,7020,8305,4983,7836,8222,308,5997,7821,7760,1347,5657,7803,8025,6849,8020,7835,6780,6156,7212,7147,6813,8923,8869,8890,4131,8925,8901,8900,8846,7839,4209,9054,8055,8080,7110,8044,665,7582,1253,6154,6315,6639,585,606,736,6674,8911,6942,6694,7712,1690,2025,2135,7602,8089,8306,6782,7138,3904,6863,4355,4220,8019,8615,8222,1461,9195,2590,7106,7096,223,5020,2933,6010,4023,7857,734,6785,6673,8025,7138,7005,7859,5286,228,3933,6792,4801,5148,5373,5349,5339,6901,8543,7837,7835,7834,7836,8441,9376,9073,9528,5877,6538,8150,6537,444,1057,1738,5995,3885,455,4385,6824,1350,396,1834,3172,2615,1232,1185,6533,6535,6506,3263,2137,1433,7920,8031,7919,8514,8134,7927,3195,4005,1698,8103,8222,405,444,8220,8183,8306,7871,783,7927,8509,6809,6845,1906,6104,6069,4710,1907,4983,6117,6679,8615,8548,1349,4652,3744,8105,2723,7156,8688,8837,8902,8681,4136,8777,6402,8957,8956,2882,8973,8547,9045,748,836,7138,8999,8910,6609,9086,4535,1005,609,754,8683,1591,8690,7992,3702,9220,2117,7607,6857,6842,9372,2025,6693,4801,7258,7249,8626,8734,9247,9326,923,6981,8214,7873,9275,7981,9304,6955,5903,812,311,4944,9404,7065,9423,9329,7994,6364,208,9381,2976,6192,206,9013,5011,2507,5885,8151,3195,9421,7719,2882,9334,6838,7839,9243,4985,9260,9612,9069,8957,9198,9200,8187,308,9327,7893,9202,9213,9538,9202,9601,9883,6113,9544,7175,7892,7874,1537,10190,7970,5917,9390,4412,9449,9759,9080,1097,8554,6139,9283,9646,8551,10085,10124,10123,10126,10177,10183,8098,9009,10294,10302,10493,10261,9,8956,7907,7861,7299,10490,10501,4694,10612,10541,9406,8231,8963,10543,10531,8514,4795,10021,9664,665,2168,10816,10818,10819,10847,8144,9819,9919,10814,9343,10978,10844,10954,6891,10741,11064,10976,11216,11222,11010,11025,3368,6740,7304,3957,6586,4349,4762,7975,3351,24,2419,7019,223,7759,1653,6890,2117,6650,6861,1773,8010,1586,1774,3913,30,1774,7238,1774,7761,743,7872,743,1127,2118,3609,1127,7126,3609,4860,7126,2192,7547,7896,5327,2265,8809,6710,3429,3159,2265,7576,5536,6695,5536,6613,5536,6579,5435,5536,8220,1772,9000,1298,6861,6282,3957,9030,7977,7615,1159,3376,3327,8900,5188,7830,36,8284,9081,6858,7929,6832,9346,9346,6171,8103,8193,7640,2554,8193,6809,9811,6591,7138,6809,444,8827,9338,4320,7718,6713,8628,8628,5046,10342,8358,6981,8305,8195,8521,10056,7839,8140,7839,7304,8140,7614,3698,8915,7156,8915,11331,8617,1416,9604,6775,9803,8620,9476,1250,8620,9476,11491) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC