SELECT p.id as profession_id, p.name->>'en_US' as profession, pt.id as tier_id, pt.name->>'en_US' as tier, count(1) as recipe_count FROM professions p JOIN profession_tiers pt ON pt.profession_id = p.id JOIN profession_tier_recipes ptr ON ptr.profession_tier_id = pt.id GROUP BY p.id, pt.id ORDER BY p.id, pt.id

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