this<h2>MySQL returned error</h2><hr><br><br><strong>Error Description :</strong><hr>Error No : 1064<br>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<br><br><strong>SQL Query<strong><hr>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,9535,9591,2778,2783,2791,8591,9588,1770,8899,1766,9590,6354,8946,2823,3073,3070,3071,2828,2824,6689,7810,6220,6688,6221,9299,7083,8088,8087,7106,8627,9037,8071,9793,8594,4752,10056,7169,8618,9906,9349,9970,10253,9149,1769,9418,8306,4178,9907,8820,1257,1210,10256,7100,7092,151,10254,8683,8816,814,5567,8894,9873,52,5995,5227,7714,9401,4784,4788,10347,5839,8460,3493,675,5516,9601,10342,8716,4639,8583,9429,9407,8618,9589,8682,9587,4940,4939,6371,6804,501,4234,7304,3989,1462,3247,4860,2594,6740,7932,4796,7238,3830,1167,8220,7602,947,1126,6010,6971,4395,6710,5371,4512,3913,8241,8334,2041,8337,8336,7022,8248,6751,7910,8019,8323,8585,4730,6315,1690,9376,9376,9137,5454,8520,5763,7099,979,8583,7808,9407,9638,9634,8584,8824,7631,9493,9591,9590,9084,7546,6201,9588,9587,9149,9593,8596,9535,8325,9665,9589,8782,9429,8324,9637,5321,8323,9867,9725,8358,9920,8583,9407,9084,8585,7546,3898,8682,3898,10053,7870,9921,1038,3542,1521,10055,4136,6824,9811,5995,10232,10090,10087,2160,10080,10238,7016,10182,10112,4624,585,2025,3288,3904,10342,10523,10479,3159,5692,10548,9808,5743,9471,10048,10212,1770,1765,10212,9942,1767,10719,1769,6354,3070,3073,3071,6689,7753,7752,10674,9212,8088,8627,9037,9665,10053,10544,6688,10975,8943,10894,11142,9798,11221,5799,107,4082,11423,11020,9477,8943,10672,11288,11310,10673,11550,6354,11644,11748,11670,10892,8323,7198,7196,9084,9407,9231,9587,9903,9589,8682,6497,8325,9536,947,3549,5334,1371,4796,5148,6644,1439,6780,766,2706,1145,5421,4131,4860,1461,6986,2261,947,435,1398,6691,2023,2023,2023,4452,4765,4765,8684,4349,4349,1766,6509,6511,6514,6515,6538,6537,6536,6535,6505,6533,6532,7843,7592,6354,3070,3073,3071,6689,6688,8324,8323,9590,8325,9588,9589,9601,9555,7546,7677,2261,5460,6876,7285,4947,3493,7068,7840,6646,7838,7903,7168,7775,6652,7184,7180,6654,6653,7188,1738,7185,7181,7879,7183,7189,7178,1521,3625,8247,4386,7187,7176,8089,8146,8248,8314,8315,8246,7167,8249,4464,7186,7182,8316,7614,3542,6713,8319,4218,4470,8242,8313,8340,8336,8317,8599,8341,8311,8342,8305,8322,8337,8328,8327,8325,8241,8332,8326,8339,8314,3715,5373,8340,8241,8330,8309,8325,8649,8598,8335,7178,7189,5379,5812,8332,7184,8310,2989,8326,7179,6652,7180,8318,8555,8883,8874,9129,4131,7188,7184,8897,8899,8003,8896,7751,6527,7972,6372,7187,7014,2029,6527,8938,8918,2006,8611,6688,9589,9535,9587,8324,1953,7249,7582,6842,7844,9911,2337,4944,9214,9527,10139,9772,6216,10045,9454,9773,2782,10246,4082,8888,3413,9160,9973,9148,8641,8055,9600,10022,8063,8575,61,7619,9453,10375,8573,7262,10549,9508,9996,10272,10464,8795,10692,1349,8741,10623,10774,10624,10672,10251,10508,10625,10835,9660,10910,3244,9052,9963,10855,10854,8892,8891,10862,10894,10895,10906,8737,2863,9610,6712,9798,10476,11289,9543,10305,8206,7717,11273,9540,11274,11332,6364,11456,7671,11573,9873,11501,11497,10532,11140,8805,11045,10789,2951,7178,7189,9429,8325,9587,730,9590,6354,7182,9593,7185,1245,10218,7184,10321,3070,9535,10200,10139,10201,10197,10215,1768,8387,381,380,10199,375,7188,394,372,376,10217,176,10322,4390,10545,1411,9137,4512,10521,10562,9587,10556,9589,9588,1266,8334,8337,10559,8342,10558,10557,10607,9429,10463,14,8341,10555,9593,10194,10561,9431,6066,9426,9436,10552,10551,10218,384,10330,10332,10331,4304,390,4684,9424,9425,9483,9433,9427,10563,4302,10606,4286,4287,4291,4305,10728,7963,10519,1557,7698,7844,7311,7608,7610,6498,9631,7693,7694,7695,7845,7843,7696,7868,9536,4804,6653,7176,7179,7180,7182,7187,6652,7176,7178,7179,7181,11015,11014,7183,11013,7189,4386,6654,7184,7185,7186,11016,5635,8899,10796,10797,10926,10975,10930,7600,11109,10928,10927,7676,11082,10931,8681,6221,8698,6223,1770,9407,8584,10214,10335,10215,10216,10213,9632,9868,9501,9084,8682,10334,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,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,10205,9925,10229,10246,10135,10131,10284,10242,8307,10240,9913,8248,8596,8324,9590,9591,1297,8804,9258,10398,10216,10215,8243,10102,8323,8341,8883,8312,9429,9429,10199,9535,10129,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,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,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,7568,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,10332,10327,6197,10607,10328,1411,7567,2820,4297,10558,3515,10563,6201,10218,4299,8332,10158,5386,7569,10137,3442,10099,4292,10333,2826,9593,10200,10560,7696,4293,4305,10322,9114,9426,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,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,11184,11022,11192,10706,11193,9168,10053,11191,2780,11241,11231,11242,9690,11149,2791,10544,9408,10606,9429,9589,9587,9588,9593,10727,8241,8249,8246,9427,8243,8242,8339,8597,8247,9143,9408,7610,535,547,11054,8596,545,550,979,1765,548,9143,9437,542,3889,8325,3894,524,10727,7987,8249,527,3896,3888,541,3887,529,7986,536,3883,8272,525,9502,8987,539,6493,8989,528,10556,9147,9146,543,537,531,11080,10822,6042,11077,11075,11076,11079,11078,11077,10957,9231,9144,11458,8665,6390,10502,6474,6475,6473,6471,6470,6453,6469,6465,6461,6462,6464,6466,6467,6463,6468,6460,6454,6457,6458,6459,6456,6455,6470,6471,6469,11493,6468,6467,6466,6465,6464,6473,6474,11019,11432,6461,6462,8586,7546,8682,9084,9407,9920,7870,10238,10565,9084,11218,8585,6039,6036,6034,6023,6038,8584,6041,6040,6542,6544,6444,6540,6539,2224,2221,694,2211,9517,9518,9521,8618,9520,681,695,2208,10322,11048,308,8325,10970,10908,10555,10336,8247,10215,10607,10729,11121,6740,10728,11149,7238,8220,11009,11137,10250,11057,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,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,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,1917,3698,3241,4099,1298,6832,2458,3595,1559,6779,5088,1498,2261,6248,3550,1257,1215,6560,3702,6588,3037,6732,252,3625,2337,6635,1521,5142,3327,2954,6793,5373,3542,4136,6104,5379,1349,6713,7016,4023,6684,5817,435,766,5339,3159,3437,971,6069,4460,4005,4258,4050,7019,7156,7138,6365,4878,1762,3080,1080,4125,249,752,322,1121,7230,7304,5460,7005,4178,4455,5020,1536,7126,7050,7238,4886,7761,1253,608,1698,4460,5545,7038,7840,6693,7354,7879,5236,2915,3725,7829,1038,7839,2705,7878,7760,7783,1371,6842,4652,7858,7640,361,2635,6663,7920,8031,8089,8094,7992,5349,4199,2387,5070,8095,3701,2294,3162,4218,2590,358,5247,8222,5885,5088,6478,4710,228,5764,2882,4766,5915,8611,1830,4217,2863,6001,7787,6941,6366,8442,4144,8829,6314,6686,2657,8548,4209,5362,6971,8555,6712,8809,2381,8938,9027,4082,9038,8837,7614,1318,8918,8687,36,1127,8910,9030,8947,6117,8901,9079,9195,8999,8902,9186,9052,8543,6981,7550,9220,7615,9086,7883,6642,9200,9248,8500,9346,9348,8805,8935,8800,9363,9321,9353,9453,7582,9372,9386,7758,9213,9402,8919,3165,9468,9335,7221,9558,2698,9471,9606,9541,9602,9377,1277,9552,9607,9638,9615,7856,9634,9554,9654,6858,9406,1699,9769,9668,8514,9825,9600,9800,9455,5484,7910,9454,7017,9374,9922,9116,9308,9221,9835,9945,9952,9964,5222,3302,5210,9986,7830,6824,9834,9814,9212,9937,10021,10018,10019,6113,10002,9910,9884,10001,9928,9896,9900,8933,61,3117,3134,9883,10039,9831,10062,9799,8006,10131,10116,10188,10129,9935,9639,8777,8776,10063,9258,239,9347,9352,8923,10173,10115,10057,10048,6010,10148,10245,9730,9951,10047,9942,9387,773,5692,5743,10243,10046,9879,10288,10283,10227,10130,10505,10284,10374,10528,10548,10373,10526,10376,10368,10375,10469,10674,10556,10394,10725,9593,10201,9591,10139,10562,9983,10199,11020,10938,9589,9587,10559,11028,9833,10892,10518,9407,10871,9588,10268,11135,10894,10727,10472,11156,11021,11122,9832,11104,10750,11136,11154,11139,11220,11218,11154,1699,10225,10649,7599,10211,10738,9389,10956,11010,6845,11314,11324,10830,10266,11018,10289,11287,11288,11126,8586,11233,11406,11360,11379,11299,8390,10719,9814,11340,10463,11361,10565,11353,1537,11442,10526,10904,2992,11437,11378,10895,9193,11396,11382,10879,2506,11304,173,10823,11351,11455,11493,3521,11409,10893,177,178,179,10314,11443,11495,11489,11522,11552,11598,9950,11599,11093,11377,11606,11480,11608,11342,11523,11600,11655,11658,11646,11285,11661,11620,11656,11453,10892,11722,11678,11691,11479,11289,9244,11681,11670,11201,9339,9381,11383,11491,10188,11621,11724,11488,11786,11785,11373,11107,11455,11764,11770,6704,93,10731,10721,11602,1969,11775,11202,11441,11851,9601,11848,11408,11784,11854,9590,11206,10561,11080,11048,11046,11079,9591,10725,11078,10214,10559,10799,8883,10801,3036,6381,7704,10797,11157,10200,10796,11153,10795,10201,10558,9589,10216,10794,8596,10793,9587,11076,11155,11159,10562,11075,11139,10215,11081,8323,9424,8245,10791,10199,9588,10790,8241,9523,10981,8247,11036,8242,8311,8241,10606,8244,11161,11151,8249,8243,8324,8310,11158,11160,3875,10332,8339,10323,10325,8247,8341,10158,8314,11050,8242,8245,8244,11759,8241,10324,10329,10053,6354,9665,11617,10333,10331,11618,11242,10330,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,551,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,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,1774,11638,10599,11582,11578,10560,11380,10559,9587,11687,9865,7697,7694,7695,11694,7868,10332,11624,7695,11694,3073,10326,10325,6354,8332,3895,3896,3888,3887,8274,3889,3893,3885,8273,6493,3897,3891,8272,3883,3894,3884,8946,10327,10328,10329,10330,10331,10323,8248,10333,10606,9119,8585,9908,10194,8882,8290,8339,9588,9587,8330,9429,8682,11722,11242,11677,8586,8618,9407,9920,9589,10200,10199,10801,11160,10557,11617,11615,11759,11618,10214,10215,10158,10096,10137,10138,10099,11156,11625,8314)  ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC