I want to get all simple products and in addition, I want to get an attribute called
title_name for those products. The attribute_id (from
eav_attribute) of the attribute is 450.
This is what I got so far:
SELECT * FROM catalog_product_entity WHERE type_id = 'simple';
Now I need the join with the attribute and this is where I am struggling. How can I do that?