Question on SQL

Would reaaaaally a appreciate small direction on this. ?? Amazing plugin, outstanding work!

So I’ve created the “Players” pod that has a new “players” table in the mysql and that has a relationship field called player_select, which pulls the custom posts from wpcm_player post type. I created these bi-relational fields on both sides (on wpcm_player post type and on player_select).

My tasks is: I have to create simple Select/From mysql query, that shows the relationship between players pod and wpcm_player post type. Basically to create list of all the fields that are connected to particular wpcm_player ID.
How would I achieve this?

Best,

Marko