SELECT,>>'en_US' as name, i.purchase_price, i.sell_price, i.is_equippable, i.is_stackable, i.level, i.required_level, i.max_count,>>'en_US' as item_class, sub.display_name->>'en_US' as item_subclass FROM items i JOIN item_classes ic ON = i.item_class_id JOIN public.item_subclasses sub ON = i.item_subclass_id AND sub.class_id = i.item_class_id JOIN item_metadata im ON im.item_id = WHERE im.is_reagent = true 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:

Known issues

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