4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del MFC Zhytomyr
TEMPORADA 2004/2005
SEGUNDA UCRANIA
Equipo PJ GF GC Puntos
1 Stal Alchevsk Stal 34 63 24 77
2 Arsenal Kharkiv Arsenal 34 50 24 73
3 Zorya Luhansk Zorya 34 57 21 66
4 Dynamo Kyiv II Dynamo Kyiv 34 51 33 54
5 FC Nyva Vinnytsya Nyva 34 52 38 53
6 Karpaty Lviv Karpaty Lviv 34 42 35 52
7 CSKA Kyiv CSKA Kyiv 34 34 38 51
8 Spartak Ivano-Frankivsk Spartak 34 37 33 50
9 Naftovyk-Ukrnafta Okhtyrka Naftovyk-Ukr 34 40 29 49
10 Stal Dniprodzerzhynsk Stal 34 45 47 49
11 Shakhtar Donetsk II Shakhtar 34 51 53 44
12 Gazovik-Skala Gazovik-Skal 34 37 42 43
13 Dynamo Khmelnytskyi Dynamo 34 48 54 43
14 Ihroservice Simferopol Ihroservice 34 41 57 41
15 Spartak Sumy Spartak Sumy 34 37 41 39
16 Nafkom Brovary Nafkom 34 29 38 37
17 MFK Mykolaiv Mykolaiv 34 21 40 31
18 MFC Zhytomyr Zhytomyr 34 5 93 2
TEMPORADA 2003/2004
SEGUNDA UCRANIA
Equipo PJ GF GC Puntos
1 Goverla Goverla 34 49 27 70
2 Metalist Kharkiv Metalist 34 51 24 66
3 Naftovyk-Ukrnafta Okhtyrka Naftovyk-Ukr 34 52 33 62
4 Dynamo Kyiv II Dynamo Kyiv 34 65 35 59
5 Stal Alchevsk Stal 34 45 27 58
6 Spartak Ivano-Frankivsk Spartak 34 42 38 55
7 FC Nyva Vinnytsya Nyva 34 34 24 52
8 Arsenal Kharkiv Arsenal 34 41 40 52
9 Spartak Sumy Spartak Sumy 34 40 41 46
10 Shakhtar Donetsk II Shakhtar 34 43 43 44
11 MFK Mykolaiv Mykolaiv 34 31 31 42
12 CSKA Kyiv CSKA Kyiv 34 29 39 42
13 Krasyliv Krasyliv 34 34 54 40
14 Nafkom Brovary Nafkom 34 35 43 38
15 Zorya Luhansk Zorya 34 28 41 37
16 Karpaty II Karpaty II 34 37 48 33
17 Inter Boyarka Inter 34 29 52 29
18 MFC Zhytomyr Zhytomyr 34 22 67 16
TEMPORADA 2002/2003
SEGUNDA UCRANIA
Equipo PJ GF GC Puntos
1 Zirka Kirovohrad Zirka 34 46 22 71
2 Borisfen Borisfen 34 45 16 66
3 Dynamo Kyiv II Dynamo Kyiv 34 57 28 64
4 Stal Alchevsk Stal 34 38 33 52
5 MFK Mykolaiv Mykolaiv 34 32 37 52
6 Naftovyk-Ukrnafta Okhtyrka Naftovyk-Ukr 34 37 27 51
7 Goverla Goverla 34 29 26 51
8 Krasyliv Krasyliv 34 43 37 49
9 Arsenal Kharkiv Arsenal 34 38 43 46
10 Spartak Sumy Spartak Sumy 34 34 43 45
11 MFC Zhytomyr Zhytomyr 34 31 38 43
12 Shakhtar Donetsk II Shakhtar 34 34 40 42
13 Karpaty II Karpaty II 34 35 39 41
14 CSKA Kyiv CSKA Kyiv 34 33 38 41
15 Inter Boyarka Inter 34 28 28 40
16 FC Nyva Vinnytsya Nyva 34 18 31 36
17 Spartak Ivano-Frankivsk Spartak 34 27 54 29
18 Sokil Zolochiv Sokil 34 24 49 22
TEMPORADA 2001/2002
SEGUNDA UCRANIA
Equipo PJ GF GC Puntos
1 Volyn Lutsk Volyn Lutsk 34 56 24 78
2 Chornomorets Odessa Chornomorets 34 48 21 67
3 Obolon Obolon 34 49 26 62
4 MFC Zhytomyr Zhytomyr 33 41 32 58
5 Spartak Ivano-Frankivsk Spartak 34 41 27 53
6 Stal Alchevsk Stal 34 42 34 50
7 Naftovyk-Ukrnafta Okhtyrka Naftovyk-Ukr 34 35 32 49
8 Dynamo Kyiv II Dynamo Kyiv 34 42 32 47
9 Shakhtar Donetsk II Shakhtar 34 50 46 46
10 Zirka Kirovohrad Zirka 34 29 28 46
11 MFK Mykolaiv Mykolaiv 34 37 44 46
12 Karpaty II Karpaty II 34 41 52 42
13 Borisfen Borisfen 33 43 45 40
14 CSKA Kyiv CSKA Kyiv 34 32 39 39
15 FC Nyva Vinnytsya Nyva 34 35 52 38
16 Elektrometalurh Elektrometal 34 30 41 37
17 Dnipro II Dnipro II 34 29 48 31
18 Nyva Ternopil Nyva 34 20 77 13
TEMPORADA 1999/2000
SEGUNDA UCRANIA
Equipo PJ GF GC Puntos
1 Dynamo Kyiv II Dynamo Kyiv 34 76 22 73
2 Stal Alchevsk Stal 34 59 36 70
3 Dnipro Cherkasy Dnipro 34 49 34 59
4 Shakhtar Donetsk II Shakhtar 34 48 38 56
5 CSKA Kyiv CSKA Kyiv 34 40 26 54
6 MFK Mykolaiv Mykolaiv 34 41 38 52
7 FC Lviv FC Lviv 34 35 31 51
8 Oleksandriya Oleksandriya 34 35 34 49
9 Volyn Lutsk Volyn Lutsk 34 44 41 48
10 Spartak Sumy Spartak Sumy 34 43 45 48
11 Elektrometalurh Elektrometal 34 32 34 48
12 FC Nyva Vinnytsya Nyva 34 30 39 48
13 Goverla Goverla 34 37 49 48
14 Naftovyk-Ukrnafta Okhtyrka Naftovyk-Ukr 34 43 51 44
15 MFC Zhytomyr Zhytomyr 34 37 51 40
16 Obolon Obolon 34 24 52 27
17 Chornomorets II Chornomorets 34 27 51 23
18 Torpedo Zaporizhia Torpedo 34 21 49 16
TEMPORADA 1998/1999
SEGUNDA UCRANIA
Equipo PJ GF GC Puntos
1 Dynamo Kyiv II Dynamo Kyiv 37 78 27 85
2 Chornomorets Odessa Chornomorets 37 77 38 76
3 Torpedo Zaporizhia Torpedo 35 55 29 71
4 Dnipro Cherkasy Dnipro 36 68 42 70
5 Oleksandriya Oleksandriya 37 47 51 55
6 FC Lviv FC Lviv 37 58 43 54
7 FC Nyva Vinnytsya Nyva 37 45 39 54
8 Naftovyk-Ukrnafta Okhtyrka Naftovyk-Ukr 37 45 40 54
9 Shakhtar Donetsk II Shakhtar 37 51 44 49
10 Stal Alchevsk Stal 35 55 52 49
11 CSKA Kyiv CSKA Kyiv 37 45 48 49
12 Spartak Sumy Spartak Sumy 37 36 42 49
13 MFC Zhytomyr Zhytomyr 37 40 55 49
14 Dynamo Khmelnytskyi Dynamo 37 39 42 48
15 Volyn Lutsk Volyn Lutsk 36 36 43 45
16 Elektrometalurh Elektrometal 35 46 63 45
17 Kremin Kremin 37 34 63 37
18 Desna Chernihiv Desna 36 28 60 24
19 Bukovyna Chernivtsi Bukovyna 37 26 68 24
20 Makiivvuhillya Makiivvuhill 18 20 40 10
TEMPORADA 1997/1998
SEGUNDA UCRANIA
Equipo PJ GF GC Puntos
1 MFK Mykolaiv Mykolaiv 41 94 31 95
2 Dynamo Kyiv II Dynamo Kyiv 42 90 31 93
3 Metalist Kharkiv Metalist 42 74 29 89
4 Stal Alchevsk Stal 42 95 53 77
5 FC Nyva Vinnytsya Nyva 42 58 34 73
6 MFC Zhytomyr Zhytomyr 42 58 64 68
7 Naftovyk-Ukrnafta Okhtyrka Naftovyk-Ukr 42 56 50 67
8 Dnipro Cherkasy Dnipro 41 51 41 65
9 Volyn Lutsk Volyn Lutsk 41 56 45 62
10 Spartak Sumy Spartak Sumy 42 52 48 62
11 CSKA Kyiv CSKA Kyiv 42 56 44 59
12 Elektrometalurh Elektrometal 41 44 61 58
13 Makiivvuhillya Makiivvuhill 42 65 77 56
14 Kremin Kremin 42 55 53 55
15 FC Lviv FC Lviv 41 65 54 54
16 Oleksandriya Oleksandriya 42 51 49 54
17 Desna Chernihiv Desna 42 45 53 54
18 Bukovyna Chernivtsi Bukovyna 41 36 50 50
19 Zorya Luhansk Zorya 42 43 84 39
20 Goverla Goverla 42 42 79 32
21 Hirnyk Rovenky Hirnyk 42 15 107 16
22 Khimik Khimik 38 26 90 13
TEMPORADA 1996/1997
SEGUNDA UCRANIA
Equipo PJ GF GC Puntos
1 Elektrometalurh Elektrometal 46 77 39 101
2 Dynamo Kyiv II Dynamo Kyiv 46 91 33 95
3 FC Mariupol FC Mariupol 46 92 56 93
4 Volyn Lutsk Volyn Lutsk 46 62 47 83
5 Naftovyk-Ukrnafta Okhtyrka Naftovyk-Ukr 46 76 44 81
6 Stal Alchevsk Stal 46 76 43 78
7 MFK Mykolaiv Mykolaiv 45 66 37 72
8 FC Lviv FC Lviv 46 56 43 69
9 Bukovyna Chernivtsi Bukovyna 46 64 51 67
10 Oleksandriya Oleksandriya 46 55 50 65
11 Metalurh Donetsk Metalurh 46 60 66 64
12 Metalist Kharkiv Metalist 46 55 53 63
13 Spartak Sumy Spartak Sumy 46 61 61 61
14 Khimik Khimik 46 64 62 59
15 MFC Zhytomyr Zhytomyr 46 44 61 55
16 Goverla Goverla 45 56 78 55
17 Dnipro Cherkasy Dnipro 46 46 78 55
18 Makiivvuhillya Makiivvuhill 45 55 62 53
19 Zorya Luhansk Zorya 46 57 83 53
20 CSKA Kyiv CSKA Kyiv 44 37 56 51
21 SKA Odesa SKA Odesa 46 47 79 50
22 Dynamo Khmelnytskyi Dynamo 45 40 66 46
23 Veres Rivne Veres Rivne 45 36 79 42
24 Chortkiv Chortkiv 45 31 77 33
TEMPORADA 1991/1992
SEGUNDA UCRANIA
Equipo PJ GF GC Puntos
1 Veres Rivne Veres Rivne 26 38 15 50
2 Karpaty Karpaty 26 27 15 47
3 Krystal Krystal 26 34 26 40
4 Podillya Podillya 26 29 21 40
5 Desna Chernihiv Desna 26 23 24 40
6 Oleksandriya Oleksandriya 25 25 27 38
7 Dynamo Kyiv II Dynamo Kyiv 26 33 23 37
8 Sumy Sumy 26 29 29 37
9 Stal Alchevsk Stal 26 28 22 35
10 MFC Zhytomyr Zhytomyr 26 30 31 35
11 Halychyna (Drohobych) Halychyna 26 25 32 32
12 Dnipro Cherkasy Dnipro 26 22 27 31
13 Chaika Chaika 26 19 39 25
14 CSKA Kyiv CSKA Kyiv 25 14 45 12

  USO DE MEMORIA  
6,002,240 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.4833
Total Execution Time  0.4849
  CADENA URL  
/historico/Fc-Polissya-Zhytomyr
  GET DATOS  
$_GET['/historico/Fc-Polissya-Zhytomyr']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0110  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 = 'Fc-Polissya-Zhytomyr' 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.0120  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 = 'Fc-Polissya-Zhytomyr' 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.0105  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=64020 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=64020 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=64020 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=64020 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=64020 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=64020 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=64020 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=64020 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=64020 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=64020 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=64020 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=64020 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=64020 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=64020 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=64020 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=64020 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0111  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 = 14298
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=64020 AND type_rel = 2
0.0109  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 = '64020' AND l.year = 2005 ORDER BY l.year DESC,cat.coefficient DESC
0.0108  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 = '64020' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0108  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 = '64020' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0107  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 = 14298 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0108  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=64020 AND l.year in (2004,2005,2006) ORDER BY l.id DESC, l.year DESC ;
0.0106  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 (26472) 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.0105  SELECT count(id) as num_players from rel_players WHERE league_id = 26472 AND teamId = 64020
0.0112  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 14298 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0107  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 = '64020' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0106  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '64020' and rp.type = 4
0.0107  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 = '64020' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0106  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 events2005 e ON e.player_id = p.id AND e.league_id = 14298 WHERE rp.league_id = 14298 AND rp.teamId = 64020 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.0106  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 events2005 e ON e.player_id = p.id AND e.league_id = 14298 WHERE rp.league_id = 14298 AND rp.teamId = 64020 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0106  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 events2005 e ON e.player_id = p.id AND e.league_id = 14298 WHERE rp.league_id = 14298 AND rp.teamId = 64020 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0109  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 = 64020 AND l.year <= 2005 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0110  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 = 26485 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 14298 ORDER BY nameShow LIMIT 100