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

Olympiakos Nicosia

Entrenador: Pampos Christodoulou

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA CHIPRE GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Omonia	14	26	9	32
2	Omonia 29is	14	28	10	30
3	Olympiakos	14	23	11	24
4	Enosis Neon	14	22	22	21
5	ASIL Lysi	14	20	22	20
6	Digenis	14	19	25	17
7	Ayia Napa	14	18	33	9
8	Peyia	14	9	33	5

TEMPORADA 2022/2023

LIGA CHIPRE GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Anorthosis	40	52	44	63
2	Nea Salamis	40	51	55	58
3	Limassol	39	35	40	49
4	Karmiotissa	40	37	54	48
5	Doxa	40	32	56	39
6	Enosis Neon	40	40	52	37
7	Akritas	40	37	73	34
8	Olympiakos	40	30	62	28

TEMPORADA 2021/2022

LIGA CHIPRE GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Apollon	22	37	21	46
2	APOEL	22	35	25	39
3	AEK Larnaca	22	31	17	39
4	Anorthosis	22	36	26	38
5	Aris	22	23	20	36
6	Pafos	22	27	19	34
7	Omonia	22	25	25	31
8	Limassol	22	26	28	25
9	Olympiakos	22	14	23	22
10	Doxa	22	18	30	22
11	PAEEK	22	17	35	15
12	Ethnikos	22	13	33	13

TEMPORADA 2020/2021

LIGA CHIPRE GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Omonia	36	55	17	79
2	Apollon	36	68	30	74
3	Limassol	36	58	34	68
4	Anorthosis	36	44	37	57
5	AEK Larnaca	36	44	40	50
6	Olympiakos	36	38	51	47

TEMPORADA 2019/2020

LIGA CHIPRE GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Pafos	1	0	2	30
2	Nea Salamis	1	2	2	26
3	Olympiakos	1	1	1	25
4	Enosis Neon	1	1	1	23
5	Ethnikos	1	2	2	21
6	Doxa	1	2	0	14

TEMPORADA 2018/2019

SEGUNDA CHIPRE
Equipo		PJ	GF	GC	Puntos
1	Ethnikos	30	72	23	71
2	Olympiakos	30	77	29	69
3	Aris	30	62	33	68
4	Othellos	30	66	35	50
5	Anagennisi	30	46	33	46
6	Omonia	30	46	39	45
7	ASIL Lysi	30	43	38	45
8	Onisilos	30	42	49	39
9	Karmiotissa	30	47	64	37
10	AE Zakakiou	30	42	55	37
11	Ayia Napa	30	44	45	35
12	Akritas	30	37	61	35
13	THOI	30	27	57	32
14	MEAP Nisou	30	42	55	28
15	PAEEK	30	35	65	22
16	Digenis	30	28	75	14

TEMPORADA 2017/2018

LIGA CHIPRE GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Nea Salamis	10	25	9	48
2	Ermis	10	15	15	46
3	Doxa	10	19	23	46
4	Pafos	10	13	13	42
5	Alki	10	18	16	39
6	Olympiakos	10	12	26	24

TEMPORADA 2016/2017

SEGUNDA CHIPRE
Equipo		PJ	GF	GC	Puntos
1	Alki	26	60	16	64
2	Pafos	26	51	24	57
3	Olympiakos	26	44	23	54
4	Othellos	26	53	33	49
5	Ayia Napa	26	52	28	46
6	Enosis Neon	26	41	32	44
7	THOI	26	32	34	33
8	ASIL Lysi	26	27	33	30
9	PAEEK	26	26	38	24
10	Ethnikos	26	24	52	23
11	Omonia	26	16	30	22
12	Akritas	26	24	45	19
13	ENAD	26	26	52	19
14	Parekklisias	26	28	64	19

TEMPORADA 2015/2016

SEGUNDA CHIPRE
Equipo		PJ	GF	GC	Puntos
1	Olympiakos	26	51	19	62
2	Karmiotissa	26	54	19	61
3	Anagennisi	26	50	18	59
4	AE Zakakiou	26	47	19	58
5	Othellos	26	55	24	56
6	PAEEK	26	32	29	33
7	ENAD	26	30	32	33
8	THOI	26	44	49	33
9	Omonia	26	28	29	32
10	Parekklisias	26	35	37	27
11	ASIL Lysi	26	32	36	26
12	Elpida	26	24	60	15
13	N&S Erimis	26	13	79	9
14	Digenis	26	16	61	8

TEMPORADA 2014/2015

SEGUNDA CHIPRE
Equipo		PJ	GF	GC	Puntos
1	Pafos	26	55	19	62
2	Enosis Neon	26	55	14	60
3	Aris	26	35	25	52
4	AE Zakakiou	26	29	19	44
5	Karmiotissa	26	36	29	38
6	Anagennisi	26	27	26	38
7	Olympiakos	26	34	42	35
8	Elpida	26	29	34	34
9	ENAD	26	30	30	29
10	N&S Erimis	26	35	48	29
11	Omonia	26	35	37	28
12	Parekklisias	26	28	38	28
13	Digenis	26	16	49	18
14	APEP	26	18	52	14

TEMPORADA 2013/2014

SEGUNDA CHIPRE GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Ayia Napa	28	58	29	63
2	Othellos	28	55	25	55
3	Anagennisi	28	67	36	51
4	Omonia	28	41	33	45
5	N&S Erimis	28	48	49	33
6	Olympiakos	28	36	43	23
7	APEP	28	22	61	19
8	Pafos	28	24	75	0

TEMPORADA 2012/2013

LIGA CHIPRE GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Ethnikos	6	13	10	33
2	Alki	6	10	12	32
3	Nea Salamis	6	9	8	31
4	Olympiakos	6	10	12	31

TEMPORADA 2011/2012

LIGA CHIPRE GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Limassol	26	33	7	60
2	Omonia	26	47	16	57
3	APOEL	26	39	13	56
4	Anorthosis	26	30	12	52
5	AEK Larnaca	26	33	21	42
6	Nea Salamis	26	33	41	36
7	Alki	26	32	40	34
8	Apollon	26	31	39	34
9	Olympiakos	26	29	34	30
10	Ethnikos	26	21	23	29
11	Enosis Neon	26	17	24	29
12	Aris	26	27	35	27
13	Anagennisi	26	16	45	11
14	Ermis	26	12	50	7

Competiciones que juega

Grupo 1

Segunda Chipre Grupo 1

Pos	Equipos		Pts
1		Enosis Neon Paralimni	33
2		Olympiakos Nicosia	30
3		Omonia Aradippou	29
4		Omonia 29is	28
5		Peyia	27
6		Digenis Ypsonas	27
7		ASIL Lysi	23
8		Ayia Napa	21
9		Achyronas-Onisilos	19
10		Digenis Morphou	19
11		MEAP Nisou	15
12		Xylotympou	14
13		PAEEK	14
14		Akritas Chlorakas	12
15		ENAD	12
16		Ermis Aradippou	7

	Playoff Ascenso : Enosis Neon Paralimni, Olympiakos Nicosia, Omonia Aradippou, Omonia 29is, Peyia, Digenis Ypsonas, ASIL Lysi, Ayia Napa
	Playoff Descenso : Achyronas-Onisilos, Digenis Morphou, MEAP Nisou, Xylotympou, PAEEK, Akritas Chlorakas, ENAD, Ermis Aradippou

RIVALES EN Copa de Chipre

RIVALES EN Segunda Chipre

USO DE MEMORIA

6,012,928 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.6899
Total Execution Time	0.6911

CADENA URL

/historico/Olympiakos

GET DATOS

$_GET['/historico/Olympiakos']

POST DATOS

No hay datos POST existentes

CONSULTAS (44)

0.0139	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' 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.0126	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=1862 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127	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=1862 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=1862 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127	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=1862 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1862 AND type_rel = 2
0.0133	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1862 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0128	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 (9789,90198,757121,758041) ORDER BY n.cover_points DESC, update_date DESC
0.0131	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 = '1862' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0132	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 = '1862' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126	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 = 75144 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131	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=1862 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126	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 (75144,74229,71176,67320) 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.0129	SELECT count(id) as num_players from rel_players WHERE league_id = 71176 AND teamId = 1862
0.0128	SELECT count(id) as num_players from rel_players WHERE league_id = 75144 AND teamId = 1862
0.0128	SELECT count(id) as num_players from rel_players WHERE league_id = 74229 AND teamId = 1862
0.0131	SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 1862
0.0126	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 = '1862' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1862' and rp.type = 4
0.0127	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 = '1862' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0125	SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '1862' and rp.type = 4
0.0137	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 = 73446 WHERE rp.league_id = 73446 AND rp.teamId = 1862 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.0139	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 = 73446 WHERE rp.league_id = 73446 AND rp.teamId = 1862 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0142	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 = 73446 WHERE rp.league_id = 73446 AND rp.teamId = 1862 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153	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 = 1862 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0143	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 = 73446 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139	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 = 75144 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 71176 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 66908 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.0129	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 = 63140 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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* `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 = 56983 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.0131	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 = 61482 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.0143	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 = 50030 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137	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 = 55550 AND t.round = 1 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145	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 = 44927 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134	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 = 38697 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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 = 42969 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134	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 = 33687 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142	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 = 15734 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 4169 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 8748 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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 = 2047 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 10246 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138	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 = 1377 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Olympiakos Nicosia

Olympiakos Nicosia

Selecciona un equipo

Competiciones que juega

Segunda Chipre Grupo 1

RIVALES EN Copa de Chipre

RIVALES EN Segunda Chipre