SELECT i.id, i.name->>'en_US' as name, i.name_description->>'en_US' as name_description, i.description->>'en_US' as description, i.purchase_price, i.sell_price, i.is_equippable, i.is_stackable, i.level, i.required_level, i.max_count, ic.name->>'en_US' as item_class, sub.display_name->>'en_US' as item_subclass FROM items i JOIN item_classes ic ON ic.id = i.item_class_id JOIN item_subclasses sub ON sub.id = i.item_subclass_id AND sub.class_id = i.item_class_id JOIN item_metadata im ON im.item_id = i.id WHERE im.has_duration IS NULL AND i.binding_id IN ('ON_USE', 'ON_EQUIP') LIMIT 100

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