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,4728,6168,5996,526,2056,391,7270,3860,4199,3896,1458,7300,6768,7300,6962,7286,4860,7899,545,550,548,539,4684,3554,3554,1398,7175,7032,1662,549,6477,525,2706,778,551,864,1366,8356,8530,546,8880,979,6394,6842,8212,7472,9030,578,547,2847,3337,1777,7178,8438,4500,4500,9076,9778,9494,9494,9791,9745,9858,8575,8575,6648,9488,9879,6583,6583,8434,8434,9547,9547,10638,6579,8063,8833,10731,8428,9853,9785,6400,10695,4500,1783,7155,7281,6413,6414,2389,7387,7066,7594,7421,7672,8203,924,7374,7491,7565,8363,5454,156,8206,8206,8839,6364,6852,5877,431,7878,7641,850,1159,7920,1345,1345,6188,5995,6315,1586,1537,5763,24,223,6103,6415,6383,435,4659,6412,6348,2294,5596,6414,5576,1351,6752,4230,3247,6947,1207,7023,7089,7068,834,6858,6171,7238,7209,5743,4146,4652,3159,3437,5996,466,1741,1572,3457,7022,3554,3754,4597,7032,566,6856,6984,7304,6110,2328,6940,7143,1536,7837,2118,7659,7834,7835,2594,1741,1210,7833,8523,665,1349,1016,7836,7840,7879,7878,8306,1215,8514,6010,5609,8358,8927,2737,8389,8915,5371,8681,8698,9041,8817,4131,8869,8884,8442,4901,7823,1257,2677,4519,8901,6006,1740,3875,372,9053,6977,8220,7903,9029,6740,9300,7238,7833,7833,7143,8141,7905,582,4503,7885,7666,7096,7118,7246,7493,8108,8831,6583,4399,6396,7917,6394,6402,9616,10731,1765,7493,9949,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,1828,1726,9968,9959,8650,10034,8364,8287,10379,10402,10693,10694,10590,10592,9004,8231,8941,8941,4362,4362,4362,10065,10065,2342,2005,7238,10056,2324,8498,11069,6733,6800,8002,8860,7416,7503,7369) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC