thisMySQL 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,7837,6210,6139,271,7928,7835,8441,1886,8435,1385,1385,1385,8367,8434,8542,8542,8389,8766,8767,8767,8064,2555,3402,8761,508,842,2302,9349,4720,9072,6003,3865,8298,5717,5742,5742,1462,7307,7083,6549,6549,408,3891,7238,7238,7976,6740,7304,7094,6004,6004,8529,6390,8402,8410,8479,8686,8435,7897,6658,8302,7995,7995,8613,8613,358,2005,8868,8868,2342,2342,8290,8435,5763,8683,8683,6408,1242,4227,7388,7483,3957,947,6740,7238,1591,6264,6131,714,7209,1624,7219,4362,2677,6261,5251,7922,7539,3704,6658,6004,7576,7872,6003,6104,6691,4990,1738,8196,8143,4983,8745,3159,223,8515,8223,6631,8547,5339,6700,8613,4435,8255,6801,8544,6316,6631,4979,6715,5568,8217,3598,915,7912,5681,6733,7711,6774,8544,993,6806,1215,5995,1215,5995,5435,5435,6619,1609,6618,8196,6618,8196,7912,2005,7912,2005,8290,7266,8290,7266,1308,108,1308,108,3197,2156,8554,5962,7872,6810,9394,9504,9525,4338,7023,7632,7815,9647,6172,9379,9732,8389,1307,7966,18,9046,2384,2889,41,9897,9758,6725,8110,9864,9814,8995,8714,9754,9532,9468,9467,9506,7222,10174,10085,123,10173,10143,10035,2171,10040,8434,10054,9972,8112,8780,8816,1993,6367,8520,6548,6715,924,8388,5717,2399,4769,6621,104,1142,240,8970,6700,6631,9215,840,6006,9229,5484,1591,6264,2644,7144,8821,5052,7871,6774,5371,217,9390,8833,9281,3327,5770,2253,8515,7838,2029,9468,9027,9322,2117,1371,6131,9162,9513,2006,7861,4435,9538,2005,2085,1052,4395,7923,7976,1242,2989,9480,7992,6642,9524,9479,6103,6004,906,9603,3428,9629,317,754,9306,6691,4079,8685,8815,8814,8826,7576,9704,3598,156,1153,9678,8659,9559,9546,9760,1912,3236,6905,4913,7599,9390,9480,4154,9754,6102,2342,8508,2467,6176,9763,9770,9783,120,6977,9782,6602,9014,7640,9344,4563,6652,9762,6623,8352,9812,2843,9830,8685,6841,8544,9006,9879,9865,9866,207,9872,9918,4216,5419,9926,6819,4320,4900,9392,6402,7104,7975,8064,7290,7290,8639,8791,8568,8568,1151,778,9284,9284,6616,8941,8942,2122,207,8497,8497,9476,9476,6613,3070,6615,10281,10281,6733,6550,6579,11364,2913,2913,3172,1232,9784,915,2615,5484,9014,3646,10085,10093,6740,8542,7238,9614,8220,9482,9547,6402,7928,7903,2374,7775,7833,7910,223,9078,8781,7640,9603,9951,5810,8489,10466,10032,10305,8659,10436,9467,10515,10542,5769,6843,8690,10649,10742,6843,7976,9951,9865,9889,9889,9889,9342,10235,1380,8963,6367,207,10248,10438,380,376,9830,1685,2605,8824,378,9192,9190,10098,9191,9156,385,810,10828,10546,9149,6082,6272,9846,10036,6272,57,10279,923,3823,3385,10279,1616,3712,5063,10176,2342,10218,10379,6215,10438,9394,6538,6656,1296,9342,6373,10305,6512,10369,10631,10687,8710,7916,10436,4842,10676,8565,4227,7216,8115,6593,10678,10775,10703,9865,3954,10676,8191,6801,10678,10932,6804,10809,8524,10874,6728,10932,10984,10402,10987,10676,10984,8565,3823,10676,1296,6503,1979,11323,2005,8565,2342,5145,11444,11399,9762,653,10604,4805,7042,11085,778,10336,3511,11216,11568,10107,8860,3913,7541,9049,7217,7217,11215,11215,11168,11168,10810,10810,10940,9865,8358,11438,2913,7385,11261,10987,10731,7159,11497,2913,11105,11289,9494,11284,5193,11399,11311,11636,7917,11074,11099,10669,11444) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC