4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2021
 
Tercera División 2021 G 1
2020/2021

I - Galicia

Tercera División 2021 G 1

  • Bergantiños FC
  • CD Lugo B
  • Somozas
  • RC Villalbés
  • Deportivo Fabril
  • Silva SD
  • CSD Arzua
  • Viveiro
  • AG Estudiantil
  • As Pontes
  • SD Fisterra
  • UD Paiosaco
  • Arenteiro
  • Arosa
  • Alondras CF
  • CD Estradense
  • Choco
  • Rápido de Bouzas
  • Barco
  • Ourense CF
  • Ribadumia
  • Ourense UD
  • UD Atios
  • Pontellas
  • Tercera División:

Clasificación

Equipo PJ GF GC Puntos
1 Bergantiños FC Bergantiños 22 37 16 48
2 CD Lugo B CD Lugo B 22 34 17 42
3 Somozas Somozas 22 41 21 41
4 RC Villalbés Villalbés 22 34 26 40
5 Deportivo Fabril Deportivo 22 41 27 32
6 Silva SD Silva SD 22 21 20 30
7 CSD Arzua CSD Arzua 22 32 23 29
8 Viveiro Viveiro 22 25 39 28
9 AG Estudiantil Estudiantil 22 27 45 20
10 As Pontes As Pontes 22 18 40 19
11 SD Fisterra SD Fisterra 22 22 35 17
12 UD Paiosaco UD Paiosaco 22 16 39 12
13 Arenteiro Arenteiro 22 33 13 47
14 Arosa Arosa 22 27 14 41
15 Alondras CF Alondras CF 22 31 15 37
16 CD Estradense Estradense 22 35 34 31
17 Choco Choco 22 28 22 31
18 Rápido de Bouzas Rápido 22 25 25 31
19 Barco Barco 22 26 27 30
20 Ourense CF Ourense CF 22 33 29 28
21 Ribadumia Ribadumia 22 24 36 26
22 Ourense UD Ourense UD 22 25 32 25
23 UD Atios UD Atios 22 18 32 20
24 Pontellas Pontellas 22 12 38 9

  USO DE MEMORIA  
5,669,928 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.3554
Total Execution Time  0.3575
  CADENA URL  
/tercera2021/grupo1/resumen/22
  GET DATOS  
$_GET['/tercera2021/grupo1/resumen/22']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0147  SELECT type FROM routes WHERE alias = 'tercera2021'
0.0297  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tercera' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0167  SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2 FROM `calendars2021` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 58579 AND c.`round` = 22 ORDER BY shedule ASC LIMIT 200
0.0212  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2021` e INNER JOIN calendars2021 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 22 AND e.real_date IS NOT NULL AND e.league_id = 58579 ORDER BY total DESC LIMIT 100
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-29 09:37:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-29 09:37:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0148  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-29 09:37:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-29 09:37:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0235  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2021 e ON e.player_id = p.id AND e.league_id = 58579 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 58579 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0314  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2021 e ON e.player_id = p.id AND e.league_id = 58579 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 58579 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0166  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2021 e ON e.player_id = p.id AND e.league_id = 58579 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 58579 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0301  SELECT *,(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 = 58579 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC