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,7971,7971,9660,8229,8229,7112,2085,4752,4769,7241,7674,7125,7110,7117,7574,389,4801,7073,1250,8053,7671,8240,7152,8033,7895,7895,8047,7656,1084,8514,8571,7250,382,8739,7483,7106,8794,7243,8282,8863,8863,4068,376,9054,8240,7671,9055,9132,9134,9134,9134,8412,9259,9733,7264,1145,8866,8941,8941,6629,2092,6390,2989,5380,223,1029,5576,7238,7304,6364,2869,6740,961,4294,5297,4395,4293,7593,1272,2605,1461,2706,5386,243,7179,7599,1371,7022,840,1351,7761,1095,4432,7840,1165,7984,6809,1349,4386,7176,8091,4985,4944,8135,7920,4945,4941,4940,4943,4942,4939,675,8358,665,8151,7239,7900,1126,8547,6600,217,8514,501,7241,7187,6953,7261,6570,6644,6104,8825,7665,8783,4834,8626,6595,8142,8488,7910,3029,8781,8305,6499,6204,3549,7636,8019,5121,7994,812,5334,9007,8055,6780,1645,1345,8047,8019,8780,7751,8816,8955,1073,6986,7224,6710,7932,9308,9343,8842,9647,9009,8620,7640,9465,9258,5678,2467,8681,9546,9558,9577,9900,6113,9945,9386,10046,9959,10146,10240,9601,10353,10346,10349,10467,10002,9257,258,8269,7659,9277,10060,10892,10814,2399,8471,8092,7900,7283,2913,8955,2761,4765,11272,11271,10287,7874,8033,11333,10715,8570,8570,10076,8406,7647,7083,7124,7107,7094,8227,7268,8438,8643,8575,9056,6715,10436,9674,8446,10171,10630,10402,10379,8207,10575,9998,2374,10960,10731,8658,8658,6728,8772,10674,5872,311,2644,10113,10114,10114,10472,10893,10543,10543,2913,2913,9281,9281,3646,3646,11063,10624,11628,11711,10768,8900,9991,11753,8765,11834,7655,7077,9056,11678,7661,8768,7268,7268,7485,7485,8740,8740,8740,9899,7662,7661,8721,1497,10166,7674,9817,8444,7114,9719,10272,10507,9547,7268,8740,8740,8908,10451,6264,6264,11225,8891,9741,10400,7539,7472,7986,10272,10489,10488,6545,6425,6424,10486,6421,10882,4224,4224,10577,10449,10881,10693,8739,7249,10009,7932,10862,10835,11127,10820,10890,10629,9540,11027,11162,9080,11103,9754,5965,9329,7585,11232,10702,7694,9959,10089,10566,10747,11372,11516,10768,11476,11331,11479,11628,11629,9509,11480,11225,11409,11453,11711,11689,11339,10614,11712,11453,11778,11675,10749,11685,11382,11484,11845,11477,11417,10397,11846,7250,11654,11846,10397,7077,7287,7286,11526,7147,8377,7249,7088,9739,10007,7081,8571,8371,8641) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC