4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Real Betis Futsal B
TEMPORADA 2023/2024
SEGUNDA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Sala 10 Zaragoza Sala 28 129 59 70
2 CD UMA Antequera Antequera 28 103 65 61
3 Burela FS Burela FS 28 93 59 56
4 Union África Ceutí Union 28 88 69 50
5 Full Energía Zaragoza Full 28 100 94 49
6 Inagroup El Ejido Inagroup 28 88 76 43
7 O Parrulo Ferrol Parrulo 28 99 88 40
8 Sala 5 Martorell Sala 28 83 90 40
9 Levante UD FS Levante 28 80 91 38
10 Ibiza Gasifred Ibiza 28 90 91 31
11 Melistar Futsal Melistar 28 67 88 30
12 Barça Atlétic Barça 28 68 80 27
13 CD Leganes FS Leganes 28 61 87 25
14 Real Betis Futsal B Real Betis. 28 59 97 23
15 Atlético Mengíbar FS Atlético 28 66 99 21
16 Bisontes Castellón FS Bisontes 28 50 91 21
TEMPORADA 2022/2023
SEGUNDA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Peñíscola FS Peñíscola 30 154 59 83
2 Burela FS Burela FS 30 129 71 68
3 O Parrulo Ferrol Parrulo 30 128 93 60
4 Alzira FS Alzira FS 30 96 78 56
5 Sala 10 Zaragoza Sala 30 118 72 55
6 Union África Ceutí Union 30 125 101 52
7 Inagroup El Ejido Inagroup 30 92 75 47
8 Real Betis Futsal B Real Betis. 30 93 106 41
9 Full Energía Zaragoza Full 30 116 113 39
10 Barça Atlétic Barça 30 116 99 38
11 CD Leganes FS Leganes 30 82 93 37
12 Bisontes Castellón FS Bisontes 30 69 91 35
13 Sala 5 Martorell Sala 30 96 141 25
14 CD El Valle CD El Valle 30 80 145 18
15 Atletico Benavente FS Atletico 30 82 163 16
16 Gran Canaria Gran Canaria 30 81 157 13
TEMPORADA 2021/2022
SEGUNDA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Noia Portus Apostoli Noia Portus 34 149 69 82
2 Peñíscola FS Peñíscola 34 122 82 64
3 CD UMA Antequera Antequera 34 123 100 62
4 Alzira FS Alzira FS 34 99 93 57
5 Atletico Benavente FS Atletico 34 152 146 54
6 Barça Atlétic Barça 34 148 120 52
7 Inagroup El Ejido Inagroup 34 95 87 52
8 Union África Ceutí Union 34 100 102 50
9 Full Energía Zaragoza Full 34 111 128 46
10 O Parrulo Ferrol Parrulo 34 106 119 45
11 Bisontes Castellón FS Bisontes 34 88 104 45
12 Real Betis Futsal B Real Betis. 34 122 118 44
13 CD Leganes FS Leganes 34 107 109 44
14 Atlético Mengíbar FS Atlético 34 109 115 42
15 Soliss FS Talavera Soliss 34 95 104 42
16 ETB Calvia - Palma Futsal Calvia Palma 34 112 126 35
17 Ciudad de Móstoles Ciudad 34 93 129 32
18 Club Inter Movistar FS Club Inter. 34 76 156 15
TEMPORADA 2020/2021
SEGUNDA DIVISIÓN B FUTSAL GRUPO 9
Equipo PJ GF GC Puntos
1 Real Betis Futsal B Real Betis. 16 75 31 38
2 Asociación Jerez Futsal Asociación 16 62 54 28
3 Nazareno Dos Hermanas FS Nazareno 16 47 42 28
4 Bujalance FS Bujalance 16 59 54 27
5 Virgili de Cadiz Virgili 16 53 48 26
6 Jaén Paraiso Interior B Jaén 16 45 37 23
7 Xerez Deportivo Xerez 16 52 49 22
8 Africa Ceutí B Africa 16 43 69 9
9 Futuro Carmonense Futuro 16 34 86 5
TEMPORADA 2019/2020
SEGUNDA DIVISIÓN B FUTSAL GRUPO 5
Equipo PJ GF GC Puntos
1 CD Bayyana El Ejido Bayyana 23 130 45 66
2 Dos Hermanas FS Hermanas 22 82 69 47
3 Melistar Futsal Melistar 23 85 65 45
4 Real Betis Futsal B Real Betis. 23 92 79 37
5 Peligros FS Peligros FS 23 93 82 37
6 Jaén Paraiso Interior B Jaén 23 80 69 37
7 Zambu Pinatar Zambu 22 77 69 37
8 Virgili de Cadiz Virgili 22 80 77 32
9 Asociación Jerez Futsal Asociación 23 68 80 32
10 Coineña UDFS Coineña 23 67 68 29
11 Victoria Kent Victoria 23 63 69 26
12 Xerez Deportivo Xerez 23 66 73 26
13 Futuro Carmonense Futuro 23 77 98 23
14 El Puntarron FS Puntarron 22 79 111 22
15 Sporting Constitución FS Sporting 23 58 95 20
16 AV Torcal-Carranque Torcal-Carra 23 57 105 7
TEMPORADA 2018/2019
SEGUNDA DIVISIÓN B FUTSAL GRUPO 5
Equipo PJ GF GC Puntos
1 Union África Ceutí Union 27 140 70 66
2 Inagroup El Ejido Inagroup 27 116 53 65
3 Melistar Futsal Melistar 28 115 95 54
4 Peligros FS Peligros FS 27 91 79 47
5 Coineña UDFS Coineña 27 90 91 44
6 Real Betis Futsal B Real Betis. 28 103 92 43
7 Virgili de Cadiz Virgili 28 100 95 41
8 Asociación Jerez Futsal Asociación 28 101 100 38
9 AV Torcal-Carranque Torcal-Carra 27 93 117 32
10 Sporting Constitución FS Sporting 25 80 93 31
11 Xerez Deportivo Xerez 28 99 113 30
12 Futuro Carmonense Futuro 28 88 109 30
13 Social Energy Alcalá FS Social 28 78 110 28
14 Victoria Kent Victoria 28 64 94 25
15 Bujalance FS Bujalance 28 76 123 11
TEMPORADA 2017/2018
SEGUNDA DIVISIÓN B FUTSAL GRUPO 5
Equipo PJ GF GC Puntos
1 Xerez Deportivo Xerez 29 129 88 65
2 Coineña UDFS Coineña 29 134 70 62
3 Cerro de Reyes A Cerro Reyes 28 125 62 58
4 Inagroup El Ejido Inagroup 29 121 104 49
5 Melistar Futsal Melistar 27 103 78 48
6 Union África Ceutí Union 29 101 92 48
7 Peligros FS Peligros FS 29 104 89 43
8 Social Energy Alcalá FS Social 29 87 96 40
9 Victoria Kent Victoria 29 83 87 39
10 Real Betis Futsal B Real Betis. 29 101 110 39
11 Baeza Dental Company Baeza Dental 28 90 111 38
12 Villa de Fines Villa Fines 27 88 92 33
13 Infantes FS Infantes FS 29 97 110 33
14 Sporting Constitución FS Sporting 27 92 90 31
15 Villa Del Rio Fs Futsal Villa Futsal 29 56 151 14
16 CD Gador CD Gador 29 58 139 12
TEMPORADA 2016/2017
SEGUNDA DIVISIÓN B FUTSAL GRUPO 5
Equipo PJ GF GC Puntos
1 Cerro de Reyes A Cerro Reyes 29 150 58 79
2 Córdoba Patrimonio Córdoba 29 160 92 73
3 Union África Ceutí Union 29 134 78 59
4 Xerez Deportivo Xerez 30 132 99 58
5 Peligros FS Peligros FS 30 153 105 52
6 Sporting Constitución FS Sporting 29 104 99 45
7 Villa del Río FS Villa Río 30 106 112 42
8 Victoria Kent Victoria 30 87 103 40
9 Coineña UDFS Coineña 30 138 122 39
10 CD Olimpic de Triana FS Olimpic 30 114 127 36
11 Real Betis Futsal B Real Betis. 30 99 120 34
12 CD Gador CD Gador 30 104 136 32
13 Infantes FS Infantes FS 29 92 127 31
14 Bujalance FS Bujalance 30 93 126 27
15 El Palo Pedregalejo Palo 30 79 144 16
16 Lucena FS Lucena FS 27 67 164 10

  USO DE MEMORIA  
5,632,304 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0891
Total Execution Time  0.0903
  CADENA URL  
/historico/Nazareno-Real-Betis-Balompie-Futsal
  GET DATOS  
$_GET['/historico/Nazareno-Real-Betis-Balompie-Futsal']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=93739 AND type_rel = 2
0.0044  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 = '93739' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0034  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 = 73235 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0041  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=93739 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0023  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 (73235) 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.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 73235 AND teamId = 93739
0.0055  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 = 73235 AND t.round = 28 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0034  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 = '93739' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0025  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '93739' and rp.type = 4
0.0023  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 = '93739' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0024  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 = 73235 WHERE rp.league_id = 73235 AND rp.teamId = 93739 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.0024  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 = 73235 WHERE rp.league_id = 73235 AND rp.teamId = 93739 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 73235 WHERE rp.league_id = 73235 AND rp.teamId = 93739 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 93739 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0028  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 = 68743 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.0028  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 = 63428 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.0027  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 = 58900 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