SELECT * FROM posts p Inner Join Authors a ON p.author_id = a.id WHERE p.slug_english='this-is-the-sample-post-and-sample-heading-2' LIMIT 1;