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,5996,1537,6362,6362,6642,6159,4419,5897,5998,6003,6195,5956,6896,6587,6638,6102,1242,6173,1591,5912,2749,7046,6718,4971,6559,5215,3701,6294,993,550,1771,524,1586,3702,2522,6980,675,538,546,6042,528,3913,7123,537,5576,1296,6004,528,526,7250,7085,7086,1664,6306,2006,7977,5897,6740,553,7238,544,8220,7654,587,8102,182,7903,1807,7110,7932,8077,8544,8470,8615,8306,8528,8047,7268,7080,7660,6709,6766,6589,6548,6584,6811,2590,4146,6831,6366,1044,5883,6984,1462,5848,3302,7019,3702,6809,2753,7158,1516,6785,2328,6941,6001,5995,3550,2389,1029,6947,308,2932,4337,217,4639,4769,7101,3261,7548,5421,1351,6740,5576,834,3197,7022,7238,4109,1461,223,501,5454,308,6780,4701,7837,7903,7835,7775,7836,7761,7827,7938,2658,3549,5334,3698,7838,3647,8222,1662,7019,223,3346,358,3754,4535,7239,8390,2029,5763,8547,8611,2006,6365,3554,8358,8561,9300,9297,9880,5719,8828,8768,10008,5371,6190,358,6833,6162,2635,52,6312,801,3966,6794,6588,464,6644,6366,6135,6130,6168,6155,6177,6177,5881,2658,7238,7238,3262,2520,3550,6740,6349,7238,7238,8220,4597,6813,6725,7775,3395,714,714,6766,7783,7783,2029,8143,4801,4801,217,3337,3029,3327,6548,1215,2749,6004,7160,5996,2992,7304,1537,2473,7548,7205,3860,6740,7238,3860,7840,8220,6774,1366,1565,1782,7898,7391,714,714,714,6579,6579,6579,6579,4979,4979,6602,6602,6602,6602,6602,6561,9830,675,7304,3860,5371,6633,6740,4452,3702,6133,2761,7484,7484,7484,7484,7484,1537,1537,7386,1738,217,545,1520,1520,3609,7239,7239,7879,3754,8222,8222,4566,1954,3863,3863,3863,4969,4969,6377,8793,8793,8547,7897,7304,233,6977,6691,6584,3823,3702,3702,4683,4683,4684,4684,7903,7953,7953,8,4769,8542,7027,5691,8489,4405,7846,1604,8110,1967,9985,9031,5810,7089,5121,6766,6766,2027,5936,1664,3702,4769,7897,7897,7897,7897,2117,6870,7897,7898,7898,6880,3531,7890,8222,7238,1371,5995,5962,6103,6845,6104,7576,6691,6632,5763,2615,5142,6348,8150,8281,6809,3030,6984,6394,2635,5782,186,6210,8230,6726,6693,2467,8305,931,7970,7640,3647,396,3761,8744,975,1057,6396,1084,1086,1085,1604,5495,714,5495,2729,1609,987,7132,5185,6533,990,4346,7020,7636,6589,7636,6750,2018,7580,4563,7972,7973,6201,3380,6098,8098,8093,7273,8302,7639,2006,6445,3521,7105,8199,8047,7895,8413,8514,9055,9132,3647,9206,8475,3169,9195,4796,8224,9900,9935,9879,9630,9945,2736,10547,10026,1993,10765,7976,10881,8053,7152,9134,9204,11798,11609,10466,11410,3702,834,3029,6715,5995,1492,6631,3029,4834,4437,7635,7953,1296,2635,4438,7995,7840,5782,6844,1357,3863,5380,5567,5769,7641,4769,3823,2041,7879,567,6621,5784,1526,6658,8358,1371,7840,8690,7962,7953,1153,3913,4405,6366,6804,4639,4405,7897,7903,7776,5838,1270,8093,2006,7775,2302,5371,2029,8296,5912,8390,7840,7912,6365,6726,7058,4395,8109,5912,3561,3029,840,8109,7548,8390,4769,4769,7932,6103,1732,2005,8230,714,7300,6715,5717,7920,6783,6795,6569,3702,3702,6004,778,778,8628,5421,840,1126,8109,8935,5484,2932,2033,5770,501,4861,6004,4178,8913,8912,5070,9030,3850,4029,8933,6122,7928,7354,1461,9052,5070,8089,6740,7238,8220,3702,9879,9116,9939,4860,9939,217,9242,9896,10002,4178,9600,4406,10047,9983,9983,9983,9471,2261,2776,7374,8833,5647,6632,6632,7920,4209,4209,4046,7150,7150,7548,7160,8390,7160,8390,7160,8390,7160,8390,7160,8390,7160,8390,7160,8390,1371,3254,6646,4501,4769,4769,5380,7879,8456,8325,8325,7091,4218,4801,3883,3885,8387,9137,8651,1973,8899,6727,6667,520,1380,1779,7654,7155,7083,7083,8793,8544,8193,6381,7307,7124,323,7270,6004,6740,7238,8220,2041,6715,7976,7076,8738,6569,182,8541,8922,3647,2331,6700,659,9338,9612,186,5784,1970,9482,6715,6715,6715,6715,6715,5996,3888,8729,391,7548,3890,3885,1492,7160,6749,3889,7987,7986,1462,377,6076,8968,1462,8968,3890,372,6593,387,7576,6593,7576,6593,7576,7985,8271,314,8389,6174,6175,9030,1726,6493,8272,3891,3883,1726,3897,378,8878,8877,7576,392,7599,7576,4473,389,3894,3884,3881,2992,368,2145,376,6076,6361,915,6361,6066,1108,1167,546,8267,8788,8223,390,8223,3892,9537,9547,8789,5956,4979,5956,9536,9536,9266,9266,8858,365,6204,6593,365,6593,6750,8878,9616,6743,6751,8390,8981,8983,6750,9879,6746,8879,6746,8879,8980,7196,8167,9950,9692,8230,9692,8230,9525,7588,6745,6386,6745,6386,6743,9890,10167,6916,7610,6745,10263,9829,5516,7906,7572,1591,6102,3457,4769,8268,8202,8399,6264,8425,8200,5994,4362,7280,4218,7897,358,7548,2399,6819,5380,4320,4320,7597,1371,156,8223,7281,7655,458,8947,461,4900,9292,5784,6578,7204,1380,8580,8404,9584,9582,9583,9585,8255,8255,9650,2913,2253,455,7114,7547,8614,1492,7664,9737,7953,7976,9951,9865,9889,9889,9889,9342,10235,1380,8963,6367,8292,207,10248,10438,2182,7528,8544,3702,10203,11053,9078,8781,7640,9603,9951,5810,8489,10466,10032,10305,8292,8659,10436,9467,10515,10542,5769,8690,10649,10742,10342,9950,6392,6276,4563,10704,10909,10676,10687,7804,9857,9513,9006,10539,2157,5000,9062,9803,6239,3609,6237,10539,10566,6291,8256,1993,5175,10764,10802,9325,11645,2389,11772,10892,7937,10349,11644,3493,11219,11455,10798,11646,1520,1296,9305,9993,10229,10548,958,11353,10719,3401,8690,10346,7205,10150,3702,6102,964,6561) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC