Sitios
- Twitter
Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

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

Resultados de Fútbol

Olympiacos Piraeus

Entrenador: José Luis Mendilibar

Temporada 2023/2024

TEMPORADA 2023/2024

SUPER LEAGUE GRIEGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	AEK Athens	31	70	29	69
2	Panathinaiko	31	74	27	68
3	PAOK	30	74	27	67
4	Olympiacos	30	67	29	63
5	Aris	31	43	37	48
6	Lamia	31	39	62	34

TEMPORADA 2022/2023

SUPER LEAGUE GRIEGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	AEK Athens	36	69	17	83
2	Panathinaiko	36	47	16	78
3	Olympiacos	36	70	24	73
4	PAOK	36	57	32	67
5	Aris	36	55	41	51
6	Volos	36	35	66	40

TEMPORADA 2021/2022

SUPER LEAGUE GRIEGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Olympiacos	36	62	26	83
2	PAOK	36	58	33	64
3	Aris	36	39	28	62
4	Panathinaiko	36	52	26	61
5	AEK Athens	36	56	42	56
6	Giannina	36	34	42	46

TEMPORADA 2020/2021

SUPER LEAGUE GRIEGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Olympiacos	26	64	13	67
2	Aris	26	34	16	51
3	AEK Athens	26	41	29	48
4	PAOK	26	49	26	47
5	Panathinaiko	26	30	19	45
6	Asteras	26	27	25	42
7	Volos	26	26	32	33
8	Giannina	26	23	26	31
9	Apollon	26	26	35	28
10	Atromitos	26	24	35	28
11	Lamia	26	14	38	23
12	Panaitolikos	26	13	32	20
13	OFI	26	22	43	19
14	AE Larisa	26	18	42	16

TEMPORADA 2019/2020

SUPER LEAGUE GRIEGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Olympiacos	10	21	7	91
2	PAOK	10	8	6	73
3	AEK Athens	10	17	10	69
4	Panathinaiko	10	8	9	58
5	Aris	10	10	19	42
6	OFI	10	8	21	36

TEMPORADA 2018/2019

SUPER LEAGUE GRIEGA
Equipo		PJ	GF	GC	Puntos
1	PAOK	30	66	14	80
2	Olympiacos	30	71	17	75
3	AEK Athens	30	50	19	57
4	Atromitos	30	41	28	52
5	Aris	30	46	33	49
6	Panionios	30	27	45	38
7	Lamia	30	28	37	37
8	Panathinaiko	30	38	30	36
9	Panaitolikos	30	34	48	36
10	AE Larisa	30	26	34	34
11	Asteras	30	25	30	33
12	Xanthi	30	22	34	32
13	OFI	30	30	42	32
14	Giannina	30	19	38	27
15	Levadiakos	30	15	45	21
16	Apollon	30	11	55	10

TEMPORADA 2017/2018

SUPER LEAGUE GRIEGA
Equipo		PJ	GF	GC	Puntos
1	AEK Athens	30	50	12	70
2	PAOK	30	59	19	64
3	Olympiacos	30	63	28	57
4	Atromitos	30	43	21	56
5	Asteras	30	39	24	45
6	Xanthi	30	31	30	45
7	Panionios	30	32	31	40
8	Panaitolikos	30	31	40	35
9	Giannina	30	31	34	34
10	Levadiakos	30	23	34	34
11	Panathinaiko	30	30	30	32
12	AE Larisa	30	22	41	31
13	Lamia	30	20	34	30
14	Apollon	30	23	36	29
15	Kerkyra	30	19	51	22
16	Platanias	30	14	65	10

TEMPORADA 2016/2017

SUPER LEAGUE GRIEGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Olympiacos	30	57	16	67
2	PAOK	30	52	19	61
3	Panathinaiko	30	45	19	57
4	AEK Athens	30	54	23	53
5	Panionios	30	35	23	52
6	Xanthi	30	34	25	48
7	Platanias	30	34	38	42
8	Atromitos	30	29	38	39
9	Giannina	30	30	37	36
10	Kerkyra	30	22	43	32
11	Panaitolikos	30	29	40	31
12	Asteras	30	34	49	28
13	AE Larisa	30	23	42	28
14	Levadiakos	30	27	49	26
15	Iraklis	30	28	39	26
16	Veria NPS	30	23	56	22

TEMPORADA 2015/2016

SUPER LEAGUE GRIEGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Olympiacos	30	81	16	85
2	AEK Athens	30	43	21	57
3	Panathinaiko	30	52	26	55
4	PAOK	30	45	32	48
5	Panionios	30	33	27	44
6	Giannina	30	36	40	42
7	Atromitos	30	26	31	42
8	Asteras	30	31	30	41
9	Platanias	30	32	30	39
10	Levadiakos	30	27	36	37
11	Iraklis	30	24	32	35
12	Panaitolikos	30	30	46	35
13	Xanthi	30	27	32	33
14	Veria NPS	30	19	33	27
15	Panthrakikos	30	18	58	17
16	Kalloni	30	19	53	16

TEMPORADA 2014/2015

SUPER LEAGUE GRIEGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Olympiacos	34	79	23	78
2	Panathinaiko	34	59	31	66
3	PAOK	34	57	42	65
4	Asteras	34	52	37	59
5	Atromitos	34	43	27	54
6	Giannina	34	47	33	53
7	Panaitolikos	34	41	28	52
8	Xanthi	34	44	41	47
9	Platanias	34	32	30	44
10	Kerkyra	34	39	38	44
11	Kalloni	34	34	39	44
12	Levadiakos	34	41	34	43
13	Panionios	34	43	42	43
14	Veria NPS	34	45	54	43
15	Panthrakikos	34	35	44	43
16	Ergotelis	34	35	60	32
17	OFI	33	26	72	0
18	Niki Volos	33	7	84	0

TEMPORADA 2013/2014

SUPER LEAGUE GRIEGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Olympiacos	34	88	19	86
2	PAOK	34	68	37	69
3	Panathinaiko	34	57	28	66
4	Atromitos	34	54	25	66
5	Asteras	34	46	35	58
6	Ergotelis	34	39	40	44
7	OFI	34	30	39	44
8	Panaitolikos	34	32	33	42
9	Levadiakos	34	42	61	42
10	Giannina	34	34	43	41
11	Panthrakikos	34	39	52	41
12	Panionios	34	33	42	39
13	Kalloni	34	31	62	39
14	Platanias	34	39	48	38
15	Veria NPS	34	31	51	38
16	Xanthi	34	44	54	38
17	Apollon	34	43	54	36
18	Aris	34	26	53	22

TEMPORADA 2012/2013

SUPER LEAGUE GRIEGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Olympiacos	30	64	16	77
2	PAOK	30	46	19	62
3	Asteras	30	41	25	56
4	Atromitos	30	26	22	46
5	Giannina	30	28	24	44
6	Panathinaiko	30	32	30	40
7	Xanthi	30	28	26	40
8	Panionios	30	35	42	36
9	Platanias	30	29	42	36
10	Panthrakikos	30	30	33	36
11	Levadiakos	30	21	35	34
12	Veria NPS	30	30	35	33
13	Aris	30	32	40	33
14	OFI	30	33	46	32
15	AEK Athens	30	21	36	27
16	Kerkyra	30	16	41	20

TEMPORADA 2011/2012

SUPER LEAGUE GRIEGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Olympiacos	30	70	17	73
2	Panathinaiko	30	54	23	66
3	Atromitos	30	32	26	50
4	PAOK	30	45	27	50
5	AEK Athens	30	36	30	48
6	Asteras	30	30	34	45
7	Levadiakos	30	33	42	39
8	Giannina	30	30	35	38
9	Aris	30	29	33	37
10	OFI	30	27	32	37
11	Xanthi	30	31	35	36
12	Panionios	30	26	34	33
13	Kerkyra	30	31	44	32
14	Ergotelis	30	27	44	29
15	Panaitolikos	30	23	37	28
16	Doxa Dramas	30	11	42	17

TEMPORADA 2010/2011

SUPER LEAGUE GRIEGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Olympiacos	30	65	18	73
2	Panathinaiko	30	47	26	60
3	AEK Athens	30	46	37	50
4	PAOK	30	32	29	48
5	Olympiakos	30	40	28	47
6	Aris	30	29	29	45
7	Kavala	30	29	27	40
8	Ergotelis	30	32	38	39
9	Xanthi	30	29	35	36
10	Iraklis	30	22	28	35
11	Panionios	30	25	35	35
12	Atromitos	30	30	34	34
13	Kerkyra	30	30	40	33
14	Asteras	30	21	29	31
15	AE Larisa	30	29	47	25
16	Panserraikos	30	22	48	24

TEMPORADA 2009/2010

SUPER LEAGUE GRIEGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	PAOK	6	7	3	19
2	AEK Athens	6	8	7	9
3	Aris	6	8	9	8
4	Olympiacos	6	3	7	8

Competiciones que juega

Europa League Grupo 1

Pos	Equipos		Pts
1		West Ham	15
2		SC Freiburg	12
3		Olympiacos Piraeus	7
4		FK TSC	1

	: West Ham
	: SC Freiburg
	: Olympiacos Piraeus
	Eliminado : FK TSC

RIVALES EN Conference Leagu.

RIVALES EN Copa Griega

RIVALES EN Fase Previa Euro.

RIVALES EN Europa League

RIVALES EN Super League Gri.

USO DE MEMORIA

7,208,600 bytes

BENCHMARKS

Loading Time Base Classes	0.0011
Controller Execution Time ( Home / Category )	0.2545
Total Execution Time	0.2557

CADENA URL

/historico/Olympiakos-Piraeus

GET DATOS

$_GET['/historico/Olympiakos-Piraeus']

POST DATOS

No hay datos POST existentes

CONSULTAS (56)

0.0210	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 = 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.0028	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.0027	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.0024	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.0024	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.0022	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.0023	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.0021	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.0022	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.0028	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 = 73871
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 = 75536
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 = 72170
0.0027	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 = 72101
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1863 AND type_rel = 2
0.0037	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.0050	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 = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0050	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.0021	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 = 74792 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 73871 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 = 75536 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0051	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 (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020	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 (75536,74792,73871,73551,72104,71432,67750) 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.0031	SELECT count(id) as num_players from rel_players WHERE league_id = 75536 AND teamId = 1863
0.0035	SELECT count(id) as num_players from rel_players WHERE league_id = 73871 AND teamId = 1863
0.0042	SELECT count(id) as num_players from rel_players WHERE league_id = 74792 AND teamId = 1863
0.0037	SELECT count(id) as num_players from rel_players WHERE league_id = 67750 AND teamId = 1863
0.0036	SELECT count(id) as num_players from rel_players WHERE league_id = 72104 AND teamId = 1863
0.0041	SELECT count(id) as num_players from rel_players WHERE league_id = 73551 AND teamId = 1863
0.0271	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1863
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 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 = 73871 AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0046	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 = 73871 WHERE rp.league_id = 73871 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.0046	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 = 73871 WHERE rp.league_id = 73871 AND rp.teamId = 1863 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021	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 = 73871 WHERE rp.league_id = 73871 AND rp.teamId = 1863 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0061	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 <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 72170 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.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* `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 = 75536 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.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 = 67777 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.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* `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 = 71244 AND t.round = 10 ORDER BY team.conference ASC,t.position 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* `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 = 63207 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.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* `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 = 66928 AND t.round = 10 ORDER BY team.conference ASC,t.position 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* `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 = 61824 AND t.round = 10 ORDER BY team.conference ASC,t.position 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* `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 = 58673 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* `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 = 49866 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.0020	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 = 55620 AND t.round = 10 ORDER BY team.conference ASC,t.position 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* `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 = 44207 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* `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 = 38720 AND t.round = 30 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* `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 = 33417 AND t.round = 30 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* `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 = 15431 AND t.round = 30 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* `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 = 3825 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* `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 = 2517 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* `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 = 2040 AND t.round = 30 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* `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 = 1552 AND t.round = 30 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* `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 = 1196 AND t.round = 30 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* `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 = 10442 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos

Resultados de Fútbol

Olympiacos Piraeus

Olympiacos Piraeus

Selecciona un equipo

Competiciones que juega

Europa League Grupo 1

RIVALES EN Conference Leagu.

RIVALES EN Copa Griega

RIVALES EN Fase Previa Euro.

RIVALES EN Europa League

RIVALES EN Super League Gri.