more efficient query for competition phase migration
merged