4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Peña Azagresa
TEMPORADA 2023/2024
AUTONÓMICA NAVARRA
Equipo PJ GF GC Puntos
1 Rotxapea CD Rotxapea CD 30 47 26 61
2 Mutilvera B Mutilvera B 30 47 30 56
3 CD Injerto CD Injerto 30 53 33 49
4 CD Ondalán CD Ondalán 30 53 45 49
5 Gares Gares 30 46 32 48
6 Artajonés Artajonés 30 49 51 48
7 Baztan Baztan 30 56 47 47
8 Peña Azagresa Peña 30 46 43 47
9 Erriberri Erriberri 30 34 34 47
10 CD Iruña CD Iruña 30 49 38 44
11 Aoiz Aoiz 30 40 33 43
12 Aluvión Aluvión 30 39 45 36
13 CD San Miguel Miguel 30 34 54 34
14 Idoya Idoya 30 45 52 34
15 CD Amigó CD Amigó 30 39 44 33
16 Corellano Corellano 30 50 44 33
17 Azkoyen Azkoyen 30 29 56 28
18 Murchante Murchante 30 21 70 12
TEMPORADA 2022/2023
AUTONÓMICA NAVARRA GRUPO 3
Equipo PJ GF GC Puntos
1 CD Lerinés CD Lerinés 30 65 34 60
2 FC Bidezarra Bidezarra 32 50 31 60
3 Beti Kozkor Beti Kozkor 30 48 30 58
4 Aoiz Aoiz 32 50 32 51
5 CD Iruña CD Iruña 30 34 29 49
6 Erriberri Erriberri 32 61 49 48
7 Peña Azagresa Peña 32 47 51 45
8 Gares Gares 30 51 51 44
9 Idoya Idoya 32 56 65 42
10 Mutilvera B Mutilvera B 30 51 43 40
TEMPORADA 2021/2022
AUTONÓMICA NAVARRA GRUPO 5
Equipo PJ GF GC Puntos
1 Zarramonza Zarramonza 36 59 44 62
2 Peña Azagresa Peña 36 56 44 57
3 Artajonés Artajonés 36 60 51 57
4 Lourdes Lourdes 36 65 53 55
5 Mendi Mendi 36 52 40 54
6 Aoiz Aoiz 36 65 58 54
7 CF Beti Casedano Beti 36 49 54 52
8 Burladés B Burladés B 36 53 51 51
9 CD Zirauki CD Zirauki 36 55 63 44
10 Doneztebe Doneztebe 36 61 79 41
11 Lagun Artea Lagun Artea 36 45 57 40
12 Universidad de Navarra Universidad 36 48 57 40
13 CD Muskaria CD Muskaria 36 37 78 31
14 Aluvión Aluvión 36 42 88 26
15 CD Fontellas Fontellas 36 28 80 18
TEMPORADA 2020/2021
TERCERA DIVISIÓN GRUPO 15
Equipo PJ GF GC Puntos
1 AD San Juan AD San Juan 20 21 9 35
2 Beti Kozkor Beti Kozkor 20 23 18 33
3 CD Valle de Egüés Valle 20 31 23 32
4 CD Itaroa Huarte Itaroa 20 29 23 30
5 CD Pamplona CD Pamplona 20 28 18 30
6 Burladés Burladés 20 22 30 26
7 Beti Onak Beti Onak 20 26 25 24
8 Corellano Corellano 20 24 29 24
9 Txantrea Txantrea 20 23 29 23
10 Subiza Subiza 20 25 28 21
11 River Ega River Ega 20 23 43 14
12 Peña Sport Peña Sport 20 32 14 47
13 Cirbonero Cirbonero 20 35 21 32
14 CF Ardoi CF Ardoi 20 26 15 32
15 Cantolagua Cantolagua 20 28 19 31
16 CD Cortes CD Cortes 20 18 21 28
17 Murchante Murchante 20 19 19 24
18 Peña Azagresa Peña 20 24 33 24
19 Baztan Baztan 20 19 27 20
20 CD Fontellas Fontellas 20 18 37 20
21 Lourdes Lourdes 20 18 26 19
22 FC Bidezarra Bidezarra 20 18 23 19
TEMPORADA 2019/2020
TERCERA DIVISIÓN GRUPO 15
Equipo PJ GF GC Puntos
1 Mutilvera Mutilvera 27 57 27 58
2 AD San Juan AD San Juan 27 49 23 55
3 Beti Kozkor Beti Kozkor 27 42 27 52
4 CD Pamplona CD Pamplona 27 36 18 50
5 CD Itaroa Huarte Itaroa 27 40 26 47
6 Peña Sport Peña Sport 27 44 35 45
7 Cirbonero Cirbonero 27 52 38 44
8 Txantrea Txantrea 27 45 34 41
9 Burladés Burladés 27 31 34 37
10 CD Valle de Egüés Valle 27 45 41 35
11 Beti Onak Beti Onak 27 32 38 35
12 CD Cortes CD Cortes 27 27 23 32
13 Corellano Corellano 27 29 42 32
14 Murchante Murchante 27 27 30 31
15 Lourdes Lourdes 27 28 37 30
16 CF Ardoi CF Ardoi 27 29 39 30
17 Peña Azagresa Peña 27 39 53 25
18 Subiza Subiza 27 34 49 24
19 Baztan Baztan 27 30 57 19
20 CD Fontellas Fontellas 27 16 61 13
TEMPORADA 2018/2019
AUTONÓMICA NAVARRA
Equipo PJ GF GC Puntos
1 Peña Azagresa Peña 34 67 31 73
2 CD Fontellas Fontellas 34 58 42 61
3 Murchante Murchante 34 47 37 56
4 Oberena Oberena 34 52 37 53
5 Lourdes Lourdes 34 54 44 52
6 Mendi Mendi 33 52 42 49
7 Aoiz Aoiz 34 42 42 49
8 Gares Gares 34 40 42 48
9 River Ega River Ega 34 60 48 46
10 FC Bidezarra Bidezarra 34 34 40 45
11 Azkoyen Azkoyen 33 42 42 43
12 Erriberri Erriberri 33 48 53 43
13 CD Iruña CD Iruña 34 52 49 42
14 Idoya Idoya 34 44 54 41
15 Infanzones Infanzones 33 47 65 39
16 CF Beti Casedano Beti 34 47 64 38
17 Valtierrano Valtierrano 34 38 55 36
18 CD Ablitense Ablitense 34 36 73 26
TEMPORADA 2017/2018
AUTONÓMICA NAVARRA
Equipo PJ GF GC Puntos
1 Beti Onak Beti Onak 34 71 40 68
2 Avance Ezcabarte Avance 34 56 28 67
3 CD Alesves CD Alesves 34 51 41 55
4 Peña Azagresa Peña 34 51 42 52
5 FC Bidezarra Bidezarra 34 44 35 49
6 Lourdes Lourdes 34 45 40 47
7 Valtierrano Valtierrano 34 41 41 47
8 CF Beti Casedano Beti 34 54 50 46
9 Erriberri Erriberri 34 46 45 46
10 Mendi Mendi 34 51 42 44
11 Aoiz Aoiz 34 42 44 44
12 Aluvión Aluvión 34 47 51 44
13 CD Ilumberri Ilumberri 34 36 48 44
14 CD Ablitense Ablitense 34 40 60 44
15 CD Ondalán CD Ondalán 34 37 44 43
16 CD Zirauki CD Zirauki 34 47 63 40
17 Cd Larrate Cd Larrate 34 45 57 31
18 AD San Juan B Juan 34 45 78 28
TEMPORADA 2016/2017
AUTONÓMICA NAVARRA
Equipo PJ GF GC Puntos
1 Beti Kozkor Beti Kozkor 34 55 37 70
2 Gares Gares 34 49 28 60
3 Peña Azagresa Peña 34 68 46 59
4 Baztan Baztan 34 56 38 57
5 Avance Ezcabarte Avance 34 39 38 53
6 Aoiz Aoiz 34 53 61 51
7 Beti Onak Beti Onak 34 52 54 47
8 CD Ilumberri Ilumberri 34 55 47 46
9 AD San Juan B Juan 34 52 50 46
10 Aluvión Aluvión 34 47 46 46
11 CD Ablitense Ablitense 34 44 50 46
12 CD Alesves CD Alesves 34 55 53 45
13 Mendi Mendi 34 45 44 43
14 CD Zirauki CD Zirauki 34 43 62 42
15 Infanzones Infanzones 34 62 60 41
16 Azkoyen Azkoyen 34 32 46 36
17 Lagunak Lagunak 34 39 57 36
18 CD Cabanillas Cabanillas 34 30 59 27
TEMPORADA 2015/2016
AUTONÓMICA NAVARRA
Equipo PJ GF GC Puntos
1 Lourdes Lourdes 34 70 45 63
2 Idoya Idoya 34 55 33 60
3 Valtierrano Valtierrano 34 52 42 58
4 Corellano Corellano 34 56 40 56
5 Avance Ezcabarte Avance 34 63 58 55
6 Peña Azagresa Peña 34 60 52 52
7 Lagunak Lagunak 34 52 43 52
8 AD San Juan B Juan 34 40 28 51
9 Azkoyen Azkoyen 34 50 51 48
10 CD Zirauki CD Zirauki 34 45 51 47
11 Aoiz Aoiz 34 41 44 46
12 Beti Kozkor Beti Kozkor 34 56 50 45
13 CD Ilumberri Ilumberri 34 55 61 44
14 Aluvión Aluvión 34 50 57 44
15 CD Tudela 1999 Tudela 1999 34 35 56 35
16 Artajonés Artajonés 34 44 61 34
17 Murchante Murchante 34 41 64 32
18 CD Buñuel CD Buñuel 34 35 64 19
TEMPORADA 2014/2015
AUTONÓMICA NAVARRA GRUPO 2
Equipo PJ GF GC Puntos
1 River Ega River Ega 30 56 34 62
2 Erriberri Erriberri 30 44 26 48
3 Lourdes Lourdes 30 55 48 47
4 Artajonés Artajonés 30 36 32 47
5 Peña Azagresa Peña 30 48 40 46
6 Azkoyen Azkoyen 30 40 35 43
7 Murchante Murchante 30 39 40 39
8 Aluvión Aluvión 30 49 53 37
9 CD Buñuel CD Buñuel 30 54 55 36
10 CD Tudela 1999 Tudela 1999 30 49 57 36
11 CD Ondalán CD Ondalán 30 35 40 35
12 La Peña La Peña 30 39 47 35
13 Zarramonza Zarramonza 30 32 40 34
14 CD Falcesino Falcesino 30 39 51 34
15 CD Lerinés CD Lerinés 30 47 58 33
16 CD Castejón Castejón 30 43 49 32
TEMPORADA 2013/2014
AUTONÓMICA NAVARRA GRUPO 2
Equipo PJ GF GC Puntos
1 Idoya Idoya 30 45 17 65
2 Mendi Mendi 30 50 26 58
3 CD Tudela 1999 Tudela 1999 30 61 35 58
4 River Ega River Ega 30 49 27 57
5 Azkoyen Azkoyen 30 49 38 47
6 CD Buñuel CD Buñuel 30 38 47 41
7 Aluvión Aluvión 30 45 50 40
8 Lourdes Lourdes 30 43 37 40
9 Peña Azagresa Peña 30 43 40 40
10 La Peña La Peña 30 37 38 38
11 CD Falcesino Falcesino 30 41 42 36
12 CD Ondalán CD Ondalán 30 35 43 35
13 Zarramonza Zarramonza 30 33 45 33
14 Cd Larrate Cd Larrate 30 34 56 29
15 Ribaforada Ribaforada 30 29 53 27
16 San Adrián San Adrián 30 27 65 15
TEMPORADA 2010/2011
TERCERA DIVISIÓN GRUPO 15
Equipo PJ GF GC Puntos
1 Tudelano Tudelano 38 87 24 90
2 Nivel Andalucia Pizarra Nivel 38 78 24 83
3 CD Valle de Egüés Valle 38 57 45 67
4 Mutilvera Mutilvera 38 60 34 66
5 Txantrea Txantrea 38 57 35 65
6 CD Iruña CD Iruña 38 52 36 59
7 AD San Juan AD San Juan 38 38 30 56
8 Cirbonero Cirbonero 38 51 46 53
9 Lourdes Lourdes 38 52 57 53
10 Oberena Oberena 38 40 39 52
11 CD Pamplona CD Pamplona 38 51 49 49
12 Murchante Murchante 38 50 57 45
13 CD Itaroa Huarte Itaroa 38 45 48 44
14 Aoiz Aoiz 38 37 49 42
15 Aluvión Aluvión 38 34 44 41
16 Idoya Idoya 38 51 77 41
17 CF Ardoi CF Ardoi 38 29 57 38
18 Lagun Artea Lagun Artea 38 38 80 37
19 River Ega River Ega 38 26 73 27
20 Peña Azagresa Peña 38 34 63 25
TEMPORADA 2009/2010
TERCERA DIVISIÓN GRUPO 15
Equipo PJ GF GC Puntos
1 Tudelano Tudelano 38 87 29 89
2 Peña Sport Peña Sport 38 87 27 82
3 Cirbonero Cirbonero 38 57 38 71
4 CD Iruña CD Iruña 38 58 35 69
5 Mutilvera Mutilvera 38 69 46 65
6 AD San Juan AD San Juan 38 50 36 58
7 CD Valle de Egüés Valle 38 51 43 57
8 Txantrea Txantrea 38 40 38 52
9 Lourdes Lourdes 38 67 64 52
10 Oberena Oberena 38 62 49 49
11 CD Pamplona CD Pamplona 38 33 45 48
12 Aoiz Aoiz 38 36 39 48
13 Aluvión Aluvión 38 44 61 44
14 River Ega River Ega 38 33 38 41
15 Peña Azagresa Peña 38 44 61 41
16 Murchante Murchante 38 29 50 40
17 CD Itaroa Huarte Itaroa 38 38 59 39
18 Valtierrano Valtierrano 38 34 91 36
19 Zarramonza Zarramonza 38 28 58 34
20 CD Cortes CD Cortes 38 25 65 23
TEMPORADA 2008/2009
TERCERA DIVISIÓN GRUPO 15
Equipo PJ GF GC Puntos
1 Izarra Izarra 36 75 27 82
2 Peña Sport Peña Sport 36 72 31 79
3 Tudelano Tudelano 36 65 32 69
4 Mutilvera Mutilvera 37 61 36 67
5 AD San Juan AD San Juan 36 61 39 63
6 CD Iruña CD Iruña 36 55 39 60
7 Cirbonero Cirbonero 37 44 40 54
8 CD Valle de Egüés Valle 36 50 46 51
9 CD Itaroa Huarte Itaroa 36 44 37 48
10 River Ega River Ega 36 41 54 46
11 Lourdes Lourdes 36 42 52 46
12 Aoiz Aoiz 37 42 47 45
13 Oberena Oberena 36 48 58 44
14 Txantrea Txantrea 36 42 46 43
15 Aluvión Aluvión 36 48 67 41
16 Murchante Murchante 36 34 52 39
17 Idoya Idoya 36 38 53 39
18 Peña Azagresa Peña 37 46 72 38
19 CF Ardoi CF Ardoi 36 44 54 36
20 Lagunak Lagunak 36 32 63 31
21 Mendi Mendi 36 29 68 23

  USO DE MEMORIA  
6,998,024 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.7639
Total Execution Time  0.7653
  CADENA URL  
/historico/Pena-Azagresa
  GET DATOS  
$_GET['/historico/Pena-Azagresa']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0177  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 = 'Pena-Azagresa' 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.0151  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=1940 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151  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=1940 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=1940 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0304  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 = 73370
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1940 AND type_rel = 2
0.0146  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1940 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0147  SELECT /*35 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 (698965,728119,744436,745004,745672) ORDER BY n.cover_points DESC, update_date DESC
0.0151  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 = '1940' ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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 = '1940' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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 = '1940' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0150  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 = 73370 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0152  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=1940 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0149  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 (73370,71432) 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.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 73370 AND teamId = 1940
0.0150  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1940
0.0153  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 = 73370 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0150  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 = '1940' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0146  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1940' and rp.type = 4
0.0154  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 = '1940' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0205  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 = 73370 WHERE rp.league_id = 73370 AND rp.teamId = 1940 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.0156  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 = 73370 WHERE rp.league_id = 73370 AND rp.teamId = 1940 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153  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 = 73370 WHERE rp.league_id = 73370 AND rp.teamId = 1940 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149  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 = 1940 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0150  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 = 73370 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.0148  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 = 68806 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.0148  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 = 71221 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.0152  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 = 63827 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 = 66946 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.0160  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 = 58594 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.0169  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 = 50283 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158  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 = 44767 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 39330 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 34178 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 16760 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 4092 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 2693 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 1135 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 842 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 145 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 73370 ORDER BY nameShow LIMIT 100