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,2605,6426,5142,1165,3898,3875,5691,3515,6197,1108,6533,2522,1520,3598,5380,254,5915,6138,5322,409,5763,2092,6638,6361,6190,2897,1084,179,1740,3492,3395,2171,452,2145,3863,6947,587,217,4566,6803,2749,7044,7009,3595,6957,7208,186,6890,1645,1511,6561,6624,176,5070,6812,5956,7159,5081,7579,6738,7139,7149,6714,6006,5995,7605,3337,7213,7966,6183,7218,6003,6583,6131,7217,3913,3609,5927,7304,7278,6004,6578,3428,1988,7143,3604,8220,7840,7833,5995,7112,3609,8082,8358,2473,2473,2473,8514,8947,1768,6519,6523,5864,1766,6532,2720,6498,6507,4300,6222,6497,6515,1767,2795,6200,4301,4936,6503,4305,6371,6529,4301,2720,4293,2780,2785,6504,2783,2778,2781,2779,2782,2784,2786,4290,4298,2787,6530,4300,4282,1766,1769,2818,2824,1764,1767,6263,222,3071,2789,6489,6531,4286,6354,3070,2823,1245,6198,6201,6199,6200,1767,1766,6354,3073,7137,511,7299,7300,7134,1767,2808,2803,3888,3885,2791,2820,2801,2802,2805,2807,2806,2794,6546,1769,2826,2827,2828,6514,1245,5576,1351,2869,834,3884,3882,7160,6515,6456,3891,3893,3896,3892,3890,7567,3897,6493,6271,6507,2720,7300,2677,2995,510,6523,6371,6743,3029,7548,6218,6199,6373,6223,6527,6201,810,2522,6354,6546,3070,7751,6689,3073,3071,1769,6750,7599,6746,7870,6749,2018,7753,6751,3889,3882,6599,374,810,379,391,387,6066,384,378,382,375,394,376,6082,1266,7054,3898,1250,4178,5647,7752,6354,1766,7598,7600,7676,7137,7631,6809,4445,4827,4512,6354,3070,3073,3071,6689,550,7677,7168,7167,7170,7165,7163,7173,7164,7959,7922,7054,6985,7752,1767,1765,1769,1766,6168,7986,2522,1741,6354,8233,8232,6880,3071,3521,2389,3070,8272,2822,2823,2826,7238,8245,2728,2893,8294,7787,8432,344,8316,8220,8313,6509,6508,8307,7238,1767,6197,8520,8514,8315,8318,1769,5909,6520,8233,8246,8334,6521,8331,6513,6514,6507,6515,8358,4639,4535,5576,2869,834,1351,1741,8481,6505,6261,3913,3085,8698,8681,3850,5647,8682,6534,6537,4178,6535,8730,8520,8333,8649,601,2170,2390,3610,8342,6641,8596,8691,8814,8817,8815,8520,5996,8142,567,7634,7635,5551,8617,8719,2520,8591,8717,2522,8681,2522,8681,8780,8944,8817,7881,9041,8683,2253,4535,8826,8682,8945,6168,223,9030,4639,311,8358,8698,4834,2992,8175,6691,8727,2925,8232,8551,8681,3913,3172,9390,1232,3165,4178,5068,9736,10297,9390,9951,10364,10238,6971,9334,3646,10353,6209,9934,8514,3731,10164,9084,223,4639,6250,10527,7554,7592,4218,8555,6712,5567,8290,10505,10656,3646,10547,10531,7910,7756,10339,9669,10364,9670,1257,4178,446,5376,222,9543,10865,10654,10877,6611,10296,10786,8306,7636,6693,6774,6395,6863,5303,6845,6104,2608,6006,6006,6977,6239,6173,2761,6173,8278,8278,9350,10436,6561,10436,6561,7159,5535,3066,1385,386,254,5053,446,397,1303,2122,2743,4558,1645,6152,6151,1520,6654,4355,800,5321,1770,5995,1768,1524,1766,5542,1769,1771,1970,6691,6718,6985,1662,737,5148,6175,7262,1767,6721,508,1771,1769,2706,7270,1133,1770,1257,5454,6204,6104,7209,272,4230,7107,7083,2023,6593,1685,1327,6689,7881,186,1073,1215,3071,6315,7671,1173,6586,5927,8088,7753,7881,6546,501,322,6858,810,979,3989,4796,5732,1173,6743,3719,3559,6315,8193,507,1351,3115,7771,3385,7213,1173,8688,4227,3881,7104,8111,7585,8436,8627,7238,8548,8220,8175,7637,8168,8687,8885,446,8440,8765,8834,512,8831,8900,8963,7837,9037,8951,1768,9136,800,8828,9136,8946,1257,8306,1215,3989,8578,9096,5995,9052,7301,7736,4130,9245,8250,9300,2122,9365,9278,9308,9382,8704,9455,8175,9439,2701,6778,7636,9308,9474,9615,1245,1532,9636,9602,8904,9623,9323,9196,8899,8946,9679,9648,8543,9347,9634,6857,9961,7581,6117,9930,9627,9195,9543,6646,10118,1108,10212,9554,6874,10149,10172,107,9867,8897,9760,10232,9665,9342,9049,9383,8728,10000,10272,10554,10342,8615,10523,9221,4337,8173,24,585,10053,9453,10476,10878,10375,10664,10893,10940,10870,11024,254,11028,10836,10292,4558,2811,30,11142,10671,8893,8132,11122,6595,11220,10672,3933,11105,6646,11021,8171,10784,6616,11302,11253,11402,11423,4437,10291,1080,4136,9929,5922,11361,7975,11142,9949,11263,3493,9865,10258,11473,9455,10464,11548,10248,10730,314,11491,8762,11423,11550,10650,5923,9866,11399,11042,11283,11690,11404,11097,26,7159,11645,11739,11678,11328,11764,11701,11118,11721,5534,11644,9603,10798,10784,783,11215,11724,9513,11074,11816,10010,11123,10554,11824,9541,11869,314,11267,11725,7854,10370,9649,9648,11751,9524,11870,2009) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC