Christer and Gunnar: Comparison

		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='Christer Bengtsson' 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 ='Gunnar Jónsson'
		) as c
		
		ORDER BY c.ar ASC
			

Christer: Other common competitors

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.