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,1038,5910,5236,4419,5998,6003,6195,5956,6896,6587,6843,6638,6102,1242,6173,1591,5912,2749,7046,6718,4971,6559,6799,6804,3744,1270,6727,5068,5998,6977,7149,7374,2967,4985,7155,6565,7416,7937,8094,2864,6860,1271,6365,2748,6130,1727,3892,7290,8523,4385,9095,7677,372,9300,9381,9374,9621,9890,6550,6580,3702,6547,5046,778,7159,6239,7301,6868,6548,5215,3701,6294,993,550,1771,524,1586,3702,2522,6980,675,6843,538,546,6042,528,3913,7123,537,5576,1296,6004,528,526,7250,7085,7086,1664,6306,2006,7977,6740,553,7238,544,8220,7654,587,8102,182,7903,1807,7110,7932,8077,8544,8470,8615,8306,8528,8047,7268,7080,7660,3409,7107,2843,6483,314,3874,314,7078,6984,8145,3860,4224,2520,7100,5066,6658,7289,7816,7816,5996,5996,2992,1537,3172,7783,4597,8683,6350,8161,2632,1250,7548,7548,4801,4801,8820,7160,8223,8526,8547,8815,3838,7806,821,821,5923,7499,4742,7272,7368,7501,7122,8406,8406,7105,7304,2041,7388,10572,10572,10211,10211) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC