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

Yeovil Town

Entrenador: Mark Cooper

Temporada 2019/2020

TEMPORADA 2019/2020

NATIONAL LEAGUE
Equipo		PJ	GF	GC	Puntos
1	Barrow	37	68	39	70
2	Harrogate	37	61	44	66
3	Notts County	38	61	38	63
4	Yeovil Town	37	61	44	60
5	Boreham Wood	37	55	40	60
6	Halifax Town	37	50	49	58
7	Barnet	35	52	42	54
8	Stockport	39	51	54	58
9	Solihull	38	48	37	55
10	Woking	38	50	55	55
11	Dover	38	49	49	54
12	Hartlepool	39	56	50	55
13	Bromley	38	57	52	52
14	Torquay	36	56	61	48
15	Sutton	38	47	42	50
16	Eastleigh	37	43	55	46
17	Dagenham	37	40	44	44
18	Aldershot	39	43	55	46
19	Wrexham AFC	37	46	49	43
20	Chesterfield	38	55	65	44
21	Maidenhead	38	44	58	41
22	Ebbsfleet	39	47	68	42
23	Fylde	37	44	60	39
24	Chorley	38	31	65	26

TEMPORADA 2018/2019

LEAGUE TWO
Equipo		PJ	GF	GC	Puntos
1	Lincoln City	46	73	43	85
2	Bury	46	82	56	79
3	Milton	46	71	49	79
4	Mansfield	46	69	41	76
5	Forest Green	46	68	47	74
6	Tranmere	46	63	50	73
7	Newport	46	59	59	71
8	Colchester	46	65	53	70
9	Exeter City	46	60	49	70
10	Stevenage	46	59	55	70
11	Carlisle	46	67	62	68
12	Crewe	46	60	59	65
13	Swindon Town	46	59	56	64
14	Oldham	46	67	60	62
15	Northampton	46	64	63	61
16	Cheltenham	46	57	68	57
17	Grimsby Town	46	45	56	56
18	Morecambe	46	54	70	54
19	Crawley Town	46	51	68	53
20	Port Vale	46	39	55	49
21	Cambridge	46	40	66	47
22	Macclesfield	46	48	74	44
23	Notts County	46	48	84	41
24	Yeovil Town	46	41	66	40

TEMPORADA 2017/2018

LEAGUE TWO
Equipo		PJ	GF	GC	Puntos
1	Accrington	46	76	46	93
2	Luton Town	46	94	46	88
3	Wycombe	46	79	60	84
4	Exeter City	46	64	54	80
5	Notts County	46	71	48	77
6	Coventry	46	64	47	75
7	Lincoln City	46	64	48	75
8	Mansfield	46	67	52	72
9	Swindon Town	46	67	65	68
10	Carlisle	46	62	54	67
11	Newport	46	56	58	64
12	Cambridge	46	56	60	64
13	Colchester	46	53	52	62
14	Crawley Town	46	58	66	59
15	Crewe	46	62	75	56
16	Stevenage	46	60	65	55
17	Cheltenham	46	67	73	51
18	Grimsby Town	46	42	66	51
19	Yeovil Town	46	59	75	48
20	Port Vale	46	49	67	47
21	Forest Green	46	54	77	47
22	Morecambe	46	41	56	46
23	Barnet	46	46	65	46
24	Chesterfield	46	47	83	38

TEMPORADA 2016/2017

LEAGUE TWO
Equipo		PJ	GF	GC	Puntos
1	Portsmouth	46	79	40	87
2	Plymouth	46	71	46	87
3	Doncaster	46	85	55	85
4	Luton Town	46	70	43	77
5	Exeter City	46	75	56	71
6	Carlisle	46	69	68	71
7	Blackpool	46	69	46	70
8	Colchester	46	67	57	69
9	Wycombe	46	58	53	69
10	Stevenage	46	67	63	67
11	Cambridge	46	58	50	66
12	Mansfield	46	54	50	66
13	Accrington	46	59	56	65
14	Grimsby Town	46	59	63	62
15	Barnet	46	57	64	57
16	Notts County	46	54	76	56
17	Crewe	46	58	67	55
18	Morecambe	46	53	73	52
19	Crawley Town	46	53	71	51
20	Yeovil Town	46	49	64	50
21	Cheltenham	46	49	69	50
22	Newport	46	51	73	48
23	Hartlepool	46	54	75	46
24	Leyton	46	47	87	36

TEMPORADA 2015/2016

LEAGUE TWO
Equipo		PJ	GF	GC	Puntos
1	Northampton	46	82	46	99
2	Oxford	46	84	41	86
3	Bristol	46	77	46	85
4	Accrington	46	74	48	85
5	Plymouth	46	72	46	81
6	Portsmouth	46	75	44	78
7	Wimbledon	46	64	50	75
8	Leyton	46	60	61	69
9	Cambridge	46	66	55	68
10	Carlisle	46	67	62	67
11	Luton Town	46	63	61	66
12	Mansfield	46	61	53	64
13	Wycombe	46	45	44	64
14	Exeter City	46	63	65	64
15	Barnet	46	67	68	62
16	Hartlepool	46	49	72	51
17	Notts County	46	54	83	51
18	Stevenage	46	52	67	48
19	Yeovil Town	46	43	59	48
20	Crawley Town	46	45	78	47
21	Morecambe	46	69	91	46
22	Newport	46	43	64	43
23	Dagenham	46	46	81	34
24	York City	46	51	87	34

TEMPORADA 2014/2015

LEAGUE ONE
Equipo		PJ	GF	GC	Puntos
1	Bristol City	46	96	38	99
2	Milton	46	101	44	91
3	Preston	46	79	40	89
4	Swindon Town	46	76	57	79
5	Sheffield	46	66	53	71
6	Chesterfield	46	68	55	69
7	Bradford	46	55	55	65
8	Rochdale	46	72	66	63
9	Peterborough	46	53	56	63
10	Fleetwood	46	49	52	63
11	Barnsley	46	62	61	62
12	Gillingham	46	65	66	62
13	Doncaster	46	58	62	61
14	Walsall	46	50	54	59
15	Oldham	46	54	67	57
16	Scunthorpe	46	62	75	56
17	Coventry	46	49	60	55
18	Port Vale	46	55	65	54
19	Colchester	46	58	77	52
20	Crewe	46	43	75	52
21	Notts County	46	45	63	50
22	Crawley Town	46	53	79	50
23	Leyton	46	59	69	49
24	Yeovil Town	46	36	75	40

TEMPORADA 2013/2014

CHAMPIONSHIP
Equipo		PJ	GF	GC	Puntos
1	Leicester	46	83	43	102
2	Burnley	46	72	37	93
3	Derby County	46	84	52	85
4	Queens Park	46	60	44	80
5	Wigan	46	61	48	73
6	Brighton	46	55	40	72
7	Reading	46	70	56	71
8	Blackburn	46	70	62	70
9	Ipswich Town	46	60	54	68
10	Bournemouth	46	67	66	66
11	Nottingham	46	67	64	65
12	Middlesbroug	46	62	50	64
13	Watford	46	74	64	60
14	Bolton	46	59	60	59
15	Leeds United	46	59	67	57
16	Sheffield	46	63	65	53
17	Huddersfield	46	58	65	53
18	Charlton	46	41	61	51
19	Millwall	46	46	74	48
20	Blackpool	46	38	66	46
21	Birmingham	46	58	74	44
22	Doncaster	46	39	70	44
23	Barnsley	46	44	77	39
24	Yeovil Town	46	44	75	37

TEMPORADA 2012/2013

LEAGUE ONE
Equipo		PJ	GF	GC	Puntos
1	Doncaster	46	62	44	84
2	Bournemouth	46	76	53	83
3	Brentford	46	62	47	79
4	Yeovil Town	46	71	56	77
5	Sheffield	46	56	42	75
6	Swindon Town	46	72	39	74
7	Leyton	46	55	48	71
8	Milton	46	62	45	70
9	Walsall	46	65	58	68
10	Crawley Town	46	59	58	68
11	Tranmere	46	58	48	67
12	Notts County	46	61	49	65
13	Crewe	46	54	62	64
14	Preston	46	54	49	59
15	Coventry	46	66	59	55
16	Shrewsbury	46	54	60	55
17	Carlisle	46	56	77	55
18	Stevenage	46	47	64	54
19	Oldham	46	46	59	51
20	Colchester	46	47	68	51
21	Scunthorpe	46	49	73	48
22	Bury	46	45	73	41
23	Hartlepool	46	39	67	41
24	Portsmouth	46	51	69	32

TEMPORADA 2011/2012

LEAGUE ONE
Equipo		PJ	GF	GC	Puntos
1	Charlton	46	82	36	101
2	Sheffield	46	81	48	93
3	Sheffield	46	92	51	90
4	Huddersfield	46	79	47	81
5	Milton	46	84	47	80
6	Stevenage	46	69	44	73
7	Notts County	46	75	63	73
8	Carlisle	46	65	66	69
9	Brentford	46	63	52	67
10	Colchester	46	61	66	59
11	Bournemouth	46	48	52	58
12	Tranmere	46	49	53	56
13	Hartlepool	46	50	55	56
14	Bury	46	60	79	56
15	Preston	46	54	68	54
16	Oldham	46	50	66	54
17	Yeovil Town	46	59	80	54
18	Scunthorpe	46	55	59	52
19	Walsall	46	51	57	50
20	Leyton	46	48	75	50
21	Wycombe	46	65	88	43
22	Chesterfield	46	56	81	42
23	Exeter City	46	46	75	42
24	Rochdale	46	47	81	38

TEMPORADA 2010/2011

LEAGUE ONE
Equipo		PJ	GF	GC	Puntos
1	Brighton	46	85	40	95
2	Southampton	46	86	38	92
3	Huddersfield	46	77	48	87
4	Peterborough	46	106	75	79
5	Milton	46	67	60	77
6	Bournemouth	46	75	54	71
7	Leyton	46	71	62	70
8	Exeter City	46	66	73	70
9	Rochdale	46	63	55	68
10	Colchester	46	57	63	62
11	Brentford	46	55	62	61
12	Carlisle	46	60	62	59
13	Charlton	46	62	66	59
14	Yeovil Town	46	56	66	59
15	Sheffield	46	67	67	58
16	Hartlepool	46	47	65	57
17	Oldham	46	53	60	56
18	Tranmere	46	53	60	56
19	Plymouth	46	51	74	52
20	Notts County	46	46	60	50
21	Walsall	46	56	75	48
22	Dagenham	46	52	70	47
23	Bristol	46	48	82	45
24	Swindon Town	46	50	72	41

TEMPORADA 2009/2010

LEAGUE ONE
Equipo		PJ	GF	GC	Puntos
1	Colchester	1	7	1	3
2	Gillingham	1	5	0	3
3	Brentford	1	3	1	3
4	Yeovil Town	1	2	0	3
5	Charlton	1	3	2	3
6	Leeds United	1	2	1	3
7	Leyton	1	2	1	3
8	Walsall	1	1	0	3
9	Huddersfield	1	2	2	1
10	Southend	1	2	2	1
11	Millwall	1	1	1	1
12	Southampton	1	1	1	1
13	Hartlepool	1	0	0	1
14	Milton	1	0	0	1
15	Oldham	1	0	0	1
16	Stockport	1	0	0	1
17	Wycombe	1	2	3	0
18	Bristol	1	1	2	0
19	Exeter City	1	1	2	0
20	Brighton	1	0	1	0
21	Carlisle	1	1	3	0
22	Tranmere	1	0	2	0
23	Swindon Town	1	0	5	0
24	Norwich City	1	1	7	0

TEMPORADA 2008/2009

LEAGUE ONE
Equipo		PJ	GF	GC	Puntos
1	Leicester	46	84	39	96
2	Peterborough	46	78	54	89
3	Milton	46	83	47	87
4	Leeds United	46	77	49	84
5	Millwall	46	63	53	82
6	Scunthorpe	46	82	63	76
7	Tranmere	46	62	49	74
8	Southend	46	58	61	71
9	Huddersfield	46	62	65	68
10	Oldham	46	66	65	65
11	Bristol	46	79	61	63
12	Colchester	46	58	58	63
13	Walsall	46	61	66	61
14	Stockport	46	59	57	60
15	Leyton	46	45	57	56
16	Swindon Town	46	68	71	53
17	Brighton	46	55	70	52
18	Yeovil Town	46	41	66	51
19	Hartlepool	46	66	79	50
20	Carlisle	46	56	69	50
21	Northampton	46	61	65	49
22	Crewe	46	59	82	46
23	Cheltenham	46	51	91	39
24	Hereford	46	42	79	34

TEMPORADA 2007/2008

LEAGUE ONE
Equipo		PJ	GF	GC	Puntos
1	Swansea City	46	82	42	92
2	Leeds United	46	72	38	91
3	Nottingham	46	64	32	82
4	Doncaster	46	65	41	80
5	Carlisle	46	64	46	80
6	Southend	46	70	55	76
7	Brighton	46	58	50	69
8	Oldham	46	58	46	67
9	Northampton	46	60	55	66
10	Huddersfield	46	50	62	66
11	Tranmere	46	52	47	65
12	Walsall	46	52	46	64
13	Swindon Town	46	63	56	61
14	Leyton	46	49	63	60
15	Bournemouth	46	62	72	58
16	Hartlepool	46	63	66	54
17	Bristol	46	45	53	53
18	Millwall	46	45	60	52
19	Yeovil Town	46	38	59	52
20	Cheltenham	46	42	64	51
21	Crewe	46	47	65	50
22	Gillingham	46	44	73	46
23	Luton Town	46	43	63	43
24	Port Vale	46	47	81	38

TEMPORADA 2006/2007

LEAGUE ONE
Equipo		PJ	GF	GC	Puntos
1	Scunthorpe	46	73	35	91
2	Bristol City	46	63	39	85
3	Blackpool	46	76	49	83
4	Nottingham	46	65	41	82
5	Yeovil Town	46	55	39	79
6	Oldham	46	69	47	75
7	Swansea City	46	69	53	72
8	Carlisle	46	54	55	68
9	Tranmere	46	58	53	67
10	Millwall	46	59	62	66
11	Doncaster	46	52	47	63
12	Port Vale	46	64	65	60
13	Crewe	46	66	72	60
14	Northampton	46	48	51	59
15	Huddersfield	46	60	69	59
16	Gillingham	46	56	77	59
17	Cheltenham	46	49	61	54
18	Brighton	46	49	58	53
19	Bournemouth	46	50	64	52
20	Leyton	46	61	77	51
21	Rotherham	46	58	75	48
22	Chesterfield	46	45	53	47
23	Bradford	46	47	65	47
24	Brentford	46	40	79	37

TEMPORADA 2005/2006

LEAGUE ONE
Equipo		PJ	GF	GC	Puntos
1	Southend	46	72	43	82
2	Colchester	46	58	40	79
3	Brentford	46	72	52	76
4	Huddersfield	46	72	59	73
5	Barnsley	46	62	44	72
6	Swansea City	46	78	55	71
7	Nottingham	46	67	52	69
8	Doncaster	46	55	51	69
9	Bristol City	46	66	62	65
10	Oldham	46	58	60	65
11	Bradford	46	51	49	61
12	Scunthorpe	46	68	73	60
13	Port Vale	46	49	54	60
14	Gillingham	46	50	64	60
15	Yeovil Town	46	54	62	56
16	Chesterfield	46	63	73	56
17	Bournemouth	46	49	53	55
18	Tranmere	46	50	52	54
19	Blackpool	46	56	64	53
20	Rotherham	46	52	62	52
21	Hartlepool	46	44	59	50
22	Milton	46	45	66	50
23	Swindon Town	46	46	65	48
24	Walsall	46	47	70	47

TEMPORADA 2004/2005

LEAGUE TWO
Equipo		PJ	GF	GC	Puntos
1	Yeovil Town	46	90	65	83
2	Scunthorpe	46	69	42	80
3	Swansea City	46	62	43	80
4	Southend	46	65	46	78
5	Macclesfield	46	60	49	75
6	Lincoln City	46	64	47	72
7	Northampton	46	62	51	72
8	Darlington	46	57	49	72
9	Rochdale	46	54	48	66
10	Wycombe	46	58	52	65
11	Leyton	46	65	67	63
12	Bristol	46	60	57	60
13	Mansfield	46	56	56	60
14	Cheltenham	46	51	54	60
15	Oxford	46	50	63	59
16	Boston	46	62	58	58
17	Bury	46	54	54	58
18	Grimsby Town	46	51	52	58
19	Notts County	46	46	62	52
20	Chester	46	43	69	52
21	Shrewsbury	46	48	53	49
22	Rushden	46	42	63	44
23	Cambridge	46	39	62	40
24	Kidderminste	46	39	85	38

TEMPORADA 2003/2004

LEAGUE TWO
Equipo		PJ	GF	GC	Puntos
1	Doncaster	46	79	37	92
2	Hull City	46	82	44	88
3	Torquay	46	68	44	81
4	Huddersfield	46	68	52	81
5	Mansfield	46	76	62	75
6	Northampton	46	58	51	75
7	Lincoln City	46	68	47	74
8	Yeovil Town	46	70	57	74
9	Oxford City	46	55	44	71
10	Swansea City	46	58	61	59
11	Boston	46	50	54	59
12	Bury	46	54	64	56
13	Cambridge	46	55	67	56
14	Cheltenham	46	57	71	56
15	Bristol	46	50	61	55
16	Kidderminste	46	45	59	55
17	Southend	46	51	63	54
18	Darlington	46	53	61	53
19	Leyton	46	48	65	53
20	Macclesfield	46	54	69	52
21	Rochdale	46	49	58	50
22	Scunthorpe	46	69	72	49
23	Carlisle	46	46	69	45
24	York City	46	35	66	44

TEMPORADA 2002/2003

NATIONAL LEAGUE
Equipo		PJ	GF	GC	Puntos
1	Yeovil Town	42	100	37	95
2	Morecambe	42	86	42	78
3	Doncaster	42	73	47	78
4	Chester	42	59	31	75
5	Dagenham	42	71	59	72
6	Hereford	42	64	51	64
7	Scarborough	42	63	54	64
8	Halifax Town	42	50	51	64
9	Forest Green	42	61	62	59
10	Margate	42	60	66	56
11	Barnet	42	65	68	53
12	Stevenage	42	61	55	52
13	Farnborough	42	57	56	51
14	Northwich	42	66	72	51
15	Telford	42	54	69	49
16	Burton	42	52	77	49
17	Ebbsfleet	42	62	73	48
18	Leigh	42	44	71	48
19	Woking	42	52	81	47
20	Nuneaton	42	51	78	46
21	Southport	42	54	69	45
22	Kettering	42	37	73	31

TEMPORADA 2001/2002

NATIONAL LEAGUE
Equipo		PJ	GF	GC	Puntos
1	Boston	42	84	42	84
2	Dagenham	42	70	47	84
3	Yeovil Town	42	66	53	70
4	Doncaster	42	68	46	67
5	Barnet	42	64	48	67
6	Morecambe	42	63	67	62
7	Farnborough	42	66	54	61
8	Margate	42	59	53	58
9	Telford	42	63	58	57
10	Nuneaton	42	57	57	57
11	Scarborough	42	55	63	56
12	Stevenage	42	57	60	55
13	Northwich	42	57	70	55
14	Chester	42	54	51	54
15	Southport	42	53	49	53
16	Leigh	42	56	58	53
17	Hereford	42	50	53	52
18	Forest Green	42	54	76	51
19	Woking	42	59	70	48
20	Hayes FC	42	53	80	44
21	Stalybridge	42	40	69	43
22	Dover	42	41	65	39

TEMPORADA 2000/2001

NATIONAL LEAGUE
Equipo		PJ	GF	GC	Puntos
1	Rushden	42	78	36	86
2	Yeovil Town	42	72	50	78
3	Dagenham	42	71	54	77
4	Southport	42	58	46	69
5	Leigh	42	63	57	68
6	Telford	42	51	51	65
7	Stevenage	42	71	61	63
8	Chester	42	49	43	62
9	Doncaster	42	47	43	58
10	Scarborough	42	56	54	58
11	Hereford	42	59	46	56
12	Boston	42	74	63	56
13	Nuneaton	42	60	59	56
14	Woking	42	52	57	54
15	Dover	42	54	56	53
16	Forest Green	42	43	54	48
17	Northwich	42	49	67	46
18	Hayes FC	42	44	71	46
19	Morecambe	42	64	66	45
20	Kettering	42	46	62	43
21	Kingstonian	42	47	73	34
22	Hednesford	42	46	85	29

Competiciones que juega

National League

Pos	Equipos		Pts
1		Barrow	70
2		Harrogate Town	66
3		Notts County	63
4		Yeovil Town	60
5		Boreham Wood	60
6		FC Halifax Town	58
7		Barnet	54
8		Stockport County	58
9		Solihull Moors	55
10		Woking	55
11		Dover Athletic	54
12		Hartlepool United	55
13		Bromley	52
14		Torquay United	48
15		Sutton United	50
16		Eastleigh	46
17		Dagenham & Redbridge	44
18		Aldershot Town	46
19		Wrexham AFC	43
20		Chesterfield	44
21		Maidenhead United	41
22		Ebbsfleet United	42
23		Fylde	39
24		Chorley	26

	Ascenso : Barrow
	Playoff Ascenso : Harrogate Town, Notts County, Yeovil Town, Boreham Wood, FC Halifax Town, Barnet
	Descenso : Maidenhead United, Ebbsfleet United, Fylde, Chorley

RIVALES EN National League

RIVALES EN National League.

RIVALES EN FA Cup

RIVALES EN FA Trophy

USO DE MEMORIA

9,487,728 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.2616
Total Execution Time	0.2628

CADENA URL

/historico/Yeovil-Town/2020

GET DATOS

$_GET['/historico/Yeovil-Town/2020']

POST DATOS

No hay datos POST existentes

CONSULTAS (54)

0.0033	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 = 'Yeovil-Town' AND l.year = 2020 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=9188 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=9188 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=9188 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=9188 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=9188 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=9188 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 50119
0.0026	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 = 57003
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9188 AND type_rel = 2
0.0023	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 9188 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 (33053,40852,43133,44159,48047) ORDER BY n.cover_points DESC, update_date DESC
0.0033	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 = '9188' ORDER BY l.year DESC,cat.coefficient DESC
0.0032	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 = '9188' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0042	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 = '9188' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 50119 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 57003 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0041	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 = 50579 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0055	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=9188 AND l.year in (2019,2020,2021) 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 (58730,58520,58519,57003,56547,44710,43924,43872) 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.0034	SELECT count(id) as num_players from rel_players WHERE league_id = 43872 AND teamId = 9188
0.0041	SELECT count(id) as num_players from rel_players WHERE league_id = 58730 AND teamId = 9188
0.0041	SELECT count(id) as num_players from rel_players WHERE league_id = 58520 AND teamId = 9188
0.0033	SELECT count(id) as num_players from rel_players WHERE league_id = 43924 AND teamId = 9188
0.0041	SELECT count(id) as num_players from rel_players WHERE league_id = 58519 AND teamId = 9188
0.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 57003 AND teamId = 9188
0.0031	SELECT count(id) as num_players from rel_players WHERE league_id = 44710 AND teamId = 9188
0.0226	SELECT count(id) as num_players from rel_players WHERE league_id = 56547 AND teamId = 9188
0.0045	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 50119 AND t.round = 39 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0023	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 = '9188' 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 = '9188' and rp.type = 4
0.0021	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 = '9188' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0057	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 events2020 e ON e.player_id = p.id AND e.league_id = 50119 WHERE rp.league_id = 50119 AND rp.teamId = 9188 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.0051	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 events2020 e ON e.player_id = p.id AND e.league_id = 50119 WHERE rp.league_id = 50119 AND rp.teamId = 9188 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0040	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 events2020 e ON e.player_id = p.id AND e.league_id = 50119 WHERE rp.league_id = 50119 AND rp.teamId = 9188 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0057	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 = 9188 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0046	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 = 50119 AND t.round = 39 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0059	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 = 43872 AND t.round = 46 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* `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 = 38701 AND t.round = 46 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* `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 = 30629 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0041	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 = 15150 AND t.round = 46 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 = 3887 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0047	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 = 1917 AND t.round = 46 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* `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 = 1317 AND t.round = 46 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 = 1071 AND t.round = 46 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* `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 = 2600 AND t.round = 1 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 = 442 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038	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 = 476 AND t.round = 46 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* `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 = 478 AND t.round = 46 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* `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 = 494 AND t.round = 46 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* `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 = 578 AND t.round = 42 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* `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 = 579 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* `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 = 580 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	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 = 50119 ORDER BY nameShow LIMIT 100

Yeovil Town

Yeovil Town

Selecciona un equipo

Competiciones que juega

National League

RIVALES EN National League

RIVALES EN National League.

RIVALES EN FA Cup

RIVALES EN FA Trophy