4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Llanidloes Town FC
TEMPORADA 2023/2024
FAW CHAMPIONSHIP GALES GRUPO 1
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 Caersws Caersws 30 60 53 39
10 Gresford Athletic Gresford 30 47 54 37
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 30 25 106 9
TEMPORADA 2022/2023
FAW CHAMPIONSHIP GALES GRUPO 1
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
TEMPORADA 2021/2022
FAW CHAMPIONSHIP GALES GRUPO 1
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
TEMPORADA 2014/2015
SEGUNDA GALES CYMRU ALLIANCE
Equipo PJ GF GC Puntos
1 Caernarfon Town FC Caernarfon 30 85 22 69
2 Llandudno FC Llandudno 30 92 31 68
3 Guilsfield FC Guilsfield 30 68 33 63
4 Buckley Town Buckley Town 30 73 42 57
5 Porthmadog Porthmadog 30 63 35 50
6 Holyhead Hotspur Holyhead 30 48 38 50
7 Caersws Caersws 30 61 47 47
8 Denbigh Town Denbigh Town 30 49 53 45
9 Flint Town United Flint Town. 30 39 45 44
10 Conwy Borough FC Conwy 30 52 46 41
11 Mold Alexandra Mold 30 54 50 41
12 Rhayader Town FC Rhayader 30 40 52 30
13 Llanidloes Town FC Llanidloes 30 53 74 29
14 Penycae FC Penycae FC 30 47 74 25
15 Llandrindod Wells Llandrindod 30 32 103 18
16 Rhydymwyn FC Rhydymwyn 30 21 132 3
TEMPORADA 2013/2014
SEGUNDA GALES CYMRU ALLIANCE
Equipo PJ GF GC Puntos
1 Cefn Druids AFC Cefn Druids 24 75 13 61
2 Conwy Borough FC Conwy 24 57 29 52
3 Caernarfon Town FC Caernarfon 24 69 30 51
4 Caersws Caersws 24 47 27 49
5 Llandudno FC Llandudno 24 47 34 34
6 Holyhead Hotspur Holyhead 24 42 38 34
7 Guilsfield FC Guilsfield 24 35 35 33
8 Porthmadog Porthmadog 24 41 43 33
9 Flint Town United Flint Town. 24 36 45 32
10 Penycae FC Penycae FC 24 37 53 27
11 Rhayader Town FC Rhayader 24 34 51 27
12 Rhydymwyn FC Rhydymwyn 24 28 53 25
13 Llanidloes Town FC Llanidloes 24 36 46 23
14 Buckley Town Buckley Town 24 35 50 22
15 Penrhyncoch FC Penrhyncoch 24 23 46 16
16 Llanrhaeadr FC Llanrhaeadr 24 28 77 10

  USO DE MEMORIA  
5,714,048 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0017
Controller Execution Time ( Home / Category )  0.0928
Total Execution Time  0.0945
  CADENA URL  
/historico/Llanidloes-Town-Fc
  GET DATOS  
$_GET['/historico/Llanidloes-Town-Fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0028  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 = 'Llanidloes-Town-Fc' 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.0018  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=13008 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=13008 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=13008 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=13008 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13008 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2158 AND type_rel = 3
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 2158 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (970440,736427) ORDER BY n.cover_points DESC, update_date DESC
0.0024  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 = '13008' ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '13008' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '13008' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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=13008 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (73677,72392,72373) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 72373 AND teamId = 13008
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 72392 AND teamId = 13008
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 73677 AND teamId = 13008
0.0021  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 = '13008' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '13008' and rp.type = 4
0.0020  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 = '13008' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0034  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 = 72373 WHERE rp.league_id = 72373 AND rp.teamId = 13008 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.0028  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 = 72373 WHERE rp.league_id = 72373 AND rp.teamId = 13008 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 72373 WHERE rp.league_id = 72373 AND rp.teamId = 13008 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 13008 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0023  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 = 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
0.0024  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.0023  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.0024  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 `tables2015` 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 = 4324 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables2014` 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 = 2809 AND t.round = 24 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC