back to overall

US Open 2014 Men's Singles  (August 25 - September 8)

NationR128R64R32R16QFSFFChampion
1.Serbia (SRB)[1]Novak Djokovic
Novak Djokovic
2.Argentina (ARG)Diego Schwartzman6-1 6-2 6-4
Novak Djokovic
3.France (FRA)Paul-Henri Mathieu6-1 6-3 6-0
Paul-Henri Mathieu
4.Luxembourg (LUX)Gilles Muller6-7(7) 7-5 7-6(6) 6-7(5) 6-1
Novak Djokovic
5.United States (USA)Sam Querrey 6-3 6-2 6-2
Sam Querrey
6.Argentina (ARG)Maximo Gonzalez6-2 4-6 6-4 4-6 6-3
Sam Querrey
7.Spain (ESP)[28]Guillermo Garcia-Lopez6-3 6-4 6-4
Guillermo Garcia-Lopez
8.Taiwan (TPE)Yen-Hsun Lu 6-4 6-2 6-2
Novak Djokovic
9.Germany (GER)[22]Philipp Kohlschreiber6-1 7-5 6-4
Philipp Kohlschreiber
10.Argentina (ARG)[Q]Facundo Bagnis6-2 7-6(3) 6-3
Philipp Kohlschreiber
11.France (FRA)[WC]Michael Llodra6-2 rtd.
Michael Llodra
12.Spain (ESP)Daniel Gimeno-Traver6-4 6-3 7-5
Philipp Kohlschreiber
13.Germany (GER)Jan-Lennard Struff7-6(4) 4-6 7-6(2) 7-6(4)
Jan-Lennard Struff
14.Kazakhstan (KAZ)Mikhail Kukushkin 2-6 3-6 6-3 6-3 7-5
John Isner
15.United States (USA)[13]John Isner7-6(5) 6-4 6-2
John Isner
16.United States (USA)[WC]Marcos Giron7-6(5) 6-2 7-6(2)
Novak Djokovic
17.France (FRA)[9]Jo-Wilfried Tsonga7-6(1) 6-7(1) 6-2 6-4
Jo-Wilfried Tsonga
18.Argentina (ARG)Juan Monaco6-3 4-6 7-6(2) 6-1
Jo-Wilfried Tsonga
19.Kazakhstan (KAZ)Aleksandr Nedovyesov6-3 6-4 6-4
Aleksandr Nedovyesov
20.Ireland (IRL)[Q]James McGee4-6 6-2 6-1 7-6(3)
Jo-Wilfried Tsonga
21.Spain (ESP)Pablo Carreno Busta6-4 6-4 6-4
Pablo Carreno Busta
22.Germany (GER)[Q]Andreas Beck6-3 4-6 6-2 7-6(0)
Pablo Carreno Busta
23.France (FRA)Benoit Paire6-1 6-4 3-6 6-3
Benoit Paire
24.France (FRA)[24]Julien Benneteau 7-6(4) 5-7 6-4 4-6 6-4
Andy Murray
25.Spain (ESP)[31]Fernando Verdasco7-5 7-5 6-4
Fernando Verdasco
26.Slovenia (SLO)Blaz Rola6-3 3-6 7-5 1-6 6-4
Andrey Kuznetsov
27.Russia (RUS)Andrey Kuznetsov6-3 4-6 4-6 7-5 6-3
Andrey Kuznetsov
28.United States (USA)Bradley Klahn6-4 4-6 6-3 7-5
Andy Murray
29.Germany (GER)[Q]Matthias Bachinger6-1 7-5 4-6 6-2
Matthias Bachinger
30.Czech Republic (CZE)Radek Stepanek6-3 6-2 6-2
Andy Murray
31.United Kingdom (GBR)[8]Andy Murray6-3 6-3 6-4
Andy Murray
32.Netherlands (NED)Robin Haase6-3 7-6(6) 1-6 7-5
Kei Nishikori
33.Switzerland (SUI)[3]Stan Wawrinka6-4 1-6 7-6(4) 6-3
Stan Wawrinka
34.Czech Republic (CZE)Jiri Vesely6-2 7-6(6) 7-6(3)
Stan Wawrinka
35.Brazil (BRA)Thomaz Bellucci6-3 6-4 3-6 7-6(1)
Thomaz Bellucci
36.France (FRA)Nicolas Mahut7-6(4) 6-4 6-1
Stan Wawrinka
37.Slovenia (SLO)Blaz Kavcicw/o
Blaz Kavcic
38.United States (USA)Donald Young7-5 6-4 6-4
Blaz Kavcic
39.France (FRA)[30]Jeremy Chardy6-2 7-6(6) 6-3
Jeremy Chardy
40.Colombia (COL)Alejandro Falla6-7(5) 6-2 7-5 6-4
Stan Wawrinka
41.Australia (AUS)Nick Kyrgios7-5 4-6 7-6(7) 6-2
Nick Kyrgios
42.Russia (RUS)[21]Mikhail Youzhny 7-5 7-6(4) 2-6 7-6(1)
Nick Kyrgios
43.Italy (ITA)Andreas Seppi6-4 7-6(2) 6-4
Andreas Seppi
44.Ukraine (UKR)Sergiy Stakhovsky6-3 6-1 6-4
Tommy Robredo
45.Italy (ITA)Simone Bolelli3-6 6-3 7-6(4) 6-3
Simone Bolelli
46.Canada (CAN)Vasek Pospisil2-6 6-4 6-2 3-6 6-3
Tommy Robredo
47.Spain (ESP)[16]Tommy Robredo5-7 6-7(5) 6-4 6-3 6-2
Tommy Robredo
48.France (FRA)Edouard Roger-Vasselin6-4 6-3 6-4
Kei Nishikori
49.Japan (JPN)[10]Kei Nishikori3-6 7-5 7-6(7) 6-7(5) 6-4
Kei Nishikori
50.United States (USA)[WC]Wayne Odesnik6-2 6-4 6-2
Kei Nishikori
51.Spain (ESP)Pablo Andujar6-4 6-1 rtd.
Pablo Andujar
52.United States (USA)Jack Sock6-4 3-6 6-1 rtd.
Kei Nishikori
53.Australia (AUS)Matthew Ebden6-4 6-2 6-3
Matthew Ebden
54.Germany (GER)Tobias Kamke6-4 6-3 7-6(2)
Leonardo Mayer
55.Argentina (ARG)[23]Leonardo Mayer6-1 6-3 6-4
Leonardo Mayer
56.Spain (ESP)Albert Montanes6-2 3-0 rtd.
Kei Nishikori
57.Croatia (CRO)[Q]Borna Coric4-6 7-6(4) 6-7(6) 7-5 6-4
Borna Coric
58.Czech Republic (CZE)[29]Lukas Rosol6-4 6-1 6-2
Victor Burgos
59.Dominican Republic (DOM)Victor Burgos7-6(2) 4-6 6-4 6-2
Victor Burgos
60.Netherlands (NED)Igor Sijsling2-6 6-4 6-3 6-2
Milos Raonic
61.Germany (GER)[Q]Peter Gojowczyk 7-6(5) 7-6(5) 7-6(3)
Peter Gojowczyk
62.Germany (GER)Benjamin Becker6-2 6-4 6-2
Milos Raonic
63.Canada (CAN)[5]Milos Raonic7-6(4) 5-7 6-4 7-6(3)
Milos Raonic
64.Japan (JPN)[Q]Taro Daniel6-3 6-2 7-6(1)
Marin Cilic
65.Czech Republic (CZE)[6]Tomas Berdych6-3 6-3 6-3
Tomas Berdych
66.Australia (AUS)Lleyton Hewitt6-3 6-4 6-3
Tomas Berdych
67.Slovakia (SVK)Martin Klizan6-3 4-6 6-2 3-6 6-3
Martin Klizan
68.Belgium (BEL)[Q]Steve Darcis3-6 2-6 7-6(5) 7-5 6-4
Tomas Berdych
69.Russia (RUS)[Q]Alexander Kudryavtsev6-3 6-2 6-4
Alexander Kudryavtsev
70.Russia (RUS)Evgeny Donskoy2-6 7-6(6) 3-6 6-3 6-4
Teymuraz Gabashvili
71.Russia (RUS)Teymuraz Gabashvili6-1 6-4 7-6(4)
Teymuraz Gabashvili
72.Colombia (COL)[27]Santiago Giraldo6-3 1-6 7-6(6) 6-3
Tomas Berdych
73.Spain (ESP)[19]Feliciano Lopez6-1 6-2 6-4
Feliciano Lopez
74.Croatia (CRO)Ivan Dodig1-6 7-5 2-6 6-4 1-1 rtd.
Feliciano Lopez
75.Japan (JPN)[Q]Tatsuma Ito6-4 3-6 6-4 7-6(4)
Tatsuma Ito
76.United States (USA)Steve Johnson6-2 3-6 5-7 4-1 rtd.
Dominic Thiem
77.Austria (AUT)Dominic Thiem6-4 6-2 6-3
Dominic Thiem
78.Slovakia (SVK)Lukas Lacko6-3 6-3 6-2
Dominic Thiem
79.Latvia (LAT)[11]Ernests Gulbis4-6 3-6 6-4 6-3 6-3
Ernests Gulbis
80.France (FRA)Kenny De Schepper6-1 6-4 6-2
Marin Cilic
81.Croatia (CRO)[14]Marin Cilic6-2 6-4 7-6(4)
Marin Cilic
82.Cyprus (CYP)Marcos Baghdatis 6-3 3-1 rtd.
Marin Cilic
83.Ukraine (UKR)[Q]Illya Marchenko 7-6(2) 6-2 6-4
Illya Marchenko
84.Switzerland (SUI)[Q]Marco Chiudinelli7-6(3) 4-6 7-6(13) 7-6(4)
Marin Cilic
85.Poland (POL)Jerzy Janowicz6-3 3-6 6-3 6-4
Jerzy Janowicz
86.Serbia (SRB)Dusan Lajovic6-3 7-5 5-7 7-5
Kevin Anderson
87.South Africa (RSA)[18]Kevin Anderson6-7(6) 6-2 6-1 6-3
Kevin Anderson
88.Uruguay (URU)Pablo Cuevas6-3 6-7(3) 4-6 6-2 7-6(1)
Marin Cilic
89.France (FRA)[26]Gilles Simon5-7 7-6(3) 6-4 3-6 6-3
Gilles Simon
90.Moldova (MDA)[Q]Radu Albot6-3 6-4 6-2
Gilles Simon
91.Argentina (ARG)Federico Delbonis6-4 3-6 7-5 6-1
Federico Delbonis
92.United States (USA)[WC]Noah Rubin6-4 6-3 6-0
Gilles Simon
93.Australia (AUS)[WC]Bernard Tomic6-3 3-6 6-1 6-3
Bernard Tomic
94.Germany (GER)Dustin Brown7-6(2) 6-4 7-6(3)
David Ferrer
95.Spain (ESP)[4]David Ferrerw/o
David Ferrer
96.Bosnia and Herzegovina (BIH)Damir Dzumhur6-1 6-2 2-6 6-2
Marin Cilic
97.Bulgaria (BUL)[7]Grigor Dimitrov 6-3 6-4 6-4
Grigor Dimitrov
98.United States (USA)[WC]Ryan Harrison6-2 7-6(4) 6-2
Grigor Dimitrov
99.Israel (ISR)Dudi Sela6-1 6-2 6-2
Dudi Sela
100.Argentina (ARG)Carlos Berlocq1-6 6-3 6-2 7-5
Grigor Dimitrov
101.Belgium (BEL)David Goffin0-6 6-3 6-4 6-1
David Goffin
102.Belgium (BEL)[Q]Niels Desein6-1 6-3 6-3
David Goffin
103.Portugal (POR)[32]Joao Sousa6-4 6-2 6-0
Joao Sousa
104.Canada (CAN)Frank Dancevic7-6(6) 3-6 6-2 4-6 7-6(2)
Gael Monfils
105.France (FRA)[20]Gael Monfils7-5 7-6(6) 7-5
Gael Monfils
106.United States (USA)[WC]Jared Donaldson6-4 6-2 6-4
Gael Monfils
107.Colombia (COL)Alejandro Gonzalez7-5 6-3 6-2
Alejandro Gonzalez
108.Russia (RUS)Dmitry Tursunov6-4 6-4 7-5
Gael Monfils
109.Italy (ITA)Paolo Lorenzi6-4 6-2 6-2
Paolo Lorenzi
110.Japan (JPN)[Q]Yoshihito Nishioka6-1 6-2 2-1 rtd.
Richard Gasquet
111.France (FRA)[12]Richard Gasquet7-6(4) 6-3 6-3
Richard Gasquet
112.Uzbekistan (UZB)Denis Istomin7-5 7-6(5) 6-4
Roger Federer
113.Italy (ITA)[15]Fabio Fognini4-6 3-6 6-4 7-5 6-2
Fabio Fognini
114.Kazakhstan (KAZ)Andrey Golubev6-4 6-4 6-2
Adrian Mannarino
115.France (FRA)Adrian Mannarino 6-3 6-4 6-1
Adrian Mannarino
116.Spain (ESP)Pere Riba3-6 7-5 6-3 6-2
Roberto Bautista Agut
117.United States (USA)[WC]Tim Smyczek7-5 6-2 6-3
Tim Smyczek
118.Serbia (SRB)[Q]Filip Krajinovic4-6 6-3 6-2 7-6(5)
Roberto Bautista Agut
119.Spain (ESP)[17]Roberto Bautista Agut6-3 6-2 6-1
Roberto Bautista Agut
120.Austria (AUT)Andreas Haider-Maurer5-7 7-6(1) 1-6 7-5 6-1
Roger Federer
121.Croatia (CRO)[25]Ivo Karlovic6-4 6-3 6-2
Ivo Karlovic
122.Finland (FIN)Jarkko Nieminen 6-4 6-4 3-6 6-4
Marcel Granollers
123.Spain (ESP)Marcel Granollers7-6(6) 6-7(3) 7-6(5) 3-6 6-4
Marcel Granollers
124.Austria (AUT)Jurgen Melzer7-6(1) 6-3 6-2
Roger Federer
125.Australia (AUS)Sam Groth4-6 6-1 6-1 6-1
Sam Groth
126.Spain (ESP)Albert Ramos-Vinolas6-3 7-6(5) 6-3
Roger Federer
127.Switzerland (SUI)[2]Roger Federer6-4 6-4 6-4
Roger Federer
128.Australia (AUS)Marinko Matosevic6-3 6-4 7-6(4)
(default) 17 queries took 21 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` ASC1441443
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` = '2014' 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` = (2190) 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, 13616, 3590, 117, 137, 4208, 94, 125, 122, 13615, 88, 90, 11457, 95, 164, 13867, 115, 123, 13565, 13873, 11461, 145, 157, 102, 139, 13563, 3720, 5049, 80, 59, 84, 66, 156, 11453, 96, 58, 129, 175, 160, 118, 10252, 72, 74, 152, 3585, 3723, 5051, 87, 107, 3718, 79, 4925, 105, 134, 170, 120, 13870, 62, 13618, 8640, 174, 159, 60, 13871, 148, 65, 3580, 127, 146, 10178, 7291, 54, 171, 111, 56, 4775, 13580, 173, 89, 136, 3722, 158, 153, 5050, 3584, 13562, 155, 5934, 100, 13869, 11454, 13868, 138, 3717, 83, 13567, 161, 85, 97, 142, 3725, 13872, 13674, 4771, 99, 13866, 13581, 69, 53, 13874, 75, 114, 119, 73, 130, 121, 5053, 8925, 113, 4769, 141, 166, 108, 140, 7848, 149, 147, 98) 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` = 21901281282
11SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (154, 197, 179, 53, 173, 68, 13, 14, 72, 194, 150, 133, 92, 91, 10, 169, 36, 94, 67, 96, 196, 111, 90, 181, 164, 168, 50, 149, 199, 104, 43, 21, 27, 31, 198, 57, 29, 52, 172, 123)40401
12SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (154, 197, 179, 53, 173, 68, 13, 14, 72, 194, 150, 133, 92, 91, 10, 169, 36, 94, 67, 96, 196, 111, 90, 181, 164, 168, 50, 149, 199, 104, 43, 21, 27, 31, 198, 57, 29, 52, 172, 123)40401
13SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (52, 13616, 3590, 117, 137, 4208, 94, 125, 122, 13615, 88, 90, 11457, 95, 164, 13867, 115, 123, 13565, 13873, 11461, 145, 157, 102, 139, 13563, 3720, 5049, 80, 59, 84, 66, 156, 11453, 96, 58, 129, 175, 160, 118, 10252, 72, 74, 152, 3585, 3723, 5051, 87, 107, 3718, 79, 4925, 105, 134, 170, 120, 13870, 62, 13618, 8640, 174, 159, 60, 13871, 148, 65, 3580, 127, 146, 10178, 7291, 54, 171, 111, 56, 4775, 13580, 173, 89, 136, 3722, 158, 153, 5050, 3584, 13562, 155, 5934, 100, 13869, 11454, 13868, 138, 3717, 83, 13567, 161, 85, 97, 142, 3725, 13872, 13674, 4771, 99, 13866, 13581, 69, 53, 13874, 75, 114, 119, 73, 130, 121, 5053, 8925, 113, 4769, 141, 166, 108, 140, 7848, 149, 147, 98)) AND (`Playercontest`.`contest_id` = 2190))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` = 201414141
16SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (19, 17, 12, 14, 1, 3, 2, 13, 18, 23, 22, 24, 7, 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