4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Ibarsos
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 11
Equipo PJ GF GC Puntos
1 Vinaròs Vinaròs 6 13 5 14
2 CF Torreblanca Torreblanca 6 12 4 12
3 Ibarsos Ibarsos 6 13 5 9
4 Orpesa Orpesa 6 10 12 7
5 Traiguera Traiguera 6 7 16 7
6 Cd Benicasim Benicasim 6 4 11 5
7 Calig Calig 6 5 11 2
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
TEMPORADA 1989/1990
TERCERA DIVISIÓN GRUPO 6
Equipo PJ GF GC Puntos
1 Torrent Torrent 34 46 17 53
2 Valencia Mestalla Valencia 34 82 23 51
3 CD Burriana CD Burriana 34 54 20 48
4 Onda Onda 34 70 27 47
5 SD Sueca SD Sueca 34 55 37 43
6 Betxi Betxi 34 51 38 40
7 Ribarroja CF Ribarroja 34 46 31 39
8 Nules Nules 34 52 36 38
9 UD Vall de Uxó Vall Uxó 34 61 47 37
10 Lliria UD Lliria UD 34 59 55 33
11 Racing D´ Algemesí Racing 34 41 52 28
12 Alaquas I Walter A Alaquas 34 31 50 28
13 CD Acero CD Acero 34 33 55 27
14 Vinaròs Vinaròs 34 25 44 26
15 At. Saguntino Saguntino 34 29 58 25
16 Ibarsos Ibarsos 34 31 80 21
17 Foios Foios 34 23 59 20
18 SC Requena SC Requena 34 15 75 8

  USO DE MEMORIA  
6,127,496 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.0922
Total Execution Time  0.0934
  CADENA URL  
/historico/Cd-Els-Ibarsos-Senior
  GET DATOS  
$_GET['/historico/Cd-Els-Ibarsos-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0026  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-Els-Ibarsos-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=46000 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=46000 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041  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 = 73769
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=46000 AND type_rel = 2
0.0021  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 = '46000' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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.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=46000 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 (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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 73769 AND teamId = 46000
0.0030  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 = 46000 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.0030  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 = 46000 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 46000 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 = 46000 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73769 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.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 `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.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 `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.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 = 62449 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.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 `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.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 `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.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 `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.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 `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.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 `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.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 `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
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 `tables1990` 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 = 21819 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC