Обсуждение и советы: создание интернет-магазинов - решения, процессы, прайсинг

Код: Выделить всё

INSERT INTO b_iblock_element_property (iblock_property_id, iblock_element_id, value, value_enum)
    SELECT (SELECT b_iblock_property.id FROM b_iblock_property
      WHERE b_iblock_property.active = 'Y' AND b_iblock_property.code = 'PLI_ID'
      AND b_iblock_property.IBLOCK_ID=12 GROUP BY b_iblock_property.code) as property_id,
    b_iblock_element.id, etrade_products.tov_id as my_value, etrade_products.tov_id as my_value_enum
    FROM b_iblock_element, etrade_products
    WHERE b_iblock_element.xml_id=etrade_products.tov_guid AND b_iblock_element.id NOT IN
      (SELECT iblock_element_id FROM b_iblock_element_property WHERE iblock_property_id IN
         (SELECT b_iblock_property.id FROM b_iblock_property WHERE b_iblock_property.active = 'Y' AND
        b_iblock_property.code = 'PLI_ID' AND b_iblock_property.IBLOCK_ID=12
        GROUP BY b_iblock_property.code));;;