Magento catalogrule ID (rule_product_id ) to SKU (product ID)

Question

I search a way to get the product ID (SKU) from a rule_product_id. The rule_product_id is the ID to a product in the catalogrule tables like: catalogrule_product

Answer 1

You could simply do a SQL-JOIN on the product entity table.