仅在1对多连接上查询最新记录

I'm working on a project where I'm pulling users and their latest blog post. The software we have stores a version ID similar to drupal. I'm hitting many errors with the query though. I'm used to writing MySQL queries, and I thought this would work, but Postegres is giving me issues.I'm working on a project where I'm pulling user