US Open 1912 Men's Singles (August 19 - August 26)

	Nation	R256	R128	R64	R32	R16	QF	SF	F	Champion
1.		Subscribe now

2.

3.

4.

5.

6.

7.		Ezra Gould		6-1 6-1 6-4
			Ezra Gould
8.		bye
						R. N. Williams
9.		R. N. Williams				7-9 6-3 6-0 6-0
			R. N. Williams
10.		bye
				R. N. Williams
11.		N. Vose		6-0 6-3 6-2
			N. Vose
12.		bye
					R. N. Williams
13.		Subscribe now

14.

15.

16.
							R. N. Williams
17.							6-1 6-1 6-1

18.

19.		H. Stiness		w/o
			H. Stiness
20.		bye
					Walter Merrill Hall
21.		R. Gatewood			6-3 6-3 6-2
			R. Gatewood
22.		bye
				R. Gatewood
23.		H. G. Brock Smith		4-6 2-6 6-4 7-5 6-3
			H. G. Brock Smith
24.		bye
						Clifton Heard
25.		Subscribe now				6-4 7-5 7-5

26.

27.

28.

29.

30.

31.		H. E. Thomas		w/o
			H. E. Thomas
32.		bye
								Maurice McLoughlin
33.		M. S. Charlock						6-4 5-7 6-4 3-6 6-3
			M. S. Charlock
34.		bye
				M. S. Charlock
35.		Abbott Phillips		6-1 6-1 6-2
			Abbott Phillips
36.		bye
					M. S. Charlock
37.		Subscribe now

38.

39.

40.
						Henry Slocum Jr.
41.						6-2 6-0 6-2

42.

43.		Ewing Stille		6-0 6-1 6-1
			Ewing Stille
44.		bye
					Henry Slocum Jr.
45.		Richard Seabury			6-4 6-0 3-6 6-2
			Richard Seabury
46.		bye
				Richard Seabury
47.		H. Simmons		15-13 5-7 6-2 6-3
			H. Simmons
48.		bye
							Maurice McLoughlin
49.		Subscribe now					6-1 6-4 6-2

50.

51.

52.

53.

54.

55.		F. McNair		6-0 6-2 6-1
			F. McNair
56.		bye
						Maurice McLoughlin
57.		J. Montgomery				6-1 6-2 6-3
			J. Montgomery
58.		bye
				J. Montgomery
59.		William Williams		6-3 6-4 6-2
			William Williams
60.		bye
					J. Montgomery
61.		Subscribe now

62.

63.

64.
									Maurice McLoughlin
65.									8-6 6-2 3-6 6-4

66.

67.		Geoffrey Taylor		6-2 6-1 6-1
			Geoffrey Taylor
68.		bye
					M. T. Whiting
69.		M. T. Whiting			2-6 4-6 6-2 12-10 13-11
			M. T. Whiting
70.		bye
				M. T. Whiting
71.		E. W. Leonard		w/o
			E. W. Leonard
72.		bye
						Whiting Preston
73.		Subscribe now				9-7 6-4 6-3

74.

75.

76.

77.

78.

79.		Roberton Griswold		6-1 6-2 6-4
			Roberton Griswold
80.		bye
							W. J. Clothier
81.		C. L. Frailey					6-1 6-1 6-1
			C. L. Frailey
82.		bye
				C. L. Frailey
83.		C. Amory		w/o
			C. Amory
84.		bye
					Gardner Beals
85.		Subscribe now

86.

87.

88.
						W. J. Clothier
89.						6-1 8-6 6-0

90.

91.		Preston Gibson		6-1 6-2 6-1
			Preston Gibson
92.		bye
					W. J. Clothier
93.		W. J. Clothier			7-5 6-4 12-10
			W. J. Clothier
94.		bye
				W. J. Clothier
95.		John Reece		6-0 6-1 6-0
			John Reece
96.		bye
								W. J. Clothier
97.		Subscribe now						7-5 6-0 6-1

98.

99.

100.

101.

102.

103.		G. C. Caner		6-2 6-1 6-2
			G. C. Caner
104.		Heinrich Kleinschroth	4-6 9-7 6-2 6-2
						Peabody Gardner
105.		N. W. Niles				6-3 4-6 4-6 6-1 6-3
			N. W. Niles
106.		Harry MacKinney	6-2 6-0 6-0
				N. W. Niles
107.		E. Pendergast		w/o
			E. Pendergast
108.		A. D. Champlin	6-1 6-3 6-1
					N. W. Niles
109.		Subscribe now

110.

111.

112.
							Raymond Little
113.							6-4 7-5 6-2

114.

115.		William D. Bourne		w/o
			William D. Bourne
116.		Charles Beck	6-4 6-3 3-6 3-6 6-3
					Richard Stevens
117.		Richard Stevens			6-4 6-4 6-4
			Richard Stevens
118.		J. R. Quinn	6-0 6-0 6-2
				Richard Stevens
119.		C. Jones		w/o
			C. Jones
120.		F. Easton Jr.	6-3 6-1 6-3
						Raymond Little
121.		Subscribe now				6-0 6-1 6-0

122.

123.

124.

125.

126.

127.		S. Miller		w/o
			S. Miller
128.		W. H. Connell	w/o
										Maurice McLoughlin
129.		Edmond Peaslee								3-6 2-6 6-2 6-4 6-2
			Edmond Peaslee
130.		E. Rogers	w/o
				Edmond Peaslee
131.		A. Devens		w/o
			A. Devens
132.		R. McCloud	1-6 6-2 6-2 6-4
					Witham McKim
133.		Subscribe now

134.

135.

136.
						T. C. Bundy
137.						6-0 6-2 6-4

138.

139.		Harold Beyer		6-0 6-0 6-1
			Harold Beyer
140.		E. Miller	w/o
					T. C. Bundy
141.		T. C. Bundy			6-0 6-0 6-2
			T. C. Bundy
142.		G. T. Adee	w/o
				T. C. Bundy
143.		Ralph Baggs		6-3 6-1 6-1
			Ralph Baggs
144.		Richard Harte	w/o
							George M. Church
145.		Subscribe now					w/o

146.

147.

148.

149.

150.

151.		R. C. Crouse		6-3 6-2 6-3
			R. C. Crouse
152.		G. McKinney	7-5 6-4 6-0
						George M. Church
153.		Suydam Cutting				6-4 4-6 6-1 4-6 6-1
			Suydam Cutting
154.		E. H. Frank	w/o
				Suydam Cutting
155.		Arthur Cragin		7-5 6-3 9-7
			Arthur Cragin
156.		Roland Hazard	6-4 3-6 6-4 6-2
					Suydam Cutting
157.		Subscribe now

158.

159.

160.
								Karl Behr
161.								6-2 6-2 6-0

162.

163.		S. L. Smith		6-1 6-2 6-3
			S. L. Smith
164.		bye
					Karl Behr
165.		Alfred Hammett			6-2 8-6 6-4
			Alfred Hammett
166.		bye
				Alfred Hammett
167.		C. Leonard		w/o
			C. Leonard
168.		bye
						Karl Behr
169.		Subscribe now				6-3 6-2 6-2

170.

171.

172.

173.

174.

175.		Frederick Frelinghuysen		w/o
			Frederick Frelinghuysen
176.		bye
							Karl Behr
177.		Charles Rogers					7-5 6-4 6-4
			Charles Rogers
178.		bye
				Charles Rogers
179.		William Dean		6-0 6-1 6-4
			William Dean
180.		bye
					Charles Rogers
181.		Subscribe now

182.

183.

184.
						Charles Rogers
185.						6-3 6-0 6-1

186.

187.		R. Thayer		6-3 6-2 6-1
			R. Thayer
188.		bye
					C. Porter
189.		C. Porter			2-6 6-4 6-2 7-5
			C. Porter
190.		bye
				C. Porter
191.		Phillip Roberts		6-2 2-6 8-6 6-3
			Phillip Roberts
192.		bye
									Wallace Johnson
193.		Subscribe now							4-6 6-0 6-3 6-2

194.

195.

196.

197.

198.

199.		William M Tilden		6-2 6-3 6-4
			William M Tilden
200.		bye
						Wallace Johnson
201.		Frank Paul				6-3 6-0 6-1
			Frank Paul
202.		bye
				Frank Paul
203.		Murray Taylor		6-1 6-3 6-4
			Murray Taylor
204.		bye
					J. R. Carpenter Jr.
205.		Subscribe now

206.

207.

208.
							Wallace Johnson
209.							6-4 6-2 6-1

210.

211.		J. Downey		w/o
			J. Downey
212.		bye
					Alfred Dabney
213.		Alfred Dabney			4-6 6-1 6-8 6-3 6-2
			Alfred Dabney
214.		bye
				Alfred Dabney
215.		Fred Harris		w/o
			Fred Harris
216.		bye
						Alfred Dabney
217.		Subscribe now				6-1 6-4 4-6 2-6 6-2

218.

219.

220.

221.

222.

223.		A. Sands		6-3 6-2 6-2
			A. Sands
224.		bye
								Wallace Johnson
225.		H. C. Johnson						8-6 6-2 3-6 6-3
			H. C. Johnson
226.		bye
				H. C. Johnson
227.		G. Phillips		6-1 6-4 6-1
			G. Phillips
228.		bye
					H. C. Johnson
229.		Subscribe now

230.

231.

232.
						Watson Washburn
233.						4-6 6-2 6-3 9-7

234.

235.		Harold Taylor		w/o
			Harold Taylor
236.		bye
					Watson Washburn
237.		W. B. Izard			2-6 6-1 7-5 6-4
			W. B. Izard
238.		bye
				W. B. Izard
239.		Frederick Feitshans		8-6 6-1 6-2
			Frederick Feitshans
240.		bye
							Watson Washburn
241.		Subscribe now					10-12 6-4 6-1 6-3

242.

243.

244.

245.

246.

247.		H. E. Colton		w/o
			H. E. Colton
248.		bye
						R. C. Seaver
249.		H. Ewer				6-1 6-2 6-3
			H. Ewer
250.		bye
				H. Ewer
251.		W. E. Heyl		6-4 6-3 6-3
			W. E. Heyl
252.		bye
					R. C. Seaver
253.		Subscribe now

254.

255.

256.

(default) 17 queries took 35 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	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` = (4)	3	3	3
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	4
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	6
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` = '1912' 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` = (545) ORDER BY `Match`.`round_id` ASC, `Match`.`no` ASC	255	255	3
9	SELECT `Player`.`id`, `Player`.`name`, `Player`.`gender`, `Player`.`slug` FROM `zavoihu1_db4tennis`.`players` AS `Player` WHERE `Player`.`id` IN (1313, 1194, 1785, 965, 1786, 1605, 21, 1613, 1747, 1242, 1787, 1624, 1788, 1789, 1790, 1749, 1510, 1791, 1792, 1793, 898, 1034, 1794, 1459, 1732, 1795, 1643, 1796, 1797, 1768, 1798, 1799, 1800, 1801, 1773, 1282, 1541, 1802, 1803, 1710, 1545, 1714, 1353, 1804, 1292, 1805, 1182, 1806, 1807, 13853, 1808, 1372, 1534, 1385, 1724, 4427, 1416, 1483, 1662, 1681, 1809, 13854, 1639, 13855, 1576, 2147, 1600, 1734, 1018, 3599, 1682, 13856, 1203, 1570, 1676, 13857, 1065, 13858, 10959, 1590, 1737, 13859, 1375, 13860, 1810, 1730, 1760, 13861, 1563, 1767, 1518, 13862, 1623, 1361, 1811, 1910, 1577, 1149, 1743, 1392, 1679, 13863, 1812, 13864, 1447, 1476, 1750, 1641, 1435, 13865, 1461, 1350, 1097, 1677, 1780, 1814, 1528, 1815, 1693, 1655, 1816, 1817, 1818, 1819, 1820, 1821, 1822, 1753, 1592, 1408, 14090, 1619, 1824, 1163, 1825, 1152, 1524, 1460, 1645, 1664, 1622, 1536, 1433, 1530, 1826, 1718, 1827, 1697, 1828, 1782, 1829, 1157, 1204, 1771, 1830, 1235, 1831, 1280, 1832, 13559, 1813) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	161	161	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` = 545	163	163	3
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 135, 72, 196)	4	4	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 135, 72, 196)	4	4	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (1313, 1194, 1785, 965, 1786, 1605, 21, 1613, 1747, 1242, 1787, 1624, 1788, 1789, 1790, 1749, 1510, 1791, 1792, 1793, 898, 1034, 1794, 1459, 1732, 1795, 1643, 1796, 1797, 1768, 1798, 1799, 1800, 1801, 1773, 1282, 1541, 1802, 1803, 1710, 1545, 1714, 1353, 1804, 1292, 1805, 1182, 1806, 1807, 13853, 1808, 1372, 1534, 1385, 1724, 4427, 1416, 1483, 1662, 1681, 1809, 13854, 1639, 13855, 1576, 2147, 1600, 1734, 1018, 3599, 1682, 13856, 1203, 1570, 1676, 13857, 1065, 13858, 10959, 1590, 1737, 13859, 1375, 13860, 1810, 1730, 1760, 13861, 1563, 1767, 1518, 13862, 1623, 1361, 1811, 1910, 1577, 1149, 1743, 1392, 1679, 13863, 1812, 13864, 1447, 1476, 1750, 1641, 1435, 13865, 1461, 1350, 1097, 1677, 1780, 1814, 1528, 1815, 1693, 1655, 1816, 1817, 1818, 1819, 1820, 1821, 1822, 1753, 1592, 1408, 14090, 1619, 1824, 1163, 1825, 1152, 1524, 1460, 1645, 1664, 1622, 1536, 1433, 1530, 1826, 1718, 1827, 1697, 1828, 1782, 1829, 1157, 1204, 1771, 1830, 1235, 1831, 1280, 1832, 13559, 1813)) AND (`Playercontest`.`contest_id` = 545))	161	161	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` = 1912	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	0

(default) 17 queries took 35 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` = '1912' 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` = (545) ORDER BY `Match`.`round_id` ASC, `Match`.`no` ASC

255

SELECT `Player`.`id`, `Player`.`name`, `Player`.`gender`, `Player`.`slug` FROM `zavoihu1_db4tennis`.`players` AS `Player` WHERE `Player`.`id` IN (1313, 1194, 1785, 965, 1786, 1605, 21, 1613, 1747, 1242, 1787, 1624, 1788, 1789, 1790, 1749, 1510, 1791, 1792, 1793, 898, 1034, 1794, 1459, 1732, 1795, 1643, 1796, 1797, 1768, 1798, 1799, 1800, 1801, 1773, 1282, 1541, 1802, 1803, 1710, 1545, 1714, 1353, 1804, 1292, 1805, 1182, 1806, 1807, 13853, 1808, 1372, 1534, 1385, 1724, 4427, 1416, 1483, 1662, 1681, 1809, 13854, 1639, 13855, 1576, 2147, 1600, 1734, 1018, 3599, 1682, 13856, 1203, 1570, 1676, 13857, 1065, 13858, 10959, 1590, 1737, 13859, 1375, 13860, 1810, 1730, 1760, 13861, 1563, 1767, 1518, 13862, 1623, 1361, 1811, 1910, 1577, 1149, 1743, 1392, 1679, 13863, 1812, 13864, 1447, 1476, 1750, 1641, 1435, 13865, 1461, 1350, 1097, 1677, 1780, 1814, 1528, 1815, 1693, 1655, 1816, 1817, 1818, 1819, 1820, 1821, 1822, 1753, 1592, 1408, 14090, 1619, 1824, 1163, 1825, 1152, 1524, 1460, 1645, 1664, 1622, 1536, 1433, 1530, 1826, 1718, 1827, 1697, 1828, 1782, 1829, 1157, 1204, 1771, 1830, 1235, 1831, 1280, 1832, 13559, 1813) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC

161

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

163

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (1313, 1194, 1785, 965, 1786, 1605, 21, 1613, 1747, 1242, 1787, 1624, 1788, 1789, 1790, 1749, 1510, 1791, 1792, 1793, 898, 1034, 1794, 1459, 1732, 1795, 1643, 1796, 1797, 1768, 1798, 1799, 1800, 1801, 1773, 1282, 1541, 1802, 1803, 1710, 1545, 1714, 1353, 1804, 1292, 1805, 1182, 1806, 1807, 13853, 1808, 1372, 1534, 1385, 1724, 4427, 1416, 1483, 1662, 1681, 1809, 13854, 1639, 13855, 1576, 2147, 1600, 1734, 1018, 3599, 1682, 13856, 1203, 1570, 1676, 13857, 1065, 13858, 10959, 1590, 1737, 13859, 1375, 13860, 1810, 1730, 1760, 13861, 1563, 1767, 1518, 13862, 1623, 1361, 1811, 1910, 1577, 1149, 1743, 1392, 1679, 13863, 1812, 13864, 1447, 1476, 1750, 1641, 1435, 13865, 1461, 1350, 1097, 1677, 1780, 1814, 1528, 1815, 1693, 1655, 1816, 1817, 1818, 1819, 1820, 1821, 1822, 1753, 1592, 1408, 14090, 1619, 1824, 1163, 1825, 1152, 1524, 1460, 1645, 1664, 1622, 1536, 1433, 1530, 1826, 1718, 1827, 1697, 1828, 1782, 1829, 1157, 1204, 1771, 1830, 1235, 1831, 1280, 1832, 13559, 1813)) AND (`Playercontest`.`contest_id` = 545))

161

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

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)