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,7149,3043,4512,2520,8305,6642,3728,6780,5484,4936,6138,452,222,1181,8933,6364,8995,9104,8960,4944,665,2998,8999,8182,4901,8306,1245,8141,7852,8613,8910,455,1912,9208,8970,8231,1738,2974,2151,7920,1055,1727,6855,9389,5623,2299,2639,955,5765,9223,9222,8844,9224,9255,9250,9402,3303,8965,9623,8960,4969,4128,254,5516,4656,9011,9290,9556,8812,8151,4049,9275,9344,4046,6986,9397,9766,4061,9777,9464,9951,9959,9827,8554,9910,9931,1016,10012,5236,10040,10014,3908,5046,10017,10015,10019,10004,10109,10110,9243,9981,9250,8762,10056,10090,7759,4099,3936,6766,9758,6571,10013,8889,10086,10242,8031,10018,9482,9541,162,4566,6876,10104,9538,9652,10021,9926,3590,10039,8844,8870,1568,10361,10397,10055,10241,2639,3415,10267,10355,10358,5839,10547,4056,9402,10480,9243,10619,10620,10621,5039,9273,8019,6681,8305,9647,10227,10711,10718,10063,2639,3844,1055,2299,3585,10720,10785,10350,10895,9558,10003,10619,10783,10784,5193,10734,10856,10380,10966,1485,10439,10440,8193,10805,10552,10820,7760,9749,10895,9968,10857,11028,9798,10149,10476,10715,10878,2954,9634,9929,10364,10131,10283,10284,7581,9648,9930,10648,10711,10990,11142,9961,10895,10964,11018,10135,11123,9347,6857,11220,2506,36,11234,11302,2446,129,9471,8543,6117,10476,11272,10935,11314,9961,11383,11382,10413,10786,228,11287,10748,10749,10397,11106,11395,11424,10870,5877,11304,10129,11302,11473,10934,11446,11423,3964,11396,10785,11171,11602,11608,11442,11443,9347,11599,9961,11457,10413,10608,8441,7835,10719,11353,8441,7835,11655,10819,10911,10672,11344,11646,2594,2473,186,501,6158,5070,1461,675,4801,2753,698,308,4765,6156,6695,6348,5763,958,6842,1350,5904,6633,5910,7238,3728,3043,1738,2261,186,6845,2932,6740,3830,1029,223,1183,1645,2615,4898,2182,7210,8220,2063,5959,8554,9202,308,6121,186,3647,7783,5763,9198,2117,6364,9392,3172,2925,1232,2658,9422,6103,2627,7976,6712,8836,8951,8947,8681,8358,322,4860,9049,9235,9235,8539,2447,2447,8616,9647,9731,9789,182,6569,7019,8222,7761,8845,4109,9195,1662,4796,7837,7834,7835,7836,8441,9297,9552,7003,8851,9614,9300,9030,9960,9925,7641,8617,9548,9879,9897,10056,9525,9463,8296,3989,7634,6726,6849,6971,9890,2164,8281,9488,10526,9085,10265,8948,186,2632,10836,10302,10471,8726,10549,2261,10480,8816,10531,1461,11121,10464,1645,11128,11230,9951,9000,11325,7909,11304,176,9814,8995,10064,8109,6712,650,8512,3849,10656,6571,11089,10636,11494,10040,11644,9993,11741,11219,10938,11324,11455,10548,3595,9993,6876,8388,11457,9634,11302,7238,6740,4784,8541,11121,223,10911,10876,10720,1767,11117,10672,8491,3908,9959,9368,9367,7670,9954,8648,10933,9161,4800,9649,10077,4401,4079,7874,10655,10702,9135,10976,10187,10768,10891,207,6953,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,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,1645,2447,186,8516,10142,9136,1381,9296,9915,2847,4076,431,10219,1327,9959,126,1765,4337,9296,4432,8389,7218,6740,7828,8145,9382,3169,3532,9392,1230,9543,9389,9066,3574,3581,7882,8661,10056,7877,10031,1044,10258,9953,6141,4156,7632,10273,9090,9507,10032,10113,9972,10484,10514,10476,10471,10776,10474,10414,10836,10905,8991,9136,8926,10751,8185,10935,11082,8175,2867,10111,10884,9976,11325,2171,9011,8289,4906,8102,10170,11361,11690,10622,11742,11101,11402,6134,10667,3646,1765,1765,3646,1771,1767,4639,2520,11101,8815,10278,1755,1116,4563,11658,5419,4784,7909,6561,6561,6561,7371,10203,4769,7501,10296,11019,10292,6718,10992,207,10310,6406,11269,10940,11247,11118,10466,9716,10408,10490,9706,9718,11254,6603,9708,11051,11427,9690,10695,860,11263,11295,6361,11053,11467,10438,9384,10730,9936,6443,6271,11731,10721,9042,11727,8685,11792,7219,365,374,7806,6586,3823,6003) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC