10G SFP+ transceiver with OM4 fiber cable – Maximum cable length

I have used a variety of SFP modules (including Ciena, Finisar, Cisco, Fiberstore.com...) in a Zyxel MGS-3712F without any issues.

Comments converted into answer: Please spend a bit of time learning the actual terminology rather than inventing your own, which confuses both you and us. An SFP (small form pluggable) is not a connector. It typically HAS one or more often two female optical connectors as part of itself, but what it IS is an electro-optical transceiver. The 10 Gig ones are not SFPs, they are SFP+ The optical cable does not matter if it's the right family and clean, what you need to is know what the SFP (or SFP+) that you are connecting to at the switch is, and get one compatible with it. Clean, by the way, is a VERY big deal with single mode fiber connections.

And the SFP+ you have shown (without showing the relevant part where the cables plug in) most likely needs a pair of optical cables, not a single cable. If it has two optical connectors, one is transmit, one is receive. Transmit at one end connects to receive on the other. I'd guess that 10GE-LR is intended to be 10GBASE-LR, which is 1310 nm lasers on single-mode fiber up to 10 kilometers, not a bidirectional standard.

https://en.wikipedia.org/wiki/10_Gigabit_Ethernet

The cable test tag on your patch cable showing what its insertion and return losses at various wavelengths were when it shipped from the factory is utterly irrlevant to the choice of the correct SFP+ - which seems to be your question, buried under a lot of mis-used terminology you need to learn if you have anything to do with this equipment.