Roland Garros 2014 Men's Singles (May 25 - June 8)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Rafael Nadal
				Rafael Nadal
2.		[WC]	Robby Ginepri	6-0 6-3 6-0
					Rafael Nadal
3.			Dominic Thiem		6-2 6-2 6-3
				Dominic Thiem
4.		[WC]	Paul-Henri Mathieu	6-4 7-6(3) 6-2
						Rafael Nadal
5.			Leonardo Mayer			6-2 7-5 6-2
				Leonardo Mayer
6.		[Q]	James Duckworth	5-7 6-2 6-4 7-6(2)
					Leonardo Mayer
7.			Teymuraz Gabashvili		6-2 4-6 6-4 6-4
				Teymuraz Gabashvili
8.		[30]	Vasek Pospisil	6-4 6-2 6-3
							Rafael Nadal
9.			Jack Sock				6-1 6-2 6-1
				Jack Sock
10.		[21]	Nicolas Almagro	5-0 rtd.
					Jack Sock
11.			Steve Johnson		7-5 6-4 6-2
				Steve Johnson
12.		[Q]	Laurent Lokoli	4-6 6-7(7) 7-6(3) 6-3 6-3
						Dusan Lajovic
13.			Dusan Lajovic			6-4 7-5 6-3
				Dusan Lajovic
14.			Federico Delbonis	6-3 6-2 6-3
					Dusan Lajovic
15.			Jurgen Zopp		6-2 6-4 6-4
				Jurgen Zopp
16.		[16]	Tommy Haas	2-5 rtd.
								Rafael Nadal
17.			Ivo Karlovic					4-6 6-4 6-0 6-1
				Ivo Karlovic
18.		[11]	Grigor Dimitrov	6-4 7-5 7-6(4)
					Ivo Karlovic
19.		[Q]	Andreas Haider-Maurer		7-5 6-3 6-4
				Andreas Haider-Maurer
20.			Daniel Brands	4-6 4-6 6-2 6-3 6-4
						Kevin Anderson
21.		[WC]	Axel Michon			6-3 rtd.
				Axel Michon
22.			Bradley Klahn	6-1 6-7(4) 5-7 6-1 6-4
					Kevin Anderson
23.		[19]	Kevin Anderson		6-2 6-3 6-2
				Kevin Anderson
24.			Stephane Robert	7-5 6-3 6-4
							David Ferrer
25.		[32]	Andreas Seppi				6-3 6-3 6-7(5) 6-1
				Andreas Seppi
26.			Santiago Giraldo	6-3 7-5 6-3
					Andreas Seppi
27.			Juan Monaco		6-2 6-4 6-4
				Juan Monaco
28.		[WC]	Lucas Pouille	6-3 6-1 6-4
						David Ferrer
29.		[Q]	Simone Bolelli			6-2 7-6(2) 6-3
				Simone Bolelli
30.		[Q]	Andrea Arnaboldi	6-4 6-4 6-2
					David Ferrer
31.		[5]	David Ferrer		6-2 6-3 6-2
				David Ferrer
32.			Igor Sijsling	6-4 6-3 6-1
									Rafael Nadal
33.			Guillermo Garcia-Lopez						6-3 6-2 6-1
				Guillermo Garcia-Lopez
34.		[3]	Stan Wawrinka	6-4 5-7 6-2 6-0
					Guillermo Garcia-Lopez
35.			Adrian Mannarino		6-4 6-3 4-6 6-0
				Adrian Mannarino
36.			Yen-Hsun Lu	6-2 6-1 6-1
						Guillermo Garcia-Lopez
37.			Donald Young			6-2 6-4 2-6 6-7(4) 6-4
				Donald Young
38.			Dudi Sela	6-1 2-6 6-1 6-0
					Donald Young
39.		[26]	Feliciano Lopez		6-3 7-6(1) 6-3
				Feliciano Lopez
40.		[Q]	Damir Dzumhur	6-3 7-6(8) 6-3
							Gael Monfils
41.		[23]	Gael Monfils				6-0 6-2 7-5
				Gael Monfils
42.			Victor Hanescu	6-2 4-6 6-4 6-2
					Gael Monfils
43.			Jan-Lennard Struff		7-6(4) 6-4 6-1
				Jan-Lennard Struff
44.		[WC]	Albano Olivetti	6-1 6-4 6-4
						Gael Monfils
45.			Thomaz Bellucci			5-7 6-2 6-4 0-6 6-2
				Thomaz Bellucci
46.			Benjamin Becker	6-2 6-4 3-6 4-6 6-2
					Fabio Fognini
47.		[14]	Fabio Fognini		6-3 6-4 7-6(2)
				Fabio Fognini
48.		[Q]	Andreas Beck	6-4 6-4 6-1
								Andy Murray
49.		[12]	Richard Gasquet					6-4 6-1 4-6 1-6 6-0
				Richard Gasquet
50.			Bernard Tomic	6-2 6-1 7-5
					Richard Gasquet
51.			Carlos Berlocq		7-6(5) 6-4 6-4
				Carlos Berlocq
52.			Lleyton Hewitt	3-6 6-2 6-1 6-4
						Fernando Verdasco
53.			Pablo Cuevas			6-3 6-2 6-3
				Pablo Cuevas
54.			Matthew Ebden	6-1 6-2 6-3
					Fernando Verdasco
55.		[24]	Fernando Verdasco		4-6 6-7(6) 7-5 6-4 6-3
				Fernando Verdasco
56.		[WC]	Michael Llodra	6-2 7-6(4) 7-6(3)
							Andy Murray
57.		[28]	Philipp Kohlschreiber				6-4 7-5 7-6(3)
				Philipp Kohlschreiber
58.			Pere Riba	7-5 6-4 6-1
					Philipp Kohlschreiber
59.			Denis Istomin		6-3 7-6(5) 6-2
				Denis Istomin
60.			Sergiy Stakhovsky	6-3 6-4 2-6 6-3
						Andy Murray
61.			Marinko Matosevic			3-6 6-3 6-3 4-6 12-10
				Marinko Matosevic
62.			Dustin Brown	7-6(5) 6-4 6-7(1) 7-5
					Andy Murray
63.		[7]	Andy Murray		6-3 6-1 6-3
				Andy Murray
64.			Andrey Golubev	6-1 6-4 3-6 6-3
										Rafael Nadal
65.		[6]	Tomas Berdych							3-6 7-5 6-2 6-4
				Tomas Berdych
66.		[Q]	Peter Polansky	6-3 6-4 6-4
					Tomas Berdych
67.			Aleksandr Nedovyesov		6-7(4) 6-4 7-5 6-3
				Aleksandr Nedovyesov
68.			Somdev Devvarman	5-7 6-3 7-6(4) 6-3
						Tomas Berdych
69.			Benoit Paire			6-1 6-2 6-7(4) 6-4
				Benoit Paire
70.			Alejandro Falla	6-3 6-4 7-6(4)
					Roberto Bautista Agut
71.		[27]	Roberto Bautista Agut		6-4 7-6(4) 6-2
				Roberto Bautista Agut
72.		[Q]	Paolo Lorenzi	6-3 7-5 6-2
							Tomas Berdych
73.		[17]	Tommy Robredo				6-4 6-4 6-4
				Tommy Robredo
74.		[Q]	James Ward	4-6 6-4 6-2 6-4
					Tommy Robredo
75.			Kenny De Schepper		6-2 6-3 6-3
				Kenny De Schepper
76.			Albert Montanes	3-1 rtd.
						John Isner
77.			Mikhail Kukushkin			7-6(13) 7-6(3) 6-7(5) 7-5
				Mikhail Kukushkin
78.			Nicolas Mahut	6-3 6-7(4) 6-3 6-4
					John Isner
79.		[10]	John Isner		6-7(6) 7-6(4) 6-3 7-6(4)
				John Isner
80.		[WC]	Pierre-Hugues Herbert	7-6(5) 7-6(4) 7-5
								Ernests Gulbis
81.		[15]	Mikhail Youzhny					6-3 6-2 6-4
				Mikhail Youzhny
82.			Pablo Carreno Busta	3-6 1-6 6-3 6-4 6-0
					Radek Stepanek
83.			Radek Stepanek		6-0 6-3 3-6 6-4
				Radek Stepanek
84.			Facundo Arguello	6-7(8) 3-6 6-4 6-3 6-2
						Ernests Gulbis
85.		[Q]	Facundo Bagnis			6-3 6-2 7-5
				Facundo Bagnis
86.			Julien Benneteau	6-1 6-2 1-6 3-6 18-16
					Ernests Gulbis
87.		[18]	Ernests Gulbis		6-2 7-5 6-0
				Ernests Gulbis
88.			Lukasz Kubot	4-6 6-4 7-5 6-1
							Ernests Gulbis
89.		[31]	Dmitry Tursunov				6-7(5) 7-6(3) 6-2 4-6 6-3
				Dmitry Tursunov
90.		[Q]	Potito Starace	6-1 7-5 6-2
					Dmitry Tursunov
91.			Sam Querrey		6-4 7-5 6-1
				Sam Querrey
92.			Filippo Volandri	7-6(3) 6-4 6-3
						Roger Federer
93.		[Q]	Diego Schwartzman			7-5 6-7(7) 6-2 6-4
				Diego Schwartzman
94.		[Q]	Gastao Elias	6-4 6-2 7-5
					Roger Federer
95.		[4]	Roger Federer		6-3 6-4 6-4
				Roger Federer
96.			Lukas Lacko	6-2 6-4 6-2
									Novak Djokovic
97.		[8]	Milos Raonic						6-3 6-3 3-6 6-3
				Milos Raonic
98.		[WC]	Nick Kyrgios	6-3 7-6(1) 6-3
					Milos Raonic
99.			Jiri Vesely		7-6(4) 6-4 6-1
				Jiri Vesely
100.			Lukas Rosol	6-2 7-6(6) 7-5
						Milos Raonic
101.			Alejandro Gonzalez			4-6 6-3 2-6 6-2 7-5
				Alejandro Gonzalez
102.			Michael Russell	6-2 6-4 6-7(6) 6-1
					Gilles Simon
103.		[29]	Gilles Simon		6-4 6-0 6-2
				Gilles Simon
104.		[Q]	Ante Pavic	6-1 6-1 6-3
							Milos Raonic
105.		[20]	Alexandr Dolgopolov				6-3 6-3 6-3
				Alexandr Dolgopolov
106.			Albert Ramos-Vinolas	7-6(4) 6-4 6-1
					Marcel Granollers
107.			Marcel Granollers		1-6 3-6 6-3 6-0 6-2
				Marcel Granollers
108.			Ivan Dodig	2-2 rtd.
						Marcel Granollers
109.			Robin Haase			6-7(5) 6-2 7-6(4) 7-5
				Robin Haase
110.			Nikolay Davydenko	7-5 6-4 6-2
					Martin Klizan
111.			Martin Klizan		6-1 3-6 6-1 1-6 7-5
				Martin Klizan
112.		[9]	Kei Nishikori	7-6(4) 6-1 6-2
								Novak Djokovic
113.		[13]	Jo-Wilfried Tsonga					7-5 7-6(5) 6-4
				Jo-Wilfried Tsonga
114.			Edouard Roger-Vasselin	7-6(4) 7-5 6-2
					Jo-Wilfried Tsonga
115.			Jurgen Melzer		6-2 6-3 6-4
				Jurgen Melzer
116.			David Goffin	6-4 5-7 7-5 6-4
						Jo-Wilfried Tsonga
117.			Jarkko Nieminen			6-4 6-4 6-3
				Jarkko Nieminen
118.			Michal Przysiezny	6-7(7) 6-4 6-7(3) 6-3 6-4
					Jerzy Janowicz
119.		[22]	Jerzy Janowicz		7-6(4) 7-6(4) 6-4
				Jerzy Janowicz
120.			Victor Burgos	6-1 6-4 6-7(6) 6-4
							Novak Djokovic
121.		[25]	Marin Cilic				6-1 6-4 6-1
				Marin Cilic
122.			Pablo Andujar	6-0 6-3 7-6(6)
					Marin Cilic
123.			Tobias Kamke		6-3 3-6 6-3 6-0
				Tobias Kamke
124.		[Q]	Miloslav Mecir Jr.	7-5 7-6(2) 7-6(1)
						Novak Djokovic
125.			Jeremy Chardy			6-3 6-2 6-7(2) 6-4
				Jeremy Chardy
126.			Daniel Gimeno-Traver	7-5 6-2 6-2
					Novak Djokovic
127.		[2]	Novak Djokovic		6-1 6-4 6-2
				Novak Djokovic
128.			Joao Sousa	6-1 6-2 6-4

(default) 17 queries took 24 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` = 'roland-garros' 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` = (2)	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` = (2)	5	5	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` = (2)	5	5	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` = 'roland-garros' 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` = (12) ORDER BY `Contest`.`year` ASC	123	123	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` = 2 AND `Contest`.`category_id` = 12 AND `Contest`.`slug` = '2014' 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` = (2178) 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 (179, 4776, 13580, 3590, 170, 71, 7291, 3723, 4925, 163, 4775, 13611, 13562, 11454, 70, 176, 141, 161, 4769, 4929, 13612, 5049, 155, 106, 74, 54, 123, 11452, 3585, 13613, 83, 8640, 94, 156, 130, 125, 175, 97, 171, 13567, 99, 135, 11457, 8705, 96, 159, 119, 145, 75, 138, 142, 65, 5934, 105, 139, 88, 122, 121, 114, 152, 98, 3717, 84, 73, 148, 7847, 13565, 4923, 157, 118, 113, 53, 5051, 128, 136, 120, 95, 58, 164, 8702, 72, 11461, 59, 13614, 13615, 102, 89, 162, 69, 57, 137, 61, 13616, 11471, 147, 173, 60, 10252, 11453, 62, 13581, 77, 100, 13617, 132, 149, 108, 111, 66, 169, 3580, 107, 115, 87, 140, 3725, 166, 8686, 3584, 13618, 3722, 79, 134, 13619, 160, 90, 52, 13674) 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` = 2178	129	129	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (53, 173, 154, 68, 197, 179, 196, 92, 13, 14, 72, 194, 29, 133, 91, 10, 36, 149, 50, 94, 67, 96, 168, 181, 164, 199, 153, 104, 43, 21, 150, 27, 31, 86, 198, 57, 172, 63)	38	38	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (53, 173, 154, 68, 197, 179, 196, 92, 13, 14, 72, 194, 29, 133, 91, 10, 36, 149, 50, 94, 67, 96, 168, 181, 164, 199, 153, 104, 43, 21, 150, 27, 31, 86, 198, 57, 172, 63)	38	38	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (179, 4776, 13580, 3590, 170, 71, 7291, 3723, 4925, 163, 4775, 13611, 13562, 11454, 70, 176, 141, 161, 4769, 4929, 13612, 5049, 155, 106, 74, 54, 123, 11452, 3585, 13613, 83, 8640, 94, 156, 130, 125, 175, 97, 171, 13567, 99, 135, 11457, 8705, 96, 159, 119, 145, 75, 138, 142, 65, 5934, 105, 139, 88, 122, 121, 114, 152, 98, 3717, 84, 73, 148, 7847, 13565, 4923, 157, 118, 113, 53, 5051, 128, 136, 120, 95, 58, 164, 8702, 72, 11461, 59, 13614, 13615, 102, 89, 162, 69, 57, 137, 61, 13616, 11471, 147, 173, 60, 10252, 11453, 62, 13581, 77, 100, 13617, 132, 149, 108, 111, 66, 169, 3580, 107, 115, 87, 140, 3725, 166, 8686, 3584, 13618, 3722, 79, 134, 13619, 160, 90, 52, 13674)) AND (`Playercontest`.`contest_id` = 2178))	128	128	2
14	SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 12 ORDER BY `Contest`.`date_from` ASC	123	123	1
15	SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 2014	14	14	1
16	SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (19, 17, 12, 14, 1, 3, 2, 13, 18, 23, 22, 24, 7, 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 24 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` = 'roland-garros' 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` = (2)

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` = (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`, `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` = 'roland-garros' AND `Category`.`slug` = 'men-singles' LIMIT 1

123

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` = 2 AND `Contest`.`category_id` = 12 AND `Contest`.`slug` = '2014' 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` = (2178) 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 (179, 4776, 13580, 3590, 170, 71, 7291, 3723, 4925, 163, 4775, 13611, 13562, 11454, 70, 176, 141, 161, 4769, 4929, 13612, 5049, 155, 106, 74, 54, 123, 11452, 3585, 13613, 83, 8640, 94, 156, 130, 125, 175, 97, 171, 13567, 99, 135, 11457, 8705, 96, 159, 119, 145, 75, 138, 142, 65, 5934, 105, 139, 88, 122, 121, 114, 152, 98, 3717, 84, 73, 148, 7847, 13565, 4923, 157, 118, 113, 53, 5051, 128, 136, 120, 95, 58, 164, 8702, 72, 11461, 59, 13614, 13615, 102, 89, 162, 69, 57, 137, 61, 13616, 11471, 147, 173, 60, 10252, 11453, 62, 13581, 77, 100, 13617, 132, 149, 108, 111, 66, 169, 3580, 107, 115, 87, 140, 3725, 166, 8686, 3584, 13618, 3722, 79, 134, 13619, 160, 90, 52, 13674) 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` = 2178

129

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (179, 4776, 13580, 3590, 170, 71, 7291, 3723, 4925, 163, 4775, 13611, 13562, 11454, 70, 176, 141, 161, 4769, 4929, 13612, 5049, 155, 106, 74, 54, 123, 11452, 3585, 13613, 83, 8640, 94, 156, 130, 125, 175, 97, 171, 13567, 99, 135, 11457, 8705, 96, 159, 119, 145, 75, 138, 142, 65, 5934, 105, 139, 88, 122, 121, 114, 152, 98, 3717, 84, 73, 148, 7847, 13565, 4923, 157, 118, 113, 53, 5051, 128, 136, 120, 95, 58, 164, 8702, 72, 11461, 59, 13614, 13615, 102, 89, 162, 69, 57, 137, 61, 13616, 11471, 147, 173, 60, 10252, 11453, 62, 13581, 77, 100, 13617, 132, 149, 108, 111, 66, 169, 3580, 107, 115, 87, 140, 3725, 166, 8686, 3584, 13618, 3722, 79, 134, 13619, 160, 90, 52, 13674)) AND (`Playercontest`.`contest_id` = 2178))

128

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

123

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

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