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

XII - Canarias

Tercera División 2020 G 12

  • Tenisca
  • Tamaraceite
  • Marino
  • UD San Fernando
  • CD Atlético Paso
  • Tenerife B
  • Vera
  • Panadería Pulido
  • Gran Tarajal
  • Unión Viera
  • Unión Puerto
  • CD Mensajero
  • CD Santa Úrsula
  • UD Las Palmas C
  • Lanzarote
  • Atlético Tacoronte
  • AU Güímar
  • Ibarra
  • CD Buzanada
  • Villa Santa Brígida
  • Tercera División:

Clasificación

Equipo PJ GF GC Puntos
1 Tenisca Tenisca 28 57 36 54
2 Tamaraceite Tamaraceite 28 49 31 53
3 Marino Marino 27 41 30 53
4 UD San Fernando Fernando 27 58 29 52
5 CD Atlético Paso Atlético 27 54 31 49
6 Tenerife B Tenerife B 27 41 32 45
7 Vera Vera 28 54 52 43
8 Panadería Pulido Panadería 28 52 39 41
9 Gran Tarajal Gran Tarajal 28 52 44 41
10 Unión Viera Unión Viera 28 32 42 39
11 Unión Puerto Unión 27 32 37 35
12 CD Mensajero Mensajero 27 51 51 34
13 CD Santa Úrsula Santa 28 32 39 34
14 UD Las Palmas C Palmas 28 33 31 32
15 Lanzarote Lanzarote 27 33 32 31
16 Atlético Tacoronte Atlético 27 34 47 30
17 AU Güímar AU Güímar 28 34 53 25
18 Ibarra Ibarra 28 24 48 25
19 CD Buzanada CD Buzanada 27 23 55 21
20 Villa Santa Brígida Villa Santa 27 27 54 16

  USO DE MEMORIA  
5,514,912 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.2866
Total Execution Time  0.2888
  CADENA URL  
/tercera2020/grupo12/resumen/28
  GET DATOS  
$_GET['/tercera2020/grupo12/resumen/28']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4 AND type_rel = 3
0.0109  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 `calendars2020` 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` = 50280 AND c.`round` = 28 ORDER BY shedule ASC LIMIT 200
0.0134  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 `events2020` e INNER JOIN calendars2020 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 = 28 AND e.real_date IS NOT NULL AND e.league_id = 50280 ORDER BY total DESC LIMIT 100
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-30 10:25:23' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0108  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-30 10:25:23' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0109  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-30 10:25:23' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-30 10:25:23' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0569  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 events2020 e ON e.player_id = p.id AND e.league_id = 50280 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50280 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.0119  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 events2020 e ON e.player_id = p.id AND e.league_id = 50280 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50280 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0112  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 events2020 e ON e.player_id = p.id AND e.league_id = 50280 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50280 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0230  SELECT *,(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 = 50280 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0170  SELECT * FROM tables_coeff WHERE `league_id` = '50280' AND `round` = '28'