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


For details on how to query jsonb fields see:

Known issues
