4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Atlético Mengíbar FS
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 B FUTSAL GRUPO 5
Equipo PJ GF GC Puntos
1 Atlético Mengíbar FS Atlético 30 128 76 64
2 Melistar Futsal Melistar 30 139 89 61
3 Social Energy Alcalá FS Social 30 124 90 61
4 Bujalance FS Bujalance 30 123 106 58
5 Córdoba Patrimonio B Córdoba 30 129 86 58
6 Granada FS Granada FS 30 139 112 53
7 ElPozo Ciudad de Murcia ElPozo 30 155 135 52
8 Zambu Pinatar Zambu 30 110 96 51
9 Jaén Paraiso Interior B Jaén 30 117 103 49
10 Coineña UDFS Coineña 30 116 104 42
11 El Puntarron FS Puntarron 30 115 151 38
12 Xerez Deportivo Xerez 29 87 106 33
13 Nazareno Dos Hermanas FS Nazareno 30 105 127 29
14 Sporting FS Almería Sporting 30 69 125 26
15 Jumilla FS Jumilla FS 30 89 159 17
16 Africa Ceutí B Africa 29 73 153 7
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 FUTSAL GRUPO 2
Equipo PJ GF GC Puntos
1 Noia Portus Apostoli Noia Portus 22 77 47 53
2 Manzanares FS Manzanares 24 71 53 42
3 Union África Ceutí Union 22 75 59 38
4 Inagroup El Ejido Inagroup 24 92 90 39
5 Atlético Mengíbar FS Atlético 24 74 61 37
6 Barça Atlétic Barça 24 85 81 34
7 Soliss FS Talavera Soliss 22 62 68 29
8 Atletico Benavente FS Atletico 22 65 69 24
TEMPORADA 2019/2020
SEGUNDA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Real Betis Futsal Real Betis. 23 83 47 50
2 CD UMA Antequera Antequera 23 82 43 45
3 Soliss FS Talavera Soliss 23 74 52 43
4 Manzanares FS Manzanares 23 67 56 43
5 Elche CF Sala Elche Sala 23 78 78 40
6 Ciudad de Móstoles Ciudad 23 73 63 33
7 ElPozo Ciudad de Murcia ElPozo 23 61 55 31
8 Noia Portus Apostoli Noia Portus 23 63 69 31
9 Atlético Mengíbar FS Atlético 23 60 61 30
10 Alzira FS Alzira FS 23 70 78 30
11 Barça Atlétic Barça 23 67 71 28
12 Union África Ceutí Union 23 58 65 26
13 Bisontes Castellón FS Bisontes 23 47 66 25
14 Santiago Futsal Santiago 23 42 59 22
15 Full Energía Zaragoza Full 23 82 103 22
16 Rivas Futsal Rivas Futsal 23 59 100 13
TEMPORADA 2018/2019
SEGUNDA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Burela FS Burela FS 30 116 68 67
2 Real Betis Futsal Real Betis. 30 123 56 66
3 Atlético Mengíbar FS Atlético 30 109 65 62
4 Manzanares FS Manzanares 30 94 80 56
5 Barça Atlétic Barça 30 110 74 54
6 ElPozo Ciudad de Murcia ElPozo 30 111 73 53
7 Córdoba Patrimonio Córdoba 30 110 104 48
8 Santiago Futsal Santiago 30 99 88 45
9 Rivas Futsal Rivas Futsal 30 93 104 37
10 Noia Portus Apostoli Noia Portus 30 102 106 35
11 Bisontes Castellón FS Bisontes 30 66 98 33
12 Elche CF Sala Elche Sala 30 75 99 33
13 Full Energía Zaragoza Full 30 110 124 32
14 Soliss FS Talavera Soliss 30 93 129 29
15 Gran Canaria Gran Canaria 30 86 104 29
16 CD Salesianos Tenerife Salesianos 30 41 166 4
TEMPORADA 2017/2018
SEGUNDA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 ElPozo Ciudad de Murcia ElPozo 30 131 84 61
2 Barça Atlétic Barça 30 122 70 60
3 Viña Albali Valdepeñas Viña Albali 30 114 72 60
4 Burela FS Burela FS 30 102 63 55
5 CD UMA Antequera Antequera 30 106 80 51
6 FSD Puertollano Puertollano 30 118 94 51
7 Real Betis Futsal Real Betis. 30 108 88 51
8 Rivas Futsal Rivas Futsal 30 110 91 48
9 Córdoba Patrimonio Córdoba 30 112 108 47
10 Bisontes Castellón FS Bisontes 30 82 99 40
11 Manzanares FS Manzanares 30 83 103 39
12 Atlético Mengíbar FS Atlético 30 81 90 38
13 Elche CF Sala Elche Sala 30 84 102 33
14 Noia Portus Apostoli Noia Portus 30 64 123 22
15 Prone Lugo FS Prone Lugo 30 64 125 18
16 Tenerife Iberia Toscal Tenerife 30 60 149 6
TEMPORADA 2016/2017
SEGUNDA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Barça Atlétic Barça 26 122 65 59
2 Naturpellet Segovia Naturpellet 26 97 60 58
3 CD UMA Antequera Antequera 26 91 63 56
4 ElPozo Ciudad de Murcia ElPozo 26 99 73 51
5 Elche CF Sala Elche Sala 26 88 61 47
6 Viña Albali Valdepeñas Viña Albali 26 80 64 45
7 O Parrulo Ferrol Parrulo 26 83 73 43
8 Atlético Mengíbar FS Atlético 26 83 80 34
9 Real Betis Futsal Real Betis. 26 79 90 29
10 FSD Puertollano Puertollano 26 74 78 27
11 Rivas Futsal Rivas Futsal 26 89 103 26
12 Tenerife Iberia Toscal Tenerife 26 95 127 23
13 Prone Lugo FS Prone Lugo 26 49 116 8
14 Cidade De Narón Cidade 26 51 127 6
TEMPORADA 2015/2016
SEGUNDA DIVISIÓN B FUTSAL GRUPO 5
Equipo PJ GF GC Puntos
1 Atlético Mengíbar FS Atlético 24 105 42 68
2 Union África Ceutí Union 24 103 54 46
3 Córdoba Patrimonio Córdoba 23 103 83 42
4 Peligros FS Peligros FS 24 100 74 41
5 Lucena FS Lucena FS 23 82 66 41
6 Victoria Kent Victoria 24 69 82 34
7 Coineña UDFS Coineña 24 85 85 33
8 Caceres Malpartida FS Caceres 24 70 88 29
9 Villa del Río FS Villa Río 24 73 92 28
10 CD Olimpic de Triana FS Olimpic 25 86 115 23
11 Sporting Constitución FS Sporting 24 70 90 23
12 Bujalance FS Bujalance 25 79 94 23
13 Isleño San Fernando FS Isleño 24 30 90 13
TEMPORADA 2014/2015
SEGUNDA DIVISIÓN B FUTSAL GRUPO 5
Equipo PJ GF GC Puntos
1 Real Betis Futsal Real Betis. 24 143 67 64
2 Atlético Mengíbar FS Atlético 24 93 75 51
3 CD Olimpic de Triana FS Olimpic 24 118 94 41
4 Santaella 2010 FS Santaella 24 91 95 40
5 Coineña UDFS Coineña 24 113 90 38
6 Union África Ceutí Union 24 91 77 35
7 Virgili de Cadiz Virgili 24 76 75 34
8 FSD Puertollano Puertollano 24 103 102 27
9 Cd Fs Ategua Futsal Ategua 24 88 95 25
10 Racing Kallan Doors Racing 24 96 124 25
11 Bujalance FS Bujalance 24 65 96 22
12 Victoria Kent Victoria 24 76 122 21
13 El Ejido 2012 FS Ejido 2012 24 74 115 16

  USO DE MEMORIA  
6,084,544 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0845
Total Execution Time  0.0857
  CADENA URL  
/historico/Mengibar-Fs-Futsal
  GET DATOS  
$_GET['/historico/Mengibar-Fs-Futsal']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0030  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 = 'Mengibar-Fs-Futsal' 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.0020  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=22230 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=22230 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=22230 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = '22230' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024  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=22230 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (74080,73235,71671,68841) 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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 73235 AND teamId = 22230
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 68841 AND teamId = 22230
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 74080 AND teamId = 22230
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 71671 AND teamId = 22230
0.0026  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 = 22230 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 68841 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.0029  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 = 58755 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.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 `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 = 61573 AND t.round = 8 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 `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 = 50516 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.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 `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 = 44362 AND t.round = 30 ORDER BY team.conference 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 `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 = 39113 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 33894 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  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 = 20046 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 = 4613 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC