SELECT * FROM blogs JOIN posts ON posts.title=CONCAT(blogs.title, '-suffix')