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,6122,6189,3216,2776,734,233,1453,501,6001,2530,975,4947,3465,6562,6575,2915,446,2869,5882,5915,6168,6162,933,6712,6710,3850,1461,6365,6588,6365,6542,6540,1453,1351,6605,4109,3521,4834,5887,6899,1563,3522,6544,6813,6396,2035,6572,6573,650,6189,3216,435,344,5572,6645,228,1145,5839,6540,6122,6544,6257,1425,1210,5777,3825,501,2594,5459,3302,6350,933,4079,463,5305,7850,3428,6544,6971,501,766,4860,7240,4796,3217,4861,3264,2164,8390,2632,8306,3989,6167,4454,8781,6740,319,5995,608,1699,2294,3519,6542,808,6588,358,6189,5915,6122,2677,319,1425,3860,463,6168,344,2183,2876,3217,3264,3557,3828,6075,1586,661,7033,1318,1407,7117,7117,1110,447,1277,6852,2654,6643,5552,2576,1313,2685,463,3825,231,4982,3217,2876,3447,5735,2518,1277,7003,802,2698,6999,1915,5371,4219,6990,7051,2469,5631,2592,6562,2685,7222,7221,1822,943,6397,341,3778,1829,3181,6993,3843,4126,396,6122,2590,7304,3195,1568,308,1127,6590,1453,6104,1647,2299,6950,1432,7858,3447,7784,7865,7803,6998,7864,6853,836,6793,6001,6942,1313,2390,7991,1200,5339,6677,6350,231,1228,3610,6856,3657,7238,6365,6350,6660,4936,7878,6982,7795,7787,1200,7718,5915,2183,6983,3892,7592,7837,7546,6725,7143,1603,947,8095,7992,6589,933,3519,7869,7995,8096,7938,6159,8223,7240,6605,8093,8271,8226,8611,8555,3046,6135,8220,6766,1200,7882,7238,6740,7903,1609,6623,8225,4598,969,7143,1586,5371,6714,6971,788,1085,8759,8611,1084,1085,1086,8763,5495,842,8757,7841,5914,3913,226,217,6806,3169,6195,6003,2079,6715,4248,7905,2643,6618,1609,3402,1604,2555,6619,4918,226,1662,8389,8434,9422,8449,445,7961,6592,9547,8019,7912,6879,6000,9042,8178,7897,7846,1563,7846,9759,9889,4338,7921,9879,9754,179,4767,1506,6559,6663,6876,5088,1520,793,464,5907,6001,308,585,600,6162,6168,358,3892,5647,4969,228,7258,6813,7304,6766,6954,6812,4217,7160,1830,6794,7144,6780,6155,2328,2506,6695,2863,6831,6802,7838,3046,7783,4983,6767,2419,7602,2573,6160,7146,8020,4735,6159,725,3728,6811,8093,6588,7143,6605,6971,4570,6128,8096,8526,6726,8230,7822,8503,8836,7304,8611,8184,8512,7887,8109,6348,8852,8489,7897,8869,6104,8869,8032,7850,6809,8118,6845,8903,6104,9075,9116,4860,8630,9052,3725,7920,2023,8500,7839,585,8948,9366,4220,9354,2925,8933,9369,1490,8955,9541,8806,9069,7022,9543,6135,9453,3549,8543,8305,6117,9647,9648,4765,341,9200,4652,9345,9374,9348,1349,8934,9346,9939,9249,9248,8795,8915,8805,8935,9924,6821,8492,9922,4566,9941,9928,4566,8501,4128,9402,4061,8031,10057,10208,9910,9117,10063,7759,4056,3936,10227,3100,1698,7138,6683,145,6986,6635,6793,6684,9991,4131,10039,6679,9363,7761,9258,10341,6595,7354,10548,7019,10688,8222,8793,8222,9195,9552,9925,10245,9993,5236,9000,9027,9282,10762,9034,3595,10879,10938,10528,10955,768,10893,8829,9352,1127,233,228,11127,9749,9065,3964,4635,4656,5046,5193,7760,11021,9038,8629,11122,308,4023,10246,6314,6779,6169,6674,180,148,6639,180,3493,2261,11324,6686,8808,11324,9379,7147,8923,8781,8257,3059,10572,10535,8539,6792,10573,11213,9467,10906,6713,8769,11489,11377,7077,11220,7156,11361,11439,7077,11361,11439,9629,11018,7077,4537,2294,9055,9204,8048,4046,10915,11124,9639,2019,11353,11599,7661,1895,11287,3288,10719,7662,10623,11125,11521,9638,10623,9220,6713,10042,10623,10042,7125,11126,11724,2923,10895,7084,5368,11678,11760,8709,8368,11237,11692,11501,11693,11803,11867,11868,10630,10272,8056,11867,10689,10623,11502,11777,10624,11647,11210,10625,11349,3197,2156,8554,5962,7872,6810,8292,9394,9504,9525,4338,7023,7632,7815,9647,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) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC