4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del O´Parrulo Ferrol FS B
TEMPORADA 2023/2024
SEGUNDA DIVISIÓN B FUTSAL GRUPO 1
Equipo PJ GF GC Puntos
1 CD Lugo Sala Lugo Sala 28 147 51 79
2 Stellae FS - Padrón Stellae 28 146 67 70
3 SD Xove SD Xove 28 152 97 64
4 Albense Albense 28 141 101 56
5 Unionistas de Salamanca Unionistas 28 143 79 52
6 Atletico Benavente FS Atletico 28 99 78 48
7 Vilalba FS Vilalba FS 28 120 108 46
8 Guardo Guardo 28 132 111 45
9 IES Coruxo IES Coruxo 28 89 111 31
10 A Estrada A Estrada 28 86 103 30
11 O´Parrulo Ferrol FS B O´Parrulo 28 101 126 26
12 Union Arroyo FS Union Arroyo 28 80 120 26
13 O Esteo O Esteo 28 91 159 26
14 Racing de Mieres Racing 28 80 137 21
15 Leis Pontevedra Leis 28 64 137 17
16 Sala Ourense 2014 Sala Ourense 28 77 163 12
TEMPORADA 2022/2023
SEGUNDA DIVISIÓN B FUTSAL GRUPO 1
Equipo PJ GF GC Puntos
1 CD Lugo Sala Lugo Sala 30 163 72 71
2 Guardo Guardo 30 147 98 63
3 Unionistas de Salamanca Unionistas 30 137 93 58
4 O´Parrulo Ferrol FS B O´Parrulo 30 115 87 58
5 Albense Albense 30 147 113 53
6 A Estrada A Estrada 30 115 106 45
7 Vilalba FS Vilalba FS 30 106 102 43
8 Juv. del Circulo Católico Juv. Circulo 30 111 108 43
9 Leis Pontevedra Leis 30 98 110 41
10 IES Coruxo IES Coruxo 30 97 109 38
11 Union Arroyo FS Union Arroyo 30 107 126 37
12 O Esteo O Esteo 30 137 167 36
13 Sala Ourense 2014 Sala Ourense 30 88 125 31
14 Ribeira De Piquin Ribeira 30 86 113 27
15 Univ. de Valladolid Univ. 30 99 164 22
16 Segosala Segosala 30 98 158 18
TEMPORADA 2021/2022
SEGUNDA DIVISIÓN B FUTSAL GRUPO 1
Equipo PJ GF GC Puntos
1 Guardo Guardo 30 138 86 67
2 Union Arroyo FS Union Arroyo 30 137 116 57
3 Santiago Futsal Santiago 30 107 68 57
4 O Esteo O Esteo 30 109 101 50
5 Segosala Segosala 30 121 108 46
6 Sala Ourense 2014 Sala Ourense 30 113 116 46
7 Ribeira De Piquin Ribeira 30 98 73 44
8 Albense Albense 30 103 91 42
9 Leis Pontevedra Leis 30 100 89 41
10 IES Coruxo IES Coruxo 30 107 103 39
11 O´Parrulo Ferrol FS B O´Parrulo 30 93 105 38
12 A Estrada A Estrada 30 102 122 37
13 Univ. de Valladolid Univ. 30 109 131 35
14 Cidade De Narón Cidade 30 88 116 33
15 UV Ventorrillo Ventorrillo 30 71 114 27
16 Racing de Mieres Racing 30 92 149 27
TEMPORADA 2020/2021
SEGUNDA DIVISIÓN B FUTSAL GRUPO 2
Equipo PJ GF GC Puntos
1 O Esteo O Esteo 16 54 47 32
2 O´Parrulo Ferrol FS B O´Parrulo 16 54 42 28
3 Ribeira De Piquin Ribeira 16 54 43 27
4 Cidade De Narón Cidade 16 40 38 24
5 A Estrada A Estrada 16 47 54 23
6 Leis Pontevedra Leis 16 55 54 20
7 Sala Ourense 2014 Sala Ourense 16 44 51 17
8 UV Ventorrillo Ventorrillo 16 49 60 17
9 SD Xove SD Xove 16 51 59 15
10 Pizarras Los Tres Cuñados Pizarras 0 0 0 0

  USO DE MEMORIA  
5,049,656 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.0819
Total Execution Time  0.0833
  CADENA URL  
/historico/O-Parrulo-Ferrol-Fs-B-Senior
  GET DATOS  
$_GET['/historico/O-Parrulo-Ferrol-Fs-B-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=138576 AND type_rel = 2
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=110 AND type_rel = 3
0.0022  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 110 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0023  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 (1015780,872854,838700,758569,754510) ORDER BY n.cover_points DESC, update_date DESC
0.0034  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 = '138576' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0029  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 = 74081 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=138576 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (74081,71671) 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 WHERE league_id = 74081 AND teamId = 138576
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 71671 AND teamId = 138576
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 = 74081 AND t.round = 28 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '138576' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '138576' and rp.type = 4
0.0020  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 = '138576' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0019  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 events2024 e ON e.player_id = p.id AND e.league_id = 74081 WHERE rp.league_id = 74081 AND rp.teamId = 138576 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.0025  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 events2024 e ON e.player_id = p.id AND e.league_id = 74081 WHERE rp.league_id = 74081 AND rp.teamId = 138576 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 events2024 e ON e.player_id = p.id AND e.league_id = 74081 WHERE rp.league_id = 74081 AND rp.teamId = 138576 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 138576 AND l.year <= 2024 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 `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 = 74081 AND t.round = 28 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 `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 = 68837 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.0026  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 = 63772 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 `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 = 58893 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