🟦 mypage리스트, 하나의 게시물의 댓글과 좋아요 수만큼 중복되어 나타난다.

🔹 원인

✅ SQL에 GROUP BY안해서 생긴 문제

 SELECT
        A.feed_id, IFNULL(B.cnt, 0) AS favCnt, IFNULL(D.cnt, 0) AS cmtCnt
            , CASE WHEN E.feed_id IS NULL THEN 0 ELSE 1 END AS isFav
            , CASE WHEN F.feed_id IS NULL THEN 0 ELSE 1 END AS isCmt
        FROM feed A
        LEFT JOIN (
        SELECT feed_id, COUNT(feed_id) AS cnt
        FROM feed_fav
        GROUP BY feed_id
        ) B
        ON A.feed_id = B.feed_id
        LEFT JOIN (
        SELECT feed_id, COUNT(feed_id) AS cnt
        FROM cmt
        GROUP BY feed_id
        ) D
        ON A.feed_id = D.feed_id   
	      LEFT JOIN feed_fav E   👈 🔺GROUP BY하지 않아서🔺
	      ON E.users_id = 2 AND A.feed_id = E.feed_id
	      LEFT JOIN cmt F
	      ON F.users_id = 2 AND A.feed_id = F.feed_id
        WHERE A.users_id = 2 👈 🔺GROUP BY하지 않아서🔺
        ORDER BY A.feed_id DESC

👇 올바른 SQL

 SELECT
        A.feed_id, IFNULL(B.cnt, 0) AS favCnt, IFNULL(D.cnt, 0) AS cmtCnt
            , CASE WHEN E.feed_id IS NULL THEN 0 ELSE 1 END AS isFav
            , CASE WHEN F.feed_id IS NULL THEN 0 ELSE 1 END AS isCmt
        FROM feed A
        LEFT JOIN (
        SELECT feed_id, COUNT(feed_id) AS cnt
        FROM feed_fav
        GROUP BY feed_id
        ) B
        ON A.feed_id = B.feed_id
        LEFT JOIN ( 
        SELECT feed_id, COUNT(feed_id) AS cnt
        FROM cmt
        GROUP BY feed_id
        ) D
        ON A.feed_id = D.feed_id
	      LEFT JOIN (                  👈 🔺GROUP BY🔺
			SELECT users_id, feed_id
			FROM feed_fav
			GROUP BY feed_id
			) E
	      ON E.users_id = 2 AND A.feed_id = E.feed_id
	      LEFT JOIN (                  👈 🔺GROUP BY🔺
	      SELECT users_id, feed_id
			FROM cmt
			GROUP BY feed_id
			) F
	      ON F.users_id = 2 AND A.feed_id = F.feed_id
        WHERE A.users_id = 2
        ORDER BY A.feed_id DESC