TPC-DS Q41

SELECT DISTINCT
TOP 100
  i_product_name
FROM item AS i1
WHERE
  i_manufact_id BETWEEN 697 AND 697 + 40
  AND (
    SELECT
      COUNT(*) AS item_cnt
    FROM item
    WHERE
      (
        i_manufact = i1.i_manufact
        AND (
          (
            i_category = 'Women'
            AND (
              i_color = 'bisque' OR i_color = 'peach'
            )
            AND (
              i_units = 'Pound' OR i_units = 'Each'
            )
            AND (
              i_size = 'medium' OR i_size = 'small'
            )
          )
          OR (
            i_category = 'Women'
            AND (
              i_color = 'green' OR i_color = 'white'
            )
            AND (
              i_units = 'Carton' OR i_units = 'Oz'
            )
            AND (
              i_size = 'petite' OR i_size = 'N/A'
            )
          )
          OR (
            i_category = 'Men'
            AND (
              i_color = 'light' OR i_color = 'tomato'
            )
            AND (
              i_units = 'Case' OR i_units = 'Tsp'
            )
            AND (
              i_size = 'economy' OR i_size = 'large'
            )
          )
          OR (
            i_category = 'Men'
            AND (
              i_color = 'floral' OR i_color = 'black'
            )
            AND (
              i_units = 'Dram' OR i_units = 'Dozen'
            )
            AND (
              i_size = 'medium' OR i_size = 'small'
            )
          )
        )
      )
      OR (
        i_manufact = i1.i_manufact
        AND (
          (
            i_category = 'Women'
            AND (
              i_color = 'khaki' OR i_color = 'papaya'
            )
            AND (
              i_units = 'Cup' OR i_units = 'Ounce'
            )
            AND (
              i_size = 'medium' OR i_size = 'small'
            )
          )
          OR (
            i_category = 'Women'
            AND (
              i_color = 'goldenrod' OR i_color = 'firebrick'
            )
            AND (
              i_units = 'Ton' OR i_units = 'Gross'
            )
            AND (
              i_size = 'petite' OR i_size = 'N/A'
            )
          )
          OR (
            i_category = 'Men'
            AND (
              i_color = 'peru' OR i_color = 'almond'
            )
            AND (
              i_units = 'Gram' OR i_units = 'N/A'
            )
            AND (
              i_size = 'economy' OR i_size = 'large'
            )
          )
          OR (
            i_category = 'Men'
            AND (
              i_color = 'thistle' OR i_color = 'mint'
            )
            AND (
              i_units = 'Bundle' OR i_units = 'Bunch'
            )
            AND (
              i_size = 'medium' OR i_size = 'small'
            )
          )
        )
      )
  ) > 0
ORDER BY
  i_product_name;