XLR PIN-2 goes to the center contact of the RCA, this carries the signal. XLR PINs-1 and 3 are tied together and carry the Ground via the Chassis. This connects to the Surround of the RCA.
Hosa cables are known for their reliability and can be found in recording studios around the world
Their line is very extensive and covers any recording need from digital cables to multipin snakes