SS7.5只调用论坛的第一张图片
创建模块-》论坛附件-》高级模式
SELECT p. * , a. *
FROM cdb_posts p
INNER JOIN cdb_attachments a ON p.tid = a.tid
AND p.authorid = a.uid
WHERE a.isimage =1
GROUP BY p.tid
ORDER BY p.dateline DESC
注意表前缀哦!!一般的前缀都是”cdb_”
下一篇: 卡个周末过得好轻松好愉快!
创建模块-》论坛附件-》高级模式
SELECT p. * , a. *
FROM cdb_posts p
INNER JOIN cdb_attachments a ON p.tid = a.tid
AND p.authorid = a.uid
WHERE a.isimage =1
GROUP BY p.tid
ORDER BY p.dateline DESC
注意表前缀哦!!一般的前缀都是”cdb_”