Speakers

latency=> SELECT

latency-> name,

latency-> job_title

latency-> FROM speakers

latency-> WHERE id IN (

latency-> SELECT ss.speaker_id

latency-> FROM session_speakers AS ss

latency-> JOIN sessions AS s ON s.id = ss.session_id

latency-> JOIN editions AS e ON e.id = s.edition_id

latency-> WHERE e.year = 2027

latency-> AND e.programme_status <> 'not_announced'

latency-> AND s.kind = 'session'

latency-> AND s.status <> 'cancelled'

latency-> )

latency-> ORDER BY name;

name | job_title

------+-----------

(0 rows)