select sr1.LINE_ID as LINE
,sr1.SEAT_NO as SEAT_F
,sr3.SEAT_NO as SEAT_T
from SEAT_RESERVE sr1
left join SEAT_RESERVE sr2
on  sr2.LINE_ID = sr1.LINE_ID
and sr2.SEAT_NO = sr1.SEAT_NO + 1
left join SEAT_RESERVE sr3
on  sr3.LINE_ID = sr2.LINE_ID
and sr3.SEAT_NO = sr2.SEAT_NO + 1
where sr1.RSV_STATUS = '0'
and sr2.RSV_STATUS = '0'
and sr3.RSV_STATUS = '0'
order by sr1.LINE_ID desc,sr1.SEAT_NO