WoW Query

Total queries: -
SELECT t.id, t.name->>'en_US' as name, t.description->>'en_US' as description, t.purchase_price, t.sell_price, t.is_equippable, t.is_stackable, t.level, t.required_level, t.max_count, class.name->>'en_US' as item_class, subclass.display_name->>'en_US' as item_subclass FROM classic.items t JOIN classic.item_classes class ON class.id = t.item_class_id JOIN classic.item_subclasses subclass ON subclass.item_class_id = t.item_class_id AND subclass.subclass_id = t.item_subclass_id WHERE t.description->>'en_US' <> '' 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