|
Une Erreur est Survenue
DEBUG MODE
SQL Error : 1064 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 'DESC
HAVING rating_number >= 5
ORDER BY average DESC
LIMIT 10' at line 4
SELECT AVG(rating) AS average, COUNT(rating) AS rating_number, MIN(rating) AS min, MAX(rating) AS max, topic_id
FROM phpbb_rate_results
WHERE topic_id IN (86, 86, 86, 86, 86, 86, 86, 86, 86, 86, 86, 86, 86, 86, 87, 87, 88, 88, 88, 88, 96, 212, 212, 212, 212, 212, 212, 527, 527, 527, 527, 527, 527, 527, 527, 527, 527, 527, 527, 527, 527, 527, 527, 527, 527, 527, 527, 527, 527, 527, 527, 527, 527, 527, 527, 527, 527, 559, 559, 559, 559, 559, 559, 559, 559, 728, 728, 728, 780, 911, 911, 938, 938, 938, 938, 938, 938, 938, 938, 938, 945, 1372, 1372, 1372, 1372, 1372, 1372, 1372, 1372, 1372, 1372, 1372, 1372, 1372, 1459, 1591, 1591, 1775, 1776, 2003, 2003, 2003, 2096, 2096, 2096, 2096, 2253, 2272, 2428, 2428, 2428, 2428, 2428, 2428, 2428, 2428, 2428, 2428, 2428, 2428, 2428, 2428, 2428, 2428, 2428, 2428, 2428, 2428, 2428, 2428, 2428, 2428, 2428, 2428, 2428, 2428, 2726, 2741, 2750, 2750, 2750, 2826, 2826, 2826, 2826, 2826, 2826, 2826, 2826, 2826, 2826, 2826, 2826, 2826, 2909, 2912, 2912, 2912, 2912, 2927, 2927, 2945, 2945, 2945, 2945, 2945, 2945, 2945, 3063, 3138, 3138, 3138, 3138, 3138, 3138, 3138, 3138, 3138, 3138, 3176, 3277, 3294, 3294, 3346, 3346, 3403, 3403, 3417, 3427, 3472, 3472, 3472, 3489, 3489, 3489, 3491, 3491, 3508, 3562, 3562, 3562, 3562, 3595, 3595, 3675, 3730, 3752, 3752, 3752, 3895, 3909, 3909, 3909, 3909, 3909, 3922, 3922, 3922, 3922, 3922, 3922, 3922, 3922, 3922, 3922, 3922, 3922, 3922, 3922, 3922, 3922, 3922, 3922, 3922, 3922, 3922, 3922, 3922, 3922, 3922, 3922, 3922, 3922, 3922, 3922, 3922, 3930, 3930, 3958, 3958, 3958, 3958, 3958, 3958, 3958, 3958, 3958, 3958, 3958, 3958, 3958, 3958, 3958, 3958, 3958, 3958, 3958, 3958, 3958, 3958, 3958, 3958, 3958, 3958, 3994, 3994, 4056, 4056, 4056, 4056, 4056, 4056, 4121, 4121, 4121, 4121, 4121, 4121, 4121, 4121, 4121, 4121, 4121, 4121, 4121, 4121, 4121, 4121, 4166, 4245, 4245, 4245, 4245, 4372, 4372, 4372, 4372, 4468, 4468, 4521, 4521, 4521, 4521, 4521, 4521, 4521, 4521, 4521, 4521, 4521, 4521, 4521, 4521, 4521, 4521, 4521, 4557, 4605, 4616, 4616, 4616, 4616, 4616, 4616, 4616, 4616, 4616, 4616, 4616, 4616, 4616, 4616, 4622, 4622, 4622, 4622, 4622, 4622, 4622, 4622, 4622, 4622, 4622, 4622, 4622, 4622, 4622, 4622, 4622, 4622, 4632, 4632, 4632, 4632, 4632, 4632, 4632, 4632, 4632, 4671, 4713, 4713, 4713, 4713, 4713, 4713, 4713, 4713, 4713, 4713, 4713, 4713, 4713, 4713, 4713, 4713, 4713, 4713, 4713, 4713, 4713, 4713, 4713, 4713, 4713, 4771, 4771, 4771, 4771, 4784, 4817, 4817, 4817, 4817, 4831, 4864, 4864, 4881, 4881, 4881, 4881, 4892, 4892, 4892, 4913, 4913, 4913, 4913, 4935, 4935, 4959, 4959, 4959, 4959, 4959, 4959, 4959, 4959, 4959, 4959, 4959, 4959, 4983, 4983, 4983, 4983, 4983, 4983, 4983, 4983, 4983, 4983, 4983, 4983, 4983, 4983, 4983, 4983, 4983, 4983, 4983, 4983, 4983, 4983, 4983, 4983, 4983, 4983, 4983, 4983, 4983, 4983, 5018, 5018, 5018, 5021, 5021, 5021, 5021, 5025, 5085, 5085, 5085, 5085, 5085, 5085, 5085, 5085, 5085, 5085, 5113, 5113, 5113, 5113, 5113, 5129, 5157, 5179, 5179, 5179, 5179, 5179, 5179, 5179, 5179, 5179, 5179, 5179, 5179, 5179, 5179, 5179, 5179, 5179, 5179, 5179, 5204, 5204, 5204, 5204, 5206, 5206, 5206, 5206, 5206, 5206, 5206, 5206, 5206, 5206, 5206, 5206, 5206, 5206, 5206, 5206, 5206, 5206, 5264, 5264, 5264, 5264, 5264, 5288, 5288, 5288, 5288, 5288, 5288, 5288, 5315, 5353, 5353, 5365, 5365, 5365, 5365, 5365, 5365, 5365, 5370, 5370, 5370, 5399, 5399, 5399, 5399, 5399, 5399, 5399, 5399, 5399, 5399, 5401, 5419, 5440, 5442, 5442, 5442, 5453, 5453, 5514, 5514, 5514, 5514, 5529, 5529, 5529, 5531, 5535, 5536, 5548, 5548, 5548, 5548, 5548, 5548, 5548, 5548, 5548, 5548, 5548, 5548, 5548, 5548, 5548, 5548, 5548, 5548, 5548, 5548, 5548, 5548, 5548, 5548, 5548, 5548, 5570, 5570, 5570, 5570, 5570, 5579, 5579, 5579, 5579, 5579, 5579, 5579, 5579, 5591, 5591, 5591, 5591, 5591, 5591, 5591, 5591, 5591, 5591, 5591, 5591, 5591, 5591, 5591, 5591, 5591, 5591, 5591, 5591, 5591, 5591, 5591, 5591, 5591, 5591, 5591, 5591, 5591, 5591, 5591, 5592, 5592, 5592, 5592, 5592, 5592, 5592, 5594, 5597, 5597, 5597, 5597, 5597, 5597, 5597, 5597, 5597, 5597, 5597, 5597, 5597, 5597, 5597, 5597, 5597, 5597, 5597, 5597, 5597, 5598, 5598, 5598, 5598, 5598, 5598, 5598, 5598, 5598, 5598, 5598, 5598, 5598, 5598, 5598, 5598, 5598, 5598, 5598, 5598, 5598, 5598, 5601, 5601, 5601, 5604, 5606, 5606, 5606, 5606, 5606, 5606, 5606, 5606, 5606, 5609, 5609, 5610, 5610, 5610, 5610, 5610, 5610, 5610, 5610, 5614, 5614, 5614, 5614, 5614, 5614, 5614, 5614, 5615, 5616, 5616, 5616, 5617, 5617, 5617, 5617, 5617, 5617, 5618, 5618, 5618, 5618, 5618, 5618, 5618, 5618, 5618, 5618, 5618, 5618, 5618, 5618, 5618, 5618, 5618, 5618, 5618, 5618, 5618, 5618, 5621, 5621, 5621, 5621, 5621, 5621, 5621, 5621, 5621, 5621, 5621, 5621, 5621, 5622, 5622, 5622, 5625, 5625, 5625, 5625, 5625, 5625, 5625, 5625, 5625, 5625, 5625, 5625, 5625, 5625, 5625, 5625, 5625, 5625, 5625, 5626, 5626, 5626, 5626, 5626, 5626, 5626, 5626, 5626, 5626, 5626, 5630, 5634, 5634, 5634, 5634, 5634, 5634, 5634, 5634, 5637, 5637, 5637, 5637, 5637, 5637, 5637, 5637, 5640, 5640, 5640, 5655, 5655, 5658, 5666, 5666, 5666, 5666, 5666, 5666, 5666, 5666, 5666, 5666, 5666, 5666, 5666, 5668, 5668, 5679, 5685, 5690, 5690, 5694, 5694, 5694, 5700, 5700, 5700, 5700, 5700, 5700, 5700, 5700, 5700, 5700, 5700, 5700, 5700, 5706, 5706, 5714, 5721, 5726, 5726, 5727, 5728, 5728, 5728, 5728, 5728, 5731, 5731, 5731, 5731, 5734, 5734, 5734, 5734, 5734, 5734, 5734, 5734, 5734, 5734, 5734, 5734, 5734, 5734, 5734, 5734, 5734, 5734, 5734, 5734, 5734, 5734, 5734, 5743, 5750, 5789, 5789, 5795, 5795, 5795, 5795, 5795, 5795, 5795, 5795, 5795, 5795, 5795, 5795, 5795, 5795, 5795, 5795, 5795, 5795, 5796, 5796, 5796, 5808, 5817, 5817, 5817, 5817, 5817, 5817, 5817, 5825, 5831, 5831, 5831, 5831, 5831, 5831, 5842, 5842, 5842, 5842, 5842, 5842, 5842, 5850, 5850, 5850, 5850, 5850, 5850, 5850, 5850, 5850, 5850, 5850, 5850, 5850, 5850, 5850, 5850, 5850, 5850, 5850, 5850, 5850, 5850, 5850, 5850, 5850, 5850, 5859, 5880, 5881, 5881, 5881, 5881, 5881, 5881, 5881, 5881, 5881, 5881, 5881, 5881, 5881, 5881, 5881, 5881, 5881, 5892, 5892, 5892, 5895, 5898, 5902, 5902, 5902, 5902, 5902, 5902, 5902, 5902, 5902, 5902, 5902, 5903, 5904, 5904, 5904, 5904, 5904, 5904, 5904, 5904, 5906, 5916, 5924, 5924, 5924, 5924, 5927, 5942, 5942, 5942, 5942, 5942, 5942, 5942, 5946, 5946, 5946, 5946, 5946, 5946, 5946, 5952, 5952, 5968, 5968, 5968, 5968, 5968, 5968, 5968, 5986, 5986, 5986, 5986, 5986, 5986, 6026, 6026, 6026, 6026, 6026, 6026, 6026, 6026, 6026, 6026, 6028, 6028, 6029, 6029, 6029, 6029, 6029, 6029, 6029, 6029, 6029, 6035, 6099, 6099, 6099, 6099, 6099, 6099, 6099, 6106, 6106, 6106, 6106, 6106, 6106, 6106, 6106, 6106, 6106, 6106, 6130, 6144, 6144, 6151, 6151, 6151, 6151, 6151, 6151, 6151, 6151, 6151, 6151, 6151, 6151, 6151, 6151, 6151, 6151, 6151, 6151, 6151, 6151, 6160, 6160, 6160, 6251, 6269, 6303, 6303, 6303, 6303, 6303, 6303, 6303, 6303, 6303, 6303, 6303, 6303, 6303, 6303, 6303, 6303, 6303, 6303, 6303, 6303, 6303, 6303, 6303, 6303, 6317, 6317, 6317, 6317, 6317, 6317, 6317, 6317, 6317, 6317, 6317, 6317, 6317, 6323, 6323, 6323, 6343, 6347, 6383, 6418, 6418, 6434, 6434, 6434, 6434, 6441, 6455, 6511, 6511, 6511, 6511, 6548, 6580, 6594, 6640, 6640, 6640, 6640, 6640, 6640, 6646, 6647, 6652, 6652, 6652, 6652, 6714, 6714, 6714, 6714, 6714, 6714, 6714, 6714, 6714, 6714, 6714, 6714, 6714, 6716, 6716, 6716, 6742, 6758, 6777, 6988, 7032, 7032, 7065, 7153, 7173, 7203, 7203, 7203, 7203, 7203, 7203, 7267, 7273, 7298, 7347, 7347, 7361, 7399, 7404, 7404, 7405, 7405, 7410, 7548, 7599)
GROUP BY topic_id DESC
HAVING rating_number >= 5
ORDER BY average DESC
LIMIT 10 Line : 530 File : functions_rate.php |
|
|