You're missing something. Nowhere in scripture does it say that the second resurrection is only the wicked. Therefore, it can (and does) include both the wicked and the righteous.
At the same time it doesn't describe anyone who is righteous being judged there. Since we know the dead in Christ rise first, and that does not include any of the unsaved we know that all the righteous are resurrected in the first resurrection which proves the second resurrection is only for the wicked. No surprise there since those unsaved people come from places like death and hell to be judged. Also, the only result of that day of judgment is punishment of the LOF. No one is shown being rewarded. We only see punishment there.
Remember that in all related passages, we see the righteous resurrected and judged first, followed later by the unrighteous. Never is there a resurrection and judgment where the righteous and unrighteous are judged and resurrected at the same time.
You can see this for yourself:
Revelation 20 speaks of two groups of the dead that resurrect/live again.
Rev 20:4 And I saw thrones, and they sat upon them, and judgment was given unto them: and I saw the souls of them that were beheaded for the witness of Jesus, and for the word of God, and which had not worshipped the beast, neither his image, neither had received his mark upon their foreheads, or in their hands;
and they lived and reigned with Christ a thousand years.
Rev 20:5 But
the rest of the dead lived not again until the thousand years were finished. This is the first resurrection.
Rev 20:6 Blessed and holy is he that hath part in the first resurrection: on such the second death hath no power, but they shall be priests of God and of Christ, and shall reign with him a thousand years.
The first resurrection is the resurrection of this first group of the dead because they resurrect first.
The rest of the dead have to wait for their resurrection:
"
the rest of the dead lived not again until the thousand years were finished" (Rev 20:5)
This is the
last resurrection of those who are dead. One group resurrected and "the rest" or the
remaining ones did not resurrect when the others did.
This proves they partake of the second resurrection also known as the last resurrection because no one is still physically dead after they "live again". This also proves without a doubt that there are two separate days of resurrection separated by a thousand years and how long that actually is doesn't matter.
Part of the dead resurrect and then "the rest of the dead" will resurrect after a period of time.
That's the dead resurrecting in two parts separated by a period of time.
The first group resurrects
before the thousand years begins and the second/last group resurrects
after the end of the thousand years.
Dan 12:2 And many of them that sleep in the dust of the earth shall awake,
some to everlasting life, and
some to shame and everlasting contempt.
First group resurrection: "to everlasting life"
Second group resurrection: "to shame and everlasting contempt"
Joh 5:29 And shall come forth; they that have done good,
unto the resurrection of life; and they that have done evil,
unto the resurrection of damnation.
First group resurrection: "resurrection of life"
Second group resurrection: "the resurrection of damnation"
What we learn from both verses is that there are two resurrections. One resurrection is to life and the other resurrection is to damnation and contempt. Two resurrections! Never is there a single resurrection of both righteous and unrighteous at the same time.