SELECT
	TBL1.LINE_ID AS LINE,
	TBL1.SEAT_NO AS SEAT_F,
	TBL3.SEAT_NO AS SEAT_T
FROM
	SEAT_RESERVE TBL1,
	SEAT_RESERVE TBL2,
	SEAT_RESERVE TBL3
WHERE
	TBL1.LINE_ID = TBL2.LINE_ID AND
	TBL2.LINE_ID = TBL3.LINE_ID AND
	TBL1.SEAT_NO+1 = TBL2.SEAT_NO AND
	TBL2.SEAT_NO+1 = TBL3.SEAT_NO AND
	TBL1.RSV_STATUS = '0' AND
	TBL2.RSV_STATUS = '0' AND
	TBL3.RSV_STATUS = '0'
ORDER BY
	LINE DESC,SEAT_F