4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del FC Melbourne Knights
TEMPORADA 2023/2024
SEGUNDA AUSTRALIA GRUPO 2
Equipo PJ GF GC Puntos
1 South Melbourne South 11 25 7 29
2 Heidelberg Utd Heidelberg 11 22 8 23
3 Avondale Heights Avondale 11 26 13 23
4 Hume City FC Hume City 11 24 12 23
5 Oakleigh Cannons Oakleigh 11 21 9 22
6 Port Melbourne Sharks Port 11 19 16 18
7 Dandenong City Dandenong 11 19 20 16
8 Altona Magic Altona Magic 11 16 23 13
9 FC Melbourne Knights Melbourne 11 14 18 11
10 Green Gully Cavaliers Green Gully 11 12 21 11
11 Dandenong Thunder SC Dandenong 11 13 24 11
12 Manningham United Manningham 11 17 27 9
13 St Albans Saints Albans 11 11 24 7
14 Moreland City Moreland 11 9 26 0
TEMPORADA 2022/2023
SEGUNDA AUSTRALIA GRUPO 1
Equipo PJ GF GC Puntos
1 Avondale Heights Avondale 26 78 23 67
2 South Melbourne South 26 54 21 62
3 Oakleigh Cannons Oakleigh 26 64 25 58
4 FC Melbourne Knights Melbourne 26 51 35 47
5 Port Melbourne Sharks Port 26 53 34 45
6 Altona Magic Altona Magic 26 48 53 41
7 Green Gully Cavaliers Green Gully 26 53 40 40
8 Dandenong Thunder SC Dandenong 26 49 48 33
9 Heidelberg Utd Heidelberg 26 31 46 31
10 Hume City FC Hume City 26 37 41 28
11 St Albans Saints Albans 26 24 53 22
12 Moreland City Moreland 26 26 69 16
13 Bentleigh Greens Bentleigh 26 24 51 15
14 North Geelong Warriors North 26 18 71 14
TEMPORADA 2021/2022
SEGUNDA AUSTRALIA GRUPO 1
Equipo PJ GF GC Puntos
1 South Melbourne South 26 59 20 62
2 Port Melbourne Sharks Port 26 45 23 56
3 Oakleigh Cannons Oakleigh 26 58 29 51
4 Green Gully Cavaliers Green Gully 26 43 30 45
5 Bentleigh Greens Bentleigh 26 47 33 42
6 Heidelberg Utd Heidelberg 26 50 43 42
7 Avondale Heights Avondale 26 49 38 40
8 Dandenong Thunder SC Dandenong 26 37 34 38
9 FC Melbourne Knights Melbourne 26 36 40 30
10 St Albans Saints Albans 26 25 38 30
11 Altona Magic Altona Magic 26 21 38 27
12 Hume City FC Hume City 26 33 48 26
13 Dandenong City Dandenong 26 24 60 20
14 Eastern Lions Eastern 26 17 70 8
TEMPORADA 2020/2021
SEGUNDA AUSTRALIA GRUPO 3
Equipo PJ GF GC Puntos
1 Avondale Heights Avondale 18 39 15 41
2 Oakleigh Cannons Oakleigh 18 36 21 34
3 Bentleigh Greens Bentleigh 18 31 22 33
4 Hume City FC Hume City 18 35 21 31
5 Dandenong Thunder SC Dandenong 18 30 25 28
6 Heidelberg Utd Heidelberg 18 23 22 27
7 Port Melbourne Sharks Port 18 28 19 26
8 FC Melbourne Knights Melbourne 18 24 26 26
9 South Melbourne South 18 19 18 25
10 Green Gully Cavaliers Green Gully 18 23 25 20
11 Eastern Lions Eastern 18 18 34 15
12 Altona Magic Altona Magic 18 19 32 14
13 Dandenong City Dandenong 18 20 36 14
14 St Albans Saints Albans 18 10 39 10
TEMPORADA 2019/2020
SEGUNDA AUSTRALIA GRUPO 3
Equipo PJ GF GC Puntos
1 Hume City FC Hume City 5 11 3 15
2 Avondale Heights Avondale 5 14 4 12
3 Oakleigh Cannons Oakleigh 5 11 6 10
4 Dandenong Thunder SC Dandenong 5 9 7 10
5 Heidelberg Utd Heidelberg 5 10 6 9
6 Port Melbourne Sharks Port 5 8 4 9
7 St Albans Saints Albans 5 7 3 9
8 South Melbourne South 5 7 7 6
9 Green Gully Cavaliers Green Gully 5 7 9 6
10 Bentleigh Greens Bentleigh 5 4 3 5
11 FC Melbourne Knights Melbourne 5 7 16 2
12 Dandenong City Dandenong 5 4 10 1
13 Eastern Lions Eastern 5 2 12 1
14 Altona Magic Altona Magic 5 2 13 1
TEMPORADA 2018/2019
SEGUNDA AUSTRALIA GRUPO 3
Equipo PJ GF GC Puntos
1 Heidelberg Utd Heidelberg 26 53 28 55
2 Avondale Heights Avondale 26 63 29 53
3 Oakleigh Cannons Oakleigh 26 45 32 45
4 Green Gully Cavaliers Green Gully 26 55 40 44
5 Bentleigh Greens Bentleigh 26 47 45 43
6 Hume City FC Hume City 26 41 37 41
7 Dandenong City Dandenong 26 42 47 35
8 FC Melbourne Knights Melbourne 26 35 42 34
9 South Melbourne South 26 27 42 34
10 Port Melbourne Sharks Port 26 41 37 31
11 Altona Magic Altona Magic 26 43 51 29
12 Dandenong Thunder SC Dandenong 26 44 70 24
13 Kingston City Kingston 26 35 51 23
14 Pascoe Vale SC Pascoe Vale 26 33 53 21
TEMPORADA 2017/2018
SEGUNDA AUSTRALIA GRUPO 3
Equipo PJ GF GC Puntos
1 Heidelberg Utd Heidelberg 26 60 29 59
2 Bentleigh Greens Bentleigh 26 53 28 58
3 Avondale Heights Avondale 26 57 32 55
4 Pascoe Vale SC Pascoe Vale 26 42 31 45
5 Oakleigh Cannons Oakleigh 26 41 39 38
6 Port Melbourne Sharks Port 26 37 41 36
7 Kingston City Kingston 26 39 45 34
8 Dandenong Thunder SC Dandenong 26 45 55 34
9 FC Melbourne Knights Melbourne 26 45 53 32
10 South Melbourne South 26 48 53 28
11 Hume City FC Hume City 26 29 43 28
12 Green Gully Cavaliers Green Gully 26 41 49 26
13 Northcote City Northcote 26 32 53 22
14 Bulleen Lions Bulleen 26 33 51 21
TEMPORADA 2016/2017
SEGUNDA AUSTRALIA GRUPO 1
Equipo PJ GF GC Puntos
1 Heidelberg Utd Heidelberg 26 53 26 54
2 South Melbourne South 26 49 28 48
3 Avondale Heights Avondale 26 28 21 48
4 Bentleigh Greens Bentleigh 26 44 30 46
5 Green Gully Cavaliers Green Gully 26 50 37 45
6 Oakleigh Cannons Oakleigh 26 43 23 43
7 Pascoe Vale SC Pascoe Vale 26 35 27 43
8 Hume City FC Hume City 26 31 26 35
9 Bulleen Lions Bulleen 26 39 42 32
10 Kingston City Kingston 26 37 42 31
11 Port Melbourne Sharks Port 26 36 44 27
12 FC Melbourne Knights Melbourne 26 31 48 24
13 St Albans Saints Albans 26 20 56 15
14 North Geelong Warriors North 26 21 67 10
TEMPORADA 2015/2016
SEGUNDA AUSTRALIA GRUPO 1
Equipo PJ GF GC Puntos
1 Bentleigh Greens Bentleigh 26 61 22 59
2 South Melbourne South 26 64 39 56
3 Heidelberg Utd Heidelberg 26 59 26 53
4 Oakleigh Cannons Oakleigh 26 48 36 47
5 Green Gully Cavaliers Green Gully 26 42 30 44
6 Hume City FC Hume City 26 47 25 43
7 Pascoe Vale SC Pascoe Vale 26 38 36 37
8 Avondale Heights Avondale 26 37 42 35
9 FC Melbourne Knights Melbourne 25 27 51 28
10 Bulleen Lions Bulleen 26 22 32 27
11 Port Melbourne Sharks Port 26 26 39 25
12 Richmond Richmond 26 37 58 23
13 Northcote City Northcote 26 27 58 20
14 Melbourne Victory Sub 21 Melbourne 25 24 65 4
TEMPORADA 2014/2015
SEGUNDA AUSTRALIA GRUPO 5
Equipo PJ GF GC Puntos
1 South Melbourne South 26 58 22 58
2 Bentleigh Greens Bentleigh 26 48 25 56
3 Heidelberg Utd Heidelberg 26 52 28 51
4 FC Melbourne Knights Melbourne 26 39 28 48
5 Pascoe Vale SC Pascoe Vale 26 36 30 43
6 Hume City FC Hume City 26 42 29 42
7 Green Gully Cavaliers Green Gully 26 52 46 37
8 Port Melbourne Sharks Port 26 37 34 33
9 Northcote City Northcote 26 34 49 32
10 Avondale Heights Avondale 26 37 44 28
11 Oakleigh Cannons Oakleigh 26 33 41 26
12 North Geelong Warriors North 26 31 52 22
13 Werribee City Werribee 26 20 50 18
14 Dandenong Thunder SC Dandenong 26 29 70 15
TEMPORADA 2013/2014
SEGUNDA AUSTRALIA GRUPO 5
Equipo PJ GF GC Puntos
1 South Melbourne South 26 59 22 66
2 Oakleigh Cannons Oakleigh 26 61 19 59
3 Heidelberg Utd Heidelberg 26 55 33 44
4 Bentleigh Greens Bentleigh 26 48 35 43
5 FC Melbourne Knights Melbourne 26 41 36 38
6 Hume City FC Hume City 26 33 33 38
7 Northcote City Northcote 26 38 39 36
8 Pascoe Vale SC Pascoe Vale 26 30 34 34
9 Dandenong Thunder SC Dandenong 26 34 47 32
10 Green Gully Cavaliers Green Gully 26 45 52 30
11 Port Melbourne Sharks Port 26 33 47 28
12 Werribee City Werribee 26 29 50 28
13 Ballarat Red Devils Ballarat 26 40 51 27
14 Goulburn Valley Suns Goulburn 26 27 75 10
TEMPORADA 2012/2013
SEGUNDA AUSTRALIA GRUPO 7
Equipo PJ GF GC Puntos
1 Northcote City Northcote 22 54 19 47
2 FC Melbourne Knights Melbourne 22 35 26 43
3 Bentleigh Greens Bentleigh 22 41 24 38
4 Green Gully Cavaliers Green Gully 22 37 29 37
5 Port Melbourne Sharks Port 22 33 30 36
6 South Melbourne South 22 45 35 35
7 Dandenong Thunder SC Dandenong 22 31 31 30
8 Hume City FC Hume City 22 32 47 29
9 Oakleigh Cannons Oakleigh 22 38 38 27
10 Pascoe Vale SC Pascoe Vale 22 28 31 24
11 Richmond Richmond 22 28 49 15
12 Southern Stars Southern 22 11 54 8
TEMPORADA 2011/2012
SEGUNDA AUSTRALIA GRUPO 2
Equipo PJ GF GC Puntos
1 Dandenong Thunder SC Dandenong 22 47 14 48
2 Oakleigh Cannons Oakleigh 22 36 26 40
3 Green Gully Cavaliers Green Gully 22 31 25 37
4 Bentleigh Greens Bentleigh 22 37 27 35
5 Northcote City Northcote 22 28 31 33
6 South Melbourne South 22 34 31 32
7 Richmond Richmond 22 32 29 30
8 FC Melbourne Knights Melbourne 22 25 30 29
9 Hume City FC Hume City 22 27 27 28
10 Southern Stars Southern 22 26 38 27
11 Moreland Zebras Moreland 22 30 42 18
12 Heidelberg Utd Heidelberg 22 23 56 10
TEMPORADA 2010/2011
SEGUNDA AUSTRALIA GRUPO 2
Equipo PJ GF GC Puntos
1 Green Gully Cavaliers Green Gully 24 51 23 43
2 Heidelberg Utd Heidelberg 24 53 26 43
3 Oakleigh Cannons Oakleigh 24 41 29 43
4 Hume City FC Hume City 24 48 32 42
5 Dandenong Thunder SC Dandenong 24 43 29 41
6 South Melbourne South 24 39 33 41
7 Northcote City Northcote 24 61 37 39
8 Richmond Richmond 24 34 38 37
9 Bentleigh Greens Bentleigh 24 34 34 36
10 FC Melbourne Knights Melbourne 24 39 33 31
11 Springvale White Eagles Springvale 24 24 62 15
12 St Albans Saints Albans 24 27 58 13
13 VTC Football Football 24 25 85 12
TEMPORADA 2009/2010
SEGUNDA AUSTRALIA GRUPO 2
Equipo PJ GF GC Puntos
1 Hume City FC Hume City 22 41 29 42
2 Richmond Richmond 22 33 26 40
3 Green Gully Cavaliers Green Gully 22 37 23 36
4 South Melbourne South 22 41 28 36
5 Heidelberg Utd Heidelberg 22 34 33 36
6 Northcote City Northcote 22 47 35 31
7 Dandenong Thunder SC Dandenong 22 24 30 31
8 Oakleigh Cannons Oakleigh 22 30 31 30
9 FC Melbourne Knights Melbourne 22 30 37 26
10 Bentleigh Greens Bentleigh 22 19 36 21
11 Altona Magic Altona Magic 22 39 46 20
12 Sunshine George Cross Sunshine 22 20 41 19
TEMPORADA 2008/2009
SEGUNDA AUSTRALIA GRUPO 2
Equipo PJ GF GC Puntos
1 Dandenong Thunder SC Dandenong 22 45 21 50
2 Altona Magic Altona Magic 22 36 26 38
3 Green Gully Cavaliers Green Gully 22 29 21 38
4 Hume City FC Hume City 22 39 16 37
5 South Melbourne South 22 41 22 37
6 Heidelberg Utd Heidelberg 22 35 26 34
7 Oakleigh Cannons Oakleigh 22 24 22 33
8 Sunshine George Cross Sunshine 22 18 18 32
9 FC Melbourne Knights Melbourne 22 26 25 27
10 Richmond Richmond 22 28 31 24
11 Whittlesea Zebras Whittlesea 22 15 42 10
12 Preston Lions Preston 22 14 80 7
TEMPORADA 2007/2008
SEGUNDA AUSTRALIA GRUPO 2
Equipo PJ GF GC Puntos
1 Green Gully Cavaliers Green Gully 26 41 17 53
2 FC Melbourne Knights Melbourne 26 47 25 52
3 Altona Magic Altona Magic 26 44 29 47
4 Heidelberg Utd Heidelberg 26 41 30 42
5 Richmond Richmond 26 57 35 40
6 Preston Lions Preston 26 37 46 39
7 Oakleigh Cannons Oakleigh 26 28 24 37
8 AIS AIS 26 41 35 36
9 South Melbourne South 26 35 32 34
10 Hume City FC Hume City 26 29 40 31
11 Whittlesea Zebras Whittlesea 26 31 33 30
12 Western Suburbs Western 26 23 42 22
13 Fawkner Blues Fawkner 26 22 59 21
14 Frankston Pines Frankston 26 19 48 17
TEMPORADA 2006/2007
SEGUNDA AUSTRALIA GRUPO 6
Equipo PJ GF GC Puntos
1 Preston Lions Preston 4 7 4 9
2 Whittlesea Zebras Whittlesea 3 5 5 6
3 Oakleigh Cannons Oakleigh 2 1 1 3
4 FC Melbourne Knights Melbourne 3 2 3 3
5 Green Gully Cavaliers Green Gully 1 1 2 0
6 Altona Magic Altona Magic 1 0 1 0
TEMPORADA 2003/2004
LIGA AUSTRALIANA
Equipo PJ GF GC Puntos
1 Perth Glory Perth Glory 24 56 22 57
2 Parramatta Power Parramatta 24 58 30 51
3 Adelaide United Adelaide 24 28 25 40
4 Marconi Stallions Marconi 24 29 25 38
5 South Melbourne South 24 39 21 37
6 Brisbane Strikers Brisbane 24 28 33 32
7 Spirit FC Spirit FC 24 31 33 30
8 Sydney Olympic Sydney 24 26 31 29
9 South Coast Wolves South Coast 24 34 41 29
10 Sydney United Sydney 24 18 25 29
11 Newcastle Jets Newcastle 24 18 33 24
12 FC Melbourne Knights Melbourne 24 21 41 23
13 NZ Knights NZ Knights 24 25 51 15

  USO DE MEMORIA  
6,757,680 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1947
Total Execution Time  0.1959
  CADENA URL  
/historico/Melbourne-Knights
  GET DATOS  
$_GET['/historico/Melbourne-Knights']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (45)  
0.0048  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 = 'Melbourne-Knights' 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.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=15283 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=15283 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0039  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 = 74782
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=15283 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=478 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 478 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0023  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 (1122647,963803,693668,674529,674121) 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 = '15283' ORDER BY l.year DESC,cat.coefficient DESC
0.0051  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 = '15283' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0040  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 = '15283' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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 = 74782 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0039  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=15283 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0023  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 (74782,72120) 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.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 74782 AND teamId = 15283
0.0034  SELECT count(id) as num_players from rel_players WHERE league_id = 72120 AND teamId = 15283
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 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 = 74782 AND t.round = 11 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '15283' 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 = '15283' and rp.type = 4
0.0021  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 = '15283' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0027  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 = 74782 WHERE rp.league_id = 74782 AND rp.teamId = 15283 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.0049  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 = 74782 WHERE rp.league_id = 74782 AND rp.teamId = 15283 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0040  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 = 74782 WHERE rp.league_id = 74782 AND rp.teamId = 15283 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0046  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 = 15283 AND l.year <= 2024 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 `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 = 74782 AND t.round = 11 ORDER BY team.conference ASC,t.position 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 `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 = 70752 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.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 `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 = 66271 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.0027  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 = 60619 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.0028  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 `tables2020` 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 = 53839 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 48424 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 42071 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 37790 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 `tables2016` 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 = 20107 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0092  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 `tables2015` 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 = 4510 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0082  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 = 10834 AND t.round = 26 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 `tables2013` 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 = 3295 AND t.round = 22 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 `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 = 28255 AND t.round = 22 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 `tables2011` 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 = 28264 AND t.round = 22 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 `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 = 28271 AND t.round = 22 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 `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 = 28277 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 `tables2008` 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 = 28282 AND t.round = 26 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 `tables2007` 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 = 26748 AND t.round = 26 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 `tables2007` 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 = 26763 AND t.round = 4 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 `tables2004` 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 = 9956 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 74782 ORDER BY nameShow LIMIT 100