WoW Query

Total queries: -
SELECT bp.name->>'en_US' as pet FROM battle_pets bp INNER JOIN battle_pet_abilities bpa ON bpa.battle_pet_id = bp.id INNER JOIN pet_abilities pa ON pa.id = bpa.ability_id WHERE pa.name->>'en_US' = 'Black Claw' OR pa.name->>'en_US' = 'Primal Cry' GROUP BY bp.id HAVING COUNT(bp.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