I've been going through the Red Room, moving what threads I see back to their original rooms (mainly Green, Techforge, and Media Central) but please keep an eye out for any more "strays". For some reason spaceturkey's Blue Room thread was in the Red Room. Fortunately, it looks like his was the only BR thread to get jumbled there.
To fix the problem, I took the node id (forum number) from our last backup of 02/21/16 and overwrite the threads with the node id they had from that day. This means that anything created after that date didn't have a node id in that database backup (like Space turkeys thread) and so wasn't updated, staying in the Red Room.
Shelter release forum is missing all but the first thread I moved there. One got dumped back in here, no idea where the others ended up.
They're in the Red Room. All threads created between 2/22/16 and a couple days ago that haven't been moved back are in the Red Room.