SELECT b.id, b.name, ( t.id ) AS tag_id, ( t.name ) AS tag_name FROM blog_entry b INNER JOIN blog_entry_tag_jn btjn (NOLOCK) ON b.id = btjn.blog_entry_id INNER JOIN tag t (NOLOCK) ON btjn.tag_id = t.id