Australian Open 1996 Men's Singles (January 15 - January 28)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Pete Sampras
				Pete Sampras
2.			Richard Fromberg	7-5 6-3 6-2
					Pete Sampras
3.			Michael Joyce		3-6 6-3 6-4 6-4
				Michael Joyce
4.			Kris Goossens	6-4 6-4 6-3
						Mark Philippoussis
5.			Mark Philippoussis			6-4 7-6(9) 7-6(3)
				Mark Philippoussis
6.		[Q]	Nicolas Kiefer	7-6(3) 6-0 6-1
					Mark Philippoussis
7.		[LL]	Eyal Ran		2-6 6-4 6-4 6-2
				Eyal Ran
8.		[Q]	Andrei Cherkasov	6-1 6-3 6-1
							Mark Woodforde
9.			Martin Sinner				6-2 6-2 6-2
				Martin Sinner
10.		[WC]	Allen Belobrajdic	5-7 3-6 6-4 7-5 6-3
					Mark Woodforde
11.			Mark Woodforde		6-4 6-1 6-4
				Mark Woodforde
12.			Shuzo Matsuoka	2-1 rtd.
						Mark Woodforde
13.			Francisco Clavet			4-6 7-6(6) 6-2 6-4
				Francisco Clavet
14.			Emilio Sanchez	6-0 6-3 6-3
					Francisco Clavet
15.			Filip Dewulf		2-6 7-5 6-3 6-2
				Filip Dewulf
16.		[16]	Paul Haarhuis	6-4 6-4 6-4
								Mark Woodforde
17.		[10]	Goran Ivanisevic					6-4 6-4 6-4
				Goran Ivanisevic
18.			Bernd Karbacher	6-4 7-6(9) 6-3
					Goran Ivanisevic
19.		[Q]	Sebastian Lareau		6-4 6-4 6-4
				Sebastian Lareau
20.			Kenneth Carlsen	4-6 4-6 6-3 6-4 7-5
						Renzo Furlan
21.			Albert Costa			6-2 3-6 6-4 6-2
				Albert Costa
22.			Fernando Meligeni	4-6 4-6 7-5 3-0 rtd.
					Renzo Furlan
23.			Renzo Furlan		1-6 7-6(4) 6-1 6-3
				Renzo Furlan
24.			Scott Draper	2-6 6-3 7-6(5) 5-7 9-7
							Thomas Enqvist
25.			David Wheaton				7-5 6-0 6-3
				David Wheaton
26.		[WC]	Jamie Morgan	6-2 6-4 7-5
					Hernan Gumy
27.			Hernan Gumy		6-3 6-7(3) 6-4 7-5
				Hernan Gumy
28.			Karim Alami	4-6 6-2 6-0 6-1
						Thomas Enqvist
29.			Adrian Voinea			6-2 7-6(3) 3-6 6-1
				Adrian Voinea
30.			Lionel Roux	7-6(6) 6-7(2) 3-6 6-1 7-5
					Thomas Enqvist
31.		[7]	Thomas Enqvist		6-4 6-4 6-1
				Thomas Enqvist
32.			Marc-Kevin Goellner	6-3 6-2 6-4
									Boris Becker
33.		[4]	Boris Becker						6-4 6-2 6-0
				Boris Becker
34.			Greg Rusedski	6-4 3-6 4-6 6-3 6-3
					Boris Becker
35.			Thomas Johansson		4-6 3-6 6-2 6-1 6-4
				Thomas Johansson
36.			Jacco Eltingh	6-4 6-3 6-1
						Boris Becker
37.			Byron Black			7-6(5) 6-3 6-3
				Byron Black
38.			Henrik Holm	6-3 6-2 6-4
					Magnus Larsson
39.			Magnus Larsson		6-3 3-6 6-4 6-4
				Magnus Larsson
40.			Nicolas Lapentti	6-7(1) 6-3 7-6(3) 6-3
							Boris Becker
41.		[Q]	Brian MacPhie				1-6 6-4 6-3 6-2
				Brian MacPhie
42.			Jan Apell	7-5 6-4 6-4
					Brett Steven
43.			Brett Steven		6-1 5-7 7-6(6) 6-4
				Brett Steven
44.			Nuno Marques	6-3 7-5 7-5
						Brett Steven
45.		[LL]	Diego Nargiso			6-1 6-4 6-7(3) 6-2
				Diego Nargiso
46.			David Prinosil	6-4 7-6(3) 4-6 2-6 6-3
					Jan Siemerink
47.			Jan Siemerink		1-6 5-7 6-2 7-6(8) 6-1
				Jan Siemerink
48.			Gilbert Schaller	4-6 7-6(4) 7-6(3) 7-5
								Boris Becker
49.		[12]	Arnaud Boetsch					6-4 7-6(9) 6-1
				Arnaud Boetsch
50.			Guy Forget	4-6 7-6(5) 6-3 6-3
					MaliVai Washington
51.			MaliVai Washington		6-4 6-1 3-6 6-1
				MaliVai Washington
52.			Javier Sanchez	6-4 6-2 4-6 6-2
						MaliVai Washington
53.			Patrick Rafter			6-4 6-2 6-3
				Patrick Rafter
54.			Marcelo Rios	6-3 6-4 6-3
					Mauricio Hadad
55.			Mauricio Hadad		7-6(5) 6-4 2-2 rtd.
				Mauricio Hadad
56.			Andrei Chesnokov	4-6 6-4 6-2 6-2
							Yevgeny Kafelnikov
57.		[WC]	Peter Tramacchi				6-3 6-2 6-4
				Peter Tramacchi
58.			Sandor Noszaly	7-6(3) 7-6(3) 6-2
					Michael Tebbutt
59.			Michael Tebbutt		6-3 6-4 7-5
				Michael Tebbutt
60.			Carl-Uwe Steeb	6-3 3-6 6-1 6-4
						Yevgeny Kafelnikov
61.			Alex Corretja			7-5 5-7 6-4 6-2
				Alex Corretja
62.		[LL]	Lars Jonsson	6-3 6-3 6-0
					Yevgeny Kafelnikov
63.		[6]	Yevgeny Kafelnikov		6-1 6-2 6-3
				Yevgeny Kafelnikov
64.			Fabrice Santoro	6-1 6-1 7-5
										Boris Becker
65.		[5]	Michael Chang							6-2 6-4 2-6 6-2
				Michael Chang
66.			David Rikl	6-2 6-1 6-2
					Michael Chang
67.			Jakob Hlasek		6-1 6-3 6-3
				Jakob Hlasek
68.			Dick Norman	6-4 6-1 6-1
						Michael Chang
69.		[WC]	Ben Ellwood			6-2 6-2 7-6(6)
				Ben Ellwood
70.			Olivier Delaitre	6-4 6-2 6-1
					Guillaume Raoux
71.			Guillaume Raoux		6-3 6-4 7-6(5)
				Guillaume Raoux
72.		[Q]	Magnus Norman	6-3 7-6(2) 6-1
							Michael Chang
73.			Stefan Edberg				6-2 6-3 6-4
				Stefan Edberg
74.			Jiri Novak	7-6(6) 7-5 3-6 5-7 6-1
					Jean-Philippe Fleurian
75.		[Q]	Jean-Philippe Fleurian		6-4 2-6 4-6 6-2 6-3
				Jean-Philippe Fleurian
76.			Sjeng Schalken	6-3 4-6 7-6(1) 2-1 rtd.
						Jean-Philippe Fleurian
77.			Frederik Fetterlein			4-6 6-3 2-2 rtd.
				Frederik Fetterlein
78.			Hendrik Dreekmann	6-0 6-2 1-6 3-6 6-4
					Richard Krajicek
79.		[11]	Richard Krajicek		6-2 6-4 6-4
				Richard Krajicek
80.			Jason Stoltenberg	6-1 6-3 6-2
								Michael Chang
81.		[14]	Andriy Medvedev					6-0 6-2 6-4
				Andriy Medvedev
82.			Carlos Moya	6-4 7-5 2-6 7-6(7)
					Patrick McEnroe
83.			Patrick McEnroe		0-6 2-6 6-2 6-3 6-2
				Patrick McEnroe
84.		[Q]	Patrik Fredriksson	3-6 6-2 6-1 7-6(4)
						Mikael Tillstrom
85.			Christian Ruud			1-6 6-4 7-6(5) 6-3
				Christian Ruud
86.		[Q]	Rodolphe Gilbert	4-6 6-4 7-6(8) 5-7 6-1
					Mikael Tillstrom
87.			Mikael Tillstrom		6-3 3-6 6-4 4-6 6-4
				Mikael Tillstrom
88.			Aaron Krickstein	6-4 6-4 2-6 5-7 6-2
							Mikael Tillstrom
89.		[Q]	Nicklas Kulti				7-5 4-6 6-3 6-2
				Nicklas Kulti
90.			Andrea Gaudenzi	5-7 7-6(4) 6-4 6-2
					Nicklas Kulti
91.			Carlos Costa		6-3 6-2 6-2
				Carlos Costa
92.			Alexander Volkov	1-6 6-4 0-6 7-5 6-4
						Thomas Muster
93.			Javier Frana			6-4 7-6(9) 6-4
				Javier Frana
94.		[Q]	Daniel Nestor	6-4 6-4 6-4
					Thomas Muster
95.		[3]	Thomas Muster		6-4 6-4 1-6 7-6(4)
				Thomas Muster
96.		[Q]	Thierry Guardiola	6-3 6-3 6-2
									Michael Chang
97.		[8]	Jim Courier						6-1 6-4 7-6(1)
				Jim Courier
98.			Johan Van Herck	7-5 7-6(1) 6-4
					Jim Courier
99.			Jeff Tarango		7-5 6-7(2) 6-4 6-3
				Jeff Tarango
100.		[WC]	Paul Kilderry	6-2 6-2 6-4
						Jim Courier
101.			Todd Woodbridge			6-3 6-7(2) 7-6(3) 3-6 8-6
				Todd Woodbridge
102.			Oleg Ogorodov	7-5 6-4 6-4
					Todd Woodbridge
103.			Bohdan Ulihrach		6-3 2-6 6-2 6-4
				Bohdan Ulihrach
104.			Stefano Pescosolido	6-4 7-6(8) 1-0 rtd.
							Jim Courier
105.			Chuck Adams				7-5 2-6 4-6 6-4 6-2
				Chuck Adams
106.		[WC]	Todd Larkham	6-4 6-7(4) 6-7(2) 6-3 9-7
					Marcos Ondruska
107.			Marcos Ondruska		7-5 7-6(3) 3-6 6-0
				Marcos Ondruska
108.			Derrick Rostagno	6-7(5) 6-1 6-2 7-5
						Marcos Ondruska
109.			Karol Kucera			6-2 4-6 6-3 6-0
				Karol Kucera
110.		[Q]	David Adams	7-5 6-0 6-0
					Karol Kucera
111.		[9]	Wayne Ferreira		6-1 6-3 6-0
				Wayne Ferreira
112.			Jonathan Stark	6-2 6-1 3-6 3-6 7-5
								Andre Agassi
113.		[15]	Todd Martin					6-7(7) 2-6 6-3 6-4 6-2
				Todd Martin
114.			Daniel Vacek	6-4 6-7(5) 6-3 6-4
					Todd Martin
115.			Richey Reneberg		6-2 7-5 3-6 7-6(5)
				Richey Reneberg
116.			Martin Damm	6-3 6-7(3) 6-3 1-6 6-2
						Jonas Bjorkman
117.			Jonas Bjorkman			6-3 3-6 6-3 2-6 6-4
				Jonas Bjorkman
118.		[WC]	Andrew Ilie	7-5 6-3 6-7(0) 6-7(3) 6-4
					Jonas Bjorkman
119.			Tim Henman		6-1 6-3 6-2
				Tim Henman
120.			Petr Korda	5-7 7-6(4) 6-3 6-4
							Andre Agassi
121.		[Q]	Steve Bryan				4-6 6-2 4-6 6-1 6-2
				Steve Bryan
122.		[Q]	Heath Denman	6-3 6-2 6-4
					Steve Bryan
123.		[WC]	Sandon Stolle		6-3 7-6(7) 6-1
				Sandon Stolle
124.			Jaime Yzaga	6-3 7-5 6-4
						Andre Agassi
125.			Vince Spadea			4-6 6-0 6-2 6-1
				Vince Spadea
126.		[Q]	David Nainkin	6-2 6-0 6-1
					Andre Agassi
127.		[2]	Andre Agassi		6-4 6-2 6-3
				Andre Agassi
128.		[Q]	Gaston Etlis	3-6 7-6(2) 4-6 7-6(5) 6-3

(default) 17 queries took 26 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	2
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	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` = (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` = '1996' 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` = (281) 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 (4095, 4131, 4158, 6174, 5713, 6175, 6176, 4121, 5635, 6177, 4022, 4094, 4155, 4017, 5706, 4118, 4108, 5692, 5709, 5679, 6178, 4188, 4187, 6157, 4061, 5619, 6179, 6162, 6163, 6180, 5671, 4197, 3968, 5705, 5723, 4169, 4337, 4173, 4186, 6181, 5704, 5606, 5686, 4089, 4083, 5696, 4166, 5674, 4153, 3931, 4101, 4053, 5663, 6182, 6183, 4054, 6184, 6185, 5725, 4114, 4191, 4133, 5702, 4129, 4045, 5197, 3948, 6186, 6164, 4117, 4154, 6264, 3933, 6187, 4035, 6188, 6189, 5718, 4176, 4067, 5677, 6190, 4148, 6191, 4194, 4171, 6192, 3934, 4156, 5710, 4179, 4062, 4087, 5667, 4008, 6166, 4081, 6193, 4066, 5729, 4123, 6194, 6195, 4164, 4100, 7345, 4168, 3980, 6168, 6196, 4162, 4199, 4142, 5633, 4040, 4185, 5726, 6159, 6197, 4075, 4111, 5636, 4189, 3975, 6169, 5703, 4001, 6198) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	128	128	3
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` = 281	128	128	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (68, 178, 197, 179, 72, 147, 14, 173, 13, 154, 53, 92, 10, 150, 94, 50, 133, 172, 29, 139, 207, 36, 194, 54, 135, 196, 21, 127, 153, 168, 91, 58, 41, 43, 84, 199)	36	36	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (68, 178, 197, 179, 72, 147, 14, 173, 13, 154, 53, 92, 10, 150, 94, 50, 133, 172, 29, 139, 207, 36, 194, 54, 135, 196, 21, 127, 153, 168, 91, 58, 41, 43, 84, 199)	36	36	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (4095, 4131, 4158, 6174, 5713, 6175, 6176, 4121, 5635, 6177, 4022, 4094, 4155, 4017, 5706, 4118, 4108, 5692, 5709, 5679, 6178, 4188, 4187, 6157, 4061, 5619, 6179, 6162, 6163, 6180, 5671, 4197, 3968, 5705, 5723, 4169, 4337, 4173, 4186, 6181, 5704, 5606, 5686, 4089, 4083, 5696, 4166, 5674, 4153, 3931, 4101, 4053, 5663, 6182, 6183, 4054, 6184, 6185, 5725, 4114, 4191, 4133, 5702, 4129, 4045, 5197, 3948, 6186, 6164, 4117, 4154, 6264, 3933, 6187, 4035, 6188, 6189, 5718, 4176, 4067, 5677, 6190, 4148, 6191, 4194, 4171, 6192, 3934, 4156, 5710, 4179, 4062, 4087, 5667, 4008, 6166, 4081, 6193, 4066, 5729, 4123, 6194, 6195, 4164, 4100, 7345, 4168, 3980, 6168, 6196, 4162, 4199, 4142, 5633, 4040, 4185, 5726, 6159, 6197, 4075, 4111, 5636, 4189, 3975, 6169, 5703, 4001, 6198)) AND (`Playercontest`.`contest_id` = 281))	128	128	2
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	2
15	SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 1996	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	1

(default) 17 queries took 26 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` = '1996' 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` = (281) 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 (4095, 4131, 4158, 6174, 5713, 6175, 6176, 4121, 5635, 6177, 4022, 4094, 4155, 4017, 5706, 4118, 4108, 5692, 5709, 5679, 6178, 4188, 4187, 6157, 4061, 5619, 6179, 6162, 6163, 6180, 5671, 4197, 3968, 5705, 5723, 4169, 4337, 4173, 4186, 6181, 5704, 5606, 5686, 4089, 4083, 5696, 4166, 5674, 4153, 3931, 4101, 4053, 5663, 6182, 6183, 4054, 6184, 6185, 5725, 4114, 4191, 4133, 5702, 4129, 4045, 5197, 3948, 6186, 6164, 4117, 4154, 6264, 3933, 6187, 4035, 6188, 6189, 5718, 4176, 4067, 5677, 6190, 4148, 6191, 4194, 4171, 6192, 3934, 4156, 5710, 4179, 4062, 4087, 5667, 4008, 6166, 4081, 6193, 4066, 5729, 4123, 6194, 6195, 4164, 4100, 7345, 4168, 3980, 6168, 6196, 4162, 4199, 4142, 5633, 4040, 4185, 5726, 6159, 6197, 4075, 4111, 5636, 4189, 3975, 6169, 5703, 4001, 6198) 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` = 281

128

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (68, 178, 197, 179, 72, 147, 14, 173, 13, 154, 53, 92, 10, 150, 94, 50, 133, 172, 29, 139, 207, 36, 194, 54, 135, 196, 21, 127, 153, 168, 91, 58, 41, 43, 84, 199)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (68, 178, 197, 179, 72, 147, 14, 173, 13, 154, 53, 92, 10, 150, 94, 50, 133, 172, 29, 139, 207, 36, 194, 54, 135, 196, 21, 127, 153, 168, 91, 58, 41, 43, 84, 199)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (4095, 4131, 4158, 6174, 5713, 6175, 6176, 4121, 5635, 6177, 4022, 4094, 4155, 4017, 5706, 4118, 4108, 5692, 5709, 5679, 6178, 4188, 4187, 6157, 4061, 5619, 6179, 6162, 6163, 6180, 5671, 4197, 3968, 5705, 5723, 4169, 4337, 4173, 4186, 6181, 5704, 5606, 5686, 4089, 4083, 5696, 4166, 5674, 4153, 3931, 4101, 4053, 5663, 6182, 6183, 4054, 6184, 6185, 5725, 4114, 4191, 4133, 5702, 4129, 4045, 5197, 3948, 6186, 6164, 4117, 4154, 6264, 3933, 6187, 4035, 6188, 6189, 5718, 4176, 4067, 5677, 6190, 4148, 6191, 4194, 4171, 6192, 3934, 4156, 5710, 4179, 4062, 4087, 5667, 4008, 6166, 4081, 6193, 4066, 5729, 4123, 6194, 6195, 4164, 4100, 7345, 4168, 3980, 6168, 6196, 4162, 4199, 4142, 5633, 4040, 4185, 5726, 6159, 6197, 4075, 4111, 5636, 4189, 3975, 6169, 5703, 4001, 6198)) AND (`Playercontest`.`contest_id` = 281))

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

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)