4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Cambrian & Clydach
TEMPORADA 2023/2024
FAW CHAMPIONSHIP GALES GRUPO 2
Equipo PJ GF GC Puntos
1 Briton Ferry Briton Ferry 30 87 39 71
2 Llanelli Town AFC Llanelli 30 80 40 64
3 Ammanford AFC Ammanford 30 60 42 57
4 Cambrian & Clydach Cambrian 30 60 37 50
5 Caerau Ely Caerau Ely 30 72 60 49
6 Carmarthen Town Carmarthen 30 50 39 47
7 Afan Lido Afan Lido 30 68 56 46
8 Goytre United Goytre 30 58 59 43
9 Cwmbran Celtic Cwmbran 30 69 64 42
10 Baglan Dragons Baglan 30 46 41 41
11 Trefelin Trefelin 30 47 63 38
12 Llantwit Major Llantwit 30 44 54 35
13 Taffs Well Taffs Well 30 44 49 32
14 Pontardawe Town Pontardawe 30 52 70 32
15 Abertillery Bluebirds Abertillery 30 34 94 15
16 Abergavenny Town Abergavenny 30 20 84 8
TEMPORADA 2022/2023
FAW CHAMPIONSHIP GALES GRUPO 2
Equipo PJ GF GC Puntos
1 Barry Town Barry Town 30 78 25 78
2 Llanelli Town AFC Llanelli 30 63 34 62
3 Briton Ferry Briton Ferry 30 72 33 60
4 Carmarthen Town Carmarthen 30 66 41 52
5 Cambrian & Clydach Cambrian 30 64 53 47
6 Afan Lido Afan Lido 30 61 52 47
7 Llantwit Major Llantwit 30 46 40 45
8 Cwmbran Celtic Cwmbran 30 62 53 38
9 Pontardawe Town Pontardawe 30 51 73 37
10 Ammanford AFC Ammanford 30 40 57 33
11 Taffs Well Taffs Well 30 50 54 32
12 Goytre United Goytre 30 45 67 32
13 Abergavenny Town Abergavenny 30 35 60 32
14 Trefelin Trefelin 30 47 70 27
15 Swansea University Swansea 30 30 64 26
16 Ynyshir Albions Ynyshir 30 33 67 24
TEMPORADA 2021/2022
FAW CHAMPIONSHIP GALES GRUPO 2
Equipo PJ GF GC Puntos
1 Llantwit Major Llantwit 30 73 31 74
2 Pontypridd United Pontypridd 30 79 30 69
3 Briton Ferry Briton Ferry 30 76 36 56
4 Cambrian & Clydach Cambrian 30 73 42 51
5 Carmarthen Town Carmarthen 30 52 25 51
6 Goytre United Goytre 30 55 36 51
7 Taffs Well Taffs Well 30 57 47 49
8 Swansea University Swansea 30 44 43 40
9 Llanelli Town AFC Llanelli 30 43 54 40
10 Afan Lido Afan Lido 30 45 67 39
11 Trefelin Trefelin 30 58 51 37
12 Ammanford AFC Ammanford 30 58 56 34
13 Cwmbran Celtic Cwmbran 30 43 74 34
14 Risca United Risca United 30 43 51 31
15 Undy Athletic Undy 30 41 84 17
16 Port Talbot Town Port Talbot 30 8 121 0
TEMPORADA 2019/2020
FAW CHAMPIONSHIP GALES GRUPO 2
Equipo PJ GF GC Puntos
1 Swansea University Swansea 25 56 31 56
2 Haverfordwest County Haverfordwes 25 58 26 55
3 Briton Ferry Briton Ferry 24 65 36 47
4 Cambrian & Clydach Cambrian 23 41 31 40
5 STM Sports STM Sports 22 51 34 39
6 Ammanford AFC Ammanford 25 44 47 37
7 Llanelli Town AFC Llanelli 25 46 51 37
8 Goytre United Goytre 25 40 41 36
9 Pontypridd United Pontypridd 24 48 37 34
10 Afan Lido Afan Lido 25 47 47 34
11 Llantwit Major Llantwit 23 34 38 27
12 Undy Athletic Undy 21 29 38 23
13 Cwmbran Celtic Cwmbran 22 29 44 22
14 Taffs Well Taffs Well 25 40 64 21
15 Cwmamman United Cwmamman 22 22 55 17
16 Caerau Ely Caerau Ely 20 18 48 7
TEMPORADA 2017/2018
SEGUNDA GALES FOOTBALL LEAGUE
Equipo PJ GF GC Puntos
1 Llanelli Town AFC Llanelli 30 87 33 75
2 Haverfordwest County Haverfordwes 30 65 37 60
3 Penybont Penybont 30 64 37 60
4 Cambrian & Clydach Cambrian 30 58 39 54
5 Afan Lido Afan Lido 30 61 48 49
6 Goytre AFC Goytre AFC 30 51 62 48
7 Goytre United Goytre 30 53 52 47
8 Cwmbran Celtic Cwmbran 30 67 51 46
9 Undy Athletic Undy 30 62 60 44
10 Port Talbot Town Port Talbot 30 58 53 38
11 Taffs Well Taffs Well 30 52 48 38
12 Briton Ferry Briton Ferry 30 58 64 37
13 Cwmamman United Cwmamman 30 38 59 30
14 Monmouth Town FC Monmouth 30 44 73 25
15 Caerau Ely Caerau Ely 30 32 78 18
16 Ton Pentre Ton Pentre 30 26 82 10
TEMPORADA 2016/2017
SEGUNDA GALES FOOTBALL LEAGUE
Equipo PJ GF GC Puntos
1 Barry Town Barry Town 30 69 18 66
2 Penybont Penybont 30 73 41 61
3 Goytre AFC Goytre AFC 30 80 49 58
4 Haverfordwest County Haverfordwes 30 55 47 54
5 Caerau Ely Caerau Ely 30 57 50 48
6 Cwmbran Celtic Cwmbran 30 60 51 45
7 Afan Lido Afan Lido 30 47 49 44
8 Undy Athletic Undy 30 53 53 41
9 Taffs Well Taffs Well 30 40 48 40
10 Goytre United Goytre 30 44 37 39
11 Cambrian & Clydach Cambrian 30 41 49 37
12 Ton Pentre Ton Pentre 30 51 61 36
13 Port Talbot Town Port Talbot 30 41 57 35
14 Monmouth Town FC Monmouth 30 49 74 33
15 Caldicot Town Caldicot 30 36 65 23
16 Risca United Risca United 30 38 85 20
TEMPORADA 2015/2016
SEGUNDA GALES FOOTBALL LEAGUE
Equipo PJ GF GC Puntos
1 Cardiff MU Cardiff MU 30 63 26 62
2 Barry Town Barry Town 30 62 33 58
3 Goytre AFC Goytre AFC 30 72 36 56
4 Caerau Ely Caerau Ely 30 60 43 51
5 Cambrian & Clydach Cambrian 30 48 39 50
6 Taffs Well Taffs Well 30 58 50 50
7 Goytre United Goytre 30 45 47 43
8 Afan Lido Afan Lido 30 53 53 42
9 Ton Pentre Ton Pentre 30 45 52 40
10 Risca United Risca United 30 48 48 39
11 Monmouth Town FC Monmouth 30 56 60 39
12 Briton Ferry Briton Ferry 30 41 49 39
13 Penybont Penybont 30 53 57 37
14 Aberdare Town FC Aberdare 30 33 57 34
15 Aberbargoed Buds Aberbargoed 30 42 63 27
16 Garden Village Garden 30 27 93 7
TEMPORADA 2014/2015
SEGUNDA GALES FOOTBALL LEAGUE
Equipo PJ GF GC Puntos
1 Caerau Ely Caerau Ely 30 75 39 68
2 Haverfordwest County Haverfordwes 30 69 32 63
3 Cardiff MU Cardiff MU 30 57 20 63
4 Goytre United Goytre 30 74 41 56
5 Penybont Penybont 30 73 52 56
6 Monmouth Town FC Monmouth 30 57 35 51
7 Briton Ferry Briton Ferry 30 52 37 48
8 Taffs Well Taffs Well 30 61 45 47
9 Ton Pentre Ton Pentre 30 44 54 40
10 Goytre AFC Goytre AFC 30 46 47 36
11 Aberdare Town FC Aberdare 30 48 68 35
12 Garden Village Garden 30 49 61 34
13 Afan Lido Afan Lido 30 40 60 33
14 Cambrian & Clydach Cambrian 30 45 46 28
15 Pontardawe Town Pontardawe 30 28 66 18
16 AFC Porth AFC Porth 30 16 131 1
TEMPORADA 2013/2014
SEGUNDA GALES FOOTBALL LEAGUE
Equipo PJ GF GC Puntos
1 Taffs Well Taffs Well 25 55 21 58
2 Monmouth Town FC Monmouth 25 66 29 52
3 Goytre AFC Goytre AFC 27 41 36 48
4 Cambrian & Clydach Cambrian 23 51 31 44
5 Haverfordwest County Haverfordwes 24 46 30 42
6 Caerau Ely Caerau Ely 26 46 41 42
7 Aberdare Town FC Aberdare 25 45 40 38
8 Penybont Penybont 21 43 29 34
9 AFC Porth AFC Porth 25 38 40 32
10 Goytre United Goytre 21 45 30 30
11 Ton Pentre Ton Pentre 25 27 37 29
12 Pontardawe Town Pontardawe 24 29 49 28
13 Tata Steel F.C Tata Steel 27 25 60 22
14 Cwmbran Celtic Cwmbran 26 33 51 20
15 Aberbargoed Buds Aberbargoed 26 28 55 14
16 West End West End 24 29 68 13
TEMPORADA 2012/2013
SEGUNDA GALES FOOTBALL LEAGUE
Equipo PJ GF GC Puntos
1 West End West End 28 64 29 58
2 Cambrian & Clydach Cambrian 28 56 26 56
3 Taffs Well Taffs Well 28 57 39 49
4 Haverfordwest County Haverfordwes 28 63 35 47
5 Aberdare Town FC Aberdare 28 45 35 47
6 AFC Porth AFC Porth 28 39 34 46
7 Monmouth Town FC Monmouth 28 54 43 42
8 Bryntirion Athletic Bryntirion 28 38 40 39
9 Ton Pentre Ton Pentre 28 39 39 36
10 Pontardawe Town Pontardawe 28 34 39 35
11 Goytre United Goytre 28 33 51 34
12 Cwmbran Celtic Cwmbran 28 41 52 32
13 Bridgend Town Bridgend 28 28 51 31
14 Tata Steel F.C Tata Steel 28 28 61 21
15 Caerleon Caerleon 28 18 63 7
16 Barry Town Barry Town 0 0 0 0
TEMPORADA 2011/2012
SEGUNDA GALES FOOTBALL LEAGUE
Equipo PJ GF GC Puntos
1 Cambrian & Clydach Cambrian 30 78 25 58
2 Taffs Well Taffs Well 30 60 42 52
3 Haverfordwest County Haverfordwes 30 58 43 52
4 Bryntirion Athletic Bryntirion 30 52 43 51
5 AFC Porth AFC Porth 30 54 36 48
6 Barry Town Barry Town 30 48 37 46
7 Goytre United Goytre 30 71 55 44
8 Bridgend Town Bridgend 30 50 41 44
9 Ton Pentre Ton Pentre 30 48 40 43
10 Pontardawe Town Pontardawe 30 48 53 42
11 West End West End 30 53 63 38
12 Cwmbran Celtic Cwmbran 30 32 54 38
13 Aberdare Town FC Aberdare 30 47 55 33
14 Cwmaman Institute Cwmaman 30 36 59 29
15 Cardiff Corinthians Cardiff 30 50 67 28
16 Caerau Ely Caerau Ely 30 37 109 15
TEMPORADA 2010/2011
SEGUNDA GALES FOOTBALL LEAGUE
Equipo PJ GF GC Puntos
1 Bryntirion Athletic Bryntirion 30 76 27 70
2 Afan Lido Afan Lido 30 63 28 65
3 Cambrian & Clydach Cambrian 30 68 37 57
4 Pontardawe Town Pontardawe 30 54 44 51
5 Caerau Ely Caerau Ely 30 66 52 49
6 Bridgend Town Bridgend 30 60 47 47
7 West End West End 30 57 47 45
8 Cardiff Corinthians Cardiff 30 58 52 40
9 Taffs Well Taffs Well 30 47 57 39
10 Aberdare Town FC Aberdare 30 58 74 39
11 Goytre United Goytre 30 47 53 38
12 Cwmbran Celtic Cwmbran 30 45 50 37
13 Barry Town Barry Town 30 39 55 35
14 Caldicot Town Caldicot 30 37 48 27
15 Garden Village Garden 30 41 75 25
16 Penrhiwceiber Rangers Penrhiwceibe 30 27 97 16
TEMPORADA 2009/2010
SEGUNDA GALES FOOTBALL LEAGUE
Equipo PJ GF GC Puntos
1 Goytre United Goytre 34 86 47 69
2 Cambrian & Clydach Cambrian 34 73 42 68
3 Afan Lido Afan Lido 34 74 37 63
4 Caldicot Town Caldicot 34 78 54 55
5 Bryntirion Athletic Bryntirion 34 67 60 54
6 Taffs Well Taffs Well 34 72 60 50
7 Barry Town Barry Town 34 46 41 49
8 Pontardawe Town Pontardawe 34 59 56 47
9 Bridgend Town Bridgend 34 57 55 45
10 Aberdare Town FC Aberdare 34 56 68 44
11 West End West End 34 62 84 44
12 Cardiff Corinthians Cardiff 34 63 69 43
13 Garden Village Garden 34 46 52 42
14 Ton Pentre Ton Pentre 34 56 65 41
15 Ely Rangers Ely Rangers 34 46 67 36
16 Bettws FC Bettws FC 34 38 59 36
17 Dinas Powys Dinas Powys 34 50 83 31
18 Caerleon Caerleon 34 37 67 30
TEMPORADA 2008/2009
SEGUNDA GALES FOOTBALL LEAGUE
Equipo PJ GF GC Puntos
1 Aberdare Town FC Aberdare 34 73 33 77
2 Goytre United Goytre 34 90 39 76
3 Barry Town Barry Town 34 63 26 70
4 Bettws FC Bettws FC 34 64 32 62
5 Bridgend Town Bridgend 34 65 49 60
6 Cambrian & Clydach Cambrian 34 62 48 57
7 Afan Lido Afan Lido 34 70 49 54
8 Pontardawe Town Pontardawe 34 48 32 52
9 Ton Pentre Ton Pentre 34 59 51 49
10 Cardiff Corinthians Cardiff 34 51 53 46
11 Bryntirion Athletic Bryntirion 34 54 58 44
12 Dinas Powys Dinas Powys 34 43 73 35
13 Caldicot Town Caldicot 34 41 67 34
14 Caerleon Caerleon 34 36 64 34
15 Taffs Well Taffs Well 34 43 58 33
16 Newport YMCA Newport YMCA 34 41 76 28
17 Croesyceiliog Croesyceilio 34 45 82 26
18 Cwmbran Town Cwmbran Town 34 32 90 16
TEMPORADA 2007/2008
SEGUNDA GALES FOOTBALL LEAGUE
Equipo PJ GF GC Puntos
1 Goytre United Goytre 34 101 30 78
2 Dinas Powys Dinas Powys 34 92 34 76
3 Ton Pentre Ton Pentre 34 102 33 73
4 Aberdare Town FC Aberdare 34 75 40 69
5 Bryntirion Athletic Bryntirion 34 82 35 65
6 Afan Lido Afan Lido 34 58 31 62
7 Newport YMCA Newport YMCA 34 88 70 61
8 Caerleon Caerleon 34 60 42 55
9 Cambrian & Clydach Cambrian 34 59 47 49
10 Bridgend Town Bridgend 34 84 68 45
11 Caldicot Town Caldicot 34 54 65 42
12 Taffs Well Taffs Well 34 53 70 40
13 Cwmbran Town Cwmbran Town 34 56 50 38
14 Croesyceiliog Croesyceilio 34 60 80 32
15 Maesteg Park Maesteg Park 34 43 83 27
16 Pontypridd United Pontypridd 34 38 116 13
17 Garw Athletic Garw 34 14 217 4

  USO DE MEMORIA  
7,174,944 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1401
Total Execution Time  0.1415
  CADENA URL  
/historico/Cambrian-Clydach
  GET DATOS  
$_GET['/historico/Cambrian-Clydach']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0032  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 = 'Cambrian-Clydach' 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=12986 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=12986 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=12986 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=12986 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0039  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 72374
0.0025  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 73677
0.0025  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 72392
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12986 AND type_rel = 2
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2158 AND type_rel = 3
0.0022  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.0019  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.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 = '12986' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '12986' 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,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 73677 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72374 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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=12986 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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,72374) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 72374 AND teamId = 12986
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 73677 AND teamId = 12986
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 72392 AND teamId = 12986
0.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 72374 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0035  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 = 72374 WHERE rp.league_id = 72374 AND rp.teamId = 12986 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.0037  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 = 72374 WHERE rp.league_id = 72374 AND rp.teamId = 12986 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 72374 WHERE rp.league_id = 72374 AND rp.teamId = 12986 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 12986 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0025  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 = 72374 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.0022  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 = 68118 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.0022  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 = 63090 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.0026  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 `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 = 50644 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 `tables2018` 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 = 43689 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 `tables2017` 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 = 33370 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 `tables2016` 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 = 15916 AND t.round = 30 ORDER BY team.conference 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 `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 = 4490 AND t.round = 30 ORDER BY team.conference 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 `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 = 2808 AND t.round = 24 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 `tables2013` 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 = 15303 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables2012` 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 = 15302 AND t.round = 30 ORDER BY team.conference 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 `tables2011` 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 = 15301 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 `tables2010` 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 = 15300 AND t.round = 34 ORDER BY team.conference 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 `tables2009` 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 = 15299 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables2008` 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 = 15298 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC