Australian Open 2008 Men's Singles (January 19 - February 1)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Roger Federer
				Roger Federer
2.			Diego Hartfield	6-0 6-3 6-0
					Roger Federer
3.			Fabrice Santoro		6-1 6-2 6-0
				Fabrice Santoro
4.			John Isner	6-2 6-2 6-4
						Roger Federer
5.			Janko Tipsarevic			6-7(5) 7-6(1) 5-7 6-1 10-8
				Janko Tipsarevic
6.		[WC]	Joseph Sirianni	7-5 6-2 6-7(6) 0-6 6-0
					Janko Tipsarevic
7.		[25]	Fernando Verdasco		7-5 7-6(3) 7-6(3)
				Fernando Verdasco
8.			Thierry Ascione	6-4 6-0 6-3
							Roger Federer
9.		[21]	Juan Monaco				6-4 7-6(7) 6-3
				Juan Monaco
10.			Carlos Berlocq	7-6(5) 7-5 6-1
					Juan Monaco
11.		[Q]	Amer Delic		6-3 7-6(6) 5-7 6-7(8) 8-6
				Amer Delic
12.			Robert Kendrick	6-4 7-5 6-2
						Tomas Berdych
13.			Oscar Hernandez			3-6 6-3 7-6(5) 6-2
				Oscar Hernandez
14.			Ivo Minar	1-6 7-6(5) 6-2 6-1
					Tomas Berdych
15.		[13]	Tomas Berdych		6-2 6-1 6-3
				Tomas Berdych
16.			Werner Eschauer	6-4 6-4 6-4
								Roger Federer
17.		[12]	James Blake					7-5 7-6(5) 6-4
				James Blake
18.			Nicolas Massu	6-3 6-2 6-2
					James Blake
19.			Michael Russell		6-3 6-2 6-2
				Michael Russell
20.			Fabio Fognini	6-1 4-6 6-2 3-6 6-3
						James Blake
21.			Sebastien Grosjean			4-6 2-6 6-0 7-6(5) 6-2
				Sebastien Grosjean
22.			Filippo Volandri	7-6(3) 6-3 7-6(0)
					Sebastien Grosjean
23.		[Q]	Robin Haase		4-6 6-4 6-0 6-7(4) 6-4
				Robin Haase
24.		[17]	Ivan Ljubicic	6-7(2) 6-3 6-0 7-6(1)
							James Blake
25.			Marin Cilic				6-3 6-4 6-4
				Marin Cilic
26.		[27]	Nicolas Almagro	7-6(4) 7-5 6-2
					Marin Cilic
27.			Jurgen Melzer		6-4 6-3 6-4
				Jurgen Melzer
28.			Jiri Vanek	6-3 6-4 6-4
						Marin Cilic
29.			Hyung-Taik Lee			6-2 6-7(4) 6-3 6-1
				Hyung-Taik Lee
30.			Chris Guccione	7-6(6) 6-3 6-4
					Fernando Gonzalez
31.		[7]	Fernando Gonzalez		4-6 6-3 6-2 6-4
				Fernando Gonzalez
32.		[Q]	Konstantinos Economidis	6-4 7-6(2) 6-1
									Novak Djokovic
33.		[3]	Novak Djokovic						7-5 6-3 7-6(5)
				Novak Djokovic
34.			Benjamin Becker	6-0 6-3 7-6(5)
					Novak Djokovic
35.			Simone Bolelli		6-1 6-2 6-2
				Simone Bolelli
36.		[Q]	Rajeev Ram	7-6(5) 3-6 6-4 2-6 6-3
						Novak Djokovic
37.			Sam Querrey			6-3 6-1 6-3
				Sam Querrey
38.			Olivier Rochus	6-3 6-2 7-5
					Sam Querrey
39.		[32]	Dmitry Tursunov		7-6(5) 4-6 6-4 6-2
				Dmitry Tursunov
40.			Xavier Malisse	6-7(1) 5-7 6-2 6-1 6-3
							Novak Djokovic
41.		[19]	Lleyton Hewitt				7-5 6-3 6-3
				Lleyton Hewitt
42.			Steve Darcis	6-0 6-3 6-0
					Lleyton Hewitt
43.		[WC]	Denis Istomin		7-6(5) 6-3 5-7 6-1
				Denis Istomin
44.		[Q]	Lukas Lacko	6-3 6-7(1) 7-6(4) 6-1
						Lleyton Hewitt
45.			Marat Safin			4-6 7-5 7-5 6-7(4) 6-3
				Marat Safin
46.			Ernests Gulbis	6-0 6-4 7-6(2)
					Marcos Baghdatis
47.		[15]	Marcos Baghdatis		6-4 6-4 2-6 3-6 6-2
				Marcos Baghdatis
48.			Thomas Johansson	7-6(0) 6-2 3-6 6-3
								Novak Djokovic
49.		[10]	David Nalbandian					6-0 6-3 7-5
				David Nalbandian
50.		[WC]	Robert Smeets	6-1 6-1 7-6(3)
					David Nalbandian
51.			Peter Luczak		4-6 7-5 6-4 6-1
				Peter Luczak
52.			Mariano Zabaleta	6-1 6-7(2) 6-3 6-4
						Juan Carlos Ferrero
53.		[WC]	Alun Jones			6-1 6-2 6-3
				Alun Jones
54.			Albert Montanes	6-4 6-3 3-6 6-2
					Juan Carlos Ferrero
55.		[22]	Juan Carlos Ferrero		6-4 6-4 6-2
				Juan Carlos Ferrero
56.			Nicolas Kiefer	6-4 6-3 6-1
							David Ferrer
57.			Vince Spadea				7-5 3-6 6-4 6-1
				Vince Spadea
58.		[30]	Radek Stepanek	2-6 2-6 7-5 6-2 6-3
					Vince Spadea
59.		[Q]	Denis Gremelmayr		4-6 6-2 6-3 2-6 9-7
				Denis Gremelmayr
60.			Sergio Roitman	6-1 0-6 6-4 7-5
						David Ferrer
61.			Juan Martin Del Potro			6-3 6-3 6-2
				Juan Martin Del Potro
62.			Santiago Ventura	6-3 6-1 6-3
					David Ferrer
63.		[5]	David Ferrer		6-3 6-4 rtd.
				David Ferrer
64.			Edouard Roger-Vasselin	6-2 6-2 6-1
										Novak Djokovic
65.		[8]	Richard Gasquet							4-6 6-4 6-3 7-6(2)
				Richard Gasquet
66.		[WC]	Nick Lindahl	6-0 6-1 3-6 6-2
					Richard Gasquet
67.			Feliciano Lopez		6-2 6-1 6-3
				Feliciano Lopez
68.		[Q]	Wayne Odesnik	7-6(6) 6-1 6-4
						Richard Gasquet
69.			Kristof Vliegen			6-3 6-2 4-6 6-4
				Kristof Vliegen
70.			Olivier Patience	6-0 6-1 7-6(3)
					Igor Andreev
71.		[31]	Igor Andreev		7-5 7-5 6-2
				Igor Andreev
72.			Andrei Pavel	5-7 6-2 7-6(4) 6-3
							Jo-Wilfried Tsonga
73.			Guillermo Garcia-Lopez				6-2 6-7(5) 7-6(6) 6-3
				Guillermo Garcia-Lopez
74.		[18]	Juan Ignacio Chela	6-4 6-2 1-6 6-2
					Guillermo Garcia-Lopez
75.			Alejandro Falla		6-4 5-7 6-4 7-6(6)
				Alejandro Falla
76.		[Q]	Kevin Anderson	5-7 7-5 6-7(8) 6-2 7-5
						Jo-Wilfried Tsonga
77.		[Q]	Sam Warburg			6-3 6-4 6-2
				Sam Warburg
78.			Juan Brzezicki	2-6 6-2 6-3 2-6 6-4
					Jo-Wilfried Tsonga
79.			Jo-Wilfried Tsonga		6-4 7-6(4) 6-2
				Jo-Wilfried Tsonga
80.		[9]	Andy Murray	7-5 6-4 0-6 7-6(5)
								Jo-Wilfried Tsonga
81.		[14]	Mikhail Youzhny					7-5 6-0 7-6(6)
				Mikhail Youzhny
82.		[WC]	Mathieu Montcourt	6-0 6-2 7-6(3)
					Mikhail Youzhny
83.			Andreas Seppi		4-6 7-5 6-3 7-6(4)
				Andreas Seppi
84.		[Q]	Harel Levy	6-4 6-2 6-1
						Mikhail Youzhny
85.			Dudi Sela			6-2 6-4 6-2
				Dudi Sela
86.		[Q]	Martin Slanar	6-2 6-4 6-2
					Ivo Karlovic
87.		[20]	Ivo Karlovic		6-7(5) 6-4 6-3 6-1
				Ivo Karlovic
88.		[Q]	Jamie Baker	6-4 6-4 6-7(1) 6-4
							Mikhail Youzhny
89.		[26]	Stan Wawrinka				7-6(2) 6-3 6-1
				Stan Wawrinka
90.			Julien Benneteau	6-3 6-3 6-3
					Marc Gicquel
91.			Marc Gicquel		6-2 3-6 7-6(5) 2-1 rtd.
				Marc Gicquel
92.			Yen-Hsun Lu	6-3 4-6 6-7(6) 6-4 6-2
						Nikolay Davydenko
93.			Nicolas Mahut			6-3 6-2 6-3
				Nicolas Mahut
94.			Jose Acasuso	7-6(2) 5-7 6-2 3-6 7-5
					Nikolay Davydenko
95.		[4]	Nikolay Davydenko		6-4 6-0 6-3
				Nikolay Davydenko
96.			Michael Llodra	7-5 7-5 6-3
									Jo-Wilfried Tsonga
97.		[6]	Andy Roddick						6-2 6-3 6-2
				Andy Roddick
98.		[Q]	Lukas Dlouhy	6-3 6-4 7-5
					Andy Roddick
99.			Michael Berrer		6-2 6-2 6-4
				Michael Berrer
100.			Donald Young	6-7(5) 7-6(4) 6-3 7-6(5)
						Philipp Kohlschreiber
101.			Evgeny Korolev			6-4 3-6 7-6(9) 6-7(3) 8-6
				Evgeny Korolev
102.		[Q]	Marcel Granollers	7-5 6-2 6-0
					Philipp Kohlschreiber
103.		[29]	Philipp Kohlschreiber		6-4 6-2 0-1 rtd.
				Philipp Kohlschreiber
104.		[Q]	Roko Karanusic	6-4 7-6(5) 6-1
							Jarkko Nieminen
105.		[24]	Jarkko Nieminen				3-6 7-6(7) 7-6(9) 6-3
				Jarkko Nieminen
106.			Frank Dancevic	6-3 6-1 5-7 2-6 6-1
					Jarkko Nieminen
107.		[WC]	Jesse Levine		6-2 7-5 7-6(2)
				Jesse Levine
108.			Martin Arguello	6-1 7-5 6-1
						Jarkko Nieminen
109.			Mardy Fish			3-6 7-6(4) 6-3 6-1
				Mardy Fish
110.			Boris Pashanski	6-2 6-3 3-6 6-3
					Mardy Fish
111.		[11]	Tommy Robredo		6-1 6-2 6-3
				Tommy Robredo
112.			Mischa Zverev	4-6 2-6 7-6(2) 6-4 7-5
								Rafael Nadal
113.			Stefan Koubek					7-5 6-3 6-1
				Stefan Koubek
114.		[16]	Carlos Moya	7-6(5) 6-7(2) 7-5 6-4
					Stefan Koubek
115.			Agustin Calleri		6-3 7-6(6) 7-6(5)
				Agustin Calleri
116.			Luis Horna	6-4 6-7(6) 6-3 6-4
						Paul-Henri Mathieu
117.			Paul Capdeville			4-6 7-6(4) 2-6 7-5 8-6
				Paul Capdeville
118.		[WC]	Brydan Klein	6-4 7-5 6-4
					Paul-Henri Mathieu
119.		[23]	Paul-Henri Mathieu		6-7(5) 6-0 6-4 6-4
				Paul-Henri Mathieu
120.			Victor Hanescu	6-1 7-6(4) 6-2
							Rafael Nadal
121.		[28]	Gilles Simon				6-4 3-0 rtd.
				Gilles Simon
122.			Bobby Reynolds	4-6 6-4 6-2 6-7(4) 6-4
					Gilles Simon
123.			Rainer Schuettler		6-2 6-2 6-1
				Rainer Schuettler
124.			Arnaud Clement	6-4 6-2 6-7(3) 6-4
						Rafael Nadal
125.			Florent Serra			7-5 6-2 6-3
				Florent Serra
126.			Florian Mayer	6-3 7-6(2) 7-6(5)
					Rafael Nadal
127.		[2]	Rafael Nadal		6-0 6-2 6-2
				Rafael Nadal
128.		[Q]	Viktor Troicki	7-6(3) 7-5 6-1

(default) 17 queries took 24 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	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	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` = 1 AND `Contest`.`category_id` = 1 AND `Contest`.`slug` = '2008' 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` = (293) 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 (147, 7837, 4129, 164, 68, 6263, 139, 7231, 123, 142, 7284, 5054, 7310, 7299, 148, 7838, 3578, 7292, 77, 119, 6256, 61, 66, 172, 3722, 163, 140, 6281, 7266, 7308, 7327, 7839, 52, 159, 3585, 7313, 137, 150, 69, 86, 65, 127, 114, 173, 6260, 89, 158, 5723, 167, 7758, 4210, 6262, 7334, 120, 93, 6175, 6169, 59, 7770, 7209, 131, 7307, 83, 87, 75, 7840, 171, 3718, 7241, 7233, 3591, 6220, 94, 76, 118, 155, 7841, 7842, 115, 84, 72, 7279, 74, 7258, 97, 7843, 141, 3719, 156, 102, 4926, 125, 58, 7298, 169, 88, 67, 7280, 4212, 175, 7323, 108, 122, 7469, 166, 4771, 109, 7295, 116, 7275, 5051, 7301, 6250, 6190, 7314, 7247, 7312, 7844, 3590, 135, 100, 4927, 4209, 5932, 126, 3583, 179, 92) 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` = 293	128	128	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (164, 68, 53, 92, 13, 133, 197, 154, 10, 173, 196, 21, 104, 91, 199, 43, 72, 181, 153, 14, 50, 179, 172, 52, 67, 27, 168, 36, 178, 147, 100, 41, 96, 74)	34	34	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (164, 68, 53, 92, 13, 133, 197, 154, 10, 173, 196, 21, 104, 91, 199, 43, 72, 181, 153, 14, 50, 179, 172, 52, 67, 27, 168, 36, 178, 147, 100, 41, 96, 74)	34	34	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (147, 7837, 4129, 164, 68, 6263, 139, 7231, 123, 142, 7284, 5054, 7310, 7299, 148, 7838, 3578, 7292, 77, 119, 6256, 61, 66, 172, 3722, 163, 140, 6281, 7266, 7308, 7327, 7839, 52, 159, 3585, 7313, 137, 150, 69, 86, 65, 127, 114, 173, 6260, 89, 158, 5723, 167, 7758, 4210, 6262, 7334, 120, 93, 6175, 6169, 59, 7770, 7209, 131, 7307, 83, 87, 75, 7840, 171, 3718, 7241, 7233, 3591, 6220, 94, 76, 118, 155, 7841, 7842, 115, 84, 72, 7279, 74, 7258, 97, 7843, 141, 3719, 156, 102, 4926, 125, 58, 7298, 169, 88, 67, 7280, 4212, 175, 7323, 108, 122, 7469, 166, 4771, 109, 7295, 116, 7275, 5051, 7301, 6250, 6190, 7314, 7247, 7312, 7844, 3590, 135, 100, 4927, 4209, 5932, 126, 3583, 179, 92)) AND (`Playercontest`.`contest_id` = 293))	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` = 2008	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 24 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` = '2008' 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` = (293) 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 (147, 7837, 4129, 164, 68, 6263, 139, 7231, 123, 142, 7284, 5054, 7310, 7299, 148, 7838, 3578, 7292, 77, 119, 6256, 61, 66, 172, 3722, 163, 140, 6281, 7266, 7308, 7327, 7839, 52, 159, 3585, 7313, 137, 150, 69, 86, 65, 127, 114, 173, 6260, 89, 158, 5723, 167, 7758, 4210, 6262, 7334, 120, 93, 6175, 6169, 59, 7770, 7209, 131, 7307, 83, 87, 75, 7840, 171, 3718, 7241, 7233, 3591, 6220, 94, 76, 118, 155, 7841, 7842, 115, 84, 72, 7279, 74, 7258, 97, 7843, 141, 3719, 156, 102, 4926, 125, 58, 7298, 169, 88, 67, 7280, 4212, 175, 7323, 108, 122, 7469, 166, 4771, 109, 7295, 116, 7275, 5051, 7301, 6250, 6190, 7314, 7247, 7312, 7844, 3590, 135, 100, 4927, 4209, 5932, 126, 3583, 179, 92) 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` = 293

128

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (164, 68, 53, 92, 13, 133, 197, 154, 10, 173, 196, 21, 104, 91, 199, 43, 72, 181, 153, 14, 50, 179, 172, 52, 67, 27, 168, 36, 178, 147, 100, 41, 96, 74)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (164, 68, 53, 92, 13, 133, 197, 154, 10, 173, 196, 21, 104, 91, 199, 43, 72, 181, 153, 14, 50, 179, 172, 52, 67, 27, 168, 36, 178, 147, 100, 41, 96, 74)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (147, 7837, 4129, 164, 68, 6263, 139, 7231, 123, 142, 7284, 5054, 7310, 7299, 148, 7838, 3578, 7292, 77, 119, 6256, 61, 66, 172, 3722, 163, 140, 6281, 7266, 7308, 7327, 7839, 52, 159, 3585, 7313, 137, 150, 69, 86, 65, 127, 114, 173, 6260, 89, 158, 5723, 167, 7758, 4210, 6262, 7334, 120, 93, 6175, 6169, 59, 7770, 7209, 131, 7307, 83, 87, 75, 7840, 171, 3718, 7241, 7233, 3591, 6220, 94, 76, 118, 155, 7841, 7842, 115, 84, 72, 7279, 74, 7258, 97, 7843, 141, 3719, 156, 102, 4926, 125, 58, 7298, 169, 88, 67, 7280, 4212, 175, 7323, 108, 122, 7469, 166, 4771, 109, 7295, 116, 7275, 5051, 7301, 6250, 6190, 7314, 7247, 7312, 7844, 3590, 135, 100, 4927, 4209, 5932, 126, 3583, 179, 92)) AND (`Playercontest`.`contest_id` = 293))

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

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)