Is there a way I can get a connected post without haven't to query it?
For example I have a connection between resorts and accommodation so if I am on the accommodation page I want to display a link to the resort page, I know I could use the WP_Query but wondered if I could use something a bit more simpler?
global $wpdb;
$ids = $wpdb->get_col( "SELECT <code>to</code> FROM $wpdb->mb_relationships WHERE <code>from</code> = 123 AND <code>type</code> = 'your_relationship' ");
PS: I think WP_Query is fine if you set 'fields' => 'ids'.