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,7883,7647,2989,1521,1954,2164,1559,4050,4082,3625,2160,2976,4218,5247,2932,2706,7835,7837,3142,3244,1163,405,8030,1718,1738,8182,8146,3479,4983,7654,5763,8150,8103,7761,1038,5732,1569,4452,7158,504,8222,8378,8371,396,1350,1521,4082,6069,1906,975,1826,8089,8281,2381,2329,1907,8290,4834,4131,3003,8142,739,3288,2985,4710,6880,8547,6255,6855,2164,971,8721,8628,8629,4005,1920,1954,8492,1830,3744,768,322,4217,1134,2863,4325,2054,741,8763,5373,7594,252,2989,8890,8851,3625,4109,3715,2337,8901,5839,8089,8904,8936,8925,3195,6707,8134,8932,2934,2294,8933,1052,9009,9086,8871,5997,7981,4624,2946,9196,4767,1190,3026,2054,4240,9197,9249,8978,8795,8805,9220,8087,7121,8045,971,9135,9373,9366,9335,4136,8919,7138,5460,9466,9478,9322,9455,8914,9539,9557,9578,9471,9464,4800,9353,9547,9607,9200,9332,9543,9654,7213,9333,9637,9680,9799,9798,9764,9769,3849,7640,9910,9904,9913,9914,162,9766,2160,6117,271,4886,6981,4901,4730,5245,7837,1645,4767,423,7834,7836,7919,7903,6205,7835,7821,7143,7833,7761,6478,1461,1325,1970,6595,1433,8222,2992,2029,4160,7760,7760,5542,3080,7130,7130,8812,8813,7852,3169,8250,6397,3913,6876,8098,8098,9222,9223,9224,9250,1536,9300,9017,61,9275,6870,6870,4346,9243,5286,5286,5997,9073,9614,9366,9552,9769,324,9478,9641,9118,2660,8610,8184,5252,9925,9925,9921,4510,10088,10087,10090,10089,10056,10086,10210,10079,2137,2137,3936,3525,10227,10229,9624,8705,9766,9968,9959,5763,10375,10212,7149,4178,4178,10608,8441,10523,9376,6103,9297,10434,7972,10548,7973,10382,7585,10397,6264,10711,10056,10315,7218,10748,10702,5567,7889,10870,10127,10749,10127,10350,11093,9255,11324,11455,11396,3059,4739,11105,11457,11489,10754,11517,11302,10012,11130,11741,8812,958,4741,11789,9777,4987,9766,1767,7631,6354,6220,1768,1766,1771,1765,1770,6688,9920,1769,10176,10098,3073,10175,3071,8583,9880,4714,6689,9679,3070,1266,8727,2506,272,6198,5810,9824,7881,7752,10053,9665,8899,8897,10067,8896,6200,9867,9031,8489,6215,8668,1766,4842,4286,6218,4297,6216,2794,2791,6497,2789,3071,6880,675,2786,2785,2787,3465,2783,2781,2779,2780,2782,6443,7868,4304,4293,10258,2778,979,7311,10238,9473,10251,9669,4224,2951,1970,6679,10188,3385,6002,8233,9073,9243,9478,545,8714,9383,9476,529,40,10055,3358,10294,9483,5207,1690,7185,7184,8815,4223,9632,3525,1369,138,7178,7179,7632,7189,4386,7176,9921,9637,1137,7187,6198,6362,1325,10258,10398,6382,10608,3875,7837,7834,9376,10607,7835,4931,3254,10552,7836,9297,10467,10536,1557,10568,10232,4,510,9474,7771,7770,6688,511,512,7637,9626,867,9067,9625,9670,9671,10612,8729,9475,8881,8161,10364,9624,10626,8882,8878,10642,10647,10639,10643,9880,9625,8880,10644,7569,7762,4804,7567,7570,7764,10298,9493,7698,10641,8016,10640,9906,9907,9970,10043,10253,10255,10256,10637,10646,10254,10752,10531,7300,10645,3165,10521,10753,10548,2261,6855,222,10522,1520,1917,3059,1461,3595,3493,145,8306,4178,5995,10212,11105,6710,7019,6876,7761,11032,8222,8793,11031,9195,9552,9925,10229,11106,9661,10397,10315,8965,9675,9655,3874,4923,4146,3409,7172,3511,10749,10938,9993,10544,11033,7753,8627,11109,8088,8946,8945,10927,8944,8668,6263,10975,11121,10641,3236,9933,7810,8110,10239,10821,10822,10931,10930,10840,10639,10637,5066,8943,10748,10926,10928,10797,4923,11255,11252,11254,11251,7592,7554,7754,7755,7756,7927,10564,8509,11246,6740,40,6683,145,9635,5,173,8978,10207,11217,11240,9363,6639,4023,6732,2843,5431,8220,9300,7238,7912,11325,7849,10056,10836,1368,28,6598,10637,848,7580,1769,1766,1768,145,8175,1765,10893,1983,7304,11101,11395,9072,11397,3327,11398,11401,9543,11382,30,152,801,9,11383,1230,9352,8389,11381,11328,11431,11421,11171,10057,7356,6773,11396,6792,10687,4510,4752,1973,10788,11442,5363,122,10827,6359,1411,9466,11479,11473,11476,11359,10829,11478,11480,11468,10278,3014,6727,5513,11177,11477,6692,11416,10520,9149,8154,8002,11067,11071,9322,11517,11181,11550,8904,9677,11342,9378,10350,8688,11598,11552,4329,11175,947,4103,8585,4730,6315,1690,9376,9376,9137,5454,8520,5763,7099,979,8583,7808,9407,9638,9634,8584,8824,7631,9493,9591,9590,9084,7546,6201,9588,9587,9149,9593,8596,9535,8325,9665,9589,9430,8782,9429,8324,9637,5321,8323,9867,9725,8358,9920,8583,9407,9084,8585,7546,3898,8682,3898,10053,7870,9921,1038,3542,1521,10055,4136,6824,9811,5995,10232,10090,10087,2160,10080,10238,7016,10182,10112,4624,585,2025,3288,3904,10342,10523,10479,3159,5692,10548,9808,5743,9471,10048,10212,1770,1765,10212,9942,1767,10719,1769,6354,3070,3073,3071,6689,7753,7752,10674,9212,8088,8627,9037,9665,10053,10544,6688,10975,8943,10894,11142,9798,11221,5799,107,4082,11423,11020,8943,10672,11288,11310,10673,11550,6354,11644,11748,11670,10892) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC