this
MySQL 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,1983,2342,4529,6264,6186,6131,6584,1296,6636,3823,3555,1973,1357,3555,6658,5145,4607,1380,4920,1358,1526,3830,4796,5236,455,464,4234,4128,4178,5279,6431,1453,6400,1537,3337,766,6195,4178,5995,6001,754,6587,5996,2158,6008,3644,223,4566,1343,6381,323,3860,397,2594,4656,6766,1826,975,6394,3964,6593,858,6986,990,3989,1591,6842,6947,6140,6941,6010,6985,1402,2261,766,5070,6349,6793,5882,1461,5331,6757,6779,6812,2374,6115,6658,4099,4656,6779,6971,7003,217,6850,1029,2474,5530,2000,6951,1371,6996,958,5371,7019,675,3100,230,6312,7034,7148,6569,1917,6168,924,3595,6103,2915,3059,834,239,7226,4947,6813,3493,1461,4796,1558,1520,6141,836,850,3860,233,1785,1537,6431,6951,1776,6275,7739,182,2932,2000,6445,1084,5339,1521,3625,7156,4995,797,2446,1462,1779,1785,6400,3037,2387,2117,7761,4529,4659,8222,8232,8128,3542,1070,7897,4639,3521,7050,1490,2029,4079,7783,8097,4405,4834,4259,8558,1890,6818,2117,8518,8611,8109,1349,8535,8388,8629,5552,4218,1811,3850,8793,7976,2737,8839,8852,7918,734,3823,3966,6667,1558,8305,6814,8889,7602,7147,8183,7307,7795,1772,186,1774,6715,3302,8684,933,4991,314,6366,8281,9340,5769,2009,6583,6438,8561,3519,3554,5305,8978,9344,9290,9197,6700,7903,6255,6552,9453,8781,7048,3520,6642,344,9776,8089,3557,9776,4849,2390,4087,9248,5046,9922,2122,9900,9910,9661,7759,9776,9928,7825,9308,36,9986,7998,10229,9798,1303,10063,6113,2989,9449,5891,2170,8816,6641,10346,10280,9552,9538,8586,10001,9602,9916,10469,10127,576,10292,10500,10375,9513,4349,2158,7173,10548,10526,10654,8956,10579,10652,10775,10652,10747,6562,10719,10894,10227,10297,10871,1765,1767,1771,1768,1769,1766,9154,9518,10670,6354,7922,3883,8272,779,10354,11041,10314,3073,6689,3071,8316,7557,8627,8088,11021,9037,7170,9945,7174,8241,9665,8333,8946,8244,10742,10924,10528,9665,7912,11239,5994,61,11104,10578,11364,10454,5421,698,4046,906,7130,7143,714,4801,2117,6940,4419,6588,6167,217,7137,421,5848,548,537,544,545,528,6042,538,554,532,7703,540,553,546,550,6613,6308,1499,7083,4906,6892,7124,3702,834,3029,6715,5995,1492,3029,4834,4437,7635,7953,1296,2635,4438,7995,7840,5782,6844,1357,3863,5380,5567,5769,7641,4769,3823,2041,7879,567,6621,6843,5784,1526,6658,8358,1371,7840,8690,7962,7953,1153,3913,4405,7391,1461,4061,7493,7437,7389,778,1732,7467,4996,4999,5872,6619,1571,6275,4991,4991,6586,6715,6715,6715,3555,3555,3555,3555,3555,6295,6295,6295,3105,6402,6402,6402,6548,6400,6400,6400,6400,6400,2005,7913,7913,1307,1993,7232,2799,1016,5956,5763,3913,5956,5576,2869,1351,834,2009,2799,7178,840,4936,665,4945,7516,7304,1666,7897,1357,6740,1380,7241,7241,7241,6561,6561,7912,7117,7117,8832,666,7085,9049,9049,9049,9049,9908,1307,1307,1307,6636,7083,7155,7119,7097,7110,7085,7112,7096,7266,7211,7115,7572,6140,6140,2005,7086,8405,8468,8468,8211,8450,7289,7289,7096,8398,8398,8236,8404,7662,7273,4769,6971,7304,6362,8596,842,842,6768,8693,8164,6804,6391,8692,6512,735,8695,2635,2635,8694,6151,3883,3892,3891,6700,8613,4435,8255,6801,8544,6316,4979,6715,5568,8217,3598,915,8292,7912,5681,6733,7711,6774,4990,1738,8196,8143,4983,8292,8745,3159,223,8515,8223,8547,5339,3913,5435,6820,7576,6122,8547,5602,8839,8590,1085,1086,1084,5994,7148,6483,8122,8976,8130,8659,6725,1296,6583,6583,8139,2005,1271,1271,6817,7920,7833,6444,2294,1825,7888,6548,8793,6844,6984,8887,8196,5858,5863,6578,6006,3266,1825,6783,6585,6611,6291,6098,1967,1967,7869,7903,842,8542,7918,947,1624,2005,1624,2005,1462,508,1462,508,1462,508,6391,8665,2069,3336,7505,4769,1624,9547,1609,6623,1609,6623,1609,6623,8881,10098,8881,10098,8881,10098,7592,10056,7264,3704,1380,7068,6583,6583,6583,6583,8182,8182,8182,8740,8424,8201,7245,8573,8573,8384,7666,7284,7284,7284,8204,9574,7931,7639,9765,8780,8816,1993,6367,8520,6548,6715,924,8388,5717,2399,4769,6621,104,1142,240,8970,6700,9215,840,6006,9229,5484,1591,6264,2644,7144,8821,5052,6774,5371,217,9390,8833,9281,3327,5770,2253,8515,7838,2029,9468,9027,9322,2117,1371,6131,9162,9513,2006,7861,4435,9538,2005,2085,1052,4395,7923,7976,1242,2989,9480,7992,6642,9524,9479,6103,6004,906,9603,3428,9629,317,754,9306,6691,4079,8685,8815,8814,8826,7576,9704,3598,156,1153,9678,8659,9559,9546,9760,1912,3236,6905,4913,7599,9390,9480,4154,9754,6102,2342,8508,2467,6176,9763,9770,9783,120,6977,9782,6602,9014,7640,9344,4563,6652,9762,6623,8352,9812,2843,9830,8685,6841,8292,8544,9006,9879,9865,9866,207,9872,9918,4216,5419,9926,6819,4320,4900,7241,3499,6718,6691,3455,5927,3898,6751,7705,7703,6715,3336,3702,7048,6587,3337,3337,6584,6584,6367,587,587,525,525,6604,6604,6612,8583,7870,8618,6503,8586,7546,1770,673,8520,2605,9030,9030,1402,1402,9084,8947,840,8826,8730,8814,9104,3598,9060,9319,7295,2520,8815,6700,6700,8949,7273,8922,8922,4598,8326,7270,7270,7374,7374,7374,6656,4121,4121,8154,7639,1746,1557,3073,6688,3071,8824,7670,6138,6138,778,778,1653,4598,223,7641,6658,222,7640,7812,5839,1084,4218,7775,2164,217,8607,8142,6646,5484,7910,9825,3702,9053,7655,7655,7906,8077,9510,7668,8207,9386,9407,7906,8955,6591,3282,9320,8422,9577,4339,9659,7669,6629,810,6693,9292,5376,7159,1685,8794,9821,2913,9664,9813,9936,3604,8742,1992,2658,9354,9479,1967,9049,9933,9985,9526,9594,9594,754,7765,7880,2253,6831,4405,2473,9846,9668,9602,9814,9602,9814,9780,8947,7548,233,182,7599,2849,1300,7261,4199,7118,2261,3702,4199,8623,8767,8280,8280,4405,375,382,389,7298,7150,7297,8236,9132,9132,2474,3247,7106,3874,4146,4146,3874,3874,3874,3874,9770,8922,7903,7833,7143,7019,8793,7761,7761,7761,7761,2169,6768,2658,7897,947,6658,2005,8866,8866,7420,7535,7535,4769,5770,8255,5567,5024,5484,4094,5769,587,8196,7256,10731,5858,3043,5068,9442,1993,378,11328,10348,11400,1153,9817,9819,9820,9818,10095,8229,8371,8712,8571,7261,461,8721,7287,7861,7088,7086,8040,6702,9095,6701,4086,8947,6774,1371,3531,5269,8613,7576,9951,4349,6426,9394,397,2029,8938,10810,10670,979,7300,2889,6365,10296,41,11019,7912,7870,10649,7631,8027,7840,11295,3327,2627,6693,7307,10671,6602,11264,10831,2005,10670,11264,11292,10687,9739,9738,9313,10863,10890,10609,11315,11352,10608,10027,10738,10111,8477,9577,9959,4199,11106,11135,11380,10892,8856,10002,10773,10774,1173,8052,10889,9293,7006,10741,10863,7095,10733,7092,10914,10362,10782,10737,11513,10400,3115,3719,9293,7894,11515,10039,11443,6779,10587,9189,11528,9660,8477,7267,9148,11220,393,11116,7269,11543,9495,8573,7903,11332,11543,10942,7296,8070,11556,9072,7143,8463,10890,2875,1378,10617,10248,9821,10403,8268,8658,11511,4665,11509,10175,10889,10648,8858,10608,10495,9828,11224,11684,10744,9189,10026,11741,7269,10779,9581,9675,10400,11633,11794,10623,11802,11380,10495,10464,11754,10027,10451,9874,11511,11797,10910,11801,9799,10674,9872,11508,11805,11753,10674,11671,8724,11540,10906,11572,10399,11916,11883,11741,11892,11914,11479,11917,554,11914,8359,11534,8547,11652,11651,10027) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC