4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Sarasota Metropolis
TEMPORADA 2019/2020
USL LEAGUE TWO
Equipo PJ GF GC Puntos
1 AFC Ann Arbor Arbor 0 0 0 0
2 Louisville City II Louisville 0 0 0 0
3 Grand Rapids Grand Rapids 0 0 0 0
4 Dayton Dutch Lions Dayton Dutch 0 0 0 0
5 South Bend Lions South Bend. 0 0 0 0
6 Flint City Bucks Flint City. 0 0 0 0
7 Cincinnati Dutch Lions Cincinnati 0 0 0 0
8 Oakland County Oakland 0 0 0 0
9 Peoria Peoria 0 0 0 0
10 Chicago FC United Chicago 0 0 0 0
11 Manitoba Manitoba 0 0 0 0
12 Thunder Bay Chill Thunder 0 0 0 0
13 St. Louis Lions Louis Lions 0 0 0 0
14 Des Moines Menace Moines 0 0 0 0
15 Kaw Valley Kaw Valley 0 0 0 0
16 Green Bay Voyageurs Green 0 0 0 0
17 Reading United Reading 0 0 0 0
18 Evergreen Evergreen 0 0 0 0
19 Philadelphia Lone Star Philadelphia 0 0 0 0
20 Lehigh Valley Utd. Sonic Lehigh 0 0 0 0
21 West Chester United West Chester 0 0 0 0
22 Bermuda Bascome Bermuda 0 0 0 0
23 Twin City Toucans Twin City T. 0 0 0 0
24 AHFC Royals AHFC Royals 0 0 0 0
25 Houston FC Houston FC 0 0 0 0
26 Texas United Texas United 0 0 0 0
27 Mississippi Brilla Mississippi 0 0 0 0
28 Corpus Christi Corpus 0 0 0 0
29 Black Rock Black Rock 0 0 0 0
30 Western Mass Pioneers Western Mass 0 0 0 0
31 Seacoast United Phantoms Seacoast 0 0 0 0
32 Boston Bolts Boston Bolts 0 0 0 0
33 Portland Phoenix Portland 0 0 0 0
34 Connecticut Connecticut 0 0 0 0
35 Sound FC Sound FC 0 0 0 0
36 CFC Atletico Atletico 0 0 0 0
37 TFA Willamette Willamette 0 0 0 0
38 TSS Rovers TSS Rovers 0 0 0 0
39 Calgary Foothills Calgary 0 0 0 0
40 Tri-Cities Tri-Cities 0 0 0 0
41 Tobacco Road Tobacco Road 0 0 0 0
42 West Virginia United West 0 0 0 0
43 North Carolina II North 0 0 0 0
44 Wake Wake 0 0 0 0
45 Virginia Beach United Virginia 0 0 0 0
46 Lionsbridge Lionsbridge 0 0 0 0
47 The Villages Villages 0 0 0 0
48 Sarasota Metropolis Sarasota 0 0 0 0
49 Miami City Miami City 0 0 0 0
50 Treasure Coast Tritons Treasure 0 0 0 0
51 Weston Weston 0 0 0 0
52 Tampa Bay Rowdies II Tampa 0 0 0 0
53 Daytona Daytona 0 0 0 0
54 Florida Elite Florida 0 0 0 0
55 Ventura County Fusion Ventura 0 0 0 0
56 Glens Glens 0 0 0 0
57 Santa Cruz Breakers Santa Cruz. 0 0 0 0
58 Golden State Force Golden State 0 0 0 0
59 San Francisco City Francisco 0 0 0 0
60 Seahorses Seahorses 0 0 0 0
61 New Mexico United U23 Mexico 0 0 0 0
62 Colorado Rush Colorado 0 0 0 0
63 Park City Red Wolves Park City W. 0 0 0 0
64 Ogden City Ogden City 0 0 0 0
65 Asheville City Asheville 0 0 0 0
66 East Atlanta East Atlanta 0 0 0 0
67 Peachtree City Peachtree 0 0 0 0
68 SC United Bantams United 0 0 0 0
69 Charlotte Eagles Charlotte 0 0 0 0
70 SSA Kings SSA Kings 0 0 0 0
71 Tormenta II Tormenta II 0 0 0 0
72 Charlotte Independence II Charlotte 0 0 0 0
73 Manhattan Manhattan 0 0 0 0
74 FA Euro FA Euro 0 0 0 0
75 New York RB III York 0 0 0 0
76 Long Island Rough Riders Long Island 0 0 0 0
77 Westchester Flames Westchester 0 0 0 0
TEMPORADA 2018/2019
USL LEAGUE TWO
Equipo PJ GF GC Puntos
1 Chicago FC United Chicago 14 31 14 28
2 Flint City Bucks Flint City. 14 29 18 27
3 Cincinnati Dutch Lions Cincinnati 14 21 16 23
4 Dayton Dutch Lions Dayton Dutch 14 21 23 17
5 West Virginia Chaos West 14 7 38 3
6 Des Moines Menace Moines 13 27 4 33
7 Kaw Valley Kaw Valley 14 18 10 24
8 Green Bay Voyageurs Green 14 19 15 22
9 Thunder Bay Chill Thunder 13 17 17 18
10 St. Louis Lions Louis Lions 14 17 20 15
11 Manitoba Manitoba 14 6 38 2
12 Reading United Reading 14 32 19 32
13 Long Island Rough Riders Long Island 14 28 14 25
14 Ocean City Nor'easters Ocean City. 14 27 22 23
15 New York RB III York 14 25 18 19
16 Cedar Stars Rush Cedar Stars 14 16 20 16
17 Lehigh Valley Utd. Sonic Lehigh 14 21 30 15
18 FA Euro FA Euro 14 16 24 12
19 Evergreen Evergreen 14 11 29 6
20 Twin City Toucans Twin City T. 14 51 14 34
21 Corpus Christi Corpus 14 43 28 26
22 Mississippi Brilla Mississippi 14 34 29 23
23 AHFC Royals AHFC Royals 14 26 22 20
24 Texas United Texas United 14 13 46 7
25 Houston FC Houston FC 14 11 39 6
26 Western Mass Pioneers Western Mass 14 31 7 36
27 Portland Phoenix Portland 14 30 20 29
28 Manhattan Manhattan 14 33 20 24
29 Boston Bolts Boston Bolts 14 23 29 17
30 Black Rock Black Rock 14 23 34 16
31 Seacoast United Phantoms Seacoast 14 19 31 15
32 Westchester Flames Westchester 14 25 32 13
33 Connecticut Connecticut 14 21 32 9
34 Calgary Foothills Calgary 14 25 15 29
35 Seattle Sounders Sub 23 Seattle 14 24 13 25
36 Lane United Lane United 14 22 17 20
37 Victoria Highlanders Victoria 14 22 22 19
38 CFC Atletico Atletico 14 14 33 13
39 TSS Rovers TSS Rovers 14 19 26 11
40 North Carolina II North 15 24 16 31
41 North Carolina Fusion U23 North 14 23 22 22
42 Virginia Beach United Virginia 14 22 22 20
43 Tri-Cities Tri-Cities 15 29 30 19
44 Lionsbridge Lionsbridge 14 26 24 18
45 Tobacco Road Tobacco Road 14 29 29 17
46 Wake Wake 14 12 22 15
47 The Villages Villages 14 33 12 34
48 Treasure Coast Tritons Treasure 14 27 14 26
49 Daytona Daytona 14 13 10 25
50 Florida Elite Florida 14 24 18 21
51 Miami City Miami City 14 24 25 19
52 Lakeland Tropics Lakeland 14 23 29 15
53 Sarasota Metropolis Sarasota 14 23 27 14
54 Weston Weston 14 9 41 3
55 Golden State Force Golden State 14 42 14 34
56 Ventura County Fusion Ventura 14 38 24 28
57 Seahorses Seahorses 14 21 19 22
58 Orange County Blues Sub 23 Orange 14 28 26 17
59 Santa Cruz Breakers Santa Cruz. 14 27 35 17
60 San Francisco City Francisco 14 26 42 15
61 San Diego Zest Diego Zest 14 22 32 13
62 Glens Glens 14 23 35 10
63 Colorado Switchbacks Colorado 12 26 14 26
64 Ogden City Ogden City 12 23 19 20
65 Park City Red Wolves Park City W. 12 16 22 13
66 Albuquerque Sol Albuquerque 12 12 22 8
67 Tormenta II Tormenta II 14 33 11 32
68 SC United Bantams United 14 22 15 29
69 Dalton Red Wolves Dalton 14 30 24 22
70 Charlotte Eagles Charlotte 14 24 29 20
71 Discoveries Discoveries 14 11 25 10
72 Peachtree City Peachtree 14 11 27 7

  USO DE MEMORIA  
6,439,624 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1381
Total Execution Time  0.1393
  CADENA URL  
/historico/Sarasota-Metropolis-Fc
  GET DATOS  
$_GET['/historico/Sarasota-Metropolis-Fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0030  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Sarasota-Metropolis-Fc' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0038  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Sarasota-Metropolis-Fc' ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0020  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=119813 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=119813 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=119813 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=119813 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0049  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 55388
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=119813 AND type_rel = 2
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=671 AND type_rel = 3
0.0022  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 671 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0025  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1160636,1014385,657541,22815) ORDER BY n.cover_points DESC, update_date DESC
0.0024  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '119813' ORDER BY l.year DESC,cat.coefficient DESC
0.0028  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '119813' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0026  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '119813' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0028  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '119813' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0038  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 55388 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0033  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=119813 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0026  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (55388,49506) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 55388 AND teamId = 119813
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 49506 AND teamId = 119813
0.0060  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2020` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 55388 AND t.round = 1 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0028  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '119813' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0022  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '119813' and rp.type = 4
0.0029  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '119813' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0031  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2020 e ON e.player_id = p.id AND e.league_id = 55388 WHERE rp.league_id = 55388 AND rp.teamId = 119813 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2020 e ON e.player_id = p.id AND e.league_id = 55388 WHERE rp.league_id = 55388 AND rp.teamId = 119813 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2020 e ON e.player_id = p.id AND e.league_id = 55388 WHERE rp.league_id = 55388 AND rp.teamId = 119813 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 119813 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0069  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 55388 AND t.round = 1 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0083  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2019` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 49041 AND t.round = 50 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 55388 ORDER BY nameShow LIMIT 100