选择具有过滤器MYSQL的特定位置的最小值

I have a little trouble with my subquery. I try to only take the nearest event in a table with a min value, but I need it to be confirmed (confirmed = 1 and cancelled = 0)I have a little trouble with my subquery. I try