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,4492,7444,5853,7406,7443,7406,7456,7070,7120,7642,7648,7645,7652,3874,7298,7674,2635,8048,8047,6003,906,6691,7406,2795,323,7078,6381,6381,7416,7385,7292,7247,7561,7101,7387,7241,7251,7422,7422,6174,6740,7238,8220,4769,7840,6003,7879,7878,7592,3913,7554,7754,7755,7756,8509,7539,446,7927,7445,2041,9359,6316,7219,7491,7537,1499,659,659,6714,6714,7501,7501,7422,7422,7422,7385,7385,7385,7385,7385,8211,9132,6348,8269,7656,9053,7660,7658,7091,9813,7077,8044,7661,8721,7662,7287,5996,526,2056,391,7270,3860,4199,3896,1458,7300,6768,7300,6962,7286,4544,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,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,7539,7986,10272,10489,10488,6545,6425,6424,10486,6421,8638,10882,4224,4224,7497,7458,7457,7451,7443,7273,7291,10185,10510,7289,9138,8794,7543,7400,7419,7541,8868,7491,7563,7390,7449,9853,9025,7290,11201,11477,11479,11480,11476,1624,820,6801,10677,10817,6803,10985,2538,11053,11215,10707,11380,3105,3108,7383,7409,7408,7406) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC