1
This code compiles (and runs without panickin...
./DDNet "gfx_backend vulkan" 
SELECT a.Map as map, Name as name, Time as time, Ranking as rank, a.Timestamp as timestamp, a.Server as rank_server, m.Server as map_server,
((time - PrevTime) / PrevTime) * 100 as faster_percent, m.Points as points, m.Stars as stars
FROM (
SELECT RANK() OVER w AS Ranking, MIN(Time) AS Time, Name, Timestamp, Server, LEAD(Time) OVER w as PrevTime, Map
FROM race
GROUP BY Map, Name
WINDOW w AS (PARTITION BY Map ORDER BY MIN(Time))
) as a
LEFT JOIN maps m ON m.Map = a.Map
WHERE Name = "Ryozuki"
ORDER BY Ranking ASC; 
SELECT
z.*,
((z.best - z.prevranktime) / z.best) * 100 as prev
FROM
(
select
y.best,
y.Map,
y.Ranking,
y.Timestamp,
(
select
r4.Time
from
(select r3.Time from race as r3 where r3.Map = y.Map order by r3.Time ASC) as r4
where
r4.Time > y.best LIMIT 1
) as prevranktime
from
(
select
x.best,
x.Map,
(
select COUNT(*) + 1 as r from (select time from race r1 where r1.Map = x.Map and r1.time < x.best group by r1.name)
)
as Ranking,
(select timestamp from race as r2 where r2.Map = x.Map and r2.Time = x.best and r2.name = "Ryozuki" LIMIT 1) as Timestamp
from (
select min(r.time) as best, Map from race r where name = "Ryozuki" group by map
) as x
) as y
) as z
--order by y.Ranking
as soon as i enable the last line 
with tearing protocol merged it is time to install it on linux back
S = 3.4848; something like S * 50 = 174.24 would be approximately equal to the observed jump height. Is this correct? If yes then why we need the final *50?