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,8222,7579,7837,4079,1210,7834,4639,7835,7836,6740,7143,4087,8358,7238,223,8220,8517,3282,7989,8306,8547,8480,2117,8610,435,8610,3014,8629,8214,5143,4218,7923,3850,8842,1207,8905,8912,6599,1127,8916,9000,665,1345,8578,8780,9046,9130,9195,9017,1461,9072,3062,4625,8933,8706,5154,9200,9242,984,9254,7907,5536,9300,3761,8495,9322,9332,9333,9334,5732,9308,9289,9291,8103,9337,1057,179,8150,3595,2135,9456,3059,9419,9290,8688,7803,9196,9347,9541,8543,8306,9552,8306,9353,8306,7581,8306,6117,9607,9603,9604,7143,6857,1890,9641,9634,9654,9643,9668,9642,9644,2360,9377,4240,9680,107,9616,9761,9234,8805,9648,4219,9676,9769,9766,9780,9800,7856,772,9798,3844,4800,3303,2299,9116,2294,5515,5765,3590,2398,9258,1416,9913,9916,9938,9942,8913,9635,5841,780,9961,3844,9543,9945,129,9471,3159,3788,444,5692,1834,8870,8844,972,10047,6848,1727,1822,360,10056,734,7615,10104,6681,5812,7016,2674,6827,1181,10128,10129,9086,3181,10141,10149,3437,10119,10120,8925,10048,10061,967,9472,1522,9963,1906,10093,220,4126,9116,5821,2743,1485,1000,152,10229,10242,10241,180,148,958,1461,2135,2192,3585,2299,10131,10282,10284,8884,4947,7019,10273,2687,2642,1826,3561,10283,9936,2421,4656,4566,4972,2571,10342,10338,10246,9348,115,10300,10380,10373,10209,10358,9050,4527,10374,10373,10440,5743,6171,10469,4168,10467,10476,10416,10479,9374,9638,10042,6267,9220,3608,5877,3035,4986,8851,9454,8837,10523,10114,10244,10527,10247,5551,8902,10394,8800,10549,10541,10537,10548,10543,322,10514,8514,1954,10021,4385,9193,1057,7550,6691,162,8901,10671,10649,9904,4767,4696,10665,7017,7582,10674,10569,5729,10745,1954,10747,10787,10798,4023,10780,10814,10737,10663,3715,10784,10836,10688,4082,10135,10782,6713,252,10878,10699,10870,5373,10935,10894,7016,10910,10892,10934,1350,4136,1521,10938,10918,10966,5142,10895,10893,10656,7140,10397,606,10782,8900,10988,5379,6828,2192,10233,7614,1532,9834,6643,10708,11028,10709,7064,10710,9081,10285,3054,7021,2270,2271,1131,10221,2672,10344,3825,10345,10513,11084,10320,123,11090,10661,10662,11105,10398,11104,7143,10990,11094,6838,239,10899,10778,9872,10673,11104,2642,7016,7710,9254,3391,9768,9254,9270,1277,7016,955,6861,1441,2654,1055,2707,1160,1159,30,243,11121,10376,10917,1160,30,11123,11127,11128,5631,11132,8687,11126,10765,11089,10454,5875,743,7758,10094,11135,11142,11136,10964,6849,2912,4982,10857,2698,10971,10733,9453,6852,10343,7864,780,3964,8835,3657,2639,3542,5379,4219,7855,1277,1042,8919,11166,3775,10148,10375,3778,5678,4665,9928,10130,5305,11180,10719,1835,11195,10473,6696,3787,6853,4362,9105,1176,2671,1313,6661,4616,2919,11219,11222,11217,10734,11230,11201,3100,10819,11237,10657,2709,10434,4233,1119,11220,8535,11199,9234,11200,4209,5487,9096,3457,2446,10861,8031,5545,6731,11198,11235,10528,6731,11084,9722,11288,11287,11268,1209,11302,11272,4056,6862,6779,11324,11325,8134,9343,5046,36,1698,2590,748,5903,11349,3936,11041,11353,3376,3195,3139,4028,4648,8802,11361,2592,2919,2685,11359,11360,2873,4536,11389,11351,11374,3482,2655,7036,3396,9402,6866,11409,10940,11417,11266,11424,11423,10715,5013,11314,11266,9811,10062,10146,24,4875,10714,11142,5252,11443,8010,10530,10714,11442,6730,9922,11438,1049,11433,1050,9221,739,11473,11437,10288,10234,11480,11456,11450,11388,11491,11494,4329,11455,9615,11488,6692,11381,11498,11489,11347,11344,11468,768,1576,11476,11371,11477,11382,9750,4648,11102,4882,11416,2555,986,9809,9807,9808,141,986,11290,3368,11492,152,10842,2477,7709,8224,3523,11599,11042,10912,11595,11598,11613,3041,2456,122,3500,3540,5328,11621,1299,6693,11373,11597,11593,11619,11518,11600,11606,11655,11620,11648,11436,10368,11661,11647,11670,11435,11451,4233,11479,11646,11678,11594,11303,11446,61,11523,4432,11663,11691,11644,10002,11362,1113,11690,10685,11698,11703,779,9965,11719,11672,11669,11724,11680,11714,11126,11446,11702,11705,11738,11737,11725,6986,3401,925,8707,8520,9222,4061,11385,2491,7760,8104,9317,5047,11658,4099,11170,9068,8483,9070,6337,4849,11764,11765,11673,9532,9987,7896,8146,2454,11379,2419,1298,9531,258,11657,5553,6902,258,11770,11772,3714,218,11752,10635,9018,11786,11660,11807,11812,9511,7362,11816,6901,11787,11785,11282,9036,10967,5629,11330,11659,9986,11681,11716,9228,11285,11827,11819,10764,4696,11821,11820,11842,11845,11829,11010,11846,11826,11869,11831,11872,11662,10956,11851,9917,11822,11699,11847,9964,9967,10877,8284,11832,11871,5885,11870,11849,11873,11900,10743,2921,9211,9166,9642,9643,9644,11921,11828,9641,9333,7719,9332,10744,9571,11480,9397,11610,9569,10359,11850,9832,6069,4417,946,11965,11978,11977,11963,11972,6553,6552,11966,11982,6315,11964,9387,10267,3731,12010,8182,10865,11990,9460,11860,10354,9897,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,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,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,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,10731,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,7149,3043,4512,2520,8305,6642,3728,6780,5484,4936,6138,452,222,1181,8933,6364,8995,9104,8960,4944,8962,665,2998,8999,8182,4901,8306,1245,8141,7852,8613,8910,455,1912,9208,8970,8231,1738,2974,2151,7920,1055,1727,6855,9389,5623,2299,2639,955,5765,9223,9222,8844,9224,9255,9250,9402,3303,8965,9623,8960,4969,4128,254,5516,4656,9011,9290,9556,8812,8151,4049,9275,9344,4046,6986,9397,9766,4061,9777,9464,9951,9959,9827,8554,9910,9931,1016,10012,5236,10040,10014,3908,5046,10017,10015,10019,10004,10109,10110,9243,9981,9250,8762,10056,10090,7759,4099,3936,6766,9758,6571,10013,8889,10086,10242,8031,10018,9482,9541,162,4566,6876,10104,9538,9652,10021,9926,3590,10039,8844,8870,1568,10361,10397,10055,10241,2639,3415,10267,10355,10358,5839,10547,4056,9402,10480,9243,10619,10620,10621,5039,9273,8019,6681,8305,9647,10227,10711,10718,10063,2639,3844,1055,2299,3585,10720,10785,10350,10895,9558,10003,10619,10783,10784,5193,10734,10856,10380,10966,1485,10439,10440,8193,10805,10552,10820,7760,9749,10895,9968,10857,11028,9798,10149,10476,10715,10878,2954,9634,9929,10364,10131,10283,10284,7581,9648,9930,10648,10711,10990,11142,9961,10895,10964,11018,10135,11123,9347,6857,11220,2506,36,11234,11302,2446,129,9471,8543,6117,10476,11272,10935,11314,9961,11383,11382,10413,10786,228,11287,10748,10749,10397,11106,11395,11424,10870,5877,10129,11302,11473,10934,11446,11423,3964,11396,10785,11171,11602,11608,11442,11443,9347,11599,9961,11457,10413,10608,8441,7835,10719,11353,8441,7835,11655,10819,10911,10672,11344,11646,8134,8936,8979,9543,5995,5148,1137,3941,4048,180,6842,5286,6595,8500,4131,7354,3921,5088,3976,1461,6792,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,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,8489,10526,10649,10758,9349,9950,8541,8765,2009,7910,10937,8973,11134,7144,8171,11120,9031,9838,9005,10500,7869,10702,186,9198,10314,8828,9951,6771,8816,11325,11283,11303,8922,11289,10875,3523,11351,11409,8434,11296,11167,11238,11247,11448,4076,9864,11213,10751,10533,10535,5782,11301,11294,9078,9915,11121,11608,10056,10724,10951,1969,11742,5402,10531,11768,9972,2389,11497,9985,3254,11809,8745,324,4659,10966,11051,11238,10302,11101,10072,11603,11968,10297,5763,11342,10340,7953,1770,4985,11366,11201,10518) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC