Wimbledon 2002 Gentlemen's Singles (June 24 - July 7)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Lleyton Hewitt
				Lleyton Hewitt
2.			Jonas Bjorkman	6-4 7-5 6-1
					Lleyton Hewitt
3.		[Q]	Gregory Carraz		6-4 7-6(5) 6-2
				Gregory Carraz
4.			Cecil Mamiit	6-2 6-4 6-7(5) 7-5
						Lleyton Hewitt
5.			Julian Knowle			6-2 6-1 6-3
				Julian Knowle
6.			Michael Llodra	3-6 6-4 6-3 3-6 6-3
					Julian Knowle
7.		[32]	Jarkko Nieminen		6-3 6-4 6-3
				Jarkko Nieminen
8.		[WC]	Alan Mackin	7-6(5) 6-3 6-3
							Lleyton Hewitt
9.		[24]	Gaston Gaudio				6-3 6-3 7-5
				Gaston Gaudio
10.		[Q]	Juan-Pablo Guzman	6-3 6-4 6-3
					Mikhail Youzhny
11.			Mikhail Youzhny		6-0 1-6 7-6(2) 5-7 6-4
				Mikhail Youzhny
12.		[LL]	Brian Vahaly	6-3 1-6 6-3 6-2
						Mikhail Youzhny
13.			Marc Rosset			6-2 1-6 6-3 6-3
				Marc Rosset
14.			Jose Acasuso	6-3 7-6(4) 6-1
					Nicolas Escude
15.		[16]	Nicolas Escude		6-2 5-7 7-5 6-4
				Nicolas Escude
16.		[WC]	Alex Bogdanovic	4-6 6-4 6-4 6-4
								Lleyton Hewitt
17.		[9]	Juan Carlos Ferrero					6-2 6-2 6-7(5) 1-6 7-5
				Juan Carlos Ferrero
18.			Neville Godwin	6-7(5) 6-3 6-3 6-3
					Jeff Morrison
19.		[LL]	Jeff Morrison		6-3 7-5 7-6(5)
				Jeff Morrison
20.			Noam Okun	6-3 7-6(3) 6-2
						Sjeng Schalken
21.			Michael Chang			6-4 7-6(7) 6-0
				Michael Chang
22.			Lars Burgsmuller	6-3 7-6(4) 6-4
					Sjeng Schalken
23.		[18]	Sjeng Schalken		7-6(2) 6-3 4-6 6-1
				Sjeng Schalken
24.			Kristian Pless	6-3 6-3 7-5
							Sjeng Schalken
25.		[25]	Fabrice Santoro				6-2 7-5 7-5
				Fabrice Santoro
26.			Agustin Calleri	2-6 7-6(4) 6-4 4-6 6-3
					Adrian Voinea
27.			Adrian Voinea		6-2 6-4 3-6 6-3
				Adrian Voinea
28.			Nicolas Coutelot	7-6(4) 6-1 6-3
						Jan Vacek
29.			Jan Vacek			6-1 4-6 6-3 6-4
				Jan Vacek
30.			Jerome Golmard	6-2 7-6(6) 3-2 rtd.
					Jan Vacek
31.		[Q]	Mario Ancic		6-4 6-4 7-5
				Mario Ancic
32.		[7]	Roger Federer	6-3 7-6(2) 6-3
									Lleyton Hewitt
33.		[4]	Tim Henman						7-5 6-1 7-5
				Tim Henman
34.		[Q]	Jean-Francois Bachelot	6-1 6-3 6-2
					Tim Henman
35.		[Q]	Scott Draper		3-6 6-3 6-4 6-3
				Scott Draper
36.		[Q]	Cristiano Caratti	6-3 4-6 6-4 7-5
						Tim Henman
37.			Wayne Ferreira			7-6(6) 3-6 7-6(8) 6-1
				Wayne Ferreira
38.			Albert Portas	7-6(5) 6-3 6-7(4) 6-3
					Wayne Ferreira
39.		[30]	Ivan Ljubicic		6-4 6-4 3-6 4-6 6-3
				Ivan Ljubicic
40.			Ramon Delgado	6-2 6-4 7-5
							Tim Henman
41.			Raemon Sluiter				7-6(5) 6-7(2) 4-6 6-3 6-2
				Raemon Sluiter
42.		[20]	Tommy Robredo	6-1 6-4 6-4
					Radek Stepanek
43.		[Q]	Radek Stepanek		6-3 6-7(5) 6-3 6-3
				Radek Stepanek
44.		[Q]	Cyril Saulnier	7-5 6-2 7-6(5)
						Michel Kratochvil
45.			Michel Kratochvil			6-2 6-3 6-3
				Michel Kratochvil
46.			Nikolay Davydenko	6-4 6-2 6-4
					Michel Kratochvil
47.			Irakli Labadze		3-6 6-0 7-6(4) 7-6(5)
				Irakli Labadze
48.		[13]	Younes El Aynaoui	4-6 7-6(4) 6-3 7-6(2)
								Tim Henman
49.		[10]	Guillermo Canas					6-3 5-7 6-4 6-3
				Guillermo Canas
50.			Michael Kohlmann	7-5 6-4 6-4
					Feliciano Lopez
51.			Feliciano Lopez		4-6 2-6 7-6(7) 7-5 10-8
				Feliciano Lopez
52.		[Q]	Konstantinos Economidis	6-3 3-6 4-6 7-6(2) 11-9
						Feliciano Lopez
53.			Sargis Sargsian			3-6 7-6(7) 6-4 6-4
				Sargis Sargsian
54.			Fernando Vicente	4-6 7-6(3) 6-3 6-2
					Rainer Schuettler
55.		[17]	Rainer Schuettler		6-3 6-0 6-1
				Rainer Schuettler
56.			Hicham Arazi	7-6(3) 6-4 6-4
							Andre Sa
57.		[31]	Stefan Koubek				6-3 7-5 4-6 6-3
				Stefan Koubek
58.		[Q]	Justin Bower	6-3 3-6 6-2 4-6 6-3
					Andre Sa
59.			Andre Sa		3-6 7-6(3) 7-5 6-3
				Andre Sa
60.			Antony Dupuis	6-3 4-6 6-4 5-7 6-3
						Andre Sa
61.		[Q]	Alexander Waske			2-6 6-4 6-3 1-6 6-1
				Alexander Waske
62.			Andrea Gaudenzi	7-6(4) 7-6(3) 6-7(2) 6-1
					Flavio Saretta
63.			Flavio Saretta		6-7(4) 6-4 6-4 7-5
				Flavio Saretta
64.		[8]	Thomas Johansson	6-7(2) 6-4 7-6(4) 3-6 12-10
										Lleyton Hewitt
65.		[5]	Yevgeny Kafelnikov							6-1 6-3 6-2
				Yevgeny Kafelnikov
66.			Dominik Hrbaty	6-1 7-6(4) 7-6(7)
					Yevgeny Kafelnikov
67.		[Q]	Nicolas Thomann		7-6(8) 6-2 6-2
				Nicolas Thomann
68.			Markus Hipfl	6-1 7-6(3) 3-6 4-6 11-9
						Xavier Malisse
69.			Vince Spadea			7-6(4) 7-5 6-1
				Vince Spadea
70.			Magnus Larsson	3-6 7-6(4) 6-7(2) 6-4 6-1
					Xavier Malisse
71.		[27]	Xavier Malisse		7-5 6-2 6-2
				Xavier Malisse
72.			Galo Blanco	6-3 6-3 6-3
							Xavier Malisse
73.		[23]	Greg Rusedski				3-6 6-3 3-6 6-3 6-4
				Greg Rusedski
74.		[Q]	Jurgen Melzer	6-1 6-4 7-5
					Greg Rusedski
75.		[Q]	Hyung-Taik Lee		6-1 6-4 5-7 6-2
				Hyung-Taik Lee
76.			Andrei Stoliarov	6-3 6-2 4-6 4-6 6-2
						Greg Rusedski
77.			Alberto Martin			6-3 6-4 6-2
				Alberto Martin
78.			Stefano Galvani	6-4 7-6(3) 6-4
					Andy Roddick
79.		[11]	Andy Roddick		6-1 6-2 6-2
				Andy Roddick
80.			Bohdan Ulihrach	6-1 3-1 rtd.
								Xavier Malisse
81.		[14]	Thomas Enqvist					6-1 4-6 6-2 3-6 9-7
				Thomas Enqvist
82.		[WC]	Arvind Parmar	6-1 6-4 6-4
					Mark Philippoussis
83.		[WC]	Mark Philippoussis		7-5 6-3 6-4
				Mark Philippoussis
84.			Julien Boutter	6-3 3-6 6-1 6-2
						Mark Philippoussis
85.			Nicolas Kiefer			3-6 6-3 6-4 6-2
				Nicolas Kiefer
86.			Juan-Manuel Balcells	6-3 2-6 5-7 7-5 6-3
					Nicolas Kiefer
87.			Fernando Gonzalez		7-5 6-3 6-0
				Fernando Gonzalez
88.		[19]	Juan Ignacio Chela	6-3 3-6 1-6 7-5 6-3
							Richard Krajicek
89.		[29]	James Blake				6-7(2) 7-6(4) 6-7(1) 7-6(5) 6-4
				James Blake
90.			Mariano Zabaleta	6-2 6-2 rtd.
					Richard Krajicek
91.			Richard Krajicek		6-3 6-4 3-6 4-6 11-9
				Richard Krajicek
92.			Franco Squillari	6-2 7-5 7-6(5)
						Richard Krajicek
93.			Paradorn Srichaphan			7-6(5) 6-4 6-2
				Paradorn Srichaphan
94.		[Q]	Jack Brasington	6-4 6-3 3-6 5-7 6-4
					Paradorn Srichaphan
95.		[3]	Andre Agassi		6-4 7-6(5) 6-2
				Andre Agassi
96.			Harel Levy	6-0 6-4 6-4
									David Nalbandian
97.		[6]	Pete Sampras						7-6(2) 6-4 1-6 2-6 6-2
				Pete Sampras
98.			Martin Lee	6-3 7-6(1) 6-3
					George Bastl
99.		[LL]	George Bastl		6-3 6-2 4-6 3-6 6-4
				George Bastl
100.		[LL]	Denis Golovanov	6-4 6-2 7-6(5)
						David Nalbandian
101.		[WC]	Paul-Henri Mathieu			6-2 6-2 6-2
				Paul-Henri Mathieu
102.			Francisco Clavet	6-4 7-5 6-3
					David Nalbandian
103.		[28]	David Nalbandian		7-6(3) 7-6(7) 6-3
				David Nalbandian
104.			David Sanchez-Munoz	6-4 6-3 4-6 7-5
							David Nalbandian
105.			Taylor Dent				6-4 7-6(4) 2-6 7-6(7)
				Taylor Dent
106.		[21]	Max Mirnyi	4-6 6-4 7-6(3) 6-4
					Taylor Dent
107.			Jan-Michael Gambill		6-4 7-5 7-6(4)
				Jan-Michael Gambill
108.			Nicolas Massu	6-3 7-6(9) 6-3
						Wayne Arthurs
109.			Wayne Arthurs			7-6(2) 7-6(3) 6-7(4) 7-6(5)
				Wayne Arthurs
110.			Michael Russell	6-4 6-4 6-3
					Wayne Arthurs
111.		[12]	Jiri Novak		6-3 7-6(9) 6-3
				Jiri Novak
112.			Fernando Meligeni	2-6 6-0 6-4 6-4
								David Nalbandian
113.		[15]	Andrei Pavel					6-4 6-4 4-6 4-6 6-4
				Andrei Pavel
114.			Kenneth Carlsen	6-4 6-1 3-6 6-3
					Andrei Pavel
115.		[Q]	Karol Beck		3-6 6-1 7-6(2) 6-4
				Karol Beck
116.			Alexandre Simoni	6-7(3) 4-6 7-6(5) 6-2 6-2
						Nicolas Lapentti
117.		[WC]	Barry Cowan			3-6 3-6 7-6(2) 6-4 6-2
				Barry Cowan
118.			Attila Savolt	6-7(3) 6-3 6-3 6-3
					Nicolas Lapentti
119.		[22]	Nicolas Lapentti		4-6 6-4 6-3 6-2
				Nicolas Lapentti
120.		[WC]	Jamie Delgado	6-3 6-2 6-7(6) 4-6 7-5
							Nicolas Lapentti
121.		[26]	Todd Martin				3-6 7-5 2-6 7-5 6-3
				Todd Martin
122.			Davide Sanguinetti	6-3 6-4 7-6(1)
					Arnaud Clement
123.			Arnaud Clement		6-3 6-4 7-6(2)
				Arnaud Clement
124.			Albert Montanes	6-3 6-4 6-0
						Arnaud Clement
125.			Olivier Rochus			6-0 7-5 6-3
				Olivier Rochus
126.			Christophe Rochus	6-2 3-6 7-6(6) 6-0
					Olivier Rochus
127.		[2]	Marat Safin		6-2 6-4 3-6 7-6(1)
				Marat Safin
128.			Cedric Pioline	7-6(7) 6-2 6-3

(default) 17 queries took 41 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `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 1	1	1	4
2	SELECT `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)	5	5	2
3	SELECT `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)	4	4	2
4	SELECT `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)	57	57	3
5	SELECT `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 1	1	1	3
6	SELECT `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` ASC	137	137	9
7	SELECT `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` = '2002' LIMIT 1	1	1	1
8	SELECT `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` = (524) ORDER BY `Match`.`round_id` ASC, `Match`.`no` ASC	127	127	2
9	SELECT `Player`.`id`, `Player`.`name`, `Player`.`gender`, `Player`.`slug` FROM `zavoihu1_db4tennis`.`players` AS `Player` WHERE `Player`.`id` IN (65, 5726, 7155, 6249, 7217, 88, 166, 7753, 6284, 8684, 72, 7246, 4143, 7298, 6234, 7764, 93, 6206, 7234, 6271, 4045, 6165, 6188, 7277, 4129, 7314, 6163, 8665, 7470, 6173, 7255, 147, 6197, 7145, 6157, 4146, 4162, 6231, 172, 6253, 6270, 5051, 59, 7200, 7332, 169, 7340, 5720, 6254, 6252, 171, 7839, 6213, 6259, 4209, 6208, 6250, 6243, 7169, 6293, 7261, 5710, 7250, 5723, 5702, 6230, 7346, 6261, 6169, 4186, 86, 6212, 5705, 140, 7266, 7328, 6223, 8723, 67, 6195, 5671, 6288, 5713, 6275, 6175, 7203, 7327, 76, 3578, 6262, 4176, 6233, 6276, 7338, 4001, 7258, 4095, 7343, 6283, 8597, 3590, 4155, 167, 7329, 7348, 6295, 6226, 7292, 6255, 77, 6187, 4188, 6220, 5679, 103, 7341, 7727, 7339, 6181, 6274, 4142, 6222, 5932, 120, 150, 6290, 6260, 4163) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	128	128	2
10	SELECT `Playercontest`.`id`, `Playercontest`.`player_id`, `Playercontest`.`contest_id`, `Playercontest`.`nat_id`, `Playercontest`.`draw` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE `Playercontest`.`contest_id` = 524	128	128	5
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (53, 13, 197, 154, 10, 21, 68, 173, 168, 14, 179, 67, 27, 92, 172, 133, 178, 29, 72, 54, 196, 127, 153, 58, 11, 146, 91, 184, 20, 50, 100, 41, 84, 71, 74)	35	35	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (53, 13, 197, 154, 10, 21, 68, 173, 168, 14, 179, 67, 27, 92, 172, 133, 178, 29, 72, 54, 196, 127, 153, 58, 11, 146, 91, 184, 20, 50, 100, 41, 84, 71, 74)	35	35	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (65, 5726, 7155, 6249, 7217, 88, 166, 7753, 6284, 8684, 72, 7246, 4143, 7298, 6234, 7764, 93, 6206, 7234, 6271, 4045, 6165, 6188, 7277, 4129, 7314, 6163, 8665, 7470, 6173, 7255, 147, 6197, 7145, 6157, 4146, 4162, 6231, 172, 6253, 6270, 5051, 59, 7200, 7332, 169, 7340, 5720, 6254, 6252, 171, 7839, 6213, 6259, 4209, 6208, 6250, 6243, 7169, 6293, 7261, 5710, 7250, 5723, 5702, 6230, 7346, 6261, 6169, 4186, 86, 6212, 5705, 140, 7266, 7328, 6223, 8723, 67, 6195, 5671, 6288, 5713, 6275, 6175, 7203, 7327, 76, 3578, 6262, 4176, 6233, 6276, 7338, 4001, 7258, 4095, 7343, 6283, 8597, 3590, 4155, 167, 7329, 7348, 6295, 6226, 7292, 6255, 77, 6187, 4188, 6220, 5679, 103, 7341, 7727, 7339, 6181, 6274, 4142, 6222, 5932, 120, 150, 6290, 6260, 4163)) AND (`Playercontest`.`contest_id` = 524))	128	128	2
14	SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 17 ORDER BY `Contest`.`date_from` ASC	137	137	1
15	SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 2002	20	20	1
16	SELECT `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'	4	4	1
17	SELECT `Tournament`.`slug`, `Tournament`.`name` FROM `zavoihu1_db4tennis`.`tournaments` AS `Tournament` WHERE `Tournament`.`id` IN (1, 2, 3, 4)	4	4	1

(default) 17 queries took 41 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `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 1

SELECT `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)

SELECT `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)

SELECT `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 1

137

SELECT `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` = '2002' LIMIT 1

SELECT `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` = (524) ORDER BY `Match`.`round_id` ASC, `Match`.`no` ASC

127

SELECT `Player`.`id`, `Player`.`name`, `Player`.`gender`, `Player`.`slug` FROM `zavoihu1_db4tennis`.`players` AS `Player` WHERE `Player`.`id` IN (65, 5726, 7155, 6249, 7217, 88, 166, 7753, 6284, 8684, 72, 7246, 4143, 7298, 6234, 7764, 93, 6206, 7234, 6271, 4045, 6165, 6188, 7277, 4129, 7314, 6163, 8665, 7470, 6173, 7255, 147, 6197, 7145, 6157, 4146, 4162, 6231, 172, 6253, 6270, 5051, 59, 7200, 7332, 169, 7340, 5720, 6254, 6252, 171, 7839, 6213, 6259, 4209, 6208, 6250, 6243, 7169, 6293, 7261, 5710, 7250, 5723, 5702, 6230, 7346, 6261, 6169, 4186, 86, 6212, 5705, 140, 7266, 7328, 6223, 8723, 67, 6195, 5671, 6288, 5713, 6275, 6175, 7203, 7327, 76, 3578, 6262, 4176, 6233, 6276, 7338, 4001, 7258, 4095, 7343, 6283, 8597, 3590, 4155, 167, 7329, 7348, 6295, 6226, 7292, 6255, 77, 6187, 4188, 6220, 5679, 103, 7341, 7727, 7339, 6181, 6274, 4142, 6222, 5932, 120, 150, 6290, 6260, 4163) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC

128

SELECT `Playercontest`.`id`, `Playercontest`.`player_id`, `Playercontest`.`contest_id`, `Playercontest`.`nat_id`, `Playercontest`.`draw` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE `Playercontest`.`contest_id` = 524

128

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (53, 13, 197, 154, 10, 21, 68, 173, 168, 14, 179, 67, 27, 92, 172, 133, 178, 29, 72, 54, 196, 127, 153, 58, 11, 146, 91, 184, 20, 50, 100, 41, 84, 71, 74)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (53, 13, 197, 154, 10, 21, 68, 173, 168, 14, 179, 67, 27, 92, 172, 133, 178, 29, 72, 54, 196, 127, 153, 58, 11, 146, 91, 184, 20, 50, 100, 41, 84, 71, 74)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (65, 5726, 7155, 6249, 7217, 88, 166, 7753, 6284, 8684, 72, 7246, 4143, 7298, 6234, 7764, 93, 6206, 7234, 6271, 4045, 6165, 6188, 7277, 4129, 7314, 6163, 8665, 7470, 6173, 7255, 147, 6197, 7145, 6157, 4146, 4162, 6231, 172, 6253, 6270, 5051, 59, 7200, 7332, 169, 7340, 5720, 6254, 6252, 171, 7839, 6213, 6259, 4209, 6208, 6250, 6243, 7169, 6293, 7261, 5710, 7250, 5723, 5702, 6230, 7346, 6261, 6169, 4186, 86, 6212, 5705, 140, 7266, 7328, 6223, 8723, 67, 6195, 5671, 6288, 5713, 6275, 6175, 7203, 7327, 76, 3578, 6262, 4176, 6233, 6276, 7338, 4001, 7258, 4095, 7343, 6283, 8597, 3590, 4155, 167, 7329, 7348, 6295, 6226, 7292, 6255, 77, 6187, 4188, 6220, 5679, 103, 7341, 7727, 7339, 6181, 6274, 4142, 6222, 5932, 120, 150, 6290, 6260, 4163)) AND (`Playercontest`.`contest_id` = 524))

128

SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 17 ORDER BY `Contest`.`date_from` ASC

137

SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 2002

SELECT `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'

SELECT `Tournament`.`slug`, `Tournament`.`name` FROM `zavoihu1_db4tennis`.`tournaments` AS `Tournament` WHERE `Tournament`.`id` IN (1, 2, 3, 4)