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,863,5719,397,714,6798,6390,713,6381,377,3036,6082,386,392,6381,3841,382,323,4906,372,6380,374,2701,2474,7238,3860,378,4199,6740,3933,6809,7833,8215,7903,1984,5995,4878,6381,1766,1506,6617,926,2783,4146,6204,222,6178,1038,600,3841,4411,504,1770,1771,323,1767,1730,6742,1768,4156,6664,4452,3036,512,1557,4185,6390,1351,4146,1770,6740,3874,4614,4146,2023,6034,6036,6596,4473,6381,6038,4791,7238,7505,435,5143,1765,6740,7238,3511,3874,508,1771,1767,7834,6740,7238,6482,7473,7837,7836,2786,3874,6023,7837,7138,6639,7354,6730,6684,4146,5535,1215,3511,7837,7834,5995,392,384,4765,391,392,377,389,5380,381,390,3875,7837,7834,7835,7835,2992,1163,341,1906,6122,6493,3897,176,2157,3337,3897,6582,6140,863,864,6583,6752,6780,397,6883,6493,6204,5956,1121,6986,1245,6381,6743,323,6388,5386,6656,3515,858,6503,7107,5909,863,7654,7654,7713,7072,7155,7105,7644,7650,6796,380,7020,726,1250,1165,979,8085,4490,4769,7118,7119,379,820,4989,6381,1557,3897,6270,3893,4452,6600,3884,3894,8034,3889,3891,3892,7117,8047,7693,7975,7100,7155,7654,6272,6195,8050,7096,3881,7304,374,1664,6719,7437,858,857,397,1537,5910,376,382,379,6743,6144,4614,6751,6082,380,4302,379,391,376,377,382,385,390,3090,6742,3728,5371,381,386,6076,385,377,394,386,8168,387,376,8165,6750,393,384,375,6270,6066,372,379,390,3893,7199,6082,368,3879,7238,409,6749,3036,365,8168,1557,392,389,8788,8785,8786,4639,8882,223,7923,4395,8878,2989,8787,6103,6746,7871,367,2117,8877,6493,3428,8881,7239,8982,5770,8983,6204,7175,8358,6785,6144,6538,8856,6386,4714,386,8789,8880,8858,8855,9192,378,7300,6491,8651,3889,3896,3883,3885,4302,7214,3888,979,810,1165,8824,8857,8358,6359,5386,5297,9149,7599,7808,1266,1411,1685,4289,6527,6521,4293,6218,3891,3890,4294,3895,6532,3892,7693,3894,3882,8271,3897,8272,3893,3881,3884,3888,3883,8274,8273,8981,8982,546,554,6537,8980,6381,3885,8879,2701,6377,9698,9713,9709,9708,9710,9711,1766,9718,9435,8241,8246,9593,9592,8310,9684,8598,8249,9427,8243,9425,8339,8242,8597,8245,8247,8248,8318,8317,9428,8319,9435,8319,9424,8320,9436,9426,8328,9591,4286,6199,9891,1145,6632,7580,6023,2677,7760,4563,7815,6986,2776,7599,272,6642,7605,637,7751,947,6871,6315,3803,7759,7972,7938,7354,4519,4558,7973,7837,1234,7834,7835,3189,5143,7836,5142,5251,8089,3066,8140,5936,8150,8111,5094,7920,4731,6713,8215,6691,8222,8193,5431,5536,8304,6810,7016,5817,1349,7005,2451,5947,4325,8390,7642,7105,3026,8281,840,8358,6732,8547,7246,8514,320,6693,8305,3913,8548,1738,5763,6354,8816,6595,5334,8802,8213,6726,4652,665,8730,8839,6778,8910,4730,8885,7903,8629,8220,8932,4936,9049,3542,4944,1886,36,4945,4941,7126,4940,4943,1521,4942,3775,4460,4939,4938,3449,1176,9300,8478,5841,180,1177,2657,9466,4950,3080,1042,7772,510,7770,7771,511,512,7637,7592,7755,7756,7927,8509,9880,8999,7019,8222,8793,9195,9925,9552,177,178,179,10229,10292,10056,9461,10063,10227,9769,10528,10526,10548,10543,9406,10358,5756,6659,9533,9675,9879,10964,10836,9383,4834,9867,10232,10278,10938,254,9220,8904,11121,10626,9677,7928,8688,9196,8547,9636,11171,10397,10315,11219,6857,11439,11361,11324,11455,10748,9929,11397,10476,10149,10784,11396,7581,6117,9347,6731,9648,4536,2873,11374,6730,4329,6692,6373,6750,979,6656,4079,6371,6372,6740,6512,8241,7751,8245,1029,8337,6538,8331,3889,6493,8323,3890,7840,7879,7878,7897,3913,6264,659,8319,6193,8323,5420,6520,8317,8341,6372,9030,713,4299,4292,1371,5484,4297,6103,6519,6518,6103,6518,8584,8585,9552,7870,7546,1770,9300,1765,3702,8222,7303,2992,4769,391,6066,384,377,6082,382,374,544,573,528,539,548,525,549,272,6381,6066,393,386,6082,6742,6796,6204,6220,6533,4146,372,375,673,6750,6751,6744,6749,6745,365,6270,387,378,376,389,6076,381,368,391,6066,384,386,6082,6082,390,6750,6751,6751,863,3882,6197,1537,418,7096,7268,7089,7121,7125,7084,7288,6751,6750,6517,6076,6377,6742,6743,382,7278,7278,7287,7287,6151,6604,6742,6918,1557,6745,379,7123,7123,7123,3889,7264,7971,7971,3890,7107,7647,7245,6540,6970,7282,217,7100,8055,7649,1666,8641,8050,8047,9229,7304,9797,7124,7099,7150,7150,7150,7105,7104,9796,7155,9794,2635,6386,6646,3327,3890,5435,5435,5435,382,382,3337,3337,3337,3337,1558,6388,6386,7702,3334,3334,3334,3334,3334,3334,380,6854,4614,8884,8788,8817,6386,8580,8341,8682,8649,1266,7753,7752,8627,8088,8699,8342,6270,372,5066,374,380,386,393,385,8727,510,7772,391,389,390,387,392,7751,8786,810,6076,5332,6652,6654,375,8784,2780,2785,6491,6489,1245,860,6546,2696,2917,4426,6600,566,4490,1210,466,4752,4788,6719,3564,6539,863,541,6985,313,6200,6199,4121,4029,6201,6198,1533,550,801,1207,4788,28,8316,8313,8338,8333,8328,8341,8342,8317,8339,8325,8314,8324,8340,8335,1245,3883,3892,3889,3890,1770,1767,4301,4286,7180,7184,7698,6223,4219,6902,8252,8873,8340,8649,8872,6390,323,8665,324,8787,8785,375,8788,8786,6270,382,391,394,9111,9114,365,8858,3719,382,365,3891,6066,6854,389,8877,372,390,380,381,6376,8329,8324,8323,8325,8243,6377,8882,393,8878,6517,8596,8883,8324,8788,6371,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,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,8599,8322,8335,8334,6534,6536,6538,6532,8300,5827,6266,8315,8320,8319,8317,8318,8248,8971,6533,6505,7655,7286,7143,4639,1645,7976,7080,8109,7897,1487,4617,7069,2389,375,390,377,6066,8078,8078,7279,3647,8230,8512,8611,8306,8306,4570,7910,8991,6907,8282,7084,8948,8459,8740,8469,8765,394,8880,8880,6774,7986,7986,8877) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC