# Sun Jan  6 16:17:07 2008
# Query_time: 1  Lock_time: 0  Rows_sent: 3  Rows_examined: 141
use theclari_clarionReport;
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-06 16:17:06' AND post_type = 'post' AND post_status = 'publish'

# Sun Jan  6 16:17:07 2008
# Query_time: 1  Lock_time: 0  Rows_sent: 3  Rows_examined: 141
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-06 16:17:06' AND post_type = 'post' AND post_status = 'publish'

# Sun Jan  6 16:17:07 2008
# Query_time: 1  Lock_time: 0  Rows_sent: 3  Rows_examined: 141
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-06 16:17:06' AND post_type = 'post' AND post_status = 'publish'