Roland Garros 2024 Men's Singles (May 26 - June 9)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Novak Djokovic
				Novak Djokovic
2.		[WC]	Pierre-Hugues Herbert	6-4 7-6(3) 6-4
					Novak Djokovic
3.			Roberto Carballes Baena		6-4 6-1 6-2
				Roberto Carballes Baena
4.			Constant Lestienne	6-3 7-5 4-6 6-2
						Novak Djokovic
5.			Gael Monfils			7-5 6-7(6) 2-6 6-3 6-0
				Gael Monfils
6.			Thiago Seyboth Wild	6-2 3-6 6-3 6-4
					Lorenzo Musetti
7.		[30]	Lorenzo Musetti		7-5 6-1 6-4
				Lorenzo Musetti
8.			Daniel Elahi Galan	6-3 6-3 7-5
							Novak Djokovic
9.		[23]	Francisco Cerundolo				6-1 5-7 3-6 7-5 6-3
				Francisco Cerundolo
10.			Yannick Hanfmann	6-3 6-3 6-4
					Francisco Cerundolo
11.		[Q]	Filip Misolic		6-2 7-6(2) 6-0
				Filip Misolic
12.		[LL]	Otto Virtanen	4-6 4-6 6-3 6-4 6-2
						Francisco Cerundolo
13.			Fabio Fognini			3-6 6-3 6-3 6-2
				Fabio Fognini
14.			Botic van de Zandschulp	6-1 6-1 7-5
					Tommy Paul
15.		[14]	Tommy Paul		6-1 6-0 6-2
				Tommy Paul
16.			Pedro Cachin	6-2 6-3 6-1
								Casper Ruud
17.		[12]	Taylor Fritz					w/o
				Taylor Fritz
18.			Federico Coria	2-6 6-1 6-2 6-1
					Taylor Fritz
19.			Dusan Lajovic		6-3 3-6 6-3 6-4
				Dusan Lajovic
20.			Roman Safiullin	4-6 7-5 6-4 6-7(6) 6-4
						Taylor Fritz
21.			Thanasi Kokkinakis			6-3 6-2 6-7(4) 5-7 6-3
				Thanasi Kokkinakis
22.			Alexei Popyrin	4-6 7-6(8) 6-3 5-7 6-3
					Thanasi Kokkinakis
23.		[Q]	Giulio Zeppieri		1-6 4-6 6-3 7-6(5) 6-2
				Giulio Zeppieri
24.		[22]	Adrian Mannarino	4-6 6-2 6-1 6-2
							Casper Ruud
25.		[28]	Tomas Martin Etcheverry				7-6(6) 3-6 6-4 6-2
				Tomas Martin Etcheverry
26.			Arthur Cazaux	3-6 6-2 6-1 6-4
					Tomas Martin Etcheverry
27.			Arthur Rinderknech		3-6 6-7(8) 6-1 5-0 rtd.
				Arthur Rinderknech
28.		[WC]	Adam Walton	6-2 6-4 7-5
						Casper Ruud
29.			Alejandro Davidovich Fokina			6-4 1-6 6-2 6-2
				Alejandro Davidovich Fokina
30.		[Q]	Valentin Vacherot	4-6 6-2 6-2 7-6(2)
					Casper Ruud
31.		[7]	Casper Ruud		7-6(5) 1-6 6-3 4-6 6-3
				Casper Ruud
32.		[Q]	Felipe Meligeni Alves	6-3 6-4 6-3
									Carlos Alcaraz
33.		[4]	Alexander Zverev						2-6 6-3 3-6 6-4 6-3
				Alexander Zverev
34.			Rafael Nadal	6-3 7-6(5) 6-3
					Alexander Zverev
35.			David Goffin		7-6(4) 6-2 6-2
				David Goffin
36.		[WC]	Giovanni Mpetshi Perricard	4-6 6-4 6-3 6-7(4) 6-3
						Alexander Zverev
37.			Luciano Darderi			3-6 6-4 6-2 4-6 7-6(3)
				Luciano Darderi
38.			Rinky Hijikata	6-3 7-6(6) 6-1
					Tallon Griekspoor
39.		[26]	Tallon Griekspoor		7-6(2) 6-3 6-3
				Tallon Griekspoor
40.			Mackenzie McDonald	6-3 6-4 1-6 6-2
							Alexander Zverev
41.		[18]	Karen Khachanov				4-6 6-1 5-7 7-6(2) 6-2
				Karen Khachanov
42.			Sumit Nagal	6-2 6-0 7-6(5)
					Jozef Kovalik
43.		[LL]	Jozef Kovalik		4-6 4-6 6-4 6-3 6-4
				Jozef Kovalik
44.			Marcos Giron	7-6(3) 6-4 3-6 7-6(5)
						Holger Rune
45.			Flavio Cobolli			7-5 6-1 7-6(2)
				Flavio Cobolli
46.		[Q]	Hamad Medjedovic	6-2 6-3 6-7(2) 6-3
					Holger Rune
47.		[13]	Holger Rune		6-4 6-3 3-6 3-6 7-6(7)
				Holger Rune
48.			Daniel Evans	6-4 6-4 6-4
								Alexander Zverev
49.		[11]	Alex de Minaur					6-4 7-6(5) 6-4
				Alex de Minaur
50.			Alex Michelsen	6-1 6-0 6-2
					Alex de Minaur
51.			Jaume Munar		7-5 6-1 6-4
				Jaume Munar
52.			Roberto Bautista Agut	6-1 4-6 6-4 6-1
						Alex de Minaur
53.			Jan-Lennard Struff			4-6 6-4 6-3 6-3
				Jan-Lennard Struff
54.		[Q]	Roman Andres Burruchaga	6-3 6-2 6-1
					Jan-Lennard Struff
55.		[19]	Alexander Bublik		6-2 6-2 6-3
				Alexander Bublik
56.		[Q]	Gregoire Barrere	6-4 7-5 6-3
							Alex de Minaur
57.		[31]	Mariano Navone				4-6 6-2 6-1 6-3
				Mariano Navone
58.			Pablo Carreno Busta	5-7 6-1 6-3 6-0
					Tomas Machac
59.			Tomas Machac		6-2 6-1 3-6 1-6 6-1
				Tomas Machac
60.			Nuno Borges	7-6(3) 6-4 6-3
						Daniil Medvedev
61.			Miomir Kecmanovic			7-6(4) 7-5 1-6 6-4
				Miomir Kecmanovic
62.		[Q]	Thiago Monteiro	6-2 6-1 4-6 7-5
					Daniil Medvedev
63.		[5]	Daniil Medvedev		6-1 5-0 rtd.
				Daniil Medvedev
64.			Dominik Koepfer	6-3 6-4 5-7 6-3
										Carlos Alcaraz
65.		[6]	Andrey Rublev							6-3 2-6 5-7 6-1 6-2
				Andrey Rublev
66.			Taro Daniel	6-2 6-7(3) 6-3 7-5
					Andrey Rublev
67.			Pedro Martinez		6-3 6-4 6-3
				Pedro Martinez
68.			Thiago Agustin Tirante	5-7 6-4 3-6 6-4 6-3
						Matteo Arnaldi
69.		[WC]	Alexandre Muller			7-6(6) 6-2 6-4
				Alexandre Muller
70.			Luca Nardi	6-4 6-1 6-3
					Matteo Arnaldi
71.			Matteo Arnaldi		6-4 6-1 6-3
				Matteo Arnaldi
72.		[29]	Arthur Fils	6-3 4-6 6-4 6-2
							Stefanos Tsitsipas
73.			Lorenzo Sonego				3-6 7-6(4) 6-2 6-2
				Lorenzo Sonego
74.		[17]	Ugo Humbert	6-4 2-6 6-4 6-3
					Zhizhen Zhang
75.			Zhizhen Zhang		7-5 3-6 6-1 6-4
				Zhizhen Zhang
76.			Aleksandar Vukic	6-4 4-6 6-3 7-5
						Stefanos Tsitsipas
77.			Daniel Altmaier			6-3 6-3 6-1
				Daniel Altmaier
78.			Laslo Djere	7-5 6-4 6-7(6) 5-7 7-6(6)
					Stefanos Tsitsipas
79.			Stefanos Tsitsipas		6-3 6-2 6-7(2) 6-4
				Stefanos Tsitsipas
80.			Marton Fucsovics	7-6(7) 6-4 6-1
								Carlos Alcaraz
81.		[15]	Ben Shelton					6-3 7-6(3) 6-4
				Ben Shelton
82.			Hugo Gaston	3-6 6-3 6-4 6-4
					Ben Shelton
83.			Kei Nishikori		7-6(7) 6-4 rtd.
				Kei Nishikori
84.		[Q]	Gabriel Diallo	7-5 7-6(3) 3-6 1-6 7-5
						Felix Auger-Aliassime
85.		[Q]	Henri Squire			6-4 6-2 6-1
				Henri Squire
86.			Max Purcell	6-2 6-2 3-6 4-6 7-6(10)
					Felix Auger-Aliassime
87.		[21]	Felix Auger-Aliassime		6-4 4-6 6-3 6-2
				Felix Auger-Aliassime
88.			Yoshihito Nishioka	6-2 6-4 6-4
							Carlos Alcaraz
89.		[27]	Sebastian Korda				6-3 6-3 6-1
				Sebastian Korda
90.		[WC]	Harold Mayot	6-2 7-6(4) 6-4
					Sebastian Korda
91.			Soon-woo Kwon		6-4 6-4 1-6 6-3
				Soon-woo Kwon
92.			Emil Ruusuvuori	6-3 6-4 6-3
						Carlos Alcaraz
93.		[Q]	Jesper de Jong			6-4 7-6(5) 6-3
				Jesper de Jong
94.			Jack Draper	7-5 6-4 6-7(3) 3-6 6-3
					Carlos Alcaraz
95.		[3]	Carlos Alcaraz		6-3 6-4 2-6 6-2
				Carlos Alcaraz
96.		[LL]	Jeffrey Wolf	6-1 6-2 6-1
									Alexander Zverev
97.		[8]	Hubert Hurkacz						2-6 6-2 6-4 6-2
				Hubert Hurkacz
98.		[Q]	Shintaro Mochizuki	4-6 6-3 3-6 6-0 6-3
					Hubert Hurkacz
99.			Brandon Nakashima		6-7(2) 6-1 6-3 7-6(5)
				Brandon Nakashima
100.		[WC]	Nicolas Moreno de Alboran	6-1 6-7(6) 6-3 6-2
						Hubert Hurkacz
101.			Denis Shapovalov			6-3 7-6(0) 4-6 6-1
				Denis Shapovalov
102.			Luca van Assche	6-3 6-4 6-4
					Denis Shapovalov
103.		[25]	Frances Tiafoe		6-7(4) 6-4 6-2 6-4
				Frances Tiafoe
104.		[Q]	Mattia Bellucci	6-3 3-6 6-7(6) 6-4 6-4
							Grigor Dimitrov
105.		[Q]	Zizou Bergs				7-6(5) 6-4 7-6(3)
				Zizou Bergs
106.		[24]	Alejandro Tabilo	3-6 7-6(5) 6-2 6-2
					Zizou Bergs
107.			Maximilian Marterer		3-6 6-3 6-1 6-3
				Maximilian Marterer
108.			Jordan Thompson	6-3 6-2 6-0
						Grigor Dimitrov
109.			Fabian Marozsan			6-3 7-6(4) 4-6 6-4
				Fabian Marozsan
110.		[Q]	Mikhail Kukushkin	6-2 6-2 6-3
					Grigor Dimitrov
111.		[10]	Grigor Dimitrov		6-0 6-3 6-4
				Grigor Dimitrov
112.			Aleksandar Kovacevic	6-4 6-3 6-4
								Jannik Sinner
113.			Corentin Moutet					6-2 6-4 7-6(3)
				Corentin Moutet
114.		[16]	Nicolas Jarry	6-2 6-1 3-6 6-0
					Corentin Moutet
115.			Alexander Shevchenko		6-4 6-2 0-6 6-3
				Alexander Shevchenko
116.			Aslan Karatsev	6-4 4-6 1-6 6-1 6-4
						Corentin Moutet
117.			Sebastian Ofner			3-6 6-4 6-4 6-1
				Sebastian Ofner
118.		[WC]	Terence Atmane	3-6 4-6 7-6(2) 6-2 7-5
					Sebastian Ofner
119.		[20]	Sebastian Baez		3-6 3-6 6-4 7-5 7-6(5)
				Sebastian Baez
120.		[Q]	Gustavo Heide	4-6 6-3 6-1 4-6 6-3
							Jannik Sinner
121.			Pavel Kotov				2-6 6-3 6-2 6-1
				Pavel Kotov
122.		[32]	Cameron Norrie	4-6 6-3 3-6 7-6(5) 6-2
					Pavel Kotov
123.			Stan Wawrinka		7-6(5) 6-4 1-6 7-6(5)
				Stan Wawrinka
124.			Andy Murray	6-4 6-4 6-2
						Jannik Sinner
125.		[WC]	Richard Gasquet			6-4 6-4 6-4
				Richard Gasquet
126.			Borna Coric	7-6(5) 7-6(2) 6-4
					Jannik Sinner
127.		[2]	Jannik Sinner		6-4 6-2 6-4
				Jannik Sinner
128.			Christopher Eubanks	6-3 6-3 6-4

(default) 17 queries took 25 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` = 'roland-garros' 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` = (2)	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` = (2)	5	5	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` = (2)	5	5	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` = 'roland-garros' 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` = (12) ORDER BY `Contest`.`year` ASC	123	123	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` = 2 AND `Contest`.`category_id` = 12 AND `Contest`.`slug` = '2024' 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` = (2335) 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 (52, 8702, 14196, 14597, 99, 14436, 14468, 14416, 14476, 14335, 14746, 14679, 119, 14463, 14153, 14537, 14178, 14443, 13562, 14465, 10251, 14266, 14538, 130, 14501, 14470, 14445, 14686, 14389, 14749, 14258, 14678, 14136, 179, 3725, 14611, 14744, 14575, 14414, 14220, 14224, 14402, 14175, 13867, 14604, 14613, 14483, 9051, 14234, 14672, 14265, 113, 11457, 14750, 14235, 14194, 14745, 11461, 14449, 14539, 14347, 14236, 14237, 14396, 14154, 13871, 14386, 14614, 14244, 14751, 14605, 14609, 14267, 14333, 14479, 14452, 14446, 14197, 14245, 14221, 14570, 14410, 107, 14752, 14753, 14417, 14330, 13874, 14428, 14444, 14268, 14433, 14685, 14477, 14464, 14434, 14270, 14630, 14432, 14680, 14252, 14596, 14087, 14599, 14554, 14415, 14264, 13568, 14641, 95, 161, 14608, 14261, 14241, 14606, 14460, 14257, 14688, 14497, 14754, 14534, 14248, 156, 84, 75, 13870, 14400, 14312) 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` = 2335	128	128	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (42, 92, 197, 29, 179, 13, 67, 133, 68, 124, 74, 10, 41, 72, 96, 36, 154, 139, 54, 14, 196, 94, 86, 173, 164, 84, 53, 100, 168, 149, 21, 43, 31, 50, 150)	35	35	2
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (42, 92, 197, 29, 179, 13, 67, 133, 68, 124, 74, 10, 41, 72, 96, 36, 154, 139, 54, 14, 196, 94, 86, 173, 164, 84, 53, 100, 168, 149, 21, 43, 31, 50, 150)	35	35	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (52, 8702, 14196, 14597, 99, 14436, 14468, 14416, 14476, 14335, 14746, 14679, 119, 14463, 14153, 14537, 14178, 14443, 13562, 14465, 10251, 14266, 14538, 130, 14501, 14470, 14445, 14686, 14389, 14749, 14258, 14678, 14136, 179, 3725, 14611, 14744, 14575, 14414, 14220, 14224, 14402, 14175, 13867, 14604, 14613, 14483, 9051, 14234, 14672, 14265, 113, 11457, 14750, 14235, 14194, 14745, 11461, 14449, 14539, 14347, 14236, 14237, 14396, 14154, 13871, 14386, 14614, 14244, 14751, 14605, 14609, 14267, 14333, 14479, 14452, 14446, 14197, 14245, 14221, 14570, 14410, 107, 14752, 14753, 14417, 14330, 13874, 14428, 14444, 14268, 14433, 14685, 14477, 14464, 14434, 14270, 14630, 14432, 14680, 14252, 14596, 14087, 14599, 14554, 14415, 14264, 13568, 14641, 95, 161, 14608, 14261, 14241, 14606, 14460, 14257, 14688, 14497, 14754, 14534, 14248, 156, 84, 75, 13870, 14400, 14312)) AND (`Playercontest`.`contest_id` = 2335))	128	128	2
14	SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 12 ORDER BY `Contest`.`date_from` ASC	123	123	1
15	SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 2024	10	10	1
16	SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (1, 3, 2, 4, 19, 17, 12, 14, 22, 24) 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 25 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` = 'roland-garros' 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` = (2)

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` = (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`, `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` = 'roland-garros' AND `Category`.`slug` = 'men-singles' LIMIT 1

123

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` = 2 AND `Contest`.`category_id` = 12 AND `Contest`.`slug` = '2024' 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` = (2335) 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, 8702, 14196, 14597, 99, 14436, 14468, 14416, 14476, 14335, 14746, 14679, 119, 14463, 14153, 14537, 14178, 14443, 13562, 14465, 10251, 14266, 14538, 130, 14501, 14470, 14445, 14686, 14389, 14749, 14258, 14678, 14136, 179, 3725, 14611, 14744, 14575, 14414, 14220, 14224, 14402, 14175, 13867, 14604, 14613, 14483, 9051, 14234, 14672, 14265, 113, 11457, 14750, 14235, 14194, 14745, 11461, 14449, 14539, 14347, 14236, 14237, 14396, 14154, 13871, 14386, 14614, 14244, 14751, 14605, 14609, 14267, 14333, 14479, 14452, 14446, 14197, 14245, 14221, 14570, 14410, 107, 14752, 14753, 14417, 14330, 13874, 14428, 14444, 14268, 14433, 14685, 14477, 14464, 14434, 14270, 14630, 14432, 14680, 14252, 14596, 14087, 14599, 14554, 14415, 14264, 13568, 14641, 95, 161, 14608, 14261, 14241, 14606, 14460, 14257, 14688, 14497, 14754, 14534, 14248, 156, 84, 75, 13870, 14400, 14312) 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` = 2335

128

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (52, 8702, 14196, 14597, 99, 14436, 14468, 14416, 14476, 14335, 14746, 14679, 119, 14463, 14153, 14537, 14178, 14443, 13562, 14465, 10251, 14266, 14538, 130, 14501, 14470, 14445, 14686, 14389, 14749, 14258, 14678, 14136, 179, 3725, 14611, 14744, 14575, 14414, 14220, 14224, 14402, 14175, 13867, 14604, 14613, 14483, 9051, 14234, 14672, 14265, 113, 11457, 14750, 14235, 14194, 14745, 11461, 14449, 14539, 14347, 14236, 14237, 14396, 14154, 13871, 14386, 14614, 14244, 14751, 14605, 14609, 14267, 14333, 14479, 14452, 14446, 14197, 14245, 14221, 14570, 14410, 107, 14752, 14753, 14417, 14330, 13874, 14428, 14444, 14268, 14433, 14685, 14477, 14464, 14434, 14270, 14630, 14432, 14680, 14252, 14596, 14087, 14599, 14554, 14415, 14264, 13568, 14641, 95, 161, 14608, 14261, 14241, 14606, 14460, 14257, 14688, 14497, 14754, 14534, 14248, 156, 84, 75, 13870, 14400, 14312)) AND (`Playercontest`.`contest_id` = 2335))

128

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

123

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

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