gistfile1.sql

SELECT agencies.name
FROM agencies
  INNER JOIN manifests ON manifests.agency_id = agencies.id
  INNER JOIN plans ON plans.manifest_id = manifests.id
  INNER JOIN plan_rows ON plan_rows.plan_id = plans.id
  INNER JOIN placements ON placements.plan_row_id = plan_rows.id
  INNER JOIN ordered_placements ON placements.ordered_placement_id = ordered_placements.id
WHERE ordered_placement_id = 87952
  AND plans.id = MAX(plans.id);