back to overall

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

NationR128R64R32R16QFSFFChampion
1.Spain (ESP)[1]Rafael Nadal
Rafael Nadal
2.Serbia (SRB)Dusan Lajovic7-6(6) 6-2 6-2
Rafael Nadal
3.Japan (JPN)Taro Daniel4-6 6-3 6-2 6-2
Taro Daniel
4.United States (USA)[WC]Tommy Paul6-1 4-6 4-6 6-2 6-2
Rafael Nadal
5.Japan (JPN)Yuichi Sugita6-7(3) 6-3 6-1 6-4
Yuichi Sugita
6.France (FRA)[WC]Geoffrey Blancaneaux6-2 6-2 6-0
Leonardo Mayer
7.Argentina (ARG)[LL]Leonardo Mayer6-7(3) 6-4 6-3 6-4
Leonardo Mayer
8.France (FRA)[26]Richard Gasquet3-6 6-2 6-4 6-2
Rafael Nadal
9.Italy (ITA)[Q]Stefano Travaglia6-2 6-4 6-1
Stefano Travaglia
10.Italy (ITA)[22]Fabio Fognini6-4 7-6(8) 3-6 6-0
Viktor Troicki
11.Serbia (SRB)Viktor Troicki7-6(6) 7-5 6-0
Viktor Troicki
12.Slovakia (SVK)Norbert Gombos3-6 6-3 3-6 6-4 6-3
Alexandr Dolgopolov
13.Ukraine (UKR)Alexandr Dolgopolov 6-1 6-0 6-4
Alexandr Dolgopolov
14.Germany (GER)Jan-Lennard Struff3-6 6-3 6-2 1-6 6-3
Alexandr Dolgopolov
15.Czech Republic (CZE)[15]Tomas Berdych3-6 6-1 7-6(5) 6-2
Tomas Berdych
16.United States (USA)Ryan Harrison6-4 6-2 7-6(4)
Rafael Nadal
17.Belgium (BEL)[9]David Goffin6-1 6-2 6-2
David Goffin
18.France (FRA)Julien Benneteau 6-4 2-6 6-4 6-2
David Goffin
19.Argentina (ARG)Guido Pella3-6 7-6(5) 6-7(2) 7-6(4) 6-3
Guido Pella
20.Belgium (BEL)Steve Darcis6-1 6-2 6-0
David Goffin
21.United States (USA)Donald Young7-5 5-1 rtd.
Donald Young
22.Germany (GER)[Q]Maximilian Marterer6-3 1-6 6-1 6-4
Gael Monfils
23.France (FRA)[18]Gael Monfils6-3 6-7(3) 6-4 2-6 7-5
Gael Monfils
24.France (FRA)Jeremy Chardy7-6(6) 6-3 6-4
Andrey Rublev
25.Bosnia and Herzegovina (BIH)Damir Dzumhur7-5 7-6(5) 6-3
Damir Dzumhur
26.Uruguay (URU)[27]Pablo Cuevas7-5 7-6(3) 6-1
Damir Dzumhur
27.Germany (GER)[Q]Cedrik-Marcel Stebe4-6 6-4 6-0 6-1
Cedrik-Marcel Stebe
28.Argentina (ARG)Nicolas Kicker5-7 6-3 6-1 6-1
Andrey Rublev
29.Russia (RUS)Andrey Rublev6-4 6-4 5-7 6-4
Andrey Rublev
30.United Kingdom (GBR)Aljaz Bedene6-1 6-4 6-4
Andrey Rublev
31.Bulgaria (BUL)[7]Grigor Dimitrov 7-5 7-6(3) 6-3
Grigor Dimitrov
32.Czech Republic (CZE)[Q]Vaclav Safranek6-1 6-4 6-2
Rafael Nadal
33.Switzerland (SUI)[3]Roger Federer4-6 6-0 6-3 6-2
Roger Federer
34.United States (USA)Frances Tiafoe4-6 6-2 6-1 1-6 6-4
Roger Federer
35.Russia (RUS)Mikhail Youzhny 6-1 6-7(3) 4-6 6-4 6-2
Mikhail Youzhny
36.Slovenia (SLO)Blaz Kavcic6-3 5-7 6-4 6-3
Roger Federer
37.Spain (ESP)Fernando Verdasco6-3 6-3 7-5
Fernando Verdasco
38.Canada (CAN)Vasek Pospisil6-2 rtd.
Feliciano Lopez
39.Spain (ESP)[31]Feliciano Lopez6-3 6-2 3-6 6-1
Feliciano Lopez
40.Russia (RUS)Andrey Kuznetsov6-4 7-6(4) 6-7(5) 6-2
Roger Federer
41.Germany (GER)[33]Philipp Kohlschreiber6-4 6-2 7-5
Philipp Kohlschreiber
42.United States (USA)[Q]Tim Smyczek6-1 6-4 6-4
Philipp Kohlschreiber
43.Colombia (COL)Santiago Giraldo6-2 6-1 3-0 rtd.
Santiago Giraldo
44.France (FRA)[Q]Vincent Millot6-1 6-0 4-6 4-6 6-4
Philipp Kohlschreiber
45.Tunisia (TUN)Malek Jaziri7-5 6-2 6-4
Malek Jaziri
46.Brazil (BRA)Thiago Monteiro7-6(5) 4-6 6-3 5-7 6-4
John Millman
47.Australia (AUS)John Millman6-1 7-6(1) 6-1
John Millman
48.Australia (AUS)[14]Nick Kyrgios6-3 1-6 6-4 6-1
Juan Martin Del Potro
49.Spain (ESP)[11]Roberto Bautista Agut7-5 3-6 7-6(8) 6-4
Roberto Bautista Agut
50.Italy (ITA)Andreas Seppi6-2 4-6 6-2 7-6(1)
Roberto Bautista Agut
51.Germany (GER)Dustin Brown6-1 6-3 7-6(3)
Dustin Brown
52.Brazil (BRA)Thomaz Bellucci6-4 6-3 6-2
Juan Martin Del Potro
53.Spain (ESP)[Q]Adrian Menendez6-3 6-3 6-4
Adrian Menendez
54.United States (USA)[WC]Patrick Kypson6-4 7-6(9) 6-1
Juan Martin Del Potro
55.Argentina (ARG)[24]Juan Martin Del Potro 6-2 6-3 7-6(3)
Juan Martin Del Potro
56.Switzerland (SUI)Henri Laaksonen6-4 7-6(3) 7-6(5)
Juan Martin Del Potro
57.France (FRA)[30]Adrian Mannarino 1-6 2-6 6-1 7-6(1) 6-4
Adrian Mannarino
58.Lithuania (LTU)Ricardas Berankis6-2 6-4 6-2
Adrian Mannarino
59.United States (USA)[WC]Bjorn Fratangelo6-3 6-7(4) 6-1 6-2
Bjorn Fratangelo
60.Croatia (CRO)Ivo Karlovic7-6(2) 6-4 3-6 7-6(4)
Dominic Thiem
61.United States (USA)[WC]Taylor Fritz7-5 6-3 6-4
Taylor Fritz
62.Cyprus (CYP)Marcos Baghdatis 6-4 6-4 6-3
Dominic Thiem
63.Austria (AUT)[6]Dominic Thiem6-4 6-4 4-6 7-5
Dominic Thiem
64.Australia (AUS)[WC]Alex de Minaur6-4 6-1 6-1
Rafael Nadal
65.United States (USA)[17]Sam Querrey 6-3 6-3 6-4
Sam Querrey
66.France (FRA)Gilles Simon6-4 6-3 6-4
Sam Querrey
67.Israel (ISR)Dudi Sela6-4 6-1 6-4
Dudi Sela
68.United States (USA)[WC]Christopher Eubanks6-2 6-4 6-2
Sam Querrey
69.Moldova (MDA)[Q]Radu Albot4-6 6-2 6-4 6-4
Radu Albot
70.United States (USA)Ernesto Escobedo7-5 4-6 6-2 6-4
Radu Albot
71.Taiwan (TPE)Yen-Hsun Lu 6-2 7-6(7) 5-7 0-6 7-6(2)
Yen-Hsun Lu
72.Russia (RUS)[25]Karen Khachanov4-6 6-2 6-3 6-3
Sam Querrey
73.Germany (GER)[23]Mischa Zverev6-2 6-2 6-1
Mischa Zverev
74.United States (USA)[WC]Thai-Son Kwiatkowski7-6(5) 4-6 4-6 7-5 6-3
Mischa Zverev
75.France (FRA)Benoit Paire6-3 6-2 3-6 6-7(3) 7-5
Benoit Paire
76.Slovakia (SVK)[LL]Lukas Lacko6-3 6-2 7-6(5)
Mischa Zverev
77.South Korea (KOR)Hyeon Chung6-4 6-3 7-6(5)
Hyeon Chung
78.Argentina (ARG)Horacio Zeballos Jr.3-6 7-6(8) 6-4 6-3
John Isner
79.United States (USA)[10]John Isner6-3 6-4 7-5
John Isner
80.France (FRA)Pierre-Hugues Herbert6-1 6-3 4-6 6-3
Kevin Anderson
81.Australia (AUS)Jordan Thompson7-6(5) 6-7(9) 6-3 7-6(7)
Jordan Thompson
82.United States (USA)[13]Jack Sock6-2 7-6(12) 1-6 5-7 6-4
Thomas Fabbiano
83.Italy (ITA)Thomas Fabbiano2-6 6-2 3-6 6-4 6-2
Thomas Fabbiano
84.Australia (AUS)[Q]John-Patrick Smith7-6(5) 6-4 3-6 7-6(4)
Paolo Lorenzi
85.Italy (ITA)Paolo Lorenzi6-2 6-4 6-4
Paolo Lorenzi
86.Portugal (POR)Joao Sousa4-6 6-3 7-6(4) 6-2
Paolo Lorenzi
87.Luxembourg (LUX)[19]Gilles Muller6-7(4) 6-3 7-6(4) 6-3
Gilles Muller
88.Australia (AUS)Bernard Tomic3-6 6-3 6-4 6-4
Kevin Anderson
89.South Africa (RSA)[28]Kevin Anderson6-4 6-3 6-7(4) 6-4
Kevin Anderson
90.United States (USA)[Q]Juan Cruz Aragone6-3 6-3 6-1
Kevin Anderson
91.Latvia (LAT)Ernests Gulbis6-3 7-5 6-4
Ernests Gulbis
92.Italy (ITA)Alessandro Giannessi6-4 6-7(3) 6-2 7-5
Kevin Anderson
93.Croatia (CRO)Borna Coric6-4 6-3 6-2
Borna Coric
94.Czech Republic (CZE)Jiri Vesely7-6(5) 7-6(2) 6-2
Borna Coric
95.Germany (GER)[4]Alexander Zverev3-6 7-5 7-6(1) 7-6(4)
Alexander Zverev
96.Barbados (BAR)[Q]Darian King7-6(9) 7-5 6-4
Kevin Anderson
97.France (FRA)[8]Jo-Wilfried Tsonga4-6 7-5 6-3 6-4
Jo-Wilfried Tsonga
98.Romania (ROU)Marius Copil6-3 6-3 6-4
Denis Shapovalov
99.Canada (CAN)[Q]Denis Shapovalov6-4 6-4 7-6(3)
Denis Shapovalov
100.Russia (RUS)Daniil Medvedev7-5 6-1 6-2
Denis Shapovalov
101.United States (USA)Steve Johnson3-6 6-3 6-3 1-0 rtd.
Steve Johnson
102.Spain (ESP)Nicolas Almagro 6-4 7-6(2) 7-6(5)
Kyle Edmund
103.United Kingdom (GBR)Kyle Edmund7-5 6-2 7-6(4)
Kyle Edmund
104.Netherlands (NED)[32]Robin Haase6-3 7-5 6-3
Pablo Carreno Busta
105.Spain (ESP)[20]Albert Ramos-Vinolas7-6(2) 7-6(4) 7-6(3)
Albert Ramos-Vinolas
106.Uzbekistan (UZB)Denis Istomin4-6 7-6(4) 7-5 6-7(3) 7-5
Nicolas Mahut
107.France (FRA)[Q]Nicolas Mahut4-6 6-4 4-6 6-3 6-0
Nicolas Mahut
108.Hungary (HUN)Marton Fucsovics6-3 2-6 6-4 2-6 7-6(3)
Pablo Carreno Busta
109.United Kingdom (GBR)[Q]Cameron Norrie6-3 6-4 6-3
Cameron Norrie
110.Russia (RUS)Dmitry Tursunov7-6(7) 6-1 rtd.
Pablo Carreno Busta
111.Spain (ESP)[12]Pablo Carreno Busta6-2 6-4 6-3
Pablo Carreno Busta
112.United States (USA)[Q]Evan King6-3 6-2 7-6(5)
Pablo Carreno Busta
113.France (FRA)[16]Lucas Pouille6-4 6-4 6-2
Lucas Pouille
114.Belgium (BEL)Ruben Bemelmans6-3 6-4 6-4
Lucas Pouille
115.United States (USA)Jared Donaldson7-5 6-4 4-6 3-6 6-4
Jared Donaldson
116.Georgia (GEO)Nikoloz Basilashvili6-0 4-6 6-3 7-6(6)
Lucas Pouille
117.Russia (RUS)Evgeny Donskoy2-6 6-3 6-4 6-4
Evgeny Donskoy
118.Austria (AUT)Andreas Haider-Maurer7-6(3) 5-1 rtd.
Mikhail Kukushkin
119.Kazakhstan (KAZ)[Q]Mikhail Kukushkin 6-4 6-4 7-5
Mikhail Kukushkin
120.Spain (ESP)[21]David Ferrer4-6 6-3 6-2 6-1
Diego Schwartzman
121.Argentina (ARG)[29]Diego Schwartzman7-6(3) 7-5 2-6 6-2
Diego Schwartzman
122.Argentina (ARG)Carlos Berlocq6-2 6-1 6-3
Diego Schwartzman
123.Serbia (SRB)Janko Tipsarevic6-2 6-4 7-5
Janko Tipsarevic
124.Australia (AUS)Thanasi Kokkinakis6-7(5) 3-6 6-1 7-6(2) 6-3
Diego Schwartzman
125.Germany (GER)Florian Mayer4-6 7-5 7-5 6-4
Florian Mayer
126.Brazil (BRA)Rogerio Dutra Da Silva7-5 0-6 6-3 6-4
Marin Cilic
127.Croatia (CRO)[5]Marin Cilic6-3 6-3 6-3
Marin Cilic
128.United States (USA)Tennys Sandgren6-4 6-3 3-6 6-3
(default) 17 queries took 22 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` = '2017' 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` = (2254) 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 (179, 13562, 13871, 14153, 13625, 14276, 170, 75, 14255, 119, 92, 14253, 132, 11457, 148, 85, 3725, 102, 6780, 127, 175, 14264, 99, 160, 13567, 5934, 64, 14242, 14154, 10225, 161, 14262, 147, 14087, 72, 129, 139, 3723, 171, 3720, 122, 5053, 54, 8924, 3728, 14236, 10177, 10252, 113, 74, 3717, 96, 3586, 14311, 131, 14254, 130, 8674, 14151, 141, 14178, 158, 13580, 14234, 137, 100, 97, 14312, 13869, 14217, 125, 14224, 7301, 14313, 157, 173, 14135, 4215, 164, 8702, 13568, 4925, 13538, 9301, 53, 13674, 117, 138, 155, 14315, 89, 14223, 13870, 11453, 14136, 14316, 115, 14094, 14252, 14237, 4775, 163, 11473, 66, 149, 114, 58, 14221, 14248, 69, 11461, 14317, 11452, 3582, 13866, 14122, 10178, 4769, 95, 83, 13616, 142, 68, 10251, 3583, 4773, 3722, 14084) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC1281283
10SELECT `Playercontest`.`id`, `Playercontest`.`player_id`, `Playercontest`.`contest_id`, `Playercontest`.`nat_id`, `Playercontest`.`draw` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE `Playercontest`.`contest_id` = 22541281281
11SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (123, 173, 172, 197, 52, 71, 196, 29, 21, 68, 110, 53, 10, 72, 100, 50, 153, 198, 94, 13, 31, 194, 154, 27, 92, 179, 84, 43, 168, 104, 133, 14, 199, 189, 169, 19, 96, 164, 181, 111, 36, 91, 150)43431
12SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (123, 173, 172, 197, 52, 71, 196, 29, 21, 68, 110, 53, 10, 72, 100, 50, 153, 198, 94, 13, 31, 194, 154, 27, 92, 179, 84, 43, 168, 104, 133, 14, 199, 189, 169, 19, 96, 164, 181, 111, 36, 91, 150)43431
13SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (179, 13562, 13871, 14153, 13625, 14276, 170, 75, 14255, 119, 92, 14253, 132, 11457, 148, 85, 3725, 102, 6780, 127, 175, 14264, 99, 160, 13567, 5934, 64, 14242, 14154, 10225, 161, 14262, 147, 14087, 72, 129, 139, 3723, 171, 3720, 122, 5053, 54, 8924, 3728, 14236, 10177, 10252, 113, 74, 3717, 96, 3586, 14311, 131, 14254, 130, 8674, 14151, 141, 14178, 158, 13580, 14234, 137, 100, 97, 14312, 13869, 14217, 125, 14224, 7301, 14313, 157, 173, 14135, 4215, 164, 8702, 13568, 4925, 13538, 9301, 53, 13674, 117, 138, 155, 14315, 89, 14223, 13870, 11453, 14136, 14316, 115, 14094, 14252, 14237, 4775, 163, 11473, 66, 149, 114, 58, 14221, 14248, 69, 11461, 14317, 11452, 3582, 13866, 14122, 10178, 4769, 95, 83, 13616, 142, 68, 10251, 3583, 4773, 3722, 14084)) AND (`Playercontest`.`contest_id` = 2254))1281282
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` = 201710101
16SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (1, 3, 12, 17, 14, 19, 22, 24, 4, 2) 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)440