4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Caravel
TEMPORADA 2023/2024
LIGA ARUBA GRUPO 3
Equipo PJ GF GC Puntos
1 La Fama La Fama 8 49 4 24
2 SV Atlético Santa Fé Atlético 8 26 9 18
3 Jong Aruba Jong Aruba 8 13 20 12
4 Sport Boys Sport Boys 8 13 28 7
5 Caravel Caravel 8 12 30 6
6 Real Koyari Real Koyari 8 5 27 4
7 Unistars Unistars 9 33 14 21
8 Sport Club United Aruba Sport Club. 7 29 9 18
9 Bubali Bubali 8 18 4 15
10 CDRA CDRA 8 12 14 9
11 Caiquetio Caiquetio 8 13 16 9
12 Atl. Deportivo Atl. 8 3 51 0
TEMPORADA 2022/2023
LIGA ARUBA GRUPO 4
Equipo PJ GF GC Puntos
1 Bubali Bubali 10 24 7 25
2 Caiquetio Caiquetio 10 21 9 22
3 Sport Club United Aruba Sport Club. 10 27 13 18
4 CDRA CDRA 10 15 27 8
5 Brazil Juniors Brazil 10 10 26 8
6 Caravel Caravel 10 13 28 5
7 La Fama La Fama 10 36 8 27
8 SV Atlético Santa Fé Atlético 10 30 16 22
9 SV Sporting SV Sporting 10 24 14 18
10 Racing Savaneta Racing 10 19 30 9
11 Unistars Unistars 10 11 28 7
12 Estudiantes Solito Estudiantes 10 12 36 4
TEMPORADA 2021/2022
LIGA ARUBA
Equipo PJ GF GC Puntos
1 Racing Club Aruba Racing Club 18 69 9 46
2 Dakota Dakota 18 76 16 45
3 Britannia Britannia 18 46 23 34
4 La Fama La Fama 18 36 28 32
5 Deportivo Nacional Deportivo 18 61 36 26
6 Caravel Caravel 18 29 56 24
7 River Plate River Plate 18 37 37 23
8 Estrella Papilon Estrella 18 31 65 14
9 Sport Club United Aruba Sport Club. 18 35 74 11
10 Bubali Bubali 18 8 84 4
TEMPORADA 2020/2021
LIGA ARUBA
Equipo PJ GF GC Puntos
1 Racing Club Aruba Racing Club 7 15 3 17
2 Deportivo Nacional Deportivo 7 13 6 12
3 Dakota Dakota 7 15 10 12
4 La Fama La Fama 7 11 8 12
5 Britannia Britannia 7 12 11 8
6 Estrella Papilon Estrella 7 12 20 6
7 Caravel Caravel 7 8 17 4
8 Bubali Bubali 7 7 18 3
TEMPORADA 2019/2020
LIGA ARUBA
Equipo PJ GF GC Puntos
1 Racing Club Aruba Racing Club 11 23 1 31
2 Dakota Dakota 11 32 10 28
3 Deportivo Nacional Deportivo 11 42 13 18
4 Bubali Bubali 11 24 21 15
5 Estrella Papilon Estrella 11 22 20 15
6 Caravel Caravel 11 15 21 13
7 Brazil Juniors Brazil 11 24 37 13
8 Britannia Britannia 11 19 20 12
9 La Fama La Fama 11 22 21 11
10 Sport Club United Aruba Sport Club. 11 7 66 0
TEMPORADA 2016/2017
LIGA ARUBA
Equipo PJ GF GC Puntos
1 Racing Club Aruba Racing Club 16 36 21 37
2 Britannia Britannia 16 47 14 32
3 Dakota Dakota 16 35 23 28
4 Deportivo Nacional Deportivo 16 40 28 27
5 River Plate River Plate 16 22 27 21
6 Estrella Papilon Estrella 16 33 32 18
7 Bubali Bubali 16 29 50 16
8 Caravel Caravel 16 15 32 11
9 La Fama La Fama 16 20 50 10
10 Jong Aruba Jong Aruba 0 0 0 0
TEMPORADA 2015/2016
LIGA ARUBA
Equipo PJ GF GC Puntos
1 Racing Club Aruba Racing Club 18 71 13 51
2 Britannia Britannia 18 50 16 44
3 Dakota Dakota 18 51 18 39
4 Deportivo Nacional Deportivo 18 35 28 27
5 Bubali Bubali 18 34 31 26
6 River Plate River Plate 18 30 32 25
7 Estrella Papilon Estrella 18 24 33 20
8 La Fama La Fama 18 13 32 13
9 Caravel Caravel 18 17 52 10
10 San Nicolas San Nicolas 18 13 83 6
TEMPORADA 2013/2014
LIGA ARUBA GRUPO 1
Equipo PJ GF GC Puntos
1 Britannia Britannia 18 46 21 40
2 Racing Club Aruba Racing Club 18 68 17 38
3 Estrella Papilon Estrella 18 45 21 34
4 Nacional Nacional 18 39 17 33
5 Dakota Dakota 18 43 22 30
6 La Fama La Fama 18 32 38 24
7 River Plate River Plate 18 41 35 23
8 Bubali Bubali 18 15 18 22
9 Caiquetio Caiquetio 18 9 59 7
10 Caravel Caravel 18 7 97 1
TEMPORADA 2011/2012
LIGA ARUBA GRUPO 1
Equipo PJ GF GC Puntos
1 Racing Club Aruba Racing Club 18 58 13 44
2 La Fama La Fama 18 57 25 39
3 Britannia Britannia 18 53 26 36
4 Estrella Papilon Estrella 18 39 28 31
5 Bubali Bubali 18 33 25 27
6 Nacional Nacional 18 22 22 24
7 Dakota Dakota 18 27 35 21
8 River Plate River Plate 18 27 48 15
9 Caravel Caravel 18 15 53 9
10 Juventud TL Juventud TL 18 11 67 7
TEMPORADA 2010/2011
LIGA ARUBA GRUPO 1
Equipo PJ GF GC Puntos
1 Racing Club Aruba Racing Club 18 44 13 43
2 Britannia Britannia 18 57 19 41
3 Nacional Nacional 18 31 19 35
4 La Fama La Fama 18 29 23 34
5 Bubali Bubali 17 47 22 30
6 Estrella Papilon Estrella 18 28 28 23
7 Caravel Caravel 18 19 40 16
8 River Plate River Plate 18 15 34 13
9 Juventud TL Juventud TL 18 31 53 12
10 SV Sporting SV Sporting 17 12 62 4
TEMPORADA 2007/2008
LIGA ARUBA GRUPO 1
Equipo PJ GF GC Puntos
1 Britannia Britannia 18 44 12 38
2 La Fama La Fama 18 47 14 37
3 Racing Club Aruba Racing Club 18 68 23 33
4 Nacional Nacional 18 33 16 33
5 Dakota Dakota 18 25 23 30
6 Jong Aruba Jong Aruba 18 30 35 25
7 Estrella Papilon Estrella 18 33 24 24
8 River Plate River Plate 18 18 27 21
9 Caravel Caravel 18 13 71 7
10 Estudiantes Solito Estudiantes 18 17 83 4

  USO DE MEMORIA  
5,567,800 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1234
Total Execution Time  0.1255
  CADENA URL  
/historico/Caravel
  GET DATOS  
$_GET['/historico/Caravel']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0031  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 = 'Caravel' 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=80611 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=80611 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=80611 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0038  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 = 75397
0.0025  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 = 75091
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=80611 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1546 AND type_rel = 3
0.0024  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 = '80611' 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 = 75091 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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 = 75397 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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=80611 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (75397,75091) 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.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 75397 AND teamId = 80611
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 75091 AND teamId = 80611
0.0050  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 = 80611 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 75397 AND t.round = 9 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 `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 = 69257 AND t.round = 9 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 `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 = 71816 AND t.round = 10 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 = 65500 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037  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 = 62541 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.0026  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 = 51422 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.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 `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 = 37156 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 = 15945 AND t.round = 18 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 `tables2014` 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 = 26863 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 `tables2012` 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 = 26870 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 `tables2011` 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 = 26875 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 `tables2008` 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 = 26889 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC