Lisburn Distillery Lisburn
Datos equipo
Nombre Lisburn Distillery
Nombre corto LIS
País
Bangor Bangor
Datos equipo
Nombre Bangor
Nombre corto BAN
País
Limavady Limavady
Datos equipo
Nombre Limavady
Nombre corto LIM
País
Armagh City Armagh City
Datos equipo
Nombre Armagh City
Nombre corto ARC
País
Annagh United Annagh
Datos equipo
Nombre Annagh United
Nombre completo Annagh United
Nombre corto AUN
País
Banbridge Town Banbridge
Datos equipo
Nombre Banbridge Town
Nombre completo Banbridge Town
Nombre corto BAN
País
Tobermore United Tobermore
Datos equipo
Nombre Tobermore United
Nombre completo Tobermore United
Nombre corto TOB
País
Portstewart Portstewart
Datos equipo
Nombre Portstewart
Nombre completo Portstewart
Nombre corto POR
País
Moyola Park Moyola Park
Datos equipo
Nombre Moyola Park
Nombre completo Moyola Park
Nombre corto MOY
País
Newington Youth Newington
Datos equipo
Nombre Newington Youth
Nombre completo Newington Youth
Nombre corto NEY
País
Dollingstown Dollingstown
Datos equipo
Nombre Dollingstown
Nombre completo Dollingstown
Nombre corto DOL
País
Clasificación
Equipo PJ GF GC Puntos
1 Annagh United Annagh 14 32 14 33
2 Portstewart Portstewart 14 28 13 30
3 Dollingstown Dollingstown 13 31 15 25
4 Bangor Bangor 12 30 21 20
5 Newington Youth Newington 11 16 18 18
6 Armagh City Armagh City 14 15 26 14
7 Banbridge Town Banbridge 12 16 20 13
8 Lisburn Distillery Lisburn 13 13 25 13
9 Moyola Park Moyola Park 12 21 28 10
10 Limavady Limavady 13 21 32 9
11 Tobermore United Tobermore 12 14 25 8
Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
4,815,952 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0038
Controller Execution Time ( Home / Category )  0.1444
Total Execution Time  0.1483
  CADENA URL  
/tercera_irlanda_del_norte2020/grupo1/equipos
  GET DATOS  
$_GET['/tercera_irlanda_del_norte2020/grupo1/equipos']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0118  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tercera_irlanda_del_norte' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1816 AND type_rel = 3
0.0023  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1816 ORDER BY order_id ASC
0.0020  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 50312 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0043  SELECT t.id,t.teamId,t.total_players,dt.* FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 50312 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0030  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-28 07:31:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0060  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-28 07:31:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0099  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-28 07:31:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-28 07:31:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0053  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tercera_irlanda_del_norte' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0022  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 = 50312 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50312 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.0026  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 = 50312 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50312 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0022  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 = 50312 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50312 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0081  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 = 50312 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC