Hi,
I want to get additional data to product-list.tpl, but this data is in another table (table structure is product_id, data). I need to join this table to product list sql, but I dont know where to find it. Tried to join this table in Category.php / getProducts(), but still I can't get this new data.
So my main question is where to join this new table to be able to get new data in product-list.tpl?