4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Sportivo Las Parejas
TEMPORADA 2023/2024
TORNEO FEDERAL A TRANSICIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 Defensores Belgrano VR Defensores 5 7 2 12
2 Sportivo Belgrano Sportivo 6 5 2 12
3 Independiente Chivilcoy Independient 5 7 3 10
4 El Linqueño Linqueño 6 2 2 9
5 Def. de Pronunciamiento Def. 6 6 10 7
6 Douglas Haig Douglas Haig 5 6 3 6
7 Sportivo Las Parejas Sportivo 5 3 4 5
8 9 de Julio Rafaela Julio 5 3 7 4
9 Gimnasia Concepción Gimnasia 5 1 7 1
TEMPORADA 2022/2023
TORNEO FEDERAL A TRANSICIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 Douglas Haig Douglas Haig 32 43 22 67
2 Independiente Chivilcoy Independient 32 31 25 49
3 Sportivo Belgrano Sportivo 32 42 34 47
4 Sportivo Las Parejas Sportivo 32 37 33 47
5 El Linqueño Linqueño 32 41 37 44
6 Def. de Pronunciamiento Def. 32 32 39 40
7 Defensores Belgrano VR Defensores 32 29 39 38
8 Unión Sunchales Unión 32 25 38 37
9 Gimnasia Concepción Gimnasia 32 24 37 33
TEMPORADA 2021/2022
TORNEO FEDERAL A TRANSICIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Racing Córdoba Racing 32 52 16 68
2 Sarm. Resistencia Sarm. 32 44 19 64
3 San Martín Formosa Martín 32 56 30 59
4 Central Norte Central 32 44 25 57
5 Gimnasia y Tiro Gimnasia 32 35 30 54
6 Douglas Haig Douglas Haig 32 42 32 48
7 Sportivo Belgrano Sportivo 32 41 34 48
8 Sportivo Las Parejas Sportivo 32 33 33 46
9 Gimnasia Concepción Gimnasia 32 33 39 44
10 Juventud Antoniana Juventud 32 34 41 40
11 Crucero del Norte Crucero 32 26 45 40
12 Boca Unidos Boca Unidos 32 34 34 37
13 Def. de Pronunciamiento Def. 32 27 40 31
14 Defensores Belgrano VR Defensores 32 24 37 30
15 Unión Sunchales Unión 32 30 48 30
16 Atlético Paraná Atlético 32 25 48 26
17 JU Gualeguaychu Gualeguaychu 32 27 56 23
TEMPORADA 2020/2021
TORNEO FEDERAL A TRANSICIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Racing Córdoba Racing 28 43 16 57
2 Gimnasia y Tiro Gimnasia 28 36 20 55
3 Central Norte Central 28 40 22 49
4 Chaco For Ever Chaco Ever 28 33 20 47
5 Sportivo Las Parejas Sportivo 28 34 28 41
6 Def. de Pronunciamiento Def. 28 32 32 38
7 JU Gualeguaychu Gualeguaychu 28 28 34 38
8 Defensores Belgrano VR Defensores 28 36 40 37
9 Sarm. Resistencia Sarm. 28 38 41 36
10 Boca Unidos Boca Unidos 28 38 36 33
11 Unión Sunchales Unión 28 28 40 30
12 Douglas Haig Douglas Haig 28 19 25 27
13 Sportivo Belgrano Sportivo 28 25 35 26
14 Gimnasia Concepción Gimnasia 28 21 42 26
15 Crucero del Norte Crucero 28 19 39 22
TEMPORADA 2019/2020
TORNEO FEDERAL A TRANSICIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 Club Atlético Güemes Club 6 10 5 15
2 Central Norte Central 6 7 6 10
3 Chaco For Ever Chaco Ever 6 8 6 9
4 Douglas Haig Douglas Haig 6 5 4 9
5 Sarm. Resistencia Sarm. 6 4 5 7
6 Def. de Pronunciamiento Def. 6 5 8 5
7 Sportivo Las Parejas Sportivo 6 6 11 3
8 Villa Mitre Bahia Blanca Villa Mitre 6 9 5 12
9 Dep. Maipú Dep. Maipú 6 7 4 10
10 Olimpo Olimpo 6 6 5 10
11 Juventud Universitario Juventud 6 8 6 8
12 Huracán Las Heras Huracán 6 4 6 7
13 Deportivo Madryn Deportivo 6 6 10 7
14 Sansinena Sansinena 6 2 6 3
TEMPORADA 2018/2019
TORNEO FEDERAL A TRANSICIÓN GRUPO 6
Equipo PJ GF GC Puntos
1 Deportivo Madryn Deportivo 8 12 5 16
2 Cipolletti Cipolletti 8 11 5 12
3 Ferro General Pico Ferro 8 12 7 11
4 Independiente Neuquén Independient 8 7 16 7
5 Dep. Roca Dep. Roca 8 5 14 6
6 Sportivo Las Parejas Sportivo 8 12 8 14
7 Def. de Pronunciamiento Def. 8 11 7 14
8 Douglas Haig Douglas Haig 8 11 7 13
9 Atlético Paraná Atlético 8 9 15 6
10 JU Gualeguaychu Gualeguaychu 8 7 13 6
11 Sportivo Estudiantes Sportivo 8 10 7 15
12 Sportivo Belgrano Sportivo 8 15 11 13
13 Racing Córdoba Racing 8 13 10 11
14 Juventud Universitario Juventud 8 8 12 10
15 San Lorenzo Alem Lorenzo Alem 8 11 17 3
16 San Martín Formosa Martín 8 14 6 17
17 Juventud Antoniana Juventud 8 8 8 11
18 Crucero del Norte Crucero 8 5 6 10
19 Altos Hornos Zapla Altos Hornos 8 5 6 9
20 Gimnasia y Tiro Gimnasia 8 4 10 8
TEMPORADA 2017/2018
TORNEO FEDERAL A TRANSICIÓN GRUPO 6
Equipo PJ GF GC Puntos
1 Deportivo Madryn Deportivo 8 10 5 17
2 Sansinena Sansinena 8 9 7 14
3 Independiente Neuquén Independient 8 7 12 9
4 Rivadavia Lincoln Rivadavia 8 9 11 8
5 Cipolletti Cipolletti 8 9 9 7
6 Huracán Las Heras Huracán 10 15 7 19
7 Unión Villa Krause Unión Villa 10 9 8 15
8 Dep. Maipú Dep. Maipú 10 15 14 13
9 San Lorenzo Alem Lorenzo Alem 10 10 13 13
10 Unión Aconquija Unión 10 9 13 10
11 Gutiérrez Gutiérrez 10 11 14 8
12 Atlético Paraná Atlético 10 15 9 18
13 Sportivo Las Parejas Sportivo 10 13 8 17
14 Def. de Pronunciamiento Def. 10 12 12 13
15 Douglas Haig Douglas Haig 10 15 19 12
16 Libertad Sunchales Libertad 10 13 16 10
17 Gimnasia Concepción Gimnasia 10 12 16 9
18 San Jorge Tucumán Jorge 10 14 9 19
19 Sportivo Patria Sportivo 10 18 14 14
20 CD Mandiyú CD Mandiyú 10 10 10 14
21 Juventud Antoniana Juventud 10 12 12 12
22 Altos Hornos Zapla Altos Hornos 10 8 11 9
23 Guaraní A. Franco Guaraní 10 10 16 8
TEMPORADA 2016/2017
TORNEO FEDERAL A TRANSICIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Unión Sunchales Unión 8 17 10 17
2 Gimnasia Mendoza Gimnasia 8 15 10 15
3 Argentino Agropecuario Argentino 8 10 9 15
4 Defensores Belgrano VR Defensores 8 11 7 14
5 Villa Mitre Bahia Blanca Villa Mitre 8 7 5 11
6 Cipolletti Cipolletti 8 7 8 10
7 Deportivo Madryn Deportivo 8 6 11 7
8 Sportivo Las Parejas Sportivo 8 5 14 5
9 Alvarado Alvarado 8 7 11 4
10 Gimnasia y Tiro Gimnasia 8 15 7 19
11 Atlético Mitre SdE Atlético 8 12 8 16
12 Sportivo Patria Sportivo 8 11 11 14
13 Sarm. Resistencia Sarm. 8 10 9 13
14 Unión Villa Krause Unión Villa 8 7 5 12
15 Unión Aconquija Unión 8 10 10 9
16 Juventud Antoniana Juventud 8 3 8 7
17 Chaco For Ever Chaco Ever 8 7 13 7
18 Altos Hornos Zapla Altos Hornos 8 5 9 4
TEMPORADA 2015/2016
TORNEO FEDERAL A GRUPO 7
Equipo PJ GF GC Puntos
1 Libertad Sunchales Libertad 12 22 16 20
2 Sportivo Las Parejas Sportivo 12 17 17 18
3 Unión Sunchales Unión 12 19 14 17
4 Def. de Pronunciamiento Def. 12 18 21 15
5 Gimnasia Concepción Gimnasia 12 17 25 13
TEMPORADA 2014/2015
TORNEO FEDERAL A GRUPO 2
Equipo PJ GF GC Puntos
1 Talleres Córdoba Talleres 18 26 12 37
2 Defensores Belgrano VR Defensores 18 26 15 30
3 Juventud Universitario Juventud 18 19 13 29
4 Unión Villa Krause Unión Villa 18 25 26 25
5 Dep. Maipú Dep. Maipú 18 18 14 24
6 9 de Julio Morteros Julio 18 19 20 23
7 Independiente Chivilcoy Independient 18 16 18 23
8 Sportivo Las Parejas Sportivo 18 22 29 21
9 Gutiérrez Gutiérrez 18 20 26 19
10 Tiro Federal Rosario Tiro Federal 18 14 32 12
TEMPORADA 2013/2014
ARGENTINO B GRUPO 7
Equipo PJ GF GC Puntos
1 Unión Sunchales Unión 18 43 17 34
2 Coronel Aguirre Coronel 18 24 18 30
3 Atlético San Jorge Atlético 18 21 21 29
4 Adelante Reconquista Adelante 18 22 28 27
5 Sportivo Las Parejas Sportivo 18 25 16 26
6 Aprendices Casildenses Aprendices 18 22 24 26
7 Sanjustino San Justo Sanjustino 18 20 28 22
8 Ben Hur Ben Hur 18 23 23 21
9 Argentino Quilmes Rafaela Argentino 18 16 26 16
10 9 de Julio Rafaela Julio 18 15 30 16
TEMPORADA 2006/2007
TORNEO REGIONAL FEDERAL AMATEUR GRUPO 3
Equipo PJ GF GC Puntos
1 Cadetes de San Martin Cadetes 2 4 4 3
2 Huracán de Comodoro Huracán 2 4 4 3
3 Juventud Alianza Juventud 2 2 2 3
4 Sportivo Las Parejas Sportivo 2 2 2 3
5 Ñuñorco Ñuñorco 2 2 2 2
6 Sarm. Resistencia Sarm. 2 2 2 2

  USO DE MEMORIA  
6,032,896 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.4694
Total Execution Time  0.4709
  CADENA URL  
/historico/Sportivo-Las-Parejas
  GET DATOS  
$_GET['/historico/Sportivo-Las-Parejas']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0223  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 = 75542
0.0109  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=16764 AND type_rel = 2
0.0117  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 16764 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0119  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 (251803,344775,861297,1118589) ORDER BY n.cover_points DESC, update_date DESC
0.0133  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 = '16764' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0118  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 = 75542 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0135  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 = 16764 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0122  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 = 75542 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0123  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 = 71107 AND t.round = 36 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0228  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 = 66957 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.0123  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 = 61891 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.0123  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 = 51042 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 60171 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.0109  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 = 45042 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 48455 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 40144 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 41925 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0214  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 = 34104 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 37687 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 20254 AND t.round = 15 ORDER BY team.conference 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 `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 = 16601 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0120  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 = 4459 AND t.round = 14 ORDER BY team.conference 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 `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 = 10882 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0120  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 = 3506 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0263  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 `tables2007` 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 = 27943 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0222  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 `tables2007` 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 = 27944 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 `tables2007` 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 = 27945 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC