4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Ruch Radzionków
TEMPORADA 2018/2019
CUARTA POLONIA GRUPO 3
Equipo PJ GF GC Puntos
1 Gornik Polkowice Gornik 34 81 32 79
2 Ślęza Wrocław Ślęza 34 68 33 66
3 Zagłębie Lubin II Zagłębie 34 70 32 64
4 Rekord Bielsko Biała Rekord 34 52 42 57
5 Gwarek Tarnowskie Gory Gwarek 34 53 43 54
6 Górnik Zabrze II Górnik 34 57 49 52
7 Ruch Zdzieszowice Ruch 34 49 44 52
8 Pawłowice Śląskie Pawłowice 34 50 38 49
9 Piast Żmigród Piast 34 49 50 49
10 Miedz Legnica II Miedz 34 51 54 45
11 Foto-Higiena Gac Foto-Higiena 34 52 54 44
12 Stal Brzeg Stal Brzeg 34 51 47 43
13 Kluczbork Kluczbork 34 33 41 42
14 Warta Gorzów Warta 34 35 47 37
15 Agroplon Głuszyna Agroplon 34 40 73 34
16 Ruch Radzionków Ruch 34 38 72 32
17 Lechia Dzierżoniów Lechia 34 43 74 26
18 Stilon Gorzów Stilon 34 29 76 25
TEMPORADA 2013/2014
CUARTA POLONIA GRUPO 6
Equipo PJ GF GC Puntos
1 SKRA Częstochowa SKRA 22 51 13 54
2 Górnik Wesoła Górnik 22 42 19 44
3 Ruch Chorzów II Ruch 22 49 28 40
4 Piast Gliwice II Piast 22 38 30 40
5 Polonia Łaziska Górne Polonia 22 43 28 39
6 Swornica Czarnowąsy Swornica 22 37 27 33
7 Szombierki Bytom Szombierki 22 40 34 29
8 Ruch Radzionków Ruch 22 25 33 28
9 LZS Piotrówka Piotrówka 22 25 24 26
10 Start Namysłów Start 22 16 57 16
11 Piast Strzelce Opolskie Piast 22 23 62 14
12 Szczakowianka Jaworzno Szczakowiank 22 17 51 10
TEMPORADA 2011/2012
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 Piast Gliwice Piast 34 57 40 64
2 Pogon Szczecin Pogon 34 54 30 61
3 Zawisza Bydgoszcz Zawisza 34 47 39 59
4 Kolejarz Stroze Kolejarz 34 40 34 57
5 Termalica Nieciecza Termalica 34 42 26 56
6 Górnik Łęczna Górnik 34 50 37 54
7 Arka Gdynia Arka Gdynia 34 50 41 51
8 Swinoujscie Swinoujscie 34 46 43 49
9 Ruch Radzionków Ruch 34 46 51 48
10 Warta Poznan Warta Poznan 34 44 36 46
11 Olimpia Grudziadz Olimpia 34 46 41 43
12 Sandecja Nowy Sacz Sandecja 34 42 46 40
13 GKS Katowice Katowice 34 33 38 39
14 Dolcan Zabki Dolcan Zabki 34 40 53 39
15 TS Polonia Bytom Polonia 34 37 51 36
16 Wisła Płock Wisła 34 39 50 35
17 Gornik Polkowice Gornik 34 40 64 30
18 Olimpia Elblag Olimpia 34 33 66 22
TEMPORADA 2010/2011
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 LKS Lódz LKS Lódz 34 59 34 71
2 Podbeskidzie Podbeskidzie 34 53 23 69
3 Swinoujscie Swinoujscie 34 58 34 66
4 Sandecja Nowy Sacz Sandecja 34 52 34 56
5 Piast Gliwice Piast 34 45 31 52
6 Pogon Szczecin Pogon 34 55 42 51
7 Górnik Łęczna Górnik 34 44 39 50
8 Warta Poznan Warta Poznan 34 44 43 50
9 Ruch Radzionków Ruch 34 34 32 46
10 Gornik Polkowice Gornik 34 31 39 42
11 GKS Katowice Katowice 34 47 57 41
12 Kolejarz Stroze Kolejarz 34 30 43 38
13 Dolcan Zabki Dolcan Zabki 34 33 39 37
14 Termalica Nieciecza Termalica 34 40 53 37
15 Kluczbork Kluczbork 34 36 44 36
16 KSZO Ostrowiec KSZO 34 32 43 36
17 Odra Wodzislaw Slaski Odra 34 29 58 32
18 Warta Gorzów Warta 34 28 62 29
TEMPORADA 2009/2010
TERCERA POLONIA GRUPO 1
Equipo PJ GF GC Puntos
1 Ruch Radzionków Ruch 34 61 25 76
2 Gornik Polkowice Gornik 34 56 31 68
3 Zagłębie Sosnowiec Zagłębie 34 44 21 62
4 Zawisza Bydgoszcz Zawisza 34 54 30 59
5 Nielba Wagrowiec Nielba 34 48 38 55
6 Olimpia Grudziadz Olimpia 34 44 40 53
7 Jarota Jarocin Jarota 34 42 39 48
8 GKS Tychy GKS Tychy 34 40 41 48
9 Czarni Żagań Czarni 34 46 42 47
10 Raków Częstochowa Raków 34 38 31 45
11 Bałtyk Gdynia Bałtyk 34 44 38 41
12 Polonia Słubice Polonia 34 31 47 39
13 Zielona Góra Zielona 34 33 54 36
14 Tur Turek Tur Turek 34 27 36 35
15 Miedz Legnica Miedz 34 33 58 35
16 TKP Elana Torun Elana Torun 34 31 47 34
17 Unia Janikowo Unia 34 44 72 33
18 Ślęza Wrocław Ślęza 34 30 56 22
TEMPORADA 2008/2009
CUARTA POLONIA GRUPO 6
Equipo PJ GF GC Puntos
1 Ruch Radzionków Ruch 30 66 17 72
2 Stal Bielsko Biała Stal Bielsko 30 55 19 64
3 Leśnica Leśnica 30 44 26 55
4 Ruch Zdzieszowice Ruch 30 55 29 49
5 Walka Makoszowy Walka 30 36 31 45
6 Orzeł Babienica Psary Orzeł 30 44 31 44
7 Rozwoj Katowice Rozwoj 30 42 33 43
8 KS Beskid Skoczów Beskid 29 31 29 41
9 Energetyk ROW Rybnik Energetyk 30 48 41 40
10 Pawłowice Śląskie Pawłowice 29 46 36 39
11 Krasiejów Krasiejów 29 33 40 35
12 Victoria Chróścice Victoria 29 32 37 34
13 Skalnik Gracze Skalnik 30 32 54 32
14 TOR Dobrzeń Wielki Dobrzeń 30 27 56 31
15 Silesius Kotórz Maly Silesius 30 17 73 20
16 TS 1910 Koszarawa Zywiec 1910 30 13 69 17
TEMPORADA 2002/2003
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 Gornik Polkowice Gornik 34 60 20 76
2 Swit Nowy Dwor Swit Nowy D. 34 41 28 67
3 Górnik Łęczna Górnik 34 44 31 65
4 GKS Bełchatów Bełchatów 34 54 23 64
5 Aluminium Aluminium 34 41 39 48
6 Ceramika Opoczno Ceramika 34 43 38 47
7 Arka Gdynia Arka Gdynia 34 38 34 47
8 LKS Lódz LKS Lódz 34 33 30 46
9 Piotrcovia Piotrcovia 34 42 40 46
10 Radomsko Radomsko 34 34 33 46
11 Polar Polar 34 45 42 45
12 Podbeskidzie Podbeskidzie 34 35 35 42
13 Tloki Tloki 34 38 41 41
14 Stal Stalowa Wola Stal Stalowa 34 30 46 38
15 Śląsk Wrocław Śląsk 34 35 48 34
16 Ruch Radzionków Ruch 34 29 44 34
17 Hetman Zamosc Hetman 34 32 60 28
18 Stomil Olsztyn Stomil 34 26 68 22
TEMPORADA 2001/2002
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 Lech Poznań Lech Poznań 38 64 18 88
2 Wisła Płock Wisła 38 50 24 73
3 Szczakowianka Jaworzno Szczakowiank 38 61 50 66
4 Górnik Łęczna Górnik 38 49 35 62
5 GKS Bełchatów Bełchatów 38 55 46 58
6 Ceramika Opoczno Ceramika 38 53 50 54
7 Hetman Zamosc Hetman 38 47 43 51
8 Ruch Radzionków Ruch 38 52 51 50
9 Polar Polar 38 49 50 50
10 Tloki Tloki 38 42 56 49
11 Gornik Polkowice Gornik 38 34 35 48
12 Arka Gdynia Arka Gdynia 38 39 41 48
13 LKS Lódz LKS Lódz 38 36 38 47
14 Swit Nowy Dwor Swit Nowy D. 38 36 50 47
15 Jagiellonia Bialystok Jagiellonia 38 41 41 45
16 Hutnik Nowa Huta Hutnik Nowa 38 48 61 44
17 Zagłębie Sosnowiec Zagłębie 38 41 47 43
18 Wlokniarz Kietrz Wlokniarz 38 34 53 41
19 Odra Opole Odra Opole 38 40 61 41
20 Myszków Myszków 38 35 56 33
TEMPORADA 2000/2001
LIGA POLACA
Equipo PJ GF GC Puntos
1 Wisla Kraków Wisla 30 66 27 62
2 Pogon Szczecin Pogon 30 43 33 53
3 Legia Warszawa Legia 30 45 29 50
4 Polonia Warszawa Polonia 30 38 30 46
5 Zaglebie Lubin Zaglebie 30 43 40 46
6 Ruch Chorzów Ruch 30 50 46 44
7 Amica Wronki Amica Wronki 30 48 44 44
8 GKS Katowice Katowice 30 28 22 42
9 Odra Wodzislaw Slaski Odra 30 39 46 39
10 Dyskobolia Grodzisk Dyskobolia 30 35 38 37
11 Śląsk Wrocław Śląsk 30 32 38 36
12 Widzew Łódź Widzew 30 33 40 36
13 Górnik Zabrze Górnik 30 29 35 34
14 Stomil Olsztyn Stomil 30 22 41 34
15 Wisła Płock Wisła 30 37 55 31
16 Ruch Radzionków Ruch 30 27 51 31
TEMPORADA 1999/2000
LIGA POLACA
Equipo PJ GF GC Puntos
1 Polonia Warszawa Polonia 30 57 25 65
2 Wisla Kraków Wisla 30 64 38 56
3 Ruch Chorzów Ruch 30 53 32 55
4 Legia Warszawa Legia 30 53 34 52
5 Zaglebie Lubin Zaglebie 30 42 37 45
6 Amica Wronki Amica Wronki 30 43 37 44
7 Widzew Łódź Widzew 30 48 54 40
8 Odra Wodzislaw Slaski Odra 30 34 38 37
9 Stomil Olsztyn Stomil 30 33 43 37
10 Ruch Radzionków Ruch 30 38 49 37
11 Dyskobolia Grodzisk Dyskobolia 30 29 46 36
12 Pogon Szczecin Pogon 30 42 53 34
13 Petrochemia Petrochemia 30 35 49 34
14 Górnik Zabrze Górnik 30 42 41 32
15 LKS Lódz LKS Lódz 30 28 42 28
16 Lech Poznań Lech Poznań 30 34 57 25
TEMPORADA 1998/1999
LIGA POLACA
Equipo PJ GF GC Puntos
1 Wisla Kraków Wisla 30 75 23 73
2 Widzew Łódź Widzew 30 50 33 56
3 Legia Warszawa Legia 30 41 25 56
4 Lech Poznań Lech Poznań 30 55 36 54
5 Polonia Warszawa Polonia 30 38 31 46
6 Ruch Radzionków Ruch 30 40 35 41
7 Górnik Zabrze Górnik 30 34 31 39
8 Zaglebie Lubin Zaglebie 30 42 44 38
9 Stomil Olsztyn Stomil 30 29 38 37
10 Ruch Chorzów Ruch 30 23 36 36
11 Amica Wronki Amica Wronki 30 31 39 34
12 LKS Lódz LKS Lódz 30 33 45 34
13 Pogon Szczecin Pogon 30 33 54 33
14 Odra Wodzislaw Slaski Odra 30 33 41 32
15 GKS Bełchatów Bełchatów 30 26 48 28
16 GKS Katowice Katowice 30 25 49 23

  USO DE MEMORIA  
6,341,160 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1397
Total Execution Time  0.1409
  CADENA URL  
/historico/Ruch-Radzionkow
  GET DATOS  
$_GET['/historico/Ruch-Radzionkow']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (50)  
0.0023  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 = 'Ruch-Radzionkow' 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.0036  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 = 'Ruch-Radzionkow' 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=59516 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=59516 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=59516 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=59516 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=59516 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=59516 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=59516 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=59516 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=59516 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=59516 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=59516 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=59516 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=59516 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=59516 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=59516 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=59516 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=59516 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=59516 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=59516 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=59516 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=59516 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 = 44318
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=59516 AND type_rel = 2
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 = '59516' AND l.year = 2019 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 = '59516' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = '59516' 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 = 44318 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=59516 AND l.year in (2018,2019,2020) 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 (49506,44318) 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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 44318 AND teamId = 59516
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 49506 AND teamId = 59516
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 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 = 44318 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '59516' 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 = '59516' 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 = '59516' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0029  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 events2019 e ON e.player_id = p.id AND e.league_id = 44318 WHERE rp.league_id = 44318 AND rp.teamId = 59516 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.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 events2019 e ON e.player_id = p.id AND e.league_id = 44318 WHERE rp.league_id = 44318 AND rp.teamId = 59516 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 events2019 e ON e.player_id = p.id AND e.league_id = 44318 WHERE rp.league_id = 44318 AND rp.teamId = 59516 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 = 59516 AND l.year <= 2019 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 44318 AND t.round = 34 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 `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 = 28018 AND t.round = 22 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 `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 = 8848 AND t.round = 34 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 `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 = 25051 AND t.round = 34 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 `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 = 28092 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 `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 = 8800 AND t.round = 30 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 `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 = 8803 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 `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 = 8805 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 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 = 44318 ORDER BY nameShow LIMIT 100