Wimbledon 1982 Gentlemen's Singles (June 21 - July 4)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	John McEnroe
				John McEnroe
2.			Van Winitsky	6-2 6-2 6-1
					John McEnroe
3.		[Q]	Eddie Edwards		6-3 6-3 7-5
				Eddie Edwards
4.		[LL]	Greg Whitecross	6-4 6-7 6-2 7-5
						John McEnroe
5.			Cassio Motta			6-2 6-2 6-0
				Cassio Motta
6.			Freddie Sauer	3-6 6-2 6-4 6-4
					Lloyd Bourne
7.			Lloyd Bourne		6-4 6-4 1-6 5-7 6-3
				Lloyd Bourne
8.			Ilie Nastase	6-1 6-3 3-6 6-4
							John McEnroe
9.			Dick Stockton				6-4 6-4 6-4
				Dick Stockton
10.			Bruce Manson	6-3 6-4 7-6
					John Fitzgerald
11.			John Fitzgerald		6-4 6-3 6-1
				John Fitzgerald
12.			Jiri Granat	6-2 7-6 6-4
						Hank Pfister
13.			Hank Pfister			6-4 5-7 6-4 5-7 6-2
				Hank Pfister
14.			Mel Purcell	6-2 6-3 6-4
					Hank Pfister
15.			Stan Smith		6-4 7-6 7-6
				Stan Smith
16.		[9]	Andres Gomez	6-4 6-3 5-7 7-6
								John McEnroe
17.		[13]	Brian Gottfried					4-6 6-2 7-5 6-3
				Brian Gottfried
18.			Gilles Moretton	7-6 7-6 6-2
					Nick Saviano
19.			Nick Saviano		6-7 6-7 7-5 6-4 6-1
				Nick Saviano
20.			Angel Gimenez	6-2 6-1 7-6
						Nick Saviano
21.			David Carter			6-4 6-4 6-4
				David Carter
22.			Jerome Potier	6-2 6-3 6-4
					David Carter
23.			Andy Andrews		3-6 7-5 6-7 6-3 9-7
				Andy Andrews
24.		[Q]	Charles Fancutt	6-1 7-6 7-6
							Johan Kriek
25.			Peter Rennert				6-2 6-3 7-5
				Peter Rennert
26.			Derek Tarr	6-3 3-6 3-6 6-2 6-4
					Peter Rennert
27.			Jonathan Smith		7-6 7-6 4-6 6-3
				Jonathan Smith
28.			Juan Avendano	2-6 6-1 6-4 7-6
						Johan Kriek
29.			Peter Elter			4-6 6-3 6-4 6-1
				Peter Elter
30.		[Q]	Chris Dunk	6-4 7-6 6-3
					Johan Kriek
31.		[5]	Johan Kriek		4-6 6-3 3-6 6-0 6-4
				Johan Kriek
32.		[Q]	Craig Wittus	6-7 6-3 6-1 6-0
									John McEnroe
33.		[4]	Sandy Mayer						6-3 6-1 6-2
				Sandy Mayer
34.			Haroon Ismail	7-5 6-2 6-3
					Sandy Mayer
35.		[Q]	Colin Dowdeswell		6-2 6-2 6-3
				Colin Dowdeswell
36.			Georges Goven	6-2 3-6 6-3 6-2
						Tim Mayotte
37.			Tim Mayotte			3-6 6-7 6-4 6-2 6-4
				Tim Mayotte
38.			Peter Fleming	6-7 6-4 6-3 6-4
					Tim Mayotte
39.		[Q]	Sashi Menon		6-4 6-2 3-6 7-5
				Sashi Menon
40.			Pavel Slozil	6-2 7-6 6-0
							Tim Mayotte
41.			Chris Johnstone				6-2 7-5 6-3
				Chris Johnstone
42.		[Q]	David Schneider	7-6 6-3 7-6
					Chris Johnstone
43.			Jay Lapidus		6-2 6-7 6-4 6-4
				Jay Lapidus
44.			Zoltan Kuharszky	3-6 7-5 6-3 6-0
						Christopher Mottram
45.			Victor Amaya			6-1 6-3 6-2
				Victor Amaya
46.			Nick Brown	7-6 6-3 6-3
					Christopher Mottram
47.		[15]	Christopher Mottram		6-4 5-7 6-4 6-4
				Christopher Mottram
48.			Anders Jarryd	6-7 6-1 6-3 6-2
								Tim Mayotte
49.		[11]	Brian Teacher					6-7 7-6 7-5 3-6 6-1
				Brian Teacher
50.			Shlomo Glickstein	3-6 7-6 6-4 4-6 6-2
					Brian Teacher
51.			Rod Frawley		7-5 6-3 4-6 6-3
				Rod Frawley
52.			Patrick Dupre	6-7 6-3 7-6 6-3
						Brian Teacher
53.			Stefan Simonsson			7-6 4-6 6-3 6-3
				Stefan Simonsson
54.			Bill Scanlon	7-5 6-4 6-1
					Stefan Simonsson
55.			Leo Palin		6-3 6-4 6-7 7-5
				Leo Palin
56.			Craig Miller	3-6 6-2 7-6 4-6 6-4
							Brian Teacher
57.			Stanislav Birner				6-4 6-4 6-3
				Stanislav Birner
58.		[Q]	Rand Evett	6-4 6-4 2-6 6-2
					Stanislav Birner
59.			Claudio Panatta		6-4 3-6 3-6 6-1 6-4
				Claudio Panatta
60.			Rick Fagel	2-6 6-0 6-1 6-2
						Mats Wilander
61.			Nduka Odizor			6-3 6-4 6-4
				Nduka Odizor
62.			Jose Lopez-Maeso	4-6 7-6 7-5 7-6
					Mats Wilander
63.		[7]	Mats Wilander		7-6 6-4 6-0
				Mats Wilander
64.			Heinz Gunthardt	6-4 6-3 3-6 6-3
										Jimmy Connors
65.			Chip Hooper							3-6 6-3 6-7 7-6 6-4
				Chip Hooper
66.		[8]	Peter McNamara	7-6 3-6 6-2 6-4
					Russell Simpson
67.			Russell Simpson		6-3 1-6 6-3 6-7 11-9
				Russell Simpson
68.			John Lloyd	3-6 4-6 7-6 6-4 6-4
						Russell Simpson
69.			Marcos Hocevar			3-6 5-7 6-3 7-6 6-3
				Marcos Hocevar
70.			Steve Krulevitz	6-4 6-2 6-3
					Marcos Hocevar
71.			Francisco Gonzalez		7-6 4-6 7-6 7-6
				Francisco Gonzalez
72.			Scott McCain	6-3 6-2 6-7 5-7 6-1
							Mark Edmondson
73.		[Q]	David Dowlen				6-4 7-6 7-6
				David Dowlen
74.			Joakim Nystrom	6-3 3-6 6-1 6-3
					Ramesh Krishnan
75.			Ramesh Krishnan		6-4 7-5 6-0
				Ramesh Krishnan
76.			Andrew Jarrett	6-4 2-6 4-6 7-6 6-2
						Mark Edmondson
77.			Joao Soares			6-3 1-6 6-1 6-4
				Joao Soares
78.		[Q]	Henrik Sundstrom	7-6 6-3 6-2
					Mark Edmondson
79.		[12]	Mark Edmondson		6-3 7-5 6-3
				Mark Edmondson
80.			Marty Davis	7-6 7-5 7-5
								Mark Edmondson
81.		[14]	Roscoe Tanner					7-6 3-6 6-4 6-3
				Roscoe Tanner
82.			Henri Leconte	6-4 7-5 6-4
					Roscoe Tanner
83.			Fritz Buehning		6-3 6-3 6-7 6-4
				Fritz Buehning
84.			Mike Estep	6-3 6-3 7-6
						Roscoe Tanner
85.			Pascal Portes			6-4 6-4 4-6 4-6 6-3
				Pascal Portes
86.			John Austin	7-6 6-2 6-2
					Vijay Amritraj
87.		[Q]	Vijay Amritraj		6-2 6-3 6-2
				Vijay Amritraj
88.			Jeff Borowiak	6-7 4-6 6-3 6-4 6-3
							Vitas Gerulaitis
89.			Bernard Fritz				6-3 6-4 6-3
				Bernard Fritz
90.			Sergio Casal	6-2 7-5 4-6 6-7 6-3
					Tomas Smid
91.			Tomas Smid		6-4 6-4 6-3
				Tomas Smid
92.			Richard Lewis	6-3 7-6 6-0
						Vitas Gerulaitis
93.			Bruce Derlin			6-7 3-6 6-3 6-4 6-2
				Bruce Derlin
94.			Danie Visser	5-7 7-6 6-3 7-5
					Vitas Gerulaitis
95.		[3]	Vitas Gerulaitis		7-5 6-2 6-3
				Vitas Gerulaitis
96.		[LL]	Brent Pirow	6-4 6-1 6-1
									Jimmy Connors
97.		[6]	Gene Mayer						6-4 6-3 6-1
				Gene Mayer
98.			Tim Gullikson	5-7 6-4 6-1 7-5
					Gene Mayer
99.			Brad Drewett		6-7 6-3 6-2 6-1
				Brad Drewett
100.		[Q]	Peter Doohan	7-6 6-2 6-4
						Gene Mayer
101.		[Q]	Larry Stefanki			7-6 6-3 6-0
				Larry Stefanki
102.			Alejandro Cortes	6-4 6-2 6-1
					Larry Stefanki
103.			Eric Fromm		6-3 4-6 6-4 7-6
				Eric Fromm
104.		[Q]	Syd Ball	6-4 3-6 7-6 6-2
							Gene Mayer
105.			Chris Lewis				6-3 6-4 6-4
				Chris Lewis
106.			Julio Goes	6-2 6-3 6-2
					Chris Lewis
107.			Tom Gullikson		7-6 7-6 7-6
				Tom Gullikson
108.			Jeremy Bates	6-4 6-4 6-3
						Steve Denton
109.		[Q]	Schalk Van Der Merwe			7-6 7-5 6-7 7-5
				Schalk Van Der Merwe
110.			Terry Moor	6-4 6-2 7-6
					Steve Denton
111.		[16]	Steve Denton		6-7 7-5 3-6 6-4 13-11
				Steve Denton
112.			John Sadri	6-7 7-6 6-4 3-6 6-3
								Jimmy Connors
113.			Bob Lutz					6-1 6-2 7-6
				Bob Lutz
114.		[LL]	Rick Meyer	2-6 6-3 6-2 6-7 6-4
					Paul McNamee
115.			Paul McNamee		6-1 1-6 6-3 7-6
				Paul McNamee
116.			Matt Doyle	5-7 6-3 7-6 7-6
						Paul McNamee
117.			Bernard Boileau			7-6 3-6 3-6 6-4 6-1
				Bernard Boileau
118.			Vincent Van Patten	6-4 3-6 2-6 7-5 6-1
					Kevin Curren
119.			Kevin Curren		6-4 6-3 6-2
				Kevin Curren
120.			John Feaver	6-2 6-2 6-2
							Jimmy Connors
121.			Thierry Tulasne				6-2 6-3 6-1
				Thierry Tulasne
122.		[Q]	Michael Fancutt	6-3 6-4 3-6 7-6
					Drew Gitlin
123.		[Q]	Drew Gitlin		6-3 6-4 6-2
				Drew Gitlin
124.			Andreas Maurer	7-5 7-5 6-4
						Jimmy Connors
125.			John Alexander			6-2 6-7 7-5 7-5
				John Alexander
126.			Kim Warwick	2-6 5-7 7-6 6-3 7-5
					Jimmy Connors
127.		[2]	Jimmy Connors		6-3 4-6 6-1 7-6
				Jimmy Connors
128.		[LL]	Mike Myburg	6-0 6-2 6-2

(default) 17 queries took 27 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` = '1982' 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` = (504) 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, 3709, 3858, 3848, 3911, 3827, 3853, 3527, 3490, 3662, 3862, 3625, 3762, 3789, 3386, 3802, 3612, 3787, 3822, 5134, 3791, 3915, 3910, 4859, 3793, 3859, 3864, 5155, 5135, 3907, 3776, 3855, 3550, 3871, 3708, 3495, 3809, 3701, 3565, 3812, 4852, 3705, 3803, 4908, 3655, 5628, 3641, 3924, 3657, 3829, 4313, 3624, 3892, 3716, 3742, 4849, 3766, 4871, 3912, 3698, 3888, 3909, 3894, 3765, 3837, 3825, 3740, 3646, 3908, 3542, 3758, 3879, 3785, 3936, 3801, 4844, 3824, 3903, 3706, 3852, 3529, 3913, 3806, 3454, 3770, 3810, 3639, 3498, 3867, 4026, 3743, 3741, 4875, 3901, 3573, 5160, 3744, 3703, 3796, 3944, 3866, 3860, 3805, 3665, 3771, 3900, 3993, 3984, 3887, 3715, 3880, 3790, 3436, 3839, 3751, 3875, 5158, 3798, 3772, 3640, 3843, 4912, 3872, 4921, 3515, 3666, 3539, 3891) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	128	128	4
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` = 504	128	128	2
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 68, 13, 153, 86, 217, 196, 172, 135, 67, 146, 179, 58, 29, 91, 43, 207, 138, 178, 173, 92, 212, 21, 84)	24	24	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 68, 13, 153, 86, 217, 196, 172, 135, 67, 146, 179, 58, 29, 91, 43, 207, 138, 178, 173, 92, 212, 21, 84)	24	24	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (3753, 3709, 3858, 3848, 3911, 3827, 3853, 3527, 3490, 3662, 3862, 3625, 3762, 3789, 3386, 3802, 3612, 3787, 3822, 5134, 3791, 3915, 3910, 4859, 3793, 3859, 3864, 5155, 5135, 3907, 3776, 3855, 3550, 3871, 3708, 3495, 3809, 3701, 3565, 3812, 4852, 3705, 3803, 4908, 3655, 5628, 3641, 3924, 3657, 3829, 4313, 3624, 3892, 3716, 3742, 4849, 3766, 4871, 3912, 3698, 3888, 3909, 3894, 3765, 3837, 3825, 3740, 3646, 3908, 3542, 3758, 3879, 3785, 3936, 3801, 4844, 3824, 3903, 3706, 3852, 3529, 3913, 3806, 3454, 3770, 3810, 3639, 3498, 3867, 4026, 3743, 3741, 4875, 3901, 3573, 5160, 3744, 3703, 3796, 3944, 3866, 3860, 3805, 3665, 3771, 3900, 3993, 3984, 3887, 3715, 3880, 3790, 3436, 3839, 3751, 3875, 5158, 3798, 3772, 3640, 3843, 4912, 3872, 4921, 3515, 3666, 3539, 3891)) AND (`Playercontest`.`contest_id` = 504))	128	128	4
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` = 1982	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 27 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` = '1982' 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` = (504) 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, 3709, 3858, 3848, 3911, 3827, 3853, 3527, 3490, 3662, 3862, 3625, 3762, 3789, 3386, 3802, 3612, 3787, 3822, 5134, 3791, 3915, 3910, 4859, 3793, 3859, 3864, 5155, 5135, 3907, 3776, 3855, 3550, 3871, 3708, 3495, 3809, 3701, 3565, 3812, 4852, 3705, 3803, 4908, 3655, 5628, 3641, 3924, 3657, 3829, 4313, 3624, 3892, 3716, 3742, 4849, 3766, 4871, 3912, 3698, 3888, 3909, 3894, 3765, 3837, 3825, 3740, 3646, 3908, 3542, 3758, 3879, 3785, 3936, 3801, 4844, 3824, 3903, 3706, 3852, 3529, 3913, 3806, 3454, 3770, 3810, 3639, 3498, 3867, 4026, 3743, 3741, 4875, 3901, 3573, 5160, 3744, 3703, 3796, 3944, 3866, 3860, 3805, 3665, 3771, 3900, 3993, 3984, 3887, 3715, 3880, 3790, 3436, 3839, 3751, 3875, 5158, 3798, 3772, 3640, 3843, 4912, 3872, 4921, 3515, 3666, 3539, 3891) 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` = 504

128

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 68, 13, 153, 86, 217, 196, 172, 135, 67, 146, 179, 58, 29, 91, 43, 207, 138, 178, 173, 92, 212, 21, 84)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 68, 13, 153, 86, 217, 196, 172, 135, 67, 146, 179, 58, 29, 91, 43, 207, 138, 178, 173, 92, 212, 21, 84)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (3753, 3709, 3858, 3848, 3911, 3827, 3853, 3527, 3490, 3662, 3862, 3625, 3762, 3789, 3386, 3802, 3612, 3787, 3822, 5134, 3791, 3915, 3910, 4859, 3793, 3859, 3864, 5155, 5135, 3907, 3776, 3855, 3550, 3871, 3708, 3495, 3809, 3701, 3565, 3812, 4852, 3705, 3803, 4908, 3655, 5628, 3641, 3924, 3657, 3829, 4313, 3624, 3892, 3716, 3742, 4849, 3766, 4871, 3912, 3698, 3888, 3909, 3894, 3765, 3837, 3825, 3740, 3646, 3908, 3542, 3758, 3879, 3785, 3936, 3801, 4844, 3824, 3903, 3706, 3852, 3529, 3913, 3806, 3454, 3770, 3810, 3639, 3498, 3867, 4026, 3743, 3741, 4875, 3901, 3573, 5160, 3744, 3703, 3796, 3944, 3866, 3860, 3805, 3665, 3771, 3900, 3993, 3984, 3887, 3715, 3880, 3790, 3436, 3839, 3751, 3875, 5158, 3798, 3772, 3640, 3843, 4912, 3872, 4921, 3515, 3666, 3539, 3891)) AND (`Playercontest`.`contest_id` = 504))

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

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)