Dos sentencias SELECT para obtener la relación entre reglas y productos en Magento

select-relaciones-entre-rules-products.sql

SELECT
  2,
  `cg`.`customer_group_id`,
  `p`.`entity_id`,
  189796,
  1484006400,
  1514764799,
  'by_percent',
  50,
  0,
  1,
  '',
  0
FROM `catalog_product_entity` AS `p`
  INNER JOIN `catalog_product_flat_2` AS `cpf` ON cpf.entity_id = p.entity_id
  LEFT JOIN `catalog_category_product` AS `ccp` ON ccp.product_id = p.entity_id
  LEFT JOIN `customer_group` AS `cg` ON cg.customer_group_id IN ('0', '1')
WHERE ((`cpf`.`sku` IN ('36672201', '36672202', '36672203', '36672204', '36672205', '36672206', '36672200'))) AND
      (`p`.`entity_id` >= '32572') AND (`p`.`entity_id` < 1032572);

SELECT
  2,
  `cg`.`customer_group_id`,
  `p`.`entity_id`,
  201459,
  1499126400,
  1501372799,
  'by_percent',
  20,
  0,
  0,
  'by_percent',
  20
FROM `catalog_product_entity` AS `p`
  INNER JOIN `catalog_product_flat_2` AS `cpf` ON cpf.entity_id = p.entity_id
  LEFT JOIN `catalog_category_product` AS `ccp` ON ccp.product_id = p.entity_id
  LEFT JOIN `customer_group` AS `cg` ON cg.customer_group_id IN ('0', '1')
WHERE ((`ccp`.`category_id` IN ('2', '15066', '15068', '15069'))) AND (`p`.`entity_id` >= '32572') AND
      (`p`.`entity_id` < 1032572)