Query Alarm Journal in SQL

Ignition
,
3

Ok thank you for this.
I now have the following query returning data in a better format. However, where can I find the full list of eventtype IDs, eventflags, priority values?

SELECT 
    ae.*,
    MAX(CASE WHEN aed.propname = 'alarmAreas' THEN aed.strvalue END) AS alarmAreas,
    MAX(CASE WHEN aed.propname = 'label' THEN aed.strvalue END) AS label,
    MAX(CASE WHEN aed.propname = 'eventValue' THEN CAST(aed.intvalue AS TEXT) END) AS eventValue,
    MAX(CASE WHEN aed.propname = 'priority' THEN CAST(aed.intvalue AS TEXT) END) AS priority, 
	MAX(CASE WHEN aed.propname = 'ackUser' THEN aed.strvalue END) AS ackUser
FROM 
    public.alarm_events ae
LEFT JOIN 
    public.alarm_event_data aed
ON 
    ae.eventtype = aed.id
GROUP BY 
    ae.id, ae.eventid, ae.source, ae.displaypath, ae.priority, ae.eventtype, ae.eventflags, ae.eventtime;