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,7120,1511,7456,7421,7563,7421,7506,7493,7560,7385,7496,8865,7079,7647,7674,3409,7107,2843,6483,314,3874,314,6984,8145,3860,4224,2520,7100,5066,6658,7289,7816,7816,5897,5996,5996,2992,1537,3172,7783,4597,8683,6350,8161,2632,1250,7548,7548,4801,4801,8820,7160,8223,8526,8547,8815,7388,7480,7409,7516,526,2957,6738,5467,1098,4765,3094,4490,4164,4519,3564,4778,5328,4778,4426,3519,4616,1600,6780,6780,3549,5334,6171,933,730,6216,6222,6501,5093,3532,3784,6523,2725,4029,2300,1823,1533,2457,7748,3085,5386,7172,608,1645,5552,4796,7572,2992,2337,8522,8224,8557,7670,7670,8649,7631,7546,8937,3071,8910,6715,8937,9300,3287,8709,6809,9890,10146,8048,8053,8245,10047,9900,5692,8714,10491,10543,10590,4860,10674,8910,10573,10659,7125,8514,10893,11802,11497,3863,10988,9985,10687,11289,2506,11904,323,7472,6381,6381,7416,7244,7108,7101,7085,6750,7276,1086,7279,7574,7987,7986,6742,6749,7985,5454,7745,7741,6529,8365,8237,8684,8818,8583,8753,3413,3510,7070,7283,6386,7906,8157,3860,7068,8397,2992,8415,1537,7304,2951,7897,7100,8743,7939,7088,5996,8080,8422,7252,7644,7830,5647,7588,252,2736,1533,1210,1210,466,8454,464,8287,8909,8585,9084,8682,7912,4834,4986,3165,8665,4405,801,8816,8815,7024,4834,5995,7304,446,446,8520,4259,5419,8220,7635,9209,8142,8512,840,924,222,2387,3625,4362,1257,6104,223,5995,7083,435,5251,1207,7143,7833,5371,1533,4784,4046,7966,4983,7751,7972,7972,7599,7973,7973,4791,7033,7033,5143,1439,2989,7261,8377,7659,8406,8406,7100,7644,7266,8288,7076,7091,8404,3327,3327,6609,6609,6616,6603,6603,6603,7655,8251,7089,10406,9793,7715,8791,8646,8412,9441,8428,10851,8462,7077,8721,8206,8537,10615,3702,8475,3884,3926,382,374,7069,7298,2009,8166,1537,7879,7104,8390,7878,1537,6740,7238,2843,7290,8095,8094,8488,8587,186,7155,7649,8741,6754,5576,2869,1351,834,8381,8886,7932,8698,8580,7089,8816,8966,9092,7781,8479,8836,6381,5362,8745,8109,9321,3029,1152,1532,9300,7266,7674,9386,5421,8230,9001,9300,9463,2467,4109,7635,7289,6971,9897,8401,9948,9783,8526,9879,7928,9349,8240,7674,7110,7252,7272,8236,8228,8451,7106,8644,7112,7654,7253,8420,7105,8236,6214,7151,7283,7246,7261,7118,2992,6212,1704,4289,4293,6880,7246,7252,7253,4752,7644,7643,8080,8080,8080,7104,7124,7648,8081,7261,7088,7088,7088,7658,7286,7975,8041,8041,8574,8713,7120,7261,7150,7077,7109,7655,7099,7155,8832,7295,7661,7662,8771,8771,7111,7079,7079,7110,7096,7971,7280,7244,7288,8055,7112,7084,7655,8050,7674,7932,7932,7932,8618,8682,9084,7172,9407,10238,11019,9920,10565,9084,7631,11218,7184,11016,5635,4386,7179,7189,6652,7178,7182,11240,510,8897,7770,7180,7772,7771,511,512,8946,6654,11013,6688,9473,11014,7181,7183,11354,7176,6653,7188,11419,11421,11422,7187,11418,11420,9407,9084,8682,10565,10238,9920,11146,11147,11148,11015,11082,11392,9437,11019,7998,4386,9129,11218,9671,9670,9669,8946,7186,11464,11493,11462,11463,8172,10750,11431,8007,6596,9233,10433,11017,8971,11430,11414,11429,11321,6836,11498,8610,11446,5988,11521,10472,6521,11181,11487,11495,11427,1347,5339,5545,9084,9920,8682,11362,8681,11109,9958,8698,11468,848,9492,6216,10864,11269,11649,11349,11664,6497,11377,11378,11678,11069,8154,10042,9638,9220,10941,11493,11647,11349,11724,10895,8900,9638,9220,10569,10787,10856,10042,9904,9086,252,5373,11126,11678,6713,11237,51,4082,7550,8837,5193,3018,10367,8780,4401,10824,24,9896,11355,1770,7184,8306,6713,7185,11016,11647,11463,11464,7176,11488,11664,5255,11876,6800,28,10942,9492,11093,524,543,553,539,535,529,532,554,7124,9933,11592) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC