US Open 1911 Men's Singles (August 21 - September 3)

	Nation	R256	R128	R64	R32	R16	QF	SF	F	CH	Champion
1.		Subscribe now								William Larned
										last year champion
2.

3.

4.

5.

6.

7.		Angus Cassils		6-1 2-6 7-5 1-6 6-2
			Angus Cassils
8.		bye
						Tudor Gross
9.		Walter Roberts				6-3 3-6 6-4 6-3
			Walter Roberts
10.		bye
				Walter Roberts
11.		Francis Washburn		7-5 2-6 13-11 2-6 6-2
			Francis Washburn
12.		bye
					Tudor Gross
13.		Subscribe now

14.

15.

16.
							Carlton Gardner
17.							3-6 6-3 6-4 6-3

18.

19.		Charles Beck		6-1 6-0 6-1
			Charles Beck
20.		bye
					Joseph Armstrong
21.		Stacey Brown			6-3 6-3 6-2
			Stacey Brown
22.		bye
				Stacey Brown
23.		Vincent Astor		6-1 6-1 6-4
			Vincent Astor
24.		bye
						Carlton Gardner
25.		Subscribe now				6-1 6-2 6-2

26.

27.

28.

29.

30.

31.		Francis Watrous		6-3 6-3 6-4
			Francis Watrous
32.		bye
								Gustave Touchard
33.		Walter L. Pate						6-3 6-4 7-5
			Walter L. Pate
34.		bye
				Walter L. Pate
35.		Frank Paul		w/o
			Frank Paul
36.		bye
					Walter L. Pate
37.		Subscribe now

38.

39.

40.
						Gustave Touchard
41.						6-4 8-6 6-2

42.

43.		J. H. MacVeagh		w/o
			J. H. MacVeagh
44.		bye
					Gustave Touchard
45.		William Gates			6-3 4-6 5-7 6-3 6-1
			William Gates
46.		bye
				William Gates
47.		R. Lyman		6-1 6-4 6-1
			R. Lyman
48.		bye
							Gustave Touchard
49.		Subscribe now					6-1 6-3 6-4

50.

51.

52.

53.

54.

55.		William Rosenbaum		6-2 6-4 1-6 6-3
			William Rosenbaum
56.		G. F. Parrish	w/o
						Ray Palmer
57.		Russell N. Dana				6-4 4-6 2-6 8-6 6-2
			Russell N. Dana
58.		Norman G. Johnson	w/o
				Russell N. Dana
59.		O. Pepper		6-0 6-1 6-0
			O. Pepper
60.		A. E. Kennedy Jr.	w/o
					J. Ames
61.		Subscribe now

62.

63.

64.
									Maurice McLoughlin		William Larned
65.									6-2 6-4 6-3		6-4 6-4 6-2

66.

67.		Frank Fall		6-1 6-2 6-2
			Frank Fall
68.		D. Noblit	6-2 6-3 6-4
					Raymond Little
69.		Fred Harris			6-4 6-1 6-3
			Fred Harris
70.		W. R. Harper	w/o
				Fred Harris
71.		A. E. Bell Sr.		6-0 6-0 6-0
			A. E. Bell Sr.
72.		Edward Palmer	w/o
						Raymond Little
73.		Subscribe now				6-0 10-8 6-8 1-6 6-4

74.

75.

76.

77.

78.

79.		F. Robinson		6-0 6-1 6-1
			F. Robinson
80.		Louis Hobbs	4-6 6-4 5-7 6-3 8-6
							Watson Washburn
81.		N. Vose					9-7 5-7 3-6 6-2 6-4
			N. Vose
82.		R. C. Crouse	w/o
				N. Vose
83.		N. H. Emmons		6-3 7-5 6-0
			N. H. Emmons
84.		M. T. Wendall	w/o
					Thomas Slidell
85.		Subscribe now

86.

87.

88.
						Watson Washburn
89.						6-8 8-6 6-3 6-3

90.

91.		Arthur Cragin		6-4 6-4 6-2
			Arthur Cragin
92.		Ewing Stille	6-3 6-1 6-3
					Watson Washburn
93.		Elliott Middleton			6-3 6-3 6-4
			Elliott Middleton
94.		G. T. Adee	w/o
				Elliott Middleton
95.		E. H. Woods		w/o
			E. H. Woods
96.		P. R. Harrower	w/o
								Maurice McLoughlin
97.		Subscribe now						6-1 6-2 6-4

98.

99.

100.

101.

102.

103.		Edward Larned		6-4 2-6 6-2 9-11 6-1
			Edward Larned
104.		A. D. Champlin	6-0 6-0 6-1
						Maurice McLoughlin
105.		C. L. Cole				6-3 6-2 7-5
			C. L. Cole
106.		E. H. Frank	6-1 6-3 6-1
				C. L. Cole
107.		J. Billings		6-2 2-6 6-2 4-6 6-3
			J. Billings
108.		E. S. Peck	6-2 6-1 6-4
					Maurice McLoughlin
109.		Subscribe now

110.

111.

112.
							Maurice McLoughlin
113.							6-4 6-4 8-6

114.

115.		Francis Roche		6-1 6-2 6-1
			Francis Roche
116.		W. O'D. Iselin	7-5 6-2 6-3
					Suydam Cutting
117.		Stewart Cushman			6-3 6-2 6-1
			Stewart Cushman
118.		J. W. Lippincott	6-1 6-0 6-1
				Stewart Cushman
119.		Paulding Fosdick		6-1 7-5 6-1
			Paulding Fosdick
120.		F. A. Jones	6-1 6-2 6-1
						Peabody Gardner
121.		Subscribe now				6-3 6-2 6-2

122.

123.

124.

125.

126.

127.		Hugh Tallant		6-3 6-3 rtd.
			Hugh Tallant
128.		Robert Stead Jr.	6-1 6-0 6-0
										Maurice McLoughlin
129.		C. K. F. Andrews								6-4 4-6 7-5 6-3
			C. K. F. Andrews
130.		C. L. Neibel	6-0 6-3 6-2
				C. K. F. Andrews
131.		A. Lapsley		w/o
			A. Lapsley
132.		C. D. Richardson	w/o
					C. K. F. Andrews
133.		Subscribe now

134.

135.

136.
						C. K. F. Andrews
137.						6-1 6-1 2-6 6-4

138.

139.		Gardner Beals		6-2 6-2 6-3
			Gardner Beals
140.		Spencer Heaton	w/o
					J. R. Carpenter Jr.
141.		S. W. Pearson			6-1 6-1 6-4
			S. W. Pearson
142.		F. J. Hall	6-3 5-7 6-2 4-6 6-2
				S. W. Pearson
143.		W. H. Connell		7-5 2-6 8-6 6-3
			W. H. Connell
144.		C. H. W. Smith	6-1 6-3 6-1
							Beals Wright
145.		Subscribe now					6-1 6-4 4-6 6-2

146.

147.

148.

149.

150.

151.		D. C. Josephs		3-6 6-4 6-2 6-2
			D. C. Josephs
152.		L. M. Thomas	6-3 6-3 6-3
						Beals Wright
153.		Beals Wright				6-3 6-4 6-1
			Beals Wright
154.		J. G. Alexander	6-0 6-1 6-0
				Beals Wright
155.		W. P. Hunt		6-0 6-1 6-1
			W. P. Hunt
156.		J. C. Tomlinson	w/o
					Beals Wright
157.		Subscribe now

158.

159.

160.
								Beals Wright
161.								6-8 1-6 6-3 10-8 7-5

162.

163.		H. L. Ghormley		6-0 6-0 6-0
			H. L. Ghormley
164.		G. A. Thompson	w/o
					N. W. Niles
165.		G. W. Wightman			6-3 6-0 6-3
			G. W. Wightman
166.		W. F. Low	6-0 6-1 6-2
				G. W. Wightman
167.		William Williams		6-0 6-0 6-0
			William Williams
168.		L. J. Grant	6-1 6-3 6-0
						N. W. Niles
169.		Subscribe now				6-4 6-2 3-6 6-3

170.

171.

172.

173.

174.

175.		Sedgwick Minot		6-3 6-2 6-4
			Sedgwick Minot
176.		B. Marshall	6-2 6-3 6-2
							N. W. Niles
177.		J. C. Devereux					6-1 6-1 6-2
			J. C. Devereux
178.		Godwin Ordway	6-3 6-0 6-0
				J. C. Devereux
179.		E. W. Leonard		w/o
			E. W. Leonard
180.		Cyril Hatch	w/o
					J. C. Devereux
181.		Subscribe now

182.

183.

184.
						G. C. Caner
185.						6-3 6-3 6-3

186.

187.		H. D. Peck		6-4 6-1 6-0
			H. D. Peck
188.		P. Ingraham	w/o
					G. C. Caner
189.		G. C. Caner			6-4 6-2 6-2
			G. C. Caner
190.		Philip Winsor	w/o
				G. C. Caner
191.		Goelet Gallatin		6-4 6-2 6-3
			Goelet Gallatin
192.		F. J. Bassett	w/o
									Beals Wright
193.		Subscribe now							6-4 6-3 6-1

194.

195.

196.

197.

198.

199.		R. C. Seaver		6-3 6-0 7-5
			R. C. Seaver
200.		C. R. Fischer	6-1 5-7 6-3 6-4
						T. C. Bundy
201.		William Burden				6-3 6-4 6-4
			William Burden
202.		bye
				William Burden
203.		R. B. Weeden		6-1 6-0 6-0
			R. B. Weeden
204.		C. E. Cutting	w/o
					William Burden
205.		Subscribe now

206.

207.

208.
							T. C. Bundy
209.							8-6 3-6 6-8 6-1 7-5

210.

211.		Clifford Black		11-9 6-3 6-2
			Clifford Black
212.		bye
					Harry MacKinney
213.		Carlton Adams			6-4 4-6 6-2 10-8
			Carlton Adams
214.		bye
				Carlton Adams
215.		Edward Torrey		w/o
			Edward Torrey
216.		bye
						George M. Church
217.		Subscribe now				6-3 6-1 8-6

218.

219.

220.

221.

222.

223.		Quincy Adams Shaw McKean		6-1 7-5 5-7 6-2
			Quincy Adams Shaw McKean
224.		bye
								T. C. Bundy
225.		Alfred Hammett						6-3 8-6 6-3
			Alfred Hammett
226.		bye
				Alfred Hammett
227.		Stanley Henshaw		6-2 4-6 6-4 6-3
			Stanley Henshaw
228.		bye
					Alfred Hammett
229.		Subscribe now

230.

231.

232.
						C. M. Bull Jr.
233.						4-6 6-3 6-4 6-3

234.

235.		F. Pelzer		6-0 6-3 6-4
			F. Pelzer
236.		bye
					C. M. Bull Jr.
237.		C. M. Bull Jr.			6-4 6-8 6-8 7-5 6-2
			C. M. Bull Jr.
238.		bye
				C. M. Bull Jr.
239.		E. Pendergast		6-2 6-2 6-2
			E. Pendergast
240.		bye
							Jed D.E. Jones
241.		Subscribe now					6-0 8-10 6-4 6-1

242.

243.

244.

245.

246.

247.		L. R. Freeman		8-6 6-4 6-3
			L. R. Freeman
248.		bye
						Jed D.E. Jones
249.		Craig Biddle Sr.				6-4 6-0 6-0
			Craig Biddle Sr.
250.		bye
				Craig Biddle Sr.
251.		G. Nichols		6-3 6-0 6-1
			G. Nichols
252.		bye
					Jed D.E. Jones
253.		Subscribe now

254.

255.

256.

(default) 17 queries took 26 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	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` = (4)	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` = (4)	3	3	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` = (4)	2	2	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` = 'us-open' 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` = (22) ORDER BY `Contest`.`year` ASC	144	144	2
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` = '1911' 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` = (544) ORDER BY `Match`.`round_id` ASC, `Match`.`no` ASC	256	256	3
9	SELECT `Player`.`id`, `Player`.`name`, `Player`.`gender`, `Player`.`slug` FROM `zavoihu1_db4tennis`.`players` AS `Player` WHERE `Player`.`id` IN (898, 1729, 1730, 1731, 1639, 1732, 1216, 1433, 1733, 1734, 1676, 1735, 1453, 1736, 1701, 1568, 1563, 1619, 1737, 1459, 1570, 1738, 1360, 1739, 1740, 1741, 1591, 1576, 1551, 1065, 1293, 1742, 1798, 1410, 1983, 1743, 14643, 1203, 14659, 1744, 1486, 1645, 14644, 1391, 3607, 1350, 1018, 1746, 14645, 1747, 1328, 1748, 1668, 1605, 1812, 938, 14646, 1441, 14647, 1749, 14648, 1697, 1758, 1750, 1034, 1751, 1361, 1752, 14649, 1620, 1987, 1753, 1545, 1460, 1847, 1292, 1681, 1348, 1476, 1672, 14650, 1643, 1393, 1200, 973, 1447, 1831, 1754, 1451, 1152, 14652, 1382, 14651, 1377, 1592, 1755, 14653, 1534, 14654, 974, 14655, 1756, 13857, 1687, 14656, 1757, 1100, 14657, 1530, 1163, 1600, 1353, 14658, 1759, 14660, 1590, 1926, 1394, 1693, 1760, 1653, 1761, 1613, 1762, 1839, 1204, 14661, 1763, 1680, 1764, 1830, 1765, 1599, 1416, 1689, 1766, 1422, 1767, 14662, 1768, 975, 1255, 1632, 1769, 14663, 1644, 1296, 1770, 1221, 1771, 14664, 1282, 1126, 1772, 1182, 1510, 1650, 1773, 14666, 1774, 14665, 1724, 14668, 1494, 14667, 1528, 1112, 1581, 1294, 1623, 1536, 1280, 14669, 1372, 1775, 14670, 1688, 1776, 1483, 1707, 1777, 1461, 1577, 1778, 1663, 1679, 1677, 1157, 1321, 1452, 1408, 1779, 1371, 1662, 1780, 1781, 1782, 1499, 1313, 1783, 1131, 1784, 1015) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	203	203	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` = 544	203	203	2
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 196, 36)	3	3	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 196, 36)	3	3	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (898, 1729, 1730, 1731, 1639, 1732, 1216, 1433, 1733, 1734, 1676, 1735, 1453, 1736, 1701, 1568, 1563, 1619, 1737, 1459, 1570, 1738, 1360, 1739, 1740, 1741, 1591, 1576, 1551, 1065, 1293, 1742, 1798, 1410, 1983, 1743, 14643, 1203, 14659, 1744, 1486, 1645, 14644, 1391, 3607, 1350, 1018, 1746, 14645, 1747, 1328, 1748, 1668, 1605, 1812, 938, 14646, 1441, 14647, 1749, 14648, 1697, 1758, 1750, 1034, 1751, 1361, 1752, 14649, 1620, 1987, 1753, 1545, 1460, 1847, 1292, 1681, 1348, 1476, 1672, 14650, 1643, 1393, 1200, 973, 1447, 1831, 1754, 1451, 1152, 14652, 1382, 14651, 1377, 1592, 1755, 14653, 1534, 14654, 974, 14655, 1756, 13857, 1687, 14656, 1757, 1100, 14657, 1530, 1163, 1600, 1353, 14658, 1759, 14660, 1590, 1926, 1394, 1693, 1760, 1653, 1761, 1613, 1762, 1839, 1204, 14661, 1763, 1680, 1764, 1830, 1765, 1599, 1416, 1689, 1766, 1422, 1767, 14662, 1768, 975, 1255, 1632, 1769, 14663, 1644, 1296, 1770, 1221, 1771, 14664, 1282, 1126, 1772, 1182, 1510, 1650, 1773, 14666, 1774, 14665, 1724, 14668, 1494, 14667, 1528, 1112, 1581, 1294, 1623, 1536, 1280, 14669, 1372, 1775, 14670, 1688, 1776, 1483, 1707, 1777, 1461, 1577, 1778, 1663, 1679, 1677, 1157, 1321, 1452, 1408, 1779, 1371, 1662, 1780, 1781, 1782, 1499, 1313, 1783, 1131, 1784, 1015)) AND (`Playercontest`.`contest_id` = 544))	203	203	2
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	1
15	SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 1911	12	12	1
16	SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (2, 1, 17, 22, 18, 23, 24, 25, 26, 12, 19, 14) 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 26 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

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

256

SELECT `Player`.`id`, `Player`.`name`, `Player`.`gender`, `Player`.`slug` FROM `zavoihu1_db4tennis`.`players` AS `Player` WHERE `Player`.`id` IN (898, 1729, 1730, 1731, 1639, 1732, 1216, 1433, 1733, 1734, 1676, 1735, 1453, 1736, 1701, 1568, 1563, 1619, 1737, 1459, 1570, 1738, 1360, 1739, 1740, 1741, 1591, 1576, 1551, 1065, 1293, 1742, 1798, 1410, 1983, 1743, 14643, 1203, 14659, 1744, 1486, 1645, 14644, 1391, 3607, 1350, 1018, 1746, 14645, 1747, 1328, 1748, 1668, 1605, 1812, 938, 14646, 1441, 14647, 1749, 14648, 1697, 1758, 1750, 1034, 1751, 1361, 1752, 14649, 1620, 1987, 1753, 1545, 1460, 1847, 1292, 1681, 1348, 1476, 1672, 14650, 1643, 1393, 1200, 973, 1447, 1831, 1754, 1451, 1152, 14652, 1382, 14651, 1377, 1592, 1755, 14653, 1534, 14654, 974, 14655, 1756, 13857, 1687, 14656, 1757, 1100, 14657, 1530, 1163, 1600, 1353, 14658, 1759, 14660, 1590, 1926, 1394, 1693, 1760, 1653, 1761, 1613, 1762, 1839, 1204, 14661, 1763, 1680, 1764, 1830, 1765, 1599, 1416, 1689, 1766, 1422, 1767, 14662, 1768, 975, 1255, 1632, 1769, 14663, 1644, 1296, 1770, 1221, 1771, 14664, 1282, 1126, 1772, 1182, 1510, 1650, 1773, 14666, 1774, 14665, 1724, 14668, 1494, 14667, 1528, 1112, 1581, 1294, 1623, 1536, 1280, 14669, 1372, 1775, 14670, 1688, 1776, 1483, 1707, 1777, 1461, 1577, 1778, 1663, 1679, 1677, 1157, 1321, 1452, 1408, 1779, 1371, 1662, 1780, 1781, 1782, 1499, 1313, 1783, 1131, 1784, 1015) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC

203

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

203

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 196, 36)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 196, 36)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (898, 1729, 1730, 1731, 1639, 1732, 1216, 1433, 1733, 1734, 1676, 1735, 1453, 1736, 1701, 1568, 1563, 1619, 1737, 1459, 1570, 1738, 1360, 1739, 1740, 1741, 1591, 1576, 1551, 1065, 1293, 1742, 1798, 1410, 1983, 1743, 14643, 1203, 14659, 1744, 1486, 1645, 14644, 1391, 3607, 1350, 1018, 1746, 14645, 1747, 1328, 1748, 1668, 1605, 1812, 938, 14646, 1441, 14647, 1749, 14648, 1697, 1758, 1750, 1034, 1751, 1361, 1752, 14649, 1620, 1987, 1753, 1545, 1460, 1847, 1292, 1681, 1348, 1476, 1672, 14650, 1643, 1393, 1200, 973, 1447, 1831, 1754, 1451, 1152, 14652, 1382, 14651, 1377, 1592, 1755, 14653, 1534, 14654, 974, 14655, 1756, 13857, 1687, 14656, 1757, 1100, 14657, 1530, 1163, 1600, 1353, 14658, 1759, 14660, 1590, 1926, 1394, 1693, 1760, 1653, 1761, 1613, 1762, 1839, 1204, 14661, 1763, 1680, 1764, 1830, 1765, 1599, 1416, 1689, 1766, 1422, 1767, 14662, 1768, 975, 1255, 1632, 1769, 14663, 1644, 1296, 1770, 1221, 1771, 14664, 1282, 1126, 1772, 1182, 1510, 1650, 1773, 14666, 1774, 14665, 1724, 14668, 1494, 14667, 1528, 1112, 1581, 1294, 1623, 1536, 1280, 14669, 1372, 1775, 14670, 1688, 1776, 1483, 1707, 1777, 1461, 1577, 1778, 1663, 1679, 1677, 1157, 1321, 1452, 1408, 1779, 1371, 1662, 1780, 1781, 1782, 1499, 1313, 1783, 1131, 1784, 1015)) AND (`Playercontest`.`contest_id` = 544))

203

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

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