4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del NK Olimpija Ljubljana
TEMPORADA 2003/2004
LIGA ESLOVENA SNL GRUPO 2
Equipo PJ GF GC Puntos
1 ND Gorica ND Gorica 10 9 8 56
2 NK Olimpija Ljubljana Olimpija 10 14 12 55
3 Maribor Maribor 10 12 11 54
4 FC Koper FC Koper 10 13 15 50
5 NK Mura NK Mura 10 12 13 49
6 Primorje Primorje 10 10 11 48
TEMPORADA 2002/2003
LIGA ESLOVENA SNL
Equipo PJ GF GC Puntos
1 Maribor Maribor 31 57 32 62
2 Celje Celje 31 57 38 55
3 NK Olimpija Ljubljana Olimpija 31 54 32 54
4 Smartno 1928 Smartno 1928 31 46 42 46
5 FC Koper FC Koper 31 41 41 45
6 Primorje Primorje 31 47 44 44
7 Dravograd Dravograd 31 40 43 36
8 ND Gorica ND Gorica 31 34 43 34
9 NK Mura NK Mura 31 38 48 34
10 NK Ljubljana Ljubljana 31 41 66 30
11 Rudar Velenje Rudar 31 32 51 25
12 NK Korotan Prevalje Korotan 11 7 14 10
TEMPORADA 2001/2002
LIGA ESLOVENA SNL
Equipo PJ GF GC Puntos
1 Maribor Maribor 33 64 23 66
2 Primorje Primorje 33 57 26 60
3 FC Koper FC Koper 33 45 26 56
4 ND Gorica ND Gorica 33 38 40 51
5 NK Olimpija Ljubljana Olimpija 33 39 42 51
6 Celje Celje 33 50 39 48
7 NK Mura NK Mura 33 36 35 48
8 Rudar Velenje Rudar 33 46 52 42
9 Smartno 1928 Smartno 1928 33 41 40 40
10 NK Korotan Prevalje Korotan 33 28 46 37
11 Triglav Kranj Triglav 33 34 60 32
12 Domžale Domžale 33 26 75 16
TEMPORADA 2000/2001
LIGA ESLOVENA SNL
Equipo PJ GF GC Puntos
1 Maribor Maribor 33 61 36 62
2 NK Olimpija Ljubljana Olimpija 33 73 46 60
3 Primorje Primorje 33 47 34 56
4 NK Mura NK Mura 33 43 39 51
5 Celje Celje 33 59 52 50
6 FC Koper FC Koper 33 43 43 46
7 ND Gorica ND Gorica 33 52 46 43
8 Rudar Velenje Rudar 33 43 44 43
9 NK Korotan Prevalje Korotan 33 44 51 43
10 Domžale Domžale 33 44 64 37
11 Dravograd Dravograd 33 48 62 35
12 Tabor Sežana Tabor 33 34 74 28
TEMPORADA 1999/2000
LIGA ESLOVENA SNL
Equipo PJ GF GC Puntos
1 Maribor Maribor 33 90 29 81
2 ND Gorica ND Gorica 33 55 34 62
3 Rudar Velenje Rudar 33 48 35 58
4 NK Korotan Prevalje Korotan 33 58 43 52
5 Primorje Primorje 33 56 49 50
6 Celje Celje 33 53 45 47
7 NK Olimpija Ljubljana Olimpija 33 64 58 46
8 Dravograd Dravograd 33 44 54 43
9 Domžale Domžale 33 50 51 41
10 NK Mura NK Mura 33 47 53 36
11 NK Pohorje NK Pohorje 33 26 73 18
12 Beltinci Beltinci 33 21 88 15
TEMPORADA 1998/1999
LIGA ESLOVENA SNL
Equipo PJ GF GC Puntos
1 Maribor Maribor 33 72 29 66
2 ND Gorica ND Gorica 33 55 31 62
3 Rudar Velenje Rudar 33 43 33 56
4 NK Mura NK Mura 33 53 35 53
5 NK Korotan Prevalje Korotan 33 44 45 48
6 NK Olimpija Ljubljana Olimpija 33 54 50 44
7 Celje Celje 33 30 35 42
8 Domžale Domžale 33 40 49 41
9 Primorje Primorje 33 39 45 40
10 Beltinci Beltinci 33 41 62 36
11 FC Koper FC Koper 33 34 61 32
12 Triglav Kranj Triglav 33 28 58 25
TEMPORADA 1997/1998
LIGA ESLOVENA SNL
Equipo PJ GF GC Puntos
1 Maribor Maribor 36 69 34 76
2 NK Mura NK Mura 36 63 42 67
3 ND Gorica ND Gorica 36 64 35 65
4 Primorje Primorje 36 63 49 57
5 NK Olimpija Ljubljana Olimpija 36 59 55 51
6 Celje Celje 36 57 57 49
7 Rudar Velenje Rudar 36 38 38 43
8 NK Korotan Prevalje Korotan 36 31 59 39
9 Beltinci Beltinci 36 44 73 34
10 NK Set Vevce Vevce 36 37 83 19
TEMPORADA 1996/1997
LIGA ESLOVENA SNL
Equipo PJ GF GC Puntos
1 Maribor Maribor 36 71 34 71
2 Primorje Primorje 36 64 25 66
3 ND Gorica ND Gorica 36 50 32 65
4 Celje Celje 36 55 61 47
5 NK Olimpija Ljubljana Olimpija 36 53 52 45
6 NK Korotan Prevalje Korotan 36 32 38 45
7 NK Mura NK Mura 36 36 45 43
8 Rudar Velenje Rudar 36 43 53 42
9 Beltinci Beltinci 36 36 67 32
10 FC Koper FC Koper 36 28 61 31
TEMPORADA 1995/1996
LIGA ESLOVENA SNL
Equipo PJ GF GC Puntos
1 ND Gorica ND Gorica 36 49 22 67
2 NK Olimpija Ljubljana Olimpija 36 79 39 64
3 NK Mura NK Mura 36 43 29 58
4 Maribor Maribor 36 46 32 53
5 Celje Celje 36 62 47 51
6 Beltinci Beltinci 36 41 40 50
7 Rudar Velenje Rudar 36 46 37 49
8 Primorje Primorje 36 56 48 48
9 NK Korotan Prevalje Korotan 36 44 46 42
10 MNK Izola MNK Izola 36 13 139 8
TEMPORADA 1994/1995
LIGA ESLOVENA SNL
Equipo PJ GF GC Puntos
1 NK Olimpija Ljubljana Olimpija 30 78 30 64
2 ND Gorica ND Gorica 30 66 30 59
3 Maribor Maribor 30 60 24 59
4 Mura 05 Mura 05 30 46 24 57
5 Celje Celje 30 50 27 54
6 Rudar Velenje Rudar 30 55 33 54
7 Beltinci Beltinci 30 74 32 53
8 NK Korotan Prevalje Korotan 30 53 36 46
9 Primorje Primorje 30 50 45 44
10 NK Ljubljana Ljubljana 30 49 43 43
11 FC Koper FC Koper 30 24 34 35
12 Svoboda Ljubljana Svoboda 30 36 58 28
13 MNK Izola MNK Izola 30 30 73 27
14 NK Naklo NK Naklo 30 34 48 24
15 Kočevje Kočevje 30 24 91 21
16 Dekani Dekani 30 12 113 3
TEMPORADA 1993/1994
LIGA ESLOVENA SNL
Equipo PJ GF GC Puntos
1 NK Olimpija Ljubljana Olimpija 30 95 20 74
2 NK Mura NK Mura 30 59 23 64
3 Maribor Maribor 30 55 24 58
4 Celje Celje 30 50 34 52
5 ND Gorica ND Gorica 30 40 38 47
6 Beltinci Beltinci 30 57 40 45
7 FC Koper FC Koper 30 43 38 43
8 NK Naklo NK Naklo 30 32 40 40
9 Rudar Velenje Rudar 30 37 49 37
10 MNK Izola MNK Izola 30 45 51 35
11 NK Ljubljana Ljubljana 30 29 44 33
12 Primorje Primorje 30 46 55 32
13 Svoboda Ljubljana Svoboda 30 31 59 32
14 Dekani Dekani 30 25 50 28
15 ND Slovan Ljubljana Slovan 30 35 70 23
16 NK Krka NK Krka 30 14 58 14
TEMPORADA 1992/1993
LIGA ESLOVENA SNL
Equipo PJ GF GC Puntos
1 NK Olimpija Ljubljana Olimpija 68 138 54 130
2 Maribor Maribor 34 50 20 66
3 NK Mura NK Mura 34 50 28 65
4 NK Naklo NK Naklo 34 55 47 55
5 Svoboda Ljubljana Svoboda 34 38 33 52
6 NK Krka NK Krka 34 35 30 51
7 FC Koper FC Koper 34 41 45 46
8 Rudar Velenje Rudar 34 45 52 46
9 Celje Celje 34 37 47 44
10 ND Gorica ND Gorica 34 39 46 42
11 Beltinci Beltinci 34 51 62 41
12 ND Slovan Ljubljana Slovan 34 45 43 40
13 Belvedur Izola Belvedur 34 45 46 40
14 Zagorje Zagorje 34 29 40 38
15 Železničar Maribor Železničar 34 30 62 26
16 Steklar Steklar 34 33 72 26
17 Nafta Lendava Nafta 34 30 64 25
TEMPORADA 1991/1992
LIGA ESLOVENA SNL
Equipo PJ GF GC Puntos
1 NK Olimpija Ljubljana Olimpija 40 102 18 96
2 Maribor Maribor 40 76 30 84
3 MNK Izola MNK Izola 40 62 26 78
4 NK Ljubljana Ljubljana 40 59 41 63
5 ND Gorica ND Gorica 40 63 40 61
6 NK Mura NK Mura 40 60 49 60
7 NK Naklo NK Naklo 40 49 39 60
8 FC Koper FC Koper 40 38 33 58
9 Celje Celje 40 43 51 55
10 ND Slovan Ljubljana Slovan 40 51 40 54
11 Svoboda Ljubljana Svoboda 40 51 55 54
12 Beltinci Beltinci 40 48 60 52
13 Rudar Velenje Rudar 40 59 65 51
14 Zagorje Zagorje 40 47 44 49
15 Nafta Lendava Nafta 40 52 63 49
16 Steklar Steklar 40 57 75 48
17 Primorje Primorje 40 44 60 47
18 Rudar Trbovlje Rudar 40 47 60 45
19 Jezero Medvode Jezero 40 26 84 32
20 Domžale Domžale 40 26 59 29
21 Dekani Dekani 40 23 91 19

  USO DE MEMORIA  
6,721,152 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.2048
Total Execution Time  0.2060
  CADENA URL  
/historico/Nk-Olimpija
  GET DATOS  
$_GET['/historico/Nk-Olimpija']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (75)  
0.0025  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 = 'Nk-Olimpija' 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.0068  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 = 'Nk-Olimpija' 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.0018  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0017  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62329 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 10345
0.0025  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 = 23725
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=62329 AND type_rel = 2
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 62329 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021  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 (45529,96952,106207,178199) ORDER BY n.cover_points DESC, update_date DESC
0.0023  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 = '62329' AND l.year = 2004 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '62329' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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 = '62329' 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 = 23725 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 = 10345 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026  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=62329 AND l.year in (2003,2004,2005) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (42358,23727,14964,10978) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 14964 AND teamId = 62329
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 10978 AND teamId = 62329
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 42358 AND teamId = 62329
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 23727 AND teamId = 62329
0.0028  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 events2004 e ON e.player_id = p.id AND e.league_id = 10978 WHERE rp.league_id = 10978 AND rp.teamId = 62329 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.0024  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 events2004 e ON e.player_id = p.id AND e.league_id = 10978 WHERE rp.league_id = 10978 AND rp.teamId = 62329 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 events2004 e ON e.player_id = p.id AND e.league_id = 10978 WHERE rp.league_id = 10978 AND rp.teamId = 62329 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 62329 AND l.year <= 2004 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 10345 AND t.round = 10 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 `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 = 14964 AND t.round = 30 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 `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 = 14965 AND t.round = 33 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 `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 = 14966 AND t.round = 33 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 `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 = 14967 AND t.round = 33 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 `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 = 14968 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 14969 AND t.round = 36 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 `tables1997` 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 = 14973 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0052  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 = 26319 AND t.round = 30 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 `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 = 26358 AND t.round = 30 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 `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 = 26364 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 26369 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC