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,1656,545,6382,6390,6527,6521,6261,7631,6212,726,510,542,528,512,6869,7770,3515,6513,526,6198,2696,6498,4614,6497,6199,6223,4289,4293,4286,4282,6197,4292,4291,532,4290,842,5903,6546,1266,1165,6359,864,3247,1685,1616,3384,540,5066,3380,543,8244,8249,7189,7184,6042,7180,6201,3581,6656,6652,3879,6733,6653,6223,6218,7176,1245,7179,7187,5332,714,4426,2917,5096,4490,7170,7172,510,7598,7596,7637,7636,8278,549,7188,8329,8246,8328,8342,548,8597,8598,8320,8317,5635,4386,8337,6654,7546,7677,2261,5460,6876,7285,4947,3493,7068,7840,6646,7838,7903,7168,7775,6652,7184,7180,6654,6653,7188,1738,7185,7181,7879,7183,7189,7178,1521,3625,8247,4386,7187,7176,8089,8146,8248,8314,8315,8246,7167,8249,4464,7186,7182,8316,7614,3542,6713,8319,4218,4470,8242,8313,8340,8336,8317,8341,8311,8342,8305,8322,8337,8328,8327,8325,8241,8332,8326,8339,8314,3715,5373,8340,8241,8330,8309,8325,8649,8598,8335,7178,7189,5379,5812,8332,7184,8310,2989,8326,7179,6652,7180,8318,8555,8883,8874,9129,4131,7188,7184,8897,8899,8003,8896,7751,6527,7972,6372,7187,7014,2029,6527,8938,8918,2006,8611,6688,9589,9535,9587,8324,1953,7249,9430,7582,6842,7844,9911,2337,4944,9214,9527,10139,9772,6216,10045,9454,9773,2782,10246,4082,8888,3413,9160,9973,9148,8641,8055,9600,10022,8063,8575,61,7619,9453,10375,8573,7262,10549,9508,9996,10272,10464,8795,10692,1349,8741,10623,10774,10624,10672,10251,10508,10625,10835,9660,10910,3244,9052,9963,10855,10854,8892,8891,10862,10894,10895,10906,8737,2863,9610,6712,9798,10476,11289,9543,10305,8206,7717,11273,9540,11274,11332,6364,11456,7671,11573,9873,11501,11497,10532,11140,8805,11045,10789,7126,1521,8514,8584,381,6117,8548,228,3889,8629,5545,8699,5339,8248,7697,7616,8777,8682,3892,8795,8247,6124,3515,8845,8819,1698,8583,7693,8615,5807,8596,8323,8932,8318,4613,8999,8242,3139,2807,8224,2786,1299,1765,7839,8010,5013,4460,9197,8904,8978,9200,1349,2393,3376,8934,8935,6703,9348,5222,3080,9289,9122,9402,9347,4023,2393,5210,9476,4277,4800,4538,181,5222,9541,9638,9347,9249,9654,8016,9750,9725,7860,9779,8776,8308,8333,8246,8307,8311,8336,6354,9115,9182,3070,8597,3073,8335,8340,9184,8310,8330,3071,7819,6957,6689,8334,8946,8241,8244,7752,9114,8699,8088,8627,8700,9037,8320,8249,9129,8946,8945,8944,8943,9665,7881,8727,8945,7054,9679,4558,6447,8340,7194,6386,7196,6191,9111,8248,9165,8244,8883,9114,6146,8246,8881,1266,858,9119,9120,8341,8307,6375,8247,8311,8699,3891,8700,8242,8873,9425,9424,8337,9433,9432,9431,8334,9534,9536,1462,8326,3402,9592,5770,9114,9414,9411,8342,9518,9427,9144,9522,9517,9426,8332,8335,1990,8598,9412,8249,8317,8328,9409,6382,8245,380,8596,9436,9386,9428,9480,8874,6139,9500,9183,9535,6371,9590,381,9591,8333,3883,9588,3891,3882,3884,3892,3881,6526,3890,3896,3893,9587,3894,8168,8597,8323,8243,8241,9589,9588,9416,8326,8325,8319,8316,8329,9434,9408,9412,8324,9908,8330,10102,10101,9868,10096,10099,10137,10139,10140,10147,10136,10138,10152,10153,10151,10198,10200,10195,10199,10202,10213,10217,10214,10216,10201,10215,4294,10194,10218,8649,10197,4296,4291,4292,10280,4282,4293,10098,4293,9633,10098,10333,10331,10330,10333,10331,10332,10323,4305,10324,9429,6201,10336,6199,9631,10322,10193,10100,10551,10328,10557,10560,10563,10607,10555,10556,7189,10326,10327,10562,10335,10103,1770,1767,1771,1769,1768,1766,10646,10643,10753,10647,5756,8894,10645,10639,10641,10752,10640,9880,10644,8887,5863,6820,6727,10874,10962,11073,8598,8317,8336,1704,4289,8874,5691,7693,6376,8241,6517,6375,6989,6995,6234,6419,6388,8387,7610,7697,7694,7695,7696,3442,7608,3515,8244,1665,6175,7054,3891,1765,6270,8246,382,6995,8788,388,6076,6768,3892,6223,381,379,391,387,6376,6375,378,8878,376,387,392,393,385,6271,726,5864,6373,6527,6522,9182,8340,8325,6529,6530,8324,8242,8322,8335,8334,6534,6536,6538,6532,8300,5827,6266,8315,8320,8319,8317,8318,8248,8971,6533,6505,9113,8243,9431,8323,8249,8333,8330,8337,9426,9183,9184,7693,1768,8307,8309,9416,8246,8335,8241,8315,8326,8700,9415,8312,8311,8316,8313,8322,8331,8327,8334,8336,8320,9424,9428,8317,8598,8245,8597,7546,8583,8584,8585,8329,8682,7631,9407,9517,9520,9112,9119,8247,8314,9409,8272,8872,9894,8342,8649,3359,9182,9407,1768,8088,3071,6688,8681,8817,8698,10753,4512,10232,9867,8944,9084,8586,8332,10645,8875,9114,9120,9114,9592,9410,8329,8245,8323,8242,8320,8332,10153,10200,3442,8700,7696,9424,9407,8334,8682,7546,7631,9084,8874,8318,8584,8316,6496,8317,8597,8335,10217,10217,10214,8598,9114,10216,10215,10336,10101,8584,10213,8586,9182,8310,8307,8314,8244,8307,8311,8308,4305,979,10521,9729,10545,8313,10334,8309,8312,8336,10335,10607,10522,3070,6354,11069,8154,11071,8002,11067,9720,10868,10526,7752,7753,6688,8946,8088,10486,6426,6854,6545,6425,6423,6421,9087,6922,10489,8267,6426,6424,10486,11817,3897,10102,9114,8331,8336,8529,8335,8530,10322,8832,365,3893,10334,10335,9633,10100,9632,10607,8307,8273,9411,6199,10153,9631,10332,6200,10152,6197,3897,6198,8274,4304,3884,4305,3889,4291,3891,4292,8272,4286,3896,4300,4298,2520,3895,2522,4299,9483,3888,3889,4293,3881,7963,3885,4294,3894,4297,3892,4287,3883,6493,9192,3887,9409,6538,9182,6537,8334,6536,8874,6534,6506,8329,6505,8699,6533,8700,6532,6359,810,1765,7808,1770,1771,1767,1769,10799,1768,10551,1766,10336,10101,9418,9412,10102,9533,3872,8586,10335,8326,10099,10555,10322,10218,9119,10332,10323,10325,10326,9592,10326,10327,10193,8649,8872,8873,9113,9112,9111,9120,10328,9414,10100,8320,8319,10551,2605,2605,10324,10329,10728,10331,10330,10334,10726,8312,10103,8313,9183,9409,9411,11085,11082,10159,9410,10726,10728,10555,8244,11042,2709,9416,8917,11082,11085,2743,3613,8260,11050,10522,6600,1762,1681,11050,8336,9792,10606,9231,5656,10970,10607,8319,3613,8874,7370,6485,5516,11050,10324,8875,10799,11055,8598,11139,8699,9112,11009,10963,8193,11008,11137,11149,11048,11047,11151,2826,6442,11054,11157,2827,2825,11057,8242,11160,11159,9409,11138,11161,6489,2815,2823,9184,9410,11158,2822,2821,2824,11156,11240,2816,2817,2820,2818,9407,10565,11218,2806,2808,2807,2812) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC