SELECT COUNT(*) FROM uchome_invite i LEFT JOIN (SELECT s.uid,s.videostatus,sf.emailcheck FROM uchome_space s LEFT JOIN uchome_spacefield sf ON s.uid=sf.uid WHERE sf.emailcheck<>0 and s.videostatus<>0 AND s.uid='1') s ON s.uid=i.uid WHERE i.uid='1' AND i.fuid>'0'
帮你写了一下,自己去改吧~