4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CD Utiel
TEMPORADA 2023/2024
TERCERA FEDERACIÓN GRUPO 6
Equipo PJ GF GC Puntos
1 Ilicitano Ilicitano 32 72 18 79
2 FC Jove Español Jove 32 44 21 61
3 Ontinyent 1931 Ontinyent 32 37 25 59
4 Atzeneta Atzeneta 32 39 24 57
5 CF Gandia CF Gandia 32 44 39 47
6 CD Utiel CD Utiel 32 38 37 47
7 At. Levante At. Levante 32 42 35 46
8 CD Roda CD Roda 32 32 31 41
9 UD Castellonense Castellonens 32 37 40 41
10 Villarreal C Villarreal 32 46 43 40
11 AC Torrellano Torrellano 32 33 39 39
12 Soneja Soneja 32 35 41 39
13 Patacona CF Patacona CF 32 37 49 37
14 CD Castellón B Castellón 32 42 49 37
15 Rayo Ibense Rayo Ibense 32 26 37 36
16 CD Acero CD Acero 32 35 51 34
17 CD Burriana CD Burriana 32 24 43 30
18 Silla CF Silla CF 32 24 65 22
TEMPORADA 2022/2023
PRIMERA FFCV GRUPO 2
Equipo PJ GF GC Puntos
1 CD Utiel CD Utiel 34 76 33 79
2 Buñol Buñol 34 65 21 72
3 Recambios Colón Recambios 34 67 19 70
4 Paiporta Paiporta 34 63 40 69
5 Manises Manises 34 69 53 61
6 Ribarroja CF Ribarroja 34 52 38 59
7 L'Alcúdia L'Alcúdia 34 48 32 57
8 SC Requena SC Requena 34 47 36 56
9 UD Aldaia UD Aldaia 34 48 48 52
10 UD Quart De Poblet Quart Poblet 34 45 50 44
11 Mislata Mislata 34 47 61 42
12 Paterna CF Paterna CF 34 57 69 33
13 Union Benetuser Union 34 38 57 33
14 San Antonio Benagéber Antonio 34 42 65 28
15 Algemesí C.F. Algemesí 34 45 67 28
16 Vilamarxant Vilamarxant 34 45 71 27
17 Alginet Alginet 34 35 93 22
18 San Marcelino Marcelino 34 40 76 21
TEMPORADA 2021/2022
PRIMERA FFCV GRUPO 2
Equipo PJ GF GC Puntos
1 Patacona CF Patacona CF 30 81 22 71
2 Buñol Buñol 30 64 13 69
3 Ribarroja CF Ribarroja 30 53 30 59
4 CD Utiel CD Utiel 30 50 22 54
5 SC Requena SC Requena 30 39 31 44
6 Alboraya Alboraya 30 44 32 43
7 Vilamarxant Vilamarxant 30 37 36 43
8 Manises Manises 30 40 49 40
9 Puzol Puzol 30 34 44 38
10 Godella Godella 30 44 59 36
11 San Antonio Benagéber Antonio 30 43 51 35
12 Paterna CF Paterna CF 30 36 41 34
13 Vallbonense Vallbonense 30 25 27 32
14 A. Moncadense Moncadense 30 34 56 31
15 Torre Levante Torre 30 34 65 24
16 La Eliana La Eliana 30 19 99 8
TEMPORADA 2020/2021
PRIMERA FFCV GRUPO 3
Equipo PJ GF GC Puntos
1 Buñol Buñol 26 37 16 59
2 CD Utiel CD Utiel 26 37 17 52
3 San Marcelino Marcelino 26 40 27 50
4 Manises Manises 26 43 27 39
5 Paiporta Paiporta 26 39 27 37
6 UD Quart De Poblet Quart Poblet 26 26 29 35
7 Benimar Picanya Benimar 26 33 35 34
8 Alcàsser Alcàsser 26 32 33 32
9 UD Aldaia UD Aldaia 26 29 41 31
10 Juv. Barrio Cristo Juv. Barrio 26 25 30 29
11 Union Benetuser Union 26 29 35 29
12 SC Requena SC Requena 26 25 33 28
13 Monte Sión Monte Sión 26 26 47 21
14 Discóbolo-La Torre Discóbolo-L 26 22 46 17
TEMPORADA 2019/2020
PRIMERA FFCV GRUPO 2
Equipo PJ GF GC Puntos
1 Buñol Buñol 26 43 15 57
2 Torrent Torrent 26 34 21 52
3 San Marcelino Marcelino 26 37 22 49
4 CD Utiel CD Utiel 26 44 21 47
5 SC Requena SC Requena 26 37 24 45
6 Paiporta Paiporta 26 42 23 43
7 UD Quart De Poblet Quart Poblet 26 44 30 40
8 Juv. Barrio Cristo Juv. Barrio 26 39 37 40
9 UD Aldaia UD Aldaia 26 51 44 39
10 Torre Levante Torre 26 30 27 37
11 Ribarroja CF Ribarroja 26 38 32 35
12 Benimar Picanya Benimar 26 34 43 34
13 R. Benagéber Benagéber 26 40 40 30
14 Vallbonense Vallbonense 26 30 43 26
15 La Eliana La Eliana 26 28 45 24
16 Godella Godella 26 30 51 23
17 Burjassot Burjassot 26 28 64 16
18 Discóbolo-La Torre Discóbolo-L 26 25 72 11
TEMPORADA 2018/2019
PRIMERA FFCV GRUPO 2
Equipo PJ GF GC Puntos
1 Recambios Colón Recambios 34 80 13 88
2 Ribarroja CF Ribarroja 34 68 23 73
3 CD Utiel CD Utiel 34 61 21 69
4 Torrent Torrent 34 60 27 69
5 Buñol Buñol 34 40 24 56
6 Discóbolo-La Torre Discóbolo-L 34 48 47 54
7 Burjassot Burjassot 34 43 48 46
8 SC Requena SC Requena 34 27 30 45
9 San Marcelino Marcelino 34 43 41 44
10 UD Quart De Poblet Quart Poblet 34 39 48 44
11 R. Benagéber Benagéber 34 44 44 40
12 Vallbonense Vallbonense 34 37 63 39
13 Juv. Barrio Cristo Juv. Barrio 34 36 51 38
14 Alcàsser Alcàsser 34 45 55 35
15 UD Aldaia UD Aldaia 34 30 46 35
16 Mislata Mislata 34 34 66 28
17 Castellar-Oliveral Castellar-Ol 34 33 64 25
18 Serranos Serranos 34 31 88 12
TEMPORADA 2017/2018
PRIMERA FFCV GRUPO 2
Equipo PJ GF GC Puntos
1 Vilamarxant Vilamarxant 34 74 26 77
2 Ribarroja CF Ribarroja 34 86 31 73
3 Torrent Torrent 34 67 30 72
4 CD Utiel CD Utiel 34 68 41 66
5 Burjassot Burjassot 34 59 44 60
6 UD Quart De Poblet Quart Poblet 33 51 42 52
7 San Marcelino Marcelino 34 52 54 49
8 Mislata Mislata 34 62 53 47
9 Juv. Barrio Cristo Juv. Barrio 34 43 46 42
10 Vallbonense Vallbonense 34 45 56 42
11 Castellar-Oliveral Castellar-Ol 34 47 68 41
12 Alcàsser Alcàsser 33 41 49 40
13 Huracan Moncada Huracan 34 51 56 38
14 SC Requena SC Requena 34 38 53 36
15 Discóbolo-La Torre Discóbolo-L 34 34 54 36
16 Massanassa C.F. A Massanassa 34 43 64 33
17 San Antonio Benagéber Antonio 34 38 73 33
18 Lliria UD Lliria UD 34 30 89 13
TEMPORADA 2016/2017
PRIMERA FFCV GRUPO 2
Equipo PJ GF GC Puntos
1 Paiporta Paiporta 34 66 30 67
2 Ribarroja CF Ribarroja 34 73 34 65
3 Vilamarxant Vilamarxant 34 62 28 63
4 SC Requena SC Requena 34 55 34 63
5 UD Quart De Poblet Quart Poblet 34 48 29 61
6 Torrent Torrent 34 46 32 55
7 Castellar-Oliveral Castellar-Ol 34 51 47 52
8 CD Utiel CD Utiel 34 47 33 50
9 Burjassot Burjassot 34 51 43 50
10 Juv. Barrio Cristo Juv. Barrio 33 51 43 49
11 Lliria UD Lliria UD 34 39 40 47
12 R. Benagéber Benagéber 34 60 53 46
13 Alginet Alginet 34 50 53 44
14 Massanassa C.F. A Massanassa 33 41 51 41
15 Discóbolo-La Torre Discóbolo-L 33 36 46 39
16 Serranos Serranos 34 27 62 25
17 CD Cheste CD Cheste 33 42 91 22
18 CF Chiva CF Chiva 34 17 113 1
TEMPORADA 2015/2016
PRIMERA FFCV GRUPO 2
Equipo PJ GF GC Puntos
1 Torrent Torrent 34 67 33 74
2 CD Utiel CD Utiel 34 57 32 67
3 Silla CF Silla CF 34 65 39 61
4 UD Quart De Poblet Quart Poblet 34 51 35 58
5 Paiporta Paiporta 34 47 37 52
6 Castellar-Oliveral Castellar-Ol 34 51 47 51
7 Discóbolo-La Torre Discóbolo-L 34 38 46 47
8 CD Cheste CD Cheste 34 49 47 47
9 Vilamarxant Vilamarxant 34 46 39 46
10 Juv. Barrio Cristo Juv. Barrio 34 48 59 44
11 SC Requena SC Requena 34 50 47 43
12 Lliria UD Lliria UD 34 44 58 40
13 Ribarroja CF Ribarroja 34 33 44 40
14 CF Chiva CF Chiva 34 51 57 39
15 Alboraya Alboraya 34 29 40 38
16 Manises Manises 34 31 40 37
17 UD Aldaia UD Aldaia 34 28 62 29
18 Godella Godella 34 48 71 27
TEMPORADA 2014/2015
TERCERA DIVISIÓN GRUPO 6
Equipo PJ GF GC Puntos
1 CD Castellón Castellón 40 61 29 74
2 At. Levante At. Levante 40 61 31 72
3 Novelda CF Novelda CF 40 66 36 66
4 Villarreal C Villarreal 40 60 51 62
5 Ontinyent CF Ontinyent 40 57 36 62
6 Muro Muro 40 55 56 62
7 Orihuela CF Orihuela CF 40 55 35 62
8 Crevillente Deportivo Crevillente 40 43 35 59
9 Benigànim Benigànim 40 54 51 59
10 Torrevieja Torrevieja 40 44 45 57
11 At. Saguntino Saguntino 40 51 48 54
12 CD Acero CD Acero 40 51 67 53
13 Torre Levante Torre 40 40 42 51
14 UD Alzira UD Alzira 40 49 59 50
15 Paterna CF Paterna CF 40 42 59 49
16 FC Jove Español Jove 40 36 54 47
17 CF Cullera CF Cullera 40 49 52 47
18 Ribarroja CF Ribarroja 40 31 47 45
19 CF La Nucía Nucía 40 36 44 40
20 SC Requena SC Requena 40 33 64 32
21 CD Utiel CD Utiel 40 31 64 26
TEMPORADA 2013/2014
TERCERA DIVISIÓN GRUPO 6
Equipo PJ GF GC Puntos
1 Eldense Eldense 38 61 34 71
2 UD Alzira UD Alzira 38 60 33 65
3 Orihuela CF Orihuela CF 38 40 31 65
4 Paterna CF Paterna CF 38 46 36 63
5 Novelda CF Novelda CF 38 39 34 59
6 Muro Muro 38 44 34 58
7 CF Cullera CF Cullera 38 46 37 57
8 CF La Nucía Nucía 38 40 40 55
9 CD Acero CD Acero 38 56 49 52
10 Torrevieja Torrevieja 38 47 50 52
11 At. Saguntino Saguntino 38 31 28 51
12 FC Jove Español Jove 38 40 37 50
13 Ribarroja CF Ribarroja 38 39 47 49
14 Villarreal C Villarreal 38 52 51 48
15 CD Castellón Castellón 38 44 43 43
16 Torre Levante Torre 38 37 49 41
17 CD Utiel CD Utiel 38 42 65 40
18 CF Borriol CF Borriol 38 29 43 37
19 CD Llosa CD Llosa 38 33 56 37
20 Pinoso Pinoso 38 35 64 33
TEMPORADA 2012/2013
TERCERA DIVISIÓN GRUPO 6
Equipo PJ GF GC Puntos
1 Ilicitano Ilicitano 40 47 28 71
2 Novelda CF Novelda CF 40 50 37 71
3 UD Alzira UD Alzira 40 50 39 69
4 CD Castellón Castellón 40 58 29 68
5 CF La Nucía Nucía 40 47 36 62
6 Muro Muro 40 53 47 59
7 Villarreal C Villarreal 40 53 50 59
8 CF Borriol CF Borriol 40 52 39 57
9 CD Utiel CD Utiel 40 45 40 56
10 Eldense Eldense 40 46 39 53
11 At. Saguntino Saguntino 40 36 45 53
12 CD Llosa CD Llosa 40 44 45 52
13 Torrevieja Torrevieja 40 45 42 52
14 FC Jove Español Jove 40 44 48 50
15 Ribarroja CF Ribarroja 40 35 46 48
16 CD Acero CD Acero 40 49 60 48
17 CD Burriana CD Burriana 40 40 57 47
18 CF Gandia CF Gandia 39 32 39 45
19 Crevillente Deportivo Crevillente 40 40 51 45
20 Dénia Dénia 40 43 56 42
21 Catarroja CF Catarroja 39 29 65 28
TEMPORADA 2011/2012
PRIMERA FFCV GRUPO 2
Equipo PJ GF GC Puntos
1 CD Utiel CD Utiel 34 63 37 66
2 Torre Levante Torre 34 48 23 65
3 UD Quart De Poblet Quart Poblet 34 60 38 64
4 Buñol Buñol 34 55 44 58
5 Cdfb La Eliana Cdfb Eliana 34 43 35 52
6 Cheste Cheste 34 53 47 52
7 Paterna CF Paterna CF 34 43 34 49
8 Fbm Moncada Fbm Moncada 34 45 47 46
9 Lliria UD Lliria UD 34 46 51 46
10 Burjassot Burjassot 34 46 44 44
11 Masamagrell Masamagrell 34 39 44 44
12 Alboraya Alboraya 34 47 42 43
13 San Marcelino Marcelino 34 48 51 43
14 Chiva Chiva 34 44 47 42
15 CF Albuixech Albuixech 34 46 52 40
16 Parreta Cf Parreta Cf 34 34 45 37
17 Atlético Vallbonense Atlético 34 29 60 25
18 Foios Foios 34 26 74 25
TEMPORADA 2010/2011
PRIMERA FFCV GRUPO 2
Equipo PJ GF GC Puntos
1 SC Requena SC Requena 34 49 36 66
2 Cheste Cheste 34 60 35 62
3 CD Utiel CD Utiel 34 52 36 61
4 Buñol Buñol 34 46 31 60
5 Torre Levante Orriols B Torre 34 49 39 58
6 Fbm Moncada Fbm Moncada 34 65 54 54
7 Quart Quart 34 45 40 53
8 Parreta Cf Parreta Cf 34 48 47 47
9 Torrent Torrent 34 41 32 45
10 Paterna CF Paterna CF 34 41 36 45
11 Masamagrell Masamagrell 34 42 48 43
12 Lliria UD Lliria UD 34 60 56 41
13 Atlético Vallbonense Atlético 34 60 57 41
14 Alboraya Alboraya 34 41 47 41
15 Foios Foios 34 34 47 39
16 Godella Godella 34 49 63 39
17 Crack´s Crack´s 34 39 48 37
18 Burjassot B Burjassot B 34 22 91 6
TEMPORADA 2009/2010
PRIMERA FFCV GRUPO 2
Equipo PJ GF GC Puntos
1 Buñol Buñol 34 65 35 78
2 Mislata Mislata 34 69 30 76
3 Paterna CF Paterna CF 34 65 43 68
4 Quart Quart 34 53 30 65
5 Torre Levante Torre 34 70 40 64
6 CD Utiel CD Utiel 34 58 44 60
7 Lliria UD Lliria UD 34 45 40 49
8 Burjassot B Burjassot B 34 43 40 47
9 Foios Foios 34 37 49 44
10 SC Requena SC Requena 34 45 46 41
11 Atl. Benaguasil Atl. 34 50 60 37
12 Alboraya Alboraya 34 51 52 34
13 Masamagrell Masamagrell 34 36 47 34
14 Crack´s Crack´s 34 41 55 34
15 Godella Godella 34 37 65 34
16 Atl. Museros Atl. Museros 34 40 53 31
17 Aldaia Aldaia 34 30 72 26
18 San Marcelino Marcelino 34 28 62 25
TEMPORADA 2008/2009
TERCERA DIVISIÓN GRUPO 6
Equipo PJ GF GC Puntos
1 Villajoyosa Villajoyosa 38 58 31 74
2 CFI Alicante B Alicante 38 62 33 71
3 CF La Nucía Nucía 38 45 27 71
4 Torrevieja Torrevieja 38 52 29 68
5 CF Gandia CF Gandia 38 41 30 64
6 Eldense Eldense 38 44 32 64
7 Burjassot Burjassot 38 50 38 62
8 Catarroja CF Catarroja 38 43 37 59
9 Villarreal C Villarreal 38 66 52 56
10 Onda Onda 38 44 43 53
11 Novelda CF Novelda CF 38 45 33 51
12 At. Levante At. Levante 38 34 38 47
13 FC Jove Español Jove 38 50 46 44
14 Ribarroja CF Ribarroja 38 38 49 43
15 Juv. Barrio Cristo Juv. Barrio 38 42 59 41
16 Crevillente Deportivo Crevillente 38 40 51 39
17 Puçol Puçol 38 48 71 39
18 CD Castellón B Castellón 38 50 66 38
19 Pego Pego 38 26 80 24
20 CD Utiel CD Utiel 38 31 64 24
TEMPORADA 2007/2008
TERCERA DIVISIÓN GRUPO 6
Equipo PJ GF GC Puntos
1 UD Alzira UD Alzira 40 64 28 79
2 Valencia Mestalla Valencia 40 66 26 75
3 CF La Nucía Nucía 40 59 32 72
4 Catarroja CF Catarroja 40 60 38 72
5 Eldense Eldense 40 54 34 70
6 Novelda CF Novelda CF 40 58 38 69
7 CD Utiel CD Utiel 40 55 43 64
8 Villarreal C Villarreal 40 45 47 55
9 Onda Onda 40 49 46 53
10 FC Jove Español Jove 40 39 45 53
11 Burjassot Burjassot 40 41 41 52
12 Puçol Puçol 40 39 53 51
13 Crevillente Deportivo Crevillente 40 32 35 50
14 CD Castellón B Castellón 40 40 59 50
15 Torrevieja Torrevieja 40 51 55 49
16 Juv. Barrio Cristo Juv. Barrio 40 43 50 47
17 Pego Pego 40 43 59 47
18 Thader Thader 40 37 54 45
19 Olimpic Xátiva Olimpic 40 36 53 43
20 Ilicitano Ilicitano 40 36 65 33
21 Alone De Guardamar Alone 40 34 80 31
TEMPORADA 2006/2007
PRIMERA FFCV GRUPO 2
Equipo PJ GF GC Puntos
1 Juv. Barrio Cristo Juv. Barrio 34 68 28 76
2 CD Utiel CD Utiel 34 63 25 74
3 Ribarroja CF Ribarroja 34 55 20 69
4 Buñol Buñol 34 59 31 57
5 At. Benaguasil Benaguasil 34 46 31 55
6 Torre Levante Torre 34 49 51 50
7 Foyos Foyos 34 54 46 46
8 Lliria UD Lliria UD 34 52 57 44
9 Crack´s Crack´s 34 33 37 41
10 El Puig El Puig 34 42 48 41
11 Puebla Farnals Puebla 34 32 38 40
12 Masamagrell Masamagrell 34 32 39 39
13 Cdf Requena Cdf Requena 34 38 45 38
14 Alboraya Alboraya 34 46 65 38
15 Chiva Chiva 34 37 62 37
16 Godella Godella 34 47 65 35
17 Puzol B Puzol B 34 37 62 34
18 Marchalenes Marchalenes 34 36 76 17
TEMPORADA 1998/1999
TERCERA DIVISIÓN GRUPO 6
Equipo PJ GF GC Puntos
1 Ilicitano Ilicitano 38 55 28 71
2 Novelda CF Novelda CF 38 52 32 67
3 Alcoyano Alcoyano 38 33 21 65
4 UD Alzira UD Alzira 38 53 33 63
5 Pego Pego 38 37 21 63
6 CD Burriana CD Burriana 38 56 31 59
7 Burjassot Burjassot 38 40 32 57
8 Pinoso Pinoso 38 38 33 56
9 Onda Onda 38 49 52 53
10 Eldense Eldense 38 54 43 53
11 Foios Foios 38 38 37 51
12 Gimnástico FC Gimnástico 38 34 36 51
13 Dénia Dénia 38 41 42 44
14 Olimpic Xátiva Olimpic 38 43 60 41
15 UD Vall de Uxó Vall Uxó 38 31 47 40
16 San Marcelino Marcelino 38 39 68 39
17 Santa Pola Santa Pola 38 30 54 39
18 SD Sueca SD Sueca 38 29 43 39
19 CD Utiel CD Utiel 38 34 61 36
20 Torrevieja Torrevieja 38 42 54 35
TEMPORADA 1997/1998
TERCERA DIVISIÓN GRUPO 6
Equipo PJ GF GC Puntos
1 Eldense Eldense 38 70 25 83
2 Benidorm Benidorm 38 52 29 68
3 Pinoso Pinoso 38 52 24 68
4 Olimpic Xátiva Olimpic 38 49 38 67
5 Burjassot Burjassot 38 56 40 66
6 Alcoyano Alcoyano 38 59 31 64
7 CD Burriana CD Burriana 38 56 42 62
8 Ilicitano Ilicitano 38 54 52 58
9 Gimnástico FC Gimnástico 38 51 47 58
10 Pego Pego 38 38 27 55
11 Condal Condal 38 44 46 51
12 UD Vall de Uxó Vall Uxó 38 47 56 49
13 SD Sueca SD Sueca 38 33 44 47
14 CD Utiel CD Utiel 38 32 47 45
15 Santa Pola Santa Pola 38 38 55 41
16 Torrevieja Torrevieja 38 44 52 41
17 San Marcelino Marcelino 38 47 68 40
18 FC Jove Español Jove 38 60 65 39
19 CD Acero CD Acero 38 46 71 38
20 Lliria UD Lliria UD 38 23 92 11

  USO DE MEMORIA  
7,873,056 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.1514
Total Execution Time  0.1529
  CADENA URL  
/historico/Utiel
  GET DATOS  
$_GET['/historico/Utiel']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0030  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 = 'Utiel' 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.0018  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=2638 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=2638 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2638 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2470 AND type_rel = 3
0.0025  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 = '2638' ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '2638' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '2638' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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=2638 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (72265,71823) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 72265 AND teamId = 2638
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 71823 AND teamId = 2638
0.0020  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 = '2638' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2638' and rp.type = 4
0.0020  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 = '2638' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0033  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 = 72265 WHERE rp.league_id = 72265 AND rp.teamId = 2638 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.0029  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 = 72265 WHERE rp.league_id = 72265 AND rp.teamId = 2638 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  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 = 72265 WHERE rp.league_id = 72265 AND rp.teamId = 2638 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 2638 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0057  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 = 68782 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 63637 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.0021  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 = 58873 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.0023  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 = 51211 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.0025  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 = 44495 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 39356 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 33969 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 16704 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 3916 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 2556 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 1946 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 1460 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 1201 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 898 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 136 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 13 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 124 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables1999` 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 = 22003 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables1998` 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 = 21987 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC