back to overall

Wimbledon 2009 Gentlemen's Singles  (June 22 - July 5)

NationR128R64R32R16QFSFFChampion
1.Argentina (ARG)[5]Juan Martin Del Potro
Juan Martin Del Potro
2.France (FRA)Arnaud Clement6-3 6-1 6-2
Lleyton Hewitt
3.Australia (AUS)Lleyton Hewitt6-3 7-5 7-5
Lleyton Hewitt
4.United States (USA)Robby Ginepri6-4 6-1 6-1
Lleyton Hewitt
5.Germany (GER)Philipp Petzschner 7-5 7-6(3) 6-3
Philipp Petzschner
6.United States (USA)[Q]Rajeev Ram2-6 6-1 7-6(3) 6-1
Philipp Petzschner
7.Germany (GER)Mischa Zverev4-6 7-6(13) 3-6 7-6(5) 6-0
Mischa Zverev
8.Russia (RUS)[25]Dmitry Tursunov6-4 6-2 3-0 rtd.
Lleyton Hewitt
9.Czech Republic (CZE)[23]Radek Stepanek4-6 2-6 6-1 6-2 6-2
Radek Stepanek
10.Colombia (COL)[Q]Alejandro Falla6-4 6-4 6-1
Radek Stepanek
11.Italy (ITA)Potito Starace6-4 4-6 6-2 4-6 6-3
Potito Starace
12.Argentina (ARG)Jose Acasuso7-6(0) 6-3 rtd.
Radek Stepanek
13.Italy (ITA)Fabio Fognini7-5 7-5 3-6 4-6 6-4
Fabio Fognini
14.Uzbekistan (UZB)Denis Istomin1-6 6-7(3) 6-4 3-1 rtd.
David Ferrer
15.Spain (ESP)[16]David Ferrer6-2 6-2 6-3
David Ferrer
16.United States (USA)Kevin Kim7-5 6-3 4-6 6-2
Andy Roddick
17.Russia (RUS)[12]Nikolay Davydenko6-3 6-7(10) 7-6(1) 4-6 6-4
Nikolay Davydenko
18.United Kingdom (GBR)[WC]Daniel Evans6-2 6-3 6-3
Nikolay Davydenko
19.Romania (ROU)Victor Crivoi6-4 6-4 6-2
Victor Crivoi
20.Germany (GER)Bjorn Phau4-6 6-1 7-6(3) 2-6 6-3
Tomas Berdych
21.France (FRA)Paul-Henri Mathieu6-2 6-3 6-2
Paul-Henri Mathieu
22.Portugal (POR)Frederico Gil6-1 2-6 6-4 6-2
Tomas Berdych
23.Czech Republic (CZE)[20]Tomas Berdych6-2 6-4 6-4
Tomas Berdych
24.United Kingdom (GBR)[WC]Alex Bogdanovic6-3 6-4 6-4
Andy Roddick
25.Austria (AUT)[26]Jurgen Melzer7-6(4) 6-4 6-3
Jurgen Melzer
26.United States (USA)Wayne Odesnik6-1 6-4 6-2
Jurgen Melzer
27.Germany (GER)Benjamin Becker7-6(6) 6-3 7-6(1)
Benjamin Becker
28.Croatia (CRO)[Q]Roko Karanusic6-4 6-4 6-1
Andy Roddick
29.Russia (RUS)Igor Kunitsyn7-6(2) 7-6(2) 4-6 6-3
Igor Kunitsyn
30.Bulgaria (BUL)[WC]Grigor Dimitrov 3-6 6-0 3-0 rtd.
Andy Roddick
31.United States (USA)[6]Andy Roddick6-4 6-2 3-6 6-2
Andy Roddick
32.France (FRA)Jeremy Chardy6-3 7-6(3) 4-6 6-3
Andy Roddick
33.United Kingdom (GBR)[3]Andy Murray6-4 4-6 7-6(7) 7-6(5)
Andy Murray
34.United States (USA)Robert Kendrick7-5 6-7(3) 6-3 6-4
Andy Murray
35.Latvia (LAT)Ernests Gulbis6-2 7-5 6-3
Ernests Gulbis
36.Italy (ITA)[Q]Riccardo Ghedin6-2 6-4 6-4
Andy Murray
37.Spain (ESP)Daniel Gimeno-Traver6-2 6-3 6-4
Daniel Gimeno-Traver
38.United States (USA)[Q]Taylor Dent7-5 7-6(6) 4-6 6-7(3) 6-4
Viktor Troicki
39.Serbia (SRB)[30]Viktor Troicki6-7(5) 6-0 1-6 6-3 7-5
Viktor Troicki
40.Argentina (ARG)Brian Dabul6-4 6-4 6-3
Andy Murray
41.Switzerland (SUI)[19]Stan Wawrinka2-6 6-3 6-3 5-7 6-3
Stan Wawrinka
42.Argentina (ARG)Eduardo Schwank7-5 6-4 6-1
Stan Wawrinka
43.Argentina (ARG)Martin Arguello6-3 6-2 6-2
Martin Arguello
44.Spain (ESP)Pablo Andujar4-6 6-3 6-2 6-2
Stan Wawrinka
45.Uruguay (URU)[LL]Pablo Cuevas5-7 7-5 6-3 6-3
Pablo Cuevas
46.Belgium (BEL)Christophe Rochus3-6 4-6 6-4 6-1 11-9
Jesse Levine
47.United States (USA)[Q]Jesse Levine6-2 6-1 4-6 4-6 6-3
Jesse Levine
48.Russia (RUS)[14]Marat Safin6-2 3-6 7-6(4) 6-4
Andy Murray
49.Chile (CHI)[10]Fernando Gonzalez7-5 6-3 6-2
Fernando Gonzalez
50.Russia (RUS)Teymuraz Gabashvili7-5 7-5 6-3
Fernando Gonzalez
51.Argentina (ARG)Leonardo Mayer6-7(4) 6-4 6-4 6-4
Leonardo Mayer
52.Spain (ESP)Oscar Hernandez6-0 6-0 6-3
Juan Carlos Ferrero
53.Spain (ESP)[WC]Juan Carlos Ferrero4-6 7-5 6-4 4-6 6-4
Juan Carlos Ferrero
54.Russia (RUS)Mikhail Youzhny 6-3 7-6(3) 6-3
Juan Carlos Ferrero
55.France (FRA)Fabrice Santoro6-7(1) 6-3 6-4 6-3
Fabrice Santoro
56.Germany (GER)[33]Nicolas Kiefer6-4 6-2 6-2
Juan Carlos Ferrero
57.Romania (ROU)[31]Victor Hanescu7-6(4) 6-3 6-2
Victor Hanescu
58.Spain (ESP)Ivan Navarro6-3 6-7(5) 6-4 6-7(5) 12-10
Victor Hanescu
59.France (FRA)Nicolas Devilder6-2 6-3 6-1
Nicolas Devilder
60.Ecuador (ECU)Nicolas Lapentti3-6 6-4 6-3 4-6 7-5
Gilles Simon
61.Brazil (BRA)[LL]Thiago Alves6-2 7-5 6-2
Thiago Alves
62.Romania (ROU)Andrei Pavel6-3 2-6 6-1 2-6 6-1
Gilles Simon
63.France (FRA)[8]Gilles Simon5-7 6-3 6-4 6-4
Gilles Simon
64.United States (USA)Bobby Reynolds6-4 6-3 6-3
Roger Federer
65.Italy (ITA)Andreas Seppi5-7 7-6(6) 7-6(5) 3-6 16-14
Andreas Seppi
66.United States (USA)[17]James Blake7-5 6-4 7-6(5)
Andreas Seppi
67.France (FRA)Marc Gicquel7-5 6-4 6-7(3) 5-7 6-4
Marc Gicquel
68.France (FRA)[Q]Adrian Mannarino 6-2 6-2 6-4
Igor Andreev
69.United States (USA)Vince Spadea6-1 7-6(5) 4-6 7-6(5)
Vince Spadea
70.Chile (CHI)Paul Capdeville6-0 6-4 7-5
Igor Andreev
71.Russia (RUS)[29]Igor Andreev6-3 7-5 6-2
Igor Andreev
72.Kazakhstan (KAZ)Evgeny Korolev4-6 7-6(2) 6-4 7-6(4)
Tommy Haas
73.Germany (GER)[24]Tommy Haas7-6(8) 6-4 6-4
Tommy Haas
74.Austria (AUT)[Q]Alexander Peya6-7(5) 7-6(0) 6-3 6-4
Tommy Haas
75.France (FRA)Michael Llodra4-3 rtd.
Michael Llodra
76.United Kingdom (GBR)[WC]Josh Goodall4-6 7-6(5) 6-4 3-6 6-4
Tommy Haas
77.United States (USA)Sam Querrey 7-5 7-5 1-6 6-7(3) 10-8
Sam Querrey
78.Thailand (THA)[LL]Danai Udomchoke6-3 6-4 6-4
Marin Cilic
79.Croatia (CRO)[11]Marin Cilic4-6 7-6(3) 6-3 6-7(4) 6-4
Marin Cilic
80.Spain (ESP)Alberto Martin6-3 6-4 6-4
Tommy Haas
81.Spain (ESP)[15]Tommy Robredo7-5 7-6(6) 4-6 6-3
Tommy Robredo
82.Slovenia (SLO)[Q]Luka Gregorc7-6(4) 6-4 5-7 7-6(3)
Tommy Robredo
83.Austria (AUT)Stefan Koubek3-6 4-6 6-4 7-6(5) 6-1
Stefan Koubek
84.France (FRA)[Q]Edouard Roger-Vasselin7-5 6-3 4-6 3-6 6-3
Dudi Sela
85.Israel (ISR)Dudi Sela7-6(8) 7-5 2-6 7-5
Dudi Sela
86.Mexico (MEX)[Q]Santiago Gonzalez6-4 4-6 7-6(2) 6-3
Dudi Sela
87.Germany (GER)[18]Rainer Schuettler7-6(3) 6-3 6-2
Rainer Schuettler
88.Belgium (BEL)[Q]Xavier Malisse6-7(9) 6-4 7-6(3) 6-1
Novak Djokovic
89.United States (USA)[28]Mardy Fish6-2 6-4 6-1
Mardy Fish
90.Argentina (ARG)Sergio Roitman6-3 6-2 4-1 rtd.
Mardy Fish
91.Serbia (SRB)Janko Tipsarevic6-4 3-6 6-1 6-4
Janko Tipsarevic
92.Czech Republic (CZE)Jan Hernych6-4 6-4 7-6(4)
Novak Djokovic
93.Germany (GER)[Q]Simon Greul6-4 6-4 6-4
Simon Greul
94.United States (USA)[Q]Michael Yani6-4 6-2 7-5
Novak Djokovic
95.Serbia (SRB)[4]Novak Djokovic7-5 6-1 6-4
Novak Djokovic
96.France (FRA)Julien Benneteau 6-7(8) 7-6(1) 6-2 6-4
Roger Federer
97.Spain (ESP)[7]Fernando Verdasco7-6(3) 7-5 6-3
Fernando Verdasco
98.United Kingdom (GBR)[WC]James Ward6-1 6-3 6-4
Fernando Verdasco
99.Belgium (BEL)Kristof Vliegen7-6(3) 6-7(3) 7-6(4) 6-4
Kristof Vliegen
100.France (FRA)[WC]Nicolas Mahut6-3 7-6(6) 5-7 5-7 6-4
Fernando Verdasco
101.Argentina (ARG)Guillermo Canas4-6 6-1 6-4 7-6(2)
Guillermo Canas
102.Argentina (ARG)Diego Junqueira6-1 6-2 6-2
Albert Montanes
103.Spain (ESP)[32]Albert Montanes6-4 6-3 4-6 6-3
Albert Montanes
104.Slovenia (SLO)[Q]Grega Zemlja6-4 6-4 6-4
Ivo Karlovic
105.Croatia (CRO)[22]Ivo Karlovic7-6(5) 6-7(4) 6-3 7-6(9)
Ivo Karlovic
106.Slovakia (SVK)[Q]Lukas Lacko6-3 7-6(4) 6-3
Ivo Karlovic
107.Belgium (BEL)Steve Darcis7-5 6-3 6-4
Steve Darcis
108.Canada (CAN)Frank Dancevic6-4 7-6(4) 6-3
Ivo Karlovic
109.Italy (ITA)Simone Bolelli7-6(5) 6-7(5) 7-5 7-6(5)
Simone Bolelli
110.Austria (AUT)Daniel Koellerer6-7(3) 2-6 7-5 6-4 6-4
Jo-Wilfried Tsonga
111.France (FRA)[9]Jo-Wilfried Tsongaw/o
Jo-Wilfried Tsonga
112.Kazakhstan (KAZ)Andrey Golubev6-3 5-7 7-6(4) 7-6(5)
Roger Federer
113.Sweden (SWE)[13]Robin Soderling6-3 7-5 7-6(3)
Robin Soderling
114.Luxembourg (LUX)Gilles Muller6-7(4) 7-5 6-1 6-2
Robin Soderling
115.Spain (ESP)Marcel Granollers4-6 7-6(7) 6-4 7-5
Marcel Granollers
116.Germany (GER)Andreas Beck6-2 6-4 6-7(4) 6-2
Robin Soderling
117.Spain (ESP)Nicolas Almagro 7-6(7) 6-4 6-4
Nicolas Almagro
118.Argentina (ARG)Juan Monaco6-7(3) 6-7(7) 7-6(5) 6-4 8-6
Nicolas Almagro
119.Slovakia (SVK)[LL]Karol Beck6-4 7-6(2) 3-6 3-6 7-5
Karol Beck
120.Spain (ESP)[21]Feliciano Lopez1-6 7-5 6-3 4-6 10-8
Roger Federer
121.Germany (GER)[27]Philipp Kohlschreiber6-4 7-6(5) 7-6(5)
Philipp Kohlschreiber
122.France (FRA)Florent Serra7-6(3) 6-1 6-4
Philipp Kohlschreiber
123.Czech Republic (CZE)Ivo Minar6-4 3-6 4-6 6-2 8-6
Ivo Minar
124.Argentina (ARG)Maximo Gonzalez6-4 3-6 7-5 6-0
Roger Federer
125.Spain (ESP)Guillermo Garcia-Lopez6-3 6-2 6-7(5) 6-1
Guillermo Garcia-Lopez
126.Argentina (ARG)Agustin Calleri6-2 6-3 6-2
Roger Federer
127.Switzerland (SUI)[2]Roger Federer6-2 6-2 6-4
Roger Federer
128.Taiwan (TPE)Yen-Hsun Lu 7-5 6-3 6-2
(default) 17 queries took 23 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` = 'wimbledon' 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` = (3)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` = (3)441
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` = (3)57571
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` = 'wimbledon' 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` = (17) ORDER BY `Contest`.`year` ASC1371373
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` = 3 AND `Contest`.`category_id` = 17 AND `Contest`.`slug` = '2009' 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` = (531) 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 (131, 5932, 65, 4776, 63, 7313, 7301, 69, 59, 118, 57, 7298, 119, 114, 83, 7265, 169, 9051, 8672, 151, 3590, 110, 148, 7764, 140, 3718, 159, 7469, 78, 161, 67, 160, 84, 5054, 89, 9052, 90, 7348, 92, 7851, 156, 5933, 7295, 79, 5934, 6290, 109, 6260, 7327, 7291, 170, 7310, 93, 72, 4129, 6175, 135, 7319, 7271, 6181, 8682, 6220, 100, 4927, 74, 3578, 4926, 130, 6169, 7312, 3591, 7323, 176, 7289, 88, 3589, 137, 101, 3722, 6223, 5051, 9053, 6250, 87, 97, 7774, 4209, 86, 116, 7209, 68, 7269, 5052, 4697, 52, 102, 139, 128, 7241, 58, 6254, 4777, 120, 3588, 141, 173, 127, 4771, 3585, 7855, 115, 73, 7248, 117, 108, 145, 163, 123, 103, 171, 122, 126, 7299, 4208, 94, 7314, 147, 125) 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` = 5311281281
11SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (164, 92, 68, 53, 72, 13, 197, 154, 96, 173, 196, 21, 104, 91, 184, 168, 150, 199, 111, 43, 10, 181, 153, 14, 50, 179, 31, 169, 36, 198, 58, 178, 41, 29, 121)35351
12SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (164, 92, 68, 53, 72, 13, 197, 154, 96, 173, 196, 21, 104, 91, 184, 168, 150, 199, 111, 43, 10, 181, 153, 14, 50, 179, 31, 169, 36, 198, 58, 178, 41, 29, 121)35351
13SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (131, 5932, 65, 4776, 63, 7313, 7301, 69, 59, 118, 57, 7298, 119, 114, 83, 7265, 169, 9051, 8672, 151, 3590, 110, 148, 7764, 140, 3718, 159, 7469, 78, 161, 67, 160, 84, 5054, 89, 9052, 90, 7348, 92, 7851, 156, 5933, 7295, 79, 5934, 6290, 109, 6260, 7327, 7291, 170, 7310, 93, 72, 4129, 6175, 135, 7319, 7271, 6181, 8682, 6220, 100, 4927, 74, 3578, 4926, 130, 6169, 7312, 3591, 7323, 176, 7289, 88, 3589, 137, 101, 3722, 6223, 5051, 9053, 6250, 87, 97, 7774, 4209, 86, 116, 7209, 68, 7269, 5052, 4697, 52, 102, 139, 128, 7241, 58, 6254, 4777, 120, 3588, 141, 173, 127, 4771, 3585, 7855, 115, 73, 7248, 117, 108, 145, 163, 123, 103, 171, 122, 126, 7299, 4208, 94, 7314, 147, 125)) AND (`Playercontest`.`contest_id` = 531))1281282
14SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 17 ORDER BY `Contest`.`date_from` ASC1371371
15SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 200920201
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)441