Hello.

Given the product.template table with a line for each of all the products, and the product.pricelist.item table with, for each pricelist version, for each pricelist, a line for each product in that pricelist version. 

I have to access in the front-end to ALL information of "that" line in the product.pricelist.item which is referring to "that" product (same product_id) in the product.template table.

Imagine other fields like the price surchage that i have to access for each product and display in the front-end.

I currently implemented a ultra-bad, debug only function in the backend which retrieve the whole product.pricelist.item table, and the frontend makes the join to find out these information.

This is (off course) performance killing and insecure and a real mess.

Do anyone of you know a way to make the join in the backend, serverside, and retrive the information in a form accessible in the front-end with something like product.item.myInformation?

thank you