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,3830,2261,435,961,2389,1461,721,5262,5996,5576,5267,2989,6691,5484,2447,5965,5314,6210,964,1051,1050,1049,3863,2830,587,856,2893,4598,2520,1052,4599,4602,4600,3864,4603,3440,5208,1981,4154,4068,5098,4181,2989,5351,4898,4076,5952,5351,1056,6907,2393,5951,5959,5927,1010,961,3702,3402,2653,6740,2530,6792,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,7146,223,5582,7598,7600,1073,5602,464,6633,1029,7631,4079,4432,5678,6671,4349,3595,4395,396,567,464,6782,6891,5551,1029,231,1834,6365,7146,2753,6809,3029,5421,1738,6845,6831,7634,6785,6364,2029,6813,6644,1402,7593,7838,7592,3850,1462,4769,7917,6967,840,840,840,840,840,840,7898,7898,7898,7898,5947,5947,5371,3549,6588,7938,8185,217,7995,8182,7837,7834,7835,7836,7992,3850,1184,8019,6979,5334,8093,6780,8305,8441,8222,3520,6712,8489,3131,8541,8555,2506,7869,4765,8019,7840,7879,7878,6971,6104,504,6103,7239,6364,3728,1232,7019,6981,3531,7374,5914,1145,7878,7143,7840,7761,7872,7903,7937,4535,7910,7938,3549,867,7358,2389,3419,2182,7770,7771,8169,511,7911,8222,7108,8231,3029,8288,512,7637,8358,5995,4983,7085,4765,4985,8469,7271,7828,3115,3559,8174,2117,8547,8626,507,7928,8705,8704,8706,2473,8706,8480,8304,8706,7125,7775,7077,3725,8683,8087,8818,7751,7972,7973,4406,8213,2989,8908,8909,2989,8776,8836,8910,8947,6821,8816,9029,9009,7599,8943,9009,8944,7595,7881,4969,2029,4983,3169,8141,3532,9198,6138,9202,1230,6138,8812,7589,4701,9216,9278,1770,9307,9331,9330,9349,9334,7998,7999,9277,9422,9479,9546,9212,9558,9612,9613,9646,9649,9383,4985,9727,1768,9736,1766,9770,1890,931,9767,9759,9386,8543,2294,223,9799,9887,9871,4405,7265,8419,9978,9884,9979,10001,10001,10053,10072,10001,4784,10111,9378,9989,8211,10073,10108,10073,10121,8780,10121,10225,10237,10247,10104,7139,9148,9377,10219,8554,10163,10124,10261,9900,9093,10123,7675,9116,9834,10293,10273,409,9257,10492,9423,10531,7777,10543,7766,10543,8914,10543,10209,10129,10127,10467,9136,10818,10724,10976,10649,8842,7634,10412,3647,7834,7882,1371,215,2117,2117,2160,7781,7783,186,7238,8097,5763,6364,8093,6785,1183,8358,8358,8281,452,4079,4079,6588,8850,4535,2328,2328,8889,2911,2615,7900,9080,4983,6139,4985,9286,7037,8554,8778,9213,7951,9403,7020,7388,3860,6104,4985,3549,4395,1302,1302,1302,1302,1302,1302,9815,10615,979,9136,8228,6586,2605,10302,3830,6197,3989,4580,275,4860,1165,4234,3860,5535,726,393,2882,2160,4730,6154,1537,4131,5996,6545,1137,543,397,6138,6040,6559,4023,725,6686,6679,6197,7879,7840,7143,7878,8220,5764,7903,8183,3784,3263,215,8222,6750,7998,7638,5995,3761,419,6981,1506,501,2706,8306,3059,971,1215,4178,1257,7833,3134,3368,8542,8616,8488,7840,7879,7878,4259,8529,8306,5143,466,252,6204,6539,7631,7870,7582,4136,3542,8434,4788,7896,8611,8615,3413,2261,7641,7837,7615,7903,7834,9144,8983,6713,9300,8842,9130,7910,9547,6023,10119,9220,9807,10548,10244,9752,9770,10523,10526,9924,10300,36,10688,11733,11346,10569,10892,10734,9811,10674,11325,9831,11380,11101,10687,11749,11215,11311,6809,2261,2989,7597,2261,4566,5576,7840,6845,8220,6104,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,6792,7559,8146,8222,8300,7938,8185,7920,8150,8293,8390,8230,8103,8299,1345,840,6642,8483,215,8302,8226,8548,2473,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,8289,1645,3647,2992,6817,6366,7795,2117,8027,7986,6870,7987,8272,553,524,526,545,540,536,528,543,544,551,537,533,550,6042,541,548,573,549,538,535,546,539,547,531,529,532,542,525,7238,1371,5995,5962,6103,6845,6104,7576,6691,6632,5763,6843,2615,5142,6348,8150,8281,6809,3030,6984,6394,2635,5782,186,6210,8230,6726,6693,8305,931,7970,7640,3647,396,3761,8744,975,1057,8306,4535,4834,8780,3131,8169,4131,8514,7903,182,2989,182,2522,5484,6117,7146,7615,7121,8910,9245,1402,9406,9116,7920,9431,9734,6744,9178,9408,8246,8244,8087,8067,9225,7704,6380,6416,6612,9734,9178,9501,9806,4286,4289,4304,4298,4299,4287,4292,4302,4296,4305,7311,7610,4297,7083,7697,7695,7696,7868,7694,2951,3442,11184,11149,11183,11181,11252,11174,5297,11182,10920,1704,11037,11179,11178,11231,11173,11175,11251,11185,11229,11177,11176,11186,7304,7548,8230,8526,6971,7112,8109,8109,6726,6726,7175,8483,8547,8151,8019,7774,4983,6891,6715,3428,2849,6691,3549,7773,1016,470,421,4535,1593,4423,3797,3728,6131,8810,754,3728,6618,2830,6733,8773,6832,6536,8887,6536,8887,1511,2989,4898,7982,1765,1771,2925,8547,7787,8514,7037,8834,6576,8547,452,5763,7837,1266,7834,7815,7835,6354,8547,3070,7579,4405,3071,1371,1771,1766,6648,3531,3076,8627,186,8659,1461,6947,6103,7836,5763,2546,1016,3809,8583,3908,8584,4659,7870,8793,8716,7816,3536,4227,104,1906,3346,8586,7189,5385,1887,4216,8825,4339,6824,7167,7580,7170,7993,7165,1771,1765,1769,1768,8578,4931,8437,7166,8627,5371,9322,9757,2331,1245,4964,6221,4178,8324,6740,7238,6270,1557,1380,8220,8247,5763,7300,217,6508,8345,8490,6512,6510,6103,6199,6533,6373,6768,8244,2989,7923,1303,6831,2374,735,9001,8151,6880,9243,6855,7594,510,9505,8869,9921,1052,9450,5839,9900,10228,4405,452,4800,10305,8135,2164,1557,2164,9931,11134,8435,8257,10086,8922,11352,9871,8262,11437,5997,1049,10741,11101,4362,8377,11519,4720,6806,11670,1803,1831,3824,1016,4983,7775,6700,7903,6600,6693,6139,5188,3595,8169,1738,322,675,186,8358,9030,9130,4834,7635,7839,8851,8845,567,2889,8925,8901,8947,1349,7920,7037,8837,156,6266,4805,9033,1738,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,11041,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,11041,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,6371,6175,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,6832,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,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,9865,10844,10667,7639,9029,8947,2522,4259,1591,6788,7605,9342,5407,9061,3878,8689,9674,9547,9320,6103,9757,609,10008,9959,9933,6781,4598,10061,10170,10211,6579,10655,1345,10537,10702,10718,8394,10356,8780,8816,1993,6367,8520,6548,6715,924,8388,5717,2399,4769,6621,104,1142,240,8970,6700,6631,9215,840,6006,9229,5484,1591,6264,2644,7144,8821,5052,6774,5371,217,9390,8833,9281,3327,5770,2253,8515,7838,2029,9468,9027,9322,2117,1371,6131,9162,9513,2006,7861,4435,9538,2005,2085,1052,4395,7923,7976,1242,2989,9480,7992,6642,9524,9479,6103,6004,906,9603,3428,9629,317,754,9306,6691,4079,8685,8815,8814,8826,7576,9704,3598,156,1153,9678,8659,9559,9546,9760,1912,3236,6905,4913,7599,9390,9480,4154,9754,6102,2342,8508,6176,9763,9770,9783,120,6977,9782,6602,9014,7640,9344,4563,6652,9762,6623,8352,9812,2843,9830,8685,6841,8292,8544,9006,9879,9865,9866,207,9872,9918,4216,5419,9926,6819,4320,4900,3884,3926,382,374,7069,7298,2009,8166,1537,7879,7104,8390,7878,1537,7078,6740,7238,2843,7290,8095,8094,8488,8587,186,7155,7649,8741,6754,5576,2869,1351,834,8381,8886,7932,8698,8580,7089,8816,8966,9092,7781,8479,8836,6381,5362,8745,8109,9321,3029,1152,1532,9300,7266,7674,9386,5421,8230,9001,9300,9463,4109,7635,7289,6971,9897,8401,9948,9783,8526,9879,7928,9349,2989,8547,8810,6904,2117,40,6870,8143,9547,7218,417,5822,7597,4801,4985,4405,9460,6979,4563,6264,2761,450,6205,9556,7926,6895,9926,4598,8482,9871,1327,9890,7974,2113,1662,452,8626,223,7890,5,7872,5,10060,9787,2658,8135,10267,5763,2644,124,8648,9553,4607,11025,10240,9546,10976,2032,1823,11127,217,10900,5262,8206,11256,8169,10986,10977,9557,8967,222,9046,130,10080,2200,3536,934,11621,10448,4144,7773,2989,8547,7149,4659,7115,7654,8306,7252,8092,7253,2117,9701,4563,2658,6264,9538,2761,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,6832,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,6390,2989,5380,223,1029,5576,7238,7304,6364,2869,6740,961,4294,5297,4395,4293,7593,1272,2605,1461,2706,5386,243,7179,7599,1371,7022,840,1351,7761,1095,4432,7840,1165,7984,6809,1349,4386,7176,8091,4985,4944,8135,7920,4945,4941,4940,4943,4942,4939,675,8358,665,8151,7239,7900,1126,8547,6600,217,8514,501,7241,7187,6953,7261,6570,6644,6104,8825,7665,8783,4834,8626,6595,8142,8488,7910,3029,8781,8305,6499,6204,3549,7636,8019,5121,7994,8638,812,5334,9007,8055,6780,1645,1345,8047,8019,8780,7751,8816,8955,1073,6986,7224,6710,7932,9308,9343,8842,9647,9009,8620,7640,9465,9258,5678,8681,9546,9558,9577,9900,6113,9945,9386,10046,9959,10146,10240,9601,10353,10346,10349,10467,10002,9257,258,8269,7659,9277,10060,10892,10814,2399,8471,8092,7900,7283,2913,8955,2761,4765,11272,11271,10287,7874,8033,11333,10715,6357,6209,6205,8833,1380,6715,6548,8281,3913,8255,9300,5995,4671,6865,6569,5769,8710,8710,8710,9340,5484,3327,7211,5788,6892,2349,8137,9946,4435,3336,3336,9791,778,8970,3598,8613,3823,1988,1988,7861,6103,675,6831,3409,5947,169,6740,7238,8220,8220,7913,7913,8733,1380,8516,8516,8563,9338,9784,7874,9762,9846,9488,8302,9322,435,4784,6174,9951,4788,4788,1207,8885,5251,6752,9049,1425,8171,1198,10235,8171,1533,6691,6691,2447,7396,2294,1253,5817,5545,5817,1347,4258,7883,608,1699,7126,7920,8999,9937,7849,10065,10292,5339,10065,5295,6691,6691,8171,10568,8111,6691,10296,10211,10671,1296,10664,7591,9812,2294,1253,7143,8547,7903,6642,8952,8358,8514,2029,8948,8922,6740,7641,8220,7238,8912,3850,9030,6849,6845,9300,6104,7019,8780,446,2658,9212,8520,9366,4178,9386,4178,7833,9366,186,8306,5995,9159,8816,8169,9936,10056,10126,9079,10240,2925,228,10815,6113,5175,665,6141,1533,1073,4199,1051,6158,2913,1050,186,2530,5576,6633,435,3904,6001,1145,2182,2261,176,4154,6962,446,1370,466,2490,5421,3989,1272,1770,1126,7607,6785,6845,1038,6986,6158,8358,8547,431,7265,7661,8947,6130,8047,8034,4068,5142,7605,9558,9652,7143,9959,10060,1769,970,9053,7164,4464,8282,3872,134,10238,2736,9378,10531,9920,9264,7607,7913,8714,8876,9607,9824,8828,11201,7655,7674,10315,7661,6119,9608,11363,11713,11117,11631,11632,7252,11674,11312,10506,11683,8517,11108,130,10649,9828,10754,8279,8294,4405,8358,8836,8296,8296,358,7840,7840,8850,6971,7840,8230,8230,8230,9390,9984,8290,8290,8290,9888,8358,5402,6832,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,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,9799,5647,8306,7020,10339,10526,5995,4801,11101,6740,7238,8220,446,223,2117,10836,8388,8302,1371,2913,5567,8520,11497,11497,11226,11770,10937,4405,9116,239,2490,8095,6119,10955,2063,10285,10092,10093,4144,8922,8628,10165,10133,10786,10552,10287,9547,10913,10286,8952,130,8995,2469,144,8008,2653,3304,4722,10702,2671,9349,10626,10830,3165,6325,8870,8844,2454,9828,10805,2753,3908,4659,10257,9767,8995,10165,2490,3590,10865,8933,10836,3465,10241,2334,4164,5839,3646,7234,9983,9864,1185,3282,10715,6780,3549,4423,11271,2253,8706,311,11435,10260,11453,7785,7586,11134,11383,2628,8304,11302,3415,10714,8169,9895,1232,665,9538,11669,8955,1052,11609,7824,11382,7777,2658,9014,9354,11272,2934,9281,1593,11620,9473,12011,9647,9078,1755,5623,8255,6953,5371,104,8869,6181,9135,9049,7774,4395,4146,10349,9543,2897,10228,9405,1770,9758,10339,788,10309,11010,120,10754,10985,9543,4659,9340,4568,1782,10000,9770,9714,9753,9863,9701,4435,11298,10649,6548,11347,10892,2989,11454,10780,11622,3327,11623,11227,9765,5269,11497,156,11621,10455,11752,11751,11101,11748,11325,713,10670,7374,10940,1823,9257,152,9704,1345,5024,12023,9257,10868,2913,5376,8520,4563,11437,2658,2989,8826,11485,9865,11400,9391,11672,11594,180,8222,11661,11497,11658,9430,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,2261,10255,8953,4788,9389,9387,11669,11046,11030,7635,7913,4765,8205,9655,10672,5459,8408,11732,3878,9390,730,11101,1993) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC