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 classic.items i JOIN classic.item_classes ic ON = i.item_class_id JOIN classic.item_subclasses sub ON sub.class_id = i.item_class_id AND = i.item_subclass_id 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