back to overall

US Open 2023 Men's Singles  (August 28 - September 10)

NationR128R64R32R16QFSFFChampion
1.Spain (ESP)[1]Carlos Alcaraz
Carlos Alcaraz
2.Germany (GER)Dominik Koepfer6-2 3-2 rtd.
Carlos Alcaraz
3.South Africa (RSA)Lloyd Harris6-3 6-1 7-6(4)
Lloyd Harris
4.Argentina (ARG)Guido Pella7-6(5) 6-4 6-4
Carlos Alcaraz
5.Netherlands (NED)Botic van de Zandschulp6-2 6-3 4-6 6-3
Botic van de Zandschulp
6.Australia (AUS)Jordan Thompson6-3 rtd.
Daniel Evans
7.United Kingdom (GBR)[26]Daniel Evans1-6 6-1 6-3 6-3
Daniel Evans
8.Colombia (COL)Daniel Elahi Galan6-4 6-2 7-5
Carlos Alcaraz
9.France (FRA)Arthur Fils6-3 6-3 6-4
Arthur Fils
10.Netherlands (NED)[24]Tallon Griekspoor4-6 6-3 5-7 6-4 7-5
Matteo Arnaldi
11.Italy (ITA)Matteo Arnaldi3-6 7-5 7-6(5) 5-7 6-4
Matteo Arnaldi
12.Australia (AUS)Jason Kubler6-3 1-0 rtd.
Matteo Arnaldi
13.Taiwan (TPE)[Q]Yu-hsiou Hsu6-3 6-4 6-3
Yu-hsiou Hsu
14.Australia (AUS)Thanasi Kokkinakis6-3 6-4 3-6 6-3
Cameron Norrie
15.United Kingdom (GBR)[16]Cameron Norrie7-5 6-4 6-4
Cameron Norrie
16.Russia (RUS)Alexander Shevchenko6-3 6-2 6-2
Carlos Alcaraz
17.Germany (GER)[12]Alexander Zverev6-3 6-2 6-4
Alexander Zverev
18.Australia (AUS)Aleksandar Vukic6-4 6-4 6-4
Alexander Zverev
19.Germany (GER)Daniel Altmaier7-6(1) 3-6 6-4 6-3
Daniel Altmaier
20.France (FRA)Constant Lestienne6-7(5) 6-3 6-1 6-2
Alexander Zverev
21.United Kingdom (GBR)Andy Murray6-7(2) 7-6(8) 6-1 6-1
Andy Murray
22.France (FRA)Corentin Moutet6-2 7-5 6-3
Grigor Dimitrov
23.Bulgaria (BUL)[19]Grigor Dimitrov 6-3 6-4 6-1
Grigor Dimitrov
24.Slovakia (SVK)Alex Molcan6-7(9) 6-7(5) 6-1 7-5 7-6(9)
Alexander Zverev
25.Argentina (ARG)[30]Tomas Martin Etcheverry6-4 3-6 6-2 4-6 6-3
Tomas Martin Etcheverry
26.Finland (FIN)[Q]Otto Virtanen6-3 6-7(3) 1-6 6-4 7-6(5)
Stan Wawrinka
27.Switzerland (SUI)Stan Wawrinka7-6(6) 6-7(7) 6-3 6-2
Stan Wawrinka
28.Japan (JPN)Yoshihito Nishioka7-6(5) 6-2 6-4
Jannik Sinner
29.Italy (ITA)Lorenzo Sonego6-3 2-6 6-4 6-2
Lorenzo Sonego
30.United States (USA)[Q]Nicolas Moreno de Alboran6-3 6-4 6-2
Jannik Sinner
31.Italy (ITA)[6]Jannik Sinner6-4 6-2 6-4
Jannik Sinner
32.Germany (GER)Yannick Hanfmann6-3 6-1 6-1
Daniil Medvedev
33.Russia (RUS)[3]Daniil Medvedev7-6(3) 6-1 3-6 6-3
Daniil Medvedev
34.Hungary (HUN)Attila Balazs6-1 6-1 6-0
Daniil Medvedev
35.Australia (AUS)Christopher O'Connell6-2 6-2 6-7(8) 6-2
Christopher O'Connell
36.Australia (AUS)Max Purcell6-4 6-3 3-6 7-6(5)
Daniil Medvedev
37.Brazil (BRA)[Q]Felipe Meligeni Alves6-2 6-2 7-6(6)
Felipe Meligeni Alves
38.Australia (AUS)[LL]James Duckworth6-4 7-6(11) 6-3
Sebastian Baez
39.Argentina (ARG)Sebastian Baez6-7(7) 6-4 6-4 rtd.
Sebastian Baez
40.Croatia (CRO)[27]Borna Coric7-5 7-5 6-1
Daniil Medvedev
41.Chile (CHI)[23]Nicolas Jarry2-6 6-4 6-1 6-2
Nicolas Jarry
42.France (FRA)Luca van Assche6-3 3-6 6-2 7-6(3)
Nicolas Jarry
43.United States (USA)[WC]Alex Michelsen4-6 6-3 6-3 6-3
Alex Michelsen
44.Spain (ESP)Albert Ramos-Vinolas6-4 6-3 6-4
Alex de Minaur
45.China (CHN)Yibing Wu6-1 6-3 6-2
Yibing Wu
46.Serbia (SRB)Dusan Lajovic3-6 6-4 2-6 6-4 6-2
Alex de Minaur
47.Australia (AUS)[13]Alex de Minaur6-1 6-2 6-1
Alex de Minaur
48.Kazakhstan (KAZ)[Q]Timofey Skatov6-2 3-6 6-1 7-5
Daniil Medvedev
49.United States (USA)[WC]Michael Mmoh6-4 6-3 6-4
Michael Mmoh
50.Russia (RUS)[11]Karen Khachanov6-2 6-4 6-2
Michael Mmoh
51.United States (USA)[WC]John Isner3-6 4-6 7-6(3) 6-4 7-6(7)
John Isner
52.Argentina (ARG)Facundo Diaz Acosta6-4 6-3 7-6(1)
Jack Draper
53.United Kingdom (GBR)Jack Draper6-4 6-2 3-6 6-3
Jack Draper
54.Moldova (MDA)Radu Albot6-1 6-4 6-3
Jack Draper
55.Poland (POL)[17]Hubert Hurkacz6-2 6-4 7-5
Hubert Hurkacz
56.Switzerland (SUI)Marc-Andrea Huesler4-6 5-7 7-6(0) 6-3 6-1
Andrey Rublev
57.Italy (ITA)Matteo Berrettini6-3 3-6 6-3 6-4
Matteo Berrettini
58.France (FRA)[29]Ugo Humbert6-4 6-2 6-2
Arthur Rinderknech
59.France (FRA)Arthur Rinderknech6-4 5-3 rtd.
Arthur Rinderknech
60.Argentina (ARG)Diego Schwartzman6-3 6-4 6-2
Andrey Rublev
61.France (FRA)Gael Monfils3-6 6-3 6-1 7-5
Gael Monfils
62.Japan (JPN)[Q]Taro Daniel4-6 6-4 6-2 7-6(4)
Andrey Rublev
63.Russia (RUS)Andrey Rublev6-4 6-3 3-6 6-1
Andrey Rublev
64.Finland (FIN)Emil Ruusuvuori6-4 7-6(5) 6-1
Novak Djokovic
65.Norway (NOR)[5]Casper Ruud6-3 7-6(5) 6-3
Casper Ruud
66.United States (USA)[Q]Emilio Nava7-6(5) 3-6 6-4 7-6(5)
Zhizhen Zhang
67.China (CHN)Zhizhen Zhang6-4 5-7 6-2 0-6 6-2
Zhizhen Zhang
68.United States (USA)Jeffrey Wolf7-5 7-5 6-7(5) 4-6 6-3
Rinky Hijikata
69.Australia (AUS)[WC]Rinky Hijikata6-3 6-3 4-6 6-3
Rinky Hijikata
70.Russia (RUS)Pavel Kotov7-5 5-7 6-3 7-5
Rinky Hijikata
71.Hungary (HUN)Marton Fucsovics6-1 6-2 6-1
Marton Fucsovics
72.United States (USA)[31]Sebastian Korda7-6(4) 4-6 7-6(1) 4-6 6-4
Frances Tiafoe
73.France (FRA)[22]Adrian Mannarino 6-4 6-1 6-4
Adrian Mannarino
74.Japan (JPN)Yosuke Watanuki7-5 6-7(3) 6-3 7-5
Adrian Mannarino
75.Hungary (HUN)Fabian Marozsan3-6 6-3 6-4 6-1
Fabian Marozsan
76.France (FRA)Richard Gasquet6-3 6-1 6-7(5) 6-7(1) 6-2
Frances Tiafoe
77.Austria (AUT)Sebastian Ofner4-6 6-2 6-3 7-6(6)
Sebastian Ofner
78.Portugal (POR)Nuno Borges7-6(5) 3-6 7-6(7) 6-4
Frances Tiafoe
79.United States (USA)[10]Frances Tiafoe6-3 6-1 6-4
Frances Tiafoe
80.United States (USA)[WC]Learner Tien6-2 7-5 6-1
Ben Shelton
81.United States (USA)[14]Tommy Paul6-2 3-6 7-6(7) 6-2
Tommy Paul
82.Italy (ITA)[Q]Stefano Travaglia6-2 6-3 4-6 6-1
Tommy Paul
83.Russia (RUS)Roman Safiullin3-6 2-6 6-2 6-4 6-3
Roman Safiullin
84.Italy (ITA)Marco Cecchinato6-4 6-2 6-0
Tommy Paul
85.Argentina (ARG)Juan Manuel Cerundolo6-1 6-0 3-6 6-3
Juan Manuel Cerundolo
86.Belarus (BLR)Ilya Ivashka2-6 6-7(4) 6-3 6-3 6-3
Alejandro Davidovich Fokina
87.Spain (ESP)[21]Alejandro Davidovich Fokina6-1 6-4 6-3
Alejandro Davidovich Fokina
88.United States (USA)Marcos Giron6-4 6-4 6-2
Ben Shelton
89.Austria (AUT)Dominic Thiem6-4 6-3 4-6 6-4
Dominic Thiem
90.Kazakhstan (KAZ)[25]Alexander Bublik6-3 6-2 6-4
Ben Shelton
91.United States (USA)Ben Shelton7-6(1) 1-0 rtd.
Ben Shelton
92.Argentina (ARG)Pedro Cachin1-6 6-3 6-2 6-4
Ben Shelton
93.Russia (RUS)Aslan Karatsev6-4 3-6 6-2 6-0
Aslan Karatsev
94.Czech Republic (CZE)Jiri Lehecka6-3 6-3 6-3
Aslan Karatsev
95.Spain (ESP)Roberto Carballes Baena6-2 4-6 6-3 7-6(4)
Roberto Carballes Baena
96.Denmark (DEN)[4]Holger Rune6-3 4-6 6-3 6-2
Novak Djokovic
97.Greece (GRE)[7]Stefanos Tsitsipas6-3 6-2 7-6(4)
Stefanos Tsitsipas
98.Canada (CAN)Milos Raonic6-2 6-3 6-4
Dominic Stricker
99.Switzerland (SUI)[Q]Dominic Stricker7-5 6-7(2) 6-7(5) 7-6(6) 6-3
Dominic Stricker
100.Australia (AUS)Alexei Popyrin6-3 6-4 3-6 6-3
Dominic Stricker
101.France (FRA)[WC]Benjamin Bonzi2-6 7-5 7-6(4) 3-6 6-2
Benjamin Bonzi
102.France (FRA)Quentin Halys5-7 6-4 6-4 6-4
Benjamin Bonzi
103.United States (USA)[28]Christopher Eubanks7-6(6) 2-6 6-2 7-6(7)
Christopher Eubanks
104.South Korea (KOR)Soon-woo Kwon6-3 6-4 0-6 6-4
Taylor Fritz
105.France (FRA)[Q]Titouan Droguet7-6(2) 6-4 6-4
Titouan Droguet
106.Italy (ITA)[18]Lorenzo Musetti6-3 0-6 6-7(5) 6-3 6-2
Jakub Mensik
107.Czech Republic (CZE)[Q]Jakub Mensik3-6 6-2 7-6(1) 6-3
Jakub Mensik
108.France (FRA)Gregoire Barrere6-4 4-6 7-6(1) 6-2
Taylor Fritz
109.Peru (PER)Juan Pablo Varillas6-1 6-2 6-0
Juan Pablo Varillas
110.Serbia (SRB)Miomir Kecmanovic1-6 7-5 7-5 6-4
Taylor Fritz
111.United States (USA)[9]Taylor Fritz6-1 6-2 6-2
Taylor Fritz
112.United States (USA)[WC]Steve Johnson6-2 6-1 6-2
Novak Djokovic
113.United States (USA)Mackenzie McDonald6-1 6-4 6-4
Mackenzie McDonald
114.Canada (CAN)[15]Felix Auger-Aliassime7-6(5) 4-6 6-1 6-4
Borna Gojo
115.Croatia (CRO)[Q]Borna Gojo6-3 6-4 6-4
Borna Gojo
116.Bolivia (BOL)Hugo Dellien6-3 6-3 6-1
Borna Gojo
117.Czech Republic (CZE)Jiri Vesely6-4 6-3 6-2
Jiri Vesely
118.France (FRA)[Q]Enzo Couacaud5-7 6-3 6-2 3-6 6-4
Jiri Vesely
119.Argentina (ARG)[20]Francisco Cerundolo7-6(5) 6-2 3-6 2-6 7-6(6)
Francisco Cerundolo
120.United States (USA)[Q]Zachary Svajda5-7 6-4 6-4 6-3
Novak Djokovic
121.Serbia (SRB)[32]Laslo Djere6-2 7-5 6-4
Laslo Djere
122.United States (USA)Brandon Nakashima7-5 6-4 6-4
Laslo Djere
123.France (FRA)[Q]Hugo Gaston6-1 6-2 6-3
Hugo Gaston
124.Japan (JPN)[Q]Sho Shimabukuro6-2 6-1 7-6(4)
Novak Djokovic
125.Spain (ESP)Bernabe Zapata Miralles4-6 4-6 6-1 6-1 6-3
Bernabe Zapata Miralles
126.United States (USA)[WC]Ethan Quinn6-4 6-4 6-3
Novak Djokovic
127.Serbia (SRB)[2]Novak Djokovic6-4 6-1 6-1
Novak Djokovic
128.France (FRA)Alexandre Muller6-0 6-2 6-3
(default) 17 queries took 29 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` = 'us-open' LIMIT 1111
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` = (4)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` = (4)331
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` = (4)221
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` = 'us-open' 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` = (22) ORDER BY `Contest`.`year` ASC1441442
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` = 4 AND `Contest`.`category_id` = 22 AND `Contest`.`slug` = '2023' LIMIT 1112
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` = (2317) ORDER BY `Match`.`round_id` ASC, `Match`.`no` ASC1271272
9SELECT `Player`.`id`, `Player`.`name`, `Player`.`gender`, `Player`.`slug` FROM `zavoihu1_db4tennis`.`players` AS `Player` WHERE `Player`.`id` IN (14464, 14396, 14332, 6780, 14463, 13568, 9051, 14416, 14609, 14414, 14605, 7856, 14598, 10251, 14248, 14606, 14136, 14452, 14446, 14597, 84, 14261, 161, 14485, 14501, 14679, 156, 13874, 14267, 14680, 14400, 14335, 14237, 14430, 14239, 14417, 14678, 71, 14497, 13870, 14241, 14596, 14672, 149, 14571, 13562, 14234, 14503, 14086, 14224, 164, 14607, 14477, 13869, 14270, 14552, 14263, 14333, 14445, 13616, 99, 13871, 14154, 14433, 14258, 14484, 14479, 14434, 14575, 14534, 14221, 14428, 130, 14595, 14641, 75, 14257, 14539, 14087, 14574, 14153, 14255, 14465, 14146, 14631, 14222, 14389, 13867, 13580, 14235, 14570, 14537, 14460, 14502, 14196, 14483, 14245, 60, 14612, 14266, 14246, 14125, 14312, 14268, 14681, 14468, 14682, 14194, 14530, 14347, 14178, 4775, 14220, 14330, 14533, 14390, 11453, 14471, 14476, 14401, 14197, 14432, 14410, 14627, 14469, 14673, 52, 14244) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC1281285
10SELECT `Playercontest`.`id`, `Playercontest`.`player_id`, `Playercontest`.`contest_id`, `Playercontest`.`nat_id`, `Playercontest`.`draw` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE `Playercontest`.`contest_id` = 23171281281
11SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (133, 68, 74, 92, 197, 13, 14, 179, 96, 94, 154, 10, 67, 139, 54, 36, 173, 196, 168, 53, 84, 164, 100, 72, 41, 20, 149, 181, 172, 50, 43, 31, 26, 150, 42, 147, 29, 123)38381
12SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (133, 68, 74, 92, 197, 13, 14, 179, 96, 94, 154, 10, 67, 139, 54, 36, 173, 196, 168, 53, 84, 164, 100, 72, 41, 20, 149, 181, 172, 50, 43, 31, 26, 150, 42, 147, 29, 123)38381
13SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (14464, 14396, 14332, 6780, 14463, 13568, 9051, 14416, 14609, 14414, 14605, 7856, 14598, 10251, 14248, 14606, 14136, 14452, 14446, 14597, 84, 14261, 161, 14485, 14501, 14679, 156, 13874, 14267, 14680, 14400, 14335, 14237, 14430, 14239, 14417, 14678, 71, 14497, 13870, 14241, 14596, 14672, 149, 14571, 13562, 14234, 14503, 14086, 14224, 164, 14607, 14477, 13869, 14270, 14552, 14263, 14333, 14445, 13616, 99, 13871, 14154, 14433, 14258, 14484, 14479, 14434, 14575, 14534, 14221, 14428, 130, 14595, 14641, 75, 14257, 14539, 14087, 14574, 14153, 14255, 14465, 14146, 14631, 14222, 14389, 13867, 13580, 14235, 14570, 14537, 14460, 14502, 14196, 14483, 14245, 60, 14612, 14266, 14246, 14125, 14312, 14268, 14681, 14468, 14682, 14194, 14530, 14347, 14178, 4775, 14220, 14330, 14533, 14390, 11453, 14471, 14476, 14401, 14197, 14432, 14410, 14627, 14469, 14673, 52, 14244)) AND (`Playercontest`.`contest_id` = 2317))1281286
14SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 22 ORDER BY `Contest`.`date_from` ASC1441441
15SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 202310101
16SELECT `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'441
17SELECT `Tournament`.`slug`, `Tournament`.`name` FROM `zavoihu1_db4tennis`.`tournaments` AS `Tournament` WHERE `Tournament`.`id` IN (1, 2, 3, 4)441