Roland Garros 1999 Women's Singles (May 24 - June 6)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Martina Hingis
				Martina Hingis
2.			Amanda Hopmans	6-1 6-4
					Martina Hingis
3.			Amelie Mauresmo		6-3 6-3
				Amelie Mauresmo
4.		[11]	Tara Snyder	6-3 6-3
						Martina Hingis
5.			Kveta Hrdlickova			6-3 6-4
				Kveta Hrdlickova
6.			Larisa Savchenko	6-4 6-1
					Kveta Hrdlickova
7.			Barbara Rittner		6-4 7-6(5)
				Barbara Rittner
8.			Magui Serna	3-6 7-6(5) 6-2
							Martina Hingis
9.			Ruxandra Dragomir				6-3 7-6(5)
				Ruxandra Dragomir
10.			Rita Grande	7-6(0) 6-1
					Ruxandra Dragomir
11.			Anne Kremer		6-4 6-2
				Anne Kremer
12.			Maureen Drake	6-2 6-3
						Ruxandra Dragomir
13.			Mariaan De Swardt			6-2 3-6 6-3
				Mariaan De Swardt
14.		[Q]	Miroslava Vavrinec	6-0 6-4
					Mariaan De Swardt
15.		[12]	Sandrine Testud		6-3 6-2
				Sandrine Testud
16.		[Q]	Sandra Nacuk	3-6 6-3 6-1
								Martina Hingis
17.		[Q]	Barbara Schwartz					6-2 6-2
				Barbara Schwartz
18.		[13]	Dominique Monami	6-1 6-0
					Barbara Schwartz
19.			Kristie Boogert		6-2 6-4
				Kristie Boogert
20.		[Q]	Anna Maria Foldenyi	6-1 6-4
						Barbara Schwartz
21.		[LL]	Elena Dementieva			6-2 6-1
				Elena Dementieva
22.			Laura Golarsa	6-1 6-4
					Nathalie Dechy
23.			Nathalie Dechy		6-2 1-6 7-5
				Nathalie Dechy
24.		[WC]	Stephanie Foretz	6-7(14) 7-6(1) 6-1
							Barbara Schwartz
25.			Alicia Molik				2-6 7-6(7) 6-3
				Alicia Molik
26.			Brenda Schultz	3-6 6-3 6-2
					Alicia Molik
27.		[WC]	Emmanuelle Curutchet		6-2 6-2
				Emmanuelle Curutchet
28.		[WC]	Jelena Dokic	7-6(5) 3-6 11-9
						Venus Williams
29.			Natasha Zvereva			6-3 6-1
				Natasha Zvereva
30.			Christina Papadaki	6-3 7-5
					Venus Williams
31.		[5]	Venus Williams		7-6(3) 6-0
				Venus Williams
32.			Alexandra Fusai	6-1 6-1
									Martina Hingis
33.		[4]	Jana Novotna						6-3 6-2
				Jana Novotna
34.			Ludmila Cervanova	6-2 7-6(4)
					Jana Novotna
35.			Adriana Gersi		6-3 6-2
				Adriana Gersi
36.			Marlene Weingartner	6-4 6-0
						Jana Novotna
37.			Silvija Talaja			6-4 3-6 6-4
				Silvija Talaja
38.			Audrey Sidot	6-3 6-4
					Silvija Talaja
39.			Chanda Rubin		2-6 6-1 6-4
				Chanda Rubin
40.			Miriam Oremans	6-0 6-3
							Sylvia Plischke
41.			Emmanuelle Gagliardi				6-3 7-6(5)
				Emmanuelle Gagliardi
42.			Nicole Pratt	6-2 6-2
					Sylvia Plischke
43.			Sylvia Plischke		6-1 6-3
				Sylvia Plischke
44.		[Q]	Meilen Tu	6-1 6-1
						Sylvia Plischke
45.			Kimberly Po			7-6(1) 6-4
				Kimberly Po
46.			Denisa Chladkova	7-6(5) 6-3
					Barbara Schett
47.		[15]	Barbara Schett		6-3 3-6 6-1
				Barbara Schett
48.			Henrieta Nagyova	6-1 6-2
								Arantxa Sanchez-Vicario
49.		[10]	Serena Williams					6-2 6-4
				Serena Williams
50.			Laurence Courtois	6-4 6-0
					Serena Williams
51.			Mariana Diaz-Oliva		6-3 6-4
				Mariana Diaz-Oliva
52.			Jolene Watanabe	6-2 6-0
						Mary Joe Fernandez
53.		[WC]	Lea Ghirardi			6-3 1-6 6-0
				Lea Ghirardi
54.			Tatiana Panova	6-7(2) 6-4 7-5
					Mary Joe Fernandez
55.			Mary Joe Fernandez		6-1 6-3
				Mary Joe Fernandez
56.			Alexia Dechaume	6-3 6-2
							Arantxa Sanchez-Vicario
57.			Irina Spirlea				w/o
				Irina Spirlea
58.			Catalina Cristea	6-4 6-1
					Irina Spirlea
59.			Olga Barabanschikova		6-3 6-3
				Olga Barabanschikova
60.			Meghann Shaughnessy	6-4 3-6 6-1
						Arantxa Sanchez-Vicario
61.			Katarina Srebotnik			6-4 6-1
				Katarina Srebotnik
62.		[WC]	Laurence Andretto	6-1 6-0
					Arantxa Sanchez-Vicario
63.		[7]	Arantxa Sanchez-Vicario		6-1 6-1
				Arantxa Sanchez-Vicario
64.			Mirjana Lucic	6-2 6-2
										Steffi Graf
65.		[8]	Mary Pierce							4-6 7-5 6-2
				Mary Pierce
66.			Joanette Kruger	6-4 6-3
					Conchita Martinez
67.			Conchita Martinez		4-6 6-3 6-3
				Conchita Martinez
68.			Cara Black	2-6 6-3 6-3
						Conchita Martinez
69.			Els Callens			6-2 7-5
				Els Callens
70.			Shi-Ting Wang	6-4 6-1
					Anna Smashnova
71.			Anna Smashnova		6-0 6-0
				Anna Smashnova
72.			Sonya Jeyaseelan	2-6 6-1 6-3
							Conchita Martinez
73.			Elena Likhovtseva				6-2 6-1
				Elena Likhovtseva
74.			Katarina Studenikova	6-3 4-6 6-1
					Elena Likhovtseva
75.			Paola Suarez		6-2 3-6 6-4
				Paola Suarez
76.			Emilie Loit	6-3 6-2
						Gala Leon Garcia
77.			Gala Leon Garcia			7-6(3) 7-6(3)
				Gala Leon Garcia
78.			Rita Kuti-Kis	6-4 6-1
					Gala Leon Garcia
79.		[9]	Nathalie Tauziat		6-2 6-4
				Nathalie Tauziat
80.			Amelie Cocheteux	6-4 6-3
								Monica Seles
81.		[16]	Julie Halard					6-1 6-4
				Julie Halard
82.			Karina Habsudova	1-6 6-4 6-1
					Julie Halard
83.			Elena Pampoulova		4-6 6-1 6-2
				Elena Pampoulova
84.			Samantha Smith	6-1 7-6(6)
						Julie Halard
85.			Andrea Glass			7-5 4-6 6-4
				Andrea Glass
86.			Lisa Raymond	6-4 7-5
					Cristina Torrens-Valero
87.			Cristina Torrens-Valero		6-4 1-6 6-1
				Cristina Torrens-Valero
88.		[WC]	Sophie Georges	6-3 6-4
							Monica Seles
89.			Raluca Sandu				6-1 7-5
				Raluca Sandu
90.			Brie Rippner	5-7 6-4 6-3
					Maria Sanchez Lorenzo
91.			Maria Sanchez Lorenzo		6-2 6-1
				Maria Sanchez Lorenzo
92.			Miho Saeki	6-7(4) 6-4 6-0
						Monica Seles
93.			Lubomira Bacheva			6-1 6-4
				Lubomira Bacheva
94.		[WC]	Virginie Razzano	6-3 6-4
					Monica Seles
95.		[3]	Monica Seles		6-3 6-4
				Monica Seles
96.			Fang Li	6-2 6-4
									Steffi Graf
97.		[6]	Steffi Graf						6-7(2) 6-3 6-4
				Steffi Graf
98.			Magdalena Maleeva	6-2 6-0
					Steffi Graf
99.		[Q]	Ines Gorrochategui		6-2 6-4
				Ines Gorrochategui
100.			Seda Noorlander	3-6 6-3 6-2
						Steffi Graf
101.			Adriana Serra-Zanetti			6-1 6-4
				Adriana Serra-Zanetti
102.		[Q]	Pavlina Stoyanova	6-2 6-4
					Asa Carlsson
103.			Asa Carlsson		6-3 7-6(2)
				Asa Carlsson
104.			Sabine Appelmans	6-2 7-5
							Steffi Graf
105.			Anna Kournikova				6-3 7-6(4)
				Anna Kournikova
106.			Tamarine Tanasugarn	6-3 6-3
					Anna Kournikova
107.			Amy Frazier		6-4 6-1
				Amy Frazier
108.			Elena Tatarkova	6-4 6-2
						Anna Kournikova
109.			Nicole Arendt			6-1 3-6 6-0
				Nicole Arendt
110.		[WC]	Sophie Lefevre	6-3 7-5
					Patty Schnyder
111.			Patty Schnyder		6-4 6-2
				Patty Schnyder
112.			Corina Morariu	3-6 6-3 8-6
								Steffi Graf
113.			Ai Sugiyama					6-1 6-7(5) 6-3
				Ai Sugiyama
114.		[14]	Amanda Coetzer	7-5 6-1
					Silvia Farina
115.			Silvia Farina		6-4 6-7(4) 11-9
				Silvia Farina
116.			Evgenia Koulikovskaya	6-0 7-5
						Jennifer Capriati
117.			Jennifer Capriati			6-2 4-0 rtd.
				Jennifer Capriati
118.			Virginia Ruano-Pascual	6-2 6-3
					Jennifer Capriati
119.			Lilia Osterloh		6-3 3-6 6-2
				Lilia Osterloh
120.			Janet Lee	6-4 2-6 7-5
							Lindsay Davenport
121.			Fabiola Zuluaga				6-2 6-3
				Fabiola Zuluaga
122.			Sarah Pitkowski	6-2 7-5
					Fabiola Zuluaga
123.			Jana Nejedly		6-3 6-0
				Jana Nejedly
124.			Maria Vento-Kabchi	6-4 3-6 6-0
						Lindsay Davenport
125.		[Q]	Justine Henin			7-6(5) 6-3
				Justine Henin
126.			Kristina Brandi	6-4 6-2
					Lindsay Davenport
127.		[2]	Lindsay Davenport		6-3 2-6 7-5
				Lindsay Davenport
128.			Jane Chi	6-3 6-1

(default) 17 queries took 22 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` = 'roland-garros' 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` = (2)	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` = (2)	5	5	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` = (2)	5	5	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` = 'roland-garros' 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` = (14) ORDER BY `Contest`.`year` ASC	117	117	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` = 2 AND `Contest`.`category_id` = 14 AND `Contest`.`slug` = '1999' 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` = (1290) 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 (10078, 10196, 10152, 10135, 10156, 9750, 9967, 10111, 10063, 10098, 10128, 9934, 10074, 10185, 9990, 10195, 10167, 10012, 10048, 10004, 10174, 9896, 10116, 10297, 10172, 9863, 11389, 10173, 9945, 10044, 10151, 10026, 9848, 10184, 10117, 10157, 10122, 10143, 9985, 9953, 10130, 9937, 10153, 10126, 9991, 10133, 10077, 10129, 10150, 10037, 10146, 10058, 10089, 10145, 9909, 9873, 10050, 10059, 10137, 10147, 10180, 10207, 9957, 10149, 10024, 10023, 9885, 10160, 10068, 10028, 10062, 10094, 10064, 10054, 10119, 10165, 10114, 10169, 10017, 10155, 9829, 9946, 9928, 9992, 10141, 10039, 10123, 11394, 10166, 10164, 10090, 10112, 10189, 10187, 9974, 9987, 9715, 9959, 9999, 10162, 10095, 10188, 10101, 9936, 10113, 10115, 9845, 10134, 9983, 11395, 10356, 10121, 10070, 10018, 10049, 10298, 9997, 10055, 10175, 10086, 10198, 10084, 10092, 10105, 10179, 10124, 10025, 10159) 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` = 1290	128	128	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (20, 43, 197, 72, 181, 201, 179, 173, 68, 194, 184, 50, 94, 10, 168, 31, 169, 153, 196, 91, 92, 14, 133, 104, 13, 74, 154, 53, 36, 219, 21, 42, 172, 111, 84, 178, 151, 207)	38	38	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (20, 43, 197, 72, 181, 201, 179, 173, 68, 194, 184, 50, 94, 10, 168, 31, 169, 153, 196, 91, 92, 14, 133, 104, 13, 74, 154, 53, 36, 219, 21, 42, 172, 111, 84, 178, 151, 207)	38	38	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (10078, 10196, 10152, 10135, 10156, 9750, 9967, 10111, 10063, 10098, 10128, 9934, 10074, 10185, 9990, 10195, 10167, 10012, 10048, 10004, 10174, 9896, 10116, 10297, 10172, 9863, 11389, 10173, 9945, 10044, 10151, 10026, 9848, 10184, 10117, 10157, 10122, 10143, 9985, 9953, 10130, 9937, 10153, 10126, 9991, 10133, 10077, 10129, 10150, 10037, 10146, 10058, 10089, 10145, 9909, 9873, 10050, 10059, 10137, 10147, 10180, 10207, 9957, 10149, 10024, 10023, 9885, 10160, 10068, 10028, 10062, 10094, 10064, 10054, 10119, 10165, 10114, 10169, 10017, 10155, 9829, 9946, 9928, 9992, 10141, 10039, 10123, 11394, 10166, 10164, 10090, 10112, 10189, 10187, 9974, 9987, 9715, 9959, 9999, 10162, 10095, 10188, 10101, 9936, 10113, 10115, 9845, 10134, 9983, 11395, 10356, 10121, 10070, 10018, 10049, 10298, 9997, 10055, 10175, 10086, 10198, 10084, 10092, 10105, 10179, 10124, 10025, 10159)) AND (`Playercontest`.`contest_id` = 1290))	128	128	2
14	SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 14 ORDER BY `Contest`.`date_from` ASC	117	117	1
15	SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 1999	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, 18, 13, 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 22 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` = 'roland-garros' 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` = (2)

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` = (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`, `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` = 'roland-garros' AND `Category`.`slug` = 'women-singles' LIMIT 1

117

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` = 2 AND `Contest`.`category_id` = 14 AND `Contest`.`slug` = '1999' 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` = (1290) 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 (10078, 10196, 10152, 10135, 10156, 9750, 9967, 10111, 10063, 10098, 10128, 9934, 10074, 10185, 9990, 10195, 10167, 10012, 10048, 10004, 10174, 9896, 10116, 10297, 10172, 9863, 11389, 10173, 9945, 10044, 10151, 10026, 9848, 10184, 10117, 10157, 10122, 10143, 9985, 9953, 10130, 9937, 10153, 10126, 9991, 10133, 10077, 10129, 10150, 10037, 10146, 10058, 10089, 10145, 9909, 9873, 10050, 10059, 10137, 10147, 10180, 10207, 9957, 10149, 10024, 10023, 9885, 10160, 10068, 10028, 10062, 10094, 10064, 10054, 10119, 10165, 10114, 10169, 10017, 10155, 9829, 9946, 9928, 9992, 10141, 10039, 10123, 11394, 10166, 10164, 10090, 10112, 10189, 10187, 9974, 9987, 9715, 9959, 9999, 10162, 10095, 10188, 10101, 9936, 10113, 10115, 9845, 10134, 9983, 11395, 10356, 10121, 10070, 10018, 10049, 10298, 9997, 10055, 10175, 10086, 10198, 10084, 10092, 10105, 10179, 10124, 10025, 10159) 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` = 1290

128

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (20, 43, 197, 72, 181, 201, 179, 173, 68, 194, 184, 50, 94, 10, 168, 31, 169, 153, 196, 91, 92, 14, 133, 104, 13, 74, 154, 53, 36, 219, 21, 42, 172, 111, 84, 178, 151, 207)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (20, 43, 197, 72, 181, 201, 179, 173, 68, 194, 184, 50, 94, 10, 168, 31, 169, 153, 196, 91, 92, 14, 133, 104, 13, 74, 154, 53, 36, 219, 21, 42, 172, 111, 84, 178, 151, 207)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (10078, 10196, 10152, 10135, 10156, 9750, 9967, 10111, 10063, 10098, 10128, 9934, 10074, 10185, 9990, 10195, 10167, 10012, 10048, 10004, 10174, 9896, 10116, 10297, 10172, 9863, 11389, 10173, 9945, 10044, 10151, 10026, 9848, 10184, 10117, 10157, 10122, 10143, 9985, 9953, 10130, 9937, 10153, 10126, 9991, 10133, 10077, 10129, 10150, 10037, 10146, 10058, 10089, 10145, 9909, 9873, 10050, 10059, 10137, 10147, 10180, 10207, 9957, 10149, 10024, 10023, 9885, 10160, 10068, 10028, 10062, 10094, 10064, 10054, 10119, 10165, 10114, 10169, 10017, 10155, 9829, 9946, 9928, 9992, 10141, 10039, 10123, 11394, 10166, 10164, 10090, 10112, 10189, 10187, 9974, 9987, 9715, 9959, 9999, 10162, 10095, 10188, 10101, 9936, 10113, 10115, 9845, 10134, 9983, 11395, 10356, 10121, 10070, 10018, 10049, 10298, 9997, 10055, 10175, 10086, 10198, 10084, 10092, 10105, 10179, 10124, 10025, 10159)) AND (`Playercontest`.`contest_id` = 1290))

128

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

117

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

SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (2, 3, 1, 12, 17, 22, 18, 13, 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)