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,2035,245,254,1005,1209,842,1993,7920,7149,8220,8440,8514,8483,8547,6911,3888,3892,9220,9300,9284,9258,9298,2265,9354,8183,9030,2849,6842,5222,5331,6842,8683,737,377,551,9322,397,863,271,4362,6191,967,784,3036,6234,3997,5508,6427,6474,6426,6381,6388,6375,5995,1038,3428,5996,2160,6103,5321,4355,228,6315,5837,4056,5421,2194,1998,6361,1453,6633,358,6100,5885,1591,6709,6769,6312,3921,5914,1402,6718,6588,4088,5081,5371,2776,734,1453,501,6172,6001,2530,975,4947,3465,6562,6575,2915,4178,222,446,4860,1398,4796,2776,5799,5070,808,1586,734,6192,1461,6117,5236,2915,947,3392,3465,3059,228,4029,2473,1371,975,5995,5362,3014,1520,5286,766,6249,2632,501,2594,3989,2932,2706,4767,6556,4769,6250,4045,458,459,28,4950,5081,223,6190,4178,5068,2706,4349,1371,840,1257,5995,4985,446,508,1152,6632,4185,4349,3059,3850,6158,4121,666,4338,6335,2594,1070,6350,4185,1520,5995,6010,5252,1380,2263,4218,5915,461,2261,4597,714,6001,6130,6589,6155,220,1038,2179,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,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,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,6710,2033,4223,4860,501,2932,1461,766,4798,5070,585,1690,4796,1038,3989,3037,2706,3904,6863,6693,3595,4061,5148,4969,2632,2261,4234,5995,1325,3830,1215,5799,1257,3241,4209,4656,5179,3080,5286,2657,739,36,6779,6679,4886,3964,504,446,228,5543,2976,3493,5331,2294,7143,608,6858,6595,1699,5795,7126,4258,1137,5817,1253,7709,5545,4460,997,5339,4178,3059,3080,4635,2933,1347,6981,5207,5142,3775,7019,6632,5193,3525,6986,1917,4566,748,1347,3100,7582,6842,3542,7761,5373,2337,7883,2894,6010,6713,4131,7920,1521,7759,7839,1369,215,2658,969,2025,802,7238,8193,6740,5236,4987,8548,5996,6713,7138,7760,6176,5371,5998,6362,675,1402,3913,2261,4405,6811,435,4419,217,4784,3595,6667,1359,1811,6003,2736,6003,3327,4639,2417,228,6821,6792,452,6275,7986,3059,3059,3059,5535,6710,4121,1351,1126,1257,6010,3878,1210,28,2995,3896,6642,182,4653,2342,2753,3889,3884,3893,435,2530,958,6842,1080,3613,2123,5251,6818,3872,923,1056,1198,1207,1533,2451,2725,2736,3014,3803,4645,4779,7288,4784,4872,4791,5431,1370,1370,956,947,7245,4785,7840,5516,7110,1425,7112,7114,7096,1119,1119,7115,7276,1121,7244,7280,7106,8033,7282,7249,7243,7081,7241,7101,7281,7281,7117,7278,3860,6562,6793,446,501,834,1198,2261,1425,1600,7304,222,7003,6574,6901,3698,6809,834,4900,4405,6875,5371,446,1766,1145,2261,1765,5995,6845,1769,4886,1520,5647,6552,7304,7019,7158,2029,906,6689,4144,3728,840,217,7359,344,5915,600,6365,2706,3216,6940,319,6740,4947,319,2876,7837,6981,182,7879,7751,7834,215,1439,1257,7836,7835,7972,7974,2006,1038,7636,7919,6103,3059,4178,7605,4320,8250,7634,8222,4406,7833,7634,8304,1559,8343,961,8441,4338,7973,7374,7635,7846,8358,8611,4061,4566,228,4652,6986,7759,8629,4128,5046,4635,4656,3936,450,8730,1345,3100,10121,9936,10142,9321,7548,182,7599,2849,1300,7261,4199,7118,2261,3702,4199,8623,8767,8280,8280,4405,375,382,389,7298,7150,7297,8236,9132,9132,2474,3247,7106,3874,4146,4146,3874,3874,3874,3874,9770,8922,7903,7833,7143,7019,8793,7761,7761,7761,7761,2169,6631,7879,5995,7548,7878,1461,3754,4109,1520,231,1738,1228,1532,186,8222,358,4185,8390,223,2727,4639,8358,6842,6155,2889,8306,6589,8103,6588,8109,6639,8514,6366,567,6726,4131,3754,2706,2029,6178,7992,4796,8222,2989,7995,8816,8910,5362,8230,5996,3604,2253,6971,6152,7761,1439,8193,4290,7919,7019,501,6707,2123,6010,8222,4304,1119,5286,6337,1080,4131,1038,8031,1121,6679,8514,1215,4209,735,8089,585,3941,4220,6635,5995,1349,6639,6732,3244,5487,7920,6848,2294,4625,3003,1253,3142,7839,5817,2894,1347,6981,4258,4460,4082,6858,1165,3080,7883,5339,7126,2933,3913,5545,8134,8805,3195,8795,5807,1432,7709,8915,4652,8548,7550,8935,8936,8979,3368,8932,3715,36,8687,2590,1298,6862,7896,739,9000,1572,3396,8905,5739,4648,9200,4337,9196,9081,6595,6740,7238,8220,8904,3115,3559,5331,507,2025,6632,4233,8688,9300,4566,7710,3612,8615,5875,4355,8104,4209,179,4553,5349,9372,9038,7025,5039,321,2419,4128,5236,228,9604,6986,9249,6407,6700,8651,9777,9777,7815,9017,9296,3775,4437,4769,9376,9542,1380,9542,9952,9768,7104,4355,5020,1998,4185,3963,5386,5400,5322,5215,1230,5917,1586,5996,24,3913,5764,4082,5885,6117,6792,3595,2992,6831,6104,6595,236,1381,6315,3860,5371,1371,1766,5331,6559,4061,5576,6154,2294,6011,4316,3368,4185,6560,6863,7019,608,501,5215,1954,6337,1690,1325,1521,1600,1272,6979,6595,5997,5371,6713,217,4985,7903,7761,7896,2594,2419,6862,7019,5142,5093,4659,2389,7751,7304,7972,1016,6010,5572,7973,6364,6103,8144,2023,6255,5763,8629,7640,3908,7607,7910,8629,8687,8629,8091,8093,1699,6102,5995,6104,4395,5339,5817,4639,6364,5906,6103,5916,5688,1016,6713,4800,4827,3542,3625,3474,5764,4784,4087,6858,6691,6782,6829,3554,5175,5965,4424,1755,1764,104,3574,6951,576,609,2849,5763,4510,4087,4046,1345,6809,6979,2300,6731,458,6845,7358,5961,1988,3719,1993,7214,7019,3704,6795,7839,4224,7605,7890,3823,4774,7810,3908,4659,7920,2643,2658,8196,1511,1984,8548,7883,7216,8144,8031,8514,8089,2294,4258,222,2989,6006,7804,5252,1984,1458,1084,8999,8108,4452,1490,582,3492,1823,9028,9212,9213,9079,3712,8224,4613,4704,1300,2849,9116,4082,4136,9372,8559,2491,8358,582,5961,9258,9375,5636,207,8274,3890,3891,3893,539,542,3896,8271,3882,3892,3894,8273,3884,5567,9937,1253,2933,5545,4178,446,3889,9377,9799,9212,535,3244,6642,6891,4082,10000,6858,10228,539,10243,9438,9437,10181,10568,385,389,8858,8789,8515,2356,380,10354,8787,8005,4087,3401,3990,4613,8534,3474,9439,9214,9930,9648,10120,9680,9764,4046,4411,1490,4049,4050,1973,6738,9823,3493,6876,11027,10114,5175,11298,11020,11235,10674,6591,11339,5207,9243,11495,640,5732,2023,6023,2221,6034,8941,9405,7374,11359,984,11413,538,390,6066,540,532,528,11353,6894,5262,608,7810,10944,10942,10940,4752,10945,10946,10943,9148,11059,11509,11210,11627,11862,11212,7151,7118,11867,11335,11542,9877,11211,11894,566,550,1533,923,7238,6740,466,4788,2736,2995,3564,1370,1917,4645,4785,1145,5988,788,7121,7097,6659,3392,2915,7245,7108,1520,3059,2261,3493,3595,7019,4947,7761,179,1461,6710,7008,2986,4234,6642,1327,721,8085,2775,2776,1886,1207,2725,8222,7019,1198,435,5251,5143,8185,8185,8434,2451,2932,501,4861,1425,4512,4316,5298,5298,5003,737,4037,8470,8685,7808,2605,2605,3989,6382,4038,3841,6144,7244,6149,378,979,7285,8793,8340,8246,8325,2520,947,7359,1126,8241,9030,8424,8204,8334,8568,6082,8874,7998,7999,8328,1173,8141,3169,842,217,698,9182,3389,6774,6774,9204,4240,9056,8445,7675,7087,182,7116,4301,4301,9053,6042,545,539,537,7986,7654,7125,7985,543,7999,9870,2677,9533,4784,7117,9418,9554,9676,1234,956,1210,1741,542,9378,1768,28,4029,3014,3891,3895,6493,3803,9878,9877,9874,9875,8459,8469,10171,10171,10187,8446,8445,10272,8363,8423,8891,8892,9082,10399,10451,9207,10011,10400,9224,10706,10759,9649,10702,10401,1257,9674,9401,9297,4401,9968,10938,10802,10991,6342,7852,8963,11089,8437,10667,10888,10887,11188,11402,7080,7661,11370,7655,10768,7655,8721,8737,9658,9199,8712,7933,9398,11189,7920,8193,3904,739,7759,7839,4950,254,4411,4258,4209,5542,4234,6104,5339,5286,1253,7857,501,5331,5286,2976,3830,8183,231,6858,2294,338,1461,8183,4355,7304,3080,1347,4460,5545,2933,231,1520,1461,5516,640,254,1119,6632,3080,3613,1681,6248,7126,4796,1119,1762,7883,6245,6256,8548,6248,6255,8502,3976,1699,5543,6249,5732,7839,419,6250,9372,1485,8819,6740,6740,6971,7072,3897,3893,3883,7270,3885,3884,3895,7655,3882,3888,7094,7123,6740,3896,7987,7903,7088,8063,1770,1765,1771,1767,1769,1766,2183,4936,4944,4945,4941,4940,4943,4942,4939,4938,6644,6644,8081,539,8080,8384,8478,8288,7840,529,6493,7879,3894,7672,8273,7903,7019,7663,4801,8361,8306,4801,8306,8358,6971,2876,3828,8343,8602,8601,7293,6075,8547,3264,8389,7080,1126,7985,4454,3557,8526,6645,528,545,7079,531,544,1461,553,8401,8793,546,524,4512,4046,344,215,8425,4316,4046,4316,4316,4046,5298,3913,6710,7253,7254,6809,8401,8425,7089,8438,8213,8909,8213,8909,8213,8909,9055,9794,9741,9054,6104,9726,9358,9829,9880,9361,3511,3510,3511,3510,3511,3510,7252,9608,9594,5576,9610,2869,9611,834,8229,9609,8832,3510,2473,2530,7386,1738,217,545,6843,1520,1520,3609,7239,7239,7879,3754,8222,8222,4566,1954,3863,3863,3863,4969,4969,6377,8793,8793,8547,7897,7304,6977,6139,2882,5997,6155,1108,314,5908,6102,5256,2113,3037,4730,4766,6104,5995,2324,5247,5088,6829,931,4412,1825,5883,2156,6633,1052,4898,5962,6825,1038,6006,3358,6364,7878,4555,7276,2845,6741,8095,8064,7262,8022,4130,2594,8078,1010,8403,7719,4770,2182,8141,8516,8306,1645,4728,4254,1257,4767,4233,8578,1559,5373,8722,8552,8289,8639,2989,8,3989,6154,7374,8841,8095,934,8587,8915,3262,5763,3297,8144,4337,8615,2381,7919,5837,8484,6907,8836,7904,5065,5066,7834,8580,7836,9058,4670,9305,9318,9269,9254,9333,9387,8220,5267,9421,9322,9365,9459,9509,9338,9479,9403,7928,6103,8628,4800,9366,9526,9641,9656,9763,9770,9028,9136,9527,9406,9798,6857,9648,9347,9634,9871,9930,9942,9750,9947,2985,9030,3479,9968,10008,9950,9935,6738,8776,10060,9978,10011,61,5477,3933,10061,10079,320,1268,1536,3162,3612,10108,10172,10128,2093,9951,9954,609,9439,9045,9032,7833,2137,10210,10228,9998,10221,1815,10303,1816,9214,9059,8891,3701,10354,10338,10307,10366,10375,9832,10351,8139,10482,9245,9807,8828,10523,10481,9373,2025,10615,585,3904,9043,10666,10648,5795,10258,6700,6548,10569,10244,10568,9904,8900,9831,8837,10548,8925,6713,10870,10880,10895,8888,8901,8902,10857,10767,9086,8089,10702,8800,10911,7828,10619,10620,10705,10621,10899,10142,10903,10935,7807,179,4767,1506,6559,6663,6876,5088,1520,793,464,5907,6001,308,585,600,6162,6168,358,3892,5647,4969,228,7258,6813,7304,6766,6954,6812,4217,7160,1830,6794,7144,6780,6155,2328,2506,6695,2863,6831,6802,7838,3046,7783,4983,6767,2419,7602,2573,6160,7146,8020,6159,725,3728,6811,8093,6588,7143,6605,6971,4570,6128,8096,8526,6726,8230,7822,8503,8836,6172,7304,8611,8184,8512,7887,8109,6348,8852,8489,7897,8869,6104,8869,8032,7850,6809,8118,6845,8903,6104,9075,9116,4860,8630,9052,3725,7920,2023,8500,7839,585,8948,9366,4220,9354,2925,8933,9369,1490,8955,9541,8806,9069,7022,9543,6135,9453,3549,8543,8305,6117,9647,9648,4765,341,9200,4652,9345,9374,9348,1349,8934,9346,9939,9249,9248,8795,8915,8805,8935,9924,6821,8492,9922,4566,9941,9928,4566,8501,4128,9402,4061,8031,10057,10208,9910,9117,10063,7759,4056,3936,10227,3100,1698,7138,6683,145,6986,6635,6793,6684,9991,4131,10039,6679,9363,7761,9258,10341,6595,7354,10548,7019,10688,8222,8793,8222,9195,9552,9925,10245,9993,5236,9000,9027,9282,10762,9034,3595,10879,10938,10528,10955,768,10893,8829,9352,1127,228,11127,9749,9065,3964,4635,4656,5046,5193,7760,11021,9038,8629,11122,308,4023,10246,6314,6779,6169,6674,180,148,6639,180,3493,2261,11324,6686,8808,11324,9379,7147,8923,8781,8257,3059,10572,10535,8539,6792,10573,11213,9467,10906,6713,8769,11489,11377,7077,11220,7156,11361,11439,7077,11361,11439,9629,11018,7077,4537,2294,9055,9204,8048,4046,10915,11124,9639,2019,11353,11599,7661,1895,11287,3288,10719,7662,10623,11125,11521,9638,10623,9220,6713,10042,10623,10042,7125,11126,11724,2923,10895,7084,5368,11678,11760,8709,8368,11237,11692,11501,11693,11803,11867,11868,10630,10272,8056,11867,10689,10623,11502,11777,10624,11647,11210,10625,11349,11336,11273,11488,11274,11912,11028,10787,11279,11275,11542,9609,8548,7839,11262,7281,9259,11958,11020,8999,11337,11534,1052,450,8648,5821,4178,9418,9771,9277,3428,4901,7989,9676,207,28,57,173,923,956,8763,7773,9378,947,1207,10814,1095,2913,1370,10454,10229,1520,3059,10278,9661,9993,130,9207,11516,11324,11679,10938,11219,11455,4395,11669,1198,1210,1234,958,2736,2451,2995,1425,3595,311,466,5602,3646,9546,4778,10548,7777,10823,11228,11621,566,11352,11812,272,9554,421,10091,3875,5454,8668,11361,5193,11785,435,6326,8967,11468,11620,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,9430,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,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,10930,9657,11838,10734,11593,10744,8885,7807,6821,11354,9555,11871,8436,5995,11355,254,11981,2294,10569,10543,7919,11965,11356,11873,3066,11984,11357,7238,11645,8220,3244,3003,11423,10342,7592,3376,7755,7754,7554,7019,8222,7761,8845,4109,9195,1662,4796,7837,7834,7835,7836,8441,9297,9552,7003,8851,9614,9300,9030,9960,9925,7641,8617,9548,9879,9897,10056,9525,9463,8296,3989,7634,6726,6849,6971,9890,2164,8281,9488,10526,9085,10265,8948,186,2632,10836,10302,10471,8962,8726,10549,2261,10480,8816,10531,1461,11121,10464,1645,11128,11230,9951,9000,11325,7909,11304,176,9814,8995,10064,8109,6712,650,8512,3849,10656,6571,11089,10636,11494,10040,11644,9993,11741,11219,10938,11324,11455,10548,3595,9993,6876,8388,11457,9634,11302,6894,8953,3493,8903,1917,180) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC