4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Morella
TEMPORADA 2023/2024
SEGUNDA FFCV GRUPO 1
Equipo PJ GF GC Puntos
1 Vall D'Alba Vall D'Alba 27 107 34 69
2 Betxi Betxi 26 65 39 57
3 Ripolles A Ripolles A 26 56 32 53
4 U.D. Atzeneta de Castellon U.D. 27 70 57 45
5 Almazora B Almazora B 26 57 43 44
6 Traiguera Traiguera 26 56 45 44
7 Morella Morella 25 45 35 39
8 Orpesa Orpesa 26 51 46 37
9 CF Torreblanca Torreblanca 26 56 39 35
10 Peñiscola Peñiscola 26 50 50 33
11 Rafalafena Rafalafena 27 50 60 32
12 San Pedro B San Pedro B 27 49 63 32
13 CF Villafranca Villafranca 27 39 58 27
14 Esportiu Vila Real Esportiu 27 38 56 27
15 Chert Chert 26 47 76 23
16 Cd Benicasim Benicasim 27 11 114 3
TEMPORADA 2022/2023
SEGUNDA FFCV GRUPO 1
Equipo PJ GF GC Puntos
1 Benicarló Benicarló 30 75 28 69
2 CF Alcalá CF Alcalá 30 59 30 61
3 Odisea FC Odisea FC 30 68 34 60
4 Orpesa Orpesa 29 65 44 46
5 Vall D'Alba Vall D'Alba 28 52 39 46
6 CF Torreblanca Torreblanca 30 57 53 46
7 Ripolles A Ripolles A 30 53 45 44
8 Rafalafena Rafalafena 30 48 48 42
9 Traiguera Traiguera 29 50 43 40
10 Esportiu Vila Real Esportiu 30 59 71 40
11 Cd Benicasim Benicasim 30 56 73 39
12 Morella Morella 30 40 48 34
13 Peñiscola Peñiscola 29 34 58 32
14 Almazora B Almazora B 30 47 66 27
15 Primer Toque CF Primer Toque 30 41 70 26
16 Chert Chert 29 29 83 12
TEMPORADA 2021/2022
SEGUNDA FFCV GRUPO 1
Equipo PJ GF GC Puntos
1 Nou Jove Castelló Jove 28 61 21 66
2 Traiguera Traiguera 28 63 33 58
3 Peñiscola Peñiscola 28 53 47 51
4 CF Torreblanca Torreblanca 28 37 36 44
5 Orpesa Orpesa 28 44 40 41
6 Morella Morella 28 30 25 39
7 Cd Benicasim Benicasim 28 40 35 38
8 Almazora B Almazora B 28 38 44 37
9 Ripolles A Ripolles A 28 40 49 37
10 Chert Chert 28 62 66 36
11 CF Alcalá CF Alcalá 28 53 56 35
12 Rafalafena Rafalafena 28 42 51 35
13 P. Tornesa P. Tornesa 28 35 43 31
14 Benicense Benicense 28 48 63 31
15 L´Alcora B L´Alcora B 28 31 68 15
TEMPORADA 2020/2021
SEGUNDA FFCV GRUPO 21
Equipo PJ GF GC Puntos
1 Peñiscola Peñiscola 6 15 3 16
2 Vilanova D'Alcolea Vilanova 6 16 10 13
3 CF Alcalá CF Alcalá 6 13 10 10
4 CF Borriol CF Borriol 6 9 8 7
5 Morella Morella 6 9 10 7
6 Benicense Benicense 6 7 11 7
7 Villafames Villafames 6 2 19 0
TEMPORADA 2019/2020
SEGUNDA FFCV GRUPO 1
Equipo PJ GF GC Puntos
1 Villa de Onda Villa Onda 24 80 25 57
2 P. Tornesa P. Tornesa 24 47 29 47
3 Cd Benicasim Benicasim 24 52 36 45
4 CF Torreblanca Torreblanca 24 41 31 40
5 Ibarsos Ibarsos 24 43 32 39
6 Orpesa Orpesa 23 49 34 38
7 Traiguera Traiguera 24 36 32 35
8 Vinaròs Vinaròs 24 39 39 34
9 Rafalafena Rafalafena 24 42 43 34
10 Villafames Villafames 24 61 44 33
11 Calig Calig 24 41 38 30
12 Morella Morella 23 37 42 28
13 San Lorenzo de Castellón Lorenzo 24 35 68 25
14 Balomp. La Cueva Balomp. 24 32 52 21
15 Benicense Benicense 24 34 90 12
16 CF Borriol CF Borriol 24 27 61 11
TEMPORADA 2018/2019
SEGUNDA FFCV GRUPO 1
Equipo PJ GF GC Puntos
1 CF Alcalá CF Alcalá 30 81 22 66
2 Benicense Benicense 30 73 51 58
3 P. Tornesa P. Tornesa 30 54 32 57
4 Traiguera Traiguera 30 45 35 55
5 CF Torreblanca Torreblanca 30 63 37 54
6 Ibarsos Ibarsos 30 60 47 53
7 Esportiu Vila Real Esportiu 30 61 41 49
8 Vinaròs Vinaròs 30 60 47 49
9 Villafames Villafames 30 42 41 39
10 Orpesa Orpesa 30 45 54 38
11 Morella Morella 30 29 47 36
12 Cd Benicasim Benicasim 30 61 76 33
13 E. Castellon A Castellon 30 43 59 32
14 Benicarlo B Benicarlo B 30 41 65 25
15 San Pedro B San Pedro B 30 36 71 24
16 Moro A Moro A 30 35 104 3
TEMPORADA 2017/2018
SEGUNDA FFCV GRUPO 1
Equipo PJ GF GC Puntos
1 Cabanes Cabanes 30 60 22 69
2 Rafalafena Rafalafena 30 67 28 66
3 E. Castellon A Castellon 30 63 39 61
4 Ibarsos Ibarsos 30 55 50 50
5 Morella Morella 30 41 36 46
6 Villafames Villafames 30 57 56 46
7 Moro A Moro A 30 42 42 44
8 Orpesa Orpesa 30 53 56 44
9 Traiguera Traiguera 30 43 45 41
10 Cd Benicasim Benicasim 30 59 62 39
11 Betxi Betxi 30 55 63 37
12 P. Tornesa P. Tornesa 30 35 49 36
13 Benicarlo B Benicarlo B 30 46 66 34
14 Onda B Onda B 30 49 58 24
15 Peñiscola Peñiscola 30 49 67 24
16 Vinroma Vinroma 30 30 65 20
TEMPORADA 2016/2017
SEGUNDA FFCV GRUPO 1
Equipo PJ GF GC Puntos
1 Sant Jordi Sant Jordi 30 86 20 74
2 Orpesa Orpesa 30 62 33 60
3 Rafalafena Rafalafena 30 58 40 57
4 Ibarsos Ibarsos 30 63 39 52
5 Onda B Onda B 30 69 42 50
6 Vinroma Vinroma 30 42 40 46
7 Morella Morella 30 50 36 44
8 Villafames Villafames 30 39 43 41
9 Traiguera Traiguera 30 51 56 41
10 Cabanes Cabanes 30 51 48 40
11 Benicassim Benicassim 30 46 58 39
12 Catí Catí 30 56 64 37
13 Moro A Moro A 30 47 57 32
14 Semprerapid A Semprerapid 30 41 83 30
15 Benicense Benicense 30 46 79 26
16 Vinaròs Vinaròs 30 21 90 7
TEMPORADA 2015/2016
SEGUNDA FFCV GRUPO 1
Equipo PJ GF GC Puntos
1 CD Roda CD Roda 30 81 31 68
2 Ibarsos Ibarsos 30 62 36 67
3 San Jorge San Jorge 30 68 19 65
4 Orpesa Orpesa 30 57 48 48
5 Rafalafena Rafalafena 30 63 53 46
6 Traiguera Traiguera 30 61 46 43
7 Benicense Benicense 30 42 55 39
8 Catí Catí 30 43 48 39
9 San Mateo San Mateo 30 32 46 38
10 Morella Morella 30 50 65 36
11 Onda B Onda B 30 46 74 34
12 Vinroma Vinroma 30 35 39 34
13 Cabanes Cabanes 30 37 53 34
14 Calig Calig 30 51 61 33
15 San Pedro B San Pedro B 30 39 57 27
16 P. Tornesa P. Tornesa 30 34 70 20
TEMPORADA 2014/2015
SEGUNDA FFCV GRUPO 1
Equipo PJ GF GC Puntos
1 CF Alcalá CF Alcalá 30 77 26 71
2 Traiguera Traiguera 30 57 32 52
3 Orpesa Orpesa 30 54 36 52
4 San Jorge San Jorge 30 43 37 46
5 Benicense Benicense 30 51 41 45
6 San Pedro B San Pedro B 30 51 46 45
7 P. Tornesa P. Tornesa 30 45 41 42
8 Ibarsos Ibarsos 30 47 54 42
9 Calig Calig 30 48 53 41
10 Cabanes Cabanes 30 40 53 41
11 Morella Morella 30 41 46 40
12 Catí Catí 30 60 69 38
13 San Mateo San Mateo 30 34 52 34
14 Benasal Benasal 30 46 72 31
15 Borriol B Borriol B 29 36 50 29
16 Cinctorra Cinctorra 29 35 57 22

  USO DE MEMORIA  
5,825,000 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Home / Category )  0.0995
Total Execution Time  0.1010
  CADENA URL  
/historico/Morella-Fc-Senior
  GET DATOS  
$_GET['/historico/Morella-Fc-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0027  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 = 'Morella-Fc-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.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=46001 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=46001 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=46001 AND type_rel = 2
0.0021  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 = '46001' ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '46001' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
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 = '46001' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = 73804 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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=46001 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (73804) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 73804 AND teamId = 46001
0.0022  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 = '46001' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
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 = '46001' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0022  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 = 73804 WHERE rp.league_id = 73804 AND rp.teamId = 46001 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.0020  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 = 73804 WHERE rp.league_id = 73804 AND rp.teamId = 46001 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  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 = 73804 WHERE rp.league_id = 73804 AND rp.teamId = 46001 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 46001 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0024  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 = 73804 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 69369 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.0023  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 = 64332 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.0022  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 = 59525 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.0020  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 = 62459 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.0023  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 = 51326 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.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 `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 = 45230 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 39361 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 34291 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 16839 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 7076 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC