# Sun Jul 27 02:20:55 2008
# Query_time: 2  Lock_time: 0  Rows_sent: 3  Rows_examined: 294
use theclari_clarionReport;
SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  LEFT JOIN wp_post2cat ON (wp_posts.ID = wp_post2cat.post_id) LEFT JOIN wp_categories ON (wp_post2cat.category_id = wp_categories.cat_ID)  WHERE 1=1  AND category_id IN (1) AND (post_type = 'post' AND (post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 10

# Sun Jul 27 02:33:56 2008
# Query_time: 2  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)='5' AND DAYOFMONTH(post_date)='13' AND post_name = 'how-far-will-your-salary-go-in-a-different-city' AND (post_type = 'post')  ORDER BY post_date DESC