SELECT
    A.LINE
  , A.SEAT_F
  , A.SEAT_L AS SEAT_T
FROM
    (
        -- 抽出対象の割り出しSQL
        SELECT
            A.LINE_ID AS LINE
          , A.SEAT_NO AS SEAT_F
          , B.SEAT_NO AS SEAT_M
          , C.SEAT_NO AS SEAT_L
          , CASE
              WHEN C.SEAT_NO - A.SEAT_NO = 2 THEN '1' ELSE '0'
            END USE_INFO
        FROM
            SEAT_RESERVE AS A
            CROSS JOIN SEAT_RESERVE AS B
            ON  A.LINE_ID = B.LINE_ID
            AND A.SEAT_NO < B.SEAT_NO
            AND B.RSV_STATUS = '0'
            CROSS JOIN SEAT_RESERVE AS C
            ON  B.LINE_ID = C.LINE_ID
            AND B.SEAT_NO < C.SEAT_NO
            AND B.RSV_STATUS = '0'
        WHERE
            A.RSV_STATUS = '0'
    ) AS A
WHERE
    USE_INFO = "1"
ORDER BY
    A.LINE DESC
  , A.SEAT_F ASC;