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,1699,5995,6117,3041,2705,5999,5328,6315,4131,2514,6314,4023,5180,6595,4682,6639,6674,6560,2590,6635,3368,6686,1113,6793,6792,2337,1298,252,3396,3542,3413,3055,2419,6713,4082,5373,3715,2967,6710,6857,6700,4136,1521,5596,6862,6863,3376,1992,6861,1698,2737,5812,6478,5379,6779,5142,739,6595,5739,4886,361,2046,3962,3135,1299,7016,3625,6782,5875,5349,3041,1164,4209,3534,3195,4805,3139,6979,7025,4553,6699,6734,6697,4048,7156,5047,5246,6694,6397,3941,6337,1698,7209,7005,6986,4875,5536,1067,5222,4570,1992,6661,5885,2737,7356,7558,7559,7582,7156,7550,6711,7709,3376,7593,6665,7143,3976,7857,7815,507,7875,7821,6694,7760,7896,6697,7876,7920,7581,7777,8016,7774,2944,1432,5536,2294,6673,8089,8102,8140,8215,1559,3904,2894,3195,4432,8291,5817,3775,4355,1835,4625,4740,5545,1347,3976,5081,4460,4741,6707,6478,1698,3941,8306,4739,8224,8543,8547,7025,8016,8104,7615,6858,1432,8480,5545,8175,8174,8629,3559,7016,5013,5875,8632,8687,5807,5328,8561,1347,2294,5543,504,3431,3474,7251,1521,7140,8782,8777,8809,6732,8819,4613,8812,4766,8801,8846,8813,8904,8905,8911,8208,4553,8916,4773,3244,8979,8978,8224,8104,3139,6665,4741,6699,1300,8974,7815,5906,9052,9072,9122,9017,9036,8888,9195,9196,9197,9200,9038,8704,9212,8231,2092,9220,9222,9223,9224,9255,9250,9273,9289,9291,9300,9301,9298,9242,9308,9317,8110,9278,9334,9347,9335,9337,9352,4049,4539,9363,9365,179,4767,1506,6559,6663,6876,5088,1520,793,464,5907,6001,308,585,600,6162,6168,358,3892,5647,4969,228,7258,6813,7304,6766,6954,6812,4217,7160,1830,6794,7144,6780,6155,2328,2506,6695,2863,6831,6802,7838,3046,7783,4983,6767,2419,7602,2573,6160,7146,8020,6159,725,3728,6811,8093,6588,7143,6605,6971,4570,6128,8096,8526,6726,8230,7822,8503,8836,6172,7304,8611,8512,7887,8109,6348,8852,8489,7897,8869,6104,8869,8032,7850,6809,8118,6845,8903,6104,9075,9116,4860,8630,9052,3725,7920,2023,8500,7839,585,8948,9366,4220,9354,2925,8933,9369,1490,8955,9541,8806,9069,7022,9543,6135,9453,3549,8543,8305,6117,9647,9648,4765,341,9200,4652,9345,9374,9348,1349,8934,9346,9939,9249,9248,8795,8915,8805,8935,9924,6821,8492,9922,4566,9941,9928,4566,8501,4128,9402,4061,8031,10057,10208,9910,9117,10063,7759,4056,3936,10227,3100,1698,7138,6683,145,6986,6635,6793,6684,9991,4131,10039,6679,9363,7761,9258,10341,6595,7354,10548,7019,10688,8222,8793,8222,9195,9552,9925,10245,9993,5236,9000,9027,9282,10762,9034,3595,10879,10938,10528,10955,768,10893,8829,9352,1127,233,228,11127,9749,9065,3964,4635,4656,5046,5193,7760,11021,9038,8629,11122,308,4023,10246,6314,6779,6169,6674,180,148,6639,180,3493,2261,11324,6686,8808,11324,9379,7147,8923,8781,8257,3059,10572,10535,8539,6792,10573,11213,9467,10906,6713,8769,11489,11377,7077,11220,7156,11361,11439,7077,11361,11439,9629,11018,7077,4537,2294,9055,9204,8048,4046,10915,11124,9639,2019,11353,11599,7661,1895,11287,3288,10719,7662,10623,11125,11521,9638,10623,9220,6713,10042,10623,10042,7125,11126,11724,2923,10895,7084,5368,11678,11760,8709,8368,11237,11692,11501,11693,11803,11867,11868,10630,10272,8056,11867,10689,10623,11502,11777,10624,11647,11210,10625,11349,11336,11273,11488,11274,11912,11028,10787,11279,11275,11542,9609,8548,7839,11262,7281,9259,11958,11020,8999,11337,11534,2160,6117,271,4886,6981,4901,4730,5245,7837,1645,4767,423,7834,7836,7919,7903,6205,7835,7821,7143,7833,7761,6478,1461,1325,1970,6595,1433,8222,2992,2029,4160,7760,7760,5542,3080,7130,7130,8812,8813,7852,3169,8250,6397,3913,6876,8098,8098,9222,9223,9224,9250,1536,9300,9017,61,9275,6870,6870,4346,9243,5286,5286,5997,9073,9614,9366,9552,9769,9477,324,9478,9641,9118,2660,8610,5252,9925,9925,9921,4510,10088,10087,10090,10089,10056,10086,10210,10079,2137,2137,3936,3525,10227,10229,9624,8705,9766,9968,9959,5763,10375,10212,7149,4178,4178,10608,8441,10523,9376,6103,9297,10434,7972,10548,7973,10382,7585,10397,6264,10711,10056,10315,7218,10748,10702,5567,7889,10870,10127,10749,10127,10350,11093,9255,11324,11455,11396,3059,4739,11105,11457,11489,10754,11517,11302,10012,11130,11741,8812,958,4741,11789,9777,4987,9766,7239,1349,9028,7276,8876,7900,8284,7872,7903,217,5513,4023,1741,156,7088,6664,9304,7815,7086,9308,8877,4796,8880,8477,7088,4535,9299,8889,4019,9561,8369,8460,9581,8772,8071,7674,8636,7285,8286,9910,9922,9959,10022,4765,9817,9819,9818,7097,9526,2032,8169,6769,8106,9125,6872,6889,4563,7144,5052,1142,8430,5053,5056,10116,9666,9212,9991,9800,9377,10008,2122,5420,7037,10081,10754,8092,9554,9036,7830,6805,10312,11021,9758,8915,9492,7987,1369,11129,11103,2288,10412,7285,5688,10847,11334,11338,10022,984,7666,7175,9438,365,380,376,8172,5903,11554,11630,11753,8891,9956,7086,11757,7935,11370,6632) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC