Australian Open 2007 Men's Singles (January 15 - January 29)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Roger Federer
				Roger Federer
2.			Bjorn Phau	7-5 6-0 6-4
					Roger Federer
3.			Jonas Bjorkman		6-2 6-3 6-2
				Jonas Bjorkman
4.			Olivier Patience	5-7 4-6 6-0 6-1 6-2
						Roger Federer
5.			Yen-Hsun Lu			6-3 6-3 7-6(5)
				Yen-Hsun Lu
6.			Simon Greul	6-3 6-4 6-3
					Mikhail Youzhny
7.		[25]	Mikhail Youzhny		7-5 6-4 6-4
				Mikhail Youzhny
8.			Jan Hernych	7-6(6) 6-2 6-0
							Roger Federer
9.		[24]	Juan Carlos Ferrero				6-2 7-5 6-3
				Juan Carlos Ferrero
10.			Jan Hajek	3-0 rtd.
					Danai Udomchoke
11.			Danai Udomchoke		7-6(0) 7-5 4-6 6-1
				Danai Udomchoke
12.			Martin Arguello	6-3 6-3 6-2
						Novak Djokovic
13.			Feliciano Lopez			6-3 6-4 5-7 6-1
				Feliciano Lopez
14.		[Q]	Brian Wilson	7-6(8) 4-6 6-3 7-6(3)
					Novak Djokovic
15.		[14]	Novak Djokovic		6-2 7-5 6-1
				Novak Djokovic
16.			Nicolas Massu	6-1 6-1 6-0
								Roger Federer
17.		[11]	Marcos Baghdatis					6-3 7-6(2) 7-5
				Marcos Baghdatis
18.			Rainer Schuettler	6-4 2-6 6-3 6-2
					Gael Monfils
19.			Gael Monfils		7-6(5) 6-2 2-6 6-0
				Gael Monfils
20.			Daniele Bracciali	7-6(2) 6-7(9) 6-4 7-6(5)
						Richard Gasquet
21.			Amer Delic			6-0 4-6 7-5 6-3
				Amer Delic
22.			Gilles Simon	6-3 6-0 6-2
					Richard Gasquet
23.		[18]	Richard Gasquet		6-1 6-2 6-4
				Richard Gasquet
24.			Filippo Volandri	6-4 6-4 6-2
							Tommy Robredo
25.		[WC]	Sam Querrey				6-4 6-2 3-6 6-4
				Sam Querrey
26.		[27]	Jose Acasuso	6-7(2) 6-4 6-1 6-3
					Sam Querrey
27.			Florent Serra		6-3 6-4 6-3
				Florent Serra
28.			Nicolas Devilder	7-5 6-2 6-4
						Tommy Robredo
29.			Jurgen Melzer			6-4 6-7(5) 6-2 6-1
				Jurgen Melzer
30.			Ivo Karlovic	6-4 6-4 7-6(6)
					Tommy Robredo
31.		[7]	Tommy Robredo		6-1 6-3 6-3
				Tommy Robredo
32.			Ruben Ramirez Hidalgo	6-4 6-4 6-0
									Roger Federer
33.			Mardy Fish						6-4 6-0 6-2
				Mardy Fish
34.		[4]	Ivan Ljubicic	4-6 7-6(2) 6-4 6-4
					Mardy Fish
35.			Nicolas Mahut		7-5 6-4 3-6 6-4
				Nicolas Mahut
36.			Juan Monaco	6-0 6-7(0) 6-3 6-4
						Mardy Fish
37.		[WC]	Wayne Arthurs			3-0 rtd.
				Wayne Arthurs
38.			Stefan Koubek	1-6 6-7(4) 7-6(5) 6-2 6-3
					Wayne Arthurs
39.		[Q]	Zack Fleishman		6-7(5) 6-1 6-4 6-4
				Zack Fleishman
40.		[30]	Agustin Calleri	7-5 4-6 6-3 6-4
							Mardy Fish
41.		[20]	Radek Stepanek				6-1 7-6(4) 2-6 7-5
				Radek Stepanek
42.			Michael Llodra	6-2 6-4 6-0
					Radek Stepanek
43.			Lukas Dlouhy		4-6 4-6 6-4 6-1 6-4
				Lukas Dlouhy
44.		[Q]	Teymuraz Gabashvili	6-3 6-1 6-7(5) 6-7(5) 16-14
						David Ferrer
45.			Thomas Johansson			6-7(5) 4-6 6-0 6-4 6-3
				Thomas Johansson
46.		[Q]	Marco Chiudinelli	6-4 3-6 1-6 6-4 6-2
					David Ferrer
47.		[16]	David Ferrer		6-2 6-7(5) 6-2 6-2
				David Ferrer
48.			Kristian Pless	7-5 6-4 6-3
								Andy Roddick
49.		[9]	Mario Ancic					6-2 6-2 6-2
				Mario Ancic
50.		[WC]	Go Soeda	6-4 6-3 6-2
					Mario Ancic
51.			Guillermo Garcia-Lopez		3-6 7-5 6-2 6-2
				Guillermo Garcia-Lopez
52.			Joachim Johansson	1-1 rtd.
						Mario Ancic
53.			Vince Spadea			6-3 6-2 6-1
				Vince Spadea
54.			Igor Andreev	6-2 7-6(3) 6-1
					Dominik Hrbaty
55.		[22]	Dominik Hrbaty		5-7 6-4 6-4 6-3
				Dominik Hrbaty
56.			Jiri Vanek	6-7(7) 7-6(1) 6-1 6-3
							Andy Roddick
57.		[26]	Marat Safin				6-3 3-6 6-1 5-7 6-4
				Marat Safin
58.			Benjamin Becker	5-7 7-6(2) 3-6 6-3 6-4
					Marat Safin
59.			Dudi Sela		6-3 5-7 4-6 7-6(4) 6-0
				Dudi Sela
60.			Paradorn Srichaphan	6-4 6-2 6-2
						Andy Roddick
61.			Marc Gicquel			7-6(2) 2-6 6-4 7-6(2)
				Marc Gicquel
62.		[WC]	Alun Jones	3-6 6-7(1) 6-4 6-1 6-0
					Andy Roddick
63.		[6]	Andy Roddick		6-0 rtd.
				Andy Roddick
64.		[WC]	Jo-Wilfried Tsonga	6-7(18) 7-6(2) 6-3 6-3
										Roger Federer
65.		[8]	David Nalbandian							7-6(2) 6-4 6-4
				David Nalbandian
66.			Janko Tipsarevic	6-7(5) 4-6 7-6(2) 6-0 2-1 rtd.
					David Nalbandian
67.			Nicolas Lapentti		6-4 6-4 6-4
				Nicolas Lapentti
68.		[Q]	Alan Mackin	6-4 6-4 6-2
						David Nalbandian
69.			Olivier Rochus			5-7 4-6 7-6(4) 6-4 6-1
				Olivier Rochus
70.		[WC]	Chris Guccione	3-6 7-5 7-5 6-7(4) 9-7
					Sebastien Grosjean
71.		[28]	Sebastien Grosjean		4-6 6-1 6-3 4-6 6-4
				Sebastien Grosjean
72.			Christophe Rochus	6-2 4-1 rtd.
							Tommy Haas
73.			Florian Mayer				4-6 6-3 6-2 6-3
				Florian Mayer
74.		[23]	Robin Soderling	3-6 6-4 3-6 6-4 6-0
					Florian Mayer
75.			Andreas Seppi		5-7 7-5 6-2 6-2
				Andreas Seppi
76.		[Q]	Bobby Reynolds	6-1 6-7(4) 6-7(5) 7-6(3) 6-3
						Tommy Haas
77.		[Q]	Ilija Bozoljac			7-6(3) 6-3 6-3
				Ilija Bozoljac
78.		[Q]	Marin Cilic	6-2 6-4 6-1
					Tommy Haas
79.		[12]	Tommy Haas		7-6(3) 6-1 6-3
				Tommy Haas
80.			Albert Montanes	7-5 6-1 7-6(3)
								Tommy Haas
81.		[13]	Tomas Berdych					6-3 2-6 1-6 6-1 7-5
				Tomas Berdych
82.			Hyung-Taik Lee	6-1 6-2 6-2
					Tomas Berdych
83.		[WC]	Robert Smeets		6-3 6-2 6-4
				Robert Smeets
84.		[Q]	Lukas Lacko	6-2 3-6 6-1 6-4
						Tomas Berdych
85.			Max Mirnyi			6-2 6-1 6-1
				Max Mirnyi
86.			Luis Horna	7-6(4) 3-6 2-6 6-4 6-4
					Dmitry Tursunov
87.		[21]	Dmitry Tursunov		6-2 6-3 7-6(4)
				Dmitry Tursunov
88.		[Q]	Alexander Waske	5-7 6-4 6-3 6-4
							Nikolay Davydenko
89.			Arnaud Clement				5-7 6-4 6-1 7-6(5)
				Arnaud Clement
90.		[29]	Xavier Malisse	6-3 3-6 7-5 6-4
					Fabrice Santoro
91.			Fabrice Santoro		6-2 6-4 6-4
				Fabrice Santoro
92.			Igor Kunitsyn	7-6(5) 6-3 6-0
						Nikolay Davydenko
93.			Gilles Muller			7-6(1) 6-2 6-2
				Gilles Muller
94.			Gaston Gaudio	6-0 4-6 6-2 6-3
					Nikolay Davydenko
95.		[3]	Nikolay Davydenko		6-4 6-0 6-3
				Nikolay Davydenko
96.			Sergio Roitman	6-2 7-5 6-2
									Fernando Gonzalez
97.		[5]	James Blake						6-1 6-3 6-1
				James Blake
98.			Carlos Moya	7-6(8) 6-2 6-4
					James Blake
99.		[Q]	Alex Kuznetsov		6-4 6-1 6-2
				Alex Kuznetsov
100.		[WC]	Peter Luczak	6-4 5-7 6-7(5) 6-1 6-4
						James Blake
101.		[Q]	Mischa Zverev			7-6(7) 7-5 6-2
				Mischa Zverev
102.		[Q]	Michael Berrer	6-4 7-6(1) 3-6 6-4
					Robby Ginepri
103.			Robby Ginepri		6-4 7-5 6-1
				Robby Ginepri
104.		[32]	Nicolas Almagro	4-6 6-2 4-6 7-5 6-3
							Fernando Gonzalez
105.		[19]	Lleyton Hewitt				7-5 6-4 7-6(4)
				Lleyton Hewitt
106.		[Q]	Michael Russell	3-6 2-6 6-3 6-3 6-3
					Lleyton Hewitt
107.			Frank Dancevic		6-4 6-4 3-6 6-4
				Frank Dancevic
108.			Victor Hanescu	6-3 6-3 7-6(6)
						Fernando Gonzalez
109.			Juan Martin Del Potro			6-2 6-2 5-7 6-4
				Juan Martin Del Potro
110.			Alessio Di Mauro	6-3 6-3 6-1
					Fernando Gonzalez
111.		[10]	Fernando Gonzalez		7-6(7) 4-6 6-7(3) 6-4 4-0 rtd.
				Fernando Gonzalez
112.			Evgeny Korolev	6-7(4) 7-6(6) 6-3 6-2
								Fernando Gonzalez
113.		[15]	Andy Murray					6-2 6-4 6-3
				Andy Murray
114.			Alberto Martin	6-0 6-0 6-1
					Andy Murray
115.			Fernando Verdasco		7-6(4) 7-5 6-4
				Fernando Verdasco
116.			Paul-Henri Mathieu	6-7(5) 4-6 6-6(1-3) rtd.
						Andy Murray
117.		[Q]	Juan Ignacio Chela			6-3 6-2 6-4
				Juan Ignacio Chela
118.			Potito Starace	7-6(5) 6-4 6-4
					Juan Ignacio Chela
119.		[17]	Jarkko Nieminen		6-3 2-6 6-4 6-4
				Jarkko Nieminen
120.			Paul Goldstein	5-7 6-2 7-6(4) 6-4
							Rafael Nadal
121.		[31]	Stan Wawrinka				6-7(3) 6-4 4-6 6-3 6-1
				Stan Wawrinka
122.			Kevin Kim	6-1 2-6 6-4 6-2
					Stan Wawrinka
123.		[Q]	Paul Capdeville		6-4 6-3 6-2
				Paul Capdeville
124.			Julien Benneteau	4-6 6-7(4) 6-2 6-1 6-2
						Rafael Nadal
125.			Philipp Kohlschreiber			6-2 6-2 6-2
				Philipp Kohlschreiber
126.			Kristof Vliegen	5-7 6-3 6-2 6-4
					Rafael Nadal
127.		[2]	Rafael Nadal		7-5 6-3 4-6 6-2
				Rafael Nadal
128.			Robert Kendrick	7-6(6) 6-3 6-2

(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	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` = '2007' 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` = (292) 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, 151, 5726, 7233, 125, 5052, 72, 7269, 93, 5936, 101, 7295, 171, 7834, 52, 7292, 158, 4209, 99, 7264, 7284, 100, 75, 61, 137, 7298, 126, 7271, 140, 141, 5051, 3726, 116, 172, 58, 123, 6255, 6250, 7759, 7314, 59, 88, 7280, 7291, 5723, 5050, 83, 7277, 7255, 3721, 94, 7466, 6169, 3591, 6230, 6281, 6260, 159, 97, 6276, 4926, 7334, 67, 115, 167, 68, 6181, 7753, 150, 7308, 6256, 6290, 3583, 7248, 74, 4927, 7836, 3722, 176, 120, 148, 7266, 7758, 173, 6295, 7247, 69, 7261, 5932, 86, 4129, 78, 117, 6284, 169, 7209, 3578, 6190, 178, 4210, 7301, 4212, 4776, 163, 65, 77, 4771, 135, 131, 7754, 7327, 7323, 84, 6223, 139, 3590, 76, 57, 166, 6248, 156, 7265, 7312, 102, 122, 7241, 179, 5054) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	128	128	4
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` = 292	128	128	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (164, 92, 68, 53, 13, 197, 154, 10, 173, 196, 21, 91, 184, 111, 72, 181, 153, 14, 50, 179, 52, 67, 27, 168, 94, 36, 178, 58, 20, 147, 100, 54, 41, 96)	34	34	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (164, 92, 68, 53, 13, 197, 154, 10, 173, 196, 21, 91, 184, 111, 72, 181, 153, 14, 50, 179, 52, 67, 27, 168, 94, 36, 178, 58, 20, 147, 100, 54, 41, 96)	34	34	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (147, 151, 5726, 7233, 125, 5052, 72, 7269, 93, 5936, 101, 7295, 171, 7834, 52, 7292, 158, 4209, 99, 7264, 7284, 100, 75, 61, 137, 7298, 126, 7271, 140, 141, 5051, 3726, 116, 172, 58, 123, 6255, 6250, 7759, 7314, 59, 88, 7280, 7291, 5723, 5050, 83, 7277, 7255, 3721, 94, 7466, 6169, 3591, 6230, 6281, 6260, 159, 97, 6276, 4926, 7334, 67, 115, 167, 68, 6181, 7753, 150, 7308, 6256, 6290, 3583, 7248, 74, 4927, 7836, 3722, 176, 120, 148, 7266, 7758, 173, 6295, 7247, 69, 7261, 5932, 86, 4129, 78, 117, 6284, 169, 7209, 3578, 6190, 178, 4210, 7301, 4212, 4776, 163, 65, 77, 4771, 135, 131, 7754, 7327, 7323, 84, 6223, 139, 3590, 76, 57, 166, 6248, 156, 7265, 7312, 102, 122, 7241, 179, 5054)) AND (`Playercontest`.`contest_id` = 292))	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` = 2007	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` = '2007' 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` = (292) 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, 151, 5726, 7233, 125, 5052, 72, 7269, 93, 5936, 101, 7295, 171, 7834, 52, 7292, 158, 4209, 99, 7264, 7284, 100, 75, 61, 137, 7298, 126, 7271, 140, 141, 5051, 3726, 116, 172, 58, 123, 6255, 6250, 7759, 7314, 59, 88, 7280, 7291, 5723, 5050, 83, 7277, 7255, 3721, 94, 7466, 6169, 3591, 6230, 6281, 6260, 159, 97, 6276, 4926, 7334, 67, 115, 167, 68, 6181, 7753, 150, 7308, 6256, 6290, 3583, 7248, 74, 4927, 7836, 3722, 176, 120, 148, 7266, 7758, 173, 6295, 7247, 69, 7261, 5932, 86, 4129, 78, 117, 6284, 169, 7209, 3578, 6190, 178, 4210, 7301, 4212, 4776, 163, 65, 77, 4771, 135, 131, 7754, 7327, 7323, 84, 6223, 139, 3590, 76, 57, 166, 6248, 156, 7265, 7312, 102, 122, 7241, 179, 5054) 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` = 292

128

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (164, 92, 68, 53, 13, 197, 154, 10, 173, 196, 21, 91, 184, 111, 72, 181, 153, 14, 50, 179, 52, 67, 27, 168, 94, 36, 178, 58, 20, 147, 100, 54, 41, 96)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (164, 92, 68, 53, 13, 197, 154, 10, 173, 196, 21, 91, 184, 111, 72, 181, 153, 14, 50, 179, 52, 67, 27, 168, 94, 36, 178, 58, 20, 147, 100, 54, 41, 96)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (147, 151, 5726, 7233, 125, 5052, 72, 7269, 93, 5936, 101, 7295, 171, 7834, 52, 7292, 158, 4209, 99, 7264, 7284, 100, 75, 61, 137, 7298, 126, 7271, 140, 141, 5051, 3726, 116, 172, 58, 123, 6255, 6250, 7759, 7314, 59, 88, 7280, 7291, 5723, 5050, 83, 7277, 7255, 3721, 94, 7466, 6169, 3591, 6230, 6281, 6260, 159, 97, 6276, 4926, 7334, 67, 115, 167, 68, 6181, 7753, 150, 7308, 6256, 6290, 3583, 7248, 74, 4927, 7836, 3722, 176, 120, 148, 7266, 7758, 173, 6295, 7247, 69, 7261, 5932, 86, 4129, 78, 117, 6284, 169, 7209, 3578, 6190, 178, 4210, 7301, 4212, 4776, 163, 65, 77, 4771, 135, 131, 7754, 7327, 7323, 84, 6223, 139, 3590, 76, 57, 166, 6248, 156, 7265, 7312, 102, 122, 7241, 179, 5054)) AND (`Playercontest`.`contest_id` = 292))

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

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)