SELECT i.id, i.name->>'en_US' as name, ic.name->>'en_US' as item_class, isc.display_name->>'en_US' as item_subclass, irr.display_string->>'en_US' as reputation_requirement FROM public.items i JOIN item_classes ic ON ic.id = i.item_class_id JOIN item_subclasses isc ON isc.class_id = i.item_subclass_class_id AND isc.id = i.item_subclass_id LEFT JOIN item_reputation_requirements irr ON irr.item_id = i.id WHERE i.item_class_id = 15 AND i.item_subclass_id = 5 LIMIT 400

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