WITH AKI AS (
	SELECT
		LINE,
		RSV
	FROM
		(SELECT
			'A' AS LINE,
			group_concat(RSV_STATUS, ',')  AS RSV
		 FROM
		 	(SELECT * FROM SEAT_RESERVE WHERE LINE_ID = 'A' ORDER BY SEAT_NO)
		UNION ALL 
		SELECT
			'B' AS LINE,
			group_concat(RSV_STATUS, ',')  AS RSV
		 FROM
		 	(SELECT * FROM SEAT_RESERVE WHERE LINE_ID = 'B' ORDER BY SEAT_NO)
		UNION ALL 
		SELECT
			'C' AS LINE,
			group_concat(RSV_STATUS, ',')  AS RSV
		 FROM
		 	(SELECT * FROM SEAT_RESERVE WHERE LINE_ID = 'C' ORDER BY SEAT_NO)
		UNION ALL 
		SELECT
			'D' AS LINE,
			group_concat(RSV_STATUS, ',')  AS RSV
		 FROM
		 	(SELECT * FROM SEAT_RESERVE WHERE LINE_ID = 'D' ORDER BY SEAT_NO)
		UNION ALL 
		SELECT
			'E' AS LINE,
			group_concat(RSV_STATUS, ',') AS RSV
		 FROM
		 	(SELECT * FROM SEAT_RESERVE WHERE LINE_ID = 'E' ORDER BY SEAT_NO)
		) 
	WHERE
		RSV LIKE '%0,0,0%'
)
SELECT
    LINE,
	INSTR(REPLACE(RSV, ',', ''), '000') AS SEAT_F,
	INSTR(REPLACE(RSV, ',', ''), '000') + 2 AS SEAT_T
FROM
	AKI
ORDER BY
    LINE DESC