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值的查询可见字段
FROM `users` u
....