4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Alzira FS
TEMPORADA 2023/2024
PRIMERA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Barça Barça 29 102 82 60
2 ElPozo Murcia Costa Cálida ElPozo 28 105 70 55
3 Jaén FS Jaén FS 28 89 66 51
4 Inter FS Inter FS 28 105 71 50
5 Jimbee Cartagena Jimbee 29 94 81 48
6 Palma Futsal Palma Futsal 29 106 96 48
7 Manzanares FS Manzanares 28 101 95 45
8 Viña Albali Valdepeñas Viña Albali 28 94 84 42
9 Industrias Santa Coloma Industrias 28 96 94 41
10 Córdoba Patrimonio Córdoba 28 80 93 34
11 Peñíscola FS Peñíscola 29 109 105 33
12 Osasuna Magna Osasuna 28 71 90 31
13 Noia Portus Apostoli Noia Portus 28 92 106 27
14 Ribera Navarra FS Ribera 28 73 90 24
15 Real Betis Futsal Real Betis. 28 73 122 24
16 Alzira FS Alzira FS 28 58 103 20
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 FUTSAL GRUPO 3
Equipo PJ GF GC Puntos
1 Alzira FS Alzira FS 24 78 67 36
2 Bisontes Castellón FS Bisontes 24 62 72 33
3 Full Energía Zaragoza Full 24 101 90 32
4 Ciudad de Móstoles Ciudad 24 71 69 32
5 CD Leganes FS Leganes 24 77 77 31
6 Elche CF Sala Elche Sala 24 84 89 31
7 ElPozo Ciudad de Murcia ElPozo 24 55 64 23
8 Rivas Futsal Rivas Futsal 24 56 97 21
9 Santiago Futsal Santiago 24 46 78 18
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 B FUTSAL GRUPO 2
Equipo PJ GF GC Puntos
1 Alzira FS Alzira FS 30 131 61 66
2 Lauburu Ke Ibarra Lauburu 30 135 87 64
3 AD San Juan FS Juan 30 122 80 60
4 CD Tafa FS CD Tafa FS 30 121 79 57
5 CFS Ibi CFS Ibi 30 143 114 55
6 Otxartabe CD Otxartabe 30 143 119 55
7 Pinseque AD Pinseque AD 30 134 106 53
8 Zierbena CDF Zierbena 30 120 107 43
9 Ciudad de Guadalajara Ciudad 30 130 136 41
10 Juv. del Circulo Católico Juv. Circulo 30 85 113 35
11 FS Cuellar Cojalba Futsal Cuellar 30 99 111 32
12 Laskorain Ke Futsal Laskorain 30 83 115 30
13 Sala 2012 AD Sala 2012 30 85 109 28
14 Sala Quinto Fs Futsal Sala Quinto 30 108 149 27
15 Santurtzi FS Santurtzi 30 105 177 18
16 Peña La Union Peña Union 30 80 161 12
TEMPORADA 2017/2018
2ª VALENCIA FUTSAL GRUPO 2
Equipo PJ GF GC Puntos
1 Inter Montesa Inter 24 147 60 62
2 Ayora Ayora 24 141 61 61
3 Sala Futsacar Sala 24 144 69 60
4 Picassent B Picassent B 24 144 76 55
5 Q. Poblet B Q. Poblet B 24 110 94 39
6 Futur Manises A Futur 24 134 100 35
7 Olimpic Floresta Olimpic 24 112 126 28
8 Inter Tavernes Blanques 'b' Inter 24 84 112 28
9 Aliança Quart de Poblet B Aliança 24 117 150 27
10 Fuensanta B Fuensanta B 24 114 160 22
11 Alzira FS Alzira FS 24 103 129 21
12 Club Deportivo Lopez Rosat Club 24 80 159 11
13 Sollana El Romani Atletic A Sollana 24 58 192 7

  USO DE MEMORIA  
5,693,656 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.4335
Total Execution Time  0.4350
  CADENA URL  
/historico/Alzira-Fs-Nitida-A-Futsal
  GET DATOS  
$_GET['/historico/Alzira-Fs-Nitida-A-Futsal']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0135  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 = 'Alzira-Fs-Nitida-A-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.0108  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=108903 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0108  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=108903 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107  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=108903 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=108903 AND type_rel = 2
0.0108  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 108903 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0112  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 (765311,765831,1052935,1053397,1109930) ORDER BY n.cover_points DESC, update_date DESC
0.0111  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '108903' ORDER BY l.year DESC,cat.coefficient DESC
0.0112  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '108903' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0111  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 = '108903' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0115  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=108903 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0109  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,73234,71723,68743) 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.0107  SELECT count(id) as num_players from rel_players WHERE league_id = 73234 AND teamId = 108903
0.0109  SELECT count(id) as num_players from rel_players WHERE league_id = 68743 AND teamId = 108903
0.0107  SELECT count(id) as num_players from rel_players WHERE league_id = 74080 AND teamId = 108903
0.0110  SELECT count(id) as num_players from rel_players WHERE league_id = 71723 AND teamId = 108903
0.0116  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 = '108903' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0109  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '108903' and rp.type = 4
0.0115  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 = '108903' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0117  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 = 73234 WHERE rp.league_id = 73234 AND rp.teamId = 108903 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.0115  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 = 73234 WHERE rp.league_id = 73234 AND rp.teamId = 108903 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0114  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 = 73234 WHERE rp.league_id = 73234 AND rp.teamId = 108903 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0123  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 = 108903 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0126  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 = 73234 AND t.round = 29 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113  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.0113  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.0110  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.0108  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 = 61574 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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.0110  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 = 44513 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 42014 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC