4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Santa Marta
TEMPORADA 2019/2020
1ª REGIONAL EXTREMADURA GRUPO 2
Equipo PJ GF GC Puntos
1 Pueblonuevo Pueblonuevo 25 51 19 54
2 CP Oliva CP Oliva 25 39 23 52
3 AD Lobón AD Lobón 25 49 24 48
4 CD Badajoz B Badajoz 25 40 19 43
5 CD Gévora CD Gévora 24 37 24 42
6 Sanvicenteño Sanvicenteñ 25 43 36 35
7 Valdelacalzada Valdelacalza 25 38 43 35
8 UD Talavera UD Talavera 24 34 39 35
9 Santa Marta Santa Marta 25 34 29 33
10 Guadiana Guadiana 24 30 29 33
11 Villar del Rey Industrial Villar 24 41 42 33
12 Alburquerque Alburquerque 24 32 38 30
13 CP Cheles CP Cheles 24 34 42 25
14 CF San Jorge Jorge 24 29 41 19
15 La Albuera-Faesal Albuera-Faes 24 24 53 18
16 Codosera CF Codosera CF 25 22 76 9
TEMPORADA 2018/2019
1ª REGIONAL EXTREMADURA GRUPO 2
Equipo PJ GF GC Puntos
1 AD Lobón AD Lobón 30 53 26 62
2 CD San Serván Serván 30 40 18 60
3 Villar del Rey Industrial Villar 30 49 39 54
4 CD Badajoz B Badajoz 30 61 35 53
5 Guadiana Guadiana 30 55 34 53
6 Santa Marta Santa Marta 30 40 37 48
7 Codosera CF Codosera CF 30 39 40 42
8 CP Oliva CP Oliva 30 37 31 41
9 UD Talavera UD Talavera 30 42 41 38
10 Sanvicenteño Sanvicenteñ 30 36 48 36
11 Alburquerque Alburquerque 30 26 39 35
12 CP Cheles CP Cheles 30 26 40 31
13 CD Gévora CD Gévora 30 28 43 29
14 EF Puebla de la Calzada Puebla 30 24 41 26
15 La Albuera-Faesal Albuera-Faes 30 17 34 25
16 Santa Teresa A Santa Teresa 30 33 60 21
TEMPORADA 2017/2018
1ª REGIONAL EXTREMADURA GRUPO 3
Equipo PJ GF GC Puntos
1 AD Llerenense Llerenense 30 75 27 64
2 Villafranca Villafranca 30 71 29 58
3 UD Frexnense Frexnense 30 52 33 57
4 UC La Estrella Estrella 30 63 38 56
5 UD Fuente de Cantos Fuente 30 66 37 55
6 CD San Serván Serván 30 53 38 51
7 Campanario Campanario 30 46 33 49
8 CD Berlanga CD Berlanga 30 63 52 42
9 Sp Ribereña Ribereña 30 44 48 42
10 Guareña Guareña 30 46 55 40
11 Santa Marta Santa Marta 30 49 62 38
12 Atlético Torremejía Atlético 30 42 55 35
13 Ilipense-Zalamea S. Ilipense-Zal 30 48 70 34
14 Monesterio Monesterio 30 44 84 24
15 Usagre Usagre 30 37 73 22
16 CD Quintana CD Quintana 30 23 88 10
TEMPORADA 2016/2017
1ª REGIONAL EXTREMADURA GRUPO 2
Equipo PJ GF GC Puntos
1 UD Talavera UD Talavera 30 55 32 54
2 Alburquerque Alburquerque 30 47 39 53
3 EMD Aceuchal Aceuchal 30 61 35 52
4 Guadiana Guadiana 30 49 36 49
5 Valdelacalzada Valdelacalza 30 54 39 47
6 Sanvicenteño Sanvicenteñ 30 32 20 47
7 Racing Valverdeño Racing 30 44 34 47
8 CD Badajoz B Badajoz 30 41 43 44
9 AD Lobón AD Lobón 30 43 40 41
10 CD Gévora CD Gévora 30 42 49 40
11 CP Oliva CP Oliva 30 31 47 40
12 CP Cheles CP Cheles 30 31 36 39
13 EF Puebla de la Calzada Puebla 30 46 53 35
14 Santa Marta Santa Marta 30 33 56 31
15 Deportivo Pacense Deportivo 30 34 61 26
16 Gran Maestre Gran Maestre 30 40 63 22
TEMPORADA 2015/2016
1ª REGIONAL EXTREMADURA GRUPO 2
Equipo PJ GF GC Puntos
1 Gran Maestre Gran Maestre 21 53 21 46
2 Santa Marta Santa Marta 21 53 28 41
3 Almendralejo A Almendralejo 21 45 37 36
4 UD Frexnense Frexnense 21 39 28 36
5 La Albuera-Faesal Albuera-Faes 21 35 20 34
6 Higuera CF Higuera CF 21 46 47 31
7 UD Bienvenida Bienvenida 20 38 41 28
8 Hernando De Soto Hernando 20 38 38 21
9 Atlético Torremejía Atlético 21 36 51 21
10 Segureña A Segureña A 20 42 45 20
11 Extremadura B Extremadura 10 13 13 17
12 San Jose Promesas B Jose 21 20 89 4
TEMPORADA 2014/2015
1ª REGIONAL EXTREMADURA GRUPO 1
Equipo PJ GF GC Puntos
1 CD Badajoz B Badajoz 20 66 21 47
2 Atletico Club Pueblonuevo B Atletico 20 51 26 46
3 La Albuera-Faesal Albuera-Faes 20 39 15 43
4 Santa Marta Santa Marta 20 58 19 41
5 AD Lobón AD Lobón 20 34 22 37
6 San Francisco de Olivenza Francisco 20 34 46 23
7 Villar del Rey Industrial Villar 20 28 47 22
8 Obandina AD Obandina AD 20 37 51 21
9 Peña el Valle Peña Valle 20 24 38 20
10 Codosera CF Codosera CF 20 26 45 13
11 Valencia de Alcantara Valencia 20 15 82 6
12 Higuera de Vargas A Higuera 0 0 0 0

  USO DE MEMORIA  
5,307,576 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0918
Total Execution Time  0.0937
  CADENA URL  
/historico/Santa-Marta-A/2020
  GET DATOS  
$_GET['/historico/Santa-Marta-A/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
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 = 'Santa-Marta-A' 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.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=30041 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=30041 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=30041 AND type_rel = 2
0.0026  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 = '30041' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0027  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 = '30041' 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 = 51307 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0029  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=30041 AND l.year in (2019,2020,2021) 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 (62272) 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.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 62272 AND teamId = 30041
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 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 = 51307 AND t.round = 25 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0023  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 = '30041' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '30041' and rp.type = 4
0.0027  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 = '30041' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0045  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 = 51307 WHERE rp.league_id = 51307 AND rp.teamId = 30041 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.0038  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 = 51307 WHERE rp.league_id = 51307 AND rp.teamId = 30041 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0034  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 = 51307 WHERE rp.league_id = 51307 AND rp.teamId = 30041 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 30041 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 51307 AND t.round = 25 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 `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 = 44629 AND t.round = 30 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 `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 = 39346 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 34428 AND t.round = 30 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 `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 = 16782 AND t.round = 22 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 = 51307 ORDER BY nameShow LIMIT 100