SQLize Online / PHPize Online  /  SQLtest Online

WITH tmp_1 AS ( SELECT bs.seat_no, substring(bs.seat_no FROM '[\d]+') as seat_row, t.passenger_name, t.contact_data FROM boarding_passes bs JOIN tickets t ON bs.ticket_no = t.ticket_no WHERE EXISTS ( SELECT 1 FROM flights f WHERE flight_no = 'PG0510' AND scheduled_departure::date = '2017-07-16' AND bs.flight_id = f.flight_id ) ) SELECT t1.seat_no, t1.passenger_name, t1.contact_data, t1.seat_row, t2.passenger_name FROM tmp_1 t1 JOIN tmp_1 t2 ON t1.seat_row = t2.seat_row WHERE t1.passenger_name = 'MIKHAIL VOROBEV' AND t2.passenger_name = 'MIKHAIL VOROBEV'