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,1699,5995,6117,3041,2705,5999,5328,6315,4131,2514,6314,4023,5180,6595,4682,6639,6674,6560,2590,6635,3368,6686,1113,6793,2337,1298,252,3396,3542,3413,3055,2419,6713,4082,5373,3715,2967,6710,6857,6700,4136,1521,5596,6862,6863,3376,1992,6861,1698,2737,5812,6478,5379,6779,5142,739,6595,5739,4886,361,2046,3962,3135,1299,7016,3625,6782,5875,5349,3041,1164,4209,3534,3195,4805,3139,6979,7025,4553,6699,6734,6697,4048,7156,5047,5246,6694,6397,3941,6337,1698,7209,7005,6986,4875,5536,1067,5222,4570,1992,6661,5885,2737,7356,7558,7559,7582,7156,7550,6711,7709,3376,7593,6665,7143,3976,7857,7815,507,7875,7821,6694,7760,7896,6697,7876,7920,7581,7777,8016,7774,2944,1432,5536,2294,6673,8089,8102,8140,8184,8215,1559,3904,2894,3195,4432,8291,5817,3775,4355,1835,4625,4740,5545,1347,3976,5081,4460,4741,6707,6478,1698,3941,8306,4739,8224,8543,8547,7025,8016,8104,7615,6858,1432,8480,5545,8175,8174,8629,3559,7016,5013,5875,8632,8687,5807,5328,8561,1347,2294,5543,504,3431,3474,7251,1521,7140,8782,8777,8809,6732,8819,4613,8812,4766,8801,8846,8813,8904,8905,8911,8208,4553,8916,4773,3244,8979,8978,8224,8104,3139,6665,4741,6699,1300,8974,7815,5906,9052,9072,9122,9017,9036,8888,9195,9196,9197,9200,9038,8704,9212,8231,2092,9220,9222,9223,9224,9255,9250,9273,9289,9291,9300,9301,9298,9242,9308,9317,8110,9278,9334,9347,9335,9337,9352,4049,4539,9363,9365,1257,6709,5995,4178,6713,6589,6639,6593,4234,501,4234,2474,2932,5629,5175,2246,1586,1196,4599,3189,6858,6947,5266,739,7138,6708,5636,1487,504,834,2841,6732,5215,1196,405,360,573,529,546,547,7138,545,7883,2933,608,2294,3080,1347,1462,3368,2473,4801,1038,5995,1095,4597,6849,6642,6192,6192,7759,7759,5142,7840,7879,7878,8290,8517,8517,8517,8517,4355,5020,1998,4185,3963,5386,5400,5322,5215,1230,5917,1586,5996,24,3913,5764,4082,5885,6117,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,233,7304,7972,1016,6010,5572,7973,6364,6103,8144,2023,6255,5763,8629,7640,3908,7607,7910,8629,8687,8629,8091,8093,739,3850,5331,1433,3368,320,5764,3715,3542,1559,6117,5373,6635,4131,5331,6559,6782,4185,2294,5349,5542,5142,3625,5717,3368,6713,1038,1299,512,2160,5215,511,1521,6315,5020,6639,1347,3037,6693,6595,6548,3080,5339,2933,6858,922,608,6154,24,6700,5247,223,5885,6367,3026,3904,5875,36,5837,6584,30,239,6674,748,1536,1576,736,585,104,510,6713,6560,1253,504,754,3474,6862,3863,2387,768,1067,1113,1347,1872,6793,1523,7138,4028,1526,1569,2381,4194,321,2660,2419,7005,2639,1055,5331,4126,511,4061,6188,2299,1647,5764,3413,1727,5614,5817,4362,6845,955,7358,6809,6104,4923,1568,741,3419,1823,3561,3933,2976,3701,6699,3936,967,5236,2590,7839,4553,7012,1134,7025,7883,784,1920,7759,3117,7780,3134,7840,3129,7876,7760,7712,7859,7879,7821,7858,7855,6981,6315,4624,7865,7856,7719,5543,6734,2882,6697,7920,7896,6679,4258,4460,6986,5545,4566,7126,252,1268,4969,7354,2244,7919,8089,3100,4128,8000,7156,4901,6684,4082,6337,6314,4730,1073,5047,1439,1127,1298,7550,8543,6131,4886,7840,6740,7238,8220,8215,8225,7827,5739,7559,6117,6365,7981,7138,8900,1311,6945,3195,6478,4432,8888,8902,6136,2018,360,1698,8901,3542,7605,8146,1521,156,9036,969,9200,9279,36,9116,739,2387,6713,9329,9244,9372,9322,9374,2944,3542,9273,7580,7138,1349,9258,1215,8306,6337,1521,6942,8925,7038,8681,9018,9051,8698,9050,8687,9109,4023,1432,8031,1257,9406,7005,6663,6664,4652,8514,8795,8805,9363,9454,8910,9402,9391,9333,9421,9335,8978,9346,9366,9308,9197,8934,9248,7839,2514,8817,5180,9041,2841,2246,4679,4504,609,7354,8254,1005,9249,1586,8935,9471,3549,5334,8794,7910,8547,8955,4765,6780,4194,5215,1576,2117,8915,752,2387,8193,8019,254,5516,4538,6684,6642,5121,9459,2709,4405,2669,428,9600,2123,5602,2118,1762,9604,9606,5379,1681,1572,1498,6874,9627,5640,3613,4099,6867,4056,3457,3964,228,8629,1080,9038,3023,9638,2743,162,9455,1121,9634,7581,1119,9335,5046,9653,9657,6663,9635,9383,9677,9665,9345,6740,2530,510,1349,2389,4338,2766,2944,972,1245,6354,6849,6858,7238,2137,320,1095,2253,6644,1070,6732,5142,5134,5707,6730,5837,7304,1268,4983,4128,3701,6693,6857,6315,252,2253,4099,2244,5657,4401,6962,6364,7303,3046,1000,6190,3244,322,7239,5582,2467,7146,223,5582,7598,7600,1073,5602,464,6633,1029,7631,4079,4432,5678,6671,4349,3595,5784,1265,4128,1650,926,1917,1461,3595,986,6190,6609,1462,1084,4767,1681,1461,4209,754,6705,5371,6809,4566,6845,6103,4046,4049,6245,1016,6561,6249,6980,6104,5717,4050,419,6248,6252,1815,2245,6804,6766,6589,6793,4086,1526,768,6686,6588,2706,6679,2417,6635,6856,6639,6684,7138,1270,5148,6726,7156,2342,6674,916,6314,6595,2169,5371,4023,6858,7158,3080,5339,2294,1895,1119,7050,7160,2923,2703,2123,5573,608,4061,2006,752,1349,1127,1253,8543,2933,8683,6713,4460,7138,1432,5373,7354,5812,4048,5266,3080,8687,8978,8925,8548,8910,5545,4652,4566,4258,8905,8795,5817,6684,9086,9030,6635,9000,9050,5339,5020,7126,4460,1349,1347,3701,8904,2933,9196,8688,9079,5157,6117,1299,4553,6696,9353,8632,9363,1298,6632,8442,9258,8102,9406,6698,3195,9200,608,5726,5349,3542,8978,6337,9347,2118,3159,4131,5331,6635,6595,6315,6010,6595,1765,5837,5286,5321,3921,6639,3941,4088,4539,3896,4950,4463,4773,4596,2025,1371,6863,958,6703,4670,4739,4740,1461,4878,3625,4875,2337,4136,7016,5373,252,3885,848,7363,1521,5081,5142,3542,947,3890,4131,7550,5995,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,233,452,6275,7986,3059,3059,3059,5535,7839,5386,1165,6359,5332,6521,4701,1266,6201,6198,6200,6199,4282,4301,4299,4293,4302,4305,4297,4301,3515,7693,6505,6533,6532,4286,4304,1704,4289,7972,7973,6218,6197,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,6348,2447,6795,186,6691,7559,8248,7505,7496,4769,6971,3073,6691,8305,8220,9038,9108,7374,8780,9200,9215,9323,1572,2265,9380,4553,311,9258,9372,9648,9666,2522,8583,9281,8584,7311,9281,8882,8878,11039,11053,6596,748,958,6710,3989,1953,6593,1038,6779,6103,6947,3550,4131,6804,6842,6986,2261,6858,6863,6691,5142,6315,5995,6981,1461,7126,5046,7019,6548,7005,7214,7036,228,7138,6890,6632,6693,3702,7156,7221,7304,7050,6633,7143,7354,6104,3561,739,1521,7758,7760,7582,7718,7614,7759,7596,7709,6856,7830,7795,7869,7359,7883,7804,7880,3625,7896,3609,7875,7751,7897,7995,7992,8031,361,714,8109,8032,7991,8183,8089,7839,8096,8102,7559,8146,8222,8300,7938,8185,7920,8150,8293,8390,8230,8103,8299,1345,840,6642,8483,215,8302,8226,8548,2473,2467,8306,8526,8305,8358,8554,8611,6076,1815,8561,8535,8547,8514,8615,8629,8687,8659,8614,8479,8688,8802,8801,8632,8759,8744,8776,1920,8829,8807,8809,8902,8888,8901,8793,8999,8918,8911,9030,8841,8846,8900,8916,8925,8923,8781,2005,7912,4716,8686,9153,6715,1462,9086,9195,9220,1296,9296,9308,9198,3823,4671,9322,9324,9202,9200,9363,9348,9289,9291,9454,9420,9419,9258,9480,9453,9402,9372,9614,9335,9637,9376,9680,1380,8108,3337,9524,9552,9751,9763,5784,7849,9479,9810,9812,9674,186,9616,5956,9543,9062,9386,9829,9934,9879,9925,9668,9951,9904,9916,9482,9931,10041,10114,9913,9990,10142,9941,10042,10125,10149,10063,10128,10126,10115,10174,10020,10188,10245,10246,10236,10131,10248,10229,10208,10227,10211,10282,10148,10243,10244,10212,10065,10305,10319,10265,10279,9936,10269,10268,10338,10342,9603,10293,10436,10466,10290,10505,2635,10438,10491,10375,10488,10535,10526,10485,10127,10548,10528,10527,10569,10273,10627,10676,10631,5769,10339,10681,6658,10731,10760,1979,10775,10649,10841,3327,10294,10721,10698,10826,10839,10955,10940,10895,10687,10932,10766,10938,10802,11024,10992,10872,10987,10416,10894,10402,9925,11872,11902,11021,11027,10113,10817,4136,7582,2337,7016,1920,3625,5005,5286,1257,6713,7759,4741,5081,1521,6866,7875,4258,4739,6707,1895,4131,2703,3936,784,7839,3129,3542,5614,4082,6986,2294,4209,4596,748,3080,4566,1134,1439,3413,4656,3117,5817,1347,5732,3134,7005,2944,3913,4460,3115,3976,6117,6793,1738,6595,608,4100,6639,5339,1253,5545,1215,6684,7126,3341,6858,5812,1347,6314,2933,7138,7156,4652,6713,608,6635,7559,6858,222,1349,7581,222,6857,7550,836,6679,2023,3454,797,4088,7839,6674,8220,6703,7354,2875,4773,5025,5541,3368,8031,6686,8548,6337,6942,8548,3080,6986,2737,7875,4513,8134,4194,7615,5379,2944,3263,1127,3162,4432,3195,2419,5629,6732,3201,3701,4740,4613,8543,1432,5477,8224,2387,8615,5175,8006,1532,1298,4539,8146,8587,1089,4875,4023,1698,609,2446,8535,8105,2594,3003,7896,6861,7709,5807,6124,6809,4411,5215,7362,5536,3558,8089,3244,3391,5020,6704,6595,2018,3559,8175,507,1439,36,6845,3139,3288,6821,6880,4538,6610,4258,8999,8900,8837,922,8101,1350,645,3370,975,1181,4160,2192,4423,396,3797,1738,455,734,1131,6192,744,5877,5362,766,4972,2674,5179,5764,4696,4861,2632,5247,1038,5764,2381,4730,1152,2882,4766,1057,1890,1439,1532,5543,2192,2331,2360,4240,3761,1042,4830,1835,1176,2657,5321,1177,7156,1826,1190,3062,3775,1461,6848,6780,1600,5321,2876,467,1176,7761,5487,470,3059,1092,3590,3303,1098,4964,3844,5765,7019,1600,1416,4947,2261,1460,2760,3136,4164,5218,3493,4984,3830,4348,6981,6104,5995,7834,1522,1869,2639,7837,7995,7836,8150,8146,8135,8000,7354,8087,665,7919,1416,1038,3303,5764,3590,3989,5623,8183,2033,215,5179,3844,6824,219,243,261,360,3067,3303,3341,3415,341,3418,3482,3778,8150,3788,4217,4722,5306,5509,6827,7835,6632,8089,4652,3941,5362,1257,1253,1318,1432,1325,8306,6154,3368,446,3830,4337,6713,1349,5576,1521,6595,1532,4652,3761,4460,1461,1038,1690,6684,5545,5719,7708,1369,7920,4395,4131,7812,7138,7239,3542,7839,3941,4082,7783,4209,6117,4566,6793,7919,4258,4796,7020,8305,4983,7836,8222,308,5997,7821,7760,1347,5657,7803,8025,6849,8020,7835,6780,6156,7212,7147,6813,8923,8869,8890,4131,8925,8901,8900,8846,7839,4209,9054,8055,8080,7110,8044,665,7582,1253,6154,6315,6639,585,606,736,6674,8911,6942,6694,7712,1690,2025,2135,7602,8089,8306,6782,7138,3904,6863,4355,4220,8019,8615,8222,1461,9195,2590,7106,7096,223,5020,2933,6010,4023,7857,734,6785,6673,8025,7138,7005,7859,5286,228,3933,4801,5148,5373,5349,5339,6901,8543,7837,7835,7834,7836,8441,9376,9073,9528,4128,6130,5893,6157,5070,4659,1381,1402,6103,5542,2137,675,1016,1038,946,5331,1954,6779,2032,2677,1385,5247,6642,1439,6364,4985,3908,6986,7101,5764,7097,4898,5142,7074,7092,7075,1461,1145,6118,7298,7019,4424,7261,7289,7239,7267,7273,7271,7285,5961,501,7158,7272,7208,7036,359,4079,7296,6740,7605,7579,7797,7245,7089,2674,7269,7097,7906,7937,2976,7835,8093,7264,8041,8144,8057,5764,7287,8169,7266,2046,2389,2025,1461,2389,8187,5142,8052,4563,7939,7154,4624,8293,6740,8423,2381,8411,8237,7982,2261,8258,8305,4639,2658,4766,8480,8483,1298,8417,1917,7994,8079,8459,8853,8062,4395,2913,8894,8769,8426,8810,6891,8955,8306,7037,7761,3346,8763,9083,7957,8651,7659,7239,8201,8658,2882,8547,8736,7210,3261,9308,9261,7775,9160,8055,6589,7900,5455,8736,8055,4131,1029,9277,4597,9561,2052,9580,9038,1453,9647,4983,9562,8477,9446,9754,4079,9834,9444,9344,9136,9313,9258,8046,9367,9544,7073,1272,10009,10027,9450,30,10025,9821,9757,665,9316,9594,9954,9530,9257,8711,10056,10123,10261,10274,10125,10297,10144,8472,8019,8052,9575,9161,10512,10535,10353,10364,10182,9999,10356,10451,9370,9091,10541,10570,10694,10693,9158,9509,7261,10767,10039,10145,9259,10582,11134,11230,8062,10476,11116,9594,11337,11371,11671,11542,11651,11654,11225,10399,11476,11538,10401,10030,11767,9999,11805,10814,10582,11802,11794,11890,11754,9259,8740,8424,9086,7865,7864,8902,7858,8919,9270,7855,8808,2698,3844,2705,1915,6635,3540,5636,9363,5210,8837,1812,6686,9353,5142,9638,9454,2261,8925,7016,3625,1520,3542,7614,1917,5623,5435,7582,7138,7222,7156,9928,6661,9937,9913,9668,9780,9456,5995,5148,1137,3941,4048,180,6842,5286,6595,8500,4131,7354,3921,5088,3976,1461,6707,9808,9464,7875,9661,6632,177,1325,156,4860,5541,8306,1586,6703,9552,3493,4513,4947,4670,10046,10112,6683,4240,4100,4088,4950,145,5005,4740,8819,9983,8846,8829,8890,9258,9925,4355,4566,4337,6679,6710,3904,9910,6986,10229,4023,5331,1954,7005,3026,6863,3744,2894,8615,10227,6684,5542,6694,7156,10523,10063,8031,9373,4233,4767,585,2054,4045,11304,3213,6632,104,10472,11302,4875,11619,4455,5995,5179,3059,4739,4234,8793,2632,10212,4596,9453,11644,4741,11455,10375,1490,9993,9052,4178,640,10128,8745,10473,4773,9471,9942,8923,7156,4131,9363,6595,9639,9353,10395,10057,10042,8888,10469,10039,10472,10569,8514,10341,9800,10245,10246,10523,9910,10745,10397,10743,10568,7354,8808,6639,7138,10048,10289,10342,10935,10934,10990,9983,10783,10892,10653,6684,1767,7631,6354,6220,1768,1766,1771,1765,1770,6688,9920,1769,10176,10098,3073,10175,3071,8583,9880,4714,6689,9679,3070,1266,8727,2506,272,6198,5810,9824,7881,7752,10053,9665,8899,8897,10067,8896,6200,9867,9031,8489,6215,8668,1766,4842,4286,6218,4297,6216,2794,2791,6497,2789,3071,6880,675,2786,2785,2787,3465,2783,2781,2779,2780,2782,6443,7868,4304,4293,10258,2778,979,7311,10238,9473,10251,9669,4224,2951,1970,6679,9477,10188,3385,6002,8233,9073,9243,9478,545,8714,9383,9476,529,40,10055,3358,10294,9483,5207,1690,7185,7184,8815,4223,9632,3525,1369,138,7178,7179,7632,7189,4386,7176,9921,9637,1137,7187,6198,6362,1325,10258,10398,6382,10608,3875,7837,7834,9376,10607,7835,4931,3254,10552,7836,9297,10467,10536,1557,10568,10232,4,510,9474,7771,7770,6688,511,512,7637,9626,867,9067,9625,9670,9671,10612,8729,9475,8881,8161,10364,9624,10626,8882,8878,10642,10647,10639,10643,9880,9625,8880,10644,7569,7762,4804,7567,7570,7764,10298,9493,7698,10641,8016,10640,9906,9907,9970,10043,10253,10255,10256,10637,10646,10254,10752,10531,7300,10645,3165,10521,10753,10548,2261,6855,222,10522,1520,1917,3059,1461,3595,3493,145,8306,4178,5995,10212,11105,6710,7019,6876,7761,11032,8222,8793,11031,9195,9552,9925,10229,11106,9661,10397,10315,8965,9675,9655,3874,4923,4146,3409,7172,3511,10749,10938,9993,10544,11033,7753,8627,11109,8088,8946,8945,10927,8944,8668,6263,10975,11121,10641,3236,9933,7810,8110,10239,10821,10822,10931,10930,10840,10639,10637,5066,8943,10748,10926,10928,10797,4923,11255,11252,11254,11251,7592,7554,7754,7755,7756,7927,10564,8509,11246,6740,40,6683,145,9635,5,173,8978,10207,11217,11240,9363,6639,4023,6732,2843,5431,8220,9300,7238,7912,11325,7849,10056,10836,1368,28,6598,10637,848,7580,1769,1766,1768,145,8175,1765,10893,1983,7304,11101,11395,9072,11397,3327,11398,11401,9543,11382,30,152,801,9,11383,1230,9352,8389,11381,11328,11431,11421,11171,10057,7356,6773,11396,10687,4510,4752,1973,10788,11442,5363,122,10827,6359,1411,9466,11479,11473,11476,11359,10829,11478,11480,11468,10278,3014,6727,5513,11177,11477,6692,11416,10520,9149,8154,8002,11067,11071,9322,11517,11181,11550,8904,9677,11342,9378,10350,8688,11598,11552,4329,11175,947,4103,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,233,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,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) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC