US Open 1907 Men's Singles (August 20 - August 28)

	Nation	R128	R64	R32	R16	QF	SF	F	CH	Champion
1.		Subscribe now							W. J. Clothier
									last year champion
2.

3.

4.

5.

6.

7.		Wylie Grant		w/o
			Wylie Grant
8.		bye
						H. Westfall
9.		G. H. Nettleton				6-2 6-3 6-3
			G. H. Nettleton
10.		bye
				G. H. Nettleton
11.		H. Foster		w/o
			H. Foster
12.		bye
					H. Westfall
13.		Subscribe now

14.

15.

16.
							William Larned
17.							6-4 6-1 6-0

18.

19.		Frederick Colston		6-2 6-2 4-6 8-6
			Frederick Colston
20.		George Wagner	6-2 6-3 6-3
					William Larned
21.		Ephrom Catlin			6-0 6-3 6-3
			Ephrom Catlin
22.		George Richardson	6-4 6-2 6-0
				William Larned
23.		William Larned		6-0 6-0 6-2
			William Larned
24.		Theodore R. Pell	6-4 6-2 6-1
						William Larned
25.		Subscribe now				6-1 6-3 6-2

26.

27.

28.

29.

30.

31.		G. Thomas Jr.		6-0 6-4 4-6 6-4
			G. Thomas Jr.
32.		R. Hodges	6-4 6-4 6-1
								William Larned		William Larned
33.		Clarence Hobart						6-2 6-2 6-1		w/o
			Clarence Hobart
34.		Henry Slocum Jr.	4-6 6-2 6-4 6-4
				Clarence Hobart
35.		Harold Beyer		6-0 6-3 6-2
			Harold Beyer
36.		Ludwig Von Salm	w/o
					Clarence Hobart
37.		Subscribe now

38.

39.

40.
						Clarence Hobart
41.						6-4 7-5 6-2

42.

43.		C. M. Bull Jr.		6-3 6-8 6-1 6-4
			C. M. Bull Jr.
44.		J. Downey	7-5 6-1 7-5
					C. M. Bull Jr.
45.		T. Potter			6-1 6-2 6-1
			T. Potter
46.		Lynford Biddle	w/o
				T. Potter
47.		W. Bigelow		4-6 6-1 6-3 5-7 6-2
			W. Bigelow
48.		F. J. Otis	w/o
							Clarence Hobart
49.		Subscribe now					6-4 6-3 5-7 5-7 6-2

50.

51.

52.

53.

54.

55.		A. Hoskins		6-2 6-2 6-4
			A. Hoskins
56.		Jed D.E. Jones	w/o
						Wallace Johnson
57.		H. C. Johnson				6-0 2-6 6-3 6-4
			H. C. Johnson
58.		H. Hitchcock	6-0 3-6 6-2 6-2
				Frederick Anderson
59.		Frederick Anderson		6-3 7-5 3-6 3-6 6-2
			Frederick Anderson
60.		J. R. Carpenter Jr.	6-3 1-6 6-1 6-1
					Frederick Anderson
61.		Subscribe now

62.

63.

64.
									William Larned
65.									6-2 6-2 6-4

66.

67.		Edward Torrey		6-1 6-4 6-4
			Edward Torrey
68.		Merwin White	w/o
					F. C. Inman
69.		G. Kobbe			6-0 6-1 6-4
			G. Kobbe
70.		John Thomas	5-7 1-6 6-2 6-3 6-1
				L. W. Scott
71.		L. W. Scott		7-5 6-2 7-5
			L. W. Scott
72.		Whiting Preston	8-6 6-3 6-2
						Henry Mollenhauer
73.		Subscribe now				6-4 6-4 1-6 6-0

74.

75.

76.

77.

78.

79.		Cowan Rodgers		6-0 6-1 6-1
			Cowan Rodgers
80.		Harry MacKinney	6-8 4-6 6-3 6-4 6-1
							Henry Mollenhauer
81.		G. T. Adee					6-4 11-9 6-0 6-4
			G. T. Adee
82.		C. L. Frailey	6-4 6-2 6-2
				Nat Thornton
83.		Nat Thornton		6-3 6-2 8-6
			Nat Thornton
84.		Ewing Stille	w/o
					Nat Thornton
85.		Subscribe now

86.

87.

88.
						Leroy Russ
89.						9-11 6-1 6-1 6-3

90.

91.		Leroy Russ		6-3 6-3 6-3
			Leroy Russ
92.		William Fischer	6-1 6-1 10-8
					Leroy Russ
93.		Harold Plummer			6-4 6-4 4-6 5-7 6-4
			Harold Plummer
94.		Seymour Johnson	6-1 6-2 6-3
				Gardner Beals
95.		Gardner Beals		2-6 2-6 6-3 6-2 8-6
			Gardner Beals
96.		Beals Wright	w/o
								Robert LeRoy
97.		Subscribe now						4-6 6-4 1-6 8-6 6-0

98.

99.

100.

101.

102.

103.		G. F. Parrish		6-2 6-1 6-4
			G. F. Parrish
104.		H. Cross	3-6 7-5 4-6 7-5 6-0
						C. Palmer
105.		E. Page				5-7 8-6 8-6 4-6 6-2
			E. Page
106.		Paulding Fosdick	6-2 6-2 6-3
				J. Ames
107.		J. Ames		6-2 6-4 6-3
			J. Ames
108.		J. Ross	6-3 6-2 6-1
					N. W. Niles
109.		Subscribe now

110.

111.

112.
							Robert LeRoy
113.							6-0 6-2 6-2

114.

115.		Walter Howe		w/o
			Walter Howe
116.		bye
					Robert LeRoy
117.		Harold Sands			6-1 6-4 6-4
			Harold Sands
118.		bye
				Artimus Holmes
119.		Artimus Holmes		1-6 6-1 4-6 6-4 6-4
			Artimus Holmes
120.		bye
						Robert LeRoy
121.		Subscribe now				6-3 6-1 6-4

122.

123.

124.

125.

126.

127.		Richard Lovering		6-2 6-1 6-2
			Richard Lovering
128.		bye

(default) 17 queries took 27 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	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` = '1907' LIMIT 1	1	1	1
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` = (540) ORDER BY `Match`.`round_id` ASC, `Match`.`no` ASC	128	128	2
9	SELECT `Player`.`id`, `Player`.`name`, `Player`.`gender`, `Player`.`slug` FROM `zavoihu1_db4tennis`.`players` AS `Player` WHERE `Player`.`id` IN (1509, 1510, 1511, 1120, 1393, 1253, 1512, 1140, 1500, 1513, 1252, 1514, 1392, 1515, 1397, 1516, 1015, 1200, 1100, 1464, 1157, 1203, 1095, 975, 1056, 1517, 971, 898, 1518, 4418, 1520, 1521, 1435, 1522, 1523, 1439, 1371, 1524, 1525, 1526, 1527, 1315, 1216, 1528, 1460, 1431, 1408, 1529, 1373, 1131, 1530, 1531, 13588, 1163, 1532, 1533, 1534, 1535, 1536, 1476, 1461, 1537, 1538, 1539, 1540, 1541, 1037, 1472, 1542, 1543, 1421, 1318, 1544, 1483, 1361, 1545, 1546, 1034, 973, 1422, 1467, 1294, 1495, 1380, 1547, 1548, 1218, 1549, 1353, 1204, 1550, 1350, 1152, 1088, 1286, 1075, 1551, 1552, 1489, 1382, 1410, 1477, 1416, 1553, 974, 1554, 1285, 1321, 1555, 1396, 1556, 1106, 1557, 1558, 1470, 1182) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	116	116	6
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` = 540	116	116	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 14)	2	2	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 14)	2	2	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (1509, 1510, 1511, 1120, 1393, 1253, 1512, 1140, 1500, 1513, 1252, 1514, 1392, 1515, 1397, 1516, 1015, 1200, 1100, 1464, 1157, 1203, 1095, 975, 1056, 1517, 971, 898, 1518, 4418, 1520, 1521, 1435, 1522, 1523, 1439, 1371, 1524, 1525, 1526, 1527, 1315, 1216, 1528, 1460, 1431, 1408, 1529, 1373, 1131, 1530, 1531, 13588, 1163, 1532, 1533, 1534, 1535, 1536, 1476, 1461, 1537, 1538, 1539, 1540, 1541, 1037, 1472, 1542, 1543, 1421, 1318, 1544, 1483, 1361, 1545, 1546, 1034, 973, 1422, 1467, 1294, 1495, 1380, 1547, 1548, 1218, 1549, 1353, 1204, 1550, 1350, 1152, 1088, 1286, 1075, 1551, 1552, 1489, 1382, 1410, 1477, 1416, 1553, 974, 1554, 1285, 1321, 1555, 1396, 1556, 1106, 1557, 1558, 1470, 1182)) AND (`Playercontest`.`contest_id` = 540))	116	116	1
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` = 1907	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 27 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` = '1907' 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` = (540) ORDER BY `Match`.`round_id` ASC, `Match`.`no` ASC

128

SELECT `Player`.`id`, `Player`.`name`, `Player`.`gender`, `Player`.`slug` FROM `zavoihu1_db4tennis`.`players` AS `Player` WHERE `Player`.`id` IN (1509, 1510, 1511, 1120, 1393, 1253, 1512, 1140, 1500, 1513, 1252, 1514, 1392, 1515, 1397, 1516, 1015, 1200, 1100, 1464, 1157, 1203, 1095, 975, 1056, 1517, 971, 898, 1518, 4418, 1520, 1521, 1435, 1522, 1523, 1439, 1371, 1524, 1525, 1526, 1527, 1315, 1216, 1528, 1460, 1431, 1408, 1529, 1373, 1131, 1530, 1531, 13588, 1163, 1532, 1533, 1534, 1535, 1536, 1476, 1461, 1537, 1538, 1539, 1540, 1541, 1037, 1472, 1542, 1543, 1421, 1318, 1544, 1483, 1361, 1545, 1546, 1034, 973, 1422, 1467, 1294, 1495, 1380, 1547, 1548, 1218, 1549, 1353, 1204, 1550, 1350, 1152, 1088, 1286, 1075, 1551, 1552, 1489, 1382, 1410, 1477, 1416, 1553, 974, 1554, 1285, 1321, 1555, 1396, 1556, 1106, 1557, 1558, 1470, 1182) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC

116

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

116

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (1509, 1510, 1511, 1120, 1393, 1253, 1512, 1140, 1500, 1513, 1252, 1514, 1392, 1515, 1397, 1516, 1015, 1200, 1100, 1464, 1157, 1203, 1095, 975, 1056, 1517, 971, 898, 1518, 4418, 1520, 1521, 1435, 1522, 1523, 1439, 1371, 1524, 1525, 1526, 1527, 1315, 1216, 1528, 1460, 1431, 1408, 1529, 1373, 1131, 1530, 1531, 13588, 1163, 1532, 1533, 1534, 1535, 1536, 1476, 1461, 1537, 1538, 1539, 1540, 1541, 1037, 1472, 1542, 1543, 1421, 1318, 1544, 1483, 1361, 1545, 1546, 1034, 973, 1422, 1467, 1294, 1495, 1380, 1547, 1548, 1218, 1549, 1353, 1204, 1550, 1350, 1152, 1088, 1286, 1075, 1551, 1552, 1489, 1382, 1410, 1477, 1416, 1553, 974, 1554, 1285, 1321, 1555, 1396, 1556, 1106, 1557, 1558, 1470, 1182)) AND (`Playercontest`.`contest_id` = 540))

116

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

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)