Thanks Jeanne. After a few hours I finally figured out that MySQL 4.0 doesn't support subqueries so I had to upgrade to 4.1. Anyway, here is the current SQL:
This is getting close. Only now it is returning 55 rows. And currently there are only 13.
Ok, turns out that is was because of my data. Since system had duplicates it was able to pull out more copies of the same record. The live data won't have duplicates so I think I will be ok. Thanks.