SQL in PHP

gistfile1.php

<?php

/**
 * Get the table data
 *
 * @return Array
 */
private function table_data() {
	global $wpdb;

	$sql = <<<SQL
		SELECT     wp_posts.ID,
			   m1.meta_value AS email,
			   wp_posts.post_date_gmt AS date
		FROM       wp_posts
		INNER JOIN wp_postmeta m1 ON ( wp_posts.ID = m1.post_id )
		WHERE      wp_posts.post_type   = 'subscriber'
		AND        wp_posts.post_status = 'publish'
		AND        m1.meta_key          = 'eec_email'
		GROUP BY   wp_posts.ID
SQL;

	$sql = str_replace( 'wp_', $wpdb->prefix, $sql );

	$results = $wpdb->get_results( $sql, ARRAY_A );

	return $results;
}