4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CD Quintanar de la Orden

CD Quintanar de la Orden

Entrenador: Iván Nieto

Temporada 2023/2024
TEMPORADA 2023/2024
PREFERENTE C. LA MANCHA GRUPO 1
Equipo PJ GF GC Puntos
1 Valdepeñas Valdepeñas 31 57 29 64
2 CD Pedroñeras Pedroñeras 30 42 16 62
3 Manzanares CF Manzanares 31 44 26 60
4 UD Almansa UD Almansa 31 62 30 59
5 Motilla CF Motilla CF 31 52 30 56
6 AD Campillo AD Campillo 31 61 37 53
7 Atlético Teresiano Atlético 31 49 45 52
8 Sporting de Alcazar Sporting 31 46 37 47
9 UD Carrión UD Carrión 31 38 41 45
10 EFB La Roda EFB La Roda 31 41 47 44
11 C.F. Almodovar C.F. 30 32 29 44
12 CD Quintanar de la Orden Quintanar 30 44 39 40
13 La Roda CF La Roda CF 31 42 55 34
14 Patrimonio Almadén CF Patrimonio 31 34 60 30
15 Miguelturreño Miguelturre 30 30 48 27
16 Socuéllamos B Socuéllamos 31 29 53 22
17 C.D. Caudetano C.D. 31 34 77 18
18 UD La Fuente Fuente 31 28 66 13
TEMPORADA 2022/2023
PREFERENTE C. LA MANCHA GRUPO 2
Equipo PJ GF GC Puntos
1 CD Cazalegas Cazalegas 34 78 33 80
2 CD Noblejas CD Noblejas 34 63 25 64
3 CD Quintanar de la Orden Quintanar 34 49 41 61
4 CD Madridejos Madridejos 34 57 32 61
5 Villa CD Villa CD 34 57 49 55
6 AD Seseña CF Seseña 34 42 46 52
7 Mora CF Mora CF 34 48 48 49
8 Sporting de Alcazar Sporting 34 60 55 47
9 San Jose Obrero Jose Obrero 34 59 54 42
10 CD Toledo B CD Toledo B 34 36 43 42
11 CD Yuncos CD Yuncos 34 38 53 41
12 CF Alovera CF Alovera 34 38 42 41
13 SP Cabanillas Cabanillas 34 47 49 40
14 AD Hogar Alcarreño Hogar 34 39 53 39
15 CD Azuqueca B Azuqueca 34 38 59 38
16 CF Orgaceño Orgaceño 34 39 52 37
17 CD Bargas CD Bargas 34 39 63 30
18 Balona Conquense Balona 34 40 70 25
TEMPORADA 2021/2022
PREFERENTE C. LA MANCHA GRUPO 1
Equipo PJ GF GC Puntos
1 CF La Solana Solana 33 77 30 74
2 Atlético Tomelloso Atlético 34 50 36 63
3 Manzanares CF Manzanares 34 57 27 62
4 CD Pedroñeras Pedroñeras 34 57 37 61
5 Valdepeñas Valdepeñas 34 67 48 57
6 AD Campillo AD Campillo 34 53 42 52
7 UD Carrión UD Carrión 34 59 47 49
8 CD Quintanar de la Orden Quintanar 34 48 34 48
9 Criptanense Criptanense 34 45 34 48
10 Sporting de Alcazar Sporting 34 37 48 45
11 Atlético Ibañés Atlético 34 50 41 44
12 UD La Fuente Fuente 34 59 58 44
13 EFB La Roda EFB La Roda 34 44 47 42
14 CDB Herencia Herencia 34 49 53 40
15 C.F. Almodovar C.F. 34 37 53 37
16 Munera Munera 34 52 76 34
17 C.D. Caudetano C.D. 33 31 98 27
18 Almagro CF Almagro CF 34 26 89 16
TEMPORADA 2020/2021
PREFERENTE C. LA MANCHA GRUPO 1
Equipo PJ GF GC Puntos
1 AD San Clemente Clemente 22 43 15 47
2 Criptanense Criptanense 22 24 14 40
3 CD Quintanar de la Orden Quintanar 22 35 24 37
4 Atlético Tomelloso Atlético 22 36 25 36
5 San Jose Obrero Jose Obrero 22 33 30 35
6 AD Campillo AD Campillo 22 31 31 31
7 Munera Munera 22 24 27 29
8 CDB Herencia Herencia 22 29 33 28
9 Sporting de Alcazar Sporting 22 21 38 26
10 Membrilla CF Membrilla 22 23 29 25
11 Atlético Ossa CF Atlético 22 28 42 20
12 La Gineta La Gineta 22 24 43 15
TEMPORADA 2019/2020
PREFERENTE C. LA MANCHA GRUPO 1
Equipo PJ GF GC Puntos
1 Manzanares CF Manzanares 26 47 7 65
2 Huracan de Balazote Huracan 26 43 17 56
3 AD San Clemente Clemente 26 48 23 54
4 CD Quintanar de la Orden Quintanar 26 35 21 46
5 La Gineta La Gineta 26 37 24 42
6 UD Carrión UD Carrión 26 23 21 37
7 Miguelturreño Miguelturre 26 23 23 37
8 Atlético Tomelloso Atlético 26 26 23 36
9 AD Campillo AD Campillo 26 32 32 34
10 San Jose Obrero Jose Obrero 26 31 37 33
11 Criptanense Criptanense 26 28 39 32
12 UD La Fuente Fuente 26 32 41 30
13 Sporting de Alcazar Sporting 26 25 29 29
14 C.F. Almodovar C.F. 26 34 44 29
15 Membrilla CF Membrilla 26 25 36 29
16 Daimiel Daimiel 26 20 30 21
17 Atlético Tarazona Atlético 26 18 41 21
18 Cultural Valdeganga Cultural 26 23 62 21
TEMPORADA 2018/2019
PREFERENTE C. LA MANCHA GRUPO 2
Equipo PJ GF GC Puntos
1 CD Illescas CD Illescas 33 71 18 77
2 CD Torrijos CD Torrijos 33 54 19 70
3 AD Hogar Alcarreño Hogar 33 71 34 66
4 CD Yuncos CD Yuncos 33 60 40 56
5 CD Sonseca CD Sonseca 33 47 45 53
6 San Jose Obrero Jose Obrero 33 45 38 51
7 CD Quintanar de la Orden Quintanar 33 40 40 43
8 SP Cabanillas Cabanillas 33 39 43 43
9 ACDM Horche ACDM Horche 33 36 37 42
10 CD Pantoja CD Pantoja 33 36 42 41
11 FD Formacion Deportiva Formacion 33 45 58 40
12 CD Urda CD Urda 33 30 46 39
13 CD Toledo B CD Toledo B 33 39 44 38
14 CD Mocejon CD Mocejon 33 44 50 37
15 Corazon Titan Corazon 33 31 42 36
16 Torpedo 66 Torpedo 66 33 46 61 32
17 Villa CD Villa CD 33 35 70 31
18 Cobeja Cobeja 17 14 56 5
TEMPORADA 2017/2018
PREFERENTE C. LA MANCHA GRUPO 2
Equipo PJ GF GC Puntos
1 CD Tarancon CD Tarancon 34 72 32 72
2 CD Quintanar de la Orden Quintanar 34 52 25 62
3 CD Illescas CD Illescas 34 54 41 60
4 AD Hogar Alcarreño Hogar 34 56 41 55
5 CD Yuncos CD Yuncos 34 48 55 48
6 Torpedo 66 Torpedo 66 34 52 45 47
7 Corazon Titan Corazon 34 42 38 45
8 CD Pantoja CD Pantoja 34 42 53 45
9 San Jose Obrero Jose Obrero 34 56 50 44
10 CD Sonseca CD Sonseca 34 55 55 44
11 CD Mocejon CD Mocejon 34 39 52 42
12 ACDM Horche ACDM Horche 34 48 48 41
13 CD Toledo B CD Toledo B 34 56 63 41
14 FD Formacion Deportiva Formacion 34 49 61 41
15 CDEEF Patrocinio CDEEF 34 32 45 40
16 CD Bargas CD Bargas 34 35 50 40
17 AD Seseña CF Seseña 34 41 55 38
18 Yeles CD Yeles CD 34 43 63 38
TEMPORADA 2016/2017
PREFERENTE C. LA MANCHA GRUPO 2
Equipo PJ GF GC Puntos
1 CD Villacañas Villacañas 34 62 25 70
2 CD Quintanar de la Orden Quintanar 34 72 31 69
3 San Jose Obrero Jose Obrero 34 62 32 64
4 CD Sonseca CD Sonseca 34 51 36 60
5 CD Tarancon CD Tarancon 34 57 31 58
6 FD Formacion Deportiva Formacion 34 49 58 51
7 Calera Calera 34 42 41 48
8 CD Pantoja CD Pantoja 34 45 38 47
9 CD Bargas CD Bargas 34 38 41 47
10 Torpedo 66 Torpedo 66 34 52 55 46
11 AD Seseña CF Seseña 34 53 59 45
12 ACDM Horche ACDM Horche 34 47 52 44
13 Miguel Esteban AD Miguel 34 37 46 43
14 Corazon Titan Corazon 34 46 55 40
15 CD Torrijos CD Torrijos 34 52 57 36
16 CF Alovera CF Alovera 34 34 63 30
17 Guadalajara B Guadalajara 34 35 65 29
18 Fuensalida Fuensalida 34 32 81 28
TEMPORADA 2015/2016
PREFERENTE C. LA MANCHA GRUPO 2
Equipo PJ GF GC Puntos
1 CD Yuncos CD Yuncos 34 76 27 73
2 Guadalajara B Guadalajara 34 60 34 63
3 CD Quintanar de la Orden Quintanar 34 54 33 63
4 CD Bargas CD Bargas 34 60 47 54
5 Torpedo 66 Torpedo 66 34 69 50 53
6 CD Tarancon CD Tarancon 34 56 41 51
7 CD Villacañas Villacañas 34 46 32 50
8 CD Sonseca CD Sonseca 34 45 36 50
9 CD Torrijos CD Torrijos 34 48 42 50
10 CD Pantoja CD Pantoja 34 45 44 50
11 ACDM Horche ACDM Horche 34 47 49 47
12 Calera Calera 34 42 39 46
13 AD Seseña CF Seseña 34 51 56 43
14 Arges Futbol Arges Futbol 34 37 74 33
15 Academia Albiceleste Academia 34 38 72 30
16 El Casar El Casar 34 31 59 30
17 CD Los Yébenes Yébenes 34 36 65 29
18 Talavera La Nueva Talavera 34 34 75 28
TEMPORADA 2014/2015
PREFERENTE C. LA MANCHA GRUPO 1
Equipo PJ GF GC Puntos
1 San Jose Obrero Jose Obrero 33 79 40 71
2 Munera Munera 33 73 27 70
3 CF La Solana Solana 33 78 38 70
4 Atlético Tomelloso Atlético 34 86 35 65
5 U.B. Conquense B U.B. 33 52 40 57
6 UD Tobarra UD Tobarra 33 49 34 54
7 Motilla CF Motilla CF 33 54 40 53
8 UD Carrión UD Carrión 33 46 34 51
9 CD Quintanar de la Orden Quintanar 33 50 48 45
10 Cd Miguelturreño Miguelturre 33 39 51 39
11 U.D. Alpera U.D. Alpera 33 50 61 37
12 C.D.B.F. Cervantes C.D.B.F. 33 38 54 35
13 C.F. Almodovar C.F. 33 41 62 35
14 C.D. Caudetano C.D. 33 36 66 35
15 EF Zona 5 EF Zona 5 33 31 64 35
16 CD Mota Del Cuervo Mota Cuervo 32 28 63 20
17 Cd Piedrabuena Piedrabuena 32 27 77 19
18 Tomelloso Tomelloso 18 21 44 12
TEMPORADA 2013/2014
PREFERENTE C. LA MANCHA GRUPO 1
Equipo PJ GF GC Puntos
1 Almagro CF Almagro CF 34 60 30 71
2 Daimiel Daimiel 34 61 34 69
3 Munera Munera 34 55 37 66
4 San Jose Obrero Jose Obrero 34 70 39 65
5 CF La Solana Solana 34 70 51 57
6 Isso CF Isso CF 34 58 35 57
7 CD Quintanar de la Orden Quintanar 34 58 41 54
8 Tomelloso Tomelloso 34 60 53 53
9 CD Mota Del Cuervo Mota Cuervo 34 58 47 45
10 Cervantes Cervantes 34 51 71 42
11 La Roda CF B Roda 34 42 55 41
12 Miguelturreño Miguelturre 34 40 49 40
13 Piedrabuena Piedrabuena 34 51 49 40
14 UD Tobarra UD Tobarra 34 40 55 37
15 CDB Herencia Herencia 34 50 61 37
16 Madrigueras UD Madrigueras 34 39 64 32
17 Criptanense Criptanense 34 50 68 31
18 Atlético Teresiano Atlético 34 19 93 12
TEMPORADA 2009/2010
PREFERENTE C. LA MANCHA GRUPO 1
Equipo PJ GF GC Puntos
1 Manzanares CF Manzanares 34 67 32 70
2 CF La Solana Solana 34 82 51 69
3 Villarrubia CF Villarrubia 34 55 33 69
4 Aldea del Rey Aldea 34 113 49 65
5 Puertollano B Puertollano 34 77 48 61
6 Miguelturreño Miguelturre 34 56 49 52
7 Atlético Ibañés Atlético 34 49 56 51
8 Atlético Teresiano Atlético 34 57 61 49
9 Albacer Albacer 34 46 42 47
10 Almagro CF Almagro CF 34 65 56 45
11 CD Manchego Provencio Manchego 34 49 62 44
12 Villamalea Villamalea 34 45 50 41
13 Bolañego Bolañego 34 40 50 40
14 Deportivo Barrax Deportivo 34 48 54 39
15 Hellín B Hellín B 34 44 56 38
16 CD Quintanar de la Orden Quintanar 34 39 63 36
17 Atlético Tarazona Atlético 34 39 58 33
18 CD Pedroñeras Pedroñeras 34 19 120 7
TEMPORADA 2008/2009
PREFERENTE C. LA MANCHA GRUPO 2
Equipo PJ GF GC Puntos
1 Carranque Carranque 34 76 33 75
2 CD Torrijos CD Torrijos 34 72 27 72
3 Mora CF Mora CF 34 57 28 67
4 Chozas de Canales Chozas 34 61 40 55
5 At. Consuegra Consuegra 34 46 46 53
6 UD Talavera UD Talavera 34 68 49 49
7 San Jose Obrero Jose Obrero 34 47 43 49
8 CD Noblejas CD Noblejas 34 40 39 49
9 Cobeja Cobeja 34 58 51 47
10 CD Villacañas Villacañas 34 52 48 47
11 CD Quintanar de la Orden Quintanar 34 45 62 46
12 SP Cabanillas Cabanillas 34 45 50 43
13 CD Madridejos Madridejos 34 33 38 42
14 CD Yuncos CD Yuncos 34 48 47 41
15 Talavera La Nueva Talavera 34 53 83 40
16 CD Sonseca CD Sonseca 34 39 54 35
17 Fuensalida Fuensalida 34 36 78 25
18 Tomelloso B Tomelloso B 34 29 89 19
TEMPORADA 2005/2006
TERCERA DIVISIÓN GRUPO 18
Equipo PJ GF GC Puntos
1 Puertollano Puertollano 38 75 28 94
2 CD Guadalajara Guadalajara 38 74 24 88
3 CD Toledo CD Toledo 38 68 33 74
4 Gimnástico de Alcázar Gimnástico 38 59 39 68
5 Atlético Albacete Atlético 38 53 33 66
6 Manchego Manchego 38 38 29 64
7 CP Villarrobledo Villarrobled 38 63 47 59
8 UD Yugo Socuéllamos Yugo 38 50 38 57
9 Tomelloso Tomelloso 38 43 43 53
10 CD Quintanar del Rey Quintanar 38 42 48 52
11 La Roda CF La Roda CF 38 44 47 46
12 UD Talavera UD Talavera 38 40 51 46
13 SD Tarazona SD Tarazona 38 42 54 42
14 CD Marchamalo Marchamalo 38 52 78 41
15 CF La Solana Solana 38 38 55 40
16 Cuenca-Mestallistes 1925 Cuenca-Mesta 38 44 62 39
17 CD Illescas CD Illescas 38 31 52 34
18 CD Quintanar de la Orden Quintanar 38 35 67 34
19 CD Villacañas Villacañas 38 42 78 28
20 Daimiel Daimiel 38 27 54 26
TEMPORADA 1969/1970
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 CD Colonia Moscardó Colonia 38 73 34 53
2 Tenerife Tenerife 38 59 28 49
3 AD Plus Ultra Plus Ultra 38 57 28 49
4 CD Badajoz CD Badajoz 38 81 50 49
5 Atlético B Atlético B 38 77 45 48
6 Mérida CP Mérida CP 38 74 48 46
7 Talavera CF Talavera CF 38 71 57 45
8 RCD Carabanchel Carabanchel 38 65 50 44
9 Plasencia Plasencia 38 57 48 41
10 Real Valladolid Promesas Real 38 62 53 41
11 Galáctico Pegaso Galáctico 38 60 55 40
12 SAD Villaverde Villaverde 38 64 64 39
13 RSD Alcalá RSD Alcalá 38 63 60 38
14 Aviaco Aviaco 38 49 54 37
15 CF Extremadura Extremadura 38 52 66 29
16 CP Cacereño Cacereño 38 55 71 29
17 CD Quintanar de la Orden Quintanar 38 42 75 28
18 Gimnástica Segoviana Gimnástica 38 49 71 26
19 CD Toledo CD Toledo 38 52 100 21
20 Olivenza Olivenza 38 28 133 8
TEMPORADA 1968/1969
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 UD Salamanca Salamanca 38 73 26 55
2 CD Colonia Moscardó Colonia 38 92 42 55
3 Tenerife Tenerife 38 80 44 47
4 AD Plus Ultra Plus Ultra 38 52 35 47
5 CP Cacereño Cacereño 38 58 46 44
6 CD Badajoz CD Badajoz 38 57 41 44
7 CD Quintanar de la Orden Quintanar 38 67 55 43
8 RSD Alcalá RSD Alcalá 38 71 58 41
9 Mérida CP Mérida CP 38 55 58 38
10 SAD Villaverde Villaverde 38 55 73 36
11 Galáctico Pegaso Galáctico 38 51 62 35
12 Talavera CF Talavera CF 38 46 51 35
13 Atlético B Atlético B 38 52 57 35
14 RCD Carabanchel Carabanchel 38 58 48 35
15 Aviaco Aviaco 38 58 68 33
16 CF Extremadura Extremadura 38 44 58 33
17 Plasencia Plasencia 38 41 69 33
18 Gimnástica Segoviana Gimnástica 38 50 72 32
19 Béjar Industrial Béjar 38 45 67 26
20 Gimnástico de Alcázar Gimnástico 38 33 108 13
TEMPORADA 1967/1968
TERCERA DIVISIÓN GRUPO 13
Equipo PJ GF GC Puntos
1 AD Plus Ultra Plus Ultra 34 104 21 56
2 Talavera CF Talavera CF 34 72 37 47
3 Gimnástica Segoviana Gimnástica 34 80 44 44
4 Calvo Sotelo PGR Calvo Sotelo 34 79 45 43
5 Gimnástico de Alcázar Gimnástico 34 57 35 42
6 CD Manchego CD Manchego 34 43 37 42
7 CD Quintanar de la Orden Quintanar 34 48 38 40
8 Galáctico Pegaso Galáctico 34 53 47 40
9 Tomelloso Tomelloso 34 55 44 39
10 Atlético B Atlético B 34 79 46 39
11 Femsa Femsa 34 64 63 34
12 UD Yugo Socuéllamos Yugo 34 39 40 33
13 Real Ávila Real Ávila 34 50 53 29
14 Santa Barbara CF Santa 34 33 82 22
15 CD Guadalajara Guadalajara 34 35 68 22
16 CD Toledo CD Toledo 34 45 87 19
17 CP Villarrobledo Villarrobled 34 33 100 12
18 Atco. Pedro Muñoz Atco. Pedro 34 12 94 9
TEMPORADA 1966/1967
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 CD Badajoz CD Badajoz 34 104 16 54
2 AD Plus Ultra Plus Ultra 34 83 19 52
3 CF Extremadura Extremadura 34 90 26 51
4 CD Manchego CD Manchego 34 79 38 43
5 CD Toledo CD Toledo 34 62 42 41
6 Mérida CP Mérida CP 34 54 53 40
7 CP Cacereño Cacereño 34 48 30 40
8 Talavera CF Talavera CF 34 69 53 39
9 CD Quintanar de la Orden Quintanar 34 61 52 36
10 Diter Zafra Diter Zafra 34 64 60 35
11 Plasencia Plasencia 34 45 49 31
12 CD Don Benito Benito 34 33 57 27
13 Calvo Sotelo PGR Calvo Sotelo 34 53 63 26
14 Real Ávila Real Ávila 34 37 66 25
15 Gimnástica Segoviana Gimnástica 34 47 67 24
16 Santa Barbara CF Santa 34 31 93 20
17 Olivenza Olivenza 33 31 95 16
18 CD Villacañas Villacañas 33 15 127 10

  USO DE MEMORIA  
7,655,256 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5816
Total Execution Time  0.5828
  CADENA URL  
/historico/Quintanar-Orden
  GET DATOS  
$_GET['/historico/Quintanar-Orden']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4306 AND type_rel = 2
0.0149  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 = '4306' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0152  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=4306 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145  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 (73526,71759) 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 = 73526 AND teamId = 4306
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 71759 AND teamId = 4306
0.0146  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 = 71759 AND t.round = 8 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0151  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 = 71759 WHERE rp.league_id = 71759 AND rp.teamId = 4306 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.0156  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 = 71759 WHERE rp.league_id = 71759 AND rp.teamId = 4306 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151  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 = 71759 WHERE rp.league_id = 71759 AND rp.teamId = 4306 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0155  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 = 4306 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0295  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 = 73526 AND t.round = 31 ORDER BY team.conference ASC,t.position 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 `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 = 68797 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.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 `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 = 63675 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.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 `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 = 58932 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.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 `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 = 51208 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.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 `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 = 44769 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 `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 = 39694 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 = 34108 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158  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 = 16709 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 `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 = 4077 AND t.round = 34 ORDER BY team.conference 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 `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 = 2697 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 `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 = 948 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 316 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160  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 = 22130 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 `tables1970` 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 = 21626 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 `tables1969` 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 = 21619 AND t.round = 38 ORDER BY team.conference 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 `tables1968` 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 = 21611 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 `tables1967` 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 = 22209 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC