WITH cte_attributes AS(
    SELECT
    product_attribute_type.id,
    product_attribute_type.product_sku,
    product_attribute_type.name,
    product_attribute_value.value
    FROM product_attribute_type
    INNER JOIN product_attribute_value ON product_attribute_value.attr_type = product_attribute_type.id
)
SELECT
    product.sku,
    product.name,
    product_category.name AS category,
    cte_attribute.name,
    cte_attribute.value,
    base_price
FROM product
INNER JOIN cte_attributes ON cte_attributes.product_sku = product.sku
INNER JOIN product_price ON product_price.product_sku = product.sku
INNER JOIN product_category ON product_category.id = product.product_category;