4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del AEM SE C
TEMPORADA 2021/2022
2ª CATALANA INFANTIL GRUPO 1
Equipo PJ GF GC Puntos
1 Club Esportiu Atletic Lleid Club 20 81 6 57
2 Escola de Futbol Intercomar Escola 19 88 18 52
3 Enfaf Construccions Moderne Enfaf 19 67 33 46
4 AEM SE C AEM SE C 20 64 31 38
5 Escola de Futbol Orgellia A Escola 20 69 46 30
6 Escola F Pinyana CE A Escola 20 39 46 24
7 Bordeta de Lleida B Bordeta 20 68 69 23
8 Escola Ftarrega B Escola 20 32 62 21
9 Pardinyes CF A Pardinyes 20 33 105 16
10 Segre Segre 20 42 90 11
11 Escola De Futbol Baix Segri Escola 20 21 98 4
TEMPORADA 2019/2020
2ª CATALANA INFANTIL GRUPO 2
Equipo PJ GF GC Puntos
1 Segre D Segre D 17 93 14 46
2 Escola Cervera C B Escola 17 91 27 40
3 Agramunt Escolagerard Gatel Agramunt 17 92 40 39
4 Escola Ftarrega B Escola 17 67 21 37
5 Escola Bosc de Tosca C A A Escola Bosc 17 61 54 32
6 AEM SE C AEM SE C 16 33 21 27
7 Fif Lleida D Lleida 15 43 43 25
8 Ivars D'urgell A Ivars 15 42 29 22
9 Escola de Futbol Bellpuig A Escola 16 43 51 20
10 Escola Futbol Base Guissona Escola 17 35 65 15
11 Escola Rialp A Escola Rialp 17 25 69 13
12 Escola Bosc de Tosca C B Escola Bosc 17 34 49 12
13 Pla Urgell CE B Urgell 17 24 81 5
14 Esportiu Ciutat La Seu Club Esportiu 17 11 130 3
TEMPORADA 2018/2019
2ª CATALANA INFANTIL GRUPO 2
Equipo PJ GF GC Puntos
1 Escola Tremp A Escola Tremp 22 95 21 59
2 Mollerussa B Mollerussa 22 65 30 52
3 Agramunt Escgerard Gatell A Agramunt 21 60 23 42
4 AEM SE C AEM SE C 22 62 54 39
5 Efac Almacelles A Efac 22 60 42 38
6 Escola Rialp A Escola Rialp 21 60 38 37
7 Escola Futbol Base Guissona Escola 22 73 59 34
8 Alpicat Club de Futbol B Alpicat Club 22 52 74 22
9 Escola Cervera C B Escola 21 23 62 21
10 Gardeny A Gardeny A 22 40 73 15
11 Pardinyes B Pardinyes B 22 26 74 9
12 Pobla Segur I Comarc A Pobla Segur 21 30 96 5
13 Fif Lleida D Lleida 0 0 0 0
TEMPORADA 2017/2018
2ª CATALANA INFANTIL GRUPO 2
Equipo PJ GF GC Puntos
1 Miralcamp A Miralcamp A 28 175 13 79
2 AEM SE C AEM SE C 28 73 31 72
3 Escola Comarcal Fles Garrig Escola 28 105 38 60
4 Escola Ftarrega B Escola 28 89 56 55
5 Escola de Futbol Bellpuig A Escola 28 71 60 48
6 Terraferma A Terraferma 28 69 77 44
7 Escola Cervera C B Escola 28 55 71 40
8 Escola de Futbol Orgellia B Escola 28 69 80 37
9 Escola Futbol Base Guissona Escola 28 64 85 36
10 La Noguera A Noguera 28 60 73 31
11 Escola de Futbol Intercomar Escola 28 89 120 31
12 Escola de Futbol Artesa A Escola 28 49 87 24
13 Efac Almacelles B Efac 28 32 86 19
14 Bordeta de Lleida C Bordeta 28 34 97 13
15 Pla Urgell A Urgell 28 44 104 12
TEMPORADA 2016/2017
2ª CATALANA INFANTIL GRUPO 3
Equipo PJ GF GC Puntos
1 AEM SE C AEM SE C 25 106 35 64
2 La Noguera A Noguera 25 97 42 52
3 Escola Tremp A Escola Tremp 25 74 50 51
4 Escola Ftarrega C Escola 26 85 59 47
5 Fif Lleida D Lleida 26 64 42 46
6 Linyola A Linyola A 25 60 54 42
7 Pardinyes B Pardinyes B 26 53 63 36
8 Segre E Segre E 25 59 65 34
9 Gardeny A Gardeny A 25 78 77 31
10 Ivars D'urgell A A Ivars 26 80 97 28
11 Bordeta de Lleida D Bordeta 26 40 60 26
12 Escola Futbol Base Guissona Escola 26 49 96 25
13 Fondarella A Fondarella 26 45 88 21
14 Miralcamp B Miralcamp B 26 43 105 11
TEMPORADA 2015/2016
2ª CATALANA INFANTIL GRUPO 2
Equipo PJ GF GC Puntos
1 Linyola A Linyola A 19 82 10 52
2 Balaguer B Balaguer B 19 73 23 50
3 AEM SE C AEM SE C 20 40 32 36
4 Pla Urgell A Urgell 20 56 40 33
5 Ivars de Urgel Ivars Urgel 19 43 43 32
6 Fif Lleida D Lleida 20 38 28 26
7 La Noguera A Noguera 19 29 38 22
8 Gardeny A Gardeny A 19 47 68 20
9 Baix Segria B Baix Segria 19 39 58 17
10 Ponent SGM A Ponent 20 18 61 13
11 Pardinyes B Pardinyes B 18 18 82 7
12 Bordeta de Lleida D Bordeta 0 0 0 0
TEMPORADA 2014/2015
2ª CATALANA INFANTIL GRUPO 1
Equipo PJ GF GC Puntos
1 MIG Segria A Segria 32 121 23 78
2 Ponent SGM A Ponent 32 129 36 77
3 FIF Lleida B Lleida 32 120 19 76
4 Segre D Segre D 32 107 23 71
5 Pla Urgell A Urgell 32 78 28 69
6 La Noguera A Noguera 32 81 38 61
7 Intercomarcal B Intercomarca 32 74 46 59
8 Alpicat A Alpicat A 32 73 50 48
9 Pardinyes A Pardinyes A 32 84 65 42
10 Efac Almacelles A Efac 32 47 69 42
11 Balafia B Balafia B 32 59 70 39
12 Pinyana A Pinyana A 32 43 75 38
13 Miralcamp B Miralcamp B 32 40 114 22
14 AEM SE C AEM SE C 32 26 96 21
15 Gardeny A Gardeny A 32 45 127 18
16 Baix Segria B Baix Segria 32 13 153 12
17 Les Garrigues B Garrigues 32 21 129 8

  USO DE MEMORIA  
5,188,024 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0017
Controller Execution Time ( Home / Category )  0.3158
Total Execution Time  0.3176
  CADENA URL  
/historico/Aem-Se-C-Infantil
  GET DATOS  
$_GET['/historico/Aem-Se-C-Infantil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=21903 AND type_rel = 2
0.0128  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 21903 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0127  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 (201497,238525) ORDER BY n.cover_points DESC, update_date DESC
0.0127  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 = '21903' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0129  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 = '21903' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0129  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=21903 AND l.year in (2021,2022,2023) 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 (65195) 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.0126  SELECT count(id) as num_players from rel_players_base WHERE league_id = 65195 AND teamId = 21903
0.0128  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 = 21903 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0128  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 = 65195 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 53083 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.0128  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 = 46286 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 40335 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 35599 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 35601 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 17515 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 4591 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC