4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Noroeste
TEMPORADA 2007/2008
SERIE C - BRASIL GRUPO 1
Equipo PJ GF GC Puntos
1 Rio Branco Acre Branco Acre 4 13 7 9
2 Luverdense Luverdense 4 11 8 9
3 Fast Clube Fast Clube 4 2 11 0
4 Holanda EC Holanda EC 6 11 8 12
5 Remo Remo 6 12 5 11
6 Cristal CA Cristal CA 6 5 5 8
7 Progresso Progresso 6 3 13 3
8 Aguia de Maraba Aguia Maraba 6 13 10 10
9 Paysandu Paysandu 6 7 5 9
10 Bacabal Bacabal 6 8 7 8
11 Palmas FR Palmas FR 6 6 12 6
12 Sampaio Correa Sampaio 6 8 2 12
13 Picos SE Picos SE 6 3 1 10
14 Barras Barras 6 2 6 5
15 Horizonte Horizonte 6 5 9 4
16 Campinense Campinense 6 11 6 11
17 Santa Cruz Santa Cruz 6 7 6 8
18 Potiguar Mossoró Potiguar 6 9 10 7
19 Central SC Central SC 6 1 6 6
20 Salgueiro Salgueiro 6 10 5 12
21 Icasa Icasa 6 7 4 11
22 Santa Cruz RN Santa Cruz 6 5 8 7
23 Treze Treze 6 3 8 2
24 ASA Arapiraquense Arapiraquens 6 14 6 13
25 Confiança Confiança 6 12 10 12
26 Atlético Alagoinhas Atlético 6 6 8 7
27 Petrolina Petrolina 6 6 14 3
28 Vitória da Conquista Vitória 6 12 7 13
29 Sergipe Sergipe 6 9 9 10
30 Itabuna Itabuna 6 8 7 9
31 CSA CSA 6 4 10 3
32 Atlético GO Atlético 6 15 5 14
33 Mixto Mixto 6 11 8 9
34 Operário MS Operário 6 3 5 7
35 Águia Negra Águia Negra 6 4 15 1
36 Real Brasília Real 6 8 8 9
37 Itumbiara Itumbiara 6 6 4 8
38 Anápolis Anápolis 6 7 11 8
39 Legião Legião 6 12 10 7
40 América Mineiro América 6 7 3 11
41 Duque de Caxias Duque Caxias 6 8 8 8
42 Paulista Paulista 6 6 6 8
43 Serra FC Serra FC 6 7 11 6
44 Guaratinguetá Guaratinguet 6 7 3 13
45 Boavista SC Boavista SC 6 13 4 10
46 Macaé Esporte Macaé 6 6 4 9
47 Linhares Linhares 6 3 18 1
48 Boa EC Boa EC 6 11 4 14
49 Noroeste Noroeste 6 9 9 8
50 Tupi Tupi 6 6 9 7
51 Mirassol Mirassol 6 7 11 4
52 Ituano Ituano 6 10 8 10
53 Guaraní Guaraní 6 5 4 10
54 Madureira RJ Madureira 6 8 9 7
55 Linense CA Linense CA 6 5 7 7
56 Toledo EC Toledo EC 6 8 6 9
57 Marcílio Dias Marcílio 6 6 4 9
58 Inter Santa Maria Inter Santa 6 7 5 8
59 Engenheiro Beltrão Engenheiro 6 3 9 6
60 Brasil de Pelotas Brasil 6 4 4 11
61 Caxias do Sul Caxias 6 8 4 8
62 J. Malucelli Malucelli 6 4 4 7
63 Metropolitano Metropolitan 6 4 8 4
TEMPORADA 2006/2007
SERIE C - BRASIL GRUPO 1
Equipo PJ GF GC Puntos
1 Rio Branco Acre Branco Acre 6 15 5 12
2 Fast Clube Fast Clube 6 6 3 11
3 Jaruense Jaruense 6 8 13 8
4 São Raimundo RR São 6 7 15 1
5 Nacional AM Nacional AM 6 10 6 11
6 Tuna Luso Tuna Luso 6 7 7 10
7 Amapá Clube Amapá Clube 6 6 8 7
8 São Raimundo AM São 6 5 7 5
9 Araguaína Araguaína 6 8 4 11
10 Imperatriz Imperatriz 6 4 2 10
11 Ananindeua Ananindeua 6 6 6 9
12 Paysandu Paysandu 6 3 9 1
13 Barras Barras 6 9 5 11
14 Sampaio Correa Sampaio 6 5 5 9
15 Ríver Ríver 6 9 11 8
16 Itapipoca Itapipoca 6 10 12 4
17 Nacional de Patos Nacional 6 8 6 11
18 Potiguar Mossoró Potiguar 6 10 8 7
19 CA Porto CA Porto 6 8 10 7
20 Icasa Icasa 6 5 7 7
21 ABC ABC 6 12 6 13
22 Atlético Cajazeirense Atlético 6 4 3 10
23 Central SC Central SC 6 9 10 6
24 Vera Cruz Vera Cruz 6 3 9 4
25 Bahía Bahía 6 11 1 16
26 Confiança Confiança 6 11 5 13
27 América SE América SE 6 1 7 4
28 ASA Arapiraquense Arapiraquens 6 3 13 1
29 Coruripe Coruripe 6 11 4 14
30 Linhares Linhares 6 12 10 8
31 Atlético Alagoinhas Atlético 6 7 12 6
32 Poções Poções 6 6 10 4
33 Atlético GO Atlético 6 8 4 12
34 CRAC CRAC 6 7 7 9
35 Ceilândia Ceilândia 6 6 7 7
36 Cacerense Cacerense 6 5 8 7
37 Vila Nova Vila Nova 6 12 5 13
38 Itumbiara Itumbiara 6 11 8 12
39 Grêmio Jaciara Grêmio 6 14 9 10
40 CDR Guará CDR Guará 6 3 18 0
41 América RJ América RJ 6 10 7 10
42 Guaraní Guaraní 6 8 7 10
43 Jaguaré Jaguaré 6 12 12 7
44 Tupi Tupi 6 8 12 7
45 Rio Claro Rio Claro 6 4 3 9
46 Volta Redonda Volta 6 6 6 8
47 Friburguense Friburguense 6 5 5 7
48 Noroeste Noroeste 6 5 6 6
49 RB Bragantino Bragantino 6 10 3 13
50 Águia Negra Águia Negra 6 7 8 8
51 CENE CENE 6 6 7 8
52 Sertãozinho Sertãozinho 6 8 13 4
53 Villa Nova Villa Nova 6 12 6 9
54 Democrata GV Democrata 6 7 10 9
55 CA Juventus CA Juventus 6 3 2 8
56 Madureira RJ Madureira 6 1 5 3
57 Roma Apucarana Roma 6 10 3 14
58 Canoas SC Canoas SC 6 9 5 9
59 Chapecoense Chapecoense 6 5 10 4
60 AC Paranavaí Paranavaí 6 4 10 4
61 Joinville Joinville 6 8 4 13
62 Esportivo BG Esportivo 6 6 9 9
63 Adap Galo Maringá Adap Galo M. 6 10 8 8
64 Caxias do Sul Caxias 6 4 7 3
TEMPORADA 2005/2006
SERIE C - BRASIL GRUPO 1
Equipo PJ GF GC Puntos
1 Tuna Luso Tuna Luso 4 9 4 10
2 Rio Negro AM Negro 4 7 8 4
3 ADESG ADESG 4 3 7 3
4 Fast Clube Fast Clube 6 7 3 13
5 Ananindeua Ananindeua 6 12 8 10
6 Amapá Clube Amapá Clube 6 7 11 5
7 São Raimundo RR São 6 5 9 5
8 Operário MT Operário 6 8 6 9
9 Mixto Mixto 6 6 6 9
10 Araguaína Araguaína 6 6 8 7
11 SC Ulbra SC Ulbra 6 7 7 0
12 Ríver Ríver 6 12 4 13
13 Maranhão Maranhão 6 8 6 10
14 Imperatriz Imperatriz 6 6 4 8
15 Flamengo PI Flamengo PI 6 3 15 2
16 Icasa Icasa 6 13 7 12
17 CA Porto CA Porto 6 10 8 11
18 Baraunas Baraunas 6 8 12 5
19 Botafogo PB Botafogo PB 6 8 12 4
20 Ferroviário Ferroviário 6 9 9 10
21 Treze Treze 6 7 5 9
22 Potiguar Mossoró Potiguar 6 6 3 8
23 Ypiranga PE Ypiranga PE 6 6 11 0
24 Bahía Bahía 6 12 7 13
25 Confiança Confiança 6 8 7 9
26 CSA CSA 6 8 10 5
27 Colo Colo BA Colo Colo 6 8 12 5
28 Vitória Vitória 6 10 5 11
29 Coruripe Coruripe 6 9 7 11
30 Olímpico Pirambú Olímpico 6 7 8 7
31 Ipitanga Ipitanga 6 5 11 4
32 Jataiense Jataiense 6 12 6 12
33 Anapolina Anapolina 6 13 6 10
34 Luziânia Luziânia 6 5 15 4
35 Coxim Coxim 6 4 7 0
36 Boa EC Boa EC 6 8 2 13
37 Atlético GO Atlético 6 6 6 8
38 Chapadão Chapadão 6 3 5 7
39 Ceilândia Ceilândia 6 5 9 0
40 América Mineiro América 6 10 4 15
41 Grêmio Barueri Grêmio 6 7 4 13
42 Vitória ES Vitória ES 6 5 9 4
43 América RJ América RJ 6 4 9 2
44 Americano Americano 6 9 5 14
45 Ipatinga FC Ipatinga FC 6 6 4 10
46 CA Juventus CA Juventus 6 7 9 4
47 Estrela do Norte Estrela 6 5 9 0
48 Cabofriense Cabofriense 6 10 6 11
49 Rio Branco SP Branco 6 13 8 10
50 Madureira RJ Madureira 6 8 7 7
51 União Barbarense União 6 5 15 6
52 J. Malucelli Malucelli 6 8 4 10
53 Noroeste Noroeste 6 5 4 9
54 Campo Mourão Campo 6 4 5 7
55 América SP América SP 6 3 7 5
56 Joinville Joinville 6 8 4 11
57 Canoas SC Canoas SC 6 7 5 10
58 Caxias do Sul Caxias 6 8 7 7
59 Rio Branco PR Branco 6 3 10 4
60 Brasil de Pelotas Brasil 6 10 8 15
61 Criciúma Criciúma 6 20 9 13
62 Novo Hamburgo Novo 6 7 14 7
63 Marcílio Dias Marcílio 6 7 13 0
TEMPORADA 1977/1978
LIGA BRASILEÑA GRUPO 19
Equipo PJ GF GC Puntos
1 Grêmio Grêmio 7 18 3 19
2 Botafogo Botafogo 7 9 8 12
3 Palmeiras Palmeiras 7 11 5 10
4 América RJ América RJ 7 7 9 10
5 Coritiba Coritiba 7 5 6 9
6 Flamengo Flamengo 7 7 10 6
7 Noroeste Noroeste 7 4 16 5
8 São Paulo São Paulo 7 6 10 3

  USO DE MEMORIA  
6,433,536 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.5535
Total Execution Time  0.5547
  CADENA URL  
/historico/Noroeste
  GET DATOS  
$_GET['/historico/Noroeste']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0138  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 = 'Noroeste' AND l.year = 2024 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.0125  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=5545 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=5545 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=5545 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=5545 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0252  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 = 75684
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5545 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=549 AND type_rel = 3
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 549 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  SELECT /*53 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 (1094400,969046,898354,809817,806395) ORDER BY n.cover_points DESC, update_date DESC
0.0133  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 = '5545' ORDER BY l.year DESC,cat.coefficient DESC
0.0129  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 = '5545' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0130  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 = '5545' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = 74864 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130  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=5545 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0127  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 (75684,73961,71432) 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.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 73961 AND teamId = 5545
0.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 75684 AND teamId = 5545
0.0138  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 5545
0.0133  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 74864 AND t.round = 15 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0129  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 = '5545' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '5545' and rp.type = 4
0.0130  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 = '5545' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0144  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 events2024 e ON e.player_id = p.id AND e.league_id = 74864 WHERE rp.league_id = 74864 AND rp.teamId = 5545 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.0137  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 events2024 e ON e.player_id = p.id AND e.league_id = 74864 WHERE rp.league_id = 74864 AND rp.teamId = 5545 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132  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 events2024 e ON e.player_id = p.id AND e.league_id = 74864 WHERE rp.league_id = 74864 AND rp.teamId = 5545 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0180  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 = 5545 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0133  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 `tables2008` 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 = 12980 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 12983 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 `tables2006` 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 = 12990 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 `tables1978` 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 = 25743 AND t.round = 11 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 `tables1978` 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 = 25782 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 `tables1978` 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 = 25801 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC