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,7561,1993,8481,8481,8833,9667,9667,6548,6548,9529,9148,9259,7288,7288,7288,7288,7288,3327,8739,10670,11101,6700,3884,3926,382,374,7069,7298,2009,8166,1537,7879,7104,8390,7878,1537,7078,6740,7238,2843,7290,8095,8094,8488,8587,186,7155,7649,8741,6754,5576,2869,1351,834,8381,8886,7932,8698,8580,7089,8816,9092,7781,8479,8836,6381,5362,8745,8109,9321,3029,1152,1532,9300,7266,7674,9386,5421,8230,9001,9300,9463,2467,4109,7635,7289,6971,9897,8401,9948,9783,8526,9879,7928,9349,5134,7829,4520,8793,9117,9195,7634,9129,609,1586,4648,9000,7546,6660,7734,8146,9541,9155,8528,8933,9052,9850,9639,10056,9639,10056,4219,9678,4219,9678,9300,9872,9300,9872,10836,10760,10836,10760,10228,9603,2635,8780,10301,427,2156,10340,10060,9365,10279,9773,9451,9130,8950,9471,8434,9463,3437,9864,8839,9116,3302,9467,9933,1215,10129,8995,9987,446,1768,10141,9092,9340,675,10073,9942,5769,5551,10314,9831,9897,6362,10048,10047,9938,9834,9710,8305,9451,933,6660,8822,8684,10935,10549,5334,9129,7903,10283,7135,10892,8089,9086,9904,11136,9986,11314,11494,8839,8974,11658,8305,11658,7204) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC