4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Flint Town United
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 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
TEMPORADA 2022/2023
LIGA GALES GRUPO 3
Equipo PJ GF GC Puntos
1 Haverfordwest County Haverfordwes 32 49 44 47
2 Pontypridd United Pontypridd 32 41 52 41
3 Caernarfon Town FC Caernarfon 32 51 54 39
4 Aberystwyth Town Aberystwyth 32 41 73 38
5 Flint Town United Flint Town. 32 41 53 35
6 Airbus UK Airbus UK 32 18 100 0
TEMPORADA 2021/2022
LIGA GALES GRUPO 2
Equipo PJ GF GC Puntos
1 The New Saints Saints 32 86 26 80
2 Bala Town Bala Town 32 67 37 59
3 Newtown Newtown 32 50 35 51
4 Caernarfon Town FC Caernarfon 32 46 53 43
5 Flint Town United Flint Town. 32 51 53 42
6 Penybont Penybont 32 49 57 40
TEMPORADA 2020/2021
LIGA GALES GRUPO 3
Equipo PJ GF GC Puntos
1 Cardiff MU Cardiff MU 10 29 11 23
2 Newtown Newtown 10 28 12 22
3 Flint Town United Flint Town. 10 17 5 17
4 Aberystwyth Town Aberystwyth 10 17 13 12
5 Haverfordwest County Haverfordwes 10 9 21 8
6 Cefn Druids AFC Cefn Druids 10 4 42 3
TEMPORADA 2019/2020
FAW CHAMPIONSHIP GALES GRUPO 1
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
TEMPORADA 2018/2019
SEGUNDA GALES CYMRU ALLIANCE
Equipo PJ GF GC Puntos
1 Airbus UK Airbus UK 30 75 20 76
2 Flint Town United Flint Town. 30 52 31 58
3 Porthmadog Porthmadog 30 60 32 57
4 Bangor City Bangor City 30 68 48 51
5 Rhyl FC Rhyl FC 30 55 44 51
6 Guilsfield FC Guilsfield 30 43 45 45
7 Ruthin Town Ruthin Town 30 46 47 43
8 Buckley Town Buckley Town 30 51 50 42
9 Prestatyn Town Prestatyn 30 52 49 39
10 Gresford Athletic Gresford 30 42 46 39
11 Conwy Borough FC Conwy 30 46 42 36
12 Llanrhaeadr FC Llanrhaeadr 30 34 71 32
13 Penrhyncoch FC Penrhyncoch 30 35 44 30
14 Holywell Holywell 30 38 58 30
15 Denbigh Town Denbigh Town 30 37 65 29
16 Holyhead Hotspur Holyhead 30 29 71 19
TEMPORADA 2017/2018
SEGUNDA GALES CYMRU ALLIANCE
Equipo PJ GF GC Puntos
1 Caernarfon Town FC Caernarfon 28 98 31 65
2 Denbigh Town Denbigh Town 28 69 43 60
3 Airbus UK Airbus UK 28 67 42 54
4 Guilsfield FC Guilsfield 28 54 38 53
5 Holywell Holywell 28 75 37 50
6 Rhyl FC Rhyl FC 28 62 45 47
7 Porthmadog Porthmadog 28 70 46 44
8 Gresford Athletic Gresford 28 57 57 39
9 Penrhyncoch FC Penrhyncoch 28 45 46 39
10 Flint Town United Flint Town. 28 49 42 36
11 Ruthin Town Ruthin Town 28 51 49 35
12 Holyhead Hotspur Holyhead 28 40 57 30
13 Caersws Caersws 28 39 72 18
14 Queens Park Queens Park 28 26 110 9
15 Llandudno Junction Llandudno 28 28 115 7
TEMPORADA 2016/2017
SEGUNDA GALES CYMRU ALLIANCE
Equipo PJ GF GC Puntos
1 Prestatyn Town Prestatyn 30 114 35 80
2 Caernarfon Town FC Caernarfon 30 83 45 64
3 Gresford Athletic Gresford 30 67 47 56
4 Porthmadog Porthmadog 30 64 48 50
5 Holywell Holywell 30 52 45 50
6 Flint Town United Flint Town. 30 62 47 48
7 Caersws Caersws 30 61 60 48
8 Guilsfield FC Guilsfield 30 54 46 43
9 Holyhead Hotspur Holyhead 30 57 52 42
10 Denbigh Town Denbigh Town 30 57 62 38
11 Penrhyncoch FC Penrhyncoch 30 39 48 34
12 Ruthin Town Ruthin Town 30 49 72 33
13 Llanfair United Llanfair 30 37 69 25
14 Mold Alexandra Mold 30 44 91 25
15 Conwy Borough FC Conwy 30 53 83 24
16 Buckley Town Buckley Town 30 38 81 22
TEMPORADA 2015/2016
SEGUNDA GALES CYMRU ALLIANCE
Equipo PJ GF GC Puntos
1 Caernarfon Town FC Caernarfon 30 95 23 75
2 Cefn Druids AFC Cefn Druids 30 62 33 66
3 Denbigh Town Denbigh Town 30 72 46 63
4 Guilsfield FC Guilsfield 30 60 44 53
5 Holywell Holywell 30 55 34 52
6 Gresford Athletic Gresford 30 45 44 49
7 Holyhead Hotspur Holyhead 30 44 40 46
8 Prestatyn Town Prestatyn 30 61 50 45
9 Flint Town United Flint Town. 30 54 45 42
10 Porthmadog Porthmadog 30 47 54 41
11 Conwy Borough FC Conwy 30 47 54 36
12 Buckley Town Buckley Town 30 45 65 32
13 Mold Alexandra Mold 30 38 59 31
14 Caersws Caersws 30 40 67 26
15 Llanfair United Llanfair 30 35 70 21
16 Rhayader Town FC Rhayader 30 24 96 15
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
TEMPORADA 2012/2013
SEGUNDA GALES CYMRU ALLIANCE
Equipo PJ GF GC Puntos
1 Rhyl FC Rhyl FC 30 100 24 78
2 Cefn Druids AFC Cefn Druids 30 79 32 69
3 Conwy Borough FC Conwy 30 57 37 61
4 Caersws Caersws 30 90 42 57
5 Buckley Town Buckley Town 30 60 35 49
6 Flint Town United Flint Town. 30 61 51 48
7 Holyhead Hotspur Holyhead 30 51 55 43
8 Guilsfield FC Guilsfield 30 61 54 42
9 Porthmadog Porthmadog 30 48 52 38
10 Penrhyncoch FC Penrhyncoch 30 50 63 34
11 Rhayader Town FC Rhayader 30 44 66 33
12 Llandudno FC Llandudno 30 36 59 32
13 Penycae FC Penycae FC 30 49 84 26
14 Rhydymwyn FC Rhydymwyn 30 49 96 26
15 Llanrhaeadr FC Llanrhaeadr 30 29 87 19
16 Ruthin Town Ruthin Town 30 47 74 16
TEMPORADA 2011/2012
SEGUNDA GALES CYMRU ALLIANCE
Equipo PJ GF GC Puntos
1 Connah's Quay Connah's 30 89 23 68
2 Rhyl FC Rhyl FC 30 80 22 62
3 Buckley Town Buckley Town 30 67 43 61
4 Porthmadog Porthmadog 30 68 41 59
5 Penrhyncoch FC Penrhyncoch 30 56 44 55
6 Cefn Druids AFC Cefn Druids 30 58 42 54
7 Caersws Caersws 30 68 49 52
8 Llandudno FC Llandudno 30 55 40 49
9 Flint Town United Flint Town. 30 59 47 46
10 Conwy Borough FC Conwy 30 59 65 37
11 Guilsfield FC Guilsfield 30 41 58 34
12 Ruthin Town Ruthin Town 30 28 60 25
13 Penycae FC Penycae FC 30 30 76 25
14 Llanrhaeadr FC Llanrhaeadr 30 40 77 18
15 Llangefni Town FC Llangefni 30 32 96 14
16 Rhos Aelwyd Rhos Aelwyd 30 29 76 13
TEMPORADA 2010/2011
SEGUNDA GALES CYMRU ALLIANCE
Equipo PJ GF GC Puntos
1 Connah's Quay Connah's 30 89 33 71
2 Rhyl FC Rhyl FC 30 73 32 62
3 Cefn Druids AFC Cefn Druids 30 60 29 60
4 Rhos Aelwyd Rhos Aelwyd 30 68 64 51
5 Caersws Caersws 30 59 49 50
6 Llandudno FC Llandudno 30 50 35 49
7 Flint Town United Flint Town. 30 64 55 46
8 Porthmadog Porthmadog 30 59 53 46
9 Buckley Town Buckley Town 30 46 48 45
10 Llangefni Town FC Llangefni 30 67 64 37
11 Penrhyncoch FC Penrhyncoch 30 49 56 37
12 Ruthin Town Ruthin Town 30 39 58 37
13 Guilsfield FC Guilsfield 30 43 56 30
14 Rhydymwyn FC Rhydymwyn 30 27 82 18
15 Rhayader Town FC Rhayader 30 34 76 15
16 Welshpool Town FC Welshpool 30 39 76 3
TEMPORADA 2009/2010
SEGUNDA GALES CYMRU ALLIANCE
Equipo PJ GF GC Puntos
1 Llangefni Town FC Llangefni 32 95 27 79
2 Flint Town United Flint Town. 32 84 29 75
3 Llandudno FC Llandudno 32 73 31 65
4 Buckley Town Buckley Town 32 57 30 60
5 Penrhyncoch FC Penrhyncoch 32 51 46 55
6 Guilsfield FC Guilsfield 32 54 54 45
7 Ruthin Town Ruthin Town 32 48 61 44
8 Holyhead Hotspur Holyhead 32 53 52 40
9 Bethesda Athletic Bethesda 32 70 59 39
10 Denbigh Town Denbigh Town 32 56 56 39
11 Llangollen Town Llangollen 32 59 78 36
12 Berriew FC Berriew FC 32 49 74 35
13 Mold Alexandra Mold 32 53 80 35
14 Lex XI Lex XI 32 45 70 34
15 Llanfairpwll FC Llanfairpwll 32 38 60 32
16 Caernarfon Town FC Caernarfon 32 50 69 26
17 Gresford Athletic Gresford 32 28 87 20
TEMPORADA 2008/2009
SEGUNDA GALES CYMRU ALLIANCE
Equipo PJ GF GC Puntos
1 Bala Town Bala Town 32 81 23 75
2 Holyhead Hotspur Holyhead 32 71 36 72
3 Llangefni Town FC Llangefni 32 74 27 67
4 Mynydd Isa Mynydd Isa 32 73 51 61
5 Llandudno FC Llandudno 32 65 33 57
6 Ruthin Town Ruthin Town 32 56 50 57
7 Flint Town United Flint Town. 32 81 52 54
8 Buckley Town Buckley Town 32 46 64 41
9 Lex XI Lex XI 32 58 63 40
10 Mold Alexandra Mold 32 62 71 39
11 Llanfairpwll FC Llanfairpwll 32 47 67 36
12 Denbigh Town Denbigh Town 32 40 49 35
13 Guilsfield FC Guilsfield 32 52 67 34
14 Penrhyncoch FC Penrhyncoch 32 41 72 32
15 Gresford Athletic Gresford 32 32 63 27
16 Glantraeth FC Glantraeth 32 40 82 18
17 Llandyrnog United Llandyrnog 32 33 82 12
TEMPORADA 2007/2008
SEGUNDA GALES CYMRU ALLIANCE
Equipo PJ GF GC Puntos
1 Prestatyn Town Prestatyn 32 93 29 76
2 Bala Town Bala Town 32 71 42 61
3 Flint Town United Flint Town. 32 62 42 58
4 Llandudno FC Llandudno 32 58 36 56
5 Holyhead Hotspur Holyhead 32 76 53 54
6 Queens Park Queens Park 32 82 47 52
7 Glantraeth FC Glantraeth 32 64 55 51
8 Denbigh Town Denbigh Town 32 52 50 46
9 Guilsfield FC Guilsfield 32 57 62 41
10 Llanfairpwll FC Llanfairpwll 32 59 71 40
11 Mynydd Isa Mynydd Isa 32 45 51 39
12 Llandyrnog United Llandyrnog 32 54 69 38
13 Ruthin Town Ruthin Town 32 41 63 36
14 Buckley Town Buckley Town 32 45 80 30
15 Penrhyncoch FC Penrhyncoch 32 38 66 26
16 Lex XI Lex XI 32 44 85 22
17 Gresford Athletic Gresford 32 32 72 18

  USO DE MEMORIA  
7,301,728 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.6964
Total Execution Time  0.6983
  CADENA URL  
/historico/Flint-Town-United
  GET DATOS  
$_GET['/historico/Flint-Town-United']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (51)  
0.0123  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 = 'Flint-Town-United' 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.0107  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=13007 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=13007 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=13007 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=13007 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=13007 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0215  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 = 72373
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13007 AND type_rel = 2
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2158 AND type_rel = 3
0.0116  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.0107  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.0113  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 = '13007' ORDER BY l.year DESC,cat.coefficient DESC
0.0110  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 = '13007' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0111  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 = '13007' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0116  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 = 72373 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0113  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=13007 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0107  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,71432,70948) 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.0107  SELECT count(id) as num_players from rel_players WHERE league_id = 70948 AND teamId = 13007
0.0108  SELECT count(id) as num_players from rel_players WHERE league_id = 72373 AND teamId = 13007
0.0117  SELECT count(id) as num_players from rel_players WHERE league_id = 73677 AND teamId = 13007
0.0108  SELECT count(id) as num_players from rel_players WHERE league_id = 72392 AND teamId = 13007
0.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 13007
0.0126  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 = 72373 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0113  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 = '13007' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0110  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '13007' and rp.type = 4
0.0114  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 = '13007' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0183  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 = 13007 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.0122  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 = 13007 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0114  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 = 13007 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0111  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 = 13007 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.0108  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 = 68116 AND t.round = 22 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 `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 = 70948 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 63211 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 66868 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `tables2021` 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 = 58691 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 `tables2021` 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 = 62041 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 50643 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.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 `tables2019` 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 = 44120 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 38811 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 33369 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113  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 = 15917 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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.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 `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
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 `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 = 15294 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 15293 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0118  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 = 15292 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0122  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 = 15291 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 15290 AND t.round = 31 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  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 = 15289 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 72373 ORDER BY nameShow LIMIT 100