Australian Open 1992 Men's Singles (January 13 - January 27)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Stefan Edberg
				Stefan Edberg
2.		[Q]	Jeremy Bates	6-4 6-2 6-4
					Stefan Edberg
3.			Claudio Mezzadri		6-1 6-2 6-1
				Claudio Mezzadri
4.		[WC]	Jamie Morgan	4-6 4-6 6-3 6-4 6-2
						Stefan Edberg
5.			Jan Siemerink			7-5 6-1 6-4
				Jan Siemerink
6.		[Q]	Jared Palmer	6-4 4-6 6-3 4-6 6-2
					John Fitzgerald
7.		[WC]	John Fitzgerald		7-5 6-1 7-6(4)
				John Fitzgerald
8.			Mark Koevermans	7-6(6) 6-4 7-6(4)
							Stefan Edberg
9.			Gilad Bloom				6-1 7-5 6-2
				Gilad Bloom
10.			Marcos Gorriz-Bonhora	6-7(11) 6-2 6-0 6-1
					Andrei Chesnokov
11.			Andrei Chesnokov		4-6 6-3 6-4 6-4
				Andrei Chesnokov
12.			Frederic Fontang	6-3 7-6(4) 6-1
						Andrei Chesnokov
13.			Patrick McEnroe			6-4 1-6 1-6 6-1 6-3
				Patrick McEnroe
14.			Massimo Cierro	6-3 6-4 6-4
					Patrick McEnroe
15.			Jeff Tarango		6-1 4-6 6-4 6-3
				Jeff Tarango
16.		[9]	Petr Korda	4-6 4-6 6-3 6-3 6-3
								Stefan Edberg
17.		[12]	Derrick Rostagno					4-6 7-5 6-1 6-7(5) 6-1
				Derrick Rostagno
18.		[Q]	Carl Limberger	2-6 6-3 1-6 6-3 6-4
					Lars-Anders Wahlgren
19.		[Q]	Lars-Anders Wahlgren		6-1 7-5 7-6(3)
				Lars-Anders Wahlgren
20.			Brad Gilbert	1-6 6-2 6-1 3-6 6-2
						Omar Camporese
21.		[Q]	Simon Youl			6-4 6-2 7-6(15)
				Simon Youl
22.			Guillaume Raoux	6-2 6-2 6-2
					Omar Camporese
23.			Omar Camporese		6-3 6-4 7-6(4)
				Omar Camporese
24.			Thomas Hogstedt	3-6 6-2 6-2 2-6 6-1
							Ivan Lendl
25.			Cedric Pioline				7-6(4) 6-1 6-3
				Cedric Pioline
26.			Javier Frana	7-6(4) 1-6 6-1 6-1
					Markus Zoecke
27.			Markus Zoecke		3-6 6-2 7-6(5) 7-6(5)
				Markus Zoecke
28.			Grant Connell	7-6(7) 6-3 6-3
						Ivan Lendl
29.		[WC]	Roger Rasheed			6-4 6-4 7-6(6)
				Roger Rasheed
30.			Danilo Marcelino	6-4 2-6 4-6 6-2 6-4
					Ivan Lendl
31.		[5]	Ivan Lendl		6-3 6-2 6-3
				Ivan Lendl
32.			Richard Fromberg	6-4 6-2 6-2
									Stefan Edberg
33.		[3]	Boris Becker						7-6(2) 6-1 6-2
				Boris Becker
34.			Jan Gunnarsson	6-1 6-4 6-2
					Boris Becker
35.			Gianluca Pozzi		7-5 7-5 6-2
				Gianluca Pozzi
36.			Bryan Shelton	4-6 7-6(4) 2-6 6-2 6-2
						John McEnroe
37.			John McEnroe			6-4 6-3 7-5
				John McEnroe
38.		[Q]	Broderick Dyke	6-2 6-0 6-1
					John McEnroe
39.			Andrei Cherkasov		7-5 3-6 6-4 6-3
				Andrei Cherkasov
40.			Patrick Kuehnen	6-7(7) 7-5 6-0 6-1
							John McEnroe
41.			Michiel Schapers				7-5 7-6(4) 4-6 2-6 8-6
				Michiel Schapers
42.			Thierry Champion	4-6 6-1 6-2 6-4
					Michiel Schapers
43.			Jacco Eltingh		1-6 6-4 5-7 6-1 6-3
				Jacco Eltingh
44.			Karsten Braasch	2-6 5-7 6-3 6-4 7-5
						Emilio Sanchez
45.		[WC]	Pat Cash			6-3 6-4 7-6(6)
				Pat Cash
46.			Horst Skoff	6-1 7-5 7-6(6)
					Emilio Sanchez
47.		[13]	Emilio Sanchez		7-6(5) 6-2 6-7(9) 3-6 6-1
				Emilio Sanchez
48.			Pablo Arraya	6-3 6-2 6-7(3) 6-3
								Wayne Ferreira
49.		[15]	David Wheaton					6-4 6-4 6-4
				David Wheaton
50.		[WC]	Jason Cask	6-4 6-0 6-0
					David Wheaton
51.			Nicklas Kulti		6-3 5-7 6-4 2-6 8-6
				Nicklas Kulti
52.			Todd Witsken	6-0 6-1 6-7(3) 6-3
						David Wheaton
53.			Paolo Cane			6-4 6-3 6-3
				Paolo Cane
54.			Byron Black	6-4 6-4 6-1
					Lars Koslowski
55.			Lars Koslowski		6-2 1-6 7-6(1) 6-2
				Lars Koslowski
56.			Jimmy Arias	6-1 7-6(2) 6-0
							Wayne Ferreira
57.			Francisco Clavet				6-7(3) 6-4 6-2 6-2
				Francisco Clavet
58.			Martin Strelba	6-2 7-6(3) 2-6 7-5
					Mark Woodforde
59.			Mark Woodforde		6-7(4) 6-4 6-1 3-6 7-5
				Mark Woodforde
60.			Jaime Yzaga	6-4 7-6(5) 6-1
						Wayne Ferreira
61.			Wayne Ferreira			4-6 6-3 6-2 6-2
				Wayne Ferreira
62.		[Q]	Leonardo Lavalle	6-2 6-4 1-6 6-3
					Wayne Ferreira
63.		[8]	Karel Novacek		3-6 6-3 7-6(6) 7-6(7)
				Karel Novacek
64.		[Q]	David Pate	2-6 7-6(10) 6-4 6-1
										Jim Courier
65.		[7]	Guy Forget							6-3 3-6 6-4 6-2
				Guy Forget
66.		[WC]	Henri Leconte	2-6 6-4 6-7(5) 6-4 6-3
					Christian Bergstrom
67.			Christian Bergstrom		7-6(5) 2-6 6-3 6-4
				Christian Bergstrom
68.			Lars Jonsson	7-6(7) 7-6(6) 6-3
						Christian Bergstrom
69.		[WC]	Sandon Stolle			6-2 6-3 4-6 6-2
				Sandon Stolle
70.			Jaime Oncins	3-6 6-2 7-5 4-6 6-2
					Bret Garnett
71.		[Q]	Bret Garnett		4-6 1-6 7-5 6-2 6-2
				Bret Garnett
72.		[WC]	Grant Doyle	6-4 6-2 6-4
							Richard Krajicek
73.			Jim Grabb				7-5 7-6(6) 6-3
				Jim Grabb
74.		[Q]	Patrick Rafter	3-6 6-0 7-6(3) 6-2
					Richard Krajicek
75.			Richard Krajicek		6-2 7-6(2) 6-1
				Richard Krajicek
76.			Christian Saceanu	6-3 6-3 6-3
						Richard Krajicek
77.			Cristiano Caratti			6-4 6-1 5-7 1-6 6-3
				Cristiano Caratti
78.			Chuck Adams	6-7(3) 6-3 6-3 6-0
					Michael Chang
79.		[14]	Michael Chang		6-3 3-6 6-4 6-4
				Michael Chang
80.			Fernando Roese	6-2 6-3 6-0
								Richard Krajicek
81.		[16]	Goran Prpic					5-7 7-6(2) 6-7(1) 6-4 6-4
				Goran Prpic
82.		[Q]	Glenn Layendecker	6-3 6-4 7-6(4)
					MaliVai Washington
83.			MaliVai Washington		6-2 6-4 6-3
				MaliVai Washington
84.		[Q]	Grant Stafford	6-4 6-2 6-1
						Wally Masur
85.			Wally Masur			6-3 6-3 6-4
				Wally Masur
86.			Marian Vajda	4-6 6-4 4-6 6-2 6-2
					Wally Masur
87.			Stefano Pescosolido		7-6(3) 6-0 6-4
				Stefano Pescosolido
88.		[Q]	Daniel Nestor	6-4 6-4 7-5
							Michael Stich
89.			Olivier Delaitre				3-6 6-4 7-6(5) 6-4
				Olivier Delaitre
90.			Cristian Miniussi	6-7(5) 6-4 6-3 6-2
					Martin Jaite
91.			Martin Jaite		3-6 6-0 1-0 rtd.
				Martin Jaite
92.			Christo Van Rensburg	3-6 7-5 6-1 3-6 8-6
						Michael Stich
93.			Jonas Svensson			6-0 2-6 7-5 6-2
				Jonas Svensson
94.			Shuzo Matsuoka	6-0 7-5 6-3
					Michael Stich
95.		[4]	Michael Stich		6-4 6-1 1-6 6-4
				Michael Stich
96.			Javier Sanchez	7-5 6-1 4-6 6-3
									Jim Courier
97.			Amos Mansdorf						w/o
				Amos Mansdorf
98.		[LL]	Peter Lundgren	6-4 3-6 6-3 6-4
					Amos Mansdorf
99.			Arnaud Boetsch		6-1 7-5 6-0
				Arnaud Boetsch
100.			Diego Nargiso	6-3 6-3 6-4
						Amos Mansdorf
101.			Dimitri Poliakov			6-1 6-4 6-3
				Dimitri Poliakov
102.			Claudio Pistolesi	6-3 3-6 4-6 6-3 6-3
					Richey Reneberg
103.			Richey Reneberg		6-3 3-6 6-7(2) 6-4 10-8
				Richey Reneberg
104.			Bart Wuyts	6-2 6-4 7-5
							Amos Mansdorf
105.			Patrick Baur				6-2 4-6 1-6 7-6(4) 4-1 rtd.
				Patrick Baur
106.		[Q]	Niclas Kroon	6-3 6-4 6-7(3) 6-1
					Alexander Volkov
107.			Alexander Volkov		6-4 6-4 6-2
				Alexander Volkov
108.			Todd Woodbridge	6-3 6-2 6-1
						Aaron Krickstein
109.			Aaron Krickstein			6-4 5-7 6-7(2) 6-1 8-6
				Aaron Krickstein
110.			Anders Jarryd	6-3 6-7(7) 6-2 6-3
					Aaron Krickstein
111.		[10]	Goran Ivanisevic		6-2 7-5 6-1
				Goran Ivanisevic
112.			Jason Stoltenberg	7-6(12) 6-3 6-4
								Jim Courier
113.		[11]	Magnus Gustafsson					6-3 6-2 6-2
				Magnus Gustafsson
114.			Gary Muller	6-4 6-3 6-3
					Marc Rosset
115.			Marc Rosset		6-3 7-5 4-6 3-6 6-3
				Marc Rosset
116.			Horacio De La Pena	6-1 6-2 6-1
						Marc Rosset
117.		[Q]	Aki Rahunen			6-4 6-4 6-3
				Aki Rahunen
118.			Andres Gomez	4-6 3-6 6-4 6-3 6-4
					Carl-Uwe Steeb
119.			Carl-Uwe Steeb		6-4 6-2 7-5
				Carl-Uwe Steeb
120.			Renzo Furlan	6-4 6-2 6-2
							Jim Courier
121.			Thomas Muster				6-3 6-1 6-3
				Thomas Muster
122.			Jean-Philippe Fleurian	7-6(2) 6-1 7-5
					Thomas Muster
123.			Paul Haarhuis		6-4 6-4 7-6(3)
				Paul Haarhuis
124.			Jakob Hlasek	6-0 2-6 2-6 6-4 6-2
						Jim Courier
125.		[Q]	Thomas Enqvist			6-1 6-4 6-2
				Thomas Enqvist
126.			Magnus Larsson	7-5 7-6(6) 7-5
					Jim Courier
127.		[2]	Jim Courier		2-6 6-3 6-1 6-4
				Jim Courier
128.			Rodolphe Gilbert	6-4 7-6(4) 6-3

(default) 17 queries took 32 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` = 'australian-open' 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` = (1)	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` = (1)	1	1	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` = (1)	1	1	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` = 'australian-open' 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` = (1) ORDER BY `Contest`.`year` ASC	112	112	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` = 1 AND `Contest`.`category_id` = 1 AND `Contest`.`slug` = '1992' 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` = (276) ORDER BY `Match`.`round_id` ASC, `Match`.`no` ASC	127	127	9
9	SELECT `Player`.`id`, `Player`.`name`, `Player`.`gender`, `Player`.`slug` FROM `zavoihu1_db4tennis`.`players` AS `Player` WHERE `Player`.`id` IN (3933, 3984, 3941, 5619, 4166, 4065, 3862, 4110, 4076, 4178, 4054, 5188, 4148, 3978, 4066, 4075, 3980, 4052, 5184, 3897, 4093, 4154, 4112, 3906, 4163, 4087, 4192, 4074, 5543, 5604, 3797, 4131, 3968, 4011, 4043, 4105, 3753, 4030, 4121, 4085, 4037, 4018, 4169, 4201, 3899, 4014, 4017, 3921, 4061, 5656, 4156, 4032, 4051, 4337, 5658, 3828, 4155, 4147, 4022, 3975, 4162, 3990, 4004, 3893, 3931, 3913, 4029, 4133, 4189, 4170, 5624, 5661, 3983, 5663, 4176, 4050, 4146, 4100, 4045, 5665, 4174, 3951, 4101, 4151, 3938, 3965, 4164, 5667, 4117, 4190, 3991, 3989, 4000, 4094, 4098, 4053, 3962, 3986, 4153, 4083, 4167, 4033, 4040, 4159, 4172, 4084, 4062, 4123, 3934, 3924, 4108, 4067, 4099, 3985, 4143, 3972, 4140, 3802, 4114, 4187, 4008, 4035, 4118, 3948, 5671, 4186, 4081, 4171) 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` = 276	128	128	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 217, 58, 13, 178, 68, 147, 179, 91, 72, 10, 92, 196, 172, 121, 14, 173, 133, 251, 36, 94, 50, 67, 21, 194, 29, 207)	27	27	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 217, 58, 13, 178, 68, 147, 179, 91, 72, 10, 92, 196, 172, 121, 14, 173, 133, 251, 36, 94, 50, 67, 21, 194, 29, 207)	27	27	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (3933, 3984, 3941, 5619, 4166, 4065, 3862, 4110, 4076, 4178, 4054, 5188, 4148, 3978, 4066, 4075, 3980, 4052, 5184, 3897, 4093, 4154, 4112, 3906, 4163, 4087, 4192, 4074, 5543, 5604, 3797, 4131, 3968, 4011, 4043, 4105, 3753, 4030, 4121, 4085, 4037, 4018, 4169, 4201, 3899, 4014, 4017, 3921, 4061, 5656, 4156, 4032, 4051, 4337, 5658, 3828, 4155, 4147, 4022, 3975, 4162, 3990, 4004, 3893, 3931, 3913, 4029, 4133, 4189, 4170, 5624, 5661, 3983, 5663, 4176, 4050, 4146, 4100, 4045, 5665, 4174, 3951, 4101, 4151, 3938, 3965, 4164, 5667, 4117, 4190, 3991, 3989, 4000, 4094, 4098, 4053, 3962, 3986, 4153, 4083, 4167, 4033, 4040, 4159, 4172, 4084, 4062, 4123, 3934, 3924, 4108, 4067, 4099, 3985, 4143, 3972, 4140, 3802, 4114, 4187, 4008, 4035, 4118, 3948, 5671, 4186, 4081, 4171)) AND (`Playercontest`.`contest_id` = 276))	128	128	6
14	SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 1 ORDER BY `Contest`.`date_from` ASC	112	112	1
15	SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 1992	20	20	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, 7, 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 32 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` = 'australian-open' 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` = (1)

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` = (1)

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` = 'australian-open' AND `Category`.`slug` = 'men-singles' LIMIT 1

112

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` = 1 AND `Contest`.`category_id` = 1 AND `Contest`.`slug` = '1992' 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` = (276) 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 (3933, 3984, 3941, 5619, 4166, 4065, 3862, 4110, 4076, 4178, 4054, 5188, 4148, 3978, 4066, 4075, 3980, 4052, 5184, 3897, 4093, 4154, 4112, 3906, 4163, 4087, 4192, 4074, 5543, 5604, 3797, 4131, 3968, 4011, 4043, 4105, 3753, 4030, 4121, 4085, 4037, 4018, 4169, 4201, 3899, 4014, 4017, 3921, 4061, 5656, 4156, 4032, 4051, 4337, 5658, 3828, 4155, 4147, 4022, 3975, 4162, 3990, 4004, 3893, 3931, 3913, 4029, 4133, 4189, 4170, 5624, 5661, 3983, 5663, 4176, 4050, 4146, 4100, 4045, 5665, 4174, 3951, 4101, 4151, 3938, 3965, 4164, 5667, 4117, 4190, 3991, 3989, 4000, 4094, 4098, 4053, 3962, 3986, 4153, 4083, 4167, 4033, 4040, 4159, 4172, 4084, 4062, 4123, 3934, 3924, 4108, 4067, 4099, 3985, 4143, 3972, 4140, 3802, 4114, 4187, 4008, 4035, 4118, 3948, 5671, 4186, 4081, 4171) 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` = 276

128

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 217, 58, 13, 178, 68, 147, 179, 91, 72, 10, 92, 196, 172, 121, 14, 173, 133, 251, 36, 94, 50, 67, 21, 194, 29, 207)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 217, 58, 13, 178, 68, 147, 179, 91, 72, 10, 92, 196, 172, 121, 14, 173, 133, 251, 36, 94, 50, 67, 21, 194, 29, 207)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (3933, 3984, 3941, 5619, 4166, 4065, 3862, 4110, 4076, 4178, 4054, 5188, 4148, 3978, 4066, 4075, 3980, 4052, 5184, 3897, 4093, 4154, 4112, 3906, 4163, 4087, 4192, 4074, 5543, 5604, 3797, 4131, 3968, 4011, 4043, 4105, 3753, 4030, 4121, 4085, 4037, 4018, 4169, 4201, 3899, 4014, 4017, 3921, 4061, 5656, 4156, 4032, 4051, 4337, 5658, 3828, 4155, 4147, 4022, 3975, 4162, 3990, 4004, 3893, 3931, 3913, 4029, 4133, 4189, 4170, 5624, 5661, 3983, 5663, 4176, 4050, 4146, 4100, 4045, 5665, 4174, 3951, 4101, 4151, 3938, 3965, 4164, 5667, 4117, 4190, 3991, 3989, 4000, 4094, 4098, 4053, 3962, 3986, 4153, 4083, 4167, 4033, 4040, 4159, 4172, 4084, 4062, 4123, 3934, 3924, 4108, 4067, 4099, 3985, 4143, 3972, 4140, 3802, 4114, 4187, 4008, 4035, 4118, 3948, 5671, 4186, 4081, 4171)) AND (`Playercontest`.`contest_id` = 276))

128

SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 1 ORDER BY `Contest`.`date_from` ASC

112

SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 1992

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