{fzw:inside src="link.html"/} {fzw:inside src="头部.html"/}

走进三原

{fzw:sql="select * from sl_article where id=2" id="p1"}
{fzw:p1:neirong nohtml="yes" size="480"/}
{/fzw:sql}
    {fzw:sql="select top 4 * from sl_laoshi where classid=70 order by paixu desc,id desc" id="p1"}
  • {fzw:p1:xingming/}

  • {/fzw:sql}
    {fzw:sql="select top 4 * from sl_article where wenzhangfenlei in (select laiyuanbianhao from sl_dxxlk where bianhao=356) and shenhe='已审核' order by dtime desc,id desc" id="p1"}
  • {fzw:p1:biaoti size="40"/}

  • {/fzw:sql}
    {fzw:sql="select top 4 * from sl_article where wenzhangfenlei in (select laiyuanbianhao from sl_dxxlk where bianhao=357) and shenhe='已审核' order by dtime desc,id desc" id="p1"}
  • {fzw:p1:biaoti size="40"/}

  • {/fzw:sql}

新闻中心

校园风光

学校视频

{fzw:sql="select top 1 * from sl_article where wenzhangfenlei in (select laiyuanbianhao from sl_dxxlk where bianhao=350) and shenhe='已审核' order by paixu desc,id desc" id="p1"} {/fzw:sql} {fzw:sql="select top 2 * from sl_article where wenzhangfenlei in (select laiyuanbianhao from sl_dxxlk where bianhao=350) and shenhe='已审核' and id not in (select top 1 id from sl_article where wenzhangfenlei in (select laiyuanbianhao from sl_dxxlk where bianhao=350) and shenhe='已审核' order by paixu desc,id desc) order by dtime desc,id desc" id="p1"} {/fzw:sql}

学生成长

{fzw:sql="select * from sl_Parameter where classid=362 order by u3 desc,id asc" id="p1"} {fzw:p1:u1/} {/fzw:sql}
{fzw:for:sql="select * from sl_Parameter where classid=362 order by u3 desc,id asc" id="p1"}
    {fzw:for:sql="select top 4 * from sl_article where wenzhangfenlei in (select laiyuanbianhao from sl_dxxlk where bianhao={fzw:p1:id/}) and shenhe='已审核' order by dtime desc,id desc" id="p2"}
  • {fzw:p2:biaoti/}
  • {/fzw:for:sql}
{/fzw:for:sql}

教师发展

名优教师 {fzw:sql="select * from sl_sort where sort_id=44 order by paixu desc,id asc" id="p1"} {fzw:p1:u1/} {/fzw:sql}
{fzw:for:sql="select id from sl_sort where sort_id=44 order by paixu desc,id asc" id="p2"}
    {fzw:for:sql="select top 4 * from sl_article where classid in({fzw:p2:id/}) and shenhe like '%已审核%' order by paixu desc,id desc" id="p1"}
  • {fzw:p1:biaoti size="34"/}

  • {/fzw:for:sql}
{/fzw:for:sql}
{fzw:inside src="底部.html"/}