4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Tampa Bay Rowdies II
TEMPORADA 2020/2021
USL LEAGUE TWO GRUPO 1
Equipo PJ GF GC Puntos
1 Western Mass Pioneers Western Mass 14 34 12 32
2 Boston Bolts Boston Bolts 14 29 16 30
3 Seacoast United Phantoms Seacoast 14 32 17 29
4 Black Rock Black Rock 14 16 27 15
5 Malaga City NY Malaga City 14 7 24 8
6 Connecticut Connecticut 14 13 35 5
7 The Villages Villages 10 19 5 25
8 Tampa Bay Rowdies II Tampa 10 19 12 18
9 Florida Elite Florida 10 14 11 16
10 Weston Weston 10 8 16 9
11 Miami City Miami City 10 16 23 8
12 FC Florida II Florida 10 8 17 8
13 CFC Atletico Atletico 12 30 11 31
14 PDX FC PDX FC 12 33 24 22
15 OVF Alliance Alliance 12 16 26 11
16 Lane United Lane United 12 18 36 5
17 Park City Red Wolves Park City W. 7 22 13 13
18 Colorado Rush Colorado 8 15 19 11
19 Ogden City Ogden City 7 11 16 7
20 Long Island Rough Riders Long Island 14 21 7 31
21 Manhattan Manhattan 13 27 13 24
22 New York RB III York 13 22 9 24
23 Cedar Stars Rush Cedar Stars 13 26 14 24
24 Motown Motown 14 18 15 20
25 New Jersey Copa Jersey Copa 13 15 16 18
26 FA Euro FA Euro 14 18 22 16
27 Morris Elite Morris Elite 14 8 28 11
28 Westchester Flames Westchester 14 13 44 2
29 SC United Bantams United 14 30 19 32
30 Tormenta II Tormenta II 14 33 12 31
31 East Atlanta East Atlanta 14 18 24 21
32 Charlotte Eagles Charlotte 14 25 23 20
33 Peachtree City Peachtree 14 22 25 17
34 Asheville City Asheville 13 15 20 17
35 Charlotte Independence II Charlotte 14 20 22 16
36 Dalton Red Wolves Dalton 13 14 23 13
37 SSA Kings SSA Kings 14 13 22 10
38 Kalamazoo FC Kalamazoo 14 29 14 31
39 Flint City Bucks Flint City. 14 35 10 29
40 Grand Rapids Grand Rapids 14 35 17 26
41 Kings Hammer Kings Hammer 13 22 15 25
42 South Bend Lions South Bend. 14 27 17 19
43 Oakland County Oakland 14 28 32 18
44 Toledo Villa Toledo Villa 14 22 40 13
45 Fort Wayne Fort Wayne 14 14 32 8
46 Dayton Dutch Lions Dayton Dutch 13 12 47 1
47 Des Moines Menace Moines 12 32 7 33
48 Chicago FC United Chicago 12 30 10 29
49 St. Louis SG Louis 12 24 20 20
50 Kaw Valley Kaw Valley 11 18 28 12
51 Green Bay Voyageurs Green 11 8 25 5
52 Wichita Wichita 10 5 27 0
53 West Chester United West Chester 14 29 6 35
54 Ocean City Nor'easters Ocean City. 14 40 12 30
55 Northern Virginia Royals Northern 14 27 21 26
56 Philadelphia Lone Star Philadelphia 14 22 28 15
57 Reading United Reading 14 18 27 15
58 Lehigh Valley Utd. Sonic Lehigh 14 18 39 10
59 RC New Jersey Jersey 14 10 31 9
60 Mississippi Brilla Mississippi 13 26 11 27
61 Texas United Texas United 14 24 15 24
62 Corpus Christi Corpus 12 20 13 23
63 AHFC Royals AHFC Royals 14 25 24 20
64 Little Rock Rangers Little Rock 14 17 17 19
65 Houston FC Houston FC 13 15 27 13
66 Round Rock Round Rock 12 13 20 12
67 Twin City Toucans Twin City T. 14 18 31 10
68 North Carolina Fusion U23 North 14 48 13 34
69 Lionsbridge Lionsbridge 14 38 16 29
70 West Virginia United West 14 31 20 29
71 Tri-Cities Tri-Cities 13 27 14 24
72 Wake Wake 14 21 33 15
73 North Carolina II North 14 15 38 10
74 Virginia Beach United Virginia 14 12 25 9
75 Tobacco Road Tobacco Road 13 10 43 7
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

  USO DE MEMORIA  
5,858,960 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.0970
Total Execution Time  0.0983
  CADENA URL  
/historico/Tampa-Bay-Rowdies-Under
  GET DATOS  
$_GET['/historico/Tampa-Bay-Rowdies-Under']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0025  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 = 'Tampa-Bay-Rowdies-Under' 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.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 = 'Tampa-Bay-Rowdies-Under' 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.0018  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=135369 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=135369 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=135369 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=135369 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=135369 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040  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 = 66975
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=135369 AND type_rel = 2
0.0020  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 = '135369' ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '135369' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '135369' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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 = '135369' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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 = 66975 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=135369 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (66975) 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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 66975 AND teamId = 135369
0.0019  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2022` 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 = 66975 AND t.round = 80 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022  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 = '135369' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '135369' and rp.type = 4
0.0021  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 = '135369' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  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 events2022 e ON e.player_id = p.id AND e.league_id = 66975 WHERE rp.league_id = 66975 AND rp.teamId = 135369 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.0019  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 events2022 e ON e.player_id = p.id AND e.league_id = 66975 WHERE rp.league_id = 66975 AND rp.teamId = 135369 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  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 events2022 e ON e.player_id = p.id AND e.league_id = 66975 WHERE rp.league_id = 66975 AND rp.teamId = 135369 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 135369 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0047  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 `tables2021` 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 = 62694 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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.0023  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 = 66975 ORDER BY nameShow LIMIT 100