I can push it to the live server, but it will take a while (Trying to entertain company and work. lol). In the mean time a better explanation is:
The 7_room.room_id column contains records 1-10, 33, 34
Query1 returns room_id 1, 2, 33
Query2 should return room_id's 3-10, 34 (because they are NOT IN Query1)
Instead Query 2 is giving me room_id's 2-10, 33, 34. I'm 99.9% certain the data is correct, and I know what Query 1 is giving me because I left the static value of 5 instead of the variable after the test, and I still got the same result.
I also attached screenshots of the two tables. 7_room has then entire table in the screenshot, and bridge_event_room is sorted by event_id, so all of the pertinent data is in the screenshot.