['and', 'status=1', ['or', 'id=1', 'id=2']]
status=1 AND (id=1 OR id=2)
SELECT
name,
SUBSTRING(GROUP_CONCAT(CONCAT(value, ',', param1, ',', param2, ',', param3, ';') ORDER BY value DESC), 1, LOCATE(';', GROUP_CONCAT(CONCAT(value, ',', param1, ',', param2, ',', param3, ';') ORDER BY value DESC))) as value
FROM test
GROUP BY name
SELECT
name,
GROUP_CONCAT(CONCAT(value, ',', param1, ',', param2, ',', param3) ORDER BY value DESC SEPARATOR ';') as value
FROM test
GROUP BY name