Wimbledon 1957 Ladies' Singles (June 24 - July 6)

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

2.

3.

4.

5.

6.

7.		[Q]	Gill Worrall		6-4 6-1
				Gill Worrall
8.			bye
							Louise Brough
9.			Heather Robson				7-5 6-1
				Heather Robson
10.			bye
					Heather Robson
11.			Elizabeth Broz		6-1 6-2
				Elizabeth Broz
12.			bye
						Heather Nicholls
13.			Subscribe now

14.

15.

16.
								Darlene Hard
17.		[3]						6-2 6-2

18.

19.			Rita Bentley		6-2 6-0
				Rita Bentley
20.			bye
						Darlene Hard
21.			Maria De Amorin			6-1 6-1
				Maria De Amorin
22.			bye
					Berna Thung
23.			Berna Thung		6-3 4-6 6-1
				Berna Thung
24.			bye
							Darlene Hard
25.			Subscribe now				3-6 7-5 6-3

26.

27.		[Q]

28.

29.

30.

31.			Valerie Koortzen		6-1 6-3
				Valerie Koortzen
32.			bye
									Darlene Hard
33.		[4]	Dorothy Head						6-2 6-3
				Dorothy Head
34.			Jennifer Staley	4-6 9-7 6-1
					Dorothy Head
35.			Christianne Mercelis		6-4 5-7 6-4
				Christianne Mercelis
36.			Anthea Gibb	6-2 6-0
						Dorothy Head
37.			Subscribe now

38.

39.

40.		[Q]
							Dorothy Head
41.							6-3 6-3

42.		[Q]

43.			Hanna Sladek		6-4 5-7 6-1
				Hanna Sladek
44.			Joan MacLeod	8-6 8-6
						Phyllis Edwards
45.			Pat Hird			7-5 3-6 6-4
				Pat Hird
46.			Pauline Titchener	6-1 6-1
					Pat Hird
47.			Denise Collier		6-1 6-2
				Denise Collier
48.		[Q]	Barbara Horton	6-2 6-1
								Dorothy Head
49.		[7]	Subscribe now					6-4 6-0

50.

51.

52.		[Q]

53.

54.

55.			Ilse Buding		4-6 6-3 7-5
				Ilse Buding
56.			Ruth Kaufmann	6-0 6-3
							Rosie Reyes
57.			Mimi Arnold				7-5 6-4
				Mimi Arnold
58.			Penny Burrell	6-0 6-0
					Mimi Arnold
59.			Viola White		6-4 6-0
				Viola White
60.			Sheila Macintosh	7-5 6-4
						Rosie Reyes
61.			Subscribe now

62.

63.

64.
										Althea Gibson
65.										6-3 6-2

66.

67.			Georgie Woodgate		6-1 6-4
				Georgie Woodgate
68.			Kathleen Holt	6-0 7-5
						Ruia Morrison
69.			Ruia Morrison			2-6 6-3 6-1
				Ruia Morrison
70.			Marion Craig-Smith	6-3 6-2
					Ruia Morrison
71.			Joan Curry		w/o
				Joan Curry
72.			Pilar Barril	6-4 6-3
							Betty Rosenquest
73.			Subscribe now				6-4 11-9

74.

75.

76.		[Q]

77.

78.

79.			Daphne Seeney		6-4 6-0
				Daphne Seeney
80.		[6]	Thelma Dorothy Coyne	6-8 9-7 9-7
								Christine Truman
81.			Bea Walter					9-7 5-7 6-4
				Bea Walter
82.		[Q]	Pat Ingram	6-0 8-6
					Christine Truman
83.			Christine Truman		6-3 6-2
				Christine Truman
84.			Marica Cranadak-Milonja	6-1 6-1
						Christine Truman
85.		[Q]	Subscribe now

86.

87.

88.
							Christine Truman
89.							6-3 6-3

90.

91.			Suzanne Schmidt		6-4 4-6 6-0
				Suzanne Schmidt
92.			June Fitzpatrick	6-2 6-4
						Shirley Bloomer
93.			Billie Woodgate			6-1 6-2
				Billie Woodgate
94.			Poucette Bernheim	2-6 6-2 6-0
					Shirley Bloomer
95.		[3]	Shirley Bloomer		6-0 6-1
				Shirley Bloomer
96.			Pat Ward	6-1 6-3
									Althea Gibson
97.			Subscribe now						6-1 6-1

98.

99.		[Q]

100.

101.

102.

103.			Anne Shilcock		4-6 9-7 6-4
				Anne Shilcock
104.			bye
							Sandra Reynolds Price
105.			Sheila Armstrong				6-3 8-6
				Sheila Armstrong
106.			bye
					Sheila Armstrong
107.			Rosemary Walsh		10-8 3-6 6-2
				Rosemary Walsh
108.			bye
						Sheila Armstrong
109.			Subscribe now

110.

111.		[8]

112.
								Althea Gibson
113.								6-1 6-1

114.

115.			Gem Hoahing		9-7 3-6 8-6
				Gem Hoahing
116.			bye
						Gem Hoahing
117.			Jean Knight			6-3 6-1
				Jean Knight
118.			bye
					Jean Knight
119.			Kay Newcombe		9-7 4-6 6-2
				Kay Newcombe
120.			bye
							Althea Gibson
121.			Subscribe now				6-4 6-2

122.

123.

124.

125.

126.

127.		[1]	Althea Gibson		6-4 6-4
				Althea Gibson
128.			bye

(default) 17 queries took 21 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` = 'women-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` = (19) ORDER BY `Contest`.`year` ASC	130	130	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` = 3 AND `Contest`.`category_id` = 19 AND `Contest`.`slug` = '1957' 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` = (1768) 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 (9007, 8952, 10892, 12177, 10879, 12181, 12085, 10907, 9375, 9384, 10944, 12274, 10888, 10931, 9412, 11045, 10829, 9071, 10845, 12247, 10861, 12113, 12103, 12276, 10987, 12255, 11008, 12202, 10990, 12259, 12239, 12277, 9309, 12278, 10913, 12175, 10873, 12270, 10932, 10891, 10996, 12279, 12106, 12280, 9310, 10799, 9398, 11048, 12219, 13542, 10844, 12267, 9400, 12251, 10760, 10875, 10827, 12230, 12257, 10936, 12281, 10755, 9092, 8875, 10808, 12282, 9325, 12283, 10947, 12284, 12265, 12254, 12263, 12285, 10828, 12231, 12097, 12286, 10880, 10857, 10855, 12195, 9323, 10865, 9118, 12142, 10770, 10922, 9358, 12030, 12238, 9080, 9088, 10914, 10788, 9131) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	96	96	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` = 1768	99	99	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (29, 196, 197, NULL, 21, 68, 172, 14, 212, 13, 219, 135, 173, 217, 90, 179, 84, 97, 54, 121, 36, 133, 10)	22	22	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (29, 196, 197, NULL, 21, 68, 172, 14, 212, 13, 219, 135, 173, 217, 90, 179, 84, 97, 54, 121, 36, 133, 10)	22	22	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9007, 8952, 10892, 12177, 10879, 12181, 12085, 10907, 9375, 9384, 10944, 12274, 10888, 10931, 9412, 11045, 10829, 9071, 10845, 12247, 10861, 12113, 12103, 12276, 10987, 12255, 11008, 12202, 10990, 12259, 12239, 12277, 9309, 12278, 10913, 12175, 10873, 12270, 10932, 10891, 10996, 12279, 12106, 12280, 9310, 10799, 9398, 11048, 12219, 13542, 10844, 12267, 9400, 12251, 10760, 10875, 10827, 12230, 12257, 10936, 12281, 10755, 9092, 8875, 10808, 12282, 9325, 12283, 10947, 12284, 12265, 12254, 12263, 12285, 10828, 12231, 12097, 12286, 10880, 10857, 10855, 12195, 9323, 10865, 9118, 12142, 10770, 10922, 9358, 12030, 12238, 9080, 9088, 10914, 10788, 9131)) AND (`Playercontest`.`contest_id` = 1768))	96	96	1
14	SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 19 ORDER BY `Contest`.`date_from` ASC	130	130	1
15	SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 1957	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` = 'Women' 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 21 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` = 'women-singles' LIMIT 1

130

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` = 19 AND `Contest`.`slug` = '1957' 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` = (1768) 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 (9007, 8952, 10892, 12177, 10879, 12181, 12085, 10907, 9375, 9384, 10944, 12274, 10888, 10931, 9412, 11045, 10829, 9071, 10845, 12247, 10861, 12113, 12103, 12276, 10987, 12255, 11008, 12202, 10990, 12259, 12239, 12277, 9309, 12278, 10913, 12175, 10873, 12270, 10932, 10891, 10996, 12279, 12106, 12280, 9310, 10799, 9398, 11048, 12219, 13542, 10844, 12267, 9400, 12251, 10760, 10875, 10827, 12230, 12257, 10936, 12281, 10755, 9092, 8875, 10808, 12282, 9325, 12283, 10947, 12284, 12265, 12254, 12263, 12285, 10828, 12231, 12097, 12286, 10880, 10857, 10855, 12195, 9323, 10865, 9118, 12142, 10770, 10922, 9358, 12030, 12238, 9080, 9088, 10914, 10788, 9131) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC

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

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (29, 196, 197, NULL, 21, 68, 172, 14, 212, 13, 219, 135, 173, 217, 90, 179, 84, 97, 54, 121, 36, 133, 10)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (29, 196, 197, NULL, 21, 68, 172, 14, 212, 13, 219, 135, 173, 217, 90, 179, 84, 97, 54, 121, 36, 133, 10)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9007, 8952, 10892, 12177, 10879, 12181, 12085, 10907, 9375, 9384, 10944, 12274, 10888, 10931, 9412, 11045, 10829, 9071, 10845, 12247, 10861, 12113, 12103, 12276, 10987, 12255, 11008, 12202, 10990, 12259, 12239, 12277, 9309, 12278, 10913, 12175, 10873, 12270, 10932, 10891, 10996, 12279, 12106, 12280, 9310, 10799, 9398, 11048, 12219, 13542, 10844, 12267, 9400, 12251, 10760, 10875, 10827, 12230, 12257, 10936, 12281, 10755, 9092, 8875, 10808, 12282, 9325, 12283, 10947, 12284, 12265, 12254, 12263, 12285, 10828, 12231, 12097, 12286, 10880, 10857, 10855, 12195, 9323, 10865, 9118, 12142, 10770, 10922, 9358, 12030, 12238, 9080, 9088, 10914, 10788, 9131)) AND (`Playercontest`.`contest_id` = 1768))

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

130

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

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` = 'Women' AND `Category`.`type` = 'Singles'

SELECT `Tournament`.`slug`, `Tournament`.`name` FROM `zavoihu1_db4tennis`.`tournaments` AS `Tournament` WHERE `Tournament`.`id` IN (1, 2, 3, 4)