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,525,550,601,933,1589,2390,1070,3264,5848,3557,3828,808,3302,5305,5552,2876,4218,529,3610,3392,4454,3048,3803,1928,1927,6950,6122,5915,6350,713,5256,6725,3754,663,1200,1313,358,6169,6162,2576,6588,6590,1000,1453,725,6159,3216,6645,6168,510,1250,6160,4512,2997,2873,2170,4038,2723,2934,1444,2573,6772,3850,6660,5535,3066,1385,386,254,5053,446,397,1303,2122,2743,4558,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,11041,1265,10667,11900,11951,11937,11921,10438,11324,11736,11872,964,1762,9868,11991,10872,11594,12012,1520,3598,5380,254,5915,6138,5322,409,5763,2092,6638,6361,6190,2897,1084,179,1740,3492,3395,2171,452,2145,3863,6947,587,217,4566,6803,2749,7044,7009,3595,6957,7208,186,6890,1511,6561,7215,6624,176,5070,6812,5956,7159,5081,7579,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,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,11041,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,11783,6595,5331,3904,6599,6141,4598,6190,3598,2830,5564,2145,1500,1565,7374,6190,9159,8022,9460,5454,5567,6740,6588,7238,6658,6796,5769,6394,7548,5567,6834,4923,6809,2658,314,3863,2473,2160,6117,271,4886,6981,4901,4730,5245,7837,4767,423,7834,7836,7919,7903,6205,7835,7821,7143,7833,7761,6478,1461,1325,1970,6595,1433,8222,2992,2029,4160,7760,7760,5542,3080,7130,7130,8812,8813,7852,3169,8250,6397,3913,6876,8098,8098,9222,9223,9224,9250,1536,9300,9017,61,9275,6870,6870,4346,9243,5286,5286,5997,9073,9614,9366,9552,9769,9477,324,9478,9641,9118,2660,8610,8184,5252,9925,9925,9921,4510,10088,10087,10090,10089,10056,10086,10210,10079,2137,2137,3936,3525,10227,10229,9624,8705,9766,9968,9959,5763,10375,10212,7149,4178,4178,10608,8441,10523,9376,6103,9297,10434,7972,10548,7973,10382,7585,10397,6264,10711,10056,10315,7218,10748,10702,5567,7889,10870,10127,10749,10127,10350,11093,9255,11324,11455,11396,3059,4739,11105,11457,11489,10754,11517,11302,10012,11130,11741,8812,958,4741,11789,9777,4987,9766,7655,7286,7143,4639,7976,7080,8109,7897,1487,4617,7069,2389,375,390,377,6066,8078,8078,7279,3647,8230,8512,8611,8306,8306,4570,7910,8991,6907,8282,7084,8948,8459,8740,8469,8765,394,388,8880,8880,6774,7986,7986,8877,4316,5298,5003,958,3059,5175,7021,7016,5379,6809,7374,6774,5279,7307,2342,4574,6006,7837,7834,7835,6845,2261,6104,7836,2644,1307,4979,6880,5236,5373,6713,6368,7020,2944,2387,7238,6821,4624,7951,4901,6658,5131,4406,8222,526,2957,6738,5467,1098,4765,3094,4490,4164,4519,3564,4778,5328,4778,4426,3519,4616,1600,6780,6780,3549,5334,6171,933,730,6216,6222,6501,5093,3532,3784,6523,2725,4029,2300,1823,1533,7078,2457,7748,3085,5386,7172,608,5552,4796,7572,2992,2337,8522,8224,8557,7670,7670,8649,7631,7546,8937,3071,8910,6715,8937,9300,3287,8709,6809,9890,10146,8048,8053,8245,10047,9900,5692,8714,10491,10543,10590,4860,10674,8910,10573,10659,7125,8514,10893,11802,11497,3863,10988,9985,10687,11289,2506,11904,9485,10935,6797,10535,4985,9959,547,7849,3865,4931,6798,531,551,510,6491,3071,7676,1324,2374,1732,8003,532,546,8289,3647,2992,6817,6366,2467,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,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,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,233,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,501,6158,5070,1461,675,4801,2753,698,308,4765,6156,6695,6348,5763,958,6842,1350,5904,6633,5910,7238,3728,3043,1738,2261,186,6845,2932,6740,3830,1029,223,1183,2615,4898,2182,7210,8220,2063,5959,8554,8962,9202,308,6121,186,3647,7783,5763,9198,2117,6364,9392,3172,2925,1232,2658,9422,6103,2627,1766,2727,6656,3402,4834,5551,2685,986,231,1730,6145,6146,4614,6311,1398,5756,3189,6214,6497,6489,5093,6223,6496,1234,946,6212,5947,3302,2776,6261,3479,6214,1741,2677,6221,6501,6212,8000,6496,1245,2696,8023,7638,8233,7304,3904,8485,8220,8628,8306,8783,8933,8361,3287,9030,9153,9152,7117,446,7117,4079,4796,7548,9600,8933,7155,7107,9750,7917,446,9849,9206,7985,9264,10039,8648,7080,10265,10556,8910,11291,8062,1988,11236,11812,1173,11497,10591,11497,8995,9838,11690,11736,9647,11656,11770,11714,11905,11782,3549,5334,11213,9039,6785,10579,11439,9897,7849,3169,466,4788,1303,3511,1215,156,1250,1498,6130,4767,5400,2029,2736,4558,1425,450,5995,3026,4791,1210,752,5729,1762,2743,5431,6490,6561,435,1398,5922,1461,4128,3936,916,5936,964,1497,3558,5251,5629,2054,5924,6986,6710,1433,1537,1917,7100,6632,104,254,1089,1215,4796,2337,501,7113,4861,7102,4762,1349,4216,5322,7280,4199,714,4220,7054,6707,4519,4401,1371,7304,5371,7097,1145,2023,6264,7072,6104,5535,934,6365,609,4983,7938,4233,52,5430,6561,8306,3244,223,2677,4639,7238,6740,8590,8183,1439,7875,8615,7023,5373,7546,2986,5143,3014,3581,5484,1126,3018,3941,4510,8783,322,2944,766,6691,8305,6103,8290,8547,7994,8554,4597,176,7639,7213,8561,5765,3590,5623,955,3843,6687,3415,2639,6833,6875,1829,6643,2117,8514,7585,4774,1327,7143,7143,1738,3582,6642,7837,7837,6103,6103,5799,4860,5995,5995,8109,3647,3647,2029,2029,7995,4395,4395,7037,7239,867,867,867,2006,1215,2041,2041,6971,6971,8230,8143,2729,2729,2729,3913,2992,9306,9976,9976,9976,9976,9976,4337,4355,6364,7238,8220,3913,8834,3610,8434,3531,8389,546,2263,8207,6904,6904,8395,1300,6691,6136,6136,1385,6718,2849,2849,8144,7239,7239,1807,4704,5534,6136,9258,9272,2677,1210,4785,7835,8828,8828,3574,10170,10291,10204,5534,10078,7280,7984,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,1345,8047,8019,8780,7751,8816,8955,1073,6986,7224,6710,7932,9308,9343,8842,9647,9009,8620,7640,9465,9258,5678,2467,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,222,6163,5572,6163,5572,6163,5572,1268,6691,3941,778,2294,1776,5927,4996,4568,1774,7270,7217,7153,7374,4432,6584,6664,7285,322,7277,3455,5020,7842,1325,3162,7834,7261,7287,7287,7287,7287,7287,7287,7287,7287,8050,6270,6954,2029,8063,6718,7834,698,7836,6349,6365,217,6620,7208,8938,7493,7563,7563,9027,2520,8782,7654,8358,6980,9949,8864,6774,6715,6715,10208,10208,9,9,8299,1571,4996,1953,8830,1624,7837,1571,10891,9866,8047,5066,5056,10717,5064,5053,4500,2627,8434,2871,2384,51,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,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,9386,9386,9386,4076,6010,666,8864,8864,7516,7516,8762,2182,2182,9195,9552,9925,2658,7834,130,217,7903,7835,7836,9616,8441,8933,9297,4406,9933,7674,10072,7674,10072,10176,9880,148,8816,8358,8,1559,9888,1559,10400,2555,1345,10274,7077,7655,9741,9053,7088,9225,8831,10086,6875,10056,8142,1990,1990,4659,4659,4659,6740,10478,9785,9649,9976,10836,9975,6740,10809,10482,867,10477,2590,5322,566,6130,2677,4452,2615,3908,215,6255,1370,6633,7113,5188,6119,7095,7117,6175,6310,6103,409,524,7295,7082,7238,7023,5995,979,5066,2261,2520,2522,4614,6701,1746,5331,6740,2605,5386,1016,6957,6702,6957,867,7646,7118,7649,1411,3609,3698,810,7076,7081,7116,5763,7106,7109,7087,4390,7153,7114,1165,7653,7599,5297,1685,7122,6272,1266,6623,8080,8042,7291,7269,7285,7101,6709,7096,3550,7808,5332,3754,7932,8049,7643,8281,8077,7245,7931,7906,8444,7967,7605,8541,8552,8304,8480,7658,8088,8435,7903,8542,2389,8283,7154,8721,6870,7284,8706,8389,8266,5371,8628,7068,6359,6890,8290,7262,7124,7294,7289,6656,2521,3644,3359,7110,8207,7661,7675,6332,6855,3725,7089,7276,7248,3014,427,8306,7282,7084,7249,7019,7761,8222,8793,7280,9195,4659,735,7283,6364,7094,9338,7247,1998,4185,7254,7293,7671,8047,8284,8064,8079,8052,8053,8063,6381,9552,9137,8578,9149,8434,3380,6263,1685,1266,8459,8449,8580,8824,8972,4555,180,7904,9743,9793,1257,7588,7721,9614,9800,9888,9868,8166,9959,7239,8581,9931,9933,9030,9386,8725,4639,9936,9950,9349,8922,223,10040,9951,9973,8566,10026,10088,9547,10087,7704,9879,9989,9536,10086,9534,10239,8202,10089,10090,10265,10008,10260,10257,10292,10247,10237,10044,9892,8087,9785,10362,10321,10061,10272,9824,5053,5056,5052,5056,10320,10520,10526,6656,10574,10575,10574,10212,10297,10505,10650,7816,10229,6977,10211,10176,8780,5064,10222,10811,7910,10814,4765,4535,10302,10546,10913,10546,10965,10821,10938,10914,10827,10131,11027,7815,10512,10011,11072,10113,11121,10114,6898,7206,6240,10881,10519,10839,10840,5995,1250,952,5402,2627,4302,6842,3976,2118,7761,6842,6010,3532,3595,3169,8093,6713,6505,8185,2933,3542,219,8220,6314,1347,6264,8547,387,3823,7151,7019,7761,8222,7647,7151,8793,7109,7125,6192,7082,8365,8816,8727,7080,7663,7550,2337,4455,4234,8923,8888,9038,9030,4566,2976,8222,8220,7879,8450,7258,7953,7879,8250,8615,8926,8995,8823,8990,421,8082,7953,9270,9271,7239,7281,9054,8084,7594,8361,9321,8083,7910,9315,9277,8222,8406,9469,9470,734,6168,8220,7238,6740,8998,931,8458,9527,9526,7070,7238,8401,6740,6740,8220,7238,7106,9552,8208,8891,8434,9302,9278,6386,3395,8439,1563,7022,3395,7904,8201,7256,3541,7944,8423,6731,1663,1663,1765,1769,5544,6740,1385,814,8423,10095,9261,9647,7907,179,3590,6828,178,10190,3380,5252,7094,10109,8460,9571,3864,10584,4861,576,9058,8358,7238,2447,186,8516,10142,9136,8962,1381,9296,9915,2847,4076,431,10219,1327,9959,126,1765,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,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,233,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,6832,7872) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC