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

Kerkyra

Temporada 2015/2016

TEMPORADA 2015/2016

FOOTBALL LEAGUE GRECIA
Equipo		PJ	GF	GC	Puntos
1	AE Larisa	34	49	15	78
2	Kerkyra	34	57	24	75
3	Trikala	34	53	22	67
4	Apollon	34	46	19	61
5	Lamia	34	41	24	59
6	Chania	34	29	19	51
7	Athens	34	41	31	49
8	Acharnaikos	34	30	29	45
9	Anagennisi	34	30	34	45
10	Panserraikos	34	39	43	43
11	Agrotikos	34	27	24	43
12	Chania	34	34	37	41
13	Panegialios	34	34	40	41
14	Panelefsinia	34	34	53	35
15	Zakynthos	34	31	32	34
16	Panachaiki	34	26	47	28
17	Olympiakos	33	16	69	10
18	Ergotelis	33	18	73	7

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

FOOTBALL LEAGUE GRECIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Niki Volos	14	18	9	27
2	Kerkyra	14	13	10	22
3	Chania	14	15	9	21
4	Olympiakos	14	10	5	19
5	Iraklis	14	13	11	19
6	Aiginiakos	14	12	18	16
7	Iraklis	14	9	16	15
8	Fostiras	14	6	18	10

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

FOOTBALL LEAGUE GRECIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Olympiakos	34	73	36	68
2	Kerkyra	34	45	25	63
3	OFI	34	44	35	62
4	Ethnikos	34	43	30	53
5	Panserraikos	34	36	35	52
6	Pierikos	34	41	31	50
7	Panaitolikos	34	43	36	50
8	Diagoras	34	43	42	48
9	Ilioupoli	34	33	35	46
10	Agrotikos	34	36	31	45
11	Ethnikos	34	39	37	45
12	Anagennisi	34	29	28	44
13	Thrasyvoulos	34	42	42	41
14	Doxa Dramas	34	37	49	40
15	Ionikos	34	32	45	39
16	Rodos	34	31	46	34
17	Kalamata FC	34	21	49	28
18	Aigaleo	34	19	55	21

TEMPORADA 2008/2009

FOOTBALL LEAGUE GRECIA
Equipo		PJ	GF	GC	Puntos
1	Atromitos	34	54	30	74
2	Giannina	34	70	36	69
3	Kavala	34	56	28	65
4	Ionikos	34	43	37	55
5	Kerkyra	34	45	40	51
6	Ilysiakos	34	42	40	46
7	Agrotikos	34	39	39	45
8	Diagoras	34	46	38	44
9	Kalamata FC	34	33	43	43
10	Pierikos	34	33	43	42
11	Ethnikos	34	42	40	41
12	Olympiakos	34	32	36	41
13	Apollon	34	34	45	41
14	Ethnikos	34	42	41	40
15	Anagennisi	34	30	43	39
16	Veria NPS	34	27	36	38
17	Athens	34	25	43	34
18	Kastoria	34	28	63	18

TEMPORADA 2007/2008

FOOTBALL LEAGUE GRECIA
Equipo		PJ	GF	GC	Puntos
1	Panserraikos	34	48	20	67
2	Thrasyvoulos	34	44	27	61
3	Panthrakikos	34	44	31	60
4	Giannina	34	54	38	57
5	Ionikos	34	37	28	54
6	Athens	34	40	35	52
7	Kerkyra	34	39	33	50
8	Agrotikos	34	44	47	47
9	Ethnikos	34	32	36	45
10	Ilysiakos	34	31	38	43
11	Kalamata FC	34	30	33	42
12	Ethnikos	34	32	37	41
13	Pierikos	34	28	33	41
14	Olympiakos	34	33	38	39
15	Aigaleo	34	28	34	39
16	Kastoria	34	26	41	39
17	Chaidari	34	30	31	38
18	Agios	34	22	62	14

TEMPORADA 2006/2007

SUPER LEAGUE GRIEGA
Equipo		PJ	GF	GC	Puntos
1	Olympiacos	30	62	23	71
2	AEK Athens	30	60	27	62
3	Panathinaiko	30	47	28	54
4	Aris	30	32	26	46
5	Panionios	30	33	31	45
6	PAOK	30	32	29	45
7	OFI	30	41	45	42
8	Atromitos	30	40	44	40
9	Ergotelis	30	30	32	39
10	AE Larisa	30	30	38	36
11	Xanthi	30	24	22	36
12	Apollon	30	27	36	35
13	Kerkyra	30	34	36	35
14	Iraklis	30	24	36	33
15	Aigaleo	30	27	45	28
16	Ionikos	30	16	61	5

TEMPORADA 2005/2006

FOOTBALL LEAGUE GRECIA
Equipo		PJ	GF	GC	Puntos
1	Ergotelis	30	41	23	56
2	Kerkyra	30	38	26	56
3	Aris	30	33	17	54
4	Thrasyvoulos	30	40	25	53
5	Veria NPS	30	28	27	41
6	Ilysiakos	30	43	35	40
7	Kastoria	30	28	28	40
8	Kalamata FC	30	26	28	39
9	Niki Volos	30	32	31	38
10	Proodeftiki	30	31	34	38
11	Ethnikos	30	36	40	38
12	Chaidari	30	27	27	37
13	Olympiakos	30	30	37	37
14	Panserraikos	30	28	37	37
15	Panachaiki	30	24	29	34
16	Paniliakos	30	16	57	9

TEMPORADA 2004/2005

SUPER LEAGUE GRIEGA
Equipo		PJ	GF	GC	Puntos
1	Olympiacos	30	54	18	65
2	Panathinaiko	30	51	18	64
3	AEK Athens	30	46	22	62
4	Xanthi	30	43	29	50
5	PAOK	30	43	39	46
6	Aigaleo	30	31	26	45
7	Iraklis	30	36	30	41
8	Halkidona	30	34	38	38
9	Athens	30	39	44	37
10	Ionikos	30	22	32	36
11	Panionios	30	25	32	35
12	Apollon	30	31	49	33
13	OFI	30	36	44	32
14	Aris	30	26	37	25
15	Ergotelis	30	19	50	20
16	Kerkyra	30	21	49	17

TEMPORADA 2003/2004

FOOTBALL LEAGUE GRECIA
Equipo		PJ	GF	GC	Puntos
1	Kerkyra	30	42	13	67
2	Apollon	30	53	27	58
3	Ergotelis	30	39	24	55
4	Kassandra	30	37	23	53
5	Poseidon	30	42	23	52
6	Niki Volos	30	31	18	49
7	Ethnikos	30	35	28	45
8	Levadiakos	30	30	31	43
9	Apollon	30	36	37	41
10	Kalamata FC	30	26	27	41
11	Patraikos	30	28	25	40
12	Panserraikos	30	31	31	40
13	Atromitos	30	33	45	37
14	Giannina	30	26	31	31
15	Fostiras	30	2	55	5
16	Panachaiki	30	1	54	3

TEMPORADA 2002/2003

FOOTBALL LEAGUE GRECIA
Equipo		PJ	GF	GC	Puntos
1	Halkidona	30	61	20	65
2	Paniliakos	30	43	25	60
3	Apollon	30	38	19	59
4	Fostiras	30	34	27	45
5	Kerkyra	30	31	23	44
6	Ethnikos	30	36	32	44
7	Kalamata FC	30	29	22	40
8	Apollon	30	40	43	39
9	Atromitos	30	30	33	37
10	Patraikos	30	28	32	36
11	Panserraikos	30	33	41	36
12	Panegialios	30	31	42	34
13	Athinaikos	30	30	41	34
14	Kassandra	30	27	36	33
15	Olympiakos	30	25	43	31
16	Kavala	30	21	58	16

TEMPORADA 2001/2002

TERCERA GRECIA
Equipo		PJ	GF	GC	Puntos
1	Kerkyra	30	44	17	63
2	Kassandra	29	42	18	62
3	Fostiras	30	51	28	59
4	Kavala	29	49	21	54
5	Atromitos	30	44	29	51
6	Kilkisiakos	30	35	27	47
7	Apollon	30	37	34	42
8	Ethnikos	30	38	41	41
9	Marko	30	37	41	41
10	Chania	30	35	37	40
11	Panelefsinia	30	24	43	32
12	Leonidio	30	25	35	28
13	Trikala	30	17	32	28
14	Nafpaktiakos	30	24	37	26
15	Panaitolikos	30	24	46	25
16	Apollon K.V.	30	14	54	14

Competiciones que juega

Football League Grecia

Pos	Equipos		Pts
1		AE Larisa	78
2		Kerkyra	75
3		Trikala	67
4		Apollon Smyrnis	61
5		Lamia	59
6		Chania	51
7		Athens Kallithea	49
8		Acharnaikos	45
9		Anagennisi Karditsas	45
10		Panserraikos FC	43
11		Agrotikos Asteras	43
12		Chania	41
13		Panegialios	41
14		Panelefsiniakos	35
15		Zakynthos	34
16		Panachaiki	28
17		Olympiakos Volos	10
18		Ergotelis	7

RIVALES EN Copa Griega

RIVALES EN Football League.

USO DE MEMORIA

6,956,944 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1580
Total Execution Time	0.1592

CADENA URL

/historico/Kerkyra/2016

GET DATOS

$_GET['/historico/Kerkyra/2016']

POST DATOS

No hay datos POST existentes

CONSULTAS (45)

0.0031	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 = 'Kerkyra' AND l.year = 2016 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.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=10044 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=10044 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=10044 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=10044 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040	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 = 15462
0.0024	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 = 18602
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10044 AND type_rel = 2
0.0020	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 10044 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021	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 (1685,100037) ORDER BY n.cover_points DESC, update_date DESC
0.0027	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 = '10044' ORDER BY l.year DESC,cat.coefficient DESC
0.0024	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 = '10044' AND l.year = 2016 ORDER BY l.year DESC,cat.coefficient DESC
0.0024	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 = '10044' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024	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 = '10044' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 18602 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 = 15462 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024	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=10044 AND l.year in (2015,2016,2017) ORDER BY l.id DESC, l.year DESC ;
0.0021	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 (36011,33417,30386,15462) 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.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 33417 AND teamId = 10044
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 15462 AND teamId = 10044
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 36011 AND teamId = 10044
0.0099	SELECT count(id) as num_players from rel_players WHERE league_id = 30386 AND teamId = 10044
0.0020	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 = '10044' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '10044' and rp.type = 4
0.0022	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 = '10044' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0044	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 events2016 e ON e.player_id = p.id AND e.league_id = 15462 WHERE rp.league_id = 15462 AND rp.teamId = 10044 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.0037	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 events2016 e ON e.player_id = p.id AND e.league_id = 15462 WHERE rp.league_id = 15462 AND rp.teamId = 10044 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029	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 events2016 e ON e.player_id = p.id AND e.league_id = 15462 WHERE rp.league_id = 15462 AND rp.teamId = 10044 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027	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 = 10044 AND l.year <= 2016 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 15462 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* `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.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* `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 = 3487 AND t.round = 26 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* `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 = 13420 AND t.round = 14 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.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* `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.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* `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.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* `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 = 13404 AND t.round = 34 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* `tables2009` 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 = 13403 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029	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* `tables2008` 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 = 13402 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* `tables2007` 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 = 397 AND t.round = 30 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* `tables2006` 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 = 13400 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* `tables2005` 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 = 399 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* `tables2004` 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 = 13398 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* `tables2003` 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 = 13397 AND t.round = 30 ORDER BY team.conference 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* `tables2002` 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 = 24859 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Kerkyra

Kerkyra

Selecciona un equipo

Competiciones que juega

Football League Grecia

RIVALES EN Copa Griega

RIVALES EN Football League.