Change Nodes Templates

select * from cmsDocument where nodeid in (select id from umbracoNode where parentId = 1207) and  newest = 1

update cmsDocument set templateid = 8663 where nodeid in (select id from umbracoNode where parentId = 1207 ) and  newest = 1