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,7834,7812,7879,7836,7878,3131,3428,6521,7663,7764,7762,5091,3520,7570,7246,7569,1656,8071,1770,7151,6531,7650,7649,4301,4293,4289,4299,4286,4305,4287,4294,4292,7643,4302,7963,4297,4298,2766,800,5024,7079,1085,6103,6780,972,8300,5371,8531,1086,7599,3519,979,7906,8587,6532,4804,8836,8814,1667,6306,8520,9038,8816,6618,9030,8092,801,7808,7127,8111,1089,7754,7554,7587,7037,8358,3744,217,8434,8523,6521,8438,6691,5965,8535,6805,4784,8439,8435,4234,6533,8556,4432,6532,8361,5732,6223,4224,8323,501,8324,8596,1536,8425,8325,8404,7570,6751,7762,8249,8248,8322,8245,8318,5235,8246,8683,8317,8323,320,8319,8247,640,8597,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,8896,6197,8728,7188,6023,1765,7187,7567,7569,7570,7762,8165,7235,7721,650,7001,6565,6076,6544,6669,377,7230,5996,6122,3879,4714,7855,6998,5735,943,6031,2571,6993,1537,2473,7237,6444,8168,2530,7231,772,6675,743,6678,6575,7051,6827,8230,7232,1829,7034,7224,6571,3843,8512,8541,6421,6882,6422,3778,6425,2469,7779,6424,4219,652,7758,7635,567,986,7228,8142,3429,6191,3351,6937,6726,6933,1967,7856,8290,6023,539,3892,6562,3891,3883,1461,313,533,6736,272,223,8542,3885,41,7019,7986,8434,7985,7813,8324,7024,6354,9300,9936,5421,10032,8003,3877,8585,8883,7870,10214,8682,10099,10158,8618,6034,10238,7588,6386,510,7772,10041,173,1160,1441,10344,3825,10519,5096,10644,10607,10325,10563,9521,9520,10555,9515,10551,10640,10797,10836,10828,10796,10545,10794,10795,10793,10791,9386,10522,10790,10829,8717,9191,10750,4302,4463,3890,8273,10846,8260,9192,11019,566,57,9534,10300,2389,367,9775,9692,6272,9304,9710,1770,9407,8584,10214,10335,10215,10216,10213,9632,9868,9501,9084,8682,10334,9430,9587,9591,9593,7764,10199,4804,8323,7762,7570,8585,8719,8717,9590,9535,7569,9588,10139,10346,6371,6518,6519,9119,10202,7631,10331,10432,10521,9429,1770,10565,1765,1770,1771,1767,10247,10637,10639,10646,10641,10645,7844,10752,10753,10552,10257,9905,10644,10750,10328,9631,6201,7870,6199,9951,9407,11046,11055,11047,9949,11050,11056,11054,8324,8596,11019,11072,9084,10800,9590,10801,11057,8584,10324,10327,10333,10329,10331,10213,9906,11033,9970,10043,10253,10255,9907,10256,11030,10925,11032,6197,6198,7698,11037,6199,10552,9632,10561,7772,9493,6532,6534,6535,6533,6505,10239,6506,11069,8154,11174,11173,11175,11185,11176,11186,11181,11183,11182,11184,11178,11179,6198,11176,11173,11151,3073,3070,3071,6689,8946,6688,10053,9665,6499,1765,9411,1730,9555,7963,8665,7698,6496,1771,1767,2780,9213,1769,1768,1766,6746,6222,4512,8154,10098,4121,3896,3070,7693,6381,3073,9377,2520,6689,6688,8946,2780,8278,4701,2778,4287,9377,9592,2816,2787,2786,2802,2801,2783,2782,2818,6354,2820,8983,2812,4302,9799,7752,6193,8627,8088,9996,7753,8727,10053,8943,8727,8944,7881,9679,9037,9665,9822,9037,7696,7881,7610,9679,4305,4286,7694,4297,9905,7695,3442,4304,9909,9903,4300,4291,4287,4298,4293,4296,7963,4290,4289,8945,6688,9867,2791,2828,9867,2825,2785,6489,2823,2826,2824,6197,9632,10232,9631,9633,6201,8946,6198,6200,7608,1704,6199,6538,2822,2821,6534,6535,6537,6506,6501,10139,6532,6533,6536,8323,6214,6216,8278,9534,9536,8276,8275,10176,8003,7782,2815,735,9781,8589,8007,10044,397,10257,979,6443,9011,8667,3898,7636,9129,8566,10372,848,1368,10072,7580,9300,6740,3841,7238,10220,9300,324,4701,10056,9383,9543,10552,10544,2749,9072,8991,3877,7762,4,4520,10647,10612,10646,8946,10641,10642,8871,10260,6311,7024,1230,10531,3425,9669,9624,9131,9671,9670,9673,9672,7171,7172,7170,7174,7165,7173,7166,7164,8681,8698,6528,4146,8817,9888,10861,8,3874,6259,7677,10836,9300,4224,8888,9304,10914,10954,8432,10963,9338,10856,10857,7772,510,7771,7770,511,512,10818,7637,9473,9475,10298,10924,10067,10443,5995,4178,446,10212,9418,1257,10098,5459,814,9667,7903,11109,7143,11121,5995,173,7636,365,392,11263,8681,5386,8698,1411,1266,8817,1685,810,5297,1685,14,6076,8154,8816,4512,8683,8594,10431,24,1210,8815,5792,10520,834,30,8730,7567,6689,7569,7570,7762,7764,8826,4804,9720,1589,2766,8822,7006,8278,10188,9906,9958,8814,10043,9970,10253,11031,10256,11032,10367,9354,9907,9629,10254,9630,10251,8826,10432,801,8358,9601,7959,8142,10868,223,9789,2818,10255,5484,2824,8814,2812,10569,8257,9348,11028,9678,8293,8520,9924,6113,3465,10146,11237,9221,9374,9807,9808,4639,7953,8809,4639,452,9000,11414,10877,9215,11388,11437,11443,10697,11163,11477,6689,11129,11600,11656,11658,11660,11659,11662,8888,10892,10895,11488,6538,6533,6534,6505,6536,6537,7567,6506,8650,7027,9791,9591,4804,7762,7570,6768,7764,10567,9791,7845,9631,9455,6212,6215,6216,6499,6222,6496,3846,6220,6223,6214,6498,9483,6497,4296,4304,6501,7963,7698,7844,7695,7610,7608,3442,6218,7696,7868,7843,7694,7693,6512,6520,6521,7569,4293,4294,7697,8323,7844,1704,8655,8692,3070,3071,7888,6689,3073,6354,1771,1765,10828,10546,11142,6697,2779,2803,2791,6443,10963,2787,2802,2817,2799,4486,4473,4470,10687,4464,4463,7166,4316,7168,7167,8520,5484,1782,11354,4338,10868,10330,10555,10330,10559,9535,10336,10336,10801,10728,10800,10727,10558,10335,8589,2820,2828,7987,7986,4291,10448,10331,10333,10158,10326,10324,10555,10335,10336,8591,6359,10725,10729,6510,6508,6509,6507,10519,9493,6532,6533,8899,11055,7189,11015,7185,6654,8897,11013,4386,7187,7184,11016,10278,10823,10924,10920,6200,10925,2605,9909,7845,7844,10922,11037,7764,7843,7570,7569,7764,4804,7567,9632,9633,6511,6515,11138,11139,8662,9232,2789,9536,2799,2816,4473,7165,2806,2824,7173,7174,4470,4486,7166,7168,7169,7167,10213,4463,4464,7163,7164,7170,11030,11031,10251,10254,9907,11032,9906,10043,10253,10256,11033,9592,11032,10255,9907,9970,10251,8246,8247,8241,10606,8245,1765,1770,11203,11204,11205,11207,11208,11209,1765,1771,1767,1769,11206,11208,10463,7870,5635,7604,5657,8883,4486,4463,4464,8662,7165,7169,11255,7168,11251,11252,11176,11186,3070,6354,11177,11175,3071,3073,6689,6688,11109,10232,9383,9867,7676,10931,10930,7600,10157,10155,10154,8432,9670,10156,9669,9670,9672,11178,11231,11229,11414,9665,10877,9720,10956,8717,8719,6730,11374,10827,2605,4390,10545,9137,10827,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,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,551,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,551,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,11175,1769,11149,11157,10606,1928,11241,11185,11176,11154,10849,10868,10970,11184,8175,9416,10323,9184,10216,8303,8596,1770,10489,10229,7695,1303,7693,8002,10251,653,10389,14,7702,7752,9589,10139,6688,9588,9429,10432,8946,653,9037,8627,10200,9383,3070,10199,9587,8290,8088,6212,9430,8945,8946,8325,8944,8323,7881,9593,2342,10562,1771,10558,1770,10559,1768,1769,10201,10557,1766,8668,9215,8885,10556,10161,7696,8436,10560,6689,8324,10640,10641,9535,6600,8946,10638,10645,10726,8175,9631,10643,9632,3511,9493,7881,8945,8944,9665,10555,10336,10975,9679,8088,8946,8945,7881,9031,8727,9587,9430,7134,9867,4714,10544,11009,10975,8946,10940,1967,7869,2506,9985,8489,8662,10927,10926,11046,10929,538,531,539,10335,10930,7881,8946,5810,510,8489,9867,9679,10544,9665,6354,10975,8946,3071,6688,11022,7869,6272,11047,11167,2506,9985,10931,7600,7567,7770,11239,11254,8278,8478,10647,10644,10641,10640,10645,10646,10642,10940,8946,7881,7546,8682,9084,8618,11051,9473,7567,7570,7569,7764,4300,4299,4304,11218,10298,10238,9475,8584,11019,9920,8585,11405,9473,11194,11139,7869,11296,9985,10298,9625,9475,9867,272,6216,8965,11325,7677,9626,6511,8946,6688,9473,11592,6512,11677,6200,9633,6198,6199,272,6197,11252,11251,11186,11177,11176,11175,1770,1765,1768,1769,1767,1766,11229,10176,11231,11179,11178,7569,7570,7762,7567,7764,4300,4297,4287,4289,4294,4301,11430,11429,4293,11728,7845,7844,3073,3070,6354,6688,11836,6689,11792,8946,3071,7752,8088,8627,9326,7753,9037,6689,3071,8946,3897,10647,3885,11722,11427,7721,10520,8436,11677,10828,527,7986,7956,11319,11723,9905,549,8247,11299,11185,11050,10326,10330,10327,9909,10433,10238,3066,11182,11587,11209,11205,11203,9518,3891,8339,11204,8274,4464,11407,7677,3888,10562,11425,11184,4714,3894,7546,6520,8326,10336,8244,8585,11181,3898,11175,11183,11176,7764,8271,3896,6197,8245,11430,1769,3887,6040,3882,8272,1768,6040,6036,7167,7165,1767,6493,10923,6505,11497,11931,1766) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC