According to Jesus, fleshly Israel was "abandoned" as serial covenant breakers. (Matthew 23:37-39) As soon as God had sent his Christ into the world to rescue obedient mankind, his part of the covenant was fulfilled. As those who relentlessly ignored God's counsel and his laws, even becoming complicit in Jesus' murder, he said.....
"Look! Your house is abandoned to you. 39 For I say to you, you will by no means see me from now until you say, ‘Blessed is the one who comes in Jehovah’s name!’”
For almost 2,000 years, the Jews have never acknowledged Jesus as the one who came in the name of his Father.....they even refused to utter his name. Only those Jews who accepted Christ and are chosen by God for positions in the Kingdom, will see life in heaven. The majority of the elect are Gentiles for that reason.....these are called
"the Israel of God" (Galatians 6:16) which include Jewish and Gentile disciples of Jesus.....so natural Israel no longer figures in God's purpose. They lost their place because of their constant disobedience and were replaced by a new spiritual nation....
"a people for his name". (Acts 15:14) This is the subject of Jesus' parable of the rich man and Lazarus. All of the first Christians were Jews....every book of the Bible was written by Jews. But as a fleshly nation, they committed spiritual suicide and were replaced in God's affections by those who were humble and accepted the truth Jesus taught, "like young children".. Isn't it obvious? Read all of Matthew 23.
Since Paul says that those who "sleep" will all be raised at Christ's return, the "first resurrection" takes place at that time. Those alive at that time, will still be part of the "first resurrection" because no one was raised before then, according to Paul. No spirits or souls went to heaven.
Since Jesus will raise both the "righteous" and the "unrighteous" at the same time and from the same place.....this is the second or general resurrection of the dead. They are called from their graves because they are all still in them. The grave is simply the place where all the dead "sleep". God does not require a single molecule of any person in order to bring them back to life. Revelation 20 speaks of 'the sea giving up its dead'. So the sea is also a grave, like hades and Sheol.
The righteous do not have to prove their loyalty to God since they died faithful, but the unrighteous who died without knowledge of God or his Christ, will have opportunity to learn and to comply with his laws during Christ's millennial reign.
Jesus' sacrifice covers their sins too because they were committed in ignorance. Any who die alienated from God at the time of the tribulation will not see life again. Their death will be permanent. This "time of the end" is a judgment period.....a time for life and death decisions, like the days of Noah. (Matthew 24:37-39)
The 'dead' judged before 'the great white throne' are the unrighteous who were raised to a "resurrection of judgment". This is where they pass their test to continue living....or not.
So, I still see just two resurrections.....and a very uncomplicated story of redemption. What God purposed in the beginning, he delivers to mankind at the end, solving the problems associated with abuse of free will in the process. All will go back to square one. (Isaiah 55:11)