4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del UJ Costa Ayala
TEMPORADA 2022/2023
1ª JUVENIL LAS PALMAS GRUPO 1
Equipo PJ GF GC Puntos
1 UJ Costa Ayala Costa Ayala 30 118 51 72
2 UD Barrial UD Barrial 30 103 61 66
3 Lomo Blanco Lomo Blanco 30 71 30 66
4 Las Mesas Las Mesas 30 93 45 64
5 Unión Viera C Unión Viera 30 81 37 61
6 Teror Teror 30 87 63 53
7 Carnevali B Carnevali B 30 95 79 50
8 San Lázaro San Lázaro 30 66 70 43
9 Atl. Gran Canaria B Atl. Gran C. 30 90 72 42
10 Veteranos del Pilar B Veteranos 30 74 72 42
11 Heidelberg Heidelberg 30 73 89 32
12 San Nicolás Nicolás 30 59 84 29
13 Victoria C Victoria C 30 41 73 25
14 Firgas Firgas 30 61 109 22
15 Acodetti C Acodetti C 30 39 116 13
16 Piletas A Piletas A 30 46 146 13
TEMPORADA 2021/2022
2ª JUVENIL LAS PALMAS GRUPO 1
Equipo PJ GF GC Puntos
1 Galdar Galdar 28 160 35 74
2 San Nicolás Nicolás 28 91 38 63
3 UJ Costa Ayala Costa Ayala 28 102 50 60
4 Roque Amagro Roque Amagro 28 77 43 60
5 Lomo Blanco Lomo Blanco 28 79 52 55
6 Goleta Goleta 28 79 52 52
7 Agaete Agaete 28 54 40 48
8 Becerril Becerril 28 91 65 44
9 Moya Moya 28 73 76 35
10 Cardones Cardones 28 61 65 30
11 Santidad Santidad 28 60 87 28
12 Sardina CF Sardina CF 28 42 98 27
13 CD Valleseco Valleseco 28 22 104 12
14 Inter del Pilar B Inter Pilar 28 39 105 11
15 Bañaderos Bañaderos 28 21 141 6

  USO DE MEMORIA  
4,648,672 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Home / Category )  0.2269
Total Execution Time  0.2285
  CADENA URL  
/historico/Union-Juventud-Costa-Ayala-Juvenil
  GET DATOS  
$_GET['/historico/Union-Juventud-Costa-Ayala-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=147621 AND type_rel = 2
0.0127  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 = '147621' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  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=147621 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (69958,66049) 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.0125  SELECT count(id) as num_players from rel_players_base WHERE league_id = 69958 AND teamId = 147621
0.0129  SELECT count(id) as num_players from rel_players_base WHERE league_id = 66049 AND teamId = 147621
0.0127  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 = '147621' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0127  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 = '147621' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0127  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 = 147621 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0129  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_base` 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 = 69958 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.0128  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_base` 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 = 66049 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