4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Molins de Rei A
TEMPORADA 2021/2022
2ª CATALANA ALEVIN GRUPO 1
Equipo PJ GF GC Puntos
1 Palleja CF A Palleja 25 164 51 69
2 Abrera Abrera 23 111 27 60
3 Sant Andreu de la Barca A Sant Andreu 27 115 71 54
4 Corbera CF A Corbera 25 113 62 50
5 San Mauro A San Mauro A 23 121 48 47
6 Anoia A Anoia A 26 93 102 42
7 Molins de Rei A Molins 25 89 86 38
8 Martorell Associacio Esport Martorell 26 81 70 37
9 Odena A Odena A 25 79 86 37
10 Sant Esteve Sesrovires A Sant Esteve 28 92 125 29
11 Fundacio Atletic Vilafranca Fundacio 22 57 95 24
12 Escola Gava C H Escola Gava 26 73 115 24
13 Igualada CF F Igualada 25 69 110 19
14 Esparreguera A Esparreguera 25 45 123 11
15 EF Olesa 87 C A Olesa 25 33 164 7
TEMPORADA 2019/2020
2ª CATALANA ALEVIN GRUPO 2
Equipo PJ GF GC Puntos
1 Fundacio Unio Esportiva Cor Fundacio 18 130 17 54
2 Sant Joan Despi UE B Sant Joan D. 19 75 60 38
3 Abrera Abrera 19 58 34 37
4 Santfeliuenc C Santfeliuenc 18 53 58 32
5 Levante Las Planas FC A Levante 19 73 63 31
6 Fundacio Atletic Vilafranca Fundacio 19 87 70 30
7 Igualada CF E Igualada 18 56 46 28
8 EF Olesa 87 C A Olesa 18 53 61 28
9 Corbera CF A Corbera 17 53 48 26
10 Sant Andreu de La Barca Agr Sant Andreu 18 48 46 25
11 Martorell Associacio Esport Martorell 18 49 61 22
12 Molins de Rei A Molins 19 62 72 20
13 Sant Sadurni B Sant Sadurni 18 53 65 18
14 Incresa Atletico Club Futbo Incresa 18 50 82 18
15 Pª Blaugrana Vallirana A Blaugrana 19 40 101 8
16 PB Sant Vicenç H. Sant Vicenç 19 49 105 6
TEMPORADA 2018/2019
2ª CATALANA ALEVIN GRUPO 2
Equipo PJ GF GC Puntos
1 Santfeliuenc B Santfeliuenc 30 163 44 77
2 Martorell Associacio Esport Martorell 30 143 58 68
3 Olesa 87 C B Olesa 29 140 62 67
4 Fundacio Unio Esportiva Cor Fundacio 30 131 58 64
5 Corbera A Corbera A 30 137 58 60
6 Sant Sadurni B Sant Sadurni 30 126 65 58
7 Molins de Rei A Molins 29 135 99 52
8 Igualada F Igualada F 30 128 90 49
9 Abrera Abrera 30 142 105 49
10 Pª Barc Sant Feliu Llobrega Barc Sant F. 30 83 101 38
11 Pª Barc Sant Vicenç Horts Pª Barc Sa. 29 107 145 33
12 Pª Blaugrana Vallirana B Blaugrana 29 68 109 25
13 Sant Andreu de La Barca Agr Sant Andreu 30 83 137 22
14 Sant Esteve Sesrovires A Sant Esteve 30 88 228 15
15 Esparreguera A Esparreguera 30 54 151 13
16 Sant Vicenç Assoc Esportiva Sant Vicenç 30 49 255 3
TEMPORADA 2017/2018
2ª CATALANA ALEVIN GRUPO 2
Equipo PJ GF GC Puntos
1 Sant Andreu de la Barca A Sant Andreu 30 145 36 85
2 Molins de Rei A Molins 30 144 66 70
3 Santfeliuenc C Santfeliuenc 30 140 59 67
4 Abrera Abrera 30 127 62 67
5 Sant VicenÇ Assoc Esportiv Sant 30 113 92 49
6 Viladecans C Viladecans 30 90 78 49
7 Igualada F Igualada F 30 95 86 47
8 EFO 87 A EFO 87 A 30 85 78 46
9 Corbera A Corbera A 30 108 92 44
10 Pª Blaugrana Vallirana B Blaugrana 30 84 106 39
11 Martorell Associacio Esport Martorell 30 98 132 38
12 Sant Esteve Sesrovires A Sant Esteve 30 105 141 25
13 Pª Barc Sant VicenÇ Horts Pª Barc Sa. 30 68 149 22
14 Incresa Atletico Club Futbo Incresa 30 74 126 19
15 Cornella G Cornella G 30 67 147 14
16 Palleja A Palleja A 30 69 162 13
TEMPORADA 2015/2016
2ª CATALANA ALEVIN GRUPO 2
Equipo PJ GF GC Puntos
1 Santfeliuenc A Santfeliuenc 30 171 42 82
2 Sant Joan Despi B Sant Joan D. 30 182 53 80
3 Corbera A Corbera A 30 229 51 78
4 PB Vallirana A Vallirana 30 197 66 77
5 Fontsanta-Fatjo A Fontsanta-Fa 30 107 83 62
6 Molins de Rei A Molins 30 100 85 52
7 Catalonia B Catalonia B 30 119 89 51
8 Sant Andreu de la Barca A Sant Andreu 30 77 99 49
9 Palleja A Palleja A 30 66 75 37
10 Cornella G Cornella G 30 83 165 32
11 PB Sant Vicenç Horts A Sant Vicenç 30 67 124 23
12 Sant Esteve Sesrovires A Sant Esteve 30 97 184 20
13 Martorell Associacio Esport Martorell 30 58 153 20
14 Igualada F Igualada F 30 64 139 17
15 EFO 87 B EFO 87 B 30 56 140 13
16 Levante las Planas A Levante 30 37 162 9
TEMPORADA 2014/2015
3ª CATALANA ALEVIN GRUPO 25
Equipo PJ GF GC Puntos
1 Molins de Rei A Molins 30 248 59 75
2 Martorell Associacio Esport Martorell 30 231 76 74
3 Pª Blanc Blava Sant Feliu A Blanc Blava 30 220 72 74
4 Torrelles A Torrelles A 30 190 64 72
5 Santfeliuenc D Santfeliuenc 30 194 56 65
6 PB Sant Vicenç Horts B Sant Vicenç 30 150 72 56
7 PB Vallirana C Vallirana 30 152 100 50
8 PB Cervello A Cervello 30 134 117 49
9 Palleja E Palleja E 30 132 90 45
10 Sant Joan Despi D Sant Joan D. 30 131 143 35
11 PB Sant Feliu A Sant Feliu 30 96 135 33
12 La Palma Cervello A Palma 30 77 234 22
13 Sector Montserratina C Sector 30 75 148 20
14 Esparreguera D Esparreguera 30 83 255 16
15 Incresa Atletico Club Futbo Incresa 30 67 206 13
16 Abrera C Abrera C 30 40 255 3

  USO DE MEMORIA  
5,229,736 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0970
Total Execution Time  0.0983
  CADENA URL  
/historico/Molins-De-Rei-Cf-A-Alevin
  GET DATOS  
$_GET['/historico/Molins-De-Rei-Cf-A-Alevin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0021  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 = 'Molins-De-Rei-Cf-A-Alevin' 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.0027  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 = 'Molins-De-Rei-Cf-A-Alevin' 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.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=35096 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=35096 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=35096 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=35096 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=35096 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=35096 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=35096 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0026  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 = 65783
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=35096 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=911 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 911 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0020  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 (1130610,997097,728077,726221) ORDER BY n.cover_points DESC, update_date DESC
0.0021  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 = '35096' ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '35096' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '35096' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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 = '35096' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 65783 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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=35096 AND l.year in (2021,2022,2023) 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 (65783) 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 = 65783 AND teamId = 35096
0.0018  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 = 65783 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '35096' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0021  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 = '35096' 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 = 35096 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 65783 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.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 = 54462 AND t.round = 29 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 `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 = 46594 AND t.round = 30 ORDER BY team.conference 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 `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 = 41374 AND t.round = 30 ORDER BY team.conference 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 `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 = 17761 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 6101 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 65783 ORDER BY nameShow LIMIT 100