# Sat Jul 19 12:19:49 2008
# Query_time: 2  Lock_time: 0  Rows_sent: 13  Rows_examined: 292
use theclari_clarionReport;
SELECT DISTINCT DAYOFMONTH(post_date)
		FROM wp_posts WHERE MONTH(post_date) = '07'
		AND YEAR(post_date) = '2008'
		AND post_type = 'post' AND post_status = 'publish'
		AND post_date < '2008-07-19 11:19:47'