Untitled

INSERT INTO term_node values (
    SELECT i.nid,i.vid,term_node.tid FROM term_node
    JOIN node_revisions       AS nr  ON nr.vid = term_node.vid
    JOIN term_data            AS td  ON td.tid = term_node.tid
    JOIN content_type_product AS ctp ON ctp.vid = nr.vid
    JOIN node                 AS i   ON i.nid = ctp.field_product_imageref_nid
);
-- AFTER
INSERT INTO term_node values (
    SELECT nri.nid,i.vid,term_node.tid FROM term_node
    JOIN node_revisions       AS nr  ON nr.vid = term_node.vid
    JOIN term_data            AS td  ON td.tid = term_node.tid
    JOIN content_type_product AS ctp ON ctp.vid = nr.vid
    JOIN node                 AS i   ON i.vid = ctp.field_product_imageref_nid
    JOIN node_revisions       AS nri ON nri.vid = i.vid
);