back to overall

Roland Garros 2004 Men's Singles  (May 24 - June 6)

NationR128R64R32R16QFSFFChampion
1.Switzerland (SUI)[1]Roger Federer
Roger Federer
2.Belgium (BEL)[LL]Kristof Vliegen6-1 6-2 6-1
Roger Federer
3.Germany (GER)Nicolas Kiefer6-3 6-4 7-6(6)
Nicolas Kiefer
4.France (FRA)Thierry Ascione6-3 6-2 6-2
Gustavo Kuerten
5.Belgium (BEL)Gilles Elseneer6-4 6-4 6-4
Gilles Elseneer
6.Spain (ESP)Ruben Ramirez Hidalgo3-6 7-5 4-6 6-4 6-3
Gustavo Kuerten
7.Brazil (BRA)[28]Gustavo Kuerten6-2 6-0 6-3
Gustavo Kuerten
8.Spain (ESP)[Q]Nicolas Almagro 7-5 7-6(2) 1-6 3-6 7-5
Gustavo Kuerten
9.Spain (ESP)[23]Feliciano Lopez6-4 6-3 3-6 6-3
Feliciano Lopez
10.Ecuador (ECU)Nicolas Lapentti5-7 6-4 6-4 6-4
Feliciano Lopez
11.Slovakia (SVK)Karol Kucera6-7(3) 6-3 6-4 6-4
Karol Kucera
12.Croatia (CRO)Ivo Karlovic7-6(4) 6-4 6-4
Feliciano Lopez
13.France (FRA)[WC]Olivier Patience7-6(3) 4-6 6-0 6-3
Olivier Patience
14.Italy (ITA)Filippo Volandri6-3 7-6(5) 6-0
Hyung-Taik Lee
15.South Korea (KOR)[LL]Hyung-Taik Lee6-4 6-4 6-3
Hyung-Taik Lee
16.Sweden (SWE)Robin Soderling0-6 3-6 6-3 6-4 7-5
David Nalbandian
17.France (FRA)[10]Sebastien Grosjean6-2 2-6 6-4 7-6(6)
Sebastien Grosjean
18.United States (USA)[Q]Kevin Kim6-1 6-1 6-4
Potito Starace
19.Italy (ITA)[Q]Potito Starace7-6(6) 6-3 6-4
Potito Starace
20.Russia (RUS)Dmitry Tursunov6-2 6-3 6-4
Marat Safin
21.Spain (ESP)Felix Mantilla6-7(4) 6-4 3-6 7-5 7-5
Felix Mantilla
22.United States (USA)[LL]Jeff Salzenstein6-4 6-1 6-7(6) 6-2
Marat Safin
23.Russia (RUS)[20]Marat Safin6-4 2-6 6-2 6-7(4) 11-9
Marat Safin
24.Argentina (ARG)Agustin Calleri5-7 6-1 4-1 rtd.
David Nalbandian
25.Bosnia and Herzegovina (BIH)[25]Ivan Ljubicic7-5 6-4 6-7(5) 6-3
Ivan Ljubicic
26.Morocco (MAR)Hicham Arazi6-7(3) 6-4 6-7(2) 6-3 6-3
Stefan Koubek
27.Austria (AUT)Stefan Koubek6-0 1-6 6-4 6-2
Stefan Koubek
28.Spain (ESP)David Sanchez-Munoz6-3 7-5 3-6 6-7(0) 6-0
David Nalbandian
29.Colombia (COL)[Q]Alejandro Falla6-7(1) 6-3 7-6(1) 7-5
Alejandro Falla
30.Denmark (DEN)Kristian Pless6-2 4-6 6-1 6-2
David Nalbandian
31.Argentina (ARG)[8]David Nalbandian5-7 6-0 6-2 6-0
David Nalbandian
32.France (FRA)Richard Gasquet6-4 7-5 7-6(1)
Gaston Gaudio
33.Spain (ESP)[4]Juan Carlos Ferrero6-3 7-6(5) 6-0
Juan Carlos Ferrero
34.Germany (GER)Tommy Haas3-6 6-4 6-4 6-2
Igor Andreev
35.Russia (RUS)Igor Andreev6-4 6-2 6-3
Igor Andreev
36.Czech Republic (CZE)Jan Vacek6-3 6-1 6-4
Igor Andreev
37.Spain (ESP)David Ferrer7-6(3) 7-6(3) 6-3
David Ferrer
38.Belgium (BEL)Olivier Rochus6-1 6-1 6-3
Julien Benneteau
39.France (FRA)Julien Benneteau 6-3 1-6 6-2 7-5
Julien Benneteau
40.Belarus (BLR)[29]Max Mirnyi7-5 7-5 1-6 6-3
Gaston Gaudio
41.Sweden (SWE)[24]Jonas Bjorkman6-4 7-5 6-3
Jonas Bjorkman
42.United States (USA)Taylor Dent6-3 2-6 6-3 3-6 6-2
Thomas Enqvist
43.Sweden (SWE)Thomas Enqvist6-3 3-6 7-6(8) 6-3
Thomas Enqvist
44.Denmark (DEN)Kenneth Carlsen6-2 6-3 6-4
Gaston Gaudio
45.Argentina (ARG)Gaston Gaudio6-0 6-4 6-7(5) 6-4
Gaston Gaudio
46.Argentina (ARG)Guillermo Canas6-2 2-6 4-6 6-3 6-2
Gaston Gaudio
47.Czech Republic (CZE)[14]Jiri Novak2-6 6-4 6-4 5-7 6-3
Jiri Novak
48.France (FRA)Antony Dupuis6-4 6-4 6-7(4) 6-3
Gaston Gaudio
49.Australia (AUS)[12]Lleyton Hewitt6-3 6-2 6-2
Lleyton Hewitt
50.France (FRA)[Q]Arnaud Di Pasquale6-0 7-6(5) 4-6 6-1
Lleyton Hewitt
51.Austria (AUT)Jurgen Melzer6-4 6-4 4-6 6-2
Jurgen Melzer
52.South Africa (RSA)Wayne Ferreira6-7(4) 6-2 6-4 6-3
Lleyton Hewitt
53.Romania (ROU)Victor Hanescu6-2 3-6 4-6 6-2 6-1
Victor Hanescu
54.France (FRA)[WC]Jean-Rene Lisnard7-5 6-2 6-4
Martin Verkerk
55.Netherlands (NED)[19]Martin Verkerk4-6 6-3 3-6 6-0 3-0 rtd.
Martin Verkerk
56.France (FRA)[WC]Julien Boutter7-5 6-3 6-1
Lleyton Hewitt
57.Spain (ESP)[26]Albert Costa7-5 6-2 7-6(6)
Albert Costa
58.Brazil (BRA)Flavio Saretta6-2 6-2 6-7(2) 6-4
Albert Costa
59.Belgium (BEL)Christophe Rochus6-1 6-2 7-5
Christophe Rochus
60.Spain (ESP)[LL]Marc Lopez6-4 6-1 6-1
Xavier Malisse
61.Germany (GER)[Q]Daniel Elsner6-4 2-6 4-6 7-6(4) 8-6
Daniel Elsner
62.Austria (AUT)[Q]Alexander Peya6-1 7-6(4) 6-2
Xavier Malisse
63.Belgium (BEL)Xavier Malisse6-3 4-0 rtd.
Xavier Malisse
64.Germany (GER)[7]Rainer Schuettler6-4 7-5 6-4
Gaston Gaudio
65.Spain (ESP)[5]Carlos Moya0-6 3-6 6-4 6-1 8-6
Carlos Moya
66.Netherlands (NED)John Van Lottum6-3 6-4 3-6 6-2
Carlos Moya
67.Spain (ESP)Fernando Vicente6-1 6-2 6-1
Fernando Vicente
68.France (FRA)[Q]Marc Gicquel3-6 7-6(4) 6-4 6-2
Carlos Moya
69.Netherlands (NED)Raemon Sluiter6-0 6-3 6-4
Raemon Sluiter
70.Brazil (BRA)[Q]Ricardo Mello7-5 6-1 3-6 6-1
Raemon Sluiter
71.Slovakia (SVK)[31]Dominik Hrbaty6-4 6-4 3-6 7-6(5)
Dominik Hrbaty
72.Czech Republic (CZE)Bohdan Ulihrach6-1 3-1 rtd.
Carlos Moya
73.Spain (ESP)[17]Tommy Robredo7-6(8) 6-4 6-2
Tommy Robredo
74.Spain (ESP)Alberto Martin6-3 6-3 6-2
Tommy Robredo
75.Spain (ESP)[Q]Guillermo Garcia-Lopez6-4 3-6 7-5 6-4
Guillermo Garcia-Lopez
76.Australia (AUS)[WC]Todd Reid4-6 6-1 6-2 6-2
Tommy Robredo
77.Belarus (BLR)[Q]Vladimir Voltchkov6-2 6-0 6-2
Vladimir Voltchkov
78.Czech Republic (CZE)Radek Stepanek6-3 2-6 3-6 6-3 11-9
Nicolas Massu
79.Chile (CHI)[11]Nicolas Massu6-3 6-1 6-0
Nicolas Massu
80.Serbia and Montenegro (SCG)[Q]Janko Tipsarevic3-6 6-1 6-4 7-6(3)
Guillermo Coria
81.Germany (GER)[Q]Florian Mayer7-5 7-6(3) 6-3
Florian Mayer
82.Chile (CHI)[16]Fernando Gonzalez6-7(6) 6-1 6-0 7-6(5)
Nicolas Escude
83.France (FRA)Nicolas Escude6-4 6-3 6-4
Nicolas Escude
84.Australia (AUS)Wayne Arthurs7-6(7) 6-2 6-2
Nicolas Escude
85.Russia (RUS)Mikhail Youzhny 6-2 7-5 6-7(3) 6-2
Mikhail Youzhny
86.Netherlands (NED)Dennis Van Scheppingen6-0 6-4 6-2
Mikhail Youzhny
87.Romania (ROU)[21]Andrei Pavel6-7(3) 7-6(4) 1-6 7-6(8) 6-2
Andrei Pavel
88.Spain (ESP)Oscar Hernandez6-2 rtd.
Guillermo Coria
89.Argentina (ARG)[30]Mariano Zabaleta6-0 rtd.
Mariano Zabaleta
90.France (FRA)[WC]Stephane Robert7-6(4) 6-3 6-2
Mario Ancic
91.Croatia (CRO)Mario Ancic6-3 6-4 3-6 6-4
Mario Ancic
92.Armenia (ARM)Sargis Sargsian7-6(4) 4-6 6-4 6-4
Guillermo Coria
93.Argentina (ARG)[Q]Juan Monaco6-3 6-1 6-2
Juan Monaco
94.Russia (RUS)Aleksandr Bogomolov Jr.6-1 6-1 5-7 6-4
Guillermo Coria
95.Argentina (ARG)[3]Guillermo Coria7-5 6-1 6-3
Guillermo Coria
96.Russia (RUS)Nikolay Davydenko6-4 6-2 6-0
Guillermo Coria
97.France (FRA)[Q]Jerome Haehnel3-6 6-4 6-0 7-5
Jerome Haehnel
98.United States (USA)[6]Andre Agassi6-4 7-6(4) 6-3
Michael Llodra
99.France (FRA)[WC]Michael Llodra6-3 6-2 3-6 6-1
Michael Llodra
100.Germany (GER)Alexander Popp4-6 6-3 6-4 6-2
Michael Llodra
101.France (FRA)[Q]Julien Jeanpierre6-2 6-2 6-3
Julien Jeanpierre
102.Slovakia (SVK)Karol Beck6-2 6-4 7-5
Julien Jeanpierre
103.United States (USA)[27]Vince Spadea6-4 6-2 7-5
Vince Spadea
104.France (FRA)[Q]Florent Serra7-5 1-6 4-6 7-6(7) 9-7
Tim Henman
105.Peru (PER)Luis Horna6-7(2) 4-6 6-4 6-3 9-7
Luis Horna
106.Australia (AUS)[18]Mark Philippoussis6-1 7-6(9) 6-3
Galo Blanco
107.Spain (ESP)Galo Blanco2-6 6-4 1-6 6-2 6-3
Galo Blanco
108.Spain (ESP)Albert Portas7-5 7-5 3-6 6-4
Tim Henman
109.Germany (GER)Lars Burgsmuller7-6(3) 6-1 6-2
Lars Burgsmuller
110.France (FRA)[WC]Nicolas Mahut7-5 6-3 3-6 6-1
Tim Henman
111.United Kingdom (GBR)[9]Tim Henman6-0 6-3 6-3
Tim Henman
112.France (FRA)Cyril Saulnier4-6 4-6 7-6(2) 6-4 6-3
Tim Henman
113.Thailand (THA)[13]Paradorn Srichaphan6-2 6-4 6-4
Paradorn Srichaphan
114.Czech Republic (CZE)Tomas Berdych6-3 6-4 3-6 6-1
Alex Corretja
115.Spain (ESP)Alex Corretja6-4 7-5 6-3
Alex Corretja
116.United States (USA)Jan-Michael Gambill6-1 4-6 6-3 6-2
Juan Ignacio Chela
117.Spain (ESP)Fernando Verdasco6-4 6-4 4-6 6-3
Fernando Verdasco
118.United Kingdom (GBR)Greg Rusedski7-6(7) 6-0 6-0
Juan Ignacio Chela
119.Argentina (ARG)[22]Juan Ignacio Chela7-5 6-2 6-2
Juan Ignacio Chela
120.Israel (ISR)Harel Levy6-3 6-1 6-4
Juan Ignacio Chela
121.France (FRA)Fabrice Santoro4-6 6-2 7-6(5) 6-2
Fabrice Santoro
122.France (FRA)[32]Arnaud Clement6-4 6-3 6-7(5) 3-6 16-14
Fabrice Santoro
123.Georgia (GEO)Irakli Labadze6-3 3-6 2-6 6-1 6-1
Irakli Labadze
124.Sweden (SWE)Joachim Johansson7-5 7-6(5) 7-5
Olivier Mutis
125.France (FRA)Olivier Mutis6-0 6-2 6-3
Olivier Mutis
126.United States (USA)Robby Ginepri6-4 6-4 6-0
Olivier Mutis
127.United States (USA)[2]Andy Roddick3-6 6-3 6-7(5) 6-3 6-2
Andy Roddick
128.United States (USA)Todd Martin7-6(5) 6-4 7-5
(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` = 'roland-garros' 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` = (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` = '2004' 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` = (382) ORDER BY `Match`.`round_id` ASC, `Match`.`no` ASC12712710
9SELECT `Player`.`id`, `Player`.`name`, `Player`.`gender`, `Player`.`slug` FROM `zavoihu1_db4tennis`.`players` AS `Player` WHERE `Player`.`id` IN (147, 7241, 6175, 7231, 8669, 3726, 6205, 163, 171, 6181, 6168, 141, 7233, 61, 7266, 7248, 6256, 7265, 57, 69, 6227, 7160, 6260, 7314, 172, 6208, 6250, 7329, 118, 7277, 167, 75, 93, 176, 3591, 7470, 83, 150, 102, 6295, 5726, 7348, 5671, 5679, 6284, 6254, 6187, 6293, 65, 6247, 140, 4162, 135, 4924, 7242, 6275, 6178, 7250, 6290, 8636, 7325, 7289, 86, 4209, 6190, 6265, 6259, 4926, 6270, 112, 6230, 6195, 5051, 6223, 94, 7342, 6251, 59, 7292, 68, 3583, 7327, 6234, 6255, 72, 6219, 6220, 7310, 6262, 106, 7255, 6213, 123, 91, 7326, 169, 7257, 4001, 88, 8664, 7171, 103, 6169, 126, 7247, 5713, 6212, 6231, 6165, 58, 6197, 7200, 6276, 148, 4191, 6226, 139, 5705, 76, 7258, 4129, 5932, 7340, 7466, 7159, 4776, 67, 4142) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC1281282
10SELECT `Playercontest`.`id`, `Playercontest`.`player_id`, `Playercontest`.`contest_id`, `Playercontest`.`nat_id`, `Playercontest`.`draw` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE `Playercontest`.`contest_id` = 3821281281
11SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (92, 68, 53, 13, 197, 216, 154, 10, 173, 21, 168, 29, 43, 153, 14, 50, 179, 27, 72, 172, 178, 54, 196, 58, 127, 11, 133, 20, 184, 147, 91, 100, 41, 71)34341
12SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (92, 68, 53, 13, 197, 216, 154, 10, 173, 21, 168, 29, 43, 153, 14, 50, 179, 27, 72, 172, 178, 54, 196, 58, 127, 11, 133, 20, 184, 147, 91, 100, 41, 71)34341
13SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (147, 7241, 6175, 7231, 8669, 3726, 6205, 163, 171, 6181, 6168, 141, 7233, 61, 7266, 7248, 6256, 7265, 57, 69, 6227, 7160, 6260, 7314, 172, 6208, 6250, 7329, 118, 7277, 167, 75, 93, 176, 3591, 7470, 83, 150, 102, 6295, 5726, 7348, 5671, 5679, 6284, 6254, 6187, 6293, 65, 6247, 140, 4162, 135, 4924, 7242, 6275, 6178, 7250, 6290, 8636, 7325, 7289, 86, 4209, 6190, 6265, 6259, 4926, 6270, 112, 6230, 6195, 5051, 6223, 94, 7342, 6251, 59, 7292, 68, 3583, 7327, 6234, 6255, 72, 6219, 6220, 7310, 6262, 106, 7255, 6213, 123, 91, 7326, 169, 7257, 4001, 88, 8664, 7171, 103, 6169, 126, 7247, 5713, 6212, 6231, 6165, 58, 6197, 7200, 6276, 148, 4191, 6226, 139, 5705, 76, 7258, 4129, 5932, 7340, 7466, 7159, 4776, 67, 4142)) AND (`Playercontest`.`contest_id` = 382))1281282
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` = 200420201
16SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (2, 3, 1, 12, 17, 22, 18, 13, 23, 4, 7, 14, 24, 25, 26, 19, 15, 16, 20, 21) 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