WordPress Posts, Postmeta, Posts 2 Posts Queries

wordpress.php

/*
 * Get the events for each person
 */

$events = new WP_Query(
  array (
        'post_type' => 'event',
        'connected_type' => 'speaker_to_event',
        'connected_items' => $speaker->ID,
    )
);

/*
 * Get the speakers (a type of person) for each event
 */

$event_speakers = new WP_Query(
array (
        'post_type' => 'person',
        'connected_type' => 'speaker_to_event',
        'connected_items' => $event->ID,
    )
);

/*
 * Takes an input array of events and attaches all of the speakers connected to each one
 */
		p2p_type( 'speaker_to_event' )->each_connected( 
			$events_list, array(), 'person' );

wpdb.sql

-- Select posts by postmeta, with Advanced Custom Fields(ACF) metadata
-- In this scenario a use ha