-- ========================================================================= -- WARNING: Due to some personal issues I'm discontinuing wow-query.dev -- This website will be taken down september 30 -- All personal data will be erased and a snapshot of the current API data -- will be published on a git repository. -- ========================================================================= SELECT i.id, i.name->>'en_US' as name, 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 public.items i JOIN public.item_classes ic ON ic.id = i.item_class_id JOIN public.item_subclasses sub ON sub.id = i.item_subclass_id AND sub.class_id = i.item_class_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: 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