Content Query Web Part Only returns 15 WorkflowStatus Column Values.
I am using a CQWP to pull back values from approximately 50 webs under a single site collection. Each web has a list with a single item that contains site data. These items are all built off of the same content type, and have a workflow associated which
identifies the state of the process that each site is in.
I can successfully pull all the data from these items, except for the Workflow Status column. The items are all returned, but the Workflow status for all but the first 15 items is returned as 8, instead of the expected value of 15-22 (It is an 8 stage process).
I have traced this back to the SPInternalRequest.CrossListQuery function, and the SQL that it generates. Specifically the tblOrds.joinOrds = 0 condition that is set in the SQL from this CrossListQuery function.
My question: Is this a bug, which is incorrectly limiting my ability to pull back data from WorkflowStatus column types, or is this a part of the overall design that just doesn't make sense to me??
January 27th, 2012 11:25pm
Hello,
Thank you for your question.
We are trying to involve someone familiar with this topic to further look at this issue.
This may take some time. Thanks for your patience.
Thanks,Pengyu Zhao
TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
February 1st, 2012 5:15am
Hi,
I've tried to repro this but I am not able to based off of your comments. Can you tell us how you've configured the CQWP webpart?Regards, Savoeurn Va Microsoft Online Community Support
February 7th, 2012 6:12pm
Content Type: AuditInformation
Fields:
Title -> Text
Organization -> Lookup
AuditWor -> Workflow Status (Values between 15-22)
AuditNumber -> Text
CQWP Definition:
<webParts>
<webPart xmlns="http://schemas.microsoft.com/WebPart/v3">
<metaData>
<type name="Microsoft.SharePoint.Publishing.WebControls.ContentByQueryWebPart, Microsoft.SharePoint.Publishing, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" />
<importErrorMessage>Cannot import this Web Part.</importErrorMessage>
</metaData>
<data>
<properties>
<property name="FilterType3" type="string" />
<property name="PageSize" type="int">-1</property>
<property name="SortBy" type="string" />
<property name="ChromeState" type="chromestate">Normal</property>
<property name="AllowZoneChange" type="bool">True</property>
<property name="ContentTypeBeginsWithId" type="string">0x0100F132384C21CDBA40853CA2E349C19AC6</property>
<property name="ServerTemplate" type="string">100</property>
<property name="Height" type="string" />
<property name="FilterField2" type="string" />
<property name="SystemViewFields" type="string" />
<property name="ParameterBindings" type="string" null="true" />
<property name="FeedTitle" type="string" />
<property name="AllowMinimize" type="bool">True</property>
<property name="ContentTypeName" type="string" />
<property name="TitleUrl" type="string" />
<property name="AllowConnect" type="bool">True</property>
<property name="DisplayColumns" type="int">1</property>
<property name="XslLink" type="string" null="true" />
<property name="ExportMode" type="exportmode">All</property>
<property name="GroupBy" type="string" />
<property name="DataSourcesString" type="string" />
<property name="WebUrl" type="string" />
<property name="AllowHide" type="bool">True</property>
<property name="AdditionalGroupAndSortFields" type="string" null="true" />
<property name="FeedDescription" type="string" />
<property name="WebsOverride" type="string" />
<property name="CommonViewFields" type="string">AuditNumber;Title;Organization;AuditWor</property>
<property name="DisplayName" type="string" />
<property name="ChromeType" type="chrometype">TitleOnly</property>
<property name="AdditionalFilterFields" type="string" null="true" />
<property name="NoDefaultStyle" type="string" null="true" />
<property name="FilterValue3" type="string" />
<property name="BaseType" type="string" />
<property name="FireInitialRow" type="bool">True</property>
<property name="SortByDirection" type="Microsoft.SharePoint.Publishing.WebControls.ContentByQueryWebPart+SortDirection, Microsoft.SharePoint.Publishing, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c">Desc</property>
<property name="DataFields" type="string" />
<property name="GroupStyle" type="string">DefaultHeader</property>
<property name="DataColumnRenames" type="string" />
<property name="HeaderXslLink" type="string" />
<property name="AllowEdit" type="bool">True</property>
<property name="MissingAssembly" type="string">Cannot import this Web Part.</property>
<property name="HelpUrl" type="string" />
<property name="ViewFieldsOverride" type="string" />
<property name="FilterField1" type="string" />
<property name="UseCache" type="bool">True</property>
<property name="ShowUntargetedItems" type="bool">False</property>
<property name="HelpMode" type="helpmode">Modeless</property>
<property name="DataSourceID" type="string" />
<property name="ListName" type="string" />
<property name="FilterType1" type="string" />
<property name="Default" type="string" />
<property name="FilterType2" type="string" />
<property name="FilterOperator1" type="Microsoft.SharePoint.Publishing.WebControls.ContentByQueryWebPart+FilterFieldQueryOperator, Microsoft.SharePoint.Publishing, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c">Eq</property>
<property name="ViewFlag" type="string" />
<property name="FilterOperator3" type="Microsoft.SharePoint.Publishing.WebControls.ContentByQueryWebPart+FilterFieldQueryOperator, Microsoft.SharePoint.Publishing, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c">Eq</property>
<property name="FilterOperator2" type="Microsoft.SharePoint.Publishing.WebControls.ContentByQueryWebPart+FilterFieldQueryOperator, Microsoft.SharePoint.Publishing, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c">Eq</property>
<property name="GroupByFieldType" type="string" />
<property name="UseCopyUtil" type="bool">True</property>
<property name="Description" type="string">Use to display a dynamic view of content from your site on a web page</property>
<property name="Filter1ChainingOperator" type="Microsoft.SharePoint.Publishing.WebControls.ContentByQueryWebPart+FilterChainingOperator, Microsoft.SharePoint.Publishing, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c">Or</property>
<property name="ItemLimit" type="int">100</property>
<property name="SortByFieldType" type="string" />
<property name="ListGuid" type="string" />
<property name="ViewContentTypeId" type="string" />
<property name="ItemXslLink" type="string">/Style Library/XSL Style Sheets/raw.xsl</property>
<property name="FeedEnabled" type="bool">False</property>
<property name="MainXslLink" type="string">/Style Library/XSL Style Sheets/raw.xsl</property>
<property name="TitleIconImageUrl" type="string" />
<property name="Filter2ChainingOperator" type="Microsoft.SharePoint.Publishing.WebControls.ContentByQueryWebPart+FilterChainingOperator, Microsoft.SharePoint.Publishing, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c">Or</property>
<property name="FilterValue1" type="string" />
<property name="ListsOverride" type="string" />
<property name="GroupByDirection" type="Microsoft.SharePoint.Publishing.WebControls.ContentByQueryWebPart+SortDirection, Microsoft.SharePoint.Publishing, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c">Desc</property>
<property name="Direction" type="direction">NotSet</property>
<property name="QueryOverride" type="string" />
<property name="UseSQLDataSourcePaging" type="bool">True</property>
<property name="Width" type="string" />
<property name="FilterByAudience" type="bool">False</property>
<property name="FilterValue2" type="string" />
<property name="SampleData" type="string"><dsQueryResponse>
<Rows>
<Row Title="Item 1" LinkUrl="http://Item1" Group="Group Header" __begincolumn="True" __begingroup="True" />
<Row Title="Item 2" LinkUrl="http://Item2" __begincolumn="False" __begingroup="False" />
<Row Title="Item 3" LinkUrl="http://Item3" __begincolumn="False" __begingroup="False" />
</Rows>
</dsQueryResponse></property>
<property name="Xsl" type="string"><xsl:stylesheet xmlns:x="http://www.w3.org/2001/XMLSchema" version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:cmswrt="http://schemas.microsoft.com/WebPart/v3/Publishing/runtime"
exclude-result-prefixes="xsl cmswrt x" > <xsl:import href="/Style Library/XSL Style Sheets/Header.xsl" /> <xsl:import href="/Style Library/XSL Style Sheets/scorecard.xsl" /> <xsl:import href="/Style Library/XSL Style
Sheets/raw.xsl" /> </xsl:stylesheet></property>
<property name="CacheXslStorage" type="bool">True</property>
<property name="Hidden" type="bool">False</property>
<property name="Title" type="string">PATS Performance Dashboard</property>
<property name="ShowWithSampleData" type="bool">False</property>
<property name="CacheXslTimeOut" type="int">86400</property>
<property name="ItemStyle" type="string">AuditResults</property>
<property name="AllowClose" type="bool">True</property>
<property name="FilterField3" type="string" />
<property name="CatalogIconImageUrl" type="string" />
</properties>
</data>
</webPart>
</webParts>
XSL Stylesheet:
<xsl:stylesheet
version="1.0"
exclude-result-prefixes="x xsl cmswrt cbq"
xmlns:x="http://www.w3.org/2001/XMLSchema"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:cmswrt="http://schemas.microsoft.com/WebPart/v3/Publishing/runtime"
xmlns:cbq="urn:schemas-microsoft-com:ContentByQueryWebPart">
<xsl:output method="xml" indent="yes" />
<xsl:param name="cbq_isgrouping" />
<xsl:param name="cbq_columnwidth" />
<xsl:param name="Group" />
<xsl:param name="GroupType" />
<xsl:param name="cbq_iseditmode" />
<xsl:param name="cbq_viewemptytext" />
<xsl:param name="SiteId" />
<xsl:param name="WebUrl" />
<xsl:param name="PageId" />
<xsl:param name="WebPartId" />
<xsl:param name="FeedPageUrl" />
<xsl:param name="FeedEnabled" />
<xsl:param name="SiteUrl" />
<xsl:param name="BlankTitle" />
<xsl:param name="BlankGroup" />
<xsl:param name="UseCopyUtil" />
<xsl:param name="DataColumnTypes" />
<xsl:param name="ClientId" />
<xsl:template match="/">
<xmp><xsl:copy-of select="*"/></xmp>
<!--xsl:call-template name="OuterTemplate" /-->
</xsl:template>
<xsl:template name="OuterTemplate">
<xsl:variable name="Rows" select="/dsQueryResponse/Rows/Row" />
<xsl:variable name="RowCount" select="count($Rows)" />
<xsl:variable name="IsEmpty" select="$RowCount = 0" />
<table id="cbqwp" cellspacing="0" cellpadding="0" class="cbq-layout-main">
<tr>
<xsl:choose>
<xsl:when test="$IsEmpty">
<xsl:call-template name="OuterTemplate.Empty" >
<xsl:with-param name="EditMode" select="$cbq_iseditmode" />
</xsl:call-template>
</xsl:when>
<xsl:otherwise>
<xsl:call-template name="OuterTemplate.Body">
<xsl:with-param name="Rows" select="$Rows" />
<xsl:with-param name="FirstRow" select="1" />
<xsl:with-param name="LastRow" select="$RowCount" />
</xsl:call-template>
</xsl:otherwise>
</xsl:choose>
</tr>
</table>
<xsl:if test="$FeedEnabled = 'True'">
<div class="cqfeed">
<xsl:variable name="FeedUrl1" select="concat($SiteUrl,$FeedPageUrl,'xsl=1&web=',$WebUrl,'&page=',$PageId,'&wp=',$WebPartId)" />
<a href="{cmswrt:RegisterFeedUrl( $FeedUrl1, 'application/rss+xml')}"><img src="\_layouts\images\rss.gif" border="0" alt="{cmswrt:GetPublishingResource('CbqRssAlt')}"/></a>
</div>
</xsl:if>
</xsl:template>
<xsl:template name="OuterTemplate.Empty">
<xsl:param name="EditMode" />
<td>
<xsl:if test="$EditMode = 'True'">
<div class="wp-content description">
<xsl:value-of disable-output-escaping="yes" select="$cbq_viewemptytext" />
</div>
</xsl:if>
</td>
</xsl:template>
<xsl:template name="OuterTemplate.Body">
<xsl:param name="Rows" />
<xsl:param name="FirstRow" />
<xsl:param name="LastRow" />
<xsl:variable name="BeginColumn1" select="string('<td id="column" width="')" />
<xsl:variable name="BeginColumn2" select="string('%" valign="top">')" />
<xsl:variable name="BeginColumn" select="concat($BeginColumn1, $cbq_columnwidth, $BeginColumn2)" />
<xsl:variable name="EndColumn" select="string('</td >')" />
<xsl:for-each select="$Rows">
<xsl:variable name="CurPosition" select="position()" />
<xsl:if test="($CurPosition >= $FirstRow and $CurPosition <= $LastRow)">
<xsl:variable name="StartNewGroup" select="@__begingroup = 'True'" />
<xsl:variable name="StartNewColumn" select="@__begincolumn = 'True'" />
<xsl:choose>
<xsl:when test="$cbq_isgrouping != 'True'">
<xsl:if test="$CurPosition = $FirstRow">
<xsl:value-of disable-output-escaping="yes" select="$BeginColumn" />
</xsl:if>
</xsl:when>
<xsl:when test="$StartNewGroup and $StartNewColumn">
<xsl:choose>
<xsl:when test="$CurPosition = $FirstRow">
<xsl:value-of disable-output-escaping="yes" select="$BeginColumn" />
<xsl:call-template name="OuterTemplate.CallHeaderTemplate"/>
</xsl:when>
<xsl:otherwise>
<xsl:call-template name="OuterTemplate.CallFooterTemplate"/>
<xsl:value-of disable-output-escaping="yes" select="concat($EndColumn, $BeginColumn)" />
<xsl:call-template name="OuterTemplate.CallHeaderTemplate"/>
</xsl:otherwise>
</xsl:choose>
</xsl:when>
<xsl:when test="$StartNewGroup">
<xsl:call-template name="OuterTemplate.CallFooterTemplate"/>
<xsl:call-template name="OuterTemplate.CallHeaderTemplate"/>
</xsl:when>
<xsl:when test="$StartNewColumn">
<xsl:choose>
<xsl:when test="$CurPosition = $FirstRow">
<xsl:value-of disable-output-escaping="yes" select="$BeginColumn" />
</xsl:when>
<xsl:otherwise>
<xsl:value-of disable-output-escaping="yes" select="concat($EndColumn, $BeginColumn)" />
</xsl:otherwise>
</xsl:choose>
</xsl:when>
<xsl:otherwise>
</xsl:otherwise>
</xsl:choose>
<xsl:call-template name="OuterTemplate.CallItemTemplate">
<xsl:with-param name="CurPosition" select="$CurPosition" />
</xsl:call-template>
<xsl:if test="$CurPosition = $LastRow">
<xsl:call-template name="OuterTemplate.CallFooterTemplate"/>
<xsl:value-of disable-output-escaping="yes" select="$EndColumn" />
</xsl:if>
</xsl:if>
</xsl:for-each>
</xsl:template>
<xsl:template name="OuterTemplate.CallHeaderTemplate">
<xsl:apply-templates select="." mode="header">
</xsl:apply-templates>
</xsl:template>
<xsl:template name="OuterTemplate.CallItemTemplate">
<xsl:param name="CurPosition" />
<xsl:choose>
<xsl:when test="@Style='NewsRollUpItem'">
<xsl:apply-templates select="." mode="itemstyle">
<xsl:with-param name="EditMode" select="$cbq_iseditmode" />
</xsl:apply-templates>
</xsl:when>
<xsl:when test="@Style='NewsBigItem'">
<xsl:apply-templates select="." mode="itemstyle">
<xsl:with-param name="CurPos" select="$CurPosition" />
</xsl:apply-templates>
</xsl:when>
<xsl:when test="@Style='NewsCategoryItem'">
<xsl:apply-templates select="." mode="itemstyle">
<xsl:with-param name="CurPos" select="$CurPosition" />
</xsl:apply-templates>
</xsl:when>
<xsl:otherwise>
<xsl:apply-templates select="." mode="itemstyle">
</xsl:apply-templates>
</xsl:otherwise>
</xsl:choose>
</xsl:template>
<xsl:template name="OuterTemplate.CallFooterTemplate">
<div id="footer">
</div>
</xsl:template>
<xsl:template name="OuterTemplate.GetSafeLink">
<xsl:param name="UrlColumnName"/>
<xsl:if test="$UseCopyUtil = 'True'">
<xsl:value-of select="concat('/_layouts/CopyUtil.aspx?Use=id&Action=dispform&ItemId=',@ID,'&ListId=',@ListId,'&WebId=',@WebId,'&SiteId=',$SiteId)"/>
</xsl:if>
<xsl:if test="$UseCopyUtil != 'True'">
<xsl:call-template name="OuterTemplate.GetSafeStaticUrl">
<xsl:with-param name="UrlColumnName" select="$UrlColumnName"/>
</xsl:call-template>
</xsl:if>
</xsl:template>
<xsl:template name="OuterTemplate.GetTitle">
<xsl:param name="Title"/>
<xsl:param name="UrlColumnName"/>
<xsl:if test="string-length($Title) != 0">
<xsl:value-of select="$Title"/>
</xsl:if>
<xsl:if test="string-length($Title) = 0">
<xsl:if test="$UseCopyUtil = 'True'">
<xsl:value-of select="$BlankTitle" />
</xsl:if>
<xsl:if test="$UseCopyUtil != 'True'">
<xsl:call-template name="OuterTemplate.GetPageNameFromUrl">
<xsl:with-param name="UrlColumnName" select="$UrlColumnName"/>
</xsl:call-template>
</xsl:if>
</xsl:if>
</xsl:template>
<xsl:template name="OuterTemplate.FormatColumnIntoUrl">
<xsl:param name="UrlColumnName"/>
<xsl:variable name="Value" select="@*[name()=$UrlColumnName]"/>
<xsl:if test="contains($DataColumnTypes,concat(';',$UrlColumnName,',URL;'))">
<xsl:call-template name="OuterTemplate.FormatValueIntoUrl">
<xsl:with-param name="Value" select="$Value"/>
</xsl:call-template>
</xsl:if>
<xsl:if test="not(contains($DataColumnTypes,concat(';',$UrlColumnName,',URL;')))">
<xsl:value-of select="$Value"/>
</xsl:if>
</xsl:template>
<xsl:template name="OuterTemplate.FormatValueIntoUrl">
<xsl:param name="Value"/>
<xsl:if test="not(contains($Value,', '))">
<xsl:value-of select="$Value"/>
</xsl:if>
<xsl:if test="contains($Value,', ')">
<xsl:call-template name="OuterTemplate.Replace">
<xsl:with-param name="Value" select="substring-before($Value,', ')"/>
<xsl:with-param name="Search" select="',,'"/>
<xsl:with-param name="Replace" select="','"/>
</xsl:call-template>
</xsl:if>
</xsl:template>
<xsl:template name="OuterTemplate.Replace">
<xsl:param name="Value"/>
<xsl:param name="Search"/>
<xsl:param name="Replace"/>
<xsl:if test="contains($Value,$Search)">
<xsl:value-of select="concat(substring-before($Value,$Search),$Replace)"/>
<xsl:call-template name="OuterTemplate.Replace">
<xsl:with-param name="Value" select="substring-after($Value,$Search)"/>
<xsl:with-param name="Search" select="$Search"/>
<xsl:with-param name="Replace" select="$Replace"/>
</xsl:call-template>
</xsl:if>
<xsl:if test="not(contains($Value,$Search))">
<xsl:value-of select="$Value"/>
</xsl:if>
</xsl:template>
<xsl:template name="OuterTemplate.GetSafeStaticUrl">
<xsl:param name="UrlColumnName"/>
<xsl:variable name="Url">
<xsl:call-template name="OuterTemplate.FormatColumnIntoUrl">
<xsl:with-param name="UrlColumnName" select="$UrlColumnName"/>
</xsl:call-template>
</xsl:variable>
<xsl:value-of select="cmswrt:EnsureIsAllowedProtocol($Url)"/>
</xsl:template>
<xsl:template name="OuterTemplate.GetColumnDataForUnescapedOutput">
<xsl:param name="Name"/>
<xsl:param name="MustBeOfType"/>
<xsl:if test="contains($DataColumnTypes,concat(';',$Name,',',$MustBeOfType,';'))">
<xsl:value-of select="@*[name()=$Name]"/>
</xsl:if>
</xsl:template>
<xsl:template name="OuterTemplate.GetPageNameFromUrl">
<xsl:param name="UrlColumnName"/>
<xsl:variable name="Url">
<xsl:call-template name="OuterTemplate.FormatColumnIntoUrl">
<xsl:with-param name="UrlColumnName" select="$UrlColumnName"/>
</xsl:call-template>
</xsl:variable>
<xsl:call-template name="OuterTemplate.GetPageNameFromUrlRecursive">
<xsl:with-param name="Url" select="$Url"/>
</xsl:call-template>
</xsl:template>
<xsl:template name="OuterTemplate.GetPageNameFromUrlRecursive">
<xsl:param name="Url"/>
<xsl:choose>
<xsl:when test="contains($Url,'/') and substring($Url,string-length($Url)) != '/'">
<xsl:call-template name="OuterTemplate.GetPageNameFromUrlRecursive">
<xsl:with-param name="Url" select="substring-after($Url,'/')"/>
</xsl:call-template>
</xsl:when>
<xsl:otherwise>
<xsl:value-of select="$Url"/>
</xsl:otherwise>
</xsl:choose>
</xsl:template>
<xsl:template name="OuterTemplate.GetGroupName">
<xsl:param name="GroupName"/>
<xsl:param name="GroupType"/>
<xsl:choose>
<xsl:when test="string-length(normalize-space($GroupName)) = 0">
<xsl:value-of select="$BlankGroup"/>
</xsl:when>
<xsl:otherwise>
<xsl:choose>
<xsl:when test="$GroupType='URL'">
<xsl:variable name="Url">
<xsl:call-template name="OuterTemplate.FormatValueIntoUrl">
<xsl:with-param name="Value" select="$GroupName"/>
</xsl:call-template>
</xsl:variable>
<xsl:call-template name="OuterTemplate.GetPageNameFromUrlRecursive">
<xsl:with-param name="Url" select="$Url"/>
</xsl:call-template>
</xsl:when>
<xsl:otherwise>
<xsl:value-of select="$GroupName" />
</xsl:otherwise>
</xsl:choose>
</xsl:otherwise>
</xsl:choose>
</xsl:template>
<xsl:template name="OuterTemplate.CallPresenceStatusIconTemplate">
<xsl:if test="string-length(@SipAddress) != 0">
<span class="presence-status-icon"><img src="/_layouts/images/imnhdr.gif" onload="IMNRC('{@SipAddress}')" ShowOfflinePawn="1" alt="" id="{concat('MWP_pawn_',$ClientId,'_',@ID,'type=sip')}"/></span>
</xsl:if>
</xsl:template>
</xsl:stylesheet>
Free Windows Admin Tool Kit Click here and download it now
February 8th, 2012 11:13am
Also. This is pulling from 50 subwebs, a single list on each called General Information where the content type in the previous post is located. There is only a single AuditInformation item in this list, this is controlled by an EventHandler attached to the
General Information List.
The workflow that sets the status (15-22) is a Visual Studio State Workflow. The states are as follows
15 - Audit Announced
16 - Entrance Conference
17 - Audit Work
18 - Exit Conference
19 - Draft Report
20 - Final Report
21 - Corrective Action
22 - Audit Closure
I can attach the SQL query that is generated by the CrossListQuery SPInternalRequest as well if you want to see the issue specifically.
LMK,
And thanks for the help it is appreciated :)
February 8th, 2012 11:18am
Here is the output from the CQWP.. Note the AuditWorkflowStatus column is populated manually to show the "correct" value / status of the AuditWor field.
<dsQueryResponse>
<Rows>
<Row ListId="{F3BA2883-84C9-4037-9ADB-0AEA6F79CA3F}" WebId="{0CD0B6E9-D795-40B1-9ABA-39D5BAA659F9}" ID="1" Title="" FileRef="Audit 060/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1"
Modified="2012-02-07 07:14:19" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-30 10:57:33" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="16.0000000000000" AuditNumber="Audit 060 Testing" WorkingTitle="Audit 060
Testing" AuditOrganization="1;#GAO" AuditWor="16" LinkUrl="http://sharepoint/Audit 060/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:14:19 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader" __begincolumn="True"
__begingroup="False" />
<Row ListId="{047C823F-B3DA-4E70-99FB-0BA20DA2FF73}" WebId="{22103B05-EF3B-48CA-B0C4-89BFA57691ED}" ID="1" Title="" FileRef="Audit 034/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1"
Modified="2012-02-07 07:14:01" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-27 08:38:16" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="21.0000000000000" AuditNumber="Audit 034 Testing Purposes" WorkingTitle="Audit
034 Testing Purposes" AuditOrganization="2;#OIG" AuditWor="21" LinkUrl="http://sharepoint/Audit 034/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:14:01 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader"
__begincolumn="False" __begingroup="False" />
<Row ListId="{3C451B7C-F977-47F2-A875-0BA2E123CDD3}" WebId="{255D9A04-120E-40A7-92EE-D31BD2DCC68E}" ID="1" Title="" FileRef="Audit 054/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1"
Modified="2012-02-07 07:14:14" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-30 10:17:43" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="21.0000000000000" AuditNumber="Audit 054 Testing" WorkingTitle="Audit 054
Testing" AuditOrganization="1;#GAO" AuditWor="21" LinkUrl="http://sharepoint/Audit 054/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:14:14 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader" __begincolumn="False"
__begingroup="False" />
<Row ListId="{7CBE2162-5348-4A25-A6A7-10DE92F85E59}" WebId="{9251FE05-7C0F-4B3E-97BA-31E13F23EEC5}" ID="1" Title="" FileRef="Audit 053/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1"
Modified="2012-02-07 07:14:13" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-30 10:06:53" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="19.0000000000000" AuditNumber="Audit 053 Testing" WorkingTitle="Audit 053
Testing" AuditOrganization="1;#GAO" AuditWor="19" LinkUrl="http://sharepoint/Audit 053/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:14:13 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader" __begincolumn="False"
__begingroup="False" />
<Row ListId="{6F4EC3BE-CE75-4770-A225-1464452E5B3B}" WebId="{23BCBB7B-9157-498D-8EEF-8B9512912C21}" ID="1" Title="" FileRef="Audit 027/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1"
Modified="2012-02-07 07:13:55" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-27 07:56:20" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="22.0000000000000" AuditNumber="Audit 027 Testing Purposes" WorkingTitle="Audit
027 Testing Purposes" AuditOrganization="2;#OIG" AuditWor="22" LinkUrl="http://sharepoint/Audit 027/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:13:55 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader"
__begincolumn="False" __begingroup="False" />
<Row ListId="{12B52EF7-67B1-48BD-9D12-180ADE9C942C}" WebId="{B9B3A6BD-2562-4FA0-8F7A-37F905245C7C}" ID="1" Title="" FileRef="Audit 035/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1"
Modified="2012-02-07 07:14:01" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-27 08:43:18" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="21.0000000000000" AuditNumber="Audit 035 Testing Purposes" WorkingTitle="Audit
035 Testing Purposes" AuditOrganization="2;#OIG" AuditWor="21" LinkUrl="http://sharepoint/Audit 035/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:14:01 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader"
__begincolumn="False" __begingroup="False" />
<Row ListId="{43FE0506-D134-4A9B-8BCC-1FC5A2322F88}" WebId="{D26F08E7-9B95-41A8-B2B9-217D534195D9}" ID="1" Title="" FileRef="Audit 032/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1"
Modified="2012-02-07 07:13:59" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-27 08:26:23" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="18.0000000000000" AuditNumber="Audit 032 Testing Purposes" WorkingTitle="Audit
032 Testing Purposes" AuditOrganization="2;#OIG" AuditWor="18" LinkUrl="http://sharepoint/Audit 032/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:13:59 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader"
__begincolumn="False" __begingroup="False" />
<Row ListId="{B37D3302-3858-4A48-BE21-1FF819A7720F}" WebId="{092D1032-DBD7-47EE-8B3F-4AED25CBD92D}" ID="1" Title="" FileRef="Audit 044/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1"
Modified="2012-02-07 07:14:07" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-27 10:54:13" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="15.0000000000000" AuditNumber="Audit 044" WorkingTitle="Audit 044" AuditOrganization="1;#GAO"
AuditWor="15" LinkUrl="http://sharepoint/Audit 044/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:14:07 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader" __begincolumn="False" __begingroup="False"
/>
<Row ListId="{F6B94F28-BB86-4F8B-8FC9-20AEDF82D224}" WebId="{311ECA93-05BD-4937-B096-678BFDBBD40E}" ID="1" Title="" FileRef="Audit 045/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1"
Modified="2012-02-07 07:14:08" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-27 11:04:23" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="15.0000000000000" AuditNumber="Audit 045" WorkingTitle="Audit 045" AuditOrganization="1;#GAO"
AuditWor="15" LinkUrl="http://sharepoint/Audit 045/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:14:08 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader" __begincolumn="False" __begingroup="False"
/>
<Row ListId="{CF3BF0D8-2965-4411-ABDC-2C1907955E23}" WebId="{FA039EB7-F755-40E5-B799-6BFD77F15D86}" ID="1" Title="" FileRef="Audit 066/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1"
Modified="2012-02-07 07:14:23" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-30 12:47:58" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="22.0000000000000" AuditNumber="Audit 066 Testing" WorkingTitle="Audit 066
Testing" AuditOrganization="1;#GAO" AuditWor="22" LinkUrl="http://sharepoint/Audit 066/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:14:23 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader" __begincolumn="False"
__begingroup="False" />
<Row ListId="{09C960B1-271D-43EE-830C-30D4CFC79CD8}" WebId="{3784AB03-D296-4C1B-AEF3-5E5754BDD99D}" ID="1" Title="" FileRef="Audit 019/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1"
Modified="2012-02-07 07:13:50" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-27 07:30:06" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="17.0000000000000" AuditNumber="Audit 019 Testing Purposes" WorkingTitle="Audit
019 Testing Purposes" AuditOrganization="2;#OIG" AuditWor="17" LinkUrl="http://sharepoint/Audit 019/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:13:50 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader"
__begincolumn="False" __begingroup="False" />
<Row ListId="{D3FE6D84-8A0B-4450-8123-37767A69DADC}" WebId="{D511D7D8-19E9-4F1A-A278-31141643BBD6}" ID="1" Title="" FileRef="Audit 043/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1"
Modified="2012-02-07 07:14:06" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-27 10:22:09" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="15.0000000000000" AuditNumber="Audit 043 Testing" WorkingTitle="Audit 043
Testing" AuditOrganization="2;#OIG" AuditWor="15" LinkUrl="http://sharepoint/Audit 043/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:14:06 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader" __begincolumn="False"
__begingroup="False" />
<Row ListId="{E71ED73F-2B7D-468B-AB75-37C315B94525}" WebId="{626FFF68-484A-4FFB-AF23-610414D75427}" ID="1" Title="" FileRef="Audit 014/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1"
Modified="2012-02-07 07:13:46" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-27 07:08:52" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="15.0000000000000" AuditNumber="Audit 014 Testing Purposes" WorkingTitle="Audit
014 Testing Purposes" AuditOrganization="2;#OIG" AuditWor="15" LinkUrl="http://sharepoint/Audit 014/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:13:46 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader"
__begincolumn="False" __begingroup="False" />
<Row ListId="{078E361B-AD08-4A67-B30B-387F4118B8E5}" WebId="{BA2F6763-8E07-4C57-9634-E3A58FE81667}" ID="1" Title="" FileRef="Audit 021/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1"
Modified="2012-02-07 07:13:51" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-27 07:36:17" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="19.0000000000000" AuditNumber="Audit 021 Testing Purposes" WorkingTitle="Audit
021 Testing Purposes" AuditOrganization="2;#OIG" AuditWor="19" LinkUrl="http://sharepoint/Audit 021/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:13:51 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader"
__begincolumn="False" __begingroup="False" />
<Row ListId="{BB8A431D-9079-4BF5-9D92-394E37273B86}" WebId="{BE4554AF-0AAC-494A-B4EB-9591CA860004}" ID="1" Title="" FileRef="Audit 069/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1"
Modified="2012-02-07 07:14:25" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-30 11:57:52" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="22.0000000000000" AuditNumber="Audit 069 Testing " WorkingTitle="Audit 069
Testing " AuditOrganization="1;#GAO" AuditWor="22" LinkUrl="http://sharepoint/Audit 069/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:14:25 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader"
__begincolumn="False" __begingroup="False" />
<Row ListId="{A0853025-40C6-4855-A655-3F8A9AE58BA8}" WebId="{A6A131B7-2F07-4CBF-8B9C-EB2F449A3538}" ID="1" Title="" FileRef="Audit 047/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1"
Modified="2012-02-07 07:14:10" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-30 08:34:15" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="15.0000000000000" AuditNumber="Audit 047 Testing" WorkingTitle="Audit 047
Testing" AuditOrganization="1;#GAO" AuditWor="8" LinkUrl="http://sharepoint/Audit 047/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:14:10 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader" __begincolumn="False"
__begingroup="False" />
<Row ListId="{C976F5D0-9992-4377-A6A9-40ED8301A909}" WebId="{0C1224DD-2129-46B5-86C0-0410BE634802}" ID="1" Title="" FileRef="Audit 009/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1"
Modified="2012-02-07 07:13:41" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-27 06:37:59" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="16.0000000000000" AuditNumber="Audit 009 for Testing" WorkingTitle="Audit
009 for Testing" AuditOrganization="1;#GAO" AuditWor="8" LinkUrl="http://sharepoint/Audit 009/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:13:41 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader"
__begincolumn="False" __begingroup="False" />
<Row ListId="{9570B806-2B41-4F9C-954B-43A17657EE58}" WebId="{42B3E518-11D8-4C83-B42E-E7B79FC12438}" ID="1" Title="" FileRef="Audit 064/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1"
Modified="2012-02-07 07:14:22" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-30 11:19:25" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="22.0000000000000" AuditNumber="Audit 064 Testing" WorkingTitle="Audit 064
Testing" AuditOrganization="1;#GAO" AuditWor="8" LinkUrl="http://sharepoint/Audit 064/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:14:22 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader" __begincolumn="False"
__begingroup="False" />
<Row ListId="{BBB57FB0-8A33-445C-BB44-4524B4A9E1B6}" WebId="{69DAAC47-F243-47DB-B77C-F31DD4A57430}" ID="1" Title="" FileRef="Audit 052/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1"
Modified="2012-02-07 07:14:13" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-30 10:04:43" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="19.0000000000000" AuditNumber="Audit 052 Testing" WorkingTitle="Audit 052
Testing" AuditOrganization="1;#GAO" AuditWor="8" LinkUrl="http://sharepoint/Audit 052/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:14:13 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader" __begincolumn="False"
__begingroup="False" />
<Row ListId="{9FD04AE7-B853-4D71-91BA-4713D51FDD90}" WebId="{3011411E-5994-4BF2-BF7D-215FC644A9E3}" ID="1" Title="" FileRef="Audit 065/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1"
Modified="2012-02-07 07:14:22" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-30 11:25:30" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="15.0000000000000" AuditNumber="Audit 065 Training" WorkingTitle="Audit 065
Training" AuditOrganization="2;#OIG" AuditWor="8" LinkUrl="http://sharepoint/Audit 065/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:14:22 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader" __begincolumn="False"
__begingroup="False" />
<Row ListId="{BD6BA8A9-42E1-4B5E-A71A-48D1A25255F4}" WebId="{445F5303-90F4-4253-B307-7B6B9EEE7246}" ID="1" Title="" FileRef="Audit 056/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1"
Modified="2012-02-07 07:14:16" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-30 10:43:02" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="19.0000000000000" AuditNumber="Audit 056 Testing" WorkingTitle="Audit 056
Testing" AuditOrganization="1;#GAO" AuditWor="8" LinkUrl="http://sharepoint/Audit 056/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:14:16 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader" __begincolumn="False"
__begingroup="False" />
</Rows>
</dsQueryResponse>
Free Windows Admin Tool Kit Click here and download it now
February 8th, 2012 11:53am
Here is the SQL query generated
exec sp_executesql N' DECLARE @tblListOrds TABLE(WebId uniqueidentifier NOT NULL,ListId uniqueidentifier NOT
NULL,[ListProperty.DraftVersionVisibility] nvarchar(255) NOT NULL,JoinOrd int NOT NULL,ColumnOrd1 int NOT
NULL,ColumnOrd2 int NOT NULL,ColumnOrd3 int NOT NULL,ColumnOrd4 int NOT NULL,ColumnOrd5 int NOT NULL,ColumnOrd6
int NOT NULL,ColumnOrd7 int NOT NULL,ColumnOrd8 int NOT NULL,ColumnOrd9 int NOT NULL,ColumnOrd10 int NOT
NULL,ColumnOrd11 int NOT NULL,ColumnOrd12 int NOT NULL,ColumnOrd13 int NOT NULL,ColumnOrd14 int NOT
NULL,ColumnOrd15 int NOT NULL,ColumnOrd16 int NOT NULL,ColumnOrd17 int NOT NULL,ColumnOrd18 int NOT
NULL,ColumnOrd19 int NOT NULL,ColumnOrd20 int NOT NULL,ColumnOrd21 int NOT NULL,ColumnOrd22 int NOT
NULL,ColumnOrd23 int NOT NULL,ColumnOrd24 int NOT NULL,ColumnOrd25 int NOT NULL,ColumnOrd26 int NOT
NULL,ColumnOrd27 int NOT NULL,ColumnOrd28 int NOT NULL,ColumnOrd29 int NOT NULL,ColumnOrd30 int NOT
NULL,ColumnOrd31 int NOT NULL,ColumnOrd32 int NOT NULL,ColumnOrd33 int NOT NULL,ColumnOrd34 int NOT
NULL,ColumnOrd35 int NOT NULL,ColumnOrd36 int NOT NULL,NvpLookupListId uniqueidentifier,JoinKeyId1
uniqueidentifier,JoinKeyId2 uniqueidentifier,ScopeId uniqueidentifier,PRIMARY KEY CLUSTERED(ListId)) INSERT
INTO @tblListOrds SELECT
''0CD0B6E9-D795-40B1-9ABA-39D5BAA659F9'',''F3BA2883-84C9-4037-9ADB-0AEA6F79CA3F'',0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''22103B05-EF3B-48CA-B0C4-89BFA57691ED'',''047C823F-B3DA-4E70-99FB-0BA20DA2FF73'',0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''255D9A04-120E-40A7-92EE-D31BD2DCC68E'',''3C451B7C-F977-47F2-A875-0BA2E123CDD3'',0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''9251FE05-7C0F-4B3E-97BA-31E13F23EEC5'',''7CBE2162-5348-4A25-A6A7-10DE92F85E59'',0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''23BCBB7B-9157-498D-8EEF-8B9512912C21'',''6F4EC3BE-CE75-4770-A225-1464452E5B3B'',0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''B9B3A6BD-2562-4FA0-8F7A-37F905245C7C'',''12B52EF7-67B1-48BD-9D12-180ADE9C942C'',0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''D26F08E7-9B95-41A8-B2B9-217D534195D9'',''43FE0506-D134-4A9B-8BCC-1FC5A2322F88'',0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''092D1032-DBD7-47EE-8B3F-4AED25CBD92D'',''B37D3302-3858-4A48-BE21-1FF819A7720F'',0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''311ECA93-05BD-4937-B096-678BFDBBD40E'',''F6B94F28-BB86-4F8B-8FC9-20AEDF82D224'',0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''FA039EB7-F755-40E5-B799-6BFD77F15D86'',''CF3BF0D8-2965-4411-ABDC-2C1907955E23'',0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''3784AB03-D296-4C1B-AEF3-5E5754BDD99D'',''09C960B1-271D-43EE-830C-30D4CFC79CD8'',0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''D511D7D8-19E9-4F1A-A278-31141643BBD6'',''D3FE6D84-8A0B-4450-8123-37767A69DADC'',0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''626FFF68-484A-4FFB-AF23-610414D75427'',''E71ED73F-2B7D-468B-AB75-37C315B94525'',0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''BA2F6763-8E07-4C57-9634-E3A58FE81667'',''078E361B-AD08-4A67-B30B-387F4118B8E5'',0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''BE4554AF-0AAC-494A-B4EB-9591CA860004'',''BB8A431D-9079-4BF5-9D92-394E37273B86'',0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''A6A131B7-2F07-4CBF-8B9C-EB2F449A3538'',''A0853025-40C6-4855-A655-3F8A9AE58BA8'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''0C1224DD-2129-46B5-86C0-0410BE634802'',''C976F5D0-9992-4377-A6A9-40ED8301A909'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''42B3E518-11D8-4C83-B42E-E7B79FC12438'',''9570B806-2B41-4F9C-954B-43A17657EE58'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''69DAAC47-F243-47DB-B77C-F31DD4A57430'',''BBB57FB0-8A33-445C-BB44-4524B4A9E1B6'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''3011411E-5994-4BF2-BF7D-215FC644A9E3'',''9FD04AE7-B853-4D71-91BA-4713D51FDD90'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''445F5303-90F4-4253-B307-7B6B9EEE7246'',''BD6BA8A9-42E1-4B5E-A71A-48D1A25255F4'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''66A13004-0114-45BE-9DB1-518117D8580D'',''0D95B742-804F-4B41-9954-49C3B2341D6F'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''DB25875F-D3DC-4767-815C-F1C73BD5B3CA'',''CE9BF355-D98B-4322-81DF-4BF867620286'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''F8F72549-C3C9-4A4E-95F6-43496DD21C70'',''7160B97C-E27D-4B54-BF70-5011B944345B'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''2077B01F-FE84-448A-852F-4BEE6F8BC105'',''34C81D0A-FFFC-47A8-A6C5-5221DA497541'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''777F7A86-B3FF-4A0C-B7BC-7AD7746C8D9E'',''F83A72F6-ADEB-427E-A5BF-5674BCEDD020'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''6730BC94-A41A-4AAD-8167-534BF2C5AAAE'',''48B95AF6-9DB9-4644-8D79-56B8CC1EE1AA'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''A03FAE2E-BEE0-44F7-95E3-DB202237DDBD'',''1D7928FC-19A7-4B19-803C-5BBA408295EC'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''5396B777-894A-4835-811F-DD60516369DF'',''FD024F49-F47A-4C78-B6E6-60259BEB4C5E'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''3C755533-44E5-4913-841D-CC05F94EE6AF'',''0C69CB41-D661-4FFE-BABF-60607222C7F2'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''4E763E24-0A33-4C8A-8BC7-D99C8D5E9DCE'',''904CD6D9-166A-4D4E-806B-60812B783171'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''5BC581B6-AA03-44E2-9D45-5F116BDDB1F8'',''AD34FFC6-0165-4BD4-9331-65FFF5A7ADB5'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''14182C89-8548-4E3B-96F8-8680B681B6CC'',''9D8ED991-2386-4BCC-B10E-6D38FC45520F'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''E92265BD-1ED4-4E64-ACF4-30D9321A2513'',''7098EEBC-27B1-4CA9-99D6-7161027E5DA8'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''B771A5A8-B777-40FB-8D46-4501D4D6B3A5'',''D0B40F2E-82E7-446A-915F-73D49B10598B'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''DA54AE93-DFA4-4625-9A97-0789012DFBA6'',''C06624D7-731B-40BF-A141-7C15C79EB951'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''0AF4F04F-9508-4170-8DAC-9929CAFCF581'',''AA89CCA6-91B3-4762-9817-84BE53EB946B'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''A58500A5-93F2-449D-9ECD-4C125177CD7A'',''EE00ABF7-E6C4-4DA5-9B1E-8D948B9161E5'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''BD3F9E9E-B521-41CD-B5D5-D3998BA32E20'',''4ECA8E54-6D12-4142-B0B0-9258B25C16BD'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''2913198C-0209-44C0-9B91-863693A5A4E3'',''D643FEFD-0DAC-41D1-B6C4-95C0879E610A'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''C8FBEFE3-8143-4AF3-B782-CF7F2F1196C9'',''FA637CA5-18D0-4B5E-8C69-9A5088EBE12F'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''CA19406E-1DD2-4369-A440-B9F92CBF50D5'',''E4ECC8E5-BC95-44D2-92F0-9BC5281C3C20'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''5C692D11-3705-48EB-9F85-62DAC5AF38A7'',''1352E156-A430-4F46-B7AD-9CE31B8E2343'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''18C17BC8-FC0A-49BE-8B7D-1D845F6B43D3'',''9B69781B-13E0-4D8F-B77F-9D02FA6777D7'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''5DFFB9D2-430A-4BE1-AA8D-F3D333BE7F6B'',''1DBA79E7-ED8B-46C0-93BA-9D4573C2F916'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''3CECB6D7-23C2-4054-A3B1-7D9579EC5A2F'',''4BD0D246-C17E-4470-8DF3-9E2EC177D0AF'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''C6567A4B-386D-4188-A5A5-7D05B8973EB3'',''38FC6788-B59A-4D30-88A2-9F380B20D162'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''F443B039-9D74-492A-94AB-8EAF50F55461'',''057D92ED-AAD4-4DF2-93B1-A3899A8F3A79'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''028AE423-E639-4537-8535-6261305EBEF5'',''7AAF52C4-C6CD-4F87-9037-A5539A76BFCB'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''C867CBBE-3C39-4C78-9205-F41B7036D08A'',''BDF10512-D4E9-4B58-826B-A5CCFBDB92AF'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''BAE8BC0F-1A1B-4502-B093-0068474B6990'',''8AC841D0-604B-4CBE-8085-A6E5D01E519E'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''A0888268-861C-4B39-8EC7-80CD82E64A4A'',''82EC51A8-0BAD-451D-B0EF-AA8F5E242B91'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''7A9F2D62-8637-4F12-AB18-7A91E86DA20A'',''F92FFA25-C4F9-4059-9C88-B0455E35C70B'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''3DC60C5C-E493-4FA1-A1F1-211F85FF73F4'',''40894565-2129-428C-B3BB-B199631C302A'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''E37FB398-265D-4ED5-AE8B-453F7BFB0D15'',''BD0D6A70-C957-4E3F-AA96-B1A379CA0CB1'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''C29E3983-1294-45C9-B397-95623735EC23'',''2E7C94C1-5161-4FDE-9330-B999DD8DA7FE'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''2E9854EC-668F-4367-A461-28AEEB25E644'',''9BEDA60D-DD3E-4ACD-8CE1-BF1317B4D813'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''DF94F663-27E8-4AD5-A3E1-F953FB9B70B7'',''5E2FB189-9846-428E-B7CE-C3B589AB2F69'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''536A0085-C946-4A0A-B121-1B5AF6D4B583'',''D91D6FFA-5AE4-46C2-81B2-C79D7D7F440E'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''F836CF08-C04B-4075-9A2A-20BE58A8DF1D'',''C097490A-CFBB-4FCB-9758-C84EC4461F5B'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''9D89E123-FE94-48BE-BAE8-1CE8B0B04827'',''23558449-CEEB-4193-8B9D-CFEDAA5E66FB'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''D596681B-47BA-4012-8871-0A0925F02551'',''9A40CEB4-AF0C-416B-8F90-D0C092B99290'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''B29D141F-A7E6-4414-BCCF-E6C1006D1BB8'',''68CE2F7E-0117-4BAD-8785-D4C135B096C6'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''6A3A562D-113D-411D-970C-984601BF5913'',''435D6089-F16A-4785-9615-D52F4AD81635'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''05699AE4-166B-45C6-AC15-AFC36D1D4CCE'',''73C82FFF-72A4-42D0-ABD4-D898500E4532'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''CE22C111-CBF0-4159-800A-D34F4F75B00C'',''AAE39E49-7FD4-41B7-AF02-DBEEA7217CE4'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''7A07F323-37CC-4DEF-8834-454283391D49'',''954F6280-7F4B-4EDA-86F4-E2C46081FCAE'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''76BA2A65-8733-4B13-9462-774BB297FB3B'',''036C0DB5-F966-4B9B-9FDB-E2EA7C95BDE5'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''A393245A-8E21-45E0-AC03-55D9593203F4'',''B7CC4715-6B1D-4A2A-9CA3-EB4E8E8F1910'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''06F42124-9C98-4750-B7CD-1426B6D9D7E9'',''0C5E440F-B719-4362-B8F7-EC4A339AAE97'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''2DD0A418-9259-45E1-B185-BEAAD3B05DB7'',''E7C4C973-BDF8-4630-9F0C-ED28039B59FC'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''11FB3492-92A3-4779-8808-036CD1802004'',''CAA069F4-D786-44A0-B799-EDF37390891D'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''C119470F-2682-4663-AE51-880781EDDF42'',''151A38E2-3C4B-4568-A636-F1F9549C9CD9'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''42002752-600B-4A06-A83A-9327A32D980A'',''F2162027-8A01-493C-84C2-F4DEB66AC30D'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''AC361E85-FAA2-4E49-8C17-2125049AD230'',''4156B5B2-111D-45ED-BA12-F5DB21260B68'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''704D0317-33F7-46D8-B893-ABED31D7E9CA'',''73E181B7-B1F1-45BA-A0E3-F796A22F20D8'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''68B85DDC-C03D-46F4-97CF-B523AEBFE154'',''286D690E-4FF3-4CDB-BE0C-F93FA9613EA4'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''93D9816C-C0E1-498A-996A-E237CCA6324D'',''990577D1-92A2-4A24-B0A0-FA085537E433'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''9F246E70-E728-4534-90BE-13CE06307D9C'',''08E8EADD-5E9B-46B1-AE6C-FA6F5D033BC6'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''BAD4DBD8-7F28-40B1-9F48-10E5DEC0EC87'',''E90F59D9-37C0-4DB9-8C48-FB0CC13003CB'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
INSERT INTO @tblListOrds SELECT
''2BADDBCD-078A-4D68-A226-6856BE52C30A'',''32786351-590D-4341-A1A4-FB926D445524'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460''
SELECT UserData.[tp_ID] AS QryCol0,ListOrds.[WebId] AS QryCol1,ListOrds.[ListId] AS
QryCol2,UserData.[tp_Created] AS QryCol3,t1.[Type] AS QryCol4,CASE WHEN DATALENGTH(t1.DirName) = 0 THEN
t1.LeafName WHEN DATALENGTH(t1.LeafName) = 0 THEN t1.DirName ELSE t1.DirName + N''/'' + t1.LeafName END AS
QryCol5,UserData.[tp_ModerationStatus] AS QryCol6,UserData.[tp_Level] AS QryCol7,UserData.[ntext1] AS
QryCol8,UserData.[nvarchar1] AS QryCol9,UserData.[tp_Modified] AS QryCol10,UserData.[tp_Author] AS
QryCol11,t2.[nvarchar1] AS QryCol12,t2.[tp_ID] AS QryCol13,t2.[nvarchar4] AS QryCol14,t2.[nvarchar5] AS
QryCol15,t2.[tp_Created] AS QryCol16,UserData.[tp_Editor] AS QryCol17,t3.[nvarchar1] AS QryCol18,t3.[tp_ID] AS
QryCol19,t3.[nvarchar4] AS QryCol20,t3.[nvarchar5] AS QryCol21,t3.[tp_Created] AS QryCol22,NULL AS
QryCol23,NULL AS QryCol24,NULL AS QryCol25,UserData.[float1] AS QryCol26,UserData.[nvarchar3] AS
QryCol27,UserData.[nvarchar9] AS QryCol28,UserData.[int3] AS QryCol29,t4.[nvarchar1] AS
QryCol30,UserData.[nvarchar11] AS QryCol31,t5.[Status1] AS QryCol32,t1.[ScopeId] AS QryCol33,t1.[Id] AS
QryCol34,ListOrds.[ListProperty.DraftVersionVisibility] AS QryCol35 FROM @tblListOrds AS ListOrds INNER LOOP
JOIN UserData WITH(NOLOCK) ON ListOrds.ListId=UserData.tp_ListId AND ListOrds.JoinOrd=0 INNER JOIN Docs AS t1
WITH(NOLOCK) ON ( 1 = 1 AND UserData.[tp_RowOrdinal] = 0 AND t1.SiteId = UserData.tp_SiteId AND t1.SiteId =
@L2 AND t1.DirName = UserData.tp_DirName AND t1.LeafName = UserData.tp_LeafName AND t1.Level =
UserData.tp_Level AND t1.IsCurrentVersion = 1 AND (1 = 1)) LEFT OUTER JOIN AllUserData AS t2 WITH(NOLOCK,
INDEX=AllUserData_PK) ON (UserData.[tp_Author]=t2.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND
t2.[tp_RowOrdinal] = 0 AND ( (t2.tp_IsCurrent = 1) ) AND t2.[tp_CalculatedVersion] = 0 AND
t2.[tp_DeleteTransactionId] = 0x AND t2.tp_ListId = ListOrds.JoinKeyId1) LEFT OUTER JOIN AllUserData AS t3
WITH(NOLOCK, INDEX=AllUserData_PK) ON (UserData.[tp_Editor]=t3.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND
t3.[tp_RowOrdinal] = 0 AND ( (t3.tp_IsCurrent = 1) ) AND t3.[tp_CalculatedVersion] = 0 AND
t3.[tp_DeleteTransactionId] = 0x AND t3.tp_ListId = ListOrds.JoinKeyId1) LEFT OUTER JOIN AllUserData AS t4
WITH(NOLOCK, INDEX=AllUserData_PK) ON (UserData.[int3]=t4.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND
t4.[tp_RowOrdinal] = 0 AND ( (t4.tp_IsCurrent = 1) ) AND t4.[tp_CalculatedVersion] = 0 AND
t4.[tp_DeleteTransactionId] = 0x AND t4.tp_ListId = ListOrds.JoinKeyId2) LEFT OUTER JOIN Workflow AS t5
WITH(NOLOCK) ON ( CAST ( CAST (UserData.[nvarchar11]AS VARBINARY) AS UNIQUEIDENTIFIER)=t5.[ID] AND
UserData.[tp_RowOrdinal] = 0 AND t5.SiteId = @L2 AND t5.ListId = UserData.tp_ListId AND t5.ItemId =
UserData.tp_Id) WHERE ((UserData.[tp_ContentTypeId]) >= 0x0100F132384C21CDBA40853CA2E349C19AC6 AND
(UserData.[tp_ContentTypeId]) <= 0x0100F132384C21CDBA40853CA2E349C19AC6 + 0xff) UNION ALL SELECT
UserData.[tp_ID] AS QryCol0,ListOrds.[WebId] AS QryCol1,ListOrds.[ListId] AS QryCol2,UserData.[tp_Created] AS
QryCol3,t1.[Type] AS QryCol4,CASE WHEN DATALENGTH(t1.DirName) = 0 THEN t1.LeafName WHEN DATALENGTH(t1.LeafName)
= 0 THEN t1.DirName ELSE t1.DirName + N''/'' + t1.LeafName END AS QryCol5,UserData.[tp_ModerationStatus] AS
QryCol6,UserData.[tp_Level] AS QryCol7,UserData.[ntext1] AS QryCol8,UserData.[nvarchar1] AS
QryCol9,UserData.[tp_Modified] AS QryCol10,UserData.[tp_Author] AS QryCol11,t2.[nvarchar1] AS
QryCol12,t2.[tp_ID] AS QryCol13,t2.[nvarchar4] AS QryCol14,t2.[nvarchar5] AS QryCol15,t2.[tp_Created] AS
QryCol16,UserData.[tp_Editor] AS QryCol17,t3.[nvarchar1] AS QryCol18,t3.[tp_ID] AS QryCol19,t3.[nvarchar4] AS
QryCol20,t3.[nvarchar5] AS QryCol21,t3.[tp_Created] AS QryCol22,NULL AS QryCol23,NULL AS QryCol24,NULL AS
QryCol25,UserData.[float1] AS QryCol26,UserData.[nvarchar3] AS QryCol27,UserData.[nvarchar9] AS
QryCol28,UserData.[int3] AS QryCol29,t4.[nvarchar1] AS QryCol30,UserData.[nvarchar11] AS QryCol31,8 AS
QryCol32,t1.[ScopeId] AS QryCol33,t1.[Id] AS QryCol34,ListOrds.[ListProperty.DraftVersionVisibility] AS
QryCol35 FROM @tblListOrds AS ListOrds INNER LOOP JOIN UserData WITH(NOLOCK) ON
ListOrds.ListId=UserData.tp_ListId AND ListOrds.JoinOrd=1 INNER JOIN Docs AS t1 WITH(NOLOCK) ON ( 1 = 1 AND
UserData.[tp_RowOrdinal] = 0 AND t1.SiteId = UserData.tp_SiteId AND t1.SiteId = @L2 AND t1.DirName =
UserData.tp_DirName AND t1.LeafName = UserData.tp_LeafName AND t1.Level = UserData.tp_Level AND
t1.IsCurrentVersion = 1 AND (1 = 1)) LEFT OUTER JOIN AllUserData AS t2 WITH(NOLOCK, INDEX=AllUserData_PK) ON
(UserData.[tp_Author]=t2.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t2.[tp_RowOrdinal] = 0 AND (
(t2.tp_IsCurrent = 1) ) AND t2.[tp_CalculatedVersion] = 0 AND t2.[tp_DeleteTransactionId] = 0x AND
t2.tp_ListId = ListOrds.JoinKeyId1) LEFT OUTER JOIN AllUserData AS t3 WITH(NOLOCK, INDEX=AllUserData_PK) ON
(UserData.[tp_Editor]=t3.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t3.[tp_RowOrdinal] = 0 AND (
(t3.tp_IsCurrent = 1) ) AND t3.[tp_CalculatedVersion] = 0 AND t3.[tp_DeleteTransactionId] = 0x AND
t3.tp_ListId = ListOrds.JoinKeyId1) LEFT OUTER JOIN AllUserData AS t4 WITH(NOLOCK, INDEX=AllUserData_PK) ON
(UserData.[int3]=t4.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t4.[tp_RowOrdinal] = 0 AND ( (t4.tp_IsCurrent
= 1) ) AND t4.[tp_CalculatedVersion] = 0 AND t4.[tp_DeleteTransactionId] = 0x AND t4.tp_ListId =
ListOrds.JoinKeyId2) WHERE ((UserData.[tp_ContentTypeId]) >= 0x0100F132384C21CDBA40853CA2E349C19AC6 AND
(UserData.[tp_ContentTypeId]) <= 0x0100F132384C21CDBA40853CA2E349C19AC6 + 0xff)',N'@L0 uniqueidentifier,@L2
uniqueidentifier',@L0='00000000-0000-0000-0000-000000000000',@L2='3B93D04F-7A20-4A69-9E97-611C553FFCB7'
Notice that the first 15 INSERT INTO Statements have the followign pattern
INSERT INTO @tblListOrds SELECT ''22103B05-EF3B-48CA-B0C4-89BFA57691ED'',''047C823F-B3DA-4E70-99FB-0BA20DA2FF73'',0,0,1
but after the first 15 INSERT INTO STATEMENT the pattern becomes
INSERT INTO @tblListOrds SELECT ''22103B05-EF3B-48CA-B0C4-89BFA57691ED'',''047C823F-B3DA-4E70-99FB-0BA20DA2FF73'',0,1,1
If I take this QUERY and update these insert statements to all follow the first pattern, all results are returned as expected.
Otherwise only the first 15 rows are returned the the correct values, with the remaining rows returning AuditWor = 8
Thanks,
Mike
February 8th, 2012 11:57am
Also.. I just realized I posted this in SP2010 forum. I am having this issue on SP 2007. I have tried to fix on SP1, SP2, and SP3.
Sorry for the inconvienience. Can you still help?
Free Windows Admin Tool Kit Click here and download it now
February 8th, 2012 12:55pm
Hi,
Yes, we can still help. We will try to repro this with the new information.Regards, Savoeurn Va Microsoft Online Community Support
February 16th, 2012 5:55am
Hi,
Yes, we can still help. We will try to repro this with the new information.Regards, Savoeurn Va Microsoft Online Community Support
Free Windows Admin Tool Kit Click here and download it now
February 16th, 2012 5:55am
Any luck? In the meantime I have added a step to shuffle the actual Workflow Status variable over to another field, which is working in the interim.
February 29th, 2012 12:00pm
Hi Mr Pullen,
Sorry about the long delay in response, Ive been out of the office for some time. As for this repro, I still cannot get it to repro on our
side with the new information. There might be something else on your farm that we are not seeing. If you would like to investigate this further, you could open a paid support ticket and discuss with an engineer on a 1:1 basis to determine
the cause of this on
your environment.
In the meantime, members of the community are welcome to contribute to this thread.Regards, Savoeurn Va Microsoft Online Community Support
Free Windows Admin Tool Kit Click here and download it now
March 30th, 2012 6:09pm
This topic is archived. No further replies will be accepted.
Other recent topics
