WITH CTE(RULESET,MANA_CAP,SUMMONER_ID,MONSTER_1_ID,MONSTER_2_ID,MONSTER_3_ID,MONSTER_4_ID,MONSTER_5_ID,MONSTER_6_ID)AS
  (
    SELECT 'STANDARD',15,109,131,50,230,51,0,0  UNION ALL 
    SELECT 'STANDARD',15,109,131,50,47,138,0,0  UNION ALL 
    SELECT 'STANDARD',15,112,129,51,54,136,0,0  UNION ALL 
    SELECT 'STANDARD',15,109,136,229,0,0,0,0  UNION ALL 
    SELECT 'STANDARD',15,109,136,50,51,0,0,0   UNION ALL 
    SELECT 'STANDARD',15,11,209,52,0,0,0,0    UNION ALL
    SELECT 'STANDARD',15,109,229,136,0,0,0,0  
  ),
C2 AS
  (
    SELECT C.SUMMONER_ID
    FROM CTE AS C
    WHERE C.MANA_CAP=15
    GROUP BY C.SUMMONER_ID
    ORDER BY COUNT(C.SUMMONER_ID)DESC
    LIMIT 1
  )
SELECT C.SUMMONER_ID,MONSTER_1.MONSTER_1_ID,MONSTER_2.MONSTER_2_ID,MONSTER_3.MONSTER_3_ID
  FROM C2 AS C
  LEFT JOIN LATERAL
  (
    SELECT X.MONSTER_1_ID
     FROM CTE AS X
     WHERE C.SUMMONER_ID=X.SUMMONER_ID AND X.MANA_CAP=15
     GROUP BY X.MONSTER_1_ID
     ORDER BY COUNT(X.MONSTER_1_ID)DESC 
     LIMIT 1
  )MONSTER_1 ON TRUE
  LEFT JOIN LATERAL
  (
     SELECT X.MONSTER_2_ID
     FROM CTE AS X
     WHERE C.SUMMONER_ID=X.SUMMONER_ID AND X.MANA_CAP=15
     GROUP BY X.MONSTER_2_ID
     ORDER BY COUNT(X.MONSTER_2_ID)DESC 
     LIMIT 1
  )MONSTER_2 ON TRUE 
  LEFT JOIN LATERAL
  (
     SELECT X.MONSTER_3_ID
     FROM CTE AS X
     WHERE C.SUMMONER_ID=X.SUMMONER_ID AND X.MANA_CAP=15
     GROUP BY X.MONSTER_3_ID
     ORDER BY COUNT(X.MONSTER_3_ID)DESC 
     LIMIT 1
  )MONSTER_3 ON TRUE