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,1917,3698,3241,4099,1298,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,9430,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,11828,11850,10798,7807,11363,9538,11872,9544,11964,11900,11899,11860,11965,11905,5334,3549,11272,9558,2145,3197,5564,6737,3250,5717,6368,6361,458,6177,4218,714,408,1084,6349,6642,1881,6710,6741,5953,4765,6709,5949,931,6779,186,867,4597,2520,6789,579,5093,431,6813,6986,4898,5923,6561,6622,6348,7019,452,5769,850,6842,2458,1616,2490,7239,405,698,1151,617,3395,3046,739,5088,5647,6004,6804,7359,3609,7547,1308,6193,7374,7759,582,1461,7760,7776,7872,582,431,7899,6312,7790,7889,7908,8031,8103,7907,1265,698,7889,2521,8110,8222,8214,7962,7953,8183,8388,8195,8182,5455,446,1815,8483,8547,8358,7547,8390,7022,961,8629,8611,8725,8765,2006,2029,8793,7128,1052,8835,2989,2310,6622,6115,6190,6193,7790,5998,2093,8947,8918,2156,9027,5484,244,9038,801,4185,2179,5790,6181,788,2085,4683,6633,5209,2288,6240,3197,3169,2302,6175,1885,6896,3250,7154,7086,1271,7081,6890,6361,7297,7285,949,2113,3172,7572,5564,359,7589,4639,1185,7254,2775,7971,324,4684,6769,2266,1381,3732,7944,916,6831,714,4362,6642,6644,4788,6780,6766,3549,5334,964,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,11041,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,4199,6598,6133,6264,6624,895,6482,1126,2995,2677,28,566,956,956,4969,524,7205,7205,8438,8438,8438,8438,867,867,867,867,867,1537,6548,1250,2093,1324,176,2374,2749,4401,1271,1497,3425,4659,6103,6701,6488,6205,324,2171,1324,6342,6163,934,52,6875,2182,4535,6348,4774,6210,4199,418,947,5331,6622,1439,3979,2027,6958,2729,5912,6972,1366,867,6806,6973,6974,737,3148,6890,6798,5822,5763,5986,6488,3425,6193,52,6240,3250,4659,2182,5314,7068,7097,2749,1016,6264,6975,5564,4683,4684,1210,6103,7154,4535,324,7218,7149,2490,7823,5763,3908,7108,7081,7990,7893,2847,7880,3346,7993,7804,4339,2027,7715,7079,6264,7270,5912,7281,7285,7154,7906,7284,7941,8283,8081,7941,7286,6103,5245,8085,6205,6138,1016,6121,2897,324,5822,359,6796,6633,8610,6904,8141,6193,8141,7584,3425,8279,4559,8560,8063,8058,8639,8445,8046,7714,8575,8653,8438,8570,7118,7295,7100,7294,7082,7075,7076,7665,7647,7666,7109,7266,7124,7647,7122,7094,7092,7155,8063,7246,7281,446,7151,51,6178,8084,7083,8402,8212,7928,8042,7250,8404,8569,4178,8706,8408,7251,8576,8403,8208,8361,8083,8576,7671,8407,8365,8818,7270,8425,7153,8228,8942,7277,8939,8939,8832,8832,8782,1257,9189,8412,9138,7095,7572,7118,7108,3860,7967,7213,7897,7897,5996,5996,7661,7661,6523,389,5165,2992,8268,1537,7104,8055,7263,7602,8033,7258,8087,8087,6388,7082,7252,7076,7079,7705,6521,6212,6223,7698,9781,9591,9592,6656,7844,9312,9590,6220,6497,6498,6222,6496,6216,6501,6215,6218,6221,6214,6499,1770,1765,1771,1767,1769,7149,3148,6170,1804,1787,1807,1084,1811,2458,2157,1786,4399,6235,1497,427,6774,6733,2029,6547,223,6795,6562,6575,1016,7110,7125,7087,7086,7088,7117,7123,7101,7116,7124,7079,7153,7069,7121,7258,7249,7106,7276,7074,7096,6712,7252,7247,7253,7084,7278,7272,7291,7096,7247,7275,7091,933,3302,7840,7878,7241,8056,5305,8070,7879,7937,7254,3860,7279,8055,7147,7289,7245,3698,7238,6740,7943,7913,7238,7097,7572,4216,2399,7280,7263,7992,6559,8386,7270,3550,906,7932,3380,8670,8471,8408,8087,714,8770,8053,8681,8736,7106,8698,8045,5098,6239,5435,6819,1616,2024,3384,8063,8473,3385,4555,8439,9578,7654,8402,7102,916,7899,358,3647,176,7908,915,1385,1385,5947,1565,8220,7974,8110,7904,7605,2063,3250,7032,6175,800,5915,8393,6210,8055,8055,7833,5848,6588,7903,1662,7023,2269,5688,8942,6618,2182,8948,5421,1385,8554,6785,6785,126,8940,7585,7175,4320,8547,7879,7612,8026,3728,8910,8947,3609,9032,1145,8831,7850,5719,8306,1126,8620,3549,5402,6691,8968,2328,5371,1521,6645,5582,3346,850,4362,6831,1371,5996,421,6795,7602,4798,223,6890,5927,9694,6785,7214,7639,9900,9386,6687,5543,5142,8876,9244,9362,9389,9387,7144,3728,10129,9497,10116,9951,10001,3081,10313,6130,10312,6889,1453,8828,10956,10517,10240,9959,7783,6633,3414,4834,4399,10818,10131,5947,9354,2467,3878,9545,104,156,7613,8219,11102,7920,2447,9828,10850,1308,11365,10269,10649,11290,3908,10666,4984,4424,11136,11454,9838,10955,661,1145,11588,11523,10934,11603,1460,1318,8539,6831,11621,11595,9949,11599,11953,9864,4079,2092,4092,7777,1016,3908,8144,6622,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,11041,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,6646,6394,358,7288,8768,6962,6383,8523,1664,6110,8523,186,5965,8831,7912,6715,6402,1296,3823,3865,1380,7912,6383,8356,8355,7805,1308,7918,9498,7541,7541,6367,7918,9065,26,4437,1345,7505,6897,8659,2635,9762,8005,9729,7711,9467,2384,6394,7917,1726,6174,9729,9856,9975,9975,9737,9737,10056,10035,7966,7966,8130,7917,7175,8483,8547,8151,8019,7774,4983,6891,6715,3428,2849,6691,3549,2467,7773,1016,470,421,4535,1593,4423,3797,3728,6131,8810,754,3728,6618,2830,6733,8773,6536,8887,6536,8887,1511,2989,4898,7982,1765,1771,2992,1215,1215,1215,8765,4144,7837,3037,7992,6349,7992,6691,2029,8828,916,4395,6971,9649,8230,9525,36,7962,8024,7953,9300,8354,6715,6312,8519,6312,8519,6984,5371,1726,5371,1726,5371,1726,6371,6175,2467,6151,1738,4289,7741,5691,5904,6526,1462,6212,7913,6742,391,3885,4512,8700,5386,6953,2164,8388,2455,4701,8780,4769,9391,3515,1116,8247,8980,4424,735,8896,2989,222,7178,6181,3036,223,8899,2389,8242,5567,7186,6444,961,6377,452,6523,9692,6652,8825,7189,9559,9631,7764,8279,8816,2778,9996,7762,7570,4437,9949,9970,9338,9792,9880,1245,7725,9763,9665,9616,1770,9950,9492,52,1765,7,9906,9951,1771,9480,9880,10219,6115,9424,3913,10102,10199,9835,5484,8432,450,10154,8257,8727,1250,9669,9782,2780,4701,10188,10110,7751,8151,4639,10155,7972,7973,9670,9892,10155,961,9671,9033,9131,8822,9672,9673,5175,576,9168,6119,9473,6003,1766,4500,5769,4349,2605,4338,979,5678,10156,151,9473,4800,9720,3081,9722,4901,10281,2467,10071,8566,8967,10655,11097,10187,10991,11025,11116,11105,11135,10974,11104,9,4424,11052,11072,10554,9959,8173,10886,11092,6181,7205,2079,6820,8507,11306,10550,1774,7048,5531,4510,11118,11260,8970,10718,2169,11045,10483,11053,11279,11482,8565,8721,2056,11099,11449,10941,1887,10947,11283,11253,6267,6118,10133,8946,9846,3327,7888,961,11638,11886,10477,11622,10682,11328,9390,11908,1265,11853,3105,3081,6821,10886,11749,4580,11744,11603,9505,11854,7214,8303,11439,10211,12001,11676,788,2748,11776,11720,9062,11452,9649,2658,2005,4234,6971,4639,4144,7957,3368,6740,7304,3957,6586,4349,4762,7975,3351,24,2419,7019,223,7759,1653,6890,2117,6650,6861,1773,8010,1586,1774,3913,30,1774,7238,1774,7761,743,7872,743,1127,2118,3609,1127,7126,3609,4860,7126,2192,7547,7896,5327,2265,8809,6710,3429,3159,2265,7576,5536,6695,5536,6613,5536,6579,5435,5536,8220,1772,9000,1298,6861,6282,3957,9030,7977,7615,1159,3376,3327,8900,5188,7830,36,8284,9081,6858,7929,9346,9346,6171,8103,8193,7640,2554,8193,6809,9811,6591,7138,6809,444,8827,9338,4320,7718,6713,8628,261,8628,5046,10342,8358,6981,8305,8195,8521,10056,7839,8140,7839,7304,8140,7614,3698,8915,7156,8915,11331,8617,1416,9604,6775,9803,8620,9476,1250,8620,9476,11491,6980,8927,9648,10734,10892,11703,8620,4056,11670,1172,7213,7213,7213,6174,4600,4600,4,6962,9788,7262,2989,8547,7149,4659,7115,7654,8306,7252,8092,7253,2117,9701,4563,2658,6264,9538,2761,2467,7940,5912,4399,8629,7946,4566,5193,5236,4656,6986,1327,8031,4061,4405,6560,6559,778,10060,9751,9758,9221,9750,7106,8395,10211,10233,7254,1349,10227,10237,9257,8391,10244,10236,9132,1521,8089,9353,7017,10245,10226,10315,9935,773,8777,10359,2261,10541,10550,10587,10567,10588,10586,2079,10666,7121,10524,7716,9870,10743,10807,9831,8211,7932,10820,10239,3542,5763,3715,7895,10976,7125,11021,11025,9259,7125,10977,7087,10904,7252,9900,10749,8047,10899,223,7265,10747,11126,10765,6845,11115,8030,6104,6870,11122,8741,2294,1253,5545,5339,1347,5817,3080,4258,7883,4460,608,2933,6858,7126,10246,10869,1699,1830,8500,8668,8206,4395,7920,7839,10350,10692,10690,7280,11679,9206,10659,11540,9959,11558,11785,7792,11402,11496,7778,9889,10949,10366,10585,11528,8891,10702,11704,8477,10027,10863,10212,8516,8892,8610,11918,11573,9204,10591,9055,8828,6208,11114,7084,5564,6718,4724,4659,2830,5923,10372,5988,6342,6190,10671,10483,10887,10888,7088,7281,8891,9659,7108,9562,7079,11514,11508,7890,8219,9338,7661,7077,11351,5922,8737,10078,10271,11531,5838,1458,10991,10854,7933,11756,10855,2182,5942,7251,6691,9375,1645,7872) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC