SELECT
A.id, A.user_id, A.` 注册时间 `, A.` 发帖数量 `, B.` 发帖数量 `
- FROM
- (
- SELECT
- qp.id,
- qp.user_id,
- qs.wechat,
from_unixtime(qp.create_at, '%Y-%m-%d') 注册时间,
COUNT(qp.user_id) 发帖数量,
count(qs.id) 二手数量,
- qs.create_at ,
- uw.create_at AS uwcreate
- FROM
- welife_quan.quan_post AS qp
- LEFT JOIN quan_post_second AS qs ON qs.pid = qp.id
- LEFT JOIN welife_system.user_wechat AS uw ON uw.unionid = qp.user_id
- GROUP BY
- qp.user_id
- HAVING
- qs.wechat != ''
- AND qs.create_at <= uwcreate + 60 * 60 * 24 * 30
- ORDER BY
- qp.id DESC
- ) AS A
- LEFT JOIN(
- SELECT
- qp.id,
- qp.user_id,
- qs.wechat,
from_unixtime(qp.create_at,'%Y-%m-%d') 注册时间,
COUNT(qp.user_id) 发帖数量,
count(qs.id) 二手数量,
- qs.create_at,
- uw.create_at AS uwcreate
- FROM
- welife_quan.quan_post AS qp
- LEFT JOIN quan_post_second AS qs ON qs.pid = qp.id
- LEFT JOIN welife_system.user_wechat AS uw ON uw.unionid = qp.user_id
- GROUP BY
- qp.user_id
- HAVING
- qs.wechat != ''
- AND qs.create_at <= uwcreate + 60 * 60 * 24 * 7
- ORDER BY
- qp.id DESC
- ) AS B ON A.user_id = B.user_id;
来源: http://www.bubuko.com/infodetail-2737144.html