4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Amposta
TEMPORADA 2023/2024
3ª CATALANA GRUPO 18
Equipo PJ GF GC Puntos
1 Amposta Amposta 26 81 19 69
2 Flix JD Flix JD 27 75 45 56
3 L'Ametlla de mar SCER L'Ametlla 26 61 23 55
4 La Cava La Cava 26 53 36 49
5 Perelló Perelló 27 63 50 49
6 Santa Barbara CF Santa 27 53 46 40
7 Masdenverge A A Masdenverge 27 44 36 40
8 Roquetenc CD Roquetenc 27 42 37 37
9 Jesus Y Maria B Jesus Maria 27 45 47 37
10 Alcanar Alcanar 27 48 50 29
11 Pinell CF Pinell CF 26 35 51 28
12 Camarles B Camarles B 26 41 54 27
13 Tortosa Ebre B Tortosa Ebre 26 40 49 25
14 Xerta A Xerta A 26 34 57 24
15 Godall FC Godall FC 26 35 61 20
16 Jesus Catalonia B Jesus 27 14 103 5
TEMPORADA 2022/2023
3ª CATALANA GRUPO 1
Equipo PJ GF GC Puntos
1 Gandesa Gandesa 30 104 21 79
2 Amposta Amposta 30 113 30 76
3 L'Ametlla de mar SCER L'Ametlla 27 72 38 58
4 La Cava La Cava 29 62 39 56
5 Rapitenca UE B Rapitenca 30 79 40 53
6 Masdenverge A A Masdenverge 30 52 44 46
7 Tortosa Ebre B Tortosa Ebre 30 55 47 42
8 Santa Barbara CF Santa 29 52 48 42
9 Flix JD Flix JD 29 48 67 35
10 Godall FC Godall FC 30 49 70 35
11 Xerta A Xerta A 30 47 64 34
12 Roquetenc CD Roquetenc 29 55 54 33
13 Perelló Perelló 30 36 71 26
14 Jesus Y Maria B Jesus Maria 30 36 69 25
15 Corbera D' Ebre CF Corbera Ebre 30 33 106 13
16 Benissanet Benissanet 29 29 114 6
TEMPORADA 2021/2022
2ª CATALANA GRUPO 11
Equipo PJ GF GC Puntos
1 Tortosa Tortosa 20 30 21 37
2 Aldeana Aldeana 18 38 26 34
3 Ampolla Ampolla 17 30 19 34
4 Amposta Amposta 19 35 27 30
5 Ebre Escola A Ebre Escola 19 25 26 24
6 La Sénia La Sénia 18 27 33 24
7 Ulldecona Ulldecona 19 23 29 24
8 At. Móra la Nova Móra Nova 19 27 23 23
9 Perelló Perelló 20 32 38 23
10 Camarles Camarles 16 24 25 22
11 Remolins Bítem Remolins 17 10 34 9
TEMPORADA 2020/2021
2ª CATALANA GRUPO 12
Equipo PJ GF GC Puntos
1 La Sénia La Sénia 1 2 0 3
2 Ulldecona Ulldecona 1 3 2 3
3 Ampolla Ampolla 1 1 0 3
4 Perelló Perelló 1 1 1 1
5 Tortosa Tortosa 1 1 1 1
6 Amposta Amposta 0 0 0 0
7 Camarles Camarles 0 0 0 0
8 Remolins Bítem Remolins 1 2 3 0
9 At. Móra la Nova Móra Nova 1 0 1 0
10 Aldeana Aldeana 1 0 2 0
TEMPORADA 2019/2020
2ª CATALANA GRUPO 6
Equipo PJ GF GC Puntos
1 Gandesa Gandesa 22 50 15 50
2 Rapitenca Rapitenca 22 55 25 46
3 Tortosa Tortosa 22 44 24 46
4 La Sénia La Sénia 21 44 37 38
5 Perelló Perelló 22 38 29 35
6 Canonja Canonja 22 39 36 34
7 Ulldecona Ulldecona 21 33 30 34
8 Amposta Amposta 22 35 31 33
9 At. Móra la Nova Móra Nova 22 33 27 32
10 Camarles Camarles 22 39 32 30
11 Ampolla Ampolla 21 33 38 26
12 Cambrils Cambrils 23 29 41 26
13 Pobla Mafumet B Pobla 21 25 30 22
14 At. Roda Barà Roda Barà 22 33 45 22
15 Riudoms Riudoms 22 21 49 15
16 Montblanc Montblanc 21 22 51 14
17 Bonavista Bonavista 21 21 53 12
18 Les Borges del Camp A Borges Camp 1 2 3 0
TEMPORADA 2018/2019
2ª CATALANA GRUPO 6
Equipo PJ GF GC Puntos
1 UE Valls UE Valls 34 88 27 84
2 El Catllar El Catllar 34 80 42 77
3 Tortosa Tortosa 34 75 36 70
4 Gandesa Gandesa 34 55 29 61
5 Ampolla Ampolla 34 66 72 53
6 Camarles Camarles 34 66 57 52
7 Ulldecona Ulldecona 34 61 56 50
8 Amposta Amposta 34 61 51 50
9 La Sénia La Sénia 34 53 53 50
10 At. Móra la Nova Móra Nova 34 56 55 48
11 Pobla Mafumet B Pobla 34 48 47 46
12 Riudoms Riudoms 34 54 53 46
13 Canonja Canonja 34 55 57 40
14 Vendrell Vendrell 34 50 63 38
15 Vilaseca Vilaseca 34 46 58 33
16 Torreforta Torreforta 34 31 69 27
17 Reus FC Reddis Reus Reddis 34 32 80 24
18 Escola La Pastoreta Escola 34 32 104 12
TEMPORADA 2017/2018
2ª CATALANA GRUPO 6
Equipo PJ GF GC Puntos
1 Cambrils Cambrils 34 80 28 79
2 Amposta Amposta 34 68 24 77
3 Gandesa Gandesa 34 90 41 69
4 Camarles Camarles 34 75 51 60
5 La Sénia La Sénia 34 80 59 54
6 Vendrell Vendrell 34 68 57 54
7 Ulldecona Ulldecona 34 55 46 51
8 Pobla Mafumet B Pobla 34 70 58 49
9 Torreforta Torreforta 34 51 58 48
10 Reus FC Reddis Reus Reddis 34 58 57 47
11 Canonja Canonja 34 44 53 47
12 Morell Morell 34 57 63 44
13 La Cava La Cava 34 58 65 44
14 Batea CF Batea CF 34 55 67 39
15 At. Roda Barà Roda Barà 34 53 64 36
16 Jesus Catalonia Jesus 34 56 69 34
17 Hospitalet de l'Infant Hospitalet 34 30 99 22
18 Torredembarra Torredembarr 34 34 123 16
TEMPORADA 2016/2017
2ª CATALANA GRUPO 6
Equipo PJ GF GC Puntos
1 Tortosa Tortosa 34 77 32 78
2 UE Valls UE Valls 34 77 34 76
3 Cambrils Cambrils 34 65 32 67
4 Amposta Amposta 34 54 21 66
5 Camarles Camarles 34 72 37 65
6 Gandesa Gandesa 34 63 35 57
7 Reus FC Reddis Reus Reddis 34 71 67 52
8 Ulldecona Ulldecona 34 46 53 44
9 Vendrell Vendrell 34 51 54 43
10 Hospitalet de l'Infant Hospitalet 34 56 57 42
11 Torredembarra Torredembarr 34 42 59 41
12 La Cava La Cava 34 42 59 41
13 Batea CF Batea CF 34 62 77 38
14 At. Roda Barà Roda Barà 34 50 43 37
15 UE Segur UE Segur 34 54 77 36
16 El Catllar El Catllar 34 39 80 22
17 La Riera La Riera 34 34 87 21
18 Salou Salou 34 28 79 17
TEMPORADA 2015/2016
PRIMERA CATALANA GRUPO 2
Equipo PJ GF GC Puntos
1 Castelldefels Castelldefel 34 84 37 70
2 Santboià Santboià 34 77 26 70
3 Balaguer Balaguer 34 60 34 66
4 Vilanova Geltru CF Vilanova 34 69 41 64
5 Igualada Igualada 34 69 41 60
6 Lleida Esportiu B Lleida 34 60 41 56
7 Vista Alegre Vista Alegre 34 66 51 56
8 Suburense Suburense 34 64 51 55
9 Sant Ildefons Sant 34 68 48 50
10 Vilaseca Vilaseca 34 47 35 49
11 Jesus y Maria Jesus Maria 34 55 44 48
12 Rapitenca Rapitenca 34 59 53 47
13 Viladecans Viladecans 34 50 65 42
14 Terrassa FC 1906 Terrassa 34 30 52 36
15 Reus FC Reddis Reus Reddis 34 35 67 31
16 Amposta Amposta 34 49 77 27
17 Torredembarra Torredembarr 34 36 78 19
18 El Catllar El Catllar 34 19 156 3
TEMPORADA 2014/2015
PRIMERA CATALANA GRUPO 2
Equipo PJ GF GC Puntos
1 Morell Morell 34 59 41 71
2 Santboià Santboià 34 72 34 70
3 El Catllar El Catllar 34 51 41 63
4 Rapitenca Rapitenca 34 52 40 54
5 Torredembarra Torredembarr 34 57 47 49
6 Reus FC Reddis Reus Reddis 34 51 37 48
7 Sant Ildefons Sant 34 49 44 48
8 Amposta Amposta 34 58 52 47
9 Balaguer Balaguer 34 43 37 47
10 Viladecans Viladecans 34 52 46 46
11 Vilanova Geltru CF Vilanova 34 46 45 46
12 Lleida Esportiu B Lleida 34 35 46 46
13 Igualada Igualada 34 44 55 42
14 Ce Efac Almacelles Efac 34 42 52 40
15 Tàrrega Tàrrega 34 33 38 39
16 Juv. 25 Setembre Juv. 34 35 56 33
17 CFJ Mollerussa Mollerussa 34 36 63 28
18 Torreforta Torreforta 34 47 88 19
TEMPORADA 2013/2014
PRIMERA CATALANA GRUPO 2
Equipo PJ GF GC Puntos
1 Martinenc Martinenc 34 66 37 69
2 Viladecans Viladecans 34 52 34 62
3 Torreforta Torreforta 34 64 45 59
4 UA Horta UA Horta 34 57 40 53
5 Tàrrega Tàrrega 33 40 38 53
6 Igualada Igualada 34 50 51 47
7 Ce Efac Almacelles Efac 34 50 46 47
8 Torredembarra Torredembarr 34 48 46 46
9 Vilanova Geltru CF Vilanova 34 42 34 43
10 El Catllar El Catllar 34 39 49 43
11 Amposta Amposta 34 43 46 42
12 Ce Tecnofutbol Tecnofutbol 34 37 39 42
13 Balaguer Balaguer 33 35 50 41
14 Vista Alegre Vista Alegre 34 42 51 39
15 At. Alpicat At. Alpicat 34 38 54 39
16 FC Andorra FC Andorra 34 51 66 38
17 Marianao Poblet Marianao 34 37 42 37
18 Jesús i Maria Jesús Maria 34 51 74 33
TEMPORADA 2012/2013
PRIMERA CATALANA GRUPO 2
Equipo PJ GF GC Puntos
1 Ascó Ascó 34 81 30 76
2 Viladecans Viladecans 34 53 23 68
3 Santfeliuenc FC Santfeliuenc 34 52 28 68
4 Martinenc Martinenc 34 60 34 59
5 Igualada Igualada 34 55 39 53
6 Vista Alegre Vista Alegre 34 52 47 53
7 Amposta Amposta 34 49 38 51
8 FC Andorra FC Andorra 34 41 44 47
9 Tàrrega Tàrrega 34 41 49 47
10 Vilanova Geltru CF Vilanova 34 48 48 44
11 Torreforta Torreforta 34 42 54 39
12 Ce Tecnofutbol Tecnofutbol 34 42 58 39
13 Reus FC Reddis Reus Reddis 34 40 74 36
14 Torredembarra Torredembarr 33 43 47 35
15 UE Sants UE Sants 34 52 66 35
16 Cervera Cervera 33 37 55 33
17 UE Valls UE Valls 34 38 58 33
18 Morell Morell 34 28 62 30
TEMPORADA 2011/2012
TERCERA DIVISIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 AE Prat AE Prat 38 57 27 75
2 Espanyol B Espanyol B 38 68 30 70
3 Manlleu Manlleu 38 72 48 65
4 CF Pobla de Mafumet Pobla 38 52 27 64
5 UE Cornellà Cornellà 38 52 34 62
6 Santboià Santboià 38 47 42 58
7 Terrassa FC Terrassa FC 38 57 55 58
8 FC Vilafranca Vilafranca 38 50 59 54
9 CF Gavá CF Gavá 38 49 50 53
10 Olot Olot 38 53 54 51
11 Rubí Rubí 38 60 54 50
12 Balaguer Balaguer 38 36 52 49
13 Castelldefels Castelldefel 38 43 47 49
14 UE Vic UE Vic 38 44 49 47
15 Montañesa Montañesa 38 42 54 47
16 CE Europa CE Europa 38 37 46 44
17 UDA Gramanet Gramanet 38 45 52 43
18 Vilanova Geltru CF Vilanova 38 42 52 42
19 Amposta Amposta 38 47 84 29
20 Masnou Masnou 38 31 68 24
TEMPORADA 2010/2011
TERCERA DIVISIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 CF Badalona Futur Badalona 38 65 36 73
2 Montañesa Montañesa 38 40 33 67
3 CF Pobla de Mafumet Pobla 38 60 36 67
4 Reus Deportiu Reus 38 52 26 65
5 Espanyol B Espanyol B 38 65 38 64
6 Manlleu Manlleu 38 58 40 61
7 CE Europa CE Europa 38 54 42 58
8 UE Cornellà Cornellà 38 58 44 55
9 AE Prat AE Prat 38 49 42 53
10 CF Gavá CF Gavá 38 42 45 52
11 FC Vilafranca Vilafranca 38 48 55 49
12 Terrassa FC Terrassa FC 38 58 53 47
13 Castelldefels Castelldefel 38 37 45 47
14 Amposta Amposta 38 45 65 45
15 Balaguer Balaguer 38 42 60 43
16 Masnou Masnou 38 51 60 41
17 Vilanova Geltru CF Vilanova 38 42 51 41
18 Palamós Palamós 38 35 45 41
19 Ascó Ascó 38 29 72 29
20 Premià Premià 38 24 66 27
TEMPORADA 2009/2010
TERCERA DIVISIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 L´Hospitalet L´Hospitale 38 75 16 86
2 Reus Deportiu Reus 38 69 23 83
3 Santboià Santboià 38 68 46 70
4 AE Prat AE Prat 38 60 33 67
5 UE Cornellà Cornellà 38 43 41 61
6 Manlleu Manlleu 38 53 39 60
7 CF Badalona Futur Badalona 38 58 42 56
8 CE Europa CE Europa 38 56 51 54
9 Balaguer Balaguer 38 55 48 52
10 Amposta Amposta 38 56 59 50
11 Castelldefels Castelldefel 38 52 60 48
12 CF Pobla de Mafumet Pobla 38 46 52 47
13 Vilanova Geltru CF Vilanova 38 50 54 46
14 Palamós Palamós 38 42 55 46
15 Ascó Ascó 38 48 69 43
16 Cassà Cassà 38 48 61 42
17 Premià Premià 38 35 53 36
18 Rapitenca Rapitenca 38 46 71 34
19 Blanes Blanes 38 43 85 27
20 Olesa Montserrat Olesa 38 30 75 26
TEMPORADA 2008/2009
TERCERA DIVISIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 Espanyol B Espanyol B 38 84 26 83
2 Reus Deportiu Reus 38 76 37 79
3 L´Hospitalet L´Hospitale 38 63 28 76
4 Santboià Santboià 38 58 39 66
5 Manlleu Manlleu 38 61 41 64
6 Premià Premià 38 70 53 64
7 Vilanova Geltru CF Vilanova 38 64 49 55
8 AE Prat AE Prat 38 46 45 55
9 CF Pobla de Mafumet Pobla 38 55 62 52
10 Amposta Amposta 38 62 66 49
11 CE Europa CE Europa 38 52 55 48
12 UE Cornellà Cornellà 38 47 59 48
13 Cassà Cassà 38 47 52 46
14 Rapitenca Rapitenca 38 44 55 43
15 Blanes Blanes 38 58 73 42
16 Balaguer Balaguer 38 49 58 39
17 Palamós Palamós 38 45 69 38
18 Mataró Mataró 38 44 68 36
19 Miapuesta Miapuesta 38 42 80 31
20 Banyoles Banyoles 38 30 82 18
TEMPORADA 1960/1961
TERCERA DIVISIÓN GRUPO 7
Equipo PJ GF GC Puntos
1 Gimnàstic Tarragona Gimnàstic 30 72 30 45
2 L´Hospitalet L´Hospitale 30 78 32 42
3 Reus Deportiu Reus 30 59 38 38
4 Martinenc Martinenc 30 59 57 31
5 Lleida Lleida 30 61 56 30
6 Rapitenca Rapitenca 30 50 71 29
7 UE Sants UE Sants 30 62 54 29
8 CE Europa CE Europa 30 57 46 29
9 Júpiter Júpiter 30 60 71 29
10 Vilanova Geltru CF Vilanova 30 54 53 28
11 Balaguer Balaguer 30 57 71 27
12 CF Gavá CF Gavá 30 51 55 27
13 CA Iberia CA Iberia 30 41 50 27
14 La Cava La Cava 30 38 68 25
15 Amposta Amposta 30 42 63 24
16 Santboià Santboià 30 47 73 20
TEMPORADA 1959/1960
TERCERA DIVISIÓN GRUPO 6
Equipo PJ GF GC Puntos
1 L´Hospitalet L´Hospitale 30 69 41 38
2 CE Manresa CE Manresa 30 62 36 37
3 UE Sants UE Sants 30 60 37 37
4 Mataró Mataró 30 70 51 36
5 Amposta Amposta 30 59 44 36
6 Badalona Badalona 30 63 66 34
7 Lleida Lleida 30 67 51 33
8 Olot Olot 30 60 58 33
9 Gimnàstic Tarragona Gimnàstic 30 46 41 28
10 CE Europa CE Europa 30 63 62 28
11 Girona Girona 30 44 42 27
12 UE Sant Andreu Sant Andreu 30 48 62 27
13 Puigreig Puigreig 30 51 66 26
14 CA Iberia CA Iberia 30 55 77 22
15 Tortosa Tortosa 30 50 81 21
16 Unió Esportiva Poble Sec Unió 30 37 89 17
TEMPORADA 1958/1959
TERCERA DIVISIÓN GRUPO 7
Equipo PJ GF GC Puntos
1 CA Iberia CA Iberia 32 62 51 41
2 Amposta Amposta 32 83 46 41
3 UD Artiguense Artiguense 32 82 56 40
4 UE Figueres UE Figueres 32 59 40 40
5 Rapitenca Rapitenca 32 78 56 38
6 Manlleu Manlleu 32 72 63 34
7 La Cava La Cava 32 70 68 34
8 Sallent Sallent 32 74 77 34
9 Martinenc Martinenc 32 81 67 32
10 CF Gavá CF Gavá 32 64 56 32
11 Santboià Santboià 32 61 64 31
12 Guíxols Guíxols 32 72 77 30
13 Banyoles Banyoles 32 55 67 29
14 UDA Gramanet Gramanet 32 56 76 26
15 Adrianenc Adrianenc 32 46 86 25
16 Sant Cugat Sant Cugat 32 63 80 23
17 UA Horta UA Horta 32 54 102 14
18 Poblense Poblense 0 0 0 0
TEMPORADA 1957/1958
TERCERA DIVISIÓN GRUPO 6
Equipo PJ GF GC Puntos
1 Lleida Lleida 42 102 46 60
2 UE Sant Andreu Sant Andreu 42 82 37 59
3 UE Sants UE Sants 42 102 64 56
4 Mataró Mataró 42 93 61 54
5 CE Europa CE Europa 41 100 49 53
6 Atlético Cataluña Atlético 42 83 72 50
7 Olot Olot 42 92 80 46
8 Gimnàstic Tarragona Gimnàstic 42 73 75 44
9 Tortosa Tortosa 42 68 71 41
10 CE Manresa CE Manresa 42 79 93 41
11 Puigreig Puigreig 42 74 72 41
12 Badalona Badalona 42 88 83 40
13 CE Mercantil Mercantil 41 67 81 40
14 EC Granollers Granollers 42 90 82 40
15 L´Hospitalet L´Hospitale 42 65 87 39
16 UE Vic UE Vic 42 73 77 38
17 Amposta Amposta 41 64 86 35
18 Adrianenc Adrianenc 42 67 84 34
19 UD Artiguense Artiguense 42 68 89 31
20 Martinenc Martinenc 42 61 105 29
21 UA Horta UA Horta 41 42 124 10
22 La Cava La Cava 38 57 72 0

  USO DE MEMORIA  
7,584,272 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5763
Total Execution Time  0.5775
  CADENA URL  
/historico/Amposta
  GET DATOS  
$_GET['/historico/Amposta']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0254  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 = 73185
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=214 AND type_rel = 2
0.0128  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 = '214' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = 73185 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130  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=214 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 (73185) 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.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 73185 AND teamId = 214
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 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 = 73185 AND t.round = 27 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0129  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 = '214' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '214' and rp.type = 4
0.0127  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 = '214' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0127  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 = 73185 WHERE rp.league_id = 73185 AND rp.teamId = 214 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.0126  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 = 73185 WHERE rp.league_id = 73185 AND rp.teamId = 214 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  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 = 73185 WHERE rp.league_id = 73185 AND rp.teamId = 214 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130  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 = 214 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73185 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.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 `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 = 68567 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 `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 = 63745 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.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 `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 = 58784 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.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 `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 = 50604 AND t.round = 23 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 `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 = 44414 AND t.round = 34 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 `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 = 38998 AND t.round = 34 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 `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 = 33990 AND t.round = 34 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 `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 = 16584 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 `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 = 3947 AND t.round = 34 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 `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 = 2674 AND t.round = 34 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 `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 = 1984 AND t.round = 34 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 `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 = 1105 AND t.round = 38 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 `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 = 836 AND t.round = 38 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 `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 = 135 AND t.round = 38 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 `tables1961` 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 = 21525 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 `tables1960` 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 = 21511 AND t.round = 30 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 `tables1959` 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 = 21499 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 `tables1958` 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 = 21451 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC