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,8232,7172,1765,1771,4302,9485,6199,9632,9633,6354,222,3073,1351,8946,6499,6214,10208,3385,2387,8714,7698,10663,3071,6497,6689,6496,6212,6221,6218,6498,6501,6223,7493,8108,8831,4544,6583,4399,6396,7917,6394,6402,9616,1765,7493,9949,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,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,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,4146,3874,8109,435,9418,1371,10324,7870,8700,9432,867,10323,5402,9920,10333,8828,7610,1770,6733,10565,9920,10326,9863,6011,9735,10336,10139,9067,9880,1768,11049,10328,1257,10235,10436,9976,10365,8559,272,6715,9857,6197,9633,9632,10232,5435,10698,9857,9667,4435,313,4769,8710,10831,9946,5435,10379,10649,10825,10819,8781,10697,6366,9386,8095,754,10698,10987,6658,10940,10579,10296,10305,9488,857,858,3926,10423,10417,10579,7680,10491,10676,10681,10402,10730,10436,10874,3889,7986,7987,6768,2658,7897,947,6658,2005,8866,8866,7420,7535,7535,4769,5770,8255,5567,5024,5484,4094,5769,587,6631,8196,7256,5858,3043,5068,9442,1993,378,11328,10348,11400,1153,9817,9819,9820,9818,10095,8229,8371,8712,8571,7261,461,8721,7287,7861,7088,7086,8040,6702,9095,6701,10844,10305,10669,8570,8570,10076,8406,7647,7083,7124,7107,7094,8638,8227,7268,8438,8643,8575,9056,6715,10436,9674,8446,10171,10630,10402,10379,8207,10575,9998,2374,10960,8658,8658,6728,8772,6668,7819,10248,10292,10464,5996,526,2056,391,7270,3860,4199,3896,1458,7300,6768,7300,6962,7286,4544,4860,7899,545,550,548,539,4684,3554,3554,1398,7175,7032,1662,549,6477,525,2706,778,551,864,1366,8356,8530,546,8880,979,6394,6842,8212,7472,9030,578,547,2847,3337,1777,7178,8438,4500,4500,9076,9778,9494,9494,9791,9745,9858,8575,8575,6648,9488,9879,6583,6583,8434,8434,9547,9547,10638,6579,8063,8833,8428,9853,9785,6400,10695,4500,1783,394,3865,10687,11264,11264,3830,5484,10649,10669,9976,10228,11216,2635,5792,1250,2033,3327,10687,6354,5986,10228,7137,10553,11366,6548,11400,9863,11373,11443,11260,11441,11101,8358,11101,8358,7953,8244,10325,10323,10328,9951,10326,10324,10331,10158,10330,10329,10333,11007,10546,11050,10560,10555,10327,10159,10137,10138,10218,10563,8873,8700,10728,10099,9894,10198,9435,10322,9436,10140,6359,10330,9434,11138,10136,8649,10202,8872,10331,10323,11049,10324,10329,10333,10326,10217,11137,11324,510,8824,7058,7752,10305,7753,8088,4320,9951,11602,11601,7374,11320,11588,10305,11611,11723,11784,10646,11321,10752,4512,7751,7972,8681,7973,10647,10364,10822,10920,840,5380,1371,7304,9030,4302,6742,7473,1988,6242,4317,3074,6174,6814,7964,8686,9351,3337,3823,1462,8732,2417,1250,7473,10932,10916,9601,6953,8780,4923,3327,11216,4769,10874,11379,10579,6715,5647,9685,9693,840,2913,9692,9713,11298,11661,2989,8648,1116,4801,6855,9787,5175,11328,11298,5484,10872,11324,11497,11101,10788,8686,11461,11410,11438,10164,11303,3210,10844,11271,11272,8485,5602,9320,8547,7576,11586,9386,11239,11266,11658,11655,10892,11437,2389,9865,8358,11438,2913,8292,7385,11261,10987,7159,11497,2913,10940,1784,1359,11373,8983,8981,6743,3883,10222,1730,9165,9601,3898,9534,8982,6742,10167,6744,6746,6749,979,6359,7599,6768,5386,8879,9217,6750,390,8241,8334,10334,10336,10335,9920,10238,10194,10200,10263,8877,382,8330,8320,8339,8337,9891,9908,9113,10202,9111,8242,8873,8872,8649,10152,9112,9120,9431,8318,9114,9119,8326,8310,8247,8313,8309,8308,9633,5691,1685,5386,6195,1765,10546,10545,7845,9633,9903,9905,6533,2605,5386,1769,8824,10546,9909,9137,8824,1685,5784,10522,9137,9149,1770,8917,1771,1765,10925,8824,8489,7869,1967,9031,5770,4714,10645,10646,10750,11167,10925,10922,9985,10466,8592,5810,390,8784,8788,8881,10613,11051,11248,11247,8882,7134,7877,2071,9303,9350,2506,11239,4714,11022,375,8787,372,376,368,381,6066,387,8858,385,380,393,375,391,386,6082,378,8784,394,6270,8880,392,365,8878,8786,8789,10896,11088,11327,11329,11182,11231,11249,6375,11178,6271,6076,379,6537,11173,11176,11175,5332,1411,810,10521,11183,10827,1266,6535,11229,11174,11186,11252,11185,10921,11238,11519,11295,11296,6505,11318,11294,11239,11254,11301,11251,11585,11571,4923,6600,11085,11665,4520,11666,11667,11085,8175,10823,10278,7922,6354,6503,6523,11425,5383,11429,11085,10886,11489,9951,6822,10966,5435,9418,10892,10984,11485,10932,6242,11285,11342,7976,11455,10141,11477,9950,11328,11101,11215,10343,10278,947,1207,7641,9655,10505,9533,11289,10566,8169,11272,10687,4779,11226,6004,4574,8109,2342,11303,9389,10909,10339,11900,11363,11302,10380,423,396,11101,10344,11217,7159,5098,1974,1726,4923,9856,1307,9488,10301,8650,8130,10316,8130,10316,226,4923,11101,11215,11101,11215,11497,10579,5435,5435,10036,11660,8585,7870,11714,10687,8586,7546,11493,5770,4503,8624,10579,8682,11658,8816,11673,11770,9920,11657,10868,11656,365,11716,8339,26,8885,11759,8,11306,9507,10331,10323,1885,10326,10325,11677,10333,10279,10327,10330,11242,10324,9482,11241,10328,8880,381,4639,7576,7555,10339,10707,4979,6740,6977,11214,5435,10987,587,10682,11039,8563,10670,9863,3957,1044,11365,11257,8139,2056,2069,3327,9791,10687,10817,3702,11399,11215,11400,11298,8191,1296,6367,9946,7048,11410,4769,7374,11497,1358,1359,11880,1983,9830,6952,6433,4985,51,1917,3698,3241,4099,1298,6832,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,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,7493,10696,10032,7708,9386,11101,4923,9976,11519,6854,653,10386,1990,3327,10940,5810,6966,4769,6715,10695,8816,1988,11101,10578,6700,7350,8139,10681,1089,10671,9049,10664,10664,10669,10669,10078,10078,10716,10716,9866,7913,8284,9812,9359,3247,6426,587,10687,10339) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC