Magento 1 – EAV – pobieranie ceny za pomocą mysql

SELECT 
    cped.value
FROM
    eav_entity_type eet
        JOIN
    eav_attribute ea ON eet.entity_type_id = ea.entity_type_id
        AND ea.attribute_code = 'price'
        AND eet.entity_type_code = 'catalog_product'
        JOIN
    catalog_product_entity_decimal cped ON ea.attribute_id = cped.attribute_id
WHERE
    cped.entity_id = 167