4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
01 Oct 17 D. Neo SidirochoriSidirochori 0 - 5 Apollon ParalimniouApollon ...
01 Oct 17 M. Alexandros KarperiAlexandros 2 - 2 Aetos OrfaniAetos ...
01 Oct 17 KavalaKavala 3 - 1 Aris AvatoAris Avato ...
01 Oct 17 Orfeas XanthiOrfeas 2 - 1 Doxa ProskynitonDoxa ...
01 Oct 17 Elpis SkoutariElpis 2 - 0 M. Alexandros XiropotamosAlexandros ...
02 Oct 17 AE DidymoteichoDidymoteich 1 - 0 Nestos ChrisoupolisNestos ...
Ver jornada
Jornada 2
08 Oct 17 D. Neo SidirochoriSidirochori 1 - 1 AE DidymoteichoDidymoteich ...
08 Oct 17 Nestos ChrisoupolisNestos 2 - 0 M. Alexandros KarperiAlexandros ...
08 Oct 17 Apollon ParalimniouApollon 2 - 0 KavalaKavala ...
08 Oct 17 Aetos OrfaniAetos 1 - 1 Orfeas XanthiOrfeas ...
08 Oct 17 Aris AvatoAris Avato 1 - 1 Elpis SkoutariElpis ...
08 Oct 17 M. Alexandros XiropotamosAlexandros 1 - 2 Doxa ProskynitonDoxa ...
Ver jornada
Jornada 3
15 Oct 17 AE DidymoteichoDidymoteich 2 - 1 M. Alexandros KarperiAlexandros ...
15 Oct 17 KavalaKavala 4 - 0 D. Neo SidirochoriSidirochori ...
15 Oct 17 Orfeas XanthiOrfeas 1 - 3 Nestos ChrisoupolisNestos ...
15 Oct 17 Elpis SkoutariElpis 2 - 2 Apollon ParalimniouApollon ...
15 Oct 17 M. Alexandros XiropotamosAlexandros 2 - 0 Aetos OrfaniAetos ...
15 Oct 17 Doxa ProskynitonDoxa 0 - 0 Aris AvatoAris Avato ...
Ver jornada
Jornada 4
22 Oct 17 KavalaKavala 1 - 0 AE DidymoteichoDidymoteich ...
22 Oct 17 M. Alexandros KarperiAlexandros 1 - 0 Orfeas XanthiOrfeas ...
22 Oct 17 D. Neo SidirochoriSidirochori 1 - 2 Elpis SkoutariElpis ...
22 Oct 17 Nestos ChrisoupolisNestos 0 - 0 M. Alexandros XiropotamosAlexandros ...
22 Oct 17 Apollon ParalimniouApollon 4 - 0 Doxa ProskynitonDoxa ...
22 Oct 17 Aris AvatoAris Avato 1 - 0 Aetos OrfaniAetos ...
Ver jornada
Jornada 5
05 Nov 17 AE DidymoteichoDidymoteich 0 - 0 Orfeas XanthiOrfeas ...
05 Nov 17 Elpis SkoutariElpis 1 - 1 KavalaKavala ...
05 Nov 17 M. Alexandros XiropotamosAlexandros 0 - 2 M. Alexandros KarperiAlexandros ...
05 Nov 17 Doxa ProskynitonDoxa 2 - 2 D. Neo SidirochoriSidirochori ...
05 Nov 17 Aris AvatoAris Avato 1 - 0 Nestos ChrisoupolisNestos ...
05 Nov 17 Aetos OrfaniAetos 0 - 0 Apollon ParalimniouApollon ...
Ver jornada
Jornada 6
12 Nov 17 Elpis SkoutariElpis 0 - 2 AE DidymoteichoDidymoteich ...
12 Nov 17 Orfeas XanthiOrfeas 1 - 0 M. Alexandros XiropotamosAlexandros ...
12 Nov 17 KavalaKavala 2 - 1 Doxa ProskynitonDoxa ...
12 Nov 17 M. Alexandros KarperiAlexandros 1 - 1 Aris AvatoAris Avato ...
12 Nov 17 D. Neo SidirochoriSidirochori 0 - 1 Aetos OrfaniAetos ...
12 Nov 17 Nestos ChrisoupolisNestos 2 - 0 Apollon ParalimniouApollon ...
Ver jornada
Jornada 7
19 Nov 17 AE DidymoteichoDidymoteich 1 - 1 M. Alexandros XiropotamosAlexandros ...
19 Nov 17 Doxa ProskynitonDoxa 0 - 2 Elpis SkoutariElpis ...
18 Nov 17 Aris AvatoAris Avato 1 - 0 Orfeas XanthiOrfeas ...
19 Nov 17 Aetos OrfaniAetos 1 - 0 KavalaKavala ...
19 Nov 17 Apollon ParalimniouApollon 1 - 0 M. Alexandros KarperiAlexandros ...
19 Nov 17 Nestos ChrisoupolisNestos 3 - 0 D. Neo SidirochoriSidirochori ...
Ver jornada
Jornada 8
03 Dic 17 Doxa ProskynitonDoxa 2 - 1 AE DidymoteichoDidymoteich ...
03 Dic 17 M. Alexandros XiropotamosAlexandros 1 - 0 Aris AvatoAris Avato ...
03 Dic 17 Elpis SkoutariElpis 2 - 1 Aetos OrfaniAetos ...
03 Dic 17 Orfeas XanthiOrfeas 0 - 1 Apollon ParalimniouApollon ...
03 Dic 17 KavalaKavala 0 - 0 Nestos ChrisoupolisNestos ...
03 Dic 17 M. Alexandros KarperiAlexandros 0 - 1 D. Neo SidirochoriSidirochori ...
Ver jornada
Jornada 9
10 Dic 17 AE DidymoteichoDidymoteich 0 - 0 Aris AvatoAris Avato ...
10 Dic 17 Aetos OrfaniAetos 3 - 2 Doxa ProskynitonDoxa ...
09 Dic 17 Apollon ParalimniouApollon 2 - 0 M. Alexandros XiropotamosAlexandros ...
10 Dic 17 Nestos ChrisoupolisNestos 0 - 1 Elpis SkoutariElpis ...
10 Dic 17 D. Neo SidirochoriSidirochori 1 - 1 Orfeas XanthiOrfeas ...
10 Dic 17 M. Alexandros KarperiAlexandros 1 - 3 KavalaKavala ...
Ver jornada
Jornada 10
17 Dic 17 Aetos OrfaniAetos 1 - 0 AE DidymoteichoDidymoteich ...
16 Dic 17 Aris AvatoAris Avato 1 - 1 Apollon ParalimniouApollon ...
17 Dic 17 Doxa ProskynitonDoxa 1 - 2 Nestos ChrisoupolisNestos ...
17 Dic 17 M. Alexandros XiropotamosAlexandros 1 - 0 D. Neo SidirochoriSidirochori ...
17 Dic 17 Elpis SkoutariElpis 1 - 0 M. Alexandros KarperiAlexandros ...
17 Dic 17 Orfeas XanthiOrfeas 1 - 0 KavalaKavala ...
Ver jornada
Jornada 11
07 Ene 18 Apollon ParalimniouApollon 4 - 0 AE DidymoteichoDidymoteich ...
07 Ene 18 Nestos ChrisoupolisNestos 0 - 1 Aetos OrfaniAetos ...
07 Ene 18 D. Neo SidirochoriSidirochori 0 - 1 Aris AvatoAris Avato ...
07 Ene 18 M. Alexandros KarperiAlexandros 0 - 1 Doxa ProskynitonDoxa ...
07 Ene 18 KavalaKavala 3 - 0 M. Alexandros XiropotamosAlexandros ...
07 Ene 18 Orfeas XanthiOrfeas 0 - 1 Elpis SkoutariElpis ...
Ver jornada
Jornada 12
14 Ene 18 Nestos ChrisoupolisNestos 1 - 0 AE DidymoteichoDidymoteich ...
14 Ene 18 Apollon ParalimniouApollon 2 - 1 D. Neo SidirochoriSidirochori ...
14 Ene 18 Aetos OrfaniAetos 5 - 2 M. Alexandros KarperiAlexandros ...
14 Ene 18 Aris AvatoAris Avato 1 - 1 KavalaKavala ...
14 Ene 18 Doxa ProskynitonDoxa 1 - 2 Orfeas XanthiOrfeas ...
14 Ene 18 M. Alexandros XiropotamosAlexandros 1 - 0 Elpis SkoutariElpis ...
Ver jornada
Jornada 13
21 Ene 18 AE DidymoteichoDidymoteich 0 - 0 D. Neo SidirochoriSidirochori ...
21 Ene 18 M. Alexandros KarperiAlexandros 0 - 0 Nestos ChrisoupolisNestos ...
21 Ene 18 KavalaKavala 1 - 0 Apollon ParalimniouApollon ...
21 Ene 18 Orfeas XanthiOrfeas 2 - 4 Aetos OrfaniAetos ...
21 Ene 18 Elpis SkoutariElpis 2 - 1 Aris AvatoAris Avato ...
21 Ene 18 Doxa ProskynitonDoxa 2 - 1 M. Alexandros XiropotamosAlexandros ...
Ver jornada
Jornada 14
28 Ene 18 M. Alexandros KarperiAlexandros 0 - 1 AE DidymoteichoDidymoteich ...
28 Ene 18 D. Neo SidirochoriSidirochori 0 - 2 KavalaKavala ...
28 Ene 18 Nestos ChrisoupolisNestos 1 - 0 Orfeas XanthiOrfeas ...
28 Ene 18 Apollon ParalimniouApollon 1 - 0 Elpis SkoutariElpis ...
28 Ene 18 Aetos OrfaniAetos 3 - 1 M. Alexandros XiropotamosAlexandros ...
28 Ene 18 Aris AvatoAris Avato 1 - 1 Doxa ProskynitonDoxa ...
Ver jornada
Jornada 15
04 Feb 18 AE DidymoteichoDidymoteich 1 - 2 KavalaKavala ...
04 Feb 18 Orfeas XanthiOrfeas 3 - 1 M. Alexandros KarperiAlexandros ...
04 Feb 18 Elpis SkoutariElpis 3 - 0 D. Neo SidirochoriSidirochori ...
04 Feb 18 M. Alexandros XiropotamosAlexandros 2 - 1 Nestos ChrisoupolisNestos ...
04 Feb 18 Doxa ProskynitonDoxa 1 - 3 Apollon ParalimniouApollon ...
04 Feb 18 Aetos OrfaniAetos 1 - 0 Aris AvatoAris Avato ...
Ver jornada
Jornada 16
11 Feb 18 Orfeas XanthiOrfeas 5 - 0 AE DidymoteichoDidymoteich ...
11 Feb 18 KavalaKavala 0 - 2 Elpis SkoutariElpis ...
11 Feb 18 M. Alexandros KarperiAlexandros 1 - 3 M. Alexandros XiropotamosAlexandros ...
11 Feb 18 D. Neo SidirochoriSidirochori 1 - 0 Doxa ProskynitonDoxa ...
11 Feb 18 Nestos ChrisoupolisNestos 0 - 1 Aris AvatoAris Avato ...
11 Feb 18 Apollon ParalimniouApollon 1 - 0 Aetos OrfaniAetos ...
Ver jornada
Jornada 17
17 Feb 18 AE DidymoteichoDidymoteich 2 - 2 Elpis SkoutariElpis ...
17 Feb 18 M. Alexandros XiropotamosAlexandros 0 - 0 Orfeas XanthiOrfeas ...
17 Feb 18 Doxa ProskynitonDoxa 1 - 2 KavalaKavala ...
17 Feb 18 Aris AvatoAris Avato 4 - 0 M. Alexandros KarperiAlexandros ...
17 Feb 18 Aetos OrfaniAetos 3 - 1 D. Neo SidirochoriSidirochori ...
17 Feb 18 Apollon ParalimniouApollon 2 - 1 Nestos ChrisoupolisNestos ...
Ver jornada
Jornada 18
25 Feb 18 M. Alexandros XiropotamosAlexandros 1 - 2 AE DidymoteichoDidymoteich ...
25 Feb 18 Elpis SkoutariElpis 0 - 0 Doxa ProskynitonDoxa ...
24 Feb 18 Orfeas XanthiOrfeas 1 - 0 Aris AvatoAris Avato ...
25 Feb 18 KavalaKavala 1 - 2 Aetos OrfaniAetos ...
25 Feb 18 M. Alexandros KarperiAlexandros 0 - 2 Apollon ParalimniouApollon ...
25 Feb 18 D. Neo SidirochoriSidirochori 0 - 2 Nestos ChrisoupolisNestos ...
Ver jornada
Jornada 19
04 Mar 18 AE DidymoteichoDidymoteich 2 - 0 Doxa ProskynitonDoxa ...
04 Mar 18 Aris AvatoAris Avato 4 - 1 M. Alexandros XiropotamosAlexandros ...
04 Mar 18 Aetos OrfaniAetos 2 - 5 Elpis SkoutariElpis ...
04 Mar 18 Apollon ParalimniouApollon 4 - 2 Orfeas XanthiOrfeas ...
04 Mar 18 Nestos ChrisoupolisNestos 2 - 2 KavalaKavala ...
04 Mar 18 D. Neo SidirochoriSidirochori 1 - 0 M. Alexandros KarperiAlexandros ...
Ver jornada
Jornada 20
11 Mar 18 Aris AvatoAris Avato 0 - 0 AE DidymoteichoDidymoteich ...
11 Mar 18 Doxa ProskynitonDoxa 1 - 3 Aetos OrfaniAetos ...
11 Mar 18 M. Alexandros XiropotamosAlexandros 0 - 1 Apollon ParalimniouApollon ...
11 Mar 18 Elpis SkoutariElpis 1 - 2 Nestos ChrisoupolisNestos ...
11 Mar 18 Orfeas XanthiOrfeas 5 - 2 D. Neo SidirochoriSidirochori ...
11 Mar 18 KavalaKavala 3 - 0 M. Alexandros KarperiAlexandros ...
Ver jornada
Jornada 21
18 Mar 18 AE DidymoteichoDidymoteich 1 - 0 Aetos OrfaniAetos ...
18 Mar 18 Apollon ParalimniouApollon 0 - 1 Aris AvatoAris Avato ...
18 Mar 18 Nestos ChrisoupolisNestos 1 - 1 Doxa ProskynitonDoxa ...
18 Mar 18 D. Neo SidirochoriSidirochori 3 - 2 M. Alexandros XiropotamosAlexandros ...
18 Mar 18 M. Alexandros KarperiAlexandros 1 - 1 Elpis SkoutariElpis ...
18 Mar 18 KavalaKavala 2 - 2 Orfeas XanthiOrfeas ...
Ver jornada
Jornada 22
01 Abr 18 AE DidymoteichoDidymoteich 1 - 0 Apollon ParalimniouApollon ...
01 Abr 18 Aetos OrfaniAetos 1 - 0 Nestos ChrisoupolisNestos ...
01 Abr 18 Aris AvatoAris Avato 0 - 3 D. Neo SidirochoriSidirochori ...
01 Abr 18 Doxa ProskynitonDoxa 3 - 1 M. Alexandros KarperiAlexandros ...
01 Abr 18 M. Alexandros XiropotamosAlexandros 0 - 2 KavalaKavala ...
01 Abr 18 Elpis SkoutariElpis 0 - 1 Orfeas XanthiOrfeas ...

Clasificación

Equipo PJ GF GC Puntos
1 Apollon Paralimniou Apollon 22 38 13 48
2 Aetos Orfani Aetos Orfani 22 35 25 42
3 Kavala Kavala 22 35 19 41
4 Elpis Skoutari Elpis 22 31 19 39
5 Nestos Chrisoupolis Nestos 22 23 16 32
6 Orfeas Xanthi Orfeas 22 30 25 32
7 Aris Avato Aris Avato 22 21 17 32
8 AE Didymoteicho Didymoteicho 22 18 22 31
9 M. Alexandros Xiropotamos Alexandros 22 18 32 21
10 Doxa Proskyniton Doxa 22 23 36 20
11 D. Neo Sidirochori Sidirochori 22 18 40 19
12 M. Alexandros Karperi Alexandros 22 14 40 10

  USO DE MEMORIA  
5,580,856 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1003
Total Execution Time  0.1021
  CADENA URL  
/3_league_grecia2018/grupo1/calendario
  GET DATOS  
$_GET['/3_league_grecia2018/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0018  SELECT type FROM routes WHERE alias = '3_league_grecia2018'
0.0041  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = '3_league_grecia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2018 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=344 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 344 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  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 (1098455,1051323,606708,277509,105444) ORDER BY n.cover_points DESC, update_date DESC
0.0019  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 = 40660 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  SELECT 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, dt1.stadium as stadium_name FROM calendars2018 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 40660 ORDER BY round ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-08 15:12:16' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-08 15:12:16' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-08 15:12:16' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-08 15:12:16' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = '3_league_grecia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2018 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0020  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 events2018 e ON e.player_id = p.id AND e.league_id = 40660 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 40660 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.0019  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 events2018 e ON e.player_id = p.id AND e.league_id = 40660 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 40660 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  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 events2018 e ON e.player_id = p.id AND e.league_id = 40660 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 40660 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0027  SELECT *,(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 = 40660 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC