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,5995,455,734,463,3585,319,663,6660,3850,4218,3184,3217,6364,5070,772,5765,5623,6599,3844,360,3521,3522,743,3520,6644,2033,5956,3519,3302,447,5839,4057,6947,1416,2390,1371,6641,601,2170,3557,567,6645,2628,7023,3264,1345,2602,944,2911,1257,780,6731,1257,4046,4536,7304,2873,4986,3465,7238,1379,446,4218,1257,6712,7752,7751,3830,7748,7799,7802,675,6263,6663,3029,3585,5179,446,6439,3613,801,1070,820,1498,975,396,6635,501,6766,6766,2706,5148,7238,7238,5576,2869,1351,5371,5552,344,6818,6940,3557,4860,3850,6189,6130,1371,6766,6899,6645,4663,2261,6982,446,6642,1947,6774,4986,6599,848,4395,6354,3070,4662,1095,2951,4512,4706,3428,1084,6578,4218,6740,1038,6766,2025,4061,1766,3037,6725,5286,5995,1215,4100,3860,5421,6631,698,4046,906,7130,7143,714,4801,2117,6940,4419,6588,217,7137,421,5848,7307,2183,6223,2824,6212,344,3828,2876,2795,2164,1765,1770,1767,1771,1768,1769,4944,4936,4941,4945,4943,4940,4942,4939,6658,6644,319,663,2808,4938,6215,7551,6501,6216,7258,8062,223,4395,4535,5996,4639,6130,3715,466,5331,3625,4337,6713,6713,4337,4082,5142,1537,5371,8220,28,958,7304,6845,4983,8358,5732,4452,5763,324,8691,4061,7840,6845,665,1349,6189,3216,435,344,5572,6645,228,1145,5839,6540,6122,6544,6172,6257,1425,1210,5777,3825,501,2594,5459,3302,6350,933,4079,463,5305,7850,3428,6544,6971,501,766,4860,7240,4796,3217,4861,3264,2164,8390,2632,8306,3989,4454,8781,6740,319,5995,6713,9011,725,5371,8995,8488,8706,3646,8560,8840,9671,9867,9907,6149,9920) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC