Where year = 1956 1957 1958 1959 1960 1961 1962 1963 1964 1965 1966 1967 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007

Where visiting team = Anaheim Angels Arizona Diamondbacks Atlanta Braves Baltimore Orioles Boston Red Sox Brooklyn Dodgers California Angels Chicago Cubs Chicago White Sox Cincinnati Reds Cleveland Indians Colorado Rockies Detroit Tigers Florida Marlins Houston Astros Kansas City Athletics Kansas City Royals Los Angeles Angels Los Angeles Dodgers Milwaukee Braves Milwaukee Brewers Minnesota Twins Montreal Expos New York Giants New York Mets New York Yankees Oakland Athletics Philadelphia Phillies Pittsburgh Pirates San Diego Padres San Francisco Giants Seattle Mariners Seattle Pilots St. Louis Cardinals Tampa Bay Devilrays Texas Rangers Toronto Blue Jays Washington Nationals Washington Senators

Where home team = Anaheim Angels Arizona Diamondbacks Atlanta Braves Baltimore Orioles Boston Red Sox Brooklyn Dodgers California Angels Chicago Cubs Chicago White Sox Cincinnati Reds Cleveland Indians Colorado Rockies Detroit Tigers Florida Marlins Houston Astros Kansas City Athletics Kansas City Royals Los Angeles Angels Los Angeles Dodgers Milwaukee Braves Milwaukee Brewers Minnesota Twins Montreal Expos New York Giants New York Mets New York Yankees Oakland Athletics Philadelphia Phillies Pittsburgh Pirates San Diego Padres San Francisco Giants Seattle Mariners Seattle Pilots St. Louis Cardinals Tampa Bay Devilrays Texas Rangers Toronto Blue Jays Washington Nationals Washington Senators

Where total hits by visiting team = > < (number of hits)

Where total hits by home team = > < (number of hits)

Where total runs scored by visiting team = > < (total runs scored)

Where total runs scored by home team = > < (total runs scored)

Where number of innings in a complete game = > < (innings played)

Where game attendance >= <= (attendance)

Where number of minutes it took to complete game >= <= (total minutes)

Where the visiting team's starting pitcher was = (pitcher's name)

Where the home team's starting pitcher was = (pitcher's name)

Where the visiting team's starting pitcher pitched a complete game = Yes No

Where the home team's starting pitcher pitched a complete game = Yes No

Where the winning team was the Home team Visiting team

Where game date = (Use format: yyyymmdd)