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,6390,6391,863,858,6191,6527,6146,6152,6377,6517,6151,6144,6750,6388,673,653,275,6607,6191,6381,4614,7018,323,394,8307,8584,6270,6531,6529,7610,7870,7697,6652,6216,5691,6528,7695,7868,7696,3442,1704,7693,6654,8719,7189,8586,7546,4302,8897,8618,3515,8682,1770,2783,6197,8728,7188,6023,1765,7187,7568,7567,7569,7570,7762,4535,2799,2799,7917,6195,6364,8946,8946,2005,7753,1461,7753,8627,9037,6354,6354,510,1766,1770,8698,8817,2384,7751,7972,7973,9669,9670,9670,9671,9131,9131,9672,9673,9673,9673,8762,3581,8243,8872,542,1665,375,8786,1500,8951,384,1766,390,8334,8856,8332,323,9049,9182,375,8700,6744,8,8874,9274,6381,9501,9481,8307,6974,9686,6700,446,8436,7580,9120,8682,8320,8330,3875,7094,8336,8681,8698,8899,8244,9041,8698,9184,9041,8656,8696,8945,7636,8694,1368,8692,8946,8693,8695,9037,7753,6354,8817,3073,7752,8943,4701,8946,8727,1769,8323,6371,1770,6223,1765,9037,1767,8248,979,1769,6599,1768,7631,6359,3115,3071,8704,1770,3719,8340,8705,9114,507,9149,8174,6354,9137,3559,7808,9278,9383,5297,8943,7753,8944,7752,8943,7881,1770,1767,1765,4716,1769,1767,8276,1768,1245,510,8275,8591,7751,9515,9407,7972,7973,8946,7592,6688,4944,7546,7748,7753,9665,321,9626,9037,1303,1770,222,1765,7020,3073,8943,3071,7963,7881,8944,9601,9084,9624,7772,8618,9867,7770,8585,7185,7771,7187,512,9806,9907,7637,9906,9911,7753,9958,7752,10053,9720,6688,8727,9722,8946,9721,3071,9723,272,6600,10232,9215,1765,1770,8815,10255,9624,3719,344,10254,9720,5484,8897,8342,8341,6223,8337,6218,8315,6521,6212,4301,6197,3442,3515,7694,7695,8898,2795,8897,7698,4282,6216,4302,6371,6175,2467,6151,1738,4289,7741,5691,5904,6526,1462,6212,7913,6742,391,3885,4512,8700,5386,6953,2164,8388,2455,4701,8780,4769,9391,3515,1116,8247,8980,4424,6832,735,2989,222,7178,6181,3036,223,8899,2389,8242,5567,7186,6444,961,6377,452,6523,9692,6652,8825,7189,9559,9631,7764,8279,8816,2778,9996,7762,7570,4437,9949,9970,9338,9792,9880,1245,7725,9763,9665,9616,1770,9950,9492,52,1765,7,9906,9951,1771,9480,9880,10219,6115,9424,3913,10102,10199,9835,5484,8432,450,10154,8257,8727,1250,9669,9782,2780,4701,10188,10110,7751,8151,4639,10155,7972,7973,9670,9892,10155,961,9671,9033,9131,8822,9672,9673,5175,576,9168,6119,9473,6003,1766,4500,5769,4349,2605,4338,979,5678,10156,151,9473,4800,9720,3081,9722,4901,10281,2467,10071,8566,8967,10655,11097,10187,10991,11025,11116,11105,11135,10974,11104,9,4424,11052,11072,10554,9959,8173,10886,11092,6181,7205,2079,6820,8507,11306,10550,1774,7048,5531,4510,11118,11260,8970,10718,2169,11045,10483,11053,11279,11482,8565,8721,2056,11099,11449,10941,1887,6,10947,11283,11253,6267,6118,10133,8946,9846,3327,7888,961,11638,11886,10477,11622,10682,11328,9390,11908,1265,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,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,10906,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,1266,5297,9515,3359,6066,8585,6688,6855,4386,9517,9518,810,1967,6382,6371,7185,7180,9522,6533,5063,5064,5056,8110,6872,4224,7882,6898,3893,3882,3884,3892,6493,8271,9895,9906,4931,9679,7187,5053,9492,3070,8584,9907,389,9665,3073,3071,6689,6441,7632,1771,9880,9011,1768,240,10043,1767,1766,9601,9867,510,391,380,464,8714,9892,3380,8728,8729,10238,10188,2775,2084,1411,810,1349,6200,8935,6198,4282,9197,4291,4304,4297,4287,7697,7694,7695,7868,6212,6526,7693,6521,6520,4652,4386,6654,7182,7189,7185,7178,7179,6652,7184,7181,7183,8897,7188,6653,7176,6214,7180,6497,6499,6216,6501,6498,6222,6218,6215,6220,6221,6212,6223,6511,6531,7845,7844,6510,6509,6508,6513,6514,6515,1165,6507,7843,1266,1685,5297,1349,9248,1767,1768,1765,1769,7170,7172,7174,7173,4473,7165,7164,7167,7187,6512,3073,6354,3071,6689,3070,6688,7753,7752,8088,8627,9037,8946,7186,7166,9383,9867,8943,8944,8945,7881,7599,9679,1368,7636,848,4121,5064,5053,1765,1770,9911,9912,7972,7751,7973,8276,8275,8278,8888,8728,9343,9722,9721,9720,9723,8816,8946,9669,3359,2951,1767,7631,6354,6220,1768,1766,1771,1765,1770,6688,9920,1769,10176,10098,3073,10175,3071,8583,9880,4714,6689,9679,3070,1266,8727,2506,272,6198,5810,9824,7881,7752,10053,9665,8899,8897,10067,6200,9867,9031,8489,6215,8668,1766,4842,4286,6218,4297,6216,2794,2791,6497,2789,3071,6880,675,2786,2785,2787,3465,2783,2781,2779,2780,2782,6443,7868,4304,4293,10258,2778,979,7311,10238,9473,10251,9669,4224,2951,1970,6679,9477,10188,3385,6002,8233,9073,9243,9478,545,8714,9383,9476,529,40,10055,3358,10294,9483,5207,1690,7185,7184,8815,4223,9632,3525,1369,138,7178,7179,7632,7189,4386,7176,9921,9637,1137,7187,6198,6362,1325,10258,10398,6382,10608,3875,7837,7834,9376,10607,7835,4931,3254,10552,7836,9297,10467,10536,1557,10568,10232,4,510,9474,7771,7770,6688,511,512,7637,9626,867,9067,9625,9670,9671,10612,8729,9475,8881,8161,10364,9624,10626,8882,8878,10642,10647,10639,10643,9880,9625,8880,10644,7569,7762,4804,7567,7570,7764,10298,9493,7698,10641,8016,10640,9906,9907,9970,10043,10253,10255,10256,10637,10646,10254,10752,10531,7300,10645,3165,10521,10753,10548,2261,6855,222,10522,1520,1917,3059,1461,3595,3493,145,8306,4178,5995,10212,11105,6710,7019,6876,7761,11032,8222,8793,11031,9195,9552,9925,10229,11106,9661,10397,10315,8965,9675,9655,3874,4923,4146,3409,7172,3511,10749,10938,9993,10544,11033,7753,8627,11109,8088,8946,8945,10927,8944,8668,6263,10975,11121,10641,3236,9933,7810,8110,10239,10821,10822,10931,10930,10840,10639,10637,5066,8943,10748,10926,10928,10797,4923,11255,11252,11254,11251,7592,7554,7754,7755,7756,7927,10564,8509,11246,6740,40,6683,145,9635,5,173,8978,10207,11217,11240,9363,6639,4023,6732,2843,5431,8220,9300,7238,7912,11325,7849,10056,10836,1368,28,6598,10637,848,7580,1769,1766,1768,145,8175,1765,10893,1983,7304,11101,11395,9072,11397,3327,11398,11401,9543,11382,30,152,801,9,11383,1230,9352,8389,11381,11328,11431,11421,11171,10057,7356,6773,11396,6792,10687,4510,4752,1973,10788,11442,5363,122,10827,6359,1411,9466,11479,11473,11476,11359,10829,11478,11480,11468,10278,3014,6727,5513,11177,11477,6692,11416,10520,9149,8154,8002,11067,11071,9322,11517,11181,11550,8904,9677,11342,9378,10350,8688,11598,11552,4329,11175,947,4103,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,8739,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,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) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC