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,8460,8568,9563,7249,8083,8641,8086,10584,8657,10575,9082,10624,7258,10582,9187,8459,9134,9609,10869,10789,7106,8430,8370,8424,10767,11045,8039,11187,10584,7071,11124,8045,11278,11277,7121,8056,10692,8739,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,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,8739,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,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,10577,10675,10272,10275,10575,10629,10630,9743,9508,9562,8034,10007,7077,9261,9564,9581,11059,10689,7108,9580,10855,8087,10854,7153,10965,10887,10881,8046,10888,8086,11034,7279,10890,10506,11211,11035,10507,9443,10508,7261,8364,8644,8961,10404,10449,8057,8368,8443,8050,7289,11276,11061,10509,10274,8472,11331,11411,11278,11065,10511,10889,8767,8207,9738,11367,11536,9057,8414,8474,7150,7666,11210,11674,11668,9148,10941,10943,10947,10942,10623,10944,10624,9821,9956,8450,10945,8468,8646,8428,8415,11630,9997,11262,10946,11760,10625,11712,9095,11211,9957,10573,8929,9744,11335,11841,11866,11839,11840,6605,793,2573,5848,4788,6560,320,947,4199,6130,1453,1521,6117,1038,1086,4337,6776,2447,6700,3184,7374,4510,4987,2384,5439,226,1439,5576,7204,6967,7605,5914,3885,1424,2748,2894,1272,8220,8271,7926,8220,8214,8560,8547,8415,5602,800,8556,7292,539,6689,7069,8047,7878,4399,7840,7169,9052,8547,9366,9362,9746,7112,766,9552,9796,8071,7089,10048,10056,7019,3159,7953,9833,9945,8514,10146,10130,9116,10836,8556,9563,10937,9864,10937,9227,10504,2615,10873,10872,8823,6599,10340,4146,867,10346,7913,2257,9939,10533,11971,9078,11660,11977,10760,11845,11494,10290,9463,11900,842,9651,7546,7677,2261,5460,6876,7285,4947,3493,7068,7840,6646,7838,7903,7168,7775,6652,7184,7180,6654,6653,7188,1738,7185,7181,7879,7183,7189,7178,1521,3625,8247,4386,7187,7176,8089,8146,8248,8314,8315,8246,7167,8249,4464,7186,7182,8316,7614,3542,6713,8319,4218,4470,8242,8313,8340,8336,8317,8599,8341,8311,8342,8305,8322,8337,8328,8327,8325,8241,8332,8326,8339,8314,3715,5373,8340,8241,8330,8309,8325,8649,8598,8335,7178,7189,5379,5812,8332,7184,8310,2989,8326,7179,6652,7180,8318,8555,8883,8874,9129,4131,7188,7184,8897,8899,8003,8896,7751,6527,7972,6372,7187,7014,2029,6527,8938,8918,2006,8611,6688,9589,9535,9587,8324,1953,7249,9430,7582,6842,7844,9911,2337,4944,9214,9527,10139,9772,6216,10045,9454,9773,2782,10246,4082,8888,3413,9160,9973,9148,8641,8055,9600,10022,8063,8575,61,7619,9453,10375,8573,7262,10549,9508,9996,10272,10464,8795,10692,1349,8741,10623,10774,10624,10672,10251,10508,10625,10835,9660,10910,3244,9052,9963,10855,10854,8892,8891,10862,10894,10895,8737,2863,9610,6712,9798,10476,11289,9543,10305,8206,7717,11273,9540,11274,11332,6364,11456,7671,11573,9873,11501,11497,10532,11140,8805,11045,10789,9076,9797,8407,2520,8236,10615,10941,11063,10400,8409,10686,11692,11693,11918,7933,3744,228,2677,6691,2677,5088,3904,4082,6696,1347,3080,6774,5817,2294,6633,6858,6863,6693,1299,4724,6793,6821,3612,6809,2262,739,608,6845,6104,6006,3115,4432,4566,320,3701,3719,7592,4652,1699,1349,4778,2451,1073,2841,7839,4460,6732,6209,4258,7946,7081,7265,7268,7971,8058,7069,4029,7154,8211,8044,8058,7244,8288,8429,8361,8078,7080,8403,8209,7294,8713,8400,3066,8469,6650,8207,8402,8468,5947,8839,8772,186,8195,8284,8876,5936,8281,7913,931,7884,801,659,3647,5545,971,9249,5961,9141,6069,7718,8468,8408,1163,9560,9743,5956,9458,9480,2329,1906,9028,8460,5460,9875,4710,9874,9648,9876,9877,9878,8445,9648,8446,10275,10270,9132,9133,9619,9620,9621,9622,10575,10078,9748,9793,9746,9747,10292,7671,10947,10948,9609,9611,9608,10687,7262,9610,7241,7672,9878,11062,10965,10943,10881,11187,10506,11045,11096,11059,10941,10891,10026,11262,10879,8573,10888,11018,11370,11275,9205,11277,9794,9756,7077,9675,11332,11337,8397,10676,11369,11469,11539,11542,10678,11266,4227,4226,10703,10449,10854,11410,11553,11614,11675,9877,11627,8740,8568,8424,10332,11252,11695,10325,11319,11696,9624,7172,9232,3559,7165,7170,7163,7171,7169,7164,7174,7173,7168,3115,11255,8228,8577,9554,4463,7166,7167,7677,4473,4470,8662,4464,4486,7070,2823,6443,1741,4645,9892,8712,11527,9509,8946,6688,9867,9383,11836,11516,10427,10963,11674,3359,11889,2780,2786,2781,2778,10789,10930,10931,10232,10926,10927,10928,11067,11068,11878,5134,3287,10543,11697,11981,8945,11576,11574,11694,11723,11355,6768,11877,9625,9626,11575,6506,11354,6533,6532,6535,6505,11355,6538,7265,8213,9821,8213,9821,9821,7068,9821,8062,8062,7657,7657,9719,8050,8720,8450,10882,10882,8240,10890,10890,10630,11045,11096,10400,10399,10625,8282,11225,9058,11124,10863,11276,11187,11331,11125,10011,9161,8573,8360,10771,10769,7267,10770,10862,11469,11470,7674,11471,7670,11332,9225,11633,11626,11652,10689,7275,11630,9662,10854,10855,11700,11755,11757,11761,11631,7084,8393,7271,8394,8876,7913,9562,7103,8474,9261,8415,8417,8394,8208,9161,10185,7250,7660,9594,10356,7115,8282,9370,9956,9821,10507,7298,8892,8891,10025,10570,10577,10508,10576,10629,10272,10574,9999,10623,10625,9744,9873,10767,9875,10399,9877,10077,10882,10881,7971,8411,9509,10965,10302,8468,10630,9148,9316,10833,9609,8071,7933,7241,7108,10076,9259,8567,9264,9563,8474,7295,10811,11108,9053,9225,11124,8282,10625,11125,7271,8736,8794,9662,7270,7715,9650,10451,8285,9574,11262,7243,9577,9293,7261,10773,10835,7092,10011,11331,9756,9755,8370,9053,8571,10451,7656,7657,9659,11376,11274,11273,10475,9660,7298,8411,9876,9797,10855,10854,9367,11275,10022,11472,11515,11516,9141,10271,11532,11534,11508,9302,11693,11692,11711,11573,11711,9398,11535,11536,8743,8415,11540,11539,7250,11108,8087,11671,9058,9059,11700,11777,8052,7271,8238,11472,11534,11279,9610,9609,11262,8892,8891,7281,11628,8460,11629,8711,8580,7088,8735,7086,9572,7289,8052,11881,9187,8087,11892,11889,11890,11513,11882,11887,11912,11913,11893,11863,11884,7646,11915,11916,11626,11955,11914,8087,11038,11305,8034,11309,7254,7088,7086,11196,11218,11278,11368,7662,10573,11337,6103,11385,7610,11052,7311,11365,11251,11421,11130,11419,11422,7892,11013,7697,3997,10981,7696,5635,1927,9555,11187,11463,3997,11116,11269,6653,11063,11376,788,4386,7172,11402,3442,7186,7286,10272,8228,7715,10980,10850,8364,7176,11370,11431,8280,11515,9082,9473,4558,11539,11497,9500,10433,11556,7890,5763,7269,9959,11496,6873,8965,10655,176,2145,10655,176,2145,10655,10805,7178,10480,11365,11795,1016,11780,2791,7179,11150,11768,10526,11746,7374,179,4767,1506,6559,6663,6876,5088,1520,793,464,5907,6001,308,585,600,6162,6168,358,3892,5647,4969,228,7258,6813,7304,6766,6954,6812,4217,7160,1830,6794,7144,6780,6155,2328,2506,6695,2863,6831,6802,7838,3046,7783,4983,6767,2419,7602,2573,6160,7146,8020,6159,725,3728,6811,8093,6588,7143,6605,6971,4570,6128,8096,8526,6726,8230,7822,8503,8836,6172,7304,8611,8184,8512,7887,8109,6348,8852,8489,7897,8869,6104,8869,8032,7850,6809,8118,6845,8903,6104,9075,9116,4860,8630,9052,3725,7920,2023,8500,7839,585,8948,9366,4220,9354,2925,8933,9369,1490,8955,9541,8806,9069,7022,9543,6135,9453,3549,8543,8305,6117,9647,9648,4765,341,9200,4652,9345,9374,9348,1349,8934,9346,9939,9249,9248,8795,8915,8805,8935,9924,6821,8492,9922,4566,9941,9928,4566,8501,4128,9402,4061,8031,10057,10208,9910,9117,10063,7759,4056,3936,10227,3100,1698,7138,6683,145,6986,6635,6793,6684,9991,4131,10039,6679,9363,7761,9258,10341,6595,7354,10548,7019,10688,8222,8793,8222,9195,9552,9925,10245,9993,5236,9000,9027,9282,10762,9034,3595,10879,10938,10528,10955,768,10893,8829,9352,1127,233,228,11127,9749,9065,3964,4635,4656,5046,5193,7760,11021,9038,8629,11122,308,4023,10246,6314,6779,6169,6674,180,148,6639,180,3493,2261,11324,6686,8808,11324,9379,7147,8923,8781,8257,3059,10572,10535,8539,6792,10573,11213,9467,6713,8769,11489,11377,7077,11220,7156,11361,11439,7077,11361,11439,9629,11018,7077,4537,2294,9055,9204,8048,4046,10915,11124,9639,2019,11353,11599,7661,1895,11287,3288,10719,7662,10623,11125,11521,9638,10623,9220,6713,10042,10623,10042,7125,11126,11724,2923,10895,7084,5368,11678,11760,8709,8368,11237,11692,11501,11693,11803,11867,11868,10630,10272,8056,11867,10689,10623,11502,11777,10624,11647,11210,10625,11349,11336,11273,11488,11274,11912,11028,10787,11279,11275,11542,9609,8548,7839,11262,7281,9259,11958,11020,8999,11337,11534,11300,8610,10888,10720,10976,6870,11189,8144,8030,7149,10011,7910,8208,4254,8892,5763,8891,5371,10768,11386,8370,11384,9557,8482,7280,1049,10869,1343,7277,9757,1016,5988,10007,10649,9739,9959,6103,28,7208,7247,9740,10854,10855,11188,4598,11471,1308,7641,11277,8400,11402,11553,450,10011,10694,11271,10510,11572,8577,8471,8547,10818,9136,11676,3908,10483,9563,10884,10372,8,11707,11634,11706,10275,7273,7248,11709,11743,8279,10270,10977,11746,11771,7088,11776,11376,10965,2447,11704,10789,8178,11818,11839,6264,8022,11840,11283,8891,11879,10051,4659,7281,9609,3967,11337,2847,9303,11927,8794,6103,11408,11115,11976,7285,1327,10274,11449,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,8739,9204,9206,9259,9529,10690,9563,11124,9578,11276,11471,9539,8063,11336,11337,9148,11059,11187,11469,11470,8058,11376,7077,11034,11542,11035,7279,7666,8044,7077,7265,8213,7930,7280,7279,7244,10009,11555,8713,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,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,10585,11212,11654,11674,9502,6520,9579,11668,11553,7252,11539,9398,9132,10624,11274,11278,11187,11395,10881,11614,11472,11867,11868,11469,11958,11911,7261,11514,11818,3165,8257,7874,7970,2473,2915,4784,4701,9079,5380,9365,7218,4639,217,9904,9938,9937,1257,7903,9525,2658,9647,9900,9666,9922,9959,10000,9931,9366,9052,8948,2033,7143,5647,3830,9027,8793,1766,9829,4405,8087,10835,7106,10629,10919,10965,10992,11020,11068,11092,8792,10625,9082,10659,10694,8414,10572,7289,10692,10773,10689,11274,11276,11277,11629,11628,11632,11652,11631,11633,11712,11630,11631,11712,11630,11685,11711,9509,11758,11743,11713,11528,7930,11518,11654,11651,11653,11779,11780,11782,11777,11778,11797,8202,11793,11795,10770,11632,11671,11798,8460,11756,8080,11802,11801,11333,11865,11469,11367,9095,11675,11368,11794,11369,11781,11883,11674,11335,7275,11376,11917,11888,11803,11805,11925,11411,11868,11926,11553,11884,11526,11892,11958,11916,11634,12002,11861,11806,6687,11804,11918,1327,11063,11130,10789,7280,8395,7944,9509,9205,8577,10077,8770,9134,8384,8395,9563,8644,8407,8408,8406,8404,10510,10675,8783,8082,7933,7674,8394,7281,8423,8771,11125,8737,9793,11370,11511,10869,11332,11124,11508,8580,9539,8212,9529,7280,10887,9817,7285,9578,7660,9134,11553,10768,11131,11331,11671,10767,9795,7088,7086,8423,11758,11693,7715,9540,11692,10869,8832,11188,10272,11096,11795,8709,8741,9816,11634,8740,11402,9259,11472,8763,4395,11797,3428,11839,8763,11781,11514,11957,9558,11832,458,11889,7092,10774,10835,11693,10585,11652,11448,11709,11761,11763,7975,11332,11779,7765,11528,10629,10659,9055,11762,11777,8414,7275,11469,11500,11368,11370,9305,2748,9062,11893,11713,11804,11553,10770,11803,11540,11573,11542,11558,11887,11889,8071,11882,11916,11975,11974,9739,9738,9313,10863,10890,10609,11315,11352,10608,10027,10738,10111,8477,9577,9959,4199,11106,11135,11380,10892,8856,10002,10773,10774,1173,8052,10889,9293,7006,10741,10863,7095,10733,7092,10914,10362,10782,10737,11513,10400,3115,3719,9293,6631,7894,11515,10039,11443,6779,10587,9189,11528,9660,8477,7267,9148,11220,393,11116,7269,11543,9495,8573,7903,11332,11543,10942,7296,8070,11556,9072,7143,8463,10890,2875,1378,10617,10248,9821,10403,8268,8658,11511,4665,11509,10175,10889,10648,8858,10608,10495,9828,11224,11684,10744,9189,10026,11741,7269,10779,9581,9675,10400,11633,11794,10623,11802,11380,10495,10464,11754,10027,10451,9874,11511,11797,10910,11801,9799,10674,9872,11508,11805,11753,10674,11671,8724,11540,11572,10399,11916,11883,11741,11892,11914,11479,11917,554,11914,8359,11534,8547,11652,11651,10027) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC