4 is the number of appearances for what football player?
(AND soccer.football_player (JOIN soccer.football_player.total_career_appearances 4^^http://www.w3.org/2001/XMLSchema#integer))