mysql multi count

• 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