SELECT,>>'en_US' as name,>>'en_US' as item_class, isc.display_name->>'en_US' as item_subclass, irr.display_string->>'en_US' as reputation_requirement, ia.value as icon FROM public.items i JOIN item_classes ic ON = i.item_class_id JOIN item_subclasses isc ON isc.class_id = i.item_subclass_class_id AND = i.item_subclass_id LEFT JOIN item_reputation_requirements irr ON irr.item_id = INNER JOIN item_media im ON im.item_id = INNER JOIN item_assets ia ON ia.item_media_id = WHERE i.item_class_id = 15 AND i.item_subclass_id = 5 LIMIT 400

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