select
    t1.line_id as LINE,
    t1.seat_no as SEAT_F,
    t3.seat_no as SEAT_T
from seat_reserve t1
join seat_reserve t2
    on t2.line_id = t1.line_id and t2.seat_no = t1.seat_no + 1 and t2.rsv_status = '0'
join seat_reserve t3
    on t3.line_id = t2.line_id and t3.seat_no = t2.seat_no + 1 and t3.rsv_status = '0'
where t1.rsv_status = '0'
order by t1.line_id desc;