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,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,9401,9443,9445,9400,7931,9529,9530,9572,9132,8240,9577,9619,9621,9650,9622,9620,9370,9441,3860,9662,7671,9660,8417,8644,9815,9816,7261,7646,8266,8450,7124,8048,7671,7572,7075,7103,7152,8529,7654,8771,7243,8365,7115,7155,7110,8364,7125,7083,7715,7765,7243,8082,9132,9148,8240,7291,7251,7665,8469,7107,7647,6794,9032,9205,7646,9047,9189,8446,8580,9259,9076,4973,7671,8768,8769,7247,7249,9134,8423,8852,9315,8439,8443,8083,7094,8060,7275,7666,8451,8034,7674,8770,8358,2643,7109,7268,9161,7104,8447,9314,7150,9537,7647,9573,9577,9619,9748,9622,9621,9747,9620,9560,9580,9746,9745,9876,9878,8085,9876,9877,9956,9138,7291,9744,9873,7243,7074,7092,6190,7280,7269,1242,7122,7113,7574,7091,7118,7109,8087,8909,7085,7572,7095,7666,7252,8401,7241,8213,8080,7245,7281,7246,8384,7654,8452,8909,7251,8362,8208,7713,7243,8772,8736,8736,7714,8782,9132,9622,9747,8395,9620,9621,8768,9610,9058,9059,8419,8087,8085,9611,7280,9205,7275,8240,8081,9458,9748,9876,9875,10029,10077,10030,10075,8266,9620,9747,9132,9619,9746,7713,7155,8306,5994,7646,9619,9132,8568,7672,7669,8384,7241,7971,8202,8202,9747,9313,9035,9132,9398,9620,8268,6569,1738,5994,8281,6538,6444,4834,9076,7083,4860,7112,7083,6569,9231,9200,9231,947,6713,4765,9378,435,5251,7610,5691,923,2725,1425,2677,9747,9056,7114,7243,9533,956,9900,8770,2635,10131,10247,7125,10039,10587,10591,6863,5576,6104,6552,6809,3625,4131,4199,6845,1461,2261,6793,4045,6632,4337,3895,6705,3921,3888,7857,1439,4046,4049,4513,5286,3889,3885,947,4652,7646,7354,2776,1145,7665,3892,4432,7251,7761,4983,6595,5732,7671,7671,1126,1559,7261,4566,8089,8417,6986,4061,4128,7759,8031,4432,8450,7273,7833,9746,9747,9622,9621,9619,9620,9132,7920,9910,9679,6688,9749,9383,8945,9665,9676,9748,9744,7241,8425,8450,6806,9933,7815,7247,6898,9821,8409,8438,9353,8760,9607,1110,802,9957,9453,9577,10065,772,743,141,9621,9813,9372,9259,8240,9611,9302,9878,7920,7935,8412,7281,7051,9622,9132,9563,5821,5756,9402,9910,2294,9937,4056,608,5545,5339,9205,3080,2933,10405,10209,8207,1699,10374,8999,10373,10376,7839,8450,8451,10343,9352,8782,6852,9530,10623,7665,10568,10534,10109,8240,9747,10642,7079,7111,7294,7124,2706,1398,7270,3891,3892,7295,7291,4178,7082,3884,446,7281,7666,5066,7286,8205,8085,8078,1257,1215,5995,7154,1656,8438,7548,8223,8306,8208,3895,3888,3894,7987,7986,7967,8390,4639,223,223,8412,7985,7160,7967,8358,6740,7238,8220,2117,2117,4701,4801,8409,5602,5602,7251,8204,7089,7076,3884,8547,1371,7243,7971,7249,7702,8164,8166,8167,9735,9176,9165,9300,9745,9873,9874,9030,7897,9875,9744,6382,9876,8654,8989,7198,7195,7199,9877,7162,9878,9879,8451,10056,10056,10056,10056,6763,7194,7194,9172,10026,9302,10264,10272,9581,9132,7190,9619,9620,7196,10185,8208,8656,9748,9622,9621,9746,9747,10887,9177,10390,10421,10419,11059,10881,10833,8267,7245,6388,10947,8469,8470,7671,11187,7268,10051,10575,10575,7665,7703,8585,10891,8468,10888,9378,8413,8383,11713,11587,9738,9259,10623,10630,10384,6919,7680,6926,6754,6759,6925,6762,8712,9257,9758,9614,9674,4800,8240,9888,9889,2032,9870,9959,9132,8081,9556,10003,9933,8460,10050,10125,8914,10175,8302,8278,8276,10234,10230,10267,9538,10179,9325,10269,9205,10261,10315,8275,10472,10499,9813,10538,10624,8199,10625,10021,10673,10513,10672,10741,3744,228,2677,6691,2677,5088,3904,4082,6696,1347,3080,6774,5817,2294,6633,6858,6863,6693,1299,4724,6793,6821,3612,6809,2262,739,608,6845,6104,6006,3115,4432,4566,320,3701,3719,7592,4652,1699,1349,4778,2451,1073,2841,7839,4460,6732,6209,4258,7946,7081,7265,7268,7971,8058,7069,4029,7154,8211,8044,8058,7244,8288,8429,8361,8078,7080,8403,8209,7294,8713,8400,3066,8469,6650,8207,8402,8468,5947,8839,8772,186,8195,8284,8876,5936,8281,7913,931,7884,801,659,3647,5545,971,9249,5961,9141,6069,7718,8468,8408,1163,9560,9743,5956,9458,9480,2329,1906,9028,8460,5460,9875,4710,9874,9648,9876,9877,9878,8445,9648,8446,10275,10270,9132,9619,9620,9621,9622,10575,10078,9748,9793,9746,9747,10292,7671,10947,10948,9609,9611,9608,10687,7262,9610,7241,7672,9878,11062,10965,10943,10906,10881,11187,10506,11045,11096,11059,10941,10891,10026,11262,10879,8573,10888,11018,11370,11275,9205,11277,9794,9756,7077,9675,11332,11337,8397,10676,11369,11469,11539,11542,10678,11266,4227,4226,10703,10449,10854,11410,11553,11614,11675,9877,11627,8740,8568,8424,10332,11252,11695,10325,11319,11696,9624,7172,9232,3559,7165,7170,7163,7171,7169,7164,7174,7173,7168,3115,11255,8228,8577,9554,4463,7166,7167,7677,4473,4470,8662,4464,4486,7070,2823,6443,1741,4645,9892,8712,11527,9509,8946,6688,9867,9383,11836,11516,10427,10963,11674,3359,11889,2780,2786,3073,3071,10247,6689,4701,7647,10053,9665,10212,7753,7752,8088,1257,8627,9277,3428,9037,9679,1616,7239,6688,8944,1215,7881,9647,9867,7281,6537,446,10056,6534,6535,6506,10008,5386,9259,4765,10342,8946,9132,10347,10541,9383,9370,7659,7251,8400,10615,10672,10232,8402,10228,9303,8403,9383,240,7662,10741,7080,8891,8251,51,5994,10275,10814,10552,5053,10738,10673,10910,9048,9389,10820,10836,8208,1303,6894,10267,10976,10975,8441,10649,9609,9889,10483,7953,3908,11024,7917,11010,8467,10029,7285,10025,8383,9560,9995,9442,9058,7766,9659,9821,9562,8768,9578,9206,8039,10889,10007,7094,10843,10742,7270,10730,10984,8722,7289,8070,7175,9367,6702,10692,10692,9563,9817,9819,7279,9820,9818,10437,8286,8369,8658,8048,10586,10588,9132,9619,9620,9621,10768,9622,9746,9747,9748,10835,9293,8477,7085,7661,7662,7077,7068,3241,1770,4519,9386,1765,9554,2033,9953,4019,90,4019,4121,9220,10094,4121,9638,10822,10416,7252,10787,9132,10699,10042,10787,9619,11121,9620,9621,9622,10915,10088,4037,11126,10087,10715,3904,10090,5373,11140,2164,10532,2820,11119,2779,2816,7982,9543,8822,10935,10891,7170,5839,3874,4146,10302,7251,7839,7920,8288,7671,8409,4258,3542,8306,8201,8408,8401,8765,7654,3921,7875,1461,8782,1347,8832,6740,8999,7238,8220,4455,3976,4088,8869,9300,7675,9453,7243,9454,9148,4670,9464,9300,7115,8450,7671,8463,368,365,9957,9302,7833,7903,8948,10056,7143,8973,8240,608,9744,9748,9745,9259,8832,9638,10146,10265,10001,10543,9746,36,10272,10623,10787,9132,9132,11509,9619,7642,10947,9620,9620) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC