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,5995,6167,455,734,463,3585,319,663,3850,4218,3184,3217,6364,5070,772,5765,5623,6599,3844,360,3521,3522,743,3520,6644,2033,5956,3519,3302,447,5839,4057,6947,1416,2390,1371,6641,601,2170,3557,567,6645,2628,7023,3264,1345,2602,944,2911,1257,780,6731,1257,4046,4536,7304,2873,4986,3465,7238,1379,6364,501,470,1098,6572,4510,744,6562,467,1474,2571,4796,1568,2331,2033,423,645,5454,2457,6574,6571,6576,4126,4019,5089,5112,261,5623,1487,6644,6767,322,466,6766,511,360,215,1160,1441,5143,2912,3590,6539,6544,444,652,955,1561,1834,6040,6542,1371,1070,2876,5719,6030,3302,1439,1645,525,550,601,933,1589,2390,1070,3264,5848,3557,3828,808,3302,5305,5552,2876,4218,529,3610,3392,4454,3048,3803,1928,1927,6950,6122,5915,6350,713,5256,6725,3754,663,1200,1313,358,6169,6162,2576,6588,6590,1000,1453,725,6159,4735,3216,6645,6168,510,1250,6160,4512,2997,2873,2170,4038,2723,2934,1444,2573,6772,3850,7238,6365,6350,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,6172,6159,8223,7240,6605,8093,8271,8226,8611,8555,3046,6135,8220,6766,1200,7882,3913,1245,2778,6804,3926,1770,1771,1085,1771,1070,1769,1767,5148,1561,6964,6110,1768,4426,6966,6961,4164,6471,4165,6504,511,510,2469,3216,1370,6383,6415,470,467,2605,3702,858,4788,1741,3771,2035,5821,344,1165,663,979,3989,1770,1765,2706,3830,3370,4943,6371,4423,6354,1600,744,1381,455,3761,2331,1232,2183,3610,3172,1474,3172,2615,3131,1185,1738,3217,7752,567,7748,663,7964,4218,5576,7779,2869,8000,1351,834,3541,2334,344,3250,5091,4701,2671,7604,2653,3136,3417,6413,4972,645,7033,7896,6940,3645,1098,1593,1407,4964,4984,1561,1460,3797,4008,4830,5218,8095,1070,5091,1738,8150,3889,6534,1257,2573,2183,7840,1345,3830,1126,6122,3302,8306,7757,6658,8613,7833,6506,6533,4218,6715,7903,7143,3216,8514,933,3557,947,5305,5848,3217,6562,7180,3889,6571,4796,6570,1181,6255,3989,1057,501,4901,7184,455,1349,3520,9032,4109,3850,8913,2360,7795,5148,8842,8183,5552,8912,7031,9130,6712,8230,1738,8274,8871,7635,8271,3073,8903,4355,6876,567,1461,3071,9354,6689,9273,9200,9039,9369,7752,7753,9365,8088,8627,9037,8948,8851,9353,8943,8944,7881,146,2473,7234,1038,4735,9371,6684,9614,9773,9772,9767,9900,9386,9525,145,9879,9814,9788,7917,7772,510,5362,9938,9936,2039,10053,9665,10001,2033,9986,5770,9987,9991,10141,9951,5484,9769,4510,8192,10188,5839,10002,8826,4945,4941,10257,9981,9982,10179,10292,311,6512,10208,10173,3883,9618,7299,9832,5454,7986,9812,10116,10368,10146,36,7699,10398,8541,9916,10314,10268,10303,10290,9888,10544,10534,8815,6971,10526,10540,8780,10474,10505,7985,10664,10048,9116,10535,3881,3890,10737,3897,10686,10736,3894,9946,10552,10542,9838,5134,7829,4520,8793,9117,9195,7634,9129,609,1586,4648,9000,7546,7734,8146,9541,9155,8528,8966,9451,9130,8950,9471,8434,9463,3437,9864,8839,9116,3302,9467,9933,1215,10129,8995,9987,446,1768,10141,9092,9340,675,10073,9942,5769,5551,10314,9831,9897,6362,10048,10047,9938,9834,8966,9710,8305,9451,933,8822,8684,10935,10549,5334,9129,7903,10283,7135,10892,8089,9086,9904) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC