look up bulkheads on Bulk Reef Supply, under "pumps & plumbing" here
http://www.bulkreefsupply.com/store/pro ... k-adapters
Those are ABS bulkheads, the most common and what you want. The hole is drilled larger because you have to insert the threaded part through the hole then screw the ring on the outside, so a hole for a 1" bulkhead like this one
http://www.bulkreefsupply.com/store/pro ... -side.html
has dimension "C" (click the picture) of 1.65" or 42mm which is how big you have to drill the hole. You'll notice that "A" is 2.67" because the flange spreads out. This is the part you have to shave about 1/3" off each side to make it fit in between the panes on the inside. You'll have to trim the rubber gasket also.
Make sense?