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,3830,6197,3989,275,4860,1165,4234,3860,5535,726,393,2882,2160,4730,6154,1537,4131,5996,6545,1137,543,397,6138,6040,6559,4023,725,6686,6679,6197,7879,7840,7143,7878,8220,5764,7903,8183,3784,3263,215,8222,6750,7998,7638,5995,3761,2467,419,6981,1506,501,2706,8306,3059,971,1215,4178,1257,7833,3134,3368,8542,8616,8488,7840,7879,7878,4259,8529,8306,5143,466,252,6204,6539,7631,7870,7582,4136,3542,8434,4788,7896,8611,8615,3413,2261,7641,7837,7615,7903,7834,9144,8983,6713,9300,8842,9130,7910,9547,6023,10119,9220,9807,10548,10244,9752,9770,10523,10526,9924,10300,36,10688,11733,11346,10569,10892,10734,9811,10674,11325,9831,11380,11101,10687,11749,11215,11311,7095,7115,7270,7247,7100,7074,7153,7119,1198,2995,7152,3392,6659,4519,7102,7109,1533,5777,1145,7243,956,7092,7089,7266,466,7716,1885,7906,1439,7263,7096,7249,7068,7154,7277,7106,7294,7110,7295,7268,7250,7281,7275,7093,7241,7666,7249,7265,7292,7088,374,7293,7125,7281,8408,8425,7288,8201,8220,7282,8577,8404,6138,7279,7080,2079,7280,8406,8400,6138,7704,8361,7266,1245,7264,6879,9302,7671,8782,7967,8034,8049,9289,8402,8450,9581,9148,9315,9259,7092,8645,7089,431,6771,244,8398,9573,9039,9939,9630,8080,409,1740,7304,5996,5576,2869,7261,834,7079,4405,5371,7666,8361,7115,7106,7897,8463,7286,8251,7286,8251,7287,7715,7287,7715,6940,8450,8240,7938,8362,7671,5262,7243,1126,8644,7906,7072,2033,8469,8852,8891,7109,3882,8891,7270,3892,8438,7270,3893,7294,8365,8769,7266,8724,8576,215,8569,8530,3890,8285,3989,8359,501,7959,8240,8798,8208,5070,5148,8470,5995,7935,3830,7638,8400,2951,735,8236,7125,7096,8641,8227,8050,8407,8396,8364,8396,8364,7265,4131,8422,7265,8422,7297,8042,547,7115,547,7115,8085,9204,8771,7105,8792,1349,7675,8772,7354,8772,7354,9315,6315,9611,8909,9611,8909,9743,9744,9134,2706,9134,2706,6595,9053,6595,9053,5995,7155,5995,7155,5995,7155,8809,9877,8759,9745,8759,9745,510,1145,7665,9378,10320,9561,9564,9480,8832,9259,8583,8598,7985,8307,553,7300,539,9183,532,545,8002,547,9410,9412,9416,9414,6354,1524,7705,524,3892,3893,3895,3890,6396,860,8917,382,3883,368,6742,6985,735,3896,528,542,546,8274,1765,573,6521,6220,6521,6220,6521,6220,3894,6200,5956,5467,2009,2257,1462,5882,6593,1887,1327,6312,6377,5742,3704,2474,7048,6127,6810,1981,6816,7547,2554,6593,3865,3327,6140,6131,1462,310,3248,5782,2635,2643,3402,7363,2843,7599,2507,4154,5068,6905,6721,1990,6618,1990,6618,2967,5567,7958,4079,6127,8110,8607,4338,6829,3531,8768,6710,3561,3029,7641,3761,7632,2455,1051,4535,6807,5602,156,6364,46,6264,8924,4339,8482,6961,2447,5484,5376,9603,8716,9552,3059,8812,4682,4682,8955,4765,5647,8019,6642,6780,9936,2491,4987,6362,4362,5322,4320,10107,9931,1172,10457,7643,1272,10267,4983,10649,924,7037,6806,6958,6959,6960,6973,6972,6974,5165,458,10504,10229,10267,207,1051,265,7815,6059,265,10495,7882,10704,1992,11342,9336,9967,6767,10314,8518,11120,9423,8960,8839,4360,10860,11376,10608,9757,11131,11115,11676,3428,11112,9403,9234,9383,7610,9867,5691,6197,7881,8943,6199,2522,8944,2520,9633,6519,4701,1779,5386,9555,4920,1767,5188,9493,6534,3883,6506,7985,6354,7986,7751,8618,8682,7973,450,8257,1770,1765,1771,10638,10646,10641,10642,10643,10640,9665,10544,9499,9217,1768,1767,10565,10840,10900,11083,9402) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC