selecttop@pagesizepe_nodes.*frompe_nodeswherenodeidnotin(selecttop@startrownodeidfrompe_nodeswhereparentid=@parentidorderbyorderid)and(parentid=@parentid)orderbyorderid
<![CDATA[SELECT Top @pagesize PE_Nodes.* FROM PE_Nodes WHERE NodeID NOT IN (SELECT TOP @startrow NodeID FROM PE_Nodes where ParentID = @parentid order by OrderID) and (ParentID = @parentid)  AND PurviewType < 3 order by OrderID]]>
selectcount(*)frompe_nodeswhereparentid=@parentid
<![CDATA[SELECT count(*) from PE_Nodes where ParentID = @parentid AND PurviewType < 3]]>
selecttop1c.generalid,c.title,c.hits,c.updatetimefromdbo.pe_nodesn,dbo.pe_commonmodelcwherec.generalid>@itemidandcharindex(','+rtrim(c.nodeid)+',',','+cast(@arrnodeidasnvarchar(100))+',')>0andc.status=99andn.parentid=@parentidorderbyc.generalidasc
<![CDATA[SELECT TOP 1 C.GeneralID,C.Title,C.Hits,C.UpdateTime FROM dbo.PE_Nodes N,dbo.PE_CommonModel C WHERE C.GeneralID > @ItemID AND CHARINDEX(',' + RTRIM(C.NodeID) +',',',' + CAST(@arrNodeID AS NVARCHAR(100)) +',') > 0 AND C.Status = 99 AND N.ParentID = @ParentID  AND N.PurviewType < 3 ORDER BY C.GeneralID ASC]]>
selecttop@shownumc.generalid,c.nodeid,c.inputtime,c.title,c.pinyintitle,c.updatetime,n.nodenamefrompe_commonmodelcleftjoinpe_nodesnonc.nodeid=n.nodeidwherec.status=99andc.elitelevel>=@elitelevelorderbyc.updatetimedesc
<![CDATA[SELECT TOP @shownum C.GeneralID,C.NodeID,C.InputTime,C.Title,C.PinyinTitle,C.UpdateTime,N.NodeName FROM PE_CommonModel C LEFT JOIN PE_Nodes N ON C.NodeID=N.NodeID WHERE C.Status = 99 AND C.EliteLevel >= @elitelevel  AND N.PurviewType < 3 ORDER BY C.UpdateTime DESC ]]>
selectnodeid,nodenamefrompe_nodeswherenodeid=@parentid
<![CDATA[SELECT NodeID,NodeName FROM PE_Nodes WHERE NodeID=@parentid AND PurviewType < 3]]>
selecttop1*frompe_nodeswherenodeid=@parentid
<![CDATA[SELECT Top 1 * FROM PE_Nodes WHERE NodeID = @parentid AND PurviewType < 3 ]]>
selectn.nodeid,n.nodename,n.parentpath,c.titlefrompe_nodesninnerjoinpe_commonmodelconn.nodeid=c.nodeidwherec.generalid=@itemid
<![CDATA[SELECT N.NodeID,N.NodeName,N.ParentPath,C.Title FROM PE_Nodes N INNER JOIN PE_CommonModel C ON N.NodeID=C.NodeID  WHERE C.GeneralID=@itemid AND PurviewType < 3]]>
selectnodeid,nodename,arrchildid,parentpathfrompe_nodeswherenodeid=@parentid
<![CDATA[SELECT NodeID,NodeName,arrChildID,ParentPath FROM PE_Nodes WHERE NodeID=@parentid AND PurviewType < 3]]>
selectrootidfrompe_nodeswherenodeid=(selectnodeidfrompe_commonmodelwheregeneralid=@generalid)
<![CDATA[SELECT rootId from pe_nodes where nodeid=(SELECT nodeid from pe_commonModel where generalid=@generalid)  AND PurviewType < 3]]>
selecttop@pagesizepe_nodes.*frompe_nodeswherenodeidnotin(selecttop@startrownodeidfrompe_nodeswhere(parentid=@parentidornodeid=@parentid)andshowonlist_parent=1orderbyorderid)and((parentid=@parentid)or(nodeid=@parentid))andshowonlist_parent=1orderbyorderid
<![CDATA[SELECT Top @pagesize PE_Nodes.* FROM PE_Nodes WHERE NodeID NOT IN (SELECT TOP @startrow NodeID FROM PE_Nodes where (ParentID = @parentid OR NodeID=@parentid) AND ShowOnList_Parent=1 AND PurviewType < 3 order by OrderID) and ((ParentID = @parentid)  OR (NodeID=@parentid)) AND ShowOnList_Parent=1 AND PurviewType < 3 order by OrderID]]>
selectcount(*)frompe_nodeswhere(parentid=@parentidornodeid=@parentid)andshowonlist_parent=1
<![CDATA[SELECT count(*) from PE_Nodes where (ParentID = @parentid OR NodeID=@parentid) AND ShowOnList_Parent=1 AND PurviewType < 3 ]]>
selectnodeid,arrchildidfrompe_nodeswhereparentid=@parentid
<![CDATA[SELECT NodeID,arrChildID FROM PE_Nodes WHERE ParentId=@parentid AND PurviewType < 3 ]]>
selecttop@shownumpe_nodes.*frompe_nodeswherenodeidnotin(selecttop@startrownodeidfrompe_nodeswhere(parentid=@parentidornodeid=@parentid)andshowonlist_parent=1orderbyorderid)and(parentid=@parentidornodeid=@parentid)andshowonlist_parent=1orderbyorderid
<![CDATA[SELECT Top @shownum PE_Nodes.* FROM PE_Nodes WHERE NodeID NOT IN (SELECT TOP @startrow NodeID FROM PE_Nodes where (ParentID = @parentid or NodeID=@parentid) AND ShowOnList_Parent=1  order by OrderID) and (ParentID = @parentid or NodeID=@parentid AND PurviewType < 3 ) AND ShowOnList_Parent=1 AND PurviewType < 3 order by OrderID]]>
selectnodeid,nodename,showonlist_parentfrompe_nodeswherenodeid=@nodeidandnodetype=1orderbyorderidasc
<![CDATA[SELECT nodeId,nodeName,ShowOnList_Parent from pe_nodes where NodeId=@nodeid and NodeType=1 AND PurviewType < 3  ORDER BY OrderID ASC]]>
selectnodeid,nodenamefrompe_nodeswherenodeid=@nodeid
<![CDATA[SELECT NodeID,NodeName From PE_Nodes Where NodeID=@nodeid AND PurviewType < 3 ]]>
selectnodeid,arrchildidfrompe_nodeswherenodeid=@parentid
<![CDATA[SELECT NodeID,arrChildID from PE_Nodes where NodeID=@parentid AND PurviewType < 3]]>
selectarrchildidfrompe_nodeswherenodeid=@parentid
<![CDATA[SELECT arrchildid from PE_Nodes where NodeID=@parentid AND PurviewType < 3 ]]>
selecttop@pagesizepe_nodes.*frompe_nodeswherenodeidnotin(selecttop@startrownodeidfrompe_nodeswhereparentid=@parentidandshowonlist_parent=1orderbyorderid)and(parentid=@parentid)andshowonlist_parent=1orderbyorderid
<![CDATA[SELECT Top @pagesize PE_Nodes.* FROM PE_Nodes WHERE NodeID NOT IN (SELECT TOP @startrow NodeID FROM PE_Nodes where ParentID = @parentid AND ShowOnList_Parent=1 AND PurviewType < 3 order by OrderID) and (ParentID = @parentid) AND ShowOnList_Parent=1 AND PurviewType < 3  order by OrderID]]>
selectcount(*)frompe_nodeswhereparentid=@parentidandshowonlist_parent=1
<![CDATA[SELECT count(*) from PE_Nodes where ParentID = @parentid AND ShowOnList_Parent=1 AND PurviewType < 3 ]]>
selecttop@pagesizepe_nodes.*frompe_nodeswherenodeidnotin(selecttop@startrownodeidfrompe_nodeswhereparentid=@parentidandshowonlist_parent=1orderbyorderid)and(parentid=@parentid)orderbyorderid
<![CDATA[SELECT Top @pagesize PE_Nodes.* FROM PE_Nodes WHERE NodeID NOT IN (SELECT TOP @startrow NodeID FROM PE_Nodes where ParentID = @parentid AND ShowOnList_Parent=1 AND PurviewType < 3 order by OrderID) and (ParentID = @parentid) AND PurviewType < 3 order by OrderID]]>
selecttop@shownumc.generalid,c.nodeid,c.inputtime,c.title,c.pinyintitle,c.updatetime,c.defaultpicurl,n.nodename,t.*from(pe_commonmodelcinnerjoinpe_nodesnonc.nodeid=n.nodeid)innerjoinpe_u_phototonc.itemid=t.idwhere(n.nodeid=@parentidorn.parentid=@parentid)andc.tablename='pe_u_photo'andc.status=99andc.defaultpicurl<>''orderbyc.updatetimedesc
<![CDATA[SELECT TOP @shownum C.GeneralID,C.NodeID,C.InputTime,C.Title,C.PinyinTitle,C.UpdateTime,C.DefaultPicUrl,N.NodeName,T.*  FROM (PE_CommonModel C INNER JOIN PE_Nodes N ON C.NodeID=N.NodeID) INNER JOIN PE_U_Photo T ON C.ItemID=T.ID WHERE (N.NodeID=@parentid OR N.ParentId=@parentid) AND C.TableName='PE_U_Photo' AND C.Status=99 AND C.DefaultPicUrl<>'' AND N.PurviewType < 3 ORDER BY C.UpdateTime DESC ]]>
selecttop@shownumc.generalid,c.nodeid,c.title,c.updatetime,c.defaultpicurl,n.nodename,t.*from(pe_commonmodelcinnerjoinpe_nodesnonc.nodeid=n.nodeid)innerjoinpe_u_phototonc.itemid=t.idwhere(n.nodeid=@parentidorn.parentid=@parentid)andc.tablename='pe_u_photo'andc.status=99andc.defaultpicurl<>''orderbyc.updatetimedesc
<![CDATA[SELECT TOP @shownum C.GeneralID,C.NodeID,C.Title,C.UpdateTime,C.DefaultPicUrl,N.NodeName,T.*  FROM (PE_CommonModel C INNER JOIN PE_Nodes N ON C.NodeID=N.NodeID) INNER JOIN PE_U_Photo T ON C.ItemID=T.ID WHERE (N.NodeID=@parentid OR N.ParentId=@parentid) AND C.TableName='PE_U_Photo' AND C.Status=99 AND C.DefaultPicUrl<>'' AND N.PurviewType < 3 ORDER BY C.UpdateTime DESC ]]>
selecttop1nodeid,nodenamefrompe_nodeswherenodeid=@parentid
<![CDATA[SELECT TOP 1 NodeID,NodeName FROM PE_Nodes WHERE NodeID=@parentid AND PurviewType < 3]]>
selectnodeid,nodename,showonlist_indexfrompe_nodeswhereparentid=@nodeidandnodetype=1andshowonlist_parent=1orderbyorderidasc
<![CDATA[SELECT nodeid,nodename,showonlist_index from pe_nodes where ParentId=@nodeid and NodeType=1 and ShowOnList_Parent=1 and PurviewType < 3  order by OrderID asc]]>
selectnodeid,nodenamefrompe_nodeswhereparentid=@nodeidandnodetype=1andshowonlist_parent=1orderbyorderidasc
<![CDATA[SELECT NodeID,NodeName from PE_Nodes where ParentID=@nodeid and NodeType=1 and ShowOnList_Parent=1 AND PurviewType < 3 order by OrderID asc]]>
selectnodeid,nodename,child,nextid,depthfrompe_nodeswhereparentid=@nodeid
<![CDATA[SELECT NodeID,NodeName,Child,NextID,Depth from PE_Nodes where ParentID=@nodeid AND PurviewType < 3 ]]>
selectnodeid,nodename,parentpath,showonpathfrompe_nodeswherenodeid=@nodeid
<![CDATA[SELECT NodeID,NodeName,ParentPath,ShowOnPath FROM PE_Nodes WHERE NodeID=@nodeid and PurviewType < 3 ]]>
selecttop1arrchildidfrompe_nodeswherenodeid=3
<![CDATA[SELECT TOP 1 arrChildId FROM PE_Nodes WHERE NodeID =3 AND PurviewType < 3]]>
selecttop@shownumc.generalid,c.nodeid,c.inputtime,c.title,c.pinyintitle,c.updatetime,n.nodename,t.*from(pe_commonmodelcinnerjoinpe_nodesnonc.nodeid=n.nodeid)innerjoinpe_u_articletonc.itemid=t.idwhere(n.nodeid=@parentidorn.parentid=@parentid)andc.tablename='pe_u_article'andc.status=99andc.defaultpicurl<>''orderbyc.updatetimedesc
<![CDATA[SELECT TOP @shownum C.GeneralID,C.NodeID,C.InputTime,C.Title,C.PinyinTitle,C.UpdateTime,N.NodeName,T.*  FROM (PE_CommonModel C INNER JOIN PE_Nodes N ON C.NodeID=N.NodeID) INNER JOIN PE_U_Article T ON C.ItemID=T.ID WHERE (N.NodeID=@parentid OR N.ParentId=@parentid) AND C.TableName='PE_U_Article' AND C.Status=99 AND C.DefaultPicUrl<>'' AND N.PurviewType < 3 ORDER BY C.UpdateTime DESC ]]>
selectcount(*)frompe_nodeswherenodeid=@parentid
<![CDATA[SELECT count(*) from PE_Nodes WHERE NodeID=@parentid AND PurviewType < 3]]>
selecttop1nodeid,nodenamefrompe_nodes
<![CDATA[SELECT TOP 1 NodeID,NodeName FROM PE_Nodes WHERE  PurviewType < 3]]>
selecttop1nodeid,arrchildidfrompe_nodeswherenodeid=@parentid
<![CDATA[SELECT TOP 1 NodeID,arrChildID FROM PE_Nodes WHERE NodeID=@parentid AND PurviewType < 3]]>
selectnodeid,nodename,showonlist_parentfrompe_nodeswhereparentid=@nodeidandnodetype=1andpurviewtype<>3orderbyorderidasc
<![CDATA[SELECT NodeID,NodeName,ShowOnList_Parent from PE_Nodes where ParentId=@nodeid and NodeType=1 and PurviewType < 3 order by OrderID asc]]>
selectnodeid,nodename,child,depthfrompe_nodeswhereparentid=@nodeid
<![CDATA[SELECT NodeID,NodeName,Child,Depth from PE_Nodes where ParentID=@nodeid AND PurviewType < 3 ]]>
selecttop@pagesizepe_nodes.*frompe_nodeswherenodeidnotin(selecttop@startrownodeidfrompe_nodeswhereparentid=@parentidandnodetype=1andshowonlist_parent=1orderbyorderid)and(parentid=@parentid)andnodetype=1andshowonlist_parent=1orderbyorderid
<![CDATA[SELECT Top @pagesize PE_Nodes.* FROM PE_Nodes WHERE NodeID NOT IN (SELECT TOP @startrow NodeID FROM PE_Nodes where ParentID = @parentid and NodeType=1 AND ShowOnList_Parent=1  AND PurviewType < 3  order by OrderID) and (ParentID = @parentid) and NodeType=1 AND ShowOnList_Parent=1 AND PurviewType < 3  order by OrderID]]>
selectcount(*)frompe_nodeswhereparentid=@parentidandnodetype=1andshowonlist_parent=1
<![CDATA[SELECT count(*) from PE_Nodes where ParentID = @parentid and NodeType=1 AND ShowOnList_Parent=1 AND PurviewType < 3 ]]>
selecttop@shownumc.generalid,c.nodeid,c.inputtime,c.title,c.pinyintitle,c.updatetime,n.nodenamefrompe_commonmodelcleftjoinpe_nodesnonc.nodeid=n.nodeidwherec.nodeidin(selectsn.nodeidfrompe_nodessnwhere(sn.nodeid=@parentidorsn.parentid=@parentid))andstatus=99and@fieldname&gt;=@fieldvalueanddatediff(d,updatetime,getdate())&lt;@daysorderby@fieldnamedesc
<![CDATA[SELECT TOP @shownum C.GeneralID,C.NodeID,C.InputTime,C.Title,C.PinyinTitle,C.UpdateTime,N.NodeName  FROM PE_CommonModel C LEFT JOIN PE_Nodes N ON C.NodeID=N.NodeID WHERE C.NodeID IN(SELECT SN.NodeID FROM PE_Nodes SN WHERE (SN.NodeID=@parentid OR SN.ParentId=@parentid)) AND Status=99 AND @fieldname>=@fieldvalue  AND Datediff(d,UpdateTime,getdate()) < @days AND N.PurviewType < 3 ORDER BY @fieldname DESC]]>
selecttop@num*frompe_nodeswhereparentid=0andshowonmenu=1andpurviewtype<>3orderbyrootid
<![CDATA[SELECT top @num * from PE_Nodes WHERE ParentID=0 and ShowOnMenu=1 and PurviewType < 3 order by RootID]]>
selectnodeid,nodename,showonpathfrompe_nodeswherenodeidin(@parentpath)orderbyrootid,orderidasc
<![CDATA[SELECT NodeID,NodeName,ShowOnPath FROM PE_Nodes WHERE NodeID IN(@parentpath) AND PurviewType < 3  order by RootID, OrderID ASC]]>
selectnodeid,custom_contentfrompe_nodeswherenodeid=@nodeid
<![CDATA[SELECT NodeId,Custom_Content from PE_Nodes where NodeID=@nodeid AND PurviewType < 3]]>
select*frompe_nodeswherenodeid=@nodeidandnodetype=1orderbyorderid
<![CDATA[SELECT * FROM PE_Nodes WHERE NodeID = @nodeid and NodeType=1 AND PurviewType < 3 order by OrderID]]>
selectcount(*)frompe_nodeswhereparentid=@parentidandnodetype=1
<![CDATA[SELECT count(*) from PE_Nodes where ParentID = @parentid and NodeType=1 AND PurviewType < 3]]>
selecttop@shownumc.generalid,c.nodeid,c.inputtime,c.title,c.pinyintitle,c.updatetime,n.nodename,t.*from(pe_commonmodelcinnerjoinpe_nodesnonc.nodeid=n.nodeid)innerjoinpe_u_softtonc.itemid=t.idwhere(c.nodeid=@parentidorc.parentid=@parentid)andc.tablename='pe_u_soft'andc.status=99andc.defaultpicurl<>''orderbyc.updatetimedesc
<![CDATA[SELECT TOP @shownum C.GeneralID,C.NodeID,C.InputTime,C.Title,C.PinyinTitle,C.UpdateTime,N.NodeName,T.*  FROM (PE_CommonModel C INNER JOIN PE_Nodes N ON C.NodeID=N.NodeID) INNER JOIN PE_U_Soft T ON C.ItemID=T.ID WHERE (C.NodeID=@parentid OR C.ParentId=@parentid) AND C.TableName='PE_U_Soft' AND C.Status=99 AND C.DefaultPicUrl<>'' AND N.PurviewType < 3 ORDER BY C.UpdateTime DESC ]]>
selecttop@num*frompe_nodeswhereparentid=0andshowonmenu=1orderbyrootid
<![CDATA[SELECT top @num * from PE_Nodes WHERE ParentID=0 and ShowOnMenu=1 and PurviewType < 3 order by RootID]]>
