back to overall

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

NationR128R64R32R16QFSFFChampion
1.Serbia (SRB)[1]Novak Djokovic
Novak Djokovic
2.Poland (POL)Hubert Hurkacz6-4 6-2 6-2
Novak Djokovic
3.Switzerland (SUI)[LL]Henri Laaksonen6-1 6-4 6-3
Henri Laaksonen
4.Spain (ESP)[Q]Pedro Martinez6-1 6-0 7-6(4)
Novak Djokovic
5.Italy (ITA)[Q]Salvatore Caruso6-3 6-3 6-2
Salvatore Caruso
6.Spain (ESP)Jaume Munar7-5 4-6 6-3 6-3
Salvatore Caruso
7.France (FRA)[26]Gilles Simon6-1 6-2 6-4
Gilles Simon
8.Ukraine (UKR)[LL]Sergiy Stakhovsky6-3 6-3 6-4
Novak Djokovic
9.Germany (GER)Jan-Lennard Struff6-3 6-2 6-2
Jan-Lennard Struff
10.Canada (CAN)[20]Denis Shapovalov7-6(1) 6-3 6-4
Jan-Lennard Struff
11.Moldova (MDA)Radu Albot7-6(2) 7-6(3) 6-7(4) 6-2
Radu Albot
12.United States (USA)[Q]Tennys Sandgren7-6(3) 7-6(1) 3-6 6-1
Jan-Lennard Struff
13.South Africa (RSA)Lloyd Harris4-6 6-1 4-6 7-6(1) 11-9
Lloyd Harris
14.Czech Republic (CZE)[LL]Lukas Rosol6-1 4-6 2-6 6-1 6-2
Borna Coric
15.Croatia (CRO)[13]Borna Coric6-2 6-3 7-6(2)
Borna Coric
16.Slovenia (SLO)Aljaz Bedene6-1 6-7(4) 6-4 6-4
Novak Djokovic
17.Italy (ITA)[9]Fabio Fognini7-5 6-2 6-2
Fabio Fognini
18.Italy (ITA)Andreas Seppi6-3 6-0 3-6 6-3
Fabio Fognini
19.Argentina (ARG)Federico Delbonis6-4 3-6 6-3 6-3
Federico Delbonis
20.Spain (ESP)[Q]Guillermo Garcia-Lopez6-1 3-6 6-3 6-2
Fabio Fognini
21.United States (USA)Taylor Fritz7-6(5) 6-4 4-6 6-1
Taylor Fritz
22.Australia (AUS)Bernard Tomic6-1 6-4 6-1
Roberto Bautista Agut
23.Spain (ESP)[18]Roberto Bautista Agut6-2 6-3 6-2
Roberto Bautista Agut
24.United States (USA)Steve Johnson6-3 6-4 6-2
Alexander Zverev
25.Serbia (SRB)[30]Dusan Lajovic3-6 6-2 6-2 7-6(5)
Dusan Lajovic
26.Brazil (BRA)[Q]Thiago Monteiro6-3 6-4 6-4
Dusan Lajovic
27.France (FRA)[Q]Elliot Benchetrit6-3 6-3 6-4
Elliot Benchetrit
28.United Kingdom (GBR)Cameron Norrie6-3 6-0 6-2
Alexander Zverev
29.Sweden (SWE)[Q]Mikael Ymer6-4 6-2 4-6 1-6 6-2
Mikael Ymer
30.Slovenia (SLO)[Q]Blaz Rola6-0 6-3 7-6(5)
Alexander Zverev
31.Germany (GER)[5]Alexander Zverev6-1 6-3 7-6(3)
Alexander Zverev
32.Australia (AUS)John Millman7-6(4) 6-3 2-6 6-7(5) 6-3
Dominic Thiem
33.Austria (AUT)[4]Dominic Thiem6-2 3-6 7-5 5-7 7-5
Dominic Thiem
34.United States (USA)[WC]Tommy Paul6-4 4-6 7-6(5) 6-2
Dominic Thiem
35.Kazakhstan (KAZ)Alexander Bublik6-3 6-7(6) 6-3 7-5
Alexander Bublik
36.Germany (GER)[Q]Rudolf Molleker7-5 6-7(4) 6-1 7-6(2)
Dominic Thiem
37.Uruguay (URU)Pablo Cuevas6-3 4-6 6-2 7-5
Pablo Cuevas
38.France (FRA)[WC]Maxime Janvier6-4 6-4 6-2
Pablo Cuevas
39.United Kingdom (GBR)[28]Kyle Edmund7-6(3) 6-3 2-1 rtd.
Kyle Edmund
40.France (FRA)Jeremy Chardy7-6(1) 5-7 6-4 4-6 7-5
Dominic Thiem
41.Spain (ESP)[23]Fernando Verdasco6-4 6-4 6-2
Fernando Verdasco
42.United Kingdom (GBR)Daniel Evans6-3 6-7(4) 6-3 6-2
Antoine Hoang
43.France (FRA)[WC]Antoine Hoang6-4 3-6 7-6(5) 7-5
Antoine Hoang
44.Bosnia and Herzegovina (BIH)Damir Dzumhur6-4 0-6 7-6(5) 6-3
Gael Monfils
45.France (FRA)Adrian Mannarino 6-3 6-2 6-3
Adrian Mannarino
46.Italy (ITA)[Q]Stefano Travaglia6-7(5) 6-3 3-6 6-2 6-2
Gael Monfils
47.France (FRA)[14]Gael Monfils6-3 6-4 6-4
Gael Monfils
48.Japan (JPN)Taro Daniel6-0 6-4 6-1
Dominic Thiem
49.Russia (RUS)[10]Karen Khachanov6-2 6-4 6-2
Karen Khachanov
50.Germany (GER)Cedrik-Marcel Stebe6-1 6-1 6-4
Karen Khachanov
51.France (FRA)[WC]Gregoire Barrere6-3 7-6(6) 0-6 7-5
Gregoire Barrere
52.Australia (AUS)Matthew Ebden6-3 5-7 7-5 6-1
Karen Khachanov
53.Slovakia (SVK)Martin Klizan6-1 6-4 6-3
Martin Klizan
54.Kazakhstan (KAZ)Mikhail Kukushkin 3-6 5-7 6-4 6-2 6-3
Martin Klizan
55.France (FRA)[22]Lucas Pouille7-6(4) 2-6 6-3 3-6 9-7
Lucas Pouille
56.Italy (ITA)[Q]Simone Bolelli6-3 6-4 7-5
Karen Khachanov
57.Australia (AUS)Jordan Thompson7-5 6-3 3-6 6-3
Jordan Thompson
58.Spain (ESP)[LL]Alejandro Davidovich Fokina6-3 6-2 7-6(3)
Jordan Thompson
59.Croatia (CRO)Ivo Karlovic6-3 6-4 6-7(2) 6-3
Ivo Karlovic
60.Spain (ESP)Feliciano Lopez7-6(4) 7-5 6-7(7) 7-5
Juan Martin Del Potro
61.Japan (JPN)Yoshihito Nishioka6-4 6-4 6-0
Yoshihito Nishioka
62.United States (USA)Mackenzie McDonald6-7(7) 6-0 4-6 6-2 6-3
Juan Martin Del Potro
63.Argentina (ARG)[8]Juan Martin Del Potro 5-7 6-4 6-2 6-7(5) 6-2
Juan Martin Del Potro
64.Chile (CHI)Nicolas Jarry3-6 6-2 6-1 6-4
Rafael Nadal
65.Greece (GRE)[6]Stefanos Tsitsipas6-3 5-7 6-1 6-1
Stefanos Tsitsipas
66.Germany (GER)Maximilian Marterer6-2 6-2 7-6(4)
Stefanos Tsitsipas
67.Bolivia (BOL)Hugo Dellien4-6 6-0 6-3 7-5
Hugo Dellien
68.India (IND)Prajnesh Gunneswaran6-1 6-3 6-1
Stefanos Tsitsipas
69.Spain (ESP)Roberto Carballes Baena7-5 6-3 6-7(5) 7-6(6)
Roberto Carballes Baena
70.France (FRA)[Q]Alexandre Muller6-4 6-4 6-2
Filip Krajinovic
71.Serbia (SRB)Filip Krajinovic6-4 6-4 6-7(1) 3-6 8-6
Filip Krajinovic
72.United States (USA)[32]Frances Tiafoe6-2 4-6 6-3 3-6 6-0
Stan Wawrinka
73.Switzerland (SUI)[24]Stan Wawrinka7-6(6) 5-7 6-4 3-6 8-6
Stan Wawrinka
74.Slovakia (SVK)Jozef Kovalik6-1 6-7(3) 6-2 6-3
Stan Wawrinka
75.Chile (CHI)Cristian Garin6-1 6-4 6-0
Cristian Garin
76.United States (USA)Reilly Opelka7-6(0) 7-5 7-6(7)
Stan Wawrinka
77.Bulgaria (BUL)Grigor Dimitrov 7-6(5) 7-6(4) 7-6(8)
Grigor Dimitrov
78.Serbia (SRB)Janko Tipsarevic6-3 6-0 3-6 6-7(4) 6-4
Grigor Dimitrov
79.Croatia (CRO)[11]Marin Cilic6-7(3) 6-4 4-6 7-6(2) 6-3
Marin Cilic
80.Italy (ITA)Thomas Fabbiano6-3 7-5 6-1
Roger Federer
81.France (FRA)[WC]Nicolas Mahut7-6(4) 4-6 7-6(5) 6-4
Nicolas Mahut
82.Italy (ITA)[16]Marco Cecchinato2-6 6-7(2) 6-4 6-2 6-4
Nicolas Mahut
83.Germany (GER)Philipp Kohlschreiber6-3 6-3 6-3
Philipp Kohlschreiber
84.Netherlands (NED)Robin Haase6-4 6-4 6-7(5) 6-1
Leonardo Mayer
85.Argentina (ARG)Leonardo Mayer3-6 7-6(3) 6-4 7-6(3)
Leonardo Mayer
86.Czech Republic (CZE)Jiri Vesely7-6(3) 6-3 6-0
Leonardo Mayer
87.Argentina (ARG)[17]Diego Schwartzman4-6 6-3 6-4 7-5
Diego Schwartzman
88.Hungary (HUN)Marton Fucsovics6-3 3-6 7-6(7) 2-6 6-2
Roger Federer
89.Italy (ITA)[29]Matteo Berrettini6-2 6-3 6-3
Matteo Berrettini
90.Spain (ESP)Pablo Andujar6-7(3) 6-4 6-4 6-2
Casper Ruud
91.Norway (NOR)Casper Ruud6-4 7-5 6-3
Casper Ruud
92.Latvia (LAT)Ernests Gulbis6-2 7-6(2) 6-0
Roger Federer
93.Germany (GER)[LL]Oscar Otte6-3 6-1 7-6(8)
Oscar Otte
94.Tunisia (TUN)Malek Jaziri6-3 6-1 4-6 6-0
Roger Federer
95.Switzerland (SUI)[3]Roger Federer6-4 6-3 6-4
Roger Federer
96.Italy (ITA)Lorenzo Sonego6-2 6-4 6-4
Rafael Nadal
97.Japan (JPN)[7]Kei Nishikori6-3 6-4 6-2
Kei Nishikori
98.France (FRA)[WC]Quentin Halys6-2 6-3 6-4
Kei Nishikori
99.France (FRA)Jo-Wilfried Tsonga4-6 6-4 6-4 6-4
Jo-Wilfried Tsonga
100.Germany (GER)Peter Gojowczyk 7-6(4) 6-1 4-6 6-3
Kei Nishikori
101.Australia (AUS)[WC]Alexei Popyrin6-4 6-7(6) 6-3 4-6 8-6
Alexei Popyrin
102.France (FRA)Ugo Humbert3-6 6-3 7-6(10) 6-3
Laslo Djere
103.Serbia (SRB)[31]Laslo Djere6-4 7-6(4) 6-4
Laslo Djere
104.Spain (ESP)Albert Ramos-Vinolas6-3 6-2 7-6(2)
Kei Nishikori
105.Australia (AUS)[21]Alex de Minaur6-2 6-7(8) 6-2 6-7(8) 7-5
Alex de Minaur
106.United States (USA)Bradley Klahn6-1 6-4 6-4
Pablo Carreno Busta
107.Spain (ESP)Pablo Carreno Busta6-3 6-1 6-1
Pablo Carreno Busta
108.Portugal (POR)Joao Sousa6-3 6-1 6-2
Benoit Paire
109.France (FRA)Benoit Paire6-2 4-6 7-6(1) rtd.
Benoit Paire
110.Romania (ROU)Marius Copil6-4 6-7(5) 6-0 6-1
Benoit Paire
111.France (FRA)Pierre-Hugues Herbert6-2 6-2 5-7 6-7(6) 11-9
Pierre-Hugues Herbert
112.Russia (RUS)[12]Daniil Medvedev4-6 4-6 6-3 6-2 7-5
Rafael Nadal
113.Argentina (ARG)Juan Londero6-1 6-1 6-3
Juan Londero
114.Georgia (GEO)[15]Nikoloz Basilashvili6-4 6-1 6-3
Juan Londero
115.France (FRA)Richard Gasquet6-2 3-6 6-3 6-4
Richard Gasquet
116.Germany (GER)Mischa Zverev6-3 6-4 6-3
Juan Londero
117.France (FRA)[WC]Corentin Moutet2-6 6-3 6-4 5-7 6-4
Corentin Moutet
118.Russia (RUS)[Q]Alexey Vatutin6-4 7-6(6) 6-4
Corentin Moutet
119.Argentina (ARG)[19]Guido Pella6-3 6-1 2-6 7-5
Guido Pella
120.Argentina (ARG)Guido Andreozzi7-6(2) 6-4 1-6 6-1
Rafael Nadal
121.Belgium (BEL)[27]David Goffin6-2 6-3 6-3
David Goffin
122.Lithuania (LTU)Ricardas Berankis6-0 6-2 6-2
David Goffin
123.Serbia (SRB)Miomir Kecmanovic6-2 6-4 6-3
Miomir Kecmanovic
124.United States (USA)Denis Kudla6-0 6-7(7) 5-7 6-3 6-4
Rafael Nadal
125.Germany (GER)[Q]Yannick Maden6-1 6-3 4-6 6-3
Yannick Maden
126.Belgium (BEL)[Q]Kimmer Coppejans7-6(0) 7-5 6-3
Rafael Nadal
127.Spain (ESP)[2]Rafael Nadal6-1 6-2 6-4
Rafael Nadal
128.Germany (GER)[Q]Yannick Hanfmann6-2 6-1 6-3
(default) 17 queries took 28 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `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 1119
2SELECT `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)551
3SELECT `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)551
4SELECT `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)551
5SELECT `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 1111
6SELECT `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` ASC1231232
7SELECT `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` = '2019' LIMIT 1111
8SELECT `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` = (2266) ORDER BY `Match`.`round_id` ASC, `Match`.`no` ASC1271271
9SELECT `Player`.`id`, `Player`.`name`, `Player`.`gender`, `Player`.`slug` FROM `zavoihu1_db4tennis`.`players` AS `Player` WHERE `Player`.`id` IN (52, 14270, 14254, 14386, 14260, 14265, 100, 152, 11457, 14252, 13869, 14084, 14332, 62, 13870, 10225, 119, 74, 11454, 94, 14178, 138, 113, 4775, 13562, 14236, 14271, 14248, 14387, 13563, 14136, 10177, 13580, 14153, 14235, 14350, 5934, 14275, 11473, 160, 139, 9051, 14388, 13567, 130, 14255, 99, 13871, 14224, 64, 14194, 105, 3580, 95, 11452, 3585, 13568, 14389, 141, 171, 13874, 14220, 131, 14241, 14245, 14264, 14390, 14348, 14196, 14244, 8925, 14087, 156, 14175, 14256, 14238, 161, 68, 3722, 13538, 58, 14146, 122, 66, 170, 11453, 13616, 14221, 14263, 79, 14258, 89, 14274, 3728, 147, 14267, 107, 14125, 115, 174, 14266, 14333, 14197, 149, 14234, 5049, 11461, 13674, 157, 14094, 8702, 14237, 14391, 14122, 75, 7301, 14261, 14392, 6780, 6785, 3725, 8674, 14347, 177, 14318, 14128, 179, 14335) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC1281281
10SELECT `Playercontest`.`id`, `Playercontest`.`player_id`, `Playercontest`.`contest_id`, `Playercontest`.`nat_id`, `Playercontest`.`draw` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE `Playercontest`.`contest_id` = 22661281281
11SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (196, 92, 179, 197, 84, 173, 41, 68, 21, 72, 104, 164, 13, 14, 194, 150, 36, 10, 139, 53, 169, 94, 29, 154, 96, 168, 86, 133, 172, 149, 189, 50, 27, 31, 26, 198, 153, 110, 71, 123, 74, 178)42421
12SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (196, 92, 179, 197, 84, 173, 41, 68, 21, 72, 104, 164, 13, 14, 194, 150, 36, 10, 139, 53, 169, 94, 29, 154, 96, 168, 86, 133, 172, 149, 189, 50, 27, 31, 26, 198, 153, 110, 71, 123, 74, 178)42421
13SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (52, 14270, 14254, 14386, 14260, 14265, 100, 152, 11457, 14252, 13869, 14084, 14332, 62, 13870, 10225, 119, 74, 11454, 94, 14178, 138, 113, 4775, 13562, 14236, 14271, 14248, 14387, 13563, 14136, 10177, 13580, 14153, 14235, 14350, 5934, 14275, 11473, 160, 139, 9051, 14388, 13567, 130, 14255, 99, 13871, 14224, 64, 14194, 105, 3580, 95, 11452, 3585, 13568, 14389, 141, 171, 13874, 14220, 131, 14241, 14245, 14264, 14390, 14348, 14196, 14244, 8925, 14087, 156, 14175, 14256, 14238, 161, 68, 3722, 13538, 58, 14146, 122, 66, 170, 11453, 13616, 14221, 14263, 79, 14258, 89, 14274, 3728, 147, 14267, 107, 14125, 115, 174, 14266, 14333, 14197, 149, 14234, 5049, 11461, 13674, 157, 14094, 8702, 14237, 14391, 14122, 75, 7301, 14261, 14392, 6780, 6785, 3725, 8674, 14347, 177, 14318, 14128, 179, 14335)) AND (`Playercontest`.`contest_id` = 2266))1281281
14SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 12 ORDER BY `Contest`.`date_from` ASC1231231
15SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 201910102
16SELECT `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'442
17SELECT `Tournament`.`slug`, `Tournament`.`name` FROM `zavoihu1_db4tennis`.`tournaments` AS `Tournament` WHERE `Tournament`.`id` IN (1, 2, 3, 4)441