4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CD Roda B
TEMPORADA 2023/2024
PRIMERA FFCV GRUPO 1
Equipo PJ GF GC Puntos
1 Paterna CF Paterna CF 26 46 23 53
2 Odisea FC Odisea FC 26 40 19 50
3 Mare Nostrum Puerto Sagunto Mare Nostrum 25 40 23 43
4 Moncofa Moncofa 26 41 28 41
5 CD Roda B CD Roda B 27 39 36 39
6 Benicarló Benicarló 26 44 38 37
7 Cabanes Cabanes 27 38 41 37
8 Quart de Les Valls Quart Valls 26 52 40 35
9 CF Albuixech Albuixech 26 33 36 35
10 Nules Nules 26 30 47 33
11 Vinaròs Vinaròs 25 44 51 32
12 CF Alcalá CF Alcalá 26 55 45 30
13 Ibarsos Ibarsos 25 30 52 28
14 C.F San Pedro Pedro 25 23 37 28
15 Tavernes Blanques CF Tavernes 25 33 45 26
16 Puzol Puzol 27 44 71 25
TEMPORADA 2022/2023
PRIMERA FFCV GRUPO 1
Equipo PJ GF GC Puntos
1 Soneja Soneja 34 85 22 80
2 CD Burriana CD Burriana 34 61 25 79
3 L´Alcora L´Alcora 34 88 29 73
4 UD Vall de Uxó Vall Uxó 34 67 25 69
5 Onda Onda 34 53 29 66
6 Alboraya Alboraya 34 63 40 58
7 Alqueríes CF Alqueríes 34 56 50 54
8 Almazora Almazora 34 59 51 53
9 Nou Jove Castelló Jove 34 56 61 51
10 CD Roda B CD Roda B 34 40 39 42
11 C.F San Pedro Pedro 34 52 54 40
12 Vinaròs Vinaròs 34 38 63 40
13 Ibarsos Ibarsos 34 29 59 30
14 Cabanes Cabanes 34 42 70 28
15 Moncofa Moncofa 34 24 61 24
16 Godella Godella 34 39 79 23
17 Puzol Puzol 34 32 80 23
18 Tavernes Blanques CF Tavernes 34 34 81 21
TEMPORADA 2021/2022
PRIMERA FFCV GRUPO 1
Equipo PJ GF GC Puntos
1 UD Vall de Uxó Vall Uxó 30 55 24 65
2 CD Burriana CD Burriana 30 52 27 60
3 Soneja Soneja 30 55 23 57
4 Almazora Almazora 30 65 41 54
5 Huracan Moncada Huracan 30 41 33 49
6 L´Alcora L´Alcora 30 48 42 45
7 C.F San Pedro Pedro 30 50 43 44
8 Alqueríes CF Alqueríes 30 37 35 42
9 Onda Onda 30 45 42 40
10 Vinaròs Vinaròs 30 45 50 40
11 Cabanes Cabanes 30 35 44 38
12 CD Roda B CD Roda B 30 52 50 35
13 Ibarsos Ibarsos 30 37 51 33
14 Benicarló Benicarló 30 34 57 27
15 Mare Nostrum Puerto Sagunto Mare Nostrum 30 29 55 22
16 Almenara Atlètic Almenara 30 23 86 12
TEMPORADA 2020/2021
SEGUNDA FFCV GRUPO 12
Equipo PJ GF GC Puntos
1 CD Roda B CD Roda B 6 14 5 13
2 Rafalafena Rafalafena 6 8 3 13
3 Balomp. La Cueva Balomp. 6 11 7 12
4 Betxi Betxi 6 13 13 7
5 Vall de Uxó B Vall Uxó 6 10 11 7
6 Almazora B Almazora B 6 8 9 6
7 Artana Artana 6 3 19 3
TEMPORADA 2019/2020
TERCERA FFCV GRUPO 2
Equipo PJ GF GC Puntos
1 CD Roda B CD Roda B 24 118 15 67
2 Almazora B Almazora B 24 71 26 58
3 San Pedro B San Pedro B 24 96 30 54
4 CF Juventut Almassora Juventut 24 83 46 53
5 L´Alcora B L´Alcora B 24 60 39 40
6 Drac Castellón Drac 24 52 44 37
7 E. Vila-Real B Vila-Real 24 61 53 35
8 Fomento Castellón Fomento 24 45 55 35
9 Les Palmes De Castello Palmes 24 49 39 33
10 Moro Moro 24 60 65 31
11 Alqueries B Alqueries B 24 47 63 28
12 ASFID Vila-real ASFID 24 49 76 28
13 Huracan Vila Real A Huracan Vila 24 29 61 20
14 La Plana Castello Plana 24 32 78 16
15 Andiamo Vila Real Andiamo Vila 24 34 117 8
16 Benicasim B Benicasim B 24 24 103 6
TEMPORADA 2018/2019
TERCERA FFCV GRUPO 2
Equipo PJ GF GC Puntos
1 San Lorenzo de Castellón Lorenzo 30 111 35 72
2 Balomp. La Cueva Balomp. 30 59 20 67
3 CD Roda B CD Roda B 29 103 26 62
4 L´Alcora B L´Alcora B 30 74 35 62
5 Rayo Oropesino Rayo 29 76 41 62
6 CF Juventut Almassora Juventut 30 92 65 48
7 Almazora B Almazora B 29 63 45 42
8 CD Burriana B Burriana 30 52 59 42
9 Les Palmes De Castello Palmes 30 74 57 40
10 Fomento Castellón Fomento 30 60 62 40
11 Drac Castellón Drac 30 37 91 31
12 San Agustin de Castellón Agustin 28 51 81 29
13 CD Ribera CD Ribera 30 46 83 25
14 Orpesa B Orpesa B 29 37 65 24
15 Beniganim B Beniganim B 30 28 120 16
16 Ribesalbes A Ribesalbes 30 28 106 11

  USO DE MEMORIA  
5,444,320 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.5002
Total Execution Time  0.5015
  CADENA URL  
/historico/Cd-Roda-B-Senior
  GET DATOS  
$_GET['/historico/Cd-Roda-B-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0155  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 = 'Cd-Roda-B-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.0145  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=113079 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=113079 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=113079 AND type_rel = 2
0.0147  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 = '113079' ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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 = '113079' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0149  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 = '113079' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148  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 = 73769 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0153  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=113079 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0147  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 (73769) 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.0154  SELECT count(id) as num_players from rel_players WHERE league_id = 73769 AND teamId = 113079
0.0150  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 = '113079' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '113079' and rp.type = 4
0.0150  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 = '113079' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0160  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 = 73769 WHERE rp.league_id = 73769 AND rp.teamId = 113079 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.0157  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 = 73769 WHERE rp.league_id = 73769 AND rp.teamId = 113079 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0156  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 = 73769 WHERE rp.league_id = 73769 AND rp.teamId = 113079 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0158  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 = 113079 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0315  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 = 68781 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.0156  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 = 63636 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 = 59526 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 = 62450 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.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 `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 = 51379 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.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 `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 = 45311 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC