为什么这个group_concat无法正常工作？

I don't understand why this GROUP_CONCAT is not working, as far as the outer query is concerned there are 3 rows returned so I want to group_concat by that but it doesn't like it...I don't understand why this GROUP_CONCAT is not