select bs.LINE_ID AS LINE
	  ,bs.SEAT_NO AS SEAT_F
	  ,p2.SEAT_NO AS SEAT_T
from SEAT_RESERVE bs
left outer join (
	select LINE_ID
		, SEAT_NO
		, RSV_STATUS
	from   SEAT_RESERVE
	) AS  p1
ON  p1.LINE_ID = bs.LINE_ID
and p1.SEAT_NO = bs.SEAT_NO+1
left outer join (
	select LINE_ID
		, SEAT_NO
		, RSV_STATUS
	from   SEAT_RESERVE
	) AS  p2
ON  p2.LINE_ID = bs.LINE_ID
and p2.SEAT_NO = bs.SEAT_NO+2
where  bs.RSV_STATUS = '1'
and    p1.RSV_STATUS = '1'
and    p2.RSV_STATUS = '1'
order by bs.LINE_ID desc,bs.SEAT_NO asc