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,3702,834,3029,6715,5995,1492,6631,3029,4834,4437,7635,1296,2635,4438,7995,7840,5782,6844,1357,3863,5380,5567,5769,7641,4769,3823,2041,7879,567,6621,6843,5784,1526,6658,8358,1371,7840,8690,7962,1153,3913,4405,7304,6622,6393,6961,6965,6962,7658,7121,2473,2473,4639,4639,223,223,7088,7088,8438,223,223,8282,8358,458,6177,4218,714,408,1084,6349,6642,1881,6710,6741,5953,4765,6709,5949,931,6779,186,867,4597,2520,6789,579,5093,431,6813,6986,4898,5923,6561,6832,6622,6348,7019,452,5769,850,6842,2458,1616,2490,7239,405,698,1151,617,3395,3046,739,5088,5647,6004,6804,7359,3609,7547,1308,6193,7374,7759,582,1461,7760,7776,7872,582,431,7899,6312,7790,7889,7908,8031,8103,7907,1265,698,7889,2521,8110,8222,8214,7962,8183,8388,8195,8182,5455,446,1815,8483,8547,8358,7547,8390,7022,961,8629,8611,8725,8765,2006,2029,8793,7128,1052,8835,2989,2310,6622,6115,6190,6193,7790,5998,2093,8947,8918,2156,9027,5484,244,9038,223,5995,446,1298,5435,1359,1359,2342,2342,2342,7654,6584,6843,3823,3702,3702,4683,4683,4684,4684,7903,8,4769,8542,7027,5691,8489,4405,7846,1604,8110,1967,9985,9031,5810,7639,5512,5512,4435,7238,4302,6842,3976,2118,7761,6842,6010,3532,3595,3169,8093,6713,6505,8185,2933,3542,219,8220,6314,1347,6264,8547,387,3823,7151,7019,7761,8222,7647,7151,8793,7109,7125,6192,7082,8365,8816,8727,7080,7663,7550,2337,4455,4234,8923,8888,9038,9030,4566,2976,8222,8220,7879,8450,7258,7879,8250,8615,8926,8995,8823,8990,421,8082,9270,9271,7239,7281,9054,8084,7594,8361,9321,8083,7910,9315,9277,8222,8406,9469,9470,734,6168,8220,7238,6740,8998,931,8458,9527,9526,7070,7238,8401,6740,6740,8220,7238,7106,9552,8208,8891,8434,9302,9278,6386,3395,8439,1563,7022,3395,7904,8201,7256,3541,7944,8423,6731,1663,1663,1765,1769,5544,6740,1385,814,8423,10095,9261,9647,7907,179,3590,6828,178,10190,3380,5252,7094,10109,1645,8460,9571,3864,10584,4861,576,9058,7962,8024,9300,8354,6715,6312,8519,6312,8519,6832,6984,5371,1726,5371,1726,5371,1726,2997,1368,848,848,7580,9300,2989,9273,5039,4730,4901,8257,5210,9466,9637,9376,1537,2869,7897,3860,9486,9486,5994,3830,6010,6880,4087,9156,8925,9192,9143,365,368,386,391,6076,382,5994,9191,8899,5389,9951,9048,3890,1894,3890,1894,1895,7194,545,540,5669,542,5669,542,5445,549,5445,549,2923,9177,548,2703,5810,5368,6249,1954,9300,3860,6255,4234,8142,5995,4362,3860,4406,9321,4406,9321,2635,2706,6259,1894,8222,7641,4325,3029,6618,3744,5484,1609,322,8434,8628,6256,5669,7635,5693,4349,5854,2033,6252,4109,5799,1954,6248,1954,6248,6138,4923,8024,1307,1307,1307,1307,1307,2643,8137,6738,8250,8250,8250,5995,520,5098,4503,8108,7916,4920,4920,4920,4349,6606,5717,5770,4437,7828,4437,7828,6123,7307,1462,1462,7841,2830,7841,2830,9788,9801,9524,8947,9868,9340,1775,1772,9386,1774,6740,1462,4395,1462,2261,7238,1085,1086,2261,8763,8220,6891,1016,8220,9404,9525,4146,8820,7155,7654,7654,7647,7665,2473,6726,7076,1371,7605,3896,7986,9132,8666,9542,3913,587,7126,9340,9116,9900,7913,7572,7589,8290,10095,8306,446,1257,5995,1371,4234,3830,501,4796,5419,4860,5647,5322,924,9362,801,9489,4639,2294,10093,8947,10236,609,4784,8816,7966,5770,317,6605,793,2573,5848,4788,6560,320,947,4199,6130,1453,1521,6117,1038,1086,4337,6776,2447,6700,3184,7374,4510,4987,2384,5439,226,1439,5576,7204,6967,7605,5914,3885,1424,2748,2894,1272,8220,8271,7926,8220,8214,8560,8547,8415,5602,800,8556,7292,539,6689,7069,8047,7878,4399,7840,7169,9052,8547,9366,9362,9746,7112,766,9552,9796,8071,7089,10048,10056,7019,3159,9833,9945,8514,10146,10130,9116,10836,8556,9563,10906,10937,9864,10937,9227,10504,2615,10873,10872,8823,6599,10340,4146,867,10346,7913,2257,9939,10533,11971,9078,11660,11977,10760,11845,11494,10290,9463,11900,842,9651,5516,7906,7572,1591,6102,3457,4769,8268,8202,8399,6264,8425,8200,5994,4362,7280,4218,7897,358,7548,2399,6819,5380,4320,4320,7597,1371,156,8223,7281,7655,458,8947,461,4900,9292,5784,6578,7204,1380,8580,8404,9584,9582,9583,9585,8255,8255,9650,2913,2253,455,6843,7114,7547,8614,1492,7664,9737,6719,387,10020,1766,6198,6222,7162,6216,7199,6391,6388,6214,2951,6220,6218,9829,9165,8156,6920,6925,6926,4304,9734,6988,10161,6742,8656,9176,9177,8816,6498,6497,6216,6499,6939,3248,9737,9176,10387,1767,1766,8330,8328,8323,1768,7569,3515,9590,9591,11047,9593,10201,10725,10920,10561,10728,9588,10139,8325,10801,10216,9429,6534,6535,9493,3073,3070,6354,7753,6689,3071,10544,10053,9665,9946,11221,10544,10975,6209,9949,9186,1308,10269,10494,9649,6550,2447,10302,6870,9300,10873,9547,7238,9300,446,4178,3327,10442,4769,5769,9033,222,10339,10548,8542,8434,7160,9049,7576,7548,9049,6836,9949,8111,10211,5435,3327,9863,1988,2635,7976,10172,10339,3863,9488,10032,2652,1272,2490,2490,2490,2490,2490,5380,4401,5371,4349,10938,3241,3073,3071,10247,6689,4701,7647,10053,9665,10212,7753,7752,8088,1257,8627,9277,3428,9037,9679,1616,7239,6688,8944,1215,7881,9647,9867,7281,6537,446,10056,6534,6535,6506,10008,5386,9259,4765,10342,9133,8946,9132,10347,10541,9383,9370,7659,7251,8400,10615,10672,10232,8402,10228,9303,8403,9383,240,7662,10741,7080,8891,8251,51,5994,10275,10814,10552,5053,10738,10673,10910,9048,9389,10820,10836,8208,1303,6894,10267,10976,10975,8441,10649,9609,9889,10483,3908,11024,7917,11010,4405,7576,7962,8659,9737,8681,5386,8698,1411,1266,8817,1685,810,5297,1685,14,6076,8154,8816,4512,8683,8594,10431,24,1210,8815,5792,10520,834,7568,30,8730,7567,6689,7569,7570,7762,7764,8826,4804,9720,1589,2766,8822,7006,8278,10188,9906,9958,8814,10043,9970,10253,11031,10256,11032,10367,9354,9907,9629,10254,9630,10251,8826,10432,801,8358,9601,7959,8142,10868,223,9789,2818,10255,5484,2824,8814,2812,10569,8257,9348,11028,9678,8293,8520,9924,6113,3465,10146,11237,9221,9374,9807,9808,4639,8809,4639,452,9000,11414,10877,9215,11388,11437,11443,10697,11163,11477,6689,11129,11600,11656,11658,11660,11659,11662,8888,10892,10895,11488,11101,8358,11101,8358,10731,9888,7875,9464,9543,4639,11661,11497,4788,11101,582,11631,11632,8087,11754,1755,933,7910,11271,10892,7055,10387,10381,10390,10390,10386,10386,10488,6762,6916,6752,6759,6754,6760,6761,6928,6918,7162,323,11003,8696,8693,8656,4305,4299,9483,4299,9483,4292,4293,10920,57,10823,10725,9590,11161,10199,9829,9533,9675,7870,11611,9386,9231,380,9892,7546,8586,11750,11722,9920,11568,10565,11493,11269,6652,10463,9892,11602,11775,7962,10882,10579,7962,11486,10150,11101,3327,11342,10340,1770,4985,11304,11366,11201,10518,8995,11621,8019,9864,8358,10687,9320,6740) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC