thisMySQL 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,6691,5484,2447,5965,5314,6210,964,1051,1050,1049,3863,2830,587,856,2893,4598,2520,1052,4602,4600,3864,4603,3440,5208,1981,4154,4068,5098,4181,2467,2989,5351,4898,4076,5952,5351,1056,6907,2393,5951,5959,5927,1010,961,6792,5629,5175,2246,1586,1196,3189,6858,6947,5266,739,7138,6708,5636,1487,504,834,2841,6732,5215,1196,405,360,573,529,546,547,7138,545,7883,2933,608,2294,3080,1347,446,947,3189,6659,4598,1533,4087,4731,2451,4519,3803,4872,4645,3872,5331,223,5251,4690,1181,1121,4125,6669,4931,5576,6568,1351,743,4598,3048,7580,7751,7881,7973,7972,7293,8088,2389,3559,507,7992,7300,7085,8206,7753,7106,7660,7656,7238,8220,8222,5995,1257,4178,4947,446,1215,7977,8290,8434,8435,2520,8389,8174,6642,8175,8306,8628,8703,8628,8703,4598,4600,7928,8737,7928,8737,8737,8793,8681,8761,8698,6958,508,4801,2092,7852,2117,5602,3531,8706,7998,7999,7137,7551,9037,9030,8922,9038,2555,8739,8850,8822,1662,4218,8613,8781,9134,9141,9142,9139,7659,1511,931,9090,186,8721,8053,2712,7117,8742,8231,9300,9079,8019,1145,9349,1145,8213,8044,546,539,8085,8339,7238,8342,8332,6726,8338,979,7672,8404,3878,7903,730,7143,7546,8615,8586,7870,8584,4432,8460,512,7092,1461,7771,8583,5020,8398,8401,5995,857,7772,8044,8063,1927,5331,1917,1929,7833,3581,8334,7660,1928,7659,1268,4969,3701,3933,5362,6497,2244,5477,1536,7268,3875,4603,8332,542,536,4600,539,5235,4602,6315,8215,529,320,553,3612,8724,3701,544,8275,8946,8343,547,9291,524,9301,9289,9337,4652,7666,7037,1349,8365,9374,8044,9346,8573,739,9248,7270,8805,8934,7913,61,7261,7068,8915,1741,566,1210,1207,7580,7755,5143,5251,7756,8509,28,2677,7554,7927,5331,5331,7761,4199,217,217,6364,4639,4659,6809,9545,1917,9648,8220,9554,9366,8092,6104,585,9655,1520,6659,9378,1370,1145,566,1532,9300,8515,735,2951,9378,4405,6441,554,7300,3073,9418,7024,8627,8088,6688,3883,573,3884,10228,10336,7985,549,550,6386,539,551,9483,7987,10072,10649,1765,8971,1771,5839,1767,7704,7706,1765,9949,2605,1769,11028,3877,10607,1768,1766,531,10044,9502,2822,6489,10963,2779,2785,2786,2791,2778,3359,2799,8192,2816,2522,7698,6596,510,4146,10067,9633,10922,10923,10924,10433,11017,8582,2808,2812,2781,8154,11071,11068,11067,9555,9554,8241,8244,3784,2817,6354,3070,3073,3071,6688,6689,7752,7753,8627,8088,11161,9037,6526,11238,2820,6521,2794,2789,3891,3877,4305,2818,9665,10053,10544,10975,524,11221,526,9383,9867,529,6855,10232,8943,11407,8316,8944,9418,7881,10644,11390,11393,10640,8878,10645,374,11422,11109,11406,6538,11320,525,6537,538,6536,535,6535,542,6534,540,11321,6506,6505,6533,6532,4598,8727,382,735,9184,9679,8596,6442,2824,7999,7998,10857,10866,11523,11131,10930,10931,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,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,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,11228,8010,11353,1234,1210,1207,1198,1145,1056,956,947,923,57,28,10823,3014,2995,2776,2725,2736,2677,2451,1741,1533,1425,1398,1370,9675,173,9418,4731,4519,3564,4600,4602,4603,10454,10447,3189,10448,1616,566,466,9533,11655,11646,11719,11724,10278,11691,11741,9148,11645,11187,11509,11681,11647,30,24,10689,11785,11361,11703,11783,11787,11842,5193,11718,10904,10964,6874,11018,11834,11838,8955,8305,6780) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC