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

Mollet

Entrenador: Albert Cámara

Temporada 2023/2024

TEMPORADA 2023/2024

PRIMERA CATALANA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Manlleu	26	52	27	58
2	Argentona	26	41	24	49
3	Caldes	26	40	31	42
4	Tossa	26	45	39	39
5	Bescanó	26	51	45	38
6	Montcada	26	43	36	37
7	Can Gibert	26	33	28	37
8	Mollet	26	40	39	36
9	Parets	26	31	27	35
10	Banyoles	26	41	39	35
11	Roses	26	39	47	35
12	Cardedeu	26	26	37	30
13	Blanes	26	32	47	30
14	Bosc Tosca	26	35	51	25
15	Mataró	26	36	43	23
16	Begur	26	30	55	21

TEMPORADA 2022/2023

PRIMERA CATALANA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	L'Escala	30	52	30	59
2	Palamós	30	46	35	53
3	UE Vic	30	43	31	53
4	UE Figueres	30	44	39	51
5	Granollers	30	51	34	49
6	Lloret	30	57	45	48
7	Mataró	30	46	46	41
8	Manlleu	30	43	44	40
9	Parets	30	34	35	38
10	Banyoles	30	33	37	38
11	Caldes	30	55	54	36
12	Bosc Tosca	30	37	40	35
13	Can Gibert	30	40	53	34
14	Mollet	30	29	35	33
15	Bescanó	30	37	57	29
16	CF Torelló	30	30	62	21

TEMPORADA 2021/2022

PRIMERA CATALANA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Montañesa	26	48	25	53
2	Lloret	26	52	34	45
3	L'Escala	26	47	33	42
4	Mollet	26	33	24	40
5	Mataró	26	38	32	40
6	Parets	26	41	35	39
7	Bescanó	26	32	36	38
8	Palamós	26	42	36	35
9	Unificació	26	36	36	35
10	Banyoles	26	25	30	33
11	Martinenc	26	26	33	32
12	Franqueses	26	39	41	31
13	Llagostera	26	24	48	28
14	Jonquera	26	18	58	12

TEMPORADA 2020/2021

PRIMERA CATALANA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Guineueta	18	32	14	37
2	Sant Cugat	18	32	13	34
3	Franqueses	18	17	13	31
4	Mataró	18	25	22	28
5	Unificació	18	27	25	26
6	Mollet	18	25	19	25
7	Rubí	18	34	35	25
8	Júpiter	18	20	32	17
9	Sabadell	18	18	35	17
10	Parets	18	14	36	12

TEMPORADA 2019/2020

PRIMERA CATALANA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Girona FC B	22	46	2	62
2	FE Grama	22	34	24	42
3	Palamós	22	43	29	41
4	Manlleu	22	37	28	41
5	UE Vic	22	34	17	38
6	Guineueta	22	29	20	34
7	Mataró	22	24	24	33
8	Júpiter	21	26	30	26
9	L'Escala	22	30	35	26
10	Rubí	21	24	37	26
11	Lloret	21	31	36	25
12	Jonquera	22	17	28	25
13	Sabadell	21	25	38	24
14	Mollet	21	32	33	22
15	Tona	22	18	32	17
16	Parets	22	25	45	16
17	Llagostera	21	14	31	13

TEMPORADA 2018/2019

2ª CATALANA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Mataró	34	83	37	75
2	Mollet	34	69	30	72
3	Turó Peira	34	75	37	68
4	Montcada	34	56	45	56
5	Europa B	34	53	37	52
6	Valldoreix	34	61	53	52
7	Premià	34	56	40	51
8	Sarrià	34	51	50	48
9	Unificació	34	55	57	48
10	Molletense	34	37	43	46
11	Parc	34	41	54	44
12	Canyelles	34	52	76	44
13	Sant	34	40	62	38
14	Pubilla	34	49	75	35
15	Young Talent	34	42	60	32
16	Sant Andreu	34	44	57	32
17	Singuerlin	34	50	76	29
18	Besòs	34	32	57	27

TEMPORADA 2017/2018

PRIMERA CATALANA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	FE Grama	34	64	29	73
2	CE Manresa	34	57	26	66
3	Can Vidalet	34	47	32	57
4	UE Vic	34	53	39	55
5	Montañesa	34	44	34	54
6	Farners	34	52	45	53
7	Manlleu	34	40	43	52
8	Jonquera	34	45	48	44
9	Llagostera	34	50	52	43
10	Juan	34	49	46	43
11	Sant Cugat	34	47	49	43
12	Júpiter	34	34	45	42
13	Banyoles	34	31	38	41
14	Lloret	34	51	54	40
15	Cardedeu	34	53	63	40
16	Sabadell B	34	36	44	40
17	Mollet	34	43	55	37
18	Castellar	34	27	81	18

TEMPORADA 2016/2017

PRIMERA CATALANA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	UA Horta	34	68	32	65
2	UE Sants	34	48	35	62
3	FC Andorra	34	43	32	62
4	Martinenc	34	49	42	55
5	Llagostera	34	45	37	51
6	Lloret	34	45	41	50
7	Mollet	34	51	44	49
8	UE Vic	34	42	45	46
9	Farners	34	44	46	45
10	CE Manresa	34	38	34	43
11	Juan	34	48	56	42
12	Sant Cugat	34	47	49	40
13	Girona FC B	34	42	40	40
14	Masnou	34	38	44	40
15	Tona	34	43	56	37
16	Ripollet	34	32	54	34
17	Avià	34	40	55	31
18	Hermes A	34	29	50	28

TEMPORADA 2015/2016

PRIMERA CATALANA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Vilassar	34	52	29	62
2	Jonquera	34	46	29	58
3	UA Horta	34	41	34	58
4	CE Manresa	34	50	36	56
5	Martinenc	34	53	48	55
6	UE Sants	34	48	43	54
7	UE Vic	34	42	33	52
8	Tona	34	47	43	52
9	Farners	34	38	32	51
10	FC Andorra	34	43	41	50
11	Mollet	34	34	33	47
12	Avià	34	51	54	46
13	Lloret	34	42	42	43
14	Girona FC B	34	45	46	41
15	Mataró	34	47	45	41
16	L'Escala	34	36	51	35
17	Abadessenc	34	37	66	30
18	Molletense	34	21	68	12

TEMPORADA 2014/2015

PRIMERA CATALANA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Júpiter	34	61	32	71
2	Granollers	34	58	36	63
3	CE Manresa	34	50	27	59
4	Avià	34	48	45	58
5	L'Escala	34	42	30	54
6	UE Sants	34	49	38	53
7	Lloret	34	55	42	50
8	Girona FC B	34	53	44	49
9	Mollet	34	34	32	49
10	Jonquera	34	53	49	47
11	UA Horta	34	40	43	47
12	UE Vic	34	48	55	44
13	Molletense	34	36	35	43
14	Farners	34	35	40	43
15	Gramanet	34	40	46	37
16	Tecnofutbol	34	34	59	34
17	Banyoles	34	27	57	23
18	Montcada	34	25	78	15

TEMPORADA 2013/2014

PRIMERA CATALANA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	CF Peralada	34	63	21	78
2	Sabadell B	34	70	35	73
3	Girona FC B	34	61	35	63
4	UE Vic	34	53	42	56
5	Farners	34	51	47	51
6	Granollers	34	60	48	50
7	Júpiter	34	57	56	46
8	Banyoles	34	50	51	46
9	Montcada	34	37	45	46
10	Mollet	34	53	53	44
11	Avià	34	39	48	42
12	Lloret	34	50	52	41
13	Vilassar	34	45	51	41
14	Jonquera	34	33	51	40
15	Unificació	34	46	59	36
16	Guíxols	34	48	56	34
17	Canyelles	34	56	73	33
18	Cristóbal	34	34	83	24

TEMPORADA 2012/2013

PRIMERA CATALANA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Cerdanyola	34	62	32	73
2	Masnou	34	63	57	56
3	UA Horta	34	58	38	55
4	Jonquera	34	55	44	53
5	Cd Montcada	34	54	46	52
6	Farners	34	49	49	49
7	CF Peralada	34	50	41	48
8	Guíxols	34	46	45	46
9	Avià	34	59	59	46
10	Mollet	34	57	62	46
11	Vilassar	34	54	53	44
12	Cristóbal	34	40	45	43
13	Lloret	34	45	55	43
14	Granollers	34	49	53	42
15	Sant Cugat	34	44	50	39
16	Sant Quirze	34	53	66	39
17	Gramanet B	34	41	62	35
18	Ripollet	34	34	56	24

TEMPORADA 2011/2012

PRIMERA CATALANA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	UE Figueres	34	69	28	78
2	Vilassar	34	64	31	69
3	Palamós	34	66	29	67
4	Cristóbal	34	53	50	63
5	Cerdanyola	34	57	41	54
6	Mollet	34	61	44	53
7	UE Avià	34	61	59	48
8	Farners	34	63	63	45
9	Cf Lloret	34	48	59	45
10	Ripollet	34	65	65	44
11	Montcada	34	52	61	44
12	Guíxols	34	44	54	42
13	CF Peralada	34	58	58	41
14	Gramanet B	34	49	66	40
15	San Lorenzo	34	38	54	38
16	Premià	34	35	59	32
17	CE Manresa	34	45	65	28
18	Junior	34	32	74	24

TEMPORADA 1957/1958

TERCERA DIVISIÓN GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Unió	42	116	73	58
2	Montcada	42	122	67	55
3	Rapitenca	42	81	59	54
4	CA Iberia	42	100	68	51
5	UE Figueres	42	76	43	50
6	Manlleu	42	84	67	49
7	Guíxols	42	98	86	47
8	Gramanet	42	96	79	47
9	Sallent	42	78	89	45
10	Santboià	42	96	82	45
11	Banyoles	42	90	94	43
12	Poble	42	79	77	43
13	Durgell	42	84	71	40
14	Balaguer	42	91	83	40
15	Calella	42	69	78	39
16	Vilafranca	42	70	78	38
17	Júpiter	42	87	79	37
18	Montagut A	42	62	78	35
19	Igualada	42	61	106	33
20	Reus	42	56	90	31
21	Sant Celoni	42	58	115	28
22	Mollet	42	52	144	16

TEMPORADA 1956/1957

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	UE Sants	46	123	68	62
2	CE Manresa	46	90	59	56
3	CE Europa	46	101	63	56
4	Badalona	46	93	76	55
5	Hércules	46	90	82	53
6	Gimnàstic	46	94	68	52
7	Tortosa	46	105	81	51
8	Fabra Coats	46	91	70	51
9	Adrianenc	46	87	94	49
10	Sant Andreu	46	89	74	49
11	Artiguense	46	93	89	47
12	UE Vic	46	84	90	47
13	Granollers	46	112	101	45
14	Mataró	46	94	93	45
15	Amposta	46	104	100	45
16	La Cava	46	67	85	45
17	UA Horta	46	76	88	43
18	Montcada	46	78	97	41
19	Martinenc	46	80	107	40
20	Puigreig	46	92	105	39
21	Unió	46	82	113	38
22	Júpiter	46	76	100	37
23	Poble Nou	46	69	108	33
24	Mollet	46	56	115	25

TEMPORADA 1955/1956

TERCERA DIVISIÓN GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Tortosa	22	49	36	27
2	Amposta	22	49	34	27
3	Gimnàstic	22	36	31	26
4	Hércules	22	54	41	25
5	Granollers	22	53	42	25
6	Unió	22	32	41	22
7	Sant Andreu	22	35	34	22
8	La Cava	22	50	40	21
9	Martinenc	22	42	44	19
10	Reus	22	38	51	19
11	Poble	22	34	52	18
12	Mollet	22	26	52	13

TEMPORADA 1954/1955

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Girona	20	47	14	31
2	CE Manresa	20	48	29	26
3	Sant Andreu	20	37	23	26
4	UE Vic	20	27	28	25
5	Mollet	20	33	29	20
6	Granollers	20	32	37	19
7	Mataró	20	33	28	18
8	Badalona	20	34	34	16
9	Puigreig	20	31	51	14
10	Montcada	20	25	50	13
11	Júpiter	20	27	51	12

Competiciones que juega

Grupo 1

Primera Catalana Grupo 1

Pos	Equipos		Pts
1		Manlleu	58
2		Argentona	49
3		Caldes Montbui	42
4		Tossa	39
5		Bescanó	38
6		Montcada	37
7		Can Gibert	37
8		Mollet	36
9		Parets	35
10		Banyoles	35
11		Roses	35
12		Cardedeu	30
13		Blanes	30
14		EF Bosc de Tosca	25
15		Mataró	23
16		Begur	21

	Ascenso : Manlleu
	Playoff Ascenso : Argentona
	Posible siguiente ronda : Caldes Montbui
	Descenso : Blanes, EF Bosc de Tosca, Mataró, Begur

RIVALES EN Primera Catalana

USO DE MEMORIA

7,156,752 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1478
Total Execution Time	0.1490

CADENA URL

/historico/Cf-Mollet

GET DATOS

$_GET['/historico/Cf-Mollet']

POST DATOS

No hay datos POST existentes

CONSULTAS (39)

0.0035	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 = 'Cf-Mollet' 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.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=6090 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=6090 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6090 AND type_rel = 2
0.0023	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6090 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0024	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 (74347,156624,966243,1094420) ORDER BY n.cover_points DESC, update_date DESC
0.0028	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 = '6090' ORDER BY l.year DESC,cat.coefficient 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 = '6090' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0028	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 = '6090' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022	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 = 72878 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028	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=6090 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019	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 (72878) 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.0032	SELECT count(id) as num_players from rel_players WHERE league_id = 72878 AND teamId = 6090
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 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 = 72878 AND t.round = 28 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022	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 = '6090' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6090' 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 = '6090' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0043	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 = 72878 WHERE rp.league_id = 72878 AND rp.teamId = 6090 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.0039	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 = 72878 WHERE rp.league_id = 72878 AND rp.teamId = 6090 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033	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 = 72878 WHERE rp.league_id = 72878 AND rp.teamId = 6090 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025	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 = 6090 AND l.year <= 2024 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* `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 = 72878 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.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 = 68448 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.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* `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 = 63408 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.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* `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 = 58715 AND t.round = 18 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* `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 = 50597 AND t.round = 23 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* `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 = 44410 AND t.round = 34 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 = 38991 AND t.round = 34 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* `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 = 33951 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* `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 = 16583 AND t.round = 34 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* `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 = 3946 AND t.round = 34 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* `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 = 2673 AND t.round = 34 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* `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 = 1983 AND t.round = 34 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 = 1458 AND t.round = 34 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* `tables1958` 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 = 21452 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0042	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* `tables1957` 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 = 21482 AND t.round = 46 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* `tables1956` 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 = 21465 AND t.round = 22 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* `tables1955` 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 = 21421 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019	SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 72878 ORDER BY nameShow LIMIT 100


	¿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

Mollet

Mollet

Selecciona un equipo

Competiciones que juega

Primera Catalana Grupo 1

RIVALES EN Primera Catalana