4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Los Palacios CF
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 1
Equipo PJ GF GC Puntos
1 CD Los Caminantes Caminantes 9 18 10 21
2 CD Cabecense Sub 19 Cabecense 9 14 9 18
3 UD Tomares Sub 19 Tomares 8 13 6 16
4 Coria CF B Coria CF B 9 19 19 13
5 Atletico Libertad Atletico 9 16 15 11
6 Los Palacios CF Palacios 8 13 12 11
7 UD Bellavista Sub 19 Bellavista 9 12 13 11
8 CMD San Juan Juvenil Juan Juvenil 9 12 15 10
9 AD Pvo. Sevilla Este Pvo. Sevilla 9 13 21 7
10 CDAtletico Dos Hermanas CF CDAtletico 9 12 22 4
TEMPORADA 2018/2019
3ª ANDALUZA SEVILLA JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 CD Cabecense Sub 19 Cabecense 32 90 34 73
2 Rinconada Cantera Rinconada 32 76 33 69
3 Atletico Libertad Atletico 31 90 36 66
4 Camas CF Camas CF 31 85 34 64
5 Coria CF B Coria CF B 31 51 33 56
6 Olivarense Atlético Olivarense 32 74 61 55
7 AD San José Sub 19 José 32 59 43 47
8 La Motilla FC Motilla 32 57 54 46
9 Los Palacios CF Palacios 31 56 39 45
10 Castilleja CF B Castilleja 31 58 51 41
11 Puebla CF Puebla CF 31 44 45 36
12 Valencina FC Valencina 30 56 66 36
13 Benacazon Benacazon 31 62 71 32
14 Alcolea del Rio FC Alcolea 31 44 92 32
15 CD Alcala CD Alcala 30 40 79 20
16 Atletico Dos Hermanas Atletico 31 27 132 12
17 Sevilla Este Sevilla Este 21 17 83 4
18 C.D. Utrera C.D. Utrera 0 0 0 0
TEMPORADA 2017/2018
4ª ANDALUZA SEVILLA JUVENIL GRUPO 3
Equipo PJ GF GC Puntos
1 Los Palacios CF Palacios 24 93 19 59
2 Atletico Dos Hermanas Atletico 23 76 24 54
3 Union Balompedica Lebrijana Union 23 45 22 53
4 CD Los Caminantes Caminantes 23 53 28 44
5 AD Mosqueo AD Mosqueo 24 58 38 42
6 La Motilla FC Motilla 23 40 34 37
7 CD Tabladilla Tabladilla 23 65 77 29
8 Atlético Antoniano Sub 19 Atlético 24 46 61 25
9 El Tinte de Utrera B Tinte Utrera 24 54 79 22
10 CD Doctor Fleming Doctor 23 43 66 20
11 La Union del Porvenir Union 24 47 61 19
12 El Palmar Vereda Real Palmar 21 37 70 19
13 Peña del Bucaro de Utrera Peña Bucaro 19 27 105 2
TEMPORADA 2016/2017
4ª ANDALUZA SEVILLA JUVENIL GRUPO 3
Equipo PJ GF GC Puntos
1 PD Rociera Sub 19 Rociera 27 100 27 67
2 AD Mosqueo AD Mosqueo 29 78 35 67
3 CD Cantera de Utrera Cantera 28 99 45 61
4 UD Dos Hermanas Hermanas 29 99 55 60
5 Union Balompedica Lebrijana Union 28 83 30 59
6 El Palmar Vereda Real Palmar 27 70 36 54
7 CD Tabladilla Tabladilla 28 75 85 42
8 Atlético Antoniano Sub 19 Atlético 29 69 60 41
9 UD Cuervo UD Cuervo 29 53 59 40
10 Ibarburu CF Ibarburu CF 28 52 59 35
11 Tinte de Utrera Tinte Utrera 29 68 111 26
12 Peña Bética Alcalá Peña 29 50 103 24
13 Racing Los Molares Racing 29 62 115 20
14 La Motilla FC Motilla 29 28 92 16
15 Los Palacios CF Palacios 29 36 86 13
16 Montellano CD Montellano 13 11 35 6
TEMPORADA 2015/2016
4ª ANDALUZA SEVILLA JUVENIL GRUPO 3
Equipo PJ GF GC Puntos
1 U.B. Lebrijana U.B. 31 106 37 70
2 La Motilla FC Motilla 31 92 39 69
3 Ibarburu CF Ibarburu CF 31 87 55 61
4 Cd Coronil Cd Coronil 31 87 61 59
5 El Palmar Vereda Real Palmar 31 65 35 58
6 UD Dos Hermanas Hermanas 31 98 58 57
7 PD Rociera Sub 19 Rociera 31 79 55 52
8 Tinte de Utrera Tinte Utrera 32 85 89 47
9 CD Tabladilla Tabladilla 32 66 84 44
10 AD Mosqueo AD Mosqueo 31 76 63 43
11 UD Cuervo UD Cuervo 31 74 65 41
12 CD Cantera de Utrera Cantera 31 69 66 40
13 Los Palacios CF Palacios 31 47 69 33
14 Vistazul CSD Vistazul 31 58 108 22
15 Racing Los Morales Racing 32 44 115 19
16 CD Atlético Viso Atlético 19 19 42 15
17 Estrella San Agustín Estrella 31 49 160 10
TEMPORADA 2014/2015
4ª ANDALUZA SEVILLA JUVENIL GRUPO 3
Equipo PJ GF GC Puntos
1 CF Torreblanca Torreblanca 30 84 25 72
2 CD Mosquito Sub 19 Mosquito 30 140 42 70
3 CD Doctor Fleming Doctor 30 82 54 62
4 AD Mosqueo AD Mosqueo 30 73 42 61
5 El Palmar Vereda Real Palmar 30 76 32 59
6 La Motilla FC Motilla 30 100 63 56
7 UD Dos Hermanas Hermanas 30 66 70 42
8 CD Montequinto Montequinto 30 61 60 38
9 CD Atlético Viso Atlético 30 72 77 37
10 Los Palacios CF Palacios 30 59 67 37
11 Su Eminencia Rvo. Eminencia 30 65 79 36
12 UD Cuervo UD Cuervo 30 52 84 32
13 Arquero Los Remedios CD Arquero 30 50 114 29
14 CD Tabladilla Tabladilla 30 42 75 28
15 CD Cantera de Utrera Cantera 30 57 93 23
16 Triana C.F. Triana C.F. 30 25 127 5

  USO DE MEMORIA  
5,367,448 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.3266
Total Execution Time  0.3279
  CADENA URL  
/historico/Los-Palacios-Cf-Juvenil
  GET DATOS  
$_GET['/historico/Los-Palacios-Cf-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0220  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 = 64947
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19638 AND type_rel = 2
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=437 AND type_rel = 3
0.0111  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 = '19638' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0116  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 = '19638' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0114  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 = 64947 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0116  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=19638 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0107  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 (64947) 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.0107  SELECT count(id) as num_players from rel_players_base WHERE league_id = 64947 AND teamId = 19638
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 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 = 64947 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0110  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 = '19638' 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 = '19638' 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 = '19638' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0108  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 = 19638 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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_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 = 59547 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.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 `tables2019_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 = 45804 AND t.round = 34 ORDER BY team.conference 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 `tables2018_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 = 40032 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 `tables2017_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 = 34585 AND t.round = 34 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 `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 = 17060 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0122  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 = 4284 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC