Australian Open 2020 Men's Singles (January 20 - February 2)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Rafael Nadal
				Rafael Nadal
2.			Hugo Dellien	6-2 6-3 6-0
					Rafael Nadal
3.			Federico Delbonis		6-3 7-6(4) 6-1
				Federico Delbonis
4.			Joao Sousa	6-3 6-4 7-6(3)
						Rafael Nadal
5.		[Q]	Peter Gojowczyk			6-1 6-2 6-4
				Peter Gojowczyk
6.		[Q]	Christopher Eubanks	7-6(1) 6-3 4-6 6-0
					Pablo Carreno Busta
7.		[27]	Pablo Carreno Busta		6-4 6-1 1-6 6-4
				Pablo Carreno Busta
8.		[LL]	Jozef Kovalik	6-4 3-6 6-1 7-6(2)
							Rafael Nadal
9.		[23]	Nick Kyrgios				6-3 3-6 7-6(6) 7-6(4)
				Nick Kyrgios
10.			Lorenzo Sonego	6-2 7-6(3) 7-6(1)
					Nick Kyrgios
11.			Gilles Simon		6-2 6-4 4-6 7-5
				Gilles Simon
12.			Pablo Cuevas	6-1 6-3 6-3
						Nick Kyrgios
13.			Mikael Ymer			6-2 7-6(5) 6-7(6) 6-7(7) 7-6(8)
				Mikael Ymer
14.			Yasutaka Uchiyama	6-4 6-1 6-2
					Karen Khachanov
15.		[16]	Karen Khachanov		6-2 2-6 6-4 3-6 7-6(8)
				Karen Khachanov
16.		[Q]	Mario Viella Martinez	4-6 6-4 7-6(4) 6-3
								Dominic Thiem
17.			Gael Monfils					7-6(3) 7-6(4) 4-6 7-6(6)
				Gael Monfils
18.			Yen-Hsun Lu	6-1 6-4 6-2
					Gael Monfils
19.			Ivo Karlovic		4-6 7-6(8) 6-4 7-5
				Ivo Karlovic
20.			Vasek Pospisil	7-6(4) 6-4 7-5
						Gael Monfils
21.			Aljaz Bedene			7-6(2) 6-4 6-3
				Aljaz Bedene
22.			James Duckworth	6-4 6-7(5) 6-7(5) 6-2 6-4
					Ernests Gulbis
23.		[Q]	Ernests Gulbis		7-5 6-3 6-2
				Ernests Gulbis
24.		[20]	Felix Auger-Aliassime	7-5 4-6 7-6(4) 6-4
							Dominic Thiem
25.		[29]	Taylor Fritz				6-2 6-4 6-4
				Taylor Fritz
26.		[Q]	Tallon Griekspoor	6-3 6-3 6-3
					Taylor Fritz
27.			Kevin Anderson		4-6 6-7(5) 7-6(4) 6-2 6-2
				Kevin Anderson
28.		[Q]	Ilya Ivashka	6-4 2-6 4-6 6-4 7-6(8)
						Dominic Thiem
29.		[WC]	Alex Bolt			6-2 6-4 6-7(5) 6-4
				Alex Bolt
30.			Albert Ramos-Vinolas	7-6(1) 1-6 6-7(5) 6-1 6-4
					Dominic Thiem
31.		[5]	Dominic Thiem		6-2 5-7 6-7(5) 6-1 6-2
				Dominic Thiem
32.			Adrian Mannarino	6-3 7-5 6-2
									Dominic Thiem
33.		[4]	Daniil Medvedev						3-6 6-4 7-6(3) 7-6(4)
				Daniil Medvedev
34.			Frances Tiafoe	6-3 4-6 6-4 6-2
					Daniil Medvedev
35.		[Q]	Pedro Martinez		7-5 6-1 6-3
				Pedro Martinez
36.			Dominik Koepfer	6-3 6-4 7-5
						Daniil Medvedev
37.			Jaume Munar			6-4 6-3 6-2
				Jaume Munar
38.		[WC]	Hugo Gaston	7-5 5-7 6-0 6-3
					Alexei Popyrin
39.			Alexei Popyrin		6-2 7-6(5) 6-2
				Alexei Popyrin
40.		[28]	Jo-Wilfried Tsonga	6-7(5) 6-2 6-1 0-0 rtd.
							Stan Wawrinka
41.		[19]	John Isner				6-2 2-6 4-6 7-6(2) 6-2
				John Isner
42.			Thiago Monteiro	6-7(5) 7-6(4) 7-6(7) 7-6(5)
					John Isner
43.		[Q]	Alejandro Tabilo		6-4 6-3 6-3
				Alejandro Tabilo
44.		[Q]	Daniel Elahi Galan	4-6 6-3 6-4 6-7(6) 6-4
						Stan Wawrinka
45.			Andreas Seppi			6-4 4-1 rtd.
				Andreas Seppi
46.			Miomir Kecmanovic	6-4 6-4 7-6(3)
					Stan Wawrinka
47.		[15]	Stan Wawrinka		4-6 7-5 6-3 3-6 6-4
				Stan Wawrinka
48.			Damir Dzumhur	7-5 6-7(4) 6-4 6-4
								Alexander Zverev
49.		[11]	David Goffin					1-6 6-3 6-4 6-2
				David Goffin
50.			Jeremy Chardy	6-4 6-3 6-1
					David Goffin
51.			Pierre-Hugues Herbert		6-1 6-4 4-6 1-6 6-3
				Pierre-Hugues Herbert
52.			Cameron Norrie	7-5 3-6 3-6 7-5 6-4
						Andrey Rublev
53.			Yuichi Sugita			2-6 7-6(3) 6-4 7-6(4)
				Yuichi Sugita
54.			Elliot Benchetrit	6-2 6-0 6-3
					Andrey Rublev
55.		[17]	Andrey Rublev		6-2 6-3 7-6(5)
				Andrey Rublev
56.		[WC]	Christopher O'Connell	6-3 0-6 6-4 7-6(5)
							Alexander Zverev
57.		[26]	Nikoloz Basilashvili				6-4 6-4 6-4
				Nikoloz Basilashvili
58.			Soon-woo Kwon	6-7(5) 6-4 7-5 3-6 6-3
					Fernando Verdasco
59.			Fernando Verdasco		4-6 7-6(5) 6-4 6-4
				Fernando Verdasco
60.			Evgeny Donskoy	7-5 6-2 6-1
						Alexander Zverev
61.			Egor Gerasimov			6-2 6-2 6-4
				Egor Gerasimov
62.			Casper Ruud	6-3 7-6(6) 1-6 4-6 7-6(6)
					Alexander Zverev
63.		[7]	Alexander Zverev		7-6(5) 6-4 7-5
				Alexander Zverev
64.			Marco Cecchinato	6-4 7-6(4) 6-3
										Novak Djokovic
65.		[8]	Matteo Berrettini							6-4 4-6 2-6 6-3 6-4
				Matteo Berrettini
66.		[WC]	Andrew Harris	6-3 6-1 6-3
					Tennys Sandgren
67.			Tennys Sandgren		7-6(7) 6-4 4-6 2-6 7-5
				Tennys Sandgren
68.			Marco Trungelliti	6-1 6-4 7-5
						Tennys Sandgren
69.			Ricardas Berankis			6-4 6-4 6-4
				Ricardas Berankis
70.			Roberto Carballes Baena	6-4 6-2 6-2
					Sam Querrey
71.			Sam Querrey		7-6(2) 4-6 6-4 6-4
				Sam Querrey
72.		[25]	Borna Coric	6-3 6-4 6-4
							Tennys Sandgren
73.			Guido Pella				7-6(5) 7-5 6-7(2) 6-4
				Guido Pella
74.		[WC]	John-Patrick Smith	6-3 7-5 6-4
					Guido Pella
75.			Gregoire Barrere		6-1 6-4 3-6 6-3
				Gregoire Barrere
76.			Mohamed Safwat	6-7(8) 7-6(1) 6-4 7-6(5)
						Fabio Fognini
77.			Jordan Thompson			7-6(0) 6-2 6-3
				Jordan Thompson
78.			Alexander Bublik	6-4 6-3 6-2
					Fabio Fognini
79.		[12]	Fabio Fognini		7-6(4) 6-1 3-6 4-6 7-6(4)
				Fabio Fognini
80.			Reilly Opelka	3-6 6-7(3) 6-4 6-3 7-6(5)
								Roger Federer
81.			Marton Fucsovics					6-3 2-6 2-6 7-6(8) 6-3
				Marton Fucsovics
82.		[13]	Denis Shapovalov	6-3 6-7(7) 6-1 7-6(3)
					Marton Fucsovics
83.			Jannik Sinner		6-4 6-4 6-3
				Jannik Sinner
84.		[Q]	Max Purcell	7-6(2) 6-2 6-4
						Marton Fucsovics
85.			Tommy Paul			6-1 6-1 6-4
				Tommy Paul
86.			Leonardo Mayer	4-6 6-4 6-4 6-4
					Tommy Paul
87.		[18]	Grigor Dimitrov		6-4 7-6(6) 3-6 6-7(3) 7-6(3)
				Grigor Dimitrov
88.			Juan Londero	4-6 6-2 6-0 6-4
							Roger Federer
89.		[31]	Hubert Hurkacz				4-6 6-1 6-2 6-2
				Hubert Hurkacz
90.		[Q]	Dennis Novak	6-7(4) 1-6 6-2 6-3 6-4
					John Millman
91.			John Millman		6-4 7-5 6-3
				John Millman
92.			Ugo Humbert	7-6(3) 6-3 1-6 7-5
						Roger Federer
93.			Filip Krajinovic			4-6 7-6(2) 6-4 4-6 7-6(8)
				Filip Krajinovic
94.		[Q]	Quentin Halys	7-6(7) 7-6(1) 3-6 4-6 7-5
					Roger Federer
95.		[3]	Roger Federer		6-1 6-4 6-1
				Roger Federer
96.			Steve Johnson	6-3 6-2 6-2
									Novak Djokovic
97.		[6]	Stefanos Tsitsipas						7-6(1) 6-4 6-3
				Stefanos Tsitsipas
98.			Salvatore Caruso	6-0 6-2 6-3
					Stefanos Tsitsipas
99.			Philipp Kohlschreiber		w/o
				Philipp Kohlschreiber
100.			Marcos Giron	7-5 6-1 6-2
						Milos Raonic
101.			Cristian Garin			7-5 6-4 7-6(2)
				Cristian Garin
102.			Stefano Travaglia	6-4 6-3 6-4
					Milos Raonic
103.		[32]	Milos Raonic		6-3 6-4 6-2
				Milos Raonic
104.		[LL]	Lorenzo Giustino	6-2 6-1 6-3
							Milos Raonic
105.		[21]	Benoit Paire				6-4 6-3 7-5
				Benoit Paire
106.			Cedrik-Marcel Stebe	6-4 3-6 6-3 6-7(2) 6-0
					Marin Cilic
107.			Marin Cilic		6-2 6-7(6) 3-6 6-1 7-6(3)
				Marin Cilic
108.			Corentin Moutet	6-3 6-2 6-4
						Marin Cilic
109.		[WC]	Michael Mmoh			6-7(3) 6-4 6-0 5-7 6-3
				Michael Mmoh
110.			Pablo Andujar	6-1 6-4 6-4
					Roberto Bautista Agut
111.		[9]	Roberto Bautista Agut		5-7 6-2 6-4 6-1
				Roberto Bautista Agut
112.			Feliciano Lopez	6-2 6-2 7-5
								Novak Djokovic
113.		[14]	Diego Schwartzman					6-4 6-3 7-6(1)
				Diego Schwartzman
114.			Lloyd Harris	6-4 6-2 6-2
					Diego Schwartzman
115.			Alejandro Davidovich Fokina		6-1 6-4 6-2
				Alejandro Davidovich Fokina
116.		[Q]	Norbert Gombos	4-6 6-4 2-6 6-3 6-2
						Diego Schwartzman
117.		[WC]	Marc Polmans			6-2 6-3 7-6(7)
				Marc Polmans
118.			Mikhail Kukushkin	6-4 6-3 4-6 6-7(8) 6-4
					Dusan Lajovic
119.		[24]	Dusan Lajovic		6-2 6-4 6-3
				Dusan Lajovic
120.			Kyle Edmund	7-6(7) 6-3 7-6(4)
							Novak Djokovic
121.		[30]	Daniel Evans				6-3 6-4 6-4
				Daniel Evans
122.			Mackenzie McDonald	3-6 4-6 6-1 6-2 6-3
					Yoshihito Nishioka
123.			Yoshihito Nishioka		6-4 6-3 6-4
				Yoshihito Nishioka
124.			Laslo Djere	6-4 3-6 6-2 7-6(1)
						Novak Djokovic
125.		[WC]	Tatsuma Ito			6-3 6-2 6-2
				Tatsuma Ito
126.		[LL]	Prajnesh Gunneswaran	6-4 6-2 7-5
					Novak Djokovic
127.		[2]	Novak Djokovic		6-1 6-4 6-2
				Novak Djokovic
128.			Jan-Lennard Struff	7-6(5) 6-2 2-6 6-1

(default) 17 queries took 28 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	6
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` = '2020' 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` = (2273) 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 (179, 14390, 11454, 13674, 174, 14312, 11461, 14175, 10252, 14267, 100, 5934, 14387, 14393, 14224, 14413, 99, 125, 141, 3723, 10225, 71, 89, 14330, 14178, 14414, 155, 14222, 10229, 149, 13580, 130, 14237, 14087, 14386, 14396, 14265, 14410, 14266, 115, 164, 14236, 14415, 14416, 74, 14347, 156, 13567, 3725, 160, 8702, 14248, 13625, 14271, 14154, 14239, 14122, 14268, 139, 10178, 14403, 14258, 14136, 14146, 14263, 14411, 14084, 14176, 8674, 14196, 137, 13870, 6780, 9301, 14194, 14272, 13568, 14235, 119, 14238, 14221, 14252, 14400, 14417, 14153, 170, 161, 14391, 14270, 14259, 10177, 14333, 8925, 14125, 147, 4775, 14245, 14260, 122, 13867, 14256, 14255, 60, 14423, 157, 64, 3722, 14261, 14086, 79, 113, 171, 13616, 14332, 14389, 14253, 14349, 95, 13562, 11473, 9051, 14220, 13874, 14197, 56, 14348, 52, 11457) 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` = 2273	128	128	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (68, 197, 13, 14, 196, 94, 173, 29, 154, 10, 181, 164, 100, 96, 168, 72, 50, 20, 149, 172, 86, 104, 133, 21, 92, 41, 43, 84, 179, 27, 31, 26, 198, 110, 169, 71, 36, 139, 59, 150, 74, 178)	42	42	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (68, 197, 13, 14, 196, 94, 173, 29, 154, 10, 181, 164, 100, 96, 168, 72, 50, 20, 149, 172, 86, 104, 133, 21, 92, 41, 43, 84, 179, 27, 31, 26, 198, 110, 169, 71, 36, 139, 59, 150, 74, 178)	42	42	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (179, 14390, 11454, 13674, 174, 14312, 11461, 14175, 10252, 14267, 100, 5934, 14387, 14393, 14224, 14413, 99, 125, 141, 3723, 10225, 71, 89, 14330, 14178, 14414, 155, 14222, 10229, 149, 13580, 130, 14237, 14087, 14386, 14396, 14265, 14410, 14266, 115, 164, 14236, 14415, 14416, 74, 14347, 156, 13567, 3725, 160, 8702, 14248, 13625, 14271, 14154, 14239, 14122, 14268, 139, 10178, 14403, 14258, 14136, 14146, 14263, 14411, 14084, 14176, 8674, 14196, 137, 13870, 6780, 9301, 14194, 14272, 13568, 14235, 119, 14238, 14221, 14252, 14400, 14417, 14153, 170, 161, 14391, 14270, 14259, 10177, 14333, 8925, 14125, 147, 4775, 14245, 14260, 122, 13867, 14256, 14255, 60, 14423, 157, 64, 3722, 14261, 14086, 79, 113, 171, 13616, 14332, 14389, 14253, 14349, 95, 13562, 11473, 9051, 14220, 13874, 14197, 56, 14348, 52, 11457)) AND (`Playercontest`.`contest_id` = 2273))	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` = 2020	8	8	1
16	SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (1, 3, 22, 24, 12, 14, 4, 2) AND `Category`.`gender` = 'Men' AND `Category`.`type` = 'Singles'	3	3	1
17	SELECT `Tournament`.`slug`, `Tournament`.`name` FROM `zavoihu1_db4tennis`.`tournaments` AS `Tournament` WHERE `Tournament`.`id` IN (1, 2, 4)	3	3	1

(default) 17 queries took 28 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` = '2020' 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` = (2273) 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 (179, 14390, 11454, 13674, 174, 14312, 11461, 14175, 10252, 14267, 100, 5934, 14387, 14393, 14224, 14413, 99, 125, 141, 3723, 10225, 71, 89, 14330, 14178, 14414, 155, 14222, 10229, 149, 13580, 130, 14237, 14087, 14386, 14396, 14265, 14410, 14266, 115, 164, 14236, 14415, 14416, 74, 14347, 156, 13567, 3725, 160, 8702, 14248, 13625, 14271, 14154, 14239, 14122, 14268, 139, 10178, 14403, 14258, 14136, 14146, 14263, 14411, 14084, 14176, 8674, 14196, 137, 13870, 6780, 9301, 14194, 14272, 13568, 14235, 119, 14238, 14221, 14252, 14400, 14417, 14153, 170, 161, 14391, 14270, 14259, 10177, 14333, 8925, 14125, 147, 4775, 14245, 14260, 122, 13867, 14256, 14255, 60, 14423, 157, 64, 3722, 14261, 14086, 79, 113, 171, 13616, 14332, 14389, 14253, 14349, 95, 13562, 11473, 9051, 14220, 13874, 14197, 56, 14348, 52, 11457) 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` = 2273

128

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (68, 197, 13, 14, 196, 94, 173, 29, 154, 10, 181, 164, 100, 96, 168, 72, 50, 20, 149, 172, 86, 104, 133, 21, 92, 41, 43, 84, 179, 27, 31, 26, 198, 110, 169, 71, 36, 139, 59, 150, 74, 178)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (68, 197, 13, 14, 196, 94, 173, 29, 154, 10, 181, 164, 100, 96, 168, 72, 50, 20, 149, 172, 86, 104, 133, 21, 92, 41, 43, 84, 179, 27, 31, 26, 198, 110, 169, 71, 36, 139, 59, 150, 74, 178)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (179, 14390, 11454, 13674, 174, 14312, 11461, 14175, 10252, 14267, 100, 5934, 14387, 14393, 14224, 14413, 99, 125, 141, 3723, 10225, 71, 89, 14330, 14178, 14414, 155, 14222, 10229, 149, 13580, 130, 14237, 14087, 14386, 14396, 14265, 14410, 14266, 115, 164, 14236, 14415, 14416, 74, 14347, 156, 13567, 3725, 160, 8702, 14248, 13625, 14271, 14154, 14239, 14122, 14268, 139, 10178, 14403, 14258, 14136, 14146, 14263, 14411, 14084, 14176, 8674, 14196, 137, 13870, 6780, 9301, 14194, 14272, 13568, 14235, 119, 14238, 14221, 14252, 14400, 14417, 14153, 170, 161, 14391, 14270, 14259, 10177, 14333, 8925, 14125, 147, 4775, 14245, 14260, 122, 13867, 14256, 14255, 60, 14423, 157, 64, 3722, 14261, 14086, 79, 113, 171, 13616, 14332, 14389, 14253, 14349, 95, 13562, 11473, 9051, 14220, 13874, 14197, 56, 14348, 52, 11457)) AND (`Playercontest`.`contest_id` = 2273))

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

SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (1, 3, 22, 24, 12, 14, 4, 2) 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, 4)