You may realize that the number of SQL records returned in the query tool is limited to a few thousand rows. This can be changed, however!
1. Select Tools | Configure | System Settings from the top level menu.
2. Go to the Display Tab.
3. Change the number of maximum sql query records to whatever amount you want. But use care: larger numbers will increase your GoldMine startup time.
Try it, and have fun!