back to overall

Wimbledon 2010 Gentlemen's Singles  (June 21 - July 4)

NationR128R64R32R16QFSFFChampion
1.Switzerland (SUI)[1]Roger Federer
Roger Federer
2.Colombia (COL)Alejandro Falla5-7 4-6 6-4 7-6(1) 6-0
Roger Federer
3.Serbia (SRB)[Q]Ilija Bozoljac6-3 6-7(4) 6-4 7-6(5)
Ilija Bozoljac
4.Chile (CHI)Nicolas Massu7-6(3) 3-6 6-3 7-6(7)
Roger Federer
5.France (FRA)Arnaud Clement6-2 6-4 6-2
Arnaud Clement
6.Serbia (SRB)Janko Tipsarevic6-3 3-6 6-4 7-5
Arnaud Clement
7.Australia (AUS)Peter Luczak6-7(4) 6-3 6-3 6-4
Peter Luczak
8.Spain (ESP)[30]Tommy Robredo2-6 7-6(3) 6-2 7-5
Roger Federer
9.Spain (ESP)[22]Feliciano Lopez6-3 6-2 6-3
Feliciano Lopez
10.United States (USA)[LL]Jesse Levine7-6(2) 3-6 6-2 6-3
Feliciano Lopez
11.Lithuania (LTU)[Q]Ricardas Berankis7-5 4-6 6-3 6-4
Ricardas Berankis
12.Australia (AUS)[Q]Carsten Ball6-2 6-0 3-6 7-6(5)
Jurgen Melzer
13.Serbia (SRB)Viktor Troicki4-6 6-3 6-2 6-4
Viktor Troicki
14.Russia (RUS)Igor Kunitsyn6-3 6-4 6-1
Jurgen Melzer
15.Austria (AUT)[16]Jurgen Melzer6-7(5) 4-6 6-3 7-6(6) 6-3
Jurgen Melzer
16.Germany (GER)Dustin Brown6-3 4-6 6-2 6-3
Tomas Berdych
17.Czech Republic (CZE)[12]Tomas Berdych6-4 3-6 6-1 6-4
Tomas Berdych
18.Kazakhstan (KAZ)Andrey Golubev7-6(5) 6-2 6-2
Tomas Berdych
19.Germany (GER)Benjamin Becker7-5 6-3 6-4
Benjamin Becker
20.United States (USA)[LL]Ryan Sweeting5-7 6-2 6-2 6-4
Tomas Berdych
21.Germany (GER)Rainer Schuettler6-7(1) 7-6(5) 6-7(8) 6-3 6-4
Rainer Schuettler
22.Russia (RUS)Dmitry Tursunov6-2 6-2 6-3
Denis Istomin
23.Uzbekistan (UZB)Denis Istomin6-3 7-6(5) 4-6 4-6 6-1
Denis Istomin
24.Switzerland (SUI)[20]Stan Wawrinka6-7(5) 6-1 2-6 7-6(4) 6-3
Tomas Berdych
25.Romania (ROU)[31]Victor Hanescu4-6 7-6(1) 7-5 6-3
Victor Hanescu
26.Russia (RUS)[WC]Andrey Kuznetsov6-7(4) 7-6(3) 6-3 1-6 7-5
Victor Hanescu
27.Turkey (TUR)[Q]Marsel Ilhan6-4 6-4 3-6 6-3
Marsel Ilhan
28.Brazil (BRA)Marcos Daniel6-7(4) 4-6 6-2 6-3 6-1
Daniel Brands
29.Germany (GER)Daniel Brands6-7(7) 6-7(3) 7-6(7) 6-3 3-0 rtd.
Daniel Brands
30.Russia (RUS)Igor Andreev7-6(5) 7-6(4) 7-5
Daniel Brands
31.Russia (RUS)[7]Nikolay Davydenko1-6 7-6(5) 7-6(8) 6-1
Nikolay Davydenko
32.South Africa (RSA)Kevin Anderson3-6 6-7(3) 7-6(3) 7-5 9-7
Tomas Berdych
33.Serbia (SRB)[3]Novak Djokovic6-3 7-6(9) 6-3
Novak Djokovic
34.Belgium (BEL)Olivier Rochus4-6 6-2 3-6 6-4 6-2
Novak Djokovic
35.United States (USA)[Q]Taylor Dent7-6(5) 6-1 6-4
Taylor Dent
36.Argentina (ARG)Juan Ignacio Chela6-3 6-7(2) 7-6(3) 7-5
Novak Djokovic
37.United States (USA)[Q]Brendan Evans6-1 6-4 6-4
Brendan Evans
38.Netherlands (NED)[Q]Jesse Huta Galung6-3 7-6(12) 6-3
Albert Montanes
39.Spain (ESP)[28]Albert Montanes3-6 6-3 6-7(5) 6-1 6-4
Albert Montanes
40.Italy (ITA)Paolo Lorenzi6-3 7-6(5) 6-2
Novak Djokovic
41.France (FRA)[21]Gael Monfils7-5 6-4 3-6 6-4
Gael Monfils
42.Argentina (ARG)Leonardo Mayer6-1 7-6(9) 6-2
Gael Monfils
43.Slovakia (SVK)Karol Beck6-4 6-4 6-7(4) 6-4
Karol Beck
44.Spain (ESP)[LL]Santiago Ventura6-3 6-1 4-6 6-2
Lleyton Hewitt
45.Kazakhstan (KAZ)Evgeny Korolev6-3 7-6(9) 6-4
Evgeny Korolev
46.Argentina (ARG)Eduardo Schwank6-1 7-6(8) 4-6 6-2
Lleyton Hewitt
47.Australia (AUS)[15]Lleyton Hewitt6-4 6-4 3-0 rtd.
Lleyton Hewitt
48.Argentina (ARG)Maximo Gonzalez5-7 6-0 6-2 6-2
Novak Djokovic
49.Germany (GER)Florian Mayer6-3 6-2 6-2
Florian Mayer
50.Croatia (CRO)[11]Marin Cilic6-2 6-4 7-6(1)
Florian Mayer
51.United States (USA)Mardy Fish6-7(2) 6-3 6-4 6-4
Mardy Fish
52.Australia (AUS)[Q]Bernard Tomic6-3 7-6(8) 6-2
Yen-Hsun Lu
53.Taiwan (TPE)Yen-Hsun Lu 6-4 6-4 2-1 rtd.
Yen-Hsun Lu
54.Argentina (ARG)Horacio Zeballos Jr.7-5 6-4 6-3
Yen-Hsun Lu
55.Poland (POL)Michal Przysiezny6-4 7-6(7) 6-3
Michal Przysiezny
56.Bosnia and Herzegovina (BIH)[17]Ivan Ljubicic7-5 7-6(5) 6-3
Yen-Hsun Lu
57.Germany (GER)[29]Philipp Kohlschreiber4-6 7-6(3) 7-6(4) 6-7(5) 9-7
Philipp Kohlschreiber
58.Italy (ITA)Potito Starace6-3 3-6 6-3 6-0
Philipp Kohlschreiber
59.Russia (RUS)[WC]Teymuraz Gabashvili7-6(6) 5-7 2-6 7-6(5) 9-7
Teymuraz Gabashvili
60.Paraguay (PAR)[LL]Ramon Delgado2-6 6-4 6-4 6-2
Andy Roddick
61.France (FRA)Michael Llodra7-5 6-7(5) 6-3 6-3
Michael Llodra
62.United States (USA)[Q]Jesse Witten6-4 6-4 6-7(5) 6-3
Andy Roddick
63.United States (USA)[5]Andy Roddick4-6 6-4 6-1 7-6(2)
Andy Roddick
64.United States (USA)Rajeev Ram6-3 6-2 6-2
Rafael Nadal
65.Italy (ITA)Fabio Fognini6-3 7-5 6-4
Fabio Fognini
66.Spain (ESP)[8]Fernando Verdasco7-6(9) 6-2 6-7(6) 6-4
Fabio Fognini
67.United States (USA)Michael Russell3-6 5-7 7-5 7-6(6) 6-3
Michael Russell
68.Spain (ESP)Pere Riba6-3 7-6(1) 2-6 7-6(1)
Julien Benneteau
69.Germany (GER)Andreas Beck6-4 6-1 4-6 6-3
Andreas Beck
70.United Kingdom (GBR)[WC]Jamie Baker7-6(4) 6-3 6-4
Julien Benneteau
71.France (FRA)[32]Julien Benneteau 3-6 6-2 4-6 7-6(5) 6-3
Julien Benneteau
72.Belgium (BEL)Kristof Vliegen2-6 6-7(6) 6-1 6-2 7-5
Jo-Wilfried Tsonga
73.Italy (ITA)Andreas Seppi6-1 6-4 3-6 6-1
Andreas Seppi
74.Spain (ESP)[19]Nicolas Almagro 7-6(4) 7-6(7) 6-2
Tobias Kamke
75.Germany (GER)[Q]Tobias Kamke3-6 6-2 6-3 6-4
Tobias Kamke
76.Spain (ESP)Guillermo Garcia-Lopez5-7 2-6 7-5 6-4 6-4
Jo-Wilfried Tsonga
77.Ukraine (UKR)Alexandr Dolgopolov 6-1 6-4 7-6(1)
Alexandr Dolgopolov
78.Switzerland (SUI)Marco Chiudinelli6-4 6-3 6-3
Jo-Wilfried Tsonga
79.France (FRA)[10]Jo-Wilfried Tsonga6-4 6-4 6-7(5) 5-7 10-8
Jo-Wilfried Tsonga
80.United States (USA)[Q]Robert Kendrick7-6(2) 7-6(6) 3-6 6-4
Andy Murray
81.Belgium (BEL)Xavier Malisse6-7(5) 7-6(5) 6-2 6-2
Xavier Malisse
82.Spain (ESP)[14]Juan Carlos Ferrero6-2 6-7(6) 7-6(5) 4-6 6-1
Xavier Malisse
83.Germany (GER)[LL]Julian Reister6-7(7) 6-4 6-1 6-4
Julian Reister
84.South Africa (RSA)[Q]Rik De Voest6-4 7-5 3-6 6-2
Sam Querrey
85.Croatia (CRO)[Q]Ivan Dodig6-7(4) 6-4 6-2 5-7 9-7
Ivan Dodig
86.Spain (ESP)Oscar Hernandez6-1 6-3 6-3
Sam Querrey
87.United States (USA)[18]Sam Querrey 6-2 5-7 6-3 7-6(10)
Sam Querrey
88.Ukraine (UKR)Sergiy Stakhovsky7-6(4) 6-3 2-1 rtd.
Andy Murray
89.France (FRA)[26]Gilles Simon7-5 6-3 6-4
Gilles Simon
90.Spain (ESP)[Q]Guillermo Alcaide6-3 6-4 7-6(0)
Gilles Simon
91.Ukraine (UKR)Illya Marchenko w/o
Illya Marchenko
92.Germany (GER)Michael Berrer6-3 7-5 rtd.
Andy Murray
93.Finland (FIN)Jarkko Nieminen 6-1 6-4 6-4
Jarkko Nieminen
94.Austria (AUT)[LL]Stefan Koubek6-4 7-6(3) 5-7 6-2
Andy Murray
95.United Kingdom (GBR)[4]Andy Murray6-3 6-4 6-2
Andy Murray
96.Czech Republic (CZE)Jan Hajek7-5 6-1 6-2
Rafael Nadal
97.Sweden (SWE)[6]Robin Soderling6-4 7-6(6) 6-4
Robin Soderling
98.United States (USA)Robby Ginepri6-2 6-2 6-3
Robin Soderling
99.Spain (ESP)Marcel Granollers7-5 6-1 6-4
Marcel Granollers
100.Portugal (POR)Frederico Gil6-3 6-0 6-4
Robin Soderling
101.Austria (AUT)[Q]Martin Fischer6-4 6-2 7-5
Martin Fischer
102.Japan (JPN)[LL]Go Soeda6-4 6-3 6-1
Thomaz Bellucci
103.Brazil (BRA)[25]Thomaz Bellucci6-7(11) 7-6(4) 7-6(1) 6-2
Thomaz Bellucci
104.Brazil (BRA)Ricardo Mello6-4 6-4 6-4
Robin Soderling
105.Slovakia (SVK)Lukas Lacko6-2 5-7 6-2 3-6 7-5
Lukas Lacko
106.Cyprus (CYP)[24]Marcos Baghdatis 6-3 2-6 6-3 6-1
Jeremy Chardy
107.France (FRA)Jeremy Chardy6-3 7-6(4) 4-6 6-7(5) 8-6
Jeremy Chardy
108.Spain (ESP)Daniel Gimeno-Traver6-3 6-3 6-1
David Ferrer
109.France (FRA)Florent Serra7-5 6-3 4-6 3-6 7-5
Florent Serra
110.Germany (GER)Simon Greul7-6(2) 6-3 6-2
David Ferrer
111.Spain (ESP)[9]David Ferrer6-4 7-5 6-7(6) 6-3
David Ferrer
112.Germany (GER)[WC]Nicolas Kiefer6-4 6-2 6-3
Rafael Nadal
113.Russia (RUS)[13]Mikhail Youzhny 3-6 6-3 7-6(4) 6-1
Mikhail Youzhny
114.Israel (ISR)Dudi Sela6-3 6-4 4-6 7-6(2)
Paul-Henri Mathieu
115.France (FRA)Paul-Henri Mathieu6-4 2-6 2-6 6-3 6-4
Paul-Henri Mathieu
116.France (FRA)Marc Gicquel6-1 7-5 3-6 6-1
Paul-Henri Mathieu
117.Netherlands (NED)Thiemo De Bakker7-6(5) 7-6(6) 6-7(8) 6-4
Thiemo De Bakker
118.Colombia (COL)Santiago Giraldo6-7(4) 6-4 6-3 5-7 16-14
Thiemo De Bakker
119.United States (USA)[23]John Isner6-0 6-3 6-2
John Isner
120.France (FRA)[Q]Nicolas Mahut6-4 3-6 6-7(7) 7-6(3) 70-68
Rafael Nadal
121.Germany (GER)[33]Philipp Petzschner 6-4 6-2 6-2
Philipp Petzschner
122.France (FRA)Stephane Robert6-4 7-6(6) 4-6 2-6 6-4
Philipp Petzschner
123.Poland (POL)Lukasz Kubot6-4 3-6 4-6 6-3 6-2
Lukasz Kubot
124.Slovenia (SLO)Blaz Kavcic4-6 6-2 6-2 6-3
Rafael Nadal
125.Netherlands (NED)Robin Haase6-4 4-6 6-7(5) 6-2 6-3
Robin Haase
126.United States (USA)James Blake6-2 6-4 6-4
Rafael Nadal
127.Spain (ESP)[2]Rafael Nadal5-7 6-2 3-6 6-0 6-3
Rafael Nadal
128.Japan (JPN)[WC]Kei Nishikori6-2 6-4 6-4
(default) 17 queries took 26 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` ASC1371372
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` = '2010' 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` = (532) 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, 118, 7836, 7292, 5932, 68, 4210, 5051, 171, 109, 8674, 7846, 92, 78, 140, 3717, 148, 73, 159, 81, 4209, 69, 114, 156, 135, 3720, 4770, 7467, 4929, 3591, 169, 155, 52, 150, 7348, 76, 8602, 143, 120, 53, 99, 170, 103, 7307, 7323, 5933, 65, 4208, 3583, 3722, 116, 138, 125, 4215, 8686, 172, 122, 57, 7291, 6253, 88, 8611, 67, 7313, 119, 139, 77, 121, 145, 3719, 102, 7241, 74, 163, 134, 94, 132, 5050, 115, 5054, 86, 93, 8917, 124, 111, 7310, 137, 152, 100, 9054, 153, 4212, 166, 6250, 84, 5936, 7248, 4776, 108, 110, 8919, 3721, 96, 112, 173, 158, 160, 90, 126, 5052, 83, 6175, 72, 97, 3590, 4926, 4772, 54, 164, 58, 63, 106, 162, 129, 66, 3578, 179, 107) 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` = 5321291293
11SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (164, 92, 43, 68, 72, 13, 133, 197, 154, 96, 10, 173, 196, 21, 29, 91, 168, 94, 150, 50, 199, 172, 181, 169, 194, 153, 14, 179, 53, 52, 149, 67, 27, 178, 190, 146, 41, 110)38381
12SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (164, 92, 43, 68, 72, 13, 133, 197, 154, 96, 10, 173, 196, 21, 29, 91, 168, 94, 150, 50, 199, 172, 181, 169, 194, 153, 14, 179, 53, 52, 149, 67, 27, 178, 190, 146, 41, 110)38381
13SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (147, 118, 7836, 7292, 5932, 68, 4210, 5051, 171, 109, 8674, 7846, 92, 78, 140, 3717, 148, 73, 159, 81, 4209, 69, 114, 156, 135, 3720, 4770, 7467, 4929, 3591, 169, 155, 52, 150, 7348, 76, 8602, 143, 120, 53, 99, 170, 103, 7307, 7323, 5933, 65, 4208, 3583, 3722, 116, 138, 125, 4215, 8686, 172, 122, 57, 7291, 6253, 88, 8611, 67, 7313, 119, 139, 77, 121, 145, 3719, 102, 7241, 74, 163, 134, 94, 132, 5050, 115, 5054, 86, 93, 8917, 124, 111, 7310, 137, 152, 100, 9054, 153, 4212, 166, 6250, 84, 5936, 7248, 4776, 108, 110, 8919, 3721, 96, 112, 173, 158, 160, 90, 126, 5052, 83, 6175, 72, 97, 3590, 4926, 4772, 54, 164, 58, 63, 106, 162, 129, 66, 3578, 179, 107)) AND (`Playercontest`.`contest_id` = 532))1281282
14SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 17 ORDER BY `Contest`.`date_from` ASC1371373
15SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 201020201
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'441
17SELECT `Tournament`.`slug`, `Tournament`.`name` FROM `zavoihu1_db4tennis`.`tournaments` AS `Tournament` WHERE `Tournament`.`id` IN (1, 2, 3, 4)440