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,8268,6654,8248,8246,8244,8310,8899,8307,8243,8319,8241,1929,1932,6390,6391,863,858,6191,6527,6146,6152,6377,6517,6151,6144,6750,6388,673,653,275,6607,6191,6381,4614,7018,323,394,8307,8584,6270,6531,6529,7610,7870,7697,6652,6216,5691,6528,7695,7868,7696,3442,1704,7693,6654,8719,7189,8586,7546,4302,8897,8618,3515,8682,1770,2783,8896,6197,7188,6023,1765,7187,7568,7567,7569,7570,7762,5386,6223,4386,7178,7188,766,3830,501,4301,7698,2992,5996,2605,7187,6377,2063,5996,3515,7696,7304,4297,8899,4301,2594,8434,8949,8874,8325,9183,8340,8324,8883,8323,8313,8322,6223,8337,8598,842,8389,8281,1765,9649,8729,9911,9912,9720,7909,7028,6836,6835,9996,8897,9959,9937,10187,9555,222,9671,9670,9407,9590,4942,9920,9587,9535,6800,7600,9911,6354,9907,7752,10053,7753,8088,8627,9037,9665,10053,3073,3071,1266,5297,9515,3359,6066,8585,6688,6855,8896,4386,9517,9518,810,1967,6382,6371,7185,7180,9522,6533,5063,5064,5056,8110,6872,4224,7882,6898,3893,3882,3884,3892,6493,8271,9895,9906,4931,9679,7187,5053,9492,3070,8584,9907,389,9665,3073,3071,6689,6441,7632,1771,9880,9011,1768,240,10043,1767,1766,9601,9867,510,391,380,464,8714,9892,3380,8729,10238,10188,2775,2084,1411,810,1349,6200,8935,6198,4282,9197,4291,4304,4297,4287,7697,7694,7695,7868,6212,6526,7693,6521,6520,4652,4386,6654,7182,8896,7189,7185,7178,7179,6652,7184,7181,7183,8897,7188,6653,7176,6214,7180,6497,6499,6216,6501,6498,6222,6218,6215,6220,6221,6212,6223,6511,6531,7845,7844,6510,6509,6508,6513,6514,6515,1165,6507,7843,1266,1685,5297,1349,9248,1767,1768,1765,1769,7170,7172,7174,7173,4473,7165,7164,7167,7187,6512,3073,6354,3071,6689,3070,6688,7753,7752,8088,8627,9037,8946,7186,7166,9383,9867,8943,8944,8945,7881,7599,9679,1368,7636,848,4121,5064,5053,1765,1770,9911,9912,7972,7751,7973,8276,8275,8278,8888,9343,9722,9721,9720,9723,8816,8946,9669,3359,2951,10194,6377,8729,6768,10417,5535,3066,1385,386,254,5053,446,397,1303,2122,2743,4558,1645,6152,6151,1520,6654,4355,800,5321,1770,5995,1768,1524,1766,5542,1769,1771,1970,6691,6718,6985,1662,737,5148,6175,7262,1767,6721,508,1771,1769,2706,7270,1133,1770,1257,5454,6204,6104,7209,272,4230,7107,7083,2023,6593,1685,1327,6689,7881,186,1073,1215,3071,6315,7671,1173,6586,5927,8088,7753,7881,6546,501,322,6858,810,979,3989,4796,5732,1173,6743,3719,3559,6315,8193,507,1351,3115,7771,3385,7213,1173,8688,4227,3881,7104,8111,7585,8436,8627,7238,8548,8220,8175,7637,8168,8687,8885,446,8440,8765,8834,512,8831,8900,8963,7837,9037,8951,1768,9136,800,8828,9136,8946,1257,8306,1215,3989,8578,9096,5995,9052,7301,7736,4130,9245,8250,9300,2122,9365,9278,9308,9382,8704,9455,8175,9439,2701,6778,7636,9308,9474,9615,1245,1532,9636,9602,8904,9623,9323,9196,8899,8946,9679,9648,8543,9347,9634,6857,9961,7581,6117,9930,9627,9195,9543,6646,10118,1108,10212,9554,6874,10149,10172,107,9867,8897,9760,10232,9665,9342,9049,9383,10000,10272,10554,10342,8615,10523,9221,4337,8173,24,585,10053,9453,10476,10878,10375,10664,10893,10940,10870,11024,254,11028,10836,10292,4558,2811,30,11142,10671,8893,8132,11122,6595,11220,10672,3933,11105,6646,11021,8171,10784,6616,11302,11253,11402,11423,4437,10291,1080,4136,9929,5922,11361,7975,11142,9949,11263,3493,9865,10258,11473,9455,10464,11548,10248,10730,314,11491,8762,11423,11550,10650,5923,9866,11399,11042,11283,11690,11404,11097,26,7159,11645,11739,11678,11328,11764,11701,11118,11721,5534,11644,9603,10798,10784,783,11215,11724,9513,11074,11816,10010,11123,10554,11824,7215,9541,11869,314,11267,11725,7854,10370,9649,9648,11751,9524,11870,2009,8618,9084,8585,7870,7631,8584,8948,7808,10265,1685,5297,5386,6216,6497,8566,10433,8729,381,7024,8729,8584,8788,10056,10522,7721,10520,4390,9909,8922,551,9767,10502,8584,7870,6198,9522,1266,9521,6042,9515,9517,550,10637,10794,10793,10639,10791,10646,10790,10519,10846,9084,10980,10545,8618,3066,11017,9624,3018,11052,8917,9651,6501,7608,10326,10970,10327,7300,10645,10607,10753,10329,10324,10562,11089,11218,7808,9084,10827,7610,10520,10521,10669,11101,11049,6354,10728,10336,9880,10642,10644,10641,7631,11321,9084,10328,6354,10752,11320,11050,11493,10637,11432,10141,10643,8842,5419,10827,7808,4320,6354,9865,11017,8971,9233,9555,8816,3897,10970,3889,3883,8899) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC