back to overall

Wimbledon 1897 Gentlemen's Singles  (June 21 - June 30)

NationR32R16QFSFFCHChampion
1.United Kingdom (GBR)
Subscribe now
Harold Mahony
last year champion
2.United Kingdom (GBR)
3.United Kingdom (GBR)
4.United Kingdom (GBR)
5.United Kingdom (GBR)
6.United Kingdom (GBR)
7.United Kingdom (GBR)Alfred Taylor6-2 6-2 6-1
Alfred Taylor
8.United Kingdom (GBR)Henry Evered6-1 6-3 3-6 3-6 6-4
Wilberforce EavesReginald Doherty
9.United Kingdom (GBR)Turketil Greville6-2 5-7 1-6 6-2 6-16-4 6-4 6-3
Turketil Greville
10.United Kingdom (GBR)Arthur Norris6-2 6-2 6-1
Turketil Greville
11.United Kingdom (GBR)Arthur Gorew/o
Arthur Gore
12.United Kingdom (GBR)J. Stone7-5 6-2 6-3
Wilberforce Eaves
13.United Kingdom (GBR)
Subscribe now
14.United Kingdom (GBR)
15.United Kingdom (GBR)
16.United Kingdom (GBR)
Reginald Doherty
17.United Kingdom (GBR)6-3 7-5 2-0 rtd.
18.United Kingdom (GBR)
19.United Kingdom (GBR)Wilfred Baddeley6-2 6-2 7-5
Wilfred Baddeley
20.United Kingdom (GBR)David Hawesw/o
Wilfred Baddeley
21.United Kingdom (GBR)Alfred Crawley6-4 6-2 6-2
Alfred Crawley
22.United Kingdom (GBR)Archdale Palmerw/o
Lawrence Doherty
23.United Kingdom (GBR)Lawrence Doherty6-0 6-2 7-5
Lawrence Doherty
24.United Kingdom (GBR)Herbert Baddeley6-4 6-4 8-6
Reginald Doherty
25.United Kingdom (GBR)
Subscribe now
6-3 6-0 6-3
26.United Kingdom (GBR)
27.United Kingdom (GBR)
28.United Kingdom (GBR)
29.United Kingdom (GBR)
30.Ireland (IRL)
31.United Kingdom (GBR)Josiah Ritchie6-3 6-2 6-1
Josiah Ritchie
32.bye
(default) 17 queries took 20 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `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 1111
2SELECT `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)551
3SELECT `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)441
4SELECT `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)57571
5SELECT `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 1111
6SELECT `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` ASC1371374
7SELECT `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` = '1897' LIMIT 1111
8SELECT `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` = (429) ORDER BY `Match`.`round_id` ASC, `Match`.`no` ASC32321
9SELECT `Player`.`id`, `Player`.`name`, `Player`.`gender`, `Player`.`slug` FROM `zavoihu1_db4tennis`.`players` AS `Player` WHERE `Player`.`id` IN (5420, 5438, 1411, 5415, 5398, 5439, 5440, 5441, 5430, 5442, 1263, 5443, 1214, 5444, 5427, 5428, 1201, 5433, 5402, 5437, 5407, 5409, 1329, 5406, 1339, 5422, 5379, 5446, 5426, 1114, 1443, 1198) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC32321
10SELECT `Playercontest`.`id`, `Playercontest`.`player_id`, `Playercontest`.`contest_id`, `Playercontest`.`nat_id`, `Playercontest`.`draw` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE `Playercontest`.`contest_id` = 42932321
11SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (90, 196)221
12SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (90, 196)221
13SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (5420, 5438, 1411, 5415, 5398, 5439, 5440, 5441, 5430, 5442, 1263, 5443, 1214, 5444, 5427, 5428, 1201, 5433, 5402, 5437, 5407, 5409, 1329, 5406, 1339, 5422, 5379, 5446, 5426, 1114, 1443, 1198)) AND (`Playercontest`.`contest_id` = 429))32321
14SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 17 ORDER BY `Contest`.`date_from` ASC1371371
15SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 189710101
16SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (22, 17, 18, 23, 24, 25, 26, 12, 19, 14) AND `Category`.`gender` = 'Men' AND `Category`.`type` = 'Singles'331
17SELECT `Tournament`.`slug`, `Tournament`.`name` FROM `zavoihu1_db4tennis`.`tournaments` AS `Tournament` WHERE `Tournament`.`id` IN (2, 3, 4)331