4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del UD Paiosaco

UD Paiosaco

Entrenador: Diego Armando

Temporada 2019/2020
TEMPORADA 2019/2020
TERCERA DIVISIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 SD Compostela Compostela 27 50 15 61
2 Ourense CF Ourense CF 27 50 21 60
3 Arosa Arosa 27 42 31 47
4 Barco Barco 27 40 40 47
5 Choco Choco 27 40 28 43
6 CSD Arzua CSD Arzua 27 40 39 41
7 Deportivo Fabril Deportivo 27 38 28 40
8 Ourense UD Ourense UD 27 32 36 40
9 Arenteiro Arenteiro 27 29 31 35
10 CD Estradense Estradense 27 33 32 35
11 CD Lugo B CD Lugo B 27 51 33 35
12 Silva SD Silva SD 27 24 25 35
13 Bergantiños FC Bergantiños 27 27 31 34
14 RC Villalbés Villalbés 27 30 30 34
15 Somozas Somozas 27 31 43 32
16 Alondras CF Alondras CF 27 32 45 32
17 As Pontes As Pontes 27 39 44 28
18 Rápido de Bouzas Rápido 27 36 54 23
19 Pontellas Pontellas 27 22 56 20
20 UD Paiosaco UD Paiosaco 27 23 47 17
TEMPORADA 2018/2019
TERCERA DIVISIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Racing Ferrol Racing 38 80 35 78
2 Bergantiños FC Bergantiños 38 58 42 74
3 SD Compostela Compostela 38 80 47 68
4 Alondras CF Alondras CF 38 47 36 65
5 Barco Barco 38 58 43 64
6 Ourense CF Ourense CF 38 51 24 64
7 Choco Choco 38 59 47 59
8 Ourense UD Ourense UD 38 45 39 59
9 Arosa Arosa 38 57 44 57
10 CD Lugo B CD Lugo B 38 55 53 52
11 RC Villalbés Villalbés 38 47 48 52
12 Silva SD Silva SD 38 52 56 48
13 Arenteiro Arenteiro 38 41 53 47
14 Somozas Somozas 38 45 52 46
15 UD Paiosaco UD Paiosaco 38 46 59 45
16 Céltiga FC Céltiga FC 38 36 66 41
17 Laracha Laracha 38 42 49 40
18 Ribadumia Ribadumia 38 41 65 38
19 Boiro Boiro 38 34 79 31
20 Porriño Industrial Porriño 38 37 74 27
TEMPORADA 2017/2018
PREFERENTE GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 CD Lugo B CD Lugo B 38 83 31 79
2 UD Paiosaco UD Paiosaco 38 66 32 79
3 As Pontes As Pontes 38 85 34 77
4 Ribadeo FC Ribadeo FC 38 71 58 67
5 Dubra Dubra 38 58 45 62
6 CD Castro CD Castro 38 59 50 59
7 CSD Arzua CSD Arzua 38 51 48 56
8 At. Arteixo At. Arteixo 38 61 62 54
9 Xallas FC Xallas FC 38 48 48 51
10 AD Estudiantil Estudiantil 38 45 48 49
11 San Tirso SD Tirso 38 52 55 48
12 SD Sofán SD Sofán 38 55 61 48
13 Club Ordenes SD Club Ordenes 38 56 55 47
14 Viveiro Viveiro 38 67 69 46
15 Boimorto CF Boimorto CF 38 46 67 46
16 SDC Residencia Residencia 38 52 63 44
17 Betanzos CF Betanzos CF 38 50 66 44
18 CF Dumbría CF Dumbría 38 41 78 41
19 Atl. Escairón Atl. 38 38 67 32
20 Outeiro De Rei Outeiro 38 31 78 28
TEMPORADA 2016/2017
PREFERENTE GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 Noia Noia 38 62 34 79
2 Laracha Laracha 38 82 45 77
3 AD Estudiantil Estudiantil 38 74 38 76
4 CD Lugo B CD Lugo B 38 87 36 73
5 UD Paiosaco UD Paiosaco 38 64 41 65
6 Atl. Escairón Atl. 38 55 50 61
7 Ribadeo FC Ribadeo FC 38 65 60 60
8 Viveiro Viveiro 38 68 44 58
9 CSD Arzua CSD Arzua 38 73 40 57
10 At. Arteixo At. Arteixo 38 76 66 53
11 Xallas FC Xallas FC 38 52 48 53
12 SD Sofán SD Sofán 38 57 61 53
13 Betanzos CF Betanzos CF 38 51 49 51
14 Galicia Mugardos Galicia 38 53 55 47
15 Club Lemos Club Lemos 38 45 62 44
16 Bertamiráns FC Bertamiráns 38 40 62 39
17 SD Chantada SD Chantada 38 42 76 36
18 Soneira Sd Soneira Sd 38 46 88 35
19 SD Sarriana SD Sarriana 38 30 75 23
20 Sporting Sada Sporting 38 23 115 12
TEMPORADA 2015/2016
PREFERENTE GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 CD Castro CD Castro 38 67 31 78
2 Dubra Dubra 38 79 44 76
3 CSD Arzua CSD Arzua 38 58 40 76
4 At. Arteixo At. Arteixo 38 74 28 74
5 Bertamiráns FC Bertamiráns 38 56 31 66
6 UD Paiosaco UD Paiosaco 38 55 39 63
7 Sporting Sada Sporting 38 44 32 61
8 Viveiro Viveiro 38 62 48 56
9 Laracha Laracha 38 62 53 53
10 Club Lemos Club Lemos 38 59 48 51
11 SD Chantada SD Chantada 38 41 41 50
12 SD Sarriana SD Sarriana 38 39 41 48
13 Xallas FC Xallas FC 38 41 46 47
14 AD Estudiantil Estudiantil 38 48 52 46
15 SCD Milagrosa Milagrosa 38 41 62 44
16 SD Villestro Villestro 38 49 63 39
17 Puebla Galicia CF Puebla 38 41 64 31
18 Cidade de Ribeira CF Cidade 38 49 96 26
19 CF Dumbría CF Dumbría 38 31 86 22
20 O Val O Val 38 31 82 21
TEMPORADA 2014/2015
PRIMERA GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 UD Paiosaco UD Paiosaco 34 73 40 64
2 San Tirso SD Tirso 34 49 39 64
3 Victoria CF Victoria CF 34 72 35 62
4 Marino CF Marino CF 34 56 38 55
5 Boimorto CF Boimorto CF 34 74 59 50
6 Olimpico CF Olimpico CF 34 66 57 49
7 Cedeira SD Cedeira SD 34 47 35 48
8 Rapido de Neda Rapido Neda 34 42 44 48
9 Ud Carral Ud Carral 34 70 66 47
10 Club do Mar de Caion Club Caion 34 39 35 46
11 Orillamar SD Orillamar 34 55 52 46
12 Eume Deportivo Eume 34 63 57 45
13 Sporting Ciudad AC y D Sporting 34 59 51 43
14 Imperator OAR Imperator 34 47 50 43
15 Narón BP Narón BP 34 64 76 43
16 Meiras CF Meiras CF 34 30 66 32
17 CD Ciudad CD Ciudad 34 42 101 29
18 Cultural Maniños Cultural 34 38 85 27

  USO DE MEMORIA  
5,750,408 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.5239
Total Execution Time  0.5259
  CADENA URL  
/historico/Ud-Paiosaco-Hierros/2020
  GET DATOS  
$_GET['/historico/Ud-Paiosaco-Hierros/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0161  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 = 'Ud-Paiosaco-Hierros' AND l.year = 2020 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.0145  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=18892 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=18892 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0292  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 = 50269
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18892 AND type_rel = 2
0.0148  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 18892 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0153  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 (528523,822157,831531,886617,1223270) ORDER BY n.cover_points DESC, update_date DESC
0.0151  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 = '18892' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0150  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 = '18892' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0151  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 = 50269 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150  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=18892 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0149  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 (61804,58579) 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.0173  SELECT count(id) as num_players from rel_players WHERE league_id = 58579 AND teamId = 18892
0.0155  SELECT count(id) as num_players from rel_players WHERE league_id = 61804 AND teamId = 18892
0.0153  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 50269 AND t.round = 27 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0155  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 events2020 e ON e.player_id = p.id AND e.league_id = 50269 WHERE rp.league_id = 50269 AND rp.teamId = 18892 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.0155  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 events2020 e ON e.player_id = p.id AND e.league_id = 50269 WHERE rp.league_id = 50269 AND rp.teamId = 18892 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153  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 events2020 e ON e.player_id = p.id AND e.league_id = 50269 WHERE rp.league_id = 50269 AND rp.teamId = 18892 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148  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 = 18892 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0151  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 = 50269 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.0150  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 = 44389 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 39342 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158  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 = 34033 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 = 16696 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 = 4051 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 50269 ORDER BY nameShow LIMIT 100