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,7671,9189,8922,8881,8881,8881,8460,7671,9767,3884,8541,8665,8446,8772,9874,8412,8052,9547,10024,10024,9502,10272,9401,9813,10275,3885,1766,3882,6354,3073,3071,7751,4512,3070,6689,8244,7752,5298,7752,8241,7072,8246,8311,8682,7636,1368,507,8704,1257,7238,8174,7580,7881,272,6204,8306,446,1215,5995,5732,7837,9037,1165,7835,2023,8598,8840,8319,640,8247,8441,8425,8407,8439,8404,9138,9297,9187,8400,8568,9795,8794,8410,8413,8782,8782,8451,8577,8208,7836,9372,8329,1347,608,1253,4258,9937,7920,10232,10243,8402,10095,8580,9560,10401,8450,9313,8407,8443,9719,7646,7103,6733,7262,9513,9563,7654,7250,9370,8716,8450,8365,7294,8395,8449,9797,7288,7082,9745,9259,9581,8569,7666,9205,8404,10026,9622,7266,9573,9561,8891,8451,3327,7048,7671,9304,10258,10272,9880,9492,8,9189,9957,10303,10312,7287,7121,8211,7110,8084,8087,7096,8047,8366,8063,7084,7658,7268,7655,8080,7714,8065,8452,8652,7659,8456,8998,8068,8268,8713,8064,8401,9560,7273,8891,8892,8393,8378,7670,9053,9594,8058,8362,8049,8425,8050,8406,8201,8640,7674,8373,7662,8641,8476,8430,8766,8443,9738,8712,9740,8428,8570,8646,9508,9741,9442,8737,9562,10025,8467,7665,7266,7122,8081,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,4580,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,9480,8832,9259,9539,7097,7644,8087,9529,7655,7655,7655,7106,8431,8070,9148,7659,7152,8368,9819,9741,7118,9795,8381,9719,9259,8709,9049,9049,8071,8071,8380,9563,7100,7068,9312,9312,7114,8282,7115,7089,7646,9053,7297,7119,7096,7261,7589,7589,7154,7154,7589,7589,5895,7765,7297,7765,8742,8742,8742,8206,7154,7070,7070,7297,7297,7297,9076,8712,10272,8063,9083,8580,7268,8459,10400,9560,8469,10614,11034,7655,9157,7297,8908,7297,8413,6615,6615,6579,6579,8768,8768,10577,10675,10272,10275,10575,10629,10630,10906,9743,9508,9562,8034,10007,7077,9261,9581,11059,10689,7108,9580,10855,8087,10854,7153,10965,10887,10881,8046,10888,8086,11034,7279,10890,10506,11211,11035,10507,9443,10508,7261,8364,8644,8961,10404,10449,8057,8368,8443,8050,7289,11276,11061,10509,10274,8472,11331,11411,11278,11065,10511,10889,8767,8207,9738,11367,11536,9057,8414,8474,7150,7666,11210,11674,11668,9148,10941,10943,10947,10942,10623,10944,10624,9821,9956,8450,10945,8468,8646,8428,8415,11630,9997,11262,10946,11760,10625,11712,9095,11211,9957,10573,8929,8081,7252,8460,7287,7250,10833,8446,10624,10625,7155,7649,10941,8208,10942,8580,11225,11210,7287,7280,7714,11628,11758,11534) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC