Year
| Distance |
Matthías Sveinsson |
Finnur Torfi Hjörleifsson |
Ratio |
SELECT c.ar, c.vegalengd, c.nafn, c.id, c.lokatimi_sek, eigin_nafn, eigin_ar, eigin_lokatimi_sek FROM
(
SELECT a.id, a.ar, a.vegalengd, a.hsa, a.nafn, a.lokatimi_sek, eigin_nafn, eigin_ar, eigin_lokatimi_sek
FROM urslit AS a
JOIN
(SELECT ar as eigin_ar, vegalengd as eigin_vegalengd, hsa as eigin_hsa, nafn as eigin_nafn, lokatimi_sek as eigin_lokatimi_sek FROM urslit WHERE nafn='Matthías Sveinsson' and lokatimi_sek>0) as eigin
WHERE
a.ar=eigin_ar AND
a.vegalengd = eigin_vegalengd AND
a.hsa=eigin_hsa AND
a.lokatimi_sek>0 AND
a.nafn ='Finnur Torfi Hjörleifsson'
) as c
ORDER BY c.ar ASC
Here you can find a list of other arch-rivals, that is those with most races in common (same year and distance). Click to see detailed comparison.