Wimbledon 1980 Gentlemen's Singles (June 23 - July 5)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Bjorn Borg
				Bjorn Borg
2.		[Q]	Ismail El Shafei	6-3 6-4 6-4
					Bjorn Borg
3.			Shlomo Glickstein		6-3 6-1 7-5
				Shlomo Glickstein
4.			Raul Ramirez	4-6 6-2 3-6 7-5 8-6
						Bjorn Borg
5.			Rod Frawley			6-4 6-7 6-1 7-5
				Rod Frawley
6.			Per Hjertquist	6-2 6-1 6-2
					Rod Frawley
7.			Tony Graham		6-7 2-6 6-1 6-2 13-11
				Tony Graham
8.			Howard Schoenfield	6-2 6-4 6-1
							Bjorn Borg
9.		[Q]	Ramesh Krishnan				6-1 7-5 6-2
				Ramesh Krishnan
10.			Bill Scanlon	3-6 6-4 6-4 6-4
					Ramesh Krishnan
11.			Mark Cox		6-7 7-5 7-5 6-1
				Mark Cox
12.			Gilles Moretton	3-6 6-1 6-4 6-4
						Balazs Taroczy
13.			Balazs Taroczy			6-3 7-6 6-2
				Balazs Taroczy
14.			Christofer Delaney	6-3 3-6 6-4 6-2
					Balazs Taroczy
15.			Trey Waltke		6-3 6-2 6-2
				Trey Waltke
16.		[Q]	Wayne Hampson	3-6 6-4 6-4 6-2
								Bjorn Borg
17.		[10]	Ivan Lendl					7-5 6-3 7-5
				Ivan Lendl
18.			Marty Riessen	6-3 4-6 6-2 6-4
					Ivan Lendl
19.			John Sadri		6-3 6-4 6-3
				John Sadri
20.			Billy Martin	6-4 6-2 6-4
						Colin Dibley
21.			Colin Dibley			4-6 6-3 6-4 7-6
				Colin Dibley
22.			Tom Leonard	6-1 6-2 7-6
					Colin Dibley
23.			Geoff Masters		2-6 6-2 7-6 6-7 8-6
				Geoff Masters
24.			Ray Moore	2-6 6-2 6-0 6-2
							Gene Mayer
25.			Corrado Barazzutti				3-6 7-5 4-6 6-1 6-2
				Corrado Barazzutti
26.		[Q]	Scott Davis	5-7 6-4 6-2 6-3
					Adriano Panatta
27.			Adriano Panatta		1-6 6-3 6-4 3-6 6-1
				Adriano Panatta
28.			Erik Van Dillen	3-6 2-6 7-6 7-5 9-7
						Gene Mayer
29.			Andrew Jarrett			6-3 6-3 6-2
				Andrew Jarrett
30.			Chris Mayotte	7-5 6-3 6-7 6-4
					Gene Mayer
31.		[6]	Gene Mayer		6-4 6-4 6-1
				Gene Mayer
32.		[Q]	Chris Johnstone	6-3 4-6 6-1 6-2
									Bjorn Borg
33.		[4]	Vitas Gerulaitis						6-2 4-6 6-2 6-0
				Vitas Gerulaitis
34.			Stefan Simonsson	6-0 6-4 6-2
					Vitas Gerulaitis
35.		[LL]	Sashi Menon		6-7 6-4 7-5 6-2
				Sashi Menon
36.			Robin Drysdale	6-7 4-6 6-0 6-4 6-4
						Vitas Gerulaitis
37.			Ross Case			6-4 4-6 7-5 6-4
				Ross Case
38.			Francisco Gonzalez	7-6 6-4 6-3
					Bruce Manson
39.			Bruce Manson		7-6 7-6 7-5
				Bruce Manson
40.			Tom Gullikson	7-6 6-7 7-6 6-4
							Wojtek Fibak
41.		[LL]	John Austin				3-6 4-6 6-3 6-3 8-6
				John Austin
42.			Andres Gomez	6-2 6-1 7-6
					Johan Kriek
43.			Johan Kriek		6-4 6-3 6-1
				Johan Kriek
44.			Fritz Buehning	6-3 7-6 6-2
						Wojtek Fibak
45.			Russell Simpson			6-1 6-4 6-1
				Russell Simpson
46.			Dominique Bedel	6-7 6-4 6-4 7-6
					Wojtek Fibak
47.		[13]	Wojtek Fibak		3-6 6-2 6-3 6-2
				Wojtek Fibak
48.			Mark Edmondson	5-7 6-4 3-6 7-6 10-8
								Brian Gottfried
49.		[15]	Stan Smith					6-4 7-6 6-2
				Stan Smith
50.			Andrew Pattison	5-7 6-3 6-3 6-4
					Stan Smith
51.			Peter Feigl		4-6 6-1 7-6 6-1
				Peter Feigl
52.		[LL]	Syd Ball	6-4 1-6 6-3 3-6 6-3
						Brian Gottfried
53.			Brian Gottfried			6-2 6-3 6-2
				Brian Gottfried
54.		[Q]	Chris Kachel	7-5 6-3 6-1
					Brian Gottfried
55.			Chris Lewis		6-3 6-4 6-2
				Chris Lewis
56.		[LL]	Leo Palin	6-4 3-6 7-5 5-7 6-4
							Brian Gottfried
57.			Phil Dent				6-1 6-2 6-2
				Phil Dent
58.			Robert Trogolo	4-6 7-6 3-6 6-3 6-4
					Phil Dent
59.			Bernie Mitton		7-5 6-3 6-3
				Bernie Mitton
60.			Jonathan Smith	6-2 6-3 3-6 6-3
						Phil Dent
61.			Jan Kodes			3-6 6-2 6-3 6-1
				Jan Kodes
62.			Tony Giammalva	7-6 5-7 6-3 6-3
					Victor Pecci
63.		[8]	Victor Pecci		6-3 6-4 6-4
				Victor Pecci
64.			Matt Mitchell	7-5 6-1 7-6
										Bjorn Borg
65.		[5]	Roscoe Tanner							1-6 7-5 6-3 6-7(16) 8-6
				Roscoe Tanner
66.			Jiri Hrebec	6-2 6-0 6-4
					Roscoe Tanner
67.		[Q]	John Fitzgerald		6-1 3-6 6-3 7-6
				John Fitzgerald
68.			Thomaz Koch	7-6 6-7 6-2 6-3
						Roscoe Tanner
69.			Paul McNamee			7-6 6-4 6-4
				Paul McNamee
70.		[Q]	Peter Doohan	6-2 7-6 6-3
					Paul McNamee
71.			Robert Van't Hof		6-1 6-1 6-3
				Robert Van't Hof
72.			Ferdi Taygan	7-6 2-6 7-5 6-4
							Roscoe Tanner
73.			Christopher Mottram				7-6 3-6 6-3 6-4
				Christopher Mottram
74.			John Lloyd	6-4 6-2 6-2
					Nick Saviano
75.			Nick Saviano		6-7 7-6 6-3 4-6 13-11
				Nick Saviano
76.		[Q]	Eddie Edwards	6-4 6-4 6-2
						Nick Saviano
77.			Cliff Drysdale			7-6 1-6 4-6 7-5 11-9
				Cliff Drysdale
78.			Byron Bertram	6-2 3-6 3-6 7-6 6-4
					Patrick Dupre
79.		[9]	Patrick Dupre		6-2 6-3 6-0
				Patrick Dupre
80.			Vincent Van Patten	6-4 3-6 6-1 6-4
								Jimmy Connors
81.			Hank Pfister					1-6 6-2 4-6 6-2 6-2
				Hank Pfister
82.		[14]	Victor Amaya	3-6 6-4 6-0 3-6 6-3
					Hank Pfister
83.			Bob Lutz		6-2 6-3 6-1
				Bob Lutz
84.		[Q]	George Hardie	7-6 6-7 6-1 7-5
						Hank Pfister
85.			Tim Gullikson			4-6 6-3 7-5 1-6 6-2
				Tim Gullikson
86.			Belus Prajoux	7-5 6-3 6-1
					Tim Gullikson
87.			Kim Warwick		3-6 6-3 6-2 7-6
				Kim Warwick
88.			Bernard Boileau	4-6 6-1 6-3 6-3
							Jimmy Connors
89.			Heinz Gunthardt				6-4 6-7 6-1 7-6
				Heinz Gunthardt
90.		[Q]	John Yuill	7-5 6-3 7-6
					Heinz Gunthardt
91.			Warren Maher		7-5 6-4 6-2
				Warren Maher
92.			Peter McNamara	2-6 6-1 6-3 6-2
						Jimmy Connors
93.			Sherwood Stewart			6-7 6-2 6-1 6-4
				Sherwood Stewart
94.			Peter Rennert	7-6 6-7 6-4 6-3
					Jimmy Connors
95.		[3]	Jimmy Connors		6-0 6-2 6-1
				Jimmy Connors
96.			Richard Lewis	6-0 6-3 6-1
									John McEnroe
97.		[7]	Peter Fleming						6-3 3-6 6-3 6-4
				Peter Fleming
98.			Colin Dowdeswell	7-5 6-3 6-4
					Peter Fleming
99.			Stanislav Birner		4-6 6-3 6-4 6-2
				Stanislav Birner
100.			Tom Gorman	6-4 7-5 6-4
						Peter Fleming
101.			Ilie Nastase			6-4 3-6 7-6 7-6
				Ilie Nastase
102.			John Feaver	6-2 6-3 7-6
					Ilie Nastase
103.			Dick Stockton		4-6 6-2 5-7 6-2 6-2
				Dick Stockton
104.			Sandy Mayer	7-6 3-6 4-6 6-3 6-2
							Peter Fleming
105.			Pascal Portes				6-3 6-2 6-7 7-6
				Pascal Portes
106.		[LL]	Van Winitsky	6-4 6-4 3-6 6-7 9-7
					Onny Parun
107.		[Q]	Onny Parun		7-5 6-3 6-4
				Onny Parun
108.			Carlos Gattiker	6-1 5-7 6-1 6-1
						Onny Parun
109.			Bernard Fritz			3-6 7-6 6-4 6-3
				Bernard Fritz
110.		[Q]	John Paish	6-4 7-6 7-6
					Jose-Luis Clerc
111.		[16]	Jose-Luis Clerc		6-4 7-6 3-6 6-0
				Jose-Luis Clerc
112.			Vijay Amritraj	1-6 3-6 7-5 7-5 6-4
								John McEnroe
113.		[Q]	Kevin Curren					6-3 6-2 6-2
				Kevin Curren
114.		[Q]	Matt Doyle	6-4 6-3 6-7 6-2
					Kevin Curren
115.			Brad Drewett		7-6 6-7 6-4 6-4
				Brad Drewett
116.		[LL]	David Schneider	4-6 6-3 6-3 6-7 6-3
						Kevin Curren
117.			Steve Krulevitz			5-7 6-2 6-3 6-1
				Steve Krulevitz
118.			Miguel Mir-Rodon	6-2 6-3 6-0
					Brian Teacher
119.			Brian Teacher		4-6 6-2 6-1 6-1
				Brian Teacher
120.			Tim Wilkinson	6-4 7-6 7-5
							John McEnroe
121.			Tom Okker				7-5 7-6 7-6
				Tom Okker
122.			John James	6-3 7-6 6-3
					Tom Okker
123.			Patrice Dominguez		7-6 7-6 1-6 2-6 6-3
				Patrice Dominguez
124.		[Q]	Sean Sorensen	6-2 7-6 6-1
						John McEnroe
125.			Terry Rocavert			6-0 7-6 6-1
				Terry Rocavert
126.			Roger Taylor	6-1 3-6 2-6 6-4 6-3
					John McEnroe
127.		[2]	John McEnroe		4-6 7-5 6-7 7-6 6-3
				John McEnroe
128.			Butch Walts	6-3 6-3 6-0

(default) 17 queries took 20 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` = '1980' LIMIT 1	1	1	1
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` = (502) 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 (3647, 3398, 3829, 3623, 4313, 3854, 3846, 3688, 3801, 3716, 818, 3787, 3661, 3868, 3672, 4851, 3797, 3168, 3790, 3613, 3574, 3494, 3560, 3388, 3651, 3849, 3614, 3502, 4844, 3841, 3744, 4852, 3573, 3892, 3565, 3994, 3571, 3758, 3662, 3993, 3810, 3802, 3776, 3806, 3740, 3792, 3685, 3706, 3386, 3558, 3778, 3665, 3612, 3761, 3771, 3742, 3538, 3799, 3696, 3864, 3533, 3756, 3684, 3752, 3529, 3658, 3862, 3344, 3751, 3944, 3795, 3674, 3641, 3646, 3822, 3858, 3305, 3821, 3624, 3798, 3762, 3655, 3436, 3637, 3703, 3654, 3666, 5158, 3765, 3678, 3830, 3825, 3451, 3793, 3539, 3741, 3701, 3708, 3766, 3446, 3527, 3640, 3490, 3550, 3770, 3709, 3517, 5145, 3867, 3559, 3774, 3639, 3772, 3875, 3796, 3705, 3542, 5126, 3657, 3746, 3380, 3650, 3632, 7071, 3814, 798, 3753, 3713) 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` = 502	128	128	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 178, 196, 172, 133, 59, 29, 135, 153, 217, 13, 207, 86, 92, 121, 68, 41, 84, 146, 149, 67, 179, 10, 14, 58, 91, 173, 21, 90)	29	29	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 178, 196, 172, 133, 59, 29, 135, 153, 217, 13, 207, 86, 92, 121, 68, 41, 84, 146, 149, 67, 179, 10, 14, 58, 91, 173, 21, 90)	29	29	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (3647, 3398, 3829, 3623, 4313, 3854, 3846, 3688, 3801, 3716, 818, 3787, 3661, 3868, 3672, 4851, 3797, 3168, 3790, 3613, 3574, 3494, 3560, 3388, 3651, 3849, 3614, 3502, 4844, 3841, 3744, 4852, 3573, 3892, 3565, 3994, 3571, 3758, 3662, 3993, 3810, 3802, 3776, 3806, 3740, 3792, 3685, 3706, 3386, 3558, 3778, 3665, 3612, 3761, 3771, 3742, 3538, 3799, 3696, 3864, 3533, 3756, 3684, 3752, 3529, 3658, 3862, 3344, 3751, 3944, 3795, 3674, 3641, 3646, 3822, 3858, 3305, 3821, 3624, 3798, 3762, 3655, 3436, 3637, 3703, 3654, 3666, 5158, 3765, 3678, 3830, 3825, 3451, 3793, 3539, 3741, 3701, 3708, 3766, 3446, 3527, 3640, 3490, 3550, 3770, 3709, 3517, 5145, 3867, 3559, 3774, 3639, 3772, 3875, 3796, 3705, 3542, 5126, 3657, 3746, 3380, 3650, 3632, 7071, 3814, 798, 3753, 3713)) AND (`Playercontest`.`contest_id` = 502))	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` = 1980	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	0

(default) 17 queries took 20 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` = '1980' 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` = (502) 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 (3647, 3398, 3829, 3623, 4313, 3854, 3846, 3688, 3801, 3716, 818, 3787, 3661, 3868, 3672, 4851, 3797, 3168, 3790, 3613, 3574, 3494, 3560, 3388, 3651, 3849, 3614, 3502, 4844, 3841, 3744, 4852, 3573, 3892, 3565, 3994, 3571, 3758, 3662, 3993, 3810, 3802, 3776, 3806, 3740, 3792, 3685, 3706, 3386, 3558, 3778, 3665, 3612, 3761, 3771, 3742, 3538, 3799, 3696, 3864, 3533, 3756, 3684, 3752, 3529, 3658, 3862, 3344, 3751, 3944, 3795, 3674, 3641, 3646, 3822, 3858, 3305, 3821, 3624, 3798, 3762, 3655, 3436, 3637, 3703, 3654, 3666, 5158, 3765, 3678, 3830, 3825, 3451, 3793, 3539, 3741, 3701, 3708, 3766, 3446, 3527, 3640, 3490, 3550, 3770, 3709, 3517, 5145, 3867, 3559, 3774, 3639, 3772, 3875, 3796, 3705, 3542, 5126, 3657, 3746, 3380, 3650, 3632, 7071, 3814, 798, 3753, 3713) 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` = 502

128

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 178, 196, 172, 133, 59, 29, 135, 153, 217, 13, 207, 86, 92, 121, 68, 41, 84, 146, 149, 67, 179, 10, 14, 58, 91, 173, 21, 90)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 178, 196, 172, 133, 59, 29, 135, 153, 217, 13, 207, 86, 92, 121, 68, 41, 84, 146, 149, 67, 179, 10, 14, 58, 91, 173, 21, 90)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (3647, 3398, 3829, 3623, 4313, 3854, 3846, 3688, 3801, 3716, 818, 3787, 3661, 3868, 3672, 4851, 3797, 3168, 3790, 3613, 3574, 3494, 3560, 3388, 3651, 3849, 3614, 3502, 4844, 3841, 3744, 4852, 3573, 3892, 3565, 3994, 3571, 3758, 3662, 3993, 3810, 3802, 3776, 3806, 3740, 3792, 3685, 3706, 3386, 3558, 3778, 3665, 3612, 3761, 3771, 3742, 3538, 3799, 3696, 3864, 3533, 3756, 3684, 3752, 3529, 3658, 3862, 3344, 3751, 3944, 3795, 3674, 3641, 3646, 3822, 3858, 3305, 3821, 3624, 3798, 3762, 3655, 3436, 3637, 3703, 3654, 3666, 5158, 3765, 3678, 3830, 3825, 3451, 3793, 3539, 3741, 3701, 3708, 3766, 3446, 3527, 3640, 3490, 3550, 3770, 3709, 3517, 5145, 3867, 3559, 3774, 3639, 3772, 3875, 3796, 3705, 3542, 5126, 3657, 3746, 3380, 3650, 3632, 7071, 3814, 798, 3753, 3713)) AND (`Playercontest`.`contest_id` = 502))

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

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)