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,4178,858,6545,6840,6763,6764,6765,3090,6144,6753,6761,6762,6759,6760,6840,6424,6752,3609,6750,6742,6391,6746,6744,6749,6745,6911,6910,6914,6913,3926,6422,6758,6421,6935,6424,6425,6932,6938,6925,6926,6912,6427,6423,6763,6764,6988,6934,6937,6928,6758,6911,6757,6756,6391,6753,3247,6917,6763,6764,6765,6762,6761,6414,2282,6932,6754,6752,6423,6935,6759,6925,6760,6427,6757,6918,6912,2274,6910,6938,6423,6424,6926,2275,6426,2282,6756,6191,6911,6758,6763,6756,6932,6926,2274,6757,6935,2275,6423,6151,215,6152,5996,3263,3277,6763,6764,4614,6656,7100,7072,7122,6612,6751,7091,7109,6744,7075,7294,653,6521,6388,6391,1746,2992,240,7087,7258,8087,7263,7675,7675,8049,7089,6385,7300,7106,7069,7276,7125,7117,7117,7117,1927,7120,6656,7116,7295,7151,7105,7246,8365,8070,7096,9081,8064,7081,7102,8798,2780,2785,6491,6489,1245,860,6546,2696,2917,4426,6600,566,4490,1210,466,4752,4788,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,388,8786,6270,382,391,394,9111,9114,365,8858,3719,382,365,6521,6761,864,5691,6527,1165,6522,6518,6538,6520,6218,4282,397,6985,1767,1704,4298,1685,7576,1084,979,6656,3442,2951,6800,4121,6376,6768,4296,858,397,3875,4286,4289,1967,3863,4121,857,6985,5297,1411,735,8245,6521,6527,397,7201,7599,8243,6261,6512,8314,8318,8317,6359,8334,8320,3875,8582,4931,8249,8490,7365,3510,7751,8729,8694,8692,2779,7300,2828,5635,2783,2826,2827,8597,2815,4804,7180,7184,2803,2805,2806,2808,6222,8654,8655,8816,8696,6521,3828,6542,6381,344,8531,681,6376,2876,8355,8353,9343,8874,9129,6444,6409,8698,2218,1266,6276,9041,8324,7721,810,2208,3337,6540,8882,382,1084,3327,9949,10037,10034,7721,10032,10263,7204,2169,7697,1704,7693,7840,10696,3327,8490,8507,10698,10579,6925,8156,1084,7721,7966,10983,6988,6922,582,6929,6925,11406,11407,10324,11677,10742,11427,374,1664,7437,858,857,397,1537,5910,376,382,379,6743,6144,4614,6751,388,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,388,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,6807,4437,1983,1153,3850,6658,6583,990,3865,3863,408,2795,7119,2781,2474,3875,1411,1266,1266,979,979,979,979,7968,8203,8200,8200,8200,6377,7599,529,7654,7663,7076,6197,6197,6197,6197,6197,3036,6381,6391,6175,1492,2520,5996,5996,6386,6386,8596,8345,8345,3172,6444,7721,6966,6151,1327,458,6616,3549,6103,464,3428,5334,3997,5882,6798,6840,6763,1663,6157,2998,3449,3069,6427,3389,6491,3898,452,222,4913,6600,6855,6388,2507,4765,3254,3169,6151,2684,6905,6129,464,4659,6181,2164,735,393,6894,379,6146,2737,1049,397,7195,7199,8656,9088,6523,3327,8387,6545,8305,6604,8592,6616,6700,9151,9190,3879,8097,6521,7400,9502,9647,9502,7266,7294,7253,4558,7152,7091,6962,7125,7095,7276,7707,3090,7123,7805,7665,7093,7296,7096,7671,7278,7271,7115,8048,8033,7280,7272,8412,8477,8645,8473,8709,7941,788,7291,7291,7124,8852,7083,7092,7106,8405,7103,8064,8393,8398,8466,8354,8349,7068,7666,1558,8475,1667,9201,7244,8465,7088,7093,7099,6969,3926,8093,7109,3090,3926,6984,9574,9573,8208,8576,7666,8577,8412,8475,9148,7346,9745,9314,9076,9583,8468,1990,9873,9470,9818,8644,9207,8410,9973,9956,7574,9055,9577,8574,8439,9956,9583,9583,9583,387,10020,1766,6198,6222,7162,6216,7199,6391,6388,6214,2951,6220,6218,9829,9165,8156,6920,6925,6926,4304,9734,6988,10161,6742,8656,9176,9177,8816,6498,6497,6216,6499,6939,3248,9737,7953,9176,10387,1767,1766,8330,8328,8323,1768,7569,3515,9590,9591,11047,9593,10201,10725,10920,10561,10728,9588,10139,8325,10801,10216,9429,6534,6535,9493,3073,3070,6354,7753,6689,3071,10544,10053,9665,9946,11221,10544,10975,9394,6700,10441,1097,2627,2627,6424,10250,10489,653,7610,6836,3515,6240,10455,7311,11726,7311,11726,5691,7697,9156,527,10429,11081,6454,6456,11003) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC