E-Newsletter SQL Fu

List by Join Date.sql

SELECT member_fname, member_lname, member_email, join_date 
FROM wp_enewsletter_members 
#Specify Range here if needed
WHERE join_date 
BETWEEN  2015-01-30 23:59:59 
AND  2015-02-01 23:59:59 
#Sort Order
ORDER BY wp_enewsletter_members.join_date ASC

Print it.php

 global $wpdb;
     // Use one of the queries shown in this Gist here; 
     $query = " " ;
     $newsletterusers = $wpdb->get_results($query);

      foreach ($newsletterusers as $user) {
            // Do stuff here
            echo "<li>".$user->fname." joined on ".$user->join_date."</li>" ; 
      }

Users who got it.sql

SELECT member_fname, member_lname, sent 
FROM wp_enewsletter_members 
WHERE sent 
# Put Date Range here (You can use PHP and do this programmatically)
BETWEEN  2015-01-30 23:59:59 
AND  2015-02-01 23:59:59
#Sort Order
ORDER BY wp_enewsletter_members.member_fname ASC