4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Mataró
TEMPORADA 2023/2024
PRIMERA CATALANA GRUPO 1
Equipo PJ GF GC Puntos
1 Manlleu Manlleu 27 53 27 61
2 Argentona Argentona 27 41 25 49
3 Caldes Montbui Caldes 26 40 31 42
4 Bescanó Bescanó 27 52 46 39
5 Tossa Tossa 26 45 39 39
6 Montcada Montcada 26 43 36 37
7 Can Gibert Can Gibert 26 33 28 37
8 Mollet Mollet 26 40 39 36
9 Parets Parets 26 31 27 35
10 Banyoles Banyoles 26 41 39 35
11 Roses Roses 27 40 49 35
12 Blanes Blanes 27 33 48 31
13 Cardedeu Cardedeu 26 26 37 30
14 EF Bosc de Tosca Bosc Tosca 27 37 52 28
15 Mataró Mataró 26 36 43 23
16 Begur Begur 26 30 55 21
TEMPORADA 2022/2023
PRIMERA CATALANA GRUPO 1
Equipo PJ GF GC Puntos
1 L'Escala L'Escala 30 52 30 59
2 Palamós Palamós 30 46 35 53
3 UE Vic UE Vic 30 43 31 53
4 UE Figueres UE Figueres 30 44 39 51
5 EC Granollers Granollers 30 51 34 49
6 Lloret Lloret 30 57 45 48
7 Mataró Mataró 30 46 46 41
8 Manlleu Manlleu 30 43 44 40
9 Parets Parets 30 34 35 38
10 Banyoles Banyoles 30 33 37 38
11 Caldes Montbui Caldes 30 55 54 36
12 EF Bosc de Tosca Bosc Tosca 30 37 40 35
13 Can Gibert Can Gibert 30 40 53 34
14 Mollet Mollet 30 29 35 33
15 Bescanó Bescanó 30 37 57 29
16 CF Torelló CF Torelló 30 30 62 21
TEMPORADA 2021/2022
PRIMERA CATALANA GRUPO 1
Equipo PJ GF GC Puntos
1 Montañesa Montañesa 26 48 25 53
2 Lloret Lloret 26 52 34 45
3 L'Escala L'Escala 26 47 33 42
4 Mollet Mollet 26 33 24 40
5 Mataró Mataró 26 38 32 40
6 Parets Parets 26 41 35 39
7 Bescanó Bescanó 26 32 36 38
8 Palamós Palamós 26 42 36 35
9 Unificació Llefià Unificació 26 36 36 35
10 Banyoles Banyoles 26 25 30 33
11 Martinenc Martinenc 26 26 33 32
12 Les Franqueses Franqueses 26 39 41 31
13 Llagostera B Llagostera 26 24 48 28
14 La Jonquera UE Jonquera 26 18 58 12
TEMPORADA 2020/2021
PRIMERA CATALANA GRUPO 2
Equipo PJ GF GC Puntos
1 Guineueta Guineueta 18 32 14 37
2 Sant Cugat Sant Cugat 18 32 13 34
3 Les Franqueses Franqueses 18 17 13 31
4 Mataró Mataró 18 25 22 28
5 Unificació Llefià Unificació 18 27 25 26
6 Mollet Mollet 18 25 19 25
7 Rubí Rubí 18 34 35 25
8 Júpiter Júpiter 18 20 32 17
9 Sabadell Nord Sabadell 18 18 35 17
10 Parets Parets 18 14 36 12
TEMPORADA 2019/2020
PRIMERA CATALANA GRUPO 1
Equipo PJ GF GC Puntos
1 Girona FC B Girona FC B 22 46 2 62
2 FE Grama FE Grama 22 34 24 42
3 Palamós Palamós 22 43 29 41
4 Manlleu Manlleu 22 37 28 41
5 UE Vic UE Vic 22 34 17 38
6 Guineueta Guineueta 22 29 20 34
7 Mataró Mataró 22 24 24 33
8 Júpiter Júpiter 21 26 30 26
9 L'Escala L'Escala 22 30 35 26
10 Rubí Rubí 21 24 37 26
11 Lloret Lloret 21 31 36 25
12 La Jonquera UE Jonquera 22 17 28 25
13 Sabadell Nord Sabadell 21 25 38 24
14 Mollet Mollet 21 32 33 22
15 Tona Tona 22 18 32 17
16 Parets Parets 22 25 45 16
17 Llagostera B Llagostera 21 14 31 13
TEMPORADA 2018/2019
2ª CATALANA GRUPO 2
Equipo PJ GF GC Puntos
1 Mataró Mataró 34 83 37 75
2 Mollet Mollet 34 69 30 72
3 Turó Peira Turó Peira 34 75 37 68
4 Montcada Montcada 34 56 45 56
5 Europa B Europa B 34 53 37 52
6 Valldoreix Valldoreix 34 61 53 52
7 Premià Premià 34 56 40 51
8 Sarrià Sarrià 34 51 50 48
9 Unificació Llefià Unificació 34 55 57 48
10 Molletense Molletense 34 37 43 46
11 Parc Parc 34 41 54 44
12 Canyelles Canyelles 34 52 76 44
13 At. Sant Pol Sant 34 40 62 38
14 Pubilla Casas Pubilla 34 49 75 35
15 Young Talent Badalona Young Talent 34 42 60 32
16 Sant Andreu Atlètic Sant Andreu 34 44 57 32
17 Singuerlin CF Singuerlin 34 50 76 29
18 Besòs Barón de Viver Besòs 34 32 57 27
TEMPORADA 2017/2018
2ª CATALANA GRUPO 2
Equipo PJ GF GC Puntos
1 Guineueta Guineueta 34 69 26 75
2 Argentona Argentona 34 77 33 70
3 Mataró Mataró 34 78 34 69
4 Europa B Europa B 34 86 35 65
5 Unificació Llefià Unificació 34 61 42 62
6 At. Sant Pol Sant 34 59 32 61
7 Sarrià Sarrià 34 60 46 56
8 Masnou Masnou 34 52 42 55
9 Besòs Barón de Viver Besòs 34 55 51 50
10 Canyelles Canyelles 34 70 63 49
11 Sant Andreu Atlètic Sant Andreu 34 72 72 47
12 Parc Parc 34 45 50 41
13 Montcada Montcada 34 48 50 40
14 Sant Andreu de la Barca Sant Andreu 34 55 72 38
15 Hermes A Hermes A 34 56 76 32
16 Piferrer At. Piferrer 34 29 99 18
17 Llavaneres Llavaneres 34 30 94 16
18 Sant Adrià Sant Adrià 34 21 106 7
TEMPORADA 2016/2017
2ª CATALANA GRUPO 2
Equipo PJ GF GC Puntos
1 FE Grama FE Grama 34 79 30 71
2 Mataró Mataró 34 76 33 69
3 Guineueta Guineueta 34 85 47 63
4 Unificació Llefià Unificació 34 75 47 63
5 Europa B Europa B 34 57 45 54
6 Premià Premià 34 50 42 52
7 At. Sant Pol Sant 34 57 53 50
8 Sant Adrià Sant Adrià 34 57 57 50
9 Sarrià Sarrià 34 59 49 48
10 Canyelles Canyelles 34 54 66 48
11 Besòs Barón de Viver Besòs 34 66 61 47
12 Llavaneres Llavaneres 34 53 61 42
13 Lloreda Lloreda 34 46 70 38
14 Martinenc B Martinenc B 34 48 55 37
15 Cirera Cirera 34 41 50 34
16 Badia del Vallès Badia 34 46 77 33
17 Carmelo CD Carmelo CD 34 44 84 24
18 EJ Can Pi EJ Can Pi 34 42 108 19
TEMPORADA 2015/2016
PRIMERA CATALANA GRUPO 1
Equipo PJ GF GC Puntos
1 UE Vilassar de Mar Vilassar 34 52 29 62
2 La Jonquera UE Jonquera 34 46 29 58
3 UA Horta UA Horta 34 41 34 58
4 CE Manresa CE Manresa 34 50 36 56
5 Martinenc Martinenc 34 53 48 55
6 UE Sants UE Sants 34 48 43 54
7 UE Vic UE Vic 34 42 33 52
8 Tona Tona 34 47 43 52
9 Farners Farners 34 38 32 51
10 FC Andorra FC Andorra 34 43 41 50
11 Mollet Mollet 34 34 33 47
12 Avià Avià 34 51 54 46
13 Lloret Lloret 34 42 42 43
14 Girona FC B Girona FC B 34 45 46 41
15 Mataró Mataró 34 47 45 41
16 L'Escala L'Escala 34 36 51 35
17 CE Abadessenc Abadessenc 34 37 66 30
18 Molletense Molletense 34 21 68 12
TEMPORADA 2014/2015
2ª CATALANA GRUPO 2
Equipo PJ GF GC Puntos
1 Mataró Mataró 34 84 35 80
2 Premia CE Premia CE 34 59 43 63
3 San Juan At. M. Juan 34 65 41 62
4 Ripollet Ripollet 34 65 49 62
5 Guineueta Guineueta 34 70 52 58
6 Unificació Llefià Unificació 34 53 38 56
7 Cirera Cirera 34 61 56 49
8 Equipo Ja CF Equipo 34 65 64 49
9 Olímpic Can Fatjó Olímpic 34 52 46 47
10 Lloreda Lloreda 34 49 49 46
11 Canyelles Canyelles 34 62 72 46
12 Carmelo CD Carmelo CD 34 46 55 40
13 At. Sant Pol Sant 34 47 48 39
14 Singuerlin CF Singuerlin 34 59 66 36
15 Catalonia UB Catalonia 34 43 71 36
16 Sarrià Sarrià 34 50 66 35
17 Catalana UD Catalana UD 34 31 68 22
18 Dinamic Batllo Esportiu Dinamic 34 23 65 17

  USO DE MEMORIA  
6,038,192 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.0761
Total Execution Time  0.0779
  CADENA URL  
/historico/Escola-Futbol-Mataro-Cd
  GET DATOS  
$_GET['/historico/Escola-Futbol-Mataro-Cd']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0043  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 = 72878
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18151 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 18151 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0020  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 (122029,1094420) ORDER BY n.cover_points DESC, update_date DESC
0.0021  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 = '18151' 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,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 = 72878 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 FROM `tables2024` 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 = 72878 AND t.round = 27 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022  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 = 18151 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2024` 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 = 72878 AND t.round = 27 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 `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 = 68448 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 `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 = 63408 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.0020  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` 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 = 58715 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.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 `tables2020` 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 = 50597 AND t.round = 23 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 `tables2019` 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 = 44410 AND t.round = 34 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 `tables2018` 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 = 38994 AND t.round = 34 ORDER BY team.conference 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 `tables2017` 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 = 33986 AND t.round = 34 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` 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 = 16583 AND t.round = 34 ORDER BY team.conference 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 `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 = 3949 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC