Wimbledon 1989 Gentlemen's Singles (June 26 - July 9)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Ivan Lendl
				Ivan Lendl
2.			Nicolas Pereira	7-6 4-6 6-3 6-7 6-1
					Ivan Lendl
3.		[Q]	Ronnie Bathman		6-7 6-3 6-2 6-2
				Ronnie Bathman
4.		[Q]	Bret Garnett	6-2 6-4 6-7 4-6 6-1
						Ivan Lendl
5.			Marian Vajda			7-6 6-3 6-1
				Marian Vajda
6.			Glenn Michibata	6-7 6-1 7-6 6-3
					Tomas Carbonell
7.			Tomas Carbonell		6-2 6-4 7-5
				Tomas Carbonell
8.			Marty Davis	6-4 3-6 7-6 6-4
							Ivan Lendl
9.			Goran Ivanisevic				1-6 7-6(5) 6-2 6-4
				Goran Ivanisevic
10.			Thierry Champion	6-3 6-4 3-6 6-3
					Ken Flach
11.			Ken Flach		6-4 6-3 4-6 6-3
				Ken Flach
12.		[Q]	Sammy Giammalva Jr.	7-6 7-6 3-6 0-6 6-3
						Peter Lundgren
13.			Peter Lundgren			6-3 6-2 6-7 6-3
				Peter Lundgren
14.			Ramesh Krishnan	6-4 7-6 7-5
					Peter Lundgren
15.		[15]	Mikael Pernfors		7-6 6-2 6-4
				Mikael Pernfors
16.			Michael Stich	5-7 6-1 6-3 6-2
								Ivan Lendl
17.		[10]	Jimmy Connors					7-6(8) 7-6(4) 6-0
				Jimmy Connors
18.			Andrei Cherkasov	6-3 6-2 4-6 6-3
					Dan Goldie
19.			Dan Goldie		7-6 5-7 6-4 6-2
				Dan Goldie
20.			Kelly Evernden	7-6 7-6 3-6 6-0
						Dan Goldie
21.		[Q]	Joey Rive			7-6 7-6 3-6 7-6
				Joey Rive
22.		[LL]	Matt Anger	7-6 6-2 6-7 7-5
					Wally Masur
23.			Wally Masur		6-3 7-6 4-6 6-2
				Wally Masur
24.		[Q]	Zeeshan Ali	6-3 6-4 6-2
							Dan Goldie
25.			Slobodan Zivojinovic				6-4 6-4 7-6(6)
				Slobodan Zivojinovic
26.			Anders Jarryd	3-6 7-6 6-3 6-0
					Slobodan Zivojinovic
27.		[WC]	Chris Bailey		6-3 7-5 7-6
				Chris Bailey
28.			Josef Cihak	7-5 6-7 3-6 6-3 6-4
						Slobodan Zivojinovic
29.			Mark Kratzmann			6-7 6-1 7-5 6-3
				Mark Kratzmann
30.			Veli Paloheimo	6-2 7-6 6-1
					Miloslav Mecir Sr.
31.		[7]	Miloslav Mecir Sr.		6-7 4-6 6-1 7-5 7-5
				Miloslav Mecir Sr.
32.		[Q]	Scott Warner	6-2 6-2 6-4
									Boris Becker
33.		[3]	Boris Becker						7-5 6-7(2) 2-6 6-4 6-3
				Boris Becker
34.		[Q]	Bryan Shelton	6-1 6-4 7-6
					Boris Becker
35.			Richard Matuszewski		6-3 7-5 6-4
				Richard Matuszewski
36.			Olli Rahnasto	2-6 6-2 6-4 6-4
						Boris Becker
37.			Jan Gunnarsson			7-5 7-6 6-3
				Jan Gunnarsson
38.			Diego Nargiso	3-6 6-3 6-7 6-3 6-4
					Jan Gunnarsson
39.			Derrick Rostagno		6-7 2-6 7-5 7-6 9-7
				Derrick Rostagno
40.			Simon Youl	7-6 6-4 6-4
							Boris Becker
41.			Patrick Kuehnen				6-4 6-4 7-5
				Patrick Kuehnen
42.			Martin Strelba	7-6 6-2 6-3
					Patrick Kuehnen
43.			Pieter Aldrich		6-1 7-5 6-0
				Pieter Aldrich
44.			Roger Smith	7-6 6-2 6-4
						Aaron Krickstein
45.			Javier Frana			4-6 6-3 6-3 6-2
				Javier Frana
46.			Jim Grabb	6-7 6-3 7-6 5-7 6-4
					Aaron Krickstein
47.		[13]	Aaron Krickstein		4-6 6-3 3-6 7-6 7-5
				Aaron Krickstein
48.			Francesco Cancellotti	6-1 6-2 3-6 6-1
								Boris Becker
49.		[12]	Kevin Curren					6-1 6-2 6-0
				Kevin Curren
50.		[WC]	Andrew Castle	6-2 4-6 7-6 6-3
					Kevin Curren
51.			Milan Srejber		4-6 6-2 6-3 6-0
				Milan Srejber
52.		[Q]	Kelly Jones	6-3 6-3 6-3
						Leif Shiras
53.			Leif Shiras			4-6 6-3 5-7 7-6 6-3
				Leif Shiras
54.			Johan Kriek	7-6 6-2 6-2
					Leif Shiras
55.			Jeremy Bates		4-6 7-5 6-3 6-2
				Jeremy Bates
56.			Cassio Motta	6-7 6-1 4-6 7-6 6-3
							Paul Chamberlin
57.			Mark Petchey				7-5 6-4 7-6(4)
				Mark Petchey
58.			Fernando Luna	6-2 6-7 6-2 6-1
					Nicholas Fulwood
59.		[Q]	Nicholas Fulwood		7-5 6-1 6-2
				Nicholas Fulwood
60.			Jonathan Canter	7-6 3-6 7-6 7-6
						Paul Chamberlin
61.			Paul Chamberlin			3-6 7-6 6-4 6-2
				Paul Chamberlin
62.			Gary Muller	4-6 6-3 7-5 6-3
					Paul Chamberlin
63.			Thomas Hogstedt		6-3 6-2 6-2
				Thomas Hogstedt
64.		[6]	Jakob Hlasek	6-3 7-6 6-1
										Boris Becker
65.		[5]	John McEnroe							6-0 7-6(1) 6-4
				John McEnroe
66.			Darren Cahill	4-6 4-6 6-2 6-3 8-6
					John McEnroe
67.			Richey Reneberg		6-3 3-6 6-3 7-5
				Richey Reneberg
68.			Christian Saceanu	6-4 6-4 4-6 4-6 6-2
						John McEnroe
69.			Robert Seguso			6-3 6-4 6-2
				Robert Seguso
70.			Jim Courier	6-2 3-6 6-4 5-7 9-7
					Jim Pugh
71.			Jim Pugh		6-3 7-6 6-3
				Jim Pugh
72.			Jeff Tarango	3-6 6-3 6-1 6-3
							John McEnroe
73.			Jonas Svensson				6-3 0-6 6-4 6-4
				Jonas Svensson
74.			David Wheaton	7-6 7-6 7-6
					Jonas Svensson
75.			Carl Limberger		6-4 6-3 7-6
				Carl Limberger
76.			Pieter Norval	7-6 6-4 3-6 6-3
						John Fitzgerald
77.			Glenn Layendecker			6-4 6-4 7-6
				Glenn Layendecker
78.			Horacio De La Pena	6-3 7-6 6-0
					John Fitzgerald
79.			John Fitzgerald		4-6 6-3 3-6 6-3 6-4
				John Fitzgerald
80.		[11]	Brad Gilbert	6-2 7-5 1-6 3-6 6-2
								John McEnroe
81.			Brad Drewett					7-6(6) 3-6 6-3 6-4
				Brad Drewett
82.		[14]	Andrei Chesnokov	6-4 7-6 6-0
					Brad Drewett
83.			Tim Wilkinson		6-7 6-3 7-5 6-2
				Tim Wilkinson
84.		[Q]	Patrick Baur	6-2 6-2 3-6 3-6 6-1
						Christo Van Rensburg
85.		[Q]	Martin Laurendeau			6-3 2-6 2-6 6-2 10-8
				Martin Laurendeau
86.			Jorge Lozano	6-2 6-4 6-3
					Christo Van Rensburg
87.			Christo Van Rensburg		3-6 7-6 6-2 6-2
				Christo Van Rensburg
88.			Mark Woodforde	7-6 6-1 6-4
							Mats Wilander
89.			Jason Stoltenberg				3-6 7-5 7-5 6-3
				Jason Stoltenberg
90.		[WC]	Stephen Botfield	7-6 7-6 6-3
					Jason Stoltenberg
91.			Omar Camporese		7-5 6-7 6-2 1-6 6-3
				Omar Camporese
92.			Christian Bergstrom	6-3 6-4 6-4
						Mats Wilander
93.			Karel Novacek			6-3 6-3 6-3
				Karel Novacek
94.		[WC]	James Turner	1-6 6-3 3-6 6-1 6-2
					Mats Wilander
95.		[4]	Mats Wilander		6-3 6-0 6-3
				Mats Wilander
96.			Magnus Gustafsson	6-2 6-2 6-2
									Stefan Edberg
97.		[8]	Tim Mayotte						7-5 7-6(2) 7-6(5)
				Tim Mayotte
98.			Paolo Cane	7-6 6-0 6-1
					Tim Mayotte
99.		[Q]	Henrik Holm		7-6 6-2 4-6 6-1
				Henrik Holm
100.			Neil Broad	6-1 6-1 6-1
						Tim Mayotte
101.			David Pate			6-4 6-1 6-3
				David Pate
102.			Paul Annacone	3-6 7-6 4-6 7-5 6-4
					David Pate
103.			Tom Nijssen		6-4 2-6 1-6 7-6 15-13
				Tom Nijssen
104.			Horst Skoff	7-5 6-3 6-2
							Tim Mayotte
105.			Andres Gomez				6-3 6-1 6-3
				Andres Gomez
106.			Leonardo Lavalle	3-6 6-4 6-4 7-6
					Michiel Schapers
107.			Michiel Schapers		2-6 7-6 7-5 3-6 6-3
				Michiel Schapers
108.		[Q]	Michael Robertson	7-5 4-6 7-6 6-4
						Michael Chang
109.			Ronald Agenor			4-6 6-3 7-5 7-5
				Ronald Agenor
110.			Jean-Philippe Fleurian	4-6 6-3 6-3 6-4
					Michael Chang
111.		[9]	Michael Chang		4-6 6-2 6-1 7-5
				Michael Chang
112.		[Q]	Bill Scanlon	6-4 6-3 2-6 6-3
								Stefan Edberg
113.		[16]	Amos Mansdorf					7-6(2) 7-6(12) 6-3
				Amos Mansdorf
114.			Sergi Bruguera	6-2 6-1 6-4
					Amos Mansdorf
115.			Eric Jelen		4-6 6-3 3-6 6-3 6-2
				Eric Jelen
116.			Alexander Volkov	7-5 6-7 6-3 6-2
						Amos Mansdorf
117.		[Q]	Greg Holmes			6-2 6-4 6-2
				Greg Holmes
118.		[WC]	Nick Brown	6-3 7-6 6-3
					Greg Holmes
119.			Todd Witsken		5-7 6-4 7-6 4-6 14-12
				Todd Witsken
120.			Johan Carlsson	6-3 6-4 7-6
							Stefan Edberg
121.			Scott Davis				6-4 6-3 6-2
				Scott Davis
122.			Andres Vysand	6-4 1-6 6-4 6-4
					Scott Davis
123.			Carl-Uwe Steeb		7-5 4-6 4-6 6-2 6-4
				Carl-Uwe Steeb
124.			Danie Visser	7-6 6-7 6-3 7-6
						Stefan Edberg
125.		[Q]	Todd Woodbridge			6-3 6-4 4-6 6-2
				Todd Woodbridge
126.			Pete Sampras	7-5 7-6 5-7 6-3
					Stefan Edberg
127.		[2]	Stefan Edberg		6-4 6-4 1-6 7-6
				Stefan Edberg
128.			Chris Pridham	6-3 6-4 6-1

(default) 17 queries took 22 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `Tournament`.`id`, `Tournament`.`name`, `Tournament`.`slug`, `Tournament`.`subtitle`, `Tournament`.`description`, `Tournament`.`surface`, `Tournament`.`venue`, `Tournament`.`eras`, `Tournament`.`history`, `Tournament`.`president`, `Tournament`.`PrizeMoney`, `Tournament`.`grandslam`, `Tournament`.`created`, `Tournament`.`modified` FROM `zavoihu1_db4tennis`.`tournaments` AS `Tournament` WHERE `Tournament`.`slug` = 'wimbledon' LIMIT 1	1	1	1
2	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`tournament_id`, `Category`.`gender`, `Category`.`type`, `Category`.`surface`, `Category`.`venue`, `Category`.`president`, `Category`.`name_of_the_tournament`, `Category`.`created`, `Category`.`modified`, `Category`.`created_by`, `Category`.`modified_by` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`tournament_id` = (3)	5	5	1
3	SELECT `Quote`.`id`, `Quote`.`tournament_id`, `Quote`.`quote`, `Quote`.`by`, `Quote`.`source`, `Quote`.`created`, `Quote`.`created_by`, `Quote`.`modified`, `Quote`.`modified_by` FROM `zavoihu1_db4tennis`.`quotes` AS `Quote` WHERE `Quote`.`tournament_id` = (3)	4	4	1
4	SELECT `Tournamenttotal`.`id`, `Tournamenttotal`.`tournament_id`, `Tournamenttotal`.`year`, `Tournamenttotal`.`price_money`, `Tournamenttotal`.`attendance`, `Tournamenttotal`.`created`, `Tournamenttotal`.`created_by`, `Tournamenttotal`.`modified`, `Tournamenttotal`.`modified_by` FROM `zavoihu1_db4tennis`.`tournamenttotals` AS `Tournamenttotal` WHERE `Tournamenttotal`.`tournament_id` = (3)	57	57	1
5	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`tournament_id`, `Category`.`gender`, `Category`.`type`, `Category`.`surface`, `Category`.`venue`, `Category`.`president`, `Category`.`name_of_the_tournament`, `Category`.`created`, `Category`.`modified`, `Category`.`created_by`, `Category`.`modified_by`, `Tournament`.`id`, `Tournament`.`name`, `Tournament`.`slug`, `Tournament`.`subtitle`, `Tournament`.`description`, `Tournament`.`surface`, `Tournament`.`venue`, `Tournament`.`eras`, `Tournament`.`history`, `Tournament`.`president`, `Tournament`.`PrizeMoney`, `Tournament`.`grandslam`, `Tournament`.`created`, `Tournament`.`modified` FROM `zavoihu1_db4tennis`.`categories` AS `Category` LEFT JOIN `zavoihu1_db4tennis`.`tournaments` AS `Tournament` ON (`Category`.`tournament_id` = `Tournament`.`id`) WHERE `Tournament`.`slug` = 'wimbledon' AND `Category`.`slug` = 'men-singles' LIMIT 1	1	1	1
6	SELECT `Contest`.`id`, `Contest`.`category_id`, `Contest`.`year`, `Contest`.`slug`, `Contest`.`ch`, `Contest`.`date_from`, `Contest`.`date_to`, `Contest`.`book`, `Contest`.`name_of_the_tournament`, `Contest`.`location`, `Contest`.`venue`, `Contest`.`surface`, `Contest`.`participants`, `Contest`.`prize_money`, `Contest`.`attendance`, `Contest`.`misc`, `Contest`.`final_misc`, `Contest`.`created`, `Contest`.`created_by`, `Contest`.`modified`, `Contest`.`modified_by` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = (17) ORDER BY `Contest`.`year` ASC	137	137	2
7	SELECT `Contest`.`id`, `Contest`.`category_id`, `Contest`.`year`, `Contest`.`slug`, `Contest`.`ch`, `Contest`.`date_from`, `Contest`.`date_to`, `Contest`.`book`, `Contest`.`name_of_the_tournament`, `Contest`.`location`, `Contest`.`venue`, `Contest`.`surface`, `Contest`.`participants`, `Contest`.`prize_money`, `Contest`.`attendance`, `Contest`.`misc`, `Contest`.`final_misc`, `Contest`.`created`, `Contest`.`created_by`, `Contest`.`modified`, `Contest`.`modified_by`, `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`tournament_id`, `Category`.`gender`, `Category`.`type`, `Category`.`surface`, `Category`.`venue`, `Category`.`president`, `Category`.`name_of_the_tournament`, `Category`.`created`, `Category`.`modified`, `Category`.`created_by`, `Category`.`modified_by` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` LEFT JOIN `zavoihu1_db4tennis`.`categories` AS `Category` ON (`Contest`.`category_id` = `Category`.`id`) WHERE `Category`.`tournament_id` = 3 AND `Contest`.`category_id` = 17 AND `Contest`.`slug` = '1989' LIMIT 1	1	1	2
8	SELECT `Match`.`id`, `Match`.`contest_id`, `Match`.`player_a_id`, `Match`.`player_aa_id`, `Match`.`player_b_id`, `Match`.`player_bb_id`, `Match`.`results`, `Match`.`long`, `Match`.`attendance`, `Match`.`no`, `Match`.`round`, `Match`.`round_id`, `Match`.`note`, `Match`.`created`, `Match`.`created_by`, `Match`.`modified`, `Match`.`modified_by` FROM `zavoihu1_db4tennis`.`matches` AS `Match` WHERE `Match`.`contest_id` = (511) ORDER BY `Match`.`round_id` ASC, `Match`.`no` ASC	127	127	2
9	SELECT `Player`.`id`, `Player`.`name`, `Player`.`gender`, `Player`.`slug` FROM `zavoihu1_db4tennis`.`players` AS `Player` WHERE `Player`.`id` IN (3797, 4104, 4918, 5624, 3965, 3918, 4092, 3852, 4108, 4018, 3953, 4203, 3986, 3801, 3943, 4098, 3539, 4121, 3950, 3966, 4049, 3919, 3938, 7708, 3969, 3924, 5591, 5189, 4002, 4149, 3977, 7102, 3968, 4105, 3961, 4113, 4011, 4083, 3980, 4093, 4085, 4147, 4073, 4047, 4087, 3983, 3934, 5171, 3772, 4042, 4031, 4056, 3838, 3776, 3984, 3911, 7150, 5142, 5559, 3935, 4103, 3985, 3906, 3948, 3753, 4060, 4040, 4050, 3929, 4081, 4019, 4066, 4000, 4061, 4052, 5600, 3951, 3972, 3862, 3897, 3796, 4054, 3746, 4172, 4096, 4039, 3989, 4022, 4067, 7713, 4112, 4029, 4004, 7712, 3894, 4099, 3809, 4051, 4173, 4109, 3893, 3946, 4106, 4014, 3802, 3990, 4037, 4097, 3964, 4035, 4045, 3716, 3962, 4120, 4021, 4062, 4020, 5628, 4032, 4057, 3849, 5190, 4114, 3901, 4123, 4095, 3933, 4082) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	128	128	2
10	SELECT `Playercontest`.`id`, `Playercontest`.`player_id`, `Playercontest`.`contest_id`, `Playercontest`.`nat_id`, `Playercontest`.`draw` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE `Playercontest`.`contest_id` = 511	128	128	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (13, 197, 178, 218, 172, 217, 196, 212, 16, 14, 133, 67, 36, 201, 92, 29, 91, 173, 121, 86, 219, 179, 58, 10, 68, 135, 81)	27	27	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (13, 197, 178, 218, 172, 217, 196, 212, 16, 14, 133, 67, 36, 201, 92, 29, 91, 173, 121, 86, 219, 179, 58, 10, 68, 135, 81)	27	27	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (3797, 4104, 4918, 5624, 3965, 3918, 4092, 3852, 4108, 4018, 3953, 4203, 3986, 3801, 3943, 4098, 3539, 4121, 3950, 3966, 4049, 3919, 3938, 7708, 3969, 3924, 5591, 5189, 4002, 4149, 3977, 7102, 3968, 4105, 3961, 4113, 4011, 4083, 3980, 4093, 4085, 4147, 4073, 4047, 4087, 3983, 3934, 5171, 3772, 4042, 4031, 4056, 3838, 3776, 3984, 3911, 7150, 5142, 5559, 3935, 4103, 3985, 3906, 3948, 3753, 4060, 4040, 4050, 3929, 4081, 4019, 4066, 4000, 4061, 4052, 5600, 3951, 3972, 3862, 3897, 3796, 4054, 3746, 4172, 4096, 4039, 3989, 4022, 4067, 7713, 4112, 4029, 4004, 7712, 3894, 4099, 3809, 4051, 4173, 4109, 3893, 3946, 4106, 4014, 3802, 3990, 4037, 4097, 3964, 4035, 4045, 3716, 3962, 4120, 4021, 4062, 4020, 5628, 4032, 4057, 3849, 5190, 4114, 3901, 4123, 4095, 3933, 4082)) AND (`Playercontest`.`contest_id` = 511))	128	128	2
14	SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 17 ORDER BY `Contest`.`date_from` ASC	137	137	1
15	SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 1989	20	20	1
16	SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (2, 3, 1, 12, 17, 22, 18, 13, 23, 4, 7, 14, 24, 25, 26, 19, 15, 16, 20, 21) AND `Category`.`gender` = 'Men' AND `Category`.`type` = 'Singles'	4	4	1
17	SELECT `Tournament`.`slug`, `Tournament`.`name` FROM `zavoihu1_db4tennis`.`tournaments` AS `Tournament` WHERE `Tournament`.`id` IN (1, 2, 3, 4)	4	4	1

(default) 17 queries took 22 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `Tournament`.`id`, `Tournament`.`name`, `Tournament`.`slug`, `Tournament`.`subtitle`, `Tournament`.`description`, `Tournament`.`surface`, `Tournament`.`venue`, `Tournament`.`eras`, `Tournament`.`history`, `Tournament`.`president`, `Tournament`.`PrizeMoney`, `Tournament`.`grandslam`, `Tournament`.`created`, `Tournament`.`modified` FROM `zavoihu1_db4tennis`.`tournaments` AS `Tournament` WHERE `Tournament`.`slug` = 'wimbledon' LIMIT 1

SELECT `Quote`.`id`, `Quote`.`tournament_id`, `Quote`.`quote`, `Quote`.`by`, `Quote`.`source`, `Quote`.`created`, `Quote`.`created_by`, `Quote`.`modified`, `Quote`.`modified_by` FROM `zavoihu1_db4tennis`.`quotes` AS `Quote` WHERE `Quote`.`tournament_id` = (3)

SELECT `Tournamenttotal`.`id`, `Tournamenttotal`.`tournament_id`, `Tournamenttotal`.`year`, `Tournamenttotal`.`price_money`, `Tournamenttotal`.`attendance`, `Tournamenttotal`.`created`, `Tournamenttotal`.`created_by`, `Tournamenttotal`.`modified`, `Tournamenttotal`.`modified_by` FROM `zavoihu1_db4tennis`.`tournamenttotals` AS `Tournamenttotal` WHERE `Tournamenttotal`.`tournament_id` = (3)

SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`tournament_id`, `Category`.`gender`, `Category`.`type`, `Category`.`surface`, `Category`.`venue`, `Category`.`president`, `Category`.`name_of_the_tournament`, `Category`.`created`, `Category`.`modified`, `Category`.`created_by`, `Category`.`modified_by`, `Tournament`.`id`, `Tournament`.`name`, `Tournament`.`slug`, `Tournament`.`subtitle`, `Tournament`.`description`, `Tournament`.`surface`, `Tournament`.`venue`, `Tournament`.`eras`, `Tournament`.`history`, `Tournament`.`president`, `Tournament`.`PrizeMoney`, `Tournament`.`grandslam`, `Tournament`.`created`, `Tournament`.`modified` FROM `zavoihu1_db4tennis`.`categories` AS `Category` LEFT JOIN `zavoihu1_db4tennis`.`tournaments` AS `Tournament` ON (`Category`.`tournament_id` = `Tournament`.`id`) WHERE `Tournament`.`slug` = 'wimbledon' AND `Category`.`slug` = 'men-singles' LIMIT 1

137

SELECT `Contest`.`id`, `Contest`.`category_id`, `Contest`.`year`, `Contest`.`slug`, `Contest`.`ch`, `Contest`.`date_from`, `Contest`.`date_to`, `Contest`.`book`, `Contest`.`name_of_the_tournament`, `Contest`.`location`, `Contest`.`venue`, `Contest`.`surface`, `Contest`.`participants`, `Contest`.`prize_money`, `Contest`.`attendance`, `Contest`.`misc`, `Contest`.`final_misc`, `Contest`.`created`, `Contest`.`created_by`, `Contest`.`modified`, `Contest`.`modified_by`, `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`tournament_id`, `Category`.`gender`, `Category`.`type`, `Category`.`surface`, `Category`.`venue`, `Category`.`president`, `Category`.`name_of_the_tournament`, `Category`.`created`, `Category`.`modified`, `Category`.`created_by`, `Category`.`modified_by` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` LEFT JOIN `zavoihu1_db4tennis`.`categories` AS `Category` ON (`Contest`.`category_id` = `Category`.`id`) WHERE `Category`.`tournament_id` = 3 AND `Contest`.`category_id` = 17 AND `Contest`.`slug` = '1989' LIMIT 1

SELECT `Match`.`id`, `Match`.`contest_id`, `Match`.`player_a_id`, `Match`.`player_aa_id`, `Match`.`player_b_id`, `Match`.`player_bb_id`, `Match`.`results`, `Match`.`long`, `Match`.`attendance`, `Match`.`no`, `Match`.`round`, `Match`.`round_id`, `Match`.`note`, `Match`.`created`, `Match`.`created_by`, `Match`.`modified`, `Match`.`modified_by` FROM `zavoihu1_db4tennis`.`matches` AS `Match` WHERE `Match`.`contest_id` = (511) ORDER BY `Match`.`round_id` ASC, `Match`.`no` ASC

127

SELECT `Player`.`id`, `Player`.`name`, `Player`.`gender`, `Player`.`slug` FROM `zavoihu1_db4tennis`.`players` AS `Player` WHERE `Player`.`id` IN (3797, 4104, 4918, 5624, 3965, 3918, 4092, 3852, 4108, 4018, 3953, 4203, 3986, 3801, 3943, 4098, 3539, 4121, 3950, 3966, 4049, 3919, 3938, 7708, 3969, 3924, 5591, 5189, 4002, 4149, 3977, 7102, 3968, 4105, 3961, 4113, 4011, 4083, 3980, 4093, 4085, 4147, 4073, 4047, 4087, 3983, 3934, 5171, 3772, 4042, 4031, 4056, 3838, 3776, 3984, 3911, 7150, 5142, 5559, 3935, 4103, 3985, 3906, 3948, 3753, 4060, 4040, 4050, 3929, 4081, 4019, 4066, 4000, 4061, 4052, 5600, 3951, 3972, 3862, 3897, 3796, 4054, 3746, 4172, 4096, 4039, 3989, 4022, 4067, 7713, 4112, 4029, 4004, 7712, 3894, 4099, 3809, 4051, 4173, 4109, 3893, 3946, 4106, 4014, 3802, 3990, 4037, 4097, 3964, 4035, 4045, 3716, 3962, 4120, 4021, 4062, 4020, 5628, 4032, 4057, 3849, 5190, 4114, 3901, 4123, 4095, 3933, 4082) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC

128

SELECT `Playercontest`.`id`, `Playercontest`.`player_id`, `Playercontest`.`contest_id`, `Playercontest`.`nat_id`, `Playercontest`.`draw` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE `Playercontest`.`contest_id` = 511

128

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (13, 197, 178, 218, 172, 217, 196, 212, 16, 14, 133, 67, 36, 201, 92, 29, 91, 173, 121, 86, 219, 179, 58, 10, 68, 135, 81)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (13, 197, 178, 218, 172, 217, 196, 212, 16, 14, 133, 67, 36, 201, 92, 29, 91, 173, 121, 86, 219, 179, 58, 10, 68, 135, 81)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (3797, 4104, 4918, 5624, 3965, 3918, 4092, 3852, 4108, 4018, 3953, 4203, 3986, 3801, 3943, 4098, 3539, 4121, 3950, 3966, 4049, 3919, 3938, 7708, 3969, 3924, 5591, 5189, 4002, 4149, 3977, 7102, 3968, 4105, 3961, 4113, 4011, 4083, 3980, 4093, 4085, 4147, 4073, 4047, 4087, 3983, 3934, 5171, 3772, 4042, 4031, 4056, 3838, 3776, 3984, 3911, 7150, 5142, 5559, 3935, 4103, 3985, 3906, 3948, 3753, 4060, 4040, 4050, 3929, 4081, 4019, 4066, 4000, 4061, 4052, 5600, 3951, 3972, 3862, 3897, 3796, 4054, 3746, 4172, 4096, 4039, 3989, 4022, 4067, 7713, 4112, 4029, 4004, 7712, 3894, 4099, 3809, 4051, 4173, 4109, 3893, 3946, 4106, 4014, 3802, 3990, 4037, 4097, 3964, 4035, 4045, 3716, 3962, 4120, 4021, 4062, 4020, 5628, 4032, 4057, 3849, 5190, 4114, 3901, 4123, 4095, 3933, 4082)) AND (`Playercontest`.`contest_id` = 511))

128

SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 17 ORDER BY `Contest`.`date_from` ASC

137

SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 1989

SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (2, 3, 1, 12, 17, 22, 18, 13, 23, 4, 7, 14, 24, 25, 26, 19, 15, 16, 20, 21) AND `Category`.`gender` = 'Men' AND `Category`.`type` = 'Singles'

SELECT `Tournament`.`slug`, `Tournament`.`name` FROM `zavoihu1_db4tennis`.`tournaments` AS `Tournament` WHERE `Tournament`.`id` IN (1, 2, 3, 4)