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,8108,867,1886,8579,6958,8621,1984,6738,7204,5439,8196,8623,6648,2643,8435,6701,8633,8255,8130,6820,8542,6959,8622,6960,8624,6687,6972,6973,6974,8112,2775,8579,7388,7437,7334,8496,7159,7385,7501,7484,9024,9024,9024,6840,6593,7619,7037,5088,5184,9831,9467,8659,9467,8659,9324,9840,2998,9959,7207,9959,7207,9959,7207,6082,9141,834,9581,8206,9997,9951,7767,10061,5564,8639,10029,4659,324,8772,9998,9989,9763,9579,8229,8063,8928,8922,8628,8050,7112,8792,8431,8510,4544,1828,1726,9968,9959,10034,8364,8287,10379,10402,10693,10694,10590,10592,6538,6533,6534,6505,6536,6537,7567,6506,7027,7568,9791,9591,4804,7762,7570,6768,7764,10567,9791,7845,9631,9455,6212,6215,6216,6499,6222,6496,3846,6220,6223,6214,6498,9483,6497,4296,4304,6501,7963,7698,7844,7695,7610,7608,3442,6218,7696,7868,7843,7694,7693,6512,6520,6521,7569,4293,4294,7697,8323,7844,1704,8655,8692,3070,3071,7888,6689,3073,6354,1771,1765,10828,10546,11142,6697,2779,2803,2791,6443,10963,2787,2802,2817,2799,4486,4473,4470,10687,4464,4463,7166,4316,7168,7167,8520,5484,1782,11354,4338,10868,10987,10339,10296,7159,5098,1974,1726,4923,9856,1307,9488,10301,8130,10316,8130,10316,226,4923,11101,11215,11101,11215,11497,10579,5435,10731,5435,10731) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC