gistfile1.txt

SELECT DISTINCT `matches`.`id` FROM `players`
	INNER JOIN `league_registrations` ON (`league_registrations`.`player_id` = `players`.id OR second_player_id = `players`.`id`)
	INNER JOIN `matches` ON (`matches`.`home_league_registration_id` = `league_registrations`.`id` OR `matches`.`away_league_registration_id` = `league_registrations`.`id`)
WHERE `players`.`id` = 113

INTERSECT

SELECT DISTINCT `matches`.`id` FROM `players`
	INNER JOIN `league_registrations` ON (`league_registrations`.`player_id` = `players`.id OR second_player_id = `players`.`id`)
	INNER JOIN `matches` ON (`matches`.`home_league_registration_id` = `league_registrations`.`id` OR `matches`.`away_league_registration_id` = `league_registrations`.`id`)
WHERE `players`.`id` = 8883