实用SQL

 LEFT JOIN 多次同一个表

        

一条SQL返回多个count

SELECTpj_submit_keywords.user_id,org_user.email,org_user.nickname,COUNT(*) AStotal_count,SUM(CASE WHEN pj_submit_keywords.state=2 THEN 1 ELSE 0 END ) ASpass_count

FROM pj_submit_keywords

LEFT JOIN org_user ON org_user.user_id=pj_submit_keywords.user_id

GROUP BY pj_submit_keywords.user_id