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,8267,6743,3036,6937,6933,6931,857,6545,8984,2594,2005,2005,858,6922,6934,6935,6938,6744,2276,6912,2275,7134,8725,2274,9111,9891,8881,9190,8340,8882,990,6757,6936,6758,6746,6426,10328,10329,9149,6422,6523,6381,9386,524,10098,10961,2331,9300,7715,801,7654,8082,7110,3913,9897,8947,1973,7397,9019,1993,2992,8781,3830,8933,3830,8933,5810,5446,9669,9670,9304,397,138,7869,7869,5810,9320,5770,5770,2029,2029,2029,2029,2029,3913,8970,3598,8613,3823,1988,1988,7861,6103,675,6831,3409,5947,169,6740,7238,8220,8220,7913,7913,8733,1380,8516,8516,8563,9338,9784,7874,9762,9846,8302,9322,435,4784,6174,9951,4788,4788,1207,8885,5251,6752,9049,1425,8171,1198,10235,8171,1533,6691,2467,6691,2447,7396,2294,1253,5817,5545,5817,1347,4258,7883,608,1699,7126,7920,8999,9937,7849,10065,10292,5339,10065,5295,6691,6691,8171,10568,8111,6691,10296,10211,10671,1296,10664,7591,9812,2294,1253,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,7472,9030,578,547,2847,3337,1777,7178,8438,4500,4500,9076,9778,9494,9494,9791,9745,9858,8575,8575,6648,9879,6583,6583,8434,8434,9547,9547,10638,6579,8063,8833,10731,8428,9853,9785,6400,10695,4500,1783,7725,7019,8222,7761,8845,4109,9195,1662,4796,7837,7834,7835,7836,8441,9297,9552,7003,8851,9614,9300,9030,9960,9925,7641,8617,9548,9879,9897,10056,9525,9463,8296,3989,7634,6726,6849,6971,9890,2164,8281,10526,9085,10265,8948,186,2632,10836,10302,10471,8962,8726,10549,2261,10480,8816,10531,1461,11121,10464,1645,11128,11230,9951,9000,11325,7909,11304,176,9814,8995,10064,8109,6712,650,8512,3849,10656,6571,11089,10636,11494,10040,11644,9993,11741,11219,10938,11324,11455,10548,3595,9993,6876,8388,11457,9634,11302,6894,8953,3493,8903,1917,180,233,7953,10032,10649,10825,10731,10819,8781,10697,6366,9386,8095,754,10698,10987,6658,10940,10579,10296,10305,4401,9348,6723,7159,5098,1974,1726,4923,9856,1307,10301,8650,8130,10316,8130,10316,226,4923,11101,11215,11101,11215,11497,10579,5435,10731,5435,10731,11308,8860,6438,11329,11410,6275,385,7976,11329,7910,11497,10937,10687,11410,9393,9300,10579,11101,2749,5567,450,11497,10228,3863,9865,10836,10477,173,11306,9359,10669,9849,5769,10339,11710,1769,6197,10330,6198,11221,6354,10822,10975,10981,8627,6689,7752,11242,10522,6199,10327,6201,6197,8856,3073,9412,11240,5297,11137,11138,11149,11204,11301,11587,10232,8585,8584,4293,10828,10836,11690,7610,6834,10232,9867,9522,10292,8764,11930,4724,11325,11121,7374,11354,11356) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC