4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 Holywell Holywell 30 79 17 81
2 Flint Town United Flint Town. 30 94 30 78
3 Airbus UK Airbus UK 30 84 28 74
4 Mold Alexandra Mold 30 66 50 55
5 Bangor 1876 Bangor 1876 30 62 55 53
6 Denbigh Town Denbigh Town 30 71 60 49
7 Ruthin Town Ruthin Town 30 58 52 42
8 Guilsfield FC Guilsfield 30 48 46 40
9 Gresford Athletic Gresford 30 47 54 37
10 Caersws Caersws 29 55 53 36
11 Buckley Town Buckley Town 30 54 60 36
12 Llandudno FC Llandudno 30 59 80 31
13 Prestatyn Town Prestatyn 30 39 74 26
14 Porthmadog Porthmadog 30 35 66 22
15 Chirk AAA Chirk AAA 30 32 82 13
16 Llanidloes Town FC Llanidloes 29 25 101 9
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Colwyn Bay Colwyn Bay 30 101 24 83
2 Holywell Holywell 30 75 22 79
3 Llandudno FC Llandudno 30 70 23 66
4 Guilsfield FC Guilsfield 30 58 37 57
5 Ruthin Town Ruthin Town 30 48 44 51
6 Prestatyn Town Prestatyn 30 66 50 46
7 Cefn Druids AFC Cefn Druids 30 48 64 43
8 Buckley Town Buckley Town 30 53 61 42
9 Mold Alexandra Mold 30 41 52 35
10 Gresford Athletic Gresford 30 32 43 35
11 Porthmadog Porthmadog 30 36 53 33
12 Llanidloes Town FC Llanidloes 30 42 63 27
13 Chirk AAA Chirk AAA 30 32 49 26
14 Conwy Borough FC Conwy 30 33 64 23
15 Penrhyncoch FC Penrhyncoch 30 31 72 16
16 Holyhead Hotspur Holyhead 30 24 69 15
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Airbus UK Airbus UK 28 85 23 72
2 Llandudno FC Llandudno 28 55 21 63
3 Guilsfield FC Guilsfield 28 51 24 52
4 Holywell Holywell 28 68 36 50
5 Ruthin Town Ruthin Town 28 51 34 49
6 Colwyn Bay Colwyn Bay 28 60 40 48
7 Holyhead Hotspur Holyhead 28 41 34 41
8 Buckley Town Buckley Town 28 48 48 40
9 Penrhyncoch FC Penrhyncoch 28 39 57 35
10 Conwy Borough FC Conwy 28 42 59 32
11 Gresford Athletic Gresford 28 39 42 31
12 Llanidloes Town FC Llanidloes 28 44 59 28
13 Prestatyn Town Prestatyn 28 34 68 20
14 Llangefni Town FC Llangefni 28 19 70 15
15 Llanrhaeadr FC Llanrhaeadr 28 23 84 10
16 Bangor City Bangor City 0 0 0 0
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Prestatyn Town Prestatyn 26 84 19 68
2 Flint Town United Flint Town. 24 61 24 52
3 Colwyn Bay Colwyn Bay 25 47 30 50
4 Guilsfield FC Guilsfield 22 47 27 46
5 Bangor City Bangor City 23 29 26 40
6 Llanrhaeadr FC Llanrhaeadr 23 42 38 36
7 Conwy Borough FC Conwy 24 45 45 36
8 Penrhyncoch FC Penrhyncoch 25 30 35 36
9 Rhyl FC Rhyl FC 25 45 38 35
10 Gresford Athletic Gresford 24 37 38 29
11 Llandudno FC Llandudno 23 35 38 28
12 Ruthin Town Ruthin Town 25 31 39 28
13 Buckley Town Buckley Town 21 25 45 24
14 Llangefni Town FC Llangefni 26 23 49 22
15 Porthmadog Porthmadog 24 28 47 18
16 Corwen Corwen 23 26 55 14
17 Llanfair United Llanfair 23 26 68 9

  USO DE MEMORIA  
5,454,848 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0037
Controller Execution Time ( Home / Category )  0.3214
Total Execution Time  0.3251
  CADENA URL  
/faw_championship_gales2024/grupo1/historico
  GET DATOS  
$_GET['/faw_championship_gales2024/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0105  SELECT type FROM routes WHERE alias = 'faw_championship_gales2024'
0.0256  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'faw_championship_gales' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0106  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2158 ORDER BY order_id ASC
0.0108  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 = 72373 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0108  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 2158 AND group_code = 1 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0112  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 = 68117 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 63089 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 18:03:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 18:03:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 18:03:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0107  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 18:03:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0111  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'faw_championship_gales' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0213  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 events2024 e ON e.player_id = p.id AND e.league_id = 72373 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72373 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.0184  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 events2024 e ON e.player_id = p.id AND e.league_id = 72373 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72373 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0115  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 events2024 e ON e.player_id = p.id AND e.league_id = 72373 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72373 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0154  SELECT *,(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 = 72373 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC