<?xml version="1.0" encoding="utf-16"?>
<ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.0" Build="9.00.5000.00" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
  <BatchSequence>
    <Batch>
      <Statements>
        <StmtSimple StatementCompId="1" StatementEstRows="2.4134" StatementId="8" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" StatementSubTreeCost="0.145901" StatementText="with&#xD;&#xA;_string_value as (--NOT MATERIALIZED(&#xD;&#xA;select av.Object_id as id,	&#xD;&#xA;	   av.Attrib_ID as IdTypeAttr,&#xD;&#xA;       coalesce(sv.value,'')+coalesce(sv.value1,'') as sValue&#xD;&#xA; from  LSDBO.attrib_value as av left join &#xD;&#xA;       LSDBO.value_string as sv on sv.id=av.Value_ID&#xD;&#xA;),&#xD;&#xA;_numeric_value as (--NOT MATERIALIZED(&#xD;&#xA;select av.Object_id as id,	&#xD;&#xA;	   av.Attrib_ID as IdTypeAttr,&#xD;&#xA;       nv.value as nValue &#xD;&#xA; from  LSDBO.attrib_value as av left join &#xD;&#xA;       LSDBO.value_numeric as nv on nv.id=av.Value_id &#xD;&#xA;),&#xD;&#xA;_datetime_value as (--NOT MATERIALIZED(&#xD;&#xA;select av.Object_id as id,	&#xD;&#xA;	   av.Attrib_ID as IdTypeAttr,&#xD;&#xA;       dv.value as dValue &#xD;&#xA; from  LSDBO.attrib_value as av left join &#xD;&#xA;       LSDBO.value_datetime as dv on dv.id=av.Value_ID &#xD;&#xA;)&#xD;&#xA;select&#xD;&#xA;  rw.id, av14.nValue, av1.sValue, av3.sValue, av4.dValue, av15.nValue, av5.nValue, av12.nValue, av10.nValue, av11.nValue,av16.nValue,av6.sValue, av7.sValue,av13.dValue, av18.nValue&#xD;&#xA;--  av14.nValue, rw.cd, av.sValue, rw.description, av2.sValue, av1.sValue, av3.sValue+' ', av4.dValue, isnull(av15.nValue,0), isnull(av5.nValue,0), isnull(av12.nValue,0), isnull(av10.nValue,0), isnull(av11.nValue,0),isnull(av16.nValue,0),av6.sValue, av7.sValue AS pStatus,isnull(av13.dValue, av17.dValue),(select LSDBO.Ric_Get_ShortFIO(av9.sValue)), av18.nValue&#xD;&#xA; From lsdbo.Ric_Get_Select(2,100000038900005,'PSft, PHrd, PExp, PSrv, pPls','','',0,'') rw left join&#xD;&#xA;--select * From lsdbo.Ric_Get_Select(2,4000000015666,'PSft, PHrd, PExp, PSrv, pPls','','',0,'') rw left join&#xD;&#xA;_string_value AS av ON av.id= rw.id and av.idTypeAttr= 100004068400000 left join&#xD;&#xA;_string_value AS av1 ON av1.id= rw.id and av1.idTypeAttr= 3000000000101 LEFT JOIN &#xD;&#xA;_string_value AS av2 ON av2.id= rw.id and av2.idTypeAttr= 100003121500000 LEFT JOIN&#xD;&#xA;_string_value AS av3 ON av3.id= rw.id and av3.idTypeAttr= 100004086600000 left join&#xD;&#xA;_datetime_value AS av4 ON av4.id= rw.id and av4.idTypeAttr= 3000000000106 LEFT JOIN&#xD;&#xA;_numeric_value AS av5 ON av5.id= rw.id and av5.idTypeAttr= 100033995800000 left join&#xD;&#xA;_string_value AS av6 ON av6.id= rw.id and av6.idTypeAttr= 100005428000000 LEFT JOIN&#xD;&#xA;_string_value AS av7 ON av7.id= rw.id and av7.idTypeAttr= 100007986500005 left join&#xD;&#xA;_string_value AS av8 ON av8.id= rw.id and av8.idTypeAttr= 100003121500000 left join&#xD;&#xA;_string_value AS av9 ON av9.id= rw.id and av9.idTypeAttr= 3000000000122 LEFT JOIN&#xD;&#xA;_numeric_value AS av10 ON av10.id= rw.id and av10.idTypeAttr= 100007971500005 LEFT JOIN&#xD;&#xA;_numeric_value AS av11 ON av11.id= rw.id and av11.idTypeAttr= 100038030700000 LEFT JOIN&#xD;&#xA;_numeric_value AS av12 ON av12.id= rw.id and av12.idTypeAttr= 3000000000103  LEFT JOIN&#xD;&#xA;_datetime_value AS av13 ON av13.id= rw.id and av13.idTypeAttr= 3000000000108 left join&#xD;&#xA;_numeric_value AS av14 ON av14.id= rw.id and av14.idTypeAttr= 100000648000000   LEFT JOIN&#xD;&#xA;_numeric_value AS av15 ON av15.id= rw.id and av15.idTypeAttr= 100004081600000 LEFT JOIN&#xD;&#xA;_numeric_value AS av16 ON av16.id= rw.id and av16.idTypeAttr= 100004087100000 LEFT JOIN&#xD;&#xA;_datetime_value AS av17 ON av17.id= rw.id and av17.idTypeAttr= 9 LEFT JOIN&#xD;&#xA;_numeric_value AS av18 ON av18.id= rw.id and av18.idTypeAttr= 100004060300000" StatementType="SELECT">
          <StatementSetOptions ANSI_NULLS="false" ANSI_PADDING="false" ANSI_WARNINGS="false" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="false" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="false" />
          <QueryPlan DegreeOfParallelism="1" MemoryGrant="750" CachedPlanSize="346" CompileTime="100" CompileCPU="100" CompileMemory="5656">
            <RelOp AvgRowSize="4107" EstimateCPU="3.4134E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2.4134" LogicalOp="Sequence" NodeId="0" Parallel="false" PhysicalOp="Sequence" EstimatedTotalSubtreeCost="0.145901">
              <OutputList>
                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                <ColumnReference Column="Expr1016" />
                <ColumnReference Column="Expr1032" />
                <ColumnReference Column="Expr1040" />
                <ColumnReference Column="Expr1048" />
                <ColumnReference Column="Expr1056" />
                <ColumnReference Column="Expr1064" />
                <ColumnReference Column="Expr1088" />
                <ColumnReference Column="Expr1096" />
                <ColumnReference Column="Expr1104" />
                <ColumnReference Column="Expr1112" />
                <ColumnReference Column="Expr1120" />
                <ColumnReference Column="Expr1128" />
                <ColumnReference Column="Expr1136" />
                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
              </OutputList>
              <RunTimeInformation>
                <RunTimeCountersPerThread Thread="0" ActualRows="7208" ActualEndOfScans="1" ActualExecutions="1" />
              </RunTimeInformation>
              <Sequence>
                <RelOp AvgRowSize="9" EstimateCPU="1.157E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Table-valued function" NodeId="1" Parallel="false" PhysicalOp="Table-valued function" EstimatedTotalSubtreeCost="1.157E-06">
                  <OutputList />
                  <RunTimeInformation>
                    <RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="1" />
                  </RunTimeInformation>
                  <TableValuedFunction>
                    <DefinedValues />
                    <Object Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" />
                    <ParameterList>
                      <ScalarOperator ScalarString="(2)">
                        <Const ConstValue="(2)" />
                      </ScalarOperator>
                      <ScalarOperator ScalarString="(100000038900005.)">
                        <Const ConstValue="(100000038900005.)" />
                      </ScalarOperator>
                      <ScalarOperator ScalarString="'PSft, PHrd, PExp, PSrv, pPls'">
                        <Const ConstValue="'PSft, PHrd, PExp, PSrv, pPls'" />
                      </ScalarOperator>
                      <ScalarOperator ScalarString="''">
                        <Const ConstValue="''" />
                      </ScalarOperator>
                      <ScalarOperator ScalarString="''">
                        <Const ConstValue="''" />
                      </ScalarOperator>
                      <ScalarOperator ScalarString="(0.)">
                        <Const ConstValue="(0.)" />
                      </ScalarOperator>
                      <ScalarOperator ScalarString="''">
                        <Const ConstValue="''" />
                      </ScalarOperator>
                    </ParameterList>
                  </TableValuedFunction>
                </RelOp>
                <RelOp AvgRowSize="4107" EstimateCPU="1.0088E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2.4134" LogicalOp="Left Outer Join" NodeId="9" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.145896">
                  <OutputList>
                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                    <ColumnReference Column="Expr1016" />
                    <ColumnReference Column="Expr1032" />
                    <ColumnReference Column="Expr1040" />
                    <ColumnReference Column="Expr1048" />
                    <ColumnReference Column="Expr1056" />
                    <ColumnReference Column="Expr1064" />
                    <ColumnReference Column="Expr1088" />
                    <ColumnReference Column="Expr1096" />
                    <ColumnReference Column="Expr1104" />
                    <ColumnReference Column="Expr1112" />
                    <ColumnReference Column="Expr1120" />
                    <ColumnReference Column="Expr1128" />
                    <ColumnReference Column="Expr1136" />
                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                  </OutputList>
                  <RunTimeInformation>
                    <RunTimeCountersPerThread Thread="0" ActualRows="7208" ActualEndOfScans="1" ActualExecutions="1" />
                  </RunTimeInformation>
                  <NestedLoops Optimized="false">
                    <OuterReferences>
                      <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                    </OuterReferences>
                    <RelOp AvgRowSize="4099" EstimateCPU="9.6309E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2.30404" LogicalOp="Left Outer Join" NodeId="10" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.13433">
                      <OutputList>
                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                        <ColumnReference Column="Expr1016" />
                        <ColumnReference Column="Expr1032" />
                        <ColumnReference Column="Expr1040" />
                        <ColumnReference Column="Expr1048" />
                        <ColumnReference Column="Expr1056" />
                        <ColumnReference Column="Expr1064" />
                        <ColumnReference Column="Expr1088" />
                        <ColumnReference Column="Expr1096" />
                        <ColumnReference Column="Expr1104" />
                        <ColumnReference Column="Expr1112" />
                        <ColumnReference Column="Expr1120" />
                        <ColumnReference Column="Expr1128" />
                        <ColumnReference Column="Expr1136" />
                      </OutputList>
                      <RunTimeInformation>
                        <RunTimeCountersPerThread Thread="0" ActualRows="7208" ActualEndOfScans="1" ActualExecutions="1" />
                      </RunTimeInformation>
                      <NestedLoops Optimized="true">
                        <OuterReferences>
                          <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                        </OuterReferences>
                        <RelOp AvgRowSize="4099" EstimateCPU="9.19451E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2.19964" LogicalOp="Left Outer Join" NodeId="12" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.128842">
                          <OutputList>
                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                            <ColumnReference Column="Expr1016" />
                            <ColumnReference Column="Expr1032" />
                            <ColumnReference Column="Expr1040" />
                            <ColumnReference Column="Expr1048" />
                            <ColumnReference Column="Expr1056" />
                            <ColumnReference Column="Expr1064" />
                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_datetime]" Alias="[dv]" Column="value" />
                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                          </OutputList>
                          <RunTimeInformation>
                            <RunTimeCountersPerThread Thread="0" ActualRows="7208" ActualEndOfScans="1" ActualExecutions="1" />
                          </RunTimeInformation>
                          <NestedLoops Optimized="false">
                            <OuterReferences>
                              <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                            </OuterReferences>
                            <RelOp AvgRowSize="4091" EstimateCPU="8.77789E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2.09997" LogicalOp="Left Outer Join" NodeId="13" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.118142">
                              <OutputList>
                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                <ColumnReference Column="Expr1016" />
                                <ColumnReference Column="Expr1032" />
                                <ColumnReference Column="Expr1040" />
                                <ColumnReference Column="Expr1048" />
                                <ColumnReference Column="Expr1056" />
                                <ColumnReference Column="Expr1064" />
                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_datetime]" Alias="[dv]" Column="value" />
                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                              </OutputList>
                              <RunTimeInformation>
                                <RunTimeCountersPerThread Thread="0" ActualRows="7208" ActualEndOfScans="1" ActualExecutions="1" />
                              </RunTimeInformation>
                              <NestedLoops Optimized="false">
                                <OuterReferences>
                                  <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                </OuterReferences>
                                <RelOp AvgRowSize="4083" EstimateCPU="8.38015E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2.00482" LogicalOp="Left Outer Join" NodeId="14" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.107842">
                                  <OutputList>
                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                    <ColumnReference Column="Expr1016" />
                                    <ColumnReference Column="Expr1032" />
                                    <ColumnReference Column="Expr1040" />
                                    <ColumnReference Column="Expr1048" />
                                    <ColumnReference Column="Expr1056" />
                                    <ColumnReference Column="Expr1064" />
                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_datetime]" Alias="[dv]" Column="value" />
                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                  </OutputList>
                                  <RunTimeInformation>
                                    <RunTimeCountersPerThread Thread="0" ActualRows="7208" ActualEndOfScans="1" ActualExecutions="1" />
                                  </RunTimeInformation>
                                  <NestedLoops Optimized="false">
                                    <OuterReferences>
                                      <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                    </OuterReferences>
                                    <RelOp AvgRowSize="4075" EstimateCPU="8.00043E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1.91398" LogicalOp="Left Outer Join" NodeId="15" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0979222">
                                      <OutputList>
                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                        <ColumnReference Column="Expr1016" />
                                        <ColumnReference Column="Expr1032" />
                                        <ColumnReference Column="Expr1040" />
                                        <ColumnReference Column="Expr1048" />
                                        <ColumnReference Column="Expr1056" />
                                        <ColumnReference Column="Expr1064" />
                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_datetime]" Alias="[dv]" Column="value" />
                                      </OutputList>
                                      <RunTimeInformation>
                                        <RunTimeCountersPerThread Thread="0" ActualRows="7208" ActualEndOfScans="1" ActualExecutions="1" />
                                      </RunTimeInformation>
                                      <NestedLoops Optimized="false">
                                        <OuterReferences>
                                          <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                        </OuterReferences>
                                        <RelOp AvgRowSize="4067" EstimateCPU="7.63792E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1.82725" LogicalOp="Left Outer Join" NodeId="16" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0883621">
                                          <OutputList>
                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                            <ColumnReference Column="Expr1016" />
                                            <ColumnReference Column="Expr1032" />
                                            <ColumnReference Column="Expr1040" />
                                            <ColumnReference Column="Expr1048" />
                                            <ColumnReference Column="Expr1056" />
                                            <ColumnReference Column="Expr1064" />
                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                          </OutputList>
                                          <RunTimeInformation>
                                            <RunTimeCountersPerThread Thread="0" ActualRows="7208" ActualEndOfScans="1" ActualExecutions="1" />
                                          </RunTimeInformation>
                                          <NestedLoops Optimized="false">
                                            <OuterReferences>
                                              <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                            </OuterReferences>
                                            <RelOp AvgRowSize="4059" EstimateCPU="7.29183E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1.74446" LogicalOp="Left Outer Join" NodeId="17" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0791427">
                                              <OutputList>
                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                <ColumnReference Column="Expr1016" />
                                                <ColumnReference Column="Expr1032" />
                                                <ColumnReference Column="Expr1040" />
                                                <ColumnReference Column="Expr1048" />
                                                <ColumnReference Column="Expr1056" />
                                                <ColumnReference Column="Expr1064" />
                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                              </OutputList>
                                              <RunTimeInformation>
                                                <RunTimeCountersPerThread Thread="0" ActualRows="7208" ActualEndOfScans="1" ActualExecutions="1" />
                                              </RunTimeInformation>
                                              <NestedLoops Optimized="false">
                                                <OuterReferences>
                                                  <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                </OuterReferences>
                                                <RelOp AvgRowSize="4050" EstimateCPU="6.96143E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1.66541" LogicalOp="Left Outer Join" NodeId="18" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.070245">
                                                  <OutputList>
                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                    <ColumnReference Column="Expr1016" />
                                                    <ColumnReference Column="Expr1032" />
                                                    <ColumnReference Column="Expr1040" />
                                                    <ColumnReference Column="Expr1048" />
                                                    <ColumnReference Column="Expr1056" />
                                                    <ColumnReference Column="Expr1064" />
                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                                  </OutputList>
                                                  <RunTimeInformation>
                                                    <RunTimeCountersPerThread Thread="0" ActualRows="7208" ActualEndOfScans="1" ActualExecutions="1" />
                                                  </RunTimeInformation>
                                                  <NestedLoops Optimized="false">
                                                    <OuterReferences>
                                                      <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                    </OuterReferences>
                                                    <RelOp AvgRowSize="4042" EstimateCPU="6.646E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1.58995" LogicalOp="Left Outer Join" NodeId="19" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0616505">
                                                      <OutputList>
                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                        <ColumnReference Column="Expr1016" />
                                                        <ColumnReference Column="Expr1032" />
                                                        <ColumnReference Column="Expr1040" />
                                                        <ColumnReference Column="Expr1048" />
                                                        <ColumnReference Column="Expr1056" />
                                                        <ColumnReference Column="Expr1064" />
                                                      </OutputList>
                                                      <RunTimeInformation>
                                                        <RunTimeCountersPerThread Thread="0" ActualRows="7208" ActualEndOfScans="1" ActualExecutions="1" />
                                                      </RunTimeInformation>
                                                      <NestedLoops Optimized="true">
                                                        <OuterReferences>
                                                          <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                        </OuterReferences>
                                                        <RelOp AvgRowSize="4042" EstimateCPU="6.34485E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1.51791" LogicalOp="Left Outer Join" NodeId="21" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0575406">
                                                          <OutputList>
                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                            <ColumnReference Column="Expr1016" />
                                                            <ColumnReference Column="Expr1032" />
                                                            <ColumnReference Column="Expr1040" />
                                                            <ColumnReference Column="Expr1048" />
                                                            <ColumnReference Column="Expr1056" />
                                                            <ColumnReference Column="Expr1064" />
                                                          </OutputList>
                                                          <RunTimeInformation>
                                                            <RunTimeCountersPerThread Thread="0" ActualRows="7208" ActualEndOfScans="1" ActualExecutions="1" />
                                                          </RunTimeInformation>
                                                          <NestedLoops Optimized="true">
                                                            <OuterReferences>
                                                              <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                            </OuterReferences>
                                                            <RelOp AvgRowSize="4042" EstimateCPU="6.05736E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1.44913" LogicalOp="Left Outer Join" NodeId="23" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.053561">
                                                              <OutputList>
                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                                <ColumnReference Column="Expr1016" />
                                                                <ColumnReference Column="Expr1032" />
                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_datetime]" Alias="[dv]" Column="value" />
                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                                                <ColumnReference Column="Expr1056" />
                                                                <ColumnReference Column="Expr1064" />
                                                              </OutputList>
                                                              <RunTimeInformation>
                                                                <RunTimeCountersPerThread Thread="0" ActualRows="7208" ActualEndOfScans="1" ActualExecutions="1" />
                                                              </RunTimeInformation>
                                                              <NestedLoops Optimized="false">
                                                                <OuterReferences>
                                                                  <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                                </OuterReferences>
                                                                <RelOp AvgRowSize="3040" EstimateCPU="5.78289E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1.38347" LogicalOp="Left Outer Join" NodeId="24" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0457681">
                                                                  <OutputList>
                                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                                    <ColumnReference Column="Expr1016" />
                                                                    <ColumnReference Column="Expr1032" />
                                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_datetime]" Alias="[dv]" Column="value" />
                                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                                                    <ColumnReference Column="Expr1056" />
                                                                  </OutputList>
                                                                  <RunTimeInformation>
                                                                    <RunTimeCountersPerThread Thread="0" ActualRows="7208" ActualEndOfScans="1" ActualExecutions="1" />
                                                                  </RunTimeInformation>
                                                                  <NestedLoops Optimized="false">
                                                                    <OuterReferences>
                                                                      <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                                    </OuterReferences>
                                                                    <RelOp AvgRowSize="2038" EstimateCPU="5.52086E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1.32078" LogicalOp="Left Outer Join" NodeId="25" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0382064">
                                                                      <OutputList>
                                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                                        <ColumnReference Column="Expr1016" />
                                                                        <ColumnReference Column="Expr1032" />
                                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_datetime]" Alias="[dv]" Column="value" />
                                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                                                      </OutputList>
                                                                      <RunTimeInformation>
                                                                        <RunTimeCountersPerThread Thread="0" ActualRows="7208" ActualEndOfScans="1" ActualExecutions="1" />
                                                                      </RunTimeInformation>
                                                                      <NestedLoops Optimized="false">
                                                                        <OuterReferences>
                                                                          <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                                        </OuterReferences>
                                                                        <RelOp AvgRowSize="2030" EstimateCPU="5.2707E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1.26093" LogicalOp="Left Outer Join" NodeId="26" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0308573">
                                                                          <OutputList>
                                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                                            <ColumnReference Column="Expr1016" />
                                                                            <ColumnReference Column="Expr1032" />
                                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_datetime]" Alias="[dv]" Column="value" />
                                                                          </OutputList>
                                                                          <RunTimeInformation>
                                                                            <RunTimeCountersPerThread Thread="0" ActualRows="7208" ActualEndOfScans="1" ActualExecutions="1" />
                                                                          </RunTimeInformation>
                                                                          <NestedLoops Optimized="false">
                                                                            <OuterReferences>
                                                                              <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                                            </OuterReferences>
                                                                            <RelOp AvgRowSize="2022" EstimateCPU="5.03187E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1.2038" LogicalOp="Left Outer Join" NodeId="27" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0237013">
                                                                              <OutputList>
                                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                                                <ColumnReference Column="Expr1016" />
                                                                                <ColumnReference Column="Expr1032" />
                                                                              </OutputList>
                                                                              <RunTimeInformation>
                                                                                <RunTimeCountersPerThread Thread="0" ActualRows="7208" ActualEndOfScans="1" ActualExecutions="1" />
                                                                              </RunTimeInformation>
                                                                              <NestedLoops Optimized="false">
                                                                                <OuterReferences>
                                                                                  <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                                                </OuterReferences>
                                                                                <RelOp AvgRowSize="1020" EstimateCPU="4.80387E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1.14925" LogicalOp="Left Outer Join" NodeId="28" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0167176">
                                                                                  <OutputList>
                                                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                                                    <ColumnReference Column="Expr1016" />
                                                                                  </OutputList>
                                                                                  <RunTimeInformation>
                                                                                    <RunTimeCountersPerThread Thread="0" ActualRows="7208" ActualEndOfScans="1" ActualExecutions="1" />
                                                                                  </RunTimeInformation>
                                                                                  <NestedLoops Optimized="true">
                                                                                    <OuterReferences>
                                                                                      <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                                                    </OuterReferences>
                                                                                    <RelOp AvgRowSize="1020" EstimateCPU="4.5862E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1.09718" LogicalOp="Left Outer Join" NodeId="30" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0133165">
                                                                                      <OutputList>
                                                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                                                        <ColumnReference Column="Expr1016" />
                                                                                      </OutputList>
                                                                                      <RunTimeInformation>
                                                                                        <RunTimeCountersPerThread Thread="0" ActualRows="7208" ActualEndOfScans="1" ActualExecutions="1" />
                                                                                      </RunTimeInformation>
                                                                                      <NestedLoops Optimized="false">
                                                                                        <OuterReferences>
                                                                                          <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                                                        </OuterReferences>
                                                                                        <RelOp AvgRowSize="16" EstimateCPU="4.37839E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Left Outer Join" NodeId="31" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00660163">
                                                                                          <OutputList>
                                                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                                                          </OutputList>
                                                                                          <RunTimeInformation>
                                                                                            <RunTimeCountersPerThread Thread="0" ActualRows="7208" ActualEndOfScans="1" ActualExecutions="1" />
                                                                                          </RunTimeInformation>
                                                                                          <NestedLoops Optimized="true">
                                                                                            <OuterReferences>
                                                                                              <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                                                            </OuterReferences>
                                                                                            <RelOp AvgRowSize="16" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Table Scan" NodeId="33" Parallel="false" PhysicalOp="Table Scan" EstimatedTotalSubtreeCost="0.0032831">
                                                                                              <OutputList>
                                                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                                                              </OutputList>
                                                                                              <RunTimeInformation>
                                                                                                <RunTimeCountersPerThread Thread="0" ActualRows="7208" ActualEndOfScans="1" ActualExecutions="1" />
                                                                                              </RunTimeInformation>
                                                                                              <TableScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
                                                                                                <DefinedValues>
                                                                                                  <DefinedValue>
                                                                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                                                                  </DefinedValue>
                                                                                                </DefinedValues>
                                                                                                <Object Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" />
                                                                                              </TableScan>
                                                                                            </RelOp>
                                                                                            <RelOp AvgRowSize="16" EstimateCPU="0.000179384" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Clustered Index Seek" NodeId="34" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00330438">
                                                                                              <OutputList>
                                                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                                                              </OutputList>
                                                                                              <RunTimeInformation>
                                                                                                <RunTimeCountersPerThread Thread="0" ActualRows="7208" ActualEndOfScans="7208" ActualExecutions="7208" />
                                                                                              </RunTimeInformation>
                                                                                              <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                                                                                                <DefinedValues>
                                                                                                  <DefinedValue>
                                                                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                                                                  </DefinedValue>
                                                                                                </DefinedValues>
                                                                                                <Object Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Index="[object_reference_ndx2]" Alias="[av]" TableReferenceId="1" />
                                                                                                <SeekPredicates>
                                                                                                  <SeekPredicate>
                                                                                                    <Prefix ScanType="EQ">
                                                                                                      <RangeColumns>
                                                                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Object_ID" />
                                                                                                      </RangeColumns>
                                                                                                      <RangeExpressions>
                                                                                                        <ScalarOperator ScalarString="[crm].[LSDBO].[Ric_Get_Select].[id] as [rw].[id]">
                                                                                                          <Identifier>
                                                                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                                                                          </Identifier>
                                                                                                        </ScalarOperator>
                                                                                                      </RangeExpressions>
                                                                                                    </Prefix>
                                                                                                  </SeekPredicate>
                                                                                                </SeekPredicates>
                                                                                                <Predicate>
                                                                                                  <ScalarOperator ScalarString="[crm].[LSDBO].[attrib_value].[Attrib_ID] as [av].[Attrib_ID]=(100004068400000.)">
                                                                                                    <Compare CompareOp="EQ">
                                                                                                      <ScalarOperator>
                                                                                                        <Identifier>
                                                                                                          <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                                                                        </Identifier>
                                                                                                      </ScalarOperator>
                                                                                                      <ScalarOperator>
                                                                                                        <Const ConstValue="(100004068400000.)" />
                                                                                                      </ScalarOperator>
                                                                                                    </Compare>
                                                                                                  </ScalarOperator>
                                                                                                </Predicate>
                                                                                              </IndexScan>
                                                                                            </RelOp>
                                                                                          </NestedLoops>
                                                                                        </RelOp>
                                                                                        <RelOp AvgRowSize="1011" EstimateCPU="1.04746E-07" EstimateIO="0" EstimateRebinds="0.0474622" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Compute Scalar" NodeId="35" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.00671028">
                                                                                          <OutputList>
                                                                                            <ColumnReference Column="Expr1016" />
                                                                                          </OutputList>
                                                                                          <ComputeScalar>
                                                                                            <DefinedValues>
                                                                                              <DefinedValue>
                                                                                                <ColumnReference Column="Expr1016" />
                                                                                                <ScalarOperator ScalarString="CASE WHEN [crm].[LSDBO].[value_string].[value] as [sv].[value] IS NOT NULL THEN [crm].[LSDBO].[value_string].[value] as [sv].[value] ELSE '' END+CASE WHEN [crm].[LSDBO].[value_string].[Value1] as [sv].[Value1] IS NOT NULL THEN [crm].[LSDBO].[value_string].[Value1] as [sv].[Value1] ELSE '' END">
                                                                                                  <Arithmetic Operation="ADD">
                                                                                                    <ScalarOperator>
                                                                                                      <IF>
                                                                                                        <Condition>
                                                                                                          <ScalarOperator>
                                                                                                            <Compare CompareOp="IS NOT">
                                                                                                              <ScalarOperator>
                                                                                                                <Identifier>
                                                                                                                  <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="value" />
                                                                                                                </Identifier>
                                                                                                              </ScalarOperator>
                                                                                                              <ScalarOperator>
                                                                                                                <Const ConstValue="NULL" />
                                                                                                              </ScalarOperator>
                                                                                                            </Compare>
                                                                                                          </ScalarOperator>
                                                                                                        </Condition>
                                                                                                        <Then>
                                                                                                          <ScalarOperator>
                                                                                                            <Identifier>
                                                                                                              <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="value" />
                                                                                                            </Identifier>
                                                                                                          </ScalarOperator>
                                                                                                        </Then>
                                                                                                        <Else>
                                                                                                          <ScalarOperator>
                                                                                                            <Const ConstValue="''" />
                                                                                                          </ScalarOperator>
                                                                                                        </Else>
                                                                                                      </IF>
                                                                                                    </ScalarOperator>
                                                                                                    <ScalarOperator>
                                                                                                      <IF>
                                                                                                        <Condition>
                                                                                                          <ScalarOperator>
                                                                                                            <Compare CompareOp="IS NOT">
                                                                                                              <ScalarOperator>
                                                                                                                <Identifier>
                                                                                                                  <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="Value1" />
                                                                                                                </Identifier>
                                                                                                              </ScalarOperator>
                                                                                                              <ScalarOperator>
                                                                                                                <Const ConstValue="NULL" />
                                                                                                              </ScalarOperator>
                                                                                                            </Compare>
                                                                                                          </ScalarOperator>
                                                                                                        </Condition>
                                                                                                        <Then>
                                                                                                          <ScalarOperator>
                                                                                                            <Identifier>
                                                                                                              <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="Value1" />
                                                                                                            </Identifier>
                                                                                                          </ScalarOperator>
                                                                                                        </Then>
                                                                                                        <Else>
                                                                                                          <ScalarOperator>
                                                                                                            <Const ConstValue="''" />
                                                                                                          </ScalarOperator>
                                                                                                        </Else>
                                                                                                      </IF>
                                                                                                    </ScalarOperator>
                                                                                                  </Arithmetic>
                                                                                                </ScalarOperator>
                                                                                              </DefinedValue>
                                                                                            </DefinedValues>
                                                                                            <RelOp AvgRowSize="1012" EstimateCPU="4.37839E-06" EstimateIO="0" EstimateRebinds="0.0474622" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Left Outer Join" NodeId="36" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00671017">
                                                                                              <OutputList>
                                                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="value" />
                                                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="Value1" />
                                                                                              </OutputList>
                                                                                              <RunTimeInformation>
                                                                                                <RunTimeCountersPerThread Thread="0" ActualRows="7034" ActualEndOfScans="7208" ActualExecutions="7208" />
                                                                                              </RunTimeInformation>
                                                                                              <NestedLoops Optimized="true">
                                                                                                <OuterReferences>
                                                                                                  <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                                                                </OuterReferences>
                                                                                                <RelOp AvgRowSize="25" EstimateCPU="0.000179384" EstimateIO="0.003125" EstimateRebinds="0.0474622" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Clustered Index Seek" NodeId="38" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00333316">
                                                                                                  <OutputList>
                                                                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                                                                  </OutputList>
                                                                                                  <RunTimeInformation>
                                                                                                    <RunTimeCountersPerThread Thread="0" ActualRows="7034" ActualEndOfScans="7208" ActualExecutions="7208" />
                                                                                                  </RunTimeInformation>
                                                                                                  <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                                                                                                    <DefinedValues>
                                                                                                      <DefinedValue>
                                                                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                                                                      </DefinedValue>
                                                                                                      <DefinedValue>
                                                                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                                                                      </DefinedValue>
                                                                                                    </DefinedValues>
                                                                                                    <Object Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Index="[object_reference_ndx2]" Alias="[av]" TableReferenceId="2" />
                                                                                                    <SeekPredicates>
                                                                                                      <SeekPredicate>
                                                                                                        <Prefix ScanType="EQ">
                                                                                                          <RangeColumns>
                                                                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Object_ID" />
                                                                                                          </RangeColumns>
                                                                                                          <RangeExpressions>
                                                                                                            <ScalarOperator ScalarString="[crm].[LSDBO].[Ric_Get_Select].[id] as [rw].[id]">
                                                                                                              <Identifier>
                                                                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                                                                              </Identifier>
                                                                                                            </ScalarOperator>
                                                                                                          </RangeExpressions>
                                                                                                        </Prefix>
                                                                                                      </SeekPredicate>
                                                                                                    </SeekPredicates>
                                                                                                    <Predicate>
                                                                                                      <ScalarOperator ScalarString="[crm].[LSDBO].[attrib_value].[Attrib_ID] as [av].[Attrib_ID]=(3000000000101.)">
                                                                                                        <Compare CompareOp="EQ">
                                                                                                          <ScalarOperator>
                                                                                                            <Identifier>
                                                                                                              <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                                                                            </Identifier>
                                                                                                          </ScalarOperator>
                                                                                                          <ScalarOperator>
                                                                                                            <Const ConstValue="(3000000000101.)" />
                                                                                                          </ScalarOperator>
                                                                                                        </Compare>
                                                                                                      </ScalarOperator>
                                                                                                    </Predicate>
                                                                                                  </IndexScan>
                                                                                                </RelOp>
                                                                                                <RelOp AvgRowSize="1012" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0.0971771" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="39" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00336219">
                                                                                                  <OutputList>
                                                                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="value" />
                                                                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="Value1" />
                                                                                                  </OutputList>
                                                                                                  <RunTimeInformation>
                                                                                                    <RunTimeCountersPerThread Thread="0" ActualRows="7034" ActualEndOfScans="0" ActualExecutions="7034" />
                                                                                                  </RunTimeInformation>
                                                                                                  <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                                                                                                    <DefinedValues>
                                                                                                      <DefinedValue>
                                                                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="value" />
                                                                                                      </DefinedValue>
                                                                                                      <DefinedValue>
                                                                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="Value1" />
                                                                                                      </DefinedValue>
                                                                                                    </DefinedValues>
                                                                                                    <Object Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Index="[PK__value_string__20CCCE1C]" Alias="[sv]" TableReferenceId="2" />
                                                                                                    <SeekPredicates>
                                                                                                      <SeekPredicate>
                                                                                                        <Prefix ScanType="EQ">
                                                                                                          <RangeColumns>
                                                                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="id" />
                                                                                                          </RangeColumns>
                                                                                                          <RangeExpressions>
                                                                                                            <ScalarOperator ScalarString="[crm].[LSDBO].[attrib_value].[Value_ID] as [av].[Value_ID]">
                                                                                                              <Identifier>
                                                                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                                                                              </Identifier>
                                                                                                            </ScalarOperator>
                                                                                                          </RangeExpressions>
                                                                                                        </Prefix>
                                                                                                      </SeekPredicate>
                                                                                                    </SeekPredicates>
                                                                                                  </IndexScan>
                                                                                                </RelOp>
                                                                                              </NestedLoops>
                                                                                            </RelOp>
                                                                                          </ComputeScalar>
                                                                                        </RelOp>
                                                                                      </NestedLoops>
                                                                                    </RelOp>
                                                                                    <RelOp AvgRowSize="16" EstimateCPU="0.000179384" EstimateIO="0.003125" EstimateRebinds="0.0971771" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Clustered Index Seek" NodeId="43" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00338555">
                                                                                      <OutputList>
                                                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                                                      </OutputList>
                                                                                      <RunTimeInformation>
                                                                                        <RunTimeCountersPerThread Thread="0" ActualRows="6957" ActualEndOfScans="7208" ActualExecutions="7208" />
                                                                                      </RunTimeInformation>
                                                                                      <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                                                                                        <DefinedValues>
                                                                                          <DefinedValue>
                                                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                                                          </DefinedValue>
                                                                                        </DefinedValues>
                                                                                        <Object Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Index="[object_reference_ndx2]" Alias="[av]" TableReferenceId="3" />
                                                                                        <SeekPredicates>
                                                                                          <SeekPredicate>
                                                                                            <Prefix ScanType="EQ">
                                                                                              <RangeColumns>
                                                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Object_ID" />
                                                                                              </RangeColumns>
                                                                                              <RangeExpressions>
                                                                                                <ScalarOperator ScalarString="[crm].[LSDBO].[Ric_Get_Select].[id] as [rw].[id]">
                                                                                                  <Identifier>
                                                                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                                                                  </Identifier>
                                                                                                </ScalarOperator>
                                                                                              </RangeExpressions>
                                                                                            </Prefix>
                                                                                          </SeekPredicate>
                                                                                        </SeekPredicates>
                                                                                        <Predicate>
                                                                                          <ScalarOperator ScalarString="[crm].[LSDBO].[attrib_value].[Attrib_ID] as [av].[Attrib_ID]=(100003121500000.)">
                                                                                            <Compare CompareOp="EQ">
                                                                                              <ScalarOperator>
                                                                                                <Identifier>
                                                                                                  <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                                                                </Identifier>
                                                                                              </ScalarOperator>
                                                                                              <ScalarOperator>
                                                                                                <Const ConstValue="(100003121500000.)" />
                                                                                              </ScalarOperator>
                                                                                            </Compare>
                                                                                          </ScalarOperator>
                                                                                        </Predicate>
                                                                                      </IndexScan>
                                                                                    </RelOp>
                                                                                  </NestedLoops>
                                                                                </RelOp>
                                                                                <RelOp AvgRowSize="1011" EstimateCPU="1.04746E-07" EstimateIO="0" EstimateRebinds="0.149252" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Compute Scalar" NodeId="44" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.00697875">
                                                                                  <OutputList>
                                                                                    <ColumnReference Column="Expr1032" />
                                                                                  </OutputList>
                                                                                  <ComputeScalar>
                                                                                    <DefinedValues>
                                                                                      <DefinedValue>
                                                                                        <ColumnReference Column="Expr1032" />
                                                                                        <ScalarOperator ScalarString="CASE WHEN [crm].[LSDBO].[value_string].[value] as [sv].[value] IS NOT NULL THEN [crm].[LSDBO].[value_string].[value] as [sv].[value] ELSE '' END+CASE WHEN [crm].[LSDBO].[value_string].[Value1] as [sv].[Value1] IS NOT NULL THEN [crm].[LSDBO].[value_string].[Value1] as [sv].[Value1] ELSE '' END">
                                                                                          <Arithmetic Operation="ADD">
                                                                                            <ScalarOperator>
                                                                                              <IF>
                                                                                                <Condition>
                                                                                                  <ScalarOperator>
                                                                                                    <Compare CompareOp="IS NOT">
                                                                                                      <ScalarOperator>
                                                                                                        <Identifier>
                                                                                                          <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="value" />
                                                                                                        </Identifier>
                                                                                                      </ScalarOperator>
                                                                                                      <ScalarOperator>
                                                                                                        <Const ConstValue="NULL" />
                                                                                                      </ScalarOperator>
                                                                                                    </Compare>
                                                                                                  </ScalarOperator>
                                                                                                </Condition>
                                                                                                <Then>
                                                                                                  <ScalarOperator>
                                                                                                    <Identifier>
                                                                                                      <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="value" />
                                                                                                    </Identifier>
                                                                                                  </ScalarOperator>
                                                                                                </Then>
                                                                                                <Else>
                                                                                                  <ScalarOperator>
                                                                                                    <Const ConstValue="''" />
                                                                                                  </ScalarOperator>
                                                                                                </Else>
                                                                                              </IF>
                                                                                            </ScalarOperator>
                                                                                            <ScalarOperator>
                                                                                              <IF>
                                                                                                <Condition>
                                                                                                  <ScalarOperator>
                                                                                                    <Compare CompareOp="IS NOT">
                                                                                                      <ScalarOperator>
                                                                                                        <Identifier>
                                                                                                          <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="Value1" />
                                                                                                        </Identifier>
                                                                                                      </ScalarOperator>
                                                                                                      <ScalarOperator>
                                                                                                        <Const ConstValue="NULL" />
                                                                                                      </ScalarOperator>
                                                                                                    </Compare>
                                                                                                  </ScalarOperator>
                                                                                                </Condition>
                                                                                                <Then>
                                                                                                  <ScalarOperator>
                                                                                                    <Identifier>
                                                                                                      <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="Value1" />
                                                                                                    </Identifier>
                                                                                                  </ScalarOperator>
                                                                                                </Then>
                                                                                                <Else>
                                                                                                  <ScalarOperator>
                                                                                                    <Const ConstValue="''" />
                                                                                                  </ScalarOperator>
                                                                                                </Else>
                                                                                              </IF>
                                                                                            </ScalarOperator>
                                                                                          </Arithmetic>
                                                                                        </ScalarOperator>
                                                                                      </DefinedValue>
                                                                                    </DefinedValues>
                                                                                    <RelOp AvgRowSize="1012" EstimateCPU="4.37839E-06" EstimateIO="0" EstimateRebinds="0.149252" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Left Outer Join" NodeId="45" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00697863">
                                                                                      <OutputList>
                                                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="value" />
                                                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="Value1" />
                                                                                      </OutputList>
                                                                                      <RunTimeInformation>
                                                                                        <RunTimeCountersPerThread Thread="0" ActualRows="6282" ActualEndOfScans="7208" ActualExecutions="7208" />
                                                                                      </RunTimeInformation>
                                                                                      <NestedLoops Optimized="true">
                                                                                        <OuterReferences>
                                                                                          <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                                                        </OuterReferences>
                                                                                        <RelOp AvgRowSize="25" EstimateCPU="0.000179384" EstimateIO="0.003125" EstimateRebinds="0.149252" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Clustered Index Seek" NodeId="47" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00345365">
                                                                                          <OutputList>
                                                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                                                          </OutputList>
                                                                                          <RunTimeInformation>
                                                                                            <RunTimeCountersPerThread Thread="0" ActualRows="6282" ActualEndOfScans="7208" ActualExecutions="7208" />
                                                                                          </RunTimeInformation>
                                                                                          <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                                                                                            <DefinedValues>
                                                                                              <DefinedValue>
                                                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                                                              </DefinedValue>
                                                                                              <DefinedValue>
                                                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                                                              </DefinedValue>
                                                                                            </DefinedValues>
                                                                                            <Object Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Index="[object_reference_ndx2]" Alias="[av]" TableReferenceId="4" />
                                                                                            <SeekPredicates>
                                                                                              <SeekPredicate>
                                                                                                <Prefix ScanType="EQ">
                                                                                                  <RangeColumns>
                                                                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Object_ID" />
                                                                                                  </RangeColumns>
                                                                                                  <RangeExpressions>
                                                                                                    <ScalarOperator ScalarString="[crm].[LSDBO].[Ric_Get_Select].[id] as [rw].[id]">
                                                                                                      <Identifier>
                                                                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                                                                      </Identifier>
                                                                                                    </ScalarOperator>
                                                                                                  </RangeExpressions>
                                                                                                </Prefix>
                                                                                              </SeekPredicate>
                                                                                            </SeekPredicates>
                                                                                            <Predicate>
                                                                                              <ScalarOperator ScalarString="[crm].[LSDBO].[attrib_value].[Attrib_ID] as [av].[Attrib_ID]=(100004086600000.)">
                                                                                                <Compare CompareOp="EQ">
                                                                                                  <ScalarOperator>
                                                                                                    <Identifier>
                                                                                                      <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                                                                    </Identifier>
                                                                                                  </ScalarOperator>
                                                                                                  <ScalarOperator>
                                                                                                    <Const ConstValue="(100004086600000.)" />
                                                                                                  </ScalarOperator>
                                                                                                </Compare>
                                                                                              </ScalarOperator>
                                                                                            </Predicate>
                                                                                          </IndexScan>
                                                                                        </RelOp>
                                                                                        <RelOp AvgRowSize="1012" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0.203798" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="48" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00350873">
                                                                                          <OutputList>
                                                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="value" />
                                                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="Value1" />
                                                                                          </OutputList>
                                                                                          <RunTimeInformation>
                                                                                            <RunTimeCountersPerThread Thread="0" ActualRows="6282" ActualEndOfScans="0" ActualExecutions="6282" />
                                                                                          </RunTimeInformation>
                                                                                          <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                                                                                            <DefinedValues>
                                                                                              <DefinedValue>
                                                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="value" />
                                                                                              </DefinedValue>
                                                                                              <DefinedValue>
                                                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="Value1" />
                                                                                              </DefinedValue>
                                                                                            </DefinedValues>
                                                                                            <Object Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Index="[PK__value_string__20CCCE1C]" Alias="[sv]" TableReferenceId="4" />
                                                                                            <SeekPredicates>
                                                                                              <SeekPredicate>
                                                                                                <Prefix ScanType="EQ">
                                                                                                  <RangeColumns>
                                                                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="id" />
                                                                                                  </RangeColumns>
                                                                                                  <RangeExpressions>
                                                                                                    <ScalarOperator ScalarString="[crm].[LSDBO].[attrib_value].[Value_ID] as [av].[Value_ID]">
                                                                                                      <Identifier>
                                                                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                                                                      </Identifier>
                                                                                                    </ScalarOperator>
                                                                                                  </RangeExpressions>
                                                                                                </Prefix>
                                                                                              </SeekPredicate>
                                                                                            </SeekPredicates>
                                                                                          </IndexScan>
                                                                                        </RelOp>
                                                                                      </NestedLoops>
                                                                                    </RelOp>
                                                                                  </ComputeScalar>
                                                                                </RelOp>
                                                                              </NestedLoops>
                                                                            </RelOp>
                                                                            <RelOp AvgRowSize="15" EstimateCPU="1.04746E-07" EstimateIO="0" EstimateRebinds="0.203798" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Compute Scalar" NodeId="52" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.00715068">
                                                                              <OutputList>
                                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_datetime]" Alias="[dv]" Column="value" />
                                                                              </OutputList>
                                                                              <ComputeScalar>
                                                                                <DefinedValues>
                                                                                  <DefinedValue>
                                                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_datetime]" Alias="[dv]" Column="value" />
                                                                                    <ScalarOperator ScalarString="[crm].[LSDBO].[value_datetime].[value] as [dv].[value]">
                                                                                      <Identifier>
                                                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_datetime]" Alias="[dv]" Column="value" />
                                                                                      </Identifier>
                                                                                    </ScalarOperator>
                                                                                  </DefinedValue>
                                                                                </DefinedValues>
                                                                                <RelOp AvgRowSize="15" EstimateCPU="4.37839E-06" EstimateIO="0" EstimateRebinds="0.203798" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Left Outer Join" NodeId="53" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00715055">
                                                                                  <OutputList>
                                                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_datetime]" Alias="[dv]" Column="value" />
                                                                                  </OutputList>
                                                                                  <RunTimeInformation>
                                                                                    <RunTimeCountersPerThread Thread="0" ActualRows="6282" ActualEndOfScans="7208" ActualExecutions="7208" />
                                                                                  </RunTimeInformation>
                                                                                  <NestedLoops Optimized="true">
                                                                                    <OuterReferences>
                                                                                      <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                                                    </OuterReferences>
                                                                                    <RelOp AvgRowSize="25" EstimateCPU="0.000179384" EstimateIO="0.003125" EstimateRebinds="0.203798" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Clustered Index Seek" NodeId="55" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00353435">
                                                                                      <OutputList>
                                                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                                                      </OutputList>
                                                                                      <RunTimeInformation>
                                                                                        <RunTimeCountersPerThread Thread="0" ActualRows="6282" ActualEndOfScans="7208" ActualExecutions="7208" />
                                                                                      </RunTimeInformation>
                                                                                      <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                                                                                        <DefinedValues>
                                                                                          <DefinedValue>
                                                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                                                          </DefinedValue>
                                                                                          <DefinedValue>
                                                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                                                          </DefinedValue>
                                                                                        </DefinedValues>
                                                                                        <Object Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Index="[object_reference_ndx2]" Alias="[av]" TableReferenceId="5" />
                                                                                        <SeekPredicates>
                                                                                          <SeekPredicate>
                                                                                            <Prefix ScanType="EQ">
                                                                                              <RangeColumns>
                                                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Object_ID" />
                                                                                              </RangeColumns>
                                                                                              <RangeExpressions>
                                                                                                <ScalarOperator ScalarString="[crm].[LSDBO].[Ric_Get_Select].[id] as [rw].[id]">
                                                                                                  <Identifier>
                                                                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                                                                  </Identifier>
                                                                                                </ScalarOperator>
                                                                                              </RangeExpressions>
                                                                                            </Prefix>
                                                                                          </SeekPredicate>
                                                                                        </SeekPredicates>
                                                                                        <Predicate>
                                                                                          <ScalarOperator ScalarString="[crm].[LSDBO].[attrib_value].[Attrib_ID] as [av].[Attrib_ID]=(3000000000106.)">
                                                                                            <Compare CompareOp="EQ">
                                                                                              <ScalarOperator>
                                                                                                <Identifier>
                                                                                                  <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                                                                </Identifier>
                                                                                              </ScalarOperator>
                                                                                              <ScalarOperator>
                                                                                                <Const ConstValue="(3000000000106.)" />
                                                                                              </ScalarOperator>
                                                                                            </Compare>
                                                                                          </ScalarOperator>
                                                                                        </Predicate>
                                                                                      </IndexScan>
                                                                                    </RelOp>
                                                                                    <RelOp AvgRowSize="15" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0.260933" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="56" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00359917">
                                                                                      <OutputList>
                                                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_datetime]" Alias="[dv]" Column="value" />
                                                                                      </OutputList>
                                                                                      <RunTimeInformation>
                                                                                        <RunTimeCountersPerThread Thread="0" ActualRows="6282" ActualEndOfScans="0" ActualExecutions="6282" />
                                                                                      </RunTimeInformation>
                                                                                      <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                                                                                        <DefinedValues>
                                                                                          <DefinedValue>
                                                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_datetime]" Alias="[dv]" Column="value" />
                                                                                          </DefinedValue>
                                                                                        </DefinedValues>
                                                                                        <Object Database="[crm]" Schema="[LSDBO]" Table="[value_datetime]" Index="[PK__value_datetime__1B13F4C6]" Alias="[dv]" TableReferenceId="1" />
                                                                                        <SeekPredicates>
                                                                                          <SeekPredicate>
                                                                                            <Prefix ScanType="EQ">
                                                                                              <RangeColumns>
                                                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_datetime]" Alias="[dv]" Column="id" />
                                                                                              </RangeColumns>
                                                                                              <RangeExpressions>
                                                                                                <ScalarOperator ScalarString="[crm].[LSDBO].[attrib_value].[Value_ID] as [av].[Value_ID]">
                                                                                                  <Identifier>
                                                                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                                                                  </Identifier>
                                                                                                </ScalarOperator>
                                                                                              </RangeExpressions>
                                                                                            </Prefix>
                                                                                          </SeekPredicate>
                                                                                        </SeekPredicates>
                                                                                      </IndexScan>
                                                                                    </RelOp>
                                                                                  </NestedLoops>
                                                                                </RelOp>
                                                                              </ComputeScalar>
                                                                            </RelOp>
                                                                          </NestedLoops>
                                                                        </RelOp>
                                                                        <RelOp AvgRowSize="15" EstimateCPU="1.04746E-07" EstimateIO="0" EstimateRebinds="0.260933" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Compute Scalar" NodeId="60" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.00734355">
                                                                          <OutputList>
                                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                                                          </OutputList>
                                                                          <ComputeScalar>
                                                                            <DefinedValues>
                                                                              <DefinedValue>
                                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                                                                <ScalarOperator ScalarString="[crm].[LSDBO].[value_numeric].[value] as [nv].[value]">
                                                                                  <Identifier>
                                                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                                                                  </Identifier>
                                                                                </ScalarOperator>
                                                                              </DefinedValue>
                                                                            </DefinedValues>
                                                                            <RelOp AvgRowSize="15" EstimateCPU="4.37839E-06" EstimateIO="0" EstimateRebinds="0.260933" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Left Outer Join" NodeId="61" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00734342">
                                                                              <OutputList>
                                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                                                              </OutputList>
                                                                              <RunTimeInformation>
                                                                                <RunTimeCountersPerThread Thread="0" ActualRows="5461" ActualEndOfScans="7208" ActualExecutions="7208" />
                                                                              </RunTimeInformation>
                                                                              <NestedLoops Optimized="false">
                                                                                <OuterReferences>
                                                                                  <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                                                </OuterReferences>
                                                                                <RelOp AvgRowSize="25" EstimateCPU="0.000179384" EstimateIO="0.003125" EstimateRebinds="0.260933" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Clustered Index Seek" NodeId="62" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00362603">
                                                                                  <OutputList>
                                                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                                                  </OutputList>
                                                                                  <RunTimeInformation>
                                                                                    <RunTimeCountersPerThread Thread="0" ActualRows="5461" ActualEndOfScans="7208" ActualExecutions="7208" />
                                                                                  </RunTimeInformation>
                                                                                  <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                                                                                    <DefinedValues>
                                                                                      <DefinedValue>
                                                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                                                      </DefinedValue>
                                                                                      <DefinedValue>
                                                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                                                      </DefinedValue>
                                                                                    </DefinedValues>
                                                                                    <Object Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Index="[object_reference_ndx2]" Alias="[av]" TableReferenceId="6" />
                                                                                    <SeekPredicates>
                                                                                      <SeekPredicate>
                                                                                        <Prefix ScanType="EQ">
                                                                                          <RangeColumns>
                                                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Object_ID" />
                                                                                          </RangeColumns>
                                                                                          <RangeExpressions>
                                                                                            <ScalarOperator ScalarString="[crm].[LSDBO].[Ric_Get_Select].[id] as [rw].[id]">
                                                                                              <Identifier>
                                                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                                                              </Identifier>
                                                                                            </ScalarOperator>
                                                                                          </RangeExpressions>
                                                                                        </Prefix>
                                                                                      </SeekPredicate>
                                                                                    </SeekPredicates>
                                                                                    <Predicate>
                                                                                      <ScalarOperator ScalarString="[crm].[LSDBO].[attrib_value].[Attrib_ID] as [av].[Attrib_ID]=(100033995800000.)">
                                                                                        <Compare CompareOp="EQ">
                                                                                          <ScalarOperator>
                                                                                            <Identifier>
                                                                                              <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                                                            </Identifier>
                                                                                          </ScalarOperator>
                                                                                          <ScalarOperator>
                                                                                            <Const ConstValue="(100033995800000.)" />
                                                                                          </ScalarOperator>
                                                                                        </Compare>
                                                                                      </ScalarOperator>
                                                                                    </Predicate>
                                                                                  </IndexScan>
                                                                                </RelOp>
                                                                                <RelOp AvgRowSize="15" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0.320779" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="63" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00369955">
                                                                                  <OutputList>
                                                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                                                                  </OutputList>
                                                                                  <RunTimeInformation>
                                                                                    <RunTimeCountersPerThread Thread="0" ActualRows="5461" ActualEndOfScans="0" ActualExecutions="5461" />
                                                                                  </RunTimeInformation>
                                                                                  <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                                                                                    <DefinedValues>
                                                                                      <DefinedValue>
                                                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                                                                      </DefinedValue>
                                                                                    </DefinedValues>
                                                                                    <Object Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Index="[PK__value_numeric__1DF06171]" Alias="[nv]" TableReferenceId="1" />
                                                                                    <SeekPredicates>
                                                                                      <SeekPredicate>
                                                                                        <Prefix ScanType="EQ">
                                                                                          <RangeColumns>
                                                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="id" />
                                                                                          </RangeColumns>
                                                                                          <RangeExpressions>
                                                                                            <ScalarOperator ScalarString="[crm].[LSDBO].[attrib_value].[Value_ID] as [av].[Value_ID]">
                                                                                              <Identifier>
                                                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                                                              </Identifier>
                                                                                            </ScalarOperator>
                                                                                          </RangeExpressions>
                                                                                        </Prefix>
                                                                                      </SeekPredicate>
                                                                                    </SeekPredicates>
                                                                                  </IndexScan>
                                                                                </RelOp>
                                                                              </NestedLoops>
                                                                            </RelOp>
                                                                          </ComputeScalar>
                                                                        </RelOp>
                                                                      </NestedLoops>
                                                                    </RelOp>
                                                                    <RelOp AvgRowSize="1011" EstimateCPU="1.04746E-07" EstimateIO="0" EstimateRebinds="0.320779" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Compute Scalar" NodeId="67" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.00755594">
                                                                      <OutputList>
                                                                        <ColumnReference Column="Expr1056" />
                                                                      </OutputList>
                                                                      <ComputeScalar>
                                                                        <DefinedValues>
                                                                          <DefinedValue>
                                                                            <ColumnReference Column="Expr1056" />
                                                                            <ScalarOperator ScalarString="CASE WHEN [crm].[LSDBO].[value_string].[value] as [sv].[value] IS NOT NULL THEN [crm].[LSDBO].[value_string].[value] as [sv].[value] ELSE '' END+CASE WHEN [crm].[LSDBO].[value_string].[Value1] as [sv].[Value1] IS NOT NULL THEN [crm].[LSDBO].[value_string].[Value1] as [sv].[Value1] ELSE '' END">
                                                                              <Arithmetic Operation="ADD">
                                                                                <ScalarOperator>
                                                                                  <IF>
                                                                                    <Condition>
                                                                                      <ScalarOperator>
                                                                                        <Compare CompareOp="IS NOT">
                                                                                          <ScalarOperator>
                                                                                            <Identifier>
                                                                                              <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="value" />
                                                                                            </Identifier>
                                                                                          </ScalarOperator>
                                                                                          <ScalarOperator>
                                                                                            <Const ConstValue="NULL" />
                                                                                          </ScalarOperator>
                                                                                        </Compare>
                                                                                      </ScalarOperator>
                                                                                    </Condition>
                                                                                    <Then>
                                                                                      <ScalarOperator>
                                                                                        <Identifier>
                                                                                          <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="value" />
                                                                                        </Identifier>
                                                                                      </ScalarOperator>
                                                                                    </Then>
                                                                                    <Else>
                                                                                      <ScalarOperator>
                                                                                        <Const ConstValue="''" />
                                                                                      </ScalarOperator>
                                                                                    </Else>
                                                                                  </IF>
                                                                                </ScalarOperator>
                                                                                <ScalarOperator>
                                                                                  <IF>
                                                                                    <Condition>
                                                                                      <ScalarOperator>
                                                                                        <Compare CompareOp="IS NOT">
                                                                                          <ScalarOperator>
                                                                                            <Identifier>
                                                                                              <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="Value1" />
                                                                                            </Identifier>
                                                                                          </ScalarOperator>
                                                                                          <ScalarOperator>
                                                                                            <Const ConstValue="NULL" />
                                                                                          </ScalarOperator>
                                                                                        </Compare>
                                                                                      </ScalarOperator>
                                                                                    </Condition>
                                                                                    <Then>
                                                                                      <ScalarOperator>
                                                                                        <Identifier>
                                                                                          <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="Value1" />
                                                                                        </Identifier>
                                                                                      </ScalarOperator>
                                                                                    </Then>
                                                                                    <Else>
                                                                                      <ScalarOperator>
                                                                                        <Const ConstValue="''" />
                                                                                      </ScalarOperator>
                                                                                    </Else>
                                                                                  </IF>
                                                                                </ScalarOperator>
                                                                              </Arithmetic>
                                                                            </ScalarOperator>
                                                                          </DefinedValue>
                                                                        </DefinedValues>
                                                                        <RelOp AvgRowSize="1012" EstimateCPU="4.37839E-06" EstimateIO="0" EstimateRebinds="0.320779" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Left Outer Join" NodeId="68" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0075558">
                                                                          <OutputList>
                                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="value" />
                                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="Value1" />
                                                                          </OutputList>
                                                                          <RunTimeInformation>
                                                                            <RunTimeCountersPerThread Thread="0" ActualRows="7208" ActualEndOfScans="7208" ActualExecutions="7208" />
                                                                          </RunTimeInformation>
                                                                          <NestedLoops Optimized="true">
                                                                            <OuterReferences>
                                                                              <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                                            </OuterReferences>
                                                                            <RelOp AvgRowSize="25" EstimateCPU="0.000179384" EstimateIO="0.003125" EstimateRebinds="0.320779" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Clustered Index Seek" NodeId="70" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00372771">
                                                                              <OutputList>
                                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                                              </OutputList>
                                                                              <RunTimeInformation>
                                                                                <RunTimeCountersPerThread Thread="0" ActualRows="7208" ActualEndOfScans="7208" ActualExecutions="7208" />
                                                                              </RunTimeInformation>
                                                                              <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                                                                                <DefinedValues>
                                                                                  <DefinedValue>
                                                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                                                  </DefinedValue>
                                                                                  <DefinedValue>
                                                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                                                  </DefinedValue>
                                                                                </DefinedValues>
                                                                                <Object Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Index="[object_reference_ndx2]" Alias="[av]" TableReferenceId="7" />
                                                                                <SeekPredicates>
                                                                                  <SeekPredicate>
                                                                                    <Prefix ScanType="EQ">
                                                                                      <RangeColumns>
                                                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Object_ID" />
                                                                                      </RangeColumns>
                                                                                      <RangeExpressions>
                                                                                        <ScalarOperator ScalarString="[crm].[LSDBO].[Ric_Get_Select].[id] as [rw].[id]">
                                                                                          <Identifier>
                                                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                                                          </Identifier>
                                                                                        </ScalarOperator>
                                                                                      </RangeExpressions>
                                                                                    </Prefix>
                                                                                  </SeekPredicate>
                                                                                </SeekPredicates>
                                                                                <Predicate>
                                                                                  <ScalarOperator ScalarString="[crm].[LSDBO].[attrib_value].[Attrib_ID] as [av].[Attrib_ID]=(100005428000000.)">
                                                                                    <Compare CompareOp="EQ">
                                                                                      <ScalarOperator>
                                                                                        <Identifier>
                                                                                          <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                                                        </Identifier>
                                                                                      </ScalarOperator>
                                                                                      <ScalarOperator>
                                                                                        <Const ConstValue="(100005428000000.)" />
                                                                                      </ScalarOperator>
                                                                                    </Compare>
                                                                                  </ScalarOperator>
                                                                                </Predicate>
                                                                              </IndexScan>
                                                                            </RelOp>
                                                                            <RelOp AvgRowSize="1012" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0.383466" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="71" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0038094">
                                                                              <OutputList>
                                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="value" />
                                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="Value1" />
                                                                              </OutputList>
                                                                              <RunTimeInformation>
                                                                                <RunTimeCountersPerThread Thread="0" ActualRows="7208" ActualEndOfScans="0" ActualExecutions="7208" />
                                                                              </RunTimeInformation>
                                                                              <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                                                                                <DefinedValues>
                                                                                  <DefinedValue>
                                                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="value" />
                                                                                  </DefinedValue>
                                                                                  <DefinedValue>
                                                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="Value1" />
                                                                                  </DefinedValue>
                                                                                </DefinedValues>
                                                                                <Object Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Index="[PK__value_string__20CCCE1C]" Alias="[sv]" TableReferenceId="5" />
                                                                                <SeekPredicates>
                                                                                  <SeekPredicate>
                                                                                    <Prefix ScanType="EQ">
                                                                                      <RangeColumns>
                                                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="id" />
                                                                                      </RangeColumns>
                                                                                      <RangeExpressions>
                                                                                        <ScalarOperator ScalarString="[crm].[LSDBO].[attrib_value].[Value_ID] as [av].[Value_ID]">
                                                                                          <Identifier>
                                                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                                                          </Identifier>
                                                                                        </ScalarOperator>
                                                                                      </RangeExpressions>
                                                                                    </Prefix>
                                                                                  </SeekPredicate>
                                                                                </SeekPredicates>
                                                                              </IndexScan>
                                                                            </RelOp>
                                                                          </NestedLoops>
                                                                        </RelOp>
                                                                      </ComputeScalar>
                                                                    </RelOp>
                                                                  </NestedLoops>
                                                                </RelOp>
                                                                <RelOp AvgRowSize="1011" EstimateCPU="1.04746E-07" EstimateIO="0" EstimateRebinds="0.383466" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Compute Scalar" NodeId="75" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.00778685">
                                                                  <OutputList>
                                                                    <ColumnReference Column="Expr1064" />
                                                                  </OutputList>
                                                                  <ComputeScalar>
                                                                    <DefinedValues>
                                                                      <DefinedValue>
                                                                        <ColumnReference Column="Expr1064" />
                                                                        <ScalarOperator ScalarString="CASE WHEN [crm].[LSDBO].[value_string].[value] as [sv].[value] IS NOT NULL THEN [crm].[LSDBO].[value_string].[value] as [sv].[value] ELSE '' END+CASE WHEN [crm].[LSDBO].[value_string].[Value1] as [sv].[Value1] IS NOT NULL THEN [crm].[LSDBO].[value_string].[Value1] as [sv].[Value1] ELSE '' END">
                                                                          <Arithmetic Operation="ADD">
                                                                            <ScalarOperator>
                                                                              <IF>
                                                                                <Condition>
                                                                                  <ScalarOperator>
                                                                                    <Compare CompareOp="IS NOT">
                                                                                      <ScalarOperator>
                                                                                        <Identifier>
                                                                                          <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="value" />
                                                                                        </Identifier>
                                                                                      </ScalarOperator>
                                                                                      <ScalarOperator>
                                                                                        <Const ConstValue="NULL" />
                                                                                      </ScalarOperator>
                                                                                    </Compare>
                                                                                  </ScalarOperator>
                                                                                </Condition>
                                                                                <Then>
                                                                                  <ScalarOperator>
                                                                                    <Identifier>
                                                                                      <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="value" />
                                                                                    </Identifier>
                                                                                  </ScalarOperator>
                                                                                </Then>
                                                                                <Else>
                                                                                  <ScalarOperator>
                                                                                    <Const ConstValue="''" />
                                                                                  </ScalarOperator>
                                                                                </Else>
                                                                              </IF>
                                                                            </ScalarOperator>
                                                                            <ScalarOperator>
                                                                              <IF>
                                                                                <Condition>
                                                                                  <ScalarOperator>
                                                                                    <Compare CompareOp="IS NOT">
                                                                                      <ScalarOperator>
                                                                                        <Identifier>
                                                                                          <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="Value1" />
                                                                                        </Identifier>
                                                                                      </ScalarOperator>
                                                                                      <ScalarOperator>
                                                                                        <Const ConstValue="NULL" />
                                                                                      </ScalarOperator>
                                                                                    </Compare>
                                                                                  </ScalarOperator>
                                                                                </Condition>
                                                                                <Then>
                                                                                  <ScalarOperator>
                                                                                    <Identifier>
                                                                                      <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="Value1" />
                                                                                    </Identifier>
                                                                                  </ScalarOperator>
                                                                                </Then>
                                                                                <Else>
                                                                                  <ScalarOperator>
                                                                                    <Const ConstValue="''" />
                                                                                  </ScalarOperator>
                                                                                </Else>
                                                                              </IF>
                                                                            </ScalarOperator>
                                                                          </Arithmetic>
                                                                        </ScalarOperator>
                                                                      </DefinedValue>
                                                                    </DefinedValues>
                                                                    <RelOp AvgRowSize="1012" EstimateCPU="4.37839E-06" EstimateIO="0" EstimateRebinds="0.383466" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Left Outer Join" NodeId="76" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00778671">
                                                                      <OutputList>
                                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="value" />
                                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="Value1" />
                                                                      </OutputList>
                                                                      <RunTimeInformation>
                                                                        <RunTimeCountersPerThread Thread="0" ActualRows="7025" ActualEndOfScans="7208" ActualExecutions="7208" />
                                                                      </RunTimeInformation>
                                                                      <NestedLoops Optimized="true">
                                                                        <OuterReferences>
                                                                          <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                                        </OuterReferences>
                                                                        <RelOp AvgRowSize="25" EstimateCPU="0.000179384" EstimateIO="0.003125" EstimateRebinds="0.383466" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Clustered Index Seek" NodeId="78" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00383886">
                                                                          <OutputList>
                                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                                          </OutputList>
                                                                          <RunTimeInformation>
                                                                            <RunTimeCountersPerThread Thread="0" ActualRows="7025" ActualEndOfScans="7208" ActualExecutions="7208" />
                                                                          </RunTimeInformation>
                                                                          <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                                                                            <DefinedValues>
                                                                              <DefinedValue>
                                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                                              </DefinedValue>
                                                                              <DefinedValue>
                                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                                              </DefinedValue>
                                                                            </DefinedValues>
                                                                            <Object Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Index="[object_reference_ndx2]" Alias="[av]" TableReferenceId="8" />
                                                                            <SeekPredicates>
                                                                              <SeekPredicate>
                                                                                <Prefix ScanType="EQ">
                                                                                  <RangeColumns>
                                                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Object_ID" />
                                                                                  </RangeColumns>
                                                                                  <RangeExpressions>
                                                                                    <ScalarOperator ScalarString="[crm].[LSDBO].[Ric_Get_Select].[id] as [rw].[id]">
                                                                                      <Identifier>
                                                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                                                      </Identifier>
                                                                                    </ScalarOperator>
                                                                                  </RangeExpressions>
                                                                                </Prefix>
                                                                              </SeekPredicate>
                                                                            </SeekPredicates>
                                                                            <Predicate>
                                                                              <ScalarOperator ScalarString="[crm].[LSDBO].[attrib_value].[Attrib_ID] as [av].[Attrib_ID]=(100007986500005.)">
                                                                                <Compare CompareOp="EQ">
                                                                                  <ScalarOperator>
                                                                                    <Identifier>
                                                                                      <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                                                    </Identifier>
                                                                                  </ScalarOperator>
                                                                                  <ScalarOperator>
                                                                                    <Const ConstValue="(100007986500005.)" />
                                                                                  </ScalarOperator>
                                                                                </Compare>
                                                                              </ScalarOperator>
                                                                            </Predicate>
                                                                          </IndexScan>
                                                                        </RelOp>
                                                                        <RelOp AvgRowSize="1012" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0.449129" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="79" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00392828">
                                                                          <OutputList>
                                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="value" />
                                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="Value1" />
                                                                          </OutputList>
                                                                          <RunTimeInformation>
                                                                            <RunTimeCountersPerThread Thread="0" ActualRows="7025" ActualEndOfScans="0" ActualExecutions="7025" />
                                                                          </RunTimeInformation>
                                                                          <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                                                                            <DefinedValues>
                                                                              <DefinedValue>
                                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="value" />
                                                                              </DefinedValue>
                                                                              <DefinedValue>
                                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="Value1" />
                                                                              </DefinedValue>
                                                                            </DefinedValues>
                                                                            <Object Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Index="[PK__value_string__20CCCE1C]" Alias="[sv]" TableReferenceId="6" />
                                                                            <SeekPredicates>
                                                                              <SeekPredicate>
                                                                                <Prefix ScanType="EQ">
                                                                                  <RangeColumns>
                                                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_string]" Alias="[sv]" Column="id" />
                                                                                  </RangeColumns>
                                                                                  <RangeExpressions>
                                                                                    <ScalarOperator ScalarString="[crm].[LSDBO].[attrib_value].[Value_ID] as [av].[Value_ID]">
                                                                                      <Identifier>
                                                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                                                      </Identifier>
                                                                                    </ScalarOperator>
                                                                                  </RangeExpressions>
                                                                                </Prefix>
                                                                              </SeekPredicate>
                                                                            </SeekPredicates>
                                                                          </IndexScan>
                                                                        </RelOp>
                                                                      </NestedLoops>
                                                                    </RelOp>
                                                                  </ComputeScalar>
                                                                </RelOp>
                                                              </NestedLoops>
                                                            </RelOp>
                                                            <RelOp AvgRowSize="16" EstimateCPU="0.000179384" EstimateIO="0.003125" EstimateRebinds="0.449129" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Clustered Index Seek" NodeId="83" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00395913">
                                                              <OutputList>
                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                              </OutputList>
                                                              <RunTimeInformation>
                                                                <RunTimeCountersPerThread Thread="0" ActualRows="6957" ActualEndOfScans="7208" ActualExecutions="7208" />
                                                              </RunTimeInformation>
                                                              <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                                                                <DefinedValues>
                                                                  <DefinedValue>
                                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                                  </DefinedValue>
                                                                </DefinedValues>
                                                                <Object Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Index="[object_reference_ndx2]" Alias="[av]" TableReferenceId="9" />
                                                                <SeekPredicates>
                                                                  <SeekPredicate>
                                                                    <Prefix ScanType="EQ">
                                                                      <RangeColumns>
                                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Object_ID" />
                                                                      </RangeColumns>
                                                                      <RangeExpressions>
                                                                        <ScalarOperator ScalarString="[crm].[LSDBO].[Ric_Get_Select].[id] as [rw].[id]">
                                                                          <Identifier>
                                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                                          </Identifier>
                                                                        </ScalarOperator>
                                                                      </RangeExpressions>
                                                                    </Prefix>
                                                                  </SeekPredicate>
                                                                </SeekPredicates>
                                                                <Predicate>
                                                                  <ScalarOperator ScalarString="[crm].[LSDBO].[attrib_value].[Attrib_ID] as [av].[Attrib_ID]=(100003121500000.)">
                                                                    <Compare CompareOp="EQ">
                                                                      <ScalarOperator>
                                                                        <Identifier>
                                                                          <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                                        </Identifier>
                                                                      </ScalarOperator>
                                                                      <ScalarOperator>
                                                                        <Const ConstValue="(100003121500000.)" />
                                                                      </ScalarOperator>
                                                                    </Compare>
                                                                  </ScalarOperator>
                                                                </Predicate>
                                                              </IndexScan>
                                                            </RelOp>
                                                          </NestedLoops>
                                                        </RelOp>
                                                        <RelOp AvgRowSize="16" EstimateCPU="0.000179384" EstimateIO="0.003125" EstimateRebinds="0.517908" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Clustered Index Seek" NodeId="84" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0040884">
                                                          <OutputList>
                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                          </OutputList>
                                                          <RunTimeInformation>
                                                            <RunTimeCountersPerThread Thread="0" ActualRows="6996" ActualEndOfScans="7208" ActualExecutions="7208" />
                                                          </RunTimeInformation>
                                                          <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                                                            <DefinedValues>
                                                              <DefinedValue>
                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                              </DefinedValue>
                                                            </DefinedValues>
                                                            <Object Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Index="[object_reference_ndx2]" Alias="[av]" TableReferenceId="10" />
                                                            <SeekPredicates>
                                                              <SeekPredicate>
                                                                <Prefix ScanType="EQ">
                                                                  <RangeColumns>
                                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Object_ID" />
                                                                  </RangeColumns>
                                                                  <RangeExpressions>
                                                                    <ScalarOperator ScalarString="[crm].[LSDBO].[Ric_Get_Select].[id] as [rw].[id]">
                                                                      <Identifier>
                                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                                      </Identifier>
                                                                    </ScalarOperator>
                                                                  </RangeExpressions>
                                                                </Prefix>
                                                              </SeekPredicate>
                                                            </SeekPredicates>
                                                            <Predicate>
                                                              <ScalarOperator ScalarString="[crm].[LSDBO].[attrib_value].[Attrib_ID] as [av].[Attrib_ID]=(3000000000122.)">
                                                                <Compare CompareOp="EQ">
                                                                  <ScalarOperator>
                                                                    <Identifier>
                                                                      <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                                    </Identifier>
                                                                  </ScalarOperator>
                                                                  <ScalarOperator>
                                                                    <Const ConstValue="(3000000000122.)" />
                                                                  </ScalarOperator>
                                                                </Compare>
                                                              </ScalarOperator>
                                                            </Predicate>
                                                          </IndexScan>
                                                        </RelOp>
                                                      </NestedLoops>
                                                    </RelOp>
                                                    <RelOp AvgRowSize="15" EstimateCPU="1.04746E-07" EstimateIO="0" EstimateRebinds="0.589951" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Compute Scalar" NodeId="85" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.0085875">
                                                      <OutputList>
                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                                      </OutputList>
                                                      <ComputeScalar>
                                                        <DefinedValues>
                                                          <DefinedValue>
                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                                            <ScalarOperator ScalarString="[crm].[LSDBO].[value_numeric].[value] as [nv].[value]">
                                                              <Identifier>
                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                                              </Identifier>
                                                            </ScalarOperator>
                                                          </DefinedValue>
                                                        </DefinedValues>
                                                        <RelOp AvgRowSize="15" EstimateCPU="4.37839E-06" EstimateIO="0" EstimateRebinds="0.589951" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Left Outer Join" NodeId="86" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00858733">
                                                          <OutputList>
                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                                          </OutputList>
                                                          <RunTimeInformation>
                                                            <RunTimeCountersPerThread Thread="0" ActualRows="7208" ActualEndOfScans="7208" ActualExecutions="7208" />
                                                          </RunTimeInformation>
                                                          <NestedLoops Optimized="false">
                                                            <OuterReferences>
                                                              <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                            </OuterReferences>
                                                            <RelOp AvgRowSize="25" EstimateCPU="0.000179384" EstimateIO="0.003125" EstimateRebinds="0.589951" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Clustered Index Seek" NodeId="87" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00422661">
                                                              <OutputList>
                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                              </OutputList>
                                                              <RunTimeInformation>
                                                                <RunTimeCountersPerThread Thread="0" ActualRows="7208" ActualEndOfScans="7208" ActualExecutions="7208" />
                                                              </RunTimeInformation>
                                                              <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                                                                <DefinedValues>
                                                                  <DefinedValue>
                                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                                  </DefinedValue>
                                                                  <DefinedValue>
                                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                                  </DefinedValue>
                                                                </DefinedValues>
                                                                <Object Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Index="[object_reference_ndx2]" Alias="[av]" TableReferenceId="11" />
                                                                <SeekPredicates>
                                                                  <SeekPredicate>
                                                                    <Prefix ScanType="EQ">
                                                                      <RangeColumns>
                                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Object_ID" />
                                                                      </RangeColumns>
                                                                      <RangeExpressions>
                                                                        <ScalarOperator ScalarString="[crm].[LSDBO].[Ric_Get_Select].[id] as [rw].[id]">
                                                                          <Identifier>
                                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                                          </Identifier>
                                                                        </ScalarOperator>
                                                                      </RangeExpressions>
                                                                    </Prefix>
                                                                  </SeekPredicate>
                                                                </SeekPredicates>
                                                                <Predicate>
                                                                  <ScalarOperator ScalarString="[crm].[LSDBO].[attrib_value].[Attrib_ID] as [av].[Attrib_ID]=(100007971500005.)">
                                                                    <Compare CompareOp="EQ">
                                                                      <ScalarOperator>
                                                                        <Identifier>
                                                                          <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                                        </Identifier>
                                                                      </ScalarOperator>
                                                                      <ScalarOperator>
                                                                        <Const ConstValue="(100007971500005.)" />
                                                                      </ScalarOperator>
                                                                    </Compare>
                                                                  </ScalarOperator>
                                                                </Predicate>
                                                              </IndexScan>
                                                            </RelOp>
                                                            <RelOp AvgRowSize="15" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0.665414" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="88" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00433823">
                                                              <OutputList>
                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                                              </OutputList>
                                                              <RunTimeInformation>
                                                                <RunTimeCountersPerThread Thread="0" ActualRows="7208" ActualEndOfScans="0" ActualExecutions="7208" />
                                                              </RunTimeInformation>
                                                              <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                                                                <DefinedValues>
                                                                  <DefinedValue>
                                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                                                  </DefinedValue>
                                                                </DefinedValues>
                                                                <Object Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Index="[PK__value_numeric__1DF06171]" Alias="[nv]" TableReferenceId="2" />
                                                                <SeekPredicates>
                                                                  <SeekPredicate>
                                                                    <Prefix ScanType="EQ">
                                                                      <RangeColumns>
                                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="id" />
                                                                      </RangeColumns>
                                                                      <RangeExpressions>
                                                                        <ScalarOperator ScalarString="[crm].[LSDBO].[attrib_value].[Value_ID] as [av].[Value_ID]">
                                                                          <Identifier>
                                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                                          </Identifier>
                                                                        </ScalarOperator>
                                                                      </RangeExpressions>
                                                                    </Prefix>
                                                                  </SeekPredicate>
                                                                </SeekPredicates>
                                                              </IndexScan>
                                                            </RelOp>
                                                          </NestedLoops>
                                                        </RelOp>
                                                      </ComputeScalar>
                                                    </RelOp>
                                                  </NestedLoops>
                                                </RelOp>
                                                <RelOp AvgRowSize="15" EstimateCPU="1.04746E-07" EstimateIO="0" EstimateRebinds="0.665414" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Compute Scalar" NodeId="92" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.00889044">
                                                  <OutputList>
                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                                  </OutputList>
                                                  <ComputeScalar>
                                                    <DefinedValues>
                                                      <DefinedValue>
                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                                        <ScalarOperator ScalarString="[crm].[LSDBO].[value_numeric].[value] as [nv].[value]">
                                                          <Identifier>
                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                                          </Identifier>
                                                        </ScalarOperator>
                                                      </DefinedValue>
                                                    </DefinedValues>
                                                    <RelOp AvgRowSize="15" EstimateCPU="4.37839E-06" EstimateIO="0" EstimateRebinds="0.665414" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Left Outer Join" NodeId="93" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00889026">
                                                      <OutputList>
                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                                      </OutputList>
                                                      <RunTimeInformation>
                                                        <RunTimeCountersPerThread Thread="0" ActualRows="5461" ActualEndOfScans="7208" ActualExecutions="7208" />
                                                      </RunTimeInformation>
                                                      <NestedLoops Optimized="false">
                                                        <OuterReferences>
                                                          <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                        </OuterReferences>
                                                        <RelOp AvgRowSize="25" EstimateCPU="0.000179384" EstimateIO="0.003125" EstimateRebinds="0.665414" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Clustered Index Seek" NodeId="94" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00437383">
                                                          <OutputList>
                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                          </OutputList>
                                                          <RunTimeInformation>
                                                            <RunTimeCountersPerThread Thread="0" ActualRows="5461" ActualEndOfScans="7208" ActualExecutions="7208" />
                                                          </RunTimeInformation>
                                                          <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                                                            <DefinedValues>
                                                              <DefinedValue>
                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                              </DefinedValue>
                                                              <DefinedValue>
                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                              </DefinedValue>
                                                            </DefinedValues>
                                                            <Object Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Index="[object_reference_ndx2]" Alias="[av]" TableReferenceId="12" />
                                                            <SeekPredicates>
                                                              <SeekPredicate>
                                                                <Prefix ScanType="EQ">
                                                                  <RangeColumns>
                                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Object_ID" />
                                                                  </RangeColumns>
                                                                  <RangeExpressions>
                                                                    <ScalarOperator ScalarString="[crm].[LSDBO].[Ric_Get_Select].[id] as [rw].[id]">
                                                                      <Identifier>
                                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                                      </Identifier>
                                                                    </ScalarOperator>
                                                                  </RangeExpressions>
                                                                </Prefix>
                                                              </SeekPredicate>
                                                            </SeekPredicates>
                                                            <Predicate>
                                                              <ScalarOperator ScalarString="[crm].[LSDBO].[attrib_value].[Attrib_ID] as [av].[Attrib_ID]=(100038030700000.)">
                                                                <Compare CompareOp="EQ">
                                                                  <ScalarOperator>
                                                                    <Identifier>
                                                                      <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                                    </Identifier>
                                                                  </ScalarOperator>
                                                                  <ScalarOperator>
                                                                    <Const ConstValue="(100038030700000.)" />
                                                                  </ScalarOperator>
                                                                </Compare>
                                                              </ScalarOperator>
                                                            </Predicate>
                                                          </IndexScan>
                                                        </RelOp>
                                                        <RelOp AvgRowSize="15" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0.744458" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="95" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00449287">
                                                          <OutputList>
                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                                          </OutputList>
                                                          <RunTimeInformation>
                                                            <RunTimeCountersPerThread Thread="0" ActualRows="5461" ActualEndOfScans="0" ActualExecutions="5461" />
                                                          </RunTimeInformation>
                                                          <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                                                            <DefinedValues>
                                                              <DefinedValue>
                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                                              </DefinedValue>
                                                            </DefinedValues>
                                                            <Object Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Index="[PK__value_numeric__1DF06171]" Alias="[nv]" TableReferenceId="3" />
                                                            <SeekPredicates>
                                                              <SeekPredicate>
                                                                <Prefix ScanType="EQ">
                                                                  <RangeColumns>
                                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="id" />
                                                                  </RangeColumns>
                                                                  <RangeExpressions>
                                                                    <ScalarOperator ScalarString="[crm].[LSDBO].[attrib_value].[Value_ID] as [av].[Value_ID]">
                                                                      <Identifier>
                                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                                      </Identifier>
                                                                    </ScalarOperator>
                                                                  </RangeExpressions>
                                                                </Prefix>
                                                              </SeekPredicate>
                                                            </SeekPredicates>
                                                          </IndexScan>
                                                        </RelOp>
                                                      </NestedLoops>
                                                    </RelOp>
                                                  </ComputeScalar>
                                                </RelOp>
                                              </NestedLoops>
                                            </RelOp>
                                            <RelOp AvgRowSize="15" EstimateCPU="1.04746E-07" EstimateIO="0" EstimateRebinds="0.744458" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Compute Scalar" NodeId="99" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.00921179">
                                              <OutputList>
                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                              </OutputList>
                                              <ComputeScalar>
                                                <DefinedValues>
                                                  <DefinedValue>
                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                                    <ScalarOperator ScalarString="[crm].[LSDBO].[value_numeric].[value] as [nv].[value]">
                                                      <Identifier>
                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                                      </Identifier>
                                                    </ScalarOperator>
                                                  </DefinedValue>
                                                </DefinedValues>
                                                <RelOp AvgRowSize="15" EstimateCPU="4.37839E-06" EstimateIO="0" EstimateRebinds="0.744458" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Left Outer Join" NodeId="100" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00921161">
                                                  <OutputList>
                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                                  </OutputList>
                                                  <RunTimeInformation>
                                                    <RunTimeCountersPerThread Thread="0" ActualRows="5525" ActualEndOfScans="7208" ActualExecutions="7208" />
                                                  </RunTimeInformation>
                                                  <NestedLoops Optimized="false">
                                                    <OuterReferences>
                                                      <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                    </OuterReferences>
                                                    <RelOp AvgRowSize="25" EstimateCPU="0.000179384" EstimateIO="0.003125" EstimateRebinds="0.744458" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Clustered Index Seek" NodeId="101" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00453018">
                                                      <OutputList>
                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                      </OutputList>
                                                      <RunTimeInformation>
                                                        <RunTimeCountersPerThread Thread="0" ActualRows="5525" ActualEndOfScans="7208" ActualExecutions="7208" />
                                                      </RunTimeInformation>
                                                      <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                                                        <DefinedValues>
                                                          <DefinedValue>
                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                          </DefinedValue>
                                                          <DefinedValue>
                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                          </DefinedValue>
                                                        </DefinedValues>
                                                        <Object Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Index="[object_reference_ndx2]" Alias="[av]" TableReferenceId="13" />
                                                        <SeekPredicates>
                                                          <SeekPredicate>
                                                            <Prefix ScanType="EQ">
                                                              <RangeColumns>
                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Object_ID" />
                                                              </RangeColumns>
                                                              <RangeExpressions>
                                                                <ScalarOperator ScalarString="[crm].[LSDBO].[Ric_Get_Select].[id] as [rw].[id]">
                                                                  <Identifier>
                                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                                  </Identifier>
                                                                </ScalarOperator>
                                                              </RangeExpressions>
                                                            </Prefix>
                                                          </SeekPredicate>
                                                        </SeekPredicates>
                                                        <Predicate>
                                                          <ScalarOperator ScalarString="[crm].[LSDBO].[attrib_value].[Attrib_ID] as [av].[Attrib_ID]=(3000000000103.)">
                                                            <Compare CompareOp="EQ">
                                                              <ScalarOperator>
                                                                <Identifier>
                                                                  <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                                </Identifier>
                                                              </ScalarOperator>
                                                              <ScalarOperator>
                                                                <Const ConstValue="(3000000000103.)" />
                                                              </ScalarOperator>
                                                            </Compare>
                                                          </ScalarOperator>
                                                        </Predicate>
                                                      </IndexScan>
                                                    </RelOp>
                                                    <RelOp AvgRowSize="15" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0.827254" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="102" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00465675">
                                                      <OutputList>
                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                                      </OutputList>
                                                      <RunTimeInformation>
                                                        <RunTimeCountersPerThread Thread="0" ActualRows="5525" ActualEndOfScans="0" ActualExecutions="5525" />
                                                      </RunTimeInformation>
                                                      <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                                                        <DefinedValues>
                                                          <DefinedValue>
                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                                          </DefinedValue>
                                                        </DefinedValues>
                                                        <Object Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Index="[PK__value_numeric__1DF06171]" Alias="[nv]" TableReferenceId="4" />
                                                        <SeekPredicates>
                                                          <SeekPredicate>
                                                            <Prefix ScanType="EQ">
                                                              <RangeColumns>
                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="id" />
                                                              </RangeColumns>
                                                              <RangeExpressions>
                                                                <ScalarOperator ScalarString="[crm].[LSDBO].[attrib_value].[Value_ID] as [av].[Value_ID]">
                                                                  <Identifier>
                                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                                  </Identifier>
                                                                </ScalarOperator>
                                                              </RangeExpressions>
                                                            </Prefix>
                                                          </SeekPredicate>
                                                        </SeekPredicates>
                                                      </IndexScan>
                                                    </RelOp>
                                                  </NestedLoops>
                                                </RelOp>
                                              </ComputeScalar>
                                            </RelOp>
                                          </NestedLoops>
                                        </RelOp>
                                        <RelOp AvgRowSize="15" EstimateCPU="1.04746E-07" EstimateIO="0" EstimateRebinds="0.827254" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Compute Scalar" NodeId="106" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.00955207">
                                          <OutputList>
                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_datetime]" Alias="[dv]" Column="value" />
                                          </OutputList>
                                          <ComputeScalar>
                                            <DefinedValues>
                                              <DefinedValue>
                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_datetime]" Alias="[dv]" Column="value" />
                                                <ScalarOperator ScalarString="[crm].[LSDBO].[value_datetime].[value] as [dv].[value]">
                                                  <Identifier>
                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_datetime]" Alias="[dv]" Column="value" />
                                                  </Identifier>
                                                </ScalarOperator>
                                              </DefinedValue>
                                            </DefinedValues>
                                            <RelOp AvgRowSize="15" EstimateCPU="4.37839E-06" EstimateIO="0" EstimateRebinds="0.827254" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Left Outer Join" NodeId="107" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00955188">
                                              <OutputList>
                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_datetime]" Alias="[dv]" Column="value" />
                                              </OutputList>
                                              <RunTimeInformation>
                                                <RunTimeCountersPerThread Thread="0" ActualRows="36" ActualEndOfScans="7208" ActualExecutions="7208" />
                                              </RunTimeInformation>
                                              <NestedLoops Optimized="true">
                                                <OuterReferences>
                                                  <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                </OuterReferences>
                                                <RelOp AvgRowSize="25" EstimateCPU="0.000179384" EstimateIO="0.003125" EstimateRebinds="0.827254" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Clustered Index Seek" NodeId="109" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00469585">
                                                  <OutputList>
                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                  </OutputList>
                                                  <RunTimeInformation>
                                                    <RunTimeCountersPerThread Thread="0" ActualRows="36" ActualEndOfScans="7208" ActualExecutions="7208" />
                                                  </RunTimeInformation>
                                                  <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                                                    <DefinedValues>
                                                      <DefinedValue>
                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                      </DefinedValue>
                                                      <DefinedValue>
                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                      </DefinedValue>
                                                    </DefinedValues>
                                                    <Object Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Index="[object_reference_ndx2]" Alias="[av]" TableReferenceId="14" />
                                                    <SeekPredicates>
                                                      <SeekPredicate>
                                                        <Prefix ScanType="EQ">
                                                          <RangeColumns>
                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Object_ID" />
                                                          </RangeColumns>
                                                          <RangeExpressions>
                                                            <ScalarOperator ScalarString="[crm].[LSDBO].[Ric_Get_Select].[id] as [rw].[id]">
                                                              <Identifier>
                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                              </Identifier>
                                                            </ScalarOperator>
                                                          </RangeExpressions>
                                                        </Prefix>
                                                      </SeekPredicate>
                                                    </SeekPredicates>
                                                    <Predicate>
                                                      <ScalarOperator ScalarString="[crm].[LSDBO].[attrib_value].[Attrib_ID] as [av].[Attrib_ID]=(3000000000108.)">
                                                        <Compare CompareOp="EQ">
                                                          <ScalarOperator>
                                                            <Identifier>
                                                              <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                            </Identifier>
                                                          </ScalarOperator>
                                                          <ScalarOperator>
                                                            <Const ConstValue="(3000000000108.)" />
                                                          </ScalarOperator>
                                                        </Compare>
                                                      </ScalarOperator>
                                                    </Predicate>
                                                  </IndexScan>
                                                </RelOp>
                                                <RelOp AvgRowSize="15" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0.913979" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="110" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00483018">
                                                  <OutputList>
                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_datetime]" Alias="[dv]" Column="value" />
                                                  </OutputList>
                                                  <RunTimeInformation>
                                                    <RunTimeCountersPerThread Thread="0" ActualRows="36" ActualEndOfScans="0" ActualExecutions="36" />
                                                  </RunTimeInformation>
                                                  <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                                                    <DefinedValues>
                                                      <DefinedValue>
                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_datetime]" Alias="[dv]" Column="value" />
                                                      </DefinedValue>
                                                    </DefinedValues>
                                                    <Object Database="[crm]" Schema="[LSDBO]" Table="[value_datetime]" Index="[PK__value_datetime__1B13F4C6]" Alias="[dv]" TableReferenceId="2" />
                                                    <SeekPredicates>
                                                      <SeekPredicate>
                                                        <Prefix ScanType="EQ">
                                                          <RangeColumns>
                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_datetime]" Alias="[dv]" Column="id" />
                                                          </RangeColumns>
                                                          <RangeExpressions>
                                                            <ScalarOperator ScalarString="[crm].[LSDBO].[attrib_value].[Value_ID] as [av].[Value_ID]">
                                                              <Identifier>
                                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                              </Identifier>
                                                            </ScalarOperator>
                                                          </RangeExpressions>
                                                        </Prefix>
                                                      </SeekPredicate>
                                                    </SeekPredicates>
                                                  </IndexScan>
                                                </RelOp>
                                              </NestedLoops>
                                            </RelOp>
                                          </ComputeScalar>
                                        </RelOp>
                                      </NestedLoops>
                                    </RelOp>
                                    <RelOp AvgRowSize="15" EstimateCPU="1.04746E-07" EstimateIO="0" EstimateRebinds="0.913979" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Compute Scalar" NodeId="114" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.0099115">
                                      <OutputList>
                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                      </OutputList>
                                      <ComputeScalar>
                                        <DefinedValues>
                                          <DefinedValue>
                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                            <ScalarOperator ScalarString="[crm].[LSDBO].[value_numeric].[value] as [nv].[value]">
                                              <Identifier>
                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                              </Identifier>
                                            </ScalarOperator>
                                          </DefinedValue>
                                        </DefinedValues>
                                        <RelOp AvgRowSize="15" EstimateCPU="4.37839E-06" EstimateIO="0" EstimateRebinds="0.913979" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Left Outer Join" NodeId="115" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0099113">
                                          <OutputList>
                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                          </OutputList>
                                          <RunTimeInformation>
                                            <RunTimeCountersPerThread Thread="0" ActualRows="7208" ActualEndOfScans="7208" ActualExecutions="7208" />
                                          </RunTimeInformation>
                                          <NestedLoops Optimized="false">
                                            <OuterReferences>
                                              <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                            </OuterReferences>
                                            <RelOp AvgRowSize="25" EstimateCPU="0.000179384" EstimateIO="0.003125" EstimateRebinds="0.913979" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Clustered Index Seek" NodeId="116" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00487107">
                                              <OutputList>
                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                              </OutputList>
                                              <RunTimeInformation>
                                                <RunTimeCountersPerThread Thread="0" ActualRows="7208" ActualEndOfScans="7208" ActualExecutions="7208" />
                                              </RunTimeInformation>
                                              <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                                                <DefinedValues>
                                                  <DefinedValue>
                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                  </DefinedValue>
                                                  <DefinedValue>
                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                  </DefinedValue>
                                                </DefinedValues>
                                                <Object Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Index="[object_reference_ndx2]" Alias="[av]" TableReferenceId="15" />
                                                <SeekPredicates>
                                                  <SeekPredicate>
                                                    <Prefix ScanType="EQ">
                                                      <RangeColumns>
                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Object_ID" />
                                                      </RangeColumns>
                                                      <RangeExpressions>
                                                        <ScalarOperator ScalarString="[crm].[LSDBO].[Ric_Get_Select].[id] as [rw].[id]">
                                                          <Identifier>
                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                          </Identifier>
                                                        </ScalarOperator>
                                                      </RangeExpressions>
                                                    </Prefix>
                                                  </SeekPredicate>
                                                </SeekPredicates>
                                                <Predicate>
                                                  <ScalarOperator ScalarString="[crm].[LSDBO].[attrib_value].[Attrib_ID] as [av].[Attrib_ID]=(100000648000000.)">
                                                    <Compare CompareOp="EQ">
                                                      <ScalarOperator>
                                                        <Identifier>
                                                          <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                        </Identifier>
                                                      </ScalarOperator>
                                                      <ScalarOperator>
                                                        <Const ConstValue="(100000648000000.)" />
                                                      </ScalarOperator>
                                                    </Compare>
                                                  </ScalarOperator>
                                                </Predicate>
                                              </IndexScan>
                                            </RelOp>
                                            <RelOp AvgRowSize="15" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="1.00482" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="117" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00501315">
                                              <OutputList>
                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                              </OutputList>
                                              <RunTimeInformation>
                                                <RunTimeCountersPerThread Thread="0" ActualRows="7208" ActualEndOfScans="0" ActualExecutions="7208" />
                                              </RunTimeInformation>
                                              <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                                                <DefinedValues>
                                                  <DefinedValue>
                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                                  </DefinedValue>
                                                </DefinedValues>
                                                <Object Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Index="[PK__value_numeric__1DF06171]" Alias="[nv]" TableReferenceId="5" />
                                                <SeekPredicates>
                                                  <SeekPredicate>
                                                    <Prefix ScanType="EQ">
                                                      <RangeColumns>
                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="id" />
                                                      </RangeColumns>
                                                      <RangeExpressions>
                                                        <ScalarOperator ScalarString="[crm].[LSDBO].[attrib_value].[Value_ID] as [av].[Value_ID]">
                                                          <Identifier>
                                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                          </Identifier>
                                                        </ScalarOperator>
                                                      </RangeExpressions>
                                                    </Prefix>
                                                  </SeekPredicate>
                                                </SeekPredicates>
                                              </IndexScan>
                                            </RelOp>
                                          </NestedLoops>
                                        </RelOp>
                                      </ComputeScalar>
                                    </RelOp>
                                  </NestedLoops>
                                </RelOp>
                                <RelOp AvgRowSize="15" EstimateCPU="1.04746E-07" EstimateIO="0" EstimateRebinds="1.00482" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Compute Scalar" NodeId="121" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.0102909">
                                  <OutputList>
                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                  </OutputList>
                                  <ComputeScalar>
                                    <DefinedValues>
                                      <DefinedValue>
                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                        <ScalarOperator ScalarString="[crm].[LSDBO].[value_numeric].[value] as [nv].[value]">
                                          <Identifier>
                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                          </Identifier>
                                        </ScalarOperator>
                                      </DefinedValue>
                                    </DefinedValues>
                                    <RelOp AvgRowSize="15" EstimateCPU="4.37839E-06" EstimateIO="0" EstimateRebinds="1.00482" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Left Outer Join" NodeId="122" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0102907">
                                      <OutputList>
                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                      </OutputList>
                                      <RunTimeInformation>
                                        <RunTimeCountersPerThread Thread="0" ActualRows="7208" ActualEndOfScans="7208" ActualExecutions="7208" />
                                      </RunTimeInformation>
                                      <NestedLoops Optimized="false">
                                        <OuterReferences>
                                          <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                        </OuterReferences>
                                        <RelOp AvgRowSize="25" EstimateCPU="0.000179384" EstimateIO="0.003125" EstimateRebinds="1.00482" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Clustered Index Seek" NodeId="123" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00505611">
                                          <OutputList>
                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                          </OutputList>
                                          <RunTimeInformation>
                                            <RunTimeCountersPerThread Thread="0" ActualRows="7208" ActualEndOfScans="7208" ActualExecutions="7208" />
                                          </RunTimeInformation>
                                          <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                                            <DefinedValues>
                                              <DefinedValue>
                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                              </DefinedValue>
                                              <DefinedValue>
                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                              </DefinedValue>
                                            </DefinedValues>
                                            <Object Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Index="[object_reference_ndx2]" Alias="[av]" TableReferenceId="16" />
                                            <SeekPredicates>
                                              <SeekPredicate>
                                                <Prefix ScanType="EQ">
                                                  <RangeColumns>
                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Object_ID" />
                                                  </RangeColumns>
                                                  <RangeExpressions>
                                                    <ScalarOperator ScalarString="[crm].[LSDBO].[Ric_Get_Select].[id] as [rw].[id]">
                                                      <Identifier>
                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                      </Identifier>
                                                    </ScalarOperator>
                                                  </RangeExpressions>
                                                </Prefix>
                                              </SeekPredicate>
                                            </SeekPredicates>
                                            <Predicate>
                                              <ScalarOperator ScalarString="[crm].[LSDBO].[attrib_value].[Attrib_ID] as [av].[Attrib_ID]=(100004081600000.)">
                                                <Compare CompareOp="EQ">
                                                  <ScalarOperator>
                                                    <Identifier>
                                                      <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                    </Identifier>
                                                  </ScalarOperator>
                                                  <ScalarOperator>
                                                    <Const ConstValue="(100004081600000.)" />
                                                  </ScalarOperator>
                                                </Compare>
                                              </ScalarOperator>
                                            </Predicate>
                                          </IndexScan>
                                        </RelOp>
                                        <RelOp AvgRowSize="15" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="1.09997" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="124" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00520626">
                                          <OutputList>
                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                          </OutputList>
                                          <RunTimeInformation>
                                            <RunTimeCountersPerThread Thread="0" ActualRows="7208" ActualEndOfScans="0" ActualExecutions="7208" />
                                          </RunTimeInformation>
                                          <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                                            <DefinedValues>
                                              <DefinedValue>
                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                              </DefinedValue>
                                            </DefinedValues>
                                            <Object Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Index="[PK__value_numeric__1DF06171]" Alias="[nv]" TableReferenceId="6" />
                                            <SeekPredicates>
                                              <SeekPredicate>
                                                <Prefix ScanType="EQ">
                                                  <RangeColumns>
                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="id" />
                                                  </RangeColumns>
                                                  <RangeExpressions>
                                                    <ScalarOperator ScalarString="[crm].[LSDBO].[attrib_value].[Value_ID] as [av].[Value_ID]">
                                                      <Identifier>
                                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                      </Identifier>
                                                    </ScalarOperator>
                                                  </RangeExpressions>
                                                </Prefix>
                                              </SeekPredicate>
                                            </SeekPredicates>
                                          </IndexScan>
                                        </RelOp>
                                      </NestedLoops>
                                    </RelOp>
                                  </ComputeScalar>
                                </RelOp>
                              </NestedLoops>
                            </RelOp>
                            <RelOp AvgRowSize="15" EstimateCPU="1.04746E-07" EstimateIO="0" EstimateRebinds="1.09997" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Compute Scalar" NodeId="128" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.010691">
                              <OutputList>
                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                              </OutputList>
                              <ComputeScalar>
                                <DefinedValues>
                                  <DefinedValue>
                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                    <ScalarOperator ScalarString="[crm].[LSDBO].[value_numeric].[value] as [nv].[value]">
                                      <Identifier>
                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                      </Identifier>
                                    </ScalarOperator>
                                  </DefinedValue>
                                </DefinedValues>
                                <RelOp AvgRowSize="15" EstimateCPU="4.37839E-06" EstimateIO="0" EstimateRebinds="1.09997" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Left Outer Join" NodeId="129" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0106908">
                                  <OutputList>
                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                  </OutputList>
                                  <RunTimeInformation>
                                    <RunTimeCountersPerThread Thread="0" ActualRows="7208" ActualEndOfScans="7208" ActualExecutions="7208" />
                                  </RunTimeInformation>
                                  <NestedLoops Optimized="false">
                                    <OuterReferences>
                                      <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                    </OuterReferences>
                                    <RelOp AvgRowSize="25" EstimateCPU="0.000179384" EstimateIO="0.003125" EstimateRebinds="1.09997" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Clustered Index Seek" NodeId="130" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00525129">
                                      <OutputList>
                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                      </OutputList>
                                      <RunTimeInformation>
                                        <RunTimeCountersPerThread Thread="0" ActualRows="7208" ActualEndOfScans="7208" ActualExecutions="7208" />
                                      </RunTimeInformation>
                                      <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                                        <DefinedValues>
                                          <DefinedValue>
                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                          </DefinedValue>
                                          <DefinedValue>
                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                          </DefinedValue>
                                        </DefinedValues>
                                        <Object Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Index="[object_reference_ndx2]" Alias="[av]" TableReferenceId="17" />
                                        <SeekPredicates>
                                          <SeekPredicate>
                                            <Prefix ScanType="EQ">
                                              <RangeColumns>
                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Object_ID" />
                                              </RangeColumns>
                                              <RangeExpressions>
                                                <ScalarOperator ScalarString="[crm].[LSDBO].[Ric_Get_Select].[id] as [rw].[id]">
                                                  <Identifier>
                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                                  </Identifier>
                                                </ScalarOperator>
                                              </RangeExpressions>
                                            </Prefix>
                                          </SeekPredicate>
                                        </SeekPredicates>
                                        <Predicate>
                                          <ScalarOperator ScalarString="[crm].[LSDBO].[attrib_value].[Attrib_ID] as [av].[Attrib_ID]=(100004087100000.)">
                                            <Compare CompareOp="EQ">
                                              <ScalarOperator>
                                                <Identifier>
                                                  <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                                </Identifier>
                                              </ScalarOperator>
                                              <ScalarOperator>
                                                <Const ConstValue="(100004087100000.)" />
                                              </ScalarOperator>
                                            </Compare>
                                          </ScalarOperator>
                                        </Predicate>
                                      </IndexScan>
                                    </RelOp>
                                    <RelOp AvgRowSize="15" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="1.19964" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="131" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00540976">
                                      <OutputList>
                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                      </OutputList>
                                      <RunTimeInformation>
                                        <RunTimeCountersPerThread Thread="0" ActualRows="7208" ActualEndOfScans="0" ActualExecutions="7208" />
                                      </RunTimeInformation>
                                      <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                                        <DefinedValues>
                                          <DefinedValue>
                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                          </DefinedValue>
                                        </DefinedValues>
                                        <Object Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Index="[PK__value_numeric__1DF06171]" Alias="[nv]" TableReferenceId="7" />
                                        <SeekPredicates>
                                          <SeekPredicate>
                                            <Prefix ScanType="EQ">
                                              <RangeColumns>
                                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="id" />
                                              </RangeColumns>
                                              <RangeExpressions>
                                                <ScalarOperator ScalarString="[crm].[LSDBO].[attrib_value].[Value_ID] as [av].[Value_ID]">
                                                  <Identifier>
                                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                                  </Identifier>
                                                </ScalarOperator>
                                              </RangeExpressions>
                                            </Prefix>
                                          </SeekPredicate>
                                        </SeekPredicates>
                                      </IndexScan>
                                    </RelOp>
                                  </NestedLoops>
                                </RelOp>
                              </ComputeScalar>
                            </RelOp>
                          </NestedLoops>
                        </RelOp>
                        <RelOp AvgRowSize="16" EstimateCPU="0.000179384" EstimateIO="0.003125" EstimateRebinds="1.19964" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Clustered Index Seek" NodeId="135" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00545696">
                          <OutputList>
                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                          </OutputList>
                          <RunTimeInformation>
                            <RunTimeCountersPerThread Thread="0" ActualRows="6778" ActualEndOfScans="7208" ActualExecutions="7208" />
                          </RunTimeInformation>
                          <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                            <DefinedValues>
                              <DefinedValue>
                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                              </DefinedValue>
                            </DefinedValues>
                            <Object Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Index="[object_reference_ndx2]" Alias="[av]" TableReferenceId="18" />
                            <SeekPredicates>
                              <SeekPredicate>
                                <Prefix ScanType="EQ">
                                  <RangeColumns>
                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Object_ID" />
                                  </RangeColumns>
                                  <RangeExpressions>
                                    <ScalarOperator ScalarString="[crm].[LSDBO].[Ric_Get_Select].[id] as [rw].[id]">
                                      <Identifier>
                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                      </Identifier>
                                    </ScalarOperator>
                                  </RangeExpressions>
                                </Prefix>
                              </SeekPredicate>
                            </SeekPredicates>
                            <Predicate>
                              <ScalarOperator ScalarString="[crm].[LSDBO].[attrib_value].[Attrib_ID] as [av].[Attrib_ID]=(9.)">
                                <Compare CompareOp="EQ">
                                  <ScalarOperator>
                                    <Identifier>
                                      <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                    </Identifier>
                                  </ScalarOperator>
                                  <ScalarOperator>
                                    <Const ConstValue="(9.)" />
                                  </ScalarOperator>
                                </Compare>
                              </ScalarOperator>
                            </Predicate>
                          </IndexScan>
                        </RelOp>
                      </NestedLoops>
                    </RelOp>
                    <RelOp AvgRowSize="15" EstimateCPU="1.04746E-07" EstimateIO="0" EstimateRebinds="1.30404" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Compute Scalar" NodeId="136" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.0115558">
                      <OutputList>
                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                      </OutputList>
                      <ComputeScalar>
                        <DefinedValues>
                          <DefinedValue>
                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                            <ScalarOperator ScalarString="[crm].[LSDBO].[value_numeric].[value] as [nv].[value]">
                              <Identifier>
                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                              </Identifier>
                            </ScalarOperator>
                          </DefinedValue>
                        </DefinedValues>
                        <RelOp AvgRowSize="15" EstimateCPU="4.37839E-06" EstimateIO="0" EstimateRebinds="1.30404" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Left Outer Join" NodeId="137" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0115556">
                          <OutputList>
                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                          </OutputList>
                          <RunTimeInformation>
                            <RunTimeCountersPerThread Thread="0" ActualRows="6957" ActualEndOfScans="7208" ActualExecutions="7208" />
                          </RunTimeInformation>
                          <NestedLoops Optimized="false">
                            <OuterReferences>
                              <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                            </OuterReferences>
                            <RelOp AvgRowSize="25" EstimateCPU="0.000179384" EstimateIO="0.003125" EstimateRebinds="1.30404" EstimateRewinds="0" EstimateRows="1.04746" LogicalOp="Clustered Index Seek" NodeId="138" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00567351">
                              <OutputList>
                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                              </OutputList>
                              <RunTimeInformation>
                                <RunTimeCountersPerThread Thread="0" ActualRows="6957" ActualEndOfScans="7208" ActualExecutions="7208" />
                              </RunTimeInformation>
                              <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                                <DefinedValues>
                                  <DefinedValue>
                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                  </DefinedValue>
                                  <DefinedValue>
                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                  </DefinedValue>
                                </DefinedValues>
                                <Object Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Index="[object_reference_ndx2]" Alias="[av]" TableReferenceId="19" />
                                <SeekPredicates>
                                  <SeekPredicate>
                                    <Prefix ScanType="EQ">
                                      <RangeColumns>
                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Object_ID" />
                                      </RangeColumns>
                                      <RangeExpressions>
                                        <ScalarOperator ScalarString="[crm].[LSDBO].[Ric_Get_Select].[id] as [rw].[id]">
                                          <Identifier>
                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[Ric_Get_Select]" Alias="[rw]" Column="id" />
                                          </Identifier>
                                        </ScalarOperator>
                                      </RangeExpressions>
                                    </Prefix>
                                  </SeekPredicate>
                                </SeekPredicates>
                                <Predicate>
                                  <ScalarOperator ScalarString="[crm].[LSDBO].[attrib_value].[Attrib_ID] as [av].[Attrib_ID]=(100004060300000.)">
                                    <Compare CompareOp="EQ">
                                      <ScalarOperator>
                                        <Identifier>
                                          <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Attrib_ID" />
                                        </Identifier>
                                      </ScalarOperator>
                                      <ScalarOperator>
                                        <Const ConstValue="(100004060300000.)" />
                                      </ScalarOperator>
                                    </Compare>
                                  </ScalarOperator>
                                </Predicate>
                              </IndexScan>
                            </RelOp>
                            <RelOp AvgRowSize="15" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="1.4134" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="139" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00584947">
                              <OutputList>
                                <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                              </OutputList>
                              <RunTimeInformation>
                                <RunTimeCountersPerThread Thread="0" ActualRows="6957" ActualEndOfScans="0" ActualExecutions="6957" />
                              </RunTimeInformation>
                              <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                                <DefinedValues>
                                  <DefinedValue>
                                    <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="value" />
                                  </DefinedValue>
                                </DefinedValues>
                                <Object Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Index="[PK__value_numeric__1DF06171]" Alias="[nv]" TableReferenceId="8" />
                                <SeekPredicates>
                                  <SeekPredicate>
                                    <Prefix ScanType="EQ">
                                      <RangeColumns>
                                        <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[value_numeric]" Alias="[nv]" Column="id" />
                                      </RangeColumns>
                                      <RangeExpressions>
                                        <ScalarOperator ScalarString="[crm].[LSDBO].[attrib_value].[Value_ID] as [av].[Value_ID]">
                                          <Identifier>
                                            <ColumnReference Database="[crm]" Schema="[LSDBO]" Table="[attrib_value]" Alias="[av]" Column="Value_ID" />
                                          </Identifier>
                                        </ScalarOperator>
                                      </RangeExpressions>
                                    </Prefix>
                                  </SeekPredicate>
                                </SeekPredicates>
                              </IndexScan>
                            </RelOp>
                          </NestedLoops>
                        </RelOp>
                      </ComputeScalar>
                    </RelOp>
                  </NestedLoops>
                </RelOp>
              </Sequence>
            </RelOp>
          </QueryPlan>
        </StmtSimple>
      </Statements>
    </Batch>
  </BatchSequence>
</ShowPlanXML>