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,549,526,548,535,546,6042,536,545,537,540,542,543,531,533,553,532,524,525,3884,3889,3890,6493,3892,3883,3893,6691,524,525,539,545,528,6042,546,544,541,538,532,540,535,547,553,550,549,537,7085,7670,7245,7101,7656,8206,7646,7666,7657,4716,6740,540,529,528,538,539,573,553,526,531,525,544,524,537,532,542,543,554,533,2324,536,9016,7251,9543,9543,1645,547,7849,3865,4931,6798,531,510,6491,3071,7676,1324,2374,1732,8003,532,546,3893,543,528,538,8425,788,2023,7174,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,9076,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,548,528,7071,535,540,7281,6141,7238,546,6658,857,5742,5733,4716,4437,2041,3863,550,8220,6381,553,7539,529,7149,8440,532,539,323,313,397,860,6386,549,8542,5853,6769,526,7704,538,528,525,7704,5853,540,864,544,1730,545,531,543,391,535,541,387,536,382,1271,4769,376,524,377,365,376,374,6270,384,2856,8787,368,6066,6082,385,394,6197,8858,372,6076,317,3913,317,3913,6382,6523,8165,375,6526,8496,3879,7588,8989,8530,8160,1380,3823,6854,6391,8159,8157,7300,7605,4701,8785,6144,9437,9435,8244,9438,8340,3879,8699,8874,5770,8316,9146,9414,9409,8700,8245,9436,9425,9408,9184,8883,8329,8247,9182,9415,8332,8318,8324,8326,8319,8241,9592,9183,9428,8248,9431,9894,9150,9143,9534,9190,9908,10045,6768,9300,7632,9154,6396,4501,10056,9792,9891,9155,9156,9217,10202,9156,10198,9854,9217,9502,10193,9502,10193,10197,10195,9147,8333,8335,10099,10102,9151,8330,10218,10147,10333,10322,10323,10217,9412,10102,10336,10332,10334,10101,10331,10100,10324,10140,9433,10213,3882,529,553,545,544,6544,3891,3896,6718,546,7580,539,3883,540,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,864,1366,8356,8530,546,8880,979,6394,6842,8212,7472,9030,578,547,2847,3337,1777,7178,8438,4500,4500,9076,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,1807,3883,531,3892,7045,6303,545,524,8338,8342,8247,528,6270,539,381,1198,553,544,526,392,385,6523,8222,543,528,545,532,541,6042,573,548,549,8289,525,4639,533,550,2573,545,9001,8028,8289,1645,3647,2992,6817,6366,2467,7795,2117,8027,7986,6870,7987,8272,553,524,526,545,540,536,528,543,544,537,533,550,6042,541,548,573,549,538,535,546,539,547,531,529,532,542,525,3863,3863,3863,546,547,524,526,542,532,7721,7644,8361,377,381,6270,6750,372,545,374,374,544,531,2520,3890,3890,3891,3891,8877,385,387,391,6391,3884,6493,3896,3895,3888,3894,3882,3888,3883,233,2035,245,254,1005,1209,842,1993,7920,7149,8220,8440,8514,8483,8547,6911,3888,3892,9220,9300,9284,9258,9298,2265,9354,8183,9030,2849,6842,5222,5331,6842,8683,737,377,9322,101,222,5419,6011,1537,6362,550,6158,6774,6154,6559,5882,6691,5995,2709,6746,6743,7159,6177,6983,801,5175,969,7938,6380,6381,7756,7659,4390,8231,6926,1886,7546,8584,6008,8681,8698,6933,8817,8910,8156,8514,573,3893,3889,7261,8251,8368,7294,8366,8366,7661,7661,8434,8434,2555,3402,7747,2171,2643,3409,9095,8295,8241,8243,3898,3898,6596,536,545,549,524,531,547,3884,397,3890,9622,6139,553,1704,5454,3891,2520,2520,9612,7297,1084,6493,8242,546,6768,6042,573,526,553,541,539,7772,510,1765,7770,524,532,528,7771,1769,6876,533,512,511,9792,7772,7580,7637,546,9911,7638,6100,7596,9147,9155,9150,9154,9156,9231,548,529,9145,9144,9146,9151,9190,9217,9192,3719,9143,8272,3883,3894,9665,538,9626,538,9625,7753,2811,2816,7748,10053,8698,8817,8173,507,1368,9911,3719,3115,8173,3244,8705,8315,9182,8315,9182,8247,8340,8700,9408,9425,8324,8244,8329,8325,8246,9233,9587,9183,9426,9111,9113,8249,8248,8245,8241,8873,8872,9427,9433,9436,8882,7986,7985,9438,3897,9437,3884,3893,547,3892,546,546,735,2951,9378,4405,6441,554,7300,3073,9418,7024,8627,8088,6688,3883,573,3884,10228,10336,7985,549,550,6386,539,9483,7987,10072,10649,1765,8971,1771,5839,1767,7704,7706,1765,9949,2605,1769,11028,3877,10607,1768,1766,531,10044,9502,2822,6489,10963,2779,2785,2786,2791,2778,3359,2799,8192,2816,2522,7698,6596,510,4146,10067,9633,10922,10923,10924,10433,11017,8582,2808,2812,2781,8154,11071,11068,11067,9555,9554,8241,8244,3784,2817,6354,3070,3073,3071,6688,6689,7752,7753,8627,8088,11161,9037,6526,11238,2820,6521,2794,2789,3891,3877,4305,2818,9665,10053,10544,10975,524,11221,526,9383,9867,529,6855,10232,8943,11407,8316,8944,9418,7881,10644,11390,11393,10640,8878,10645,374,11422,11109,11406,6538,11320,525,6537,538,6536,535,6535,542,6534,540,11321,6506,6505,6533,6532,4599,4598,8727,382,735,9184,9679,8596,6442,2824,7999,7998,10857,10866,11523,11131,10930,10931,8618,9084,8585,7870,7631,8584,8948,7808,10265,1685,5297,5386,6216,6497,8566,10433,8729,381,7024,8729,8584,8788,10056,10522,7721,8728,10520,4390,9909,8922,9767,10502,8584,7870,6198,9522,1266,9521,6042,9515,9517,550,10637,10794,10793,10639,10791,10646,10790,10519,10846,9084,10980,10545,8618,3066,11017,9624,3018,11052,8917,9651,6501,7608,10326,10970,10327,7300,10645,10607,10753,10329,10324,10562,11089,11218,7808,9084,10827,7610,10520,10521,10669,11101,11049,6354,10728,10336,9880,10642,10644,10641,7631,11321,9084,10328,6354,10752,11320,11050,11493,10637,11432,10141,10643,8842,5419,10827,7808,4320,6354,9865,11017,8971,9233,9555,8816,547,549,550,7592,6042,536,537,539,510,8820,9438,9437,10354,542,541,540,548,543,10607,553,532,531,529,528,525,524,8247,533,11242,554,526,11137,11049,527,4486,4473,4470,7168,4464,4463,7677,7167,7163,7166,7165,7164,7174,7173,11254,11251,11229,10925,10920,11186,11184,11182,11231,11177,11179,11181,11252,11175,11176,10921,6518,11173,11174,11037,11183,6519,6523,11178,1704,3442,7698,7843,7844,7845,7868,11185,10924,4297,4298,4299,9631,7843,6220,3883,3896,3891,3893,6493,3885,3890,8273,3887,3894,3897,3892,3888,3884,3889,3895,8274,10922,6537,6505,4296,6506,6536,6534,6535,6532,6538,6197,3515,10923,529,541,531,545,542,540,539,538,537,536,532,543,528,527,526,6042,553,550,548,547,554,9665,10053,10544,10975,11221,10948,549,535,524,10947,8240,6533,6532,6042,11241,10194,525,8332,9432,9435,10326,11240,11156,9431,9434,11241,9427,9428,11242,11406,11405,10326,8243,10606,547,11153,10560,11160,8327,8311,9416,9412,9409,11046,11151,11154,10556,10201,10139,11161,11054,11055,11139,11152,10559,10562,9593,9908,10136,9891,9894,10096,10101,10103,10102,11154,10100,11407,8245,9414,8325,8319,9415,8332,8318,8307,8249,9410,8248,9424,8247,9425,9426,8246,8308,9182,9414,10326,11153,272,4146,2781,3874,2779,2780,2785,6443,10963,2787,2791,9436,2778,4224,9589,9183,8883,8330,10926,10927,10931,9383,9867,11109,8945,8946,6688,10232,7600,10928,7636,810,8327,9430,9592,10137,10645,10643,10641,10639,6198,6199,11430,11252,11176,11218,11493,8586,8682,9084,7546,9407,9920,10565,11147,10238,7694,8584,8585,10463,179,178,177,11324,11219,10938,10750,7631,11019,8618,7870,9993,11455,7810,9655,9554,8443,8050,11369,9520,9522,4752,10229,958,3493,7761,8793,9925,2261,8222,9195,3595,7019,9661,6710,3059,6876,1461,1520,11644,9418,180,233,10278,10823,566,173,28,11228,1370,1210,1207,956,1056,466,3872,2451,1741,923,57,1533,3392,1234,1145,3189,2725,1398,2736,9675,1198,2776,1425,9533,2677,2995,3014,4762,4784,4785,173,5089,4788,4690,8894,5756,5112,5143,3189,2992,5756,5251,7172,1537,7304,9453,9052,24,3327,3860,10526,4234,8798,8893,501,4701,5996,10375,3048,11812,5179,3989,766,6261,4708,3830,9378,4779,947,4731,4519,4029,8220,6740,2632,9300,10836,11121,5799,10056,11690,9879,9030,1616,9980,10050,10473,10065,11020,11235,8999,9937,10568,5339,5545,11495,7126,7920,8548,5817,7883,4460,608,2933,1699,6858,3080,7839,9372,10243,11784,1347,4258,11747,11748,11872,11493,11899,11722,11836,11644,11869,11816,6117,9648,10930,9657,11838,10734,11593,10744,8885,7807,6821,11354,9555,11871,8436,5995,11355,254,11981,2294,10569,10543,7919,11965,11356,11873,3066,11984,11357,7238,11645,8220,3244,3003,11423,10342,7592,3376,9590,10563,10923,10140,10147,8308,10924,9435,9436,726,5864,6504,10594,10596,3066,10600,8885,7014,6381,10522,10922,8586,8682,9920,8618,7891,10612,6191,10996,10998,10193,10197,10195,10200,10597,10640,10641,11054,10645,10639,10838,10753,11139,10999,11011,11012,10993,9410,9411,9416,9429,9430,10139,10151,10153,10176,10637,10199,10642,11055,11138,9232,11049,10799,8875,9113,9114,9182,11157,11158,11159,11160,11154,8662,11155,11057,11153,11156,10800,11008,9587,8325,8596,11152,10201,8324,10557,10556,10558,10559,10561,11161,10562,9589,9593,11242,11240,11046,10801,9588,10333,11238,11207,11151,11218,10727,11149,11241,9781,10646,11204,3784,7568,7569,7570,8330,8331,8336,8339,8341,9633,11209,11244,11245,10644,9087,10337,4804,6221,6497,6214,6220,6216,6501,6218,6215,6499,6212,2720,11203,11269,11205,9593,10323,11183,11178,11231,10326,10198,11184,9137,11301,11206,11176,10102,11009,8309,10096,10322,8872,8242,8327,9424,10334,9891,10218,8335,10214,8329,10920,10646,11320,11322,6538,6534,6532,6533,6536,6505,6506,11318,8883,1730,7169,10827,10828,10750,10829,9426,4714,11242,11167,11238,11295,10139,10752,810,1266,10725,10729,10522,11317,10557,9430,9592,9535,9894,10101,10102,10326,11405,11157,10556,11048,3896,3895,3893,3889,3885,3883,8272,6493,3897,3894,533,532,528,527,526,525,550,548,542,541,540,3892,3891,6042,553,539,531,524,3890,3888,3887,3884,11296,4510,6381,11430,7986,7987,537,8274,10137,11467,10321,8764,4558,8111,11432,3881,11407,10324,11022,6214,6223,10801,11247,10643,10647,8273,10466,8682,7546,11161,11405,4791,6223,11493,6518,6519,6535,6537,6372,6371,11294,6498,11254,6496,11139,10560,10201,6215,4555,9108,10822,11394,11584,11585,11586,11590,10216,10562,11574,11591,8335,8329,9412,9409,8332,9425,9427,9428,11617,11624,11625,9431,9432,11616,11615,11241,11589,11591,11601,11375,11650,11425,11575,11580,9905,11588,11592,11229,10921,11173,11174,6521,11429,553,550,542,541,540,539,537,533,532,531,528,527,526,524,545,543,538,535,529,554,549,547,9520,9521,9587,11321,11611,7546,11493,1768,1769,9880,1766,9920,11427,11697,8294,10321,3066,8294,6212,6501,6496,6214,6221,8883,6223,6222,6216,10216,11054,11156,11154,10639,11723,11618,11677,11759,8340,8334,6042,3883,6456,323,6453,6455,6454,6390,11650,6995,10371,10138,8331,8320,8327,11571,11030,11696,11031,11695,11032,11461,11460,11033,11406,10925,8273,11799,10520,8585,9149,4390,8154,11069,10257,10521,11078,11079,11080,11081,11077,11051,11791,6354,11576,7194,673,11075,10797,3070,3073,10053,10975,10544,11221,11587,11324,8244,545,535,11205,528,525,9906,9970,526,11209,536,527,533,1080,11030,10251,389,10402,11031,10253,529,532,6354,538,542,540,541,531,537,6042,7374,545,8585,542,527,533,540,524,541,538,532,6042,529,536,537,9084,539,531,8586,548,547,554,550,3890,8824,3879,549,3885,10640,10647,10639,3897,3891,3889,3892,527,531,9084,542,6173,7565,7565,7565,7565,7565,7565,7565,7565,7565,4154,11238,3389,7986,7987,533) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC