We have complex products (of type "simple product") with associations between them. Most of our products therefore have accessories associated, which are displayed on the product detail page.
However, our accessories still are valid, viewable products on their own, meaning that one can find them using the search function. It would be beneficial for customers to see the products that the product they are currently viewing is associated from.
The products "A", "B" and "C" have the product "Z" as a product association. "Z" is displayed on each of their product detail pages.
So the question is:
Is there any way of finding a simple product to simple product association from "Z" to "A", "B" and "C", without loading all products and checking
$product->getAssociatedProducts() manually for the ID of "Z"?