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

Paysandu

Entrenador: Hélio dos Anjos

Temporada 2004/2005
TEMPORADA 2004/2005
LIGA BRASILEÑA
Equipo PJ GF GC Puntos
1 Corinthians Corinthians 42 87 59 81
2 Internacional Internaciona 42 72 49 78
3 Goiás EC Goiás EC 42 68 51 74
4 Palmeiras Palmeiras 42 81 65 70
5 Fluminense Fluminense 42 79 70 68
6 Athletico Paranaense Athletico 42 76 67 61
7 Paraná Paraná 42 59 51 61
8 Cruzeiro Cruzeiro 42 73 72 60
9 Botafogo Botafogo 42 57 56 59
10 Santos FC Santos FC 42 68 71 59
11 São Paulo São Paulo 42 77 67 58
12 Flamengo Flamengo 42 56 60 55
13 EC Juventude Juventude 42 66 72 55
14 Fortaleza EC Fortaleza 42 58 64 55
15 Vasco da Gama Vasco Gama 42 75 86 54
16 Figueirense Figueirense 42 65 72 53
17 São Caetano São Caetano 42 54 60 52
18 Ponte Preta Ponte Preta 42 63 80 51
19 Coritiba Coritiba 42 51 60 49
20 Atl. Mineiro Atl. Mineiro 42 54 59 47
21 Brasiliense Brasiliense 42 49 68 42
22 Paysandu Paysandu 42 63 92 41
TEMPORADA 2003/2004
LIGA BRASILEÑA
Equipo PJ GF GC Puntos
1 Santos FC Santos FC 46 103 58 89
2 Athletico Paranaense Athletico 46 93 56 86
3 São Paulo São Paulo 46 78 43 82
4 Palmeiras Palmeiras 46 72 47 79
5 Corinthians Corinthians 46 54 54 74
6 Goiás EC Goiás EC 46 81 68 72
7 EC Juventude Juventude 46 60 66 70
8 Internacional Internaciona 46 66 59 67
9 Fluminense Fluminense 46 65 68 67
10 Ponte Preta Ponte Preta 46 43 73 64
11 Figueirense Figueirense 46 57 59 63
12 Coritiba Coritiba 46 53 48 62
13 Cruzeiro Cruzeiro 46 69 81 56
14 Paysandu Paysandu 46 56 76 56
15 Flamengo Flamengo 46 51 53 54
16 Vasco da Gama Vasco Gama 46 64 68 54
17 Paraná Paraná 46 52 73 54
18 São Caetano São Caetano 46 65 49 53
19 Atl. Mineiro Atl. Mineiro 46 60 66 53
20 Botafogo Botafogo 46 62 71 51
21 Criciúma Criciúma 46 61 78 50
22 Guaraní Guaraní 46 43 55 49
23 Vitória Vitória 46 68 87 48
24 Grêmio Grêmio 46 60 80 39
TEMPORADA 2002/2003
LIGA BRASILEÑA
Equipo PJ GF GC Puntos
1 Cruzeiro Cruzeiro 46 102 47 100
2 Santos FC Santos FC 46 93 60 87
3 São Paulo São Paulo 46 81 67 78
4 Coritiba Coritiba 46 67 58 73
5 Atl. Mineiro Atl. Mineiro 46 76 62 72
6 São Caetano São Caetano 46 53 37 71
7 Internacional Internaciona 46 59 57 70
8 Flamengo Flamengo 46 66 73 66
9 Goiás EC Goiás EC 46 78 63 65
10 Paraná Paraná 46 85 75 65
11 Figueirense Figueirense 46 62 54 65
12 Athletico Paranaense Athletico 46 67 72 61
13 Guaraní Guaraní 46 64 72 61
14 Criciúma Criciúma 46 57 69 60
15 Corinthians Corinthians 46 61 63 57
16 Paysandu Paysandu 46 74 77 57
17 Vitória Vitória 46 50 64 56
18 Vasco da Gama Vasco Gama 46 57 69 54
19 Ponte Preta Ponte Preta 46 63 73 51
20 Grêmio Grêmio 46 54 68 50
21 EC Juventude Juventude 46 55 70 50
22 Fluminense Fluminense 46 52 77 50
23 Fortaleza EC Fortaleza 46 58 74 49
24 Bahía Bahía 46 59 92 46
TEMPORADA 2001/2002
LIGA BRASILEÑA
Equipo PJ GF GC Puntos
1 São Paulo São Paulo 25 57 35 52
2 São Caetano São Caetano 25 42 28 47
3 Corinthians Corinthians 25 37 35 43
4 Grêmio Grêmio 25 39 29 41
5 EC Juventude Juventude 25 34 30 41
6 Atl. Mineiro Atl. Mineiro 25 49 43 40
7 Fluminense Fluminense 25 43 46 40
8 Santos FC Santos FC 25 46 36 39
9 Cruzeiro Cruzeiro 25 40 39 39
10 Vitória Vitória 25 46 42 37
11 Goiás EC Goiás EC 25 42 39 36
12 Coritiba Coritiba 25 34 34 36
13 Athletico Paranaense Athletico 25 39 33 34
14 Ponte Preta Ponte Preta 25 35 34 34
15 Vasco da Gama Vasco Gama 25 37 38 33
16 Guaraní Guaraní 25 32 35 33
17 Figueirense Figueirense 25 34 43 31
18 Flamengo Flamengo 25 38 39 30
19 Bahía Bahía 25 35 37 30
20 Internacional Internaciona 25 36 37 29
21 Paysandu Paysandu 25 35 46 29
22 Paraná Paraná 25 37 42 28
23 Palmeiras Palmeiras 25 37 46 27
24 Portuguesa Portuguesa 25 26 40 27
25 Gama Gama 25 30 39 25
26 Botafogo Botafogo 25 24 39 25
TEMPORADA 2000/2001
SERIE B - BRASIL
Equipo PJ GF GC Puntos
1 Paysandu Paysandu 26 44 26 47
2 Caxias do Sul Caxias 26 44 35 46
3 Ceará Ceará 26 50 36 41
4 Náutico Náutico 26 43 34 41
5 CRB CRB 26 35 36 41
6 Fortaleza EC Fortaleza 26 40 27 40
7 América RN América RN 26 32 30 38
8 SAO Raimundo EC Raimundo 26 36 37 38
9 Anapolina Anapolina 26 45 47 34
10 Sergipe Sergipe 26 38 41 32
11 Remo Remo 26 33 39 32
12 Sampaio Correa Sampaio 26 32 40 32
13 Tuna Luso Tuna Luso 26 36 45 30
14 ABC ABC 26 32 40 29
15 Nacional AM Nacional AM 26 30 48 25
16 Figueirense Figueirense 26 50 38 42
17 Avaí Avaí 26 36 31 42
18 União São João União São 26 45 31 41
19 Joinville Joinville 26 39 26 41
20 XV de Piracicaba Piracicaba 26 39 45 38
21 Londrina Londrina 26 45 36 37
22 Vila Nova Vila Nova 26 43 44 37
23 América RJ América RJ 26 32 36 37
24 RB Bragantino Bragantino 26 40 43 35
25 J. Malucelli Malucelli 26 32 37 32
26 Criciúma Criciúma 26 35 40 30
27 Ferroviário Ferroviário 26 26 48 29
28 Serra FC Serra FC 26 33 49 24
TEMPORADA 1994/1995
LIGA BRASILEÑA GRUPO 3
Equipo PJ GF GC Puntos
1 Botafogo Botafogo 12 22 6 27
2 EC Juventude Juventude 12 19 12 23
3 Corinthians Corinthians 12 19 15 23
4 Palmeiras Palmeiras 12 18 11 22
5 RB Bragantino Bragantino 12 20 16 19
6 Grêmio Grêmio 12 14 14 19
7 Flamengo Flamengo 12 14 15 16
8 Cruzeiro Cruzeiro 12 17 15 14
9 Paraná Paraná 12 17 16 14
10 Guaraní Guaraní 12 14 19 13
11 Vitória Vitória 12 14 18 11
12 Paysandu Paysandu 12 11 24 8
13 Santos FC Santos FC 12 25 13 27
14 Atl. Mineiro Atl. Mineiro 12 23 15 26
15 Goiás EC Goiás EC 12 17 14 19
16 Portuguesa Portuguesa 12 12 14 17
17 Internacional Internaciona 12 14 12 14
18 São Paulo São Paulo 12 17 18 14
19 Vasco da Gama Vasco Gama 12 18 19 13
20 Sport Recife Sport Recife 12 16 18 13
21 Fluminense Fluminense 12 9 12 13
22 Criciúma Criciúma 12 10 12 12
23 Bahía Bahía 12 9 24 12
24 União São João União São 12 11 28 5
TEMPORADA 1993/1994
LIGA BRASILEÑA GRUPO 7
Equipo PJ GF GC Puntos
1 Guaraní Guaraní 8 11 5 12
2 Portuguesa Portuguesa 8 16 8 11
3 Fluminense Fluminense 8 14 13 8
4 Vasco da Gama Vasco Gama 8 4 7 8
5 Internacional Internaciona 8 4 5 7
6 Grêmio Grêmio 8 6 12 5
7 Paysandu Paysandu 8 2 11 4
8 Corinthians Corinthians 8 6 16 4
9 Botafogo Botafogo 8 13 5 13
10 Santos FC Santos FC 8 10 3 11
11 São Paulo São Paulo 8 14 9 10
12 Bahía Bahía 8 10 6 10
13 Paraná Paraná 8 9 9 8
14 Flamengo Flamengo 8 5 9 7
15 Palmeiras Palmeiras 8 11 12 6
16 Sport Recife Sport Recife 8 5 10 4
TEMPORADA 1992/1993
LIGA BRASILEÑA GRUPO 3
Equipo PJ GF GC Puntos
1 Vitória Vitória 14 27 14 20
2 Remo Remo 14 28 17 17
3 Paysandu Paysandu 14 15 13 17
4 Náutico Náutico 14 14 18 14
5 Ceará Ceará 14 16 19 13
6 Santa Cruz Santa Cruz 14 20 17 12
7 Goiás EC Goiás EC 14 12 22 10
8 Fortaleza EC Fortaleza 14 11 23 9
TEMPORADA 1991/1992
LIGA BRASILEÑA GRUPO 1
Equipo PJ GF GC Puntos
1 Vasco da Gama Vasco Gama 19 31 14 36
2 Botafogo Botafogo 19 37 23 35
3 RB Bragantino Bragantino 19 16 13 33
4 Flamengo Flamengo 19 32 24 30
5 Corinthians Corinthians 19 24 22 30
6 São Paulo São Paulo 19 22 16 29
7 Cruzeiro Cruzeiro 19 20 14 28
8 Santos FC Santos FC 19 23 18 28
9 Guaraní Guaraní 19 15 19 28
10 Palmeiras Palmeiras 19 23 17 27
11 Internacional Internaciona 19 19 20 27
12 Atl. Mineiro Atl. Mineiro 19 15 18 24
13 Fluminense Fluminense 19 21 19 23
14 Sport Recife Sport Recife 19 15 15 23
15 Athletico Paranaense Athletico 19 19 32 21
16 Portuguesa Portuguesa 19 21 26 19
17 Goiás EC Goiás EC 19 23 34 19
18 Bahía Bahía 19 20 24 18
19 Paysandu Paysandu 19 19 35 17
20 Náutico Náutico 19 17 29 16
TEMPORADA 1985/1986
LIGA BRASILEÑA GRUPO 2
Equipo PJ GF GC Puntos
1 Flamengo Flamengo 10 15 7 14
2 Corinthians Corinthians 10 16 6 13
3 Ponte Preta Ponte Preta 10 18 11 13
4 Athletico Paranaense Athletico 10 12 5 12
5 Grêmio Grêmio 10 15 11 11
6 América RJ América RJ 10 10 11 10
7 Goiás EC Goiás EC 10 8 9 10
8 Joinville Joinville 10 14 17 9
9 Sergipe Sergipe 10 5 16 8
10 Botafogo PB Botafogo PB 10 9 16 7
11 Paysandu Paysandu 10 5 18 3
TEMPORADA 1984/1985
LIGA BRASILEÑA GRUPO 5
Equipo PJ GF GC Puntos
1 Sport Recife Sport Recife 11 23 7 28
2 Ceará Ceará 11 20 9 27
3 Nacional AM Nacional AM 11 24 11 21
4 CSA CSA 11 16 8 18
5 Paysandu Paysandu 11 15 13 18
6 Mixto Mixto 11 11 12 18
7 Botafogo PB Botafogo PB 11 12 16 13
8 Remo Remo 11 9 20 12
9 ABC ABC 11 17 18 11
10 Flamengo PI Flamengo PI 11 7 14 8
11 Sergipe Sergipe 11 9 20 6
12 Sampaio Correa Sampaio 11 12 27 5
TEMPORADA 1982/1983
LIGA BRASILEÑA GRUPO 1
Equipo PJ GF GC Puntos
1 Santos FC Santos FC 8 17 8 13
2 Flamengo Flamengo 8 24 11 12
3 Rio Negro AM Negro 8 4 15 6
4 Paysandu Paysandu 8 12 15 5
5 Moto Club MA Moto Club 8 6 14 4
TEMPORADA 1981/1982
LIGA BRASILEÑA GRUPO 12
Equipo PJ GF GC Puntos
1 Sport Recife Sport Recife 6 11 4 11
2 Bahía Bahía 6 9 7 8
3 XV de Novembro Novembro 6 7 10 7
4 Paysandu Paysandu 6 6 12 5
TEMPORADA 1980/1981
LIGA BRASILEÑA GRUPO 7
Equipo PJ GF GC Puntos
1 Vitória Vitória 6 6 4 11
2 Fluminense Fluminense 6 12 6 9
3 Portuguesa Portuguesa 6 6 6 7
4 Paysandu Paysandu 6 3 11 3

  USO DE MEMORIA  
7,393,952 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.2092
Total Execution Time  0.2104
  CADENA URL  
/historico/Paysandu-Belem/2005
  GET DATOS  
$_GET['/historico/Paysandu-Belem/2005']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (57)  
0.0164  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 = 'Paysandu-Belem' AND l.year = 2005 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.0024  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=1936 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023  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=1936 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023  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=1936 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022  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=1936 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=1936 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=1936 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=1936 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0031  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 = 436
0.0026  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 = 14203
0.0029  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 = 14211
0.0028  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 = 14212
0.0026  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 = 14213
0.0024  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 = 14214
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1936 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1936 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023  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 (29522,64009,70779,71344,95658) ORDER BY n.cover_points DESC, update_date DESC
0.0044  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 = '1936' AND l.year = 2005 ORDER BY l.year DESC,cat.coefficient DESC
0.0031  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 = '1936' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 436 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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 = 14203 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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 = 14213 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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 = 14212 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0034  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=1936 AND l.year in (2004,2005,2006) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (23849,14218,14216,12961,437) 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.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 437 AND teamId = 1936
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 12961 AND teamId = 1936
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 23849 AND teamId = 1936
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 14216 AND teamId = 1936
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 14218 AND teamId = 1936
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 FROM `tables2005` 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 = 436 AND t.round = 42 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022  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 = '1936' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1936' and rp.type = 4
0.0020  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 = '1936' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 events2005 e ON e.player_id = p.id AND e.league_id = 436 WHERE rp.league_id = 436 AND rp.teamId = 1936 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.0033  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 events2005 e ON e.player_id = p.id AND e.league_id = 436 WHERE rp.league_id = 436 AND rp.teamId = 1936 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0035  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 events2005 e ON e.player_id = p.id AND e.league_id = 436 WHERE rp.league_id = 436 AND rp.teamId = 1936 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0038  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 = 1936 AND l.year <= 2005 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0045  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 `tables2005` 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 = 436 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 `tables2003` 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 = 438 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 `tables2002` 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 = 439 AND t.round = 25 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM `tables2001` 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 = 23357 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0058  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 `tables1995` 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 = 25263 AND t.round = 11 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables1995` 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 = 25265 AND t.round = 12 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 `tables1994` 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 = 25268 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables1994` 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 = 25275 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables1994` 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 = 25278 AND t.round = 8 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 `tables1993` 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 = 25302 AND t.round = 14 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 `tables1992` 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 = 25323 AND t.round = 19 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 `tables1986` 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 = 25411 AND t.round = 11 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables1985` 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 = 25465 AND t.round = 11 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables1985` 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 = 25501 AND t.round = 11 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables1983` 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 = 25520 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 `tables1982` 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 = 25552 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 `tables1982` 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 = 25659 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables1981` 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 = 25567 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 `tables1981` 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 = 25572 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC