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

« Temporada Anterior

Temporada 2016

Temporada Siguiente »

2015/2016

Temporada Regular

Eliminatoria

Liga Chipre 2016 G 1

Ver

TEMPORADA 2015/2016

Equipo		PJ	GF	GC	Puntos
1	APOEL	26	72	18	62
2	AEK Larnaca	26	47	17	61
3	Anorthosis	26	48	22	52
4	Omonia	26	46	24	49
5	Apollon	26	41	24	49
6	Nea Salamis	26	37	52	33
7	Aris	26	29	31	31
8	Limassol	26	22	32	31
9	Doxa	26	31	41	30
10	Pafos	26	35	47	27
11	Ethnikos	26	27	43	24
12	Ermis	26	22	40	24
13	Enosis Neon	26	28	47	20
14	Ayia Napa	26	17	64	6

Ver

TEMPORADA 2014/2015

Equipo		PJ	GF	GC	Puntos
1	Apollon	22	49	26	48
2	APOEL	22	34	13	46
3	AEK Larnaca	22	41	23	39
4	Omonia	22	32	22	39
5	Anorthosis	22	32	22	38
6	Ermis	22	29	28	35
7	Limassol	22	33	26	30
8	Ethnikos	22	18	37	22
9	Nea Salamis	22	16	29	19
10	Othellos	22	13	26	16
11	Ayia Napa	22	21	42	16
12	Doxa	22	14	38	14

Ver

TEMPORADA 2013/2014

Equipo		PJ	GF	GC	Puntos
1	Limassol	26	48	16	62
2	Apollon	26	47	19	59
3	APOEL	26	56	18	59
4	Ermis	26	44	28	52
5	Omonia	26	45	22	47
6	Anorthosis	26	46	36	38
7	Nea Salamis	26	26	31	38
8	AEK Larnaca	26	37	28	37
9	Doxa	26	33	45	28
10	Ethnikos	26	27	38	23
11	Enosis Neon	26	29	45	22
12	AEK Kouklia	26	27	64	21
13	Aris	26	29	40	20
14	Alki	26	14	78	2

Ver

TEMPORADA 2012/2013

Equipo		PJ	GF	GC	Puntos
1	APOEL	26	56	10	66
2	Anorthosis	26	57	21	60
3	AEK Larnaca	26	50	21	55
4	Omonia	26	51	22	53
5	Limassol	26	46	26	51
6	Apollon	26	32	24	40
7	Doxa	26	26	40	30
8	Enosis Neon	26	23	35	28
9	Alki	26	33	46	25
10	Olympiakos	26	36	44	24
11	Nea Salamis	26	18	36	23
12	Ethnikos	26	28	40	22
13	Ayia Napa	26	15	59	8
14	Pafos	26	17	64	6

Ver

TEMPORADA 2011/2012

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

Ver

TEMPORADA 2010/2011

Equipo		PJ	GF	GC	Puntos
1	APOEL	26	55	19	62
2	Omonia	26	38	16	50
3	Anorthosis	26	46	31	45
4	AEK Larnaca	26	36	30	42
5	Apollon	26	40	37	38
6	Enosis Neon	26	26	25	36
7	Olympiakos	26	41	41	36
8	Ethnikos	26	25	27	33
9	Limassol	26	28	35	33
10	Ermis	26	31	38	30
11	Alki	26	30	40	29
12	Pafos	26	33	37	26
13	Doxa	26	25	55	20
14	APOP Kinyras	26	24	47	19

Ver

TEMPORADA 2009/2010

Equipo		PJ	GF	GC	Puntos
1	Omonia	26	52	21	62
2	Anorthosis	26	45	20	58
3	Apollon	26	43	15	57
4	APOEL	26	44	18	55
5	Limassol	26	32	22	45
6	APOP Kinyras	26	40	44	34
7	Ermis	26	31	34	29
8	Enosis Neon	26	29	35	29
9	Ethnikos	26	21	32	29
10	Doxa	26	25	37	26
11	Pafos	26	27	40	26
12	Aris	26	26	47	20
13	Nea Salamis	26	19	43	14
14	APEP	26	26	52	11

Ver

TEMPORADA 2008/2009

Equipo		PJ	GF	GC	Puntos
1	APOEL	26	53	14	69
2	Omonia	26	61	18	64
3	Anorthosis	26	49	19	62
4	Apollon	26	53	34	43
5	Limassol	26	34	30	43
6	Ethnikos	26	34	32	40
7	APOP Kinyras	26	35	35	40
8	Doxa	26	37	39	31
9	Pafos	26	30	38	27
10	Enosis Neon	26	23	43	25
11	APEP	26	28	44	23
12	Alki	26	27	50	19
13	AEK Larnaca	26	27	45	15
14	Atromitos	26	19	69	7

Ver

TEMPORADA 2007/2008

Equipo		PJ	GF	GC	Puntos
1	Anorthosis	26	49	13	64
2	APOEL	26	51	19	53
3	Omonia	26	36	22	48
4	AEK Larnaca	26	34	32	41
5	Apollon	26	40	33	39
6	APOP Kinyras	26	35	35	37
7	Enosis Neon	26	28	30	36
8	Ethnikos	26	34	35	34
9	Doxa	26	38	40	34
10	Alki	26	32	40	27
11	Limassol	26	28	38	27
12	Aris	26	24	35	27
13	Nea Salamis	26	28	54	24
14	Olympiakos	26	23	54	14

Ver

TEMPORADA 2006/2007

Equipo		PJ	GF	GC	Puntos
1	APOEL	26	59	22	64
2	Omonia	26	62	22	57
3	Anorthosis	26	42	20	53
4	Ethnikos	26	38	33	37
5	Enosis Neon	26	31	27	35
6	Apollon	26	35	36	35
7	AEK Larnaca	26	33	32	34
8	Aris	26	39	58	32
9	Nea Salamis	26	32	41	30
10	Limassol	26	31	42	30
11	Olympiakos	26	24	36	28
12	Digenis	26	23	41	25
13	Ayia Napa	26	26	41	20
14	Pafos	26	21	45	18

Ver

TEMPORADA 2005/2006

Equipo		PJ	GF	GC	Puntos
1	Apollon	26	68	24	64
2	Omonia	26	59	20	63
3	APOEL	26	63	22	62
4	Anorthosis	26	55	26	53
5	Enosis Neon	26	40	28	43
6	Nea Salamis	26	53	48	41
7	Limassol	26	44	48	35
8	AEK Larnaca	26	37	36	31
9	Ethnikos	26	42	43	28
10	Digenis	26	32	45	28
11	Olympiakos	26	40	49	27
12	APOP Kinyras	26	35	65	18
13	APEP	26	17	72	8
14	THOI	26	14	73	7

Ver

TEMPORADA 2004/2005

Equipo		PJ	GF	GC	Puntos
1	Anorthosis	25	64	23	62
2	APOEL	26	56	21	58
3	Omonia	26	47	29	47
4	Olympiakos	26	36	38	39
5	Digenis	26	36	31	36
6	Nea Salamis	26	36	40	36
7	Apollon	25	43	35	35
8	Enosis Neon	26	38	39	32
9	AEK Larnaca	26	26	34	32
10	Limassol	26	36	38	31
11	Ethnikos	26	31	40	30
12	Pafos	26	38	52	29
13	Alki	26	39	55	29
14	Aris	26	22	73	4

Ver

TEMPORADA 2003/2004

Equipo		PJ	GF	GC	Puntos
1	APOEL	26	56	20	65
2	Omonia	26	68	29	62
3	Apollon	26	50	23	49
4	Limassol	26	52	26	49
5	Anorthosis	26	57	35	48
6	Ethnikos	26	51	37	38
7	Pafos	26	41	36	38
8	Enosis Neon	26	40	36	36
9	AEK Larnaca	26	50	52	32
10	Olympiakos	26	45	44	31
11	Digenis	26	27	38	28
12	Anagennisi	26	17	44	18
13	Onisilos	26	22	63	13
14	Doxa	26	18	111	7

Ver

TEMPORADA 2002/2003

Equipo		PJ	GF	GC	Puntos
1	Anorthosis	26	65	30	59
2	Omonia	25	66	21	57
3	APOEL	26	55	24	55
4	Olympiakos	25	55	29	49
5	Limassol	26	56	45	39
6	Ethnikos	26	35	32	37
7	Pafos	26	38	45	37
8	AEK Larnaca	26	43	50	32
9	Digenis	26	40	40	31
10	Enosis Neon	25	39	39	31
11	Apollon	26	42	46	31
12	Nea Salamis	25	38	38	29
13	Aris	26	31	92	9
14	Alki	26	21	93	6

Ver

TEMPORADA 2001/2002

Equipo		PJ	GF	GC	Puntos
1	APOEL	26	66	22	59
2	Anorthosis	26	71	31	58
3	Limassol	26	47	27	54
4	Omonia	25	55	33	53
5	Olympiakos	26	53	45	42
6	AEK Larnaca	26	56	42	41
7	Ethnikos	25	44	37	39
8	Enosis Neon	26	42	38	39
9	Apollon	26	56	48	36
10	Pafos	26	54	46	36
11	Alki	26	37	37	31
12	Ethnikos	26	40	70	18
13	Doxa	26	30	84	9
14	Ermis	26	16	107	1

Ver

TEMPORADA 2000/2001

Equipo		PJ	GF	GC	Puntos
1	Omonia	26	60	27	57
2	Olympiakos	26	58	30	54
3	Limassol	26	48	28	52
4	Anorthosis	26	60	32	51
5	APOEL	26	58	37	44
6	Apollon	26	56	40	44
7	AEK Larnaca	26	52	47	36
8	Pafos	26	45	53	33
9	Enosis Neon	26	42	53	30
10	Doxa	26	26	37	29
11	Ethnikos	26	44	49	28
12	Nea Salamis	26	41	47	27
13	Digenis	26	28	78	11
14	Aris	26	28	88	4

Ver

TEMPORADA 1999/2000

Equipo		PJ	GF	GC	Puntos
1	Anorthosis	26	82	28	65
2	Omonia	26	71	27	59
3	APOEL	26	58	31	46
4	Nea Salamis	26	58	34	43
5	Apollon	26	49	44	42
6	Limassol	26	45	42	42
7	AEK Larnaca	26	42	38	41
8	Enosis Neon	26	50	50	36
9	Olympiakos	26	57	58	36
10	Ethnikos	26	42	36	35
11	APOP Paphos	26	38	47	32
12	Ethnikos	26	35	38	31
13	Anagennisi	26	22	87	12
14	Alki	26	20	109	3

Ver

TEMPORADA 1998/1999

Equipo		PJ	GF	GC	Puntos
1	Anorthosis	26	95	28	67
2	Omonia	26	81	25	67
3	APOEL	26	70	29	59
4	AEK Larnaca	26	63	45	45
5	Limassol	26	55	39	44
6	Ethnikos	26	49	43	42
7	Apollon	26	51	45	41
8	Enosis Neon	26	55	64	32
9	Olympiakos	26	40	49	29
10	Nea Salamis	26	46	53	28
11	Alki	26	37	70	25
12	Evaghoras	26	30	66	22
13	Doxa	26	27	79	9
14	Aris	26	32	96	9

Ver

TEMPORADA 1997/1998

Equipo		PJ	GF	GC	Puntos
1	Anorthosis	26	87	18	66
2	Omonia	26	90	20	62
3	Apollon	26	50	25	55
4	Ethnikos	26	35	28	47
5	AEK Larnaca	26	42	40	34
6	Enosis Neon	26	45	49	33
7	APOEL	26	48	51	31
8	Nea Salamis	26	43	59	31
9	Limassol	26	37	50	29
10	Alki	26	46	65	29
11	Evaghoras	26	29	52	29
12	Anagenisis	26	37	65	27
13	APOP Paphos	26	40	59	26
14	Ethnikos	26	28	76	12

Ver

TEMPORADA 1996/1997

Equipo		PJ	GF	GC	Puntos
1	Anorthosis	26	58	14	65
2	Apollon	26	43	22	52
3	Omonia	26	40	31	46
4	AEK Larnaca	26	49	37	41
5	APOEL	26	57	43	40
6	Ethnikos	26	48	36	37
7	Enosis Neon	26	48	48	35
8	Nea Salamis	26	43	37	34
9	Anagenisis	26	27	42	32
10	APOP Paphos	26	29	44	31
11	Alki	26	41	49	30
12	Aris	26	33	41	28
13	Olympiakos	26	28	47	27
14	APEP	26	22	75	11

JUGADORES DESTACADOS

Nombre	Goles	Equipo
F. Cavenaghi	19	APO
D. Ndlovu	16	ANO
A. Alves	15	AEK
D. Makriev	14	NEA
T. De Vincenti	13	APO
A. Schembri	11	OMO
C. Sheridan	10	OMO
N. Maachi	10	PAP
G. Efrem	9	APO
A. Keita	8	ERM

Equipos de esta liga

USO DE MEMORIA

7,204,232 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.2236
Total Execution Time	0.2256

CADENA URL

/1_division_chipre2016/grupo1/historico

GET DATOS

$_GET['/1_division_chipre2016/grupo1/historico']

POST DATOS

No hay datos POST existentes

CONSULTAS (35)

0.0017	SELECT type FROM routes WHERE alias = '1_division_chipre2016'
0.0039	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = '1_division_chipre' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2016 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=187 AND type_rel = 3
0.0026	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.0024	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.0021	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 = 15731 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024	SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 187 AND group_code = 1 and tables = 1 AND year <= 2016 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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* `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 = 15731 AND t.round = 26 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* `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 = 4166 AND t.round = 22 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* `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 = 2769 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033	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.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* `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
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* `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 = 8735 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032	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 = 8733 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034	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 = 8732 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033	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 = 8731 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033	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 = 8730 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039	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 = 8727 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* `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 = 8726 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035	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 = 8723 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033	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 = 8722 AND t.round = 26 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* `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 = 8721 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032	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* `tables2001` 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 = 8718 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036	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* `tables2000` 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 = 8713 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030	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* `tables1999` 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 = 8704 AND t.round = 26 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* `tables1998` 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 = 8712 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 url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 14:42:53' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 14:42:53' 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=4 AND last_update > '2024-04-27 14:42:53' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 14:42:53' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = '1_division_chipre' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2016 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0300	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 events2016 e ON e.player_id = p.id AND e.league_id = 15731 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 15731 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.0472	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 events2016 e ON e.player_id = p.id AND e.league_id = 15731 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 15731 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0051	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 events2016 e ON e.player_id = p.id AND e.league_id = 15731 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 15731 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0052	SELECT ,(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 = 15731 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Nombre	Amarillas	Equipo
E. A. Fusco	11	AYI
A. Iacob	10	ETH
Thomas Präger	10	ETH
G. Skopelitis	10	NEA
Marco Airosa	9	AEL
Cristóvão	9	OMO
Ulysse Ndong	9	ERM
G. Efstathiou	9	ARI
M. Maragoudakis	8	ARI
G. Ogungbe	8	ETH

Nombre	Rojas	Equipo
N. Skopljak	2	AYI
S. Dimitriou	2	DOX
Ulysse Ndong	2	ERM
E. A. Fusco	2	NEA
V. Laban	2	AEK
David Català	2	AEK
Rasheed Alabi	2	PAP
V. Sielis	2	AEL
E. Sachetti	2	APO
R. Nuhu	2	ANO


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