WoW Query

Total queries: -
SELECT,>>'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,>>'en_US' as item_class, subclass.display_name->>'en_US' as item_subclass FROM public.items t JOIN public.item_classes class ON = t.item_class_id JOIN public.item_subclasses subclass ON subclass.item_class_id = t.item_class_id AND subclass.subclass_id = t.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