list.var不支持程序代码，所以不能判断字段值是否为空:
用js可以
这里直接分享最简单的写法

where id id between 1 and 100 order by id desc

灵动标签，调用数据表news下 1-100的文章

[e:loop={"select *  from phome_ecms_news where id  between 1 and 100 order by id desc limit 100",0,24,0}]
<a href="<?=$bqsr['titleurl']?>" target="_blank"><?=$bqr['title']?></a> <br>
[/e:loop]