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,7089,7113,6122,5995,7083,7096,7121,7110,7895,7566,7392,7265,7121,7152,7589,8047,8082,7675,7123,7096,7088,8048,7068,8067,7117,8087,7069,8384,7125,7114,8040,7115,7116,8053,7249,7493,7493,7263,7116,7278,7108,7092,7093,7084,7276,7282,7290,7247,7089,7086,7081,7117,7291,7102,7273,7076,7075,7249,7095,7245,7077,7272,7264,7281,7279,7119,7241,7108,7125,7112,7117,7271,7280,7262,7292,7121,7293,8060,7278,7152,7247,8044,8066,7268,7106,8065,8069,7984,8051,8081,8071,7086,7125,7070,7672,7244,8381,8046,7106,7281,8268,7084,8084,7089,7082,8425,8400,7292,7088,7241,7280,7971,7092,8401,7943,7280,8201,548,528,535,540,7281,551,6141,1511,7279,272,7107,7280,7097,8066,7086,7096,8055,8065,7932,7077,7154,7931,8076,8087,7941,8064,7943,8053,8077,8208,8063,7081,7263,7121,8453,7106,7664,7115,7250,7250,7262,7656,7084,8450,7092,7671,7293,7087,7104,7269,7279,7108,7273,7116,7281,7119,7276,7154,7244,7289,6925,7703,7262,8395,7654,7241,7241,8644,8425,8425,8576,8402,7599,7599,8400,1557,6388,6191,7106,8404,8401,7152,8576,6191,6151,8268,8085,9308,8407,8782,8782,9593,7666,7659,6928,9734,7655,9441,9441,9441,6656,6656,7268,9816,11060,8439,5222,7266,7152,3647,7154,7660,7117,7110,7296,7278,7869,3026,5729,7834,7834,7837,7836,7903,6632,3080,7665,1371,5516,254,7616,7146,8269,7660,8388,8441,8489,8526,6971,8611,7258,8687,3368,8739,8734,8699,2590,2419,7585,7585,8193,6397,4767,4432,1349,7896,8951,5455,2023,8016,3990,9057,9079,5552,4103,9050,7640,4985,3384,9119,7388,9322,9297,9297,7106,3561,9377,6315,9212,9259,9471,8406,9455,7244,9526,1992,1992,6138,9660,9572,9614,7293,8948,9787,9814,9799,3646,9813,8477,9821,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,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,8709,7108,8641,8836,3904,7102,7095,7088,7110,8082,7653,1981,1981,7254,7113,8430,7674,7277,7574,7895,7288,8385,8472,7589,8464,7147,8047,7106,7767,7765,7092,7079,8645,8742,8269,8374,8381,8072,7931,7932,8475,8477,3874,7646,8641,8640,7286,8363,8067,7068,7279,7108,7068,8366,8456,8573,7672,7941,7941,8394,7152,7115,7116,7272,7932,7096,7245,6726,7125,7241,7897,7106,217,7266,7084,8055,8071,7270,7671,1029,7672,8079,4597,8087,4770,8062,1402,4662,8384,7668,421,7675,8269,7657,3550,8019,8077,8657,8053,8363,8202,8739,8052,8081,7668,8468,7931,8418,8084,8056,8471,8422,8641,8087,9148,8736,9053,7671,8475,2573,2328,2388,8450,3297,8438,8477,130,5915,8385,8041,8288,7656,8045,8042,8068,8407,8782,8065,8057,8060,8069,8067,8282,7660,8058,8051,7095,7097,7666,7669,9160,8359,9054,9055,8367,8419,9573,9574,9575,9578,8476,9577,9561,10022,8467,9539,10074,9793,9580,10077,9999,8235,8642,10009,10023,10051,9158,9565,9998,10075,9572,10186,10027,8082,8078,7076,7081,7108,9443,9445,9510,9581,10024,10026,9562,10076,8364,10185,10022,8767,8410,8085,8507,8528,6879,7628,10272,8411,8412,8398,8397,10275,9793,8396,10186,10690,10659,8286,10629,10624,10689,10030,9225,8439,10630,8408,10675,10770,10773,10691,8644,10811,10807,10774,8405,10625,6896,10835,10843,10889,10891,10852,10853,9187,9204,9206,9218,10881,10906,10692,10862,10863,10834,9206,9219,9263,9262,9261,9264,9875,9876,10270,11066,10271,11062,8567,8473,9292,9313,8201,8207,7290,8569,9314,10965,8206,8537,9367,9368,11045,9316,8468,11027,10586,11187,10450,10405,10401,10890,11336,11224,11333,10572,11368,11370,9294,7275,8229,11331,8474,10694,8383,8929,7289,9399,9400,11376,11500,11501,11502,11507,11506,11503,11513,11542,11614,11538,11540,11528,7114,7389,7241,7111,4362,7147,5887,7068,7095,7110,7258,5996,7123,7100,7082,7116,7112,7088,7276,7072,1828,1726,7092,2342,8048,7675,7152,7675,7086,7117,8033,7096,8082,7265,7250,7674,7089,7271,7093,7666,8041,8049,7077,7077,8071,8071,7264,7264,7108,8211,8044,7084,7084,8396,8537,7095,8397,8067,8069,8069,8642,8285,8285,8282,8282,8282,8282,8637,7241,8368,8770,8047,7287,7906,8419,8058,7101,7101,7660,7660,7660,7096,9187,8087,8087,8087,8087,8908,8908,9574,7280,7657,8475,9293,9293,9158,8050,7640,6439,9529,9529,9541,9751,9258,8585,9933,10057,9581,7086,8735,8055,3029,8368,7096,8473,9160,9187,8056,3890,7385,7258,7089,7939,10670,8460,8568,9563,7249,8083,8641,8086,10584,8657,10575,9082,10624,7258,10582,9187,8459,9134,9609,10869,10789,10906,7106,8430,8370,8424,10767,11045,8039,11187,10584,11124,8045,11278,11277,7121,8056,10692,8739,8039,9054,7276,7272,11196,8370,8282,9539,9578,11124,7662,7661,11125,11276,7278,11334,11376,9793,8711,8431,10510,11472,11469,11471,7241,11411,8711,11470,7574,11196,11525,11511,7108,9370,10580,10275,10271,10270,11333,7271,11526,8411) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC