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,748,958,6710,3989,1953,6593,1038,6779,6103,6947,3550,4131,6804,6842,6986,2261,6858,6863,6691,5142,6315,5995,6981,1461,7126,5046,7019,6548,7005,7214,7036,228,7138,6890,6632,6693,3702,7156,7221,7304,7050,6633,7143,7354,6104,3561,739,1521,7758,7760,7582,7718,7614,7759,7596,7709,6856,7830,7795,7359,7883,7804,7880,3625,7896,3609,7875,7751,7897,7995,7992,8031,361,714,8109,8032,7991,8183,8089,7839,8096,8102,6792,7559,8146,8222,8300,7938,8185,7920,8150,8293,8390,8230,8103,8299,1345,840,6642,8483,215,8302,8226,8548,2473,2467,8306,8526,8305,8358,8554,8611,6076,1815,8561,8535,8547,8514,8615,8629,8687,8659,8614,8479,8688,8802,8801,8632,8759,8744,8776,1920,8829,8807,8809,8902,8888,8901,8793,8999,8918,8911,9030,8841,8846,8900,8916,8925,8923,8781,2005,7912,4716,8686,9153,6715,1462,9086,9195,9220,1296,9296,9308,9198,3823,4671,9322,9324,9202,9200,9363,9348,9289,9291,9454,9420,9419,9258,9480,9453,9402,9372,9614,9335,9637,9376,9680,1380,8108,3337,9524,9552,9751,9763,5784,7849,9479,9810,9812,9674,186,9616,5956,9543,9062,9386,9829,9934,9879,9925,9668,9951,9904,9916,9482,9931,10041,10114,9913,9990,10142,9941,10042,10125,10149,10063,10128,10126,10115,10174,10020,10188,10245,10246,10236,10131,10248,10229,10208,10227,10211,10282,10148,10243,10244,10212,10065,10305,10319,10265,10279,9936,10269,10268,10338,10342,9603,10293,10436,10466,10290,10505,2635,10438,10491,10375,10488,10535,10526,10485,10127,10548,10528,10527,10569,10273,10627,10676,10631,5769,10339,10681,6658,10731,10760,1979,10775,10649,10841,3327,10294,10721,10698,10826,10839,10955,10940,10895,10687,10932,10766,10938,10802,11024,10992,10872,10987,10416,10894,10402,9925,11872,11902,11021,11027,10113,10817,5222,7266,7152,3647,7154,7660,7117,7110,7296,7278,3026,5729,7834,7834,7837,7836,7903,6632,3080,7665,1371,5516,254,7616,7146,8269,7660,8388,8441,8489,8526,6971,8611,7071,7258,8687,3368,8739,8734,8699,2590,2419,7585,7585,8193,6397,4767,4432,1349,7896,8951,5455,2023,8016,3990,9057,9079,5552,4103,9050,7640,4985,3384,9119,7388,9322,9297,9297,7106,3561,9377,6315,9212,9259,9471,8406,9455,7244,9526,1992,1992,6138,9660,9572,9614,7293,8948,9787,9814,9799,3646,9813,8477,9821,3217,7806,6588,6599,358,7840,7878,7928,7214,3465,5810,3519,4570,5421,725,7938,6160,2342,1826,650,6565,7147,1085,1086,3850,358,5915,7160,840,7240,7548,6589,6130,4597,2117,2628,975,2555,3525,8223,734,5419,3760,8095,8094,8488,6740,7034,396,743,7594,5602,8587,7783,6712,7910,7101,7275,7241,7280,7290,7276,1917,7153,5516,6710,1738,4061,4411,7830,1439,176,7992,3493,3613,1681,2669,2123,8193,7019,7938,1487,6633,7238,6365,6350,6660,4936,7878,6982,7795,7787,1200,7718,5915,2183,6983,3892,7592,7837,7546,6725,7143,1603,947,8095,7992,6589,933,3519,7995,8096,7938,6172,6159,8223,7240,6605,8093,8271,8226,8611,8555,3046,6135,8220,6766,1200,7882,6010,8109,6844,501,1461,2658,6726,223,8358,6733,6190,3337,8485,6740,7238,8220,8514,4061,6690,8659,4401,322,1591,1070,4983,2145,3850,7546,2933,7904,6768,1917,2546,8512,8230,3989,3830,5576,2473,2737,8551,6562,3216,7812,5371,7995,358,2029,8020,2328,6871,8093,6589,5915,6695,8390,8281,6122,6971,6350,6766,7795,7158,5956,2573,6812,7903,8230,8296,7240,6971,8781,8009,9010,8305,1453,3549,8019,9047,9063,8526,7910,4454,6809,9321,5371,2467,3549,6588,7938,8185,217,7995,8182,7837,7834,7835,7836,7992,3850,1184,8019,6979,5334,8093,6780,8305,8441,8222,3520,6712,8489,3131,8541,8555,2506,4765,8019,7840,7879,7878,6971,7753,501,7752,3282,1215,5576,3889,8088,3885,1967,1967,7903,842,8542,6631,7918,947,7773,1369,6584,6402,6069,1272,9376,8689,9405,6715,8389,1885,5995,801,156,3236,5795,3525,4913,5639,6311,9788,9497,9857,9951,4156,2453,9959,9778,9543,9637,9543,9637,9868,6010,9868,6010,9868,6010,5269,754,5269,754,3878,6173,7143,1453,7833,7903,7304,5477,2389,7238,6845,8005,8220,6315,1402,5688,3957,1536,7992,1327,8489,3644,9300,8948,7593,906,1349,5235,5810,1173,1768,4302,7599,7610,1165,7808,2605,4282,6359,1766,4614,3891,6493,3895,3879,4720,1770,3883,6354,3070,7696,7168,5810,4714,7748,7748,6689,3073,8618,3892,4784,1767,1533,2677,6740,7238,8220,9300,9049,6523,6373,6373,6373,8489,9031,9920,8583,4714,8584,7546,9407,9084,9084,8682,783,8618,7870,7971,9132,8393,1766,1769,1768,1767,1765,6740,446,1345,9569,9622,9158,7659,9621,8477,9622,9660,9563,9745,8769,8399,8288,4512,6642,7241,7272,7286,9813,8475,8049,9562,9767,9770,9247,9888,10040,10272,8059,6324,9093,7774,8955,7989,9771,2342,9609,2967,10630,10689,8151,9319,10696,9647,10451,10741,10656,7289,10441,8202,7671,8358,10679,11441,11225,10692,11331,11533,8050,9748,10274,9773,10273,10629,10869,7962,3823,8087,7081,5810,9320,9488,5770,5770,2029,2029,2029,2029,2029,3913,1126,1145,2331,4432,5996,8019,5251,3368,947,8220,5956,3875,4178,6768,6388,1704,8547,6218,6223,6521,744,1600,467,423,470,645,9770,9566,5312,8000,4830,4984,5218,4423,3136,4008,1474,1593,8894,9378,1460,1098,4164,4165,89,2760,4395,3370,1234,435,9533,9418,5306,3067,2904,1407,3541,4944,1662,8389,10102,10110,1593,6740,10098,10107,8305,6212,10269,2164,4788,9675,1425,5218,2776,9676,10054,1561,2904,7033,10442,89,661,1092,1318,1407,2904,3094,4165,8241,4301,10913,10983,10999,11008,4160,11009,11006,11021,11020,10142,467,744,1407,3541,4964,5312,8000,1098,4830,4348,1318,1593,3645,3797,5218,5170,89,4008,4164,1561,28,9655,4348,1474,744,9418,11409,10278,11402,1092,11228,4165,470,11252,1092,4984,1198,4940,9378,4943,11546,8995,9838,11610,2824,2785,2778,6443,5306,2904,6962,661,5306,2904,7751,11663,11657,1237,11546,566,4165,3645,2760,1600,467,11485,956,57,9533,10278,11228,11812,3370,3136,1593,1474,1318,1092,744,470,4164,8000,4008,3797,3645,1593,10002,9935,9829,8481,1990,6809,6760,7238,8220,10187,1371,9389,9258,9220,9638,10042,8901,10056,9300,10836,10416,10957,10368,10787,10836,11296,11254,4714,11301,2506,10212,10060,6550,7788,10211,10116,5913,1097,7910,5810,10736,1458,10707,8541,10649,4659,10296,1308,8290,2458,5567,5402,7828,2913,7775,916,9934,10986,6700,10176,8389,9767,8,8168,10466,7501,8489,9031,2506,9985,1049,10742,10033,386,6270,8881,8880,10098,381,11121,384,3894,3895,3897,8607,11098,11239,8290,7986,11301,3888,7987,11022,3892,3891,3889,11295,3890,3884,11299,6261,8272,3883,4300,4292,4294,4298,4301,4305,1770,4293,1765,1767,1768,1769,1766,11319,3881,3882,11317,6520,368,11392,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,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,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,7568,11218,10298,10238,9475,8584,11019,9920,8585,11405,9473,11194,11139,11296,9985,10298,9625,9475,9867,272,6216,8965,11325,7677,9626,6511,8946,6688,9473,11592,6512,11677,8983,8981,6743,3883,10222,1730,9165,9601,3898,9534,8982,6742,10167,6744,6746,6749,979,6359,7599,6768,5386,8879,9217,6750,390,8241,8334,10334,10336,10335,9920,10238,10194,10200,10263,8877,382,8330,8320,8339,8337,9891,9908,9113,10202,9111,8242,8873,8872,8649,10152,9112,9120,9431,8318,9114,9119,8326,8310,8247,8313,8309,8308,9633,5691,1685,5386,6195,1765,10546,10545,7845,9633,9903,9905,6533,2605,5386,1769,8824,10546,9909,9137,8824,1685,5784,10522,9137,9149,1770,8917,1771,1765,10925,8824,8489,1967,9031,5770,4714,10645,10646,10750,11167,10925,10922,9985,10466,8592,5810,390,8784,8788,8881,10613,11051,11248,11247,8882,7134,7877,2071,9303,9350,2506,11239,4714,11022,375,8787,372,376,368,381,6066,387,8858,385,380,393,375,391,386,6082,378,8784,394,6270,8880,392,365,8878,8786,8789,10896,11088,11327,11329,11182,11231,11249,6375,11178,6271,6076,379,6537,11173,11176,11175,5332,1411,810,10521,11183,10827,1266,6535,11229,11174,11186,11252,11185,10921,11238,11519,11295,11296,6505,11318,11294,11239,11254,11301,11251,11585,11571,4923,10731,6600,11085,11665,4520,11666,11667,11085,8175,10823,10278,7922,6354,6503,6523,11425,5383,11429,11085,10742,6261,2925,1967,7610,7311,10033,3515,11294,2824,2785,2816,2779,6354,3070,3073,3071,7752,7753,8088,6689,8489,10526,10649,10758,9349,9950,8541,8765,2009,7910,10937,8973,11134,7144,8171,11120,9031,9838,9005,10500,10702,186,9198,10314,8828,9951,6771,8816,11325,11283,11303,8922,11289,10875,3523,11351,11409,8434,11296,11167,11238,11247,11448,4076,9864,11213,10751,10533,10535,5782,11301,11294,9078,9915,11121,11608,10056,10724,10951,1969,11742,5402,10531,11768,9972,2389,11497,9985,3254,11809,8745,11304,324,4659,10966,11051,11238,10302,11101,10072,11603,11968,10297,5763,11239,947,9910,10128,9941,10148,972,10063,10116,10283,10227,231,10284,10039,10188,6700,8139,10303,10319,10268,10473,4023,9406,10306,10526,10548,2841,10547,10569,5175,9031,10362,10268,10368,9900,10002,10499,10528,10048,9832,9945,10543,10021,9126,10735,10375,10665,10208,10266,9212,4234,10290,10935,2639,10938,10541,10990,10723,10289,10919,10783,10653,10912,10895,10116,10904,10880,10871,10894,11021,3787,10892,11226,11202,2393,10115,11233,11135,10657,10715,11163,972,10778,1268,11136,10085,11220,2390,10683,11104,11287,11314,10739,11353,10740,10823,1181,11379,11172,9922,3482,10663,9249,11201,10627,11324,11443,11377,11361,10653,11439,10130,11442,11388,11474,10893,4217,4527,9629,9354,9630,9939,11213,9235,5692,10085,10879,11285,4652,9666,10341,10864,10565,11019,7169,10238,1766,4464,9084,7546,11218,8586,8618,8682,9590,10551,10323,10322,11050,10332,9434,11242,9435,10331,10327,10325,8531,7986,11241,3884,3885,3888,11017,8971,6263,11458,11459,10292,6836,6834,10328,6835,11467,11319,11167,11301,11299,11239,11301,11238,10176,11247,10466,11022,11254,11295,8345,9031,5810,4714,11294,11296,11493,10804,3888,10606,3887,11269,11484,810,11051,11181,7610,7698,10922,10921,10923,11518,10821,10687,11435,6270,390,6789,7006,6076,6880,374,11601,11460,11422,11758,11903,11590,10789,8362,11909,3217,2573,6618,1609,6623,6143,6332,6371,6149,6221,5430,5756,313,2995,6215,1210,6443,1487,2917,640,4419,6550,6636,340,267,754,6486,7131,7873,947,1663,2270,2135,3882,2446,1783,8480,8561,8559,8771,52,8910,7837,7899,7772,7150,7167,4464,3860,9309,9406,4395,6104,2117,4834,8739,9983,4029,7962,2632,7103,9833,9300,8062,7143,10865,11485,8545,11271,11782,9659,916,8271,2122) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC