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,4769,5996,834,1537,3913,4437,4438,6602,4086,1270,1153,867,6967,5188,6969,1974,1153,5996,6947,5484,7022,906,5576,3698,1973,587,2635,6386,6646,3327,3890,382,382,388,388,3337,3337,3337,3337,1558,6388,6386,7702,3334,3334,3334,3334,3334,3334,380,6854,4614,8884,8788,8817,6386,8580,2749,4923,3531,2555,7918,5887,6394,7846,5567,223,5995,446,1298,1359,1359,7953,2342,2342,2342,3863,6445,3105,6667,1993,3865,2041,1357,6775,6631,3913,6820,7576,6122,8547,5602,8839,8590,1085,1086,1084,5994,7148,6483,8122,8976,8130,8659,6774,6733,2029,6547,223,6795,6562,6575,1016,7110,7125,7087,7086,7088,7117,7123,7101,7116,7124,7079,7153,7069,7121,7258,7249,7106,7276,7074,7096,6712,7252,7247,7253,7084,7278,7272,7291,7096,7247,7275,7091,933,3302,7840,7878,7241,8056,5305,8070,7879,7937,7254,3860,7279,8055,7147,7289,7245,3698,7238,6740,7943,7913,7238,7097,7572,4216,2399,7280,7263,7992,6559,8386,7270,3550,906,7932,3380,8670,6832,8471,8408,8087,714,8770,8053,8681,8736,7106,8698,8045,5098,6239,6819,1616,2024,3384,8063,8473,3385,4555,8439,9578,7654,8402,3368,6740,7304,3957,6586,4349,4762,7975,3351,24,2419,7019,223,7759,1653,6890,2117,6650,6861,1773,8010,1586,1774,3913,30,1774,7238,1774,7761,743,7872,743,1127,2118,3609,1127,7126,3609,4860,7126,2192,7547,7896,5327,2265,8809,6710,3429,3159,2265,7576,5536,6695,5536,6613,5536,6579,5536,8220,1772,9000,1298,6861,6282,3957,9030,7977,7615,1159,3376,3327,8900,5188,7830,36,8284,9081,6858,7929,6832,9346,9346,6171,8103,8193,7640,2554,8193,6809,9811,6591,7138,6809,444,8827,9338,4320,7718,6713,8628,261,8628,5046,10342,8358,6981,8305,8195,8521,10056,7839,8140,7839,7304,8140,7614,3698,8915,7156,8915,11331,8617,1416,9604,6775,9803,8620,9476,1250,8620,9476,11491,993,6806,1215,5995,1215,5995,8292,8292,6619,1609,6618,8196,6618,8196,7912,2005,7912,2005,8290,7266,8290,7266,1308,108,1308,108,6548,8828,9649,9086,7865,7864,8902,7858,8919,9270,7855,8808,2698,3844,2705,1915,6792,6635,3540,5636,9363,5210,8837,1812,6686,9353,5142,9638,9454,2261,8925,7016,3625,1520,3542,7614,1917,5623,7582,7138,7222,7156,9928,6661,9937,9913,9668,9780,9456,9266,1993,3860,7905,9340,10316,8014,9951,2158,2158,2158,2158,2158,6700,587,587,587,9667,9667,4769,7503,8816,9865,6367,8436,10339,3165,3327,10707,10325,3327,9946,10328,10330,275,10333,10331,10326,10327,8333,8332,8584,8585,8682,10565,9407,7870,9084,9920,11019,10565,10238,8584,7546,8585,7631,11218,8586,9151,7178,11203,6652,11204,4386,6654,11207,7182,11205,11206,11013,7187,11209,5635,11322,11146,9517,8321,11148,11138,11147,7184,8699,7185,9424,11016,8328,11422,8242,11421,9415,7189,9416,7176,9409,11418,11240,7179,8332,10336,8330,8597,9428,9427,8249,3327,7953,9863,1988,2635,7976,10172,10339,3863,9547,3334,4769,924,5380,9667,3327,5419,5322,10436,9976,10365,8559,272,6715,9857,6197,9633,9632,10232,10698,9857,9667,10731,4435,313,4769,8710,10831,9946,6602,8955,4923,10248,207,1993,3327,10211,3863,10310,10720,3957,9863,4742,9946,10314,10228,10871,8358,916,9771,3863,5806,5419,5385,10987,10687,9863,10976,10910,10985,11293,10816,10339,10916,3863,7385,10631,7456,10687,10687,11023,10687,3327,10844,9863,10687,9863,11380,10579,10211,9078,1296,10010,7194,5389,1993,9863,10707,4979,6740,6977,11214,10987,587,10682,11039,8563,10670,9863,3957,1044,11365,11257,8139,2056,2069,3327,9791,10687,10817,3702,11399,11215,11400,11298,8191,1296,10731,6367,9946,7048,11410,4769,7374,11497,1358,1359,11880,1983,3327,10339,11283,3863,3913,9951,10228,10228,10844,10844,6715,10670,10844,10670,10844,7592,7592,3327,9863,3327,9863,11410,3913,2035,8191,3954,10844,9300,11281,7388,9832,8306,51,4178,5995,10212,9300,4987,6740,7238,11489,9951,6822,10966,9418,10892,10984,11485,10932,6242,11285,11342,7976,11455,10141,11477,9950,11328,11101,10731,11215,10343,10278,947,1207,7641,9655,10505,9533,11289,10566,8169,11272,10687,4779,11226,6004,4574,8109,2342,11303,9389,10909,10339,11900,11363,8436,3913,10526,1993,10940,9865,10228,7849,6715,11885,11410,6300,7159,5098,1974,1726,4923,9856,1307,9488,10301,8650,8130,10316,8130,10316,226,4923,11101,11215,11101,11215,11497,10579,10731,10731,4769,10721,10687,11101,11323,11637,11263,7912,7380,2989,7874,10579,11744,11519,4769,9866,11497,11497) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC