-- fill in recommendation cache

select n.id, __nodeLink_UpdateRecommendCacheAll(n.id, null) 
from nodeT n
join allowedNodeLinkT anl on n.nodeTypeId = anl.srcNodeTypeId
where anl.singleSrc = 'n'
group by n.id;

select n.id, __nodeLink_UpdateRecommendCacheAll(null, n.id) 
from nodeT n
join allowedNodeLinkT anl on n.nodeTypeId = anl.dstNodeTypeId
where anl.singleSrc = 'n'
group by n.id;