mysql multi count() in one query DISTINCT 를 이용한 COUNT SELECT u.user_id, u.user_name COUNT(DISTINCT l.logined) AS login_cnt, COUNT(DISTINCT i.items) AS item_cnt FROM user AS u LEFT JOIN logged AS l ON u.user_id=l.user_id LEFT JOIN items AS i ON u.user_id=i.user_id GROUP BY u.user_id
