4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Mutxamel
TEMPORADA 2023/2024
PRIMERA FFCV GRUPO 4
Equipo PJ GF GC Puntos
1 Mutxamel Mutxamel 1 4 0 3
2 Almoradí Almoradí 1 2 0 3
3 El Campello El Campello 1 2 0 3
4 Novelda UCF Novelda UCF 1 2 1 3
5 SC Torrevieja CF Torrevieja 1 2 1 3
6 UE Crevillent Crevillent 1 1 0 3
7 Atlético Catral Atlético 1 2 2 1
8 Murada Murada 1 2 2 1
9 Pinoso Pinoso 1 2 2 1
10 Villena Villena 1 2 2 1
11 Novelda CF Novelda CF 1 1 2 0
12 S. Fulgencio Fulgencio 1 1 2 0
13 Polop Polop 1 0 1 0
14 Benferri Benferri 1 0 2 0
15 Villajoyosa Villajoyosa 1 0 2 0
16 Carrús UD Ilicitana Carrús 1 0 4 0
TEMPORADA 2022/2023
SEGUNDA FFCV GRUPO 7
Equipo PJ GF GC Puntos
1 El Campello El Campello 30 78 29 71
2 Polop Polop 30 52 31 62
3 Mutxamel Mutxamel 30 76 39 58
4 Salesianos Alicante Salesianos 30 57 43 56
5 Atlético Benidorm Atlético 30 56 53 46
6 Alicante City Alicante 30 46 45 45
7 UD Altea UD Altea 30 55 46 42
8 Betis Florida Betis 30 63 59 42
9 CF Intercity B Intercity 30 60 56 39
10 Club Costa City Club Costa. 30 51 53 37
11 Atletico Jonense Atletico 30 41 55 37
12 Univ. Alicante Univ. 30 40 52 34
13 Alfaz del Pi Alfaz 30 45 50 33
14 Benissa Benissa 30 48 56 33
15 Callosa Callosa 30 30 81 18
16 Agost Agost 30 42 92 15
TEMPORADA 2021/2022
SEGUNDA FFCV GRUPO 8
Equipo PJ GF GC Puntos
1 Villena Villena 28 85 27 69
2 Eldense B Eldense B 28 82 23 68
3 Salesianos Alicante Salesianos 28 61 44 54
4 CF Intercity B Intercity 28 57 37 51
5 Alicante City Alicante 28 59 38 48
6 Atletico Jonense Atletico 28 54 52 43
7 Odisea FC Odisea FC 28 51 52 42
8 El Campello El Campello 28 45 44 38
9 Sax Sax 28 53 59 35
10 Mutxamel Mutxamel 28 44 50 33
11 Agost Agost 28 48 77 33
12 Petrelense Petrelense 28 49 59 32
13 Ciutat de Valencia A Ciutat 28 45 53 29
14 Castalla Castalla 28 36 82 11
15 CD Iraklis CD Iraklis 28 23 95 7
TEMPORADA 2020/2021
SEGUNDA FFCV GRUPO 29
Equipo PJ GF GC Puntos
1 Polop Polop 6 19 4 16
2 Agost Agost 6 10 12 11
3 Alicante City Alicante 6 14 7 10
4 Castalla Castalla 6 8 11 9
5 Mutxamel Mutxamel 6 6 9 8
6 Atletico Sedavi A Atletico 6 6 13 3
7 Altet Altet 6 4 11 1
TEMPORADA 2019/2020
SEGUNDA FFCV GRUPO 7
Equipo PJ GF GC Puntos
1 Calpe Calpe 23 65 24 54
2 La Nucia B La Nucia B 24 55 25 53
3 Novelda UCF Novelda UCF 23 37 19 45
4 UD Aspe UD Aspe 23 36 29 41
5 UD Altea UD Altea 24 47 33 39
6 Betis Florida Betis 24 36 37 34
7 Gorgos Gorgos 24 46 44 31
8 Racing de San Gabriel Racing 24 32 40 31
9 El Campello El Campello 24 44 36 30
10 Alicante City Alicante 24 48 56 30
11 Salesianos Alicante Salesianos 24 43 54 28
12 Mutxamel Mutxamel 23 34 49 27
13 Atletico Jonense Atletico 24 46 53 25
14 Polop Polop 24 27 40 25
15 Benissa Benissa 24 35 51 23
16 UD Ondarense Ondarense 24 19 60 11
TEMPORADA 2018/2019
SEGUNDA FFCV GRUPO 7
Equipo PJ GF GC Puntos
1 CF Benidorm CF Benidorm 28 54 27 63
2 Pedreguer Pedreguer 28 62 21 61
3 La Nucia B La Nucia B 28 69 25 59
4 UD Altea UD Altea 28 65 36 58
5 Il-Licitana Raval A Il-Licitana 28 55 35 47
6 El Campello El Campello 28 45 36 44
7 Mutxamel Mutxamel 28 50 45 41
8 Caramanchel A Caramanchel 28 32 47 34
9 Gorgos Gorgos 28 49 59 33
10 San Gabriel A Gabriel 28 45 50 32
11 Benissa Benissa 28 36 47 32
12 Polop Polop 28 35 57 26
13 UD Ondarense Ondarense 28 33 55 22
14 Mediterraneo CF Mediterraneo 28 40 69 19
15 Coca de Aspe Coca Aspe 28 25 86 10
16 Novelda B Novelda B 0 0 0 0
TEMPORADA 2017/2018
SEGUNDA FFCV GRUPO 7
Equipo PJ GF GC Puntos
1 Pego Pego 30 85 22 75
2 Rafelcofer Rafelcofer 30 57 31 68
3 UD Oliva UD Oliva 30 60 47 49
4 UD Altea UD Altea 30 52 39 49
5 El Campello El Campello 30 43 37 45
6 Gorgos Gorgos 30 52 54 44
7 Real de Gandia Real Gandia 30 50 55 42
8 Mutxamel Mutxamel 30 54 50 40
9 Pedreguer Pedreguer 30 50 59 37
10 UD Ondarense Ondarense 29 36 55 36
11 Benissa Benissa 30 36 57 36
12 Alginet B Alginet B 30 53 68 35
13 Orba Orba 30 43 52 33
14 Polop Polop 29 45 57 31
15 Benirredra Benirredra 30 55 77 30
16 Xeraco Xeraco 30 44 55 28
TEMPORADA 2016/2017
SEGUNDA FFCV GRUPO 7
Equipo PJ GF GC Puntos
1 C. Benidorm C. Benidorm 29 56 26 63
2 Rafelcofer Rafelcofer 28 64 34 62
3 CFI Alicante Alicante 29 79 39 59
4 San Gabriel A Gabriel 28 47 41 45
5 D. La Voz D. La Voz 29 54 49 44
6 Polop Polop 30 58 55 41
7 Real de Gandia Real Gandia 29 43 45 39
8 Xeraco Xeraco 29 33 49 39
9 UD Ondarense Ondarense 29 42 42 38
10 Pedreguer Pedreguer 28 60 50 37
11 Orba Orba 28 47 53 36
12 Mutxamel Mutxamel 29 39 37 35
13 El Campello El Campello 30 33 37 34
14 Font d'en Carròs Font d'en C. 29 35 50 30
15 CF Cullera CF Cullera 30 45 82 25
16 Jove Espanyol B Jove 30 35 81 16
TEMPORADA 2015/2016
SEGUNDA FFCV GRUPO 7
Equipo PJ GF GC Puntos
1 UD Altea UD Altea 30 73 31 73
2 San Joan San Joan 30 82 23 73
3 Pedreguer Pedreguer 30 83 44 59
4 D. La Voz D. La Voz 30 81 50 56
5 Mutxamel Mutxamel 30 63 35 51
6 Polop Polop 30 52 42 46
7 Jove Espanyol B Jove 30 70 43 45
8 Orba Orba 30 48 52 43
9 Rafelcofer Rafelcofer 30 43 56 42
10 El Campello El Campello 30 62 55 39
11 Xeraco Xeraco 30 48 40 38
12 C. Benidorm C. Benidorm 30 35 44 37
13 Real de Gandia Real Gandia 30 36 47 33
14 Benissa Benissa 30 40 45 28
15 Callosa Callosa 30 18 111 9
16 CF Gandia CF Gandia 30 15 131 7
TEMPORADA 2014/2015
SEGUNDA FFCV GRUPO 7
Equipo PJ GF GC Puntos
1 Calpe Calpe 30 71 24 70
2 UD Oliva UD Oliva 30 71 23 68
3 San Joan San Joan 30 68 18 65
4 Altet Altet 30 67 32 62
5 Rafelcofer Rafelcofer 30 54 34 54
6 Benissa Benissa 30 46 41 53
7 Mutxamel Mutxamel 29 65 34 49
8 Xeraco Xeraco 30 44 46 42
9 C. Benidorm C. Benidorm 30 45 48 42
10 Polop Polop 28 47 44 37
11 UD Altea UD Altea 30 51 57 35
12 Callosa Callosa 30 44 51 29
13 CF Gandia CF Gandia 30 33 89 22
14 Cullera B Cullera B 29 29 68 18
15 UD Ondarense Ondarense 28 23 88 15
16 Finestrat Finestrat 30 25 86 10

  USO DE MEMORIA  
5,939,024 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5661
Total Execution Time  0.5673
  CADENA URL  
/historico/Mutxamel-Cf-Senior
  GET DATOS  
$_GET['/historico/Mutxamel-Cf-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0156  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 = 'Mutxamel-Cf-Senior' 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.0147  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=46412 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0148  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=46412 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0301  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 73772
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=46412 AND type_rel = 2
0.0153  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 = '46412' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0146  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 = '46412' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0157  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 = 73772 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0162  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=46412 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0150  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 (73772,69375) 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.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 73772 AND teamId = 46412
0.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 69375 AND teamId = 46412
0.0146  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 = '46412' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0147  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 = '46412' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0159  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 = 73772 WHERE rp.league_id = 73772 AND rp.teamId = 46412 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.0155  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 = 73772 WHERE rp.league_id = 73772 AND rp.teamId = 46412 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0152  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 = 73772 WHERE rp.league_id = 73772 AND rp.teamId = 46412 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148  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 = 46412 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0152  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 = 73772 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.0153  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 = 69375 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.0154  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 = 64339 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.0150  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 = 59533 AND t.round = 13 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 62467 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 51332 AND t.round = 24 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 45236 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0170  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 = 39367 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0170  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 = 34297 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 = 16846 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 = 7090 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC