# Thu Sep  4 21:48:14 2008
# Query_time: 2  Lock_time: 0  Rows_sent: 10  Rows_examined: 1188
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 (6) AND (post_type = 'post' AND (post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 10