Australian Open 2002 Men's Singles (January 14 - January 27)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.			Alberto Martin
				Alberto Martin
2.		[1]	Lleyton Hewitt	1-6 6-1 6-4 7-6(4)
					Alberto Martin
3.			Michel Kratochvil		3-6 6-3 6-3 6-3
				Michel Kratochvil
4.			Fernando Meligeni	6-4 6-1 6-2
						Marcelo Rios
5.			Marcelo Rios			6-4 6-3 7-6(3)
				Marcelo Rios
6.		[WC]	Jaymon Crabb	6-2 6-0 5-7 6-4
					Marcelo Rios
7.			Karol Kucera		7-6(5) 7-5 6-2
				Karol Kucera
8.		[27]	Sjeng Schalken	6-1 6-4 1-6 6-1
							Marcelo Rios
9.		[23]	Nicolas Lapentti				7-5 6-1 6-4
				Nicolas Lapentti
10.			Axel Pretzsch	7-5 4-6 6-0 6-0
					Nicolas Lapentti
11.			Jose Acasuso		7-6(5) 6-2 6-3
				Jose Acasuso
12.			Jan Vacek	3-6 1-6 6-4 7-6(5) 6-1
						Nicolas Lapentti
13.			Gaston Gaudio			4-6 5-7 6-4 6-2 6-4
				Gaston Gaudio
14.		[Q]	Jack Brasington	6-4 7-6(3) 7-5
					Gaston Gaudio
15.		[15]	Arnaud Clement		6-4 4-6 6-2 7-6(3)
				Arnaud Clement
16.			Flavio Saretta	6-4 7-6(5) 6-4
								Tommy Haas
17.		[11]	Roger Federer					7-6(2) 6-4 6-7(2) 7-6(5)
				Roger Federer
18.			Michael Chang	6-4 6-4 6-3
					Roger Federer
19.			Attila Savolt		6-2 7-5 6-4
				Attila Savolt
20.		[Q]	Olivier Patience	6-3 3-6 6-3 3-6 6-4
						Roger Federer
21.			Rainer Schuettler			7-6(6) 7-6(5) 6-4
				Rainer Schuettler
22.		[WC]	Paul-Henri Mathieu	2-6 6-1 4-6 6-1 6-4
					Rainer Schuettler
23.		[17]	Carlos Moya		3-6 6-7(4) 6-1 7-6(5) 6-2
				Carlos Moya
24.			Agustin Calleri	2-6 6-7(3) 6-4 7-6(4) 1-0 rtd.
							Tommy Haas
25.		[29]	Xavier Malisse				7-6(3) 4-6 3-6 6-4 8-6
				Xavier Malisse
26.		[Q]	Tomas Behrend	6-4 6-4 7-5
					Todd Martin
27.			Todd Martin		6-3 6-2 6-2
				Todd Martin
28.			Andre Sa	6-4 6-3 7-5
						Tommy Haas
29.		[Q]	Jean-Francois Bachelot			6-7(8) 6-3 3-6 6-4 6-1
				Jean-Francois Bachelot
30.		[Q]	Stefano Galvani	6-2 7-5 7-5
					Tommy Haas
31.		[7]	Tommy Haas		6-1 6-2 6-3
				Tommy Haas
32.			Andrei Stoliarov	6-1 6-3 6-1
									Marat Safin
33.		[Q]	Byron Black						6-7(5) 7-6(4) 3-6 6-0 6-2
				Byron Black
34.		[LL]	Irakli Labadze	4-6 4-6 6-3 6-3 7-5
					Albert Costa
35.			Albert Costa		6-1 6-4 6-4
				Albert Costa
36.			Felix Mantilla	2-6 6-2 6-3 6-4
						Albert Costa
37.			Alexandre Simoni			7-6(4) 6-4 6-4
				Alexandre Simoni
38.			Ota Fukarek	4-6 7-5 6-2 6-7(3) 7-5
					Andrei Pavel
39.		[25]	Andrei Pavel		6-1 4-0 rtd.
				Andrei Pavel
40.			Franco Squillari	6-4 6-3 3-6 6-2
							Wayne Ferreira
41.			Wayne Ferreira				4-6 6-4 6-4 6-7(4) 9-7
				Wayne Ferreira
42.		[19]	Jan-Michael Gambill	6-2 6-4 7-6(6)
					Wayne Ferreira
43.			David Nalbandian		6-7(5) 7-6(2) 7-5 6-3
				David Nalbandian
44.			Daniel Vacek	7-5 3-6 6-3 6-3
						Wayne Ferreira
45.			Ivan Ljubicic			4-6 4-6 7-6(3) 6-3 7-5
				Ivan Ljubicic
46.			Bohdan Ulihrach	6-7(4) 1-6 6-4 7-6(7) 9-7
					Ivan Ljubicic
47.		[13]	Andy Roddick		7-6(11) 3-2 rtd.
				Andy Roddick
48.			Mariano Zabaleta	6-3 5-7 6-3 6-3
								Marat Safin
49.		[9]	Marat Safin					5-2 rtd.
				Marat Safin
50.			Antony Dupuis	7-5 6-4 6-2
					Marat Safin
51.			Christophe Rochus		6-2 7-6(6) 6-1
				Christophe Rochus
52.		[Q]	Raemon Sluiter	4-6 6-3 6-4 6-2
						Marat Safin
53.			Mikhail Youzhny			6-4 6-4 6-4
				Mikhail Youzhny
54.			Michael Llodra	6-7(2) 6-2 6-2 6-3
					Mikhail Youzhny
55.		[Q]	Mardy Fish		6-4 6-3 6-2
				Mardy Fish
56.		[20]	Fabrice Santoro	6-2 1-6 6-4 6-1
							Marat Safin
57.		[30]	Nicolas Escude				6-2 6-4 6-7(5) 7-6(8)
				Nicolas Escude
58.		[WC]	Todd Reid	1-6 6-1 6-4 6-4
					Nicolas Escude
59.			Alex Calatrava		2-6 2-6 6-4 7-5 6-4
				Alex Calatrava
60.		[Q]	Olivier Rochus	6-3 3-6 6-3 3-6 6-3
						Pete Sampras
61.			Juan Ignacio Chela			7-6(5) 5-7 6-4 6-7(6) 6-3
				Juan Ignacio Chela
62.		[Q]	Noam Okun	6-2 6-7(5) 6-3 6-1
					Pete Sampras
63.		[8]	Pete Sampras		6-3 7-5 3-6 6-4
				Pete Sampras
64.			Jarkko Nieminen	6-3 6-3 6-4
										Thomas Johansson
65.		[5]	Sebastien Grosjean							3-6 6-4 6-4 7-6(4)
				Sebastien Grosjean
66.			Juan-Manuel Balcells	6-2 2-6 7-6(5) 7-6(2)
					Francisco Clavet
67.			Francisco Clavet		6-4 3-6 6-0 5-7 6-4
				Francisco Clavet
68.			Martin Lee	7-6(2) 6-1 6-0
						Jiri Novak
69.			Andrea Gaudenzi			6-3 6-4 6-1
				Andrea Gaudenzi
70.		[WC]	Richard Fromberg	1-6 6-0 7-5 6-3
					Jiri Novak
71.		[26]	Jiri Novak		2-6 5-7 6-2 6-3 6-3
				Jiri Novak
72.			Nicolas Kiefer	6-1 6-0 6-4
							Jiri Novak
73.		[18]	Albert Portas				6-4 6-2 5-7 6-2
				Albert Portas
74.			Andrew Ilie	6-7(3) 7-6(6) 6-2 6-0
					Dominik Hrbaty
75.			Dominik Hrbaty		6-1 6-3 6-0
				Dominik Hrbaty
76.			Lars Burgsmuller	3-6 2-6 6-3 6-3 7-5
						Dominik Hrbaty
77.			Jerome Golmard			6-3 6-1 6-7(6) 7-5
				Jerome Golmard
78.			Wayne Arthurs	7-6(4) 7-5 7-6(5)
					Jerome Golmard
79.		[10]	Goran Ivanisevic		6-3 7-6(2) 5-7 6-4
				Goran Ivanisevic
80.			Martin Damm	4-6 7-5 7-6(4) 6-4
								Jiri Novak
81.			James Blake					6-2 6-3 6-2
				James Blake
82.		[14]	Alex Corretja	5-7 7-6(6) 6-3 6-2
					Stefan Koubek
83.			Stefan Koubek		4-6 2-6 6-4 6-1 6-2
				Stefan Koubek
84.		[Q]	Cyril Saulnier	0-6 1-6 7-6(6) 6-4 8-6
						Stefan Koubek
85.			Kristian Pless			7-6(4) 7-5 6-3
				Kristian Pless
86.			Max Mirnyi	3-6 6-3 6-4 6-3
					Kristian Pless
87.		[22]	Hicham Arazi		6-3 6-4 6-1
				Hicham Arazi
88.			Ivo Heuberger	6-4 6-2 2-6 7-6(1)
							Stefan Koubek
89.		[32]	Tommy Robredo				7-5 6-1 6-7(3) 6-2
				Tommy Robredo
90.			Michael Russell	6-7(5) 6-3 6-3 6-4
					Fernando Gonzalez
91.		[Q]	Fernando Gonzalez		6-2 6-4 6-4
				Fernando Gonzalez
92.			Sargis Sargsian	6-1 6-3 7-6(5)
						Fernando Gonzalez
93.		[Q]	Alex Kim			6-2 6-2 6-3
				Alex Kim
94.			Davide Sanguinetti	3-6 6-2 6-3 6-4
					Alex Kim
95.		[4]	Yevgeny Kafelnikov		6-3 7-5 6-3
				Yevgeny Kafelnikov
96.		[Q]	Michael Kohlmann	6-3 6-3 6-2
									Thomas Johansson
97.		[6]	Tim Henman						7-6(5) 0-6 4-6 6-3 6-4
				Tim Henman
98.		[WC]	Todd Larkham	7-5 6-2 6-2
					Tim Henman
99.			Vladimir Voltchkov		6-3 6-4 6-1
				Vladimir Voltchkov
100.		[Q]	Cecil Mamiit	3-6 6-3 6-3 6-3
						Tim Henman
101.			Mark Philippoussis			6-4 6-3 1-6 6-3
				Mark Philippoussis
102.			Galo Blanco	6-3 6-4 7-5
					Greg Rusedski
103.		[28]	Greg Rusedski		7-6(7) 6-3 6-4
				Greg Rusedski
104.		[WC]	Scott Draper	7-6(8) 6-3 7-5
							Jonas Bjorkman
105.		[24]	Thomas Enqvist				6-2 7-6(6) 6-4
				Thomas Enqvist
106.		[Q]	Nicolas Thomann	2-6 6-3 6-1 6-2
					Jonas Bjorkman
107.			Jonas Bjorkman		3-6 7-5 6-4 6-2
				Jonas Bjorkman
108.			Nicolas Massu	6-4 rtd.
						Jonas Bjorkman
109.			Ramon Delgado			6-3 6-2 6-4
				Ramon Delgado
110.			Albert Montanes	7-5 6-7(5) 4-6 6-4 6-1
					Guillermo Canas
111.		[12]	Guillermo Canas		6-2 7-5 6-7(9) 6-4
				Guillermo Canas
112.		[WC]	Paradorn Srichaphan	6-1 6-1 6-4
								Thomas Johansson
113.		[16]	Thomas Johansson					6-0 2-6 6-3 6-4
				Thomas Johansson
114.			Jacobo Diaz-Ruiz	6-1 3-6 7-6(2) 6-4
					Thomas Johansson
115.			Markus Hipfl		6-4 6-1 6-4
				Markus Hipfl
116.			Nikolay Davydenko	6-1 6-4 3-6 6-4
						Thomas Johansson
117.			Fernando Vicente			5-7 6-2 6-2 6-4
				Fernando Vicente
118.			Kenneth Carlsen	2-6 2-6 6-4 6-4 10-8
					Younes El Aynaoui
119.		[21]	Younes El Aynaoui		4-6 6-3 6-3 6-3
				Younes El Aynaoui
120.			Jiri Vanek	6-3 6-3 6-3
							Thomas Johansson
121.		[31]	Andreas Vinciguerra				6-7(8) 6-2 6-0 6-4
				Andreas Vinciguerra
122.			Federico Luzzi	6-2 6-2 7-6(3)
					Taylor Dent
123.		[WC]	Taylor Dent		6-3 6-4 6-2
				Taylor Dent
124.			Michal Tabara	6-2 6-1 6-2
						Adrian Voinea
125.			Adrian Voinea			3-6 6-3 6-4 3-6 6-3
				Adrian Voinea
126.			David Sanchez-Munoz	5-7 6-2 7-6(5) 6-2
					Adrian Voinea
127.			Julien Boutter		6-2 6-4 6-7(5) 2-6 6-3
				Julien Boutter
128.		[2]	Gustavo Kuerten	3-6 4-6 7-5 6-3 6-3

(default) 17 queries took 34 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` = '2002' 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` = (287) 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 (6223, 65, 7332, 4188, 6182, 6207, 6168, 6188, 6181, 6280, 7298, 7470, 6284, 7338, 5932, 7250, 147, 4045, 7339, 7233, 4209, 3590, 6190, 7314, 86, 6286, 4142, 7169, 7145, 8723, 176, 7328, 4337, 7340, 6178, 6227, 7341, 7208, 6220, 6233, 4162, 6226, 167, 5633, 172, 6195, 67, 6262, 6260, 6293, 6290, 6270, 72, 88, 116, 4129, 6234, 7342, 6224, 150, 76, 6271, 4095, 166, 6256, 7203, 4155, 7343, 5710, 4131, 6187, 6175, 6231, 6159, 6230, 6165, 6173, 6255, 4108, 4185, 3578, 4191, 6250, 7200, 7277, 6295, 6208, 7336, 5051, 77, 7327, 6213, 7344, 6222, 5702, 6252, 6197, 7345, 6251, 6249, 5713, 6212, 5705, 6157, 5671, 7346, 5726, 7292, 6253, 120, 6254, 6276, 5723, 6235, 6261, 169, 6259, 5679, 5720, 6281, 6273, 7347, 7348, 6292, 6163, 7329, 6275, 6205) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	128	128	14
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` = 287	128	128	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (13, 197, 154, 10, 21, 68, 173, 179, 67, 27, 72, 50, 172, 53, 29, 207, 178, 54, 196, 92, 127, 153, 168, 58, 41, 133, 11, 14, 20, 146, 91, 184, 84, 71)	34	34	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (13, 197, 154, 10, 21, 68, 173, 179, 67, 27, 72, 50, 172, 53, 29, 207, 178, 54, 196, 92, 127, 153, 168, 58, 41, 133, 11, 14, 20, 146, 91, 184, 84, 71)	34	34	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (6223, 65, 7332, 4188, 6182, 6207, 6168, 6188, 6181, 6280, 7298, 7470, 6284, 7338, 5932, 7250, 147, 4045, 7339, 7233, 4209, 3590, 6190, 7314, 86, 6286, 4142, 7169, 7145, 8723, 176, 7328, 4337, 7340, 6178, 6227, 7341, 7208, 6220, 6233, 4162, 6226, 167, 5633, 172, 6195, 67, 6262, 6260, 6293, 6290, 6270, 72, 88, 116, 4129, 6234, 7342, 6224, 150, 76, 6271, 4095, 166, 6256, 7203, 4155, 7343, 5710, 4131, 6187, 6175, 6231, 6159, 6230, 6165, 6173, 6255, 4108, 4185, 3578, 4191, 6250, 7200, 7277, 6295, 6208, 7336, 5051, 77, 7327, 6213, 7344, 6222, 5702, 6252, 6197, 7345, 6251, 6249, 5713, 6212, 5705, 6157, 5671, 7346, 5726, 7292, 6253, 120, 6254, 6276, 5723, 6235, 6261, 169, 6259, 5679, 5720, 6281, 6273, 7347, 7348, 6292, 6163, 7329, 6275, 6205)) AND (`Playercontest`.`contest_id` = 287))	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	1
15	SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 2002	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 34 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` = '2002' 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` = (287) 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 (6223, 65, 7332, 4188, 6182, 6207, 6168, 6188, 6181, 6280, 7298, 7470, 6284, 7338, 5932, 7250, 147, 4045, 7339, 7233, 4209, 3590, 6190, 7314, 86, 6286, 4142, 7169, 7145, 8723, 176, 7328, 4337, 7340, 6178, 6227, 7341, 7208, 6220, 6233, 4162, 6226, 167, 5633, 172, 6195, 67, 6262, 6260, 6293, 6290, 6270, 72, 88, 116, 4129, 6234, 7342, 6224, 150, 76, 6271, 4095, 166, 6256, 7203, 4155, 7343, 5710, 4131, 6187, 6175, 6231, 6159, 6230, 6165, 6173, 6255, 4108, 4185, 3578, 4191, 6250, 7200, 7277, 6295, 6208, 7336, 5051, 77, 7327, 6213, 7344, 6222, 5702, 6252, 6197, 7345, 6251, 6249, 5713, 6212, 5705, 6157, 5671, 7346, 5726, 7292, 6253, 120, 6254, 6276, 5723, 6235, 6261, 169, 6259, 5679, 5720, 6281, 6273, 7347, 7348, 6292, 6163, 7329, 6275, 6205) 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` = 287

128

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (13, 197, 154, 10, 21, 68, 173, 179, 67, 27, 72, 50, 172, 53, 29, 207, 178, 54, 196, 92, 127, 153, 168, 58, 41, 133, 11, 14, 20, 146, 91, 184, 84, 71)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (13, 197, 154, 10, 21, 68, 173, 179, 67, 27, 72, 50, 172, 53, 29, 207, 178, 54, 196, 92, 127, 153, 168, 58, 41, 133, 11, 14, 20, 146, 91, 184, 84, 71)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (6223, 65, 7332, 4188, 6182, 6207, 6168, 6188, 6181, 6280, 7298, 7470, 6284, 7338, 5932, 7250, 147, 4045, 7339, 7233, 4209, 3590, 6190, 7314, 86, 6286, 4142, 7169, 7145, 8723, 176, 7328, 4337, 7340, 6178, 6227, 7341, 7208, 6220, 6233, 4162, 6226, 167, 5633, 172, 6195, 67, 6262, 6260, 6293, 6290, 6270, 72, 88, 116, 4129, 6234, 7342, 6224, 150, 76, 6271, 4095, 166, 6256, 7203, 4155, 7343, 5710, 4131, 6187, 6175, 6231, 6159, 6230, 6165, 6173, 6255, 4108, 4185, 3578, 4191, 6250, 7200, 7277, 6295, 6208, 7336, 5051, 77, 7327, 6213, 7344, 6222, 5702, 6252, 6197, 7345, 6251, 6249, 5713, 6212, 5705, 6157, 5671, 7346, 5726, 7292, 6253, 120, 6254, 6276, 5723, 6235, 6261, 169, 6259, 5679, 5720, 6281, 6273, 7347, 7348, 6292, 6163, 7329, 6275, 6205)) AND (`Playercontest`.`contest_id` = 287))

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

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)