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,1768,6519,6523,5864,1766,6532,2720,6498,6507,4300,6222,6497,6515,1767,2795,6200,4301,4936,6503,4305,6371,6529,4301,2720,4293,2780,2785,6504,2783,2778,2781,2779,2782,2784,2786,4290,4298,2787,6530,4300,4282,1766,1769,2818,2824,1764,1767,6263,222,3071,2789,6489,6531,4286,6354,3070,2823,1245,6198,6201,6199,6200,1767,1766,6354,3073,7137,511,7299,7300,7134,1767,2808,2803,3888,3885,2791,2820,2801,2802,2805,2807,2806,2794,6546,1769,2826,2827,2828,6514,1245,5576,1351,2869,834,3884,3882,7160,6515,6456,3891,3893,3896,3892,3890,7567,3897,6493,6271,6507,2720,7300,2677,2995,510,6523,6371,6743,3029,7548,6218,6199,6373,6223,6527,6201,810,2522,6354,6546,3070,7751,6689,3073,3071,1769,6750,7599,6746,7870,6749,2018,7753,6751,3889,3882,6599,374,810,379,391,387,6066,384,378,382,375,394,376,6082,1266,7215,7054,3898,1250,4178,5647,7752,6354,1766,7598,7600,7676,7137,7631,6809,4445,4827,4512,6354,3070,3073,3071,6689,550,7677,7168,7167,7170,7165,7163,7173,7164,7959,7922,7054,6985,7752,1767,1765,1769,1766,6168,7986,2522,1741,6354,8233,6880,3071,3521,2389,3070,8272,2822,2823,2826,7238,8245,2728,2893,8294,7787,8432,344,8316,8220,8313,6509,6508,8307,7238,1767,6197,8520,8514,8315,8318,1769,5909,6520,8233,8246,8334,6521,8331,6513,6514,6507,6515,8358,4639,4535,5576,2869,834,1351,1741,8481,6505,6261,3913,3085,8698,8681,3850,5647,8682,6534,6537,4178,6535,8730,8520,8333,8649,601,2170,2390,3610,8342,6641,8596,8691,8814,8817,8815,8520,5996,8142,567,7634,7635,5551,8617,8719,2520,8591,8717,2522,8681,2522,8681,8780,8944,8817,7881,9041,8683,2253,4535,8826,8682,8945,6168,223,9030,4639,311,8358,8698,4834,2992,8175,6691,8727,2925,8551,8681,3913,3172,9390,1232,3165,4178,5068,9736,10297,9390,9951,10364,10238,6971,9334,3646,10353,6209,9934,8514,3731,10164,9084,223,4639,6250,10527,7554,7592,4218,8555,6712,5567,8290,10505,10656,3646,10547,10531,7910,7756,10339,9669,10364,9670,1257,4178,446,5376,222,9543,10865,10654,10877,6611,10296,10786,8306,7636,3830,4796,5236,455,464,4234,4128,4178,5279,6431,1453,6400,1537,3337,766,6195,4178,5995,6001,754,6587,5996,2158,6008,3644,223,4566,1343,6381,323,3860,397,2594,4656,6766,1826,975,6394,3964,6593,858,6986,990,3989,1591,6842,6947,6140,6941,6010,6985,1402,2261,766,5070,6349,6793,5882,1461,5331,6757,6779,6812,2374,6115,6631,6658,4099,4656,6779,6971,7003,217,6850,1029,2474,5530,2000,6951,1371,6996,958,5371,7019,675,3100,230,6312,7034,7148,6569,1917,6168,924,3595,6103,2915,3059,834,239,7226,4947,6813,3493,1461,4796,1558,1520,6141,836,850,3860,233,1785,1537,6431,6951,1776,6275,7739,182,2932,2000,6445,1084,5339,1521,3625,7156,4995,797,2446,1462,1779,1785,6400,3037,2387,2117,7761,4529,4659,8222,8128,3542,1070,7897,4639,3521,7050,1490,2029,4079,7783,8097,4405,4834,4259,8558,1890,6818,2117,8518,8611,8109,6631,1349,8535,8388,8629,5552,4218,1811,3850,8793,7976,2737,8839,8852,7918,734,3823,3966,6667,1558,8305,6814,8889,7602,7147,8183,7307,7795,1772,186,1774,6715,3302,8684,933,4991,314,6366,8281,9340,5769,2009,6583,6438,8561,3519,3554,5305,8978,9344,9290,9197,6700,7903,6255,6552,9453,8781,7048,6631,3520,6642,344,9776,8089,3557,9776,4849,2390,4087,9248,5046,9922,2122,9900,9910,9661,7759,9776,9928,7825,9308,36,9986,7998,10229,9798,1303,10063,6113,2989,9449,5891,2170,8816,6641,10346,10280,9552,9538,8586,10001,9602,9916,10469,10127,576,10292,10500,10375,9513,4349,2158,7173,10548,10526,10654,8956,10579,10652,10775,10652,10747,6562,10719,10894,10227,10297,10871,1765,1767,1771,1768,1769,1766,9154,9518,10670,6354,7922,3883,8272,779,10354,11041,10314,3073,6689,3071,8316,7557,8627,8088,11021,9037,7170,9945,7174,8241,9665,8333,8946,8244,10742,10924,10528,9665,7912,11239,5994,61,11104,10578,11364,10454,8914,8833,8869,7897,8781,8960,4395,5602,8512,8841,7359,9078,6750,7671,7671,3889,8771,8771,8047,9206,9055,9204,8832,8832,7106,6218,8473,8055,8055,8055,8055,8055,8055,4298,4304,6928,6932,6934,6938,6936,6935,6604,9088,7195,7199,7198,7162,7191,8825,1730,6596,5961,4292,9067,4259,2084,8168,6491,8387,8582,8352,6967,6966,4614,6970,7966,6965,6415,6968,1557,6272,6385,14,6450,3380,8831,3247,5882,8490,4501,7816,6396,6656,6383,6076,7904,1663,8821,9631,1616,3358,7632,9767,6787,8542,5545,5339,4258,3080,5817,7126,1347,8548,7883,1253,4739,4045,6740,7238,9000,8220,4460,9937,8434,8542,9212,6772,6593,1746,5912,7640,7505,7437,7437,7561,7561,1992,7497,1981,1981,3881,7985,6493,3893,8272,3884,8274,3890,3883,535,3894,3897,3892,9493,1767,1769,1768,7299,2520,1766,9892,9534,6512,6511,6509,6510,6508,3885,3070,7753,7753,7753,7752,9502,9502,4788,5821,1764,7115,7906,8063,7068,8712,7085,8048,8368,9083,7080,9053,9148,7244,9057,7944,7287,7287,7111,9259,7282,8404,8713,8044,7152,7671,8080,7935,8460,8709,9398,8652,9225,9225,9560,7279,7279,8364,8364,9755,9225,7080,8408,9199,10030,8364,10023,8363,7266,9956,9302,10076,9999,10024,10024,9956,9956,8229,10046,10278,9421,4624,9980,8782,7654,9813,9878,9755,10577,10811,10768,9794,9561,10767,10769,10869,9316,10833,10854,10757,10855,10770,11038,10675,10890,10854,11210,11210,11262,9739,9875,9874,11335,10623,9873,9873,11225,11514,11331,8205,10572,8063,9739,11692,9386,9031,2052,7214,4639,9049,7155,9258,3389,6547,6823,7172,1765,1771,4302,9485,6199,9632,9633,6354,222,3073,1351,8946,6499,6214,10208,3385,2387,8714,7698,10663,3071,6497,6689,6496,6212,10731,6221,6218,6498,6501,6223,6898,272,8820,6388,7311,7610,6600,6416,7922,8944,7881,9679,10232,6416,9383,10427,9867,6386,10232,10431,8566,6377,545,3887,537,7703,14,6200,7166,9902,8885,8693,8732,726,810,10613,10386,9172,10387,10098,9734,10420,9905,9735,10638,10383,9601,10429,9909,9087,10643,8011,10645,8696,10432,10644,10640,365,1411,4614,10421,10637,10334,2701,6332,10389,10433,9733,10520,10443,6381,6380,10431,7192,7190,10213,10222,10162,10725,9892,6385,7715,7014,6382,7040,2287,6933,9591,8665,10238,9903,10565,10044,2605,4178,6519,10561,5995,10043,9500,7705,10239,8713,8713,8737,9832,8241,10545,5332,6216,6501,6214,6220,6497,6499,6215,8310,3892,10644,6898,10520,6656,6496,6212,6222,6223,6221,6498,7100,7091,6218,7698,8361,3898,6359,10827,7660,10941,10942,1327,9649,10922,10937,9125,11069,8584,8585,2520,7963,4302,7610,7134,1765,1770,10382,7055,9534,10822,3897,10980,368,1770,10239,10821,11255,10443,10612,6270,8878,9483,9143,6749,6197,4297,9155,3881,7632,9217,4296,11320,4464,6742,9156,4301,6745,4293,9154,8983,9231,4298,8980,10957,4292,8879,9151,4300,10646,9147,4305,9144,10640,4294,10645,9633,9146,5635,8729,6743,10639,4289,10752,10753,10642,10641,11427,10644,9792,11081,10643,10647,11080,4304,11321,4390,10545,10828,11076,11077,8982,8981,10637,11432,10520,9149,10827,10646,10752,11320,2605,1266,9137,10637,10647,10639,9949,1765,1770,11321,10645,11432,4390,11017,1685,11466,11218,8585,11723,11247,11252,11091,8980,8982,8981,6607,10822,5065,10921,10044,10045,10500,10386,10389,10612,7891,6854,6220,10387,6419,11390,11079,7702,6426,8342,4714,6936,979,4614,6656,7569,9909,810,11562,11493,11564,10596,10045,11394,11590,5383,6426,10331,11677,11137,11139,11173,11037,11174,11182,10924,11155,2787,10466,10920,7171,10922,11186,10829,11138,8272,10828,10519,11178,10827,10546,10520,4390,5332,5297,1685,9149,10522,9137,8274,5383,10925,3884,3881,3073,11375,947,3885,3890,7631,1730,11461,1766,8585,1768,1769,1767,7884,7374,11459,7694,11269,6898,6656,4555,11167,374,11299,7697,2520,2522,11425,6076,4923,4178,9300,10836,4296,4291,4304,4292,4289,4286,4300,4298,11497,9483,4299,4301,4299,9601,4297,2520,1765,1770,1769,1768,11069,6800,8780,2951,5484,9949,2520,10228,10687,11588,7693,10922,4614,10921,10790,11207,810,11591,9424,11458,8241,10606,10822,10499,11586,11291,7546,11904,8316,11906,8584,10649,9892,6102,6423,11254,11269,10750,8246) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC