select p.identifier as pokemon, vg.identifier as version_group, tmp.* from (select pokemon_id, version_group_id, level, array_agg("order" order by "order") as "order" from pokemon_moves where level != 0 group by pokemon_id, version_group_id, level having count(*) != 1 and not every("order" is not null)) as tmp join pokemon p on tmp.pokemon_id = p.id join version_groups vg on tmp.version_group_id = vg.id order by version_group_id, pokemon_id, level;