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

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Novak Djokovic
				Novak Djokovic
2.			Juan Carlos Ferrero	6-3 6-3 6-1
					Novak Djokovic
3.			Ryan Harrison		6-4 6-4 6-4
				Ryan Harrison
4.			Yen-Hsun Lu	4-6 6-3 6-4 6-2
						Novak Djokovic
5.			Benjamin Becker			4-6 6-2 6-2 6-2
				Benjamin Becker
6.			James Blake	6-7(4) 7-5 6-0 6-4
					Radek Stepanek
7.		[28]	Radek Stepanek		6-2 7-6(4) 6-3
				Radek Stepanek
8.			Sergiy Stakhovsky	6-1 1-0 rtd.
							Novak Djokovic
9.			Viktor Troicki				6-3 6-1 6-3
				Viktor Troicki
10.		[24]	Marcel Granollers	7-5 7-6(5) 3-6 2-6 8-6
					Viktor Troicki
11.			Martin Klizan		6-4 4-6 5-7 7-6(3) 6-4
				Martin Klizan
12.			Juan Ignacio Chela	7-5 3-6 7-6(6) 1-6 11-9
						Viktor Troicki
13.			Jeremy Chardy			7-5 7-5 6-3
				Jeremy Chardy
14.			Filippo Volandri	6-0 6-1 1-0 rtd.
					Juan Monaco
15.		[15]	Juan Monaco		6-2 3-6 6-3 7-6(3)
				Juan Monaco
16.			Leonardo Mayer	6-4 7-6(5) 7-6(5)
								Novak Djokovic
17.		[12]	Nicolas Almagro					6-4 6-1 6-4
				Nicolas Almagro
18.			Olivier Rochus	6-7(4) 3-6 7-6(4) 6-2 6-4
					Nicolas Almagro
19.		[Q]	Guillaume Rufin		6-2 5-7 6-2 6-4
				Guillaume Rufin
20.			Steve Darcis	6-4 3-6 5-7 6-4 6-4
						Richard Gasquet
21.		[Q]	Ruben Bemelmans			6-3 6-4 6-4
				Ruben Bemelmans
22.			Carlos Berlocq	7-5 6-7(4) 6-3 7-6(2)
					Richard Gasquet
23.		[18]	Richard Gasquet		6-3 6-4 6-4
				Richard Gasquet
24.			Tobias Kamke	6-2 6-2 6-2
							Florian Mayer
25.		[31]	Florian Mayer				6-3 6-1 3-6 6-2
				Florian Mayer
26.			Dmitry Tursunov	7-6(3) 6-2 6-3
					Florian Mayer
27.			Philipp Petzschner		3-6 3-6 6-4 6-2 6-4
				Philipp Petzschner
28.			Blaz Kavcic	6-4 6-4 6-2
						Florian Mayer
29.		[Q]	Jerzy Janowicz			7-6(5) 3-6 2-6 6-3 7-5
				Jerzy Janowicz
30.		[Q]	Simone Bolelli	3-6 6-3 6-3 6-3
					Jerzy Janowicz
31.			Ernests Gulbis		2-6 6-4 3-6 7-6(2) 9-7
				Ernests Gulbis
32.		[6]	Tomas Berdych	7-6(5) 7-6(4) 7-6(4)
									Roger Federer
33.		[3]	Roger Federer						6-3 3-6 6-4 6-3
				Roger Federer
34.			Albert Ramos-Vinolas	6-1 6-1 6-1
					Roger Federer
35.			Fabio Fognini		6-1 6-3 6-2
				Fabio Fognini
36.			Michael Llodra	3-6 6-3 6-4 7-5
						Roger Federer
37.		[Q]	Michael Russell			4-6 6-7(3) 6-2 7-6(6) 6-1
				Michael Russell
38.		[Q]	Adrian Menendez	6-3 6-1 7-6(7)
					Julien Benneteau
39.		[29]	Julien Benneteau		7-6(4) 2-6 6-4 7-5
				Julien Benneteau
40.			Gilles Muller	6-2 7-5 7-6(4)
							Roger Federer
41.		[17]	Fernando Verdasco				7-6(1) 6-1 4-6 6-3
				Fernando Verdasco
42.		[Q]	Jimmy Wang	7-6(3) 6-4 7-5
					Fernando Verdasco
43.		[WC]	Grega Zemlja		7-6(4) 7-6(4) 3-6 6-3
				Grega Zemlja
44.		[WC]	Josh Goodall	6-4 3-6 7-6(3) 6-4
						Xavier Malisse
45.			Xavier Malisse			1-6 7-6(5) 6-1 4-6 6-3
				Xavier Malisse
46.			Marinko Matosevic	6-2 6-2 7-5
					Xavier Malisse
47.		[13]	Gilles Simon		6-4 6-4 7-6(5)
				Gilles Simon
48.			Paul-Henri Mathieu	6-3 5-4 rtd.
								Roger Federer
49.			Alejandro Falla					6-1 6-2 6-2
				Alejandro Falla
50.		[11]	John Isner	6-4 6-7(7) 3-6 7-6(7) 7-5
					Alejandro Falla
51.			Nicolas Mahut		6-4 6-3 4-6 4-6 7-5
				Nicolas Mahut
52.			Paolo Lorenzi	6-3 5-7 6-7(3) 7-5 6-2
						Denis Istomin
53.			Igor Andreev			6-3 6-4 3-6 7-6(5)
				Igor Andreev
54.		[WC]	Oliver Golding	1-6 7-6(4) 7-6(7) 7-5
					Denis Istomin
55.			Denis Istomin		6-3 7-6(3) 4-6 6-2
				Denis Istomin
56.		[23]	Andreas Seppi	6-7(2) 6-4 3-6 6-3 8-6
							Mikhail Youzhny
57.		[26]	Mikhail Youzhny				6-3 5-7 6-4 6-7(5) 7-5
				Mikhail Youzhny
58.			Donald Young	4-6 6-3 6-2 6-3
					Mikhail Youzhny
59.		[Q]	Inigo Cervantes		6-1 6-3 6-4
				Inigo Cervantes
60.			Flavio Cipolla	2-6 6-7(4) 6-3 6-2 6-1
						Mikhail Youzhny
61.		[Q]	Ryan Sweeting			6-3 6-4 3-6 6-3
				Ryan Sweeting
62.			Potito Starace	6-2 2-0 rtd.
					Janko Tipsarevic
63.		[8]	Janko Tipsarevic		5-7 7-5 6-4 6-2
				Janko Tipsarevic
64.			David Nalbandian	6-4 7-6(4) 6-2
										Roger Federer
65.		[7]	David Ferrer							4-6 7-5 6-3 6-4
				David Ferrer
66.		[Q]	Dustin Brown	7-6(5) 6-4 6-4
					David Ferrer
67.		[Q]	Kenny De Schepper		7-6(1) 6-2 6-4
				Kenny De Schepper
68.			Matthias Bachinger	6-4 6-2 6-2
						David Ferrer
69.			Bjorn Phau			2-6 7-6(8) 6-4 6-3
				Bjorn Phau
70.		[LL]	Wayne Odesnik	6-3 3-6 6-7(3) 6-3 6-4
					Andy Roddick
71.		[30]	Andy Roddick		6-3 7-6(1) 6-3
				Andy Roddick
72.		[WC]	Jamie Baker	7-6(1) 6-4 7-5
							David Ferrer
73.		[19]	Kei Nishikori				6-3 6-2 6-3
				Kei Nishikori
74.			Mikhail Kukushkin	7-5 6-3 6-4
					Kei Nishikori
75.		[Q]	Florent Serra		6-3 7-5 6-2
				Florent Serra
76.		[Q]	Andrey Kuznetsov	3-6 7-6(3) 6-4 4-6 6-4
						Juan Martin Del Potro
77.			Go Soeda			6-3 7-6(3) 6-1
				Go Soeda
78.			Igor Kunitsyn	6-3 6-2 6-1
					Juan Martin Del Potro
79.		[9]	Juan Martin Del Potro		6-2 6-3 1-6 6-4
				Juan Martin Del Potro
80.			Robin Haase	6-4 3-6 7-6(3) 7-5
								Andy Murray
81.		[16]	Marin Cilic					6-7(5) 7-6(6) 6-4 7-6(4)
				Marin Cilic
82.			Cedrik-Marcel Stebe	6-4 3-6 6-3 6-2
					Marin Cilic
83.			Lukasz Kubot		7-6(4) 6-2 6-1
				Lukasz Kubot
84.			Tatsuma Ito	7-6(6) 6-3 6-3
						Marin Cilic
85.			Sam Querrey			7-6(6) 6-4 6-7(2) 6-7(3) 17-15
				Sam Querrey
86.			Vasek Pospisil	7-5 6-7(5) 6-3 6-4
					Sam Querrey
87.		[21]	Milos Raonic		6-7(3) 7-6(7) 7-6(8) 6-4
				Milos Raonic
88.			Santiago Giraldo	6-4 6-4 6-4
							Andy Murray
89.			Grigor Dimitrov				7-5 6-2 6-3
				Grigor Dimitrov
90.		[32]	Kevin Anderson	7-5 7-6(3) 6-7(4) 6-3
					Marcos Baghdatis
91.			Marcos Baghdatis		7-5 4-1 rtd.
				Marcos Baghdatis
92.			Albert Montanes	6-2 6-4 6-4
						Andy Murray
93.			Ivo Karlovic			7-5 3-6 7-5 6-1
				Ivo Karlovic
94.			Dudi Sela	6-4 6-4 7-6(5)
					Andy Murray
95.		[4]	Andy Murray		7-5 6-7(5) 6-2 7-6(4)
				Andy Murray
96.			Nikolay Davydenko	6-1 6-1 6-4
									Andy Murray
97.		[5]	Jo-Wilfried Tsonga						6-3 6-4 3-6 7-5
				Jo-Wilfried Tsonga
98.		[WC]	Lleyton Hewitt	6-3 6-4 6-4
					Jo-Wilfried Tsonga
99.			Guillermo Garcia-Lopez		6-7(3) 6-4 6-1 6-3
				Guillermo Garcia-Lopez
100.			Edouard Roger-Vasselin	6-7(2) 6-3 7-6(4) 5-7 10-8
						Jo-Wilfried Tsonga
101.			Lukas Lacko			6-4 6-3 6-3
				Lukas Lacko
102.			Adrian Ungur	7-6(4) 6-1 6-3
					Lukas Lacko
103.			Jurgen Melzer		6-4 6-7(4) 3-6 6-3 6-4
				Jurgen Melzer
104.		[25]	Stan Wawrinka	3-6 7-6(2) 2-6 6-4 8-6
							Jo-Wilfried Tsonga
105.		[WC]	David Goffin				4-6 7-6(4) 6-4 6-4
				David Goffin
106.		[20]	Bernard Tomic	3-6 6-3 6-4 6-4
					David Goffin
107.		[Q]	Jesse Levine		4-6 6-4 6-1 6-3
				Jesse Levine
108.			Karol Beck	6-4 6-7(6) 6-3 6-2
						Mardy Fish
109.		[WC]	James Ward			6-3 7-6(6) 7-6(6)
				James Ward
110.			Pablo Andujar	4-6 6-0 3-6 6-3 6-3
					Mardy Fish
111.		[10]	Mardy Fish		6-3 5-7 6-4 6-7(3) 6-3
				Mardy Fish
112.			Ruben Ramirez Hidalgo	7-6(3) 7-5 7-6(1)
								Jo-Wilfried Tsonga
113.			Jarkko Nieminen					7-6(5) 4-6 7-6(3) 6-2
				Jarkko Nieminen
114.		[14]	Feliciano Lopez	7-6(4) 3-6 7-6(5) 6-4
					Brian Baker
115.		[Q]	Brian Baker		6-0 6-2 6-4
				Brian Baker
116.			Rui Machado	7-6(2) 6-4 6-0
						Brian Baker
117.			Benoit Paire			6-4 4-6 6-1 6-3
				Benoit Paire
118.			Matthew Ebden	6-1 6-3 6-7(1) 6-3
					Benoit Paire
119.		[22]	Alexandr Dolgopolov		7-6(2) 6-4 6-4
				Alexandr Dolgopolov
120.			Aleksandr Bogomolov Jr.	6-3 6-4 7-5
							Philipp Kohlschreiber
121.		[27]	Philipp Kohlschreiber				6-1 7-6(4) 6-3
				Philipp Kohlschreiber
122.		[WC]	Tommy Haas	3-6 7-6(8) 6-7(5) 7-6(1) 6-2
					Philipp Kohlschreiber
123.			Malek Jaziri		6-1 7-6(2) 6-1
				Malek Jaziri
124.		[Q]	Jurgen Zopp	4-6 4-6 6-3 6-4 9-7
						Philipp Kohlschreiber
125.			Lukas Rosol			6-2 6-3 7-6(6)
				Lukas Rosol
126.			Ivan Dodig	6-4 3-6 7-6(0) 7-5
					Lukas Rosol
127.		[2]	Rafael Nadal		6-7(9) 6-4 6-4 2-6 6-4
				Rafael Nadal
128.			Thomaz Bellucci	7-6(0) 6-2 6-3

(default) 17 queries took 29 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	1
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	1
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	1
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	1
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	1
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	4
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` = '2012' LIMIT 1	1	1	2
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` = (1012) 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 (52, 93, 85, 125, 159, 3578, 59, 152, 92, 108, 3580, 76, 160, 61, 123, 170, 163, 150, 3581, 127, 3582, 142, 75, 134, 3583, 69, 63, 129, 3584, 3585, 89, 148, 147, 149, 119, 88, 77, 3586, 102, 117, 139, 3587, 3588, 3589, 86, 98, 100, 3590, 118, 164, 58, 53, 3591, 3592, 114, 74, 72, 175, 3593, 168, 81, 57, 68, 167, 83, 3717, 136, 80, 151, 3718, 67, 3719, 107, 95, 126, 3720, 3721, 78, 131, 66, 3722, 64, 162, 56, 137, 3723, 60, 54, 161, 155, 158, 120, 141, 97, 84, 169, 115, 65, 94, 87, 173, 3724, 140, 156, 3725, 138, 109, 103, 128, 79, 116, 3726, 166, 171, 3727, 82, 157, 105, 132, 91, 122, 176, 3728, 70, 62, 111, 179, 96) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	128	128	3
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` = 1012	128	128	3
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (164, 92, 43, 94, 68, 53, 36, 72, 13, 133, 197, 154, 63, 10, 173, 150, 196, 21, 104, 96, 29, 91, 168, 50, 199, 111, 181, 169, 194, 14, 179, 172, 52, 31, 149, 67, 153, 189)	38	38	2
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (164, 92, 43, 94, 68, 53, 36, 72, 13, 133, 197, 154, 63, 10, 173, 150, 196, 21, 104, 96, 29, 91, 168, 50, 199, 111, 181, 169, 194, 14, 179, 172, 52, 31, 149, 67, 153, 189)	38	38	2
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (52, 93, 85, 125, 159, 3578, 59, 152, 92, 108, 3580, 76, 160, 61, 123, 170, 163, 150, 3581, 127, 3582, 142, 75, 134, 3583, 69, 63, 129, 3584, 3585, 89, 148, 147, 149, 119, 88, 77, 3586, 102, 117, 139, 3587, 3588, 3589, 86, 98, 100, 3590, 118, 164, 58, 53, 3591, 3592, 114, 74, 72, 175, 3593, 168, 81, 57, 68, 167, 83, 3717, 136, 80, 151, 3718, 67, 3719, 107, 95, 126, 3720, 3721, 78, 131, 66, 3722, 64, 162, 56, 137, 3723, 60, 54, 161, 155, 158, 120, 141, 97, 84, 169, 115, 65, 94, 87, 173, 3724, 140, 156, 3725, 138, 109, 103, 128, 79, 116, 3726, 166, 171, 3727, 82, 157, 105, 132, 91, 122, 176, 3728, 70, 62, 111, 179, 96)) AND (`Playercontest`.`contest_id` = 1012))	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` = 2012	17	17	1
16	SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (1, 22, 17, 12, 3, 2, 4, 7, 23, 13, 18, 14, 24, 25, 26, 19, 15) 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 29 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` = '2012' 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` = (1012) 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 (52, 93, 85, 125, 159, 3578, 59, 152, 92, 108, 3580, 76, 160, 61, 123, 170, 163, 150, 3581, 127, 3582, 142, 75, 134, 3583, 69, 63, 129, 3584, 3585, 89, 148, 147, 149, 119, 88, 77, 3586, 102, 117, 139, 3587, 3588, 3589, 86, 98, 100, 3590, 118, 164, 58, 53, 3591, 3592, 114, 74, 72, 175, 3593, 168, 81, 57, 68, 167, 83, 3717, 136, 80, 151, 3718, 67, 3719, 107, 95, 126, 3720, 3721, 78, 131, 66, 3722, 64, 162, 56, 137, 3723, 60, 54, 161, 155, 158, 120, 141, 97, 84, 169, 115, 65, 94, 87, 173, 3724, 140, 156, 3725, 138, 109, 103, 128, 79, 116, 3726, 166, 171, 3727, 82, 157, 105, 132, 91, 122, 176, 3728, 70, 62, 111, 179, 96) 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` = 1012

128

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (164, 92, 43, 94, 68, 53, 36, 72, 13, 133, 197, 154, 63, 10, 173, 150, 196, 21, 104, 96, 29, 91, 168, 50, 199, 111, 181, 169, 194, 14, 179, 172, 52, 31, 149, 67, 153, 189)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (164, 92, 43, 94, 68, 53, 36, 72, 13, 133, 197, 154, 63, 10, 173, 150, 196, 21, 104, 96, 29, 91, 168, 50, 199, 111, 181, 169, 194, 14, 179, 172, 52, 31, 149, 67, 153, 189)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (52, 93, 85, 125, 159, 3578, 59, 152, 92, 108, 3580, 76, 160, 61, 123, 170, 163, 150, 3581, 127, 3582, 142, 75, 134, 3583, 69, 63, 129, 3584, 3585, 89, 148, 147, 149, 119, 88, 77, 3586, 102, 117, 139, 3587, 3588, 3589, 86, 98, 100, 3590, 118, 164, 58, 53, 3591, 3592, 114, 74, 72, 175, 3593, 168, 81, 57, 68, 167, 83, 3717, 136, 80, 151, 3718, 67, 3719, 107, 95, 126, 3720, 3721, 78, 131, 66, 3722, 64, 162, 56, 137, 3723, 60, 54, 161, 155, 158, 120, 141, 97, 84, 169, 115, 65, 94, 87, 173, 3724, 140, 156, 3725, 138, 109, 103, 128, 79, 116, 3726, 166, 171, 3727, 82, 157, 105, 132, 91, 122, 176, 3728, 70, 62, 111, 179, 96)) AND (`Playercontest`.`contest_id` = 1012))

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` = 2012

SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (1, 22, 17, 12, 3, 2, 4, 7, 23, 13, 18, 14, 24, 25, 26, 19, 15) 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)