SELECT workflow.company_review_block.block_type_id,
       workflow.company_review_score.block_id,
       workflow.company_review_score.score_type_id,
       workflow.company_review_score.score
FROM   workflow.workflow_note
       JOIN workflow.company_review
         ON workflow.workflow_note.id = workflow.company_review.id
       JOIN workflow.company_review_block
         ON workflow.company_review.id =
            workflow.company_review_block.company_review_id
       JOIN workflow.company_review_score
         ON workflow.company_review_block.id =
            workflow.company_review_score.block_id
       JOIN (SELECT workflow.company_review_block.block_type_id AS block_type_id
                    ,
workflow.company_review_score.score_type_id AS score_type_id,
MAX(workflow.company_review.date_closed)    AS max_date
FROM   workflow.workflow_note
JOIN workflow.company_review
  ON workflow.workflow_note.id = workflow.company_review.id
JOIN workflow.company_review_block
  ON workflow.company_review.id =
     workflow.company_review_block.company_review_id
JOIN workflow.company_review_score
  ON workflow.company_review_block.id =
     workflow.company_review_score.block_id
GROUP  BY workflow.company_review_block.block_type_id,
   workflow.company_review_score.score_type_id) AS anon_1
ON anon_1.block_type_id = workflow.company_review_block.block_type_id
AND anon_1.score_type_id = workflow.company_review_score.score_type_id
AND anon_1.max_date = workflow.company_review.date_closed
WHERE  workflow.workflow_note.target_entity_id = 2