4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del UD Tomares
TEMPORADA 2023/2024
DIVISIÓN HONOR SENIOR GRUPO 1
Equipo PJ GF GC Puntos
1 Club Atl. Central Club Atl. C. 23 31 16 43
2 Atlético Onubense Atlético 23 29 18 42
3 UD Tomares UD Tomares 23 37 21 39
4 Castilleja Castilleja 23 34 22 38
5 Almodóvar del Río Almodóvar 23 35 36 36
6 Lebrijana Lebrijana 23 29 19 35
7 Los Barrios Los Barrios 23 30 23 35
8 Chiclana CF Chiclana CF 23 24 22 32
9 San Fernando CD B Fernando 23 20 21 32
10 Montilla Montilla 23 27 24 31
11 UD Algaida UD Algaida 23 24 28 31
12 CD Rota CD Rota 23 26 30 30
13 Viso UP Viso UP 23 27 30 27
14 Pinzón CD Pinzón CD 23 23 44 20
15 Utrera B Utrera B 23 23 38 18
16 Villafranco Villafranco 23 18 45 9
TEMPORADA 2022/2023
DIVISIÓN HONOR SENIOR GRUPO 1
Equipo PJ GF GC Puntos
1 La Palma CF La Palma CF 30 52 25 62
2 Cabecense Cabecense 30 45 23 54
3 UD Tomares UD Tomares 30 59 38 53
4 Chiclana CF Chiclana CF 30 40 25 52
5 Villafranco Villafranco 30 36 28 52
6 UD Algaida UD Algaida 30 43 30 47
7 Castilleja Castilleja 30 36 30 44
8 Los Barrios Los Barrios 30 27 26 43
9 Lebrijana Lebrijana 30 26 21 36
10 Viso UP Viso UP 30 34 35 35
11 Club Atl. Central Club Atl. C. 30 24 34 35
12 Montilla Montilla 30 21 30 34
13 Palma del Rio Atletico CF Palma 30 23 48 30
14 Arcos CF Arcos CF 30 32 54 26
15 Moguer CD Moguer CD 30 22 53 22
16 Egabrense Egabrense 30 31 51 21
TEMPORADA 2021/2022
TERCERA FEDERACIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 Recreativo Recreativo 32 57 20 77
2 Utrera Utrera 32 59 26 67
3 Xerez CD Xerez CD 32 50 24 62
4 Ciudad de Lucena Ciudad 32 45 25 60
5 CD Gerena CD Gerena 32 53 31 58
6 Córdoba CF B Córdoba 32 54 33 58
7 Salerm Puente Genil Salerm 32 36 41 45
8 Sevilla C Sevilla C 32 40 48 43
9 AD Ceuta FC B Ceuta 32 26 39 37
10 Conil Conil 32 30 49 36
11 CD Rota CD Rota 32 31 45 36
12 CD Pozoblanco Pozoblanco 32 37 49 34
13 Atlético Antoniano Atlético 32 29 35 34
14 AD Cartaya AD Cartaya 32 26 30 33
15 UD Tomares UD Tomares 32 27 46 31
16 Cabecense Cabecense 32 25 51 23
17 Los Barrios Los Barrios 32 26 59 23
TEMPORADA 2020/2021
DIVISIÓN HONOR SENIOR GRUPO 5
Equipo PJ GF GC Puntos
1 AD Cartaya AD Cartaya 26 51 31 48
2 UD Tomares UD Tomares 26 45 34 48
3 Chiclana CF Chiclana CF 26 40 31 46
4 CD Guadalcacín Guadalcacín 26 40 29 45
5 Atlético Espeleño Atlético 26 41 32 43
6 Montilla Montilla 26 42 37 41
7 PD Rociera PD Rociera 26 34 30 39
8 Viso UP Viso UP 26 34 46 28
TEMPORADA 2019/2020
DIVISIÓN HONOR SENIOR GRUPO 1
Equipo PJ GF GC Puntos
1 Castilleja Castilleja 25 44 23 52
2 Cabecense Cabecense 25 49 26 46
3 La Palma CF La Palma CF 25 41 29 45
4 Atlético Onubense Atlético 25 35 21 40
5 Chiclana CF Chiclana CF 25 35 34 40
6 Atlético Espeleño Atlético 25 43 30 39
7 UD Tomares UD Tomares 25 39 33 36
8 CD San Roque Roque 25 33 25 35
9 AD Cartaya AD Cartaya 25 28 21 35
10 Torreblanca CF Torreblanca 25 27 26 34
11 Viso UP Viso UP 25 30 31 30
12 CD Guadalcacín Guadalcacín 25 26 27 30
13 AD San José José 25 41 43 30
14 Aroche CF Aroche CF 25 21 35 30
15 Isla Cristina Isla 25 22 35 28
16 CD Alcalá CD Alcalá 25 27 41 25
17 Atlético Algabeño Atlético 25 30 52 20
18 Ciudad Jardin CD Ciudad 25 26 65 18
TEMPORADA 2018/2019
PRIMERA ANDALUZA GRUPO 5
Equipo PJ GF GC Puntos
1 UD Tomares UD Tomares 34 82 32 77
2 PD Rociera PD Rociera 34 64 33 67
3 Villafranco Villafranco 34 67 46 60
4 UD Bellavista Bellavista 34 71 53 59
5 UD Morón UD Morón 34 68 42 58
6 A. Cerro Águila Cerro 34 64 41 56
7 Estrella San Agustín Estrella 34 48 38 56
8 Osuna Bote Club Osuna Bote. 34 58 56 52
9 Lora CF Lora CF 34 42 46 49
10 CD Coronil CD Coronil 34 47 49 45
11 Mairena Mairena 34 39 51 43
12 Camas Camas 34 46 58 41
13 Paradas Balompié Paradas 34 54 69 41
14 CD Pedrera CD Pedrera 34 68 68 40
15 Camino Viejo Camino Viejo 34 39 55 36
16 Los Palacios CF Palacios 34 40 57 36
17 Alcalá del Río CF Alcalá Río 34 29 76 17
18 CD Demo CD Demo 34 28 84 17
TEMPORADA 2017/2018
PRIMERA ANDALUZA GRUPO 5
Equipo PJ GF GC Puntos
1 Torreblanca CF Torreblanca 34 53 20 72
2 Moron Moron 34 66 34 66
3 Los Palacios CF Palacios 34 53 30 63
4 UD Morón UD Morón 34 55 36 60
5 PD Rociera PD Rociera 34 55 37 59
6 UD Tomares UD Tomares 34 65 42 59
7 A. Cerro Águila Cerro 34 58 47 54
8 Villafranco Villafranco 34 48 44 52
9 UD Bellavista Bellavista 34 45 45 50
10 CD Demo CD Demo 34 45 47 49
11 Mairena Mairena 34 47 54 47
12 Lora CF Lora CF 34 36 47 42
13 CD Coronil CD Coronil 34 35 42 40
14 CD Pedrera CD Pedrera 34 36 52 37
15 UD Villaverde Villaverde 34 30 43 35
16 San Juan San Juan 34 36 52 35
17 CD Diablos Rojos Diablos 34 26 62 23
18 La Liara Balompie Liara 34 22 77 9
TEMPORADA 2016/2017
PRIMERA ANDALUZA GRUPO 6
Equipo PJ GF GC Puntos
1 Atlético Algabeño Atlético 34 72 45 63
2 Los Palacios CF Palacios 34 60 44 57
3 PD Rociera PD Rociera 34 49 39 53
4 Villafranco Villafranco 34 58 47 53
5 A. Cerro Águila Cerro 34 58 40 53
6 UD Tomares UD Tomares 34 60 63 53
7 Torreblanca CF Torreblanca 34 51 41 51
8 Moron Moron 34 58 48 50
9 UD Bellavista Bellavista 34 57 55 49
10 Mairena Mairena 34 47 42 49
11 CD Diablos Rojos Diablos 34 47 45 48
12 CD Pedrera CD Pedrera 34 62 67 46
13 La Liara Balompie Liara 34 45 50 43
14 Osuna Bote Club Osuna Bote. 34 46 56 42
15 Puebla CF Puebla CF 34 49 62 39
16 Pilas Pilas 34 47 58 33
17 Nervión Nervión 34 40 66 32
18 La Barrera La Barrera 34 34 72 24
TEMPORADA 2015/2016
2ª ANDALUZA SEVILLA
Equipo PJ GF GC Puntos
1 Viso UP Viso UP 34 59 26 67
2 Villafranco Villafranco 34 67 50 63
3 UD Tomares UD Tomares 34 55 38 61
4 Torreblanca C.F. Torreblanca 34 55 36 60
5 Osuna Bote Club Osuna Bote. 34 57 38 59
6 A. Cerro Águila Cerro 34 59 35 56
7 La Liara Balompie Liara 33 53 38 54
8 CD Diablos Rojos Diablos 32 56 49 53
9 Puebla CF Puebla CF 34 45 37 49
10 Atlético Algabeño Atlético 34 57 54 47
11 Mosqueo Mosqueo 34 47 58 42
12 Paradas Balompié Paradas 33 55 58 40
13 Ciudad Jardin Ciudad 34 38 62 40
14 UD Rinconada Rinconada 34 48 54 37
15 UD Soleá UD Soleá 34 48 69 36
16 CD Coronil CD Coronil 34 43 65 30
17 Gilena C.F. Gilena C.F. 34 33 62 26
18 Huévar C.F. Huévar C.F. 34 38 84 22
TEMPORADA 2014/2015
2ª ANDALUZA SEVILLA
Equipo PJ GF GC Puntos
1 Nervión Nervión 34 77 31 79
2 UD Rinconada Rinconada 34 63 47 64
3 Pilas Pilas 34 57 34 63
4 A. Cerro Águila Cerro 34 64 37 62
5 Puebla CF Puebla CF 34 65 48 56
6 Osuna Bote Club Osuna Bote. 34 65 54 54
7 Paradas Balompié Paradas 34 45 55 53
8 UD Tomares UD Tomares 34 64 62 51
9 Viso UP Viso UP 34 48 43 46
10 Atlético Algabeño Atlético 34 68 63 45
11 UD Soleá UD Soleá 34 54 46 43
12 Torreblanca C.F. Torreblanca 34 47 57 42
13 Mosqueo Mosqueo 34 44 48 41
14 Huévar C.F. Huévar C.F. 34 51 66 41
15 UD Bellavista Bellavista 34 51 62 38
16 Triana CF Triana CF 34 36 68 30
17 San Antonio Drago Antonio 34 45 81 27
18 CD Albaida CD Albaida 34 44 86 21
TEMPORADA 2013/2014
2ª ANDALUZA SEVILLA
Equipo PJ GF GC Puntos
1 Moron Moron 38 79 38 81
2 CD Pedrera CD Pedrera 38 92 34 80
3 Nervión Nervión 38 94 42 74
4 Mosqueo Mosqueo 38 65 46 66
5 CD Albaida CD Albaida 38 59 50 63
6 Puebla Farnals Puebla 38 65 54 61
7 Huévar C.F. Huévar C.F. 38 80 68 60
8 Torreblanca CF Torreblanca 38 61 55 60
9 Triana CF Triana CF 38 65 54 58
10 UD Rinconada Rinconada 38 54 61 56
11 A. Cerro Águila Cerro 38 64 61 55
12 UD Bellavista Bellavista 38 52 54 50
13 UD Tomares UD Tomares 38 72 70 49
14 Paradas Balompié Paradas 38 67 80 48
15 Dos Hermanas CF Hermanas 38 66 72 45
16 Ciudad Jardín Ciudad 38 41 58 42
17 UD Marinaleda Marinaleda 38 41 81 38
18 Los Palacios Palacios 38 52 76 36
19 Brenes Balompié Brenes 38 34 71 30
20 Guillena Cf Guillena Cf 38 22 100 12
TEMPORADA 2012/2013
2ª ANDALUZA SEVILLA
Equipo PJ GF GC Puntos
1 Osuna Bote Club Osuna Bote. 34 51 31 65
2 La Estrella La Estrella 34 60 40 63
3 Triana CF Triana CF 34 61 45 62
4 UD Bellavista Bellavista 34 53 49 57
5 Puebla Farnals Puebla 34 57 46 56
6 Torreblanca CF Torreblanca 34 64 57 55
7 UD Tomares UD Tomares 34 67 50 52
8 Mosqueo Mosqueo 34 52 44 51
9 UD Rinconada Rinconada 34 62 45 50
10 CD Pedrera CD Pedrera 34 59 56 49
11 Guillena Cf Guillena Cf 34 41 48 44
12 A. Cerro Águila Cerro 34 42 42 43
13 Dos Hermanas CF Hermanas 34 39 55 41
14 Ciudad Jardín Ciudad 34 56 58 40
15 A.D. Barrios Unidos A.D. Barrios 34 59 73 38
16 Arahal Arahal 34 39 60 35
17 UD Soleá UD Soleá 34 36 62 33
18 UD Villaverde Villaverde 34 50 87 26
TEMPORADA 2010/2011
2ª ANDALUZA SEVILLA
Equipo PJ GF GC Puntos
1 CD Gerena CD Gerena 36 96 41 78
2 Cabecense Cabecense 36 81 51 68
3 Lora CF Lora CF 36 59 38 67
4 Lebrijana Lebrijana 36 71 58 58
5 La Estrella La Estrella 36 68 58 53
6 Ciudad Jardín Ciudad 36 64 58 51
7 Mosqueo Mosqueo 36 49 55 51
8 Triana CF Triana CF 36 65 63 50
9 Moron Moron 36 54 49 47
10 UD Bellavista Bellavista 36 57 59 46
11 Puebla Farnals Puebla 36 44 54 46
12 UD Villaverde Villaverde 36 51 66 46
13 Nervión Nervión 36 50 68 46
14 CD Pedrera CD Pedrera 36 62 67 45
15 Camino Viejo Camino Viejo 36 62 66 44
16 UD Tomares UD Tomares 36 44 54 40
17 Atlético Sanlucar Atlético 36 43 54 35
18 Atlético Algabeño Atlético 36 52 87 34
19 Huévar C.F. Huévar C.F. 36 66 92 32
TEMPORADA 2009/2010
2ª ANDALUZA SEVILLA
Equipo PJ GF GC Puntos
1 Brenes Balompié Brenes 34 90 49 69
2 PD Rociera PD Rociera 34 54 37 66
3 Triana CF Triana CF 34 75 42 63
4 Huévar C.F. Huévar C.F. 34 65 42 63
5 Puebla Farnals Puebla 34 54 33 59
6 Lora CF Lora CF 34 57 50 54
7 UD Tomares UD Tomares 34 53 51 49
8 La Estrella La Estrella 34 51 41 48
9 UD Bellavista Bellavista 34 51 54 47
10 Atlético Algabeño Atlético 34 47 57 43
11 Lebrijana Lebrijana 34 42 53 43
12 UD Villaverde Villaverde 34 46 55 42
13 Nervión Nervión 34 46 64 39
14 Atlético Sanlucar Atlético 34 48 65 38
15 Torreblanca CF Torreblanca 34 55 69 37
16 CD San Martin Martin 34 39 56 36
17 Pilas Pilas 34 41 58 33
18 Camas Camas 34 35 73 25
TEMPORADA 2008/2009
PRIMERA ANDALUZA GRUPO 2
Equipo PJ GF GC Puntos
1 UD Marinaleda Marinaleda 34 56 36 61
2 AD San José José 34 51 41 61
3 Montilla Montilla 34 51 27 60
4 Arahal Arahal 34 59 39 58
5 Utrera Utrera 34 49 35 56
6 Peñarroya Pueblonuevo Peñarroya 34 64 42 54
7 Real Betis C Real Betis 34 41 29 54
8 Castilleja Castilleja 34 54 50 52
9 San Juan San Juan 34 48 33 51
10 Aguilarense Aguilarense 34 58 54 48
11 A. Cerro Águila Cerro 34 48 51 46
12 Baena At. Baena At. 34 42 38 42
13 Paradas B. Paradas B. 34 46 54 42
14 Cabecense Cabecense 34 40 40 41
15 UD Tomares UD Tomares 34 43 56 41
16 Camas Camas 34 36 59 31
17 Pilas Pilas 34 38 86 25
18 Belmezano Belmezano 34 26 80 17
TEMPORADA 2007/2008
PRIMERA ANDALUZA GRUPO 2
Equipo PJ GF GC Puntos
1 Atlético Antoniano Atlético 34 54 17 69
2 Coria CF Coria CF 34 61 23 65
3 Montilla Montilla 34 51 33 61
4 Utrera Utrera 34 65 40 55
5 Baena At. Baena At. 34 42 35 53
6 Paradas B. Paradas B. 34 42 28 51
7 Castilleja Castilleja 34 46 38 50
8 Cabecense Cabecense 34 37 34 49
9 UD Marinaleda Marinaleda 34 40 34 48
10 UD Tomares UD Tomares 34 49 49 46
11 Peñarroya Pueblonuevo Peñarroya 34 38 36 45
12 Pilas Pilas 34 44 53 45
13 Arahal Arahal 34 33 33 43
14 Camas Camas 34 38 49 43
15 Moron Moron 34 39 39 42
16 Egabrense Egabrense 34 26 59 30
17 CD Montalbeño Montalbeño 34 26 70 21
18 Priego Ind. Priego Ind. 34 33 94 14
TEMPORADA 2006/2007
2ª ANDALUZA SEVILLA
Equipo PJ GF GC Puntos
1 UD Tomares UD Tomares 34 50 23 68
2 UD Marinaleda Marinaleda 34 57 24 67
3 Arahal Arahal 34 57 31 67
4 Real Betis C Real Betis 34 65 34 66
5 Nueva Sevilla Nueva 34 50 33 56
6 A.D. San José A.D. José 34 47 37 54
7 Marchena Balompié Marchena 34 39 33 49
8 JD Bormujos JD Bormujos 34 49 47 49
9 CD San Martin Martin 34 62 49 47
10 CS San Antonio Antonio 34 56 61 45
11 Estepa Ind. Estepa Ind. 34 45 44 44
12 Atlético Algabeño Atlético 34 37 38 43
13 AD. Carmona AD. Carmona 34 46 43 41
14 Mosqueo Mosqueo 34 34 51 40
15 Lebrijana Lebrijana 34 33 51 36
16 Poli Aguadulce Poli 34 23 55 28
17 Viso UP Viso UP 34 34 64 24
18 Su Eminencia Eminencia 34 18 84 13
TEMPORADA 2005/2006
2ª ANDALUZA SEVILLA
Equipo PJ GF GC Puntos
1 Sevilla C Sevilla C 34 48 11 73
2 Paradas B. Paradas B. 34 63 36 66
3 A.D. San José A.D. José 34 63 40 66
4 Real Betis C Real Betis 34 85 37 65
5 Estepa Ind. Estepa Ind. 34 60 36 64
6 UD Tomares UD Tomares 34 47 35 50
7 UD Marinaleda Marinaleda 34 40 34 49
8 CD San Martin Martin 34 49 44 46
9 AD. Carmona AD. Carmona 34 46 49 44
10 Lebrijana Lebrijana 34 41 55 43
11 Viso UP Viso UP 33 43 41 41
12 Mosqueo Mosqueo 34 38 47 40
13 San Juan Bosco Juan Bosco 34 47 54 38
14 Poli Aguadulce Poli 34 45 58 38
15 Su Eminencia Eminencia 34 48 77 38
16 UD Rinconada Rinconada 34 37 56 37
17 La Estrella La Estrella 34 26 50 31
18 Brenes Balompié Brenes 33 25 91 19
TEMPORADA 2004/2005
2ª ANDALUZA SEVILLA
Equipo PJ GF GC Puntos
1 Cabecense Cabecense 34 58 30 72
2 Pilas Pilas 34 63 26 70
3 Estepa Ind. Estepa Ind. 34 59 40 57
4 AD. Carmona AD. Carmona 34 49 28 56
5 UD Marinaleda Marinaleda 34 47 35 56
6 San Juan Bosco Juan Bosco 34 57 42 52
7 CD San Martin Martin 34 32 31 48
8 Mosqueo Mosqueo 34 57 53 46
9 Viso UP Viso UP 34 43 43 45
10 UD Tomares UD Tomares 34 30 39 44
11 Su Eminencia Eminencia 34 42 56 42
12 Lebrijana Lebrijana 34 50 61 40
13 La Estrella La Estrella 34 41 60 40
14 Brenes Balompié Brenes 34 34 44 39
15 Atlético Algabeño Atlético 34 41 62 38
16 Puebla Farnals Puebla 34 33 44 37
17 Cantillana Cantillana 34 42 67 29
18 JD Bormujos JD Bormujos 34 39 56 26

  USO DE MEMORIA  
7,487,552 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1487
Total Execution Time  0.1500
  CADENA URL  
/historico/U-D-Tomares-470
  GET DATOS  
$_GET['/historico/U-D-Tomares-470']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (44)  
0.0040  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 = 'U-D-Tomares-470' 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=14952 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0017  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=14952 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=14952 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041  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 = 72023
0.0025  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 = 73495
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=14952 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2383 AND type_rel = 3
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 = '14952' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '14952' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 72023 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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 = 73495 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=14952 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (73495,72023) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 73495 AND teamId = 14952
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 72023 AND teamId = 14952
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 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 = 72023 AND t.round = 5 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0023  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 = '14952' 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 = '14952' and rp.type = 4
0.0024  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 = '14952' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 72023 WHERE rp.league_id = 72023 AND rp.teamId = 14952 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.0030  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 = 72023 WHERE rp.league_id = 72023 AND rp.teamId = 14952 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 72023 WHERE rp.league_id = 72023 AND rp.teamId = 14952 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 = 14952 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73495 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.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 `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 = 68671 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.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 = 62394 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.0020  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 = 58970 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.0020  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 = 61678 AND t.round = 8 ORDER BY team.conference ASC,t.position 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 `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 = 51038 AND t.round = 25 ORDER BY team.conference ASC,t.position 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 `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 = 44624 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 `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 = 39328 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 `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 = 34151 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 `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 = 16800 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 `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 = 4103 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 `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 = 2575 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 `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 = 2943 AND t.round = 38 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 `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 = 2942 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 324 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 `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 = 113 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 `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 = 2939 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 `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 = 2938 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 `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 = 2937 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 dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 72023 ORDER BY nameShow LIMIT 100