private Sql <ISqlContext> SqlContentSourcesSelectUmbracoNodeJoin(ISqlContext sqlContext) { ISqlSyntaxProvider syntax = sqlContext.SqlSyntax; SqlTemplate sqlTemplate = sqlContext.Templates.Get( Constants.SqlTemplates.NuCacheDatabaseDataSource.SourcesSelectUmbracoNodeJoin, builder => builder.InnerJoin <NodeDto>("x") .On <NodeDto, NodeDto>( (left, right) => left.NodeId == right.NodeId || SqlText <bool>(left.Path, right.Path, (lp, rp) => $"({lp} LIKE {syntax.GetConcat(rp, "',%'")})"), aliasRight: "x")); Sql <ISqlContext> sql = sqlTemplate.Sql(); return(sql); }