select
t1.line_id AS LINE,
t1.seat_no as SEAT_F,
t3.seat_no as SETA_L
from seat_reserve as t1
left join seat_reserve as t2
on t1.line_id = t2.line_id
and t1.seat_no = t2.seat_no -1
left join seat_reserve as t3
on t2.line_id = t3.line_id
and t2.seat_no = t3.seat_no -1
where t1.rsv_status = '0'
and t2.rsv_status = '0'
and t3.rsv_status = '0'
order by line desc,seat_f