SELECT>>'en_US' as pet FROM pets p INNER JOIN pet_abilities pa ON pa.pet_id = INNER JOIN battle_pet_abilities bpa ON = pa.ability_id WHERE>>'en_US' = 'Black Claw' OR>>'en_US' = 'Primal Cry' GROUP BY HAVING COUNT( = 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:

Known issues

While data is being downloaded from the server there is no loading indicator yet, just wait a few seconds