4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CE Xilvar
TEMPORADA 2022/2023
PREFERENTE BALEARES GRUPO 2
Equipo PJ GF GC Puntos
1 UE Alcudia UE Alcudia 30 76 25 69
2 Cardassar Cardassar 30 73 31 69
3 Algaida Algaida 30 66 28 59
4 CD Son Cladera Cladera 30 48 33 48
5 UD Alaró UD Alaró 30 43 40 41
6 Serverense Serverense 30 34 35 41
7 Atletico Rafal Atletico 30 43 44 40
8 CE Xilvar CE Xilvar 30 33 48 39
9 Son Veri Son Veri 30 32 55 37
10 Campos Campos 30 58 57 35
11 Recreativo La Victoria Recreativo 30 38 56 35
12 Indep. Camp Redó Indep. Camp 30 50 54 34
13 S´Horta S´Horta 30 43 53 34
14 Calvia Calvia 30 43 50 34
15 Son Sardina Son Sardina 30 41 63 26
16 Alqueria Alqueria 30 23 72 17
TEMPORADA 2021/2022
PREFERENTE BALEARES GRUPO 1
Equipo PJ GF GC Puntos
1 Inter Manacor Inter 38 66 36 75
2 CD Sant Jordi Sant Jordi 38 71 39 71
3 Porreres Porreres 38 70 40 70
4 Cardassar Cardassar 38 55 32 69
5 Sineu Sineu 38 66 39 68
6 Recreativo La Victoria Recreativo 38 56 45 63
7 Ferriolense Ferriolense 38 45 42 63
8 UE Alcudia UE Alcudia 38 64 40 62
9 CD Génova CD Génova 38 60 43 61
10 CE Xilvar CE Xilvar 38 51 47 60
11 Santa Catalina Atlético Santa 38 52 41 53
12 UD Alaró UD Alaró 38 64 47 51
13 CD Son Cladera Cladera 38 42 43 48
14 UE Petra UE Petra 38 51 60 45
15 Calvia Calvia 38 49 63 42
16 Arta Arta 37 52 80 38
17 Alqueria Alqueria 37 38 70 35
18 Pla de Na Tesa Tesa 38 52 90 30
19 Son Sardina Son Sardina 38 47 95 26
20 Esporles Esporles 38 37 96 19
TEMPORADA 2020/2021
PREFERENTE BALEARES GRUPO 2
Equipo PJ GF GC Puntos
1 Rotlet Molinar Rotlet 18 25 9 38
2 Murense Murense 18 25 11 37
3 Sineu Sineu 18 36 21 29
4 Serverense Serverense 18 30 23 29
5 UD Alaró UD Alaró 18 23 29 22
6 Alqueria Alqueria 18 20 28 22
7 CE Xilvar CE Xilvar 18 26 26 21
8 Cala Millor Cala Millor 18 18 33 20
9 Atletico Rafal Atletico 18 19 25 18
10 La Unión CF Unión 18 18 35 13
TEMPORADA 2019/2020
PREFERENTE BALEARES GRUPO 1
Equipo PJ GF GC Puntos
1 Cardassar Cardassar 28 56 17 64
2 Campos Campos 28 48 27 50
3 CD Génova CD Génova 28 65 47 45
4 Serverense Serverense 28 47 37 42
5 Rotlet Molinar Rotlet 28 39 33 41
6 CD Sant Jordi Sant Jordi 28 42 40 41
7 UD Alaró UD Alaró 28 36 37 41
8 Porreres Porreres 28 41 32 40
9 Atletico Rafal Atletico 28 43 39 40
10 Inter Manacor Inter 28 36 40 40
11 Sineu Sineu 28 47 46 39
12 Son Veri Son Veri 28 40 41 39
13 Murense Murense 28 42 35 37
14 CD Son Cladera Cladera 28 37 35 34
15 Cala Millor Cala Millor 28 47 55 33
16 UEF Santa María Santa María 28 34 48 33
17 CE Xilvar CE Xilvar 28 37 59 32
18 UE Petra UE Petra 28 34 49 27
19 La Unión CF Unión 28 29 47 24
20 A-Llubi A-Llubi 28 24 60 19
TEMPORADA 2018/2019
PREFERENTE BALEARES GRUPO 1
Equipo PJ GF GC Puntos
1 Andratx Andratx 38 89 30 86
2 UD Collerense Collerense 38 74 34 77
3 Rotlet Molinar Rotlet 38 67 37 74
4 Campos Campos 38 57 41 58
5 Sineu Sineu 38 63 63 58
6 Atletico Rafal Atletico 38 70 61 57
7 Son Veri Son Veri 38 61 57 57
8 UD Alaró UD Alaró 38 57 54 57
9 Cala Millor Cala Millor 38 63 61 55
10 Inter Manacor Inter 38 45 47 50
11 UE Petra UE Petra 38 51 53 49
12 A-Llubi A-Llubi 38 58 67 48
13 CD Génova CD Génova 38 68 83 48
14 CE Xilvar CE Xilvar 38 52 59 45
15 La Unión CF Unión 38 57 71 44
16 Recreativo La Victoria Recreativo 38 59 68 43
17 CD Sant Jordi Sant Jordi 38 52 68 42
18 Serverense Serverense 38 62 71 41
19 Port de Soller Port Soller 38 35 71 32
20 Son Sardina Son Sardina 38 48 92 29
TEMPORADA 2017/2018
PREFERENTE BALEARES GRUPO 1
Equipo PJ GF GC Puntos
1 Soller Soller 38 86 32 79
2 Murense Murense 38 66 43 72
3 CD Sant Jordi Sant Jordi 38 63 44 68
4 Andratx Andratx 38 79 54 64
5 Rotlet Molinar Rotlet 38 68 45 62
6 La Unión CF Unión 38 64 49 61
7 Port de Soller Port Soller 38 51 50 60
8 Recreativo La Victoria Recreativo 38 58 48 59
9 Atletico Rafal Atletico 38 47 35 59
10 Inter Manacor Inter 38 55 53 52
11 Sineu Sineu 38 55 49 52
12 CE Xilvar CE Xilvar 38 52 55 52
13 CD Génova CD Génova 38 66 64 51
14 UD Alaró UD Alaró 38 46 48 50
15 A-Llubi A-Llubi 38 44 51 47
16 Son Veri Son Veri 38 62 65 47
17 Campos Campos 38 32 39 47
18 Indep. Camp Redó Indep. Camp 38 37 85 23
19 Cardassar Cardassar 38 38 98 23
20 Llosetense C Llosetense 38 42 104 21
TEMPORADA 2016/2017
PREFERENTE BALEARES GRUPO 1
Equipo PJ GF GC Puntos
1 Manacor Manacor 38 70 27 77
2 UE Petra UE Petra 38 60 40 67
3 La Unión CF Unión 38 59 40 66
4 Santanyi Santanyi 38 48 37 64
5 CE Xilvar CE Xilvar 38 58 44 62
6 Serverense Serverense 38 62 47 59
7 Sineu Sineu 38 56 49 56
8 A-Llubi A-Llubi 38 47 43 54
9 Recreativo La Victoria Recreativo 38 48 52 52
10 Atletico Rafal Atletico 38 45 39 52
11 Murense Murense 38 51 64 51
12 Cardassar Cardassar 38 45 51 48
13 Port de Soller Port Soller 38 47 47 46
14 CD Génova CD Génova 38 65 78 44
15 UD Alaró UD Alaró 38 40 58 43
16 Andratx Andratx 38 48 47 43
17 Soller Soller 38 44 63 43
18 Indep. Camp Redó Indep. Camp 38 45 80 42
19 Platges de Calvià B Platges 38 39 55 40
20 Ce Campanet Ce Campanet 38 48 64 39
TEMPORADA 2015/2016
1ª REGIONAL BALEARES
Equipo PJ GF GC Puntos
1 Indep. Camp Redó Indep. Camp 36 97 46 83
2 CE Xilvar CE Xilvar 38 80 54 76
3 Son Sardina Son Sardina 38 76 52 71
4 CD Sant Jordi Sant Jordi 38 58 35 71
5 Juventud UDSO Juventud 37 82 51 65
6 Sporting Sant Marçal Sporting 38 81 61 65
7 Inter Manacor Inter 38 74 57 64
8 CD Binissalem B Binissalem 38 51 55 58
9 Pla de Na Tesa Tesa 38 80 76 54
10 Pilares La Soledad Pilares 36 81 83 49
11 Santa Ponsa Santa Ponsa 37 63 61 49
12 Valldemossa Atl Valldemossa 38 63 71 46
13 S´Horta S´Horta 38 65 66 45
14 Cala Millor Cala Millor 38 72 93 43
15 CE Escolar CE Escolar 38 46 59 42
16 Consell Consell 38 43 57 41
17 Llosetense C Llosetense 38 53 69 41
18 UE Lloret UE Lloret 38 53 78 38
19 Arta Arta 38 47 97 35
20 Pina Pina 38 56 100 32
TEMPORADA 2014/2015
1ª REGIONAL BALEARES
Equipo PJ GF GC Puntos
1 Sineu Sineu 38 74 39 73
2 UD Arenal UD Arenal 38 77 45 73
3 A-Llubi A-Llubi 38 61 37 73
4 Inter Manacor Inter 38 80 54 72
5 Soledad Soledad 38 78 55 67
6 CE Xilvar CE Xilvar 38 74 40 66
7 Pilares La Soledad Pilares 38 80 80 63
8 UE Lloret UE Lloret 38 67 57 60
9 Santa Ponsa Santa Ponsa 38 58 51 55
10 CD Binissalem B Binissalem 38 64 55 54
11 Consell Consell 38 55 57 51
12 Pla de Na Tesa Tesa 38 60 69 50
13 Juventud UDSO Juventud 38 50 55 46
14 Sporting Sant Marçal Sporting 38 60 79 46
15 Arta Arta 38 57 71 45
16 Pina Pina 38 54 64 44
17 CD Sant Jordi Sant Jordi 38 62 76 42
18 Son Ferrer Son Ferrer 38 55 73 36
19 CF Pollença Pollença 38 62 107 28
20 Algaida Algaida 38 28 92 16
TEMPORADA 2012/2013
PREFERENTE BALEARES GRUPO 1
Equipo PJ GF GC Puntos
1 Rotlet Molinar Rotlet 38 74 45 71
2 Cf Platges De Calvià Platges 38 65 30 68
3 Atletico Rafal Atletico 38 71 55 68
4 Santa Catalina Atlético Santa 38 63 46 61
5 Scd Independiente Independient 38 59 57 60
6 Cd Génova Cd Génova 38 60 46 58
7 Cd Serverense Serverense 38 67 58 55
8 La Unión CF Unión 38 63 53 53
9 Cd S´horta Cd S´horta 38 53 68 52
10 UD Alaró UD Alaró 38 54 63 51
11 Ce Campanet Ce Campanet 38 57 62 50
12 UD Arenal UD Arenal 38 57 58 49
13 CE Escolar CE Escolar 38 49 49 48
14 Cd Murense Cd Murense 38 58 72 48
15 Cd Cardassar Cardassar 38 52 66 48
16 Ce Esporles Ce Esporles 38 67 66 47
17 Ud Pla De Na Tesa Tesa 38 65 79 44
18 CE Xilvar CE Xilvar 38 43 61 43
19 Sporting Sant Marçal Sporting 38 57 78 38
20 CF Pollença Pollença 38 42 64 35

  USO DE MEMORIA  
6,277,696 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7172
Total Execution Time  0.7184
  CADENA URL  
/historico/Ce-Xilvar-Senior
  GET DATOS  
$_GET['/historico/Ce-Xilvar-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (45)  
0.0145  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 = 'Ce-Xilvar-Senior' 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.0185  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 = 'Ce-Xilvar-Senior' 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.0125  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=9607 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=9607 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=9607 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=9607 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=9607 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  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=9607 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=9607 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=9607 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=9607 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=9607 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=9607 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  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=9607 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 = 68764
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9607 AND type_rel = 2
0.0127  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=79 AND type_rel = 3
0.0129  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 79 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0131  SELECT /*53 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 (1105676,1105343,1104898,676494,412502) ORDER BY n.cover_points DESC, update_date DESC
0.0130  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 = '9607' ORDER BY l.year DESC,cat.coefficient DESC
0.0129  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 = '9607' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '9607' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  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 = '9607' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = 68764 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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=9607 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0125  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 (68764) 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.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 68764 AND teamId = 9607
0.0132  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 68764 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0129  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 = '9607' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '9607' and rp.type = 4
0.0131  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 = '9607' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0178  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 events2023 e ON e.player_id = p.id AND e.league_id = 68764 WHERE rp.league_id = 68764 AND rp.teamId = 9607 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.0171  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 events2023 e ON e.player_id = p.id AND e.league_id = 68764 WHERE rp.league_id = 68764 AND rp.teamId = 9607 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0169  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 events2023 e ON e.player_id = p.id AND e.league_id = 68764 WHERE rp.league_id = 68764 AND rp.teamId = 9607 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0143  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 = 9607 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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,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 = 68764 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.0137  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 = 63634 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  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 = 58942 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.0137  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 = 51180 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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 = 44632 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140  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 = 39183 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138  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 = 33976 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 16792 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157  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 = 3982 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140  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 = 1993 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC