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,7661,7244,7655,7920,7837,3080,7077,8569,7243,7243,8723,8723,6862,7266,7294,7253,4558,7152,7091,6962,7125,7095,7276,7707,3090,7123,7805,7665,7093,7296,7096,7671,7278,7271,7115,8048,8033,7280,7272,8412,8477,8645,8473,7941,788,7291,7291,7124,8852,7083,7092,7106,8405,7103,8064,8393,8398,8466,8354,8349,7068,7666,1558,8475,1667,9201,7244,8465,7088,7093,7099,6969,3926,8093,7109,3090,3926,6984,9574,9573,8208,8576,7666,8577,8412,8475,9148,7346,9745,9314,9076,9583,6719,8468,1990,9873,9470,9818,8644,9207,8410,9973,9956,7574,9055,9577,8574,8439,9956,9583,9583,9583,7122,7083,7716,8423,8832,8438,8386,7775,7775,7926,7926,7776,6904,6795,463,6315,5995,5020,409,5222,6571,1416,3303,6569,219,6678,1577,6141,7004,231,7209,4156,2605,3872,7081,7261,7290,321,4259,7255,7278,3888,1770,3172,1185,5208,8296,8222,7238,8514,3897,8757,1537,8469,7752,2006,7115,8651,7775,7714,1569,7168,7166,389,7547,1993,8109,9614,8053,9134,9831,7642,435,8048,6365,3532,3169,7264,3169,4659,7548,8034,1487,3904,4360,8045,8049,8282,6870,7154,6870,6870,6870,7998,7999,7999,8199,8288,8067,7535,8446,8469,8424,7268,8864,7251,6693,389,6907,5883,6693,386,386,8788,393,8789,1524,9021,9021,8859,8859,372,7270,3026,7895,1461,7265,7241,7941,7875,7939,7077,8070,8086,3933,6365,7992,2029,7946,7087,8078,7119,7093,7944,7121,7108,7589,8365,7271,7268,2006,320,6204,7677,7096,7083,7071,7241,7095,8611,8688,4355,8404,8049,7281,8615,8819,8422,8227,8407,8404,8375,8908,7286,8049,8793,9027,7080,8084,8918,4209,8938,8561,7674,7117,7270,7096,7940,8460,8362,8641,7266,8438,8767,8447,7108,8641,8836,3904,7115,7906,8063,7068,8712,7085,8048,8368,9083,7080,9053,9148,7244,9057,7944,7287,7287,7111,9259,7282,8404,8713,8044,7152,7671,8080,7935,8460,9398,8652,9225,9225,9560,7279,7279,8364,8364,9755,9225,7080,8408,9199,10030,8364,10023,8363,8232,8232,7266,9956,9302,10076,9999,10024,10024,9956,9956,8229,10046,10278,9421,4624,9980,8782,7654,9813,9878,9755,10577,10811,10768,9794,9561,10767,10769,10869,9316,10833,10854,10757,10855,10770,11038,10675,10890,10854,11210,11210,11262,9739,9875,9874,11335,10623,9873,9873,11225,11514,11331,8205,10572,8063,9739,11692,526,2957,6738,5467,1098,4765,3094,4490,4164,4519,3564,4778,5328,4778,4426,3519,4616,1600,6780,6780,3549,5334,6171,933,730,6216,6222,6501,5093,3532,3784,6523,2725,4029,2300,1823,1533,7078,2457,7748,3085,5386,7172,608,1645,5552,4796,7572,2992,2337,8522,8224,8557,7670,7670,8649,7631,7546,8937,3071,8910,6715,8937,9300,3287,6809,9890,10146,8048,8053,8245,10047,9900,5692,8714,10491,10543,10590,4860,10674,8910,10573,10659,7125,8514,10893,11802,11497,3863,10988,9985,10687,11289,2506,11904,9485,8063,8404,8403,8403,8407,788,8567,7286,7075,8576,8236,8236,8406,7086,7109,8065,8408,8408,8408,8408,8408,8408,9719,9205,9225,8425,9022,9022,9264,7273,7107,7122,7122,7124,9539,7097,7644,8087,9529,7655,7655,7655,7106,8431,8070,9148,7659,7152,8368,9819,9741,7118,9795,8381,9719,9259,9049,9049,8071,8071,8380,9563,7100,7068,9312,9312,7114,8282,7115,7089,7646,9053,7297,7119,7096,9564,5576,6583,1207,6656,3385,3384,8693,8694,7599,4784,1967,4714,7187,5046,8665,1685,9137,3037,8071,7273,7660,8429,8034,10007,9795,9563,9873,7280,7278,9225,8386,7674,8909,7265,9053,7272,7278,9611,9610,9563,8087,10835,9053,9225,8770,9259,8372,8457,179,4767,1506,6559,6663,6876,5088,1520,793,464,5907,6001,308,585,600,6162,6168,358,3892,5647,4969,228,7258,6813,7304,6766,6954,6812,4217,7160,1830,6794,7144,6780,6155,2328,2506,6695,2863,6831,6802,7838,3046,7783,4983,6767,2419,7602,2573,6160,7146,8020,4735,6159,725,3728,6811,8093,6588,7143,6605,6971,4570,6128,8096,8526,6726,8230,7822,8503,8836,6172,7304,8611,8184,8512,7887,8109,6348,8852,8489,7897,8869,6104,8869,8032,7850,6809,8118,6845,8903,6104,9075,9116,4860,8630,9052,3725,7920,2023,8500,7839,585,8948,9366,4220,9354,2925,8933,9369,1490,8955,9541,8806,9069,7022,9543,6135,9453,3549,8543,8305,6117,9647,9648,4765,341,9200,4652,9345,9374,9348,1349,8934,9346,9939,9249,9248,8795,8915,8805,8935,9924,6821,8492,9922,4566,9941,9928,4566,8501,4128,9402,4061,8031,10057,10208,9910,9117,10063,7759,4056,3936,10227,3100,1698,7138,6683,145,6986,6635,6793,6684,9991,4131,10039,6679,9363,7761,9258,10341,6595,7354,10548,7019,10688,8222,8793,8222,9195,9552,9925,10245,9993,5236,9000,9027,9282,10762,9034,3595,10879,10938,10528,10955,768,10893,8829,9352,1127,233,228,11127,9749,9065,3964,4635,4656,5046,5193,7760,11021,9038,8629,11122,308,4023,10246,6314,6779,6169,6674,180,148,6639,180,3493,2261,11324,6686,8808,11324,9379,7147,8923,8781,8257,3059,10572,10535,8539,6792,10573,11213,9467,10906,6713,8769,11489,11377,7077,11220,7156,11361,11439,7077,11361,11439,9629,11018,7077,4537,2294,9055,9204,8048,4046,10915,11124,9639,2019,11353,11599,7661,1895,11287,3288,10719,7662,10623,11125,11521,9638,10623,9220,6713,10042,10623,10042,7125,11126,11724,2923,10895,7084,5368,11678,11760,8368,11237,11692,11501,11693,11803,11867,11868,10630,10272,8056,11867,10689,10623,11502,11777,10624,11647,11210,10625,11349,2913,9390,10537,10060,5267,10547,10767,9135,10505,6364,9370,104,10891,9926,10706,7273,6591,5913,6103,9609,958,9608,9546,8358,10814,9510,10887,8578,10704,1487,7669,10694,11332,8048,9954,8467,11187,10011,9955,9611,10881,9610,8048,11124,9509,11125,8410,10401,10623,8199,11514,10078,8471,8407,11411,9793,6690,9056,7289,11196,9573,11539,7271,8422,8472,7268,7296,11692,11712,11671,11693,10357,8419,11096,10863,11225,9659,11763,9581,8285,11631,10629,7656,9561,9204,11754,10409,9141,8400,9187,11500,10275,9134,8426,11065,10807,11767,10030,11262,7674,11711,9821,11686,11713,7241,11538,11335,9561,11926,7935,11892,1327,11063,11130,10789,7280,8395,7944,9509,9205,8577,10077,8770,9134,8384,8395,9563,8644,8407,8408,8406,8404,10510,10675,8783,8082,7933,7674,8394,7281,8423,8771,11125,8737,9793,11370,11511,10869,11332,11124,11508,8580,9539,8212,9529,7280,10887,9817,7285,9578,7660,9134,11553,10768,11131,11331,10906,11671,10767,9795,7088,7086,8423,11758,11693,7715,9540,11692,10869,8832,11188,10272,11096,11795,8741,9816,11634,8740,11402,9259,11472,8763,4395,11797) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC