4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del RW Koblenz
TEMPORADA 2023/2024
OBERLIGA GRUPO 8
Equipo PJ GF GC Puntos
1 Eintracht Trier Eintracht 34 105 27 92
2 Gonsenheim Gonsenheim 34 84 42 68
3 FK Pirmasens Pirmasens 34 78 36 65
4 Wormatia Worms Wormatia 34 67 44 60
5 Auersmacher Auersmacher 34 61 56 58
6 Kaiserslautern II Kaiserslaute 34 71 58 56
7 Engers 07 Engers 07 34 69 53 52
8 RW Koblenz RW Koblenz 34 62 56 52
9 Diefflen Diefflen 34 68 72 51
10 Morlautern Morlautern 34 57 63 50
11 Karbach Karbach 34 64 78 48
12 Arminia Ludwigshafen Arminia 34 55 71 46
13 Mechtersheim Mechtersheim 34 59 49 45
14 Cosmos Koblenz Cosmos 34 61 65 40
15 Dudenhofen Dudenhofen 34 52 56 39
16 Alemannia Waldalgesheim Alemannia 34 38 59 37
17 VfR Baumholder Baumholder 34 52 76 31
18 Pfeddersheim Pfeddersheim 34 44 86 27
19 SpVgg Quierschied SpVgg 34 32 73 25
20 FC Bitburg FC Bitburg 34 43 102 17
TEMPORADA 2022/2023
REGIONALLIGA GRUPO 3
Equipo PJ GF GC Puntos
1 Ulm Ulm 34 59 25 72
2 TSV Steinbach Haiger Steinbach 34 80 31 71
3 Hoffenheim II Hoffenheim 34 80 38 69
4 FC 08 Homburg Homburg 34 65 44 58
5 FSV Frankfurt Frankfurt 34 57 45 57
6 TSG Balingen Balingen 34 51 44 56
7 Kickers Offenbach FC Kickers 34 48 38 55
8 Stuttgart II Stuttgart 34 53 39 52
9 Mainz 05 II Mainz 05 II 34 50 47 48
10 Bahlinger SC Bahlinger 34 53 67 46
11 Barockstadt Barockstadt 34 47 50 40
12 Astoria Walldorf Astoria 34 43 64 34
13 Hessen Kassel Hessen 34 34 51 33
14 Freiberg Freiberg 34 41 68 33
15 VfR Aalen VfR Aalen 34 38 52 32
16 Wormatia Worms Wormatia 34 37 63 29
17 RW Koblenz RW Koblenz 34 35 67 27
18 Eintracht Trier Eintracht 34 32 70 22
TEMPORADA 2021/2022
REGIONALLIGA GRUPO 3
Equipo PJ GF GC Puntos
1 SV Elversberg Elversberg 36 79 29 80
2 Ulm Ulm 36 60 30 77
3 Kickers Offenbach FC Kickers 36 67 26 76
4 TSV Steinbach Haiger Steinbach 36 62 35 70
5 Mainz 05 II Mainz 05 II 36 63 42 69
6 FC 08 Homburg Homburg 36 43 48 52
7 Hessen Kassel Hessen 36 46 37 51
8 TSG Balingen Balingen 36 46 64 46
9 Bahlinger SC Bahlinger 36 35 44 45
10 Astoria Walldorf Astoria 36 49 61 44
11 Stuttgart II Stuttgart 36 49 52 43
12 VfR Aalen VfR Aalen 36 49 60 43
13 Hoffenheim II Hoffenheim 36 45 50 41
14 RW Koblenz RW Koblenz 36 36 44 39
15 FSV Frankfurt Frankfurt 36 40 53 39
16 SG Sonnenhof Großaspach Sonnenhof 36 42 64 39
17 Schott Mainz Schott Mainz 36 36 58 33
18 FK Pirmasens Pirmasens 36 32 59 33
19 FC Giessen FC Giessen 36 28 51 29
TEMPORADA 2020/2021
REGIONALLIGA GRUPO 2
Equipo PJ GF GC Puntos
1 Freiburg II Freiburg II 42 95 38 93
2 SV Elversberg Elversberg 42 98 43 88
3 Kickers Offenbach FC Kickers 42 80 32 87
4 Ulm Ulm 42 75 40 79
5 TSV Steinbach Haiger Steinbach 42 84 47 74
6 FSV Frankfurt Frankfurt 42 58 48 70
7 FC 08 Homburg Homburg 42 73 53 68
8 Stuttgart II Stuttgart 42 82 55 65
9 Bahlinger SC Bahlinger 42 66 75 61
10 RW Koblenz RW Koblenz 42 57 61 56
11 FC Giessen FC Giessen 42 52 51 53
12 Hessen Kassel Hessen 42 57 71 53
13 VfR Aalen VfR Aalen 42 49 60 52
14 FK Pirmasens Pirmasens 42 45 58 52
15 TSG Balingen Balingen 42 51 60 51
16 Hoffenheim II Hoffenheim 42 59 76 50
17 Mainz 05 II Mainz 05 II 42 58 73 49
18 Astoria Walldorf Astoria 42 64 79 47
19 SG Sonnenhof Großaspach Sonnenhof 42 52 75 43
20 Schott Mainz Schott Mainz 42 55 104 38
21 Bayern Alzenau Bayern 42 47 94 25
22 Eintracht Stadtallendorf Eintracht 42 40 104 17
TEMPORADA 2019/2020
REGIONALLIGA GRUPO 4
Equipo PJ GF GC Puntos
1 1. FC Saarbrücken Saarbrücken 23 52 18 55
2 SV Elversberg Elversberg 23 48 24 49
3 TSV Steinbach Haiger Steinbach 22 40 18 48
4 FC 08 Homburg Homburg 23 42 30 46
5 Astoria Walldorf Astoria 23 41 31 37
6 Mainz 05 II Mainz 05 II 23 37 29 37
7 Ulm Ulm 22 38 24 35
8 Kickers Offenbach FC Kickers 22 29 28 32
9 Hoffenheim II Hoffenheim 22 37 34 29
10 Bayern Alzenau Bayern 22 28 31 28
11 Bahlinger SC Bahlinger 23 33 38 28
12 FSV Frankfurt Frankfurt 23 26 32 28
13 Freiburg II Freiburg II 23 30 37 28
14 VfR Aalen VfR Aalen 22 27 25 26
15 FC Giessen FC Giessen 23 22 39 25
16 FK Pirmasens Pirmasens 22 19 35 18
17 TSG Balingen Balingen 23 24 57 11
18 RW Koblenz RW Koblenz 22 12 55 5
TEMPORADA 2018/2019
OBERLIGA GRUPO 7
Equipo PJ GF GC Puntos
1 RW Koblenz RW Koblenz 34 68 30 71
2 Rochling Volklingen Rochling 34 67 38 60
3 Pfeddersheim Pfeddersheim 34 73 57 60
4 TuS Koblenz TuS Koblenz 34 54 34 59
5 Engers 07 Engers 07 34 59 48 59
6 Eintracht Trier Eintracht 34 67 41 57
7 Schott Mainz Schott Mainz 34 76 55 57
8 Mechtersheim Mechtersheim 34 57 49 53
9 Kaiserslautern II Kaiserslaute 34 61 42 51
10 Hertha Wiesbach Hertha 34 50 43 50
11 Hassia Bingen Hassia 34 58 58 47
12 Karbach Karbach 34 48 50 45
13 Arminia Ludwigshafen Arminia 34 58 74 43
14 Diefflen Diefflen 34 60 73 42
15 FSV Jägersburg Jägersburg 34 49 65 35
16 Emmelshausen Emmelshausen 34 34 71 35
17 Idar-Oberstein Idar-Oberste 34 47 95 18
18 VfB Dillingen Dillingen 34 34 97 16
TEMPORADA 2017/2018
OBERLIGA GRUPO 11
Equipo PJ GF GC Puntos
1 FC 08 Homburg Homburg 36 112 20 96
2 FK Pirmasens Pirmasens 36 97 31 79
3 Kaiserslautern II Kaiserslaute 36 89 29 77
4 Eintracht Trier Eintracht 36 65 36 71
5 Diefflen Diefflen 36 81 61 63
6 FSV Jägersburg Jägersburg 36 68 60 55
7 RW Koblenz RW Koblenz 36 66 60 52
8 Hertha Wiesbach Hertha 36 62 72 48
9 Mechtersheim Mechtersheim 36 58 73 47
10 Karbach Karbach 36 65 75 44
11 Idar-Oberstein Idar-Oberste 36 53 57 43
12 Pfeddersheim Pfeddersheim 36 48 66 43
13 Engers 07 Engers 07 36 47 69 42
14 Dudenhofen Dudenhofen 36 41 72 40
15 Gonsenheim Gonsenheim 36 57 68 39
16 Morlautern Morlautern 36 46 79 30
17 Salmrohr Salmrohr 36 32 71 28
18 Saar Saarbrücken Saar 36 36 74 27
19 Eppelborn Eppelborn 36 51 101 24
TEMPORADA 2016/2017
OBERLIGA GRUPO 14
Equipo PJ GF GC Puntos
1 Schott Mainz Schott Mainz 34 110 41 74
2 Rochling Volklingen Rochling 34 83 41 70
3 Hertha Wiesbach Hertha 34 95 50 67
4 Mechtersheim Mechtersheim 34 78 52 62
5 RW Koblenz RW Koblenz 34 65 51 57
6 Karbach Karbach 34 82 53 55
7 Saar Saarbrücken Saar 34 67 44 52
8 FK Pirmasens II Pirmasens 34 68 52 52
9 Gonsenheim Gonsenheim 34 71 60 52
10 Diefflen Diefflen 34 87 71 51
11 Pfeddersheim Pfeddersheim 34 75 54 46
12 Morlautern Morlautern 34 57 49 46
13 Hauenstein Hauenstein 34 65 55 41
14 FSV Jägersburg Jägersburg 34 65 74 38
15 Salmrohr Salmrohr 34 57 68 37
16 Arminia Ludwigshafen Arminia 34 52 72 32
17 Borussia Neunkirchen Borussia 34 46 71 31
18 Burgbrohl Burgbrohl 34 9 255 1

  USO DE MEMORIA  
6,276,088 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5607
Total Execution Time  0.5619
  CADENA URL  
/historico/Tus-Rw-Koblenz
  GET DATOS  
$_GET['/historico/Tus-Rw-Koblenz']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0137  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 = 'Tus-Rw-Koblenz' 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.0125  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=90537 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=90537 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=90537 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=90537 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0259  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 = 72627
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=90537 AND type_rel = 2
0.0143  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 = '90537' ORDER BY l.year DESC,cat.coefficient DESC
0.0144  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 = '90537' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0163  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 = '90537' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0134  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 = 72627 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0142  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=90537 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0136  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 (72627,72172,71432,68047) 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.0144  SELECT count(id) as num_players from rel_players WHERE league_id = 68047 AND teamId = 90537
0.0140  SELECT count(id) as num_players from rel_players WHERE league_id = 72627 AND teamId = 90537
0.0155  SELECT count(id) as num_players from rel_players WHERE league_id = 72172 AND teamId = 90537
0.0138  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 90537
0.0129  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 = '90537' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0129  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '90537' and rp.type = 4
0.0134  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 = '90537' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0180  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 events2024 e ON e.player_id = p.id AND e.league_id = 72627 WHERE rp.league_id = 72627 AND rp.teamId = 90537 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.0187  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 events2024 e ON e.player_id = p.id AND e.league_id = 72627 WHERE rp.league_id = 72627 AND rp.teamId = 90537 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151  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 events2024 e ON e.player_id = p.id AND e.league_id = 72627 WHERE rp.league_id = 72627 AND rp.teamId = 90537 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130  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 = 90537 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0132  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 `tables2024` 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 = 72627 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  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 `tables2023` 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 = 68047 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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 `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 = 63290 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.0133  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 = 57336 AND t.round = 42 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 50105 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 44338 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 `tables2018` 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 = 39086 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 `tables2017` 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 = 34103 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC