mysqlÎÊÌ⣬¹òÇó¸ßÊÖ½â´ð

select c.globalUid,c.badge,temp.sumB,temp.sumP from tb_user c,(select a.uid,sum(a.badge) as sumB,IFNULL(sum(b.propertyNum),0) as sumP,sum(a.badge)-IFNULL(sum(b.propertyNum),0) as cha from tb_buyfun_log a left join buyrecord b on a.uid=b.globaluid group by a.uid having cha>500) as temp where uptime>'2009-12-01 00:00:00' and globaluid=temp.uid


Ë­°ïæÓÅ»¯ÏÂÕâÓï¾ä£¬ÎÒÔÚµçÄÔÉÏÔËÐкóºÜÂý£¬ÓÐʱ°ëÌ춼²»³öÀ´£¬ÓÐʱÁ¬²éѯ¹¤¾ß¶¼¸ãÆðËÀµô£¬¹ØÒ²¹Ø²»ÁË£¬ ¸÷λ¸ßÊÖ°ï濴Ϻò»£¿

---

SQL code:
select c.globalUid,c.badge,temp.sumB,temp.sumP
from tb_user c,(
select a.uid,sum(a.badge) as sumB,
IFNULL(sum(b.propertyNum),0) as sumP,
sum(a.badge)-IFNULL(sum(b.propertyNum),0) as cha
from tb_buyfun_log a left join buyrecord b on a.uid=b.globaluid
group by a.uid
having cha>500
) as temp
where uptime>'2009-12-01 00:00:00' and globaluid=temp.uid



ÄãÕâÊǸöµÑ¿¨»ý°¡¡£

Ìù³öÄãµÄ
show index from tb_user
show index from tb_buyfun_log
show index from buyrecord
ÒÔ¼°
explain select c.globalUid,c.badge,temp.sumB,temp.sumP
from tb_user c,(
select a.uid,sum(a.badge) as sumB,
IFNULL(sum(b.propertyNum),0) as sumP,
sum(a.badge)-IFNULL(sum(b.propertyNum),0) as cha
from tb_buyfun_log a left join buyrec