SELECT DISTINCT name, trainername, pokelevel, primary_type, secondary_type from Pokemon.pokemons left join pokemon_trainer ON Pokemon.pokemons.id = pokemon_id left join trainers on pokemon_id where pokelevel = 100 AND secondary_type IS NOT NULL; I am no expert on pokemons, but i have been told that 100 is the highest pokelevel, so i regard that as the strongest pokemon. And any trainer fortunate to have one, i reckon is stronger the more they have.