back to overall

Australian Open 2010 Men's Singles  (January 18 - January 31)

NationR128R64R32R16QFSFFChampion
1.Switzerland (SUI)[1]Roger Federer
Roger Federer
2.Russia (RUS)Igor Andreev4-6 6-2 7-6(2) 6-0
Roger Federer
3.Romania (ROU)Victor Hanescu6-2 6-3 6-2
Victor Hanescu
4.Argentina (ARG)Juan Ignacio Chela6-4 6-3 7-6(2)
Roger Federer
5.France (FRA)Stephane Robert6-3 6-4 6-4
Stephane Robert
6.Italy (ITA)Potito Starace6-3 7-6(2) 7-6(4)
Albert Montanes
7.Spain (ESP)[31]Albert Montanes4-6 6-7(3) 6-2 6-3 6-3
Albert Montanes
8.Spain (ESP)Oscar Hernandez7-6(5) 2-2 rtd.
Roger Federer
9.Australia (AUS)[22]Lleyton Hewitt6-2 6-3 6-4
Lleyton Hewitt
10.Brazil (BRA)[Q]Ricardo Hocevar6-1 6-2 6-3
Lleyton Hewitt
11.United States (USA)[Q]Donald Young7-6(3) 6-4 6-1
Donald Young
12.Belgium (BEL)Christophe Rochus1-6 7-5 6-2 6-4
Lleyton Hewitt
13.Cyprus (CYP)Marcos Baghdatis 6-0 4-2 rtd.
Marcos Baghdatis
14.Italy (ITA)Paolo Lorenzi6-2 6-4 6-4
Marcos Baghdatis
15.Spain (ESP)[17]David Ferrer4-6 3-6 7-6(4) 6-3 6-1
David Ferrer
16.Portugal (POR)Frederico Gil6-0 6-0 2-0 rtd.
Roger Federer
17.Spain (ESP)[9]Fernando Verdasco2-6 6-3 6-0 7-5
Fernando Verdasco
18.Australia (AUS)[WC]Carsten Ball6-7(4) 7-6(1) 7-5 6-2
Fernando Verdasco
19.Ukraine (UKR)[Q]Ivan Sergeyev6-1 6-2 6-2
Ivan Sergeyev
20.Israel (ISR)Dudi Sela6-3 7-6(3) 4-6 7-6(8)
Fernando Verdasco
21.Austria (AUT)[Q]Stefan Koubek6-1 rtd.
Stefan Koubek
22.United States (USA)Rajeev Ram4-6 6-3 5-7 6-1 6-3
Stefan Koubek
23.Croatia (CRO)[Q]Ivan Dodig7-6(4) 6-1 6-2
Ivan Dodig
24.Spain (ESP)[23]Juan Carlos Ferrero2-6 1-6 6-4 6-1 6-1
Nikolay Davydenko
25.Argentina (ARG)[30]Juan Monaco6-2 7-5 4-6 6-7(5) 6-3
Juan Monaco
26.Latvia (LAT)Ernests Gulbis6-3 7-6(5) 6-1
Juan Monaco
27.France (FRA)Michael Llodra3-6 3-6 7-6(5) 6-1 6-3
Michael Llodra
28.Argentina (ARG)Martin Arguello6-3 7-5 6-4
Nikolay Davydenko
29.Ukraine (UKR)[Q]Illya Marchenko 6-0 6-3 6-4
Illya Marchenko
30.Spain (ESP)Carlos Moya7-6(2) 7-5 6-3
Nikolay Davydenko
31.Russia (RUS)[6]Nikolay Davydenko6-3 6-3 6-0
Nikolay Davydenko
32.Germany (GER)[Q]Dieter Kindlmann6-1 6-0 6-3
Roger Federer
33.Serbia (SRB)[3]Novak Djokovic6-2 6-3 6-2
Novak Djokovic
34.Spain (ESP)Daniel Gimeno-Traver7-5 6-3 6-2
Novak Djokovic
35.Switzerland (SUI)Marco Chiudinelli3-6 6-1 6-1 6-3
Marco Chiudinelli
36.Australia (AUS)[WC]Marinko Matosevic7-6(7) 7-6(3) 4-6 6-3
Novak Djokovic
37.Germany (GER)Michael Berrer6-1 6-1 6-2
Michael Berrer
38.Belgium (BEL)Kristof Vliegen6-1 6-2 6-1
Denis Istomin
39.Uzbekistan (UZB)Denis Istomin7-5 6-3 6-4
Denis Istomin
40.France (FRA)[32]Jeremy Chardy6-2 6-2 6-0
Novak Djokovic
41.Russia (RUS)[20]Mikhail Youzhny 6-1 6-2 7-5
Mikhail Youzhny
42.France (FRA)Richard Gasquet6-7(9) 4-6 7-6(2) 7-6(4) 6-4
Mikhail Youzhny
43.Czech Republic (CZE)Jan Hajek6-2 6-1 6-1
Jan Hajek
44.United States (USA)Robby Ginepri7-6(2) 7-5 6-1
Lukasz Kubot
45.Poland (POL)Lukasz Kubotw/o
Lukasz Kubot
46.Germany (GER)Mischa Zverev6-3 6-3 6-3
Lukasz Kubot
47.Colombia (COL)Santiago Giraldo6-4 3-6 6-3 6-1
Santiago Giraldo
48.Spain (ESP)[16]Tommy Robredo6-4 6-2 6-2
Jo-Wilfried Tsonga
49.France (FRA)[10]Jo-Wilfried Tsonga7-6(8) 6-7(5) 1-6 6-3 6-1
Jo-Wilfried Tsonga
50.Ukraine (UKR)Sergiy Stakhovsky6-3 6-4 6-4
Jo-Wilfried Tsonga
51.United States (USA)Taylor Dent6-4 6-3 6-3
Taylor Dent
52.Italy (ITA)Fabio Fognini6-1 6-3 6-3
Jo-Wilfried Tsonga
53.Serbia (SRB)Janko Tipsarevic6-4 3-6 6-1 7-5
Janko Tipsarevic
54.United States (USA)[WC]Ryan Harrison6-2 6-4 7-6(3)
Tommy Haas
55.Germany (GER)[18]Tommy Haas4-6 6-4 6-3 1-6 6-3
Tommy Haas
56.Germany (GER)Simon Greul6-7(5) 6-4 6-2 6-1
Jo-Wilfried Tsonga
57.Spain (ESP)[26]Nicolas Almagro 6-3 6-4 4-6 6-7(6) 9-7
Nicolas Almagro
58.Belgium (BEL)[Q]Xavier Malisse7-6(12) 6-4 2-6 4-6 8-6
Nicolas Almagro
59.Germany (GER)Benjamin Becker6-4 6-2 3-6 4-6 6-3
Benjamin Becker
60.Slovenia (SLO)[Q]Grega Zemlja7-6(5) 7-5 7-5
Nicolas Almagro
61.Colombia (COL)Alejandro Falla6-4 6-3 6-4
Alejandro Falla
62.Brazil (BRA)Marcos Daniel7-5 6-3 6-1
Alejandro Falla
63.Spain (ESP)Marcel Granollers6-4 6-1 6-3
Marcel Granollers
64.Sweden (SWE)[8]Robin Soderling5-7 2-6 6-4 6-4 6-2
Roger Federer
65.United States (USA)[7]Andy Roddick6-3 6-4 7-6(11)
Andy Roddick
66.Netherlands (NED)Thiemo De Bakker6-1 6-4 6-4
Andy Roddick
67.Brazil (BRA)Thomaz Bellucci6-3 6-4 6-4
Thomaz Bellucci
68.Russia (RUS)Teymuraz Gabashvili6-3 7-5 4-6 6-4
Andy Roddick
69.Spain (ESP)Feliciano Lopez6-7(4) 6-4 6-4 7-6(3)
Feliciano Lopez
70.Uruguay (URU)Pablo Cuevas6-1 6-4 7-5
Feliciano Lopez
71.Germany (GER)Rainer Schuettler6-3 2-6 6-3 6-2
Rainer Schuettler
72.United States (USA)[25]Sam Querrey 6-3 2-6 6-4 6-3
Andy Roddick
73.Czech Republic (CZE)[21]Tomas Berdych6-3 3-6 4-6 7-5 6-2
Tomas Berdych
74.Netherlands (NED)Robin Haase6-0 6-3 6-3
Evgeny Korolev
75.Kazakhstan (KAZ)Evgeny Korolev6-4 6-4 7-5
Evgeny Korolev
76.Germany (GER)Daniel Brands6-2 7-5 7-5
Fernando Gonzalez
77.Turkey (TUR)[LL]Marsel Ilhan6-7(5) 6-3 1-6 6-3 6-4
Marsel Ilhan
78.France (FRA)[WC]Sebastien Grosjean6-4 6-3 7-5
Fernando Gonzalez
79.Chile (CHI)[11]Fernando Gonzalez6-3 6-4 7-5
Fernando Gonzalez
80.Belgium (BEL)Olivier Rochus6-3 6-4 3-6 6-1
Marin Cilic
81.Croatia (CRO)[14]Marin Cilic7-6(4) 6-3 3-6 2-6 6-3
Marin Cilic
82.France (FRA)Fabrice Santoro7-5 7-5 6-3
Marin Cilic
83.Australia (AUS)[WC]Bernard Tomic6-7(6) 6-3 4-6 6-2 6-4
Bernard Tomic
84.France (FRA)[Q]Guillaume Rufin6-3 6-4 6-4
Marin Cilic
85.Russia (RUS)Igor Kunitsyn4-6 6-4 6-3 6-3
Igor Kunitsyn
86.Argentina (ARG)Jose Acasuso6-1 2-6 6-4 6-2
Stan Wawrinka
87.Switzerland (SUI)[19]Stan Wawrinka6-3 6-2 6-2
Stan Wawrinka
88.Spain (ESP)Guillermo Garcia-Lopez6-3 6-3 6-2
Marin Cilic
89.Serbia (SRB)[29]Viktor Troicki5-7 6-4 7-5 5-7 6-3
Viktor Troicki
90.Ecuador (ECU)Nicolas Lapentti4-6 6-3 6-1 6-3
Florian Mayer
91.Germany (GER)Florian Mayer4-6 6-4 7-6(2) 6-1
Florian Mayer
92.Germany (GER)Philipp Petzschner 0-6 2-6 6-4 6-2 6-2
Juan Martin Del Potro
93.United States (USA)James Blake6-3 0-6 6-4 7-5
James Blake
94.France (FRA)Arnaud Clement7-5 7-5 6-2
Juan Martin Del Potro
95.Argentina (ARG)[4]Juan Martin Del Potro 6-4 6-7(3) 5-7 6-3 10-8
Juan Martin Del Potro
96.United States (USA)Michael Russell6-4 6-4 3-6 6-2
Andy Murray
97.United Kingdom (GBR)[5]Andy Murray3-6 6-4 6-4 6-2
Andy Murray
98.South Africa (RSA)[Q]Kevin Anderson6-1 6-1 6-2
Andy Murray
99.France (FRA)Marc Gicquel6-1 6-4 6-3
Marc Gicquel
100.Italy (ITA)Simone Bolelli7-6(2) 7-6(3) 6-3
Andy Murray
101.Finland (FIN)Jarkko Nieminen 7-5 6-1 6-4
Jarkko Nieminen
102.Australia (AUS)[WC]Nick Lindahl6-2 7-5 6-4
Florent Serra
103.France (FRA)Florent Serra3-6 6-4 5-7 7-6(4) 7-5
Florent Serra
104.Austria (AUT)[28]Jurgen Melzer6-1 6-7(3) 6-4 4-6 6-3
Andy Murray
105.United States (USA)[33]John Isner7-6(4) 6-3 6-2
John Isner
106.Italy (ITA)Andreas Seppi6-3 6-3 3-6 5-7 6-4
John Isner
107.Ireland (IRL)[Q]Louk Sorensen6-3 7-6(4) 7-5
Louk Sorensen
108.Taiwan (TPE)Yen-Hsun Lu 6-4 3-6 6-2 6-1
John Isner
109.Croatia (CRO)[Q]Antonio Veic6-1 4-6 7-6(4) 7-6(5)
Antonio Veic
110.Austria (AUT)Daniel Koellerer6-4 3-6 6-7(3) 6-1 6-4
Gael Monfils
111.France (FRA)[12]Gael Monfils6-4 6-4 6-4
Gael Monfils
112.Australia (AUS)[Q]Matthew Ebden6-4 6-4 6-4
Andy Murray
113.Croatia (CRO)Ivo Karlovic6-3 7-6(2) 3-0 rtd.
Ivo Karlovic
114.Czech Republic (CZE)[13]Radek Stepanek2-6 7-6(5) 6-4 3-6 6-4
Ivo Karlovic
115.France (FRA)Julien Benneteau 2-6 6-1 6-3 6-3
Julien Benneteau
116.France (FRA)[Q]David Guez0-6 6-4 7-6(4) 7-6(2)
Ivo Karlovic
117.Kazakhstan (KAZ)[WC]Andrey Golubev6-3 3-6 6-3 7-6(7)
Andrey Golubev
118.United States (USA)Mardy Fish6-2 1-6 6-3 6-3
Ivan Ljubicic
119.Bosnia and Herzegovina (BIH)[24]Ivan Ljubicic6-3 3-6 6-2 6-3
Ivan Ljubicic
120.Australia (AUS)[WC]Jason Kubler6-1 6-2 6-2
Rafael Nadal
121.Germany (GER)[27]Philipp Kohlschreiber6-4 4-6 6-4 6-4
Philipp Kohlschreiber
122.Argentina (ARG)Horacio Zeballos Jr.6-1 7-5 6-1
Philipp Kohlschreiber
123.United States (USA)Wayne Odesnik6-4 3-6 6-3 6-2
Wayne Odesnik
124.Slovenia (SLO)[Q]Blaz Kavcic4-6 6-1 6-4 6-2
Rafael Nadal
125.Slovakia (SVK)Lukas Lacko6-4 6-2 2-6 7-5
Lukas Lacko
126.Argentina (ARG)Leonardo Mayer6-4 6-4 6-0
Rafael Nadal
127.Spain (ESP)[2]Rafael Nadal6-2 6-2 6-2
Rafael Nadal
128.Australia (AUS)Peter Luczak7-6(0) 6-1 6-4
(default) 17 queries took 54 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 1112
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)552
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)112
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 1112
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` ASC1121123
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` = '2010' 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` = (295) 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 (147, 3591, 135, 76, 106, 57, 120, 7310, 65, 7852, 175, 6290, 158, 53, 83, 110, 139, 7846, 7853, 97, 6250, 7313, 111, 93, 123, 89, 88, 7295, 153, 6190, 169, 7473, 52, 90, 5050, 98, 4212, 7241, 114, 160, 72, 75, 5936, 4776, 162, 7301, 54, 5051, 115, 152, 7348, 119, 68, 85, 176, 5052, 163, 86, 159, 3588, 118, 7467, 108, 7248, 67, 4772, 96, 7291, 171, 5934, 4209, 137, 148, 66, 7323, 4929, 4770, 6256, 7327, 150, 3722, 4129, 138, 3581, 78, 7298, 156, 94, 92, 6181, 3583, 63, 3578, 5932, 131, 77, 84, 155, 4926, 3585, 166, 7840, 126, 140, 164, 74, 4774, 125, 7854, 7855, 99, 105, 141, 59, 102, 7309, 73, 116, 172, 7856, 122, 4215, 3718, 129, 173, 170, 179, 4210) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC12812824
10SELECT `Playercontest`.`id`, `Playercontest`.`player_id`, `Playercontest`.`contest_id`, `Playercontest`.`nat_id`, `Playercontest`.`draw` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE `Playercontest`.`contest_id` = 2951281283
11SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (164, 92, 43, 53, 72, 13, 133, 197, 154, 96, 68, 10, 173, 196, 21, 104, 29, 91, 150, 50, 199, 181, 169, 153, 14, 179, 194, 172, 52, 149, 67, 27, 168, 190, 90, 198, 58, 178, 41)39392
12SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (164, 92, 43, 53, 72, 13, 133, 197, 154, 96, 68, 10, 173, 196, 21, 104, 29, 91, 150, 50, 199, 181, 169, 153, 14, 179, 194, 172, 52, 149, 67, 27, 168, 190, 90, 198, 58, 178, 41)39392
13SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (147, 3591, 135, 76, 106, 57, 120, 7310, 65, 7852, 175, 6290, 158, 53, 83, 110, 139, 7846, 7853, 97, 6250, 7313, 111, 93, 123, 89, 88, 7295, 153, 6190, 169, 7473, 52, 90, 5050, 98, 4212, 7241, 114, 160, 72, 75, 5936, 4776, 162, 7301, 54, 5051, 115, 152, 7348, 119, 68, 85, 176, 5052, 163, 86, 159, 3588, 118, 7467, 108, 7248, 67, 4772, 96, 7291, 171, 5934, 4209, 137, 148, 66, 7323, 4929, 4770, 6256, 7327, 150, 3722, 4129, 138, 3581, 78, 7298, 156, 94, 92, 6181, 3583, 63, 3578, 5932, 131, 77, 84, 155, 4926, 3585, 166, 7840, 126, 140, 164, 74, 4774, 125, 7854, 7855, 99, 105, 141, 59, 102, 7309, 73, 116, 172, 7856, 122, 4215, 3718, 129, 173, 170, 179, 4210)) AND (`Playercontest`.`contest_id` = 295))1281281
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` = 201020202
16SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (2, 3, 1, 12, 17, 22, 13, 23, 4, 7, 18, 14, 24, 25, 26, 19, 15, 16, 20, 21) AND `Category`.`gender` = 'Men' AND `Category`.`type` = 'Singles'442
17SELECT `Tournament`.`slug`, `Tournament`.`name` FROM `zavoihu1_db4tennis`.`tournaments` AS `Tournament` WHERE `Tournament`.`id` IN (1, 2, 3, 4)442