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,3415,5623,1727,1647,3850,3500,2380,1313,319,808,772,986,6564,3136,2151,463,6562,3585,1727,1237,4021,1098,1277,3610,5552,732,955,6644,6677,6599,1856,3454,447,780,1915,1160,5170,645,1460,2760,2707,2912,2270,2271,219,6779,1441,6709,2469,3351,1159,3482,3417,243,341,360,2685,652,2653,2654,2671,2454,3304,3447,1834,2602,3341,6827,2639,3844,943,2518,2298,5657,1871,3657,1869,231,2592,2477,2919,3843,5509,2974,2299,1822,1829,1297,3714,2334,4217,3787,3778,5735,2456,231,2477,4796,4806,4808,3159,6828,5331,3035,6192,396,5692,2873,3437,975,6992,3447,4798,3825,699,944,2446,2387,1416,4855,1893,2864,4722,3788,2934,1228,922,2723,7003,836,4008,6852,1561,6901,6998,5247,925,5743,6663,675,1038,255,1521,5078,5142,2698,5631,6902,1131,6117,5764,2337,455,2160,3625,6188,462,7016,7224,7221,7234,7047,7237,7230,2299,2639,3415,5765,1869,1893,6994,3788,4164,645,231,836,2454,2864,3181,3778,6993,3454,6575,470,645,4008,6564,6565,6572,6575,1461,1593,6562,3797,4165,1092,744,6568,3645,7063,6998,467,7119,7095,4164,1600,6521,4423,7089,7093,4964,6527,1474,7121,6522,1098,6504,6735,7115,6576,7115,6902,7125,7029,6503,6901,7047,6523,6996,7223,7235,7001,7029,1460,2456,7233,6675,3418,7013,652,2917,2696,7112,2956,1425,7249,7276,341,3447,943,1869,7231,2446,3454,7234,2456,2454,3610,1893,1765,944,7034,2151,1829,7089,2974,6588,7272,7271,6168,7272,6350,7271,7273,3417,7296,2334,6530,2671,7280,2653,5371,6365,7241,6676,7258,6993,2876,7057,7106,397,4021,6678,6726,6518,6512,6371,726,6528,6530,6529,6531,7691,7689,4305,860,7692,650,7686,7699,7681,4224,6530,313,810,7753,272,7275,5066,7844,3784,7661,7670,7602,7662,7108,7084,7265,7268,7170,7168,7599,1771,1767,1207,1769,1765,1768,6669,5331,6967,6544,4570,6901,7029,1738,1461,3181,1568,925,1145,466,1461,2261,4209,2706,6961,1366,6691,6110,6968,6650,1425,7833,3549,7910,4765,650,7840,652,7783,3418,7803,2956,6565,7995,4079,7783,6740,7147,6177,5996,7146,7812,8143,7548,7602,8519,2573,2573,2473,2473,6633,1371,7863,7787,4834,4834,1029,6001,7878,7878,7878,6589,6589,6589,231,6942,1869,2446,3454,3787,1738,501,1461,1228,836,3657,6570,802,1055,1160,1568,943,772,743,1441,1277,1727,1915,7864,7858,6852,2592,6827,1110,6845,7856,7758,3590,7221,3844,5623,5765,2654,3303,7034,1577,1822,2685,463,7232,3181,6853,219,5509,8488,1416,2864,3844,3418,360,8094,944,1522,2653,243,341,2469,1575,2334,3482,2956,7803,3788,1313,2571,4219,3989,2723,5148,2671,3843,3304,319,470,3417,1829,3584,7779,4722,5552,4021,986,3351,3778,6643,5735,7784,6849,5170,6570,8616,5070,2454,2706,1893,6573,2456,6562,652,8707,6574,6571,6567,6998,8684,7224,650,7031,7229,7232,7221,6675,7227,3540,6676,5088,6564,444,7063,6563,6568,6575,6565,6576,6883,6574,6735,7228,6678,6882,7013,7690,3415,1856,6996,7757,7687,6999,6997,7688,8726,6992,7689,8147,6990,7223,7231,6994,7681,8148,7001,7059,7235,7225,6736,7057,7692,8993,6885,7684,7685,6669,7052,7234,6902,7682,7683,7226,7699,7233,7691,8919,7237,9003,6007,1834,8994,2151,6676,9002,9068,6860,8997,8996,8814,1826,650,6565,7147,1085,1086,3850,358,5915,7160,840,7240,7548,6589,6130,4597,2117,2628,975,2555,3525,7869,8223,734,5419,8095,8094,8488,6740,7034,396,743,7594,5602,8587,7783,6712,7910,6192,6113,6010,4985,1516,6001,2168,6559,4682,6118,5893,6158,2269,6154,508,6011,566,219,5222,5321,1425,5917,6782,6362,1603,3824,3856,4417,4617,5011,5208,6785,1398,2911,3216,6780,423,5837,6136,6806,6691,6973,6972,6947,255,1370,6156,6157,5222,239,6059,7299,7034,7023,7303,6795,7206,6633,6981,4788,1029,6337,947,1126,5334,1325,4432,466,3549,156,566,5582,311,1738,464,7904,6192,6813,4218,435,7833,1245,4385,1207,2776,3761,7928,6163,5542,1532,1600,698,236,3131,8557,5011,8614,8535,8554,8550,8614,8305,1029,8547,2331,4983,7861,6712,7602,2737,7599,5143,8871,7928,6778,156,3875,3046,3531,4730,4765,5893,6813,5915,308,6156,9448,7982,8151,6644,6831,6767,7938,9403,9307,6829,801,7913,6953,6894,665,9889,9926,9933,93,6163,8284,9665,10067,9953,9721,10046,9722,9449,9545,9603,10118,9754,10055,10145,9723,9835,9836,10112,9942,7812,10679,10113,10501,10512,10495,10628,10626,10697,9724,10237,10353,10358,10366,10482,10608,10497,10610,10876,10715,944,11330,7889,1886,11291,10294,11287,1210,10877,11101,10938,11136,10935,11134,11200,6898,11232,11347,11290,4899,9558,11233,10684,10733,4603,4602,4600,4599,11358,9728,11364,7019,8222,9993,11219,11324,3595,9195,9552,9925,11027,11112,11115,11127,11435,11552,11738,11449,11447,11456,11586,11236,11460,11551,11372,11622,11825,11371,11360,11699,11773,11524,11135,11774,11832,2867,11845,11441,11363,10910,10493,10904,10820,11119,11585,11587,11589,11592,9342,6836,11935,11936,11937,11938,11849,1439,6793,743,5088,7290,6901,2863,4217,7047,7837,7275,1895,2677,6902,5623,4432,1954,3590,6901,1826,6553,419,7063,2677,7029,341,6860,2956,7879,7840,341,8502,6718,7674,8171,8436,470,8587,8488,8095,8616,8094,8587,8886,2956,3788,6562,6563,2334,5222,3417,3282,743,9002,8997,8993,8994,9003,9001,7233,6990,7783,7029,8617,1416,8870,5765,1577,2889,3029,2766,6824,5692,2331,7034,9002,8587,8993,2957,6790,8004,3590,9321,6780,1568,7712,6902,7029,8488,8095,8780,7619,3564,1131,444,2331,2334,2592,955,9390,2956,2446,9363,1834,971,3418,3479,8923,1893,9463,7787,2454,9511,9512,9531,9532,9528,9551,9568,9571,9570,9566,9002,9001,8094,8095,7000,9531,9419,1532,9321,8996,8094,8834,2680,9783,1163,7618,6882,2698,9981,9982,10005,10004,10012,10013,10014,10017,10015,4422,7907,10019,6828,10109,10110,9947,9982,10108,9948,10118,10165,10112,7830,9570,9226,8845,8461,7674,6556,6557,7618,926,6095,2923,6551,6555,1278,1815,6068,5856,9987,10267,10221,7792,6205,9987,10413,10414,9620,9619,8083,8034,5066,3358,7605,10397,2329,9532,10345,6555,6551,6248,6552,7829,10266,10141,10127,10632,10635,10395,10266,10621,10620,10619,773,9200,9116,8978,9290,6635,9798,8431,9650,7272,9742,10571,10574,10585,10772,3874,4682,7120,7297,7642,6261,5995,7967,4337,6364,4022,7012,6315,1215,1215,802,7266,7967,7252,231,7075,7246,1257,7666,3860,5996,6714,7473,7096,446,8412,7270,6728,3341,7967,7083,7270,7075,7151,8741,8409,8395,8064,8407,8820,7120,7294,7803,341,7784,3418,3447,6853,2653,2671,3417,1568,1647,4126,6171,3437,5692,5743,2334,361,6515,4316,4701,3159,8761,7928,8290,8304,8845,8818,4936,4944,7761,8706,4765,1370,1126,4411,6310,231,243,946,2469,836,7859,1127,7864,7034,944,1228,1297,1416,6942,1522,7712,1577,7031,1869,1893,2446,2087,2451,2454,2456,2571,2995,3014,3059,3189,3201,6659,3778,3843,3303,3803,4092,4029,8894,4219,1313,6838,4690,4785,4791,5756,1533,3885,9321,4862,8247,8730,3327,6845,9363,6971,8901,8520,9402,9552,9951,947,9600,7233,8726,8615,4337,4233,4209,3904,2025,9373,8193,5516,249,9052,4234,1215,10212,9879,10526,9453,8922,1439,6104,10739,10765,162,8995,6809,9614,9234,8888,10127,10870,4665,5013,3989,10549,10634,10636,8834,11141,8010,10355,11020,11028,10964,11122,11220,8681,1398,6678,7270,7251,7251,1126,6595,6447,2849,7856,6595,7296,7856,3595,6795,7296,7904,7714,7879,7271,7101,8053,8058,8034,8076,8040,7119,7931,8046,7878,7548,6155,7946,8284,8209,6235,7273,8373,8418,7840,7878,7879,7115,8481,8573,5320,8220,7280,4878,5320,8720,7971,7275,7297,7971,8761,7298,8419,7670,182,8683,7761,7547,182,3895,2522,8682,8618,6936,6938,7675,8698,8739,8933,9030,7124,3080,8412,8908,8580,7103,7083,4258,2605,8847,9134,8358,6354,9336,9134,8042,9244,9329,3070,9322,3073,1349,4460,9071,7087,9449,7239,8064,8458,6514,6514,8405,6986,9312,8832,6700,9367,9093,9777,1381,8436,4299,3541,4160,8681,9958,9874,4178,2253,6619,9143,7368,1770,1765,9932,10109,10087,9603,8724,7113,9603,7649,9200,10008,1767,1771,7692,7690,7686,3172,5837,8896,1609,4805,3071,3875,8220,7020,3590,1766,6740,1688,9963,3282,9769,10008,6828,1787,6642,7752,2261,8220,7973,7751,9146,2915,10379,2349,4847,4847,4728,675,1785,169,9951,9486,7368,5245,9951,9082,9026,8255,6658,9932,2474,8956,9009,3908,2337,9384,814,4330,7203,4234,7059,6624,9879,1357,7203,814,8856,8855,8761,1698,1308,1776,6030,3250,1766,9873,9833,3893,8793,1461,9344,6715,7235,2784,7246,9893,6427,9052,9115,9052,4566,1165,7903,3380,1215,446,8942,7823,9824,10742,4535,10475,4535,10475,8742,10228,10965,6728,6700,8080,10737,3860,9676,8669,576,9496,10929,4947,7598,9547,6416,10422,10381,6764,10264,6751,544,6151,6763,8160,6493,7705,573,8158,9859,1664,7605,2605,10416,2270,10742,8394,5484,10356,7751,10789,11289,6776,5487,9368,9367,8323,4730,93,11268,10836,10056,9300,8082,10768,10767,11719,11781,8910,8514,10722,10722,11670,7895,10543,9406,11846,11686,11890,10702,11211,11772,7127,10664,8764,1766,10291,10292,6718) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC