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

« Temporada Anterior

Temporada 2022

Temporada Siguiente »

2021/2022

Temporada Regular

Primera División Bolivia - Apertura 2022

Primera División Bolivia - Clausura

Primera División Bolivia - Apertura 2022

Ver

TEMPORADA 2021/2022

Equipo		PJ	GF	GC	Puntos
1	Atlético	16	18	21	28
2	Strongest	16	21	11	27
3	Nacional	16	31	24	25
4	Oriente	16	22	22	22
5	Guabirá	16	17	21	19
6	Real Santa.	16	22	28	18
7	Aurora	16	18	21	17
8	Club	16	17	22	16
9	Bolívar	16	42	9	37
10	Blooming	16	27	30	27
11	Royal Pari	16	32	26	23
12	Always Ready	16	24	22	19
13	Universitari	16	18	29	19
14	Jorge	16	16	20	18
15	Independient	16	17	26	18
16	Real	16	14	24	18

Ver

TEMPORADA 2018/2019

Equipo		PJ	GF	GC	Puntos
1	Bolívar	26	66	35	57
2	Strongest	26	55	30	52
3	Nacional	26	44	22	50
4	Blooming	26	55	45	47
5	José Oruro	26	55	44	40
6	Jorge	26	44	37	40
7	Oriente	26	41	43	37
8	Guabirá	26	31	49	31
9	Always Ready	26	50	43	30
10	Real Potosí	26	41	59	27
11	Royal Pari	26	39	55	25
12	Sport Boys.	26	32	51	23
13	Aurora	26	32	52	23
14	Club	26	23	43	22

Ver

TEMPORADA 2017/2018

Equipo		PJ	GF	GC	Puntos
1	Jorge	14	42	13	32
2	Bolívar	14	30	16	25
3	Oriente	14	26	21	20
4	Club	14	22	28	16
5	Real Potosí	14	23	47	13
6	Guabirá	14	23	28	11
7	Club	14	18	29	11
8	José Oruro	14	29	11	31
9	Blooming	14	18	20	23
10	Strongest	14	22	16	22
11	Nacional	14	21	24	18
12	Royal Pari	14	13	19	14
13	Aurora	14	14	21	14
14	Sport Boys.	14	14	22	14

Ver

TEMPORADA 2016/2017

Equipo		PJ	GF	GC	Puntos
1	Strongest	22	44	12	49
2	Bolívar	22	46	21	49
3	Oriente	22	25	31	34
4	Real Potosí	22	33	30	31
5	Blooming	22	24	25	29
6	Jorge	22	28	34	29
7	Nacional	22	41	47	28
8	Sport Boys.	22	27	31	26
9	Club	22	27	37	25
10	José Oruro	22	29	42	24
11	Petrolero	22	20	19	23
12	Guabirá	22	27	42	20

Ver

TEMPORADA 2015/2016

Equipo		PJ	GF	GC	Puntos
1	Sport Boys.	22	36	17	45
2	Bolívar	22	52	36	43
3	Strongest	22	45	26	39
4	Club	22	44	43	36
5	Oriente	22	32	30	34
6	Jorge	22	34	30	33
7	Ciclón	22	31	38	30
8	Blooming	22	32	38	25
9	José Oruro	22	31	37	24
10	Nacional	22	38	48	21
11	Petrolero	22	20	35	19
12	Real Potosí	22	31	48	17

Ver

TEMPORADA 2014/2015

Equipo		PJ	GF	GC	Puntos
1	Bolívar	22	52	23	46
2	Oriente	22	33	18	42
3	Strongest	22	39	26	37
4	Jorge	22	30	25	34
5	José Oruro	22	34	33	34
6	Blooming	22	29	30	31
7	Real Potosí	22	23	28	30
8	Club	22	26	35	29
9	Nacional	22	29	32	26
10	Petrolero	22	27	41	26
11	Sport Boys.	22	21	28	20
12	Universitari	22	18	42	12

Ver

TEMPORADA 2013/2014

Equipo		PJ	GF	GC	Puntos
1	Strongest	26	60	31	57
2	Bolívar	26	65	25	52
3	José Oruro	26	48	37	43
4	Jorge	26	49	42	40
5	Nacional	26	24	26	40
6	Club	26	43	41	36
7	Oriente	26	32	48	36
8	Real Potosí	26	36	42	31
9	Sport Boys.	26	27	34	30
10	Blooming	26	21	46	25
11	Guabirá	26	30	45	23
12	Aurora	26	39	57	18

Ver

TEMPORADA 2012/2013

Equipo		PJ	GF	GC	Puntos
1	Strongest	22	53	31	45
2	José Oruro	22	51	35	41
3	Bolívar	22	46	31	37
4	Blooming	22	29	30	35
5	Real Potosí	22	30	27	32
6	Oriente	22	28	32	31
7	Jorge	22	34	35	28
8	Club	22	31	32	25
9	Nacional	22	26	28	25
10	Petrolero	22	21	30	24
11	Aurora	22	31	47	22
12	La Paz FC	22	28	50	16

Ver

TEMPORADA 2011/2012

Equipo		PJ	GF	GC	Puntos
1	Bolívar	12	22	12	19
2	Club	12	17	14	19
3	Guabirá	12	16	23	19
4	José Oruro	12	10	7	18
5	Real Potosí	12	20	11	17
6	Blooming	12	11	22	10
7	Aurora	12	23	13	24
8	Oriente	12	26	18	23
9	Nacional	12	23	15	16
10	Strongest	12	34	23	15
11	La Paz FC	12	16	29	14
12	Real Mamoré	12	10	41	6

Ver

TEMPORADA 2009/2010

Equipo		PJ	GF	GC	Puntos
1	Strongest	12	22	18	19
2	José Oruro	12	24	19	18
3	Aurora	12	18	17	17
4	Club	12	21	18	16
5	Guabirá	12	15	24	12
6	Blooming	12	13	20	11
7	Bolívar	12	23	11	28
8	Oriente	12	22	10	22
9	Jorge	12	17	17	18
10	Real Potosí	12	11	19	16
11	La Paz FC	12	18	20	14
12	Real Mamoré	12	15	26	12

Ver

TEMPORADA 2008/2009

Equipo		PJ	GF	GC	Puntos
1	Bolívar	22	36	22	40
2	Real Potosí	22	45	31	39
3	José Oruro	22	53	35	35
4	Oriente	22	33	30	35
5	Club	22	38	27	33
6	Strongest	22	36	35	32
7	La Paz FC	22	38	39	32
8	Nacional	22	36	40	28
9	Blooming	22	24	32	27
10	Aurora	22	26	33	26
11	Jorge	22	22	38	17
12	Real Mamoré	22	25	50	17

Ver

TEMPORADA 2007/2008

Equipo		PJ	GF	GC	Puntos
1	Club	22	36	17	43
2	La Paz FC	22	44	30	37
3	José Oruro	22	46	45	36
4	Oriente	22	41	35	33
5	Blooming	22	39	41	31
6	Bolívar	22	41	26	30
7	Aurora	22	33	41	30
8	Strongest	22	41	36	29
9	Real Mamoré	22	27	52	28
10	Jorge	22	41	46	27
11	Real Potosí	22	41	39	25
12	Guabirá	22	26	48	18

Ver

TEMPORADA 2006/2007

Equipo		PJ	GF	GC	Puntos
1	Real Potosí	22	46	25	39
2	Oriente	22	33	30	37
3	La Paz FC	22	31	23	35
4	Jorge	22	29	23	35
5	Bolívar	22	32	37	34
6	Blooming	22	32	35	31
7	Strongest	22	36	40	29
8	Aurora	22	37	34	28
9	José Oruro	22	36	35	28
10	Club	22	28	35	26
11	Club	22	32	32	25
12	Real Mamoré	22	32	55	24

Ver

TEMPORADA 2004/2005

Equipo		PJ	GF	GC	Puntos
1	Bolívar	12	32	13	30
2	Blooming	12	34	13	26
3	José Oruro	12	22	17	22
4	Strongest	12	22	10	21
5	La Paz FC	12	17	18	18
6	Oriente	12	15	17	18
7	Jorge	12	21	13	17
8	Club	12	26	26	16
9	Real Potosí	12	20	19	12
10	Aurora	12	14	15	12
11	Unión	12	14	30	10
12	Iberoamerica	12	6	52	0

Ver

TEMPORADA 2003/2004

Equipo		PJ	GF	GC	Puntos
1	Bolívar	22	51	21	53
2	Aurora	22	42	32	38
3	Jorge	22	40	28	36
4	Real Potosí	22	43	38	33
5	José Oruro	22	35	36	32
6	Oriente	22	43	38	31
7	La Paz FC	22	33	38	31
8	Unión	22	27	29	30
9	Real Santa.	22	28	40	26
10	Strongest	22	31	31	24
11	Blooming	22	28	52	19
12	Iberoamerica	22	23	41	18

Ver

TEMPORADA 2002/2003

Equipo		PJ	GF	GC	Puntos
1	Strongest	22	43	29	46
2	Bolívar	22	54	21	45
3	Jorge	22	43	19	40
4	Oriente	22	51	37	33
5	Real Potosí	22	44	40	31
6	Iberoamerica	22	35	40	30
7	José Oruro	22	29	34	25
8	Aurora	22	35	43	25
9	Unión	22	26	39	25
10	Blooming	22	31	38	24
11	Guabirá	22	21	44	18
12	Independient	22	21	49	18

Ver

TEMPORADA 2001/2002

Equipo		PJ	GF	GC	Puntos
1	Bolívar	22	56	23	49
2	Strongest	22	37	23	42
3	Oriente	22	61	35	39
4	Blooming	22	43	45	37
5	Jorge	22	46	35	35
6	Iberoamerica	22	33	32	32
7	Unión	22	29	34	29
8	Real Potosí	22	46	50	28
9	Guabirá	22	23	44	28
10	Independient	22	26	43	23
11	José Oruro	22	35	40	22
12	Mariscal	22	17	48	12

Ver

TEMPORADA 2000/2001

Equipo		PJ	GF	GC	Puntos
1	Bolívar	22	53	28	42
2	Oriente	22	48	31	42
3	Blooming	22	34	25	36
4	Strongest	22	42	34	34
5	Jorge	22	40	36	33
6	Real Potosí	22	33	34	31
7	Unión	22	27	34	30
8	Independient	22	29	39	27
9	Mariscal	22	31	36	24
10	Guabirá	22	25	35	23
11	Iberoamerica	22	37	47	20
12	Real Santa.	22	23	43	20

Ver

TEMPORADA 1999/2000

Equipo		PJ	GF	GC	Puntos
1	Jorge	22	36	20	44
2	Guabirá	22	39	35	38
3	Bolívar	22	48	37	37
4	Strongest	22	49	28	34
5	Real Potosí	22	31	40	34
6	Independient	22	35	29	33
7	Oriente	22	34	29	33
8	Mariscal	22	38	37	32
9	Blooming	22	33	42	28
10	Pompeya	22	24	49	22
11	Real Santa.	22	31	43	20
12	Unión	22	19	28	19

JUGADORES DESTACADOS

Nombre	Goles	Equipo
F. Suárez	10	OPE
A. Chávez	8	JWI
F. Da Costa	8	BOL
T. Tobar	8	NAC
B. Miranda	7	BOL
H. Dorrego	7	OPE
G. Álvarez	7	ROY
Wesley Tanque	6	CMV
J. Amoroso	6	ROY
J. Correa	5	IND

Equipos de esta liga

USO DE MEMORIA

6,921,608 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.6093
Total Execution Time	0.6112

CADENA URL

/apertura_bolivia2022/grupo1/historico

GET DATOS

$_GET['/apertura_bolivia2022/grupo1/historico']

POST DATOS

No hay datos POST existentes

CONSULTAS (35)

0.0125	SELECT type FROM routes WHERE alias = 'apertura_bolivia2022'
0.0257	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_bolivia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0128	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=40 AND type_rel = 3
0.0168	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 40 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0139	SELECT /53 bs_news_model/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1306003,1302659,1220725,1211419,1210541) ORDER BY n.cover_points DESC, update_date DESC
0.0139	SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 66450 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0140	SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 40 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0136	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 = 66450 AND t.round = 16 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 48663 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 42447 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 33484 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 15422 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 4018 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 3277 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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 = 1525 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143	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 = 2591 AND t.round = 12 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143	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 = 1006 AND t.round = 12 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 1005 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 250 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 13609 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 13604 AND t.round = 12 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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* `tables2004` 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 = 13600 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 27479 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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 = 27482 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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 = 27483 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138	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* `tables2000` 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 = 27487 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 04:02:04' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 04:02:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0132	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 04:02:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0131	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 04:02:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0143	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_bolivia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0178	SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 66450 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66450 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0289	SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 66450 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66450 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0141	SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 66450 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66450 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0142	SELECT ,(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 = 66450 AND t.round = 16 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Nombre	Amarillas	Equipo
M. Avilés	9	IND
L. Maldonado	9	DRT
N. Iribarren	8	BLO
Jesús Sagredo	7	BLO
R. Spenhay	7	BLO
J. Andia	7	NAC
I. Vidaurre	7	CMV
Serginho	7	JWI
A. Quiroga	7	GUA
E. Blanco	7	REA

Nombre	Rojas	Equipo
Ronaldo Sánchez	2	OPE
Jair Torrico	2	AUR
S. Moruno	2	AUR
M. Riquelme	2	REA
L. Maldonado	2	DRT
R. Spenhay	1	BLO
Joel Calicho	1	UDV
V. Galain	1	NAC
P. Rodríguez	1	BOL
J. Andia	1	NAC


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos