# User@Host: chris_habari[chris_habari] @ localhost [] # Query_time: 0 Lock_time: 0 Rows_sent: 2 Rows_examined: 618 SELECT DISTINCT habari__posts.id AS id, habari__posts.slug AS slug, habari__posts.title AS title, habari__posts.guid AS guid, habari__posts.content AS content, habari__posts.cached_content AS cached_content, habari__posts.user_id AS user_id, habari__posts.status AS status, habari__posts.pubdate AS pubdate, habari__posts.updated AS updated, habari__posts.modified AS modified, habari__posts.content_type AS content_type FROM habari__posts WHERE pubdate >= '1173879207' AND content_type = 1 AND status = 2 ORDER BY pubdate ASC LIMIT 2;