SELECT ji.name->>'en_US' as "Instance name", je.name->>'en_US' as "Encounter name", i.id as "Item id", i.name->>'en_US' as "Item name" FROM journal_instances ji INNER JOIN journal_encounters je ON je.instance_id = ji.id INNER JOIN journal_encounter_items jei ON jei.encounter_id = je.id INNER JOIN classic.items i ON i.id = jei.item_id WHERE ji.expansion_id = 68 ORDER BY i.id

All available tables are listed on the left column, more tables will be added soon

For details on how to query jsonb fields see: https://www.postgresql.org/docs/9.5/functions-json.html

Known issues

While data is being downloaded from the server there is no loading indicator yet, just wait a few seconds