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,8925,8901,8947,1349,7920,7037,8837,156,6266,4805,9033,1738,2467,9038,6986,8089,8884,320,36,1349,6569,7647,2989,3719,9196,665,4395,9249,3142,446,6266,1439,3523,6863,5331,9195,8915,7019,9464,1215,5732,9376,36,8089,9553,9556,9557,254,9526,6845,1461,8934,4947,4769,9637,9372,24,104,9639,5142,206,9648,9654,9641,9750,7388,458,947,9824,9779,9930,9543,9926,9363,162,30,145,739,9937,9340,9972,9965,9221,6986,10062,4156,10057,10063,1325,608,7602,9553,9638,10149,93,9764,10042,6798,9635,2976,3878,1559,8358,2594,220,10212,6632,6104,6261,446,1299,7138,7036,10258,10244,36,228,6117,6163,61,10267,501,93,10300,9335,9754,6858,5148,9811,10182,9638,4056,1347,9764,10243,9220,10227,9052,5267,10476,10350,7017,10341,10416,9476,41,10396,10315,10541,10530,10543,9807,10568,308,8999,10127,9249,10548,10657,8615,10548,10608,10523,10622,10569,10652,5795,9107,10528,10663,9937,5513,739,61,10780,10719,10375,1127,1257,10784,10787,10749,10870,228,10893,9798,10894,10669,6696,8193,10895,10672,10878,10737,10870,9353,10798,10883,11021,2706,11028,10856,10964,10879,10784,10871,10748,11027,10373,9406,1047,252,10683,10764,10512,11123,11106,11126,6113,11018,3532,10667,11122,11197,11235,11135,11219,11234,11129,11180,11199,11281,11220,11287,11142,11171,11200,11340,11105,11324,10744,11330,10754,11104,11361,11201,11377,10747,10566,11353,11227,11107,9935,10783,9910,11234,11349,11288,11455,11127,11492,11495,11266,10910,7810,5997,11478,11442,11494,11488,585,11395,115,11489,6696,180,9248,8934,11593,10747,10892,11134,156,3523,11599,6696,739,11324,11647,11491,11396,11646,10246,7761,11670,11644,11550,11689,11594,10065,162,11491,9402,11658,11455,10548,11309,11594,11180,4258,10798,11646,11613,8031,8869,11235,10568,9749,1298,4969,11480,10917,10126,11477,11783,11787,7995,57,10531,11479,2590,10919,11606,10002,11644,5046,4325,7017,11827,10917,11834,228,11871,11838,11764,11819,11835,11849,11872,3904,1253,10065,28,30,11495,10892,10314,9648,11847,11871,11869,11900,11904,11921,11848,7839,11342,1176,10091,11235,1699,9769,11725,11498,7883,2933,11964,7126,779,11020,2615,11495,10358,11873,11784,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,8232,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,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,4185,5542,5906,2889,254,5247,5322,3216,5837,6315,320,5331,6796,3026,464,6700,6866,5331,1462,508,6121,1230,924,4218,5994,922,6364,6382,5956,3542,6130,1645,7304,5996,5909,3037,4109,567,4834,1557,5088,6891,1325,4450,405,2117,1998,421,324,4029,7547,7143,4690,2729,4432,3054,5763,5735,4986,450,4320,4659,4722,2246,6809,7834,5904,1073,8093,7592,7837,7835,7836,1461,8103,8151,7907,6828,4765,3549,7910,7359,637,3014,501,6838,5602,1327,7919,8092,3872,4901,3904,358,435,4056,1119,1121,7861,1215,4983,1029,7812,7783,8617,4731,8629,8793,8745,6642,8555,8837,8836,8869,4566,8919,8840,7037,1461,4730,6397,4950,36,768,8169,9030,9075,9073,8933,9074,9072,9164,9163,8841,9096,9072,9074,9216,9244,9243,9242,7815,4395,8441,5088,5236,9281,7899,9344,2253,6310,5046,4061,6986,1038,4339,2847,8839,8031,8547,7559,9460,9456,9459,9464,9455,9454,7354,7587,6713,3261,6782,8089,2882,1516,504,9497,7833,9479,9546,9757,9647,9463,9814,9635,2989,7804,8970,9810,5881,5885,7548,7873,6842,8280,8291,8818,9038,9334,9078,9614,5915,7140,3395,9345,8978,10004,8504,9990,9637,9888,9897,9910,10113,9900,10114,6002,6981,9967,9603,10046,2446,9753,9788,409,9319,10039,9828,10064,9558,10060,10088,10182,10087,10261,9987,1385,10109,10104,10260,10267,9354,10237,10358,9769,10258,10183,1142,9180,9185,9299,9506,9801,10063,10259,9389,10229,8910,9406,9275,10210,10528,10121,10547,10549,10297,10343,10364,10380,10320,10319,10318,10564,10699,9959,10090,10480,10187,9919,10820,10700,10471,10505,10741,10847,10569,7131,10655,10668,10712,10977,10967,10972,10893,10702,10935,10679,10538,10119,11044,11090,10971,10416,10715,10719,11021,9336,11103,11104,11042,9615,10174,9969,10440,10780,10785,10737,11106,10754,10734,9617,10778,11028,10749,11129,11135,11162,11163,11134,11089,11237,10536,10842,11126,10876,11258,11230,10261,10875,10878,10865,10086,11282,11220,11272,11315,11339,3493,11372,11382,11361,11121,11397,11234,11127,11446,11450,11381,11131,11386,11271,10236,5795,10837,11487,11423,11213,11377,11359,10938,11621,11551,11606,11379,11612,11703,11698,11646,11724,11440,11230,10663,11593,9896,11800,11669,11678,11850,11872,11363,7144,11838,11748,11344,11879,11965,11900,11775,5193,10844,8222,7579,7837,4079,1210,7834,4639,7835,7836,6740,7143,4087,8358,7238,223,8220,8517,3282,7989,8306,8547,8480,2117,8610,435,8610,3014,8629,8214,5143,4218,7923,3850,8842,1207,8905,8912,6599,1127,8916,9000,665,1345,8578,8780,9046,9130,9195,9017,1461,9072,3062,4625,8933,8706,5154,9200,9242,984,9254,7907,5536,9300,3761,8495,9322,9332,9333,9334,5732,9308,9289,9291,8103,9337,1057,179,8150,3595,2135,9456,3059,9419,9290,8688,7803,9196,9347,9541,8543,8306,9552,8306,9353,8306,7581,8306,6117,9607,9603,9604,7143,6857,1890,9641,9634,9654,9643,9668,9642,9644,2360,9377,4240,9680,107,9616,9761,9234,8805,9648,4219,9676,9769,9766,9780,9800,7856,772,9798,3844,4800,3303,2299,9116,2294,5515,5765,3590,2398,9258,1416,9913,9916,9938,9942,8913,9635,5841,780,9961,3844,9543,9945,129,9471,3159,3788,444,5692,1834,8870,8844,972,10047,6848,1727,1822,360,10056,734,7615,10104,6681,5812,7016,2674,6827,1181,10128,10129,9086,3181,10141,10149,3437,10119,10120,8925,10048,10061,967,9472,1522,9963,1906,10093,220,4126,9116,5821,2743,1485,1000,152,10229,10242,10241,180,148,958,1461,2135,2192,3585,2299,10131,10282,10284,8884,4947,7019,10273,2687,2642,1826,3561,10283,9936,2421,4656,4566,4972,2571,10342,10338,10246,9348,115,10300,10380,10373,10209,10358,9050,4527,10374,10373,10440,5743,6171,10469,4168,10467,10476,10416,10479,9374,9638,10042,6267,9220,3608,5877,3035,4986,8851,9454,8837,10523,10114,10244,10527,10247,5551,8902,10394,8800,10549,10541,10537,10548,10543,322,10514,8514,1954,10021,4385,9193,1057,7550,6691,162,8901,10671,10649,9904,4767,4696,10665,7017,7582,10674,10569,5729,10745,1954,10747,10787,10798,4023,10780,10814,10737,10663,3715,10784,10836,10688,4082,10135,10782,6713,252,10878,10699,10870,5373,10935,10894,7016,10910,10892,10934,1350,4136,1521,10938,10918,10966,5142,10895,10893,10656,7140,10397,606,10782,8900,10988,5379,6828,2192,10233,7614,1532,9834,6643,10708,11028,10709,7064,10710,9081,10285,3054,7021,2270,2271,1131,10221,2672,10344,3825,10345,10513,11084,10320,123,11090,10661,10662,11105,10398,11104,7143,10990,11094,6838,239,10899,10778,9872,10673,11104,2642,7016,7710,9254,3391,9768,9254,9270,1277,7016,955,6861,1441,2654,1055,2707,1160,1159,30,243,11121,10376,10917,1160,30,11123,11127,11128,5631,11132,8687,11126,10765,11089,10454,5875,743,7758,10094,11135,11142,11136,10964,6849,2912,4982,10857,2698,10971,10733,9453,6852,10343,7864,780,3964,8835,3657,2639,3542,5379,4219,7855,1277,1042,8919,11166,3775,10148,10375,3778,5678,4665,9928,10130,5305,11180,10719,1835,11195,10473,6696,3787,6853,4362,9105,1176,2671,1313,6661,4616,2919,11219,11222,11217,10734,11230,11201,3100,10819,11237,10657,2709,10434,4233,1119,11220,8535,11199,9234,11200,4209,5487,9096,3457,2446,10861,8031,5545,6731,11198,11235,10528,6731,11084,9722,11288,11287,11268,1209,11304,11302,11272,4056,6862,6779,11324,11325,8134,9343,5046,36,1698,2590,748,5903,11349,3936,11353,3376,3195,3139,4028,4648,8802,11361,2592,2919,2685,11359,11360,2873,4536,11389,11351,11374,3482,2655,7036,3396,9402,6866,11409,10940,11417,11266,11424,11423,10715,5013,11314,11266,9811,10062,10146,24,4875,10714,11142,5252,11443,8010,10530,10714,11442,6730,9922,11438,1049,11433,1050,9221,739,11473,11437,10288,10234,11480,11456,11450,11388,11491,11494,4329,11455,9615,11488,6692,11381,11498,11489,11347,11344,11468,768,1576,11476,11371,11477,11382,9750,4648,11102,4882,11416,2555,986,9809,9807,9808,141,986,11290,3368,11492,152,10842,2477,7709,8224,3523,11599,11042,10912,11595,11598,11613,3041,2456,122,3500,3540,5328,11621,1299,6693,11373,11597,11593,11619,11518,11600,11606,11655,11620,11648,11436,10368,11661,11647,11670,11435,11451,4233,11479,11646,11678,11594,11303,11446,61,11523,4432,11663,11691,11644,10002,11362,1113,11690,10685,11698,11703,779,9965,11719,11672,11669,11724,11680,11714,11126,11446,11702,11705,11738,11737,11725,6986,3401,925,8707,8520,9222,4061,11385,2491,7760,8104,9317,5047,11658,4099,11170,9068,8483,9070,6337,4849,11764,11765,11673,9532,9987,7896,8146,2454,11379,2419,1298,9531,258,11657,5553,6902,258,11770,11772,3714,218,11752,10635,9018,11786,11660,11807,11812,9511,7362,11816,6901,11787,11785,11282,9036,10967,5629,11330,11659,9986,11681,11716,9228,11285,11827,11819,10764,4696,11821,11820,11842,11845,11829,11010,11846,11826,11869,11831,11872,11662,10956,11851,9917,11822,11699,11847,9964,9967,10877,8284,11832,11871,5885,11870,11849,11873,11900,10743,2921,9211,9166,9642,9643,9644,11921,11828,9641,9333,7719,9332,10744,9571,11480,9397,11610,9569,10359,11850,9832,6069,4417,946,11965,11978,11977,11963,11972,6553,6552,11966,11982,6315,11964,9387,10267,3731,12010,8182,10865,11990,9460,11860,10354,9897,4079,2092,4092,7777,1016,3908,8144,6622,6832,7374,6903,1461,9195,5245,4144,7670,9277,8514,7775,8910,7981,659,9641,2160,4432,4079,6315,9274,5564,5314,1645,5020,4076,5093,6104,6845,9925,9405,8514,8910,9338,9406,6622,7909,30,10476,9798,9929,9930,6117,7581,10149,8543,9648,9961,9634,6857,10543,7872,2530,93,10878,4125,9543,9235,9193,446,9959,6849,9402,9325,9910,10063,11122,9786,9789,10080,10412,4923,4795,10081,11220,11361,10093,9524,9557,7888,11489,11646,5193,10986,10092,10094,9096,10190,6550,10649,5790,10632,10690,7715,11027,2736,2761,11104,9959,2137,3100,6103,9543,6740,11103,10784,11128,11126,11142,11202,11217,11112,11235,11237,3908,11123,10951,11222,8214,4079,3728,5013,4665,10127,3346,9810,10355,10269,10870,8010,7990,6622,10611,2615,6348,11220,11349,10937,6633,11423,10125,11136,11226,8144,9757,10976,11065,11281,8763,8626,9546,11129,11094,11352,9479,11288,11258,11105,11107,11604,10085,11491,11598,11495,11595,11498,10971,10668,11480,11132,11230,10655,11496,11521,11658,4950,3197,4724,11733,9406,10569,10786,11127,4882,11439,11747,11449,11492,9539,9541,9602,11550,11787,2092,964,6832,1183,7268,7124,4432,7175,7109,3368,3890,3882,3885,3100,5904,3897,1145,6863,320,5046,3891,4099,7095,4724,3894,7986,8052,3989,3896,1073,7883,3883,7266,3881,4209,8209,4570,6315,6155,8222,6312,2737,8205,1439,2029,3612,8423,7281,7008,6713,231,8389,3933,8477,6942,8449,1698,6365,3062,6699,6697,8553,8635,7271,8202,228,1137,3195,7920,501,8517,8776,2737,4710,5331,8804,4805,2706,8736,585,2932,1089,3989,6315,6595,8801,8927,8805,5386,9036,8449,8386,9080,7674,661,5236,9038,8936,8553,9058,9059,7546,8682,8584,8368,7659,9079,9134,9108,9010,9293,8891,8892,2995,5247,9212,9298,4128,9134,8978,7268,9366,9308,8714,9406,3419,9200,9313,9402,9220,9258,9471,9295,9563,2594,9214,2246,6069,9527,4519,3474,9561,4805,9676,145,4624,162,9578,4656,9353,9813,9347,9807,9821,9836,9314,504,8282,9900,9950,9956,9954,9951,9157,1038,9541,8102,4131,10022,10025,10023,10011,10063,10065,9984,4635,9983,9991,10056,2615,10186,2976,10041,10074,10076,6683,10142,9928,7972,9811,7973,5236,9922,10048,10244,2294,10274,10270,7943,10272,10294,8629,10292,10079,10275,10046,8291,9983,10127,10342,9769,5460,10450,9527,10359,9745,10513,10116,9874,9873,10410,10576,10451,10623,10434,10407,8830,10479,5251,10674,10570,10399,10571,10400,10624,10401,10773,7005,10630,10771,10769,10768,8513,10891,10675,9249,10774,10862,10880,10798,10890,10811,10905,7672,10888,10693,10893,10938,9082,10863,9793,10967,11045,10001,9807,10733,11089,10783,145,11065,10951,11127,10895,10577,11122,10397,7671,10754,11187,9302,10625,10955,10934,10905,11095,10967,11106,11273,11172,11274,10965,3115,11275,11121,7268,11281,8006,8400,361,11336,10341,8807,11396,4805,4209,11288,9705,9688,10879,11124,9875,11423,11279,9744,11066,11395,9957,11107,8929,11409,11491,10076,9370,8071,11442,8783,11513,11527,10629,8462,11509,11604,8438,9577,11515,11573,9134,11542,10274,11442,8445,11627,11142,11633,7276,11515,11508,11689,11339,11654,11674,11693,11711,10030,11671,11713,10630,11675,9001,11756,11753,3115,11763,11760,7765,11692,11767,11793,11502,8175,11746,11702,6699,11803,11804,11801,11824,11747,11781,11700,9580,8469,11818,11784,11777,11862,11863,11671,11802,11882,11883,11339,11881,11095,11758,11888,11889,11915,11918,11914,9639,8472,10513,11927,11913,11892,9354,9629,9630,11888,11881,11926,11957,12007,12004,10904,11797,10891,11334,10615,10614,10935,11594,7126,7883,3080,4258,6858,5817,1699,5545,7839,608,10568,11495,5339,1347,4460,1253,9325,167,11678,11787,11827,11645,30,145,228,9928,11838,11288,11764,9542,11123,11140,11180,10362,10871,11020,10770,11821,6785,7920,8548,9372,9937,10243,10065,11783,11235,11871,1349,10787,11521,181,167,107,10523,10569,11991,8999,4652,10856,969,2933,11784,10472,2294,11873,11919,9924,8776,5535,3066,1385,386,254,5053,446,397,1303,2122,2743,4558,1645,6152,6151,1520,6654,4355,800,5321,1770,5995,1768,1524,1766,5542,1769,1771,1970,6691,6718,6985,1662,737,5148,6175,7262,1767,6721,508,1771,1769,2706,7270,1133,1770,1257,5454,6204,6104,7209,272,4230,7107,7083,2023,6593,1685,1327,6689,7881,186,1073,1215,3071,6315,7671,1173,6586,5927,8088,7753,7881,6546,501,322,6858,810,979,3989,4796,5732,1173,6743,3719,3559,6315,8193,507,1351,3115,7771,3385,7213,1173,8688,4227,3881,7104,8111,7585,8436,8627,7238,8548,8220,8175,7637,8168,8687,8885,446,8440,8765,8834,512,8831,8900,8963,7837,9037,8951,1768,9136,800,8828,9136,8946,1257,8306,1215,3989,8578,9096,5995,9052,7301,7736,4130,9245,8250,9300,2122,9365,9278,9308,9382,8704,9455,8175,9439,2701,6778,7636,9308,9474,9615,1245,1532,9636,9602,8904,9623,9323,9196,8899,8946,9679,9648,8543,9347,9634,6857,9961,7581,6117,9930,9627,9195,9543,6646,10118,1108,10212,9554,6874,10149,10172,107,9867,8897,9760,10232,9665,9342,9049,9383,8728,10000,10272,10554,10342,8615,10523,9221,4337,8173,24,585,10053,9453,10476,10878,10375,10664,10893,10940,10870,11024,254,11028,10836,10292,4558,2811,30,11142,10671,8893,8132,11122,6595,11220,10672,3933,11105,6646,11021,8171,10784,6616,11302,11253,11402,11423,4437,10291,1080,4136,9929,5922,11361,7975,11142,9949,11263,3493,9865,10258,11473,9455,10464,11548,10248,10730,314,11491,8762,11423,11550,10650,5923,9866,11399,11042,11283,11690,11404,11097,26,7159,11645,11739,11678,11328,11764,11701,11118,11721,5534,11644,9603,10798,10784,783,11215,11724,9513,11074,11816,10010,11123,10554,11824,7215,9541,11869,314,11267,11725,7854,10370,9649,9648,11751,9524,11870,2009,1265,10667,11900,11951,11937,11921,10438,11324,11736,11872,964,1762,9868,11991,10872,11594,12012) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC