# Thu Nov 20 13:30:11 2008
# Query_time: 2  Lock_time: 0  Rows_sent: 20  Rows_examined: 365
use theclari_clarionReport;
SELECT post_title, DAYOFMONTH(post_date) as dom FROM wp_posts WHERE YEAR(post_date) = '2007' AND MONTH(post_date) = '11' AND post_date < '2008-11-20 13:30:09' AND post_type = 'post' AND post_status = 'publish'

# Thu Nov 20 13:47:41 2008
# Query_time: 4  Lock_time: 0  Rows_sent: 1  Rows_examined: 365
use theclari_clarionReport;
SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  WHERE 1=1  AND YEAR(post_date)='2008' AND MONTH(post_date)='8' AND DAYOFMONTH(post_date)='7' AND (post_type = 'post' AND (post_status = 'publish'))  ORDER BY post_date DESC LIMIT 0, 10