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,7116,7115,7077,7261,7278,7101,7288,7268,7574,7984,8067,8070,8050,8211,8064,8081,8053,7668,8061,8085,2992,8051,7657,7657,8082,7287,7287,3860,3860,7304,8448,7672,7650,7286,8066,7903,7903,7659,7108,7941,7143,8268,8473,8055,7108,8370,8370,9139,9140,9140,9158,9158,8229,8741,9058,9059,9059,8384,7672,8573,8573,8202,8202,9610,9610,9608,8475,8580,9611,9611,8722,8722,9204,7114,8083,358,808,7286,7089,8063,8063,8288,8213,8213,8569,8569,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,7071,7278,7152,7247,8044,8066,7268,7106,8065,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,7096,7082,7112,7093,7294,7106,8049,7119,7087,7116,8211,8208,5996,8033,8209,8144,7664,7268,7072,7152,7273,7117,8040,7266,8047,7897,7943,8077,8055,8061,8057,8085,8076,8081,8369,8370,8268,7258,7245,7659,8652,8050,8461,7574,8394,8463,7975,8465,8792,8476,8083,7114,8282,8466,7273,7661,7662,8050,7124,7096,7943,8385,9160,8285,8652,8724,7293,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,8642,8285,8285,8282,8282,8282,8282,8637,7241,8368,8770,8047,7287,7906,8419,8058,7101,7101,7660,7660,7660,7096,7071,9187,8087,8087,8087,8087,8908,8908,9574,7280,7657,8475,9293,9293,9158,7304,8067,8063,8063,7906,8052,8072,7250,7084,8063,7931,7273,7250,7081,7096,8070,7069,7089,7068,7273,9021,7085,7077,9195,8058,7660,217,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,7071,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,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,5995,9125,7084,8648,5267,4349,7982,8279,5872,4985,2029,4983,10061,7640,7249,9674,2261,7970,4566,10267,1142,8046,7374,10543,8209,10121,10547,10236,10674,8087,10814,10649,10269,10228,10978,10021,10976,9094,9762,10281,576,10566,10609,5913,11127,11024,1371,10768,9926,6119,11201,8290,11200,2897,11344,3908,6103,10682,11272,11134,10404,11232,10505,7937,9083,8763,11376,8713,7670,11468,3646,11225) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC