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,470,645,4008,6564,6565,6572,6575,1461,1593,6562,3797,4165,1092,744,6568,3645,7063,6998,467,7119,7095,4164,1600,6521,4423,7089,7093,4964,6527,1474,7121,6522,1098,6504,6735,7115,6576,7115,6902,7125,7029,6503,6901,7047,6523,6996,7223,7235,7001,7029,1460,2456,7233,6675,3418,7013,652,2917,2696,7112,2956,1425,7249,7276,341,3447,943,1869,7231,3760,2446,3454,7234,2456,2454,3610,1893,1765,944,7034,2151,1829,7089,2974,6588,7272,7271,6168,7272,6350,7271,7273,3417,7296,2334,6530,2671,7280,2653,5371,6365,7241,6676,7258,6993,2876,7057,7106,397,4021,6678,6726,6518,6512,6371,726,6528,6530,6529,6531,7691,7689,4305,860,7692,650,7686,7699,7681,4224,6530,313,810,7753,272,7275,5066,7844,3784,7661,7670,7602,7108,7084,7265,7268,7170,7168,7599,1771,1767,1207,1769,1765,1768,6669,7238,7083,7654,7094,2989,7124,4769,2677,5995,7670,7666,7594,7647,5647,446,7642,2632,7122,3964,7114,7661,4406,7081,4082,5602,7359,4936,7279,7272,4944,7648,7093,7243,249,7119,7265,7273,7089,7085,7271,7077,7655,7252,7661,3561,5995,5719,8537,7286,2117,5996,3863,7256,7068,7261,7304,7661,3327,3327,7655,7655,8081,7655,3896,1973,1973,1308,8951,8951,8951,7985,3895,8273,3892,7655,7655,7655,7655,7655,7077,7287,6484,6484,7090,7068,7108,7971,7072,7247,7946,7946,7107,7294,3036,8044,8049,7906,7282,7282,8086,7279,8081,7269,7939,7074,4983,8220,7940,8371,8371,8086,7077,8571,8206,8206,7906,7663,8071,8113,8439,7666,7266,8167,8164,8206,6796,4716,6728,7661,7642,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,1768,7273,7249,7675,8361,6349,8087,8087,7661,7661,9021,9021,8087,8206,7661,8410,4774,7077,5923,6870,8828,3066,6691,7155,7077,8371,3884,3888,3897,3893,8199,8198,8197,7076,7100,8201,7646,8585,8583,7661,8395,8083,8083,1559,4217,4624,5148,3989,254,5516,585,6250,4220,3613,6255,1498,1439,2954,1073,1954,4005,1830,6117,5764,6635,3904,4046,4128,3368,6155,1113,1163,1681,1690,2915,1038,4050,4049,4045,4233,7262,7244,8206,7263,8206,7263,7661,8063,8087,7099,7068,7284,7282,7264,7286,7288,7106,7268,7089,4209,6863,7984,7654,3698,1738,3197,1210,7265,7111,734,7250,7249,7250,2261,7086,6785,7114,7077,7286,7239,3131,1461,6644,4405,7285,2360,7665,7658,7069,7641,4527,7115,6842,455,7283,7278,464,217,7878,7068,7655,7899,7020,7665,7671,8044,7939,7659,396,7102,7675,8087,4405,8393,4696,8046,4406,7684,7287,5763,7661,8033,2398,5131,2530,8063,8282,7879,7717,8389,842,8430,7089,8767,7085,8064,8282,2192,6646,1131,8394,1029,8770,7917,8475,8397,8722,7112,1163,7660,8282,8398,5362,1057,7661,217,5907,8391,7760,6808,1718,4653,2187,8537,3134,8055,7943,7657,9225,9441,405,7083,7155,7119,7097,7110,7085,7112,7096,7266,7211,7115,7572,6140,6140,6631,2005,7086,8405,8468,8468,8211,8450,7289,7289,7096,8398,8398,8236,8404,7273,7096,7082,7112,7093,7294,7106,8049,7119,7087,7116,8211,8208,5996,8033,8209,8144,7664,7268,7072,7152,7273,8069,7117,8040,7266,8047,7897,7943,8077,8055,8061,8057,8085,8076,8081,8369,8370,8268,7258,7245,7659,8652,8050,8461,7574,8394,8463,7975,8465,8792,8476,8083,7114,8282,8466,7273,7661,8050,7124,7096,7943,8385,9160,8285,8652,8724,7293,7252,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,8771,8771,7111,1116,1116,7660,8083,7068,7084,7084,8580,7088,7086,7661,8063,8046,8034,8087,9543,9543,8864,8391,9247,7659,9158,9158,8393,9225,9338,7715,4234,8063,9082,9362,8644,3884,7121,8615,6134,8412,9264,7280,9398,2677,7984,7932,8306,8423,9662,9382,7661,7759,9658,9464,9148,9659,5179,9844,7108,4947,7023,1533,3493,9563,1461,2995,2417,7986,4046,4769,10076,3863,8891,6781,8449,10026,10051,9220,10212,10077,10126,9821,2644,2455,10025,5454,10185,6209,3875,10270,6986,1370,7280,10275,10273,4906,956,7149,9444,10436,10063,9787,10506,9325,10149,10314,8782,9543,10523,9741,450,9533,10271,10578,9822,9747,180,4724,8972,8762,10768,9492,3891,1370,10767,7985,4762,10257,10890,8071,10854,9373,10882,9993,10888,10302,10881,8783,6102,10554,9608,6876,10887,7251,10190,3863,10789,10702,11130,9793,10078,10938,5251,8743,10965,10991,11025,11027,11188,11224,10823,5331,11212,11268,11189,4778,11278,11196,11281,10670,10701,11038,11262,11329,11187,11337,5454,11108,11376,9795,10274,10412,10187,11402,11336,7913,8474,11215,10862,11455,9199,8423,11228,11524,9417,9308,11331,10839,4645,7261,7792,4791,10615,11449,10072,11511,4355,11633,8721,11302,7986,9817,9481,11628,11484,11700,9993,11038,9649,8366,7363,7094,11117,10818,11629,11760,4401,11797,3883,11758,11444,10891,11776,1371,2677,10360,11553,5331,11793,11327,2658,11105,11763,11101,9398,6904,721,11712,9554,585,8460,10716,7661,8742,7655,7077,7287,7121,8211,7110,8084,8087,7096,8047,8366,8063,7084,7658,7268,7655,8080,7714,8065,8452,8652,7659,8456,8998,8068,8268,8713,8064,8401,9560,7273,8891,8892,8393,8378,7670,9053,9594,8058,8362,8049,8425,8050,8406,8201,8640,7674,8373,8641,8476,8430,8766,8443,9564,9738,8712,9740,8428,8570,8646,9508,9741,9442,8737,9562,10025,8467,7665,7266,7122,8081,7219,7491,7537,1499,659,659,6714,6714,7501,7501,7422,7422,7422,7472,7385,7385,7385,7385,7385,8211,9132,6348,8269,7656,9053,7660,7658,7091,9813,7077,8044,7661,8721,7287,8768,7268,7268,7485,7485,8740,8740,8740,9899,7661,8721,1497,10166,8638,7674,9817,8444,7114,9719,10272,10507,9547,3073,3071,10247,6689,4701,7647,10053,9665,10212,7753,7752,8088,1257,8627,9277,3428,9037,9679,1616,7239,6688,8944,1215,7881,9647,9867,7281,6537,446,10056,6534,6535,6506,10008,5386,9259,4765,10342,9133,8946,9132,10347,10541,9383,9370,7659,7251,8400,10615,10672,10232,8402,10228,9303,8403,9383,240,10741,7080,8891,8251,51,5994,10275,10814,10552,5053,10738,10673,10910,9048,9389,10820,10836,8208,1303,6894,10267,10976,10975,8441,10649,9609,9889,10483,7953,3908,11024,7917,11010,8063,8891,8892,7077,7661,7655,8087,8394,7088,7086,9875,9876,9877,8444,8740,8424,8568,8067,8459,7661,9659,9563,9817,9819,7279,9820,9818,10437,8286,8369,8658,8048,10586,10588,9132,9133,9619,9620,9621,10768,9622,9746,9747,9748,10835,9293,8477,7085,7661,7077,7068,8080,9573,7674,7122,7287,7971,7125,9055,8449,8770,8449,7655,7715,10401,7286,7280,7714,10475,10272,7265,8571,7660,8451,7281,9148,8288,11692,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,8739,8039,9054,7276,7272,11196,8370,8282,9539,9578,11124,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,7651,7167,7654,4520,7077,8580,8015,9543,6197,9873,2520,11331,10941,10686,7166,8585,9874,7250,7165,9875,8584,11354,9719,8212,11149,6354,4464,3070,9876,9877,3073,8577,8199,3071,9878,10045,9601,6689,8577,7168,9367,7169,4791,7164,8662,7654,7297,6774,1730,4486,8580,7173,7298,8087,11038,11305,8034,11309,7254,7088,7086,11196,11218,10906,11278,11368,10573,11337,7354,4566,6683,10770,5596,9377,8808,10674,5431,1234,173,4432,10226,10079,8927,9900,6397,10272,11262,11187,10146,5513,145,11335,11381,9922,6278,1775,3368,9338,11287,5247,7250,11108,5236,28,9464,7876,10397,11225,7661,4023,6679,10893,1145,9888,8568,8424,8740,9977,5175,4023,4061,4969,3989,6595,228,4233,9968,1398,11630,7143,11652,11633,7671,9560,8812,9251,10168,8813,11517,10748,10472,10675,11684,9417,10904,9036,8517,11703,11658,11442,9874,9873,9876,9875,1173,713,2995,923,11388,172,8474,1970,10577,8929,7655,8081,9205,10854,9461,10855,9503,8889,11609,11385,6635,9980,9896,10869,11398,9246,8140,3558,10078,11753,8139,6548,11795,11473,11689,11794,10624,9220,10860,9638,252,10042,11822,9904,11838,11130,9401,7670,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,4735,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,10906,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,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) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC