4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 1999/2000
SUPER LEAGUE GRIEGA
Equipo PJ GF GC Puntos
1 Olympiacos Piraeus Olympiacos 34 86 18 92
2 Panathinaikos Panathinaiko 34 92 24 88
3 AEK Athens AEK Athens 34 69 39 66
4 OFI OFI 34 60 44 63
5 PAOK PAOK 34 64 44 55
6 Iraklis Thessaloniki Iraklis 34 58 58 50
7 Aris Thessaloniki Aris 34 50 46 50
8 Panionios Panionios 34 50 63 45
9 Kalamata FC Kalamata FC 34 41 57 44
10 Ionikos Nikea Ionikos 34 40 50 41
11 Ethnikos Asteras Ethnikos 34 33 50 41
12 Xanthi Xanthi 34 36 43 41
13 Paniliakos Paniliakos 34 44 48 40
14 Panachaiki Panachaiki 34 37 47 39
15 Kavala Kavala 34 33 66 30
16 Proodeftiki FC Proodeftiki 34 27 55 28
17 Apollon Smyrnis Apollon 34 30 59 24
18 Trikala Trikala 34 35 74 21
TEMPORADA 1998/1999
SUPER LEAGUE GRIEGA
Equipo PJ GF GC Puntos
1 Olympiacos Piraeus Olympiacos 34 82 22 85
2 AEK Athens AEK Athens 34 71 27 75
3 Panathinaikos Panathinaiko 34 66 36 74
4 PAOK PAOK 34 52 31 62
5 Ionikos Nikea Ionikos 34 64 36 60
6 Aris Thessaloniki Aris 34 53 43 60
7 Xanthi Xanthi 34 44 33 56
8 OFI OFI 34 50 44 51
9 Iraklis Thessaloniki Iraklis 34 54 45 47
10 Kavala Kavala 34 46 62 42
11 Ethnikos Asteras Ethnikos 34 40 58 40
12 Proodeftiki FC Proodeftiki 34 28 37 39
13 Paniliakos Paniliakos 34 37 54 38
14 Apollon Smyrnis Apollon 34 42 62 36
15 Panionios Panionios 34 42 58 32
16 Panelefsiniakos Panelefsinia 34 25 49 32
17 Veria NPS Veria NPS 34 20 55 23
18 Ethnikos Piraeus Ethnikos 34 17 81 8
TEMPORADA 1997/1998
SUPER LEAGUE GRIEGA
Equipo PJ GF GC Puntos
1 Olympiacos Piraeus Olympiacos 34 88 27 88
2 Panathinaikos Panathinaiko 34 90 24 85
3 AEK Athens AEK Athens 34 61 30 74
4 PAOK PAOK 34 74 41 70
5 Ionikos Nikea Ionikos 34 46 31 62
6 Iraklis Thessaloniki Iraklis 34 49 45 51
7 OFI OFI 34 45 53 49
8 Xanthi Xanthi 34 52 52 45
9 Veria NPS Veria NPS 34 38 48 42
10 Apollon Smyrnis Apollon 34 37 51 36
11 Panionios Panionios 34 41 54 36
12 Paniliakos Paniliakos 34 41 54 36
13 Kavala Kavala 34 40 58 35
14 Proodeftiki FC Proodeftiki 34 35 57 34
15 Ethnikos Piraeus Ethnikos 34 27 51 33
16 Panachaiki Panachaiki 34 29 62 32
17 Kalamata FC Kalamata FC 34 27 50 29
18 Athinaikos Athinaikos 34 23 55 27
TEMPORADA 1996/1997
SUPER LEAGUE GRIEGA
Equipo PJ GF GC Puntos
1 Olympiacos Piraeus Olympiacos 34 72 14 84
2 AEK Athens AEK Athens 34 75 28 72
3 OFI OFI 34 51 28 66
4 PAOK PAOK 34 53 28 66
5 Panathinaikos Panathinaiko 34 60 25 64
6 Kavala Kavala 34 42 43 55
7 Paniliakos Paniliakos 34 39 49 45
8 Ionikos Nikea Ionikos 34 40 47 44
9 Apollon Smyrnis Apollon 34 39 42 42
10 Veria NPS Veria NPS 34 33 33 41
11 Kalamata FC Kalamata FC 34 34 50 41
12 Athinaikos Athinaikos 34 41 59 40
13 Iraklis Thessaloniki Iraklis 34 41 54 39
14 Xanthi Xanthi 34 53 59 39
15 Panachaiki Panachaiki 34 31 38 39
16 Aris Thessaloniki Aris 34 32 48 35
17 Edessaikos Edessaikos 34 38 61 28
18 Kastoria Kastoria 34 13 81 8
TEMPORADA 1995/1996
SUPER LEAGUE GRIEGA
Equipo PJ GF GC Puntos
1 Panathinaikos Panathinaiko 34 72 22 83
2 AEK Athens AEK Athens 34 87 22 81
3 Olympiacos Piraeus Olympiacos 34 66 34 65
4 Iraklis Thessaloniki Iraklis 34 51 39 58
5 OFI OFI 34 57 52 57
6 Xanthi Xanthi 34 53 47 47
7 Aris Thessaloniki Aris 34 45 47 46
8 Ionikos Nikea Ionikos 34 44 50 46
9 Edessaikos Edessaikos 34 50 59 44
10 Athinaikos Athinaikos 34 33 47 44
11 Apollon Smyrnis Apollon 34 49 48 40
12 Paniliakos Paniliakos 34 46 51 40
13 Kalamata FC Kalamata FC 34 41 46 39
14 PAOK PAOK 34 42 46 38
15 Panachaiki Panachaiki 34 27 47 36
16 AE Larisa AE Larisa 34 32 64 34
17 Panionios Panionios 34 35 59 29
18 Ethnikos Piraeus Ethnikos 34 40 90 18
TEMPORADA 1994/1995
SUPER LEAGUE GRIEGA
Equipo PJ GF GC Puntos
1 Panathinaikos Panathinaiko 34 83 21 83
2 Olympiacos Piraeus Olympiacos 34 69 31 67
3 PAOK PAOK 34 55 29 65
4 Apollon Smyrnis Apollon 34 61 37 63
5 AEK Athens AEK Athens 34 61 33 62
6 Iraklis Thessaloniki Iraklis 34 62 38 62
7 Aris Thessaloniki Aris 34 46 34 62
8 Xanthi Xanthi 34 52 55 50
9 OFI OFI 34 40 38 49
10 Edessaikos Edessaikos 34 45 54 42
11 AE Larisa AE Larisa 34 41 46 40
12 Athinaikos Athinaikos 34 29 35 40
13 Ethnikos Piraeus Ethnikos 34 38 48 39
14 Panionios Panionios 34 36 58 36
15 Ionikos Nikea Ionikos 34 27 53 34
16 Doxa Dramas Doxa Dramas 34 28 71 29
17 Levadiakos Levadiakos 34 23 67 20
18 Kavala Kavala 34 27 75 19
TEMPORADA 1993/1994
SUPER LEAGUE GRIEGA
Equipo PJ GF GC Puntos
1 AEK Athens AEK Athens 34 63 28 79
2 Panathinaikos Panathinaiko 34 82 32 72
3 Olympiacos Piraeus Olympiacos 34 63 27 68
4 Aris Thessaloniki Aris 34 55 34 63
5 PAOK PAOK 34 45 38 51
6 Iraklis Thessaloniki Iraklis 34 59 45 49
7 OFI OFI 34 55 42 47
8 Xanthi Xanthi 34 62 63 45
9 Panionios Panionios 34 49 58 43
10 Levadiakos Levadiakos 34 38 45 42
11 AE Larisa AE Larisa 34 45 53 42
12 Apollon Smyrnis Apollon 34 30 41 40
13 Athinaikos Athinaikos 34 34 50 40
14 Edessaikos Edessaikos 34 41 56 39
15 Doxa Dramas Doxa Dramas 34 37 64 38
16 Panachaiki Panachaiki 34 36 56 37
17 Apollon Pontou Apollon 34 42 66 32
18 FAS Naousa FAS Naousa 34 38 76 18
TEMPORADA 1992/1993
SUPER LEAGUE GRIEGA
Equipo PJ GF GC Puntos
1 AEK Athens AEK Athens 34 78 27 78
2 Panathinaikos Panathinaiko 34 85 21 77
3 Olympiacos Piraeus Olympiacos 34 68 31 68
4 OFI OFI 34 64 32 66
5 PAOK PAOK 34 52 38 57
6 Iraklis Thessaloniki Iraklis 34 51 41 56
7 AE Larisa AE Larisa 34 36 42 43
8 Xanthi Xanthi 34 56 66 42
9 Aris Thessaloniki Aris 34 40 50 42
10 Panachaiki Panachaiki 34 41 50 39
11 Athinaikos Athinaikos 34 27 37 39
12 Apollon Smyrnis Apollon 34 27 49 37
13 Doxa Dramas Doxa Dramas 34 34 57 36
14 Apollon Pontou Apollon 34 28 44 35
15 Edessaikos Edessaikos 34 38 60 35
16 Pierikos Pierikos 34 35 62 34
17 Ionikos Nikea Ionikos 34 33 49 33
18 PAS Korinthos Korinthos 34 28 65 27
TEMPORADA 1991/1992
SUPER LEAGUE GRIEGA
Equipo PJ GF GC Puntos
1 AEK Athens AEK Athens 34 72 25 77
2 Olympiacos Piraeus Olympiacos 34 74 30 71
3 Panathinaikos Panathinaiko 34 66 21 69
4 PAOK PAOK 34 44 43 52
5 Apollon Smyrnis Apollon 34 35 34 49
6 OFI OFI 34 34 30 45
7 PAS Korinthos Korinthos 34 37 47 43
8 Aris Thessaloniki Aris 34 26 40 43
9 AE Larisa AE Larisa 34 40 46 42
10 Xanthi Xanthi 34 36 48 42
11 Iraklis Thessaloniki Iraklis 34 41 41 41
12 Panachaiki Panachaiki 34 42 56 41
13 Pierikos Pierikos 34 41 56 41
14 Athinaikos Athinaikos 34 36 41 40
15 Doxa Dramas Doxa Dramas 34 39 38 38
16 Panionios Panionios 34 32 51 38
17 Panserraikos FC Panserraikos 34 29 59 35
18 Ethnikos Piraeus Ethnikos 34 30 48 32
TEMPORADA 1990/1991
SUPER LEAGUE GRIEGA
Equipo PJ GF GC Puntos
1 Panathinaikos Panathinaiko 34 77 22 77
2 Olympiacos Piraeus Olympiacos 34 77 28 67
3 AEK Athens AEK Athens 34 59 33 60
4 PAOK PAOK 34 56 39 57
5 Athinaikos Athinaikos 34 40 33 53
6 Iraklis Thessaloniki Iraklis 34 40 36 51
7 Doxa Dramas Doxa Dramas 34 42 45 48
8 OFI OFI 34 37 38 45
9 Aris Thessaloniki Aris 34 34 38 44
10 Apollon Smyrnis Apollon 34 41 62 40
11 AE Larisa AE Larisa 34 38 46 39
12 Panionios Panionios 34 38 54 39
13 Panachaiki Panachaiki 34 36 48 37
14 Panserraikos FC Panserraikos 34 30 42 37
15 Levadiakos Levadiakos 34 35 51 37
16 Xanthi Xanthi 34 35 53 37
17 Ionikos Nikea Ionikos 34 37 50 36
18 PAS Giannina Giannina 34 20 54 33
TEMPORADA 1989/1990
SUPER LEAGUE GRIEGA
Equipo PJ GF GC Puntos
1 Panathinaikos Panathinaiko 34 75 35 74
2 AEK Athens AEK Athens 34 64 18 70
3 PAOK PAOK 34 49 26 65
4 Olympiacos Piraeus Olympiacos 34 60 37 63
5 Iraklis Thessaloniki Iraklis 34 43 35 53
6 OFI OFI 34 52 41 52
7 Aris Thessaloniki Aris 34 37 40 46
8 AE Larisa AE Larisa 34 35 38 46
9 Levadiakos Levadiakos 34 34 45 44
10 Xanthi Xanthi 34 33 51 41
11 Doxa Dramas Doxa Dramas 34 36 39 38
12 Panionios Panionios 34 43 52 38
13 Panserraikos FC Panserraikos 34 32 42 38
14 Apollon Smyrnis Apollon 34 33 35 36
15 Ionikos Nikea Ionikos 34 27 48 36
16 Apollon Pontou Apollon 34 30 38 34
17 Olympiakos Volos Olympiakos 34 32 63 32
18 Ethnikos Piraeus Ethnikos 34 20 52 27
TEMPORADA 1988/1989
SUPER LEAGUE GRIEGA
Equipo PJ GF GC Puntos
1 AEK Athens AEK Athens 30 45 20 63
2 Olympiacos Piraeus Olympiacos 30 54 25 57
3 Panathinaikos Panathinaiko 30 45 25 51
4 Iraklis Thessaloniki Iraklis 30 43 27 49
5 OFI OFI 30 45 36 47
6 Aris Thessaloniki Aris 30 31 26 44
7 AE Larisa AE Larisa 30 37 34 44
8 PAOK PAOK 30 34 30 43
9 Doxa Dramas Doxa Dramas 30 26 28 38
10 Panionios Panionios 30 32 36 37
11 Levadiakos Levadiakos 30 33 47 34
12 Olympiakos Volos Olympiakos 30 36 45 32
13 Apollon Smyrnis Apollon 30 29 38 30
14 Ethnikos Piraeus Ethnikos 30 31 49 29
15 Diagoras Diagoras 30 21 43 24
16 Apollon Pontou Apollon 30 24 57 21
TEMPORADA 1987/1988
SUPER LEAGUE GRIEGA
Equipo PJ GF GC Puntos
1 AE Larisa AE Larisa 30 51 22 61
2 PAOK PAOK 30 60 27 56
3 AEK Athens AEK Athens 30 51 31 55
4 OFI OFI 30 54 41 54
5 Panathinaikos Panathinaiko 30 47 34 51
6 Iraklis Thessaloniki Iraklis 30 42 32 47
7 Ethnikos Piraeus Ethnikos 30 27 28 44
8 Olympiacos Piraeus Olympiacos 30 39 41 40
9 Aris Thessaloniki Aris 30 39 41 38
10 Panionios Panionios 30 32 34 34
11 Apollon Pontou Apollon 30 23 39 31
12 Diagoras Diagoras 30 25 38 30
13 Levadiakos Levadiakos 30 32 46 30
14 Veria NPS Veria NPS 30 24 53 30
15 Panserraikos FC Panserraikos 30 24 42 29
16 Panachaiki Panachaiki 30 32 53 28

  USO DE MEMORIA  
7,125,392 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1595
Total Execution Time  0.1608
  CADENA URL  
/historico/Olympiakos-Piraeus/2000
  GET DATOS  
$_GET['/historico/Olympiakos-Piraeus/2000']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (47)  
0.0037  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 = 'Olympiakos-Piraeus' AND l.year = 2000 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.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=1863 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=1863 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=1863 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=1863 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=1863 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0026  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 = 9685
0.0025  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 = 10974
0.0025  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 = 23490
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1863 AND type_rel = 2
0.0029  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1863 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023  SELECT /*35 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 (408,1855,2676,3017,3042) ORDER BY n.cover_points DESC, update_date DESC
0.0036  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 = '1863' AND l.year = 2000 ORDER BY l.year DESC,cat.coefficient DESC
0.0036  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 = '1863' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 9685 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 23490 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  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 = 10974 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 404 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0060  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=1863 AND l.year in (1999,2000,2001) ORDER BY l.id DESC, l.year DESC ;
0.0021  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 (73137,42336,23490,10975,9693,405) 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.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 405 AND teamId = 1863
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 9693 AND teamId = 1863
0.0033  SELECT count(id) as num_players from rel_players WHERE league_id = 10975 AND teamId = 1863
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 42336 AND teamId = 1863
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 23490 AND teamId = 1863
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 73137 AND teamId = 1863
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 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 = 9685 AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0023  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 = '1863' 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 = '1863' and rp.type = 4
0.0022  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 = '1863' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0019  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '1863' and rp.type = 4
0.0041  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 events2000 e ON e.player_id = p.id AND e.league_id = 9685 WHERE rp.league_id = 9685 AND rp.teamId = 1863 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.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 events2000 e ON e.player_id = p.id AND e.league_id = 9685 WHERE rp.league_id = 9685 AND rp.teamId = 1863 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0035  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 events2000 e ON e.player_id = p.id AND e.league_id = 9685 WHERE rp.league_id = 9685 AND rp.teamId = 1863 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0041  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 = 1863 AND l.year <= 2000 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 405 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 `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 = 406 AND t.round = 34 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 `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 = 407 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 `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 = 408 AND t.round = 34 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 `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 = 409 AND t.round = 34 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 `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 = 29003 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 `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 = 29004 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 `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 = 29005 AND t.round = 34 ORDER BY team.conference 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 `tables1991` 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 = 29006 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 `tables1990` 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 = 29007 AND t.round = 34 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 `tables1989` 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 = 29008 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 `tables1988` 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 = 29009 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC