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,7105,7076,7096,7083,7105,7243,7241,7253,7254,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,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,5435,6819,1616,2024,3384,8063,8473,3385,4555,8439,9578,7654,8402,7243,249,7119,7265,7273,7089,7085,7271,7077,7655,7661,7662,3561,5995,5719,8537,7246,7286,7086,7115,7647,7297,7297,7297,7297,7253,4752,7644,7643,8080,8080,8080,7104,7124,7648,8081,7261,7088,7088,7088,7658,7286,7975,8041,8041,8574,8713,7078,7120,7261,7150,7077,7109,7655,7099,7155,8832,7295,7661,7662,8771,8771,7111,7646,7904,7674,3169,8063,7992,5719,3754,7265,8213,4079,2052,4152,8208,8193,8290,8206,8434,7903,6178,4395,7272,7278,8229,7976,8206,8393,7097,1142,3702,2521,8220,7272,8918,5956,6583,2635,6565,6678,6576,6569,6568,6564,6574,8033,7094,7998,7096,7100,7082,3830,5148,186,1662,7840,7840,7879,7878,7160,8095,8095,6740,7238,7238,8094,8220,7649,1537,1537,8109,8903,6726,6971,8816,8230,2374,9030,9321,7278,7278,3893,7100,7155,8362,7261,7096,7079,7654,7654,3895,2992,3895,3888,6588,3384,4901,8512,6726,7070,7070,6578,6658,8389,8412,8412,2635,2635,2635,2635,2635,4683,7906,8283,5782,7079,7079,3874,4682,7120,7297,7642,6261,5995,7967,4337,6364,4022,7012,6315,1215,1215,802,7266,7967,231,7075,7246,1257,7666,3860,5996,6714,7473,7096,446,8412,7270,6728,3341,7967,7083,7270,7075,7151,8741,3760,8409,8395,8064,8407,8820,7120,7294,7298,3337,6584,7110,7072,7074,7251,8400,8236,3896,3892,3891,8576,7083,7107,7674,6386,7100,8365,4121,4121,7155,8085,8236,7118,8228,7291,7700,6768,8240,7674,7110,7272,8236,8228,8451,7106,8644,7112,7078,7654,7253,8420,7105,8236,7155,6270,8203,7070,6396,7253,7254,7083,8580,6750,6381,8771,8832,3604,6076,7032,8665,397,1385,857,8361,858,6823,3510,7070,7078,7283,6386,7906,8157,3860,7068,8397,2992,8415,1537,7304,2951,7897,7100,8743,7939,7088,5996,8080,8422,7644,7830,5647,7588,252,2736,1533,1210,1210,466,8454,464,8287,8909,8585,9084,8682,7912,4834,4986,3165,8665,4405,801,8816,8815,7024,4834,5995,7304,446,446,8520,4259,5419,8220,7635,9209,8142,8512,840,924,7147,7110,8211,5996,2992,2992,1537,5188,7155,8080,7069,7279,8199,8198,7655,7674,7288,8743,8063,8063,7113,7572,7286,8737,7080,8741,8742,8742,8742,8742,8742,8742,8415,6569,7283,7970,254,1049,1049,2946,2946,1051,6880,1050,1050,6003,7012,6402,8547,8547,7261,6388,6416,8203,8203,8201,8201,7243,7074,7092,6190,7280,7269,1242,7122,7113,7574,7091,7118,7109,8087,8909,7085,7572,7095,7666,8401,7241,8213,8080,7245,7281,7246,8384,7654,8452,8909,7251,8362,8208,7713,7243,8772,8736,8736,9133,7714,8782,9132,9622,9747,8395,9620,9621,8768,9610,9058,9059,8419,8087,8085,9611,7280,9205,7275,8240,8081,9458,9748,9876,9875,10029,10077,10030,10075,9525,8064,7083,7840,7878,7879,7104,7715,7099,7082,6110,7096,7278,7249,7107,8065,7110,8049,7094,5770,8070,7960,2635,6544,8452,8384,8381,8393,7931,7895,8406,6131,7105,7654,7247,8407,7112,8349,7124,8041,7266,7106,7261,7717,8084,7246,7100,8461,8464,6968,8409,8407,7670,8408,8644,8641,8394,7277,8396,7153,8083,7266,8203,7251,7112,9053,7286,7666,8406,7258,8430,8404,8782,8473,8072,1343,2658,8683,9247,7082,8470,8644,8047,7085,9259,8034,8460,9225,8398,8462,7095,9205,8832,8431,7943,7115,8475,7084,8395,8082,9573,9578,9579,7253,7272,8033,8473,8370,7589,8635,9204,7147,7655,7123,8066,7093,7076,7254,7280,5947,2934,5719,7708,8909,8053,10659,10586,8407,10675,10690,9386,11124,10573,10859,1990,10773,8781,7288,7250,7674,8354,7286,8282,8381,7112,8087,8430,8783,7295,8411,7574,7249,8080,7659,7096,7155,8377,8033,8059,8366,8058,7100,8203,8454,7278,8453,7663,7906,8287,7253,7151,7113,8361,8771,7082,8040,8082,7281,8429,7277,8409,8036,7110,7154,8044,7105,7150,8373,7115,3908,9621,9896,7642,7123,8212,9898,7259,9620,9957,9954,4121,9954,9619,9997,9501,6824,10011,10017,368,3784,10013,11394,368,3784,11391,11335,5066,11390,11277,11211,9959,10016,9965,11059,11187,11331,11210,11392,10855,11262,11196,11458,9956,10625,11534,9955,11225,10906,10585,11212,11654,11674,9502,6520,9579,11668,11553,11539,9398,9132,10624,11274,11278,11187,11395,10881,11614,11472,11867,11868,11469,11958,11911,7261,11514,11818,7095,7572,7118,7108,3860,7967,6832,6832,7213,7897,7897,5996,5996,7661,7661,6523,389,5165,2992,8268,1537,7104,8055,7263,7602,8033,7258,8087,8087,6388,7082,7076,7079,7705,6521,6212,6223,7698,9781,9591,9592,6656,7844,9312,9590,6220,6497,6498,6222,6496,6216,6501,6215,6218,6221,6214,6499,1770,1765,1771,1767,1769,314,6701,6445,6176,7082,7291,7647,7253,8407,2989,8547,7149,4659,7115,7654,8306,8092,7253,2117,9701,4563,2658,6264,9538,2761,2467,7940,5912,4399,8629,7946,4566,5193,5236,4656,6986,1327,8031,4061,4405,6560,6559,778,10060,9751,9758,9221,9750,7106,8395,10211,10233,7254,1349,10227,10237,9257,8391,10244,10236,9132,1521,8089,9353,7017,10245,10226,10315,9935,773,8777,10359,2261,10541,10550,10587,10567,10588,10586,2079,10666,7121,10524,7716,9870,10743,10807,9831,8211,7932,10820,10239,3542,5763,3715,7895,10976,7125,11021,11025,9259,7125,10977,7087,10904,9900,10749,8047,10899,223,7265,10747,11126,10765,6845,11115,8030,6104,6870,11122,8741,2294,1253,5545,5339,1347,5817,3080,4258,7883,4460,608,2933,6858,7126,10246,10869,1699,1830,8500,8668,8206,4395,7920,7839,10350,10692,6832,10690,7280,11679,9206,10659,11540,9959,11558,11785,7792,11402,11496,7778,9889,10949,10366,10585,11528,8891,10702,11704,8477,10027,10863,10212,8516,8892,8610,11918,11573,9204,10591,9055,9578,9999,9030,9132,8782,9793,9539,10074,7253,7254,7251,7072,3897,3893,3883,7270,3885,3884,3895,7655,3882,3888,7094,7123,6740,3896,7987,7903,7088,8063,1770,1765,1771,1767,1769,1766,2183,4936,4944,4945,4941,4940,4943,4942,4939,4938,6644,6644,8081,539,8080,8384,8478,8288,7840,529,6493,7879,3894,7672,8273,7903,7019,7663,4801,8361,8306,4801,8306,8358,6971,2876,3828,8343,8602,8601,7293,6075,8547,3264,8389,7080,1126,7985,4454,3557,8526,6645,528,545,7079,531,544,1461,553,8401,8793,546,524,4512,4046,344,215,8425,4316,4046,4316,4316,4046,5298,3913,6710,7253,7254,233,6809,8401,8425,7089,8438,8213,8909,8213,8909,8213,8909,9055,9794,9741,9054,6104,9726,9358,9829,9880,9361,3511,3510,3511,3510,3511,3510,9608,9594,5576,9610,2869,9611,834,8229,9609,8832,3510,2473,2530,7283,7261,5454,5454,5454,5454,8366,8366,8081,8460,7287,7250,10833,8446,10624,10625,7155,7649,10941,8208,10942,8580,9564,11225,11210,7287,7280,7714,3241,1770,4519,9386,1765,9554,2033,9953,4019,90,4019,4121,9220,10094,4121,9638,10822,10416,10787,9132,10699,9133,10042,10787,9619,11121,9620,9621,9622,10915,10088,4037,11126,10087,10715,3904,10090,5373,8080,7264,7262,7262,6113,5175,665,6141,1533,1073,4199,1051,6158,2913,1050,186,2530,5576,6633,435,3904,6001,1145,2182,2261,176,4154,6962,446,1370,466,2490,5421,3989,1272,1770,1126,7607,6785,6845,1038,6986,6158,8358,8547,431,7265,7661,8947,6130,8047,8034,4068,5142,7605,9558,9652,7143,9959,10060,1769,970,9053,7164,4464,8282,3872,134,10238,2736,9378,10531,9920,9264,7607,7913,2467,8714,8876,9607,9824,8828,11201,7655,7674,10315,7661,6119,9608,11363,11713,11117,11631,11632,11674,11312,10506,11683,8517,11108,130,10942,11514,3327,11733,3885,11955) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC