SELECT
        u.user_nicename,
        p.post_content AS content,
        p.post_title AS title,
        p.guid AS url
    FROM
        wp_posts p
    JOIN wp_users u ON(u.ID = p.post_author)
    WHERE
        p.post_status != 'trash'
    AND
        p.post_type = 'post'
    ORDER BY p.ID DESC
    LIMIT 10