4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Sevilla Sub 19

Sevilla Sub 19

Entrenador: Lolo Rosano

Temporada 2023/2024
TEMPORADA 2023/2024
DIVISIÓN DE HONOR GRUPO 4
Equipo PJ GF GC Puntos
1 Sevilla Sub 19 Sevilla 32 80 12 86
2 Real Betis Sub 19 Real Betis 33 107 24 82
3 Granada CF Sub 19 Granada 33 58 32 66
4 Cádiz Sub 19 Cádiz 32 55 37 58
5 Almería Sub 19 Almería 32 51 32 54
6 Málaga Sub 19 Málaga 32 57 43 51
7 CD San Félix Sub 19 Félix 33 42 41 47
8 Calavera CF Sub 19 Calavera 33 52 57 45
9 Alhendín Balompié Sub 19 Alhendín 32 38 30 42
10 Córdoba CF Sub 19 Córdoba 32 31 38 41
11 La Cañada Atlético Sub 19 Cañada 32 35 44 41
12 Marbella FC Sub 19 Marbella 33 49 52 37
13 Xerez Deportivo FC Sub 19 Xerez 33 48 60 36
14 Sporting Atlético Sub 19 Sporting 33 28 54 33
15 26 De Febrero Sub 19 Febrero 33 27 51 32
16 Séneca CF Sub 19 Séneca 33 31 67 28
17 UD Tomares Sub 19 Tomares 32 33 61 22
18 UD Melilla Sub 19 Melilla 33 16 103 10
TEMPORADA 2022/2023
DIVISIÓN DE HONOR GRUPO 4
Equipo PJ GF GC Puntos
1 Real Betis Sub 19 Real Betis 34 82 20 86
2 Sevilla Sub 19 Sevilla 34 73 21 84
3 Almería Sub 19 Almería 34 81 28 82
4 Cádiz Sub 19 Cádiz 34 85 44 61
5 Málaga Sub 19 Málaga 34 49 32 61
6 Granada CF Sub 19 Granada 34 61 47 55
7 Calavera CF Sub 19 Calavera 34 55 46 50
8 CD San Félix Sub 19 Félix 34 63 47 48
9 Séneca CF Sub 19 Séneca 34 44 41 45
10 Marbella FC Sub 19 Marbella 34 49 44 45
11 26 De Febrero Sub 19 Febrero 34 40 49 40
12 UD Tomares Sub 19 Tomares 34 56 73 38
13 Recreativo Sub 19 Recreativo 34 46 58 36
14 CD Vázquez Cultural Sub 19 Vázquez 34 41 57 35
15 San Roque Balompie Sub 19 Roque 34 36 62 29
16 CF Rusadir Sub 19 Rusadir 34 36 109 25
17 CD Polillas Ceuta Sub 19 Polillas 34 25 86 20
18 Algeciras CF Sub 19 Algeciras 34 29 87 17
TEMPORADA 2021/2022
DIVISIÓN DE HONOR GRUPO 4
Equipo PJ GF GC Puntos
1 Real Betis Sub 19 Real Betis 42 113 17 111
2 Granada CF Sub 19 Granada 42 110 28 107
3 Sevilla Sub 19 Sevilla 42 115 22 101
4 Calavera CF Sub 19 Calavera 42 74 44 83
5 Almería Sub 19 Almería 42 86 45 81
6 Cádiz Sub 19 Cádiz 42 88 43 80
7 Málaga Sub 19 Málaga 41 76 44 71
8 CD San Félix Sub 19 Félix 42 91 61 66
9 CD Vázquez Cultural Sub 19 Vázquez 41 47 54 58
10 Séneca CF Sub 19 Séneca 42 53 51 56
11 UD Tomares Sub 19 Tomares 42 56 61 54
12 Recreativo Sub 19 Recreativo 42 68 74 54
13 Pvo. El Ejido Sub 19 Pvo. Ejido 42 71 71 54
14 Atl. Jaen Sub 19 Atl. Jaen 42 60 85 51
15 Córdoba CF Sub 19 Córdoba 42 55 60 44
16 CD Tiro Pichón Sub 19 Tiro Pichón 42 53 68 41
17 Coria CF Sub 19 Coria 42 38 62 41
18 CD Santa Fe Sub 19 Santa 42 49 75 40
19 Atlético Sanluqueño Sub 19 Atlético 42 43 77 40
20 Sporting Atlético Sub 19 Sporting 41 36 132 31
21 Castilleja CF Sub 19 Castilleja 42 40 85 29
22 Jóvenes Promesas Sub 19 Jóvenes 41 10 173 2
TEMPORADA 2020/2021
DIVISIÓN DE HONOR GRUPO 21
Equipo PJ GF GC Puntos
1 Málaga Sub 19 Málaga 25 79 16 68
2 Sevilla Sub 19 Sevilla 25 69 6 60
3 Granada CF Sub 19 Granada 25 58 20 54
4 Real Betis Sub 19 Real Betis 25 49 14 53
5 Cádiz Sub 19 Cádiz 25 41 26 45
6 CD San Félix Sub 19 Félix 25 43 22 42
7 Calavera CF Sub 19 Calavera 25 37 37 41
8 Séneca CF Sub 19 Séneca 25 40 41 32
9 CD Vázquez Cultural Sub 19 Vázquez 25 30 40 31
10 CD Tiro Pichón Sub 19 Tiro Pichón 25 32 41 31
TEMPORADA 2019/2020
DIVISIÓN DE HONOR GRUPO 4
Equipo PJ GF GC Puntos
1 Sevilla Sub 19 Sevilla 27 73 19 67
2 Málaga Sub 19 Málaga 27 70 23 62
3 Calavera CF Sub 19 Calavera 29 49 21 59
4 Real Betis Sub 19 Real Betis 27 68 23 58
5 Granada CF Sub 19 Granada 27 48 24 52
6 CD San Félix Sub 19 Félix 29 65 38 47
7 Almería Sub 19 Almería 29 54 39 47
8 Cádiz Sub 19 Cádiz 29 45 35 44
9 CD Vázquez Cultural Sub 19 Vázquez 29 43 42 44
10 CD Santa Fe Sub 19 Santa 29 53 68 35
11 Córdoba CF Sub 19 Córdoba 29 42 44 34
12 AD Nervión Sub 19 Nervión 29 32 44 32
13 26 De Febrero Sub 19 Febrero 29 26 50 29
14 Castilleja CF Sub 19 Castilleja 29 27 44 28
15 Recreativo Sub 19 Recreativo 29 48 74 28
16 Dos Hermanas SA Sub 19 Hermanas 29 28 61 16
17 Gimnástica Ceuta Sub 19 Gimnástica 26 25 87 15
18 Barcelonista Melilla Sub 19 Barcelonista 24 13 73 8
TEMPORADA 2018/2019
DIVISIÓN DE HONOR GRUPO 4
Equipo PJ GF GC Puntos
1 Sevilla Sub 19 Sevilla 34 92 26 79
2 Granada CF Sub 19 Granada 34 64 29 73
3 Real Betis Sub 19 Real Betis 34 82 32 72
4 Málaga Sub 19 Málaga 34 80 35 64
5 Cádiz Sub 19 Cádiz 34 38 26 57
6 Almería Sub 19 Almería 34 58 36 53
7 CD San Félix Sub 19 Félix 34 59 43 52
8 Córdoba CF Sub 19 Córdoba 34 43 46 51
9 CD Vázquez Cultural Sub 19 Vázquez 34 57 52 49
10 Gimnástica Ceuta Sub 19 Gimnástica 33 33 39 41
11 26 De Febrero Sub 19 Febrero 34 42 58 39
12 Calavera CF Sub 19 Calavera 34 51 56 38
13 Recreativo Sub 19 Recreativo 34 32 46 36
14 La Cañada Atlético Sub 19 Cañada 34 34 61 34
15 CD Tiro Pichón Sub 19 Tiro Pichón 34 27 65 31
16 UD Tomares Sub 19 Tomares 33 36 76 29
17 Séneca CF Sub 19 Séneca 34 31 62 25
18 CF Rusadir Sub 19 Rusadir 34 37 108 23
TEMPORADA 2017/2018
DIVISIÓN DE HONOR GRUPO 4
Equipo PJ GF GC Puntos
1 Málaga Sub 19 Málaga 30 86 27 72
2 Real Betis Sub 19 Real Betis 30 61 27 70
3 CD San Félix Sub 19 Félix 30 65 19 69
4 Sevilla Sub 19 Sevilla 30 59 21 68
5 Granada CF Sub 19 Granada 30 72 31 59
6 Almería Sub 19 Almería 30 50 38 48
7 Córdoba CF Sub 19 Córdoba 30 44 35 47
8 UD Tomares Sub 19 Tomares 30 40 47 36
9 Cádiz Sub 19 Cádiz 30 35 44 33
10 La Cañada Atlético Sub 19 Cañada 30 30 49 31
11 26 De Febrero Sub 19 Febrero 30 42 76 30
12 Recreativo Sub 19 Recreativo 30 25 41 27
13 AD Nervión Sub 19 Nervión 30 30 71 27
14 Sevilla Este Sevilla Este 30 30 67 24
15 Atl. Sanluqueño Sub 19 Atl. 30 25 66 22
16 Antequera CF A Antequera 30 28 63 15
TEMPORADA 2016/2017
DIVISIÓN DE HONOR GRUPO 4
Equipo PJ GF GC Puntos
1 Málaga Sub 19 Málaga 34 94 34 75
2 Sevilla Sub 19 Sevilla 34 109 28 75
3 Real Betis Sub 19 Real Betis 34 83 28 74
4 Córdoba CF Sub 19 Córdoba 34 84 39 72
5 Almería Sub 19 Almería 34 73 28 71
6 CD San Félix Sub 19 Félix 34 70 34 62
7 Granada CF Sub 19 Granada 34 62 43 56
8 Recreativo Sub 19 Recreativo 34 49 52 53
9 La Cañada Atlético Sub 19 Cañada 34 48 40 52
10 Cádiz Sub 19 Cádiz 34 36 42 43
11 UD Tomares Sub 19 Tomares 34 47 65 42
12 Sevilla Este Sevilla Este 34 47 69 36
13 Gimnástica Ceuta Sub 19 Gimnástica 34 30 89 32
14 Real Jaén Sub 19 Real Jaén 34 43 74 31
15 CMD San Juan Juvenil Juan Juvenil 34 34 68 30
16 CD Puerto Malagueño Sub 19 Puerto 34 35 70 30
17 CF Rusadir Sub 19 Rusadir 34 29 70 27
18 Dos Hermanas CF Hermanas 34 13 113 0
TEMPORADA 2015/2016
DIVISIÓN DE HONOR GRUPO 4
Equipo PJ GF GC Puntos
1 Sevilla Sub 19 Sevilla 30 59 15 72
2 Málaga Sub 19 Málaga 30 74 21 70
3 Real Betis Sub 19 Real Betis 30 63 23 59
4 Almería Sub 19 Almería 30 58 26 57
5 Granada CF Sub 19 Granada 30 57 45 46
6 Sevilla Este Sevilla Este 30 37 35 44
7 Córdoba CF Sub 19 Córdoba 30 50 45 42
8 CD San Félix Sub 19 Félix 30 41 46 41
9 Cádiz Sub 19 Cádiz 30 43 46 40
10 La Cañada Atlético Sub 19 Cañada 30 40 51 36
11 Recreativo Sub 19 Recreativo 30 37 53 34
12 CMD San Juan Juvenil Juan Juvenil 30 35 56 30
13 CD Santa Fe Sub 19 Santa 30 27 56 29
14 26 De Febrero Sub 19 Febrero 30 38 67 28
15 Marbella FC Sub 19 Marbella 30 25 55 21
16 Séneca CF Sub 19 Séneca 30 17 61 15
TEMPORADA 2014/2015
DIVISIÓN DE HONOR GRUPO 4
Equipo PJ GF GC Puntos
1 Málaga Sub 19 Málaga 34 89 22 78
2 Sevilla Sub 19 Sevilla 34 79 14 71
3 Cádiz Sub 19 Cádiz 34 90 41 69
4 Real Betis Sub 19 Real Betis 34 92 35 67
5 Almería Sub 19 Almería 34 79 50 64
6 Recreativo Sub 19 Recreativo 34 55 28 63
7 Granada CF Sub 19 Granada 34 70 44 56
8 Sevilla Este Sevilla Este 34 45 37 50
9 Séneca CF Sub 19 Séneca 34 48 57 46
10 CD San Félix Sub 19 Félix 34 45 42 45
11 26 De Febrero Sub 19 Febrero 34 54 54 45
12 CD Santa Fe Sub 19 Santa 34 52 59 45
13 CD Puerto Malagueño Sub 19 Puerto 34 51 65 42
14 UD Maracena Sub 19 Maracena 34 37 68 30
15 Atlético Sanluqueño Sub 19 Atlético 34 40 78 23
16 Los Molinos CF Sub 19 Molinos 34 38 83 22
17 Gimnástica Ceuta Sub 19 Gimnástica 34 15 86 20
18 Barcelonista Melilla Sub 19 Barcelonista 34 28 144 18
TEMPORADA 2013/2014
DIVISIÓN DE HONOR GRUPO 4
Equipo PJ GF GC Puntos
1 Málaga Sub 19 Málaga 30 82 21 73
2 Sevilla Sub 19 Sevilla 30 93 25 72
3 Real Betis Sub 19 Real Betis 30 59 29 55
4 Cádiz Sub 19 Cádiz 30 59 33 53
5 Almería Sub 19 Almería 30 52 37 50
6 Granada CF Sub 19 Granada 30 59 38 50
7 CD Santa Fe Sub 19 Santa 30 52 45 44
8 Recreativo Sub 19 Recreativo 30 38 43 44
9 CD Puerto Malagueño Sub 19 Puerto 30 32 33 39
10 Los Molinos CF Sub 19 Molinos 30 37 61 36
11 26 De Febrero Sub 19 Febrero 30 46 52 34
12 Sevilla Este Sevilla Este 30 39 48 34
13 Xerez CD Xerez CD 30 40 64 29
14 CD Gimnastico Melilla Gimnastico 30 35 84 26
15 Coria CF Sub 19 Coria 30 34 66 23
16 AD Taraguilla Juvenil Taraguilla 30 26 104 11
TEMPORADA 2012/2013
DIVISIÓN DE HONOR GRUPO 4
Equipo PJ GF GC Puntos
1 Sevilla Sub 19 Sevilla 30 73 18 71
2 Málaga Sub 19 Málaga 30 70 26 69
3 Almería Sub 19 Almería 30 72 32 66
4 Real Betis Sub 19 Real Betis 30 53 32 51
5 Recreativo Sub 19 Recreativo 30 39 34 42
6 Granada CF Sub 19 Granada 30 39 52 42
7 Xerez CD Xerez CD 30 42 52 41
8 Los Molinos CF Sub 19 Molinos 30 35 52 37
9 CD Puerto Malagueño Sub 19 Puerto 30 35 41 36
10 CD Santa Fe Sub 19 Santa 29 42 45 35
11 Sevilla Este Sevilla Este 30 35 45 35
12 Coria CF Sub 19 Coria 30 43 50 33
13 Córdoba CF Sub 19 Córdoba 30 33 53 30
14 UD Maracena Sub 19 Maracena 29 25 54 26
15 Séneca CF Sub 19 Séneca 30 30 52 24
16 AD Nervión Sub 19 Nervión 30 36 64 21
TEMPORADA 2011/2012
DIVISIÓN DE HONOR GRUPO 4
Equipo PJ GF GC Puntos
1 Sevilla Sub 19 Sevilla 30 65 23 66
2 Málaga Sub 19 Málaga 30 65 26 63
3 Real Betis Sub 19 Real Betis 30 62 34 55
4 Granada CF Sub 19 Granada 30 49 47 51
5 Recreativo Sub 19 Recreativo 30 59 32 48
6 Sevilla Este Sevilla Este 30 49 47 45
7 CD Puerto Malagueño Sub 19 Puerto 30 47 44 44
8 Séneca CF Sub 19 Séneca 30 47 46 43
9 Almería Sub 19 Almería 30 50 48 42
10 Coria CF Sub 19 Coria 30 55 67 37
11 Córdoba CF Sub 19 Córdoba 30 53 50 36
12 CD Vázquez Cultural Sub 19 Vázquez 30 43 54 35
13 CD Santa Fe Sub 19 Santa 30 35 48 35
14 Cádiz Sub 19 Cádiz 30 32 53 35
15 Gimnástica Ceuta Sub 19 Gimnástica 30 31 89 21
16 Dos Hermanas SA Sub 19 Hermanas 30 42 76 18
TEMPORADA 2010/2011
DIVISIÓN DE HONOR GRUPO 4
Equipo PJ GF GC Puntos
1 Sevilla Sub 19 Sevilla 30 81 39 61
2 Córdoba CF Sub 19 Córdoba 30 62 33 61
3 Málaga Sub 19 Málaga 30 60 36 55
4 Real Betis Sub 19 Real Betis 30 50 29 53
5 Almería Sub 19 Almería 30 51 31 49
6 Coria CF Sub 19 Coria 30 35 33 48
7 Cádiz Sub 19 Cádiz 30 43 37 47
8 Dos Hermanas SA Sub 19 Hermanas 30 45 52 43
9 Recreativo Sub 19 Recreativo 30 36 36 42
10 Gimnástica Ceuta Sub 19 Gimnástica 30 47 48 42
11 CD Puerto Malagueño Sub 19 Puerto 30 46 45 40
12 CD Santa Fe Sub 19 Santa 30 49 50 40
13 Xerez CD Xerez CD 30 56 64 36
14 CD Siempre Alegres Sub 19 Siempre 30 33 72 27
15 Real Jaén Sub 19 Real Jaén 30 20 60 19
16 Cp Ejido Juvenil Ejido 30 36 85 15

  USO DE MEMORIA  
7,342,336 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6413
Total Execution Time  0.6425
  CADENA URL  
/historico/Sevilla-Fc-Juvenil
  GET DATOS  
$_GET['/historico/Sevilla-Fc-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (46)  
0.0123  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 = 'Sevilla-Fc-Juvenil' 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.0106  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=4883 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=4883 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=4883 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107  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=4883 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0109  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=4883 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0111  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=4883 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0112  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=4883 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0152  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 = 75469
0.0109  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4883 AND type_rel = 2
0.0121  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 4883 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0118  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (61999,66193,66834,67892,95904) ORDER BY n.cover_points DESC, update_date DESC
0.0139  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 = '4883' ORDER BY l.year DESC,cat.coefficient DESC
0.0138  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 = '4883' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0143  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 = '4883' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0118  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 = 73244 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0113  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 = 73969 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0136  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=4883 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0116  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 (75470,74910,74025,73244) 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.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 73244 AND teamId = 4883
0.0123  SELECT count(id) as num_players from rel_players WHERE league_id = 74025 AND teamId = 4883
0.0115  SELECT count(id) as num_players from rel_players WHERE league_id = 74910 AND teamId = 4883
0.0106  SELECT count(id) as num_players from rel_players WHERE league_id = 75470 AND teamId = 4883
0.0112  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 = 73244 AND t.round = 33 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0108  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 = '4883' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0106  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '4883' and rp.type = 4
0.0107  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 = '4883' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0164  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 = 73244 WHERE rp.league_id = 73244 AND rp.teamId = 4883 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.0159  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 = 73244 WHERE rp.league_id = 73244 AND rp.teamId = 4883 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 = 73244 WHERE rp.league_id = 73244 AND rp.teamId = 4883 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0111  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 = 4883 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0112  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 = 68516 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.0112  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 = 63683 AND t.round = 42 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 58881 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.0108  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 = 61972 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 50494 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.0114  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 = 44578 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 39179 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 34121 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 16591 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 4202 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 2712 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 2069 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 1489 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 1163 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 73244 ORDER BY nameShow LIMIT 100