SELECT
	BASE.LINE_ID AS LINE
	,PREV.SEAT_NO AS SEAT_F
	,NEXT.SEAT_NO AS SEAT_T

FROM
	SEAT_RESERVE AS BASE
	
INNER JOIN SEAT_RESERVE AS PREV
ON PREV.LINE_ID = BASE.LINE_ID
AND PREV.SEAT_NO = BASE.SEAT_NO - 1
AND PREV.RSV_STATUS = '0'

INNER JOIN SEAT_RESERVE AS NEXT
ON NEXT.LINE_ID = BASE.LINE_ID
AND NEXT.SEAT_NO = BASE.SEAT_NO + 1
AND NEXT.RSV_STATUS = '0'

WHERE
	BASE.RSV_STATUS = '0'

ORDER BY 
	BASE.LINE_ID DESC
	,PREV.SEAT_NO ASC;