Using SharePoint 2013 Enterprise for a Publishing site.
This blog post on cross-site publishing contains the following screenshot:
It's a Product details page that contains related content such as "Customer reviews". I assume the customer reviews are stored in a separate list given the one-to-many relationship with products.
As far as I'm aware the Content Search Web Part can't perform "joins", so how would this page pull in related content? and how would the page be displayed in search results based on the related content e.g.
A user searches for a term that is not contained within the product itself, but is contained within a customer review about the product.