Buscando

SELECT t1.name, case when t1.gender='M' then 'Male' when t1.gender='W' then 'Female' else '' end as gender, t2.country, t1.cat,t1.time, t3.marathon, t3.date FROM `results` t1 left join `countries` t2 on (t1.country=t2.id) left join `races` t3 on (t1.idrace=t3.id) WHERE t1.name like '%%' ORDER BY t1.time limit 0,100
Mostrando los primeros 100 resultados...

N°	Nombre	Género	País	Categoría	Tiempo	Maratón	Fecha
1	Lee Warden	Male			00:00:00	Farnham Pilgrims - England	2020-09-13
2	Stephen Elliott Nicholls	Male			00:00:00	Farnham Pilgrims - England	2020-09-13
3	Peter Tucker	Male			00:00:00	Farnham Pilgrims - England	2020-09-13
4	James Adams	Male		40-49	00:00:00	Farnham Pilgrims - England	2020-09-13
5	Carlo Fabio Marcel Calcagni		Italy		01:05:49	Venice - Italy	2020-11-01
6	Katia Aere		Italy		01:17:40	Venice - Italy	2020-11-01
7	Tiziano Monti		Italy		01:25:11	Venice - Italy	2020-11-01
8	Francesco Pizzo		Italy		01:25:16	Venice - Italy	2020-11-01
9	Francesca Caruso		Italy		01:25:32	Venice - Italy	2020-11-01
10	Giulia Ruffato		Italy		01:31:44	Venice - Italy	2020-11-01
11	Annalisa Baraldo		Italy		01:33:05	Venice - Italy	2020-11-01
12	Andrea Meschiari		Italy		01:35:42	Venice - Italy	2020-11-01
13	Laura Roccasalva Firenze		Italy		01:40:29	Venice - Italy	2020-11-01
14	Guglielmo Capolino		Italy		01:58:05	Venice - Italy	2020-11-01
15	Brian Siemann	Male	United States	30-39	02:00:13	Walt Disney World - USA	2020-03-11
16	Kristian Jones	Male	Australia	30-39	02:01:30	Sydney - Australia	2020-11-08
17	Eliud Kipchoge	Male	Kenya	30-39	02:01:39	Berlin - Germany	2018-09-16
18	Kenenisa Bekele	Male	Ethiopia	30-39	02:01:41	Berlin - Germany	2019-09-29
19	Eliud Kipchoge	Male	Kenya	18-39	02:02:37	London - Great Britain	2019-04-28
20	Birhanu Legese	Male	Ethiopia	20-29	02:02:48	Berlin - Germany	2019-09-29
21	Mosinet Geremew	Male	Ethiopia	18-39	02:02:55	London - Great Britain	2019-04-28
22	Mauro Preziosa		Italy		02:03:00	Venice - Italy	2020-11-01
23	Kenenisa Bekele	Male	Ethiopia	30-39	02:03:03	Berlin - Germany	2016-09-25
24	Wilson Kipsang	Male	Kenya	30-39	02:03:13	Berlin - Germany	2016-09-25
25	Mule Wasihun	Male	Ethiopia	18-39	02:03:16	London - Great Britain	2019-04-28
26	Eliud Kipchoge	Male	Kenya	30-39	02:03:32	Berlin - Germany	2017-09-24
27	Sisay Lemma	Male	Ethiopia	20-29	02:03:36	Berlin - Germany	2019-09-29
28	Guye Adola	Male	Ethiopia		02:03:46	Berlin - Germany	2017-09-24
29	Kinde Atanaw Alayew	Male	Ethiopia		02:03:50	Valencia - Spain	2019-12-01
30	Kipchoge, Eliud	Male	Kenya	30-39	02:04:00	Berlin - Germnay	2015-09-27
31	Lawrence Cherono	Male	Kenya	18-34	02:04:06	Amsterdam - Netherlands	2018-10-21
32	Marius Kipserem	Male	Kenya	19-34	02:04:11	Rotterdam - Netherland	2019-04-07
33	Kaan Kigen Ozbilen	Male	Turkey		02:04:16	Valencia - Spain	2019-12-01
34	Eliud Kipchoge	Male	Kenya		02:04:30	NN Mission - Netherlands	2021-04-18
35	Piero Quaia		Italy		02:04:36	Venice - Italy	2020-11-01
36	Mule Wasihun	Male	Ethiopia	18-34	02:04:37	Amsterdam - Netherlands	2018-10-21
37	Solomon Deksisa	Male	Ethiopia	18-34	02:04:40	Amsterdam - Netherlands	2018-10-21
38	Guye Idemo Adola	Male	Ethiopia		02:04:41	Valencia - Spain	2019-12-01
39	Kipchoge, Eliud	Male	Kenya	18-39	02:04:42	London - Great Britain	2015-04-26
40	Birhanu Legese	Male	Ethiopia	20-29	02:04:46	Tokyo - Japan	2019-03-03
41	Mekuant Ayenew Gebre	Male	Ethiopia		02:04:46	Sevilla - Spain	2020-02-23
42	Kipsang, Wilson	Male	Kenya	18-39	02:04:47	London - Great Britain	2015-04-26
43	Abebe Negewo Degefa	Male	Ethiopia		02:04:50	Valencia - Spain	2019-12-01
44	Chebet Evans Kiplagat	Male	Kenya	20-29	02:05:00	Buenos Aires - Argentina	2019-09-22
45	Philemon Rono	Male	Kenya	20-29	02:05:00	Toronto - Canada	2019-10-20
46	Tola Shura Kitata	Male	Ethiopia	18-39	02:05:01	London - Great Britain	2019-04-28
47	Kiptanui, Eliud	Male	Kenya	20-29	02:05:02	Berlin - Germnay	2015-09-27
48	Korir,mark	Male			02:05:04	Paris	2015-04-12
49	Barnabas Kiptum	Male	Kenya		02:05:05	Sevilla - Spain	2020-02-23
50	Vincent Kipchumba	Male	Kenya	Msen	02:05:09	Amsterdam - Netherlands	2019-10-19
51	Lemi Berhanu	Male	Ethiopia	20-29	02:05:09	Toronto - Canada	2019-10-20
52	Lawrence Cherono	Male	Kenya		02:05:09	Amsterdam - Netherlands	2017-10-15
53	Norbert Kigen	Male	Kenya		02:05:10	Amsterdam - Netherlands	2017-10-15
54	Mo Farah	Male	Great Britain	30-39	02:05:11	Chicago - USA	2018-10-07
55	Filex Chemonges	Male	Uganda	20-29	02:05:12	Toronto - Canada	2019-10-20
56	Benson Kipruto	Male	Kenya	20-29	02:05:13	Toronto - Canada	2019-10-20
57	Sammy Kirop Kitwara	Male	Kenya		02:05:15	Valencia - Spain	2017-11-19
58	Solomon Deksisa	Male	Ethiopia	Msen	02:05:16	Amsterdam - Netherlands	2019-10-19
59	Elisha Rotich	Male	Kenya	Msen	02:05:18	Amsterdam - Netherlands	2019-10-19
60	Kipyego Reuben Kipop	Male	Kenya	20-29	02:05:18	Buenos Aires - Argentina	2019-09-22
61	Kipkemboi Saina Emmanuel	Male	Kenya	20-29	02:05:20	Buenos Aires - Argentina	2018-09-23
62	Daniel Wanjiru	Male			02:05:20	Amsterdam - Netherlands	2016-10-16
63	Mosinet Geremew Bayih	Male	Ethiopia	20-29	02:05:24	Chicago - USA	2018-10-07
64	Kaan Özbilen	Male	Turkey	19-34	02:05:26	Rotterdam - Netherland	2019-04-07
65	Abraham Kiptum	Male	Kenya		02:05:26	Amsterdam - Netherlands	2017-10-15
66	Betesfa Getahun	Male	Ethiopia	Msen	02:05:27	Amsterdam - Netherlands	2019-10-19
67	Dickson Chumba	Male	Kenya	30-39	02:05:29	Tokyo - Japan	2018-02-25
68	Evans Kiplagat Chebet	Male	Kenya		02:05:30	Valencia - Spain	2017-11-19
69	Evans Chebet	Male	Kenya	20-29	02:05:31	Berlin - Germany	2016-09-25
70	Mule Wasihun	Male	Ethiopia		02:05:39	Amsterdam - Netherlands	2017-10-15
71	Mo Farah	Male	Great Britain	18-39	02:05:39	London - Great Britain	2019-04-28
72	Emanuel Saina	Male	Kenya	19-34	02:05:42	Rotterdam - Netherland	2019-04-07
73	Amos Kipruto	Male	Kenya		02:05:43	Amsterdam - Netherlands	2017-10-15
74	Kenneth Kipkemoi	Male	Kenya		02:05:44	Rotterdam - Netherlands	2018-04-08
75	Brace Clement	Male			02:05:44	Marine Corps - USA	2020-10-25
76	Lawrence Cherono	Male	Kenya	30-34	02:05:45	Chicago - USA	2019-10-13
77	Sammy Kitwara	Male			02:05:45	Amsterdam - Netherlands	2016-10-16
78	Dejene Debela	Male	Ethiopia	20-24	02:05:46	Chicago - USA	2019-10-13
79	Marius Kimutai	Male			02:05:47	Amsterdam - Netherlands	2016-10-16
80	Asefa Mengstu	Male	Ethiopia	30-34	02:05:48	Chicago - USA	2019-10-13
81	Gideon Kipketer	Male	Kenya	20-29	02:05:49	Tokyo - Japan	2017-02-26
82	Abera Kuma	Male	Kenya		02:05:50	Rotterdam - Netherlands	2018-04-08
83	Suguru Osako	Male	Japan	20-29	02:05:50	Chicago - USA	2018-10-07
84	Kimetto, Dennis	Male	Kenya	18-39	02:05:50	London - Great Britain	2015-04-26
85	Bedan Karoki	Male	Kenya	25-29	02:05:53	Chicago - USA	2019-10-13
86	Laban Korir	Male			02:05:54	Amsterdam - Netherlands	2016-10-16
87	Kelkile Gezahegn	Male	Ethiopia		02:05:56	Rotterdam - Netherlands	2018-04-08
88	Kenneth Kipkemoi	Male	Kenya	30-39	02:05:57	Chicago - USA	2018-10-07
89	Laban Korir	Male	Kenya		02:05:58	Rotterdam - Netherlands	2018-04-08
90	Almahjoub Dazza	Male	Bahrain		02:05:58	Prague - Czech Republic	2019-05-05
91	Endeshaw Negesse	Male	Ethiopia	20-29	02:05:59	Tokyo - Japan	2015-02-22
92	Lelisa Desisa	Male	Ethiopia	20-29	02:05:59	New York - USA	2018-11-04
93	Shura Kitata	Male	Ethiopia	20-29	02:06:01	New York - USA	2018-11-04
94	Fentahun Hunegnaw	Male	Ethiopia	Msen	02:06:04	Amsterdam - Netherlands	2019-10-19
95	Marius Kimutai	Male	Kenya		02:06:04	Rotterdam - Netherlands	2017-04-09
96	Philemon Kacheran Lokedi	Male	Kenya		02:06:04	Valencia - Spain	2019-12-01
97	Alemu Bekele	Male	Bahrain		02:06:04	Barcelona - Spain	2019-03-10
98	Lilesa, Feyisa	Male	Ethiopia	20-29	02:06:05	Berlin - Germnay	2015-09-27
99	Ezekiel Chebii	Male			02:06:06	Amsterdam - Netherlands	2016-10-16
100	Galen Rupp	Male	United States		02:06:07	Prague - Czech Republic	2018-05-06