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

Rukh Lviv

Entrenador: Vitaliy Ponomarev

Temporada 2023/2024
TEMPORADA 2023/2024
LIGA UCRANIANA
Equipo PJ GF GC Puntos
1 Shakhtar Donetsk Shakhtar 26 58 21 64
2 Dynamo Kyiv Dynamo Kyiv 26 62 25 60
3 FC Kryvbas FC Kryvbas 26 47 25 54
4 Dnipro-1 Dnipro-1 26 36 25 45
5 Rukh Lviv Rukh Lviv 26 39 27 44
6 Polissya Zhytomyr Polissya 26 32 26 42
7 LNZ Cherkasy Cherkasy 26 25 31 32
8 Vorskla Poltava Vorskla 26 23 38 30
9 Kolos Kovalivka Kolos 25 18 19 29
10 Chornomorets Odessa Chornomorets 26 35 40 29
11 Zorya Luhansk Zorya 25 25 32 27
12 Oleksandriya Oleksandriya 26 22 34 26
13 Obolon Obolon 26 16 35 22
14 Veres Rivne Veres Rivne 26 23 41 20
15 Minai Minai 26 20 40 19
16 Metalist 1925 Kharkiv Metalist 26 25 47 19
TEMPORADA 2022/2023
LIGA UCRANIANA
Equipo PJ GF GC Puntos
1 Shakhtar Donetsk Shakhtar 30 69 21 72
2 Dnipro-1 Dnipro-1 30 61 27 67
3 Zorya Luhansk Zorya 30 61 34 64
4 Dynamo Kyiv Dynamo Kyiv 30 51 25 60
5 Vorskla Poltava Vorskla 30 38 37 45
6 Oleksandriya Oleksandriya 30 42 39 44
7 FC Kryvbas FC Kryvbas 30 26 30 41
8 Minai Minai 30 25 30 36
9 Kolos Kovalivka Kolos 30 23 36 36
10 Chornomorets Odessa Chornomorets 30 35 40 35
11 Rukh Lviv Rukh Lviv 30 31 37 32
12 Metalist 1925 Kharkiv Metalist 30 23 42 32
13 Veres Rivne Veres Rivne 30 35 45 31
14 Inhulets Inhulets 30 22 34 31
15 Metalist Kharkiv Metalist 30 27 58 22
16 FC Lviv FC Lviv 30 18 52 13
TEMPORADA 2021/2022
LIGA UCRANIANA
Equipo PJ GF GC Puntos
1 Shakhtar Donetsk Shakhtar 18 49 10 47
2 Dynamo Kyiv Dynamo Kyiv 18 47 9 45
3 Dnipro-1 Dnipro-1 18 35 17 40
4 Zorya Luhansk Zorya 18 37 19 36
5 Vorskla Poltava Vorskla 18 30 18 33
6 Oleksandriya Oleksandriya 18 19 16 26
7 Desna Chernihiv Desna 18 22 27 25
8 Kolos Kovalivka Kolos 18 14 23 24
9 Veres Rivne Veres Rivne 18 15 20 23
10 Metalist 1925 Kharkiv Metalist 18 17 29 19
11 Rukh Lviv Rukh Lviv 17 16 21 18
12 FC Lviv FC Lviv 18 14 30 17
13 Chornomorets Odessa Chornomorets 18 20 40 14
14 Inhulets Inhulets 17 13 28 13
15 Minai Minai 18 12 30 10
16 FC Mariupol FC Mariupol 18 21 44 8
TEMPORADA 2020/2021
LIGA UCRANIANA
Equipo PJ GF GC Puntos
1 Dynamo Kyiv Dynamo Kyiv 26 59 15 65
2 Shakhtar Donetsk Shakhtar 26 54 19 54
3 Zorya Luhansk Zorya 26 44 22 50
4 Kolos Kovalivka Kolos 26 36 26 41
5 Vorskla Poltava Vorskla 26 37 30 41
6 Desna Chernihiv Desna 26 38 32 38
7 Dnipro-1 Dnipro-1 26 36 38 30
8 FC Lviv FC Lviv 26 25 51 29
9 Oleksandriya Oleksandriya 26 33 37 29
10 Rukh Lviv Rukh Lviv 26 27 39 28
11 FC Mariupol FC Mariupol 26 27 41 26
12 Inhulets Inhulets 26 24 39 26
13 Olimpik Donetsk Olimpik 26 28 48 22
14 Minai Minai 26 16 47 18
TEMPORADA 2019/2020
SEGUNDA UCRANIA
Equipo PJ GF GC Puntos
1 Minai Minai 30 51 28 62
2 Inhulets Inhulets 30 47 22 60
3 Ahrobiznes Volochysk Ahrobiznes 30 52 30 60
4 Rukh Lviv Rukh Lviv 29 48 21 58
5 Volyn Lutsk Volyn Lutsk 30 57 36 57
6 Obolon Obolon 30 40 31 51
7 Metalist 1925 Kharkiv Metalist 30 44 34 51
8 Avanhard Kramatorsk Avanhard 30 37 40 45
9 Hirnyk-Sport Hirnyk-Sport 30 42 48 39
10 Chornomorets Odessa Chornomorets 30 40 37 39
11 MFK Mykolaiv Mykolaiv 30 45 45 34
12 FC Prykarpattia Prykarpattia 30 44 51 30
13 Kremin Kremin 30 35 57 27
14 Balkany Zorya Balkany 30 27 51 25
15 Metalurh Zaporizhya Metalurh 29 28 55 22
16 Cherkashchyna-Akademiya Cherkashchyn 30 23 74 7
TEMPORADA 2018/2019
SEGUNDA UCRANIA
Equipo PJ GF GC Puntos
1 Dnipro-1 Dnipro-1 28 72 21 67
2 Volyn Lutsk Volyn Lutsk 28 55 30 58
3 Kolos Kovalivka Kolos 28 49 18 54
4 Metalist 1925 Kharkiv Metalist 27 35 20 48
5 Avanhard Kramatorsk Avanhard 27 44 26 45
6 Obolon Obolon 27 35 28 44
7 Inhulets Inhulets 27 35 32 39
8 MFK Mykolaiv Mykolaiv 28 36 32 37
9 Balkany Zorya Balkany 27 28 31 35
10 Rukh Lviv Rukh Lviv 28 37 36 34
11 FC Prykarpattia Prykarpattia 27 41 39 31
12 Hirnyk-Sport Hirnyk-Sport 27 24 43 24
13 Sumy Sumy 27 21 88 16
14 Ahrobiznes Volochysk Ahrobiznes 26 14 36 13
15 Zirka Kirovohrad Zirka 17 10 49 4
16 Helios Kharkiv Helios 3 1 8 0
TEMPORADA 2017/2018
SEGUNDA UCRANIA
Equipo PJ GF GC Puntos
1 Arsenal Kyiv Arsenal Kyiv 34 59 23 75
2 Poltava Poltava 34 56 26 72
3 Desna Chernihiv Desna 34 71 25 71
4 Inhulets Inhulets 34 46 20 69
5 Kolos Kovalivka Kolos 34 39 30 61
6 Avanhard Kramatorsk Avanhard 34 44 42 52
7 Hirnyk-Sport Hirnyk-Sport 34 30 40 50
8 Rukh Lviv Rukh Lviv 33 36 30 48
9 Helios Kharkiv Helios 33 35 43 46
10 MFK Mykolaiv Mykolaiv 34 39 50 44
11 Balkany Zorya Balkany 34 30 35 40
12 Sumy Sumy 33 29 39 37
13 Volyn Lutsk Volyn Lutsk 34 31 44 36
14 Naftovyk-Ukrnafta Okhtyrka Naftovyk-Ukr 34 27 42 33
15 Obolon Obolon 33 24 37 32
16 Cherkashchyna-Akademiya Cherkashchyn 34 29 49 29
17 Kremin Kremin 33 25 54 29
18 Zhemchuzhyna Odesa Zhemchuzhyna 31 33 54 27
TEMPORADA 2016/2017
TERCERA UCRANIA
Equipo PJ GF GC Puntos
1 Zhemchuzhyna Odesa Zhemchuzhyna 32 75 22 74
2 Rukh Lviv Rukh Lviv 32 68 24 72
3 Kremin Kremin 32 67 29 68
4 Real Pharma Real Pharma 32 50 31 55
5 Balkany Zorya Balkany 31 54 32 54
6 Inhulets II Inhulets II 32 50 33 48
7 FC Nyva Vinnytsya Nyva 32 42 33 48
8 Myr Myr 32 39 28 47
9 Enerhiya Nova Kakhovka Enerhiya 32 62 46 46
10 Teplovyk Teplovyk 32 51 35 44
11 Nikopol Nikopol 32 40 49 41
12 Krystal Krystal 31 31 24 38
13 Illichivets II Illichivets 32 42 56 32
14 Podillya Khmelnytskyi Podillya 32 29 68 23
15 Arsenal Bila Tserkva Arsenal Bila 32 29 82 23
16 Metalurh Zaporizhya Metalurh 32 32 104 21
17 Sudnobudivnyk Sudnobudivny 32 19 84 20

  USO DE MEMORIA  
6,071,760 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4470
Total Execution Time  0.4483
  CADENA URL  
/historico/Rukh-Vynnyky
  GET DATOS  
$_GET['/historico/Rukh-Vynnyky']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=89520 AND type_rel = 2
0.0132  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 = '89520' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0133  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 = 73212 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0135  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 = 72212 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0143  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=89520 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0134  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 (73212,72212,71432) 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.0144  SELECT count(id) as num_players from rel_players WHERE league_id = 72212 AND teamId = 89520
0.0150  SELECT count(id) as num_players from rel_players WHERE league_id = 73212 AND teamId = 89520
0.0152  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 89520
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 FROM `tables2024` 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 = 72212 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0133  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 = '89520' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0127  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '89520' and rp.type = 4
0.0133  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 = '89520' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0176  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 events2024 e ON e.player_id = p.id AND e.league_id = 72212 WHERE rp.league_id = 72212 AND rp.teamId = 89520 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.0172  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 events2024 e ON e.player_id = p.id AND e.league_id = 72212 WHERE rp.league_id = 72212 AND rp.teamId = 89520 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0143  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 events2024 e ON e.player_id = p.id AND e.league_id = 72212 WHERE rp.league_id = 72212 AND rp.teamId = 89520 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130  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 = 89520 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2024` 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 = 72212 AND t.round = 26 ORDER BY team.conference ASC,t.position 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 `tables2023` 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 = 68061 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.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 `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 = 62931 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 58446 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 44344 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 = 38758 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142  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 = 33939 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  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 = 72212 ORDER BY nameShow LIMIT 100