4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Ittihad Tanger

Ittihad Tanger

Entrenador: Hilal Et-Tair

Temporada 2023/2024
TEMPORADA 2023/2024
BOTOLA PRO
Equipo PJ GF GC Puntos
1 FAR Rabat FAR Rabat 26 57 17 64
2 Raja Casablanca Raja 26 43 14 60
3 RSB Berkane RSB Berkane 25 30 15 43
4 Wydad Casablanca Wydad 26 29 24 40
5 FUS Rabat FUS Rabat 26 27 24 39
6 Olympic Safi Olympic Safi 26 25 22 37
7 UTS Rabat UTS Rabat 26 27 29 34
8 Moghreb Tetouan Moghreb 25 23 21 33
9 Renaissance Zemamra Renaissance 26 29 32 31
10 Maghreb Fes Maghreb Fes 26 29 31 29
11 Ittihad Tanger Ittihad 26 26 35 28
12 Hassania Agadir Hassania 26 24 36 27
13 JS Soualem JS Soualem 27 26 39 27
14 SCC Mohammédia Mohammédia 26 19 34 24
15 Mouloudia Oujda Mouloudia 27 19 41 24
16 Youssoufia Berrechid Youssoufia 26 18 37 19
TEMPORADA 2022/2023
BOTOLA PRO
Equipo PJ GF GC Puntos
1 FAR Rabat FAR Rabat 30 50 19 67
2 Wydad Casablanca Wydad 30 47 21 66
3 FUS Rabat FUS Rabat 30 36 16 55
4 Olympic Safi Olympic Safi 30 34 28 47
5 Raja Casablanca Raja 30 31 26 44
6 RSB Berkane RSB Berkane 30 31 29 44
7 Hassania Agadir Hassania 30 30 29 39
8 UTS Rabat UTS Rabat 30 34 40 36
9 JS Soualem JS Soualem 30 31 40 36
10 Maghreb Fes Maghreb Fes 30 27 33 34
11 Mouloudia Oujda Mouloudia 30 30 35 32
12 SCC Mohammédia Mohammédia 30 27 36 31
13 Moghreb Tetouan Moghreb 30 28 41 30
14 Ittihad Tanger Ittihad 30 23 39 29
15 Olympique Khouribga Olympique 30 29 36 28
16 Difaâ El Jadida Difaâ 30 24 44 25
TEMPORADA 2021/2022
BOTOLA PRO
Equipo PJ GF GC Puntos
1 Wydad Casablanca Wydad 30 46 24 63
2 Raja Casablanca Raja 30 41 21 60
3 FAR Rabat FAR Rabat 30 38 29 48
4 Maghreb Fes Maghreb Fes 30 28 17 45
5 FUS Rabat FUS Rabat 30 34 30 43
6 RSB Berkane RSB Berkane 30 39 33 41
7 Olympic Safi Olympic Safi 30 29 27 39
8 Difaâ El Jadida Difaâ 30 32 40 38
9 JS Soualem JS Soualem 30 37 38 36
10 Olympique Khouribga Olympique 30 32 37 36
11 SCC Mohammédia Mohammédia 30 27 32 34
12 Hassania Agadir Hassania 30 26 30 34
13 Ittihad Tanger Ittihad 30 31 41 33
14 Mouloudia Oujda Mouloudia 30 35 38 33
15 Rapide Oued Zem Rapide Oued 30 19 39 29
16 Youssoufia Berrechid Youssoufia 30 25 43 26
TEMPORADA 2020/2021
BOTOLA PRO
Equipo PJ GF GC Puntos
1 Wydad Casablanca Wydad 30 58 26 67
2 Raja Casablanca Raja 30 48 26 59
3 FAR Rabat FAR Rabat 30 39 29 51
4 RSB Berkane RSB Berkane 30 37 36 45
5 Mouloudia Oujda Mouloudia 30 38 35 42
6 Hassania Agadir Hassania 30 23 24 37
7 Maghreb Fes Maghreb Fes 30 30 34 36
8 Ittihad Tanger Ittihad 30 29 36 36
9 SCC Mohammédia Mohammédia 30 26 25 35
10 FUS Rabat FUS Rabat 30 32 36 35
11 Difaâ El Jadida Difaâ 30 32 40 35
12 Olympic Safi Olympic Safi 30 30 41 35
13 Youssoufia Berrechid Youssoufia 30 23 33 33
14 Rapide Oued Zem Rapide Oued 30 28 36 33
15 Moghreb Tetouan Moghreb 30 36 43 32
16 Renaissance Zemamra Renaissance 30 31 40 30
TEMPORADA 2019/2020
BOTOLA PRO
Equipo PJ GF GC Puntos
1 Raja Casablanca Raja 30 43 23 60
2 Wydad Casablanca Wydad 30 52 28 59
3 RSB Berkane RSB Berkane 30 35 23 57
4 FUS Rabat FUS Rabat 30 39 30 49
5 Mouloudia Oujda Mouloudia 30 35 28 48
6 FAR Rabat FAR Rabat 30 45 34 45
7 Moghreb Tetouan Moghreb 30 30 27 40
8 Rapide Oued Zem Rapide Oued 30 30 30 36
9 Youssoufia Berrechid Youssoufia 30 33 44 36
10 Hassania Agadir Hassania 30 34 38 36
11 Difaâ El Jadida Difaâ 30 26 28 35
12 Renaissance Zemamra Renaissance 30 40 41 34
13 Olympic Safi Olympic Safi 30 25 34 33
14 Ittihad Tanger Ittihad 30 20 36 32
15 Olympique Khouribga Olympique 30 24 38 28
16 Raja Beni Mellal Raja Beni M. 30 13 42 12
TEMPORADA 2018/2019
BOTOLA PRO
Equipo PJ GF GC Puntos
1 Wydad Casablanca Wydad 30 56 30 59
2 Raja Casablanca Raja 30 56 36 55
3 Hassania Agadir Hassania 30 30 22 45
4 Olympic Safi Olympic Safi 30 37 38 45
5 Ittihad Tanger Ittihad 30 27 30 40
6 RSB Berkane RSB Berkane 30 34 34 39
7 Youssoufia Berrechid Youssoufia 30 36 37 39
8 Difaâ El Jadida Difaâ 30 30 32 39
9 FUS Rabat FUS Rabat 30 25 25 38
10 Rapide Oued Zem Rapide Oued 30 28 31 37
11 Olympique Khouribga Olympique 30 38 42 36
12 Mouloudia Oujda Mouloudia 30 31 38 35
13 Moghreb Tetouan Moghreb 30 29 32 34
14 FAR Rabat FAR Rabat 30 32 32 33
15 Kawkab Marrakech Kawkab 30 34 40 30
16 Chabab Rif Hoceima Chabab 30 27 51 27
TEMPORADA 2017/2018
BOTOLA PRO
Equipo PJ GF GC Puntos
1 Ittihad Tanger Ittihad 30 34 23 52
2 Hassania Agadir Hassania 30 40 22 51
3 Wydad Casablanca Wydad 30 44 26 51
4 FUS Rabat FUS Rabat 30 34 26 49
5 Difaâ El Jadida Difaâ 30 49 33 48
6 Raja Casablanca Raja 30 45 33 48
7 Olympic Safi Olympic Safi 30 32 28 43
8 FAR Rabat FAR Rabat 30 35 34 43
9 RSB Berkane RSB Berkane 30 37 34 41
10 Rapide Oued Zem Rapide Oued 30 27 31 37
11 Moghreb Tetouan Moghreb 30 24 35 36
12 Olympique Khouribga Olympique 30 37 47 35
13 Chabab Rif Hoceima Chabab 30 27 31 33
14 Kawkab Marrakech Kawkab 30 29 48 32
15 Chabab Atlas Khenifra Chabab Atlas 30 30 41 29
16 Racing de Casablanca Racing 30 23 55 17
TEMPORADA 2016/2017
BOTOLA PRO
Equipo PJ GF GC Puntos
1 Wydad Casablanca Wydad 30 50 24 66
2 Difaâ El Jadida Difaâ 30 45 23 59
3 Raja Casablanca Raja 30 42 17 57
4 RSB Berkane RSB Berkane 30 30 16 51
5 Ittihad Tanger Ittihad 30 33 25 45
6 FAR Rabat FAR Rabat 30 42 39 44
7 FUS Rabat FUS Rabat 30 32 32 40
8 Hassania Agadir Hassania 30 32 40 38
9 Olympic Safi Olympic Safi 30 25 32 36
10 Chabab Atlas Khenifra Chabab Atlas 30 26 25 34
11 Olympique Khouribga Olympique 30 34 40 34
12 Moghreb Tetouan Moghreb 30 30 37 34
13 Kawkab Marrakech Kawkab 30 36 42 33
14 Chabab Rif Hoceima Chabab 30 26 46 31
15 Kasba Tadla Kasba Tadla 30 25 47 28
16 KAC Kenitra KAC Kenitra 30 27 50 23
TEMPORADA 2015/2016
BOTOLA PRO
Equipo PJ GF GC Puntos
1 FUS Rabat FUS Rabat 30 40 21 58
2 Wydad Casablanca Wydad 30 34 19 56
3 Ittihad Tanger Ittihad 30 36 23 50
4 Raja Casablanca Raja 30 48 30 47
5 FAR Rabat FAR Rabat 30 40 35 47
6 RSB Berkane RSB Berkane 30 24 19 43
7 Moghreb Tetouan Moghreb 30 34 43 43
8 Hassania Agadir Hassania 30 44 46 41
9 Olympic Safi Olympic Safi 30 23 27 37
10 Chabab Rif Hoceima Chabab 30 27 34 36
11 KAC Kenitra KAC Kenitra 30 26 37 35
12 Difaâ El Jadida Difaâ 30 26 30 34
13 Olympique Khouribga Olympique 30 26 35 34
14 Kawkab Marrakech Kawkab 30 23 30 30
15 Maghreb Fes Maghreb Fes 30 24 31 29
16 Mouloudia Oujda Mouloudia 30 26 41 29
TEMPORADA 2014/2015
BOTOLA 2
Equipo PJ GF GC Puntos
1 Ittihad Tanger Ittihad 30 22 11 54
2 Mouloudia Oujda Mouloudia 30 32 22 49
3 USM Ait Melloul Melloul 30 39 24 48
4 Kasba Tadla Kasba Tadla 30 29 22 48
5 Youssoufia Berrechid Youssoufia 30 34 25 46
6 Raja Beni Mellal Raja Beni M. 30 21 16 39
7 JSM Laayoune Laayoune 30 24 24 37
8 AS Salé AS Salé 30 23 26 37
9 US Temara US Temara 30 33 37 36
10 CODM Meknes CODM Meknes 30 28 29 35
11 Widad Temara Widad Temara 30 23 26 35
12 Racing de Casablanca Racing 30 27 35 35
13 Olympique Dcheïra Olympique 30 24 32 33
14 Wydad Fès Wydad Fès 30 19 28 33
15 Chabab Houara Chabab 30 23 31 31
16 Union Mohammedia Union 30 22 35 28
TEMPORADA 2013/2014
BOTOLA 2
Equipo PJ GF GC Puntos
1 Ittihad Khemisset Ittihad 30 34 13 57
2 Chabab Atlas Khenifra Chabab Atlas 30 36 13 53
3 Ittihad Tanger Ittihad 30 33 21 48
4 CODM Meknes CODM Meknes 30 34 31 46
5 Tihad Temara Tihad Temara 30 26 25 44
6 Raja Beni Mellal Raja Beni M. 30 38 33 41
7 Union Mohammedia Union 30 23 27 39
8 Kasba Tadla Kasba Tadla 30 31 29 36
9 Youssoufia Berrechid Youssoufia 30 24 28 36
10 Mouloudia Oujda Mouloudia 30 25 30 35
11 Chabab Houara Chabab 30 30 37 35
12 JSM Laayoune Laayoune 30 23 34 35
13 Racing de Casablanca Racing 30 25 28 34
14 USM Ait Melloul Melloul 30 23 33 30
15 Rachad Bernoussi Rachad 30 21 31 29
16 USM Oujda USM Oujda 30 23 36 28
TEMPORADA 2012/2013
BOTOLA 2
Equipo PJ GF GC Puntos
1 Kawkab Marrakech Kawkab 30 44 12 65
2 AS Salé AS Salé 30 30 13 57
3 Ittihad Khemisset Ittihad 30 25 26 50
4 Mouloudia Oujda Mouloudia 30 30 20 49
5 Rachad Bernoussi Rachad 30 27 22 45
6 USM Ait Melloul Melloul 30 26 25 44
7 Youssoufia Berrechid Youssoufia 30 34 38 39
8 USM Oujda USM Oujda 30 29 32 36
9 Union Mohammedia Union 30 27 28 35
10 Kasba Tadla Kasba Tadla 30 19 22 35
11 Racing de Casablanca Racing 30 26 33 35
12 JSM Laayoune Laayoune 30 26 32 34
13 Ittihad Tanger Ittihad 30 28 35 33
14 US Temara US Temara 30 23 31 32
15 TAS Casablanca Casablanca 30 17 27 32
16 Olympique Marrakech Olympique 30 25 40 22
TEMPORADA 2011/2012
BOTOLA 2
Equipo PJ GF GC Puntos
1 Raja Beni Mellal Raja Beni M. 30 25 15 48
2 RSB Berkane RSB Berkane 30 29 27 47
3 TAS Casablanca Casablanca 30 32 27 46
4 Union Mohammedia Union 30 38 27 43
5 Kawkab Marrakech Kawkab 30 29 19 42
6 AS Salé AS Salé 30 32 24 41
7 USM Ait Melloul Melloul 30 37 40 40
8 Racing de Casablanca Racing 30 27 24 39
9 Youssoufia Berrechid Youssoufia 30 33 34 39
10 Mouloudia Oujda Mouloudia 30 26 31 39
11 Kasba Tadla Kasba Tadla 30 22 27 35
12 Ittihad Tanger Ittihad 30 21 26 34
13 Rachad Bernoussi Rachad 30 26 33 33
14 US Temara US Temara 30 15 20 32
15 Chabab Houara Chabab 30 22 32 31
16 Stade Marocain Stade 30 26 34 29
TEMPORADA 2010/2011
BOTOLA 2
Equipo PJ GF GC Puntos
1 CODM Meknes CODM Meknes 34 35 10 64
2 Ittihad Khemisset Ittihad 34 43 29 61
3 USM Ait Melloul Melloul 34 42 24 61
4 Youssoufia Berrechid Youssoufia 34 33 20 59
5 TAS Casablanca Casablanca 34 26 25 50
6 Mouloudia Oujda Mouloudia 34 29 29 47
7 Union Mohammedia Union 34 28 28 46
8 Chabab Houara Chabab 34 28 29 46
9 Rachad Bernoussi Rachad 34 27 29 43
10 Racing de Casablanca Racing 34 38 36 42
11 Ittihad Tanger Ittihad 34 28 33 40
12 AS Salé AS Salé 34 38 39 39
13 US Temara US Temara 34 25 26 39
14 Stade Marocain Stade 34 18 24 39
15 Raja Al Hoceima Raja Hoceima 34 18 29 35
16 Fkih Ben Salah Fkih Salah 34 27 39 35
17 SCCM Mohamedia SCCM 34 25 33 33
18 Hilal Nador Hilal Nador 34 18 44 25
TEMPORADA 2009/2010
BOTOLA 2
Equipo PJ GF GC Puntos
1 Kasba Tadla Kasba Tadla 36 34 23 65
2 Chabab Rif Hoceima Chabab 36 32 23 61
3 Union Mohammedia Union 36 38 25 58
4 CODM Meknes CODM Meknes 36 38 26 58
5 US Temara US Temara 36 39 35 56
6 Chabab Houara Chabab 36 38 28 53
7 Stade Marocain Stade 36 36 33 52
8 Racing de Casablanca Racing 36 36 36 52
9 Raja Al Hoceima Raja Hoceima 36 37 36 48
10 Youssoufia Berrechid Youssoufia 36 39 35 43
11 Mouloudia Oujda Mouloudia 36 30 34 43
12 TAS Casablanca Casablanca 36 28 28 42
13 Ittihad Tanger Ittihad 36 28 33 42
14 Rachad Bernoussi Rachad 36 26 37 42
15 Fkih Ben Salah Fkih Salah 36 29 36 41
16 SCCM Mohamedia SCCM 36 26 37 41
17 Chabab Atlas Khenifra Chabab Atlas 36 31 46 40
18 Settat Settat 36 29 40 38
19 Sidi Kacem Sidi Kacem 36 33 36 36
TEMPORADA 2008/2009
BOTOLA 2
Equipo PJ GF GC Puntos
1 FUS Rabat FUS Rabat 34 43 13 66
2 Wydad Fès Wydad Fès 34 39 22 61
3 Stade Marocain Stade 34 34 28 60
4 Chabab Rif Hoceima Chabab 34 37 30 51
5 Chabab Houara Chabab 34 42 31 50
6 Racing de Casablanca Racing 34 37 36 50
7 Union Mohammedia Union 34 32 27 47
8 CODM Meknes CODM Meknes 34 31 30 44
9 Ittihad Tanger Ittihad 34 27 26 44
10 Fkih Ben Salah Fkih Salah 34 34 34 44
11 Youssoufia Berrechid Youssoufia 34 31 32 43
12 Sidi Kacem Sidi Kacem 34 25 39 38
13 US Temara US Temara 34 23 35 36
14 TAS Casablanca Casablanca 34 19 23 35
15 Settat Settat 34 27 40 35
16 Rachad Bernoussi Rachad 34 31 34 34
17 Olympique Marrakech Olympique 34 24 36 34
18 CWW Casablanca Casablanca 34 26 46 26
TEMPORADA 2007/2008
BOTOLA 2
Equipo PJ GF GC Puntos
1 AS Salé AS Salé 29 40 17 51
2 SCCM Mohamedia SCCM 28 31 21 45
3 US Temara US Temara 29 26 19 44
4 Ittihad Tanger Ittihad 29 17 15 42
5 Sidi Kacem Sidi Kacem 29 28 19 39
6 Chabab Houara Chabab 28 37 34 39
7 TAS Casablanca Casablanca 29 24 22 38
8 CWW Casablanca Casablanca 29 29 27 37
9 Union Mohammedia Union 29 20 22 37
10 Chabab Rif Hoceima Chabab 29 20 19 36
11 Settat Settat 28 20 19 35
12 Racing de Casablanca Racing 29 18 23 34
13 Rachad Bernoussi Rachad 28 30 30 33
14 Youssoufia Berrechid Youssoufia 29 22 22 32
15 UTS Rabat UTS Rabat 29 25 36 28
16 Hilal Nador Hilal Nador 29 15 57 19
TEMPORADA 2006/2007
BOTOLA PRO
Equipo PJ GF GC Puntos
1 Olympique Khouribga Olympique 30 38 16 62
2 FAR Rabat FAR Rabat 30 31 17 55
3 Moghreb Tetouan Moghreb 30 37 31 54
4 Wydad Casablanca Wydad 30 30 20 47
5 Difaâ El Jadida Difaâ 30 29 19 42
6 Kawkab Marrakech Kawkab 30 23 17 42
7 Ittihad Khemisset Ittihad 30 24 23 42
8 JSM Laayoune Laayoune 30 21 21 37
9 Hassania Agadir Hassania 30 22 23 36
10 Mouloudia Oujda Mouloudia 30 25 35 36
11 Raja Casablanca Raja 30 23 20 35
12 Olympic Safi Olympic Safi 30 22 31 32
13 CODM Meknes CODM Meknes 30 17 24 31
14 Maghreb Fes Maghreb Fes 30 19 34 29
15 Ittihad Tanger Ittihad 30 21 30 26
16 AS Salé AS Salé 30 21 42 21
TEMPORADA 2005/2006
BOTOLA PRO
Equipo PJ GF GC Puntos
1 Wydad Casablanca Wydad 30 33 16 61
2 FAR Rabat FAR Rabat 30 41 14 58
3 Olympique Khouribga Olympique 30 44 23 53
4 Raja Casablanca Raja 30 34 24 51
5 Hassania Agadir Hassania 30 31 24 49
6 CODM Meknes CODM Meknes 30 23 25 41
7 Difaâ El Jadida Difaâ 30 29 26 40
8 Ittihad Khemisset Ittihad 30 20 26 36
9 AS Salé AS Salé 30 18 26 35
10 Olympic Safi Olympic Safi 30 26 27 34
11 Mouloudia Oujda Mouloudia 30 27 30 34
12 Moghreb Tetouan Moghreb 30 19 27 33
13 JSM Laayoune Laayoune 30 23 26 32
14 Ittihad Tanger Ittihad 30 22 29 29
15 SCCM Mohamedia SCCM 30 15 35 27
16 UTS Rabat UTS Rabat 30 12 39 19
TEMPORADA 2004/2005
BOTOLA PRO
Equipo PJ GF GC Puntos
1 FAR Rabat FAR Rabat 30 35 9 62
2 Raja Casablanca Raja 30 42 17 60
3 Wydad Casablanca Wydad 30 32 14 50
4 Olympic Safi Olympic Safi 30 25 22 41
5 JSM Laayoune Laayoune 30 26 25 39
6 Ittihad Khemisset Ittihad 30 18 21 37
7 Hassania Agadir Hassania 30 19 21 36
8 Olympique Khouribga Olympique 30 24 29 36
9 UTS Rabat UTS Rabat 30 27 33 36
10 AS Salé AS Salé 30 25 33 35
11 SCCM Mohamedia SCCM 30 18 24 34
12 Mouloudia Oujda Mouloudia 30 21 27 33
13 CODM Meknes CODM Meknes 30 16 22 33
14 Ittihad Tanger Ittihad 30 19 28 33
15 Maghreb Fes Maghreb Fes 30 22 26 32
16 Kawkab Marrakech Kawkab 30 17 35 27

  USO DE MEMORIA  
7,805,520 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4886
Total Execution Time  0.4898
  CADENA URL  
/historico/Ittihad-Tanger
  GET DATOS  
$_GET['/historico/Ittihad-Tanger']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13909 AND type_rel = 2
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 13909 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0127  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 (935,4898,15753,129075,427272) ORDER BY n.cover_points DESC, update_date DESC
0.0133  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 = '13909' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0131  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=13909 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0125  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 (75598,73592) 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.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 73592 AND teamId = 13909
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 75598 AND teamId = 13909
0.0136  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 = 73592 WHERE rp.league_id = 73592 AND rp.teamId = 13909 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.0135  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 = 73592 WHERE rp.league_id = 73592 AND rp.teamId = 13909 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0137  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 = 73592 WHERE rp.league_id = 73592 AND rp.teamId = 13909 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132  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 = 13909 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0128  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 = 68951 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.0131  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 = 64194 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.0129  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 = 60252 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.0128  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 = 50017 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.0128  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 = 43575 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 34134 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 15633 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 4197 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 2934 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 8703 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 8702 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 8697 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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 = 8693 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142  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 = 8691 AND t.round = 29 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144  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 `tables2007` 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 = 8684 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144  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 `tables2006` 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 = 8682 AND t.round = 31 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 `tables2005` 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 = 8679 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC