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

CA Manucci

Entrenador: Milton Mendes

Temporada 2019/2020
TEMPORADA 2019/2020
PERÚ - LIGA 1 FASE 2
Equipo PJ GF GC Puntos
1 Sporting Cristal Sporting 9 20 9 23
2 Univ. San Martín Univ. 9 12 10 16
3 UTC Cajamarca Cajamarca 9 18 9 14
4 Cienciano Cienciano 9 12 11 14
5 Deportivo Binacional Deportivo 9 11 13 13
6 Universitario de Deportes Universitari 9 12 17 11
7 Carlos Stein Carlos Stein 9 12 16 10
8 Atlético Grau Atlético 9 9 12 9
9 Alianza Universidad Alianza 9 8 13 8
10 Academia Cantolao Academia 9 11 15 6
11 Ayacucho FC Ayacucho FC 9 14 5 20
12 Univ. César Vallejo Univ. César 9 16 7 18
13 CA Manucci CA Manucci 9 13 7 16
14 Cusco FC Cusco FC 9 13 10 15
15 FBC Melgar FBC Melgar 9 18 14 13
16 Sport Boys Association Sport Boys. 9 10 18 12
17 Deportivo Llacuabamba Deportivo 9 16 21 10
18 Deportivo Municipal Deportivo 9 9 14 9
19 Sport Huancayo Sport 9 9 15 9
20 Alianza Lima Alianza Lima 9 9 16 4
TEMPORADA 2018/2019
PERÚ - LIGA 1 FASE 1
Equipo PJ GF GC Puntos
1 Deportivo Binacional Deportivo 17 44 23 36
2 Sporting Cristal Sporting 17 28 13 32
3 Univ. César Vallejo Univ. César 17 25 21 29
4 Deportivo Municipal Deportivo 17 27 20 27
5 Alianza Lima Alianza Lima 17 30 24 26
6 Cusco FC Cusco FC 17 19 15 26
7 Ayacucho FC Ayacucho FC 17 26 23 25
8 UTC Cajamarca Cajamarca 17 26 24 25
9 Academia Cantolao Academia 17 18 17 25
10 Sport Huancayo Sport 17 22 23 24
11 FBC Melgar FBC Melgar 17 26 25 23
12 Universitario de Deportes Universitari 17 25 27 23
13 Alianza Universidad Alianza 17 18 18 22
14 CA Manucci CA Manucci 17 22 27 16
15 Unión Comercio Unión 17 15 21 15
16 Univ. San Martín Univ. 17 13 32 15
17 Pirata FC Pirata FC 17 17 29 13
18 Sport Boys Association Sport Boys. 17 9 28 10
TEMPORADA 2017/2018
PERÚ - LIGA 2
Equipo PJ GF GC Puntos
1 Univ. César Vallejo Univ. César 28 53 21 59
2 Cienciano Cienciano 28 63 30 55
3 CA Manucci CA Manucci 28 65 33 52
4 Union Huaral Union Huaral 28 58 39 48
5 Deportivo Hualgayo Deportivo 28 49 38 48
6 Juan Aurich Chiclayo Juan Aurich 28 51 27 47
7 Alianza Atl. Sullana Alianza Atl. 28 48 37 47
8 Atlético Grau Atlético 28 58 42 42
9 Deportivo Coopsol Deportivo 28 46 32 37
10 Los Chankas Los Chankas 28 38 36 37
11 Los Caimanes Caimanes 28 38 57 27
12 Alfredo Salinas Alfredo 28 30 63 27
13 Sport Victoria Sport 28 34 54 25
14 Sport Loreto Sport Loreto 28 38 68 24
15 Willy Serrato Willy 28 23 115 10
TEMPORADA 2016/2017
PERÚ - LIGA 2
Equipo PJ GF GC Puntos
1 Univ. César Vallejo Univ. César 28 76 29 57
2 Sport Boys Association Sport Boys. 28 54 23 57
3 Deportivo Hualgayo Deportivo 28 70 44 48
4 Cienciano Cienciano 28 61 41 47
5 Union Huaral Union Huaral 28 56 57 45
6 Los Chankas Los Chankas 28 42 27 44
7 CA Manucci CA Manucci 28 53 38 41
8 Sport Victoria Sport 28 36 44 37
9 Deportivo Coopsol Deportivo 27 45 46 35
10 Sport Loreto Sport Loreto 28 39 48 33
11 Alfredo Salinas Alfredo 27 41 53 29
12 Willy Serrato Willy 28 33 68 24
13 Los Caimanes Caimanes 28 41 59 22
14 Defensor La Bocana Defensor 28 49 73 20
15 Sport Ancash Huaraz Sport Ancash 28 27 73 13
TEMPORADA 2015/2016
PERÚ - LIGA 2
Equipo PJ GF GC Puntos
1 Academia Cantolao Academia 30 45 31 53
2 Sport Ancash Huaraz Sport Ancash 30 53 44 53
3 Cienciano Cienciano 30 48 26 52
4 CA Manucci CA Manucci 30 47 31 50
5 Deportivo Coopsol Deportivo 30 39 26 50
6 Los Chankas Los Chankas 30 42 40 46
7 Alianza Universidad Alianza 30 35 24 45
8 Alfredo Salinas Alfredo 30 57 36 43
9 Los Caimanes Caimanes 30 39 37 42
10 Sport Loreto Sport Loreto 30 39 41 36
11 Sport Victoria Sport 30 39 53 36
12 Union Huaral Union Huaral 30 38 50 33
13 Willy Serrato Willy 30 36 53 32
14 Sport Boys Association Sport Boys. 30 41 32 31
15 Club Atletico Torino Club 30 31 41 28
16 Unión Tarapoto Unión 30 8 72 10
TEMPORADA 2014/2015
PERÚ - LIGA 2
Equipo PJ GF GC Puntos
1 Comerciantes Unidos Comerciantes 22 46 33 45
2 Los Caimanes Caimanes 22 34 26 41
3 Club Atletico Torino Club 22 30 24 37
4 Sport Boys Association Sport Boys. 22 36 24 34
5 Deportivo Coopsol Deportivo 22 34 28 34
6 Willy Serrato Willy 22 30 27 34
7 Alianza Universidad Alianza 22 36 24 31
8 Union Huaral Union Huaral 22 26 26 30
9 Sport Victoria Sport 22 28 31 23
10 CA Manucci CA Manucci 22 24 32 23
11 San Simón San Simón 22 14 39 17
12 Atlético Minero Atlético 22 15 39 15
TEMPORADA 2013/2014
PERÚ - LIGA 2
Equipo PJ GF GC Puntos
1 Deportivo Municipal Deportivo 30 49 29 61
2 Deportivo Coopsol Deportivo 30 53 26 58
3 CA Manucci CA Manucci 30 46 32 55
4 Alianza Universidad Alianza 30 51 30 53
5 Willy Serrato Willy 30 44 37 46
6 Union Huaral Union Huaral 30 38 37 40
7 Defensor San Alejandro Defensor 30 37 37 39
8 Atlético Minero Atlético 30 30 40 39
9 Alfonso Ugarte de Puno Alfonso 30 36 50 39
10 Club Atletico Torino Club 30 37 34 37
11 Sport Boys Association Sport Boys. 30 42 47 37
12 Pacífico Pacífico 30 33 44 35
13 Sport Victoria Sport 30 31 38 31
14 Comerciantes Unidos Comerciantes 30 29 36 30
15 José Gálvez José 30 25 39 25
16 Walter Ormeño Walter 30 21 46 21

  USO DE MEMORIA  
5,842,808 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.6865
Total Execution Time  0.6880
  CADENA URL  
/historico/Carlos-Manucci-Trujillo/2020
  GET DATOS  
$_GET['/historico/Carlos-Manucci-Trujillo/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0194  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 = 'Carlos-Manucci-Trujillo' 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.0151  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=17803 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151  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=17803 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151  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=17803 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0293  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 = 53548
0.0151  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 = 53549
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17803 AND type_rel = 2
0.0146  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 17803 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0147  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 (612239,620301,627356,676056,696211) ORDER BY n.cover_points DESC, update_date DESC
0.0150  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 = '17803' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0149  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 = '17803' 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 = 53548 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149  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 = 53549 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0158  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=17803 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 (63314,63055,61643,61225) 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.0157  SELECT count(id) as num_players from rel_players WHERE league_id = 61643 AND teamId = 17803
0.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 63314 AND teamId = 17803
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 61225 AND teamId = 17803
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 63055 AND teamId = 17803
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 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 = 53548 AND t.round = 19 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0146  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 = '17803' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17803' and rp.type = 4
0.0146  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 = '17803' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 53548 WHERE rp.league_id = 53548 AND rp.teamId = 17803 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.0156  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 = 53548 WHERE rp.league_id = 53548 AND rp.teamId = 17803 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151  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 = 53548 WHERE rp.league_id = 53548 AND rp.teamId = 17803 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149  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 = 17803 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 53548 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 53549 AND t.round = 9 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 48718 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 48717 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 43140 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 37755 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 20256 AND t.round = 30 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 `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 = 13716 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 = 3678 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 53548 ORDER BY nameShow LIMIT 100