帝国CMS模板调用指定栏目的tag或当前栏目的tag

wdzsjl 2周前 (01-01) 阅读数 57 #其它CMS

文章标签综艺帝国帝国如何找到相应栏目的帝国cms栏目分类帝国tag标签帝国cms tag

在帝国CMS模板中，可以通过不同的SQL查询方式来调用指定栏目中的所有TAG。以下是四种不同的方法及其解释。

方法1

SQL 查询

sql

select DISTINCT([!db.pre!]enewstags.tagname), [!db.pre!]enewstags.tagid, [!db.pre!]enewstags.num  from [!db.pre!]enewstags  inner join [!db.pre!]enewstagsdata on [!db.pre!]enewstags.tagid = [!db.pre!]enewstagsdata.tagid  where [!db.pre!]enewstagsdata.classid = 34  order by [!db.pre!]enewstags.num DESC  limit 30

模板代码

html

[e:loop={"select DISTINCT([!db.pre!]enewstags.tagname), [!db.pre!]enewstags.tagid, [!db.pre!]enewstags.num  from [!db.pre!]enewstags  inner join [!db.pre!]enewstagsdata on [!db.pre!]enewstags.tagid = [!db.pre!]enewstagsdata.tagid  where [!db.pre!]enewstagsdata.classid = 34  order by [!db.pre!]enewstags.num DESC  limit 30", 0, 24}] <a href='<?=$public_r['newsurl']?>e/tags/?tagname=<?=$bqr['tagname']?>' title='<?=$bqr['num']?>个'>   <?=$bqr['tagname']?> (<?=$bqr['num']?>) </a> [/e:loop]

方法2

SQL 查询

sql

select a.tagname, a.num, b.tagid  from [!db.pre!]enewstags a, [!db.pre!]enewstagsdata b  where a.tagid = b.tagid and classid = 34  group by tagid  order by num desc  limit 40

模板代码

html

[e:loop={"select a.tagname, a.num, b.tagid  from [!db.pre!]enewstags a, [!db.pre!]enewstagsdata b  where a.tagid = b.tagid and classid = 34  group by tagid  order by num desc  limit 40", 40, 24, 0}] <a href='<?=$public_r['newsurl']?>e/tags/?tagname=<?=$bqr['tagname']?>' title='<?=$bqr['num']?>个'>   <?=$bqr['tagname']?> (<?=$bqr['num']?>) </a> [/e:loop]

方法3

SQL 查询

sql

select a.*, b.*  from [!db.pre!]enewstags a, [!db.pre!]enewstagsdata b  where a.tagid = b.tagid and classid = 34  group by b.tagid  order by a.num desc  limit 40

模板代码

html

[e:loop={"select a.*, b.*  from [!db.pre!]enewstags a, [!db.pre!]enewstagsdata b  where a.tagid = b.tagid and classid = 34  group by b.tagid  order by a.num desc  limit 40", 40, 24, 0}] <a href='<?=$public_r['newsurl']?>e/tags/?tagname=<?=$bqr['tagname']?>' title='<?=$bqr['num']?>个'>   <?=$bqr['tagname']?> (<?=$bqr['num']?>) </a> [/e:loop]

方法4

SQL 查询

sql

select a.*, b.*  from [!db.pre!]enewstags a  LEFT JOIN [!db.pre!]enewstagsdata b ON a.tagid = b.tagid  where classid = 34  group by b.tagid  order by a.num desc  limit 100

模板代码

html

[e:loop={"select a.*, b.*  from [!db.pre!]enewstags a  LEFT JOIN [!db.pre!]enewstagsdata b ON a.tagid = b.tagid  where classid = 34  group by b.tagid  order by a.num desc  limit 100", 0, 24, 0}] <a href='<?=$public_r['newsurl']?>e/tags/?tagname=<?=$bqr['tagname']?>' title='<?=$bqr['num']?>个'>   <?=$bqr['tagname']?> (<?=$bqr['num']?>) </a> [/e:loop]