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,101,222,6011,1537,6362,550,6158,6774,6154,6559,5882,6691,5995,2709,6746,6743,7159,6177,6983,801,5175,969,7938,6380,6381,7756,7659,4390,8231,6926,1886,7546,8584,6008,8681,8698,6933,8817,8910,8156,8514,573,551,3893,3889,6006,4411,6100,2218,3038,1145,1345,6023,4798,6953,3428,4226,3830,4125,840,6619,4920,3070,3073,5782,5380,1537,3071,2399,5872,4437,6122,5421,4218,5770,5371,5576,1462,2342,1343,4570,3863,2455,1461,5576,2269,7307,6981,2869,6809,1351,4535,6809,7020,834,501,7020,5657,3850,6709,2269,1764,7359,4446,934,7546,1038,6599,698,4566,452,3492,6845,6721,156,1271,6723,446,7604,924,5647,1973,4178,2932,1200,4362,5148,766,2932,4860,2006,7160,7631,1993,3830,1439,4901,713,5995,1453,4796,6367,6103,5837,754,2029,5269,7840,6168,5376,6981,7592,6740,7554,7833,6155,7754,1345,7751,7756,6131,5484,7304,5602,8434,6740,6740,6740,6740,6740,1250,1250,1250,1250,1826,650,6565,7147,1085,1086,3850,358,5915,7160,840,7240,7548,6589,6130,4597,2117,2628,975,2555,3525,7869,8223,734,3760,8095,8094,8488,6740,7034,396,743,7594,5602,8587,7783,6712,7910,8440,2117,7840,7879,7878,4146,6740,7238,1349,8306,446,1257,5995,1371,4234,3830,501,4796,4860,5647,5322,924,9362,801,9489,7953,4639,2294,10093,8947,10236,609,4784,8816,9014,3402,223,924,8885,2253,2253,6984,1666,9513,9513,7547,7547,4216,8659,8017,9823,9823,6642,9678,7840,240,3510,7070,7078,7283,6386,7906,8157,3860,7068,8397,2992,8415,1537,7304,2951,7897,7100,8743,7939,7088,5996,8080,8422,7252,7644,7830,5647,7588,252,2736,1533,1210,1210,466,8454,464,8287,8909,8585,9084,8682,7912,4834,4986,3165,8665,4405,801,8816,8815,7024,4834,5995,7304,446,446,8520,4259,8220,7635,9209,8142,8512,840,924,8780,8816,1993,6367,8520,6548,6715,924,8388,5717,2399,4769,6621,104,1142,240,8970,6700,6631,9215,840,6006,9229,5484,1591,6264,2644,7144,8821,5052,6774,5371,217,9390,8833,9281,3327,5770,2253,8515,7838,2029,9468,9027,9322,2117,1371,6131,9162,9513,2006,7861,4435,9538,2005,2085,1052,4395,7923,7976,1242,2989,9480,7992,6642,9524,9479,6103,6004,906,9603,3428,9629,317,754,9306,6691,4079,8685,8815,8814,8826,7576,9704,3598,156,1153,9678,8659,9559,9546,9760,1912,3236,6905,4913,7599,9390,9480,4154,9754,6102,2342,8508,2467,6176,9763,9770,9783,120,6977,9782,6602,9014,7640,9344,4563,6652,9762,6623,8352,9812,2843,9830,8685,6841,8292,8544,9006,9879,9865,9866,207,9872,9918,4216,9926,6819,4320,4900,8050,28,28,7089,8211,7666,8055,8055,7106,389,8460,7261,8084,7266,7075,7241,7246,7713,7151,7665,7100,8395,7094,8065,7273,7096,4178,7109,7268,7268,7080,7654,7654,8034,7076,8438,9620,9611,9745,8401,9622,9746,9621,9748,9744,9719,9259,9675,9980,8358,5484,5602,5995,9258,8047,6539,681,10024,8450,9874,9956,9877,5053,9957,9876,3380,9148,7150,8450,7266,5995,840,4146,1768,9820,9933,9933,3874,3874,5064,5064,5056,10272,4146,2253,2253,8449,8449,10024,9999,9878,9844,9747,8071,5376,5376,4512,7238,11225,11225,7110,4349,10022,1770,10212,3165,11452,9574,8087,2658,4395,3863,8524,11438,4535,1095,7773,4395,5996,3428,4395,2932,4209,4079,8902,9630,8092,526,546,4796,4769,5995,4860,9761,9746,1439,9785,10002,9808,7920,9750,840,608,7839,9668,3941,9925,9638,9220,10173,10165,10149,6632,10243,10115,10135,10245,10233,10229,10244,9993,10042,107,10148,10188,10243,10246,10284,9406,5647,9453,10266,840,10440,1461,10080,10258,10380,665,10283,10439,10141,1215,10212,10268,3913,10314,10375,3989,4861,5148,9052,5799,1257,10062,10227,3241,2706,8893,6842,5070,9602,8514,9420,4234,2632,766,10787,4861,4901,2894,2594,8517,10879,10894,501,396,10128,10895,10315,6842,10375,10306,9453,11028,10020,9780,10569,7614,7615,7550,6713,8837,4082,7017,8888,11237,9454,8925,11488,2706,10856,11349,5373,252,3542,1521,9220,10375,11593,9904,5739,9374,9615,4455,4739,10857,4455,4739,10857,1490,640,4411,2023,9987,779,11644,10798,10300,8049,7906,10342,10530,11595,11678,11594,8548,9850,9348,6557,6961,739,11492,1127,10131,1371,8947,120,5810,9547,3334,4769,924,5380,9667,3327,5435,5322,4320,4742,9946,10314,10228,10871,8358,916,9771,3863,5435,5806,5385,10987,10687,9863,10976,10910,10985,11293,10816,8683,10780,5647,1371,5380,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,8728,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,10827,7808,4320,6354,9865,11017,8971,9233,9555,8816,3646,1765,1765,3646,8962,1771,1767,4639,2520,11101,8815,10278,1755,1116,4563,11658,4784) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC