Wimbledon 1978 Gentlemen's Singles (June 26 - July 8)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Bjorn Borg
				Bjorn Borg
2.			Victor Amaya	8-9 6-1 1-6 6-3 6-3
					Bjorn Borg
3.			Peter McNamara		6-2 6-2 6-4
				Peter McNamara
4.			Christophe Roger-Vasselin	8-6 6-3 5-7 6-3
						Bjorn Borg
5.		[Q]	Jaime Fillol			6-4 6-2 6-8 6-4
				Jaime Fillol
6.			Jan Kodes	6-2 6-1 2-0 rtd.
					Jaime Fillol
7.			Robin Drysdale		6-3 6-3 6-2
				Robin Drysdale
8.			Jiri Hrebec	2-6 2-6 6-4 6-3 6-2
							Bjorn Borg
9.			Ove Bengston				6-2 6-4 8-6
				Ove Bengston
10.			Fred Stolle	6-4 6-4 7-5
					Geoff Masters
11.			Geoff Masters		6-0 6-8 9-8 6-4
				Geoff Masters
12.			Bill Scanlon	7-5 6-8 6-3 6-2
						Geoff Masters
13.			Frew McMillan			6-3 7-5 6-1
				Frew McMillan
14.			Rick Fagel	6-1 6-1 6-2
					Frew McMillan
15.		[12]	Christopher Mottram		9-8 6-4 6-3
				Christopher Mottram
16.		[LL]	Douglas Palm	7-5 6-2 6-2
								Bjorn Borg
17.		[13]	Wojtek Fibak					7-5 6-4 6-3
				Wojtek Fibak
18.			Jose-Luis Clerc	6-3 7-5 7-5
					Wojtek Fibak
19.		[Q]	Johan Kriek		8-6 4-6 6-2 6-4
				Johan Kriek
20.			Tim Wilkinson	6-4 7-5 6-3
						Wojtek Fibak
21.			Ray Ruffels			6-1 4-6 7-5 9-7
				Ray Ruffels
22.			John Paish	6-3 6-4 6-2
					Terry Moor
23.			Terry Moor		7-5 7-5 9-8
				Terry Moor
24.			Marcelo Lara	6-2 6-4 9-8
							Sandy Mayer
25.			Van Winitsky				6-4 6-2 6-8 1-6 7-5
				Van Winitsky
26.		[LL]	Bruce Manson	6-1 6-3 4-6 6-3
					Marty Riessen
27.			Marty Riessen		6-3 6-2 4-6 9-7
				Marty Riessen
28.			Mike Fishbach	6-1 6-2 6-2
						Sandy Mayer
29.		[Q]	Mark Edmondson			8-6 7-5 6-3
				Mark Edmondson
30.			Ray Moore	3-6 2-6 6-4 6-2 6-4
					Sandy Mayer
31.		[8]	Sandy Mayer		6-4 6-2 4-6 6-2
				Sandy Mayer
32.			Tomas Smid	7-5 6-4 6-3
									Bjorn Borg
33.		[4]	Guillermo Vilas						6-4 6-4 6-4
				Guillermo Vilas
34.			Stan Smith	6-4 6-3 6-3
					Guillermo Vilas
35.			John Feaver		6-3 2-6 6-4 6-3
				John Feaver
36.		[Q]	Joel Bailey	6-4 6-4 6-4
						Tom Okker
37.			Tom Okker			6-3 6-4 6-2
				Tom Okker
38.			Onny Parun	6-8 6-3 6-3 6-2
					Tom Okker
39.			Yannick Noah		6-2 6-3 6-2
				Yannick Noah
40.			Ricardo Ycaza	8-9 3-6 6-2 6-1 10-8
							Tom Okker
41.			Antonio Zugarelli				6-1 9-8 6-1
				Antonio Zugarelli
42.		[Q]	Chris Kachel	7-5 4-6 2-6 9-8 6-1
					Tom Leonard
43.			Tom Leonard		6-2 6-4 9-8
				Tom Leonard
44.			Paul McNamee	6-3 6-4 6-3
						Tom Leonard
45.			Brian Fairlie			6-2 4-6 8-6 6-3
				Brian Fairlie
46.			Steve Krulevitz	6-3 6-3 7-5
					Brian Fairlie
47.			Steve Docherty		6-3 6-4 6-3
				Steve Docherty
48.		[15]	Arthur Ashe Jr.	8-9 9-8 6-3 5-7 7-5
								Tom Okker
49.		[9]	Ilie Nastase					7-5 6-1 2-6 6-3
				Ilie Nastase
50.			John Yuill	6-2 6-2 5-7 6-3
					Ilie Nastase
51.			Gianni Ocleppo		6-3 6-4 9-7
				Gianni Ocleppo
52.		[LL]	Stanislav Birner	6-3 4-6 6-4 8-6
						Ilie Nastase
53.		[LL]	Mike Machette			6-4 6-3 1-6 6-3
				Mike Machette
54.			Vladimir Zednik	9-7 4-6 6-3 6-3
					Tom Gullikson
55.			Tom Gullikson		6-4 6-4 6-2
				Tom Gullikson
56.		[Q]	Bob Carmichael	6-3 6-4 8-6
							Ilie Nastase
57.			Peter Fleming				2-6 6-4 6-2 6-3
				Peter Fleming
58.			Jiri Granat	9-8 9-8 6-4
					Fred McNair
59.		[Q]	Fred McNair		9-8 6-8 4-6 8-6 6-3
				Fred McNair
60.			Cliff Letcher	6-3 7-5 6-4
						Roscoe Tanner
61.			Bob Giltinan			6-4 6-2 6-2
				Bob Giltinan
62.			David Lloyd	6-2 6-1 9-8
					Roscoe Tanner
63.		[6]	Roscoe Tanner		6-2 6-2 6-4
				Roscoe Tanner
64.			Ismail El Shafei	8-9 1-6 6-2 9-7 6-2
										Bjorn Borg
65.		[5]	Brian Gottfried							6-2 6-2 6-3
				Brian Gottfried
66.			John Lloyd	6-1 6-8 8-6 6-4
					Brian Gottfried
67.			Brian Teacher		6-2 7-5 6-3
				Brian Teacher
68.			Bob Lutz	6-4 6-4 3-6 6-1
						Brian Gottfried
69.			Allan Stone			6-8 9-7 6-2 6-1
				Allan Stone
70.			Terry Rocavert	6-1 6-4 6-4
					Allan Stone
71.			Bernie Mitton		6-1 2-6 6-8 6-1 10-8
				Bernie Mitton
72.		[Q]	Mark Farrell	6-1 5-7 6-1 6-4
							Brian Gottfried
73.		[Q]	Jan Simbera				6-2 6-4 6-2
				Jan Simbera
74.			Andrew Jarrett	7-5 8-6 3-6 6-3
					Tim Gullikson
75.			Tim Gullikson		6-2 6-3 6-4
				Tim Gullikson
76.			Andrew Pattison	6-4 3-6 6-1 6-0
						Tim Gullikson
77.			Billy Martin			6-3 9-7 7-5
				Billy Martin
78.			Jeff Borowiak	5-7 6-4 6-4 6-4
					Billy Martin
79.		[Q]	Erik Van Dillen		5-7 7-5 6-8 6-4 7-5
				Erik Van Dillen
80.		[11]	John McEnroe	7-5 1-6 8-9 6-4 6-3
								Vitas Gerulaitis
81.		[Q]	John Marks					7-5 4-6 9-7 6-2
				John Marks
82.		[10]	Dick Stockton	6-2 9-8 7-5
					Nick Saviano
83.			Nick Saviano		6-3 6-2 6-3
				Nick Saviano
84.			Chris Bradnam	6-4 6-2 3-6 6-1
						Hank Pfister
85.			Hank Pfister			9-7 8-9 6-2 6-2
				Hank Pfister
86.		[Q]	Alvaro Fillol	6-1 6-1 6-2
					Hank Pfister
87.		[LL]	David Carter		6-3 6-4 9-8
				David Carter
88.			Richard Lewis	8-6 6-4 9-8
							Vitas Gerulaitis
89.			Sherwood Stewart				6-3 3-6 6-2 6-3
				Sherwood Stewart
90.		[Q]	Michael Wayman	6-4 9-8 6-3
					Sherwood Stewart
91.			Rick Fisher		6-4 9-7 9-7
				Rick Fisher
92.			Jean-Francois Caujolle	6-3 6-3 6-1
						Vitas Gerulaitis
93.		[Q]	Jayakumar Royappa			9-8 6-0 6-2
				Jayakumar Royappa
94.			Greg Halder	2-6 6-3 6-2 6-2
					Vitas Gerulaitis
95.		[3]	Vitas Gerulaitis		6-3 7-5 6-2
				Vitas Gerulaitis
96.			Heinz Gunthardt	6-2 6-2 4-6 6-1
									Jimmy Connors
97.		[7]	Raul Ramirez						9-7 6-2 6-1
				Raul Ramirez
98.			Colin Dibley	9-7 9-8 6-3
					Raul Ramirez
99.		[Q]	David Schneider		6-1 6-0 6-2
				David Schneider
100.			Dick Crealy	6-2 6-4 9-8
						Raul Ramirez
101.		[Q]	Rod Frawley			6-4 7-5 6-3
				Rod Frawley
102.			Ion Tiriac	3-6 6-3 6-4 6-4
					Rod Frawley
103.			Eric Deblicker		7-9 6-0 6-0 6-3
				Eric Deblicker
104.			Louk Sanders	6-2 8-9 6-3 3-6 6-3
							Raul Ramirez
105.			Phil Dent				6-2 9-8 6-3
				Phil Dent
106.			Tony Roche	6-4 7-5 4-6 4-6 7-5
					Phil Dent
107.			Vijay Amritraj		3-6 6-3 6-3 4-6 7-5
				Vijay Amritraj
108.			Carlos Kirmayr	6-1 6-3 9-8
						John Newcombe
109.			Ross Case			6-1 1-6 6-4 6-4
				Ross Case
110.			Belus Prajoux	7-5 4-6 7-9 6-1 6-4
					John Newcombe
111.		[16]	John Newcombe		6-4 6-2 9-8
				John Newcombe
112.		[Q]	Dale Collings	4-6 7-5 7-5 6-3
								Jimmy Connors
113.		[14]	John Alexander					6-4 6-4 6-2
				John Alexander
114.			Victor Pecci	7-5 4-6 9-8 8-9 12-10
					John Alexander
115.			Anand Amritraj		5-7 6-3 7-5 6-2
				Anand Amritraj
116.			Jonathan Smith	6-3 6-0 6-4
						John Alexander
117.			Bob Hewitt			8-6 rtd.
				Bob Hewitt
118.			George Hardie	3-6 5-7 6-4 6-3 6-2
					Bob Hewitt
119.			Colin Dowdeswell		6-4 4-6 6-2 6-4
				Colin Dowdeswell
120.			Roger Taylor	5-7 6-3 6-4 4-6 6-2
							Jimmy Connors
121.			Tom Gorman				6-2 6-2 6-4
				Tom Gorman
122.			Chris Lewis	0-6 6-2 4-6 7-5 6-3
					Tom Gorman
123.			Mark Cox		4-6 8-6 8-6 7-5
				Mark Cox
124.			John James	6-4 3-6 6-4 6-4
						Jimmy Connors
125.			Kim Warwick			6-4 8-6 8-9 6-3
				Kim Warwick
126.			Gene Mayer	7-5 0-6 6-0 2-6 6-4
					Jimmy Connors
127.		[2]	Jimmy Connors		6-3 7-5 2-6 6-4
				Jimmy Connors
128.			Russell Simpson	7-5 9-8 6-1

(default) 17 queries took 35 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	2
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	4
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` = '1978' 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` = (500) ORDER BY `Match`.`round_id` ASC, `Match`.`no` ASC	127	127	3
9	SELECT `Player`.`id`, `Player`.`name`, `Player`.`gender`, `Player`.`slug` FROM `zavoihu1_db4tennis`.`players` AS `Player` WHERE `Player`.`id` IN (3647, 3655, 3825, 3836, 3437, 3533, 3994, 3658, 3518, 729, 3560, 3716, 3382, 3698, 3641, 4837, 3685, 3774, 3776, 3746, 3466, 3559, 3715, 3425, 3709, 3662, 3168, 3748, 3706, 3388, 3550, 3743, 3618, 3386, 3640, 3817, 3380, 3517, 3768, 3749, 3648, 3761, 3494, 3751, 3546, 3542, 3675, 3215, 3527, 3678, 3767, 3766, 3545, 3563, 3993, 3531, 3701, 3625, 3554, 3710, 3788, 3611, 3529, 3398, 3612, 3646, 3657, 3436, 817, 3814, 3696, 3679, 5137, 4844, 3703, 3558, 3613, 3498, 3502, 3753, 3739, 3490, 3822, 7680, 3762, 3763, 3791, 3741, 3451, 6738, 3786, 3659, 6737, 3783, 3573, 3765, 3623, 3574, 3705, 808, 4313, 3526, 3714, 5138, 3538, 3349, 3639, 3692, 3571, 3654, 761, 3773, 3515, 3684, 3619, 3864, 738, 3637, 3708, 798, 3446, 3771, 818, 3650, 3666, 3744, 3539, 3740) 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` = 500	128	128	2
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (196, 217, 13, 172, 197, 41, 133, 59, 121, 135, 178, 153, 230, 10, 86, 92, 68, 146, 149, 29, 58, 179, 36)	23	23	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (196, 217, 13, 172, 197, 41, 133, 59, 121, 135, 178, 153, 230, 10, 86, 92, 68, 146, 149, 29, 58, 179, 36)	23	23	5
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (3647, 3655, 3825, 3836, 3437, 3533, 3994, 3658, 3518, 729, 3560, 3716, 3382, 3698, 3641, 4837, 3685, 3774, 3776, 3746, 3466, 3559, 3715, 3425, 3709, 3662, 3168, 3748, 3706, 3388, 3550, 3743, 3618, 3386, 3640, 3817, 3380, 3517, 3768, 3749, 3648, 3761, 3494, 3751, 3546, 3542, 3675, 3215, 3527, 3678, 3767, 3766, 3545, 3563, 3993, 3531, 3701, 3625, 3554, 3710, 3788, 3611, 3529, 3398, 3612, 3646, 3657, 3436, 817, 3814, 3696, 3679, 5137, 4844, 3703, 3558, 3613, 3498, 3502, 3753, 3739, 3490, 3822, 7680, 3762, 3763, 3791, 3741, 3451, 6738, 3786, 3659, 6737, 3783, 3573, 3765, 3623, 3574, 3705, 808, 4313, 3526, 3714, 5138, 3538, 3349, 3639, 3692, 3571, 3654, 761, 3773, 3515, 3684, 3619, 3864, 738, 3637, 3708, 798, 3446, 3771, 818, 3650, 3666, 3744, 3539, 3740)) AND (`Playercontest`.`contest_id` = 500))	128	128	3
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	2
15	SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 1978	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	2
17	SELECT `Tournament`.`slug`, `Tournament`.`name` FROM `zavoihu1_db4tennis`.`tournaments` AS `Tournament` WHERE `Tournament`.`id` IN (1, 2, 3, 4)	4	4	2

(default) 17 queries took 35 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` = '1978' 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` = (500) 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, 3655, 3825, 3836, 3437, 3533, 3994, 3658, 3518, 729, 3560, 3716, 3382, 3698, 3641, 4837, 3685, 3774, 3776, 3746, 3466, 3559, 3715, 3425, 3709, 3662, 3168, 3748, 3706, 3388, 3550, 3743, 3618, 3386, 3640, 3817, 3380, 3517, 3768, 3749, 3648, 3761, 3494, 3751, 3546, 3542, 3675, 3215, 3527, 3678, 3767, 3766, 3545, 3563, 3993, 3531, 3701, 3625, 3554, 3710, 3788, 3611, 3529, 3398, 3612, 3646, 3657, 3436, 817, 3814, 3696, 3679, 5137, 4844, 3703, 3558, 3613, 3498, 3502, 3753, 3739, 3490, 3822, 7680, 3762, 3763, 3791, 3741, 3451, 6738, 3786, 3659, 6737, 3783, 3573, 3765, 3623, 3574, 3705, 808, 4313, 3526, 3714, 5138, 3538, 3349, 3639, 3692, 3571, 3654, 761, 3773, 3515, 3684, 3619, 3864, 738, 3637, 3708, 798, 3446, 3771, 818, 3650, 3666, 3744, 3539, 3740) 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` = 500

128

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (196, 217, 13, 172, 197, 41, 133, 59, 121, 135, 178, 153, 230, 10, 86, 92, 68, 146, 149, 29, 58, 179, 36)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (196, 217, 13, 172, 197, 41, 133, 59, 121, 135, 178, 153, 230, 10, 86, 92, 68, 146, 149, 29, 58, 179, 36)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (3647, 3655, 3825, 3836, 3437, 3533, 3994, 3658, 3518, 729, 3560, 3716, 3382, 3698, 3641, 4837, 3685, 3774, 3776, 3746, 3466, 3559, 3715, 3425, 3709, 3662, 3168, 3748, 3706, 3388, 3550, 3743, 3618, 3386, 3640, 3817, 3380, 3517, 3768, 3749, 3648, 3761, 3494, 3751, 3546, 3542, 3675, 3215, 3527, 3678, 3767, 3766, 3545, 3563, 3993, 3531, 3701, 3625, 3554, 3710, 3788, 3611, 3529, 3398, 3612, 3646, 3657, 3436, 817, 3814, 3696, 3679, 5137, 4844, 3703, 3558, 3613, 3498, 3502, 3753, 3739, 3490, 3822, 7680, 3762, 3763, 3791, 3741, 3451, 6738, 3786, 3659, 6737, 3783, 3573, 3765, 3623, 3574, 3705, 808, 4313, 3526, 3714, 5138, 3538, 3349, 3639, 3692, 3571, 3654, 761, 3773, 3515, 3684, 3619, 3864, 738, 3637, 3708, 798, 3446, 3771, 818, 3650, 3666, 3744, 3539, 3740)) AND (`Playercontest`.`contest_id` = 500))

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

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)