back to overall

Wimbledon 2007 Gentlemen's Singles  (June 25 - July 8)

NationR128R64R32R16QFSFFChampion
1.Switzerland (SUI)[1]Roger Federer
Roger Federer
2.Russia (RUS)Teymuraz Gabashvili6-3 6-2 6-4
Roger Federer
3.Argentina (ARG)Juan Martin Del Potro 6-2 7-5 6-1
Juan Martin Del Potro
4.Italy (ITA)Davide Sanguinetti3-6 6-3 6-4 6-4
Roger Federer
5.Pakistan (PAK)[Q]Aisam Qureshi6-1 6-4 7-6(4)
Aisam Qureshi
6.United Kingdom (GBR)[Q]Lee Childs6-3 6-4 7-6(6)
Marat Safin
7.Russia (RUS)[26]Marat Safin6-4 6-2 7-6(4)
Marat Safin
8.South Africa (RSA)[Q]Rik De Voest7-6(5) 6-4 7-5
Roger Federer
9.Russia (RUS)[21]Dmitry Tursunovw/o
Dmitry Tursunov
10.Spain (ESP)Nicolas Almagro 7-6(2) 6-4 6-7(7) 6-3
Dmitry Tursunov
11.Germany (GER)Michael Berrer4-6 6-4 6-4 6-4
Michael Berrer
12.Spain (ESP)Albert Montanes6-3 6-3 6-2
Tommy Haas
13.Czech Republic (CZE)[Q]Tomas Zib1-6 6-4 7-6(5) 6-4
Tomas Zib
14.Argentina (ARG)Diego Hartfield4-6 7-6(4) 3-6 6-3 6-4
Tommy Haas
15.Germany (GER)[13]Tommy Haas6-3 7-6(5) 6-4
Tommy Haas
16.United States (USA)[Q]Zack Fleishman6-3 6-4 6-2
Roger Federer
17.United States (USA)[9]James Blake7-6(2) 3-6 6-1 6-3
James Blake
18.Russia (RUS)Igor Andreev6-3 6-4 6-4
James Blake
19.Romania (ROU)Andrei Pavel6-4 6-3 6-3
Andrei Pavel
20.Argentina (ARG)Juan-Pablo Guzman6-4 6-4 6-1
Juan Carlos Ferrero
21.Luxembourg (LUX)[Q]Gilles Muller3-6 6-3 6-3 7-6(4)
Gilles Muller
22.Spain (ESP)Oscar Hernandez6-2 6-7(6) 4-3 rtd.
Juan Carlos Ferrero
23.Spain (ESP)[20]Juan Carlos Ferrero6-4 6-4 6-7(2) 7-6(8)
Juan Carlos Ferrero
24.Czech Republic (CZE)Jan Hajek6-7(5) 4-6 6-3 6-2 7-5
Juan Carlos Ferrero
25.France (FRA)Florent Serra7-5 6-3 7-6(5)
Florent Serra
26.Germany (GER)[27]Philipp Kohlschreiber7-6(4) 6-4 6-4
Janko Tipsarevic
27.Serbia (SRB)Janko Tipsarevic6-3 6-2 6-7(3) 3-6 6-2
Janko Tipsarevic
28.Austria (AUT)Alexander Peya4-6 3-6 6-3 6-4 6-3
Janko Tipsarevic
29.Colombia (COL)[Q]Alejandro Falla6-3 3-6 6-3 4-6 8-6
Alejandro Falla
30.United States (USA)Sam Querrey 7-6(5) 6-1 6-4
Fernando Gonzalez
31.Chile (CHI)[5]Fernando Gonzalez4-6 6-3 6-4 7-6(1)
Fernando Gonzalez
32.United States (USA)Robby Ginepri3-6 7-6(4) 6-2 6-2
Roger Federer
33.United States (USA)[3]Andy Roddick7-5 6-3 6-4
Andy Roddick
34.United States (USA)Justin Gimelstob6-1 7-5 7-6(3)
Andy Roddick
35.Thailand (THA)Danai Udomchoke6-3 6-4 7-6(3)
Danai Udomchoke
36.Argentina (ARG)Carlos Berlocq6-4 7-5 6-3
Andy Roddick
37.Spain (ESP)Fernando Verdasco6-3 6-4 7-6(2)
Fernando Verdasco
38.United States (USA)[Q]Bobby Reynolds6-4 6-4 6-3
Fernando Verdasco
39.Italy (ITA)Andreas Seppi6-3 6-2 6-4
Andreas Seppi
40.Slovakia (SVK)[31]Dominik Hrbaty7-6(8) 6-1 6-2
Andy Roddick
41.Spain (ESP)[17]David Ferrer6-2 7-5 7-6(6)
David Ferrer
42.Argentina (ARG)Sergio Roitman6-3 6-3 6-1
Paul-Henri Mathieu
43.France (FRA)Paul-Henri Mathieu6-3 6-4 6-3
Paul-Henri Mathieu
44.Czech Republic (CZE)Radek Stepanek7-6(4) 6-2 6-2
Paul-Henri Mathieu
45.Czech Republic (CZE)Jan Hernych4-6 7-5 6-2 6-3
Jan Hernych
46.France (FRA)Marc Gicquel0-6 6-4 6-4 6-4
Ivan Ljubicic
47.Bosnia and Herzegovina (BIH)[15]Ivan Ljubicic6-4 6-3 6-4
Ivan Ljubicic
48.United States (USA)Vince Spadea6-4 6-4 4-6 7-6(4)
Richard Gasquet
49.France (FRA)[12]Richard Gasquet4-6 4-6 7-6(2) 7-6(3) 8-6
Richard Gasquet
50.Czech Republic (CZE)[Q]Bohdan Ulihrach6-3 6-4 6-4
Richard Gasquet
51.France (FRA)[Q]Nicolas Mahut6-4 6-3 6-4
Nicolas Mahut
52.France (FRA)Arnaud Clement6-3 3-6 7-6(5) 6-4
Richard Gasquet
53.France (FRA)[Q]Edouard Roger-Vasselin6-3 6-4 6-2
Edouard Roger-Vasselin
54.United Kingdom (GBR)[WC]Jamie Baker7-6(2) 6-2 6-3
Edouard Roger-Vasselin
55.Argentina (ARG)[24]Juan Ignacio Chela7-6(3) 6-4 7-5
Juan Ignacio Chela
56.Germany (GER)Benjamin Becker3-6 4-6 6-4 6-4 10-8
Richard Gasquet
57.United Kingdom (GBR)Tim Henman6-4 6-3 6-4
Tim Henman
58.Spain (ESP)[25]Carlos Moya6-3 1-6 5-7 6-2 13-11
Feliciano Lopez
59.Spain (ESP)Feliciano Lopez7-6(3) 7-6(5) 3-6 2-6 6-1
Feliciano Lopez
60.United Kingdom (GBR)[WC]Josh Goodall6-1 6-4 6-4
Jo-Wilfried Tsonga
61.France (FRA)[WC]Jo-Wilfried Tsonga6-3 7-6(4) 6-3
Jo-Wilfried Tsonga
62.France (FRA)Julien Benneteau 7-6(4) 7-5 6-4
Jo-Wilfried Tsonga
63.Ecuador (ECU)Nicolas Lapentti6-4 6-2 6-3
Nicolas Lapentti
64.United States (USA)[LL]Kevin Kim2-6 6-2 4-6 6-3 6-4
Roger Federer
65.Russia (RUS)[6]Nikolay Davydenko7-6(7) 4-6 7-6(3) 2-6 6-2
Nikolay Davydenko
66.Kazakhstan (KAZ)Evgeny Korolev7-6(12) 6-4 7-6(5)
Nikolay Davydenko
67.Australia (AUS)Chris Guccione3-6 5-7 7-6(5) 6-4 6-2
Chris Guccione
68.United Kingdom (GBR)[WC]Alex Bogdanovic7-6(2) 6-4 6-4
Nikolay Davydenko
69.France (FRA)Gael Monfils6-3 7-5 6-3
Gael Monfils
70.Sweden (SWE)Thomas Johansson6-4 7-6(5) 6-2
Gael Monfils
71.Belgium (BEL)Kristof Vliegen7-5 7-6(4) 7-6(1)
Kristof Vliegen
72.Argentina (ARG)[32]Juan Monaco6-4 6-3 7-6(3)
Marcos Baghdatis
73.Argentina (ARG)[23]David Nalbandian7-6(5) 7-6(5) 6-3
David Nalbandian
74.Germany (GER)[Q]Mischa Zverev6-3 6-4 6-2
David Nalbandian
75.Canada (CAN)[LL]Frank Dancevic6-2 6-3 5-7 6-3
Frank Dancevic
76.Austria (AUT)Stefan Koubek6-2 6-4 6-2
Marcos Baghdatis
77.France (FRA)Nicolas Devilder6-2 7-5 6-0
Nicolas Devilder
78.Argentina (ARG)Mariano Zabaleta6-7(3) 6-4 7-5 6-4
Marcos Baghdatis
79.Cyprus (CYP)[10]Marcos Baghdatis 6-0 7-6(5) 6-7(4) 6-2
Marcos Baghdatis
80.Latvia (LAT)Ernests Gulbis3-6 6-4 6-3 6-2
Novak Djokovic
81.Australia (AUS)[16]Lleyton Hewitt7-6(4) 7-6(9) 6-7(3) 4-6 7-5
Lleyton Hewitt
82.United Kingdom (GBR)[WC]Richard Bloomfield7-5 6-3 7-5
Lleyton Hewitt
83.Italy (ITA)Simone Bolelli6-2 6-2 6-1
Simone Bolelli
84.Spain (ESP)Guillermo Garcia-Lopez4-6 7-6(5) 6-4 6-4
Lleyton Hewitt
85.Belarus (BLR)Max Mirnyi6-4 3-6 6-3 6-4
Max Mirnyi
86.Taiwan (TPE)Yen-Hsun Lu 6-3 6-4 2-1 rtd.
Guillermo Canas
87.Argentina (ARG)[22]Guillermo Canas6-7(4) 6-1 7-6(4) 7-6(4)
Guillermo Canas
88.Spain (ESP)Ivan Navarro7-6(3) 6-3 6-1
Novak Djokovic
89.Germany (GER)Nicolas Kiefer7-6(8) 7-6(2) 4-6 7-6(5)
Nicolas Kiefer
90.Italy (ITA)[30]Filippo Volandri6-3 7-6(6) 6-1
Nicolas Kiefer
91.France (FRA)Fabrice Santoro6-4 6-3 6-4
Fabrice Santoro
92.Croatia (CRO)Ivo Karlovic4-6 7-6(4) 7-6(3) 3-6 6-4
Novak Djokovic
93.Bosnia and Herzegovina (BIH)Amer Delic7-6(4) 6-7(6) 6-2 7-6(5)
Amer Delic
94.Czech Republic (CZE)Lukas Dlouhy6-3 6-4 5-7 6-4
Novak Djokovic
95.Serbia (SRB)[4]Novak Djokovic6-3 3-6 6-3 7-6(4)
Novak Djokovic
96.Italy (ITA)Potito Starace6-0 6-3 6-4
Rafael Nadal
97.Czech Republic (CZE)[7]Tomas Berdych3-6 6-1 4-1 rtd.
Tomas Berdych
98.Chile (CHI)Nicolas Massu7-6(5) 6-4 6-2
Tomas Berdych
99.France (FRA)Michael Llodra7-6(4) 7-6(2) 3-6 7-6(4)
Michael Llodra
100.Switzerland (SUI)Stan Wawrinka6-4 6-4 6-1
Tomas Berdych
101.South Korea (KOR)Hyung-Taik Lee6-4 7-6(2) 7-6(3)
Hyung-Taik Lee
102.Argentina (ARG)Martin Arguello6-4 6-2 6-3
Hyung-Taik Lee
103.Argentina (ARG)[29]Agustin Calleri7-6(6) 6-4 6-7(3) 6-3
Agustin Calleri
104.Peru (PER)Luis Horna6-2 7-6(4) 7-5
Tomas Berdych
105.Sweden (SWE)[19]Jonas Bjorkman6-4 6-0 6-7(6) 6-0
Jonas Bjorkman
106.Spain (ESP)[Q]Fernando Vicente6-3 6-1 6-2
Jonas Bjorkman
107.Taiwan (TPE)[Q]Jimmy Wang6-0 6-3 6-7(8) 6-4
Jimmy Wang
108.Russia (RUS)Igor Kunitsyn6-3 6-4 6-7(5) 6-7(8) 6-2
Jonas Bjorkman
109.Australia (AUS)[Q]Wayne Arthurs6-2 6-1 6-4
Wayne Arthurs
110.Netherlands (NED)[WC]Thiemo De Bakker6-7(7) 6-7(7) 7-6(4) 6-4 6-4
Wayne Arthurs
111.Spain (ESP)[11]Tommy Robredo6-3 7-6(5) 6-3
Tommy Robredo
112.United States (USA)Robert Kendrick6-2 3-6 6-3 6-7(5) 6-3
Rafael Nadal
113.Russia (RUS)[14]Mikhail Youzhny 7-6(1) 6-4 6-2
Mikhail Youzhny
114.Denmark (DEN)Kristian Pless6-4 6-2 6-4
Mikhail Youzhny
115.France (FRA)Gilles Simon6-4 4-6 3-6 7-5 6-4
Gilles Simon
116.Croatia (CRO)[WC]Marin Cilic3-6 7-5 6-4 4-6 6-3
Mikhail Youzhny
117.Germany (GER)Florian Mayer7-5 7-6(5) 6-3
Florian Mayer
118.United States (USA)[Q]Sam Warburg6-4 6-2 6-2
Jarkko Nieminen
119.Finland (FIN)[18]Jarkko Nieminen 3-6 6-3 7-6(2) 2-6 6-3
Jarkko Nieminen
120.United States (USA)Michael Russell6-3 6-2 7-5
Rafael Nadal
121.Sweden (SWE)[28]Robin Soderling4-6 3-6 6-1 6-2 6-2
Robin Soderling
122.Belgium (BEL)Olivier Rochus6-3 6-2 6-2
Robin Soderling
123.France (FRA)Sebastien Grosjean6-3 3-6 6-3 6-2
Sebastien Grosjean
124.United Kingdom (GBR)[WC]Jonathan Marray6-2 7-6(0) 7-5
Rafael Nadal
125.Austria (AUT)Werner Eschauer6-4 6-4 6-7(7) 4-6 7-5
Werner Eschauer
126.Spain (ESP)Ruben Ramirez Hidalgo6-2 3-6 6-4 6-3
Rafael Nadal
127.Spain (ESP)[2]Rafael Nadal6-2 6-4 6-1
Rafael Nadal
128.United States (USA)Mardy Fish6-3 7-6(4) 6-3
(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` ASC1371373
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` = '2007' 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` = (529) 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, 7291, 131, 6222, 7245, 7735, 6260, 124, 69, 163, 4212, 120, 6282, 7837, 176, 7759, 3578, 3591, 6220, 8684, 117, 7310, 93, 5936, 126, 122, 68, 7289, 118, 137, 7327, 4776, 67, 6218, 101, 142, 139, 4927, 74, 6230, 83, 7209, 3590, 59, 7269, 4926, 172, 6169, 75, 6195, 58, 5932, 87, 3719, 76, 159, 6197, 6190, 171, 3589, 115, 102, 6181, 7265, 169, 7323, 7308, 7764, 99, 5723, 7241, 123, 167, 7301, 4771, 6250, 7271, 6262, 158, 89, 65, 7761, 3585, 94, 6295, 125, 6254, 7319, 6175, 61, 4129, 141, 7284, 7280, 52, 57, 148, 7292, 88, 156, 7266, 7295, 7314, 7247, 5726, 6259, 3587, 78, 6255, 4772, 5051, 5054, 72, 7277, 100, 3722, 3583, 7841, 166, 77, 7248, 150, 6256, 7747, 7838, 3726, 179, 116) 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` = 5291281281
11SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (164, 92, 68, 53, 13, 197, 154, 10, 173, 104, 184, 111, 43, 72, 172, 181, 50, 179, 21, 52, 67, 27, 196, 36, 133, 178, 58, 153, 168, 14, 20, 141, 147, 100, 54, 41, 96)37371
12SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (164, 92, 68, 53, 13, 197, 154, 10, 173, 104, 184, 111, 43, 72, 172, 181, 50, 179, 21, 52, 67, 27, 196, 36, 133, 178, 58, 153, 168, 14, 20, 141, 147, 100, 54, 41, 96)37373
13SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (147, 7291, 131, 6222, 7245, 7735, 6260, 124, 69, 163, 4212, 120, 6282, 7837, 176, 7759, 3578, 3591, 6220, 8684, 117, 7310, 93, 5936, 126, 122, 68, 7289, 118, 137, 7327, 4776, 67, 6218, 101, 142, 139, 4927, 74, 6230, 83, 7209, 3590, 59, 7269, 4926, 172, 6169, 75, 6195, 58, 5932, 87, 3719, 76, 159, 6197, 6190, 171, 3589, 115, 102, 6181, 7265, 169, 7323, 7308, 7764, 99, 5723, 7241, 123, 167, 7301, 4771, 6250, 7271, 6262, 158, 89, 65, 7761, 3585, 94, 6295, 125, 6254, 7319, 6175, 61, 4129, 141, 7284, 7280, 52, 57, 148, 7292, 88, 156, 7266, 7295, 7314, 7247, 5726, 6259, 3587, 78, 6255, 4772, 5051, 5054, 72, 7277, 100, 3722, 3583, 7841, 166, 77, 7248, 150, 6256, 7747, 7838, 3726, 179, 116)) AND (`Playercontest`.`contest_id` = 529))1281282
14SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 17 ORDER BY `Contest`.`date_from` ASC1371371
15SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 200720201
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