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,7241,3499,6718,6691,3455,5927,3898,6751,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,6631,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,858,6191,6152,1730,6517,397,8549,6376,4178,4340,5763,6703,752,3457,4023,6809,585,3908,5764,6740,6104,3913,4950,3474,504,7238,3715,1016,3368,3933,7937,7903,8220,4337,4901,4901,6821,8306,8306,8306,6151,8228,6750,6521,6521,6521,3612,7614,7614,7199,7195,9165,7162,7198,653,3875,7196,7191,7194,8988,6385,8984,9592,2520,7199,6925,7200,9087,6926,6931,3277,7190,6386,8986,9172,9885,7199,9177,8986,10044,9175,7196,10045,6931,7192,6936,6935,8583,8598,7985,8307,553,7300,539,9183,532,545,8002,547,9410,9412,9416,9414,6354,1524,524,3892,3893,3895,3890,6396,860,8917,382,3883,368,6742,6985,735,3896,528,542,546,8274,4580,1765,573,6521,6220,6521,6220,6521,6220,3894,6200,8085,7654,8361,6920,539,9734,9735,8987,2701,7095,7572,7118,7108,3860,7967,6832,6832,7213,7897,7897,5996,5996,7661,7661,6523,389,5165,2992,8268,1537,7104,8055,7263,7602,8033,7258,8087,8087,6388,7082,7252,7076,7079,6521,6212,6223,7698,9781,9591,9592,6656,7844,9312,9590,6220,6497,6498,6222,6496,6216,6501,6215,6218,6221,6214,6499,1770,1765,1771,1767,1769,186,1738,3891,3892,6715,8989,6715,8989,8831,3493,1738,7019,546,7195,3898,9156,8988,7199,9409,8882,6928,9173,9172,8700,9408,9176,9536,6768,8971,1730,8387,8858,9146,9145,9147,9144,9143,8881,9150,9190,9191,240,9411,9151,8987,9192,9767,8986,8654,8656,9592,8530,8529,536,535,7694,7695,7696,7697,3881,3884,3888,7868,3890,3883,8531,3882,3895,3893,7196,7198,7702,6937,7196,7198,8655,8665,8581,9993,8879,9088,9178,6270,9633,3896,3894,9177,9175,1765,5386,6656,6985,9217,8168,2856,7870,9154,9892,10100,9155,9792,392,386,9891,10097,10099,9894,9906,9891,4305,8242,9903,9951,8274,3887,3885,10136,10147,10102,9909,9908,9950,379,10193,3889,3892,9535,8329,9535,8329,9500,10239,8232,1398,6678,7270,7251,7251,1126,6595,6447,2849,7856,6595,7296,7856,3595,6795,7296,7904,7714,7879,7271,7101,8053,8058,8034,8076,8040,7119,7931,8046,7878,7548,6155,7946,8284,8209,6235,7273,8373,8418,7840,7878,7879,7115,8481,8573,5320,8220,7280,4878,5320,8720,7971,7275,7297,7971,8761,7298,8419,7670,182,8683,7761,7547,182,3895,2522,8682,8618,6936,6938,7675,8698,8739,8933,9030,7124,3080,8412,8908,8580,7103,7083,4258,2605,8847,9134,8358,6354,9336,9134,8042,9244,9329,3070,9322,3073,1349,4460,9071,7087,9449,7239,8064,8458,6514,6514,8405,6986,9312,8832,6700,9367,9093,9777,1381,3760,8436,4299,3541,4160,8681,9958,9874,4178,2253,6619,9143,7368,1770,1765,9932,10109,10087,9603,8724,7113,9603,7649,9200,10008,1767,1771,7692,7690,7686,3172,5837,8896,1609,4805,3071,3875,8220,7020,3590,1766,6740,1688,9963,3282,9769,10008,6828,1787,6642,7752,2261,8220,7973,7751,9146,2915,10379,2349,4847,4847,4728,675,1785,169,9951,9486,7368,5245,9951,9082,9026,8255,6658,9932,2474,8956,9009,3908,2337,9384,814,4330,7203,4234,7059,6624,9879,1357,7203,814,8856,8855,8761,1698,1308,1776,6030,3250,1766,9873,9833,3893,8793,1461,9344,6715,7235,2784,7246,9893,6427,9052,9115,9052,4566,1165,7903,3380,1215,446,8942,7823,9824,10742,4535,10475,4535,10475,8742,10228,10965,6728,6700,8080,10737,3860,9676,8669,576,9496,10929,4947,7598,9547,6416,10422,10381,6764,10264,6751,544,6151,6763,8160,6493,573,8158,9859,1664,7605,2605,10416,2270,10742,8394,5484,10356,7751,10789,11289,6776,5487,9368,9367,8323,4730,93,11268,10836,10056,9300,8082,10768,10767,11719,11781,8910,8514,10722,10722,11670,7895,10543,9406,11846) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC