SELECT u.id, u.er, u.url, u.percent, u.jifen, c.in, c.out, c.c2, d.ip, x.domain
FROM `users` u
LEFT OUTER JOIN (SELECT sum( `in` ) `in` , sum( `out` ) `out` , sum( `c2` ) `c2` , `only`
FROM `clickip`
WHERE `date` = '20120714'
GROUP BY `only`
)c ON u.id = c.only
LEFT OUTER JOIN (SELECT count( `ip` ) `ip` , `only` ,pv
FROM `clicked`
WHERE `date` = '20120714'
GROUP BY `only`
)d ON u.id = d.only
LEFT OUTER JOIN (SELECT `list` , `domain`
FROM `cloud`
GROUP BY `list`
)x ON u.er = x.list
WHERE u.able = 'yes'
ORDER BY d.ip DESC
加一个c.c2/d.ip值的查询可见字段
FROM `users` u
LEFT OUTER JOIN (SELECT sum( `in` ) `in` , sum( `out` ) `out` , sum( `c2` ) `c2` , `only`
FROM `clickip`
WHERE `date` = '20120714'
GROUP BY `only`
)c ON u.id = c.only
LEFT OUTER JOIN (SELECT count( `ip` ) `ip` , `only` ,pv
FROM `clicked`
WHERE `date` = '20120714'
GROUP BY `only`
)d ON u.id = d.only
LEFT OUTER JOIN (SELECT `list` , `domain`
FROM `cloud`
GROUP BY `list`
)x ON u.er = x.list
WHERE u.able = 'yes'
ORDER BY d.ip DESC
加一个c.c2/d.ip值的查询可见字段
解决方案 »
- 删除重复的数据
- Toad For Mysql 创建存储过程
- MySQL的版本比较,大家都再使用那个版本
- mysql 只显示数据表数量 但是打不开数据表
- 在windows XP下如何利用ODBC数据源连接到postgreSQL数据库?
- 将Access中有用First的SQL移植到PostgreSQL中,怎么修改First方法?
- 请高手指教:请问在mysql中怎样使两个表有参照完整性约束呢?
- 关于创建数据库的问题?
- 求一个高效的树型结构的实现方式。(包括数据结构和算法)如果解决有1000分想送!!!!
- mysql递归查询排序问题
- 发第二遍了,很小的问题,我是新手啊!!!!!!!!
- 如何解决服务器死机问题
FROM `users` u
....