Wimbledon 1985 Gentlemen's Singles (June 24 - July 7)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	John McEnroe
				John McEnroe
2.			Peter McNamara	6-4 6-3 6-4
					John McEnroe
3.			Nduka Odizor		7-6 6-1 7-6
				Nduka Odizor
4.		[Q]	Gary Muller	6-7 6-7 7-6 6-3 6-3
						John McEnroe
5.			Chris Lewis			6-3 7-5 6-4
				Chris Lewis
6.			Stephen Shaw	6-4 6-2 6-3
					Christo Steyn
7.		[Q]	Christo Steyn		3-6 7-6 6-4 6-4
				Christo Steyn
8.			Givaldo Barbosa	6-4 6-4 6-2
							John McEnroe
9.		[Q]	Andreas Maurer				6-0 6-4 6-2
				Andreas Maurer
10.			John Frawley	7-5 6-3 7-5
					Andreas Maurer
11.			Hans Schwaier		6-3 7-5 7-5
				Hans Schwaier
12.		[Q]	Robert Van't Hof	6-3 6-2 6-4
						Andreas Maurer
13.			John Fitzgerald			6-1 6-4 3-6 6-3
				John Fitzgerald
14.		[Q]	Tony Giammalva	6-4 7-5 6-1
					Johan Kriek
15.		[9]	Johan Kriek		3-6 7-6 7-5 6-1
				Johan Kriek
16.			Victor Pecci	6-4 6-0 4-6 7-5
								Kevin Curren
17.		[14]	Stefan Edberg					6-2 6-2 6-4
				Stefan Edberg
18.			Peter Doohan	6-2 6-3 6-4
					Stefan Edberg
19.			Tim Wilkinson		6-1 7-5 3-6 6-7 9-7
				Tim Wilkinson
20.			Marko Ostoja	6-4 6-0 2-6 7-6
						Stefan Edberg
21.			Terry Moor			6-3 6-4 6-4
				Terry Moor
22.			Jakob Hlasek	6-3 3-6 6-7 7-6 7-5
					Chip Hooper
23.			Chip Hooper		6-4 6-4 7-5
				Chip Hooper
24.			Balazs Taroczy	7-5 7-6 6-3
							Kevin Curren
25.		[Q]	David Mustard				7-6 6-3 7-6
				David Mustard
26.			Stuart Bale	7-6 6-2 4-6 6-4
					David Mustard
27.			Marc Flur		7-6 6-4 2-6 6-4
				Marc Flur
28.			Jeremy Bates	6-4 6-3 6-4
						Kevin Curren
29.			Mike De Palmer			6-3 6-3 7-5
				Mike De Palmer
30.			Raul Viver	6-3 6-3 3-6 6-3
					Kevin Curren
31.		[8]	Kevin Curren		7-5 5-7 6-4 6-4
				Kevin Curren
32.			Larry Stefanki	7-6 6-3 6-4
									Kevin Curren
33.		[3]	Jimmy Connors						6-2 6-2 6-1
				Jimmy Connors
34.			Stefan Simonsson	6-1 6-3 6-4
					Jimmy Connors
35.		[Q]	Kelly Evernden		6-3 6-2 6-1
				Kelly Evernden
36.			Jaroslav Navratil	6-4 6-4 6-4
						Jimmy Connors
37.			Ramesh Krishnan			7-5 5-7 7-5 6-2
				Ramesh Krishnan
38.			Bruce Derlin	6-2 7-5 4-6 7-6
					Ramesh Krishnan
39.			Lloyd Bourne		6-4 7-5 6-2
				Lloyd Bourne
40.			Guy Forget	3-6 6-3 6-3 6-4
							Jimmy Connors
41.			Leif Shiras				6-3 6-4 6-3
				Leif Shiras
42.			Leighton Alfred	6-3 7-6 6-3
					Ben Testerman
43.			Ben Testerman		6-4 6-7 4-6 6-1 7-5
				Ben Testerman
44.		[Q]	Craig Miller	3-6 6-3 6-4 6-2
						Sammy Giammalva Jr.
45.			Sammy Giammalva Jr.			4-6 6-3 7-5 7-6
				Sammy Giammalva Jr.
46.		[Q]	Charles Cox	6-0 6-4 5-7 6-4
					Sammy Giammalva Jr.
47.		[15]	Tomas Smid		6-3 6-1 6-2
				Tomas Smid
48.			Russell Simpson	6-4 6-7 7-5 7-6
								Jimmy Connors
49.			Tom Gullikson					6-1 7-6 6-2
				Tom Gullikson
50.		[12]	Miloslav Mecir Sr.	4-6 6-3 6-4 6-7 6-3
					Tom Gullikson
51.			Jay Lapidus		6-7 6-7 6-4 6-2 6-3
				Jay Lapidus
52.			Jimmy Arias	6-4 6-4 3-6 6-7 7-5
						Robert Seguso
53.			Mike Bauer			4-6 6-3 7-5 6-2
				Mike Bauer
54.			Marian Vajda	5-7 7-6 7-5 6-2
					Robert Seguso
55.		[Q]	Robert Seguso		6-3 6-4 6-4
				Robert Seguso
56.			Rodney Harmon	6-4 6-3 6-0
							Ricardo Acuna
57.			Steve Denton				6-4 7-6 6-2
				Steve Denton
58.			Tim Gullikson	6-4 6-3 3-6 6-3
					David Pate
59.			David Pate		7-6 6-4 6-4
				David Pate
60.			Nicholas Fulwood	6-3 6-4 6-4
						Ricardo Acuna
61.		[Q]	Ricardo Acuna			7-5 6-4 6-2
				Ricardo Acuna
62.			Tarik Benhabiles	6-3 4-6 6-1 6-2
					Ricardo Acuna
63.		[6]	Pat Cash		7-6 6-3 3-6 6-7 6-4
				Pat Cash
64.			Todd Nelson	2-6 6-2 7-5 6-7 6-3
										Boris Becker
65.		[5]	Anders Jarryd							6-3 6-7 7-6 6-4
				Anders Jarryd
66.			Claudio Panatta	4-6 3-6 6-4 6-4 6-3
					Anders Jarryd
67.			Scott Davis		5-7 7-6 7-5 6-4
				Scott Davis
68.		[Q]	Barry Moir	6-2 6-2 6-3
						Anders Jarryd
69.			Matt Mitchell			6-3 6-3 6-1
				Matt Mitchell
70.		[Q]	Thierry Champion	6-3 6-4 6-2
					Vincent Van Patten
71.			Vincent Van Patten		7-5 6-3 6-2
				Vincent Van Patten
72.			Peter Elter	6-3 6-7 7-5 6-4
							Anders Jarryd
73.			Danie Visser				6-1 6-4 6-1
				Danie Visser
74.			Damir Keretic	7-6 6-4 6-7 6-3
					Danie Visser
75.			Jan Gunnarsson		6-7 6-4 6-4 7-6
				Jan Gunnarsson
76.			Marty Davis	6-3 6-2 3-6 6-3
						Danie Visser
77.			Greg Holmes			6-3 4-6 6-7 6-0 10-8
				Greg Holmes
78.			Henrik Sundstrom	6-3 4-6 6-7 6-4 6-2
					Greg Holmes
79.			Bud Schultz		6-4 6-7 6-2 6-3
				Bud Schultz
80.		[10]	Aaron Krickstein	6-4 3-6 7-6 6-4
								Anders Jarryd
81.		[11]	Yannick Noah					6-4 6-3 6-2
				Yannick Noah
82.			Brad Gilbert	6-4 3-6 7-6 6-7 6-3
					Yannick Noah
83.			Eddie Edwards		4-6 6-4 7-6 6-2
				Eddie Edwards
84.			Colin Dowdeswell	6-3 6-3 6-3
						Vijay Amritraj
85.			Vijay Amritraj			4-6 7-6 6-3 7-6
				Vijay Amritraj
86.			Jonathan Canter	6-3 6-4 6-4
					Vijay Amritraj
87.			Brad Drewett		7-6 6-7 7-6 7-5
				Brad Drewett
88.			Scott McCain	7-6 7-5 6-4
							Heinz Gunthardt
89.			Vitas Gerulaitis				6-4 6-4 6-1
				Vitas Gerulaitis
90.			Peter Fleming	6-2 5-7 6-4 3-6 6-3
					Vitas Gerulaitis
91.			John Sadri		5-7 6-4 3-6 7-6 6-4
				John Sadri
92.			Cassio Motta	6-3 6-2 6-3
						Heinz Gunthardt
93.			Heinz Gunthardt			6-3 6-7 6-1 3-6 7-5
				Heinz Gunthardt
94.			Brian Teacher	6-4 7-5 6-7 6-2
					Heinz Gunthardt
95.			Slobodan Zivojinovic		6-4 4-6 4-6 6-3 6-4
				Slobodan Zivojinovic
96.		[4]	Mats Wilander	6-2 5-7 7-5 6-0
									Boris Becker
97.		[7]	Joakim Nystrom						2-6 7-6 6-3 6-3
				Joakim Nystrom
98.			Jason Goodall	6-3 6-3 3-6 6-0
					Joakim Nystrom
99.			Paul Annacone		7-5 7-5 6-3
				Paul Annacone
100.			Dan Goldie	5-7 7-5 6-1 1-6 9-7
						Boris Becker
101.		[Q]	Matt Anger			3-6 7-6 6-1 4-6 9-7
				Matt Anger
102.			Zoltan Kuharszky	5-7 6-2 6-2 3-6 6-1
					Boris Becker
103.			Boris Becker		6-0 6-1 6-3
				Boris Becker
104.			Hank Pfister	4-6 6-3 6-2 6-4
							Boris Becker
105.			Paul McNamee				6-3 4-6 6-7 7-6 6-2
				Paul McNamee
106.			Steve Meister	6-2 6-4 7-6
					Paul McNamee
107.		[Q]	Roberto Saad		6-3 7-6 7-6
				Roberto Saad
108.			Bob Green	6-3 6-2 6-4
						Tim Mayotte
109.			Ken Flach			3-6 4-6 7-6 6-2 6-0
				Ken Flach
110.			Pavel Slozil	6-3 6-7 6-1 7-6
					Tim Mayotte
111.		[16]	Tim Mayotte		6-4 6-4 6-4
				Tim Mayotte
112.			Trevor Allan	7-5 6-4 6-2
								Boris Becker
113.		[13]	Eliot Teltscher					7-6 3-6 6-3 6-4
				Eliot Teltscher
114.			Gianni Ocleppo	5-7 7-6 7-6 6-0
					John Lloyd
115.			John Lloyd		6-3 6-4 4-6 3-6 7-5
				John Lloyd
116.			Wolfgang Popp	6-2 6-4 7-6
						Henri Leconte
117.			Henri Leconte			5-7 6-3 6-4 6-4
				Henri Leconte
118.		[Q]	Chris Dunk	6-3 7-6 7-6
					Henri Leconte
119.			Wally Masur		4-6 6-4 7-6 6-3
				Wally Masur
120.			Dan Cassidy	7-6 7-6 6-1
							Henri Leconte
121.			Shlomo Glickstein				3-6 6-4 6-3 6-1
				Shlomo Glickstein
122.			Jose Lopez-Maeso	7-6 6-3 6-1
					Shlomo Glickstein
123.			Francisco Gonzalez		6-3 6-4 3-6 7-5
				Francisco Gonzalez
124.			Mark Edmondson	6-3 6-2 7-6
						Ivan Lendl
125.			Mike Leach			7-6 4-6 6-3 6-2
				Mike Leach
126.			Wojtek Fibak	7-6 6-4 6-1
					Ivan Lendl
127.		[2]	Ivan Lendl		6-3 1-6 6-2 6-7 6-4
				Ivan Lendl
128.			Mel Purcell	6-4 7-6 7-6

(default) 17 queries took 30 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	2
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	4
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	3
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` = '1985' 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` = (507) 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 (3753, 3825, 3888, 3985, 3771, 4917, 3922, 3813, 4921, 3952, 3940, 3795, 3862, 3756, 3776, 3684, 3933, 3944, 3746, 3826, 3715, 3948, 3837, 3661, 4884, 5539, 3963, 3984, 3877, 3971, 3772, 3866, 3539, 3892, 3966, 3987, 3801, 4875, 3853, 3931, 3838, 9035, 3890, 4849, 4203, 5578, 3743, 3740, 3993, 3977, 3803, 3828, 3925, 3965, 3929, 3904, 3880, 3703, 3893, 5559, 3885, 3982, 3899, 3930, 3924, 3912, 3849, 4010, 3752, 4018, 3798, 5135, 3901, 4876, 4011, 3852, 4020, 3903, 3960, 3934, 3768, 3897, 3858, 3708, 3639, 3935, 3796, 3879, 3573, 3701, 3790, 3911, 3765, 3657, 3969, 3894, 3936, 7862, 3946, 3950, 3919, 4908, 3968, 3762, 3751, 3874, 3970, 3939, 3953, 3812, 3809, 4332, 3754, 3767, 3646, 5146, 3913, 3907, 3938, 3973, 3829, 3909, 3758, 3706, 3884, 3685, 3797, 3789) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	128	128	3
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` = 507	128	128	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (196, 217, 197, 86, 84, 146, 149, 13, 135, 179, 92, 68, 29, 219, 91, 172, 41, 138, 178, 173, 212, 10, 58)	23	23	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (196, 217, 197, 86, 84, 146, 149, 13, 135, 179, 92, 68, 29, 219, 91, 172, 41, 138, 178, 173, 212, 10, 58)	23	23	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (3753, 3825, 3888, 3985, 3771, 4917, 3922, 3813, 4921, 3952, 3940, 3795, 3862, 3756, 3776, 3684, 3933, 3944, 3746, 3826, 3715, 3948, 3837, 3661, 4884, 5539, 3963, 3984, 3877, 3971, 3772, 3866, 3539, 3892, 3966, 3987, 3801, 4875, 3853, 3931, 3838, 9035, 3890, 4849, 4203, 5578, 3743, 3740, 3993, 3977, 3803, 3828, 3925, 3965, 3929, 3904, 3880, 3703, 3893, 5559, 3885, 3982, 3899, 3930, 3924, 3912, 3849, 4010, 3752, 4018, 3798, 5135, 3901, 4876, 4011, 3852, 4020, 3903, 3960, 3934, 3768, 3897, 3858, 3708, 3639, 3935, 3796, 3879, 3573, 3701, 3790, 3911, 3765, 3657, 3969, 3894, 3936, 7862, 3946, 3950, 3919, 4908, 3968, 3762, 3751, 3874, 3970, 3939, 3953, 3812, 3809, 4332, 3754, 3767, 3646, 5146, 3913, 3907, 3938, 3973, 3829, 3909, 3758, 3706, 3884, 3685, 3797, 3789)) AND (`Playercontest`.`contest_id` = 507))	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	3
15	SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 1985	19	19	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, 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 30 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` = '1985' 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` = (507) 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 (3753, 3825, 3888, 3985, 3771, 4917, 3922, 3813, 4921, 3952, 3940, 3795, 3862, 3756, 3776, 3684, 3933, 3944, 3746, 3826, 3715, 3948, 3837, 3661, 4884, 5539, 3963, 3984, 3877, 3971, 3772, 3866, 3539, 3892, 3966, 3987, 3801, 4875, 3853, 3931, 3838, 9035, 3890, 4849, 4203, 5578, 3743, 3740, 3993, 3977, 3803, 3828, 3925, 3965, 3929, 3904, 3880, 3703, 3893, 5559, 3885, 3982, 3899, 3930, 3924, 3912, 3849, 4010, 3752, 4018, 3798, 5135, 3901, 4876, 4011, 3852, 4020, 3903, 3960, 3934, 3768, 3897, 3858, 3708, 3639, 3935, 3796, 3879, 3573, 3701, 3790, 3911, 3765, 3657, 3969, 3894, 3936, 7862, 3946, 3950, 3919, 4908, 3968, 3762, 3751, 3874, 3970, 3939, 3953, 3812, 3809, 4332, 3754, 3767, 3646, 5146, 3913, 3907, 3938, 3973, 3829, 3909, 3758, 3706, 3884, 3685, 3797, 3789) 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` = 507

128

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (196, 217, 197, 86, 84, 146, 149, 13, 135, 179, 92, 68, 29, 219, 91, 172, 41, 138, 178, 173, 212, 10, 58)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (196, 217, 197, 86, 84, 146, 149, 13, 135, 179, 92, 68, 29, 219, 91, 172, 41, 138, 178, 173, 212, 10, 58)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (3753, 3825, 3888, 3985, 3771, 4917, 3922, 3813, 4921, 3952, 3940, 3795, 3862, 3756, 3776, 3684, 3933, 3944, 3746, 3826, 3715, 3948, 3837, 3661, 4884, 5539, 3963, 3984, 3877, 3971, 3772, 3866, 3539, 3892, 3966, 3987, 3801, 4875, 3853, 3931, 3838, 9035, 3890, 4849, 4203, 5578, 3743, 3740, 3993, 3977, 3803, 3828, 3925, 3965, 3929, 3904, 3880, 3703, 3893, 5559, 3885, 3982, 3899, 3930, 3924, 3912, 3849, 4010, 3752, 4018, 3798, 5135, 3901, 4876, 4011, 3852, 4020, 3903, 3960, 3934, 3768, 3897, 3858, 3708, 3639, 3935, 3796, 3879, 3573, 3701, 3790, 3911, 3765, 3657, 3969, 3894, 3936, 7862, 3946, 3950, 3919, 4908, 3968, 3762, 3751, 3874, 3970, 3939, 3953, 3812, 3809, 4332, 3754, 3767, 3646, 5146, 3913, 3907, 3938, 3973, 3829, 3909, 3758, 3706, 3884, 3685, 3797, 3789)) AND (`Playercontest`.`contest_id` = 507))

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` = 1985

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, 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)