4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Orasje
TEMPORADA 2021/2022
PRIMERA FBIH BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Igman Konjic Igman Konjic 30 47 16 68
2 GOŠK Gabela GOŠK Gabela 30 56 24 66
3 Buducnost Banovici Buducnost 30 48 34 52
4 TOSK Tesanj TOSK Tesanj 30 46 32 52
5 Rudar Kakanj Rudar Kakanj 30 40 35 52
6 Gradina Srebrenik Gradina 30 49 47 45
7 NK Bratstvo Gračanica Bratstvo 30 48 43 44
8 Orasje Orasje 30 36 41 43
9 Goražde Goražde 30 33 40 38
10 Zvijezda Zvijezda 30 36 37 33
11 Vis Simm-Bau Simm-Bau 30 31 33 32
12 Radnik Hadžići Radnik 30 23 35 31
13 Jedinstvo Bihac Jedinstvo 30 34 56 29
14 Travnik Travnik 30 36 45 28
15 NK Mladost Doboj Kakanj Mladost 30 35 55 27
16 Tomislav Tomislav 30 29 54 22
TEMPORADA 2020/2021
PRIMERA FBIH BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Posušje Posušje 30 49 15 61
2 TOSK Tesanj TOSK Tesanj 30 48 28 54
3 Rudar Kakanj Rudar Kakanj 30 43 31 50
4 Goražde Goražde 30 43 37 49
5 Zvijezda Zvijezda 30 44 31 48
6 NK Bratstvo Gračanica Bratstvo 30 43 30 48
7 GOŠK Gabela GOŠK Gabela 30 38 27 43
8 Jedinstvo Bihac Jedinstvo 30 26 36 43
9 Radnik Hadžići Radnik 30 32 36 40
10 Buducnost Banovici Buducnost 30 38 49 40
11 Vis Simm-Bau Simm-Bau 30 42 37 39
12 Travnik Travnik 30 31 37 39
13 Igman Konjic Igman Konjic 30 38 35 37
14 Orasje Orasje 30 43 51 36
15 Capljina Capljina 30 38 49 36
16 Slaven Živinice Slaven 30 17 84 8
TEMPORADA 2019/2020
PRIMERA FBIH BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Olimpik Sarajevo Olimpik 16 28 13 37
2 TOSK Tesanj TOSK Tesanj 16 27 21 31
3 Goražde Goražde 16 27 15 28
4 GOŠK Gabela GOŠK Gabela 16 30 25 28
5 Capljina Capljina 16 19 15 24
6 Rudar Kakanj Rudar Kakanj 16 26 21 23
7 Travnik Travnik 16 23 21 23
8 Igman Konjic Igman Konjic 16 17 18 23
9 Zvijezda Zvijezda 16 23 26 22
10 Metalleghe-Bsi Jajce Metalleghe-B 16 23 26 21
11 Buducnost Banovici Buducnost 16 26 22 20
12 NK Bratstvo Gračanica Bratstvo 16 24 29 20
13 Orasje Orasje 16 24 32 18
14 Jedinstvo Bihac Jedinstvo 16 20 30 17
15 Slaven Živinice Slaven 16 15 24 13
16 Radnik Hadžići Radnik 16 17 31 13
TEMPORADA 2018/2019
PRIMERA FBIH BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Velež Mostar Velež 30 78 18 76
2 Olimpik Sarajevo Olimpik 30 58 18 69
3 TOSK Tesanj TOSK Tesanj 30 46 43 45
4 Goražde Goražde 30 48 36 44
5 Zvijezda Zvijezda 30 44 43 44
6 Orasje Orasje 30 37 36 44
7 Rudar Kakanj Rudar Kakanj 30 51 49 43
8 Jedinstvo Bihac Jedinstvo 30 31 41 43
9 Metalleghe-Bsi Jajce Metalleghe-B 30 39 38 42
10 NK Bratstvo Gračanica Bratstvo 30 36 37 42
11 Capljina Capljina 30 39 51 42
12 Slaven Živinice Slaven 30 41 41 41
13 Igman Konjic Igman Konjic 30 30 27 40
14 Vitez Vitez 30 28 41 34
15 Novi Travnik Novi Travnik 30 20 55 19
16 Bosna Visoko Bosna Visoko 30 16 68 12
TEMPORADA 2017/2018
PRIMERA FBIH BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 FK Tuzla City Tuzla City 30 61 23 66
2 Olimpik Sarajevo Olimpik 30 44 20 61
3 Velež Mostar Velež 31 49 23 56
4 Orasje Orasje 31 51 37 50
5 Zvijezda Zvijezda 30 38 25 50
6 NK Bratstvo Gračanica Bratstvo 30 50 42 45
7 Rudar Kakanj Rudar Kakanj 30 38 34 42
8 Metalleghe-Bsi Jajce Metalleghe-B 30 40 41 41
9 TOSK Tesanj TOSK Tesanj 30 35 38 38
10 Bosna Visoko Bosna Visoko 30 42 49 37
11 Slaven Živinice Slaven 30 33 46 37
12 Capljina Capljina 31 37 52 37
13 Igman Konjic Igman Konjic 30 31 35 36
14 Jedinstvo Bihac Jedinstvo 31 28 63 34
15 Iskra Bugojno Iskra 30 27 46 32
16 Travnik Travnik 30 21 51 17
TEMPORADA 2016/2017
PRIMERA FBIH BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 GOŠK Gabela GOŠK Gabela 30 50 26 56
2 Bosna Visoko Bosna Visoko 30 39 29 50
3 FK Tuzla City Tuzla City 30 43 36 48
4 Rudar Kakanj Rudar Kakanj 30 40 28 46
5 Capljina Capljina 30 34 25 46
6 Travnik Travnik 30 44 36 46
7 NK Bratstvo Gračanica Bratstvo 30 43 34 45
8 Zvijezda Zvijezda 30 40 32 45
9 Orasje Orasje 30 40 42 44
10 Jedinstvo Bihac Jedinstvo 30 34 37 44
11 Velež Mostar Velež 30 39 33 43
12 Goražde Goražde 30 35 32 43
13 FK Radnički Lukavac Radnički 30 37 51 36
14 Buducnost Banovici Buducnost 30 36 40 35
15 Bosna Sema Bosna Sema 30 38 46 32
16 Novi Travnik Novi Travnik 30 14 79 10
TEMPORADA 2015/2016
PRIMERA FBIH BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Metalleghe-Bsi Jajce Metalleghe-B 30 52 24 61
2 Zvijezda Zvijezda 30 49 26 59
3 Bosna Visoko Bosna Visoko 30 47 36 47
4 Orasje Orasje 30 41 30 47
5 Capljina Capljina 30 39 30 47
6 NK Bratstvo Gračanica Bratstvo 30 38 30 46
7 Buducnost Banovici Buducnost 30 34 27 46
8 GOŠK Gabela GOŠK Gabela 30 33 27 45
9 Rudar Kakanj Rudar Kakanj 30 41 32 44
10 Jedinstvo Bihac Jedinstvo 30 41 35 43
11 Goražde Goražde 30 31 31 42
12 Novi Travnik Novi Travnik 30 51 43 41
13 FK Radnički Lukavac Radnički 30 38 46 38
14 HNK Branitelj Branitelj 30 25 44 27
15 Ljubuski Ljubuski 30 17 39 21
16 NK Podgrmec NK Podgrmec 30 17 94 20
TEMPORADA 2014/2015
PRIMERA FBIH BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 NK Mladost Doboj Kakanj Mladost 30 39 25 59
2 GOŠK Gabela GOŠK Gabela 30 48 18 57
3 NK Bratstvo Gračanica Bratstvo 30 42 28 53
4 Buducnost Banovici Buducnost 30 37 27 53
5 Goražde Goražde 30 33 19 50
6 Metalleghe-Bsi Jajce Metalleghe-B 30 34 26 50
7 FK Radnički Lukavac Radnički 30 38 26 47
8 Jedinstvo Bihac Jedinstvo 30 31 23 43
9 Rudar Kakanj Rudar Kakanj 30 35 33 43
10 HNK Branitelj Branitelj 30 20 25 35
11 Orasje Orasje 30 33 42 35
12 Capljina Capljina 30 38 44 34
13 NK Podgrmec NK Podgrmec 30 27 41 34
14 Gradina Srebrenik Gradina 30 29 40 31
15 Turbina Jablanica Turbina 30 17 48 27
16 Igman Konjic Igman Konjic 30 20 56 13
TEMPORADA 2013/2014
PRIMERA FBIH BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Sloboda Tuzla Sloboda 30 61 16 71
2 Jedinstvo Bihac Jedinstvo 30 50 10 69
3 NK Bratstvo Gračanica Bratstvo 30 55 32 53
4 Rudar Kakanj Rudar Kakanj 30 37 23 50
5 Orasje Orasje 30 48 40 48
6 NK Mladost Doboj Kakanj Mladost 30 41 36 43
7 GOŠK Gabela GOŠK Gabela 30 42 34 42
8 Capljina Capljina 30 41 36 42
9 Gradina Srebrenik Gradina 30 29 30 41
10 FK Radnički Lukavac Radnički 30 37 27 40
11 HNK Branitelj Branitelj 30 39 32 39
12 Buducnost Banovici Buducnost 30 42 39 39
13 Igman Konjic Igman Konjic 30 37 53 39
14 NK Podgrmec NK Podgrmec 30 38 61 39
15 Iskra Bugojno Iskra 30 20 58 27
16 NK Troglav NK Troglav 30 8 98 5
TEMPORADA 2011/2012
PRIMERA FBIH BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Gradina Srebrenik Gradina 30 59 30 61
2 Buducnost Banovici Buducnost 30 47 32 54
3 Vitez Vitez 30 55 31 52
4 Rudar Kakanj Rudar Kakanj 30 51 33 52
5 Krajina Cazin Krajina 30 39 28 50
6 NK Bratstvo Gračanica Bratstvo 30 63 30 49
7 Capljina Capljina 30 42 34 48
8 Iskra Bugojno Iskra 30 42 34 48
9 Goražde Goražde 30 38 43 42
10 HNK Branitelj Branitelj 30 43 42 40
11 Jedinstvo Bihac Jedinstvo 30 48 46 39
12 Krajisnik Velika Krajisnik 30 41 42 38
13 Orasje Orasje 30 41 61 38
14 FK Famos Hrasnica Famos 30 34 38 37
15 Omladinac Omladinac 30 18 96 17
16 UNIS Vogošća UNIS 30 23 64 14
TEMPORADA 2010/2011
PRIMERA FBIH BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 GOŠK Gabela GOŠK Gabela 30 38 21 56
2 Capljina Capljina 30 49 41 48
3 Iskra Bugojno Iskra 30 45 35 47
4 Krajina Cazin Krajina 30 41 31 47
5 Orasje Orasje 30 40 31 47
6 Jedinstvo Bihac Jedinstvo 30 38 39 46
7 Goražde Goražde 30 50 39 45
8 Gradina Srebrenik Gradina 30 44 39 44
9 Krajisnik Velika Krajisnik 30 41 40 44
10 Rudar Kakanj Rudar Kakanj 30 46 44 43
11 FK Famos Hrasnica Famos 30 49 49 43
12 Omladinac Omladinac 30 37 39 42
13 Bosna Visoko Bosna Visoko 30 39 44 41
14 Slaven Živinice Slaven 30 27 42 34
15 Igman Konjic Igman Konjic 30 34 57 31
16 Radnik Hadžići Radnik 30 26 53 20
TEMPORADA 2009/2010
PRIMERA FBIH BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Buducnost Banovici Buducnost 28 52 20 62
2 Orasje Orasje 28 45 34 48
3 Iskra Bugojno Iskra 28 50 26 47
4 Rudar Kakanj Rudar Kakanj 28 40 29 47
5 FK Famos Hrasnica Famos 28 44 39 42
6 Bosna Visoko Bosna Visoko 28 47 41 41
7 GOŠK Gabela GOŠK Gabela 28 36 31 40
8 Igman Konjic Igman Konjic 28 41 37 40
9 Slaven Živinice Slaven 28 33 40 40
10 Krajisnik Velika Krajisnik 28 37 49 40
11 Omladinac Omladinac 28 37 49 38
12 Goražde Goražde 28 29 39 37
13 Jedinstvo Bihac Jedinstvo 28 33 47 37
14 Vitez Vitez 28 37 41 36
15 NK Žepce NK Žepce 28 21 60 12
TEMPORADA 2008/2009
LIGA BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Zrinjski Zrinjski 30 50 37 57
2 Slavija Slavija 30 36 28 52
3 Sloboda Tuzla Sloboda 30 32 26 50
4 Borac Banja Luka Borac Banja 30 45 26 49
5 Sarajevo Sarajevo 30 43 30 49
6 Siroki Brijeg Siroki 30 47 38 45
7 Zvijezda Zvijezda 30 43 38 43
8 Laktaši Laktaši 30 43 39 42
9 Željeznicar Željeznicar 30 30 35 42
10 Celik Zenica Celik Zenica 30 30 32 41
11 Leotar Leotar 30 32 43 39
12 Velež Mostar Velež 30 42 45 37
13 FK Modrica FK Modrica 30 37 41 37
14 Travnik Travnik 30 38 53 37
15 Orasje Orasje 30 33 43 34
16 Posušje Posušje 30 31 58 23
TEMPORADA 2007/2008
LIGA BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 FK Modrica FK Modrica 30 57 45 55
2 Siroki Brijeg Siroki 30 44 29 54
3 Celik Zenica Celik Zenica 30 38 32 52
4 Zrinjski Zrinjski 30 46 27 49
5 Sarajevo Sarajevo 30 42 29 48
6 Sloboda Tuzla Sloboda 30 44 38 47
7 Željeznicar Željeznicar 30 47 35 45
8 Slavija Slavija 30 39 44 44
9 Velež Mostar Velež 30 39 46 44
10 Laktaši Laktaši 30 42 40 43
11 Posušje Posušje 30 42 46 43
12 Orasje Orasje 30 50 45 42
13 Travnik Travnik 30 35 39 42
14 Leotar Leotar 30 38 45 41
15 Jedinstvo Bihac Jedinstvo 30 28 43 40
16 NK Žepce NK Žepce 30 25 73 7
TEMPORADA 2006/2007
LIGA BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Sarajevo Sarajevo 30 44 26 57
2 Zrinjski Zrinjski 30 67 40 55
3 Slavija Slavija 30 41 35 53
4 Siroki Brijeg Siroki 30 39 32 45
5 Željeznicar Željeznicar 30 51 40 44
6 FK Modrica FK Modrica 30 42 42 44
7 Leotar Leotar 30 47 48 43
8 Velež Mostar Velež 30 41 42 43
9 Jedinstvo Bihac Jedinstvo 30 46 58 43
10 NK Žepce NK Žepce 30 30 37 40
11 Posušje Posušje 30 42 51 40
12 Sloboda Tuzla Sloboda 30 36 45 40
13 Orasje Orasje 30 40 35 39
14 Borac Banja Luka Borac Banja 30 42 47 39
15 Celik Zenica Celik Zenica 30 29 34 39
16 Radnik Bijeljina Radnik 30 25 50 25
TEMPORADA 2005/2006
LIGA BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Siroki Brijeg Siroki 30 37 18 63
2 Sarajevo Sarajevo 30 57 26 60
3 Zrinjski Zrinjski 30 47 29 54
4 FK Modrica FK Modrica 30 50 31 53
5 Slavija Slavija 30 41 47 41
6 Željeznicar Željeznicar 30 38 32 40
7 Jedinstvo Bihac Jedinstvo 30 38 40 40
8 NK Žepce NK Žepce 30 28 40 40
9 Leotar Leotar 30 43 47 39
10 Sloboda Tuzla Sloboda 30 31 37 39
11 Posušje Posušje 30 38 46 39
12 Orasje Orasje 30 50 51 38
13 Radnik Bijeljina Radnik 30 37 52 38
14 Celik Zenica Celik Zenica 30 33 45 35
15 Travnik Travnik 30 33 41 34
16 Buducnost Banovici Buducnost 30 29 48 33
TEMPORADA 2004/2005
LIGA BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Zrinjski Zrinjski 30 56 30 61
2 Željeznicar Željeznicar 30 31 22 51
3 Siroki Brijeg Siroki 30 42 33 45
4 Sarajevo Sarajevo 30 39 37 45
5 Travnik Travnik 30 42 47 44
6 FK Modrica FK Modrica 30 38 32 42
7 Orasje Orasje 30 46 44 42
8 Buducnost Banovici Buducnost 30 37 40 42
9 Posušje Posušje 30 35 44 42
10 Slavija Slavija 30 36 34 41
11 Sloboda Tuzla Sloboda 30 30 28 41
12 NK Žepce NK Žepce 30 33 36 41
13 Celik Zenica Celik Zenica 30 29 37 41
14 Leotar Leotar 30 35 45 41
15 Borac Banja Luka Borac Banja 30 36 39 40
16 Rudar Ugljevik Rudar 30 26 43 25
TEMPORADA 2003/2004
LIGA BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Siroki Brijeg Siroki 30 58 32 61
2 Željeznicar Željeznicar 30 67 35 59
3 Sarajevo Sarajevo 30 58 25 56
4 Leotar Leotar 30 46 23 56
5 Sloboda Tuzla Sloboda 30 38 36 42
6 FK Modrica FK Modrica 30 43 43 40
7 Borac Banja Luka Borac Banja 30 40 42 39
8 Orasje Orasje 30 40 51 39
9 Rudar Ugljevik Rudar 30 31 43 39
10 Posušje Posušje 30 35 48 39
11 Zrinjski Zrinjski 30 40 47 38
12 Celik Zenica Celik Zenica 30 42 43 37
13 NK Žepce NK Žepce 30 26 38 37
14 Travnik Travnik 30 30 43 37
15 Glasinac Sokolac Glasinac 30 34 49 33
16 Brotnjo Citluk Brotnjo 30 29 59 19
TEMPORADA 2002/2003
LIGA BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Leotar Leotar 38 82 27 85
2 Željeznicar Željeznicar 38 66 24 82
3 Sarajevo Sarajevo 38 83 39 69
4 Siroki Brijeg Siroki 38 69 45 68
5 Celik Zenica Celik Zenica 38 61 33 58
6 Sloboda Tuzla Sloboda 38 51 38 54
7 Borac Banja Luka Borac Banja 38 50 49 54
8 Orasje Orasje 38 50 57 54
9 Posušje Posušje 38 42 55 54
10 NK Žepce NK Žepce 38 49 50 53
11 Zrinjski Zrinjski 38 46 65 53
12 Rudar Ugljevik Rudar 38 61 57 52
13 Brotnjo Citluk Brotnjo 38 47 55 52
14 Glasinac Sokolac Glasinac 38 37 54 52
15 Kozara Gradiška Kozara 38 55 62 51
16 Jedinstvo Bihac Jedinstvo 38 59 63 50
17 Velež Mostar Velež 38 47 59 45
18 Mladost Gacko Mladost 38 40 65 39
19 Buducnost Banovici Buducnost 38 48 67 38
20 Bosna Visoko Bosna Visoko 38 28 107 13
TEMPORADA 2001/2002
LIGA BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Željeznicar Željeznicar 30 60 26 62
2 Siroki Brijeg Siroki 30 43 24 51
3 Brotnjo Citluk Brotnjo 30 45 27 47
4 Sarajevo Sarajevo 30 50 34 47
5 Zrinjski Zrinjski 30 35 39 46
6 Celik Zenica Celik Zenica 30 39 30 43
7 Orasje Orasje 30 38 38 43
8 Velež Mostar Velež 30 44 46 42
9 Jedinstvo Bihac Jedinstvo 30 33 39 41
10 Sloboda Tuzla Sloboda 30 32 28 40
11 Posušje Posušje 30 30 38 40
12 Bosna Visoko Bosna Visoko 30 33 48 39
13 Olimpik Sarajevo Olimpik 30 40 46 38
14 NK Troglav NK Troglav 30 33 49 32
15 Grude Grude 30 23 43 31
16 Iskra Bugojno Iskra 30 25 48 29

  USO DE MEMORIA  
7,320,584 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1259
Total Execution Time  0.1273
  CADENA URL  
/historico/Orasje
  GET DATOS  
$_GET['/historico/Orasje']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13130 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=364 AND type_rel = 3
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 364 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0020  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 (743245,312189) ORDER BY n.cover_points DESC, update_date DESC
0.0022  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 = '13130' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = '13130' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = '13130' 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 = '13130' and rp.type = 4
0.0019  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 = '13130' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 events2022 e ON e.player_id = p.id AND e.league_id = 63323 WHERE rp.league_id = 63323 AND rp.teamId = 13130 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.0020  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 events2022 e ON e.player_id = p.id AND e.league_id = 63323 WHERE rp.league_id = 63323 AND rp.teamId = 13130 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 events2022 e ON e.player_id = p.id AND e.league_id = 63323 WHERE rp.league_id = 63323 AND rp.teamId = 13130 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 13130 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2022` 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 = 63323 AND t.round = 30 ORDER BY team.conference ASC,t.position 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 `tables2021` 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 = 57037 AND t.round = 30 ORDER BY team.conference ASC,t.position 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 `tables2020` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 50481 AND t.round = 18 ORDER BY team.conference ASC,t.position 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 `tables2019` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 44445 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 `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 = 38757 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 `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 = 33560 AND t.round = 30 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 `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 = 15787 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 `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 = 4505 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0042  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 = 8986 AND t.round = 30 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 `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 = 9003 AND t.round = 30 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 `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 = 9001 AND t.round = 30 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 `tables2010` 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 = 8999 AND t.round = 30 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 `tables2009` 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 = 8979 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 `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 = 8977 AND t.round = 30 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 `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 = 8975 AND t.round = 30 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 `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 = 8973 AND t.round = 30 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 `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 = 8972 AND t.round = 30 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 `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 = 8970 AND t.round = 30 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 `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 = 8965 AND t.round = 38 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 `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 = 33840 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC