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,6006,4411,6100,5419,2218,3038,1145,1345,6023,4798,3428,4226,778,5872,5912,223,7067,7840,8459,8459,4346,4346,8514,8910,9320,9320,9320,9320,9320,779,810,578,730,4639,645,4405,6809,6845,6104,6805,2615,4659,1603,5484,5904,7146,6979,4774,5116,7303,1764,1460,6687,3492,5276,7144,3797,4854,4316,4964,423,5298,5003,7756,1272,510,4985,1831,7882,7874,4512,2989,5400,470,5763,3358,6559,7981,7988,952,1092,3856,665,2331,7994,2913,3719,7956,3893,8135,5889,3878,4087,7287,4652,1184,3136,5995,7807,5332,7937,6732,7971,549,5965,4616,3824,8483,8484,6560,3169,5252,8257,4784,4830,8514,8573,8169,1872,8471,2024,6192,1349,7985,8305,2989,7251,3580,6255,6829,8713,2389,1250,6122,5848,5188,725,2157,6159,6177,6001,3850,1271,6189,186,6155,7878,7879,7594,6365,7146,7883,7882,3131,6644,6366,7995,341,2876,8150,8223,7938,3241,6312,8109,6006,576,2729,5572,7921,6855,1498,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,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,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,2294,5912,4639,4046,576,4639,4406,5995,4349,7840,7775,8547,4405,223,3913,3878,3878,3646,8306,7022,1215,9479,5763,8388,3957,450,450,450,10121,979,1351,834,4566,2605,2869,6740,5576,5297,834,2164,3029,3850,6223,6223,8301,223,4639,8358,8815,8730,8489,8814,8547,8230,7599,9130,4860,3989,501,5484,8306,1257,9215,5148,2253,6371,6175,2467,6151,1738,4289,7741,5691,5904,6526,1462,6212,7913,6742,391,3885,4512,8700,5386,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,2467,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,8948,9614,5770,223,5769,3863,6510,6212,6530,6509,6223,6531,6511,6512,6529,6538,6537,6533,6515,6508,6535,5386,6528,6523,6514,6198,6200,6382,6390,6066,377,979,726,810,6513,1165,6223,1461,5995,5691,313,5996,7019,1038,3384,3385,3702,6872,7299,6364,3428,7239,1524,7761,2824,5691,1349,4136,6214,7149,7981,8031,6216,6496,1704,7608,7698,1767,1766,2989,7753,1769,1770,1765,5763,1771,1767,8178,8362,7890,4258,5362,7083,7973,1769,5142,5339,8548,8240,7919,7126,5817,5912,5817,6903,8716,8773,1016,8773,8805,8846,5763,8547,8900,2967,8900,8220,2023,1970,659,6205,5373,8716,1327,8902,9086,9372,7804,7790,7584,9552,126,6629,7926,9348,9374,10000,9378,9639,9648,6163,9937,10146,10187,10065,9945,311,2913,9281,10350,10130,10416,10315,10212,10568,10115,9548,10528,10749,10895,7893,10904,8214,10667,10721,11025,10566,8871,7024,7077,10816,10210,10413,11197,11200,11034,11063,10787,10820,4901,10914,1576,11201,11347,11324,1886,958,11130,11402,11278,11488,11376,11117,10039,10494,10885,11115,10687,2266,11495,11449,11497,11455,4154,4520,11782,8937,8299,8144,8516,8468,1385,11272,11234,10720,9277,11776,11187,11843,11840,7804,7893,11704,10269,9007,9757,10869,10854,7069,4701,5484,4424,6118,223,4639,3165,5255,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,3760,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,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,1770,8255,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,2467,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,450,9322,2455,8388,9213,2473,8455,6855,8933,1770,2473,3784,1993,4218,7238,8220,9879,10339,9802,9909,9342,8828,10060,1097,6550,9771,9931,10161,9043,10126,2897,1953,8879,9044,9993,10166,2830,6774,9093,9843,10125,10237,10282,10297,3465,8973,8613,9987,4156,9336,2164,3647,7576,10269,10468,10280,10183,10537,4906,9934,8830,9557,9786,7602,9342,7917,6648,9789,2164,10098,156,9329,10735,9497,10080,8763,10320,10481,10886,9910,10532,11026,10892,11099,11102,10133,8967,10649,11078,934,11140,11097,11133,11095,7602,11233,8976,10808,1097,3282,6119,10093,675,5792,9283,11260,11166,130,367,11198,9235,11396,9193,11141,7148,5454,11479,10094,11352,11359,11442,7613,11447,9402,10091,7761,3863,3863,9603,7135,2749,6578,6578,9787,9787,5484,5484,5484,2986,2986,2946,9667,754,148,10229,6710,1461,1917,179,10278,9655,2761,4029,10566,10761,3872,10786,961,10649,10346,9855,10905,8358,10892,3908,9959,9368,9367,7670,9954,8648,10933,9161,4800,9649,10077,4401,4079,7874,10655,10702,9135,10976,10187,10768,10891,207,10000,10771,9889,8639,10769,9955,10172,10185,1209,11108,721,10171,7250,9736,8446,10226,8444,8740,8424,8568,8447,9199,8737,9658,9053,8741,10816,8962,7284,8445,10834,8061,8073,7890,7264,8575,8641,130,5961,7833,9561,7714,1343,11025,9968,1378,7283,8144,10550,7639,2079,11305,8144,6138,9245,11170,7280,11433,8098,10861,7279,7951,11332,9247,11195,9674,7286,11280,7084,10655,10191,1970,11225,1173,7251,7269,8653,8279,7037,7587,11654,11434,11675,6831,11654,11800,6831,2506,7288,6102,8370,9158,11626,11692,11693,11468,11674,6805,10944,10945,10584,10583,10741,5484,10747,11342,5995,3327,3428,10212,11172,7304,9030,4302,6742,7473,1988,6242,4317,3074,6174,6814,7964,8686,9351,3337,3823,1462,8732,2417,1250,7473,10932,10916,9601,8780,4923,3327,11216,4769,10874,10731,11379,10579,6715,5647,9685,9693,840,2913,9692,9713,11298,11661,2989,8648,1116,4801,6855,9787,11121,6740,10844,7592,11025,2253,11215,10940,10305,4424,9765,10212,11216,8257,4512,6354,3070,3073,8727,9679,8946,3071,6688,9665,10053,510,7772,7770,10544,7753,7637,8816,8730,7813,8088,7120,10367,1895,8681,8698,8817,7751,7972,7973,9129,8815,10463,8780,9720,9215,10643,10544,8815,9720,9722,730,8172,9074,223,8933,9721,8306,9492,5995,9281,10868,2164) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC