SELECT u.id,u.domain1,u.domain2,u.jifen,u.able,c.pv1,c.pv2,c.out,d.ip,(c.pv1/d.ip) AS apv,(c.pv2/d.ip) AS bpv
FROM `users` uLEFT OUTER JOIN (
SELECT sum(`pv1`)`pv1`,sum(`pv2`)`pv2`,sum(`out`)`out`,`domain2`
FROM `clickip`
WHERE `date` = $_SESSION[date]
GROUP BY `domain2`
)c ON u.domain2 = c.domain2LEFT OUTER JOIN (
SELECT count(`ip`)`ip`,`domain2`
FROM `clicked`
WHERE `date` = $_SESSION[date]
GROUP BY `domain2`
)d ON u.domain2 = d.domain2WHERE u.able = 'yes'
LIMIT $offset,$pagesize";这个SQL u.domain2 = c.domain2 我想在后面再一个u.domain1=c.domain1 怎么写啊
FROM `users` uLEFT OUTER JOIN (
SELECT sum(`pv1`)`pv1`,sum(`pv2`)`pv2`,sum(`out`)`out`,`domain2`
FROM `clickip`
WHERE `date` = $_SESSION[date]
GROUP BY `domain2`
)c ON u.domain2 = c.domain2LEFT OUTER JOIN (
SELECT count(`ip`)`ip`,`domain2`
FROM `clicked`
WHERE `date` = $_SESSION[date]
GROUP BY `domain2`
)d ON u.domain2 = d.domain2WHERE u.able = 'yes'
LIMIT $offset,$pagesize";这个SQL u.domain2 = c.domain2 我想在后面再一个u.domain1=c.domain1 怎么写啊
FROM `users` uLEFT OUTER JOIN (
SELECT sum(`pv1`)`pv1`,sum(`pv2`)`pv2`,sum(`out`)`out`,`domain2`
FROM `clickip`
WHERE `date` = $_SESSION[date]
GROUP BY `domain2`
)c ON u.domain2 = c.domain2LEFT OUTER JOIN (
SELECT count(`ip`)`ip`,`domain2`
FROM `clicked`
WHERE `date` = $_SESSION[date]
GROUP BY `domain2`
)d ON u.domain2 = d.domain2 AND u.domain2 = c.domain2WHERE u.able = 'yes'
LIMIT $offset,$pagesize";