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,7022,7244,7107,7122,8402,7647,7647,8208,8737,7668,7669,8201,7293,8425,8058,8080,7080,9580,8424,8424,9160,9444,7154,8415,8743,9445,9400,9443,10075,9293,9660,10185,8477,8417,8414,8426,8077,8418,7271,8472,8396,8067,8419,8368,8086,8712,8427,7285,7085,7280,8741,8206,8658,8282,7102,8711,8794,7931,7097,8740,8567,8891,7114,8742,8892,8052,8079,7655,7092,7281,9058,9059,8206,8891,9091,9140,9158,9160,9056,8467,9157,8045,9204,9205,8059,9247,9261,9148,9225,7248,9302,9262,9264,9313,9141,9138,8415,8768,9368,9367,9443,9445,9400,7931,9529,9530,9133,9572,9132,8240,9577,9619,9621,9650,9622,9620,9370,9441,3860,9662,7671,9660,8417,8644,9815,9816,6750,7124,2992,1988,8580,6740,6740,9139,8743,8743,8415,8415,8050,7288,7288,7111,7111,7115,7115,7664,8771,7113,7246,7117,7263,7263,7505,7505,9877,8460,9873,9874,9874,9856,9856,9821,9821,11515,11525,11525,9398,7112,8040,8050,8048,4683,7111,8036,8369,7123,8033,7675,8034,7278,7113,7118,7082,7649,7647,8378,8472,7261,7283,7265,7081,8792,8431,7574,8036,7287,8253,7266,8466,7250,7572,8361,8429,8473,8385,7245,8452,8456,7105,8055,7244,8455,8444,8393,8768,8080,8446,7943,8769,8084,8414,8474,7069,8741,8998,7268,8461,8415,8743,7080,8712,8721,8474,8086,8722,8426,7111,9204,8908,8635,9207,9187,8045,7096,8366,8930,8641,7663,8070,7093,9225,8269,9201,8642,9139,7264,9148,7931,8652,7975,9444,9445,9447,9446,9398,9443,9400,9446,7097,9560,8044,8058,9580,9203,8363,8642,8046,7262,9247,8470,9583,7245,4639,8445,9482,6974,7713,9259,9259,8477,4199,7659,9158,8724,9294,8287,7657,8397,8449,8406,7076,7095,8400,7291,8203,9132,8446,8362,8034,8475,7106,7665,7094,9259,7251,7124,8055,7932,7674,8359,8058,8084,7261,8408,7150,7713,7900,8577,7297,7275,7597,8170,7653,7298,8092,1569,1885,4019,8144,8772,8279,8456,8282,8206,8456,7733,7734,8071,8648,7641,8089,2989,7920,8358,7019,4652,7761,4639,9245,9557,9444,9329,9443,9399,9400,9446,9447,9445,9398,9367,9448,9917,7661,9918,9926,9889,9759,9919,9542,8743,9562,8929,8081,8386,8769,9370,8568,9817,9082,9082,8657,7671,9189,8922,9564,8881,8881,8881,8460,7671,9767,3884,8541,8665,8446,8772,9874,8412,8052,9547,10024,10024,9502,10272,9813,10275,9430,9535,9591,2778,2783,2791,8591,9588,1770,8899,1766,9590,6354,8946,2823,3073,3070,3071,2828,2824,6689,7810,6220,6688,6221,9299,7083,8088,8087,7106,8627,9037,8071,9793,8594,4752,10056,7169,8618,9906,9349,9970,10253,9149,1769,9418,8306,4178,9907,8820,1257,1210,10256,7100,7092,151,10254,8683,8816,814,5567,8894,9873,52,5995,5227,7714,4784,4788,10347,5839,8460,3493,675,5516,9601,10342,8716,4639,566,550,1533,923,7238,6740,466,4788,2736,2995,3564,1370,1917,4645,4785,1145,5988,788,7121,7097,6659,3392,2915,7245,7108,1520,3059,2261,3493,3595,7019,4947,7761,179,1461,6710,7008,2986,4234,6642,1327,721,8085,2775,2776,1886,1207,2725,8222,7019,1198,435,5251,5143,8185,8185,8434,2451,2932,233,501,4861,1425,4512,4316,5298,5298,5003,737,4037,8470,8685,7808,2605,2605,3989,6382,4038,3841,6144,7244,6149,378,979,7285,8793,8340,8246,8325,2520,947,7359,1126,8241,9030,8424,8204,8334,8568,6082,8874,7998,7999,8328,1173,8141,3169,842,217,698,9182,3389,6774,6774,9204,4240,9056,8445,7675,7087,182,7116,4301,4301,9053,6042,545,539,537,7986,7654,7125,7985,543,7999,9870,2677,9533,4784,7117,9418,9554,9676,1234,956,1210,1741,542,9378,1768,28,4029,3014,3891,3895,6493,3803,9878,9877,9874,9875,8459,8469,10171,10171,10187,8446,8445,10272,8363,8423,8891,8892,9082,10399,10451,9207,10011,10400,9224,10706,10759,9649,10702,10401,1257,9674,9297,4401,9968,10938,10802,10991,6342,7852,8963,11089,8437,10667,10888,10887,11188,11402,7080,7661,11370,7655,10768,7655,8721,8737,9658,9199,8712,7933,9398,11189,9873,9794,7879,7657,9312,501,9292,9313,8477,8269,9148,10023,10075,9161,9264,7659,9158,10027,10403,10404,8928,8208,9148,10022,7669,9225,8079,10403,10449,9530,8832,10409,8235,10437,10609,10588,10774,7110,10591,10835,10889,8468,10575,9219,10836,10272,7125,10887,10029,11059,9058,9968,9091,9054,9139,9160,9187,11065,11034,11035,8073,7077,8040,10586,9447,11402,10580,7599,10881,8771,4282,9076,7671,7281,7311,9189,11050,7076,8477,1766,7082,8474,10890,10545,7289,11375,10862,11224,11317,10271,11225,10922,9314,9563,10275,11319,10923,10924,10675,10639,5065,11470,10026,10642,10641,10640,9999,7605,10185,9539,7599,10637,10869,11252,11251,9134,7266,11177,7299,7270,5535,11511,11513,10321,4512,9189,7986,730,9578,1768,5003,9259,1766,9138,9608,8668,5454,7247,1766,11602,8782,7354,4566,6683,10770,5596,9377,8808,10674,5431,1234,173,4432,10226,10079,8927,9900,6397,10272,11262,11187,10146,5513,145,11335,11381,9922,6278,1775,3368,9338,11287,5247,7250,11108,5236,28,9464,7876,10397,11225,7662,7661,4023,6679,10893,1145,9888,8568,8424,8740,9977,5175,4023,4061,4969,3989,6595,228,4233,9968,1398,11630,7143,11652,11633,7671,9560,8812,9251,10168,8813,11517,10748,10472,10675,11684,9417,10904,9036,8517,11703,11658,11442,9874,9873,9876,9875,1173,713,2995,923,11388,172,8474,1970,10577,8929,7655,8081,9205,10854,9461,10855,9503,8889,11609,11385,6635,9980,9896,10869,11398,9246,8140,3558,10078,11753,8139,6548,11795,11473,11689,11794,10624,9220,10860,9638,252,10042,11822,9904,11838,11130,7670) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC