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,6569,1738,5994,8281,6538,6444,4834,7083,4860,7112,7083,6569,9231,9200,9231,947,6713,4765,9378,435,5251,7610,5691,923,2725,1425,2677,9747,9056,7114,9133,7243,9533,956,9900,8770,2635,10131,10247,7125,10039,10587,10591,6000,385,7067,7067,3840,375,380,8880,8787,8881,8771,8771,8939,8882,8832,8832,381,374,8878,6270,6066,393,390,389,381,8877,8878,379,372,372,7294,2780,7072,7261,7286,7122,7068,7094,7108,7107,7104,7283,7266,7081,7121,7154,7119,8240,8228,7946,8349,8207,8406,8396,7967,7279,7715,8790,7106,7278,8360,8439,8423,8423,7599,8404,7658,6382,7946,547,8371,8459,7070,1769,1967,8208,8362,8380,8463,8832,7076,3883,8050,7665,8201,7932,8394,4769,8362,7261,7646,8266,8450,7124,8048,7671,7572,7075,7103,7152,8529,7654,8771,7243,8365,7115,7155,7110,8364,7125,7083,7715,7765,7243,8082,9132,9148,8240,7291,7251,7665,8469,7107,7647,6794,9032,9205,7646,9047,9189,8446,8580,9259,4973,7671,8768,8769,7247,7249,9134,8423,8852,9315,8439,8443,8083,7094,8060,7275,7666,8451,8034,7674,8770,8358,2643,7109,7268,9161,7104,8447,9314,7150,9537,7647,9133,9133,9573,9577,9619,9748,9622,9621,9747,9620,9560,9580,9746,9745,9876,9878,8085,9876,9877,9956,9138,7291,9744,9873,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,7175,573,3882,7647,540,526,7935,7150,7671,9132,3883,1557,2087,9744,9138,7642,7642,9794,9950,8365,8365,8365,7649,9875,10026,9797,7082,7599,6845,545,7572,7100,9437,9931,186,7662,7906,7663,8071,8113,8439,7666,7266,8167,8164,8206,6796,4716,6728,7661,7642,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,8386,6961,9729,8365,9492,9730,9481,4029,9537,7124,7107,5996,526,2056,391,7270,3860,4199,3896,1458,7300,6768,7300,6962,7286,4544,4860,7899,545,550,548,539,4684,3554,3554,1398,7175,7032,1662,549,6477,525,2706,778,551,864,1366,8356,8530,546,8880,979,6394,6842,8212,7472,9030,578,547,2847,3337,1777,7178,8438,4500,4500,9778,9494,9494,9791,9745,9858,8575,8575,6648,9488,9879,6583,6583,8434,8434,9547,9547,10638,6579,8063,8833,10731,8428,9853,9785,6400,10695,4500,1783,7266,7294,7253,4558,7152,7091,6962,7125,7095,7276,7707,3090,7123,7805,7665,7093,7296,7096,7671,7278,7271,7115,8048,8033,7280,7272,8412,8477,8645,8473,8709,7941,788,7291,7291,7124,8852,7083,7092,7106,8405,7103,8064,8393,8398,8466,8354,8349,7068,7666,1558,8475,1667,9201,7244,8465,7088,7093,7099,6969,3926,8093,7109,3090,3926,6984,9574,9573,8208,8576,7666,8577,8412,8475,9148,7346,9745,9314,9583,6719,8468,1990,9873,9470,9818,8644,9207,8410,9973,9956,7574,9055,9577,8574,8439,9956,9583,9583,9583,1609,1609,4570,7975,3247,3247,6766,9879,6726,6971,10198,9890,8109,10471,10474,8903,10526,10202,10604,9741,9995,9815,375,553,535,6042,538,8832,3881,540,3883,3891,7262,7262,7589,7589,7154,7154,7589,7589,5895,7765,7297,7765,8742,8742,8742,8206,7154,7070,7070,7297,7297,7297,8712,10272,8063,9083,8580,7268,8459,10400,9560,9564,8469,10614,11034,7655,9157,7297,8908,7297,8272,3883,10167,6742,6744,6751,6745,8982,8983,6749,6750,8879,8980,8981,6746,10045,10222,6386,6743,6914,1662,554,10272,9189,390,9518,9520,9517,9521,9522,8985,9515,10429,6854,7703,8986,8987,10427,10647,9144,10729,10763,10532,10763,10126,9580,10532,7238,9192,9191,9217,9231,9143,10957,9144,1016,1016,9797,8407,2520,8236,10615,10941,11063,10400,10906,8409,10686,11692,11693,11918,7933,6216,8041,8034,10264,8867,8047,8048,10008,9719,9853,389,8476,10185,10404,10510,8400,10604,10597,10601,10596,9794,8419,9059,9082,9662,8404,10011,10029,9247,10767,7282,8227,8472,8471,8475,9367,7304,6967,6376,7143,7023,3380,539,7904,7270,6349,4079,7249,7247,8400,8201,8198,8199,8201,377,6066,8576,8568,2635,2635,553,544,1462,1462,7680,6763,3449,5718,5718,6381,9189,8082,8443,8253,9312,7090,7090,7278,9300,9864,8995,7266,10056,9573,7585,7585,9304,9560,9560,9577,9577,8542,8542,8542,10265,8168,6925,8986,10026,8782,10572,10272,4080,9148,9561,10836,8451,9949,381,7124,7124,7095,8782,9619,9189,8083,9581,9138,9874,8782,7275,7647,7103,8240,10600,10600,10598,10601,10596,9067,10612,6840,11091,8168,11069,11080,11075,11079,11076,11078,545,549,11085,548,11077,9189,9794,4989,4997,970,2137,11095,8782,8771,6740,9052,8940,7175,11948,7599,10881,8771,4282,7671,7281,7311,9189,11050,7076,8477,1766,7082,8474,10890,10545,7289,11375,10862,11224,11317,10271,11225,10922,9401,9314,9563,10275,11319,10923,10924,10675,10639,5065,11470,10026,10642,10641,10640,9999,7605,10185,9539,7599,10637,10869,11252,11251,9134,7266,11177,7299,7270,5535,11511,11513,10321,4512,9189,7986,730,9578,1768,5003,9259,1766,9138,9608,8668,5454,7247,1766,11602,8782,9892,9149,6596,11150,3359,8205,8582,10858,7283,3895,8366,10947,8782,10948,4390,186,6768,1411,7024,7280,535,3896,3887,810,10944,9885,9601,8204,3894,1303,10829,3897,3885,3881,10000,10943,9959,7155,7704,8201,11108,7986,8451,51,3085,7245,10827,4639,8712,7753,8228,8240,7752,10077,7147,7572,3070,7589,11225,11063,8272,6688,9095,10053,104,9095,10053,104,9579,11514,8640,10615,10008,8211,9867,10272,10232,10675,7172,10975,4659,11221,9222,9223,8812,9251,8812,9224,10887,7080,7088,10976,7600,11228,10278,9968,3908,11631,10823,10930,9741,8971,6740,7153,11836,11762,7933,7238,9007,11707,7661,6629,1381,9255,8220,11628,10926,9817,7280,6376,6517,6989,6743,6750,6746,4614,7610,7103,11085,6768,11082,8582,6199,6198,6200,9632,9631,11297,10445,3898,10981,6201,10948,9150,10947,8346,8345,7311,11429,9794,8228,1704,4804,8771,7697,3515,7694,1666,7608,3442,7696,7646,7150,7868) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC