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

Tiro Pichon Sub 14

Temporada 2023/2024

TEMPORADA 2023/2024

3ª ANDALUZA MÁLAGA INFANTIL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Mijas	22	64	40	51
2	Pizarra	22	82	26	46
3	Julian	22	65	34	44
4	Marbella	22	47	26	44
5	Tiro Pichon	22	35	23	39
6	Alh. Torre	22	42	27	36
7	Hermanas	22	51	28	35
8	Fuengirola	22	34	34	32
9	Estepona	22	37	67	31
10	Marbella	22	38	44	29
11	Union	22	37	51	29
12	Ath.	22	39	44	19
13	Vazquez	22	25	57	18
14	Campillos	22	22	47	16
15	Atl.	22	26	53	14
16	Alhaurino	22	22	65	13

TEMPORADA 2022/2023

3ª ANDALUZA MÁLAGA INFANTIL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Pedro	30	93	25	80
2	Carlinda	30	110	44	71
3	Esteponense	30	96	46	62
4	Vazquez	30	79	55	51
5	Malaka	30	54	54	46
6	Atl.	30	63	64	45
7	Fuengirola	30	54	55	44
8	Marbella	30	54	51	43
9	Tiro Pichon	30	64	81	39
10	Estepona	30	62	58	38
11	Marbella	30	54	67	38
12	Hermanas	30	66	82	37
13	Puerto Torre	30	74	67	32
14	Atl.	30	82	88	31
15	Albion Elite	30	37	92	18
16	Las Chapas	30	29	142	10

TEMPORADA 2021/2022

2ª ANDALUZA MÁLAGA INFANTIL
Equipo		PJ	GF	GC	Puntos
1	Marbella	29	151	25	83
2	Malaka	29	95	16	81
3	Athletic	29	67	41	54
4	Palo	29	73	53	52
5	Estepona	28	94	55	51
6	Puerto	29	87	49	51
7	Mortadelo	29	65	55	44
8	Lauro	29	85	77	41
9	UD La Mosca	29	64	70	39
10	Tiro Pichon	29	62	64	37
11	Torremolinos	29	69	76	35
12	Atletico	29	57	74	31
13	Fuengirola	29	52	72	30
14	Antequera	29	36	87	20
15	Carlinda	28	23	151	7
16	Ath. Puerta	29	32	147	6

TEMPORADA 2020/2021

1ª ANDALUZA INFANTIL GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Málaga	8	24	10	19
2	Almeria	8	21	16	16
3	Puerto	8	16	13	13
4	UD Maracena	7	16	13	11
5	Tiro Pichon	8	17	16	8
6	Granada	8	10	11	8
7	Cañada	8	10	22	8
8	Atletico	7	5	18	3

TEMPORADA 2019/2020

1ª ANDALUZA INFANTIL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Málaga	23	91	18	62
2	Almeria	23	61	27	52
3	Tiro Pichon	23	39	21	46
4	Ciudad	23	41	24	40
5	Puerto	23	38	29	37
6	Granada	23	34	24	36
7	Cañada	23	35	40	33
8	Marbella	23	44	40	30
9	Santa	23	33	44	27
10	We Sub 14	23	32	48	27
11	Alhaurín	23	37	49	26
12	Pavia	23	36	49	26
13	Atletico	23	30	54	22
14	Ejido 2012	23	35	57	21
15	Real Jaén	23	33	53	20
16	Úbeda Viva	23	21	63	11

TEMPORADA 2018/2019

1ª ANDALUZA INFANTIL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Málaga	30	78	11	84
2	Granada	30	61	18	65
3	We Sub 14	30	46	20	59
4	Tiro Pichon	30	61	36	53
5	Puerto	30	40	23	52
6	Almeria	30	40	28	50
7	Pavia	30	43	25	46
8	Cañada	30	40	24	45
9	Ciudad	30	41	32	43
10	Real Jaén	30	51	53	43
11	Alhaurín	30	40	50	40
12	Úbeda Viva	30	40	54	34
13	Motril	30	42	60	33
14	Natacion	30	22	76	10
15	Antequera	30	13	65	9
16	Huetor Tajar	30	10	93	8

TEMPORADA 2017/2018

1ª ANDALUZA INFANTIL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Málaga	30	134	14	79
2	Almeria	30	110	17	76
3	Granada	30	106	32	68
4	Puerto	30	67	28	59
5	Tiro Pichon	30	68	42	59
6	Cañada	30	50	43	55
7	Ciudad	30	54	57	42
8	We Sub 14	30	29	37	42
9	Pavia	30	29	55	34
10	Motril	30	48	78	30
11	Real Jaén	30	36	72	28
12	Antequera	30	31	94	28
13	Linares	30	32	92	27
14	Maracena A	30	34	63	24
15	Atletico	30	40	77	23
16	Ciudad	30	26	93	18

TEMPORADA 2016/2017

1ª ANDALUZA INFANTIL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Málaga	30	120	32	75
2	Puerto	30	76	25	69
3	Almeria	30	92	24	66
4	Granada	30	64	34	56
5	Real Jaén	30	62	38	56
6	Tiro Pichon	30	39	59	42
7	Atletico	30	62	56	41
8	Motril	30	47	51	41
9	Ciudad	30	35	49	36
10	Cañada	30	41	52	35
11	We Sub 14	30	34	45	35
12	Pavia	30	49	66	33
13	Malaka	30	43	82	33
14	Velez	30	24	47	32
15	Pol.	30	33	78	26
16	Santa	30	17	100	7

TEMPORADA 2015/2016

1ª ANDALUZA INFANTIL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Málaga	30	152	18	82
2	Almeria	30	94	16	70
3	Granada	30	94	37	64
4	Real Jaén	30	68	39	59
5	Puerto	30	78	37	54
6	Cañada	30	60	47	48
7	Tiro Pichon	30	45	52	44
8	Tosiria	30	66	63	42
9	Pol.	30	53	54	41
10	Santa	30	47	40	40
11	Motril	30	49	55	39
12	Velez	30	44	57	36
13	Roquetas	30	42	85	32
14	Fuengirola	30	28	130	15
15	Atlético	30	25	89	12
16	Futbol	30	18	144	5

TEMPORADA 2014/2015

1ª ANDALUZA INFANTIL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Málaga	30	152	13	86
2	Puerto	30	78	21	71
3	Granada	30	87	28	68
4	Almeria	30	80	28	60
5	Real Jaén	30	68	50	52
6	Fuengirola	30	56	45	46
7	Tiro Pichon	30	59	60	41
8	Santa	30	67	61	40
9	Roquetas	30	48	72	39
10	Cañada	30	43	51	37
11	Velez	30	57	51	36
12	Atlético	30	38	56	35
13	U.D.	30	40	88	29
14	Arenas	30	36	51	26
15	Comarca	30	26	145	10
16	Betis	30	10	125	4

TEMPORADA 2013/2014

1ª ANDALUZA INFANTIL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Málaga	30	145	22	85
2	Granada	30	85	35	67
3	Tiro Pichon	30	102	51	64
4	Real Jaén	30	80	47	64
5	Puerto	30	78	41	59
6	Almeria	30	81	46	58
7	Velez	30	66	74	41
8	Santa	30	55	49	38
9	U.D.	30	60	66	37
10	Fuengirola	30	48	67	35
11	Cañada	30	44	59	34
12	Roquetas	30	51	107	32
13	Atletico	30	43	74	26
14	Vera	30	41	124	22
15	Úbeda Viva	30	36	83	14
16	Vazquez	30	24	94	13

Competiciones que juega

Grupo 2

RIVALES EN 3ª Andaluza Mála.

RIVALES EN División de Hono.

USO DE MEMORIA

6,021,840 bytes

BENCHMARKS

Loading Time Base Classes	0.0015
Controller Execution Time ( Home / Category )	0.1508
Total Execution Time	0.1524

CADENA URL

/historico/Cd-Tiro-Pichon-Infantil

GET DATOS

$_GET['/historico/Cd-Tiro-Pichon-Infantil']

POST DATOS

No hay datos POST existentes

CONSULTAS (36)

0.0029	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 = 'Cd-Tiro-Pichon-Infantil' 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=44050 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=44050 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=44050 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0052	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 = 74242
0.0025	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 = 74441
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=44050 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=463 AND type_rel = 3
0.0022	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 = '44050' ORDER BY l.year DESC,cat.coefficient DESC
0.0021	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 = '44050' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0021	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 = '44050' 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 = 74242 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 = 74441 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021	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=44050 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018	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 (74441,74242) 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.0018	SELECT count(id) as num_players from rel_players_base WHERE league_id = 74441 AND teamId = 44050
0.0018	SELECT count(id) as num_players from rel_players_base WHERE league_id = 74242 AND teamId = 44050
0.0019	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 = 74242 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0019	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 = '44050' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019	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 = '44050' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0023	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 = 44050 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_base` 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 = 74441 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* `tables2024_base` 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 = 74242 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.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* `tables2023_base` 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 = 68960 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* `tables2023_base` 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 = 69872 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.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* `tables2022_base` 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 = 64288 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.0040	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_base` 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 = 66760 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.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* `tables2021_base` 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 = 59837 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.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* `tables2021_base` 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 = 62009 AND t.round = 8 ORDER BY team.conference ASC,t.position 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* `tables2020_base` 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 = 52960 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.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* `tables2019_base` 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 = 44969 AND t.round = 30 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* `tables2018_base` 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 = 39446 AND t.round = 30 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* `tables2017_base` 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 = 34416 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0043	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_base` 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 = 17538 AND t.round = 30 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 = 4396 AND t.round = 30 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* `tables2014_base` 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 = 3063 AND t.round = 30 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

Tiro Pichon Sub 14

Tiro Pichon Sub 14

Selecciona un equipo

Competiciones que juega

RIVALES EN 3ª Andaluza Mála.

RIVALES EN División de Hono.