sv_port
is different for both of them, if you're using the default value then the servers will automatically assign different ports to themselves so you don't have to worry about thatselect Map from maps
except select Map from race where Name in ("player 1", "player 2") limit 50
https://db.ddstats.org/ddnet-38a429a?sql=select+Map+from+maps%0D%0Aexcept+select+Map+from+race+where+Name+in+%28%22player+1%22%2C+%22player+2%22%29+limit+50select Map from maps
except select Map from race where Name in ("player 1", "player 2") limit 50
https://db.ddstats.org/ddnet-38a429a?sql=select+Map+from+maps%0D%0Aexcept+select+Map+from+race+where+Name+in+%28%22player+1%22%2C+%22player+2%22%29+limit+50 SELECT Map FROM (
SELECT Map
FROM maps
WHERE server = 'Oldschool'
EXCEPT
SELECT Map
FROM race
WHERE Name IN ('always', 'moty')
) AS filtered_maps
LIMIT 50;
this what i got so farSELECT filtered_maps.Map, COUNT(race.Map) AS TotalFinishes
FROM (
SELECT Map
FROM maps
WHERE server = 'Oldschool'
EXCEPT
SELECT Map
FROM race
WHERE Name IN ('always', 'moty')
) AS filtered_maps
LEFT JOIN race ON filtered_maps.Map = race.Map
GROUP BY filtered_maps.Map
ORDER BY TotalFinishes DESC
LIMIT 50;
thanks chat gpt :D (edited)