SELECT p.name, c.code, c.description
FROM patients p
JOIN encounters e ON e.patient_id = p.id
JOIN conditions c ON c.encounter_id = e.id
WHERE c.system = 'ICD-10'
AND e.date >= '2025-01-01'
LIMIT 25;

MATCH (p:Patient)-[:HAS_ENCOUNTER]->(e)
      -[:DIAGNOSED_WITH]->(c:Condition)
WHERE c.system = 'ICD-10'
  AND e.date >= '2025-01-01'
RETURN p.name, c.code, c.description
LIMIT 25