Consultando os Alertas de Produtos em Estoque do Magento

SELECT
pn.value AS produto, CONCAT(n.value, ' ', s.value) AS cliente, e.email, DATE_FORMAT(p.add_date, '%d/%m/%Y') AS solicitacao
FROM
product_alert_stock AS p
LEFT JOIN
customer_address_entity_varchar AS n ON (n.entity_id = p.customer_id AND n.attribute_id = 20)
LEFT JOIN
customer_address_entity_varchar AS s ON (s.entity_id = p.customer_id AND s.attribute_id = 22)
LEFT JOIN
customer_entity AS e ON (e.entity_id = p.customer_id)
LEFT JOIN
catalog_product_entity_varchar AS pn ON (pn.entity_id = p.product_id AND pn.attribute_id = 65)