SELECT b.*, bt.blog_tag FROM blog AS b LEFT OUTER JOIN blog_tags AS bt ON bt.blog_tag_id = b.blog_tag_id AND bt.languages_id = 4 WHERE blog_id = 0 AND languages_id = 4 LIMIT 1