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,6000,4971,5279,1167,2158,3823,6586,2300,5215,3701,6294,993,550,1771,524,1586,3702,2522,6980,675,6843,538,546,6042,528,3913,7123,537,5576,1296,528,526,7250,7085,7086,1664,6306,2006,7977,5897,6740,553,7238,544,8220,7654,587,8102,182,7903,1807,7110,7932,8077,8544,8470,8615,8306,8528,8047,7268,7080,7660,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,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,7953,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,3913,3609,5927,7304,7278,7215,6578,3428,1988,7143,3604,8220,7840,7833,5995,7112,3609,8082,8358,2473,2473,2473,8514,8947,2749,6843,7160,5996,2992,7304,1537,2473,7548,7205,3860,6740,7238,3860,7840,8220,3860,6582,5576,7110,6010,6766,7158,2029,783,7249,2006,7834,7903,7998,4046,6971,8204,8204,6894,3824,7081,8087,7659,7149,8206,379,8290,8648,8648,8648,8547,8547,8547,8713,8706,7928,7928,8611,8948,8823,3066,961,8198,8948,9053,9053,8415,8743,7670,9128,2261,8023,7118,7151,7675,2024,8447,7245,8444,8460,8765,8460,3385,8365,8067,8067,7074,9349,6806,8995,8995,6270,6270,2122,8787,392,8858,8786,8784,391,9481,7082,9418,924,6740,7238,5927,6190,511,7213,6979,801,958,6725,6270,372,7872,6349,7828,464,2897,7912,1151,408,3647,7861,5965,7994,223,6593,7599,7605,4395,6364,4320,7982,4535,8626,5959,8947,7874,8969,2253,9014,5763,8281,8991,5952,7128,7148,8836,6891,7146,7773,8108,6000,3878,952,7849,5024,5717,2447,6667,6584,3838,7912,6766,6588,4355,952,5763,223,223,7946,7946,7307,7374,7374,6361,6361,4979,2458,2458,4399,4399,7849,7849,317,4979,5303,9042,9975,9975,10033,10036,1662,6402,820,6700,6714,7304,6801,7976,3184,6403,6803,7307,7083,6549,6549,408,3891,7238,7238,7976,6740,7304,7094,8529,6390,8402,8410,8292,8292,8479,8686,8435,7897,6658,8302,7995,7995,8613,8613,8292,358,2005,8868,8868,2342,2342,8290,8435,5763,8683,8683,6408,1242,4227,7388,7483,3957,947,6740,7238,1591,6264,6131,714,7209,1624,7219,4362,2677,6261,5251,7922,7539,3704,6658,7576,7872,8292,6003,6104,6691,6810,6770,3515,3889,8111,3882,4769,4724,3895,6725,3888,5927,6971,1462,8436,7012,3884,6450,8390,368,8003,5922,3896,6797,3967,6983,4297,4299,4302,9028,1265,6578,8355,7205,3581,9049,7160,8661,8490,8917,8885,6490,6209,7912,9502,7576,6235,1151,4742,5279,2033,744,2658,3368,5148,7833,5251,2932,5576,4701,9221,8303,2169,1242,6733,7761,2932,2033,5770,501,4861,4178,8913,8912,5070,9030,3850,4029,8933,6843,6122,7928,7354,1461,9052,5070,8089,6740,7238,8220,3702,9879,9116,9939,4860,9939,217,9242,9896,10002,4178,9600,4406,10047,9983,9983,9983,9471,2261,2776,3702,3702,6843,6843,778,778,1779,7654,7155,7083,7083,8793,8544,8193,6381,7307,7124,323,7270,6740,7238,8220,2041,6715,7976,7076,8738,6569,182,8541,8922,6843,3647,2331,6700,659,9338,9612,186,6548,778,9300,6715,8922,9296,1927,6151,8840,8214,6700,8699,6286,1782,1774,1782,1774,1782,1774,6611,7893,842,4405,1927,4706,4224,120,9970,6584,10001,28,1768,10043,10043,10043,10043,10043,3830,7548,8230,2473,2473,6646,2573,8305,9049,7576,5961,5961,1738,5770,6962,2331,4860,6402,6613,7725,6599,840,6367,7708,9386,7105,9359,9986,6367,7646,7217,1785,9618,10060,7251,7089,7743,7505,7723,9320,2830,9320,2830,6402,6402,6402,5719,7708,9547,9546,8355,3936,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,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,5419,9926,6819,4320,4900,1324,2041,6583,6561,8115,8115,9169,9169,5484,7979,8425,8236,8236,8547,8547,8438,8438,9308,9258,9366,9366,5636,114,114,6857,9347,9347,9554,9533,9675,8514,8514,1345,8175,6715,5269,7875,7876,9900,9952,9945,8306,9386,9320,9320,9942,10687,11489,9951,6822,10966,5435,9418,10892,10984,11485,10932,6242,11285,11342,7976,11455,10141,11477,9950,11328,11101,10731,11215,10343,10278,947,1207,7641,9655,10505,9533,11289,10566,8169,11272,10687,4779,11226,4574,8109,2342,11303,9389,10909,10339,11900,11363,11302,10380,423,396,11101,10344,11217) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC