SELECT p.id, p.name->>'en_US' as pet, bpa.id as "ability_id" FROM pets p INNER JOIN pet_abilities pa ON pa.pet_id = p.id INNER JOIN battle_pet_abilities bpa ON bpa.id = pa.ability_id WHERE bpa.name->>'en_US' IN ('Sniff Out', 'Scratch', 'Feed', 'Tentacle Stab', 'Forboding Curse', 'Dark Rebirth')

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