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,6155,2669,2913,3646,4079,6173,1755,6175,6700,1462,3169,958,3646,6967,6383,2253,6366,2913,7149,5421,6642,6644,2261,5046,311,7872,3428,6548,7605,1998,6130,6104,5484,6845,6809,4412,7022,2490,8178,665,7871,7994,7982,1116,6364,6979,7981,2761,4079,4405,8220,840,7992,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,5419,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,6981,7592,6740,7554,7833,6155,7754,1345,7751,7756,6131,5484,3510,7143,7833,7304,7903,1461,540,7124,7840,8547,4395,3850,9002,8934,8816,7572,7147,1349,7918,7069,3702,9053,7655,7655,7906,8077,9510,7668,8207,9386,9407,6631,7906,8955,6591,3282,9320,8422,9577,4339,9659,7669,6629,810,6693,9292,7159,1685,8794,9821,2913,9664,9813,9936,3604,8742,1992,2658,9354,9479,1967,9049,9933,9985,9526,9594,9594,754,7765,7880,2253,5956,5467,2009,2257,1462,5882,6593,1887,1327,6312,6377,5742,3704,2474,7048,6127,6810,1981,6816,7547,2554,6593,3865,3327,6140,6131,1462,310,3248,5782,2635,2643,3402,7363,2843,7599,2507,4154,5068,6905,6721,1990,6618,1990,6618,2967,5567,7958,4079,6127,8110,8607,4338,6829,3531,8768,6710,3561,3029,7641,3761,7632,2455,1051,4535,6807,5602,156,6364,46,6264,8924,4339,8482,6961,2447,5484,9603,8716,9552,3059,8812,4682,4682,8955,4765,5647,8019,6642,6780,9936,2491,4987,6362,4362,5322,4320,10107,9931,4580,1172,10457,7643,1272,10267,4983,10649,924,7037,6806,6958,6959,6960,6973,6972,6974,5165,458,10504,10229,10267,207,1051,265,7815,6059,265,10495,7882,10704,1992,11342,9336,9967,6767,10314,8518,11120,9423,8960,8839,4360,10860,11376,10608,9757,11131,11115,11676,3428,11112,9403,9234,8151,8780,4405,7992,2913,4079,4535,7721,4405,4766,10610,10337,10257,4800,1768,6519,6523,5864,1766,6532,2720,6498,6507,4300,6222,6497,6515,1767,2795,6200,4301,4936,6503,4305,6371,6529,4301,2720,4293,2780,2785,6504,2783,2778,2781,2779,2782,2784,2786,4290,4298,2787,6530,4300,4282,1766,1769,2818,2824,1764,1767,6263,222,3071,2789,6489,6531,4286,6354,3070,2823,1245,6198,6201,6199,6200,1767,1766,6354,3073,7137,511,7299,7300,7134,1767,2808,2803,3888,3885,2791,2820,2801,2802,2805,2807,2806,2794,6546,1769,2826,2827,2828,6514,1245,5576,1351,2869,834,3884,3882,7160,6515,6456,3891,3893,3896,3892,3890,7567,3897,6493,6271,6507,2720,7300,2677,2995,510,6523,6371,6743,3029,7548,6218,6199,6373,6223,6527,6201,810,2522,6354,6546,3070,7751,6689,3073,3071,1769,6750,7599,6746,7870,6749,2018,7753,6751,3889,3882,6599,374,810,379,391,387,6066,384,378,382,375,394,376,6082,1266,7215,7054,3898,1250,4178,5647,7752,6354,1766,7598,7600,7676,7137,7631,6809,4445,4827,4512,6354,3070,3073,3071,6689,550,7677,7168,7167,7170,7165,7163,7173,7164,7959,7922,7054,6985,7752,1767,1765,1769,1766,6168,7986,2522,1741,6354,8233,8232,6880,3071,3521,2389,3070,8272,2822,2823,2826,7238,8245,2728,2893,8294,7787,8432,344,8316,8220,8313,6509,6508,8307,7238,1767,6197,8520,8514,8315,8318,1769,5909,6520,8233,8246,8334,6521,8331,6513,6514,6507,6515,8358,4639,4535,5576,2869,834,1351,1741,8481,6505,6261,3913,3085,8698,8681,3850,5647,8682,6534,6537,4178,6535,8730,8520,8333,8649,601,2170,2390,3610,8342,6641,8596,8691,8814,8817,8815,8520,5996,8142,567,7634,7635,5551,8617,8719,2520,8591,8717,2522,8681,2522,8681,8780,8944,8817,7881,9041,8683,2253,4535,8826,8682,8945,6168,223,9030,4639,311,8358,8698,4834,2992,8175,6691,8727,2925,8232,8551,8681,3913,3172,9390,1232,3165,4178,5068,9736,10297,9390,9951,10364,10238,6971,9334,3646,10353,6209,9934,8514,3731,10164,9084,223,4639,6250,10527,7554,7592,4218,8555,6712,5567,8290,10505,10656,3646,10547,10531,7910,7756,10339,9669,10364,9670,1257,4178,446,222,9543,10865,10654,10877,6611,10296,10786,8306,7636,4985,2253,2913,8169,10669,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,5419,1768,9820,9933,9933,3874,3874,5064,5064,5056,10272,4146,2253,2253,8449,8449,10024,9999,9878,9844,9747,8071,4512,7238,11225,11225,7110,4349,10022,1770,10212,3165,11452,9574,8087,2658,4395,3863,8524,11438,9257,10868,2913,8520,4563,11437,2658,2989,8826,11485,9865,11400,9391,2467,11672,11594,180,8222,11661,11497,11658,1398,5770,7505,7505,7301,7301,4639,6239,7374,7374,820,820,6613,5996,8306,8828,8828,8828,8828,8828,8828,8828,8828,7130,5421,8973,8973,8973,8973,8973,9471,1771,1770,10041,1771,1767,1767,1767,1767,1767,8864,4199,6809,9391,10892,10543,8515) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC