下边的效果更好:
SELECT * FROM [!db.pre!]ecms_news AS t1 JOIN (SELECT ROUND(RAND() * ((SELECT MAX(id) FROM [!db.pre!]ecms_news)-(SELECT MIN(id) FROM [!db.pre!]ecms_news))+(SELECT MIN(id) FROM [!db.pre!]ecms_news)) AS id) AS t2 WHERE t1.id >= t2.id ORDER BY t1.id LIMIT 10
整合到灵动标签中：
<ul>
[e:loop={'SELECT * FROM [!db.pre!]ecms_news AS t1 JOIN (SELECT ROUND(RAND() * ((SELECT MAX(id) FROM [!db.pre!]ecms_news)-(SELECT MIN(id) FROM [!db.pre!]ecms_news))+(SELECT MIN(id) FROM [!db.pre!]ecms_news)) AS id) AS t2 WHERE t1.id >= t2.id ORDER BY t1.id LIMIT 10 ',10,24,0}]
<li><a href="<?=$bqsr['titleurl']?>" target="_blank"><?=$bqr['title']?></a></li>
[/e:loop]
</ul>