back to overall

Australian Open 2009 Men's Singles  (January 19 - February 1)

NationR128R64R32R16QFSFFChampion
1.Spain (ESP)[1]Rafael Nadal
Rafael Nadal
2.Belgium (BEL)Christophe Rochus6-0 6-2 6-2
Rafael Nadal
3.Croatia (CRO)Roko Karanusic6-2 6-3 6-2
Roko Karanusic
4.France (FRA)Florent Serra6-3 1-6 6-3 3-6 6-3
Rafael Nadal
5.Germany (GER)Tommy Haas6-4 6-2 6-2
Tommy Haas
6.Argentina (ARG)Eduardo Schwank6-3 6-3 6-4
Tommy Haas
7.Italy (ITA)[Q]Flavio Cipolla6-1 6-2 6-1
Flavio Cipolla
8.Russia (RUS)[29]Dmitry Tursunov4-6 6-2 7-6(7) 7-5
Rafael Nadal
9.France (FRA)[24]Richard Gasquet6-3 6-2 6-4
Richard Gasquet
10.Argentina (ARG)Diego Junqueira6-7(5) 7-6(3) 6-3 6-4
Richard Gasquet
11.Uzbekistan (UZB)[WC]Denis Istomin6-3 6-4 6-4
Denis Istomin
12.United States (USA)Vince Spadea6-2 7-5 6-4
Fernando Gonzalez
13.Argentina (ARG)Guillermo Canas3-6 3-6 7-6(10) 6-2 12-10
Guillermo Canas
14.Germany (GER)[Q]Dieter Kindlmann3-6 7-5 5-7 6-0 7-5
Fernando Gonzalez
15.Chile (CHI)[13]Fernando Gonzalez7-5 6-3 6-4
Fernando Gonzalez
16.Australia (AUS)Lleyton Hewitt5-7 6-2 6-2 3-6 6-3
Rafael Nadal
17.France (FRA)[12]Gael Monfils6-2 7-5 7-5
Gael Monfils
18.Argentina (ARG)Martin Arguello6-1 6-3 7-5
Gael Monfils
19.Austria (AUT)Stefan Koubek6-4 6-4 3-6 6-2
Stefan Koubek
20.Russia (RUS)Mikhail Youzhny 6-3 6-2 6-2
Gael Monfils
21.Italy (ITA)Fabio Fognini6-4 6-3 7-5
Fabio Fognini
22.Kazakhstan (KAZ)Andrey Golubev3-6 7-6(7) 6-4 6-2
Nicolas Almagro
23.Spain (ESP)[17]Nicolas Almagro 6-2 7-5 6-0
Nicolas Almagro
24.Chile (CHI)Nicolas Massu6-4 6-4 3-6 5-7 6-3
Gilles Simon
25.Croatia (CRO)[25]Ivo Karlovic6-4 2-6 6-1 rtd.
Ivo Karlovic
26.Spain (ESP)Daniel Gimeno-Traver6-3 6-4 6-4
Mario Ancic
27.Croatia (CRO)Mario Ancic5-7 7-5 4-6 6-4 6-3
Mario Ancic
28.United States (USA)[Q]Wayne Odesnik7-5 6-4 4-6 6-2
Gilles Simon
29.Australia (AUS)Chris Guccione7-6(2) 6-4 6-2
Chris Guccione
30.France (FRA)Nicolas Devilder6-4 6-2 6-4
Gilles Simon
31.France (FRA)[6]Gilles Simon6-7(5) 6-4 6-1 6-2
Gilles Simon
32.Spain (ESP)Pablo Andujar6-4 6-1 6-1
Rafael Nadal
33.United Kingdom (GBR)[4]Andy Murray6-7(4) 6-4 7-6(2) 6-7(1) 6-4
Andy Murray
34.Romania (ROU)Andrei Pavel6-2 3-1 rtd.
Andy Murray
35.Spain (ESP)Marcel Granollers6-4 6-2 6-2
Marcel Granollers
36.Russia (RUS)Teymuraz Gabashvili6-4 7-6(3) 4-6 6-0
Andy Murray
37.Germany (GER)[Q]Andreas Beck7-5 6-0 6-3
Andreas Beck
38.Australia (AUS)[WC]Colin Ebelthite7-5 6-1 6-0
Jurgen Melzer
39.Austria (AUT)[31]Jurgen Melzer5-7 7-6(7) 6-4 6-3
Jurgen Melzer
40.Japan (JPN)Kei Nishikori7-5 6-2 6-1
Fernando Verdasco
41.Czech Republic (CZE)[22]Radek Stepanek2-6 6-1 1-6 6-3 6-4
Radek Stepanek
42.Ecuador (ECU)Nicolas Lapentti3-6 6-3 6-4 6-4
Radek Stepanek
43.Germany (GER)[Q]Michael Berrer6-3 6-2 6-7(3) 7-5
Michael Berrer
44.Australia (AUS)[WC]Carsten Ball6-2 6-4 6-3
Fernando Verdasco
45.France (FRA)Arnaud Clement6-4 6-0 6-0
Arnaud Clement
46.Ukraine (UKR)Sergiy Stakhovsky6-3 2-6 4-6 6-2 6-1
Fernando Verdasco
47.Spain (ESP)[14]Fernando Verdasco6-1 6-1 6-2
Fernando Verdasco
48.France (FRA)[WC]Adrian Mannarino 6-0 6-2 6-2
Fernando Verdasco
49.United States (USA)[9]James Blake7-6(2) 3-6 6-3 6-2
James Blake
50.Canada (CAN)[LL]Frank Dancevic6-4 6-3 7-5
James Blake
51.France (FRA)[Q]Sebastien De Chaunac6-3 6-2 6-3
Sebastien De Chaunac
52.Belgium (BEL)Steve Darcis2-6 6-3 0-6 6-2 6-2
James Blake
53.Latvia (LAT)Ernests Gulbis6-3 6-2 3-6 6-1
Ernests Gulbis
54.Spain (ESP)Albert Montanes6-3 6-2 6-3
Igor Andreev
55.Russia (RUS)[18]Igor Andreev6-4 6-4 5-7 3-6 6-4
Igor Andreev
56.Canada (CAN)[Q]Peter Polansky5-7 3-6 6-4 6-3 6-4
Jo-Wilfried Tsonga
57.Israel (ISR)[Q]Dudi Sela6-4 6-4 7-6(3)
Dudi Sela
58.Germany (GER)[30]Rainer Schuettler1-6 6-2 6-4 6-4
Dudi Sela
59.Romania (ROU)Victor Hanescu6-3 6-3 6-2
Victor Hanescu
60.Czech Republic (CZE)Jan Hernych3-6 3-6 7-6(7) 7-6(4) 8-6
Jo-Wilfried Tsonga
61.Bosnia and Herzegovina (BIH)Ivan Ljubicic6-4 6-2 1-6 6-1
Ivan Ljubicic
62.Russia (RUS)Igor Kunitsyn4-6 7-6(3) 7-6(7) 5-7 6-3
Jo-Wilfried Tsonga
63.France (FRA)[5]Jo-Wilfried Tsonga6-7(4) 7-6(8) 7-6(7) 6-2
Jo-Wilfried Tsonga
64.Argentina (ARG)Juan Monaco6-4 6-4 6-0
Rafael Nadal
65.United States (USA)[7]Andy Roddick7-5 3-6 7-6(3) 3-6 6-2
Andy Roddick
66.Sweden (SWE)[Q]Bjorn Rehnquist6-0 6-2 6-2
Andy Roddick
67.Belgium (BEL)[Q]Xavier Malisse4-6 6-2 7-6(1) 6-2
Xavier Malisse
68.France (FRA)Michael Llodra7-6(8) 6-1 6-1
Andy Roddick
69.France (FRA)Fabrice Santoro6-3 6-4 6-2
Fabrice Santoro
70.Spain (ESP)Juan Carlos Ferrero6-3 6-2 6-7(5) 6-2
Fabrice Santoro
71.Germany (GER)[32]Philipp Kohlschreiber5-7 7-5 3-6 7-5 6-3
Philipp Kohlschreiber
72.United States (USA)Sam Querrey 7-6(6) 6-3 6-2
Andy Roddick
73.Spain (ESP)[21]Tommy Robredo7-5 6-1 6-3
Tommy Robredo
74.United States (USA)Bobby Reynolds6-2 7-5 6-1
Tommy Robredo
75.Serbia (SRB)Viktor Troicki6-1 6-3 6-0
Viktor Troicki
76.Spain (ESP)Alberto Martin6-3 3-6 6-2 6-4
Tommy Robredo
77.Taiwan (TPE)Yen-Hsun Lu 6-1 6-3 6-2
Yen-Hsun Lu
78.Brazil (BRA)Thomaz Bellucci6-3 7-5 6-4
Yen-Hsun Lu
79.Argentina (ARG)[10]David Nalbandian6-4 5-7 4-6 6-4 6-2
David Nalbandian
80.France (FRA)Marc Gicquel6-1 4-6 6-2 6-3
Andy Roddick
81.Sweden (SWE)[16]Robin Soderling6-7(3) 6-4 6-2 2-1 rtd.
Robin Soderling
82.United States (USA)Robert Kendrick5-7 6-4 6-4 7-5
Marcos Baghdatis
83.Cyprus (CYP)Marcos Baghdatis 3-6 7-5 6-3 6-3
Marcos Baghdatis
84.France (FRA)Julien Benneteau 6-3 7-6(5) 6-2
Marcos Baghdatis
85.Italy (ITA)Simone Bolelli6-2 6-4 6-4
Simone Bolelli
86.Belgium (BEL)Kristof Vliegen7-6(5) 7-6(3) 7-5
Mardy Fish
87.United States (USA)[23]Mardy Fish6-4 6-1 7-5
Mardy Fish
88.Australia (AUS)[WC]Sam Groth6-7(3) 6-4 7-5 6-0
Novak Djokovic
89.France (FRA)[28]Paul-Henri Mathieu6-1 7-6(1) 6-7(5) 6-2
Paul-Henri Mathieu
90.Finland (FIN)Jarkko Nieminen 6-2 4-1 rtd.
Amer Delic
91.Bosnia and Herzegovina (BIH)[LL]Amer Delic1-6 3-6 6-3 7-6(3) 9-7
Amer Delic
92.United States (USA)Taylor Dent6-4 3-6 4-6 6-3 6-4
Novak Djokovic
93.France (FRA)Jeremy Chardy6-2 4-6 6-3 7-6(4)
Jeremy Chardy
94.Brazil (BRA)Marcos Daniel6-4 6-4 6-1
Novak Djokovic
95.Serbia (SRB)[3]Novak Djokovic7-5 6-1 6-3
Novak Djokovic
96.Italy (ITA)[Q]Andrea Stoppini6-2 6-3 7-5
Roger Federer
97.Argentina (ARG)[8]Juan Martin Del Potro 6-2 7-5 7-5
Juan Martin Del Potro
98.Germany (GER)Mischa Zverev6-3 6-4 6-2
Juan Martin Del Potro
99.Germany (GER)[Q]Florian Mayer6-1 7-5 6-2
Florian Mayer
100.Algeria (ALG)[Q]Lamine Ouahab6-2 6-1 6-2
Juan Martin Del Potro
101.Australia (AUS)[WC]Bernard Tomic6-7(5) 7-5 6-3 7-5
Bernard Tomic
102.Italy (ITA)Potito Starace7-6(5) 1-6 7-6(5) 7-6(6)
Gilles Muller
103.Luxembourg (LUX)Gilles Muller3-6 6-1 6-4 6-2
Gilles Muller
104.Spain (ESP)[27]Feliciano Lopez6-3 7-6(5) 4-6 4-6 16-14
Juan Martin Del Potro
105.Croatia (CRO)[19]Marin Cilic5-7 6-4 6-4 6-2
Marin Cilic
106.South Africa (RSA)Kevin Anderson6-3 6-2 6-7(4) 6-3
Marin Cilic
107.Serbia (SRB)Janko Tipsarevic6-2 6-3 4-6 6-3
Janko Tipsarevic
108.Spain (ESP)Oscar Hernandez4-6 6-1 6-3 4-6 6-0
Marin Cilic
109.Slovakia (SVK)[Q]Dominik Hrbaty7-6(5) 6-3 6-4
Dominik Hrbaty
110.United States (USA)[WC]John Isner7-6(4) 2-6 6-2 7-5
David Ferrer
111.Spain (ESP)[11]David Ferrer6-2 6-2 6-1
David Ferrer
112.Germany (GER)Denis Gremelmayr6-1 6-7(6) 6-1 6-7(5) 6-4
Roger Federer
113.Switzerland (SUI)[15]Stan Wawrinka6-3 6-0 6-0
Stan Wawrinka
114.Czech Republic (CZE)Ivo Minar6-1 2-6 7-5 7-6(9)
Stan Wawrinka
115.Australia (AUS)[WC]Brydan Klein6-3 6-4 6-4
Brydan Klein
116.Germany (GER)[Q]Bjorn Phau6-4 6-3 4-6 6-3
Tomas Berdych
117.Argentina (ARG)Brian Dabul4-6 6-1 6-3 6-4
Brian Dabul
118.Germany (GER)Philipp Petzschner 6-1 6-2 6-4
Tomas Berdych
119.Czech Republic (CZE)[20]Tomas Berdych6-1 6-1 6-3
Tomas Berdych
120.United States (USA)Robby Ginepri6-4 6-4 6-3
Roger Federer
121.Russia (RUS)[26]Marat Safin4-6 6-7(4) 6-4 6-4 6-2
Marat Safin
122.Spain (ESP)Ivan Navarro6-3 6-3 6-4
Marat Safin
123.Spain (ESP)Guillermo Garcia-Lopez7-5 6-2 6-2
Guillermo Garcia-Lopez
124.Argentina (ARG)Agustin Calleri3-6 7-6(5) 6-2 6-0
Roger Federer
125.Kazakhstan (KAZ)[Q]Evgeny Korolev6-3 6-2 7-6(5)
Evgeny Korolev
126.Spain (ESP)Carlos Moya6-3 6-1 7-6(7)
Roger Federer
127.Switzerland (SUI)[2]Roger Federer6-2 6-3 6-1
Roger Federer
128.Italy (ITA)Andreas Seppi6-1 7-6(4) 7-5
(default) 17 queries took 76 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` = 'australian-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` = (1)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` = (1)111
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` = (1)111
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` = 'australian-open' AND `Category`.`slug` = 'men-singles' LIMIT 11151
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` = (1) ORDER BY `Contest`.`year` ASC1121124
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` = 1 AND `Contest`.`category_id` = 1 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` = (294) 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, 6290, 7469, 126, 176, 5933, 168, 69, 75, 4777, 114, 6169, 6254, 7473, 7327, 65, 99, 7295, 6250, 72, 119, 73, 163, 7292, 141, 90, 7255, 3718, 7308, 7271, 100, 79, 84, 6220, 108, 7291, 145, 7845, 140, 107, 59, 6181, 4212, 7846, 5932, 152, 139, 130, 3578, 4771, 7189, 127, 89, 120, 3591, 7847, 97, 4209, 135, 7269, 172, 78, 115, 123, 67, 7785, 86, 88, 4129, 93, 122, 137, 5051, 4927, 92, 6223, 125, 96, 167, 4926, 7248, 5054, 158, 102, 3585, 7241, 116, 7848, 3590, 166, 7284, 7348, 160, 7467, 52, 7849, 131, 7301, 3583, 7850, 138, 57, 117, 171, 3722, 155, 68, 7310, 6230, 164, 83, 7770, 156, 7299, 7844, 151, 7851, 63, 148, 4776, 6260, 7319, 94, 7314, 7323, 6190, 147, 74) 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` = 2941281282
11SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (164, 92, 53, 72, 13, 197, 154, 96, 68, 173, 196, 21, 104, 29, 91, 94, 199, 111, 10, 181, 153, 14, 50, 179, 194, 172, 52, 67, 27, 36, 58, 168, 178, 41, 5)35351
12SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (164, 92, 53, 72, 13, 197, 154, 96, 68, 173, 196, 21, 104, 29, 91, 94, 199, 111, 10, 181, 153, 14, 50, 179, 194, 172, 52, 67, 27, 36, 58, 168, 178, 41, 5)35351
13SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (179, 6290, 7469, 126, 176, 5933, 168, 69, 75, 4777, 114, 6169, 6254, 7473, 7327, 65, 99, 7295, 6250, 72, 119, 73, 163, 7292, 141, 90, 7255, 3718, 7308, 7271, 100, 79, 84, 6220, 108, 7291, 145, 7845, 140, 107, 59, 6181, 4212, 7846, 5932, 152, 139, 130, 3578, 4771, 7189, 127, 89, 120, 3591, 7847, 97, 4209, 135, 7269, 172, 78, 115, 123, 67, 7785, 86, 88, 4129, 93, 122, 137, 5051, 4927, 92, 6223, 125, 96, 167, 4926, 7248, 5054, 158, 102, 3585, 7241, 116, 7848, 3590, 166, 7284, 7348, 160, 7467, 52, 7849, 131, 7301, 3583, 7850, 138, 57, 117, 171, 3722, 155, 68, 7310, 6230, 164, 83, 7770, 156, 7299, 7844, 151, 7851, 63, 148, 4776, 6260, 7319, 94, 7314, 7323, 6190, 147, 74)) AND (`Playercontest`.`contest_id` = 294))1281282
14SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 1 ORDER BY `Contest`.`date_from` ASC1121121
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