SELECT p.name->>'en_US' as pet 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' = 'Black Claw' OR bpa.name->>'en_US' = 'Primal Cry' GROUP BY p.id HAVING COUNT(p.id) = 2

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