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

UCV

Temporada 2023/2024

TEMPORADA 2023/2024

APERTURA VENEZUELA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Metropolitan	2	2	0	4
2	UCV	2	2	0	4
3	La Guaira	2	2	3	3
4	Inter	2	1	4	0
5	Carabobo	2	3	2	4
6	Angostura	2	2	2	2
7	Puerto	2	2	2	2
8	Portuguesa	2	2	3	1

TEMPORADA 2022/2023

PRIMERA DIVISIÓN VENEZUELA
Equipo		PJ	GF	GC	Puntos
1	Deportivo	28	47	17	64
2	Puerto	28	49	19	60
3	Portuguesa	28	32	26	46
4	Caracas	28	44	27	45
5	Carabobo	28	35	21	45
6	La Guaira	28	37	33	39
7	Metropolitan	28	37	37	39
8	Rayo Zuliano	28	33	39	36
9	Estudiantes	28	39	41	33
10	Angostura	28	32	41	30
11	Monagas	28	29	41	30
12	Zamora FC	28	31	50	30
13	UCV	28	27	36	27
14	Inter	28	25	37	24
15	Mineros	28	25	57	20

TEMPORADA 2021/2022

PRIMERA DIVISIÓN VENEZUELA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Zamora FC	30	44	24	55
2	Metropolitan	30	44	29	53
3	Monagas	30	46	33	48
4	Carabobo	30	36	22	46
5	La Guaira	30	46	42	46
6	Deportivo	30	38	33	44
7	Puerto	30	38	41	41
8	Inter	30	39	38	40
9	Estudiantes	30	38	37	39
10	Portuguesa	30	26	27	37
11	Caracas	30	34	36	36
12	Deportivo	30	32	36	36
13	Mineros	30	43	54	34
14	Zulia FC	30	29	43	32
15	UCV	30	19	40	27
16	Aragua FC	30	32	49	24

TEMPORADA 2020/2021

PRIMERA DIVISIÓN VENEZUELA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	La Guaira	24	33	22	38
2	Deportivo	24	42	30	34
3	Puerto	24	24	21	34
4	Aragua FC	24	22	25	33
5	Gran	24	25	32	33
6	Carabobo	24	28	28	31
7	Yaracuyanos	24	16	32	20
8	Deportivo	24	49	22	49
9	Estudiantes	24	39	25	42
10	Portuguesa	24	32	21	39
11	Inter	24	43	35	36
12	Zamora FC	24	36	30	32
13	Zulia FC	24	37	32	31
14	Trujillanos	24	8	79	1
15	Caracas	24	50	27	48
16	Monagas	24	44	27	45
17	Metropolitan	24	42	31	35
18	Venezuela	24	36	38	34
19	UCV	24	32	30	31
20	Mineros	24	25	33	29
21	LALA	24	15	58	9

TEMPORADA 2019/2020

CLAUSURA SEGUNDA DIVISIÓN VENEZUELA
Equipo		PJ	GF	GC	Puntos
1	Ureña	10	16	7	23
2	Inter	10	21	12	20
3	ULA Mérida	10	16	16	15
4	Atlético	10	14	16	11
5	Deportivo	10	12	16	11
6	Real	10	12	24	4
7	Llaneros	10	14	8	21
8	UCV	10	10	4	19
9	Yaracuy	10	10	9	13
10	Academia	10	7	8	12
11	Angostura	10	6	9	8
12	Fundación	10	6	15	5

TEMPORADA 2018/2019

CLAUSURA SEGUNDA DIVISIÓN VENEZUELA
Equipo		PJ	GF	GC	Puntos
1	Atl. Furrial	10	16	8	20
2	Yaracuyanos	10	18	8	19
3	Deportivo	10	12	11	17
4	Yaracuy	10	14	12	16
5	Libertador	10	7	14	7
6	Gran	10	10	24	7
7	Titanes FC	12	25	17	26
8	Atlético	12	25	12	24
9	Inter	12	23	19	21
10	Real	12	22	19	17
11	Deportivo	12	33	31	14
12	ULA Mérida	12	19	28	10
13	Ureña	12	8	29	5
14	Angostura	12	26	11	25
15	Petroleros	12	20	10	25
16	UCV	12	14	8	22
17	Fundación	12	14	18	16
18	Ciudad	12	8	13	10
19	Dynamo	12	9	20	9
20	Chicó	12	10	21	8

TEMPORADA 2017/2018

CLAUSURA SEGUNDA DIVISIÓN VENEZUELA
Equipo		PJ	GF	GC	Puntos
1	Margarita	20	33	25	38
2	LALA	20	27	19	37
3	Gran	20	24	21	32
4	Angostura	20	24	17	31
5	Chicó	20	22	20	31
6	Yaracuy	20	38	31	30
7	Atl. Furrial	20	19	20	23
8	Petroleros	20	25	28	23
9	Libertador	20	21	31	23
10	Deportivo	20	18	25	21
11	UCV	20	18	32	17
12	ULA Mérida	18	36	21	36
13	Llaneros	18	27	20	34
14	Ureña	18	45	28	33
15	Titanes FC	18	25	17	28
16	Real	18	28	25	26
17	Inter	18	24	25	22
18	Atlético	18	26	28	21
19	Deportivo	18	23	33	20
20	Yaracuyanos	18	22	37	12
21	Falcon	18	20	42	10

TEMPORADA 2016/2017

TRANSICIÓN SEGUNDA VENEZUELA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Gran	28	38	28	49
2	UCV	28	36	23	45
3	Puerto	28	39	33	43
4	Falcon	28	40	41	41
5	Yaracuyanos	28	31	35	41
6	Caracas II	28	29	29	38
7	Yaracuy	28	38	48	33
8	Deportivo	28	23	37	25

TEMPORADA 2015/2016

APERTURA SEGUNDA DIVISIÓN VENEZUELA
Equipo		PJ	GF	GC	Puntos
1	Puerto	28	59	36	53
2	Yaracuyanos	28	39	24	47
3	UCV	28	35	26	45
4	Caracas II	28	33	29	37
5	Tucanes FC	28	26	36	35
6	Atlético	28	34	34	33
7	Gran	28	34	51	29
8	Arroceros	28	28	52	21
9	Atlético	28	61	22	65
10	Atlético	28	44	28	55
11	Falcon	28	58	34	53
12	Zamora II	28	43	38	39
13	Titanes FC	28	42	50	35
14	Real	28	27	32	30
15	Potros	28	38	45	29
16	Policia Lara	28	9	73	9
17	Metropolitan	28	48	25	55
18	Petroleros	28	48	23	50
19	LALA	28	42	25	49
20	Angostura	28	45	40	46
21	Chicó	28	44	54	36
22	Margarita	28	39	51	34
23	Deportivo	28	33	45	26
24	Mineros	28	23	59	16

TEMPORADA 2014/2015

TRANSICIÓN SEGUNDA VENEZUELA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Monagas	10	23	5	25
2	Deportivo	10	14	7	17
3	UCV	10	15	11	17
4	Atlético	10	11	12	14
5	Puerto	10	13	13	9
6	Chicó	10	10	38	3

TEMPORADA 2013/2014

CLAUSURA SEGUNDA DIVISIÓN VENEZUELA
Equipo		PJ	GF	GC	Puntos
1	Portuguesa	18	24	9	38
2	Metropolitan	18	36	14	34
3	Zamora II	18	29	20	29
4	Falcon	18	19	15	26
5	Gran	18	28	20	25
6	Arroceros	18	16	17	25
7	Guatire	18	19	18	22
8	Angostura	18	19	28	21
9	Mineros	18	21	32	21
10	UCV	18	14	52	5

TEMPORADA 2012/2013

APERTURA SEGUNDA DIVISIÓN VENEZUELA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Real	18	34	23	36
2	Guatire	18	27	21	31
3	Mineros	18	35	24	28
4	Tucanes FC	17	22	16	28
5	Caracas II	18	31	33	28
6	Estrella	18	18	15	25
7	Arroceros	18	34	34	23
8	Angostura	18	33	37	21
9	UCV	17	23	33	20
10	Monagas II	18	17	38	5

Competiciones que juega

Grupo 1

Apertura Venezuela Grupo 2

Pos	Equipos		Pts
1		Metropolitanos	4
2		UCV	4
3		Carabobo	4
4		La Guaira	3
5		Angostura	2
6		Puerto Cabello	2
7		Portuguesa FC	1
8		Inter De Barinas	0

	Siguiente Ronda : Metropolitanos

RIVALES EN Apertura Venezue.

USO DE MEMORIA

6,160,272 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.6036
Total Execution Time	0.6048

CADENA URL

/historico/Ucv

GET DATOS

$_GET['/historico/Ucv']

POST DATOS

No hay datos POST existentes

CONSULTAS (39)

0.0136	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 = 'Ucv' 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.0125	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=11653 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=11653 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=11653 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=11653 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=11653 AND type_rel = 2
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=113 AND type_rel = 3
0.0131	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 113 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0127	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 (983658,982611,952759,912282,888297) ORDER BY n.cover_points DESC, update_date DESC
0.0130	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 = '11653' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0129	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 = '11653' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0129	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=11653 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126	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 (75910,71432,70807) 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.0126	SELECT count(id) as num_players from rel_players WHERE league_id = 75910 AND teamId = 11653
0.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 70807 AND teamId = 11653
0.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 11653
0.0136	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 75910 WHERE rp.league_id = 75910 AND rp.teamId = 11653 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.0130	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 75910 WHERE rp.league_id = 75910 AND rp.teamId = 11653 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0127	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 75910 WHERE rp.league_id = 75910 AND rp.teamId = 11653 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130	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 = 11653 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 75089 AND t.round = 13 ORDER BY team.conference ASC,t.position 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* `tables2023` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 70807 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.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* `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 = 66566 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.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* `tables2021` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 61656 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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* `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 = 55451 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127	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 = 59975 AND t.round = 10 ORDER BY team.conference ASC,t.position 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* `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 = 48931 AND t.round = 14 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* `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 = 50191 AND t.round = 14 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* `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 = 42703 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* `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 = 44558 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* `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 = 41145 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127	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 = 37783 AND t.round = 28 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* `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 = 15537 AND t.round = 28 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* `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 = 4182 AND t.round = 18 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* `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 = 16468 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127	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 = 19412 AND t.round = 10 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* `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 = 3284 AND t.round = 18 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* `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 = 3218 AND t.round = 18 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* `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 = 14654 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

UCV

UCV

Selecciona un equipo

Competiciones que juega

Apertura Venezuela Grupo 2

RIVALES EN Apertura Venezue.