调用uc博客最新主题

[ecmsinfo]‘select subject as title,uid as userid,blogid as id from uchome_blog order by blogid desc limit 17′,0,40,0,24,28,0[/ecmsinfo]

## 调用uc博客最新图片

[ecmsinfo]‘select albumname as title,uid as userid,albumid as id,pic as titlepic from uchome_album order by albumid desc limit 2′,0,22,0,24,31,0[/ecmsinfo]

## 调用uc博客最新回复

[ecmsinfo]‘select subject as title,uid as userid,blogid as id from uchome_blog order by tracenum desc limit 3′,0,30,0,24,29,0[/ecmsinfo]

## 调用uc博客群组

[ecmsinfo]‘select subject as title,tid as userid,tagid as id from uchome_thread order by replynum desc limit 1′,0,18,0,24,30,0[/ecmsinfo]

## 调用dz论坛最新主题

[ecmsinfo]‘select subject as title,tid as id from cdb_threads  order by lastpost desc limit 4′,0,40,0,24,25,0[/ecmsinfo]

## 调用dz论坛最新图片

[ecmsinfo]‘select u.attachment as titlepic,ui.subject as title,u.tid as id from cdb_attachments u LEFT JOIN cdb_threads ui ON u.tid=ui.tid where u.isimage=1 order by ui.tid DESC limit 2′,0,30,0,24,36,0[/ecmsinfo]

## 调用dz论坛随即帖子

[ecmsinfo]‘select subject as title,tid as id from cdb_threads  order by highlight desc limit 3′,0,30,0,24,27,0[/ecmsinfo]

## 调用dz论坛精华帖子

[ecmsinfo]‘select subject as title,tid as id from cdb_threads  order by digest desc limit 1′,0,18,0,24,26,0[/ecmsinfo]

## 调用dz论坛指定版块的帖子

[ecmsinfo]‘select subject as title,tid as id from cdb_threads where fid=10 order by tid desc limit 14′,0,30,0,24,38,0[/ecmsinfo]

## 例子

[ecmsinfo]‘select subject as title(调用后变量),tid as id from cdb_threads(数据表) where fid=10(版块id) order by tid desc limit 14(调用条数)’,0,30,0,24,38,0[/ecmsinfo]