4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Benicarló
TEMPORADA 2023/2024
PRIMERA FFCV GRUPO 1
Equipo PJ GF GC Puntos
1 Paterna CF Paterna CF 26 46 23 53
2 Odisea FC Odisea FC 26 40 19 50
3 Mare Nostrum Puerto Sagunto Mare Nostrum 25 40 23 43
4 Moncofa Moncofa 26 41 28 41
5 CD Roda B CD Roda B 27 39 36 39
6 Benicarló Benicarló 26 44 38 37
7 Quart de Les Valls Quart Valls 26 52 40 35
8 CF Albuixech Albuixech 26 33 36 35
9 Cabanes Cabanes 26 33 40 34
10 Nules Nules 26 30 47 33
11 Vinaròs Vinaròs 25 44 51 32
12 CF Alcalá CF Alcalá 26 55 45 30
13 Ibarsos Ibarsos 25 30 52 28
14 C.F San Pedro Pedro 25 23 37 28
15 Tavernes Blanques CF Tavernes 25 33 45 26
16 Puzol Puzol 26 43 66 25
TEMPORADA 2022/2023
SEGUNDA FFCV GRUPO 1
Equipo PJ GF GC Puntos
1 Benicarló Benicarló 30 75 28 69
2 CF Alcalá CF Alcalá 30 59 30 61
3 Odisea FC Odisea FC 30 68 34 60
4 Orpesa Orpesa 29 65 44 46
5 Vall D'Alba Vall D'Alba 28 52 39 46
6 CF Torreblanca Torreblanca 30 57 53 46
7 Ripolles A Ripolles A 30 53 45 44
8 Rafalafena Rafalafena 30 48 48 42
9 Traiguera Traiguera 29 50 43 40
10 Esportiu Vila Real Esportiu 30 59 71 40
11 Cd Benicasim Benicasim 30 56 73 39
12 Morella Morella 30 40 48 34
13 Peñiscola Peñiscola 29 34 58 32
14 Almazora B Almazora B 30 47 66 27
15 Primer Toque CF Primer Toque 30 41 70 26
16 Chert Chert 29 29 83 12
TEMPORADA 2021/2022
PRIMERA FFCV GRUPO 1
Equipo PJ GF GC Puntos
1 UD Vall de Uxó Vall Uxó 30 55 24 65
2 CD Burriana CD Burriana 30 52 27 60
3 Soneja Soneja 30 55 23 57
4 Almazora Almazora 30 65 41 54
5 Huracan Moncada Huracan 30 41 33 49
6 L´Alcora L´Alcora 30 48 42 45
7 C.F San Pedro Pedro 30 50 43 44
8 Alqueríes CF Alqueríes 30 37 35 42
9 Onda Onda 30 45 42 40
10 Vinaròs Vinaròs 30 45 50 40
11 Cabanes Cabanes 30 35 44 38
12 CD Roda B CD Roda B 30 52 50 35
13 Ibarsos Ibarsos 30 37 51 33
14 Benicarló Benicarló 30 34 57 27
15 Mare Nostrum Puerto Sagunto Mare Nostrum 30 29 55 22
16 Almenara Atlètic Almenara 30 23 86 12
TEMPORADA 2020/2021
TERCERA DIVISIÓN GRUPO 6
Equipo PJ GF GC Puntos
1 UD Alzira UD Alzira 20 29 12 38
2 CD Roda CD Roda 20 28 16 35
3 At. Saguntino Saguntino 20 30 27 31
4 Villarreal C Villarreal 20 32 18 30
5 Silla CF Silla CF 20 20 21 25
6 Recambios Colón Recambios 20 16 19 23
7 Benicarló Benicarló 20 22 21 22
8 Torrent Torrent 20 17 25 21
9 CD Acero CD Acero 20 18 25 20
10 Paterna CF Paterna CF 20 14 25 20
11 Vilamarxant Vilamarxant 20 13 30 15
12 Eldense Eldense 18 30 11 41
13 Ilicitano Ilicitano 18 33 17 38
14 CF Intercity Intercity 18 30 8 37
15 Olimpic Xátiva Olimpic 18 22 24 25
16 Benigànim Benigànim 18 14 30 20
17 FC Jove Español Jove 18 17 23 19
18 Crevillente Deportivo Crevillente 18 17 24 19
19 Hércules B Hércules B 18 13 17 18
20 Villajoyosa Villajoyosa 18 17 27 17
21 Novelda CF Novelda CF 18 15 27 12
TEMPORADA 2019/2020
PRIMERA FFCV GRUPO 1
Equipo PJ GF GC Puntos
1 Benicarló Benicarló 26 41 25 50
2 CD Burriana CD Burriana 26 51 27 48
3 CD Castellón B Castellón 26 46 26 48
4 Almazora Almazora 26 38 19 47
5 UD Vall de Uxó Vall Uxó 26 37 19 46
6 Soneja Soneja 26 43 28 45
7 Puzol Puzol 26 50 32 43
8 Alcala Alcala 26 37 33 39
9 C.F San Pedro Pedro 26 36 40 34
10 Onda Onda 26 35 25 33
11 Cabanes Cabanes 26 40 39 32
12 L´Alcora L´Alcora 26 29 34 31
13 Huracan Moncada Huracan 26 36 43 28
14 Manises Manises 26 39 54 28
15 Alqueríes CF Alqueríes 26 25 44 26
16 Almenara Atlètic Almenara 26 24 46 24
17 Nules Nules 26 20 55 16
18 CF Albuixech Albuixech 26 23 61 14
TEMPORADA 2018/2019
PRIMERA FFCV GRUPO 1
Equipo PJ GF GC Puntos
1 Puzol Puzol 34 61 29 69
2 CD Burriana CD Burriana 34 56 22 67
3 Onda Onda 34 86 36 65
4 Almazora Almazora 34 61 34 62
5 Nules Nules 34 66 46 60
6 CF Albuixech Albuixech 34 63 40 57
7 Cabanes Cabanes 34 42 32 55
8 CD Castellón B Castellón 34 43 28 51
9 UD Vall de Uxó Vall Uxó 34 57 41 49
10 L´Alcora L´Alcora 34 55 54 48
11 Benicarló Benicarló 34 39 51 47
12 C.F San Pedro Pedro 34 40 41 43
13 Almenara AT. Almenara 34 48 50 36
14 Huracan Moncada Huracan 34 40 65 35
15 Alqueríes CF Alqueríes 34 44 72 35
16 Rafalafena Rafalafena 34 39 62 34
17 Sant Jordi Sant Jordi 34 26 73 17
18 CF Borriol CF Borriol 34 20 110 3
TEMPORADA 2017/2018
PRIMERA FFCV GRUPO 1
Equipo PJ GF GC Puntos
1 CD Acero CD Acero 34 92 28 76
2 UD Vall de Uxó Vall Uxó 34 57 25 72
3 R. Benagéber Benagéber 34 53 25 69
4 Puzol Puzol 34 54 34 67
5 Onda Onda 34 59 28 66
6 C.F San Pedro Pedro 34 53 40 59
7 Almenara AT. Almenara 34 48 50 54
8 CD Castellón B Castellón 34 44 26 53
9 CD Burriana CD Burriana 34 53 46 48
10 CF Albuixech Albuixech 34 55 45 47
11 Benicarló Benicarló 34 44 57 42
12 Sant Jordi Sant Jordi 34 52 61 41
13 L´Alcora L´Alcora 34 49 63 40
14 Nules Nules 34 47 66 36
15 CF Alcalá CF Alcalá 34 42 58 34
16 Bétera Bétera 34 41 76 27
17 Xirivella Xirivella 34 31 80 13
18 Club La Vall Club Vall 34 25 91 11
TEMPORADA 2016/2017
PRIMERA FFCV GRUPO 1
Equipo PJ GF GC Puntos
1 Onda Onda 34 73 22 77
2 CD Roda CD Roda 34 73 38 77
3 CD Acero CD Acero 34 74 28 75
4 Puzol Puzol 34 66 39 62
5 CD Castellón B Castellón 34 54 33 61
6 L´Alcora L´Alcora 34 49 43 52
7 UD Vall de Uxó Vall Uxó 34 48 41 49
8 CD Burriana CD Burriana 34 55 50 48
9 Benicarló Benicarló 34 51 57 42
10 C.F San Pedro Pedro 34 46 49 41
11 CF Albuixech Albuixech 34 37 47 41
12 Huracan Moncada Huracan 34 45 57 38
13 Club La Vall Club Vall 34 49 57 36
14 CF Alcalá CF Alcalá 34 53 70 35
15 Nules Nules 34 38 59 33
16 Alboraya Alboraya 34 36 65 32
17 El Puig El Puig 34 42 90 28
18 Alqueríes CF Alqueríes 34 30 74 20
TEMPORADA 2015/2016
PRIMERA FFCV GRUPO 1
Equipo PJ GF GC Puntos
1 Segorbe Segorbe 34 77 28 75
2 Almazora Almazora 34 61 19 68
3 CD Burriana CD Burriana 34 70 34 64
4 Onda Onda 34 76 42 60
5 Club La Vall Club Vall 34 61 29 59
6 CD Castellón B Castellón 34 73 44 57
7 L´Alcora L´Alcora 34 65 37 49
8 UD Vall de Uxó Vall Uxó 34 58 45 49
9 CF Albuixech Albuixech 34 66 52 48
10 Puzol Puzol 34 46 41 45
11 Benicarló Benicarló 34 44 61 45
12 Atl. Museros Atl. Museros 34 47 51 43
13 C.F San Pedro Pedro 34 50 51 40
14 Alqueríes CF Alqueríes 34 48 53 39
15 CF Alcalá CF Alcalá 34 60 86 39
16 Benicassim Benicassim 34 41 67 38
17 CF Cullera CF Cullera 34 28 90 16
18 Vinaròs Vinaròs 34 16 157 0
TEMPORADA 2014/2015
PRIMERA FFCV GRUPO 1
Equipo PJ GF GC Puntos
1 CF Borriol CF Borriol 34 69 14 82
2 UD Vall de Uxó Vall Uxó 34 58 27 71
3 CD Burriana CD Burriana 34 61 24 69
4 Onda Onda 34 66 37 65
5 C.F San Pedro Pedro 34 60 47 57
6 Vinaròs Vinaròs 34 53 46 51
7 Alqueríes CF Alqueríes 34 45 53 46
8 Benicarló Benicarló 34 51 53 42
9 Club La Vall Club Vall 34 48 51 41
10 Benicassim Benicassim 34 38 41 41
11 CD Castellón B Castellón 34 46 45 40
12 CF Torreblanca Torreblanca 34 38 48 40
13 L´Alcora L´Alcora 34 54 67 40
14 Almazora Almazora 34 42 56 40
15 Puzol Puzol 34 36 55 39
16 Nules Nules 34 43 56 36
17 FB Sagunto FB Sagunto 34 30 68 23
18 Masamagrell Masamagrell 34 40 90 20
TEMPORADA 2013/2014
PRIMERA FFCV GRUPO 1
Equipo PJ GF GC Puntos
1 Puzol Puzol 34 59 35 72
2 Almazora Almazora 34 70 22 69
3 Alqueríes CF Alqueríes 34 57 26 69
4 CF Albuixech Albuixech 34 59 29 62
5 CF Lécera 2022 Lécera 2022 34 54 38 58
6 UD Vall de Uxó Vall Uxó 34 54 45 56
7 Vinaròs Vinaròs 34 61 39 55
8 C.F San Pedro Pedro 34 49 58 51
9 Onda Onda 34 54 45 47
10 Benicarló Benicarló 34 44 54 47
11 Atl. Museros Atl. Museros 34 37 36 42
12 CD Burriana CD Burriana 34 51 61 39
13 Nules Nules 34 42 53 38
14 L´Alcora L´Alcora 34 39 65 35
15 Cd Benicasim Benicasim 34 26 48 33
16 Tavernes Blanques CF Tavernes 34 37 57 31
17 El Puig El Puig 34 43 70 29
18 Cd Catí Cd Catí 34 32 87 21
TEMPORADA 2009/2010
PRIMERA FFCV GRUPO 1
Equipo PJ GF GC Puntos
1 CF Borriol CF Borriol 34 76 40 74
2 At. Saguntino Saguntino 34 62 26 73
3 Benlloch Benlloch 34 53 39 57
4 CD Castellón B Castellón 34 58 37 52
5 Villafamés Villafamés 34 45 39 50
6 Nules Nules 34 52 53 49
7 Benicassim Benicassim 34 42 43 48
8 Almenara Atlètic Almenara 34 57 48 47
9 La Vilavella Vilavella 34 50 50 47
10 CD Burriana CD Burriana 34 48 50 46
11 UD Vall de Uxó Vall Uxó 34 51 56 46
12 CD Acero CD Acero 34 57 51 45
13 Almazora Almazora 34 42 46 44
14 San Jorge San Jorge 34 39 40 43
15 L´Alcora L´Alcora 34 58 61 43
16 Vinaròs Vinaròs 34 53 54 42
17 Benicarló Benicarló 34 37 70 20
18 Pobla Farnals Pobla 34 40 117 16
TEMPORADA 2008/2009
PRIMERA FFCV GRUPO 1
Equipo PJ GF GC Puntos
1 CF Borriol CF Borriol 34 76 29 76
2 Benlloch Benlloch 34 63 29 75
3 At. Saguntino Saguntino 34 53 19 71
4 San Jorge San Jorge 34 54 29 69
5 Benicassim Benicassim 34 59 36 62
6 Almenara Atlètic Almenara 34 60 47 51
7 Villafamés Villafamés 34 53 47 46
8 UD Vall de Uxó Vall Uxó 34 48 42 46
9 CD Acero CD Acero 34 56 47 44
10 CD Burriana CD Burriana 34 45 66 43
11 Nules Nules 34 39 38 42
12 Almazora Almazora 34 47 62 42
13 Vinaròs Vinaròs 34 45 63 41
14 La Vilavella Vilavella 34 52 70 40
15 Benicarló Benicarló 34 38 62 36
16 CF Sant Rafel Sant Rafel 34 45 70 28
17 CF San Pedro Pedro 34 33 64 26
18 Estivella Estivella 34 23 69 13
TEMPORADA 2007/2008
PRIMERA FFCV GRUPO 1
Equipo PJ GF GC Puntos
1 At. Saguntino Saguntino 34 89 27 80
2 Benicassim Benicassim 34 67 28 71
3 San Jorge San Jorge 33 63 31 68
4 Nules Nules 34 57 31 67
5 CD Acero CD Acero 33 64 33 66
6 Vinaròs Vinaròs 34 64 46 56
7 Almenara Atlètic Almenara 34 49 46 49
8 Estivella Estivella 35 54 54 47
9 Almazora Almazora 34 49 43 46
10 Benicarló Benicarló 34 58 54 45
11 Benlloch Benlloch 35 66 60 43
12 Villafamés Villafamés 34 53 69 39
13 C.F San Pedro Pedro 34 43 68 34
14 UD Vall de Uxó Vall Uxó 34 43 55 33
15 CD Burriana CD Burriana 34 36 54 33
16 L´Alcora L´Alcora 34 49 81 30
17 Traiguera Traiguera 34 35 65 27
18 Orpesa Orpesa 34 18 112 22
TEMPORADA 2006/2007
PRIMERA FFCV GRUPO 1
Equipo PJ GF GC Puntos
1 Villarreal C Villarreal 34 73 29 68
2 Almazora Almazora 34 67 32 66
3 Benicassim Benicassim 34 46 32 65
4 San Jorge San Jorge 34 70 33 64
5 Orpesa Orpesa 34 43 29 58
6 At. Saguntino Saguntino 34 59 31 57
7 CD Acero CD Acero 34 56 37 55
8 CD Burriana CD Burriana 34 62 38 54
9 Almenara Atlètic Almenara 34 48 42 52
10 Villafamés Villafamés 34 57 52 51
11 UD Vall de Uxó Vall Uxó 34 47 46 44
12 Vinaròs Vinaròs 34 29 46 39
13 C.F San Pedro Pedro 34 37 46 38
14 Benicarló Benicarló 34 37 55 37
15 CF Borriol CF Borriol 34 50 62 36
16 L´Alcora L´Alcora 34 34 53 36
17 Alcala de Xivert Alcala 34 24 98 11
18 San Mateo San Mateo 34 20 98 10
TEMPORADA 1992/1993
TERCERA DIVISIÓN GRUPO 6
Equipo PJ GF GC Puntos
1 Pinoso Pinoso 38 49 29 49
2 Crevillente Deportivo Crevillente 38 51 39 49
3 Villena Villena 38 57 38 49
4 UD Oliva UD Oliva 38 58 29 48
5 Calpe Calpe 38 54 43 48
6 Ontinyent CF Ontinyent 38 45 23 45
7 CF Gandia CF Gandia 38 61 39 44
8 Alaquas I Walter A Alaquas 38 45 41 42
9 SD Sueca SD Sueca 38 43 39 41
10 Jávea Jávea 38 43 28 40
11 Eldense Eldense 38 53 41 40
12 Alberic Alberic 38 45 48 36
13 Mutxamel Mutxamel 38 48 52 36
14 UD Alzira UD Alzira 38 31 51 35
15 Carcaixent Carcaixent 38 57 63 34
16 Benicarló Benicarló 38 47 47 32
17 Foios Foios 38 39 62 27
18 Torrent Torrent 38 22 42 27
19 Picassent Picassent 38 39 73 24
20 At. Saguntino Saguntino 38 31 91 14
TEMPORADA 1988/1989
TERCERA DIVISIÓN GRUPO 6
Equipo PJ GF GC Puntos
1 Benidorm Benidorm 42 86 21 67
2 CD Burriana CD Burriana 42 71 34 62
3 Valencia Mestalla Valencia 42 89 35 60
4 Ontinyent CF Ontinyent 42 67 32 56
5 Alaquas I Walter A Alaquas 42 60 52 49
6 Onda Onda 42 43 34 47
7 Torrent Torrent 42 60 46 46
8 UD Vall de Uxó Vall Uxó 42 63 51 46
9 Betxi Betxi 42 54 39 43
10 Villajoyosa Villajoyosa 42 54 49 42
11 Pego Pego 42 43 43 41
12 Racing D´ Algemesí Racing 42 33 41 41
13 CD Acero CD Acero 42 52 63 38
14 SD Sueca SD Sueca 42 53 49 38
15 Dénia Dénia 42 43 62 38
16 Aspense Aspense 42 46 59 36
17 Ilicitano Ilicitano 42 38 54 35
18 Alicante Alicante 42 32 70 32
19 SC Requena SC Requena 42 31 54 31
20 At. Saguntino Saguntino 42 43 76 27
21 Canals Canals 42 17 56 27
22 Benicarló Benicarló 42 28 86 22
TEMPORADA 1987/1988
TERCERA DIVISIÓN GRUPO 6
Equipo PJ GF GC Puntos
1 Nules Nules 40 81 35 59
2 Torrent Torrent 40 73 29 58
3 CD Burriana CD Burriana 40 70 26 57
4 SD Sueca SD Sueca 40 47 28 50
5 Ilicitano Ilicitano 40 60 41 48
6 Ontinyent CF Ontinyent 40 47 27 47
7 Villajoyosa Villajoyosa 40 62 51 45
8 Alaquas I Walter A Alaquas 40 46 40 45
9 At. Saguntino Saguntino 40 61 48 45
10 Canals Canals 40 44 32 42
11 Alicante Alicante 40 58 57 42
12 Racing D´ Algemesí Racing 40 63 58 41
13 UD Vall de Uxó Vall Uxó 40 46 51 41
14 Dénia Dénia 40 46 57 34
15 CD Acero CD Acero 40 39 55 34
16 Betxi Betxi 40 41 52 33
17 SC Requena SC Requena 40 25 54 31
18 Benicarló Benicarló 40 47 78 31
19 CD Castellón B Castellón 40 30 67 26
20 Monovar Monovar 40 32 84 17
21 Novelda CF Novelda CF 40 20 68 14
TEMPORADA 1986/1987
TERCERA DIVISIÓN GRUPO 6
Equipo PJ GF GC Puntos
1 Olimpic Xátiva Olimpic 38 73 22 64
2 Levante Levante 38 66 21 54
3 Villarreal Villarreal 38 64 34 49
4 Benidorm Benidorm 38 47 28 47
5 Valencia Mestalla Valencia 38 56 39 46
6 Racing D´ Algemesí Racing 38 55 45 43
7 Monovar Monovar 38 36 27 42
8 Villajoyosa Villajoyosa 38 48 40 42
9 Nules Nules 38 40 35 41
10 Alicante Alicante 38 49 44 40
11 SC Requena SC Requena 38 39 36 37
12 CD Burriana CD Burriana 38 37 52 32
13 Alaquas I Walter A Alaquas 38 41 67 32
14 Novelda CF Novelda CF 38 43 61 31
15 Ontinyent CF Ontinyent 38 39 52 30
16 CD Castellón B Castellón 38 38 57 29
17 Benicarló Benicarló 38 38 63 29
18 Vinaròs Vinaròs 38 29 46 29
19 Rayo Ibense Rayo Ibense 38 33 67 23
20 Catarroja CF Catarroja 38 29 64 20
TEMPORADA 1985/1986
TERCERA DIVISIÓN GRUPO 6
Equipo PJ GF GC Puntos
1 UD Alzira UD Alzira 38 65 28 57
2 CF Gandia CF Gandia 38 62 23 56
3 Nules Nules 38 52 33 43
4 Olimpic Xátiva Olimpic 38 56 39 43
5 Valencia Mestalla Valencia 38 63 38 42
6 Villarreal Villarreal 38 51 39 41
7 Ontinyent CF Ontinyent 38 47 45 40
8 CD Burriana CD Burriana 38 51 47 39
9 Benidorm Benidorm 38 48 48 37
10 Villajoyosa Villajoyosa 38 49 50 37
11 CD Castellón B Castellón 38 48 49 36
12 Alicante Alicante 38 46 49 36
13 SC Requena SC Requena 38 41 55 35
14 Novelda CF Novelda CF 38 39 46 34
15 Catarroja CF Catarroja 38 46 57 33
16 Rayo Ibense Rayo Ibense 38 41 65 33
17 Benicarló Benicarló 38 43 58 31
18 Vinaròs Vinaròs 38 33 59 31
19 Villena Villena 38 33 68 28
20 Carcaixent Carcaixent 38 37 55 28

  USO DE MEMORIA  
7,847,528 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.5909
Total Execution Time  0.5925
  CADENA URL  
/historico/Benicarlo
  GET DATOS  
$_GET['/historico/Benicarlo']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0296  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 = 73769
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=468 AND type_rel = 2
0.0150  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 = '468' 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 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=468 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (73769,69369) 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.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 73769 AND teamId = 468
0.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 69369 AND teamId = 468
0.0149  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 = '468' 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 = '468' and rp.type = 4
0.0146  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 = '468' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0218  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 = 73769 WHERE rp.league_id = 73769 AND rp.teamId = 468 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.0229  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 = 73769 WHERE rp.league_id = 73769 AND rp.teamId = 468 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0177  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 = 73769 WHERE rp.league_id = 73769 AND rp.teamId = 468 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0159  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 = 468 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 69369 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 `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 = 58584 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.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 `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 = 51210 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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 `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 = 44494 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 `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 = 39355 AND t.round = 34 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 `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 = 33968 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0172  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 `tables1993` 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 = 21885 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 `tables1989` 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 = 21800 AND t.round = 42 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 `tables1988` 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 = 21781 AND t.round = 51 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 `tables1987` 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 = 21762 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0643  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 `tables1986` 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 = 21748 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC