mysql left join写法

SELECT * FROM 
(select distinct `vOpenID` as vopenid from t_PlayerRegister 
where  1=1 and  1=1 and  dtEventTimei+8*3600<1481817600 AND dtEventTimei>1481212800 and  dtRegTimei+8*3600<1481817600 AND dtRegTimei>1481212800) as a 
LEFT JOIN 
(SELECT vopenid,COUNT(*) as num FROM t_PlayerRegister WHERE dtEventTimei+8*3600<1481817600 GROUP BY vopenid HAVING num>1) as b 
ON a.vopenid = b.vopenid