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,7806,7842,9862,4130,4294,10668,10664,10677,10672,10706,10671,10679,10680,10324,7870,8700,9432,867,10323,5402,9920,10333,8828,7610,1770,6733,10565,9920,10326,6011,9735,10336,10139,10731,9067,9880,1768,11049,10328,5435,3327,7953,1988,2635,7976,10172,10339,3863,9787,4435,6291,10631,6367,10211,10211,4639,2986,7641,1973,10720,5435,3957,3327,10010,4742,9946,10314,10228,10871,8358,916,9771,3863,5435,5806,5419,5385,10987,10687,10976,10910,10985,11293,10816,10749,3702,10940,10940,11101,1770,1765,9078,1296,5435,10010,7194,5389,1993,8255,6953,5371,104,8869,6181,9135,9049,7774,4395,4146,10349,9543,2897,10228,9405,1770,9758,10339,788,10309,11010,120,10754,10985,9543,4659,9340,4568,1782,10000,9770,9714,9753,9701,4435,11298,10649,6548,11347,10892,2467,2989,11454,10780,11622,3327,11623,11227,9765,5269,11497,156,11621,10455,11752,11751,11101,11748,11325,713,10670,7374,10940,1823,9257,152,9704,1345,5024,12023,5435,10339,10916,3863,7385,10631,7456,10687,10687,11023,10687,3327,10844,10687,11380,10579,10211,5269,6104,9866,9865,10670,5839,4568,6276,6300,10707,4979,6740,6977,11214,5435,10987,587,10682,11039,8563,10670,3957,1044,11365,11257,8139,2056,2069,3327,9791,10687,10817,3702,11399,11215,11400,11298,8191,1296,10731,6367,9946,7048,11410,4769,7374,11497,1358,1359,11880,1983,9830,6952,6433,4985,51,9767,10107,9770,10054,3327,10904,10442,11101,9900,11442,10115,10892,11443,10687,11436,3863,3913,9951,10228,10228,10844,10844,6715,10670,10844,10670,10844,5435,7592,5435,7592,3327,3327,11410,3913,10292,10305,9350,10687,10940,10464,11383,11383,9889,10940,10039,10649,11410,11395,11412,10670,11399,11412,10670,11399,8139,10296,10840,8191,3890,7987,7808,11209,5297,8682,3896,11215,8255,11307,10646,9129,3358,8244,6688,11322,8897,10520,11049,7176,8874,11013,8618,11015,7632,11432,11414,11463,9865,10932,10984,11204,11147,10326,11205,5635,11418,9524,8963,9258,11400,11720,7903,11497,9865,8110,11433,10113,7752,8088,7881,8727,6688,10544,10679,11101,2253,11272,11289,3327,10865,10975,8946,10910,11373,7752,10114,11361,6103,4659,8088,892,10362,10670,6237,10228,6392,5806,2969,3838,11489,7159,11551,8586,10836,8256,9383,10687,11121,11325,11263,11101,4769,2009,2506,1967,11101,10106,11519,8388,11521,9843,8306,10687,10892,9603,8947,11714,6548,5567,11410,11366,10731,6548,11400,11373,7680,10386,6762,857,4435,4716,1993,10823,11519,8220,11214,3874) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC