# Wed Jun  4 20:15:45 2008
# Query_time: 6  Lock_time: 0  Rows_sent: 2  Rows_examined: 247
use theclari_clarionReport;
SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  WHERE 1=1  AND YEAR(post_date)='2007' AND MONTH(post_date)='7' AND DAYOFMONTH(post_date)='12' AND (post_type = 'post' AND (post_status = 'publish'))  ORDER BY post_date DESC LIMIT 0, 10