The pipe is made of two parts. You need to order both and mount it by yourself!
I would suggest e.g. Sugru (sugru.com) for the sealing.
Cause the pipe is made of glazed ceramic, there is the possibility that some of the glaze stuck the openings. In case of this, you need to grind or even drill this parts to clear it.
Please order the pipe only if you think you can handle this!