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,7238,7083,7654,7094,2989,7124,4769,2677,5995,7670,7666,7594,7647,5647,446,2632,7122,3964,7114,7661,4406,7662,7081,4082,5602,7359,4936,7279,7272,4944,7648,7093,5853,7406,7443,7406,7472,7456,7070,7120,7648,7645,7652,3874,7298,7674,2635,8048,8047,6003,906,6691,7406,2795,7125,7895,7091,7906,7111,7967,7123,7090,1153,8080,7266,1084,4936,8712,1770,1767,4720,2627,6809,6718,3913,4146,1662,2520,7391,7391,7493,2122,3874,7501,8290,7077,2520,3874,4682,7120,7297,6261,5995,7967,4337,6364,4022,7012,6315,1215,1215,802,7266,7967,7252,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,7111,7090,7107,7076,7072,7096,7294,8083,7086,7118,7280,7967,7270,7270,7125,7262,7675,7262,7675,7106,8240,7266,8208,7152,7155,7120,7150,7105,7650,7650,7646,7646,7647,7647,7104,7118,7118,7291,7291,7246,7096,7270,7086,7080,7119,3874,7385,2179,1324,7108,7292,7292,7096,8050,7104,8061,7298,8060,7297,1366,7106,1366,7107,7122,6740,7238,8220,7124,8431,7607,7094,8470,7108,7077,7293,8443,7250,7655,7288,8033,7574,8444,9300,8469,8768,8395,7932,4801,7971,7674,7105,7082,8472,8740,8424,8568,8445,10056,7262,1145,6632,7580,6023,2677,7760,388,4563,7815,6986,2776,7599,272,6642,7605,637,7751,947,6871,6315,3803,7759,7972,7938,7354,4519,4558,7973,7837,1234,7834,7835,3189,5143,7836,5142,5251,8089,3066,8140,5936,8150,8111,5094,7920,4731,6713,8215,6691,8222,8193,5431,5536,8304,6810,7016,5817,1349,7005,2451,5947,4325,8390,7105,3026,8281,840,8358,6732,8547,7246,8514,320,6693,8305,3913,8548,1738,5763,6354,8816,6595,5334,8802,8213,6726,4652,665,8730,8839,6778,8910,4730,8885,7903,8629,8220,8932,4936,9049,3542,4944,1886,36,4945,4941,7126,4940,4943,1521,4942,3775,4460,4939,4938,3449,1176,9300,8478,5841,180,1177,2657,9466,4950,3080,1042,7772,510,7770,7771,511,512,7637,7592,7755,7756,7927,8509,9880,8999,7019,8222,8793,9195,9925,9552,177,178,179,10229,10292,10056,9461,10063,10227,9769,10528,10526,10548,10543,9406,10358,5756,6659,9533,9675,9879,10964,10836,9383,4834,9867,10232,10278,10938,254,9220,8904,11121,10626,9677,7928,8688,9196,8547,9636,11171,10397,10315,11219,6857,11439,11361,11324,11455,10748,9929,11397,10476,10149,10784,11396,7581,6117,9347,6731,9648,4536,2873,11374,6730,4329,6692,7650,7643,7643,7103,7103,7105,7105,7104,7099,7304,7662,7906,7663,8071,8113,8439,7666,7266,8167,8164,8206,6796,4716,6728,7661,7662,7286,8461,8363,7287,1250,8712,7096,8408,8425,6596,8386,7082,7109,7075,8412,8208,7294,8052,8767,8251,8721,8741,7647,7644,8891,8892,8950,8471,8832,8768,7290,7986,7125,7152,9148,3564,7107,8439,8406,6908,7280,7079,1983,8129,9620,9189,9141,7241,7088,8283,9076,8386,6961,9729,8365,9492,9730,9481,4029,9537,7124,7107,7103,2288,2288,6209,6209,6240,6240,6133,6133,5566,6836,5953,8111,7884,4752,6778,7713,7082,7716,8577,8406,8553,8408,8408,8644,8767,9458,7150,7499,7291,7975,7122,7154,7107,8033,8228,7247,7654,7100,7967,7155,6718,7298,7906,8205,7106,7103,7251,8361,8580,7297,8208,389,7270,8381,8425,5936,7674,7967,7294,7079,8203,8828,8407,9049,7096,9158,8047,7266,8207,8203,8413,9141,8980,8879,8981,8982,8983,8498,7704,9146,9882,9794,9892,6744,6749,6751,8410,6746,6386,9176,9762,8581,9177,10097,10098,9821,10189,10095,10078,9733,9088,6854,3894,3893,8784,387,392,6082,372,365,8530,8529,8201,6076,9217,4305,10161,5995,7913,10263,10213,8882,8788,8786,8451,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,7252,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,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,7252,11539,9398,9132,10624,11274,11278,11187,11395,10881,11614,11472,11867,11868,26,6768,2555,7258,7115,1988,6578,7551,1296,6984,1085,9469,9467,9784,3169,9633,9847,9524,9845,9494,8200,8365,9451,9843,9796,9846,8266,9995,9972,9665,9129,3071,9842,9350,9855,8203,314,9806,8228,7105,7104,7107,7103,6689,9854,9867,7155,9794,9580,9498,7070,9632,10238,10053,6242,9880,9622,9205,10176,7120,9563,10254,8450,10256,10095,4121,9134,8732,9621,1768,10232,9259,1616,9204,10077,7632,9539,8047,3358,10037,9933,7121,6898,6272,7111,3889,7125,5769,9529,6613,6582,8048,6579,7256,5051,8965,7119,9084,9578,8201,7152,7117,7116,8739,8053,993,9975,10510,10571,7895,9563,7675,10239,10544,10590,10612,10640,512,7087,10587,10659,10690,510,8824,10592,8770,9054,8644,9134,9563,9055,10586,8053,9055,9134,7088,7096,7086,8055,7106,7083,8034,7297,11212,11189,7243,8240,9622,11187,9746,11188,11196,7298,8499,9206,10588,9563,9620,8407,10272,10692,8438,8404,8208,10614,11150,8928,8236,10615,10689,10587,8410,9813,10869,7122,11108,8782,9609,9608,7668,7669,9611,10565,10328,10975,9610,7247,7672,11096,8573,9748,3893,543,528,538,8425,788,2023,7174,551,540,8404,532,6382,546,541,553,545,544,536,533,6493,542,531,6031,550,548,8212,8240,8529,7985,8771,547,391,2218,8832,2521,537,526,3881,3894,535,6204,6042,3889,7833,539,7816,8917,529,6788,2573,8274,8271,6650,6880,8273,8462,2521,546,2843,7815,529,542,3883,536,7075,7076,7666,4566,8839,7109,7118,8231,3908,7804,3829,9144,5732,9048,8716,9076,7175,573,3882,7647,540,526,7935,7150,7671,9132,3883,1557,2087,9744,9138,9794,9950,8365,8365,8365,7649,9875,10026,9797,7082,7599,7244,7278,7110,7091,7096,7079,7256,226,226,3402,7283,7967,7123,7298,1988,587,587,7114,7916,7083,7241,7241,7895,8064,7112,7254,7254,6127,7074,7093,7574,7069,7272,7665,8065,7674,7094,7266,8055,8753,8456,8201,8080,8050,8087,8385,8064,8769,8635,8736,8439,9560,9578,8407,6984,7671,9148,8363,8417,9314,9259,8767,6795,463,6315,5995,5020,409,5222,6571,1416,3303,6569,219,6678,1577,6141,7004,231,7209,4156,2605,3872,7081,7261,7290,321,4259,7255,7278,3888,1770,3172,1185,5208,8296,8222,7238,8514,3897,8757,1537,8469,7752,2006,7115,8651,7775,8709,7714,1569,7168,7166,389,7547,1993,8109,9614,8053,9134,9831,435,8048,10717,10717,9983,9983,10831,10831,6602,2951,10302,7646,2261,7646,2261,4432,10938,4432,10938,9879,10526,2261,8514,2261,8514,9132,9133,11509,9619,10947,9620,9620) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC