4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Atletico La Union
TEMPORADA 2022/2023
PREFERENTE BALEARES ALEVÍN GRUPO 1
Equipo PJ GF GC Puntos
1 Es Pla Es Pla 28 128 35 70
2 Balears A Balears A 28 123 40 67
3 CD Son Cladera A Cladera 28 117 43 66
4 Atº San Cayetano DSC Atº 28 107 59 56
5 Atlético Rafal Atlético 28 115 79 52
6 UD Pla de Na Tesa Tesa 28 104 77 49
7 CF Soller CF Soller 28 63 63 45
8 Espanya Espanya 28 98 81 43
9 Platges de Calvia Platges 28 66 76 34
10 Santanyi Santanyi 28 70 78 32
11 Atletico La Union Atletico 28 61 113 31
12 Penya Esp Sarenal Penya 28 69 92 27
13 Constancia B Constancia 28 64 108 20
14 Recreativo Penya Arrabal Recreativo 28 52 169 10
15 Sp. Sant Marcal Sant Marcal 28 45 169 7
TEMPORADA 2021/2022
1ª BALEARES ALEVÍN GRUPO 1
Equipo PJ GF GC Puntos
1 Sp. Sant Marcal Sant Marcal 37 152 46 98
2 AD Son Sardina A Sardina 37 156 39 90
3 Recreativo La Victoria Recreativo 37 155 60 87
4 AD Santa Catalina A Santa 36 136 61 78
5 La Salle B La Salle B 37 153 70 77
6 SP AT Ciutat de Palma A Ciutat Palma 36 102 66 70
7 Recreativo Penya Arrabal Recreativo 36 127 78 67
8 Son Cladera Atº Del SC A Cladera Atº 37 118 104 67
9 Atletico La Union Atletico 36 125 78 65
10 Atlético Son Caliu B Atlético 37 131 85 65
11 Atlético Rafal A Atlético 37 80 70 54
12 San Francisco Dsfat Francisco 36 101 119 44
13 Balears B Balears B 37 98 135 39
14 CD Calvia CD Calvia 37 64 114 35
15 CE Campusesport Campusesport 37 80 167 31
16 Racing Club Andratx del A Racing Club 37 70 155 25
17 CD San Cayetano B Cayetano 37 75 142 23
18 Estudiantes Del PS A Estudiantes 37 61 159 20
19 Atº Calvia A Atº Calvia 37 54 169 15
20 UD Pla de Na Tesa Tesa 36 44 165 13
TEMPORADA 2015/2016
1ª BALEARES ALEVÍN GRUPO 1
Equipo PJ GF GC Puntos
1 La Salle Atlético Salle 30 175 31 81
2 CD Madre Alberta A Madre 30 175 41 78
3 Santa Catalina Atlético B Santa 30 183 88 62
4 Sant Marcal B Sant Marcal 30 167 93 60
5 Patronato A Patronato A 30 90 69 54
6 Recreativo Penya Arrabal A Recreativo 30 113 87 50
7 Arenal B Arenal B 30 118 81 49
8 Genova A Genova A 30 94 89 45
9 Porto Cristo FC Porto Cristo 30 114 105 43
10 CD Calvia CD Calvia 30 105 153 34
11 CD Atlético Manacor Atlético 30 78 99 33
12 Murense Murense 30 83 151 32
13 Atletico La Union Atletico 30 77 139 31
14 CE Montaura A Montaura 30 71 105 24
15 CE Andratx A Andratx 30 47 220 9
16 CD Son Cladera A Cladera 30 69 208 8
TEMPORADA 2014/2015
1ª BALEARES ALEVÍN GRUPO 1
Equipo PJ GF GC Puntos
1 Joventud Mallorca A Joventud 30 154 41 74
2 Balears A Balears A 30 169 58 74
3 CD Olimpic A Olimpic 30 151 54 72
4 Pollença I Port FC Pollença 30 161 57 68
5 Patronato A Patronato A 30 113 47 61
6 Genova A Genova A 30 103 58 57
7 Atletico Son Caliu A Atletico 30 113 106 43
8 Porto Cristo FC Porto Cristo 30 90 100 43
9 Atletico La Union Atletico 30 127 103 40
10 Cardassar A Cardassar A 30 96 97 40
11 Bunyola Club de Futbol A Bunyola Club 30 63 97 37
12 Es Pla A Es Pla A 30 83 116 34
13 CD San Francisco Atletico Francisco 30 60 114 26
14 San Pedro Atletico Pedro 30 61 172 14
15 CD Viva Sports Viva Sports 30 43 199 7
16 Atletico Escolar Atletico 30 29 197 4

  USO DE MEMORIA  
4,990,600 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.3799
Total Execution Time  0.3812
  CADENA URL  
/historico/At-La-Union-Alevin
  GET DATOS  
$_GET['/historico/At-La-Union-Alevin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0292  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 = 69195
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=35387 AND type_rel = 2
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=980 AND type_rel = 3
0.0146  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 = '35387' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147  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 = 69195 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146  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=35387 AND l.year in (2022,2023,2024) 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 (69195,65367) 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.0145  SELECT count(id) as num_players from rel_players_base WHERE league_id = 69195 AND teamId = 35387
0.0145  SELECT count(id) as num_players from rel_players_base WHERE league_id = 65367 AND teamId = 35387
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 `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 = 69195 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0145  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 = '35387' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0147  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 = '35387' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0147  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 = 35387 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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_base` 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 = 69195 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.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 `tables2022_base` 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 = 65367 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.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 `tables2016_base` 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 = 17983 AND t.round = 30 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 `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 = 6468 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC