SELECT 
SEAT1.LINE_ID as LINE
,SEAT1.SEAT_NO as SEAT_F
,SEAT3.SEAT_NO as SEAT_T
FROM SEAT_RESERVE SEAT1
LEFT JOIN 
SEAT_RESERVE SEAT2
ON 
SEAT1.LINE_ID = SEAT2.LINE_ID
AND
SEAT1.SEAT_NO +1 = SEAT2.SEAT_NO
LEFT JOIN 
SEAT_RESERVE SEAT3
ON 
SEAT1.LINE_ID = SEAT3.LINE_ID
AND
SEAT1.SEAT_NO +2 = SEAT3.SEAT_NO
WHERE SEAT1.RSV_STATUS = '0' and SEAT2.RSV_STATUS = '0' and SEAT3.RSV_STATUS = '0'
ORDER BY SEAT1.LINE_ID DESC ,SEAT_F