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,5222,7266,7152,3647,7154,7660,7117,7110,7296,7278,7869,3026,5729,7834,7834,7837,7836,7903,6632,3080,7665,1371,5516,254,7616,7146,8269,7660,8388,8441,8489,8526,6971,8611,7071,7258,8687,3368,8734,8699,2590,2419,7585,7585,8193,6397,4767,4432,1349,7896,8951,5455,2023,8016,3990,9057,9079,5552,4103,9050,7640,4985,3384,9119,7388,9322,9297,9297,7106,3561,9377,6315,9212,9259,9471,8406,9455,7244,9526,1992,1992,6138,9660,9572,9614,7293,8948,9787,9814,9799,3646,9813,8477,9821,5822,4862,3425,2182,7147,7147,7218,7218,7218,7218,7646,7646,7646,7297,8520,5647,8816,7112,2085,4752,4769,7241,7674,7125,7110,7117,7574,389,4801,7073,1250,8053,7671,8240,7152,8033,7895,7895,8047,7656,1084,8514,8571,7250,382,7483,7106,8794,8638,7243,8282,8863,8863,4068,376,9054,8240,7671,9055,9132,9134,9134,9134,8412,9259,9733,1398,6678,7270,7251,7251,1126,6595,6447,2849,7856,6595,7296,7856,3595,6795,7296,7904,7714,7879,7271,7101,8053,8058,8034,8076,8040,7119,7931,8046,7878,7548,6155,7946,8284,8209,6235,7273,8373,8418,7840,7878,7879,7115,8481,8573,5320,8220,7280,4878,5320,8720,7971,7275,7297,7971,8761,7298,8419,7670,182,8683,7761,7547,182,3895,2522,8682,8618,6936,6938,7675,8698,8933,9030,7124,3080,8412,8908,8580,7103,7083,4258,2605,8847,9134,8358,6354,9336,9134,8042,9244,9329,3070,9322,3073,1349,4460,9071,7087,9449,7239,8064,8458,6514,6514,8405,6986,9312,8832,6700,9367,9093,9777,1381,3760,8436,4299,3541,4160,8681,9958,9874,4178,2253,6619,9143,7368,1770,1765,9932,10109,10087,9603,8724,7113,9603,7649,9200,10008,1767,1771,7692,7690,7686,3172,5837,8896,1609,4805,3071,3875,8220,7020,3590,1766,6740,1688,9963,3282,9769,10008,6828,1787,6642,7752,2261,8220,7973,7751,9146,2915,10379,2349,4847,4847,4728,675,1785,169,9951,9486,7368,5245,9951,9082,9026,8255,6658,9932,2474,8956,9009,3908,2337,9384,814,4330,7203,4234,7059,6624,9879,1357,7203,814,8856,8855,8761,1698,1308,1776,6030,3250,1766,9873,9833,3893,8793,1461,9344,6715,7235,2784,7246,9893,6427,9052,9115,9052,4566,1165,7903,3380,1215,446,8942,7823,9824,10742,4535,10475,4535,10475,8742,10228,10965,6728,6700,8080,10737,3860,9676,8669,576,9496,10929,4947,7598,9547,6416,10422,10381,6764,10264,6751,544,6151,6763,8160,6493,7705,573,8158,9859,1664,7605,2605,10416,2270,10742,8394,5484,10356,7751,10789,11289,6776,5487,9368,9367,8323,4730,93,11268,10836,10056,9300,8082,10768,10767,11719,11781,8910,8514,10722,10722,11670,7895,10543,9406,11846,11686,11890,10702,11211,11772,7127,10664,8764,1766,10291,10292,7580,7751,7881,7973,7972,7293,8088,2389,3559,507,7992,7300,7085,8206,7753,7106,7660,7656,7238,8220,8222,5995,1257,4178,4947,446,1215,7977,8290,8434,8435,2520,8389,8174,6642,8175,8306,8628,8703,8628,8703,4598,4599,4600,7928,8737,7928,8737,8737,8793,8681,8761,8698,6958,508,4801,2092,7852,2117,5602,3531,8706,7998,7999,7137,7551,9037,9030,8922,9038,2555,8850,8822,1662,4218,8613,8781,9134,9141,9142,9139,7659,1511,931,9090,186,8721,8053,2712,7117,8742,8231,9300,9079,8019,1145,9349,1145,8213,8044,7152,7115,7116,7272,7932,7096,7245,6726,7125,7241,7897,7106,217,7266,7084,8055,8071,7270,7671,1029,7672,8079,4597,8087,4770,8062,1402,4662,8384,7668,421,7675,8269,7657,3550,8019,8077,8657,8053,8363,8202,8052,8081,7668,8468,7931,8418,8084,8056,7071,8471,8422,8641,8087,9148,8736,9053,7671,8475,2573,2328,2388,8450,3297,8438,8477,130,5915,8385,8041,8288,7656,8045,8042,8068,8407,8782,8065,8057,8060,8069,8067,8282,7660,8058,8051,7095,7097,7666,7669,9160,8359,9054,9055,8367,8419,9573,9574,9575,9578,8476,9577,9561,10022,8467,9539,10074,9793,9580,10077,9999,8235,8642,10009,10023,10051,9158,9565,9998,10075,9572,10186,10027,8082,8078,7076,7081,7108,9443,9445,9510,9581,10024,10026,9562,10076,8364,10185,10022,8767,8410,8085,8507,8528,6879,7628,10272,8411,8412,8398,8397,10275,9793,8396,10186,10690,10659,8286,10629,10624,10689,10030,9225,8439,10630,8408,10675,10770,10773,10691,8644,10811,10807,10774,8405,10625,6896,10835,10843,10889,10891,10852,10853,9187,9204,9206,9218,10881,10906,10692,10862,10863,10834,9206,9219,9263,9262,9261,9264,9875,9876,10270,11066,10271,11062,8567,8473,9292,9313,8201,8207,7290,8569,9314,10965,8206,8537,9367,9368,11045,9316,8468,11027,10586,11187,10450,10405,10401,10890,11336,11224,11333,10572,11368,11370,9294,7275,8229,11331,8474,10694,8383,8929,7289,9399,9400,11376,11500,11501,11502,11507,11506,11503,11513,11542,11614,11538,11540,11528,7116,7096,7152,3830,7289,7245,7106,7272,7119,7117,8269,7097,2932,7296,7089,5148,7271,7906,7268,8056,4860,7572,8385,8395,7258,8086,7104,7151,8287,7276,7675,7115,7068,7094,7084,4796,7124,8282,8361,7107,7304,7943,2992,7714,3860,1537,8230,7646,8365,7118,7246,8450,7083,7671,8058,8055,8473,7151,7295,7897,7647,8463,7675,7967,7107,8526,8109,7288,8903,7118,7663,7246,7291,7666,7124,8365,7104,7096,8083,7277,7089,7155,7246,7083,501,7110,7895,7112,7897,8199,8198,7266,7114,7125,7267,7093,7087,7084,7675,8048,7152,7117,8477,8417,8076,7115,7671,8385,7932,8084,8045,8055,7574,7931,8473,8042,8082,9139,7241,7936,9563,3554,7935,9879,9148,9874,9875,9873,9876,9877,9878,10022,7671,3217,2573,6618,1609,6623,6143,6332,6371,6149,6221,5430,5756,313,2995,6215,1210,6443,1487,2917,640,4419,6550,6636,340,267,754,6486,7131,7873,947,1663,2270,2135,3882,2446,1783,8480,8561,8559,8771,52,8910,7837,7899,7772,7150,7167,4464,3860,9309,9406,4395,6104,2117,4834,9983,4029,7962,2632,7103,9833,9300,8062,7143,7869,10865,11485,8545,11271,11782,9659,916,8271,2122,5995,5279,9055,8462,8048,7731,7293,8466,8468,7931,7241,8076,8547,7087,8055,7116,8077,7656,7280,8066,8770,8358,8832,8386,8053,7675,9161,7267,8358,8571,8087,9031,7087,8398,553,8770,7125,6130,7086,7124,9293,9793,10075,7111,7122,7931,7107,7094,7124,7124,6740,7087,7087,9660,9574,7656,9083,7657,10409,10475,10475,10074,10591,10588,10592,10774,10691,10609,10692,10889,10694,6561,6006,6000,1425,6658,3555,3949,6595,5995,1591,6587,6583,6978,6962,6586,6588,7019,2145,6120,6103,6264,1558,2473,6710,7258,6445,7093,501,6713,7166,2658,6098,4209,3904,6785,3604,3595,8349,8537,8342,8620,8620,8683,6583,2992,7753,8514,9104,5052,8088,4652,8413,9339,9130,9348,9563,9579,8053,9539,9366,223,6971,10212,9741,10307,3904,10513,9945,10691,10690,10689,10588,9054,7675,8910,10629,11025,9198,9162,1232,11222,36,11812,1807,11994,4580,26,6768,2555,7258,7115,1988,6578,7551,1296,6984,1085,9469,9467,9784,3169,9633,9847,9524,9845,9494,8200,8365,7642,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,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,10577,10449,10881,10693,7249,8638,10009,7932,10862,10835,11127,10820,10890,10629,9540,11027,11162,9080,11103,9754,5965,9329,7585,11232,10702,7694,9959,10089,10566,10747,11372,11516,10768,11476,11331,11479,11628,11629,9509,11480,11225,11409,11453,11711,11689,11339,10614,11712,11453,11778,11675,10749,11685,11382,11484,11845,11477,11417,10397,11846,7250,11654,11846,10397,8460,8568,9563,7249,8083,8641,8086,10584,8657,10575,9082,10624,7258,10582,9187,8459,9134,9609,10869,10789,10906,7106,8430,8370,8424,10767,11045,8039,11187,10584,7071,11124,8045,11278,11277,7121,8056,10692,8039,9054,7276,7272,11196,8370,8282,9539,9578,11124,7662,7661,11125,11276,7278,11334,11376,9793,8711,8431,10510,11472,11469,11471,7241,11411,8711,11470,7574,11196,11525,11511,7108,9370,10580,10275,10271,10270,11333,7271,11526,8411,9312,8713,7279,9756,7265,8475,10270,7666,10272,8458,8461,8537,7077,7971,7068,10789,7984,8391,8393,8211,10659,10692,10588,7087,10588,7111,7115,7116,7117,7119,7125,7675,7895,8047,8048,10169,6131,9055,8770,9134,9204,9206,9259,9529,10690,9563,11124,9578,11276,11471,9539,8063,11336,11337,9148,11059,11187,11469,11470,10906,8058,11376,7077,11034,11542,11035,7279,7666,8044,7077,7265,8213,7930,7280,7279,7244,10009,11555,8713,7561,1993,8966,8481,8481,8833,9667,9667,6548,6548,9529,9148,9259,7288,7288,7288,7288,7288,3327,10670,11101,6700) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC