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,2389,2869,1738,5515,5371,4527,1461,2869,1890,7159,2187,4061,1351,834,217,6858,7046,5179,1462,5882,5995,6364,6940,4637,6845,3428,6693,6365,7138,6396,7131,5046,7359,7005,7049,6110,6727,6766,7022,3989,7032,3100,3561,1131,179,6740,6986,7238,455,1350,4385,7210,7144,7023,7156,7141,7058,7206,3936,6710,1461,7050,6809,6104,3165,5491,2652,3523,1823,7126,6856,1742,6969,7745,7742,3043,7244,7078,7108,7101,7085,6750,7276,1086,7279,7574,7987,7986,6742,6749,7985,5454,7745,6529,8365,8237,8684,8818,8583,8753,3413,7021,1402,3883,4597,7656,7657,7123,7097,6869,7675,7658,7655,7121,7101,2522,2117,6947,6743,7286,8071,8041,7116,7287,8067,8197,3892,5602,6604,6745,7279,840,8210,8298,8040,8227,7971,7226,8391,1462,8410,8462,7745,7742,8053,8047,8022,7093,7910,8580,6648,8547,397,8685,6272,5184,8391,8055,7903,6596,4282,7654,8290,6259,3029,6371,6175,2467,6151,1738,4289,5691,5904,6526,1462,6212,7913,6742,391,3885,4512,8700,5386,6953,2164,8388,2455,4701,8780,4769,9391,3515,1116,8247,8980,4424,6832,735,8896,2989,222,7178,6181,3036,223,8899,2389,8242,5567,7186,6444,961,6377,452,6523,9692,6652,8825,7189,9559,9631,7764,8279,8816,2778,9996,7762,7570,4437,9949,9970,9338,9792,9880,1245,7725,9763,9665,9616,1770,9950,9492,52,1765,7,9906,9951,1771,9480,9880,10219,6115,9424,3913,10102,10199,9835,5484,8432,450,10154,8257,8727,1250,9669,9782,2780,4701,10188,10110,7751,8151,4639,10155,7972,7973,9670,9892,10155,961,9671,9033,9131,8822,9672,9673,5175,576,9168,6119,9473,6003,1766,4500,5769,4349,2605,4338,979,5678,10156,151,9473,4800,9720,3081,9722,4901,10281,2467,10071,8566,8967,10655,11097,10187,10991,11025,11116,11105,11135,10974,11104,9,4424,11052,11072,10554,9959,8173,10886,11092,6181,7205,2079,6820,8507,11306,10550,1774,7048,5531,4510,11118,11260,8970,10718,2169,11045,10483,11053,11279,11482,8565,8721,2056,11099,11449,10941,1887,10947,11283,11253,6267,6118,10133,8946,9846,3327,7888,961,11638,11886,10477,11622,10682,11328,9390,11908,1265,11853,3105,3081,6821,10886,11749,4580,11744,11603,9505,11854,7214,8303,11439,10211,12001,11676,788,2748,11776,11720,9062,11452,9649,6971,6592,6971,6592,6971,6592,6971,6592,7733,8801,9694,9579,9718) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC