Has elegido rechazar las cookies basadas en consentimiento que utilizamos principalmente para gestionar la publicidad y las recomendaciones de contenido.

En adelante, para aceder a nuestra web tienes que elegir alguna de las siguientes opciones.

Has cambiado de idea y quieres
NAVEGAR GRATIS Y CON PUBLICIDAD...

Navega por besoccer.com y resultados-futbol.com con publicidad personalizada, seguimiento y cookies de forma gratuita.

Optar por esta opción te permitirá mantener tu experiencia de navegación como hasta ahora. Al aceptar las cookies y tecnologías similares, estás dando tu consentimiento para que recopilemos y utilicemos tu información de navegación con el propósito de adaptar la publicidad y la personalización según tus intereses. La presencia de esta publicidad es crucial para continuar proporcionando contenido de calidad, sevicios eficientes a los usuarios y mejorar la experiencia general de uso.

Nosotros y nuestros socios hacemos el siguiente tratamiento de datos: almacenamiento y acceso a información de geolocalización con propósitos de publicidad dirigida, almacenamiento y acceso a información de geolocalización para realizar estudios de mercado, almacenar o acceder a información en un dispositivo, analizar activamente las características del dispositivo para su identificación, compartir tus análisis de navegación y grupos de interés con terceros, crear un perfil para la personalización de contenidos, crear un perfil publicitario personalizado, desarrollar y mejorar productos, enriquecer el perfil con información de terceros, medir el rendimiento de los anuncios, medir el rendimiento del contenido, seleccionar anuncios básicos, seleccionar anuncios personalizados, seleccionar contenido personalizado, utilizar datos de localización geográfica precisa, utilizar estudios de mercado a fin de generar información sobre el público.

Aceptar y continuar gratis

...O sigues prefiriendo rechazar las cookies y entonces
CONTINÚA REGISTRÁNDOTE Y SUSCRIBIÉNDOTE

Navega por besoccer.com y resultados-futbol.com sin publicidad ni seguimiento suscribiéndote a nuestra web por 0,50 € al día.

Además de abonar la suscripción, es necesario realizar un registro previo para acceder. El mismo perfil de usuario es compartido entre los sitios besoccer.com y resultados-futbol.com

Accede por 0,50 € al día

Para saber más, consulta nuestra Política de Cookies.

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

CE Escolar

Temporada 2023/2024

TEMPORADA 2023/2024

1ª REGIONAL BALEARES GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Unión	24	60	28	52
2	S´Horta	23	48	27	45
3	Atlètic	23	60	53	40
4	Porto Cristo	24	53	35	39
5	Arta	24	34	25	36
6	Pollença	24	47	39	36
7	Baleares	24	44	37	35
8	Ce Campanet	24	37	46	34
9	Binissalem	23	28	29	33
10	CD Génova	24	36	39	29
11	CE Escolar	23	26	39	28
12	S'arraco	24	25	51	26
13	Vilafranca	23	32	35	24
14	Col. Pedro	24	33	46	24
15	Athlàtic	23	33	52	20
16	Sporting	24	39	54	16

TEMPORADA 2022/2023

1ª REGIONAL BALEARES GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Santa	30	73	20	77
2	Andratx B	30	78	28	67
3	Athetic Club	30	59	40	54
4	CE Escolar	30	63	43	53
5	Consell	30	54	34	52
6	Unión	30	57	41	52
7	Unió	30	50	39	43
8	Athlàtic	30	50	46	42
9	Baleares	30	49	41	40
10	Margaritense	30	52	56	37
11	Port Soller	30	35	46	36
12	Picafort	30	41	58	36
13	Pilares	30	43	64	31
14	Binissalem	30	36	73	28
15	San Roque	30	37	65	18
16	Taujá	30	18	101	3

TEMPORADA 2021/2022

1ª REGIONAL BALEARES
Equipo		PJ	GF	GC	Puntos
1	Algaida	38	89	33	80
2	UD Arenal	38	63	24	76
3	S´Horta	37	80	41	72
4	Portol	38	75	35	69
5	Atletico	37	55	34	65
6	Indep. Camp	38	86	52	62
7	Espanya	38	54	39	62
8	Cala Millor	38	72	56	61
9	Pollença	38	64	70	58
10	Unión	38	56	48	54
11	Platges	38	65	70	51
12	Athlàtic	38	60	68	50
13	Montaura	38	54	69	49
14	Santa María	38	39	57	45
15	Ce Campanet	38	55	74	45
16	CE Escolar	38	42	68	40
17	A-Llubi	38	44	74	37
18	Constancia	38	48	89	33
19	Picafort	38	36	77	28
20	Porto Cristo	38	39	98	24

TEMPORADA 2020/2021

2ª REGIONAL BALEARES GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	CE Escolar	19	50	21	44
2	Ponsa	19	44	23	37
3	Andratx B	19	30	16	35
4	Santa	19	34	27	34
5	Soller B	19	29	30	25
6	Taujá	19	23	34	25
7	Establiments	19	26	34	22
8	Bunyola	19	29	30	21
9	Binissalem	19	23	31	20
10	Valldemossa	19	24	39	17
11	Poblense B	20	20	47	12

TEMPORADA 2019/2020

2ª REGIONAL BALEARES
Equipo		PJ	GF	GC	Puntos
1	Arta	27	78	28	68
2	Constancia	28	58	31	56
3	Baleares	27	60	32	51
4	Portol	26	69	44	50
5	Bunyola	27	65	40	49
6	Santa Ponsa	27	61	39	45
7	CE Escolar	26	60	46	44
8	Pilares	27	51	46	39
9	Athetic Club	26	34	40	32
10	Llosetense	26	57	64	32
11	Collerense	26	52	69	31
12	Taujá	25	42	48	29
13	Valldemossa	26	44	65	29
14	Soller B	25	46	59	28
15	Binissalem	27	29	62	28
16	UE Lloret	27	43	56	26
17	Cayetano	26	42	67	25
18	Poblense B	26	29	47	24
19	Picafort	26	31	52	23
20	Establiments	25	44	60	17

TEMPORADA 2018/2019

2ª REGIONAL BALEARES
Equipo		PJ	GF	GC	Puntos
1	Santa	38	100	43	90
2	Calvia	38	88	34	82
3	Vilafranca	38	108	58	80
4	Serralta	38	99	57	71
5	Alqueria	37	78	58	63
6	Athetic Club	38	80	50	62
7	UE Lloret	37	66	50	59
8	Binissalem	37	65	53	58
9	Establiments	38	65	57	57
10	CE Escolar	38	64	69	49
11	Constancia	38	62	58	47
12	Portol	38	62	71	45
13	Soller B	38	68	83	43
14	Pilares	38	67	85	42
15	Picafort	38	51	76	42
16	Poblense B	38	38	72	39
17	Valldemossa	38	57	86	36
18	Margaritense	38	44	70	35
19	Palmanyola	38	41	102	27
20	Porto Cristo	37	37	108	18

TEMPORADA 2017/2018

2ª REGIONAL BALEARES
Equipo		PJ	GF	GC	Puntos
1	Porreres	38	108	28	92
2	Algaida	38	105	46	91
3	Santa	38	97	40	78
4	Vilafranca	37	90	57	74
5	CE Escolar	38	88	56	73
6	Athetic Club	37	80	57	69
7	Alqueria	38	65	57	62
8	Constancia	38	77	64	58
9	Serralta	37	72	87	49
10	Soller B	38	59	62	49
11	Margaritense	38	54	65	48
12	Porto Cristo	37	62	76	47
13	UE Lloret	38	68	85	43
14	Calvia	37	57	69	42
15	Atlético	38	66	96	40
16	Santanyi DS	38	46	78	37
17	Portol	38	49	77	36
18	Pilares	38	56	113	35
19	Cayetano	37	47	79	33
20	Atlético	38	50	104	20

TEMPORADA 2016/2017

1ª REGIONAL BALEARES
Equipo		PJ	GF	GC	Puntos
1	Inter	40	104	38	95
2	Sant Jordi	40	96	43	84
3	Son Veri	39	112	63	76
4	Llosetense	40	91	56	75
5	Sporting	40	79	66	70
6	Tesa	40	74	66	70
7	Establiments	40	75	57	65
8	Pollença	40	78	85	55
9	Binissalem	40	65	79	55
10	Cala Millor	40	75	82	53
11	Juventud	40	79	71	50
12	S´Horta	40	69	73	49
13	UD Arenal	40	58	65	49
14	Espanya	40	76	85	49
15	Son Sardina	40	73	81	46
16	Bunyola	39	57	76	46
17	Santa Ponsa	40	78	107	46
18	Consell	40	63	84	43
19	Valldemossa	40	60	86	41
20	CE Escolar	40	70	99	39
21	Pilares	40	61	131	33

TEMPORADA 2015/2016

1ª REGIONAL BALEARES
Equipo		PJ	GF	GC	Puntos
1	Indep. Camp	36	97	46	83
2	CE Xilvar	38	80	54	76
3	Son Sardina	38	76	52	71
4	Sant Jordi	38	58	35	71
5	Juventud	37	82	51	65
6	Sporting	38	81	61	65
7	Inter	38	74	57	64
8	Binissalem	38	51	55	58
9	Tesa	38	80	76	54
10	Pilares	36	81	83	49
11	Santa Ponsa	37	63	61	49
12	Valldemossa	38	63	71	46
13	S´Horta	38	65	66	45
14	Cala Millor	38	72	93	43
15	CE Escolar	38	46	59	42
16	Consell	38	43	57	41
17	Llosetense	38	53	69	41
18	UE Lloret	38	53	78	38
19	Arta	38	47	97	35
20	Pina	38	56	100	32

TEMPORADA 2014/2015

PREFERENTE BALEARES GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Santa	38	81	39	83
2	Rotlet	38	85	40	82
3	Cardassar	38	78	36	76
4	Esporles	38	60	33	73
5	Santanyi	38	68	46	63
6	Andratx	38	61	43	63
7	Ce Campanet	38	57	49	63
8	Santa	38	60	50	62
9	Recreativo	38	65	63	56
10	CD Génova	38	61	53	55
11	UE Petra	38	52	49	52
12	Serverense	38	59	71	44
13	Murense	38	49	69	42
14	CD España	38	47	70	40
15	Felanitx	38	54	73	37
16	Port Soller	38	41	73	37
17	S´Horta	38	48	66	36
18	Unión	38	50	79	36
19	Indep. Camp	38	42	76	33
20	CE Escolar	38	48	88	30

TEMPORADA 2013/2014

PREFERENTE BALEARES GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Soller	38	92	39	85
2	Santa	38	81	31	82
3	UD Alaró	38	50	30	67
4	Cardassar	38	64	53	64
5	Indep. Camp	38	77	47	62
6	Cladera	38	67	61	60
7	Esporles	38	44	36	59
8	Andratx	38	62	44	59
9	Ce Campanet	38	65	55	58
10	Serverense	38	74	64	53
11	CD Génova	38	59	58	52
12	CD España	38	56	62	51
13	S´Horta	38	71	81	51
14	Port Soller	38	48	67	47
15	CE Escolar	38	57	64	46
16	Unión	38	57	75	44
17	Murense	38	38	66	35
18	UD Arenal	38	44	74	31
19	Binissalem	38	40	86	28
20	Son Ferrer	38	37	90	27

TEMPORADA 2012/2013

PREFERENTE BALEARES GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Rotlet	38	74	45	71
2	Platges	38	65	30	68
3	Atletico	38	71	55	68
4	Santa	38	63	46	61
5	Independient	38	59	57	60
6	Cd Génova	38	60	46	58
7	Serverense	38	67	58	55
8	Unión	38	63	53	53
9	Cd S´horta	38	53	68	52
10	UD Alaró	38	54	63	51
11	Ce Campanet	38	57	62	50
12	UD Arenal	38	57	58	49
13	CE Escolar	38	49	49	48
14	Cd Murense	38	58	72	48
15	Cardassar	38	52	66	48
16	Ce Esporles	38	67	66	47
17	Tesa	38	65	79	44
18	CE Xilvar	38	43	61	43
19	Sporting	38	57	78	38
20	Pollença	38	42	64	35

TEMPORADA 1987/1988

TERCERA DIVISIÓN GRUPO 11
Equipo		PJ	GF	GC	Puntos
1	Santa Ponsa	38	60	40	55
2	SD Ibiza	38	71	25	55
3	Manacor	38	66	42	51
4	Mallorca B	38	82	43	46
5	CE Alaior	38	62	36	44
6	Peña	38	47	29	44
7	Ferreries	38	44	32	43
8	Murense	38	52	45	39
9	Soller	38	46	38	38
10	CD Isleño	38	46	49	35
11	Platges	38	36	49	35
12	UD Alaró	38	45	58	35
13	Paguera	38	46	52	32
14	SD Portmany	38	36	49	32
15	UE Alcudia	38	30	52	32
16	Llosetense	38	40	55	32
17	Hospitalet	38	40	55	32
18	Santanyi	38	40	61	31
19	Andratx	38	36	85	25
20	CE Escolar	38	42	72	24

TEMPORADA 1986/1987

TERCERA DIVISIÓN GRUPO 11
Equipo		PJ	GF	GC	Puntos
1	Mahonès	38	87	27	59
2	Atlético	38	70	45	50
3	Serverense	38	55	31	49
4	Constància	38	70	36	48
5	Peña	38	64	35	48
6	SD Portmany	38	59	46	43
7	CE Alaior	38	57	47	40
8	Manacor	38	66	69	39
9	UD Alaró	38	59	68	39
10	Ferreries	38	44	42	39
11	SD Ibiza	38	44	45	37
12	Murense	38	50	62	34
13	Hospitalet	38	38	48	33
14	Santanyi	38	34	59	33
15	Platges	38	42	51	31
16	CE Escolar	38	47	73	30
17	Son Sardina	38	29	44	29
18	Montuiri	38	36	59	29
19	Soller	38	39	74	27
20	CD Isleño	38	32	61	23

TEMPORADA 1961/1962

TERCERA DIVISIÓN GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Constància	20	61	12	32
2	SD Ibiza	20	52	17	31
3	Manacor	20	48	23	29
4	Soledad	20	40	24	21
5	Juventud	20	37	36	20
6	CE Escolar	20	29	46	18
7	UD Alaró	20	26	38	17
8	Felanitx	20	28	40	16
9	Poblense	20	20	50	13
10	Pollença	20	24	52	12
11	Andratx	20	22	49	11

Competiciones que juega

Grupo 1

1ª Regional Baleares Grupo 1

Pos	Equipos		Pts
1		La Unión CF	52
2		S´Horta	45
3		Atlètic Sencelles	40
4		Porto Cristo	39
5		Arta	36
6		CF Pollença	36
7		Baleares Sin Fronteras	35
8		Ce Campanet	34
9		CD Binissalem B	33
10		CD Génova	29
11		CE Escolar	28
12		S'arraco	26
13		Vilafranca	24
14		Col. San Pedro	24
15		Athlàtic Huialfàs	20
16		Sporting Sant Marçal	16

	Ascenso : La Unión CF, S´Horta, Atlètic Sencelles

RIVALES EN 1ª Regional Bale.

USO DE MEMORIA

7,037,696 bytes

BENCHMARKS

Loading Time Base Classes	0.0011
Controller Execution Time ( Home / Category )	0.1142
Total Execution Time	0.1153

CADENA URL

/historico/Ce-Escolar-Senior

GET DATOS

$_GET['/historico/Ce-Escolar-Senior']

POST DATOS

No hay datos POST existentes

CONSULTAS (27)

0.0030	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 = 'Ce-Escolar-Senior' 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.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=9605 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=9605 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9605 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=686 AND type_rel = 3
0.0024	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 686 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0027	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 (1104898,627067,564570) ORDER BY n.cover_points DESC, update_date 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 = '9605' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0025	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 = '9605' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0036	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 = 73782 WHERE rp.league_id = 73782 AND rp.teamId = 9605 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 events2024 e ON e.player_id = p.id AND e.league_id = 73782 WHERE rp.league_id = 73782 AND rp.teamId = 9605 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0034	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 = 73782 WHERE rp.league_id = 73782 AND rp.teamId = 9605 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026	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 = 9605 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 73782 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.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 = 63635 AND t.round = 38 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* `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 = 59032 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.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* `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 = 51366 AND t.round = 28 ORDER BY team.conference ASC,t.position 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* `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 = 44635 AND t.round = 38 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* `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 = 39185 AND t.round = 38 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* `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 = 34179 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031	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 = 16792 AND t.round = 38 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* `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 = 4075 AND t.round = 38 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 = 2683 AND t.round = 38 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 = 1993 AND t.round = 38 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* `tables1988` 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 = 21786 AND t.round = 38 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* `tables1987` 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 = 21767 AND t.round = 38 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* `tables1962` 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 = 21539 AND t.round = 22 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

CE Escolar

CE Escolar

Selecciona un equipo

Competiciones que juega

1ª Regional Baleares Grupo 1

RIVALES EN 1ª Regional Bale.