Wimbledon 1983 Gentlemen's Singles (June 20 - July 3)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Jimmy Connors
				Jimmy Connors
2.			Eddie Edwards	6-4 7-5 6-3
					Jimmy Connors
3.			Wally Masur		6-4 7-6 6-0
				Wally Masur
4.			Lloyd Bourne	4-6 4-6 6-4 6-3 6-2
						Jimmy Connors
5.			Henrik Sundstrom			6-1 7-6 6-2
				Henrik Sundstrom
6.			Vincent Van Patten	6-4 6-0 2-6 7-5
					Henrik Sundstrom
7.			Stefan Edberg		2-6 7-6 7-6 4-6 8-6
				Stefan Edberg
8.			Christophe Roger-Vasselin	6-2 7-6 6-1
							Kevin Curren
9.			Brad Drewett				6-3 6-7 6-3 7-6
				Brad Drewett
10.			Alberto Tous	6-3 6-1 6-1
					Rodney Harmon
11.			Rodney Harmon		6-2 6-4 6-4
				Rodney Harmon
12.			Robbie Venter	6-2 6-3 3-6 7-6
						Kevin Curren
13.			Sergio Casal			6-4 7-5 6-2
				Sergio Casal
14.			Hans Simonsson	3-6 6-3 6-2 3-6 6-3
					Kevin Curren
15.		[12]	Kevin Curren		7-6 6-4 6-3
				Kevin Curren
16.			Jeff Borowiak	6-7 6-3 7-5 1-0 rtd.
								Kevin Curren
17.		[16]	Tim Mayotte					4-6 7-6 6-2 7-6
				Tim Mayotte
18.			Mark Dickson	7-5 6-3 6-3
					Tim Mayotte
19.		[Q]	Andy Andrews		6-1 6-2 6-2
				Andy Andrews
20.			Anders Jarryd	6-4 7-6 6-3
						Tim Mayotte
21.			Brian Teacher			7-6 6-4 6-7 6-3
				Brian Teacher
22.			Marcos Hocevar	6-4 6-0 2-6 6-4
					Brian Teacher
23.			Wojtek Fibak		7-6 2-6 4-6 7-5 6-1
				Wojtek Fibak
24.			Christopher Mottram	4-6 6-4 7-6 6-2
							Tim Mayotte
25.			Tom Gullikson				6-0 6-2 6-4
				Tom Gullikson
26.		[LL]	Sashi Menon	6-2 6-1 6-2
					Cassio Motta
27.			Cassio Motta		3-6 7-6 6-4 6-4
				Cassio Motta
28.			Raul Ramirez	7-6 6-1 2-6 3-2 rtd.
						John McCurdy
29.		[LL]	John McCurdy			6-0 6-4 3-6 6-1
				John McCurdy
30.			Juan Avendano	6-3 6-4 6-2
					John McCurdy
31.			Claudio Panatta		7-6 6-3 7-6
				Claudio Panatta
32.		[7]	Jose-Luis Clerc	6-1 6-4 6-2
									Chris Lewis
33.			Nduka Odizor						6-7 6-4 7-6 6-7 8-6
				Nduka Odizor
34.		[4]	Guillermo Vilas	3-6 5-7 7-6 7-5 6-2
					Nduka Odizor
35.		[Q]	Peter Fleming		6-4 4-6 6-4 6-2
				Peter Fleming
36.			Jeremy Bates	7-6 6-3 6-2
						Nduka Odizor
37.			Loic Courteau			3-6 7-6 6-4 3-6 6-3
				Loic Courteau
38.			Magnus Tideman	7-5 6-4 7-5
					Loic Courteau
39.			Andrew Jarrett		6-2 7-5 6-3
				Andrew Jarrett
40.			Bruce Foxworth	4-6 6-2 7-5 6-1
							Chris Lewis
41.		[Q]	Charles Fancutt				6-1 6-3 6-3
				Charles Fancutt
42.			Chris Bradnam	6-4 6-4 7-6
					Mike Bauer
43.			Mike Bauer		6-4 6-4 6-0
				Mike Bauer
44.			Damir Keretic	7-5 7-5 7-5
						Chris Lewis
45.		[Q]	Broderick Dyke			6-4 3-6 7-5 6-7 6-4
				Broderick Dyke
46.			Guy Forget	6-2 6-2 3-6 6-2
					Chris Lewis
47.			Chris Lewis		7-6 6-1 6-3
				Chris Lewis
48.		[9]	Steve Denton	6-4 4-6 7-6 4-6 6-3
								Chris Lewis
49.		[13]	Brian Gottfried					6-7 6-0 6-4 7-6
				Brian Gottfried
50.			Shlomo Glickstein	6-1 6-4 6-4
					Brian Gottfried
51.			Matt Doyle		7-5 4-6 7-6 6-4
				Matt Doyle
52.			Libor Pimek	6-2 6-1 6-1
						Brian Gottfried
53.		[Q]	Tony Giammalva			7-6 6-2 6-2
				Tony Giammalva
54.		[Q]	Jeff Turpin	6-1 7-6 3-6 7-6
					Joao Soares
55.			Joao Soares		7-6 6-7 7-6 6-4
				Joao Soares
56.			Eric Fromm	6-4 6-3 6-4
							Mel Purcell
57.			Stuart Bale				4-6 6-3 6-3 6-2
				Stuart Bale
58.			Matt Mitchell	7-6 6-7 5-7 6-4 12-10
					Mel Purcell
59.			Mel Purcell		7-6 6-4 6-3
				Mel Purcell
60.			Tim Wilkinson	6-2 4-6 6-2 6-1
						Mel Purcell
61.			Andreas Maurer			5-7 6-3 6-2 6-2
				Andreas Maurer
62.		[LL]	Mike Brunnberg	3-6 6-1 6-4 5-7 6-4
					Andreas Maurer
63.			Victor Amaya		6-3 6-4 7-6
				Victor Amaya
64.		[LL]	Bruce Kleege	6-4 6-3 6-4
										John McEnroe
65.		[5]	Mats Wilander							6-2 6-2 6-2
				Mats Wilander
66.			John Fitzgerald	6-4 6-1 4-6 6-7 6-4
					Mats Wilander
67.		[Q]	Tian Viljoen		6-3 6-2 6-1
				Tian Viljoen
68.		[Q]	Rod Frawley	7-6 2-6 7-6 5-7 9-7
						Roscoe Tanner
69.			John Alexander			6-7 7-5 6-3 6-4
				John Alexander
70.			Thomas Hogstedt	6-7 6-3 6-1 7-6
					Roscoe Tanner
71.			Roscoe Tanner		6-2 7-6 4-6 6-3
				Roscoe Tanner
72.			Jan Gunnarsson	6-4 6-3 6-2
							Roscoe Tanner
73.			Robert Van't Hof				6-2 6-3 6-3
				Robert Van't Hof
74.			Chris Johnstone	4-6 6-1 3-6 7-6 6-4
					Robert Van't Hof
75.			Henri Leconte		3-6 6-4 4-6 6-3 6-2
				Henri Leconte
76.		[Q]	Danie Visser	6-3 4-6 6-2 4-6 7-5
						Robert Van't Hof
77.			Nick Saviano			6-3 7-6 6-1
				Nick Saviano
78.			Jonathan Smith	7-5 6-3 6-2
					Johan Kriek
79.		[11]	Johan Kriek		6-4 3-6 5-7 6-3 6-2
				Johan Kriek
80.			Sammy Giammalva Jr.	6-4 6-3 6-2
								Ivan Lendl
81.		[15]	Hank Pfister					7-5 7-6 6-3
				Hank Pfister
82.			Tomas Smid	6-3 6-4 3-6 6-3
					Ricardo Acuna
83.			Ricardo Acuna		3-6 7-6 7-6 4-6 6-4
				Ricardo Acuna
84.			Givaldo Barbosa	6-7 6-4 7-6 6-3
						Pat Cash
85.			Fritz Buehning			6-3 6-4 6-4
				Fritz Buehning
86.			Craig Wittus	6-4 6-4 3-6 6-4
					Pat Cash
87.			Pat Cash		6-3 6-0 6-2
				Pat Cash
88.			Julio Goes	6-0 6-0 6-3
							Ivan Lendl
89.			Craig Miller				6-4 7-6 6-1
				Craig Miller
90.			John Lloyd	6-1 6-7 2-6 6-3 6-1
					Jakob Hlasek
91.		[Q]	Jakob Hlasek		6-4 6-4 6-7 3-6 6-1
				Jakob Hlasek
92.			Stanislav Birner	6-2 6-1 6-3
						Ivan Lendl
93.			Trey Waltke			6-1 6-2 6-7 6-4
				Trey Waltke
94.			Stan Smith	6-4 3-6 2-6 6-3 2-0 rtd.
					Ivan Lendl
95.		[3]	Ivan Lendl		6-4 6-2 6-3
				Ivan Lendl
96.		[Q]	Bernie Mitton	7-6 6-1 6-0
									John McEnroe
97.		[8]	Vitas Gerulaitis						7-6 6-4 6-4
				Vitas Gerulaitis
98.			Ramesh Krishnan	5-7 7-5 7-6 5-7 6-3
					Mark Edmondson
99.			Mark Edmondson		7-6 7-5 7-5
				Mark Edmondson
100.			Vijay Amritraj	6-3 6-4 7-6
						Mike Leach
101.		[Q]	Mike Leach			6-3 3-6 6-4 4-6 6-4
				Mike Leach
102.			Richard Lewis	7-6 2-6 7-6 6-4
					Mike Leach
103.			Paul McNamee		6-4 3-6 7-6 6-7 6-3
				Paul McNamee
104.		[Q]	Eric Korita	6-1 3-6 6-4 6-7 9-7
							Sandy Mayer
105.			Mike De Palmer				6-1 7-6 6-1
				Mike De Palmer
106.		[Q]	Wayne Hampson	7-6 6-3 5-7 6-4
					Mike De Palmer
107.			Stefan Simonsson		6-4 6-4 6-3
				Stefan Simonsson
108.			Patrick Dupre	6-3 7-6 6-4
						Sandy Mayer
109.			Gianni Ocleppo			7-6 6-2 6-1
				Gianni Ocleppo
110.			Morris Strode	6-4 3-6 6-3 3-6 6-2
					Sandy Mayer
111.			Sandy Mayer		7-6 6-2 3-6 6-7 6-3
				Sandy Mayer
112.		[Q]	Scott Davis	6-2 6-4 6-2
								John McEnroe
113.		[14]	Bill Scanlon					6-3 7-5 6-0
				Bill Scanlon
114.			Gilles Moretton	7-6 6-3 7-6
					Bill Scanlon
115.			Chip Hooper		7-6 6-0 7-6
				Chip Hooper
116.			Per Hjertquist	6-2 6-4 6-4
						Bill Scanlon
117.		[Q]	Tim Gullikson			6-4 6-4 6-3
				Tim Gullikson
118.			Tom Cain	6-1 3-0 rtd.
					Tim Gullikson
119.			Peter Elter		5-7 6-1 6-4 6-4
				Peter Elter
120.			Michiel Schapers	6-2 6-2 6-4
							John McEnroe
121.			Drew Gitlin				7-5 7-6 7-6
				Drew Gitlin
122.		[Q]	John Sadri	7-5 6-7 6-1 7-5
					Brad Gilbert
123.			Brad Gilbert		6-7 6-3 7-5 7-5
				Brad Gilbert
124.			Russell Simpson	4-6 6-3 6-3 6-3
						John McEnroe
125.			Florin Segarceanu			6-2 6-2 6-2
				Florin Segarceanu
126.			Jaime Fillol	6-3 6-1 1-6 6-4
					John McEnroe
127.		[2]	John McEnroe		4-6 6-2 6-3 6-3
				John McEnroe
128.			Ben Testerman	6-4 7-6 6-2

(default) 17 queries took 29 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	2
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	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` = '1983' 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` = (505) 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 (3539, 3858, 3938, 3853, 3903, 3798, 3933, 3836, 3796, 5167, 3904, 7018, 4026, 3856, 3772, 3498, 3809, 3889, 3910, 3924, 3657, 3908, 3685, 3641, 3993, 3565, 3911, 3623, 3923, 5155, 3912, 3774, 3888, 3618, 3701, 3984, 3917, 5166, 4844, 3794, 4859, 7680, 3925, 4876, 4030, 3931, 3771, 3880, 3612, 3829, 3875, 3932, 3756, 4913, 3824, 3805, 5539, 3752, 3789, 3746, 4921, 3883, 3655, 3800, 3894, 3862, 7066, 4313, 3515, 3906, 3529, 4011, 3795, 4852, 3913, 3901, 3822, 3864, 3776, 4203, 3762, 3743, 3885, 3813, 3806, 3855, 3899, 3900, 4849, 3646, 3948, 3766, 3672, 3386, 3797, 3696, 3573, 3801, 3706, 3639, 3884, 3741, 3751, 3895, 3877, 4851, 3892, 3624, 3767, 4877, 3550, 3849, 3716, 3787, 3837, 3854, 3703, 3835, 5135, 4037, 3872, 3790, 3897, 3740, 3926, 3437, 3753, 3890) 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` = 505	128	128	2
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 178, 41, 13, 86, 10, 121, 196, 149, 172, 135, 217, 92, 68, 29, 91, 138, 153, 21, 179, 173, 133, 212)	23	23	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 178, 41, 13, 86, 10, 121, 196, 149, 172, 135, 217, 92, 68, 29, 91, 138, 153, 21, 179, 173, 133, 212)	23	23	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (3539, 3858, 3938, 3853, 3903, 3798, 3933, 3836, 3796, 5167, 3904, 7018, 4026, 3856, 3772, 3498, 3809, 3889, 3910, 3924, 3657, 3908, 3685, 3641, 3993, 3565, 3911, 3623, 3923, 5155, 3912, 3774, 3888, 3618, 3701, 3984, 3917, 5166, 4844, 3794, 4859, 7680, 3925, 4876, 4030, 3931, 3771, 3880, 3612, 3829, 3875, 3932, 3756, 4913, 3824, 3805, 5539, 3752, 3789, 3746, 4921, 3883, 3655, 3800, 3894, 3862, 7066, 4313, 3515, 3906, 3529, 4011, 3795, 4852, 3913, 3901, 3822, 3864, 3776, 4203, 3762, 3743, 3885, 3813, 3806, 3855, 3899, 3900, 4849, 3646, 3948, 3766, 3672, 3386, 3797, 3696, 3573, 3801, 3706, 3639, 3884, 3741, 3751, 3895, 3877, 4851, 3892, 3624, 3767, 4877, 3550, 3849, 3716, 3787, 3837, 3854, 3703, 3835, 5135, 4037, 3872, 3790, 3897, 3740, 3926, 3437, 3753, 3890)) AND (`Playercontest`.`contest_id` = 505))	128	128	6
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` = 1983	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 29 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` = '1983' 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` = (505) 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 (3539, 3858, 3938, 3853, 3903, 3798, 3933, 3836, 3796, 5167, 3904, 7018, 4026, 3856, 3772, 3498, 3809, 3889, 3910, 3924, 3657, 3908, 3685, 3641, 3993, 3565, 3911, 3623, 3923, 5155, 3912, 3774, 3888, 3618, 3701, 3984, 3917, 5166, 4844, 3794, 4859, 7680, 3925, 4876, 4030, 3931, 3771, 3880, 3612, 3829, 3875, 3932, 3756, 4913, 3824, 3805, 5539, 3752, 3789, 3746, 4921, 3883, 3655, 3800, 3894, 3862, 7066, 4313, 3515, 3906, 3529, 4011, 3795, 4852, 3913, 3901, 3822, 3864, 3776, 4203, 3762, 3743, 3885, 3813, 3806, 3855, 3899, 3900, 4849, 3646, 3948, 3766, 3672, 3386, 3797, 3696, 3573, 3801, 3706, 3639, 3884, 3741, 3751, 3895, 3877, 4851, 3892, 3624, 3767, 4877, 3550, 3849, 3716, 3787, 3837, 3854, 3703, 3835, 5135, 4037, 3872, 3790, 3897, 3740, 3926, 3437, 3753, 3890) 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` = 505

128

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (3539, 3858, 3938, 3853, 3903, 3798, 3933, 3836, 3796, 5167, 3904, 7018, 4026, 3856, 3772, 3498, 3809, 3889, 3910, 3924, 3657, 3908, 3685, 3641, 3993, 3565, 3911, 3623, 3923, 5155, 3912, 3774, 3888, 3618, 3701, 3984, 3917, 5166, 4844, 3794, 4859, 7680, 3925, 4876, 4030, 3931, 3771, 3880, 3612, 3829, 3875, 3932, 3756, 4913, 3824, 3805, 5539, 3752, 3789, 3746, 4921, 3883, 3655, 3800, 3894, 3862, 7066, 4313, 3515, 3906, 3529, 4011, 3795, 4852, 3913, 3901, 3822, 3864, 3776, 4203, 3762, 3743, 3885, 3813, 3806, 3855, 3899, 3900, 4849, 3646, 3948, 3766, 3672, 3386, 3797, 3696, 3573, 3801, 3706, 3639, 3884, 3741, 3751, 3895, 3877, 4851, 3892, 3624, 3767, 4877, 3550, 3849, 3716, 3787, 3837, 3854, 3703, 3835, 5135, 4037, 3872, 3790, 3897, 3740, 3926, 3437, 3753, 3890)) AND (`Playercontest`.`contest_id` = 505))

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

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)