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,1768,4302,7599,7610,1165,7808,2605,4282,6359,1766,4614,3891,6493,3895,4720,1770,3883,6354,3070,7696,7168,5810,4714,7748,7748,6689,3073,8618,3892,4784,1767,1533,2677,6740,7238,8220,9300,9049,6523,6373,6373,6373,7869,8489,9031,9920,8583,4714,8584,7546,9407,9084,9084,8682,783,8618,7870,1656,545,6382,6390,6527,6521,6261,7631,6212,726,510,542,528,512,6869,7770,3515,6513,526,6198,2696,6498,4614,6497,6199,6223,4289,4293,4286,4282,6197,4292,4291,532,4290,842,5903,6546,1266,1165,6359,864,3247,1685,1616,3384,540,5066,3380,543,8244,8249,7189,7184,6042,7180,6201,3581,6656,6652,6733,6653,6223,6218,7176,1245,7179,7187,5332,714,4426,2917,5096,4490,7170,7172,510,7598,7596,7637,7636,8278,549,7188,8599,8329,8246,8328,8342,548,8597,8598,8320,8317,5635,4386,8337,6654,8165,7235,7721,650,7001,6565,6076,6544,6669,377,7230,5996,6122,4714,7855,6998,5735,943,6031,2571,6993,1537,2473,7237,6444,8168,2530,7231,772,6675,743,6678,6575,7051,6827,8230,7232,1829,7034,7224,6571,3843,8512,8541,6421,6882,6422,3778,6425,2469,7779,6424,4219,652,7758,7635,567,986,7228,8142,3429,6191,3351,6937,6726,6933,1967,7856,8290,6023,539,3892,6562,3891,3883,1461,313,533,6736,272,223,8542,3885,41,7019,7986,8434,7985,7813,8324,7024,6354,7568,9300,9936,5421,10032,8003,3877,8585,8883,7870,10214,8682,10099,10158,8618,6034,10238,7588,6386,510,7772,10041,173,1160,1441,10344,3825,10519,5096,10644,10607,10325,10563,9521,9520,10555,9515,10551,10640,10797,10836,10828,10796,10545,10794,10795,10793,10791,9386,10522,10790,10829,8717,9191,10750,4302,4463,3890,8273,10846,8260,9192,11019,566,57,374,1664,6719,7437,858,857,397,1537,5910,376,382,379,6743,6144,4614,6751,388,6082,380,4302,379,391,376,377,382,385,390,3090,6742,3728,5371,381,386,6076,385,377,394,386,8168,387,376,8165,6750,393,384,375,388,6270,6066,372,379,390,3893,7199,6082,368,7238,409,6749,3036,365,8168,1557,392,389,8788,8785,8786,4639,8882,223,7923,4395,8878,2989,8787,6103,6746,7871,367,2117,8877,6493,3428,8881,7239,8982,5770,8983,6204,7175,8358,6785,6144,6538,8856,6386,4714,386,8789,8880,8858,8855,9192,378,7300,6491,8651,3889,3896,3883,3885,4302,7214,3888,979,810,1165,8824,8857,8358,6359,5386,5297,9149,7599,7808,1266,1411,1685,4289,6527,6521,4293,6218,3891,3890,4294,3895,6532,3892,7693,3894,3882,8271,3897,8272,3893,3881,3884,3888,3883,8274,8273,8981,8982,546,554,6537,8980,6381,3885,8879,2701,6377,9698,9713,9709,9708,9710,9711,1766,9718,9435,8241,8246,9593,9592,8310,9684,8598,8249,9427,8243,9425,8339,8242,8597,8245,8247,8248,8318,8317,9428,8319,9435,8319,9424,8320,9436,9426,8328,9591,4286,6199,9891,7238,546,6658,857,5742,5733,4716,4437,2041,3863,550,8220,6381,553,7539,529,7149,8440,532,539,323,313,397,860,6386,549,8542,5853,6769,526,7704,538,528,525,7704,5853,540,551,864,544,1730,545,531,543,391,535,541,387,536,382,1271,4769,376,524,377,365,376,374,6270,384,2856,8787,368,6066,6082,385,394,6197,8858,372,6076,317,3913,317,3913,6382,6523,8165,375,6526,8496,7588,8989,8530,8160,1380,3823,6854,6391,8159,8157,7300,7605,4701,8785,6144,9437,9435,8244,9438,8340,8699,8874,5770,8316,9146,9414,9409,8700,8245,9436,9425,9408,9184,8883,8329,8247,9182,9415,8332,8318,8324,8326,8319,8241,9592,9183,9428,8248,9431,9894,9150,9143,9534,9190,9908,10045,6768,9300,7632,9154,6396,4501,10056,9792,9891,9155,9156,9217,10202,9156,10198,9854,9217,9502,10193,9502,10193,10197,10195,9147,8333,8335,10099,10102,9151,8330,10218,10147,10333,10322,10323,10217,9412,10102,10336,10332,10334,10101,10331,10100,10324,10140,9433,10213,6151,1327,458,6616,3549,6103,464,3428,5334,3997,5882,6798,6840,6763,1663,6157,2998,3449,3069,6427,3389,6491,3898,452,222,4913,6600,6855,6388,2507,4765,3254,3169,6151,2684,6905,6129,464,4659,6181,2164,735,393,6894,379,6146,2737,1049,397,7195,7199,8656,9088,6523,3327,8387,6545,8305,6604,8592,6616,6719,6700,9151,9190,8097,6521,7400,9502,9647,9502,3893,3883,3882,8389,8389,8389,8389,3897,3883,9342,3949,10554,510,512,7374,545,8585,542,527,533,540,524,541,538,532,6042,529,536,537,9084,539,531,8586,548,547,554,550,3890,8824,549,3885,551,10640,10647,10639,3897,3891,3889,3892,527,531,9084,11203,11405,11583,11430,11209,9147,11207,11205,10487,6425,11429,8873,10214,11080,11206,11204,11081,391,8649,8872,11582,9184,8883,11564,11581,10216,6521,9113,11204,8696,11078,11079,9231,11406,9111,9112,10215,6424,8655,9588,11139,10152,10151,11076,11077,8665,9414,10158,10560,9587,9908,9119,11075) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC