Wimbledon 1955 Gentlemen's Singles (June 20 - July 1)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[2]	Subscribe now

2.

3.

4.

5.

6.

7.			Josip Palada		6-4 6-3 6-3
				Josip Palada
8.			Jose-Maria Draper	4-6 6-2 6-3 6-1
							Ken Rosewall
9.			Mike Davies				6-4 6-1 2-1 rtd.
				Mike Davies
10.		[Q]	Clive Bernstein	6-1 6-1 6-4
					Mike Davies
11.			Wayne Van Voorhess		6-4 6-2 10-8
				Wayne Van Voorhess
12.			Carlos Figueira	6-0 6-1 6-1
						Giuseppe Merlo
13.		[Q]	Subscribe now

14.

15.

16.
								Ken Rosewall
17.		[8]						6-4 6-1 6-2

18.

19.			Enrique Morea		6-4 6-4 6-2
				Enrique Morea
20.			Arthur Gubb	6-2 8-6 6-1
						Sven Davidson
21.			Franz Saiko			6-3 6-3 2-6 4-6 6-3
				Franz Saiko
22.			Tony Pickard	4-6 7-5 6-4 4-6 6-3
					William Knight
23.			William Knight		6-3 6-2 6-2
				William Knight
24.			Gino Mezzi	w/o
							Sven Davidson
25.			Subscribe now				4-6 6-1 7-5 6-4

26.

27.

28.		[Q]

29.

30.

31.			Luis Ayala		6-2 6-1 6-3
				Luis Ayala
32.			Cedric Mason	6-2 6-3 7-5
									Kurt Nielsen
33.		[3]	Vic Seixas						11-9 6-2 2-6 6-4
				Vic Seixas
34.			Anthony Clayton	6-3 6-0 6-0
					Gilbert Shea
35.			Gilbert Shea		3-6 6-4 6-4 4-6 6-4
				Gilbert Shea
36.			Torsten Johansson	4-6 6-1 4-6 6-3 6-4
						Gilbert Shea
37.		[LL]	Subscribe now

38.

39.

40.
							Nicola Pietrangeli
41.							2-6 6-4 6-4 6-4

42.

43.			Tony Mottram		7-5 5-7 11-9 5-7 6-2
				Tony Mottram
44.			Gardnar Mulloy	6-1 6-4 6-1
						Nicola Pietrangeli
45.			Colin Hannam			1-6 6-4 7-5 6-4
				Colin Hannam
46.		[Q]	Jeffrey Robinson	6-4 6-3 6-1
					John Ager
47.			John Ager		6-1 6-3 6-8 6-1
				John Ager
48.			John Ward	4-6 6-0 6-2 6-4
								Kurt Nielsen
49.		[5]	Subscribe now					1-6 6-3 5-7 6-2 7-5

50.

51.

52.

53.

54.

55.			Alejo Russell		6-3 6-2 6-0
				Alejo Russell
56.			Ivor Warwick	3-6 6-1 6-4 7-5
							Kurt Nielsen
57.		[Q]	Richard Potter				4-6 6-1 6-4 6-3
				Richard Potter
58.		[Q]	Howard Walton	6-2 6-4 7-5
					Kurt Nielsen
59.			Kurt Nielsen		4-6 6-2 6-2 9-7
				Kurt Nielsen
60.			Arthur Marshall	6-2 6-4 8-6
						Kurt Nielsen
61.			Subscribe now

62.		[Q]

63.		[Q]

64.
										Tony Trabert
65.										6-3 7-5 6-1

66.

67.			Ilija Panajotovic		6-4 6-4 3-6 6-3
				Ilija Panajotovic
68.			Rafiq Ahmad	6-2 6-3 6-4
						Herbert Flam
69.			Gordon Forbes			4-6 6-2 6-4 6-2
				Gordon Forbes
70.			Lennart Bergelin	4-6 2-6 6-2 12-10 9-7
					Herbert Flam
71.			Herbert Flam		w/o
				Herbert Flam
72.			Robert Bedard	6-3 6-2 6-2
							Budge Patty
73.			Subscribe now				6-1 6-3 4-6 1-6 6-4

74.

75.

76.

77.		[Q]

78.

79.		[7]	Budge Patty		6-0 6-4 6-3
				Budge Patty
80.		[Q]	George Druliner	6-4 6-3 6-1
								Budge Patty
81.			Arthur Larsen					6-4 6-4 6-4
				Arthur Larsen
82.			Orlando Sirola	6-4 7-5 6-3
					Arthur Larsen
83.			Malcolm Fox		6-2 7-5 7-5
				Malcolm Fox
84.			Istvan Sikorszky	11-9 6-3 8-6
						Arthur Larsen
85.			Subscribe now

86.

87.

88.
							Lew Hoad
89.							6-4 6-4 6-8 6-3

90.

91.			Geoffrey Paish		6-4 6-4 6-3
				Geoffrey Paish
92.			Claude Molinari	3-6 6-4 6-1 5-7 6-3
						Lew Hoad
93.			Philippe Washer			6-3 6-3 6-4
				Philippe Washer
94.			Eric Filby	6-3 8-10 6-0 6-3
					Lew Hoad
95.		[4]	Lew Hoad		6-1 6-3 6-2
				Lew Hoad
96.			Bob Howe	7-5 7-5 6-2
									Tony Trabert
97.			Subscribe now						8-6 6-2 6-2

98.

99.

100.

101.

102.

103.			John Horn		6-3 4-0 rtd.
				John Horn
104.		[LL]	Jack D. Forbes	6-3 6-4 6-2
							Jaroslav Drobny
105.			Robert Haillet				8-6 6-3 6-4
				Robert Haillet
106.			Gordon Mudge	6-3 6-4 6-0
					Jack Arkinstall
107.			Jack Arkinstall		6-3 7-9 7-5 4-6 6-4
				Jack Arkinstall
108.			Alan Mills	6-2 6-3 6-2
						Jaroslav Drobny
109.			Subscribe now

110.

111.		[6]

112.
								Tony Trabert
113.								8-6 6-1 6-4

114.

115.			Ian Vermaak		6-1 6-1 6-1
				Ian Vermaak
116.			Andres Hammersley	4-6 6-3 6-4 6-3
						Naresh Kumar
117.			Naresh Kumar			6-3 6-2 3-6 9-7
				Naresh Kumar
118.			Isaias Pimentel	6-3 6-1 8-6
					Naresh Kumar
119.			Bill Gilmour		3-6 6-4 8-6 6-2
				Bill Gilmour
120.			Joseph Hackett	6-0 6-4 6-1
							Tony Trabert
121.			Subscribe now				6-4 6-2 6-2

122.

123.

124.

125.

126.

127.		[1]	Tony Trabert		6-1 6-2 6-2
				Tony Trabert
128.			Mal Anderson	6-3 6-4 6-2

(default) 17 queries took 25 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` = 'wimbledon' 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` = (3)	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` = (3)	4	4	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` = (3)	57	57	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` = 'wimbledon' 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` = (17) ORDER BY `Contest`.`year` ASC	137	137	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` = 3 AND `Contest`.`category_id` = 17 AND `Contest`.`slug` = '1955' 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` = (477) 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 (653, 3088, 612, 2860, 2945, 6692, 2658, 6698, 694, 6623, 4885, 6699, 6700, 4704, 3071, 2960, 2885, 669, 2804, 6701, 6691, 681, 3109, 4811, 3147, 6690, 4855, 3008, 3347, 4961, 2946, 674, 675, 3094, 706, 2847, 6636, 4695, 474, 2983, 722, 693, 2799, 615, 4932, 3085, 2751, 6726, 646, 6678, 2871, 6688, 680, 4715, 2734, 6689, 771, 4753, 2943, 6702, 4902, 3397, 6704, 6584, 6657, 6666, 4879, 4974, 3315, 697, 712, 3006, 2760, 4968, 3072, 4996, 3351, 6686, 2708, 6705, 657, 4858, 2883, 4954, 688, 4951, 6681, 2968, 3329, 6673, 2835, 2918, 2787, 2640, 650, 632, 683, 6646, 6622, 6687, 4893, 2906, 2884, 13631, 3107, 6710, 677, 3354, 633, 692, 642, 4809, 3050, 4796, 4839, 2778, 2874, 3198, 690, 3404, 2836, 661, 2879, 4874, 737, 3016, 685, 684) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	128	128	2
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` = 477	128	128	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (13, 196, 21, 197, 172, 133, 87, 178, 149, 92, 84, 72, 14, 10, 201, 219, 54, 198, 68, 88, 188, 173, 86, 212, 41, 141, 90, 36, 150, 59, 179)	31	31	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (13, 196, 21, 197, 172, 133, 87, 178, 149, 92, 84, 72, 14, 10, 201, 219, 54, 198, 68, 88, 188, 173, 86, 212, 41, 141, 90, 36, 150, 59, 179)	31	31	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (653, 3088, 612, 2860, 2945, 6692, 2658, 6698, 694, 6623, 4885, 6699, 6700, 4704, 3071, 2960, 2885, 669, 2804, 6701, 6691, 681, 3109, 4811, 3147, 6690, 4855, 3008, 3347, 4961, 2946, 674, 675, 3094, 706, 2847, 6636, 4695, 474, 2983, 722, 693, 2799, 615, 4932, 3085, 2751, 6726, 646, 6678, 2871, 6688, 680, 4715, 2734, 6689, 771, 4753, 2943, 6702, 4902, 3397, 6704, 6584, 6657, 6666, 4879, 4974, 3315, 697, 712, 3006, 2760, 4968, 3072, 4996, 3351, 6686, 2708, 6705, 657, 4858, 2883, 4954, 688, 4951, 6681, 2968, 3329, 6673, 2835, 2918, 2787, 2640, 650, 632, 683, 6646, 6622, 6687, 4893, 2906, 2884, 13631, 3107, 6710, 677, 3354, 633, 692, 642, 4809, 3050, 4796, 4839, 2778, 2874, 3198, 690, 3404, 2836, 661, 2879, 4874, 737, 3016, 685, 684)) AND (`Playercontest`.`contest_id` = 477))	128	128	1
14	SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 17 ORDER BY `Contest`.`date_from` ASC	137	137	1
15	SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 1955	20	20	1
16	SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (2, 3, 1, 12, 17, 22, 13, 18, 23, 4, 7, 14, 24, 25, 26, 19, 15, 16, 20, 21) 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 25 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` = 'wimbledon' 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` = (3)

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

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

137

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` = 3 AND `Contest`.`category_id` = 17 AND `Contest`.`slug` = '1955' 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` = (477) 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 (653, 3088, 612, 2860, 2945, 6692, 2658, 6698, 694, 6623, 4885, 6699, 6700, 4704, 3071, 2960, 2885, 669, 2804, 6701, 6691, 681, 3109, 4811, 3147, 6690, 4855, 3008, 3347, 4961, 2946, 674, 675, 3094, 706, 2847, 6636, 4695, 474, 2983, 722, 693, 2799, 615, 4932, 3085, 2751, 6726, 646, 6678, 2871, 6688, 680, 4715, 2734, 6689, 771, 4753, 2943, 6702, 4902, 3397, 6704, 6584, 6657, 6666, 4879, 4974, 3315, 697, 712, 3006, 2760, 4968, 3072, 4996, 3351, 6686, 2708, 6705, 657, 4858, 2883, 4954, 688, 4951, 6681, 2968, 3329, 6673, 2835, 2918, 2787, 2640, 650, 632, 683, 6646, 6622, 6687, 4893, 2906, 2884, 13631, 3107, 6710, 677, 3354, 633, 692, 642, 4809, 3050, 4796, 4839, 2778, 2874, 3198, 690, 3404, 2836, 661, 2879, 4874, 737, 3016, 685, 684) 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` = 477

128

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (13, 196, 21, 197, 172, 133, 87, 178, 149, 92, 84, 72, 14, 10, 201, 219, 54, 198, 68, 88, 188, 173, 86, 212, 41, 141, 90, 36, 150, 59, 179)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (13, 196, 21, 197, 172, 133, 87, 178, 149, 92, 84, 72, 14, 10, 201, 219, 54, 198, 68, 88, 188, 173, 86, 212, 41, 141, 90, 36, 150, 59, 179)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (653, 3088, 612, 2860, 2945, 6692, 2658, 6698, 694, 6623, 4885, 6699, 6700, 4704, 3071, 2960, 2885, 669, 2804, 6701, 6691, 681, 3109, 4811, 3147, 6690, 4855, 3008, 3347, 4961, 2946, 674, 675, 3094, 706, 2847, 6636, 4695, 474, 2983, 722, 693, 2799, 615, 4932, 3085, 2751, 6726, 646, 6678, 2871, 6688, 680, 4715, 2734, 6689, 771, 4753, 2943, 6702, 4902, 3397, 6704, 6584, 6657, 6666, 4879, 4974, 3315, 697, 712, 3006, 2760, 4968, 3072, 4996, 3351, 6686, 2708, 6705, 657, 4858, 2883, 4954, 688, 4951, 6681, 2968, 3329, 6673, 2835, 2918, 2787, 2640, 650, 632, 683, 6646, 6622, 6687, 4893, 2906, 2884, 13631, 3107, 6710, 677, 3354, 633, 692, 642, 4809, 3050, 4796, 4839, 2778, 2874, 3198, 690, 3404, 2836, 661, 2879, 4874, 737, 3016, 685, 684)) AND (`Playercontest`.`contest_id` = 477))

128

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

137

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

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