SELECT
 LINE_ID AS LINE,
 SEAT_NO AS SEAT_F,
 SEAT_NO + 2 AS SEAT_T
FROM
 SEAT_RESERVE
INNER JOIN
(
SELECT
 LINE_ID AS LINE,
 SEAT_NO AS SEAT2
FROM
 SEAT_RESERVE
WHERE
 RSV_STATUS = '0'
) A
ON
 A.LINE = SEAT_RESERVE.LINE_ID
AND
 A.SEAT2 = SEAT_RESERVE.SEAT_NO + 1 
INNER JOIN
(
SELECT
 LINE_ID AS LINE,
 SEAT_NO AS SEAT3
FROM
 SEAT_RESERVE
WHERE
 RSV_STATUS = '0'
) B
ON
 B.LINE = SEAT_RESERVE.LINE_ID
AND
 B.SEAT3 = SEAT_RESERVE.SEAT_NO + 2 
WHERE
 RSV_STATUS = '0'
ORDER BY
 LINE_ID DESC,
 SEAT_NO ASC