PHP 三级联动

{dede:sql sql="完整的SQL查询语句"}

[field:查询的所有字段/]

{/dede:sql}

   left join  INNER JOIN

#@__addonarticle → #@__archives

#@__addonarticle → #@__sys_enum

书写格式： SELECT * FROM (表1 inner join 表2 on 表1.字段名 =表2.字段名) INNER join 表3 on 表1.字段名 = 表3.字段名 where .... order by .. desc limit 0,12

下面的CODE到DEDE默认模板里的index.htm修改

{dede:sql sql="select * from (#@__addonarticle inner join #@__archives on #@__addonarticle.aid = #@__archives.id) INNER JOIN #@__sys_enum on #@__addonarticle.news = #@__sys_enum.evalue where #@__addonarticle.news <> 0 and #@__archives.channel = 1 order by #@__archives.pubdate desc limit 0,6"}

[field:字段名/]

{/dede:sql}