4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Cd Arguijón
TEMPORADA 2023/2024
1ª REGIONAL CANARIAS GRUPO 5
Equipo PJ GF GC Puntos
1 Atlético Restinga Atlético 25 70 28 63
2 UD Rambla UD Rambla 26 52 23 55
3 Atl. Perdoma Atl. Perdoma 27 56 28 52
4 Tacoronte CF Tacoronte 25 48 30 51
5 CD Valle Guerra Valle Guerra 26 51 31 49
6 Ud Valle Frontera Valle 26 50 44 43
7 Santa Úrsula B Santa 26 47 39 42
8 Taco San Luis Taco Luis 25 59 47 39
9 UD Tacoronte Tacoronte 26 34 40 33
10 Cd Arguijón Arguijón 27 37 54 30
11 CD Alirón Tegueste Alirón 26 34 35 29
12 Atletico Pinar El Hierro Atletico 26 28 44 28
13 Verdellada Verdellada 25 29 42 23
14 CF Sporting San José Sporting 26 26 64 21
15 CD Buenavista Buenavista 25 30 65 14
16 CD Juventud Silense Juventud 25 22 59 10
TEMPORADA 2022/2023
1ª REGIONAL CANARIAS GRUPO 6
Equipo PJ GF GC Puntos
1 Guargacho Guargacho 32 77 16 74
2 Charco del Pino Charco Pino 33 70 32 71
3 Taco San Luis Taco Luis 32 86 43 67
4 At. Granadilla Granadilla 32 60 39 61
5 Santos Reyes Santos Reyes 32 58 47 50
6 Unión Isora Unión Isora 32 60 63 48
7 AU Guimar B AU Guimar B 32 67 62 42
8 UD Gomera UD Gomera 32 48 53 42
9 CD El Roque CD El Roque 32 39 43 41
10 Raqui San Isidro Raqui Isidro 32 49 44 38
11 Santiago del Teide Santiago 32 41 53 38
12 Arafo FEM Arafo FEM 32 60 60 36
13 Atletico Chenet Atletico 32 39 63 35
14 Nast Costa Isora Nast Costa. 32 45 52 34
15 CD Igueste CD Igueste 32 38 61 30
16 Cd Arguijón Arguijón 32 37 93 24
17 SD Valleseco Valleseco 32 43 90 20
18 Atlético Alcalá Atlético 1 0 3 0
TEMPORADA 2021/2022
PREFERENTE CANARIAS GRUPO 3
Equipo PJ GF GC Puntos
1 Atlético Tacoronte Atlético 24 57 10 62
2 CD Laguna CD Laguna 24 61 19 50
3 Llanos Aridane Llanos 24 39 19 46
4 CD Candela CD Candela 24 30 22 35
5 CD Sauzal CD Sauzal 24 33 38 31
6 Unión Tejina Unión 24 32 39 30
7 UD Tacoronte Tacoronte 24 18 26 28
8 Real Unión de Tenerife Real Unión 24 30 32 27
9 CD San Andrés Andrés 24 23 31 27
10 Atlético San Juan Atlético 24 20 32 27
11 CD Ofra CD Ofra 24 26 47 23
12 Zamorano Esperanza Zamorano 24 28 44 20
13 Cd Arguijón Arguijón 24 17 55 14
TEMPORADA 2020/2021
PREFERENTE CANARIAS GRUPO 3
Equipo PJ GF GC Puntos
1 CD Laguna CD Laguna 12 32 7 32
2 Cd Arguijón Arguijón 13 25 18 28
3 CD Guancha CD Guancha 10 17 7 19
4 Unión Tejina Unión 13 13 17 15
5 CD Sauzal CD Sauzal 9 16 11 13
6 Puerto Cruz Puerto Cruz 7 9 7 12
7 La Florida La Florida 10 23 26 11
8 UD Cruz Santa Cruz Santa 7 13 12 10
9 CD Buenavista Buenavista 7 10 14 8
10 Zamorano Esperanza Zamorano 8 8 12 8
11 Isora CF Isora CF 7 8 12 7
12 UD Tacoronte Tacoronte 5 7 13 3
13 Orotava Orotava 7 6 16 3
14 UD Icodense UD Icodense 7 7 22 1
TEMPORADA 2018/2019
PREFERENTE CANARIAS GRUPO 2
Equipo PJ GF GC Puntos
1 Vera Vera 34 67 35 75
2 Atletico Victoria Atletico 34 72 24 71
3 UD Cruz Santa Cruz Santa 34 57 29 66
4 San Lorenzo Constancia Lorenzo 34 59 43 58
5 Atlético San Juan Atlético 34 62 60 54
6 UD Icodense UD Icodense 34 57 54 52
7 AD Añaza AD Añaza 34 61 58 51
8 Puerto Cruz Puerto Cruz 34 63 43 50
9 Orotava Orotava 34 66 47 49
10 Unión Tejina Unión 34 69 55 49
11 At. Granadilla Granadilla 34 52 49 47
12 CD Águilas CD Águilas 34 55 54 47
13 CD Guancha CD Guancha 34 46 50 44
14 CD Marino B CD Marino B 34 52 58 42
15 La Florida La Florida 34 39 46 31
16 I'Gara I'Gara 34 52 92 28
17 Cd Arguijón Arguijón 34 30 89 21
18 Ud Valle Frontera Valle 34 25 98 17
TEMPORADA 2014/2015
PREFERENTE CANARIAS GRUPO 2
Equipo PJ GF GC Puntos
1 CD Buzanada CD Buzanada 36 62 27 71
2 Raqui San Isidro Raqui Isidro 36 75 49 71
3 UD Cruz Santa Cruz Santa 36 55 38 65
4 UD Gomera UD Gomera 36 40 25 59
5 Charco del Pino Charco Pino 36 48 41 55
6 San Lorenzo Constancia Lorenzo 36 73 65 54
7 Atlético Tacoronte Atlético 36 44 39 52
8 Orotava Orotava 36 49 48 48
9 Águilas Águilas 36 46 49 48
10 AU Güímar AU Güímar 36 72 66 47
11 Atlético San Juan Atlético 36 64 56 46
12 CD San Andrés Andrés 36 51 55 46
13 I'Gara I'Gara 36 49 51 45
14 UD Icodense UD Icodense 36 53 67 45
15 Realejos Realejos 36 40 48 42
16 CD Valle Guerra Valle Guerra 36 42 60 40
17 UD Hidalgo UD Hidalgo 36 50 63 35
18 Cd Arguijón Arguijón 36 35 59 30
19 Ud Valle Frontera Valle 36 37 79 29
TEMPORADA 2013/2014
PREFERENTE CANARIAS GRUPO 2
Equipo PJ GF GC Puntos
1 Realejos B Realejos B 34 73 39 69
2 CD San Andrés Andrés 34 46 28 69
3 CD Valle Guerra Valle Guerra 34 58 37 60
4 CD Laguna CD Laguna 34 48 23 59
5 CD Santa Úrsula Santa 34 50 40 59
6 CD Atlético Paso Atlético 34 52 34 56
7 Ud Orotava Ud Orotava 34 46 42 51
8 CD Buzanada CD Buzanada 34 49 51 46
9 Atlético Tacoronte Atlético 34 50 61 41
10 Llanos Aridane Llanos 33 35 42 39
11 Charco del Pino Charco Pino 34 33 39 38
12 Atlético San Juan Atlético 34 46 52 37
13 UD Fuencaliente Fuencaliente 34 45 54 37
14 Cd Arguijón Arguijón 34 38 61 37
15 UD Icodense UD Icodense 34 46 70 36
16 Ud Valle Frontera Valle 34 38 49 35
17 San Andrés y Sauces Andrés 33 39 57 33
18 Zona Norte Zona Norte 34 52 65 31
TEMPORADA 2012/2013
PREFERENTE CANARIAS GRUPO 2
Equipo PJ GF GC Puntos
1 Realejos Realejos 34 72 38 69
2 CD San Andrés Andrés 34 46 28 69
3 CD Laguna CD Laguna 34 48 23 59
4 Cd Santa Úrsula Santa 33 50 40 58
5 CD Valle Guerra Valle Guerra 33 55 37 57
6 CD Atlético Paso Atlético 33 52 35 55
7 Ud Orotava Ud Orotava 34 45 41 51
8 CD Buzanada CD Buzanada 34 49 51 46
9 Atlético Tacoronte Atlético 34 51 61 41
10 Atlético San Juan Atlético 33 45 48 37
11 Charco del Pino Charco Pino 34 32 41 37
12 Cd Arguijón Arguijón 33 38 58 37
13 Llanos Aridane Llanos 32 33 41 36
14 UD Icodense UD Icodense 34 46 70 36
15 Ud Valle Frontera Valle 33 37 47 35
16 Ud Ibarra Ud Ibarra 33 39 56 35
17 UD Fuencaliente Fuencaliente 33 42 53 34
18 UD Norte UD Norte 34 51 63 31
TEMPORADA 2011/2012
PREFERENTE CANARIAS GRUPO 2
Equipo PJ GF GC Puntos
1 Raqui San Isidro Raqui Isidro 34 62 39 70
2 UD Gomera UD Gomera 34 75 35 69
3 Lauburu Ke Ibarra Lauburu 34 72 37 68
4 Orotava Orotava 34 62 32 67
5 CD Santa Úrsula Santa 34 44 37 51
6 At. Paso At. Paso 34 49 44 51
7 UD Icodense UD Icodense 34 51 49 50
8 CD San Andrés Andrés 34 45 44 50
9 Llanos Aridane Llanos 34 46 43 47
10 Ud Valle Frontera Valle 34 39 37 46
11 Zona Norte Zona Norte 34 55 70 42
12 UD Fuencaliente Fuencaliente 34 49 51 39
13 Realejos Realejos 34 34 41 38
14 CD Valle Guerra Valle Guerra 34 43 54 37
15 Cd Arguijón Arguijón 34 32 51 37
16 CD Victoria Tazacorte Victoria 34 41 57 35
17 Tegueste Tegueste 34 43 55 33
18 Ud Médano Ud Médano 34 25 91 17

  USO DE MEMORIA  
5,854,392 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0907
Total Execution Time  0.0919
  CADENA URL  
/historico/Cd-Arguijon
  GET DATOS  
$_GET['/historico/Cd-Arguijon']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0042  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 = 73643
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6140 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2523 AND type_rel = 3
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 = '6140' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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 = 73643 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=6140 AND l.year in (2023,2024,2025) 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 (73643) 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.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 73643 AND teamId = 6140
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 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 = 73643 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '6140' 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 = '6140' and rp.type = 4
0.0021  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 = '6140' 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 events2024 e ON e.player_id = p.id AND e.league_id = 73643 WHERE rp.league_id = 73643 AND rp.teamId = 6140 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 events2024 e ON e.player_id = p.id AND e.league_id = 73643 WHERE rp.league_id = 73643 AND rp.teamId = 6140 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 = 73643 WHERE rp.league_id = 73643 AND rp.teamId = 6140 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 6140 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73643 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.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 `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 = 69587 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.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 = 64496 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.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 = 59645 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.0032  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 = 44766 AND t.round = 34 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 `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 = 4084 AND t.round = 38 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 `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 = 2687 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 `tables2013` 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 = 1995 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 `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 = 1472 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 73643 ORDER BY nameShow LIMIT 100