4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del RC Victoria
TEMPORADA 2022/2023
PREFERENTE CANARIAS GRUPO 4
Equipo PJ GF GC Puntos
1 Unión Viera Unión Viera 30 48 19 64
2 Herbania Herbania 30 55 14 63
3 CD Valleseco Valleseco 30 44 26 60
4 Breñamen Las Playitas Breñamen 30 45 22 57
5 Playas de Sotavento Playas 30 51 36 55
6 El Cotillo El Cotillo 30 52 25 54
7 Arguineguín Arguineguín 30 48 36 49
8 CD Becerril CD Becerril 30 46 34 45
9 Doramas Doramas 30 48 49 41
10 Universitario FC Universitari 30 38 35 39
11 UD Balos UD Balos 30 32 39 36
12 Juan Grande Juan Grande 30 44 56 32
13 CD Goleta CD Goleta 30 38 57 32
14 RC Victoria RC Victoria 30 20 64 15
15 Tarajalejo Tarajalejo 30 19 77 7
16 CF Pedro Hidalgo Pedro 30 18 57 0
TEMPORADA 2021/2022
PREFERENTE CANARIAS GRUPO 1
Equipo PJ GF GC Puntos
1 Maspalomas Maspalomas 26 50 22 54
2 RC Victoria RC Victoria 26 54 26 49
3 Tahiche Tahiche 26 46 32 48
4 CD Goleta CD Goleta 26 30 25 47
5 Sporting Tías Sporting 26 46 27 46
6 San Bartolomé CF Bartolomé 26 55 20 45
7 CD Becerril CD Becerril 26 37 44 35
8 CD Ingenio CD Ingenio 26 36 43 34
9 Arguineguín Arguineguín 26 30 33 32
10 UD Balos UD Balos 26 30 33 32
11 Telde Telde 26 33 40 31
12 San Pedro Mártir Pedro 26 30 43 27
13 UD Artenara UD Artenara 26 26 71 12
14 CD Cardones CD Cardones 26 22 66 7
TEMPORADA 2020/2021
PREFERENTE CANARIAS GRUPO 1
Equipo PJ GF GC Puntos
1 Herbania Herbania 18 40 10 43
2 El Cotillo El Cotillo 18 41 11 42
3 CD Goleta CD Goleta 18 36 24 32
4 Breñamen Las Playitas Breñamen 19 34 25 31
5 RC Victoria RC Victoria 18 31 19 29
6 UD Teror UD Teror 17 35 24 29
7 UD Balos UD Balos 18 23 18 29
8 Arguineguín Arguineguín 18 24 33 25
9 Maspalomas Maspalomas 18 23 25 24
10 CD Ingenio CD Ingenio 18 20 22 19
11 CF Pedro Hidalgo Pedro 18 23 33 18
12 Valsequillo Valsequillo 18 14 29 15
13 Castillo CF Castillo CF 18 16 55 10
14 Agaete Agaete 18 13 45 8
TEMPORADA 2019/2020
PREFERENTE CANARIAS GRUPO 1
Equipo PJ GF GC Puntos
1 UD Guía UD Guía 25 46 14 62
2 Arucas Arucas 26 59 24 58
3 San Pedro Mártir Pedro 26 60 33 51
4 Estrella Estrella 26 59 37 49
5 UD Teror UD Teror 26 54 30 44
6 El Cotillo El Cotillo 25 38 22 44
7 CF Pedro Hidalgo Pedro 27 60 49 41
8 Union Sur Yaiza Union Yaiza 26 38 35 39
9 RC Victoria RC Victoria 27 48 51 38
10 Costa Ayala Costa Ayala 26 42 47 38
11 Arguineguín Arguineguín 26 29 58 32
12 Doramas Doramas 27 39 44 31
13 Tablero Tablero 26 34 40 30
14 UD San Antonio Antonio 27 36 43 30
15 CD Ingenio CD Ingenio 27 41 55 29
16 CD Becerril CD Becerril 27 25 45 28
17 Maspalomas Maspalomas 27 27 47 24
18 UD Balos UD Balos 27 33 63 23
19 Tahiche Tahiche 26 35 66 11
TEMPORADA 2018/2019
PREFERENTE CANARIAS GRUPO 1
Equipo PJ GF GC Puntos
1 Gran Tarajal Gran Tarajal 34 81 30 74
2 UD Teror UD Teror 34 76 40 73
3 Estrella Estrella 34 94 35 71
4 UD Guía UD Guía 34 58 36 61
5 Arucas Arucas 34 75 45 60
6 CF Pedro Hidalgo Pedro 34 75 53 60
7 Maspalomas Maspalomas 34 63 43 59
8 Doramas Doramas 34 69 51 53
9 UD San Antonio Antonio 34 52 41 52
10 CD Becerril CD Becerril 34 49 51 48
11 San Pedro Mártir Pedro 34 55 45 47
12 Tablero Tablero 34 56 59 46
13 UD Balos UD Balos 34 51 44 45
14 RC Victoria RC Victoria 34 43 52 36
15 Union Marina Union Marina 34 47 78 25
16 Haría CF Haría CF 34 46 86 25
17 Unión Costa Bañaderos Unión Costa 34 43 138 20
18 UD San Gregorio Gregorio 34 13 119 2
TEMPORADA 2017/2018
PREFERENTE CANARIAS GRUPO 1
Equipo PJ GF GC Puntos
1 Tamaraceite Tamaraceite 36 105 29 90
2 Unión Viera Unión Viera 36 90 28 81
3 Arucas Arucas 36 70 34 76
4 UD San Gregorio Gregorio 36 75 47 64
5 Maspalomas Maspalomas 36 62 47 60
6 CD Becerril CD Becerril 36 67 55 60
7 UD San Antonio Antonio 36 69 53 59
8 UD Balos UD Balos 36 66 59 56
9 UD Teror UD Teror 36 72 61 55
10 RC Victoria RC Victoria 36 56 48 51
11 UD Guía UD Guía 36 55 58 42
12 Doramas Doramas 36 45 50 41
13 Union Marina Union Marina 36 45 72 41
14 CF Pedro Hidalgo Pedro 36 55 79 40
15 Tahiche Tahiche 36 44 77 35
16 CD Vecinklubf Vecinklubf 36 41 74 35
17 Cerruda Cerruda 36 51 66 31
18 Telde Telde 36 29 86 17
19 Costa Ayala Costa Ayala 36 39 113 14
TEMPORADA 2016/2017
PREFERENTE CANARIAS GRUPO 1
Equipo PJ GF GC Puntos
1 UD Las Palmas C Palmas 34 99 15 87
2 Haría CF Haría CF 34 51 27 67
3 CD Vecinklubf Vecinklubf 34 64 32 64
4 Maspalomas Maspalomas 34 52 41 60
5 UD Teror UD Teror 34 66 50 50
6 CD Becerril CD Becerril 34 57 47 46
7 UD Balos UD Balos 34 45 53 45
8 UD San Antonio Antonio 34 56 60 43
9 Costa Ayala Costa Ayala 34 45 65 42
10 UD Guía UD Guía 34 45 45 41
11 RC Victoria RC Victoria 34 52 63 40
12 UD San Gregorio Gregorio 34 48 67 40
13 CF Pedro Hidalgo Pedro 34 43 58 39
14 Union Marina Union Marina 34 43 51 38
15 San Bartolomé CF Bartolomé 34 33 53 38
16 San Pedro Mártir Pedro 34 46 61 37
17 Real Sporting San José Real 34 47 64 35
18 Teguise Teguise 34 29 69 27

  USO DE MEMORIA  
5,523,640 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1175
Total Execution Time  0.1188
  CADENA URL  
/historico/Rc-Victoria-Senior
  GET DATOS  
$_GET['/historico/Rc-Victoria-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0028  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 = 'Rc-Victoria-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.0040  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 = 'Rc-Victoria-Senior' 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.0019  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=92235 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=92235 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=92235 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=92235 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=92235 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=92235 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022  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=92235 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=92235 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0036  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 = 68937
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=92235 AND type_rel = 2
0.0022  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 92235 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021  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 (310571) ORDER BY n.cover_points DESC, update_date DESC
0.0022  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 = '92235' ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '92235' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
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 = '92235' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = '92235' 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 = 68937 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  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=92235 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (68937) 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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 68937 AND teamId = 92235
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 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 = 68937 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '92235' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '92235' and rp.type = 4
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 = '92235' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0021  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 events2023 e ON e.player_id = p.id AND e.league_id = 68937 WHERE rp.league_id = 68937 AND rp.teamId = 92235 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.0021  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 events2023 e ON e.player_id = p.id AND e.league_id = 68937 WHERE rp.league_id = 68937 AND rp.teamId = 92235 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 events2023 e ON e.player_id = p.id AND e.league_id = 68937 WHERE rp.league_id = 68937 AND rp.teamId = 92235 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 = 92235 AND l.year <= 2023 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 `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 = 68937 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 `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 = 64494 AND t.round = 26 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 `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 = 59643 AND t.round = 26 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 `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 = 51277 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.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 `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 = 44764 AND t.round = 34 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 `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 = 39649 AND t.round = 38 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 `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 = 34177 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 68937 ORDER BY nameShow LIMIT 100