back to overall

US Open 2003 Men's Singles  (August 25 - September 7)

NationR128R64R32R16QFSFFChampion
1.United States (USA)[1]Andre Agassi
Andre Agassi
2.Spain (ESP)Alex Corretja6-1 6-2 6-2
Andre Agassi
3.Sweden (SWE)Andreas Vinciguerra7-6(1) 6-1 6-4
Andreas Vinciguerra
4.United States (USA)[WC]Robert Kendrick7-6(4) 6-7(2) 7-5 1-6 6-1
Andre Agassi
5.Denmark (DEN)Kenneth Carlsen6-3 7-6(4) 6-4
Kenneth Carlsen
6.United States (USA)[WC]Jeff Morrison6-2 3-6 6-3 6-4
Yevgeny Kafelnikov
7.Russia (RUS)[27]Yevgeny Kafelnikov4-6 6-2 6-3 6-3
Yevgeny Kafelnikov
8.Belgium (BEL)Kristof Vliegen3-6 7-6(1) 6-2 6-2
Andre Agassi
9.Russia (RUS)Nikolay Davydenko6-7(5) 6-4 7-5 rtd.
Nikolay Davydenko
10.Belarus (BLR)[18]Max Mirnyi7-6(3) 2-6 6-2 7-6(6)
Taylor Dent
11.United States (USA)Taylor Dent6-3 6-4 7-6(7)
Taylor Dent
12.Sweden (SWE)[Q]Robin Soderling7-6(1) 6-3 3-6 6-4
Taylor Dent
13.Austria (AUT)Stefan Koubek7-6(9) 6-7(3) 3-6 7-6(4) 6-4
Stefan Koubek
14.Italy (ITA)[Q]Giorgio Galimberti5-7 6-2 6-2 7-6(4)
Fernando Gonzalez
15.Chile (CHI)[15]Fernando Gonzalez7-6(1) 6-1 6-2
Fernando Gonzalez
16.United States (USA)[WC]Michael Chang6-3 7-5 5-7 6-4
Andre Agassi
17.Paraguay (PAR)[Q]Ramon Delgado6-4 6-3 7-5
Ramon Delgado
18.France (FRA)[9]Sebastien Grosjean6-4 6-7(3) 4-6 7-6(7) 6-4
Jonas Bjorkman
19.Sweden (SWE)Jonas Bjorkman4-6 6-4 6-4 3-6 6-3
Jonas Bjorkman
20.Italy (ITA)Filippo Volandri6-1 6-4 6-0
Jonas Bjorkman
21.Slovakia (SVK)Karol Kucera6-4 4-6 6-7(3) 6-4 6-4
Karol Kucera
22.Germany (GER)Alexander Popp6-2 7-5 6-3
Karol Kucera
23.United States (USA)[24]Mardy Fish6-4 7-6(7) 6-4
Mardy Fish
24.Sweden (SWE)[Q]Joachim Johansson6-3 6-2 6-4
Guillermo Coria
25.France (FRA)[30]Arnaud Clement6-2 6-3 4-6 6-2
Arnaud Clement
26.United States (USA)Brian Vahaly6-7(6) 7-6(6) 6-3 6-4
Gregory Carraz
27.France (FRA)Gregory Carraz3-6 1-6 6-2 7-6(3) 6-1
Gregory Carraz
28.United Kingdom (GBR)Greg Rusedski6-4 4-6 6-2 5-7 6-4
Guillermo Coria
29.Czech Republic (CZE)Bohdan Ulihrach7-5 6-1 7-5
Bohdan Ulihrach
30.Germany (GER)[Q]Maximilian Abel4-6 6-4 6-3 6-1
Guillermo Coria
31.Argentina (ARG)[5]Guillermo Coria6-2 6-1 6-4
Guillermo Coria
32.Argentina (ARG)Mariano Puerta6-4 6-3 6-1
Juan Carlos Ferrero
33.Spain (ESP)[3]Juan Carlos Ferrero6-4 6-3 3-6 6-4
Juan Carlos Ferrero
34.Czech Republic (CZE)[Q]Jan Vacek6-2 4-6 6-3 6-2
Juan Carlos Ferrero
35.Austria (AUT)Jurgen Melzer1-6 7-6(2) 6-2 6-4
Jurgen Melzer
36.United States (USA)[WC]Brian Baker6-3 6-3 5-7 6-3
Juan Carlos Ferrero
37.Czech Republic (CZE)[LL]Tomas Berdych7-5 7-5 6-1
Tomas Berdych
38.Germany (GER)Tomas Behrend5-7 6-3 6-2 6-3
Juan Ignacio Chela
39.Argentina (ARG)[32]Juan Ignacio Chela2-6 6-1 6-4 6-3
Juan Ignacio Chela
40.Croatia (CRO)[Q]Roko Karanusic6-4 7-6(2) 6-3
Juan Carlos Ferrero
41.South Africa (RSA)[23]Wayne Ferreira6-2 6-4 3-6 5-7 6-3
Wayne Ferreira
42.Peru (PER)Ivan Miranda6-4 6-3 6-1
Robby Ginepri
43.United States (USA)Robby Ginepri6-2 6-4 6-7(0) 6-2
Robby Ginepri
44.Spain (ESP)David Ferrer6-2 6-3 6-3
Todd Martin
45.United States (USA)Todd Martin6-7(2) 7-6(4) 6-4 6-4
Todd Martin
46.United States (USA)[WC]Robert Yim6-1 7-6(7) 6-2
Todd Martin
47.Netherlands (NED)[16]Martin Verkerk6-3 6-4 6-7(5) 7-6(9)
Martin Verkerk
48.Russia (RUS)[WC]Aleksandr Bogomolov Jr.7-6(4) 4-6 3-6 7-6(9) 1-0 rtd.
Juan Carlos Ferrero
49.Thailand (THA)[11]Paradorn Srichaphan4-6 6-3 7-6(5) 6-1
Paradorn Srichaphan
50.France (FRA)Cyril Saulnier2-6 6-2 6-3 7-6(4)
Paradorn Srichaphan
51.Slovakia (SVK)Dominik Hrbaty6-3 6-4 6-3
Dominik Hrbaty
52.United States (USA)Justin Gimelstob6-3 6-4 6-2
Paradorn Srichaphan
53.Italy (ITA)Davide Sanguinetti6-3 6-4 6-3
Davide Sanguinetti
54.Spain (ESP)Ruben Ramirez Hidalgo4-6 6-0 3-6 6-1 6-1
Fernando Verdasco
55.Spain (ESP)[LL]Fernando Verdasco7-6(6) 7-6(5) 4-6 6-3
Fernando Verdasco
56.Spain (ESP)[17]Tommy Robredo6-3 6-4 6-2
Lleyton Hewitt
57.Czech Republic (CZE)Radek Stepanek4-6 6-2 6-4 6-2
Radek Stepanek
58.Spain (ESP)[28]Feliciano Lopez6-4 6-4 6-4
Radek Stepanek
59.France (FRA)Fabrice Santoro6-2 6-4 6-7(6) 6-3
Fabrice Santoro
60.France (FRA)[Q]Julien Benneteau 0-6 7-5 6-2 6-2
Lleyton Hewitt
61.South Korea (KOR)Hyung-Taik Lee6-1 3-0 rtd.
Hyung-Taik Lee
62.Belarus (BLR)Vladimir Voltchkov6-3 6-4 7-6(3)
Lleyton Hewitt
63.Australia (AUS)[6]Lleyton Hewitt5-7 6-2 6-2 6-4
Lleyton Hewitt
64.Romania (ROU)Victor Hanescu6-3 6-2 6-2
Andy Roddick
65.Germany (GER)[8]Rainer Schuettler6-3 7-6(2) 6-3
Rainer Schuettler
66.Australia (AUS)Wayne Arthurs4-6 6-3 6-2 6-4
Rainer Schuettler
67.Germany (GER)Nicolas Kiefer6-1 7-5 2-6 6-4
Nicolas Kiefer
68.Argentina (ARG)Franco Squillari6-3 5-0 rtd.
Rainer Schuettler
69.Spain (ESP)Alberto Martin6-1 6-4 6-2
Alberto Martin
70.France (FRA)Olivier Mutis6-0 6-3 6-1
Alberto Martin
71.Spain (ESP)[25]Albert Costa6-3 6-3 3-6 6-2
Albert Costa
72.Netherlands (NED)Raemon Sluiter7-6(5) 7-6(3) 2-6 6-3
Sjeng Schalken
73.Croatia (CRO)[Q]Ivo Karlovic6-1 4-6 6-3 6-4
Ivo Karlovic
74.Spain (ESP)[21]Felix Mantilla6-4 6-4 6-4
Ivo Karlovic
75.Morocco (MAR)Hicham Arazi3-6 7-6(5) 7-6(4) 7-6(6)
Hicham Arazi
76.United States (USA)[Q]Jeff Salzenstein6-1 7-6(4) 6-3
Sjeng Schalken
77.Germany (GER)Lars Burgsmuller7-6(8) 7-6(5) 7-6(3)
Lars Burgsmuller
78.Peru (PER)Luis Horna6-4 4-6 3-6 7-5 6-1
Sjeng Schalken
79.Netherlands (NED)[12]Sjeng Schalken4-6 2-6 6-2 6-2 6-0
Sjeng Schalken
80.France (FRA)Julien Boutter6-2 6-3 6-2
Andy Roddick
81.Russia (RUS)[Q]Dmitry Tursunov6-4 6-2 6-3
Dmitry Tursunov
82.Brazil (BRA)[14]Gustavo Kuerten5-7 6-2 6-2 4-6 7-6(1)
Dmitry Tursunov
83.Netherlands (NED)John Van Lottum6-4 3-6 6-3 5-7 6-2
John Van Lottum
84.Belgium (BEL)Christophe Rochus6-0 6-2 6-2
Xavier Malisse
85.Belgium (BEL)Xavier Malisse7-5 6-4 7-6(8)
Xavier Malisse
86.Belgium (BEL)Olivier Rochus6-3 6-4 6-2
Xavier Malisse
87.Argentina (ARG)[19]Agustin Calleri6-2 6-7(3) 6-3 3-6 6-3
Agustin Calleri
88.Austria (AUT)Werner Eschauer7-6(4) 7-6(2) 1-6 6-4
Andy Roddick
89.Brazil (BRA)Flavio Saretta6-3 6-4 7-6(5)
Flavio Saretta
90.United States (USA)[31]Vince Spadea6-3 6-1 5-7 7-6(8)
Flavio Saretta
91.Ecuador (ECU)Nicolas Lapentti6-2 6-4 6-0
Nicolas Lapentti
92.Slovakia (SVK)Karol Beck4-6 6-3 7-5 3-6 6-4
Andy Roddick
93.Bosnia and Herzegovina (BIH)Ivan Ljubicic6-1 6-3 6-3
Ivan Ljubicic
94.France (FRA)Paul-Henri Mathieu6-4 6-2 7-5
Andy Roddick
95.United States (USA)[4]Andy Roddick6-3 6-7(4) 6-3 7-6(8)
Andy Roddick
96.United Kingdom (GBR)Tim Henman6-3 7-6(2) 6-3
Andy Roddick
97.Spain (ESP)[7]Carlos Moya6-7(4) 3-6 7-6(7) 6-1 6-3
Carlos Moya
98.Australia (AUS)Scott Draper4-6 6-4 7-5 7-6(6)
Carlos Moya
99.South Africa (RSA)[Q]Wesley Moodie6-2 7-6(6) 6-3
Wesley Moodie
100.Spain (ESP)Albert Montanes7-6(3) 6-2 6-2
Carlos Moya
101.Sweden (SWE)[Q]Thomas Enqvist7-5 6-4 3-6 6-3
Thomas Enqvist
102.Spain (ESP)Albert Portas6-2 6-3 6-1
Nicolas Massu
103.Chile (CHI)Nicolas Massu6-3 6-2 7-5
Nicolas Massu
104.Argentina (ARG)[29]Gaston Gaudio6-3 6-3 6-2
Younes El Aynaoui
105.Morocco (MAR)[22]Younes El Aynaoui7-6(4) 7-6(7) 4-6 6-4
Younes El Aynaoui
106.United States (USA)[WC]Alex Kim7-5 7-6(5) 6-3
Younes El Aynaoui
107.Spain (ESP)Rafael Nadal7-6(6) 6-3 7-6(6)
Rafael Nadal
108.Spain (ESP)Fernando Vicente6-4 6-3 6-3
Younes El Aynaoui
109.United States (USA)Jan-Michael Gambill7-6(1) 5-7 3-6 6-3 7-6(5)
Jan-Michael Gambill
110.Spain (ESP)David Sanchez-Munoz7-6(3) 6-2 6-2
Jiri Novak
111.Czech Republic (CZE)[10]Jiri Novak6-4 6-4 6-4
Jiri Novak
112.Croatia (CRO)Mario Ancic3-6 6-3 5-7 6-2 6-2
David Nalbandian
113.Argentina (ARG)[13]David Nalbandian7-6(2) 6-2 3-6 7-5
David Nalbandian
114.Germany (GER)[Q]Philipp Kohlschreiber6-4 7-6(4) 6-3
David Nalbandian
115.Finland (FIN)Jarkko Nieminen 5-7 6-3 6-1 4-6 7-6(3)
Jarkko Nieminen
116.France (FRA)[Q]Nicolas Mahut6-2 6-4 7-5
David Nalbandian
117.France (FRA)Antony Dupuis7-5 6-7(10) 6-3 6-2
Antony Dupuis
118.Russia (RUS)Mikhail Youzhny 5-7 6-4 3-6 6-3 7-5
Mark Philippoussis
119.Australia (AUS)[20]Mark Philippoussis6-2 6-3 6-4
Mark Philippoussis
120.Serbia and Montenegro (SCG)[Q]Janko Tipsarevic6-2 7-6(4) 6-4
David Nalbandian
121.United States (USA)James Blake3-6 7-6(1) 6-4 6-3
James Blake
122.Argentina (ARG)[26]Mariano Zabaleta7-6(4) 6-3 6-2
James Blake
123.Armenia (ARM)Sargis Sargsian6-3 6-4 4-6 7-6(6)
Sargis Sargsian
124.Bosnia and Herzegovina (BIH)[WC]Amer Delic4-6 6-3 6-7(3) 6-2 7-5
Roger Federer
125.France (FRA)Jean-Rene Lisnard6-3 7-6(4) 6-3
Jean-Rene Lisnard
126.Sweden (SWE)Magnus Norman6-2 6-2 6-7(4) 0-6 7-6(4)
Roger Federer
127.Switzerland (SUI)[2]Roger Federer6-1 6-2 6-0
Roger Federer
128.Argentina (ARG)Jose Acasuso5-7 6-3 6-3 2-0 rtd.
(default) 17 queries took 27 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` = 'us-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` = (4)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` = (4)331
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` = (4)221
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` = 'us-open' 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` = (22) ORDER BY `Contest`.`year` ASC1441442
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` = 4 AND `Contest`.`category_id` = 22 AND `Contest`.`slug` = '2003' 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` = (638) 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 (4001, 4191, 6273, 5054, 5679, 7234, 5702, 7241, 169, 6295, 7348, 7248, 6250, 7260, 7327, 4045, 6253, 6256, 5726, 61, 6168, 8664, 116, 7466, 5932, 7246, 7155, 5705, 6195, 8668, 7326, 6257, 93, 7470, 140, 3727, 148, 6286, 76, 7469, 4162, 7468, 4776, 83, 4142, 8683, 7242, 91, 6276, 7200, 6230, 6218, 6222, 3726, 139, 5051, 59, 171, 4129, 102, 7266, 6251, 65, 135, 4209, 6255, 6175, 6233, 6223, 7159, 6178, 6270, 141, 6227, 6208, 7160, 6165, 7247, 6188, 6275, 69, 6205, 6265, 6290, 86, 150, 7314, 7838, 7250, 6169, 6181, 103, 172, 3590, 67, 6197, 6190, 6157, 7267, 120, 5671, 6231, 7292, 6284, 5720, 7344, 179, 6259, 6226, 7329, 6187, 7255, 167, 122, 166, 58, 6293, 72, 5713, 68, 3578, 6262, 6213, 7284, 4924, 6264, 147, 7298) 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` = 6381281281
11SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (68, 53, 92, 13, 197, 216, 154, 10, 173, 21, 168, 72, 153, 14, 50, 179, 67, 27, 172, 178, 54, 196, 127, 58, 133, 29, 11, 20, 146, 184, 147, 100, 41)33331
12SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (68, 53, 92, 13, 197, 216, 154, 10, 173, 21, 168, 72, 153, 14, 50, 179, 67, 27, 172, 178, 54, 196, 127, 58, 133, 29, 11, 20, 146, 184, 147, 100, 41)33331
13SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (4001, 4191, 6273, 5054, 5679, 7234, 5702, 7241, 169, 6295, 7348, 7248, 6250, 7260, 7327, 4045, 6253, 6256, 5726, 61, 6168, 8664, 116, 7466, 5932, 7246, 7155, 5705, 6195, 8668, 7326, 6257, 93, 7470, 140, 3727, 148, 6286, 76, 7469, 4162, 7468, 4776, 83, 4142, 8683, 7242, 91, 6276, 7200, 6230, 6218, 6222, 3726, 139, 5051, 59, 171, 4129, 102, 7266, 6251, 65, 135, 4209, 6255, 6175, 6233, 6223, 7159, 6178, 6270, 141, 6227, 6208, 7160, 6165, 7247, 6188, 6275, 69, 6205, 6265, 6290, 86, 150, 7314, 7838, 7250, 6169, 6181, 103, 172, 3590, 67, 6197, 6190, 6157, 7267, 120, 5671, 6231, 7292, 6284, 5720, 7344, 179, 6259, 6226, 7329, 6187, 7255, 167, 122, 166, 58, 6293, 72, 5713, 68, 3578, 6262, 6213, 7284, 4924, 6264, 147, 7298)) AND (`Playercontest`.`contest_id` = 638))1281283
14SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 22 ORDER BY `Contest`.`date_from` ASC1441442
15SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 200320202
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'442
17SELECT `Tournament`.`slug`, `Tournament`.`name` FROM `zavoihu1_db4tennis`.`tournaments` AS `Tournament` WHERE `Tournament`.`id` IN (1, 2, 3, 4)442