4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Segunda Australia 2019

La temporada finalizó el Sábado, 31 Agosto 2019.
Resultados
« Jornada Anterior
Jornada 22
 
 
31 Ago 19
09:00 Finalizado 		Armadale Armadale 1-0 ECU Joondalup ECU Joondalup más información Jugadas destacadas ...
68' M. Uriel 1-0
 
31 Ago 19
09:00 Finalizado 		Perth SC Perth SC 2-3 Sorrento FC Sorrento FC más información Jugadas destacadas ...
0-1 17' A. Morgan
0-2 26' A. Morgan
0-3 40' A. Morgan
76' P. Zimarino 1-3
88' M. Domfeh 2-3
 
31 Ago 19
09:00 Finalizado 		Floreat Athena Floreat Athena 3-6 Rockingham City Rockingham City más información Jugadas destacadas ...
6' R. Petkov 1-0
1-1 11' R. Van Dieken
1-2 12' Harmer
1-3 27' R. Van Dieken
1-4 32' Harmer
55' D. Evans 2-4
67' A. Phillip 3-4
3-5 83' R. Kennedy
85' R. Malton
 
31 Ago 19
09:00 Finalizado 		Bayswater City Bayswater City 1-2 Cockburn City Cockburn City más información Jugadas destacadas ...
0-1 5' H. Stevens
49' G. Smith 1-1
66' D. Santich
1-2 72' Rosindale
74' S. Hesketh
 
31 Ago 19
09:00 Finalizado 		Balcatta Balcatta 1-0 Stirling Macedonia Stirling Macedonia más información Jugadas destacadas ...
61' J. Kearney 1-0
 
31 Ago 19
09:00 Finalizado 		Inglewood United Inglewood United 2-0 Perth Glory Sub 21 Perth Glory Sub 21 más información Jugadas destacadas ...
19' H. Evans 1-0
25' S. Sokol 2-0
Clasificación
« Jornada Anterior
Jornada 22
 
Grupo A Puntos J. G. E. P. F. C. Forma
1 Perth SC Perth SC 49 22 15 4 3 53 21
  • DERROTA
  • Floreat Athena 2
  • Perth SC 1
  • VICTORIA
  • Perth SC 3
  • Balcatta 0
  • VICTORIA
  • Armadale 0
  • Perth SC 2
  • VICTORIA
  • Cockburn City 3
  • Perth SC 4
  • DERROTA
  • Perth SC 2
  • Sorrento FC 3
2 Inglewood United Inglewood United 38 22 11 5 6 38 36
  • EMPATE
  • Inglewood United 2
  • Sorrento FC 2
  • EMPATE
  • ECU Joondalup 1
  • Inglewood United 1
  • VICTORIA
  • Inglewood United 3
  • Stirling Macedonia 0
  • VICTORIA
  • Rockingham City 1
  • Inglewood United 3
  • VICTORIA
  • Inglewood United 2
  • Perth Glory Sub 21 0
3 Sorrento FC Sorrento FC 31 22 9 4 9 40 41
  • EMPATE
  • Inglewood United 2
  • Sorrento FC 2
  • EMPATE
  • Sorrento FC 3
  • Floreat Athena 3
  • EMPATE
  • Balcatta 2
  • Sorrento FC 2
  • DERROTA
  • Sorrento FC 0
  • Armadale 1
  • VICTORIA
  • Perth SC 2
  • Sorrento FC 3
4 Rockingham City Rockingham City 26 22 8 2 12 37 49
  • VICTORIA
  • Rockingham City 1
  • Cockburn City 0
  • VICTORIA
  • Rockingham City 2
  • Perth Glory Sub 21 1
  • DERROTA
  • Bayswater City 5
  • Rockingham City 0
  • DERROTA
  • Rockingham City 1
  • Inglewood United 3
  • VICTORIA
  • Floreat Athena 3
  • Rockingham City 6
5 ECU Joondalup ECU Joondalup 23 22 4 11 7 24 32
  • EMPATE
  • Bayswater City 1
  • ECU Joondalup 1
  • EMPATE
  • ECU Joondalup 1
  • Inglewood United 1
  • VICTORIA
  • Floreat Athena 1
  • ECU Joondalup 2
  • EMPATE
  • ECU Joondalup 2
  • Balcatta 2
  • DERROTA
  • Armadale 1
  • ECU Joondalup 0
6 Stirling Macedonia Stirling 19 22 5 4 13 16 42
  • DERROTA
  • Perth Glory Sub 21 1
  • Stirling Macedonia 0
  • VICTORIA
  • Stirling Macedonia 2
  • Bayswater City 1
  • DERROTA
  • Inglewood United 3
  • Stirling Macedonia 0
  • EMPATE
  • Stirling Macedonia 0
  • Floreat Athena 0
  • DERROTA
  • Balcatta 1
  • Stirling Macedonia 0
Grupo B Puntos J. G. E. P. F. C. Forma
1 Floreat Athena Floreat Athena 37 22 11 4 7 48 37
  • VICTORIA
  • Floreat Athena 2
  • Perth SC 1
  • EMPATE
  • Sorrento FC 3
  • Floreat Athena 3
  • DERROTA
  • Floreat Athena 1
  • ECU Joondalup 2
  • EMPATE
  • Stirling Macedonia 0
  • Floreat Athena 0
  • DERROTA
  • Floreat Athena 3
  • Rockingham City 6
2 Balcatta Balcatta 33 22 9 6 7 26 26
  • EMPATE
  • Balcatta 3
  • Armadale 3
  • DERROTA
  • Perth SC 3
  • Balcatta 0
  • EMPATE
  • Balcatta 2
  • Sorrento FC 2
  • EMPATE
  • ECU Joondalup 2
  • Balcatta 2
  • VICTORIA
  • Balcatta 1
  • Stirling Macedonia 0
3 Bayswater City Bayswater City 32 22 9 5 8 45 29
  • EMPATE
  • Bayswater City 1
  • ECU Joondalup 1
  • DERROTA
  • Stirling Macedonia 2
  • Bayswater City 1
  • VICTORIA
  • Bayswater City 5
  • Rockingham City 0
  • VICTORIA
  • Perth Glory Sub 21 1
  • Bayswater City 2
  • DERROTA
  • Bayswater City 1
  • Cockburn City 2
4 Cockburn City Cockburn City 28 22 8 4 10 38 38
  • DERROTA
  • Rockingham City 1
  • Cockburn City 0
  • DERROTA
  • Cockburn City 1
  • Armadale 5
  • VICTORIA
  • Perth Glory Sub 21 0
  • Cockburn City 1
  • DERROTA
  • Cockburn City 3
  • Perth SC 4
  • VICTORIA
  • Bayswater City 1
  • Cockburn City 2
5 Perth Glory Sub 21 Perth Glory 26 22 7 5 10 35 39
  • VICTORIA
  • Perth Glory Sub 21 1
  • Stirling Macedonia 0
  • DERROTA
  • Rockingham City 2
  • Perth Glory Sub 21 1
  • DERROTA
  • Perth Glory Sub 21 0
  • Cockburn City 1
  • DERROTA
  • Perth Glory Sub 21 1
  • Bayswater City 2
  • DERROTA
  • Inglewood United 2
  • Perth Glory Sub 21 0
6 Armadale Armadale 25 22 7 4 11 35 45
  • EMPATE
  • Balcatta 3
  • Armadale 3
  • VICTORIA
  • Cockburn City 1
  • Armadale 5
  • DERROTA
  • Armadale 0
  • Perth SC 2
  • VICTORIA
  • Sorrento FC 0
  • Armadale 1
  • VICTORIA
  • Armadale 1
  • ECU Joondalup 0
Series Finales : Perth SC, Floreat Athena
JUGADORES DESTACADOS

INFORMACIÓN

La FFA está integrada por distintas federaciones que rigen el fútbol en cada uno de los estados de Australia, excepto en Nueva Gales del Sur, donde existen dos federaciones (norte y sur): Football Federation Victoria (Estado de Victoria) Capital Football o Australian Capital Territory Football Federation (Territorio de la Capital Australiana) Football Federation Northern Territory (Territorio del Norte) Football Queensland (Estado de Queensland) Football Federation of South Australia (Estado de Australia Meridional) Football West (Estado de Australia Occidental Football Federation Tasmania (Estado de Tasmania) Football New South Wales (Centro y sur del Estado de Nueva Gales del Sur) Northern New South Wales Football (Norte de Estado de Nueva Gales del Sur)

  USO DE MEMORIA  
5,704,920 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3469
Total Execution Time  0.3489
  CADENA URL  
/segunda_australia2019/grupo2
  GET DATOS  
$_GET['/segunda_australia2019/grupo2']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0136  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.0139  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.0134  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 = 48423 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 01:55:16' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 01:55:16' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 01:55:16' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 01:55:16' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0133  SELECT rel.media_id, rel.team1, rel.team2, m.name, m.type, m.lang, m.location, rel.id AS rel_id, m.url FROM rel_media_match AS rel INNER JOIN media AS m ON m.id=rel.media_id WHERE (m.lang='es' OR m.language='spanish') AND rel.active=1 AND rel.league_id=48423 AND rel.round=22
0.0128  SELECT fau.user_name, c.*, NOW() as difference_time,creation_date FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id LEFT JOIN fa_user fau ON fau.id = c.author_id WHERE c.creation_date > "2024-03-28" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 48423 ORDER BY creation_date DESC LIMIT 0, 10
0.0148  SELECT count(c.id) as cuenta FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id WHERE c.creation_date > "2024-03-28" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 48423
0.0169  SELECT c.isVideo, c.id,c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars2019` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 48423 AND c.`round` = 22 ORDER BY shedule ASC LIMIT 200
0.0170  SELECT ev.match_id,dp.alias,ev.minute,ev.action,ev.player_id,e.name,e.classf,dp.nick,rel.squadNumber,rel.player_id as playerId,rel.team_id,rel.teamId FROM events2019 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2019 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 48423 AND (ev.team1id=rel.team_id OR ev.team2id=rel.team_id) INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE ev.match_id IN (418782,418783,418784,418785,418786,418787) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0137  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2019` e INNER JOIN calendars2019 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 22 AND e.real_date IS NOT NULL AND e.league_id = 48423 ORDER BY total DESC LIMIT 40
0.0136  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 = 48423 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  SELECT *,(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 = 48423 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  SELECT distinct(shedule), round FROM `calendars2019` as c WHERE c.`league_id` = 48423 AND shedule >= '2019/08/01' AND shedule < '2019/09/01' ORDER BY shedule ASC
0.0144  SELECT data1, data2 FROM services_tags WHERE categoryId=478
0.0144  SELECT group_code, extraName from `leagues` WHERE categoryId=478 AND year=2019