US Open 2016 Men's Singles (August 29 - September 11)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Novak Djokovic
				Novak Djokovic
2.			Jerzy Janowicz	6-3 5-7 6-2 6-1
					Novak Djokovic
3.			Jiri Vesely		w/o
				Jiri Vesely
4.		[Q]	Saketh Myneni	7-6(5) 4-6 2-6 6-2 7-5
						Novak Djokovic
5.			Guido Pella			4-2 rtd.
				Guido Pella
6.		[WC]	Bjorn Fratangelo	6-3 6-4 6-4
					Mikhail Youzhny
7.			Mikhail Youzhny		6-2 6-1 7-6(3)
				Mikhail Youzhny
8.			Martin Klizan	6-2 6-1 6-1
							Novak Djokovic
9.		[20]	John Isner				6-2 6-1 6-4
				John Isner
10.		[WC]	Frances Tiafoe	3-6 4-6 7-6(5) 6-2 7-6(3)
					John Isner
11.		[Q]	Steve Darcis		6-3 6-4 6-7(10) 6-3
				Steve Darcis
12.			Jordan Thompson	5-7 3-6 7-6(5) 6-4 7-5
						Kyle Edmund
13.		[WC]	Ernesto Escobedo			6-4 3-6 6-2 7-6(5)
				Ernesto Escobedo
14.			Lukas Lacko	6-4 6-4 4-6 6-3 rtd.
					Kyle Edmund
15.			Kyle Edmund		7-5 6-4 6-4
				Kyle Edmund
16.			Richard Gasquet	6-2 6-2 6-3
								Novak Djokovic
17.		[9]	Jo-Wilfried Tsonga					6-3 6-2 0-0 rtd.
				Jo-Wilfried Tsonga
18.		[Q]	Guido Andreozzi	6-3 6-4 6-4
					Jo-Wilfried Tsonga
19.		[WC]	James Duckworth		6-4 3-6 6-3 6-4
				James Duckworth
20.			Robin Haase	4-6 7-5 6-3 4-6 6-3
						Jo-Wilfried Tsonga
21.			Vasek Pospisil			6-3 6-4 7-6(4)
				Vasek Pospisil
22.		[LL]	Jozef Kovalik	6-1 6-3 6-3
					Kevin Anderson
23.		[23]	Kevin Anderson		7-6(3) 6-4 6-4
				Kevin Anderson
24.			Yoshihito Nishioka	6-3 7-5 6-4
							Jo-Wilfried Tsonga
25.		[26]	Jack Sock				6-3 6-3 6-7(7) 6-2
				Jack Sock
26.			Taylor Fritz	7-6(3) 7-5 3-6 1-6 6-4
					Jack Sock
27.		[Q]	Mischa Zverev		6-1 6-1 6-2
				Mischa Zverev
28.			Pierre-Hugues Herbert	6-4 7-6(6) 4-6 6-0
						Jack Sock
29.			Sergiy Stakhovsky			6-4 6-3 6-3
				Sergiy Stakhovsky
30.			Gastao Elias	6-1 3-6 2-6 6-3 7-6(4)
					Marin Cilic
31.		[7]	Marin Cilic		6-1 6-2 6-3
				Marin Cilic
32.			Rogerio Dutra Da Silva	6-4 7-5 6-1
									Novak Djokovic
33.		[4]	Rafael Nadal						6-3 6-2 3-6 6-2
				Rafael Nadal
34.			Denis Istomin	6-1 6-4 6-2
					Rafael Nadal
35.			Andreas Seppi		6-0 7-5 6-1
				Andreas Seppi
36.			Stephane Robert	6-2 3-6 6-4 6-3
						Rafael Nadal
37.			Andrey Kuznetsov			6-1 6-4 6-2
				Andrey Kuznetsov
38.			Thomaz Bellucci	6-3 3-6 6-1 7-6(6)
					Andrey Kuznetsov
39.		[31]	Albert Ramos-Vinolas		7-5 6-4 7-6(5)
				Albert Ramos-Vinolas
40.			Julien Benneteau	3-6 6-3 6-3 2-6 6-1
							Lucas Pouille
41.		[24]	Lucas Pouille				6-1 2-6 6-4 3-6 7-6(6)
				Lucas Pouille
42.			Mikhail Kukushkin	3-6 6-2 6-4 6-2
					Lucas Pouille
43.		[Q]	Marco Chiudinelli		4-6 3-6 7-6(6) 6-2 6-0
				Marco Chiudinelli
44.		[Q]	Guilherme Sarti Clezar	2-6 7-6(6) 6-2 6-4
						Lucas Pouille
45.			Federico Delbonis			3-6 7-5 2-6 7-5 6-1
				Federico Delbonis
46.			Brian Baker	3-6 6-7(6) 6-4 6-2 6-2
					Roberto Bautista Agut
47.		[15]	Roberto Bautista Agut		5-7 6-2 6-3 6-2
				Roberto Bautista Agut
48.			Guillermo Garcia-Lopez	7-5 6-1 6-7(5) 7-6(3)
								Gael Monfils
49.		[10]	Gael Monfils					6-4 6-3 6-3
				Gael Monfils
50.			Gilles Muller	6-4 6-2 7-6(5)
					Gael Monfils
51.		[Q]	Jan Satral		7-5 6-4 6-3
				Jan Satral
52.		[WC]	Mackenzie McDonald	4-6 3-6 6-3 6-2 6-2
						Gael Monfils
53.			Nicolas Almagro			6-4 6-2 6-4
				Nicolas Almagro
54.		[Q]	Marton Fucsovics	6-1 6-4 7-6(7)
					Nicolas Almagro
55.		[18]	Pablo Cuevas		7-6(5) 6-4 7-6(9)
				Pablo Cuevas
56.			Dudi Sela	6-3 6-2 0-6 5-7 6-3
							Gael Monfils
57.		[32]	Benoit Paire				6-3 6-2 6-3
				Benoit Paire
58.			Dusan Lajovic	6-2 2-6 3-6 7-5 6-1
					Marcos Baghdatis
59.			Marcos Baghdatis		6-2 6-4 3-6 6-4
				Marcos Baghdatis
60.			Facundo Bagnis	6-4 6-2 6-1
						Marcos Baghdatis
61.		[Q]	Ryan Harrison			6-3 7-6(4) 1-6 6-1
				Ryan Harrison
62.			Adrian Mannarino	6-4 7-6(5) 6-3
					Ryan Harrison
63.		[5]	Milos Raonic		6-7(4) 7-5 7-5 6-1
				Milos Raonic
64.			Dustin Brown	7-5 6-3 6-4
										Stan Wawrinka
65.		[8]	Dominic Thiem							6-7(1) 6-4 7-5 6-3
				Dominic Thiem
66.			John Millman	6-3 2-6 5-7 6-4 6-3
					Dominic Thiem
67.			Ricardas Berankis		6-4 6-3 6-2
				Ricardas Berankis
68.			Malek Jaziri	3-6 7-6(3) 6-4 6-2
						Dominic Thiem
69.			Pablo Carreno Busta			1-6 6-4 6-4 7-5
				Pablo Carreno Busta
70.		[Q]	Ilya Ivashka	6-0 7-5 6-2
					Pablo Carreno Busta
71.			Janko Tipsarevic		3-6 4-6 6-1 6-4 6-4
				Janko Tipsarevic
72.			Sam Querrey	7-6(4) 6-7(0) 6-3 6-3
							Juan Martin Del Potro
73.		[19]	Steve Johnson				6-3 3-2 rtd.
				Steve Johnson
74.			Evgeny Donskoy	4-6 1-6 7-6(2) 6-3 6-3
					Juan Martin Del Potro
75.		[WC]	Juan Martin Del Potro		7-6(5) 6-3 6-2
				Juan Martin Del Potro
76.			Diego Schwartzman	6-4 6-4 7-6(3)
						Juan Martin Del Potro
77.			Fabio Fognini			7-6(3) 6-2 6-3
				Fabio Fognini
78.			Teymuraz Gabashvili	6-7(9) 3-6 7-6(5) 7-5 6-4
					David Ferrer
79.		[11]	David Ferrer		6-0 4-6 5-7 6-1 6-4
				David Ferrer
80.			Alexandr Dolgopolov	6-5 rtd.
								Stan Wawrinka
81.		[14]	Nick Kyrgios					7-6(5) 4-6 6-3 6-2
				Nick Kyrgios
82.			Aljaz Bedene	6-4 6-4 6-4
					Nick Kyrgios
83.			Horacio Zeballos Jr.		7-5 6-4 6-4
				Horacio Zeballos Jr.
84.			Florian Mayer	6-3 6-4 7-6(7)
						Illya Marchenko
85.			Illya Marchenko			4-6 6-4 6-1 rtd.
				Illya Marchenko
86.			Ivan Dodig	6-3 6-4 6-7(4) 7-5
					Illya Marchenko
87.			Damir Dzumhur		6-2 6-4 6-3
				Damir Dzumhur
88.			Bernard Tomic	6-4 6-3 4-6 7-6(0)
							Stan Wawrinka
89.		[27]	Alexander Zverev				6-4 6-1 6-7(5) 6-3
				Alexander Zverev
90.		[LL]	Daniel Brands	3-6 6-1 6-4 7-6(4)
					Daniel Evans
91.			Daniel Evans		6-4 6-4 5-7 6-2
				Daniel Evans
92.		[WC]	Rajeev Ram	6-2 4-6 7-5 6-1
						Stan Wawrinka
93.		[Q]	Alessandro Giannessi			4-6 6-3 6-7(6) 7-6(8) 6-2
				Alessandro Giannessi
94.			Denis Kudla	0-6 6-4 6-1 1-6 6-0
					Stan Wawrinka
95.		[3]	Stan Wawrinka		6-1 7-6(4) 7-5
				Stan Wawrinka
96.			Fernando Verdasco	7-6(4) 6-4 6-4
									Stan Wawrinka
97.		[6]	Kei Nishikori						4-6 7-5 6-4 6-2
				Kei Nishikori
98.			Benjamin Becker	6-1 6-1 3-6 6-3
					Kei Nishikori
99.		[Q]	Karen Khachanov		6-4 4-6 6-4 6-3
				Karen Khachanov
100.		[Q]	Thomas Fabbiano	6-3 6-3 4-6 6-3
						Kei Nishikori
101.			Paul-Henri Mathieu			4-6 6-1 6-2 6-2
				Paul-Henri Mathieu
102.		[Q]	Christian Harrison	6-0 6-2 6-1
					Nicolas Mahut
103.			Nicolas Mahut		6-4 6-4 6-2
				Nicolas Mahut
104.			Philipp Kohlschreiber	6-3 7-5 1-0 rtd.
							Kei Nishikori
105.		[21]	Ivo Karlovic				6-3 6-4 7-6(4)
				Ivo Karlovic
106.			Yen-Hsun Lu	4-6 7-6(4) 6-7(4) 7-6(5) 7-5
					Ivo Karlovic
107.			Donald Young		6-4 7-6(4) 6-4
				Donald Young
108.			Jan-Lennard Struff	6-3 7-5 4-6 7-5
						Ivo Karlovic
109.			Viktor Troicki			6-4 7-6(3) 6-3
				Viktor Troicki
110.			Radu Albot	5-7 3-6 6-4 6-4 7-6(5)
					Jared Donaldson
111.		[Q]	Jared Donaldson		7-5 6-3 6-3
				Jared Donaldson
112.			David Goffin	4-6 7-5 6-4 6-0
								Kei Nishikori
113.		[16]	Feliciano Lopez					1-6 6-4 4-6 6-1 7-5
				Feliciano Lopez
114.			Borna Coric	3-4 rtd.
					Joao Sousa
115.			Joao Sousa		6-2 6-4 1-6 7-5
				Joao Sousa
116.			Victor Burgos	6-0 6-1 6-1
						Grigor Dimitrov
117.			Jeremy Chardy			6-4 6-1 3-6 6-2
				Jeremy Chardy
118.		[WC]	Michael Mmoh	6-4 6-4 6-1
					Grigor Dimitrov
119.		[22]	Grigor Dimitrov		4-6 6-4 3-6 6-4 6-2
				Grigor Dimitrov
120.			Inigo Cervantes	6-2 6-4 7-6(7)
							Andy Murray
121.		[30]	Gilles Simon				6-1 6-2 6-2
				Gilles Simon
122.		[Q]	Radek Stepanek	6-3 6-1 6-4
					Paolo Lorenzi
123.			Paolo Lorenzi		3-6 6-2 6-2 6-7(1) 7-6(3)
				Paolo Lorenzi
124.			Carlos Berlocq	6-4 6-2 6-1
						Andy Murray
125.			Marcel Granollers			7-6(4) 5-7 6-2 6-3
				Marcel Granollers
126.			Juan Monaco	7-6(5) 7-6(2) 6-4
					Andy Murray
127.		[2]	Andy Murray		6-4 6-1 6-4
				Andy Murray
128.			Lukas Rosol	6-3 6-2 6-2

(default) 17 queries took 342 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` = 'us-open' LIMIT 1	1	1	95
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` = (4)	5	5	101
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` = (4)	3	3	16
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` = (4)	2	2	12
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` = 'us-open' 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` = (22) ORDER BY `Contest`.`year` ASC	144	144	93
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` = 4 AND `Contest`.`category_id` = 22 AND `Contest`.`slug` = '2016' LIMIT 1	1	1	3
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` = (2246) ORDER BY `Match`.`round_id` ASC, `Match`.`no` ASC	127	127	3
9	SELECT `Player`.`id`, `Player`.`name`, `Player`.`gender`, `Player`.`slug` FROM `zavoihu1_db4tennis`.`players` AS `Player` WHERE `Player`.`id` IN (52, 3584, 11453, 14216, 6780, 14151, 72, 3580, 164, 14087, 127, 13568, 14217, 173, 11473, 75, 115, 6785, 71, 66, 3723, 14175, 155, 13874, 4925, 14178, 7301, 8702, 152, 11471, 3722, 4773, 179, 114, 74, 106, 3720, 96, 149, 102, 11452, 95, 5050, 14218, 11454, 3727, 113, 94, 99, 117, 14219, 14220, 163, 14221, 5934, 97, 157, 13562, 158, 13615, 85, 130, 60, 3717, 13580, 10177, 8674, 3728, 11461, 14222, 68, 137, 4775, 10178, 131, 13616, 119, 7291, 83, 132, 10252, 10225, 4215, 3583, 153, 111, 13567, 138, 14136, 4929, 9051, 7313, 14223, 177, 156, 139, 107, 159, 14224, 13538, 3590, 8641, 58, 122, 141, 125, 175, 11457, 92, 13869, 13866, 3725, 171, 13870, 13674, 13618, 160, 14086, 161, 3593, 100, 59, 53, 142, 108, 123, 84, 62) 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` = 2246	128	128	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (123, 173, 172, 10, 52, 197, 72, 196, 29, 68, 110, 57, 179, 50, 198, 21, 31, 164, 194, 154, 13, 27, 150, 92, 84, 133, 199, 20, 149, 189, 168, 96, 181, 111, 86, 94, 36, 53, 91, 14)	40	40	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (123, 173, 172, 10, 52, 197, 72, 196, 29, 68, 110, 57, 179, 50, 198, 21, 31, 164, 194, 154, 13, 27, 150, 92, 84, 133, 199, 20, 149, 189, 168, 96, 181, 111, 86, 94, 36, 53, 91, 14)	40	40	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (52, 3584, 11453, 14216, 6780, 14151, 72, 3580, 164, 14087, 127, 13568, 14217, 173, 11473, 75, 115, 6785, 71, 66, 3723, 14175, 155, 13874, 4925, 14178, 7301, 8702, 152, 11471, 3722, 4773, 179, 114, 74, 106, 3720, 96, 149, 102, 11452, 95, 5050, 14218, 11454, 3727, 113, 94, 99, 117, 14219, 14220, 163, 14221, 5934, 97, 157, 13562, 158, 13615, 85, 130, 60, 3717, 13580, 10177, 8674, 3728, 11461, 14222, 68, 137, 4775, 10178, 131, 13616, 119, 7291, 83, 132, 10252, 10225, 4215, 3583, 153, 111, 13567, 138, 14136, 4929, 9051, 7313, 14223, 177, 156, 139, 107, 159, 14224, 13538, 3590, 8641, 58, 122, 141, 125, 175, 11457, 92, 13869, 13866, 3725, 171, 13870, 13674, 13618, 160, 14086, 161, 3593, 100, 59, 53, 142, 108, 123, 84, 62)) AND (`Playercontest`.`contest_id` = 2246))	128	128	3
14	SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 22 ORDER BY `Contest`.`date_from` ASC	144	144	4
15	SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 2016	10	10	1
16	SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (1, 3, 12, 14, 19, 17, 22, 24, 4, 2) 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 342 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` = 'us-open' LIMIT 1

101

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` = (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` = (4)

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` = 'us-open' AND `Category`.`slug` = 'men-singles' LIMIT 1

144

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` = 4 AND `Contest`.`category_id` = 22 AND `Contest`.`slug` = '2016' 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` = (2246) 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, 3584, 11453, 14216, 6780, 14151, 72, 3580, 164, 14087, 127, 13568, 14217, 173, 11473, 75, 115, 6785, 71, 66, 3723, 14175, 155, 13874, 4925, 14178, 7301, 8702, 152, 11471, 3722, 4773, 179, 114, 74, 106, 3720, 96, 149, 102, 11452, 95, 5050, 14218, 11454, 3727, 113, 94, 99, 117, 14219, 14220, 163, 14221, 5934, 97, 157, 13562, 158, 13615, 85, 130, 60, 3717, 13580, 10177, 8674, 3728, 11461, 14222, 68, 137, 4775, 10178, 131, 13616, 119, 7291, 83, 132, 10252, 10225, 4215, 3583, 153, 111, 13567, 138, 14136, 4929, 9051, 7313, 14223, 177, 156, 139, 107, 159, 14224, 13538, 3590, 8641, 58, 122, 141, 125, 175, 11457, 92, 13869, 13866, 3725, 171, 13870, 13674, 13618, 160, 14086, 161, 3593, 100, 59, 53, 142, 108, 123, 84, 62) 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` = 2246

128

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (52, 3584, 11453, 14216, 6780, 14151, 72, 3580, 164, 14087, 127, 13568, 14217, 173, 11473, 75, 115, 6785, 71, 66, 3723, 14175, 155, 13874, 4925, 14178, 7301, 8702, 152, 11471, 3722, 4773, 179, 114, 74, 106, 3720, 96, 149, 102, 11452, 95, 5050, 14218, 11454, 3727, 113, 94, 99, 117, 14219, 14220, 163, 14221, 5934, 97, 157, 13562, 158, 13615, 85, 130, 60, 3717, 13580, 10177, 8674, 3728, 11461, 14222, 68, 137, 4775, 10178, 131, 13616, 119, 7291, 83, 132, 10252, 10225, 4215, 3583, 153, 111, 13567, 138, 14136, 4929, 9051, 7313, 14223, 177, 156, 139, 107, 159, 14224, 13538, 3590, 8641, 58, 122, 141, 125, 175, 11457, 92, 13869, 13866, 3725, 171, 13870, 13674, 13618, 160, 14086, 161, 3593, 100, 59, 53, 142, 108, 123, 84, 62)) AND (`Playercontest`.`contest_id` = 2246))

128

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

144

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

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