Wimbledon 2023 Gentlemen's Singles (July 3 - July 16)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Carlos Alcaraz
				Carlos Alcaraz
2.			Jeremy Chardy	6-0 6-2 7-5
					Carlos Alcaraz
3.			Alexandre Muller		6-4 7-6(2) 6-3
				Alexandre Muller
4.			Arthur Rinderknech	7-6(5) 1-6 6-3 6-4
						Carlos Alcaraz
5.			Jason Kubler			6-3 6-7(6) 6-3 7-5
				Jason Kubler
6.			Ugo Humbert	6-4 4-6 6-2 3-6 6-3
					Nicolas Jarry
7.		[25]	Nicolas Jarry		7-5 5-7 6-3 6-4
				Nicolas Jarry
8.			Marco Cecchinato	4-6 6-2 6-4 6-1
							Carlos Alcaraz
9.		[19]	Alexander Zverev				3-6 6-3 6-3 6-3
				Alexander Zverev
10.		[Q]	Gijs Brouwer	6-4 7-6(4) 7-6(5)
					Alexander Zverev
11.		[LL]	Yosuke Watanuki		6-4 5-7 6-2 6-2
				Yosuke Watanuki
12.			Marc-Andrea Huesler	6-7(5) 5-7 7-6(5) 7-6(3) 6-3
						Matteo Berrettini
13.			Matteo Berrettini			6-3 7-6(4) 7-6(5)
				Matteo Berrettini
14.			Lorenzo Sonego	6-7(5) 6-3 7-6(7) 6-3
					Matteo Berrettini
15.		[15]	Alex de Minaur		6-3 6-4 6-4
				Alex de Minaur
16.		[Q]	Kimmer Coppejans	6-7(5) 6-3 6-3 7-6(2)
								Carlos Alcaraz
17.		[10]	Frances Tiafoe					7-6(3) 6-4 6-4
				Frances Tiafoe
18.			Yibing Wu	7-6(4) 6-3 6-4
					Frances Tiafoe
19.		[Q]	Dominic Stricker		7-6(11) 6-4 6-2
				Dominic Stricker
20.			Alexei Popyrin	3-6 6-3 6-2 4-6 7-5
						Grigor Dimitrov
21.			Ilya Ivashka			6-2 6-3 6-2
				Ilya Ivashka
22.			Federico Coria	4-6 6-4 6-3 6-0
					Grigor Dimitrov
23.		[21]	Grigor Dimitrov		6-3 6-4 6-4
				Grigor Dimitrov
24.		[Q]	Sho Shimabukuro	6-1 6-2 6-1
							Holger Rune
25.		[31]	Alejandro Davidovich Fokina				3-6 7-6(6) 7-6(4) 6-3
				Alejandro Davidovich Fokina
26.		[WC]	Arthur Fils	7-6(3) 6-1 6-2
					Alejandro Davidovich Fokina
27.			Botic van de Zandschulp		6-1 2-6 6-4 6-3
				Botic van de Zandschulp
28.			Zhizhen Zhang	2-6 7-6(3) 7-6(6) 3-6 6-2
						Holger Rune
29.			Roberto Carballes Baena			6-3 4-6 3-6 6-4 7-6(8)
				Roberto Carballes Baena
30.		[Q]	Matteo Arnaldi	6-7(0) 6-3 6-4 6-4
					Holger Rune
31.		[6]	Holger Rune		6-3 7-6(3) 6-4
				Holger Rune
32.		[WC]	George Loffhagen	7-6(4) 6-3 6-2
									Carlos Alcaraz
33.		[3]	Daniil Medvedev						6-3 6-3 6-3
				Daniil Medvedev
34.		[WC]	Arthur Fery	7-5 6-4 6-3
					Daniil Medvedev
35.			Adrian Mannarino		6-3 6-3 7-6(5)
				Adrian Mannarino
36.			Alexander Shevchenko	6-3 6-3 6-2
						Daniil Medvedev
37.			Marcos Giron			4-6 6-3 6-4 6-4
				Marcos Giron
38.			Hugo Dellien	7-6(2) 6-4 6-4
					Marton Fucsovics
39.			Marton Fucsovics		7-6(2) 6-3 4-6 6-4
				Marton Fucsovics
40.		[28]	Tallon Griekspoor	6-4 6-2 6-4
							Daniil Medvedev
41.		[18]	Francisco Cerundolo				6-4 6-2 rtd.
				Francisco Cerundolo
42.			Nuno Borges	5-7 6-3 6-3 6-4
					Jiri Lehecka
43.			Jiri Lehecka		6-2 6-2 6-2
				Jiri Lehecka
44.		[WC]	Sebastian Ofner	6-4 6-4 6-4
						Jiri Lehecka
45.			Milos Raonic			6-2 7-6(2) 6-7(5) 6-7(9) 6-2
				Milos Raonic
46.		[Q]	Dennis Novak	6-7(5) 6-4 7-6(5) 6-1
					Tommy Paul
47.		[16]	Tommy Paul		6-4 7-6(4) 6-7(4) 6-4
				Tommy Paul
48.		[Q]	Shintaro Mochizuki	7-5 6-3 6-1
								Daniil Medvedev
49.		[12]	Cameron Norrie					6-4 1-6 4-6 7-6(4) 6-1
				Cameron Norrie
50.		[Q]	Tomas Machac	6-3 4-6 6-1 6-4
					Christopher Eubanks
51.			Christopher Eubanks		6-3 3-6 6-2 7-6(3)
				Christopher Eubanks
52.			Thiago Monteiro	4-6 7-5 7-5 6-3
						Christopher Eubanks
53.			Christopher O'Connell			7-6(5) 7-6(3) 7-6(2)
				Christopher O'Connell
54.		[Q]	Hamad Medjedovic	7-5 6-4 4-6 6-4
					Christopher O'Connell
55.			Jiri Vesely		6-3 7-5 6-4
				Jiri Vesely
56.		[22]	Sebastian Korda	7-6(7) 4-6 6-2 6-3
							Christopher Eubanks
57.		[32]	Ben Shelton				3-6 7-6(4) 3-6 6-4 6-4
				Ben Shelton
58.		[LL]	Taro Daniel	6-4 6-3 3-6 4-6 6-3
					Laslo Djere
59.			Laslo Djere		3-6 6-3 7-6(5) 6-3
				Laslo Djere
60.			Maxime Cressy	6-7(5) 7-6(3) 7-6(8) 7-6(7)
						Stefanos Tsitsipas
61.			Andy Murray			6-4 7-6(5) 6-4
				Andy Murray
62.		[WC]	Ryan Peniston	6-3 6-0 6-1
					Stefanos Tsitsipas
63.		[5]	Stefanos Tsitsipas		7-6(3) 6-7(2) 4-6 7-6(3) 6-4
				Stefanos Tsitsipas
64.			Dominic Thiem	3-6 7-6(1) 6-2 6-7(5) 7-6(8)
										Carlos Alcaraz
65.		[8]	Jannik Sinner							1-6 7-6(6) 6-1 3-6 6-4
				Jannik Sinner
66.			Juan Manuel Cerundolo	6-2 6-2 6-2
					Jannik Sinner
67.			Diego Schwartzman		7-5 6-1 6-2
				Diego Schwartzman
68.			Miomir Kecmanovic	6-0 6-3 6-4
						Jannik Sinner
69.			Aleksandar Vukic			3-6 6-2 6-3 6-4
				Aleksandar Vukic
70.			Daniel Altmaier	6-3 7-6(1) 3-6 7-5
					Quentin Halys
71.			Quentin Halys		6-3 6-1 6-4
				Quentin Halys
72.		[27]	Daniel Evans	6-2 6-3 6-7(5) 6-4
							Jannik Sinner
73.			Daniel Elahi Galan				7-6(4) 6-4 6-3
				Daniel Elahi Galan
74.		[24]	Yoshihito Nishioka	6-4 6-3 6-3
					Daniel Elahi Galan
75.		[Q]	Oscar Otte		6-3 3-6 6-3 7-6(3)
				Oscar Otte
76.			Dominik Koepfer	7-5 6-3 7-6(9)
						Daniel Elahi Galan
77.			Mikael Ymer			6-2 6-7(2) 7-6(5) 3-6 6-1
				Mikael Ymer
78.			Alex Molcan	6-3 6-3 6-4
					Mikael Ymer
79.		[9]	Taylor Fritz		3-6 2-6 6-3 6-4 6-2
				Taylor Fritz
80.			Yannick Hanfmann	6-4 2-6 4-6 7-5 6-3
								Jannik Sinner
81.			Guido Pella					6-4 3-6 6-2 6-2
				Guido Pella
82.		[13]	Borna Coric	6-3 7-5 4-6 3-6 6-1
					Guido Pella
83.		[Q]	Harold Mayot		2-6 6-3 7-6(3) 7-5
				Harold Mayot
84.			Benjamin Bonzi	6-3 6-4 7-5
						Roman Safiullin
85.			Corentin Moutet			7-6(1) 6-4 6-0
				Corentin Moutet
86.			Richard Gasquet	6-3 7-5 7-5
					Roman Safiullin
87.			Roman Safiullin		7-5 6-3 7-6(4)
				Roman Safiullin
88.		[20]	Roberto Bautista Agut	2-6 7-6(7) 6-7(4) 6-4 7-5
							Roman Safiullin
89.		[26]	Denis Shapovalov				3-6 6-3 6-1 6-3
				Denis Shapovalov
90.		[Q]	Radu Albot	5-7 6-4 6-2 6-2
					Denis Shapovalov
91.			Gregoire Barrere		6-3 6-4 7-6(7)
				Gregoire Barrere
92.			Lloyd Harris	7-5 6-7(4) 7-5 6-3
						Denis Shapovalov
93.		[WC]	Liam Broady			4-6 6-2 7-5 7-5
				Liam Broady
94.			Constant Lestienne	6-1 6-3 7-5
					Liam Broady
95.		[4]	Casper Ruud		6-4 3-6 4-6 6-3 6-0
				Casper Ruud
96.		[Q]	Laurent Lokoli	6-1 5-7 6-4 6-3
									Novak Djokovic
97.		[7]	Andrey Rublev						6-3 6-4 7-6(4)
				Andrey Rublev
98.			Max Purcell	6-3 7-5 6-4
					Andrey Rublev
99.			Aslan Karatsev		6-7(4) 6-3 6-4 7-5
				Aslan Karatsev
100.			Luca van Assche	6-7(4) 6-4 6-2 6-4
						Andrey Rublev
101.		[Q]	Marcelo Tomás Barrios Vera			6-3 6-7(6) 7-6(5) 6-2
				Marcelo Tomás Barrios Vera
102.			Sebastian Baez	7-6(7) 3-6 6-3 7-6(2)
					David Goffin
103.		[WC]	David Goffin		7-6(3) 5-7 6-2 6-0
				David Goffin
104.		[LL]	Fabian Marozsan	6-2 5-7 6-2 6-0
							Andrey Rublev
105.		[23]	Alexander Bublik				7-5 6-3 6-7(6) 6-7(5) 6-4
				Alexander Bublik
106.			Mackenzie McDonald	6-7(3) 6-4 6-4 6-4
					Alexander Bublik
107.			Jeffrey Wolf		6-3 7-6(5) 6-0
				Jeffrey Wolf
108.		[Q]	Enzo Couacaud	7-5 6-3 7-6(4)
						Alexander Bublik
109.		[Q]	Maximilian Marterer			6-4 6-1 7-6(4)
				Maximilian Marterer
110.			Borna Gojo	7-5 6-7(8) 6-3 6-4
					Maximilian Marterer
111.		[LL]	Michael Mmoh		7-5 7-6(5) 6-4
				Michael Mmoh
112.		[11]	Felix Auger-Aliassime	7-6(4) 6-7(4) 7-6(4) 6-4
								Novak Djokovic
113.		[14]	Lorenzo Musetti					4-6 6-1 6-4 6-3
				Lorenzo Musetti
114.			Juan Pablo Varillas	6-3 6-1 7-5
					Lorenzo Musetti
115.			Jaume Munar		6-4 6-3 6-1
				Jaume Munar
116.			John Isner	4-6 6-3 6-4 6-4
						Hubert Hurkacz
117.		[WC]	Jan Choinski			7-6(4) 6-4 6-4
				Jan Choinski
118.			Dusan Lajovic	5-7 7-6(4) 6-2 6-2
					Hubert Hurkacz
119.		[17]	Hubert Hurkacz		6-4 6-4 7-6(3)
				Hubert Hurkacz
120.			Albert Ramos-Vinolas	6-1 6-4 6-4
							Novak Djokovic
121.		[29]	Tomas Martin Etcheverry				7-6(6) 7-6(6) 5-7 6-4
				Tomas Martin Etcheverry
122.			Bernabe Zapata Miralles	6-7(5) 5-7 6-3 6-4 7-5
					Stan Wawrinka
123.			Stan Wawrinka		6-3 4-6 6-4 6-2
				Stan Wawrinka
124.			Emil Ruusuvuori	7-5 7-5 6-4
						Novak Djokovic
125.			Jordan Thompson			6-3 6-1 7-6(5)
				Jordan Thompson
126.			Brandon Nakashima	2-6 2-6 6-4 7-6(4) 6-3
					Novak Djokovic
127.		[2]	Novak Djokovic		6-3 7-6(4) 7-5
				Novak Djokovic
128.			Pedro Cachin	6-3 6-3 7-6(4)

(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` = 'wimbledon' 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` = (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	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` = (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` = '2023' 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` = (2313) 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 (14464, 160, 14244, 14445, 7856, 14333, 14241, 14146, 14136, 14573, 14595, 14552, 14263, 14267, 14234, 14128, 14087, 14571, 14612, 14266, 14222, 14443, 161, 14627, 14389, 14609, 14463, 14479, 14196, 14605, 14483, 14628, 14237, 14629, 130, 14606, 13867, 14390, 14221, 14414, 14476, 14539, 14502, 14257, 60, 14259, 14153, 14630, 14248, 14449, 14312, 14236, 14239, 14613, 11453, 14428, 14570, 13871, 14197, 14429, 84, 14551, 14245, 13580, 14400, 14631, 13616, 14347, 14452, 14446, 14125, 9051, 14416, 13874, 14274, 14396, 14387, 14485, 14178, 14335, 6780, 13870, 14444, 14246, 14261, 75, 14465, 113, 14252, 13869, 14194, 14332, 8937, 14597, 14258, 13611, 14154, 14417, 14460, 14596, 14478, 14497, 3725, 14641, 14235, 14220, 14434, 14471, 14264, 14533, 14086, 14330, 14468, 14530, 14265, 164, 14632, 13562, 14270, 149, 14501, 14469, 156, 14433, 13568, 14432, 52, 14537) 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` = 2313	128	128	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (179, 94, 13, 53, 147, 133, 68, 74, 197, 14, 92, 154, 36, 10, 67, 139, 54, 173, 196, 72, 29, 168, 164, 84, 41, 20, 149, 172, 50, 21, 43, 31, 26, 96, 150, 153, 42, 178)	38	38	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (179, 94, 13, 53, 147, 133, 68, 74, 197, 14, 92, 154, 36, 10, 67, 139, 54, 173, 196, 72, 29, 168, 164, 84, 41, 20, 149, 172, 50, 21, 43, 31, 26, 96, 150, 153, 42, 178)	38	38	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (14464, 160, 14244, 14445, 7856, 14333, 14241, 14146, 14136, 14573, 14595, 14552, 14263, 14267, 14234, 14128, 14087, 14571, 14612, 14266, 14222, 14443, 161, 14627, 14389, 14609, 14463, 14479, 14196, 14605, 14483, 14628, 14237, 14629, 130, 14606, 13867, 14390, 14221, 14414, 14476, 14539, 14502, 14257, 60, 14259, 14153, 14630, 14248, 14449, 14312, 14236, 14239, 14613, 11453, 14428, 14570, 13871, 14197, 14429, 84, 14551, 14245, 13580, 14400, 14631, 13616, 14347, 14452, 14446, 14125, 9051, 14416, 13874, 14274, 14396, 14387, 14485, 14178, 14335, 6780, 13870, 14444, 14246, 14261, 75, 14465, 113, 14252, 13869, 14194, 14332, 8937, 14597, 14258, 13611, 14154, 14417, 14460, 14596, 14478, 14497, 3725, 14641, 14235, 14220, 14434, 14471, 14264, 14533, 14086, 14330, 14468, 14530, 14265, 164, 14632, 13562, 14270, 149, 14501, 14469, 156, 14433, 13568, 14432, 52, 14537)) AND (`Playercontest`.`contest_id` = 2313))	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` = 2023	10	10	1
16	SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (3, 1, 12, 14, 17, 19, 22, 24, 2, 4) 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` = '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` = '2023' 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` = (2313) 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 (14464, 160, 14244, 14445, 7856, 14333, 14241, 14146, 14136, 14573, 14595, 14552, 14263, 14267, 14234, 14128, 14087, 14571, 14612, 14266, 14222, 14443, 161, 14627, 14389, 14609, 14463, 14479, 14196, 14605, 14483, 14628, 14237, 14629, 130, 14606, 13867, 14390, 14221, 14414, 14476, 14539, 14502, 14257, 60, 14259, 14153, 14630, 14248, 14449, 14312, 14236, 14239, 14613, 11453, 14428, 14570, 13871, 14197, 14429, 84, 14551, 14245, 13580, 14400, 14631, 13616, 14347, 14452, 14446, 14125, 9051, 14416, 13874, 14274, 14396, 14387, 14485, 14178, 14335, 6780, 13870, 14444, 14246, 14261, 75, 14465, 113, 14252, 13869, 14194, 14332, 8937, 14597, 14258, 13611, 14154, 14417, 14460, 14596, 14478, 14497, 3725, 14641, 14235, 14220, 14434, 14471, 14264, 14533, 14086, 14330, 14468, 14530, 14265, 164, 14632, 13562, 14270, 149, 14501, 14469, 156, 14433, 13568, 14432, 52, 14537) 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` = 2313

128

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (179, 94, 13, 53, 147, 133, 68, 74, 197, 14, 92, 154, 36, 10, 67, 139, 54, 173, 196, 72, 29, 168, 164, 84, 41, 20, 149, 172, 50, 21, 43, 31, 26, 96, 150, 153, 42, 178)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (179, 94, 13, 53, 147, 133, 68, 74, 197, 14, 92, 154, 36, 10, 67, 139, 54, 173, 196, 72, 29, 168, 164, 84, 41, 20, 149, 172, 50, 21, 43, 31, 26, 96, 150, 153, 42, 178)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (14464, 160, 14244, 14445, 7856, 14333, 14241, 14146, 14136, 14573, 14595, 14552, 14263, 14267, 14234, 14128, 14087, 14571, 14612, 14266, 14222, 14443, 161, 14627, 14389, 14609, 14463, 14479, 14196, 14605, 14483, 14628, 14237, 14629, 130, 14606, 13867, 14390, 14221, 14414, 14476, 14539, 14502, 14257, 60, 14259, 14153, 14630, 14248, 14449, 14312, 14236, 14239, 14613, 11453, 14428, 14570, 13871, 14197, 14429, 84, 14551, 14245, 13580, 14400, 14631, 13616, 14347, 14452, 14446, 14125, 9051, 14416, 13874, 14274, 14396, 14387, 14485, 14178, 14335, 6780, 13870, 14444, 14246, 14261, 75, 14465, 113, 14252, 13869, 14194, 14332, 8937, 14597, 14258, 13611, 14154, 14417, 14460, 14596, 14478, 14497, 3725, 14641, 14235, 14220, 14434, 14471, 14264, 14533, 14086, 14330, 14468, 14530, 14265, 164, 14632, 13562, 14270, 149, 14501, 14469, 156, 14433, 13568, 14432, 52, 14537)) AND (`Playercontest`.`contest_id` = 2313))

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

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