INSERT INTO  modx_site_tmplvar_contentvalues (contentid, value, tmplvarid)

SELECT c2.id, v.value, v.tmplvarid  FROM modx_site_tmplvar_contentvalues v

JOIN modx_site_content c

JOIN modx_site_content c2

ON c.longtitle LIKE '%reducer%' AND c.parent = 564 AND v.contentid = c.id AND c2.parent = (2252, 2252) AND c2.longtitle LIKE '%reducer%'