Код: Выделить всё
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));;;