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,3830,3989,4580,275,4860,1165,4234,3860,5535,726,393,2882,2160,4730,6154,1537,4131,5996,6545,1137,543,397,6138,6040,6559,4023,725,6686,6679,7879,7840,7143,7878,8220,5764,7903,8183,3784,3263,215,8222,6750,7998,7638,5995,3761,2467,419,6981,1506,501,2706,8306,3059,971,1215,4178,1257,7833,3134,3368,8542,8616,8488,7840,7879,7878,4259,8529,8306,5143,466,252,6204,6539,7631,7870,7582,4136,3542,8434,4788,7896,8611,8615,3413,2261,7641,7837,7615,7903,7834,9144,8983,6713,9300,8842,9130,7910,9547,6023,10119,9220,9807,10548,10244,9752,9770,10523,10526,9924,10300,36,10688,2605,6426,5142,1165,3898,3875,5691,3515,1108,6533,7215,2522,1656,545,6382,6390,6527,6521,6261,7631,6212,726,510,542,528,512,6869,7770,3515,6513,526,6198,2696,6498,4614,6497,6199,6223,4289,4293,4286,4282,4292,4291,532,4290,842,5903,6546,1266,1165,6359,864,3247,1685,1616,3384,540,5066,3380,543,8244,8249,7189,7184,6042,7180,6201,3581,6656,6652,3879,6733,6653,6223,6218,7176,1245,7179,7187,5332,714,4426,2917,5096,4490,7170,7172,510,7598,7596,7637,7636,8278,549,7188,8599,8329,8246,8328,8342,548,8597,8598,8320,8317,5635,4386,8337,6654,6198,6201,7241,1988,7697,1993,7134,1979,7693,6200,7133,6532,8268,8251,6533,6538,7610,8209,3250,6534,3327,7906,2824,7074,6506,6533,4804,7152,7764,7111,7567,6536,8418,4769,3515,8759,7693,8251,5770,7839,5386,1165,6359,5332,6521,4701,1266,6792,6201,6198,6200,6199,4282,4301,4299,4293,4302,4305,4297,4301,3515,7693,6505,6533,6532,4286,4304,1704,4289,7972,7973,6218,6501,6497,7698,6498,6215,6216,6496,6222,6221,6212,6223,8244,8249,8246,8243,8339,8245,8247,8248,8318,8317,8319,8320,8334,8326,8337,8330,8327,8315,8331,8335,8322,8333,8325,8324,8323,8336,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,8232,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,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,8232,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,8312,8310,8334,8309,8311,2779,3511,8314,4301,6604,3581,391,6066,384,377,6082,382,374,544,573,528,539,548,525,549,272,6381,6066,393,386,6082,6742,6796,6204,6220,6533,4146,372,375,673,6750,6751,6744,6749,6745,365,6270,387,378,376,389,6076,381,368,388,388,391,6066,384,386,6082,6082,390,6750,6751,6751,3220,3220,3223,3224,3225,3227,863,3882,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,551,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,8858,372,6076,317,3913,317,3913,6382,6523,8165,375,6526,8496,3879,7588,8989,8530,8163,8160,1380,3823,6854,6391,8159,8157,7300,7605,4701,8785,6144,6784,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,6420,2282,6911,3036,6967,389,6961,6966,1730,7897,1303,6951,3896,7266,8831,8529,6743,8165,979,8585,8833,8833,3702,3702,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,8728,7188,6023,1765,7187,7568,7567,7569,7570,7762,8764,6771,1165,7963,2520,4294,4282,8824,6201,6200,8885,6198,6778,6810,4297,1770,6198,6371,6521,6527,6372,6523,6223,6519,6531,5864,6518,6218,6216,6215,6496,6656,8167,6497,6386,6145,4931,8333,8241,8337,8883,8327,8245,8591,6607,6604,8700,3442,8342,8341,6223,8337,6218,8315,6521,6212,4301,3442,3515,7694,7695,8898,2795,8896,8897,7698,4282,6216,4302,8491,7733,6270,381,6223,6719,2474,3875,1411,1266,1266,979,979,979,979,7968,8203,8200,8200,8200,6377,7599,529,7654,7663,7076,4979,9407,6218,6768,9181,6201,4293,4289,4305,4296,4298,4294,4292,4290,6200,9631,7963,4300,9633,4286,7610,9632,7696,3442,1704,3515,7608,5951,2092,6609,3863,8251,714,7717,7269,4337,984,7287,6769,8063,579,2023,2023,8182,8220,7262,5732,6840,359,1524,7861,9057,6738,2546,2122,397,9499,8672,7068,9496,9502,9763,9063,6656,665,6382,8744,6151,223,6961,3090,452,9453,452,9453,452,9453,6469,372,9883,860,2490,9989,1296,8683,6545,6371,7082,5245,7666,5245,7100,8724,7665,389,7632,9493,9631,9632,7654,9502,9633,9048,9343,8737,4282,9438,6768,8780,9437,7032,9903,9924,9469,9792,3893,3894,5770,5770,5567,3881,1526,3890,7986,8358,8325,11009,275,11201,9383,7610,9867,5691,7881,8943,6199,2522,8944,2520,9633,6519,4701,1779,5386,9555,4920,1767,5188,9493,6534,3883,6506,7985,6354,7986,7751,8618,8682,7973,450,8257,1770,1765,1771,10638,10646,10641,10642,10643,10640,9665,10544,9499,9217,1768,1767,10565,10840,4580,10900,11083,9402,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,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,7568,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,6214,4299,4293,4287,9726,5718,1616,4291,1770,9951,4300,4289,7173,7170,858,10505,10526,10527,10522,10534,10436,10502,9632,6499,6220,10296,9838,6200,10563,9631,10440,6199,10438,3883,4804,7762,7567,313,2696,272,9892,9493,10612,10045,4769,10645,10643,10640,10536,8717,5769,10644,10607,10641,1153,10639,5068,7570,10637,10335,4614,6010,4224,6332,10552,10647,3884,10677,7764,10339,10486,10371,2005,10424,10161,6752,9829,10444,7917,10208,10579,10290,10515,7600,10696,10797,10750,9523,10821,10796,9903,10794,10795,10793,4144,10790,10239,1351,10678,7894,10649,7888,8563,10332,10327,10607,10328,1411,7567,2820,4297,10558,3515,10563,6201,10218,4299,8332,10158,5386,7569,10137,3442,10099,4292,10333,2826,9593,9430,10200,10560,7696,4293,4305,10322,9114,9426,9181,9424,9409,4298,9112,9113,8883,2824,10136,9894,9633,4304,10215,8662,9908,4294,6200,2825,10218,2823,8727,1765,9120,8326,8627,1771,9626,4296,1768,7174,9037,6689,1767,2808,1766,510,1771,9473,8944,9669,9407,7752,7677,8627,9920,8432,9474,10154,10725,10642,8971,10139,9665,9475,10155,9601,10298,10729,9493,10238,10522,9383,10637,9867,8586,10152,5576,10877,7636,10232,4386,848,1368,9687,10828,7580,9031,10641,11048,11008,6800,11000,11046,7870,11088,11019,10329,10864,9854,9911,10645,11007,10565,9912,10463,10647,11047,10866,10923,10646,10154,4464,11014,9046,7019,7165,10155,7166,4486,8780,9215,4470,7761,10157,7677,10156,7551,8222,2818,10519,11051,8793,4855,2816,11109,11183,3897,10102,9114,8331,8336,8529,8335,8530,10322,8832,365,3893,10334,10335,9633,10100,9632,10607,8307,8273,9411,6199,10153,9631,10332,6200,10152,3897,6198,8274,4304,3884,4305,3889,4291,3891,4292,8272,4286,3896,4300,4298,2520,3895,2522,4299,9483,3888,3889,4293,3881,7963,3885,4294,3894,4297,3892,4287,3883,6493,9192,3887,9409,6538,9182,6537,8334,6536,8874,6534,8599,6506,8329,6505,8699,6533,8700,6532,6359,810,1765,7808,1770,1771,1767,1769,10799,1768,10551,1766,10336,10101,9418,9412,10102,9533,3872,8586,10436,9976,10365,8559,272,6715,9857,9633,9632,10232,5435,10698,9857,9667,10731,4435,313,4769,8710,10831,9946,5435,8964,9534,8003,6332,8278,10727,10563,10559,9231,10646,10812,9892,10044,10426,10487,6212,7843,10417,10489,7844,7845,3890,10545,10389,7196,384,10381,6443,10520,8579,10040,6517,6216,8242,10925,7704,10923,10729,9181,10560,10199,10558,10557,10200,3894,3957,1764,10823,8882,11080,4302,8274,8250,11091,4512,2555,8696,1086,4316,5003,10318,2039,4774,9386,2998,10486,6535,9493,11153,7299,10045,6143,10935,9903,10828,4827,5208,8878,7171,4798,735,7174,7172,7170,381,8880,10176,3442,7173,7677,380,9624,8154,730,10321,810,4390,8824,7808,7697,8154,7694,8002,4298,4289,6354,10327,8584,3070,8649,7546,10519,8618,7843,8682,9084,1704,7870,9407,7844,10238,7631,4121,7845,9920,9632,7695,9920,9633,6199,6200,6493,7986,9631,6198,7985,6201,7987,8272,6260,3884,3883,3892,3897,8154,9905,3881,9909,9119,6526,8260,6520,6521,6373,6503,6523,10924,6504,10920,9903,8321,8241,10324,10563,10331,10329,9522,10333,10331,10329,8244,10323,10921,10922,4293,4282,4294,7963,4287,5792,3442,7696,6855,10565,10827,10750,7698,1766,6214,6499,6218,6221,9920,10238,6212,1766,9517,6496,6501,9515,8154,6216,6223,6497,6215,11069,6222,8586,11067,9084,9522,10333,7696,8878,9232,10970,7170,11019,7173,7167,9515,9517,10563,6200,11081,11075,6198,6201,9920,9633,9407,9632,10827,11076,10822,10923,10828,11218,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,7568,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,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) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC