WITH first_hop AS (
  SELECT ae.object_id AS affected_id, ae.event_date
  FROM article_events ae
  WHERE ae.subject_id = (SELECT id FROM companies WHERE name = 'ASML')
    AND ae.event_type IN ('supply_cut', 'export_restriction', 'production_delay')
)
SELECT DISTINCT c.name, ae2.event_type, ae2.event_date
FROM first_hop fh
JOIN article_events ae2 ON ae2.subject_id = fh.affected_id
JOIN companies c ON c.id = ae2.object_id
WHERE ae2.event_date >= fh.event_date
ORDER BY ae2.event_date;