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

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Novak Djokovic
				Novak Djokovic
2.			Florian Mayer	6-3 7-5 6-4
					Novak Djokovic
3.		[Q]	Bobby Reynolds		7-6(2) 6-3 6-1
				Bobby Reynolds
4.		[WC]	Steve Johnson	1-6 7-6(4) 6-3 6-7(4) 6-4
						Novak Djokovic
5.		[Q]	Jan-Lennard Struff			6-3 6-2 6-2
				Jan-Lennard Struff
6.			Blaz Kavcic	6-4 6-1 6-3
					Jeremy Chardy
7.		[28]	Jeremy Chardy		6-2 5-7 7-6(6) 7-6(7)
				Jeremy Chardy
8.			Ryan Harrison	7-6(4) 4-6 7-5 6-2
							Novak Djokovic
9.			Feliciano Lopez				6-1 6-4 7-6(4)
				Feliciano Lopez
10.		[19]	Gilles Simon	6-2 6-4 7-6(11)
					Feliciano Lopez
11.			Paul-Henri Mathieu		6-3 5-1 rtd.
				Paul-Henri Mathieu
12.			Ricardas Berankis	7-6(4) 7-5 6-7(3) 6-4
						Tommy Haas
13.		[Q]	Jimmy Wang			4-6 6-2 7-5 6-4
				Jimmy Wang
14.		[Q]	Wayne Odesnik	7-6(5) 4-6 6-2 3-6 7-5
					Tommy Haas
15.		[13]	Tommy Haas		6-3 6-2 7-5
				Tommy Haas
16.			Dmitry Tursunov	6-3 7-5 7-5
								Novak Djokovic
17.		[9]	Richard Gasquet					7-6(5) 6-4 6-3
				Richard Gasquet
18.			Marcel Granollers	6-7(2) 6-4 7-5 6-4
					Richard Gasquet
19.		[Q]	Go Soeda		6-0 6-3 6-7(5) 6-3
				Go Soeda
20.			Andreas Haider-Maurer	7-6(6) 7-5 6-1
						Bernard Tomic
21.			James Blake			7-6(7) 5-7 7-5 7-6(5)
				James Blake
22.			Thiemo De Bakker	6-1 6-3 6-2
					Bernard Tomic
23.			Bernard Tomic		6-3 6-4 7-5
				Bernard Tomic
24.		[21]	Sam Querrey	7-6(6) 7-6(3) 3-6 2-6 6-3
							Tomas Berdych
25.		[27]	Kevin Anderson				7-6(4) 6-7(5) 6-4 6-4
				Kevin Anderson
26.		[LL]	Olivier Rochus	6-4 6-2 6-1
					Kevin Anderson
27.		[Q]	Michal Przysiezny		6-4 7-6(2) 6-4
				Michal Przysiezny
28.			Philipp Petzschner	6-3 7-6(6) 6-0
						Tomas Berdych
29.			Daniel Brands			3-6 6-3 6-4 7-5
				Daniel Brands
30.			Daniel Gimeno-Traver	7-6(5) 6-7(4) 6-7(5) 6-1 6-4
					Tomas Berdych
31.		[7]	Tomas Berdych		7-6(6) 6-4 6-2
				Tomas Berdych
32.			Martin Klizan	6-3 6-4 6-4
									Novak Djokovic
33.		[4]	David Ferrer						7-5 4-6 7-6(2) 6-7(6) 6-3
				David Ferrer
34.			Martin Alund	6-1 4-6 7-5 6-2
					David Ferrer
35.			Roberto Bautista Agut		6-3 3-6 7-6(4) 7-5
				Roberto Bautista Agut
36.		[Q]	Teymuraz Gabashvili	6-3 6-4 7-6(3)
						David Ferrer
37.			Santiago Giraldo			6-7(6) 7-6(2) 2-6 6-1 6-2
				Santiago Giraldo
38.			Horacio Zeballos Jr.	3-6 7-6(4) 6-7(6) 6-1 6-3
					Alexandr Dolgopolov
39.		[26]	Alexandr Dolgopolov		6-4 7-5 6-3
				Alexandr Dolgopolov
40.			Gastao Elias	6-1 7-6(2) 6-2
							David Ferrer
41.		[17]	Milos Raonic				6-7(3) 7-6(6) 6-1 6-1
				Milos Raonic
42.			Carlos Berlocq	6-4 6-3 6-3
					Igor Sijsling
43.			Igor Sijsling		7-5 6-4 7-6(4)
				Igor Sijsling
44.		[Q]	Alex Kuznetsov	6-3 6-4 6-4
						Ivan Dodig
45.		[Q]	Denis Kudla			6-0 6-1 1-0 rtd.
				Denis Kudla
46.		[Q]	James Duckworth	6-4 6-2 3-6 4-6 6-1
					Ivan Dodig
47.			Ivan Dodig		6-1 7-6(4) 7-5
				Ivan Dodig
48.		[16]	Philipp Kohlschreiber	4-6 6-7(6) 7-6(3) 6-3 2-1 rtd.
								Juan Martin Del Potro
49.		[12]	Kei Nishikori					6-2 6-4 7-6(5)
				Kei Nishikori
50.		[WC]	Matthew Ebden	6-2 6-4 6-3
					Kei Nishikori
51.			Leonardo Mayer		7-6(5) 6-4 6-2
				Leonardo Mayer
52.			Aljaz Bedene	6-2 6-3 6-4
						Andreas Seppi
53.			Michael Llodra			3-6 6-2 6-7(4) 6-1 6-4
				Michael Llodra
54.			Jarkko Nieminen	7-6(3) 6-4 6-3
					Andreas Seppi
55.		[23]	Andreas Seppi		7-5 0-0 rtd.
				Andreas Seppi
56.			Denis Istomin	7-6(6) 7-6(3) 5-7 3-6 6-3
							Juan Martin Del Potro
57.		[29]	Grigor Dimitrov				6-4 7-6(2) 6-3
				Grigor Dimitrov
58.			Simone Bolelli	6-1 6-4 6-3
					Grega Zemlja
59.			Grega Zemlja		3-6 7-6(4) 3-6 6-4 11-9
				Grega Zemlja
60.			Michael Russell	6-7(3) 6-4 6-4 6-1
						Juan Martin Del Potro
61.			Jesse Levine			7-5 7-6(3) 6-0
				Jesse Levine
62.			Guido Pella	6-4 6-2 4-6 3-6 4-3 rtd.
					Juan Martin Del Potro
63.		[8]	Juan Martin Del Potro		6-2 7-6(7) 6-3
				Juan Martin Del Potro
64.			Albert Ramos-Vinolas	6-2 7-5 6-1
										Andy Murray
65.			Steve Darcis							6-4 7-5 6-4
				Steve Darcis
66.		[5]	Rafael Nadal	7-6(4) 7-6(8) 6-4
					Lukasz Kubot
67.			Lukasz Kubot		w/o
				Lukasz Kubot
68.			Igor Andreev	6-1 7-5 6-2
						Lukasz Kubot
69.		[Q]	Stephane Robert			6-1 6-3 6-4
				Stephane Robert
70.			Alejandro Falla	6-3 7-6(5) 7-5
					Benoit Paire
71.		[25]	Benoit Paire		6-4 7-5 6-4
				Benoit Paire
72.			Adrian Ungur	6-4 4-6 6-3 6-1
							Lukasz Kubot
73.		[18]	John Isner				4-6 6-3 3-6 6-3 6-4
				John Isner
74.			Evgeny Donskoy	6-1 7-6(5) 7-6(3)
					Adrian Mannarino
75.			Adrian Mannarino		1-1 rtd.
				Adrian Mannarino
76.			Pablo Andujar	6-1 6-2 6-3
						Adrian Mannarino
77.		[Q]	Dustin Brown			6-4 6-2 7-5
				Dustin Brown
78.			Guillermo Garcia-Lopez	6-3 6-3 6-3
					Dustin Brown
79.			Lleyton Hewitt		6-4 6-4 6-7(3) 6-2
				Lleyton Hewitt
80.		[11]	Stan Wawrinka	6-4 7-5 6-3
								Jerzy Janowicz
81.		[15]	Nicolas Almagro					7-5 6-4 6-4
				Nicolas Almagro
82.			Jurgen Zopp	6-4 7-6(2) 7-5
					Nicolas Almagro
83.			Guillaume Rufin		7-5 6-7(6) 6-3 6-4
				Guillaume Rufin
84.			Marinko Matosevic	6-1 4-6 6-4 6-3
						Jerzy Janowicz
85.			Radek Stepanek			7-6(6) 6-3 6-4
				Radek Stepanek
86.		[Q]	Matt Reid	6-2 6-2 6-4
					Jerzy Janowicz
87.		[24]	Jerzy Janowicz		6-2 5-3 rtd.
				Jerzy Janowicz
88.		[WC]	Kyle Edmund	6-2 6-2 6-4
							Jerzy Janowicz
89.			Jurgen Melzer				3-6 7-6(1) 6-4 4-6 6-4
				Jurgen Melzer
90.		[30]	Fabio Fognini	6-7(5) 7-5 6-3 6-2
					Jurgen Melzer
91.		[Q]	Julian Reister		3-6 7-6(2) 7-6(5) 6-2
				Julian Reister
92.			Lukas Rosol	6-3 4-6 7-6(5) 6-7(4) 6-4
						Jurgen Melzer
93.			Sergiy Stakhovsky			6-2 2-6 7-5 6-3
				Sergiy Stakhovsky
94.			Rogerio Dutra Da Silva	6-4 6-0 6-4
					Sergiy Stakhovsky
95.		[3]	Roger Federer		6-7(5) 7-6(5) 7-5 7-6(5)
				Roger Federer
96.			Victor Hanescu	6-3 6-2 6-0
									Andy Murray
97.		[6]	Jo-Wilfried Tsonga						6-7(2) 6-4 6-4 6-3
				Jo-Wilfried Tsonga
98.			David Goffin	7-6(4) 6-4 6-3
					Ernests Gulbis
99.			Ernests Gulbis		3-6 6-3 6-3 0-0 rtd.
				Ernests Gulbis
100.			Edouard Roger-Vasselin	7-6(1) 6-4 7-5
						Fernando Verdasco
101.			Fernando Verdasco			6-2 6-4 6-4
				Fernando Verdasco
102.			Xavier Malisse	6-7(5) 6-1 6-4 6-3
					Fernando Verdasco
103.		[31]	Julien Benneteau		7-6(1) 7-6(4) 6-4
				Julien Benneteau
104.			Tobias Kamke	6-4 6-7(5) 6-4 6-2
							Fernando Verdasco
105.		[22]	Juan Monaco				6-4 6-4 6-4
				Juan Monaco
106.		[Q]	Bastian Knittel	6-4 6-2 6-3
					Juan Monaco
107.			Rajeev Ram		5-7 6-2 6-4 6-2
				Rajeev Ram
108.			Lukas Lacko	7-5 6-4 6-7(2) 6-2
						Kenny De Schepper
109.			Kenny De Schepper			6-4 7-6(8) 6-4
				Kenny De Schepper
110.			Paolo Lorenzi	7-6(6) 6-4 6-2
					Kenny De Schepper
111.		[10]	Marin Cilic		w/o
				Marin Cilic
112.			Marcos Baghdatis	6-3 6-4 6-4
								Andy Murray
113.			Viktor Troicki					4-6 3-6 6-1 6-4 7-5
				Viktor Troicki
114.		[14]	Janko Tipsarevic	6-3 6-4 7-6(5)
					Viktor Troicki
115.			Andrey Kuznetsov		6-4 6-3 6-4
				Andrey Kuznetsov
116.			Albert Montanes	6-3 6-4 3-6 6-3
						Mikhail Youzhny
117.			Vasek Pospisil			6-3 6-4 7-5
				Vasek Pospisil
118.		[Q]	Marc Gicquel	6-3 6-2 7-6(3)
					Mikhail Youzhny
119.		[20]	Mikhail Youzhny		6-2 6-7(3) 7-6(7) 3-6 6-4
				Mikhail Youzhny
120.			Robin Haase	6-4 7-5 7-5
							Andy Murray
121.		[32]	Tommy Robredo				6-4 7-6(5) 6-1
				Tommy Robredo
122.			Aleksandr Bogomolov Jr.	6-2 6-2 6-4
					Tommy Robredo
123.		[WC]	Nicolas Mahut		7-6(3) 6-1 7-6(5)
				Nicolas Mahut
124.			Jan Hajek	6-2 6-4 6-3
						Andy Murray
125.			Yen-Hsun Lu			6-2 6-4 7-5
				Yen-Hsun Lu
126.		[WC]	James Ward	6-7(4) 6-4 7-6(11) 7-6(4)
					Andy Murray
127.		[2]	Andy Murray		6-3 6-3 7-5
				Andy Murray
128.			Benjamin Becker	6-4 6-3 6-2

(default) 17 queries took 71 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	45
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	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	3
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` = '2013' 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` = (1991) 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, 3583, 4927, 4775, 11457, 129, 160, 85, 171, 100, 3590, 8674, 3587, 3718, 176, 69, 75, 108, 3721, 4769, 3578, 4772, 138, 137, 155, 150, 8686, 63, 4929, 90, 148, 3580, 83, 11455, 113, 7291, 54, 4215, 132, 11471, 60, 142, 8640, 178, 177, 71, 111, 122, 107, 105, 170, 10225, 88, 166, 74, 114, 161, 3585, 3588, 77, 109, 6780, 131, 149, 127, 179, 162, 3591, 106, 118, 157, 3724, 164, 10178, 130, 79, 3717, 94, 65, 156, 163, 70, 3581, 98, 59, 9296, 3584, 11473, 140, 119, 8917, 62, 152, 4773, 147, 135, 115, 3725, 89, 87, 139, 86, 102, 134, 123, 11474, 7313, 173, 136, 53, 3722, 158, 92, 68, 3720, 120, 3723, 4926, 72, 66, 5051, 91, 58, 5936, 125, 128, 84, 159) 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` = 1991	128	128	2
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (173, 10, 172, 154, 52, 72, 169, 68, 110, 53, 197, 92, 50, 29, 21, 133, 31, 164, 194, 13, 196, 150, 43, 179, 104, 14, 153, 199, 149, 168, 36, 181, 67, 94, 63)	35	35	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (173, 10, 172, 154, 52, 72, 169, 68, 110, 53, 197, 92, 50, 29, 21, 133, 31, 164, 194, 13, 196, 150, 43, 179, 104, 14, 153, 199, 149, 168, 36, 181, 67, 94, 63)	35	35	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (52, 3583, 4927, 4775, 11457, 129, 160, 85, 171, 100, 3590, 8674, 3587, 3718, 176, 69, 75, 108, 3721, 4769, 3578, 4772, 138, 137, 155, 150, 8686, 63, 4929, 90, 148, 3580, 83, 11455, 113, 7291, 54, 4215, 132, 11471, 60, 142, 8640, 178, 177, 71, 111, 122, 107, 105, 170, 10225, 88, 166, 74, 114, 161, 3585, 3588, 77, 109, 6780, 131, 149, 127, 179, 162, 3591, 106, 118, 157, 3724, 164, 10178, 130, 79, 3717, 94, 65, 156, 163, 70, 3581, 98, 59, 9296, 3584, 11473, 140, 119, 8917, 62, 152, 4773, 147, 135, 115, 3725, 89, 87, 139, 86, 102, 134, 123, 11474, 7313, 173, 136, 53, 3722, 158, 92, 68, 3720, 120, 3723, 4926, 72, 66, 5051, 91, 58, 5936, 125, 128, 84, 159)) AND (`Playercontest`.`contest_id` = 1991))	128	128	4
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` = 2013	15	15	1
16	SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (19, 1, 2, 3, 12, 14, 22, 17, 18, 24, 13, 23, 7, 15, 4) 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 71 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` = '2013' 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` = (1991) 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, 3583, 4927, 4775, 11457, 129, 160, 85, 171, 100, 3590, 8674, 3587, 3718, 176, 69, 75, 108, 3721, 4769, 3578, 4772, 138, 137, 155, 150, 8686, 63, 4929, 90, 148, 3580, 83, 11455, 113, 7291, 54, 4215, 132, 11471, 60, 142, 8640, 178, 177, 71, 111, 122, 107, 105, 170, 10225, 88, 166, 74, 114, 161, 3585, 3588, 77, 109, 6780, 131, 149, 127, 179, 162, 3591, 106, 118, 157, 3724, 164, 10178, 130, 79, 3717, 94, 65, 156, 163, 70, 3581, 98, 59, 9296, 3584, 11473, 140, 119, 8917, 62, 152, 4773, 147, 135, 115, 3725, 89, 87, 139, 86, 102, 134, 123, 11474, 7313, 173, 136, 53, 3722, 158, 92, 68, 3720, 120, 3723, 4926, 72, 66, 5051, 91, 58, 5936, 125, 128, 84, 159) 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` = 1991

128

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (52, 3583, 4927, 4775, 11457, 129, 160, 85, 171, 100, 3590, 8674, 3587, 3718, 176, 69, 75, 108, 3721, 4769, 3578, 4772, 138, 137, 155, 150, 8686, 63, 4929, 90, 148, 3580, 83, 11455, 113, 7291, 54, 4215, 132, 11471, 60, 142, 8640, 178, 177, 71, 111, 122, 107, 105, 170, 10225, 88, 166, 74, 114, 161, 3585, 3588, 77, 109, 6780, 131, 149, 127, 179, 162, 3591, 106, 118, 157, 3724, 164, 10178, 130, 79, 3717, 94, 65, 156, 163, 70, 3581, 98, 59, 9296, 3584, 11473, 140, 119, 8917, 62, 152, 4773, 147, 135, 115, 3725, 89, 87, 139, 86, 102, 134, 123, 11474, 7313, 173, 136, 53, 3722, 158, 92, 68, 3720, 120, 3723, 4926, 72, 66, 5051, 91, 58, 5936, 125, 128, 84, 159)) AND (`Playercontest`.`contest_id` = 1991))

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

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