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

Moreirense

Entrenador: Rui Borges

Temporada 2017/2018
TEMPORADA 2017/2018
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Porto Porto 34 82 18 88
2 Benfica Benfica 34 80 22 81
3 Sporting CP Sporting CP 34 63 24 78
4 Sporting Braga Sporting 34 74 29 75
5 Rio Ave Rio Ave 34 40 42 51
6 Chaves Chaves 34 47 55 47
7 Marítimo Marítimo 34 36 49 47
8 Boavista Boavista 34 35 44 45
9 Vitória Guimarães Vitória 34 45 56 43
10 Portimonense Portimonense 34 52 60 38
11 Tondela Tondela 34 41 50 38
12 Os Belenenses Belenenses 34 33 46 37
13 Desportivo Aves Desportivo 34 36 51 34
14 Vitória Setúbal Vitória 34 39 62 32
15 Moreirense Moreirense 34 29 50 32
16 Feirense Feirense 34 32 48 31
17 Paços de Ferreira Paços 34 33 59 30
18 Estoril Estoril 34 29 61 30
TEMPORADA 2016/2017
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Benfica Benfica 34 72 18 82
2 Porto Porto 34 71 19 76
3 Sporting CP Sporting CP 34 68 36 70
4 Vitória Guimarães Vitória 34 50 39 62
5 Sporting Braga Sporting 34 51 36 54
6 Marítimo Marítimo 34 34 32 50
7 Rio Ave Rio Ave 34 41 39 49
8 Feirense Feirense 34 31 45 48
9 Boavista Boavista 34 33 36 43
10 Estoril Estoril 34 36 42 38
11 Chaves Chaves 34 35 42 38
12 Vitória Setúbal Vitória 34 30 39 38
13 Paços de Ferreira Paços 34 32 45 36
14 Os Belenenses Belenenses 34 27 45 36
15 Moreirense Moreirense 34 33 48 33
16 Tondela Tondela 34 29 52 32
17 Arouca Arouca 34 33 57 32
18 Nacional Nacional 34 22 58 21
TEMPORADA 2015/2016
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Benfica Benfica 34 88 22 88
2 Sporting CP Sporting CP 34 79 21 86
3 Porto Porto 34 67 30 73
4 Sporting Braga Sporting 34 54 35 58
5 Arouca Arouca 34 47 38 54
6 Rio Ave Rio Ave 34 44 44 50
7 Paços de Ferreira Paços 34 43 42 49
8 Estoril Estoril 34 40 41 47
9 Os Belenenses Belenenses 34 44 66 41
10 Vitória Guimarães Vitória 34 45 53 40
11 Nacional Nacional 34 40 56 38
12 Moreirense Moreirense 34 38 54 36
13 Marítimo Marítimo 34 45 63 35
14 Boavista Boavista 34 24 41 33
15 Vitória Setúbal Vitória 34 40 61 30
16 Tondela Tondela 34 34 54 30
17 União Madeira União 34 27 50 29
18 Académica Académica 34 32 60 25
TEMPORADA 2014/2015
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Benfica Benfica 34 86 16 85
2 Porto Porto 34 74 13 82
3 Sporting CP Sporting CP 34 67 29 76
4 Sporting Braga Sporting 34 55 28 58
5 Vitória Guimarães Vitória 34 50 35 55
6 Os Belenenses Belenenses 34 34 35 48
7 Nacional Nacional 34 45 46 47
8 Paços de Ferreira Paços 34 40 45 47
9 Marítimo Marítimo 34 46 45 44
10 Rio Ave Rio Ave 34 38 42 43
11 Moreirense Moreirense 34 33 42 43
12 Estoril Estoril 34 38 56 40
13 Boavista Boavista 34 27 50 34
14 Vitória Setúbal Vitória 34 24 56 29
15 Académica Académica 34 26 46 29
16 Arouca Arouca 34 26 50 28
17 Gil Vicente Gil Vicente 34 25 60 23
18 Penafiel Penafiel 34 29 69 22
TEMPORADA 2013/2014
SEGUNDA LIGA
Equipo PJ GF GC Puntos
1 Moreirense Moreirense 42 65 25 79
2 Porto II Porto II 42 59 42 77
3 Penafiel Penafiel 42 47 24 73
4 Desportivo Aves Desportivo 42 46 35 71
5 Benfica II Benfica II 42 77 56 70
6 Sporting CP II Sporting 42 61 50 70
7 Portimonense Portimonense 42 58 48 67
8 Chaves Chaves 42 58 56 67
9 Tondela Tondela 42 41 38 59
10 Farense Farense 42 45 44 57
11 Academico Viseu Academico 42 43 43 54
12 Beira Mar SC Beira 42 45 48 54
13 União Madeira União 42 50 46 52
14 Feirense Feirense 42 41 46 50
15 CD Santa Clara Santa Clara 42 38 46 48
16 SC Covilha SC Covilha 42 34 50 48
17 Leixões Leixões 42 42 57 47
18 UD Oliveirense Oliveirense 42 56 76 47
19 Trofense Trofense 42 36 61 47
20 Sporting Braga II Sporting 42 47 60 44
21 Marítimo II Marítimo 42 39 57 43
22 Atlético CP Atlético 42 34 54 40
TEMPORADA 2012/2013
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Porto Porto 30 70 14 78
2 Benfica Benfica 30 77 20 77
3 Paços de Ferreira Paços 30 42 29 54
4 Sporting Braga Sporting 30 60 44 52
5 Estoril Estoril 30 47 37 45
6 Rio Ave Rio Ave 30 35 42 42
7 Sporting CP Sporting CP 30 36 36 42
8 Nacional Nacional 30 45 51 40
9 Vitória Guimarães Vitória 30 36 47 40
10 Marítimo Marítimo 30 34 45 38
11 Académica Académica 30 33 45 28
12 Vitória Setúbal Vitória 30 30 55 26
13 Gil Vicente Gil Vicente 30 31 54 25
14 Olhanense Olhanense 30 26 42 25
15 Moreirense Moreirense 30 30 51 24
16 Beira Mar SC Beira 30 35 55 23
TEMPORADA 2011/2012
SEGUNDA LIGA
Equipo PJ GF GC Puntos
1 Estoril Estoril 30 40 20 57
2 Moreirense Moreirense 30 47 32 52
3 Desportivo Aves Desportivo 30 38 23 50
4 Naval Naval 30 40 33 46
5 Os Belenenses Belenenses 30 34 32 41
6 Leixões Leixões 30 32 34 40
7 UD Oliveirense Oliveirense 30 39 38 39
8 Trofense Trofense 30 36 45 39
9 Penafiel Penafiel 30 33 36 38
10 União Madeira União 30 35 40 37
11 Atlético CP Atlético 30 27 36 37
12 Arouca Arouca 30 32 36 34
13 SC Freamunde Freamunde 30 35 40 34
14 CD Santa Clara Santa Clara 30 29 38 34
15 Portimonense Portimonense 30 35 42 32
16 SC Covilha SC Covilha 30 22 29 32
TEMPORADA 2010/2011
SEGUNDA LIGA
Equipo PJ GF GC Puntos
1 Feirense Feirense 30 41 31 55
2 Trofense Trofense 30 41 27 54
3 Gil Vicente Gil Vicente 30 51 37 53
4 UD Oliveirense Oliveirense 30 36 35 45
5 Arouca Arouca 30 47 41 43
6 Leixões Leixões 30 35 27 42
7 Desportivo Aves Desportivo 30 35 31 40
8 Moreirense Moreirense 30 36 41 40
9 Estoril Estoril 30 36 31 38
10 CD Santa Clara Santa Clara 30 26 28 38
11 SC Freamunde Freamunde 30 37 39 37
12 Penafiel Penafiel 30 36 44 36
13 Os Belenenses Belenenses 30 33 36 35
14 Varzim Varzim 30 37 44 32
15 SC Covilha SC Covilha 30 32 48 32
16 Fatima Fatima 30 29 48 23
TEMPORADA 2005/2006
SEGUNDA LIGA
Equipo PJ GF GC Puntos
1 Beira Mar SC Beira 34 45 18 68
2 Desportivo Aves Desportivo 33 46 29 63
3 Leixões Leixões 34 47 19 62
4 Olhanense Olhanense 34 41 28 52
5 Varzim Varzim 34 47 39 52
6 Gondomar Gondomar 34 56 41 51
7 CD Santa Clara Santa Clara 34 45 32 51
8 Chaves Chaves 34 40 36 50
9 Estoril Estoril 33 43 42 44
10 Feirense Feirense 34 44 44 44
11 Vizela Vizela 34 42 48 44
12 Portimonense Portimonense 34 36 36 43
13 Moreirense Moreirense 34 36 37 42
14 SC Covilha SC Covilha 34 37 42 42
15 FC Barreirense Barreirense 34 31 41 35
16 FC Marco FC Marco 34 32 63 29
17 Ovarense Ovarense 34 36 72 25
18 FC Maia FC Maia 34 30 67 24
TEMPORADA 2004/2005
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Benfica Benfica 34 51 31 65
2 Porto Porto 34 39 26 62
3 Sporting CP Sporting CP 34 66 36 61
4 Sporting Braga Sporting 34 45 28 58
5 Vitória Guimarães Vitória 34 38 29 54
6 Boavista Boavista 34 39 43 50
7 Marítimo Marítimo 34 39 32 49
8 Rio Ave Rio Ave 34 35 35 47
9 Os Belenenses Belenenses 34 38 34 46
10 Vitória Setúbal Vitória 34 46 45 44
11 Penafiel Penafiel 34 39 53 43
12 Nacional Nacional 34 46 48 41
13 Gil Vicente Gil Vicente 34 34 40 40
14 Académica Académica 34 29 41 38
15 União de Leiria União 34 29 36 38
16 Moreirense Moreirense 34 30 43 34
17 Estoril Estoril 34 38 55 30
18 Beira Mar SC Beira 34 30 56 30
TEMPORADA 2003/2004
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Porto Porto 34 63 19 82
2 Benfica Benfica 34 62 28 74
3 Sporting CP Sporting CP 34 60 33 73
4 Nacional Nacional 34 56 35 56
5 Sporting Braga Sporting 34 36 38 54
6 Marítimo Marítimo 34 35 33 48
7 Rio Ave Rio Ave 34 42 37 48
8 Boavista Boavista 34 32 31 47
9 Moreirense Moreirense 34 33 33 46
10 União de Leiria União 34 43 45 45
11 Beira Mar SC Beira 34 36 45 41
12 Gil Vicente Gil Vicente 34 43 40 40
13 Académica Académica 34 40 42 38
14 Vitória Guimarães Vitória 34 31 40 37
15 Os Belenenses Belenenses 34 35 54 35
16 FC Alverca FC Alverca 34 33 49 35
17 Paços de Ferreira Paços 34 27 53 28
18 Estrela Amadora Estrela 34 22 74 17
TEMPORADA 2002/2003
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Porto Porto 34 73 26 86
2 Benfica Benfica 34 74 27 75
3 Sporting CP Sporting CP 34 52 38 59
4 Vitória Guimarães Vitória 34 47 46 50
5 União de Leiria União 34 49 47 49
6 Paços de Ferreira Paços 34 40 47 45
7 Marítimo Marítimo 34 36 48 44
8 Gil Vicente Gil Vicente 34 42 53 44
9 Os Belenenses Belenenses 34 47 48 43
10 Boavista Boavista 34 32 31 43
11 Nacional Nacional 34 40 46 40
12 Moreirense Moreirense 34 42 46 39
13 Beira Mar SC Beira 34 43 50 39
14 Sporting Braga Sporting 34 34 47 38
15 Académica Académica 34 38 48 37
16 Varzim Varzim 34 38 51 36
17 CD Santa Clara Santa Clara 34 39 54 35
18 Vitória Setúbal Vitória 34 40 53 31
TEMPORADA 2001/2002
SEGUNDA LIGA
Equipo PJ GF GC Puntos
1 Moreirense Moreirense 34 55 35 64
2 Nacional Nacional 34 62 39 62
3 Académica Académica 34 60 49 62
4 Estrela Amadora Estrela 34 44 38 57
5 Chaves Chaves 34 52 44 52
6 Portimonense Portimonense 34 44 37 52
7 Desportivo Aves Desportivo 34 50 51 47
8 Rio Ave Rio Ave 34 45 36 46
9 FC Maia FC Maia 34 50 43 46
10 Campomaiorense Campomaioren 34 48 50 45
11 Naval Naval 34 54 50 42
12 Leça FC Leça FC 33 36 36 41
13 Ovarense Ovarense 35 43 53 41
14 Uniao Lamas Uniao Lamas 34 33 47 41
15 Penafiel Penafiel 35 28 39 39
16 FC Felgueiras Felgueiras 33 35 50 38
17 Espinho Espinho 34 31 49 34
18 UD Oliveirense Oliveirense 34 44 68 28
TEMPORADA 1999/2000
SEGUNDA LIGA
Equipo PJ GF GC Puntos
1 Paços de Ferreira Paços 34 56 31 65
2 Beira Mar SC Beira 34 54 30 65
3 Desportivo Aves Desportivo 34 33 24 61
4 Varzim Varzim 34 53 33 60
5 Académica Académica 34 55 37 57
6 Penafiel Penafiel 34 52 33 56
7 FC Felgueiras Felgueiras 34 42 36 51
8 Uniao Lamas Uniao Lamas 34 39 50 46
9 SC Freamunde Freamunde 34 42 37 45
10 Espinho Espinho 34 51 48 45
11 Leça FC Leça FC 34 41 49 45
12 Chaves Chaves 34 46 45 44
13 Naval Naval 34 53 55 42
14 FC Maia FC Maia 34 35 44 42
15 Imortal DC Imortal DC 34 43 64 33
16 Moreirense Moreirense 34 29 49 29
17 Esposende Esposende 34 31 65 28
18 SC Covilha SC Covilha 34 23 48 25
TEMPORADA 1998/1999
SEGUNDA LIGA
Equipo PJ GF GC Puntos
1 Gil Vicente Gil Vicente 34 58 24 68
2 Os Belenenses Belenenses 34 55 28 61
3 CD Santa Clara Santa Clara 34 53 37 55
4 Desportivo Aves Desportivo 34 46 43 51
5 FC Felgueiras Felgueiras 34 60 40 50
6 Espinho Espinho 34 45 37 50
7 Leça FC Leça FC 34 51 49 50
8 Varzim Varzim 34 51 46 48
9 Penafiel Penafiel 34 56 49 47
10 FC Maia FC Maia 34 53 50 46
11 Paços de Ferreira Paços 34 38 35 44
12 Moreirense Moreirense 34 40 56 41
13 Esposende Esposende 34 24 34 38
14 Naval Naval 34 34 54 38
15 Feirense Feirense 34 34 53 37
16 Uniao Lamas Uniao Lamas 34 28 48 37
17 União Madeira União 34 34 50 33
18 Estoril Estoril 34 23 50 28
TEMPORADA 1997/1998
SEGUNDA LIGA
Equipo PJ GF GC Puntos
1 União de Leiria União 34 73 32 70
2 Beira Mar SC Beira 34 41 26 64
3 FC Alverca FC Alverca 34 64 35 62
4 Gil Vicente Gil Vicente 34 44 23 60
5 Penafiel Penafiel 34 63 48 59
6 Feirense Feirense 34 39 39 49
7 Estoril Estoril 34 40 39 46
8 FC Maia FC Maia 34 50 47 45
9 FC Felgueiras Felgueiras 34 38 42 45
10 Espinho Espinho 34 45 43 44
11 Moreirense Moreirense 34 48 53 42
12 Paços de Ferreira Paços 34 34 39 41
13 União Madeira União 34 36 48 41
14 Uniao Lamas Uniao Lamas 34 37 55 40
15 Desportivo Aves Desportivo 34 48 64 38
16 Academico Viseu Academico 34 30 45 33
17 Torreense Torreense 34 31 62 30
18 Nacional Nacional 34 37 58 27

  USO DE MEMORIA  
7,745,240 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.8377
Total Execution Time  0.8389
  CADENA URL  
/historico/Moreirense-Fc/2018
  GET DATOS  
$_GET['/historico/Moreirense-Fc/2018']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (52)  
0.0158  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 = 'Moreirense-Fc' AND l.year = 2018 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.0127  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=1737 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=1737 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=1737 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=1737 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  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=1737 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=1737 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0155  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 = 38648
0.0130  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 = 39546
0.0152  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 = 38952
0.0157  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 = 39913
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1737 AND type_rel = 2
0.0164  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1737 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0127  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 (8389,8392,8469,9219,13903) ORDER BY n.cover_points DESC, update_date DESC
0.0131  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 = '1737' AND l.year = 2018 ORDER BY l.year DESC,cat.coefficient DESC
0.0142  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 = '1737' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 38648 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 38952 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 39913 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131  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 = 39546 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0135  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=1737 AND l.year in (2017,2018,2019) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (49388,44781,44369,43558,43475) 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.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 43558 AND teamId = 1737
0.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 44781 AND teamId = 1737
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 44369 AND teamId = 1737
0.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 49388 AND teamId = 1737
0.0234  SELECT count(id) as num_players from rel_players WHERE league_id = 43475 AND teamId = 1737
0.0132  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 38648 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0128  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 = '1737' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1737' and rp.type = 4
0.0128  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 = '1737' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0152  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 events2018 e ON e.player_id = p.id AND e.league_id = 38648 WHERE rp.league_id = 38648 AND rp.teamId = 1737 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.0138  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 events2018 e ON e.player_id = p.id AND e.league_id = 38648 WHERE rp.league_id = 38648 AND rp.teamId = 1737 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133  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 events2018 e ON e.player_id = p.id AND e.league_id = 38648 WHERE rp.league_id = 38648 AND rp.teamId = 1737 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136  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 = 1737 AND l.year <= 2018 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0131  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 = 38648 AND t.round = 34 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 `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 = 31005 AND t.round = 34 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 `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 = 15394 AND t.round = 34 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 `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 = 3797 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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 = 2504 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  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 `tables2013` 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 = 1931 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  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 `tables2012` 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 = 1617 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  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 `tables2011` 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 = 1111 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  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 = 559 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 108 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 `tables2004` 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 = 109 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0168  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 = 214 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  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 = 613 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138  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 `tables2000` 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 = 615 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138  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 `tables1999` 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 = 616 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 `tables1998` 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 = 13411 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 38648 ORDER BY nameShow LIMIT 100