4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2001/2002
Equipo PJ GF GC Puntos
1 Rubin Kazán Rubin Kazán 34 51 14 72
2 Chernomorets Novorossisk Chernomorets 34 59 29 70
3 Tom Tomsk Tom Tomsk 34 51 23 61
4 Amkar Perm Amkar Perm 34 47 31 54
5 FC Kuban FC Kuban 34 44 30 54
6 Spartak Nalchik Spartak 34 42 30 53
7 FK Khimki FK Khimki 34 38 27 52
8 Lada Tolyatti Lada 34 54 35 50
9 FK Chita FK Chita 34 38 46 45
10 FC Soyuz Izhevsk Soyuz 34 34 32 44
11 Kristall Kristall 34 39 43 44
12 SKA-Khabarovsk SKA-Khabarov 34 35 37 42
13 Fakel Fakel 34 34 42 40
14 Neftekhimik Neftekhimik 34 34 49 38
15 Volgar Astrakhan Volgar 34 34 51 36
16 Dynamo St Petersburg Dynamo 34 28 56 36
17 SKA Rostov SKA Rostov 34 38 62 31
18 Yenisey Yenisey 34 24 87 16
Ver
TEMPORADA 2000/2001
Equipo PJ GF GC Puntos
1 Shinnik Yaroslavl Shinnik 34 58 21 69
2 Elista Uralan Elista 34 55 31 65
3 FC Kuban FC Kuban 34 56 29 60
4 Amkar Perm Amkar Perm 34 46 29 56
5 Spartak Nalchik Spartak 34 48 37 55
6 Volgar Astrakhan Volgar 34 40 40 50
7 Tom Tomsk Tom Tomsk 34 31 28 47
8 Rubin Kazán Rubin Kazán 34 44 44 46
9 Yenisey Yenisey 34 39 47 45
10 Kristall Kristall 34 37 45 44
11 Neftekhimik Neftekhimik 34 49 56 43
12 FK Khimki FK Khimki 34 42 54 43
13 FC Soyuz Izhevsk Soyuz 34 38 44 42
14 Lada Tolyatti Lada 34 40 50 41
15 Arsenal Tula Arsenal Tula 34 27 35 40
16 FK Chita FK Chita 34 38 50 40
17 Baltika Kaliningrad Baltika 34 35 51 39
18 Lokomotiv Nizhny Novgorod Lokomotiv 34 26 58 32
Ver
TEMPORADA 1999/2000
Equipo PJ GF GC Puntos
1 Sokol Saratov Sokol 38 78 27 89
2 T. Moscow T. Moscow 38 62 28 80
3 Rubin Kazán Rubin Kazán 38 61 28 78
4 Shinnik Yaroslavl Shinnik 38 58 33 71
5 Kristall Kristall 38 63 49 61
6 Amkar Perm Amkar Perm 38 53 38 60
7 FC Soyuz Izhevsk Soyuz 38 55 52 59
8 FK Chita FK Chita 38 50 51 53
9 Lada Tolyatti Lada 38 58 49 52
10 Tom Tomsk Tom Tomsk 38 36 28 52
11 Arsenal Tula Arsenal Tula 38 45 39 52
12 Volgar Astrakhan Volgar 38 46 39 51
13 Baltika Kaliningrad Baltika 38 40 46 51
14 Yenisey Yenisey 38 40 49 50
15 Spartak Nalchik Spartak 38 37 44 48
16 NoSta NoSta 38 44 51 46
17 Zhemchuzhina Sochi Zhemchuzhina 38 48 70 43
18 Metallurg Lipetsk Metallurg 38 43 53 39
19 Spartak-Tchukotka Moscow Spartak-Tchu 38 29 115 16
20 Lokomotiv St Petersburg Lokomotiv 38 30 87 13
Ver
TEMPORADA 1998/1999
Equipo PJ GF GC Puntos
1 Anzhi Anzhi 42 55 20 86
2 Fakel Fakel 42 65 31 85
3 T. Moscow T. Moscow 42 67 27 82
4 Sokol Saratov Sokol 42 74 39 82
5 Baltika Kaliningrad Baltika 42 60 37 74
6 Amkar Perm Amkar Perm 42 65 49 70
7 Rubin Kazán Rubin Kazán 42 56 49 66
8 Arsenal Tula Arsenal Tula 42 61 51 64
9 FC Soyuz Izhevsk Soyuz 42 50 47 64
10 FK Chita FK Chita 42 48 50 62
11 Kristall Kristall 42 44 49 58
12 Tom Tomsk Tom Tomsk 42 48 54 58
13 Spartak Nalchik Spartak 42 49 61 56
14 Yenisey Yenisey 42 38 43 54
15 Metallurg Lipetsk Metallurg 42 51 53 53
16 Lokomotiv St Petersburg Lokomotiv 42 35 51 51
17 Volgar Astrakhan Volgar 42 41 49 50
18 Tyumen Tyumen 42 43 59 48
19 Torpedo-Viktoriya Torpedo-Vikt 42 47 67 43
20 Akademiya Tolyatti Akademiya 42 37 69 40
21 Dynamo St Petersburg Dynamo 42 31 50 39
22 Znamya Znamya 42 25 85 13
Ver
TEMPORADA 1997/1998
Equipo PJ GF GC Puntos
1 Saturn Moskva Saturn 42 73 34 84
2 Lokomotiv Nizhny Novgorod Lokomotiv 42 65 34 77
3 Sokol Saratov Sokol 42 58 32 76
4 Kristall Kristall 42 59 47 72
5 Arsenal Tula Arsenal Tula 42 65 53 65
6 Akademiya Tolyatti Akademiya 41 65 60 64
7 Dynamo St Petersburg Dynamo 41 51 37 63
8 Rubin Kazán Rubin Kazán 42 56 50 63
9 Fakel Fakel 42 54 45 60
10 FC Soyuz Izhevsk Soyuz 41 53 55 60
11 Anzhi Anzhi 42 47 56 57
12 Tom Tomsk Tom Tomsk 42 54 45 56
13 Spartak Nalchik Spartak 42 49 52 56
14 Metallurg Lipetsk Metallurg 42 41 50 56
15 FK Chita FK Chita 41 38 38 53
16 Neftekhimik Neftekhimik 41 44 53 52
17 Lada Tolyatti Lada 41 49 70 51
18 Druzhba Maykop Druzhba 42 45 55 50
19 Lokomotiv St Petersburg Lokomotiv 37 45 50 44
20 FC Kuban FC Kuban 42 42 68 43
21 FC Irtysh Omsk Irtysh Omsk 42 36 58 41
22 KamAZ KamAZ 41 32 79 26
Ver
TEMPORADA 1996/1997
Equipo PJ GF GC Puntos
1 Elista Uralan Elista 42 67 22 92
2 Metallurg Lipetsk Metallurg 42 80 41 84
3 Sokol Saratov Sokol 42 58 35 74
4 Spartak Nalchik Spartak 42 74 53 72
5 Lokomotiv St Petersburg Lokomotiv 42 55 38 70
6 Akademiya Tolyatti Akademiya 42 80 71 69
7 Kristall Kristall 42 70 45 68
8 FK Chita FK Chita 42 62 63 65
9 Saturn Moskva Saturn 42 65 55 63
10 Dynamo St Petersburg Dynamo 42 54 58 62
11 FC Soyuz Izhevsk Soyuz 42 42 39 61
12 Neftekhimik Neftekhimik 42 53 54 61
13 Lada Tolyatti Lada 42 61 56 60
14 Anzhi Anzhi 42 66 72 60
15 FC Irtysh Omsk Irtysh Omsk 42 52 53 57
16 FC Kuban FC Kuban 42 63 66 57
17 Druzhba Maykop Druzhba 42 51 62 57
18 Zarya Leninsk Zarya 42 39 58 45
19 Tekstilshchik Kamyshin Tekstilshchi 42 46 67 38
20 Ural Yekaterinburg Ural 42 43 77 35
21 Energiya Volzhskiy Energiya 42 29 72 30
22 Luch Vladivostok Luch 42 23 76 21
Ver
TEMPORADA 1995/1996
Equipo PJ GF GC Puntos
1 Druzhba Arzamas Druzhba 84 97 111 103
2 Tyumen Tyumen 42 82 34 84
3 Shinnik Yaroslavl Shinnik 42 66 32 83
4 Fakel Fakel 42 72 33 82
5 FC Soyuz Izhevsk Soyuz 42 69 44 79
6 Dynamo St Petersburg Dynamo 42 64 45 74
7 Zarya Leninsk Zarya 42 63 54 66
8 Elista Uralan Elista 42 47 41 66
9 Sokol Saratov Sokol 42 56 49 62
10 FC Kuban FC Kuban 42 65 60 59
11 Spartak Nalchik Spartak 42 62 59 59
12 Saturn Moskva Saturn 42 48 48 57
13 Lokomotiv St Petersburg Lokomotiv 42 57 46 55
14 Neftekhimik Neftekhimik 42 45 55 55
15 Luch Vladivostok Luch 42 39 49 54
16 Energiya Volzhskiy Energiya 42 57 71 54
17 FK Chita FK Chita 42 50 56 51
18 Okean Nakhodka Okean 42 42 76 39
19 Zvezda Irkutsk Zvezda 42 31 63 38
20 Yenisey Yenisey 42 33 61 35
21 Chkalovets Ns Chkalovets 42 44 102 27
Ver
TEMPORADA 1994/1995
Equipo PJ GF GC Puntos
1 Baltika Kaliningrad Baltika 42 83 30 92
2 Lada Tolyatti Lada 42 67 39 79
3 Zenit Zenit 42 65 42 77
4 Zvezda Irkutsk Zvezda 42 61 50 73
5 Shinnik Yaroslavl Shinnik 42 56 39 72
6 Luch Vladivostok Luch 42 51 48 66
7 Neftekhimik Neftekhimik 42 55 50 65
8 FK Chita FK Chita 42 66 67 65
9 Dynamo St Petersburg Dynamo 42 66 51 63
10 Sokol Saratov Sokol 42 62 56 61
11 Chkalovets Ns Chkalovets 42 58 65 61
12 Zarya Leninsk Zarya 42 69 53 58
13 Fakel Fakel 42 54 48 57
14 Druzhba Arzamas Druzhba 42 60 67 57
15 Elista Uralan Elista 42 56 61 56
16 Energiya Volzhskiy Energiya 42 75 74 55
17 Okean Nakhodka Okean 42 43 56 50
18 Druzhba Maykop Druzhba 42 51 65 50
19 Saturn-1991 Saturn-1991 42 45 62 49
20 Kolos Krasnodar Kolos 42 44 66 45
21 FC Irtysh Omsk Irtysh Omsk 42 47 82 45
22 Asmaral Moskva Asmaral 42 35 98 28
Ver
TEMPORADA 1993/1994
Equipo PJ GF GC Puntos
1 Chernomorets Novorossisk Chernomorets 42 103 31 94
2 FK Rostov FK Rostov 42 92 44 89
3 Baltika Kaliningrad Baltika 42 89 41 88
4 Sokol Saratov Sokol 42 65 48 74
5 Shinnik Yaroslavl Shinnik 42 69 44 71
6 Neftekhimik Neftekhimik 42 56 40 65
7 Zarya Leninsk Zarya 42 80 64 64
8 Druzhba Maykop Druzhba 42 51 57 62
9 FK Chita FK Chita 42 59 56 61
10 Asmaral Moskva Asmaral 42 57 55 59
11 Elista Uralan Elista 42 69 67 57
12 Luch Vladivostok Luch 42 44 53 56
13 Okean Nakhodka Okean 42 58 60 54
14 Zenit Zenit 42 44 49 54
15 Zvezda Irkutsk Zvezda 42 57 64 54
16 Saturn-1991 Saturn-1991 42 47 66 52
17 FC Irtysh Omsk Irtysh Omsk 42 50 79 52
18 Avtodor Avtodor 42 48 67 45
19 Torpedo Vladimir Torpedo 42 52 81 44
20 Erzu Groznyi Erzu Groznyi 42 33 73 41
21 Zvezda Perm Zvezda Perm 42 46 81 38
22 Krasnoznamensk Krasnoznamen 42 55 104 23
Ver
TEMPORADA 1992/1993
Equipo PJ GF GC Puntos
1 Chernomorets Novorossisk Chernomorets 42 121 33 94
2 Avtodor Avtodor 42 73 48 80
3 Erzu Groznyi Erzu Groznyi 42 72 26 79
4 Saturn-1991 Saturn-1991 42 70 50 76
5 Baltika Kaliningrad Baltika 42 67 44 75
6 Torpedo Vladimir Torpedo 42 67 53 73
7 Elista Uralan Elista 42 60 64 71
8 Druzhba Maykop Druzhba 42 70 55 69
9 Akhmat Grozny Akhmat 42 79 60 67
10 Metallurg Lipetsk Metallurg 42 68 50 66
11 Fakel Fakel 42 58 38 64
12 Spartak UGP Anapa Spartak 42 59 65 62
13 FK Taganrog FK Taganrog 42 62 65 61
14 Kolos Krasnodar Kolos 42 47 57 59
15 FC Kuban FC Kuban 42 62 84 53
16 Spartak Nalchik Spartak 42 52 73 47
17 Tekstilshchik Tekstilshchi 42 49 58 44
18 Znamya Znamya 42 42 64 41
19 Dinamo Vologda Dinamo 42 36 65 40
20 Asmaral Kislovodsk Asmaral 42 33 68 34
21 Nart Cherkessk Nart 42 30 84 32
22 APK Morozovsk Morozovsk 42 25 98 17
Ver
TEMPORADA 1991/1992
Equipo PJ GF GC Puntos
1 Zhemchuzhina Sochi Zhemchuzhina 34 84 40 77
2 Elista Uralan Elista 34 65 49 62
3 Chernomorets Novorossisk Chernomorets 34 63 35 61
4 Akhmat Grozny Akhmat 34 63 43 59
5 Druzhba Maykop Druzhba 34 57 42 59
6 Dinamo Vologda Dinamo 34 51 43 52
7 Spartak Nalchik Spartak 34 58 47 51
8 Metallurg Lipetsk Metallurg 34 49 41 50
9 Spartak UGP Anapa Spartak 34 49 47 49
10 Torpedo Vladimir Torpedo 34 53 53 45
11 Asmaral Kislovodsk Asmaral 34 37 50 43
12 FK Taganrog FK Taganrog 34 47 39 42
13 Nart Cherkessk Nart 34 37 55 41
14 APK Morozovsk Morozovsk 34 37 60 39
15 Tekstilshchik Tekstilshchi 34 58 57 38
16 Energomash Energomash 34 44 68 35
17 Dynamo St Petersburg Dynamo 34 36 65 27
18 Volga Tver Volga Tver 34 31 85 26

  USO DE MEMORIA  
6,769,744 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0031
Controller Execution Time ( Home / Category )  0.5619
Total Execution Time  0.5651
  CADENA URL  
/rusia_1_division2002/grupo1/historico
  GET DATOS  
$_GET['/rusia_1_division2002/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0145  SELECT type FROM routes WHERE alias = 'rusia_1_division2002'
0.0294  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'rusia_1_division' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2002 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=317 AND type_rel = 3
0.0149  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 317 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0155  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 (1309284,1162132,1157300,1122023,1110027) ORDER BY n.cover_points DESC, update_date DESC
0.0159  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 26508 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0159  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 317 AND group_code = 1 and tables = 1 AND year <= 2002 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0154  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 = 26508 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 26510 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 26511 AND t.round = 40 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 26513 AND t.round = 44 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 = 26517 AND t.round = 44 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 26519 AND t.round = 44 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 `tables1996` 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 = 26523 AND t.round = 44 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 26526 AND t.round = 44 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158  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 = 26533 AND t.round = 44 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0161  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 = 26541 AND t.round = 44 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 26559 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 17:25:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 17:25:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 17:25:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 17:25:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'rusia_1_division' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2002 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0146  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2002 e ON e.player_id = p.id AND e.league_id = 26508 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 26508 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0146  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2002 e ON e.player_id = p.id AND e.league_id = 26508 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 26508 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0145  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2002 e ON e.player_id = p.id AND e.league_id = 26508 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 26508 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0162  SELECT *,(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 = 26508 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC