Both of the following tables have 2 entries for the same player.
SELECT punishment_id, punishment.reason, cooldown.id, cooldown.time_left FROM player INNER JOIN punishment ON player.most_uuid=punishment.most_uuid INNER JOIN cooldown ON player.most_uuid=cooldown.most_uuid WHERE player.most_uuid=2941535451391147758
In the result of this query I have some kind of "duplicated" rows. I get 4 rows when I'd like to have just 2 with the essentials values inside.
I need all the values present in the rows, but as you can see there are pairs of rows with the exact same value twice.
Is there a possibility of merging them to actually have 2 like this (and not having duplicated values):