New posts in Scalar Subquery

PostgreSQL 9.2 row_to_json() with nested joins