📄 幻灯片效果显示图片_查询条件.config
字号:
<!-- 日期范围查询datenum=0 -->
<xsl:if test="$datenum=0">
<!-- SELECT Top @shownum C.*,T.* FROM PE_CommonModel C INNER JOIN @tablename T ON C.ItemID=T.ID WHERE C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel AND C.TableName='@tablename' AND C.DefaultPicUrl !='' ORDER BY @sqlordertype -->
{PE.Label id="显示幻灯片效果显示图片" parentid="<xsl:value-of select="$parentid" />" arrnodeid="<xsl:value-of select="arrChildID" />" includechild ="<xsl:value-of select="$includechild" />" specialid="<xsl:value-of select="$specialid" />" shownum="<xsl:value-of select="$shownum" />" ishot="<xsl:value-of select="$ishot" />" iselite="<xsl:value-of select="$iselite" />" datenum="<xsl:value-of select="$datenum" />" ordertype="<xsl:value-of select="$ordertype" />" imgwidth="<xsl:value-of select="$imgwidth" />" imgheight="<xsl:value-of select="$imgheight" />" titlelen="<xsl:value-of select="$titlelen" />" timeout="<xsl:value-of select="$timeout" />" effectid="<xsl:value-of select="$effectid" />" hits="<xsl:value-of select="$hits" />" elitelevel="<xsl:value-of select="$elitelevel" />" tablename="<xsl:value-of select="$tablename" />" strsql="SELECT Top @shownum C.*,T.* FROM PE_CommonModel C INNER JOIN @tablename T ON C.ItemID=T.ID WHERE C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel AND C.TableName='@tablename' AND C.DefaultPicUrl !='' ORDER BY <xsl:value-of select="$sqlordertype" /> " /}
</xsl:if>
<!-- 日期范围查询datenum>0 -->
<xsl:if test="$datenum>0">
<!-- SELECT Top @shownum C.*,T.* FROM PE_CommonModel C INNER JOIN @tablename T ON C.ItemID=T.ID WHERE C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel AND C.TableName='@tablename' AND C.DefaultPicUrl !='' AND Datediff(d,C.UpdateTime,getdate())<=@datenum ORDER BY @sqlordertype -->
{PE.Label id="显示幻灯片效果显示图片" parentid="<xsl:value-of select="$parentid" />" arrnodeid="<xsl:value-of select="arrChildID" />" includechild ="<xsl:value-of select="$includechild" />" specialid="<xsl:value-of select="$specialid" />" shownum="<xsl:value-of select="$shownum" />" ishot="<xsl:value-of select="$ishot" />" iselite="<xsl:value-of select="$iselite" />" datenum="<xsl:value-of select="$datenum" />" ordertype="<xsl:value-of select="$ordertype" />" imgwidth="<xsl:value-of select="$imgwidth" />" imgheight="<xsl:value-of select="$imgheight" />" titlelen="<xsl:value-of select="$titlelen" />" timeout="<xsl:value-of select="$timeout" />" effectid="<xsl:value-of select="$effectid" />" hits="<xsl:value-of select="$hits" />" elitelevel="<xsl:value-of select="$elitelevel" />" tablename="<xsl:value-of select="$tablename" />" strsql="SELECT Top @shownum C.*,T.* FROM PE_CommonModel C INNER JOIN @tablename T ON C.ItemID=T.ID WHERE C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel AND C.TableName='@tablename' AND C.DefaultPicUrl !='' AND @datenum>=Datediff(d,C.UpdateTime,getdate()) ORDER BY <xsl:value-of select="$sqlordertype" /> " /}
</xsl:if>
</xsl:if>
</xsl:if>
<!-- 指定专题 -->
<xsl:if test="$specialid!='0'">
<!-- 查询所有内容shownum=0 -->
<xsl:if test="$shownum=0">
<!-- 日期范围查询datenum=0 -->
<xsl:if test="$datenum=0">
<!-- SELECT C.*,T.* FROM PE_CommonModel C INNER JOIN @tablename T ON C.ItemID=T.ID WHERE C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel AND C.TableName='@tablename' AND C.DefaultPicUrl !='' AND C.GeneralID IN(SELECT S.GeneralID FROM PE_SpecialInfos S WHERE S.SpecialID IN(@specialid)) ORDER BY @sqlordertype -->
{PE.Label id="显示幻灯片效果显示图片" parentid="<xsl:value-of select="$parentid" />" arrnodeid="<xsl:value-of select="arrChildID" />" includechild ="<xsl:value-of select="$includechild" />" specialid="<xsl:value-of select="$specialid" />" shownum="<xsl:value-of select="$shownum" />" ishot="<xsl:value-of select="$ishot" />" iselite="<xsl:value-of select="$iselite" />" datenum="<xsl:value-of select="$datenum" />" ordertype="<xsl:value-of select="$ordertype" />" imgwidth="<xsl:value-of select="$imgwidth" />" imgheight="<xsl:value-of select="$imgheight" />" titlelen="<xsl:value-of select="$titlelen" />" timeout="<xsl:value-of select="$timeout" />" effectid="<xsl:value-of select="$effectid" />" hits="<xsl:value-of select="$hits" />" elitelevel="<xsl:value-of select="$elitelevel" />" tablename="<xsl:value-of select="$tablename" />" strsql="SELECT C.*,T.* FROM PE_CommonModel C INNER JOIN @tablename T ON C.ItemID=T.ID WHERE C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel AND C.TableName='@tablename' AND C.DefaultPicUrl !='' AND C.GeneralID IN(SELECT S.GeneralID FROM PE_SpecialInfos S WHERE S.SpecialID IN(@specialid)) ORDER BY <xsl:value-of select="$sqlordertype" /> " /}
</xsl:if>
<!-- 日期范围查询datenum>0 -->
<xsl:if test="$datenum>0">
<!-- SELECT C.*,T.* FROM PE_CommonModel C INNER JOIN @tablename T ON C.ItemID=T.ID WHERE C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel AND C.TableName='@tablename' AND C.DefaultPicUrl !='' AND Datediff(d,C.UpdateTime,getdate())<=@datenum AND C.GeneralID IN(SELECT S.GeneralID FROM PE_SpecialInfos S WHERE S.SpecialID IN(@specialid)) ORDER BY @sqlordertype -->
{PE.Label id="显示幻灯片效果显示图片" parentid="<xsl:value-of select="$parentid" />" arrnodeid="<xsl:value-of select="arrChildID" />" includechild ="<xsl:value-of select="$includechild" />" specialid="<xsl:value-of select="$specialid" />" shownum="<xsl:value-of select="$shownum" />" ishot="<xsl:value-of select="$ishot" />" iselite="<xsl:value-of select="$iselite" />" datenum="<xsl:value-of select="$datenum" />" ordertype="<xsl:value-of select="$ordertype" />" imgwidth="<xsl:value-of select="$imgwidth" />" imgheight="<xsl:value-of select="$imgheight" />" titlelen="<xsl:value-of select="$titlelen" />" timeout="<xsl:value-of select="$timeout" />" effectid="<xsl:value-of select="$effectid" />" hits="<xsl:value-of select="$hits" />" elitelevel="<xsl:value-of select="$elitelevel" />" tablename="<xsl:value-of select="$tablename" />" strsql="SELECT C.*,T.* FROM PE_CommonModel C INNER JOIN @tablename T ON C.ItemID=T.ID WHERE C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel AND C.TableName='@tablename' AND C.DefaultPicUrl !='' AND @datenum>=Datediff(d,C.UpdateTime,getdate()) AND C.GeneralID IN(SELECT S.GeneralID FROM PE_SpecialInfos S WHERE S.SpecialID IN(@specialid)) ORDER BY <xsl:value-of select="$sqlordertype" /> " /}
</xsl:if>
</xsl:if>
<!-- 查询所有内容shownum>0 -->
<xsl:if test="$shownum>0">
<!-- 日期范围查询datenum=0 -->
<xsl:if test="$datenum=0">
<!-- SELECT Top @shownum C.*,T.* FROM PE_CommonModel C INNER JOIN @tablename T ON C.ItemID=T.ID WHERE C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel AND C.TableName='@tablename' AND C.DefaultPicUrl !='' AND C.GeneralID IN(SELECT S.GeneralID FROM PE_SpecialInfos S WHERE S.SpecialID IN(@specialid)) ORDER BY @sqlordertype -->
{PE.Label id="显示幻灯片效果显示图片" parentid="<xsl:value-of select="$parentid" />" arrnodeid="<xsl:value-of select="arrChildID" />" includechild ="<xsl:value-of select="$includechild" />" specialid="<xsl:value-of select="$specialid" />" shownum="<xsl:value-of select="$shownum" />" ishot="<xsl:value-of select="$ishot" />" iselite="<xsl:value-of select="$iselite" />" datenum="<xsl:value-of select="$datenum" />" ordertype="<xsl:value-of select="$ordertype" />" imgwidth="<xsl:value-of select="$imgwidth" />" imgheight="<xsl:value-of select="$imgheight" />" titlelen="<xsl:value-of select="$titlelen" />" timeout="<xsl:value-of select="$timeout" />" effectid="<xsl:value-of select="$effectid" />" hits="<xsl:value-of select="$hits" />" elitelevel="<xsl:value-of select="$elitelevel" />" tablename="<xsl:value-of select="$tablename" />" strsql="SELECT Top @shownum C.*,T.* FROM PE_CommonModel C INNER JOIN @tablename T ON C.ItemID=T.ID WHERE C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel AND C.TableName='@tablename' AND C.DefaultPicUrl !='' AND C.GeneralID IN(SELECT S.GeneralID FROM PE_SpecialInfos S WHERE S.SpecialID IN(@specialid)) ORDER BY <xsl:value-of select="$sqlordertype" /> " /}
</xsl:if>
<!-- 日期范围查询datenum>0 -->
<xsl:if test="$datenum>0">
<!-- SELECT Top @shownum C.*,T.* FROM PE_CommonModel C INNER JOIN @tablename T ON C.ItemID=T.ID WHERE C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel AND C.TableName='@tablename' AND C.DefaultPicUrl !='' AND Datediff(d,C.UpdateTime,getdate())<=@datenum AND C.GeneralID IN(SELECT S.GeneralID FROM PE_SpecialInfos S WHERE S.SpecialID IN(@specialid)) ORDER BY @sqlordertype -->
{PE.Label id="显示幻灯片效果显示图片" parentid="<xsl:value-of select="$parentid" />" arrnodeid="<xsl:value-of select="arrChildID" />" includechild ="<xsl:value-of select="$includechild" />" specialid="<xsl:value-of select="$specialid" />" shownum="<xsl:value-of select="$shownum" />" ishot="<xsl:value-of select="$ishot" />" iselite="<xsl:value-of select="$iselite" />" datenum="<xsl:value-of select="$datenum" />" ordertype="<xsl:value-of select="$ordertype" />" imgwidth="<xsl:value-of select="$imgwidth" />" imgheight="<xsl:value-of select="$imgheight" />" titlelen="<xsl:value-of select="$titlelen" />" timeout="<xsl:value-of select="$timeout" />" effectid="<xsl:value-of select="$effectid" />" hits="<xsl:value-of select="$hits" />" elitelevel="<xsl:value-of select="$elitelevel" />" tablename="<xsl:value-of select="$tablename" />" strsql="SELECT Top @shownum C.*,T.* FROM PE_CommonModel C INNER JOIN @tablename T ON C.ItemID=T.ID WHERE C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel AND C.TableName='@tablename' AND C.DefaultPicUrl !='' AND @datenum>=Datediff(d,C.UpdateTime,getdate()) AND C.GeneralID IN(SELECT S.GeneralID FROM PE_SpecialInfos S WHERE S.SpecialID IN(@specialid)) ORDER BY <xsl:value-of select="$sqlordertype" /> " /}
</xsl:if>
</xsl:if>
</xsl:if>
</xsl:when>
<!-- 指定栏目 -->
<xsl:otherwise>
<!-- 所有专题 -->
<xsl:if test="$specialid='0'">
<!-- 查询所有内容shownum=0 -->
<xsl:if test="$shownum=0">
<!-- 日期范围查询datenum=0 -->
<xsl:if test="$datenum=0">
<!-- SELECT C.*,T.* FROM PE_CommonModel C INNER JOIN @tablename T ON C.ItemID=T.ID WHERE C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel AND C.TableName='@tablename' AND C.DefaultPicUrl !='' AND C.NodeID IN(@arrnodeid) ORDER BY @sqlordertype -->
{PE.Label id="显示幻灯片效果显示图片" parentid="<xsl:value-of select="$parentid" />" arrnodeid="<xsl:value-of select="arrChildID" />" includechild ="<xsl:value-of select="$includechild" />" specialid="<xsl:value-of select="$specialid" />" shownum="<xsl:value-of select="$shownum" />" ishot="<xsl:value-of select="$ishot" />" iselite="<xsl:value-of select="$iselite" />" datenum="<xsl:value-of select="$datenum" />" ordertype="<xsl:value-of select="$ordertype" />" imgwidth="<xsl:value-of select="$imgwidth" />" imgheight="<xsl:value-of select="$imgheight" />" titlelen="<xsl:value-of select="$titlelen" />" timeout="<xsl:value-of select="$timeout" />" effectid="<xsl:value-of select="$effectid" />" hits="<xsl:value-of select="$hits" />" elitelevel="<xsl:value-of select="$elitelevel" />" tablename="<xsl:value-of select="$tablename" />" strsql="SELECT C.*,T.* FROM PE_CommonModel C INNER JOIN @tablename T ON C.ItemID=T.ID WHERE C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel AND C.TableName='@tablename' AND C.DefaultPicUrl !='' AND C.NodeID IN(@arrnodeid) ORDER BY <xsl:value-of select="$sqlordertype" /> " /}
</xsl:if>
<!-- 日期范围查询datenum>0 -->
<xsl:if test="$datenum>0">
<!-- SELECT C.*,T.* FROM PE_CommonModel C INNER JOIN @tablename T ON C.ItemID=T.ID WHERE C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel AND C.TableName='@tablename' AND C.DefaultPicUrl !='' AND Datediff(d,C.UpdateTime,getdate())<=@datenum AND C.NodeID IN(@arrnodeid) AND C.NodeID IN(@arrnodeid) ORDER BY @sqlordertype -->
{PE.Label id="显示幻灯片效果显示图片" parentid="<xsl:value-of select="$parentid" />" arrnodeid="<xsl:value-of select="arrChildID" />" includechild ="<xsl:value-of select="$includechild" />" specialid="<xsl:value-of select="$specialid" />" shownum="<xsl:value-of select="$shownum" />" ishot="<xsl:value-of select="$ishot" />" iselite="<xsl:value-of select="$iselite" />" datenum="<xsl:value-of select="$datenum" />" ordertype="<xsl:value-of select="$ordertype" />" imgwidth="<xsl:value-of select="$imgwidth" />" imgheight="<xsl:value-of select="$imgheight" />" titlelen="<xsl:value-of select="$titlelen" />" timeout="<xsl:value-of select="$timeout" />" effectid="<xsl:value-of select="$effectid" />" hits="<xsl:value-of select="$hits" />" elitelevel="<xsl:value-of select="$elitelevel" />" tablename="<xsl:value-of select="$tablename" />" strsql="SELECT C.*,T.* FROM PE_CommonModel C INNER JOIN @tablename T ON C.ItemID=T.ID WHERE C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel AND C.TableName='@tablename' AND C.DefaultPicUrl !='' AND @datenum>=Datediff(d,C.UpdateTime,getdate()) AND C.NodeID IN(@arrnodeid) ORDER BY <xsl:value-of select="$sqlordertype" /> " /}
</xsl:if>
</xsl:if>
<!-- 查询所有内容shownum>0 -->
<xsl:if test="$shownum>0">
<!-- 日期范围查询datenum=0 -->
<xsl:if test="$datenum=0">
<!-- SELECT Top @shownum C.*,T.* FROM PE_CommonModel C INNER JOIN @tablename T ON C.ItemID=T.ID WHERE C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel AND C.TableName='@tablename' AND C.DefaultPicUrl !='' AND C.NodeID IN(@arrnodeid) ORDER BY @sqlordertype -->
{PE.Label id="显示幻灯片效果显示图片" parentid="<xsl:value-of select="$parentid" />" arrnodeid="<xsl:value-of select="arrChildID" />" includechild ="<xsl:value-of select="$includechild" />" specialid="<xsl:value-of select="$specialid" />" shownum="<xsl:value-of select="$shownum" />" ishot="<xsl:value-of select="$ishot" />" iselite="<xsl:value-of select="$iselite" />" datenum="<xsl:value-of select="$datenum" />" ordertype="<xsl:value-of select="$ordertype" />" imgwidth="<xsl:value-of select="$imgwidth" />" imgheight="<xsl:value-of select="$imgheight" />" titlelen="<xsl:value-of select="$titlelen" />" timeout="<xsl:value-of select="$timeout" />" effectid="<xsl:value-of select="$effectid" />" hits="<xsl:value-of select="$hits" />" elitelevel="<xsl:value-of select="$elitelevel" />" tablename="<xsl:value-of select="$tablename" />" strsql="SELECT Top @shownum C.*,T.* FROM PE_CommonModel C INNER JOIN @tablename T ON C.ItemID=T.ID WHERE C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel AND C.TableName='@tablename' AND C.DefaultPicUrl !='' AND C.NodeID IN(@arrnodeid) ORDER BY <xsl:value-of select="$sqlordertype" /> " /}
</xsl:if>
<!-- 日期范围查询datenum>0 -->
<xsl:if test="$datenum>0">
<!-- SELECT Top @shownum C.*,T.* FROM PE_CommonModel C INNER JOIN @tablename T ON C.ItemID=T.ID WHERE C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel AND C.TableName='@tablename' AND C.DefaultPicUrl !='' AND Datediff(d,C.UpdateTime,getdate())<=@datenum AND C.NodeID IN(@arrnodeid) ORDER BY @sqlordertype -->
{PE.Label id="显示幻灯片效果显示图片" parentid="<xsl:value-of select="$parentid" />" arrnodeid="<xsl:value-of select="arrChildID" />" includechild ="<xsl:value-of select="$includechild" />" specialid="<xsl:value-of select="$specialid" />" shownum="<xsl:value-of select="$shownum" />" ishot="<xsl:value-of select="$ishot" />" iselite="<xsl:value-of select="$iselite" />" datenum="<xsl:value-of select="$datenum" />" ordertype="<xsl:value-of select="$ordertype" />" imgwidth="<xsl:value-of select="$imgwidth" />" imgheight="<xsl:value-of select="$imgheight" />" titlelen="<xsl:value-of select="$titlelen" />" timeout="<xsl:value-of select="$timeout" />" effectid="<xsl:value-of select="$effectid" />" hits="<xsl:value-of select="$hits" />" elitelevel="<xsl:value-of select="$elitelevel" />" tablename="<xsl:value-of select="$tablename" />" strsql="SELECT Top @shownum C.*,T.* FROM PE_CommonModel C INNER JOIN @tablename T ON C.ItemID=T.ID WHERE C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel AND C.TableName='@tablename' AND C.DefaultPicUrl !='' AND @datenum>=Datediff(d,C.UpdateTime,getdate()) AND C.NodeID IN(@arrnodeid) ORDER BY <xsl:value-of select="$sqlordertype" /> " /}
</xsl:if>
</xsl:if>
</xsl:if>
<!-- 指定专题 -->
<xsl:if test="$specialid!='0'">
<!-- 查询所有内容shownum=0 -->
<xsl:if test="$shownum=0">
<!-- 日期范围查询datenum=0 -->
<xsl:if test="$datenum=0">
<!-- SELECT C.*,T.* FROM PE_CommonModel C INNER JOIN @tablename T ON C.ItemID=T.ID WHERE C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel AND C.TableName='@tablename' AND C.DefaultPicUrl !='' AND C.GeneralID IN(SELECT S.GeneralID FROM PE_SpecialInfos S WHERE S.SpecialID IN(@specialid)) AND C.NodeID IN(@arrnodeid) ORDER BY @sqlordertype -->
{PE.Label id="显示幻灯片效果显示图片" parentid="<xsl:value-of select="$parentid" />" arrnodeid="<xsl:value-of select="arrChildID" />" includechild ="<xsl:value-of select="$includechild" />" specialid="<xsl:value-of select="$specialid" />" shownum="<xsl:value-of select="$shownum" />" ishot="<xsl:value-of select="$ishot" />" iselite="<xsl:value-of select="$iselite" />" datenum="<xsl:value-of select="$datenum" />" ordertype="<xsl:value-of select="$ordertype" />" imgwidth="<xsl:value-of select="$imgwidth" />" imgheight="<xsl:value-of select="$imgheight" />" titlelen="<xsl:value-of select="$titlelen" />" timeout="<xsl:value-of select="$timeout" />" effectid="<xsl:value-of select="$effectid" />" hits="<xsl:value-of select="$hits" />" elitelevel="<xsl:value-of select="$elitelevel" />" tablename="<xsl:value-of select="$tablename" />" strsql="SELECT C.*,T.* FROM PE_CommonModel C INNER JOIN @tablename T ON C.ItemID=T.ID WHERE C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel AND C.TableName='@tablename' AND C.DefaultPicUrl !='' AND C.GeneralID IN(SELECT S.GeneralID FROM PE_SpecialInfos S WHERE S.SpecialID IN(@specialid)) AND C.NodeID IN(@arrnodeid) ORDER BY <xsl:value-of select="$sqlordertype" /> " /}
</xsl:if>
<!-- 日期范围查询datenum>0 -->
<xsl:if test="$datenum>0">
<!-- SELECT C.*,T.* FROM PE_CommonModel C INNER JOIN @tablename T ON C.ItemID=T.ID WHERE C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel AND C.TableName='@tablename' AND C.DefaultPicUrl !='' AND Datediff(d,C.UpdateTime,getdate())<=@datenum AND C.GeneralID IN(SELECT S.GeneralID FROM PE_SpecialInfos S WHERE S.SpecialID IN(@specialid)) AND C.NodeID IN(@arrnodeid) ORDER BY @sqlordertype -->
{PE.Label id="显示幻灯片效果显示图片" parentid="<xsl:value-of select="$parentid" />" arrnodeid="<xsl:value-of select="arrChildID" />" includechild ="<xsl:value-of select="$includechild" />" specialid="<xsl:value-of select="$specialid" />" shownum="<xsl:value-of select="$shownum" />" ishot="<xsl:value-of select="$ishot" />" iselite="<xsl:value-of select="$iselite" />" datenum="<xsl:value-of select="$datenum" />" ordertype="<xsl:value-of select="$ordertype" />" imgwidth="<xsl:value-of select="$imgwidth" />" imgheight="<xsl:value-of select="$imgheight" />" titlelen="<xsl:value-of select="$titlelen" />" timeout="<xsl:value-of select="$timeout" />" effectid="<xsl:value-of select="$effectid" />" hits="<xsl:value-of select="$hits" />" elitelevel="<xsl:value-of select="$elitelevel" />" tablename="<xsl:value-of select="$tablename" />" strsql="SELECT C.*,T.* FROM PE_CommonModel C INNER JOIN @tablename T ON C.ItemID=T.ID WHERE C.Status=99 AND C.Hits>=@hits AND C.EliteLevel>=@elitelevel AND C.TableName='@tablename' AND C.DefaultPicUrl !='' AND @datenum>=Datediff(d,C.UpdateTime,getdate()) AND C.GeneralID IN(SELECT S.GeneralID FROM PE_SpecialInfos S WHERE S.SpecialID IN(@specialid)) AND C.NodeID IN(@arrnodeid) ORDER BY <xsl:value-of select="$sqlordertype" /> " /}
</xsl:if>
</xsl:if>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -