4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Sant Pol B
TEMPORADA 2022/2023
3ª CATALANA GRUPO 4
Equipo PJ GF GC Puntos
1 Pª Barc Barcino A A Pª Barc Ba. 34 90 39 82
2 EF Barberà And. Barberà 34 81 34 79
3 Calella Calella 34 69 37 66
4 Pomar A A Pomar A A 33 80 60 55
5 Mataronesa Mataronesa 34 69 65 53
6 La Llàntia La Llàntia 34 69 59 51
7 FE Montgat FE Montgat 34 72 70 46
8 Sant Cebria de Vallalta Sant Cebria 34 62 69 46
9 Vilassar Dalt B Vilassar 34 58 65 43
10 Aqua Hotel FC Aqua Hotel 32 63 70 41
11 Vilassar Mar C Vilassar 34 71 91 41
12 Sinera United Sinera 34 76 74 40
13 Santvicentí Santvicentí 34 56 64 39
14 At. Masnou At. Masnou 33 56 68 36
15 Tiana Tiana 34 57 97 35
16 Sant Pol B Sant Pol B 34 56 75 34
17 Alella 2013 Alella 2013 34 57 87 31
18 CE Sant Miquel de Balenyà Sant Miquel 34 60 78 28
TEMPORADA 2021/2022
3ª CATALANA GRUPO 4
Equipo PJ GF GC Puntos
1 Vilassar Dalt Vilassar 30 92 24 79
2 Cabrils Cabrils 30 106 30 78
3 Sinera United Sinera 29 63 35 60
4 Calella Calella 29 73 52 55
5 FE Montgat FE Montgat 30 67 57 49
6 La Llàntia La Llàntia 29 55 62 42
7 Mataronesa Mataronesa 29 57 47 40
8 Aqua Hotel FC Aqua Hotel 28 62 63 38
9 Vilassar Mar C Vilassar 29 60 62 38
10 Alella 2013 Alella 2013 30 52 61 34
11 At. Masnou At. Masnou 29 60 63 32
12 Sant Pol B Sant Pol B 29 39 63 29
13 Santvicentí Santvicentí 28 37 61 28
14 Tiana Tiana 30 42 85 27
15 Molinos B Molinos B 30 43 89 23
16 Premià Dalt Premià Dalt 29 35 89 16
TEMPORADA 2020/2021
3ª CATALANA GRUPO 17
Equipo PJ GF GC Puntos
1 Cal Aguido Cal Aguido 17 49 12 47
2 Sporting-Vidrerenca Sporting-Vid 17 38 18 38
3 Calonge Calonge 17 44 27 35
4 Lloret B Lloret B 17 36 21 34
5 Caldes Malavella UE Caldes 17 35 35 26
6 Aro CE Aro CE 17 43 32 25
7 Breda Breda 17 32 26 25
8 Hostalric Hostalric 17 41 30 24
9 Sauleda Sauleda 17 28 38 21
10 Farners B Farners B 17 25 29 20
11 La Batllòria A Batllòria 17 31 37 19
12 Sant Pol B Sant Pol B 17 27 34 19
13 Blanes B Blanes B 17 33 45 19
14 Angles Angles 17 22 36 19
15 Vilartagues Vilartagues 17 24 40 15
16 Sils La Selva Sils Selva 17 34 44 14
17 Arbucies CF Arbucies CF 17 23 39 14
18 Celra A Celra A 17 21 43 11
TEMPORADA 2019/2020
3ª CATALANA GRUPO 16
Equipo PJ GF GC Puntos
1 Tordera Tordera 23 57 25 57
2 Palafrugell Palafrugell 23 58 21 52
3 Cal Aguido Cal Aguido 23 61 38 48
4 Calonge Calonge 23 58 45 43
5 Sporting-Vidrerenca Sporting-Vid 23 66 41 41
6 Aro CE Aro CE 23 48 39 38
7 Sils La Selva Sils Selva 22 49 44 35
8 Arbucies CF Arbucies CF 23 37 32 34
9 Caldes Malavella UE Caldes 23 40 39 30
10 Hostalric Hostalric 23 36 49 30
11 Farners B Farners B 23 47 47 29
12 Quart B Quart B 23 40 49 29
13 La Batllòria A Batllòria 23 35 44 29
14 Vilartagues Vilartagues 23 32 42 28
15 Sant Pol B Sant Pol B 23 38 62 21
16 Lloret B Lloret B 23 47 61 18
17 Sauleda Sauleda 22 39 62 15
18 Celra A Celra A 23 29 77 5
TEMPORADA 2018/2019
4ª CATALANA GRUPO 28
Equipo PJ GF GC Puntos
1 Sils La Selva Sils Selva 30 117 32 78
2 Sant Pol B Sant Pol B 29 79 26 69
3 Sant Hilari Font Vella A A Sant Hilari 29 91 42 65
4 Can Gibert B Gibert 30 90 47 64
5 Breda Breda 29 71 24 61
6 Tossa B B Tossa B B 30 61 51 53
7 Blanes Atletic Blanes 30 88 63 49
8 Juventus-Lloret Juventus-Llo 29 84 60 48
9 Vilobi FC Vilobi FC 28 82 51 45
10 Sporting-Vidrerenca B Sporting-Vid 28 52 56 33
11 Base LLagostera CF A Base 30 57 76 28
12 Riells i Viabrea Riells 29 46 86 25
13 Cuatro Vientos Cuatro 27 34 97 15
14 LLoret de Mar 2015 Femeni C LLoret 2015 27 44 117 13
15 Maçanet Selva Maçanet 29 29 113 11
16 FC Lloretenc Lloretenc 30 25 109 8
17 Olimpic Malgrat Olimpic 0 0 0 0
TEMPORADA 2017/2018
4ª CATALANA GRUPO 5
Equipo PJ GF GC Puntos
1 Premia Dalt CD C Premia Dalt 22 71 22 54
2 Cerdanyola Mataro Assoc Cerdanyola 24 92 39 52
3 Tiana Tiana 24 70 24 51
4 Rocafonda CF B Rocafonda 23 76 38 50
5 Alella A Alella A 23 70 44 43
6 Juventus AC Juventus AC 24 56 51 43
7 Juvesport A Juvesport A 25 39 42 34
8 Molinos B B Molinos B B 25 56 76 29
9 Sant Pol B Sant Pol B 25 49 56 25
10 Canet A Canet A 25 53 70 25
11 Pineda de Mar Pineda 24 32 64 25
12 Mataro Athletic A A Mataro 23 36 69 18
13 Dosrius 2010 A Dosrius 2010 24 32 124 8
14 Arenys de Munt A Arenys Munt 5 9 22 0
TEMPORADA 2016/2017
4ª CATALANA GRUPO 5
Equipo PJ GF GC Puntos
1 Calella A A Calella A A 24 84 29 61
2 Rocafonda A Rocafonda A 23 85 29 57
3 Tiana B Tiana B 23 79 25 55
4 Juventus AC Juventus AC 23 53 41 41
5 Mataro Athletic A A Mataro 23 67 52 40
6 Canet A Canet A 22 58 51 33
7 Cabrils C Cabrils C 22 41 41 32
8 Sant Pol B Sant Pol B 24 45 43 31
9 Cerdanyola Mataro Assoc Cerdanyola 23 60 62 29
10 Arenys de Munt A Arenys Munt 24 37 68 26
11 Juvesport A Juvesport A 24 44 63 20
12 Iluro A Iluro A 20 29 65 9
13 Dosrius 2010 A Dosrius 2010 23 23 136 1
TEMPORADA 2015/2016
4ª CATALANA GRUPO 5
Equipo PJ GF GC Puntos
1 Molinos Molinos 26 91 30 65
2 Santvicentí Santvicentí 26 102 32 59
3 Canet A Canet A 25 70 41 53
4 Cabrils C Cabrils C 25 68 28 53
5 Sant Pol B Sant Pol B 26 56 37 44
6 Juventus AC Juventus AC 26 47 47 42
7 Dosrius 2010 A Dosrius 2010 26 58 70 38
8 Tiana B Tiana B 26 52 48 36
9 Juvesport A Juvesport A 26 44 55 29
10 Escola Salesians-Mataro A Escola 25 42 69 27
11 Iluro A Iluro A 26 58 80 27
12 Athletic Mataro A Athletic 26 48 81 20
13 Rocafonda A Rocafonda A 25 40 85 15
14 Arenys de Munt A Arenys Munt 26 30 103 7
TEMPORADA 2014/2015
4ª CATALANA GRUPO 5
Equipo PJ GF GC Puntos
1 Vilassar Dalt B Vilassar 30 66 21 72
2 Pla D'en Boet A D'en Boet 30 88 30 69
3 Molinos Molinos 30 99 41 66
4 Canet A Canet A 30 83 54 53
5 Sant Pol B Sant Pol B 30 53 56 50
6 Escola Salesians-Mataro A Escola 30 52 49 49
7 Arenys de Mar B Arenys 30 85 66 46
8 Susannenc A Susannenc A 29 52 55 46
9 Santvicentí Santvicentí 30 55 56 43
10 Iluro A Iluro A 30 38 47 38
11 Athletic Mataro A Athletic 30 52 62 35
12 Masnou At. B Masnou 30 46 70 31
13 Rocafonda A Rocafonda A 30 53 98 26
14 Juvesport A Juvesport A 30 60 90 23
15 Llavaneres B Llavaneres 30 55 89 20
16 Valldemia Mariestes Valldemia 29 26 79 14

  USO DE MEMORIA  
5,782,768 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0862
Total Execution Time  0.0874
  CADENA URL  
/historico/Sant-Pol-At-B
  GET DATOS  
$_GET['/historico/Sant-Pol-At-B']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=23972 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=685 AND type_rel = 3
0.0031  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 685 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0024  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 (979937,978211,935979,930202,887509) ORDER BY n.cover_points DESC, update_date DESC
0.0024  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 = '23972' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0025  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 = '23972' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0025  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=23972 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0025  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 (68570) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 68570 AND teamId = 23972
0.0021  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2023 e ON e.player_id = p.id AND e.league_id = 68570 WHERE rp.league_id = 68570 AND rp.teamId = 23972 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2023 e ON e.player_id = p.id AND e.league_id = 68570 WHERE rp.league_id = 68570 AND rp.teamId = 23972 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2023 e ON e.player_id = p.id AND e.league_id = 68570 WHERE rp.league_id = 68570 AND rp.teamId = 23972 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 23972 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0040  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 = 68570 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.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 `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 = 63749 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.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 `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 = 58801 AND t.round = 17 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` 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 = 50758 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 = 44543 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 `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 = 39932 AND t.round = 26 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 = 36068 AND t.round = 26 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 = 16962 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 = 4735 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC