4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CD Utrera Sub 19
TEMPORADA 2023/2024
2ª ANDALUZA SEVILLA JUVENIL
Equipo PJ GF GC Puntos
1 CD Mosquito Sub 19 Mosquito 26 57 17 63
2 CD Utrera Sub 19 Utrera 26 64 27 60
3 UP Viso Sub 19 Viso 27 55 29 56
4 San Roque Balompie Sub 19 B Roque 26 44 32 43
5 SAM-CAM Dos Hermanas Sub 19 SAM-CAM 26 42 38 41
6 Solea Sub 19 Solea 26 46 40 39
7 UD Bellavista Sub 19 Bellavista 26 32 28 37
8 AD Nervión Sub 19 Nervión 26 42 42 32
9 La Liara Balompié Sub 19 Liara 26 42 43 32
10 Osuna Bote Sub 19 Osuna Bote 26 43 53 32
11 Torreblanca CF Sub 19 Torreblanca 26 29 46 30
12 CD Cabecense Sub 19 Cabecense 26 33 47 29
13 UD Tomares Sub 19 Tomares 26 52 56 26
14 Atlético Antoniano Sub 19 Atlético 26 36 63 26
15 Juventud Gines Sub 19 Juventud 26 42 56 22
16 AD San José Sub 19 José 27 35 77 17
TEMPORADA 2022/2023
4ª ANDALUZA SEVILLA JUVENIL GRUPO 4
Equipo PJ GF GC Puntos
1 UP Viso Sub 19 Viso 22 70 23 58
2 CD Cantera de Utrera Cantera 22 106 28 56
3 Club Deportivo Union de Los Club 22 69 30 51
4 CD Pablo VI CD Pablo VI 22 64 57 34
5 Ciudad de Utrera Ciudad 22 51 48 32
6 La Barrera CF Barrera 22 51 52 28
7 CD Utrera Sub 19 Utrera 22 33 38 23
8 Cd Coronil Cd Coronil 22 45 71 23
9 CD El Tinte De Utrera Tinte Utrera 22 44 75 20
10 CD Montellano Montellano 22 37 56 19
11 CD Mairena CD Mairena 22 37 56 18
12 Estrella San Agustín Estrella 22 36 109 9
13 Paradas Balompie Paradas 0 0 0 0
TEMPORADA 2021/2022
2ª ANDALUZA SEVILLA JUVENIL
Equipo PJ GF GC Puntos
1 CD Utrera Sub 19 Utrera 34 97 40 72
2 UD Tomares Sub 19 Tomares 34 75 36 72
3 CD Cabecense Sub 19 Cabecense 34 73 37 71
4 CD Los Caminantes Caminantes 34 73 47 64
5 CD Mosquito Sub 19 Mosquito 34 77 58 61
6 San Roque Balompie Sub 19 B Roque 34 60 42 58
7 Castilleja CF B Castilleja 34 79 59 50
8 UD Bellavista Sub 19 Bellavista 34 63 56 50
9 Coria CF B Coria CF B 34 59 52 47
10 Lora CF Lora CF 34 62 61 47
11 Torreblanca CF Sub 19 Torreblanca 34 48 61 42
12 Andalucía Este Andalucía 34 38 55 41
13 CMD San Juan Juvenil Juan Juvenil 34 41 63 38
14 Estrella San Agustín Estrella 34 44 76 36
15 U.D. Moron C.F. U.D. Moron. 34 52 69 34
16 CD Asoc. Dva. Nervion Asoc. Dva.. 34 57 76 33
17 Los Palacios CF Palacios 34 45 86 30
18 Atletico Libertad Atletico 34 31 100 11
TEMPORADA 2020/2021
2ª ANDALUZA SEVILLA JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 San Roque Balompie Sub 19 Roque 7 12 5 17
2 U.D. Moron C.F. U.D. Moron. 8 23 9 16
3 CD Mosquito Sub 19 Mosquito 7 21 7 16
4 CD Asoc. Dva. Nervion Asoc. Dva.. 8 18 11 16
5 Andalucía Este Andalucía 8 12 15 11
6 Centro Histórico AAVV Centro 8 13 19 10
7 Torreblanca CF Sub 19 Torreblanca 8 8 9 9
8 CD Utrera Sub 19 Utrera 8 15 14 8
9 Calavera Sub 19 B Calavera 8 10 15 7
10 Ecija Balompie SAD Ecija 8 6 34 0
TEMPORADA 2019/2020
2ª ANDALUZA SEVILLA JUVENIL
Equipo PJ GF GC Puntos
1 C Atl. Antoniano Atl. 24 50 35 46
2 Sevilla FC SAD Sevilla 23 68 31 43
3 UD Tomares Sub 19 Tomares 24 51 25 43
4 Atletico Libertad Atletico 24 52 30 42
5 San Roque Balompie Sub 19 Roque 24 53 34 42
6 UD Bellavista Sub 19 Bellavista 24 39 35 42
7 Torreblanca CF Sub 19 Torreblanca 23 39 35 40
8 CD Utrera Sub 19 Utrera 23 51 25 39
9 CD Los Caminantes Caminantes 24 38 35 35
10 Centro Histórico AAVV Centro 23 51 40 34
11 CD Cabecense Sub 19 Cabecense 24 32 47 34
12 CD Mosquito Sub 19 Mosquito 23 44 42 33
13 CMD San Juan Juvenil Juan Juvenil 24 30 46 24
14 Calavera Sub 19 B Calavera 24 41 57 22
15 CD Asoc. Dva. Nervion Asoc. Dva.. 24 29 45 20
16 AD Pvo. Sevilla Este Pvo. Sevilla 23 21 54 10
17 CDAtletico Dos Hermanas CF CDAtletico 23 13 86 7
18 Ecija Balompie SAD Ecija 1 0 0 1

  USO DE MEMORIA  
5,057,248 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0717
Total Execution Time  0.0729
  CADENA URL  
/historico/Cd-Utrera-Juvenil
  GET DATOS  
$_GET['/historico/Cd-Utrera-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0025  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 = 'Cd-Utrera-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=123916 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=123916 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=123916 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=437 AND type_rel = 3
0.0020  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 = '123916' ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '123916' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0019  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 = '123916' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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=123916 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (73834,69886,68419) 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.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 73834 AND teamId = 123916
0.0019  SELECT count(id) as num_players from rel_players_base WHERE league_id = 68419 AND teamId = 123916
0.0017  SELECT count(id) as num_players from rel_players_base WHERE league_id = 69886 AND teamId = 123916
0.0019  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 = '123916' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  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 = '123916' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0021  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 = 123916 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2024_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 = 73834 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.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 `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 = 68419 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.0021  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 = 69886 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.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 `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 = 64947 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.0022  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_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 = 59548 AND t.round = 15 ORDER BY team.conference ASC,t.position 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 `tables2020_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 = 53858 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