back to overall

Australian Open 2000 Men's Singles  (January 17 - January 31)

NationR128R64R32R16QFSFFChampion
1.United States (USA)[1]Andre Agassi
Andre Agassi
2.Argentina (ARG)Mariano Puerta6-2 6-2 6-3
Andre Agassi
3.Netherlands (NED)Sjeng Schalken7-5 6-0 6-3
Sjeng Schalken
4.Spain (ESP)Galo Blanco7-6(8) 6-4 7-6(2)
Andre Agassi
5.Argentina (ARG)Mariano Zabaleta6-4 6-4 6-2
Mariano Zabaleta
6.Spain (ESP)Felix Mantilla6-1 5-7 6-3 7-6(5)
Mariano Zabaleta
7.Australia (AUS)[WC]Todd Woodbridge7-6(6) 4-6 6-1 6-4
Todd Woodbridge
8.Netherlands (NED)Jan Siemerink6-4 6-1 6-3
Andre Agassi
9.Australia (AUS)Andrew Ilie6-4 7-6(4) 5-7 6-3
Andrew Ilie
10.United States (USA)Jeff Tarango6-3 7-6(4) 4-6 6-3
Andrew Ilie
11.Czech Republic (CZE)Jiri Novak6-3 7-6(5) 6-7(4) 6-4
Jiri Novak
12.Austria (AUT)Markus Hipfl6-3 4-6 6-3 5-7 6-2
Mark Philippoussis
13.Netherlands (NED)[Q]Raemon Sluiter6-4 7-6(4) 6-1
Raemon Sluiter
14.Italy (ITA)Andrea Gaudenzi3-6 6-1 3-6 6-3 13-11
Mark Philippoussis
15.Australia (AUS)[16]Mark Philippoussis6-1 2-6 7-6(4) 6-1
Mark Philippoussis
16.Israel (ISR)[Q]Noam Okun6-4 6-2 2-6 3-6 6-2
Andre Agassi
17.Netherlands (NED)[9]Richard Krajicek6-4 6-4 6-2
Richard Krajicek
18.France (FRA)Fabrice Santoro6-1 6-2 7-5
Nicolas Escude
19.France (FRA)Nicolas Escude2-6 6-3 6-1 6-3
Nicolas Escude
20.United States (USA)Jim Courier6-7(4) 6-3 7-5 6-1
Nicolas Escude
21.India (IND)[Q]Leander Paes6-4 6-4 6-3
Leander Paes
22.Australia (AUS)[WC]Dejan Petrovic6-2 3-6 7-6(5) 6-4
Andreas Vinciguerra
23.Sweden (SWE)Andreas Vinciguerra7-6(3) 6-4 6-3
Andreas Vinciguerra
24.Argentina (ARG)Hernan Gumy7-6(2) 6-1 6-1
Hicham Arazi
25.Sweden (SWE)[Q]Fredrik Jonsson6-4 6-3 7-6(7)
Fredrik Jonsson
26.Spain (ESP)Jacobo Diaz-Ruiz4-6 4-6 6-2 7-5 6-3
Hicham Arazi
27.Morocco (MAR)Hicham Arazi6-3 6-4 6-4
Hicham Arazi
28.Spain (ESP)Julian Alonso-Pintor6-3 7-6(6) 6-2
Hicham Arazi
29.Spain (ESP)Fernando Vicente6-3 6-3 6-2
Fernando Vicente
30.Spain (ESP)Alberto Berasategui6-0 6-2 6-2
Fernando Vicente
31.United States (USA)[8]Todd Martin6-4 2-6 3-6 6-3 7-5
Todd Martin
32.Zimbabwe (ZIM)Byron Black5-7 6-7(4) 6-4 6-2 8-6
Andre Agassi
33.United States (USA)[3]Pete Sampras6-4 3-6 6-7(0) 7-6(5) 6-1
Pete Sampras
34.Australia (AUS)Wayne Arthurs6-4 7-5 6-4
Pete Sampras
35.Sweden (SWE)Mikael Tillstrom6-3 7-6(6) 6-1
Mikael Tillstrom
36.Canada (CAN)Sebastian Lareau4-6 6-4 6-2 6-1
Pete Sampras
37.Switzerland (SUI)Marc Rosset6-7(9) 3-6 6-3 7-5 6-3
Marc Rosset
38.United Kingdom (GBR)[LL]Jamie Delgado7-6(0) 6-3 7-6(3)
Wayne Black
39.Zimbabwe (ZIM)[Q]Wayne Black6-1 2-6 7-6(1) 6-3
Wayne Black
40.United States (USA)Jan-Michael Gambill7-6(3) 6-1 6-4
Pete Sampras
41.Argentina (ARG)Franco Squillari6-1 6-2 3-6 6-1
Franco Squillari
42.Australia (AUS)[WC]Joseph Sirianni6-3 6-2 6-1
Franco Squillari
43.Australia (AUS)[WC]Mark Woodforde6-4 7-6(3) 3-6 6-4
Mark Woodforde
44.Italy (ITA)[Q]Davide Sanguinetti6-3 6-4 7-6(4)
Slava Dosedel
45.Czech Republic (CZE)Slava Dosedel7-5 6-2 6-3
Slava Dosedel
46.France (FRA)[Q]Julien Boutter7-6(4) 5-7 6-3 7-5
Slava Dosedel
47.Thailand (THA)Paradorn Srichaphan4-6 6-2 6-4 6-1
Paradorn Srichaphan
48.Slovakia (SVK)[14]Karol Kucera6-2 6-4 3-6 6-3
Pete Sampras
49.United Kingdom (GBR)[11]Tim Henman7-5 6-3 6-3
Tim Henman
50.France (FRA)Jerome Golmard6-7(3) 6-3 7-6(4) 7-6(7)
Tim Henman
51.Germany (GER)Rainer Schuettler6-2 4-1 rtd.
Rainer Schuettler
52.Costa Rica (CRC)Juan-Antonio Marin6-3 6-3 6-3
Tim Henman
53.Australia (AUS)[WC]Michael Hill6-1 6-4 4-6 7-6(6)
Michael Hill
54.Germany (GER)Bernd Karbacher6-4 6-2 6-2
Sebastien Grosjean
55.France (FRA)Sebastien Grosjean4-6 6-1 7-6(3) 6-0
Sebastien Grosjean
56.Japan (JPN)[WC]Gouichi Motomura6-3 6-3 6-2
Chris Woodruff
57.Australia (AUS)[WC]James Sekulov7-5 1-6 6-4 3-6 7-5
James Sekulov
58.Bosnia and Herzegovina (BIH)Ivan Ljubicic7-6(5) 4-6 4-6 7-5 6-0
Chris Woodruff
59.United States (USA)Chris Woodruff6-3 6-2 6-2
Chris Woodruff
60.Czech Republic (CZE)Martin Damm6-3 7-6(3) 6-3
Chris Woodruff
61.Germany (GER)Axel Pretzsch6-1 6-4 7-6(6)
Axel Pretzsch
62.United States (USA)[Q]Alex O'Brien7-6(1) 6-2 6-1
Richard Fromberg
63.Australia (AUS)Richard Fromberg7-6(6) 7-6(6) 6-4
Richard Fromberg
64.Sweden (SWE)[6]Thomas Enqvist6-4 7-6(4) 4-6 3-6 10-8
Andre Agassi
65.Spain (ESP)Albert Portas3-6 6-3 6-2 6-4
Albert Portas
66.Brazil (BRA)[5]Gustavo Kuerten4-6 4-6 6-4 7-6(8) 6-4
Adrian Voinea
67.Romania (ROU)Adrian Voinea6-2 6-1 6-3
Adrian Voinea
68.United States (USA)Vince Spadea7-6(1) 4-6 4-6 6-3 6-2
Lleyton Hewitt
69.Australia (AUS)Lleyton Hewitt6-2 7-5 6-3
Lleyton Hewitt
70.United States (USA)Paul Goldstein6-2 6-7(5) 7-6(5) 6-4
Lleyton Hewitt
71.Spain (ESP)Alex Corretja6-0 6-0 6-1
Alex Corretja
72.Armenia (ARM)Sargis Sargsian7-6(5) 6-4 6-4
Magnus Norman
73.Sweden (SWE)Jonas Bjorkman6-3 6-1 7-6(6)
Jonas Bjorkman
74.Australia (AUS)Jason Stoltenberg6-7(6) 6-4 6-4 0-6 6-4
Jonas Bjorkman
75.Czech Republic (CZE)[Q]Jiri Vanek6-4 3-6 6-4 7-6(4)
Jiri Vanek
76.Netherlands (NED)Peter Wessels6-4 6-3 2-6 7-6(5)
Magnus Norman
77.Italy (ITA)Gianluca Pozzi6-4 6-4 7-6(8)
Gianluca Pozzi
78.Czech Republic (CZE)Tomas Zib6-3 7-6(7) 6-7(5) 6-1
Magnus Norman
79.Sweden (SWE)[12]Magnus Norman6-4 6-3 6-4
Magnus Norman
80.United States (USA)Cecil Mamiit7-5 6-4 3-6 6-3
Magnus Norman
81.Croatia (CRO)Goran Ivanisevic3-6 6-3 6-1 7-6(4)
Goran Ivanisevic
82.France (FRA)[13]Cedric Pioline6-4 2-6 7-5 1-6 9-7
Francisco Clavet
83.Spain (ESP)Francisco Clavet7-6(5) 6-4 6-2
Francisco Clavet
84.Slovakia (SVK)Dominik Hrbaty3-6 6-1 6-4 7-6(3)
Wayne Ferreira
85.South Africa (RSA)Wayne Ferreira6-3 6-4 3-6 6-3
Wayne Ferreira
86.Switzerland (SUI)George Bastl6-3 6-3 4-6 7-6(2)
Wayne Ferreira
87.Sweden (SWE)Thomas Johansson6-3 6-2 6-7(2) 4-6 6-2
Thomas Johansson
88.Sweden (SWE)Nicklas Kulti6-1 6-2 6-4
Nicolas Kiefer
89.France (FRA)[Q]Michael Llodra6-3 6-4 6-2
Michael Llodra
90.Argentina (ARG)Gaston Gaudio6-3 6-3 6-2
Karim Alami
91.Morocco (MAR)Karim Alami7-6(4) 6-3 6-2
Karim Alami
92.Switzerland (SUI)Lorenzo Manta6-4 7-6(5) 7-5
Nicolas Kiefer
93.Germany (GER)Tomas Behrend6-3 6-4 6-2
Tomas Behrend
94.Brazil (BRA)Fernando Meligeni6-2 4-6 6-7(5) 6-3 6-0
Nicolas Kiefer
95.Germany (GER)[4]Nicolas Kiefer7-6(5) 6-0 6-2
Nicolas Kiefer
96.Argentina (ARG)Guillermo Canas4-6 6-3 6-4 6-4
Yevgeny Kafelnikov
97.Ecuador (ECU)[7]Nicolas Lapentti6-1 6-2 6-4
Nicolas Lapentti
98.Ukraine (UKR)Andriy Medvedev6-3 5-7 6-7(2) 6-4 8-6
Arnaud Clement
99.France (FRA)Arnaud Clement3-6 7-6(3) 6-2 4-1 rtd.
Arnaud Clement
100.Netherlands (NED)John Van Lottum7-6(2) 6-4 rtd.
Arnaud Clement
101.Slovakia (SVK)Jan Kroslak6-1 6-4 6-3
Jan Kroslak
102.Spain (ESP)Alex Moron6-1 3-6 6-3 7-5
Roger Federer
103.Switzerland (SUI)Roger Federer7-6(1) 6-2 6-3
Roger Federer
104.United States (USA)Michael Chang6-4 6-4 7-6(5)
Younes El Aynaoui
105.Spain (ESP)Juan Carlos Ferrero3-6 6-3 6-4 3-6 10-8
Juan Carlos Ferrero
106.Australia (AUS)[WC]Scott Draper7-6(3) 6-3 7-6(3)
Juan Carlos Ferrero
107.Italy (ITA)Laurence Tieleman7-6(5) 6-4 5-7 6-7(5) 6-4
Laurence Tieleman
108.Spain (ESP)Alberto Martin6-2 7-6(3) 6-7(3) 6-3
Younes El Aynaoui
109.Morocco (MAR)Younes El Aynaoui7-6(3) 4-6 4-6 7-6(5) 6-4
Younes El Aynaoui
110.United Kingdom (GBR)[Q]Arvind Parmar6-7(8) 7-6(5) 1-6 6-3 6-1
Younes El Aynaoui
111.Germany (GER)[10]Tommy Haas7-5 6-3 6-3
Tommy Haas
112.France (FRA)[Q]Cyril Saulnier7-6(2) 6-4 4-6 6-2
Yevgeny Kafelnikov
113.Belgium (BEL)[Q]Christophe Rochus6-0 6-3 7-6(4)
Christophe Rochus
114.Spain (ESP)[15]Albert Costa6-3 6-7(8) 6-4 6-3
Christophe Rochus
115.Zimbabwe (ZIM)[Q]Kevin Ullyett6-4 6-4 6-3
Kevin Ullyett
116.Czech Republic (CZE)[LL]Michal Tabara6-1 7-6(6) 4-6 6-1
Christophe Rochus
117.France (FRA)Antony Dupuis3-6 6-4 6-3 7-6(2)
Antony Dupuis
118.Argentina (ARG)Martin Rodriguez6-4 6-4 7-6(4)
Max Mirnyi
119.Belarus (BLR)Max Mirnyi6-7(3) 7-6(6) 7-6(5) 7-6(5)
Max Mirnyi
120.Haiti (HAI)Ronald Agenor6-7(5) 7-6(5) 6-3 6-3
Yevgeny Kafelnikov
121.Austria (AUT)Stefan Koubek6-1 6-3 7-5
Stefan Koubek
122.France (FRA)[Q]Rodolphe Cadart6-3 5-7 6-2 6-4
Stefan Koubek
123.South Africa (RSA)[Q]Grant Stafford5-7 7-5 2-6 6-2 6-3
Grant Stafford
124.Russia (RUS)Marat Safin7-6(4) 6-4 6-1
Yevgeny Kafelnikov
125.Czech Republic (CZE)Daniel Vacek6-3 6-3 6-4
Daniel Vacek
126.Bulgaria (BUL)Orlin Stanoytchev1-6 7-6(4) 7-6(11) 6-2
Yevgeny Kafelnikov
127.Russia (RUS)[2]Yevgeny Kafelnikov6-3 6-0 6-1
Yevgeny Kafelnikov
128.Germany (GER)Jens Knippschild6-7(4) 6-4 6-1 6-2
(default) 17 queries took 21 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 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` = (1) ORDER BY `Contest`.`year` ASC1121122
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` = '2000' 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` = (285) 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, 6257, 6188, 6212, 6262, 6227, 4123, 4166, 6159, 4066, 6187, 6261, 6270, 5710, 5713, 6271, 4176, 4129, 6234, 4081, 6161, 6272, 6273, 6179, 6244, 6235, 6208, 6238, 6259, 6201, 4142, 4337, 4095, 6255, 6192, 5709, 4143, 6274, 6170, 6226, 6233, 6263, 4022, 6222, 4198, 6275, 6276, 6168, 6197, 6173, 4209, 6239, 6277, 5692, 6256, 6278, 6279, 172, 6204, 4185, 6280, 4336, 4131, 5671, 6231, 6205, 6163, 6169, 65, 6248, 4191, 6213, 5726, 4067, 6281, 6245, 4043, 6282, 6264, 6249, 4108, 4163, 4155, 6230, 4162, 6283, 5723, 4156, 88, 6284, 6162, 6285, 6286, 4188, 6175, 6254, 6181, 5677, 5932, 6265, 6156, 6287, 147, 4045, 93, 6157, 6266, 6223, 5720, 6288, 176, 7200, 6290, 6178, 6291, 6292, 6293, 6294, 6295, 3964, 6250, 6296, 4151, 6260, 5633, 6200, 5702, 7725) 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` = 2851281281
11SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (13, 68, 173, 179, 27, 72, 81, 197, 92, 50, 172, 178, 133, 53, 29, 207, 194, 154, 36, 127, 168, 86, 153, 10, 58, 196, 31, 11, 48, 14, 91, 184, 94, 21, 20)35351
12SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (13, 68, 173, 179, 27, 72, 81, 197, 92, 50, 172, 178, 133, 53, 29, 207, 194, 154, 36, 127, 168, 86, 153, 10, 58, 196, 31, 11, 48, 14, 91, 184, 94, 21, 20)35351
13SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (4001, 6257, 6188, 6212, 6262, 6227, 4123, 4166, 6159, 4066, 6187, 6261, 6270, 5710, 5713, 6271, 4176, 4129, 6234, 4081, 6161, 6272, 6273, 6179, 6244, 6235, 6208, 6238, 6259, 6201, 4142, 4337, 4095, 6255, 6192, 5709, 4143, 6274, 6170, 6226, 6233, 6263, 4022, 6222, 4198, 6275, 6276, 6168, 6197, 6173, 4209, 6239, 6277, 5692, 6256, 6278, 6279, 172, 6204, 4185, 6280, 4336, 4131, 5671, 6231, 6205, 6163, 6169, 65, 6248, 4191, 6213, 5726, 4067, 6281, 6245, 4043, 6282, 6264, 6249, 4108, 4163, 4155, 6230, 4162, 6283, 5723, 4156, 88, 6284, 6162, 6285, 6286, 4188, 6175, 6254, 6181, 5677, 5932, 6265, 6156, 6287, 147, 4045, 93, 6157, 6266, 6223, 5720, 6288, 176, 7200, 6290, 6178, 6291, 6292, 6293, 6294, 6295, 3964, 6250, 6296, 4151, 6260, 5633, 6200, 5702, 7725)) AND (`Playercontest`.`contest_id` = 285))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` = 200020201
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