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

Airbus UK

Temporada 2016/2017

TEMPORADA 2016/2017

LIGA GALES GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Newtown	10	33	9	45
2	Cefn Druids	10	16	8	39
3	Llandudno	10	13	16	35
4	Aberystwyth	10	16	22	34
5	Rhyl FC	10	11	20	30
6	Airbus UK	10	9	23	21

TEMPORADA 2015/2016

LIGA GALES GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Connah's	2	3	0	6
2	Airbus UK	2	2	2	3
3	Newtown	1	1	2	0
4	Carmarthen	1	0	2	0

TEMPORADA 2014/2015

LIGA GALES GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Saints	10	26	8	77
2	Bala Town	10	20	14	59
3	Airbus UK	10	21	12	58
4	Aberystwyth	10	20	26	52
5	Port Talbot	10	14	26	43
6	Newtown	10	12	27	38

TEMPORADA 2013/2014

LIGA GALES GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Saints	20	55	10	46
2	Airbus UK	20	41	20	42
3	Bangor City	20	29	23	31
4	Newtown	20	30	32	31
5	Rhyl FC	20	25	25	28
6	Carmarthen	20	31	32	27
7	Aberystwyth	20	34	34	25
8	Port Talbot	20	22	28	23
9	Prestatyn	20	21	26	21
10	Bala Town	20	25	29	20
11	Connah's	20	24	49	20
12	Afan Lido	20	14	43	13

TEMPORADA 2012/2013

LIGA GALES GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Saints	22	48	17	46
2	Airbus UK	22	59	31	39
3	Bangor City	22	51	34	36
4	Prestatyn	22	52	48	36
5	Port Talbot	22	40	37	32
6	Carmarthen	22	31	36	30
7	Connah's	22	51	54	29
8	Llanelli	22	28	44	27
9	Bala Town	22	33	38	26
10	Newtown	22	37	45	26
11	Aberystwyth	22	28	45	26
12	Afan Lido	22	32	61	14

TEMPORADA 2011/2012

LIGA GALES GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Bangor City	22	53	28	50
2	Saints	22	52	24	49
3	Llanelli	22	47	23	45
4	Neath	22	43	20	43
5	Bala Town	22	35	25	39
6	Prestatyn	22	33	37	28
7	Airbus UK	22	32	37	25
8	Port Talbot	22	26	37	22
9	Afan Lido	22	24	35	22
10	Aberystwyth	22	27	38	17
11	Carmarthen	22	19	51	13
12	Newtown	22	26	62	13

TEMPORADA 2010/2011

LIGA GALES GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Bangor City	22	63	25	56
2	Saints	22	68	24	50
3	Neath	22	50	23	45
4	Llanelli	22	35	28	36
5	Prestatyn	22	35	29	31
6	Port Talbot	22	28	36	27
7	Aberystwyth	22	26	40	26
8	Airbus UK	22	35	41	24
9	Carmarthen	22	30	52	22
10	Bala Town	22	25	42	17
11	Newtown	22	20	44	15
12	Haverfordwes	22	19	50	15

TEMPORADA 2009/2010

LIGA GALES
Equipo		PJ	GF	GC	Puntos
1	Saints	34	69	13	82
2	Llanelli	34	79	26	80
3	Port Talbot	34	56	23	65
4	Aberystwyth	34	54	41	64
5	Bangor City	34	75	45	63
6	Rhyl FC	34	74	43	62
7	Airbus UK	34	49	37	49
8	Prestatyn	34	53	53	48
9	Neath	34	41	38	47
10	Carmarthen	34	45	38	45
11	Bala Town	34	39	47	45
12	Haverfordwes	34	43	47	44
13	Newtown	34	54	57	41
14	Connah's	34	31	42	41
15	Porthmadog	34	23	66	24
16	Welshpool	34	30	70	23
17	Caersws	34	26	94	13
18	Cefn Druids	34	16	77	9

TEMPORADA 2008/2009

LIGA GALES
Equipo		PJ	GF	GC	Puntos
1	Rhyl FC	34	95	29	90
2	Llanelli	34	98	38	83
3	Saints	34	79	27	71
4	Carmarthen	34	52	47	62
5	Port Talbot	34	57	48	56
6	Bangor City	34	58	40	55
7	Haverfordwes	34	53	39	55
8	Aberystwyth	34	51	50	46
9	Connah's	34	49	65	41
10	Newtown	34	46	54	40
11	Welshpool	34	48	70	40
12	Airbus UK	34	47	57	39
13	Cefn Druids	34	57	74	34
14	Neath	34	43	65	34
15	Prestatyn	34	48	70	33
16	Porthmadog	34	57	91	32
17	Caersws	34	28	61	25
18	Caernarfon	34	32	73	20

TEMPORADA 2007/2008

LIGA GALES
Equipo		PJ	GF	GC	Puntos
1	Llanelli	34	98	34	85
2	Saints	34	85	30	78
3	Rhyl FC	34	60	24	69
4	Port Talbot	34	57	48	59
5	Bangor City	34	62	31	55
6	Carmarthen	34	58	47	54
7	Neath	34	57	52	54
8	Haverfordwes	34	61	59	47
9	Aberystwyth	34	57	45	46
10	Welshpool	34	49	51	46
11	Airbus UK	34	36	44	42
12	Cefn Druids	34	45	66	38
13	Newtown	34	47	66	37
14	Caernarfon	34	42	74	36
15	Connah's	34	42	85	34
16	Porthmadog	34	47	69	27
17	Caersws	34	37	72	26
18	Llangefni	34	39	82	24

TEMPORADA 2006/2007

LIGA GALES
Equipo		PJ	GF	GC	Puntos
1	Saints	32	81	20	76
2	Rhyl FC	32	67	35	69
3	Llanelli	32	72	33	63
4	Welshpool	32	54	33	60
5	Connah's	32	49	40	56
6	Port Talbot	32	42	39	51
7	Carmarthen	32	57	50	50
8	Aberystwyth	32	47	37	48
9	Bangor City	32	54	46	48
10	Haverfordwes	32	49	46	39
11	Porthmadog	32	39	51	35
12	Airbus UK	32	40	67	29
13	Cefn Druids	32	41	66	28
14	Caersws	32	34	59	27
15	Caernarfon	32	41	73	26
16	Newtown	32	30	63	24
17	Cwmbran Town	32	36	75	20

TEMPORADA 2005/2006

LIGA GALES
Equipo		PJ	GF	GC	Puntos
1	Saints	34	87	17	86
2	Llanelli	34	64	28	68
3	Rhyl FC	34	65	30	64
4	Carmarthen	34	62	42	57
5	Port Talbot	34	47	30	56
6	Welshpool	34	59	48	54
7	Aberystwyth	34	59	48	52
8	Haverfordwes	34	49	36	50
9	Bangor City	34	51	54	45
10	Caersws	34	44	56	45
11	Porthmadog	34	57	59	44
12	Connah's	34	36	46	38
13	Caernarfon	34	47	55	37
14	Newtown	34	42	61	36
15	Cefn Druids	34	42	58	32
16	Airbus UK	34	35	60	32
17	Cwmbran Town	34	42	73	32
18	Grange Quins	34	23	110	16

Competiciones que juega

Grupo 1

Liga Gales Grupo 1

Pos	Equipos		Pts
1		The New Saints	64
2		Connah's Quay	43
3		Bala Town	40
4		Bangor City	36
5		Cardiff MU	31
6		Carmarthen Town	28
7		Llandudno FC	26
8		Aberystwyth Town	23
9		Rhyl FC	21
10		Cefn Druids AFC	20
11		Newtown	19
12		Airbus UK	15

	Playoff Título : The New Saints, Connah's Quay, Bala Town, Bangor City, Cardiff MU, Carmarthen Town
	Playoff Descenso : Llandudno FC, Aberystwyth Town, Rhyl FC, Cefn Druids AFC, Newtown, Airbus UK

RIVALES EN Copa de Gales

RIVALES EN Copa de la Liga.

RIVALES EN Liga Gales

USO DE MEMORIA

6,534,352 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1619
Total Execution Time	0.1631

CADENA URL

/historico/Airbus-Uk/2017

GET DATOS

$_GET['/historico/Airbus-Uk/2017']

POST DATOS

No hay datos POST existentes

CONSULTAS (53)

0.0032	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 = 'Airbus-Uk' AND l.year = 2017 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=9979 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=9979 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=9979 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=9979 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=9979 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=9979 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0027	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 = 29285
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 = 37803
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 = 33400
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9979 AND type_rel = 2
0.0020	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 9979 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022	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 (21277,1219818) ORDER BY n.cover_points DESC, update_date DESC
0.0029	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 = '9979' AND l.year = 2017 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 = '9979' 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 = 33400 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019	SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 29285 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026	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=9979 AND l.year in (2016,2017,2018) 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 (40059,38811,38726,38427,37803,15735) 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.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 37803 AND teamId = 9979
0.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 38811 AND teamId = 9979
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 15735 AND teamId = 9979
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 38726 AND teamId = 9979
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 40059 AND teamId = 9979
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 38427 AND teamId = 9979
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 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 = 29285 AND t.round = 22 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021	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 = '9979' 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 = '9979' and rp.type = 4
0.0020	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 = '9979' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 events2017 e ON e.player_id = p.id AND e.league_id = 29285 WHERE rp.league_id = 29285 AND rp.teamId = 9979 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.0028	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 events2017 e ON e.player_id = p.id AND e.league_id = 29285 WHERE rp.league_id = 29285 AND rp.teamId = 9979 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2017 e ON e.player_id = p.id AND e.league_id = 29285 WHERE rp.league_id = 29285 AND rp.teamId = 9979 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030	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 = 9979 AND l.year <= 2017 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 29285 AND t.round = 22 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* `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 = 37803 AND t.round = 10 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* `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 = 15497 AND t.round = 22 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* `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 = 20320 AND t.round = 10 ORDER BY team.conference 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* `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 = 29270 AND t.round = 2 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* `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 = 4162 AND t.round = 22 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* `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 = 10087 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2014` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 10412 AND t.round = 10 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* `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 = 2487 AND t.round = 20 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* `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 = 10413 AND t.round = 10 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* `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 = 2032 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* `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 = 10394 AND t.round = 10 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* `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 = 1371 AND t.round = 22 ORDER BY team.conference 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* `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 = 10397 AND t.round = 10 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* `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 = 1084 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 1050 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 249 AND t.round = 34 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 = 10402 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 10401 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 10400 AND t.round = 34 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

Airbus UK

Airbus UK

Selecciona un equipo

Competiciones que juega

Liga Gales Grupo 1

RIVALES EN Copa de Gales

RIVALES EN Copa de la Liga.

RIVALES EN Liga Gales