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

Karmiotissa

Entrenador: Marios Charalampous

Temporada 2023/2024

TEMPORADA 2023/2024

LIGA CHIPRE GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	APOEL	26	54	16	59
2	Aris	26	53	21	56
3	AEK Larnaca	26	44	26	52
4	Pafos	26	48	20	50
5	Omonia	26	49	30	49
6	Anorthosis	26	38	23	47
7	Apollon	26	37	27	38
8	Nea Salamis	26	34	39	36
9	Limassol	26	34	45	30
10	Ethnikos	26	39	56	26
11	Karmiotissa	26	31	53	20
12	AE Zakakiou	26	28	59	16
13	Othellos	26	20	52	15
14	Doxa	26	14	56	12

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

SEGUNDA CHIPRE
Equipo		PJ	GF	GC	Puntos
1	Karmiotissa	30	52	20	63
2	Nea Salamis	30	59	24	63
3	Akritas	30	49	26	58
4	Enosis Neon	30	48	24	57
5	Alki	30	36	38	47
6	Ermis	30	43	42	44
7	Othellos	30	40	53	42
8	Xylotympou	30	39	42	38
9	Anagennisi	30	33	40	37
10	Omonia 29is	30	31	33	36
11	Omonia	30	30	44	35
12	Onisilos	30	34	44	33
13	Ayia Napa	30	41	52	31
14	Ahironas	30	28	41	31
15	Olympiada	30	23	44	28
16	ASIL Lysi	30	28	47	23

TEMPORADA 2020/2021

LIGA CHIPRE GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Pafos	40	58	38	63
2	APOEL	40	48	39	60
3	Ethnikos	40	48	56	52
4	Doxa	40	46	43	51
5	Nea Salamis	40	48	61	43
6	Ermis	40	40	61	38
7	Enosis Neon	40	35	61	34
8	Karmiotissa	40	36	98	24

TEMPORADA 2019/2020

SEGUNDA CHIPRE GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Karmiotissa	6	15	7	15
2	Aris	6	7	4	13
3	Ayia Napa	6	4	2	11
4	Ermis	6	9	8	10
5	Onisilos	6	6	8	7
6	ASIL Lysi	6	3	5	5
7	Othellos	6	7	13	4
8	Anagennisi	6	8	12	3

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

SEGUNDA CHIPRE
Equipo		PJ	GF	GC	Puntos
1	Enosis Neon	26	54	20	60
2	Anagennisi	26	53	23	59
3	Othellos	26	45	19	54
4	Ayia Napa	26	43	33	42
5	AE Zakakiou	26	36	26	41
6	Omonia	26	39	33	38
7	Karmiotissa	26	41	36	37
8	ASIL Lysi	26	32	35	32
9	PAEEK	26	33	40	31
10	Digenis	26	30	50	28
11	THOI	26	25	39	26
12	Xylotympou	26	29	44	26
13	Ethnikos	26	22	42	18
14	Halkanoras	26	23	65	12

TEMPORADA 2016/2017

LIGA CHIPRE GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Nea Salamis	10	11	11	45
2	Ethnikos	10	15	20	43
3	Ermis	10	16	20	42
4	Aris	10	17	13	41
5	Doxa	10	20	14	37
6	Karmiotissa	10	17	18	37

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 2
Equipo		PJ	GF	GC	Puntos
1	Karmiotissa	18	40	16	36
2	Parekklisias	18	21	18	31
3	Chalkanoras	18	26	22	27
4	AE Zakakiou	18	17	28	23
5	Digenis	18	20	18	22
6	Onisilos	18	15	23	20
7	PAEEK	18	15	17	19
8	ASIL Lysi	18	14	26	19

TEMPORADA 2012/2013

TERCERA CHIPRE
Equipo		PJ	GF	GC	Puntos
1	Karmiotissa	26	49	19	56
2	Parekklisias	26	54	20	53
3	Digenis	26	40	26	51
4	ASIL Lysi	26	41	22	50
5	ENAD	26	39	22	45
6	Spartakos	26	38	37	41
7	Adonis	26	38	35	37
8	Ethnikos	26	27	34	29
9	Ormideia	26	33	33	27
10	Ahironas	26	26	55	23
11	Digenis	26	27	43	22
12	Elpida	26	22	43	22
13	Frenaros	26	32	52	21
14	Atromitos	26	28	53	20

Competiciones que juega

Grupo 1

Liga Chipre Grupo 3

Pos	Equipos		Pts
1		Ethnikos Achnas	21
2		Apollon Limassol	21
3		AEL Limassol	20
4		Karmiotissa	19
5		Doxa Katokopias	19
6		Othellos Athienou	12
7		Nea Salamis	11
8		AE Zakakiou	1

	Descenso : Othellos Athienou, Nea Salamis, AE Zakakiou

RIVALES EN Copa de Chipre

RIVALES EN Liga Chipre

USO DE MEMORIA

6,069,664 bytes

BENCHMARKS

Loading Time Base Classes	0.0014
Controller Execution Time ( Home / Category )	0.1644
Total Execution Time	0.1658

CADENA URL

/historico/Karmiotissa

GET DATOS

$_GET['/historico/Karmiotissa']

POST DATOS

No hay datos POST existentes

CONSULTAS (44)

0.0046	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 = 'Karmiotissa' 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.0020	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=19169 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=19169 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	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=19169 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=19169 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	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=19169 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0049	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 = 74229
0.0020	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19169 AND type_rel = 2
0.0020	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=187 AND type_rel = 3
0.0033	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 187 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0032	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 (1280408,1272893,1257778,1219444,1213703) ORDER BY n.cover_points DESC, update_date DESC
0.0035	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 = '19169' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0034	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 = '19169' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024	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 = 74229 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025	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 = 75462 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0036	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=19169 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0022	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 (75462,74229,71432) 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.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 75462 AND teamId = 19169
0.0030	SELECT count(id) as num_players from rel_players WHERE league_id = 74229 AND teamId = 19169
0.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 19169
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 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 = 75462 AND t.round = 12 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0029	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 = '19169' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0021	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '19169' and rp.type = 4
0.0020	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 = '19169' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0031	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 = 75462 WHERE rp.league_id = 75462 AND rp.teamId = 19169 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.0030	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 = 75462 WHERE rp.league_id = 75462 AND rp.teamId = 19169 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023	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 = 75462 WHERE rp.league_id = 75462 AND rp.teamId = 19169 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032	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 = 19169 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 72108 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.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 = 67847 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.0021	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.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* `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 = 64192 AND t.round = 30 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* `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.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 = 61483 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.0021	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 = 51093 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.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 = 55493 AND t.round = 6 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* `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.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* `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 = 38801 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 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 = 33682 AND t.round = 26 ORDER BY team.conference 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* `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 = 38058 AND t.round = 10 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* `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.0021	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.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* `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 = 2771 AND t.round = 28 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* `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 = 23918 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Karmiotissa

Karmiotissa

Selecciona un equipo

Competiciones que juega

Liga Chipre Grupo 3

RIVALES EN Copa de Chipre

RIVALES EN Liga Chipre