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

Mallorca Sub 19

Entrenador: Carlos Muñoz

Temporada 2023/2024
TEMPORADA 2023/2024
DIVISIÓN DE HONOR GRUPO 3
Equipo PJ GF GC Puntos
1 Mallorca Sub 19 Mallorca 30 59 19 67
2 Espanyol Sub 19 Espanyol 30 52 19 63
3 Barcelona Sub 19 Barcelona 30 48 32 56
4 Badalona Sub 19 Badalona 30 50 36 51
5 Zaragoza Sub 19 Zaragoza 30 41 25 51
6 CF Damm Sub 19 Damm 30 42 35 43
7 Huesca Sub 19 Huesca 30 42 45 41
8 Mercantil Sub 19 Mercantil 30 33 42 38
9 Girona FC Sub 19 Girona 30 36 40 37
10 San Francisco Sub 19 Francisco 30 44 48 36
11 Cornellà Sub 19 Cornellà 30 34 38 35
12 Racing Club Zaragoza Sub 19 Racing Club 30 30 38 34
13 Sabadell Sub 19 Sabadell 30 41 47 34
14 CE Constància Sub 19 Constància 30 28 55 25
15 Escola Gava Sub 19 Escola Gava 30 39 61 24
16 Platges de Calvia Sub 19 Platges 30 24 63 18
TEMPORADA 2022/2023
DIVISIÓN DE HONOR GRUPO 3
Equipo PJ GF GC Puntos
1 Barcelona Sub 19 Barcelona 30 65 28 67
2 Zaragoza Sub 19 Zaragoza 30 60 29 61
3 Mallorca Sub 19 Mallorca 30 54 27 55
4 CF Damm Sub 19 Damm 30 45 24 55
5 Girona FC Sub 19 Girona 30 45 34 52
6 San Francisco Sub 19 Francisco 30 38 33 50
7 Espanyol Sub 19 Espanyol 30 51 36 47
8 Badalona Sub 19 Badalona 30 47 42 40
9 Cornellà Sub 19 Cornellà 30 41 31 40
10 Sabadell Sub 19 Sabadell 30 41 49 33
11 Huesca Sub 19 Huesca 30 28 42 31
12 CE Constància Sub 19 Constància 30 27 48 31
13 CE Europa Sub 19 Europa 30 44 59 30
14 Gimnàstic Sub 19 Gimnàstic 30 30 64 27
15 FE Grama Sub 19 Grama 30 34 60 23
16 CD Ebro Sub 19 Ebro 30 22 66 16
TEMPORADA 2021/2022
DIVISIÓN DE HONOR GRUPO 3
Equipo PJ GF GC Puntos
1 Barcelona Sub 19 Barcelona 34 103 23 85
2 Espanyol Sub 19 Espanyol 34 69 21 73
3 CF Damm Sub 19 Damm 34 60 27 71
4 Zaragoza Sub 19 Zaragoza 34 49 31 63
5 Sabadell Sub 19 Sabadell 34 47 42 56
6 Cornellà Sub 19 Cornellà 34 58 35 51
7 Mallorca Sub 19 Mallorca 34 44 41 51
8 CE Europa Sub 19 Europa 34 38 36 51
9 Girona FC Sub 19 Girona 34 50 34 48
10 CD Ebro Sub 19 Ebro 34 33 34 47
11 Gimnàstic Sub 19 Gimnàstic 34 46 59 44
12 San Francisco Sub 19 Francisco 34 38 50 41
13 UD Bellvitge Sub 19 Bellvitge 34 50 54 39
14 Atlético Baleares Sub 19 Atlético 34 27 47 37
15 Sant Andreu Sub 19 Sant Andreu 34 54 59 37
16 UD Montecarlo Sub 19 Montecarlo 34 33 74 26
17 Cerdanyola Sub 19 Cerdanyola 34 27 86 17
18 Lleida Esportiu Sub 19 Lleida 34 22 95 15
TEMPORADA 2020/2021
DIVISIÓN DE HONOR GRUPO 20
Equipo PJ GF GC Puntos
1 Mallorca Sub 19 Mallorca 23 37 37 33
2 San Francisco Sub 19 Francisco 23 27 26 32
3 Lleida Esportiu Sub 19 Lleida 23 33 28 31
4 Cornellà Sub 19 Cornellà 23 33 29 30
5 Huesca Sub 19 Huesca 23 20 24 30
6 Penya Arrabal Sub 19 Penya 23 34 46 26
7 Jabac I Terrassa Sub 19 Jabac 23 31 33 25
8 Stadium Casablanca Sub 19 Stadium 23 27 46 23
9 El Olivar Sub 19 Olivar 23 22 40 17
10 At. Villacarlos Sub 19 Villacarlos 23 14 79 8
TEMPORADA 2019/2020
DIVISIÓN DE HONOR GRUPO 3
Equipo PJ GF GC Puntos
1 Barcelona Sub 19 Barcelona 25 82 13 63
2 Zaragoza Sub 19 Zaragoza 25 55 22 61
3 Espanyol Sub 19 Espanyol 24 77 23 57
4 CE Europa Sub 19 Europa 25 28 18 42
5 Mallorca Sub 19 Mallorca 25 41 34 41
6 Cornellà Sub 19 Cornellà 25 34 24 39
7 CF Damm Sub 19 Damm 25 52 40 38
8 Girona FC Sub 19 Girona 25 45 38 36
9 Gimnàstic Sub 19 Gimnàstic 25 32 23 34
10 Stadium Casablanca Sub 19 Stadium 25 35 51 27
11 San Francisco Sub 19 Francisco 25 31 50 24
12 Huesca Sub 19 Huesca 25 17 39 24
13 CD Ebro Sub 19 Ebro 25 28 55 23
14 At. Villacarlos Sub 19 Villacarlos 25 23 68 20
15 Lleida Esportiu Sub 19 Lleida 24 19 65 14
16 Jabac I Terrassa Sub 19 Jabac 25 17 53 11
TEMPORADA 2018/2019
DIVISIÓN DE HONOR GRUPO 3
Equipo PJ GF GC Puntos
TEMPORADA 2017/2018
DIVISIÓN DE HONOR GRUPO 3
Equipo PJ GF GC Puntos
1 Barcelona Sub 19 Barcelona 30 74 18 72
2 Zaragoza Sub 19 Zaragoza 30 66 28 66
3 Mallorca Sub 19 Mallorca 30 59 29 63
4 Girona FC Sub 19 Girona 30 59 35 59
5 Espanyol Sub 19 Espanyol 30 62 26 54
6 El Olivar Sub 19 Olivar 30 32 32 50
7 Cornellà Sub 19 Cornellà 30 34 27 46
8 San Francisco Sub 19 Francisco 30 34 33 41
9 CD Manacor Sub 19 Manacor 29 32 35 37
10 Gimnástic Manresa Sub 19 Gimnástic 30 25 38 35
11 Gimnàstic Sub 19 Gimnàstic 30 29 42 34
12 Lleida Esportiu Sub 19 Lleida 29 31 56 30
13 Sant Andreu Sub 19 Sant Andreu 30 31 55 27
14 CF Damm Sub 19 Damm 30 36 60 22
15 UD Bellvitge Sub 19 Bellvitge 30 24 50 18
16 Peña Deportiva Sub 19 Peña 30 17 81 14
TEMPORADA 2016/2017
DIVISIÓN DE HONOR GRUPO 3
Equipo PJ GF GC Puntos
1 Barcelona Sub 19 Barcelona 30 72 22 71
2 Mallorca Sub 19 Mallorca 30 59 17 64
3 Espanyol Sub 19 Espanyol 30 54 24 60
4 Cornellà Sub 19 Cornellà 30 40 29 53
5 CF Damm Sub 19 Damm 30 45 30 53
6 Zaragoza Sub 19 Zaragoza 30 40 37 46
7 San Francisco Sub 19 Francisco 30 29 19 44
8 Girona FC Sub 19 Girona 30 28 28 44
9 CD Manacor Sub 19 Manacor 30 23 40 34
10 UD Bellvitge Sub 19 Bellvitge 30 26 32 34
11 Gimnàstic Sub 19 Gimnàstic 30 36 49 34
12 Sant Andreu Sub 19 Sant Andreu 30 32 34 31
13 CD Ferriolense Sub 19 Ferriolense 30 30 49 30
14 Atlético Baleares Sub 19 Atlético 30 29 49 29
15 Santo D. Juventud Sub 19 Santo 30 31 63 23
16 Sabadell Sub 19 Sabadell 30 27 79 12
TEMPORADA 2015/2016
DIVISIÓN DE HONOR GRUPO 3
Equipo PJ GF GC Puntos
1 Espanyol Sub 19 Espanyol 30 70 24 77
2 Mallorca Sub 19 Mallorca 30 72 25 68
3 CF Damm Sub 19 Damm 30 65 23 66
4 Barcelona Sub 19 Barcelona 30 68 30 58
5 Zaragoza Sub 19 Zaragoza 30 49 38 49
6 Gimnàstic Sub 19 Gimnàstic 30 54 49 43
7 Sant Andreu Sub 19 Sant Andreu 30 39 45 41
8 San Francisco Sub 19 Francisco 30 32 36 40
9 Cornellà Sub 19 Cornellà 30 40 46 37
10 CD Manacor Sub 19 Manacor 30 25 48 34
11 Girona FC Sub 19 Girona 30 39 53 33
12 Atlético Baleares Sub 19 Atlético 30 32 51 33
13 Lleida Esportiu Sub 19 Lleida 30 34 52 29
14 CD Ebro Sub 19 Ebro 30 29 62 25
15 SD La Salle Sub 19 Salle 30 23 51 22
16 Stadium Casablanca Sub 19 Stadium 30 19 57 14
TEMPORADA 2014/2015
DIVISIÓN DE HONOR GRUPO 3
Equipo PJ GF GC Puntos
1 Espanyol Sub 19 Espanyol 30 66 10 74
2 CF Damm Sub 19 Damm 30 52 16 64
3 Mallorca Sub 19 Mallorca 30 53 16 59
4 Barcelona Sub 19 Barcelona 30 49 25 56
5 CD Manacor Sub 19 Manacor 30 43 37 47
6 Cornellà Sub 19 Cornellà 30 38 36 45
7 Gimnàstic Sub 19 Gimnàstic 30 33 31 45
8 Zaragoza Sub 19 Zaragoza 30 43 40 39
9 Atlético Baleares Sub 19 Atlético 30 31 36 37
10 San Francisco Sub 19 Francisco 30 38 46 37
11 Stadium Casablanca Sub 19 Stadium 30 33 52 34
12 Lleida Esportiu Sub 19 Lleida 30 30 45 32
13 Badalona Sub 19 Badalona 30 35 49 30
14 Jabac I Terrassa Sub 19 Jabac 30 34 52 24
15 Mercantil Juvenil Mercantil 30 32 74 18
16 Huesca Sub 19 Huesca 30 19 64 18
TEMPORADA 2013/2014
DIVISIÓN DE HONOR GRUPO 3
Equipo PJ GF GC Puntos
1 Barcelona Sub 19 Barcelona 30 83 23 72
2 Espanyol Sub 19 Espanyol 30 76 36 62
3 Mallorca Sub 19 Mallorca 30 64 42 57
4 CF Damm Sub 19 Damm 30 53 39 53
5 Badalona Sub 19 Badalona 30 48 39 52
6 Jabac I Terrassa Sub 19 Jabac 29 39 33 48
7 CD Roda Sub 19 Roda 30 48 48 47
8 Cornellà Sub 19 Cornellà 30 55 44 45
9 Gimnàstic Sub 19 Gimnàstic 29 38 40 39
10 Zaragoza Sub 19 Zaragoza 30 38 50 37
11 San Francisco Sub 19 Francisco 30 40 47 35
12 Atlético Baleares Sub 19 Atlético 30 46 56 35
13 Sant Andreu Sub 19 Sant Andreu 30 31 44 33
14 CE Europa Sub 19 Europa 30 35 81 29
15 Girona FC Sub 19 Girona 30 24 49 16
16 CD Menorca Sub 19 Menorca 30 25 72 12
TEMPORADA 2012/2013
DIVISIÓN DE HONOR GRUPO 3
Equipo PJ GF GC Puntos
1 Barcelona Sub 19 Barcelona 30 93 18 81
2 Mallorca Sub 19 Mallorca 30 71 36 59
3 Espanyol Sub 19 Espanyol 30 64 34 59
4 Zaragoza Sub 19 Zaragoza 30 64 37 53
5 Girona FC Sub 19 Girona 30 58 43 51
6 Gimnàstic Sub 19 Gimnàstic 30 57 51 49
7 Badalona Sub 19 Badalona 30 49 40 48
8 CF Damm Sub 19 Damm 30 51 47 46
9 Cornellà Sub 19 Cornellà 30 54 42 45
10 Sant Andreu Sub 19 Sant Andreu 30 50 47 43
11 CD Menorca Sub 19 Menorca 30 49 70 31
12 San Francisco Sub 19 Francisco 30 36 56 29
13 Stadium Casablanca Sub 19 Stadium 30 38 79 26
14 Gavà Sub 19 Gavà 30 40 71 22
15 Mataró CE Sub 19 Mataró 30 25 73 21
16 Aec Manlleu Juvenil Manlleu 30 29 84 13
TEMPORADA 2011/2012
DIVISIÓN DE HONOR GRUPO 3
Equipo PJ GF GC Puntos
1 Espanyol Sub 19 Espanyol 30 72 16 77
2 Barcelona Sub 19 Barcelona 30 78 22 76
3 Girona FC Sub 19 Girona 30 44 34 53
4 Zaragoza Sub 19 Zaragoza 30 61 59 48
5 Cornellà Sub 19 Cornellà 30 52 40 47
6 Gimnàstic Sub 19 Gimnàstic 30 39 32 45
7 Mallorca Sub 19 Mallorca 30 38 27 43
8 San Francisco Sub 19 Francisco 30 48 43 38
9 Badalona Sub 19 Badalona 30 43 40 37
10 Mataró CE Sub 19 Mataró 30 45 49 37
11 CF Damm Sub 19 Damm 30 35 51 34
12 Huesca Sub 19 Huesca 30 26 45 31
13 Aec Manlleu Juvenil Manlleu 30 35 59 31
14 Lleida Esportiu Sub 19 Lleida 30 30 52 30
15 CIDE Palma CIDE Palma 29 27 56 26
16 Reus Deportiu Sub 19 Reus 29 30 78 17
TEMPORADA 2010/2011
DIVISIÓN DE HONOR GRUPO 3
Equipo PJ GF GC Puntos
1 Barcelona Sub 19 Barcelona 30 83 22 71
2 Espanyol Sub 19 Espanyol 30 75 22 71
3 Mallorca Sub 19 Mallorca 30 66 28 64
4 CF Damm Sub 19 Damm 30 56 36 53
5 Cornellà Sub 19 Cornellà 30 59 38 51
6 Lleida Esportiu Sub 19 Lleida 30 46 39 45
7 Badalona Sub 19 Badalona 30 49 41 41
8 Gimnàstic Sub 19 Gimnàstic 30 33 48 36
9 Huesca Sub 19 Huesca 30 35 63 34
10 Girona FC Sub 19 Girona 30 36 49 33
11 San Francisco Sub 19 Francisco 30 26 39 33
12 Juventut Sallista Juvenil Juventut 30 36 58 32
13 Aec Manlleu Juvenil Manlleu 30 50 76 32
14 L'Hospitalet Sub 19 L'Hospitalet 30 39 56 29
15 UDA Gramenet Milán Juvenil Gramenet 30 35 69 23
16 Ud Poblense Ud Poblense 30 33 73 18

  USO DE MEMORIA  
6,711,248 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1555
Total Execution Time  0.1567
  CADENA URL  
/historico/Rcd-Mallorca-Juvenil
  GET DATOS  
$_GET['/historico/Rcd-Mallorca-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0031  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 = 'Rcd-Mallorca-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.0019  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=4854 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=4854 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=4854 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=4854 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=4854 AND type_rel = 2
0.0026  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 4854 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0019  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 (72501) ORDER BY n.cover_points DESC, update_date DESC
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 = '4854' ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '4854' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '4854' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 73242 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=4854 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (75947,74910,73242) 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 = 73242 AND teamId = 4854
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 75947 AND teamId = 4854
0.0035  SELECT count(id) as num_players from rel_players WHERE league_id = 74910 AND teamId = 4854
0.0039  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 = 73242 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0034  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 = '4854' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0022  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '4854' and rp.type = 4
0.0031  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 = '4854' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0086  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 = 73242 WHERE rp.league_id = 73242 AND rp.teamId = 4854 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.0086  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 = 73242 WHERE rp.league_id = 73242 AND rp.teamId = 4854 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0052  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 = 73242 WHERE rp.league_id = 73242 AND rp.teamId = 4854 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0039  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 = 4854 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0033  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 = 68515 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.0032  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 = 63682 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.0027  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 = 58842 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.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 `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 = 61971 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.0029  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 = 50493 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.0019  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 = 44577 AND t.round = 30 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 = 39178 AND t.round = 30 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 `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 = 34120 AND t.round = 30 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 `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 = 16590 AND t.round = 30 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 = 4200 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 2711 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 = 2068 AND t.round = 30 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 = 1492 AND t.round = 30 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 `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 = 1167 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 73242 ORDER BY nameShow LIMIT 100