Wimbledon 2019 Gentlemen's Singles (July 1 - July 14)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Novak Djokovic
				Novak Djokovic
2.			Philipp Kohlschreiber	6-3 7-5 6-3
					Novak Djokovic
3.			Denis Kudla		6-3 6-2 6-2
				Denis Kudla
4.			Malek Jaziri	6-4 6-1 6-3
						Novak Djokovic
5.			Leonardo Mayer			7-5 6-7(5) 6-1 6-4
				Leonardo Mayer
6.			Ernests Gulbis	6-1 7-6(12) 6-2
					Hubert Hurkacz
7.			Hubert Hurkacz		6-7(4) 6-1 7-6(7) 6-3
				Hubert Hurkacz
8.		[32]	Dusan Lajovic	6-3 4-6 6-4 6-4
							Novak Djokovic
9.		[19]	Felix Auger-Aliassime				6-3 6-2 6-3
				Felix Auger-Aliassime
10.			Vasek Pospisil	5-7 6-2 6-4 6-3
					Felix Auger-Aliassime
11.		[Q]	Corentin Moutet		6-3 4-6 6-4 6-2
				Corentin Moutet
12.			Grigor Dimitrov	2-6 3-6 7-6(4) 6-3 6-1
						Ugo Humbert
13.		[Q]	Marcel Granollers			6-4 7-5 6-3
				Marcel Granollers
14.			Lorenzo Sonego	7-6(4) 6-4 6-4
					Ugo Humbert
15.			Ugo Humbert		6-4 7-6(3) 7-5
				Ugo Humbert
16.		[16]	Gael Monfils	6-7(6) 3-6 6-4 7-5 3-0 rtd.
								Novak Djokovic
17.		[11]	Daniil Medvedev					6-4 6-0 6-2
				Daniil Medvedev
18.			Paolo Lorenzi	6-3 7-6(2) 7-6(2)
					Daniil Medvedev
19.		[Q]	Alexei Popyrin		6-7(6) 6-1 6-4 6-4
				Alexei Popyrin
20.			Pablo Carreno Busta	7-6(2) 7-5 6-2
						David Goffin
21.			Jeremy Chardy			4-6 6-2 3-6 6-3 7-5
				Jeremy Chardy
22.			Martin Klizan	3-6 6-0 6-3 6-4
					David Goffin
23.		[21]	David Goffin		6-2 6-4 6-3
				David Goffin
24.			Bradley Klahn	6-4 6-4 6-4
							David Goffin
25.		[30]	Kyle Edmund				7-6(9) 2-6 6-3 6-4
				Kyle Edmund
26.			Jaume Munar	6-4 6-4 6-4
					Fernando Verdasco
27.			Fernando Verdasco		4-6 4-6 7-6(3) 6-3 6-4
				Fernando Verdasco
28.		[Q]	Kamil Majchrzak	6-4 6-4 6-4
						Fernando Verdasco
29.			Ivo Karlovic			6-4 7-6(1) 6-4
				Ivo Karlovic
30.		[Q]	Andrea Arnaboldi	6-4 6-4 7-6(4)
					Thomas Fabbiano
31.			Thomas Fabbiano		6-3 6-7(6) 6-3 6-7(4) 6-4
				Thomas Fabbiano
32.		[7]	Stefanos Tsitsipas	6-4 3-6 6-4 6-7(8) 6-3
									Novak Djokovic
33.		[4]	Kevin Anderson						6-2 4-6 6-3 6-2
				Kevin Anderson
34.			Pierre-Hugues Herbert	6-3 6-4 6-2
					Kevin Anderson
35.			Janko Tipsarevic		6-4 6-7(5) 6-1 6-4
				Janko Tipsarevic
36.			Yoshihito Nishioka	6-4 6-7(2) 6-2 5-7 6-2
						Guido Pella
37.			Andreas Seppi			6-4 6-3 7-6(4)
				Andreas Seppi
38.			Nicolas Jarry	6-3 6-7(8) 6-1 6-2
					Guido Pella
39.		[26]	Guido Pella		6-4 4-6 4-6 7-5 6-1
				Guido Pella
40.			Marius Copil	7-6(11) 5-7 6-3 6-4
							Guido Pella
41.		[22]	Stan Wawrinka				3-6 4-6 6-3 7-6(3) 8-6
				Stan Wawrinka
42.		[Q]	Ruben Bemelmans	6-3 6-2 6-2
					Reilly Opelka
43.			Reilly Opelka		7-5 3-6 4-6 6-4 8-6
				Reilly Opelka
44.			Cedrik-Marcel Stebe	6-3 7-6(4) 6-1
						Milos Raonic
45.			Robin Haase			7-6(1) 6-2 6-1
				Robin Haase
46.			Jozef Kovalik	6-1 6-3 6-1
					Milos Raonic
47.		[15]	Milos Raonic		7-6(1) 7-5 7-6(4)
				Milos Raonic
48.			Prajnesh Gunneswaran	7-6(1) 6-4 6-2
								Roberto Bautista Agut
49.		[10]	Karen Khachanov					7-5 6-4 3-6 6-3
				Karen Khachanov
50.		[Q]	Soon-woo Kwon	7-6(6) 6-4 4-6 7-5
					Karen Khachanov
51.		[WC]	Feliciano Lopez		4-6 6-4 7-5 6-4
				Feliciano Lopez
52.		[Q]	Marcos Giron	6-4 6-2 6-4
						Roberto Bautista Agut
53.			Steve Darcis			6-3 7-6(3) 6-1
				Steve Darcis
54.			Mischa Zverev	6-2 6-4 6-4
					Roberto Bautista Agut
55.		[23]	Roberto Bautista Agut		6-3 6-2 4-2 rtd.
				Roberto Bautista Agut
56.			Peter Gojowczyk	6-3 6-2 6-3
							Roberto Bautista Agut
57.		[28]	Benoit Paire				6-3 7-5 6-2
				Benoit Paire
58.			Juan Londero	4-6 6-4 6-4 7-6(4)
					Benoit Paire
59.			Miomir Kecmanovic		7-6(5) 6-4 rtd.
				Miomir Kecmanovic
60.			Roberto Carballes Baena	2-6 6-3 6-3 6-1
						Benoit Paire
61.			Pablo Cuevas			5-7 7-6(5) 6-3 7-6(2)
				Pablo Cuevas
62.			Damir Dzumhur	4-6 7-6(8) 2-6 6-4 6-2
					Jiri Vesely
63.		[Q]	Jiri Vesely		4-6 7-6(5) 6-4 6-4
				Jiri Vesely
64.		[6]	Alexander Zverev	4-6 6-3 6-2 7-5
										Novak Djokovic
65.			Sam Querrey							7-6(5) 1-6 7-6(4) 4-6 13-12(3)
				Sam Querrey
66.		[5]	Dominic Thiem	6-7(4) 7-6(1) 6-3 6-0
					Sam Querrey
67.			Andrey Rublev		6-3 6-2 6-3
				Andrey Rublev
68.			Cristian Garin	4-6 6-4 7-5 6-4
						Sam Querrey
69.			John Millman			7-6(3) 7-6(8) 6-3
				John Millman
70.			Hugo Dellien	6-2 6-3 6-4
					John Millman
71.		[31]	Laslo Djere		6-3 6-2 6-1
				Laslo Djere
72.			Guido Andreozzi	3-6 7-6(3) 7-6(3) 6-3
							Sam Querrey
73.		[20]	Gilles Simon				6-4 6-7(7) 7-6(3) 7-6(5)
				Gilles Simon
74.		[Q]	Salvatore Caruso	7-6(7) 6-3 6-2
					Tennys Sandgren
75.			Tennys Sandgren		6-2 6-3 4-6 3-6 8-6
				Tennys Sandgren
76.		[Q]	Yasutaka Uchiyama	3-6 6-2 6-4 6-3
						Tennys Sandgren
77.			Marton Fucsovics			6-3 7-6(12) 6-3
				Marton Fucsovics
78.		[Q]	Dennis Novak	3-6 6-4 7-6(2) 6-2
					Fabio Fognini
79.		[12]	Fabio Fognini		6-7(6) 6-4 7-6(3) 2-6 6-3
				Fabio Fognini
80.			Frances Tiafoe	5-7 6-4 6-3 4-6 6-4
								Rafael Nadal
81.		[13]	Marin Cilic					7-5 6-2 6-2
				Marin Cilic
82.			Adrian Mannarino	7-6(6) 7-6(4) 6-3
					Joao Sousa
83.			Joao Sousa		6-4 6-4 6-4
				Joao Sousa
84.		[WC]	Paul Jubb	6-0 6-3 6-7(8) 6-1
						Joao Sousa
85.			Daniel Evans			4-6 6-4 7-5 4-6 6-4
				Daniel Evans
86.			Federico Delbonis	6-3 7-6(5) 6-3
					Daniel Evans
87.		[18]	Nikoloz Basilashvili		6-3 6-2 7-6(2)
				Nikoloz Basilashvili
88.		[WC]	James Ward	2-6 4-6 6-4 6-4 8-6
							Rafael Nadal
89.			Ricardas Berankis				6-2 6-2 6-2
				Ricardas Berankis
90.		[29]	Denis Shapovalov	7-6(0) 6-4 6-3
					Jo-Wilfried Tsonga
91.			Jo-Wilfried Tsonga		7-6(4) 6-3 6-3
				Jo-Wilfried Tsonga
92.			Bernard Tomic	6-2 6-1 6-4
						Rafael Nadal
93.			Nick Kyrgios			6-2 6-3 6-2
				Nick Kyrgios
94.			Jordan Thompson	7-6(4) 3-6 7-6(10) 0-6 6-1
					Rafael Nadal
95.		[3]	Rafael Nadal		6-3 3-6 7-6(5) 7-6(3)
				Rafael Nadal
96.		[Q]	Yuichi Sugita	6-3 6-1 6-3
									Roger Federer
97.		[8]	Kei Nishikori						7-6(3) 1-6 6-3 6-4
				Kei Nishikori
98.		[Q]	Thiago Monteiro	6-4 7-6(3) 6-4
					Kei Nishikori
99.			Cameron Norrie		6-4 6-4 6-0
				Cameron Norrie
100.			Denis Istomin	6-2 6-4 6-4
						Kei Nishikori
101.			Steve Johnson			6-4 6-3 6-2
				Steve Johnson
102.			Albert Ramos-Vinolas	6-4 6-2 6-3
					Steve Johnson
103.		[25]	Alex de Minaur		3-6 7-6(4) 6-3 3-6 6-3
				Alex de Minaur
104.			Marco Cecchinato	6-0 6-4 7-6(5)
							Kei Nishikori
105.		[33]	Jan-Lennard Struff				6-3 3-6 6-3 6-4
				Jan-Lennard Struff
106.			Radu Albot	6-4 6-3 6-2
					Jan-Lennard Struff
107.			Taylor Fritz		6-4 6-3 5-7 7-6(2)
				Taylor Fritz
108.			Tomas Berdych	6-4 6-4 6-3
						Mikhail Kukushkin
109.			Mikhail Kukushkin			6-3 7-6(5) 4-6 7-5
				Mikhail Kukushkin
110.			Pablo Andujar	6-3 6-2 6-4
					Mikhail Kukushkin
111.		[9]	John Isner		6-4 6-7(3) 4-6 6-1 6-4
				John Isner
112.			Casper Ruud	6-3 6-4 7-6(9)
								Roger Federer
113.		[17]	Matteo Berrettini					4-6 6-1 6-4 6-4
				Matteo Berrettini
114.			Aljaz Bedene	3-6 6-3 6-2 7-6(3)
					Matteo Berrettini
115.		[WC]	Marcos Baghdatis		6-1 7-6(4) 6-3
				Marcos Baghdatis
116.		[LL]	Brayden Schnur	6-2 6-4 6-4
						Matteo Berrettini
117.		[WC]	Dominik Koepfer			6-7(5) 7-6(2) 4-6 7-6(5) 6-3
				Dominik Koepfer
118.			Filip Krajinovic	6-3 4-6 7-6(9) 6-1
					Diego Schwartzman
119.		[24]	Diego Schwartzman		6-0 6-3 7-5
				Diego Schwartzman
120.			Matthew Ebden	6-4 3-6 6-3 6-2
							Roger Federer
121.		[27]	Lucas Pouille				6-1 6-2 6-2
				Lucas Pouille
122.			Richard Gasquet	6-1 6-4 7-6(4)
					Lucas Pouille
123.		[Q]	Gregoire Barrere		6-1 7-6(0) 6-4
				Gregoire Barrere
124.			Alexander Bublik	3-6 6-4 6-3 6-3
						Roger Federer
125.		[WC]	Jay Clarke			7-5 6-2 7-6(4)
				Jay Clarke
126.		[Q]	Noah Rubin	4-6 7-5 6-4 6-4
					Roger Federer
127.		[2]	Roger Federer		6-1 7-6(3) 6-2
				Roger Federer
128.			Lloyd Harris	3-6 6-1 6-2 6-2

(default) 17 queries took 33 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` = 'wimbledon' LIMIT 1	1	1	5
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` = (3)	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` = (3)	4	4	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` = (3)	57	57	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` = 'wimbledon' AND `Category`.`slug` = 'men-singles' LIMIT 1	1	1	2
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` = (17) ORDER BY `Contest`.`year` ASC	137	137	3
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` = 3 AND `Contest`.`category_id` = 17 AND `Contest`.`slug` = '2019' 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` = (2270) ORDER BY `Match`.`round_id` ASC, `Match`.`no` ASC	127	127	4
9	SELECT `Player`.`id`, `Player`.`name`, `Player`.`gender`, `Player`.`slug` FROM `zavoihu1_db4tennis`.`players` AS `Player` WHERE `Player`.`id` IN (52, 122, 177, 3728, 170, 89, 14270, 13562, 14330, 3723, 14261, 161, 108, 14267, 14333, 99, 14237, 53, 14266, 11461, 160, 3580, 3725, 5049, 11473, 14265, 139, 14341, 141, 13613, 13538, 14245, 155, 8702, 68, 13874, 74, 14241, 6780, 14094, 156, 3582, 14238, 64, 66, 14175, 60, 14348, 14224, 14268, 171, 13867, 127, 7301, 113, 174, 157, 14391, 14347, 14196, 5934, 13567, 11453, 14136, 137, 13580, 14154, 14256, 10177, 14390, 14197, 6785, 100, 14260, 14084, 14393, 14221, 14259, 119, 14087, 3722, 130, 13674, 14394, 9051, 11454, 14122, 128, 8674, 14252, 115, 138, 10252, 13568, 179, 13625, 107, 14236, 14248, 114, 4775, 149, 14234, 14146, 11457, 13869, 14178, 148, 95, 79, 164, 14258, 14263, 10225, 158, 14395, 14396, 8925, 13616, 105, 11452, 75, 14194, 14235, 14319, 13868, 147, 14332) 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` = 2270	128	128	3
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (72, 179, 196, 53, 173, 94, 68, 74, 13, 164, 197, 14, 150, 92, 36, 10, 139, 154, 29, 149, 100, 96, 168, 50, 189, 41, 199, 172, 133, 86, 104, 21, 84, 27, 31, 26, 198, 153, 110, 169, 71, 52, 123)	43	43	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (72, 179, 196, 53, 173, 94, 68, 74, 13, 164, 197, 14, 150, 92, 36, 10, 139, 154, 29, 149, 100, 96, 168, 50, 189, 41, 199, 172, 133, 86, 104, 21, 84, 27, 31, 26, 198, 153, 110, 169, 71, 52, 123)	43	43	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (52, 122, 177, 3728, 170, 89, 14270, 13562, 14330, 3723, 14261, 161, 108, 14267, 14333, 99, 14237, 53, 14266, 11461, 160, 3580, 3725, 5049, 11473, 14265, 139, 14341, 141, 13613, 13538, 14245, 155, 8702, 68, 13874, 74, 14241, 6780, 14094, 156, 3582, 14238, 64, 66, 14175, 60, 14348, 14224, 14268, 171, 13867, 127, 7301, 113, 174, 157, 14391, 14347, 14196, 5934, 13567, 11453, 14136, 137, 13580, 14154, 14256, 10177, 14390, 14197, 6785, 100, 14260, 14084, 14393, 14221, 14259, 119, 14087, 3722, 130, 13674, 14394, 9051, 11454, 14122, 128, 8674, 14252, 115, 138, 10252, 13568, 179, 13625, 107, 14236, 14248, 114, 4775, 149, 14234, 14146, 11457, 13869, 14178, 148, 95, 79, 164, 14258, 14263, 10225, 158, 14395, 14396, 8925, 13616, 105, 11452, 75, 14194, 14235, 14319, 13868, 147, 14332)) AND (`Playercontest`.`contest_id` = 2270))	128	128	2
14	SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 17 ORDER BY `Contest`.`date_from` ASC	137	137	1
15	SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 2019	10	10	1
16	SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (3, 1, 12, 14, 19, 24, 17, 22, 4, 2) 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 33 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` = 'wimbledon' 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` = (3)

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` = (3)

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` = 'wimbledon' AND `Category`.`slug` = 'men-singles' LIMIT 1

137

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` = 3 AND `Contest`.`category_id` = 17 AND `Contest`.`slug` = '2019' 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` = (2270) 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 (52, 122, 177, 3728, 170, 89, 14270, 13562, 14330, 3723, 14261, 161, 108, 14267, 14333, 99, 14237, 53, 14266, 11461, 160, 3580, 3725, 5049, 11473, 14265, 139, 14341, 141, 13613, 13538, 14245, 155, 8702, 68, 13874, 74, 14241, 6780, 14094, 156, 3582, 14238, 64, 66, 14175, 60, 14348, 14224, 14268, 171, 13867, 127, 7301, 113, 174, 157, 14391, 14347, 14196, 5934, 13567, 11453, 14136, 137, 13580, 14154, 14256, 10177, 14390, 14197, 6785, 100, 14260, 14084, 14393, 14221, 14259, 119, 14087, 3722, 130, 13674, 14394, 9051, 11454, 14122, 128, 8674, 14252, 115, 138, 10252, 13568, 179, 13625, 107, 14236, 14248, 114, 4775, 149, 14234, 14146, 11457, 13869, 14178, 148, 95, 79, 164, 14258, 14263, 10225, 158, 14395, 14396, 8925, 13616, 105, 11452, 75, 14194, 14235, 14319, 13868, 147, 14332) 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` = 2270

128

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (52, 122, 177, 3728, 170, 89, 14270, 13562, 14330, 3723, 14261, 161, 108, 14267, 14333, 99, 14237, 53, 14266, 11461, 160, 3580, 3725, 5049, 11473, 14265, 139, 14341, 141, 13613, 13538, 14245, 155, 8702, 68, 13874, 74, 14241, 6780, 14094, 156, 3582, 14238, 64, 66, 14175, 60, 14348, 14224, 14268, 171, 13867, 127, 7301, 113, 174, 157, 14391, 14347, 14196, 5934, 13567, 11453, 14136, 137, 13580, 14154, 14256, 10177, 14390, 14197, 6785, 100, 14260, 14084, 14393, 14221, 14259, 119, 14087, 3722, 130, 13674, 14394, 9051, 11454, 14122, 128, 8674, 14252, 115, 138, 10252, 13568, 179, 13625, 107, 14236, 14248, 114, 4775, 149, 14234, 14146, 11457, 13869, 14178, 148, 95, 79, 164, 14258, 14263, 10225, 158, 14395, 14396, 8925, 13616, 105, 11452, 75, 14194, 14235, 14319, 13868, 147, 14332)) AND (`Playercontest`.`contest_id` = 2270))

128

SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 17 ORDER BY `Contest`.`date_from` ASC

137

SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 2019

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