if you mean the stem hole goes into the bowl from the side, instead of the bottom, thats kind of a bad idea. You'll suck a lot of ash like that.

theres a reason why they make pipes with the hole in the bottom of the bowl instead of on the side

BUT if it did work for you, i don't know what you would search for it

ask the guy you smoked with where he got it