# Mon Jan  7 16:16:06 2008
# Query_time: 1  Lock_time: 0  Rows_sent: 1  Rows_examined: 0
use theclari_clarionReport;
SELECT email_addr FROM wp_email_list WHERE gets_mail = 1

# Mon Jan  7 16:33:40 2008
# Query_time: 1  Lock_time: 0  Rows_sent: 1  Rows_examined: 2
use theclari_clarionReport;
SELECT   wp_posts.* FROM wp_posts  WHERE 1=1  AND YEAR(post_date)='2008' AND MONTH(post_date)='1' AND DAYOFMONTH(post_date)='7' AND post_name = 'the-week-in-review-january-07-2008-what-to-watch-for' AND (post_type = 'post')  ORDER BY post_date DESC

# Mon Jan  7 16:33:41 2008
# Query_time: 1  Lock_time: 0  Rows_sent: 4  Rows_examined: 142
SELECT post_title, DAYOFMONTH(post_date) as dom FROM wp_posts WHERE YEAR(post_date) = '2008' AND MONTH(post_date) = '01' AND post_date < '2008-01-07 16:33:40' AND post_type = 'post' AND post_status = 'publish'