4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2000
Temporada Siguiente »
Publicidad 600x120.gif
Clausura Venezuela 2000
1999/2000

Clausura Venezuela 2000

  • Apertura Venezuela:
Información Histórica 
						Clausura
========

Table:

 1.Deportivo Táchira      22 14  6  2  40-13  48 
 2.Deportivo ItalChacao   22 13  4  5  35-18  43  [Caracas]
 3.Caracas FC             22 12  6  4  38-19  42
 4.Carabobo FC            21 10  6  5  24-15  36
 5.Estudiantes de Mérida  22 10  4  8  30-29  34
 6.ULA                    22  9  2 11  28-26  29  [Mérida]
 7.Mineros de Guayana     22  7  4 11  26-33  25
 8.Zulianos FC            21  5  8  8  24-33  23  [Maracaibo]
 9.El Vigía FC            22  5  6 11  25-36  21
10.Llaneros Guanaré       22  5  6 11  25-45  21
11.Nacional Táchira       22  4  8 10  17-31  20
12.Deportivo Trujillanos  22  4  6 12  21-35  18

Round 1 
(Jan 23)  
Trujillanos    0-0 Zulianos  
Caracas        1-0 ULA  
Estudiantes    1-0 Nacional  
Carabobo       3-0 Mineros  
(Jan 26)
Llaneros      0-10 ItalChacao
(Mar 8)
Tachira        awd El Vigia    [awarded 3-0] 

Round 2 
(Jan 30)
Nacional       1-2 Caracas  
Mineros        2-0 Llaneros  
ULA            2-1 Trujillanos  
Carabobo       2-2 Estudiantes  
ItalChacao     2-1 Tachira  
(Feb 16)
Zulianos       1-1 El Vigía

Round 3 (Feb 3)
Caracas        1-2 Estudiantes  
Zulianos       0-0 Llaneros  
Tachira        1-0 Carabobo 
Trujillanos    2-1 Mineros  
El Vigia       2-0 Nacional  
ULA            0-1 ItalChacao

Round 4 (Feb 6)
Llaneros       0-1 Estudiantes  
Trujillanos    2-1 Nacional  
ULA            3-0 Zulianos  
El Vigía       2-1 ItalChacao  
Tachira        2-0 Mineros  
Caracas        3-0 Carabobo

Round 5 (Feb 9) 
Estudiantes    1-1 Tachira  
ItalChacao     1-0 Zulianos  
Nacional       1-1 ULA  
Mineros        4-2 El Vigia  
Carabobo       0-0 Trujillanos  
Llaneros       0-3 Caracas

Round 6 (Feb 13)
Zulianos       1-2 Nacional  
ItalChacao     0-0 Mineros  
ULA            3-0 Carabobo  
El Vigia       0-1 Estudiantes  
Tachira        2-0 Caracas  
Trujillanos    0-0 Llaneros
  
Round 7 (Feb 20)
Mineros        0-0 Zulianos  
Caracas        2-0 El Vigia  
Estudiantes    0-1 ItalChacao
Carabobo       3-0 Nacional  
Llaneros       2-1 ULA  
Tachira        1-0 Trujillanos

Round 8 (Feb 23)
Zulianos       0-1 Carabobo  
Mineros        3-1 Estudiantes  
Nacional       2-1 Llaneros
ULA            0-2 Tachira  
El Vigia       4-3 Trujillanos  
ItalChacao     2-1 Caracas

Round 9 (Feb 27)
Estudiantes    4-1 Zulianos  
Llaneros       1-0 Carabobo 
Caracas        1-0 Mineros
Tachira        1-1 Nacional  
Trujillanos    1-2 ItalChacao  
El Vigia       1-2 ULA

Round 10 (Mar 1)      
Zulianos       0-2 Tachira  
Trujillanos    2-2 Caracas  
El Vigia       4-3 Llaneros
ULA            2-3 Estudiantes  
ItalChacao     0-0 Carabobo  
Nacional       1-1 Mineros

Round 11 (Mar 5)
Llaneros       2-2 Tachira  
Carabobo       2-1 El Vigia  
Mineros        1-0 ULA
Nacional       0-0 ItalChacao  
Caracas        2-2 Zulianos  
Estudiantes    1-0 Trujillanos

Round 12 (Mar 12)
ULA            1-1 Caracas  
Zulianos       2-1 Trujillanos  
Mineros        0-2 Carabobo  
Nacional       1-1 Estudiantes  
ItalChacao     3-0 Llaneros  
El Vigia       1-1 Tachira

Round 13 (Mar 19)
El Vigia       1-1 Zulianos 
Trujillanos    1-0 ULA 
Tachira        1-1 Italchacao
Caracas        1-1 Nacional 
Llaneros       3-2 Mineros 
Estudiantes    0-1 Carabobo

Round 14 (Mar 22)
Estudiantes    0-1 Caracas 
Mineros        1-1 Trujillanos 
Llaneros       2-2 Zulianos
Carabobo       0-0 Tachira 
Nacional       0-0 El Vigia 
Italchacao     1-0 ULA

Round 15 (Mar 26)
Zulianos       1-0 ULA 
Italchacao     1-0 El Vigia 
Nacional       1-0 Trujillanos
Mineros        1-2 Tachira 
Carabobo       0-0 Caracas 
Estudiantes    0-0 Llaneros

Round 16 (Apr 2)
Zulianos       3-1 Italchacao 
ULA            1-0 Nacional 
El Vigia       1-2 Mineros
Trujillanos    0-3 Carabobo 
Tachira        3-0 Estudiantes 
Caracas        3-1 Llaneros

Round 17 (Apr 9)
Nacional       2-1 Zulianos 
Mineros        2-1 Italchacao 
Carabobo       0-1 ULA
Estudiantes    2-0 El Vigia 
Llaneros       4-2 Trujillanos 
Caracas        2-0 Tachira

Round 18 (Apr 16)
Zulianos       4-3 Mineros 
Nacional       2-2 Carabobo 
Italchacao     3-2 Estudiantes
ULA            3-0 Llaneros 
El Vigia       3-1 Caracas 
Trujillanos    0-3 Tachira

Round 19 (Apr 19)
Carabobo       ppd Zulianos 
Estudiantes    2-1 Mineros 
Llaneros       5-1 Nacional
Caracas        3-0 Italchacao 
Tachira        3-0 ULA 
Trujillanos    0-0 El Vigia

Round 20 (Apr 30)
Italchacao     awd Trujillanos [awarded 1-0] 
Nacional       0-2 Tachira 
Mineros        0-2 Caracas 
Zulianos       2-1 Estudiantes 
ULA            3-1 El Vigia
Carabobo       1-0 Llaneros

Round 21 (May 3) 
Tachira        5-2 Zulianos 
Caracas        5-1 Trujillanos 
Llaneros       1-1 El Vigia 
Estudiantes    4-2 ULA 
Carabobo       2-1 Italchacao 
Mineros        1-0 Nacional

Round 22 (May 7)
Italchacao     2-0 Nacional 
Tachira        2-0 Llaneros 
Zulianos       1-1 Caracas 
El Vigia       0-2 Carabobo 
Trujillanos    4-1 Estudiantes 
ULA            3-1 Mineros
 
Table:

 1.Deportivo Táchira      22 14  6  2  40-13  48 
 2.Deportivo ItalChacao   22 13  4  5  35-18  43  [Caracas]
 3.Caracas FC             22 12  6  4  38-19  42
 4.Carabobo FC            21 10  6  5  24-15  36
 5.Estudiantes de Mérida  22 10  4  8  30-29  34
 6.ULA                    22  9  2 11  28-26  29  [Mérida]
 7.Mineros de Guayana     22  7  4 11  26-33  25
 8.Zulianos FC            21  5  8  8  24-33  23  [Maracaibo]
 9.El Vigía FC            22  5  6 11  25-36  21
10.Llaneros Guanaré       22  5  6 11  25-45  21
11.Nacional Táchira       22  4  8 10  17-31  20
12.Deportivo Trujillanos  22  4  6 12  21-35  18

Deportivo Táchira won Clausura

Aggregate Table: 

 1.Deportivo Táchira      44 27 13  4  76-32  94
 2.Deportivo ItalChacao   44 24 12  8  67-36  84  [Caracas]
 3.Estudiantes de Mérida  44 23  8 13  80-53  77
 4.Caracas FC             44 21 14  9  79-52  77
 5.ULA                    44 16  8 20  62-63  56  [Mérida] 
 6.Mineros de Guayana     44 15 10 19  57-66  55
 7.Carabobo FC            43 14 13 16  47-56  55
 8.Zulianos FC            43 12 15 16  59-60  51  [Maracaibo]
 9.Deportivo Trujillanos  44 11 14 19  52-63  47
10.El Vigía FC            44 11 10 23  57-87  43
11.Nacional Táchira       44  9 15 20  36-67  42
12.Llaneros Guanaré       44  7 15 22  53-90  36

Championship Playoff

Final Table:
 
 1.Deportivo Táchira       6  4  1  1   7- 3  15  Champions  [*]
 2.Deportivo ItalChacao    6  1  4  1   4- 4   7  [Caracas]
 3.Estudiantes de Mérida   6  1  3  2   5- 6   6
 4.Caracas FC              6  0  4  2   5- 8   4

[*] Deportivo Táchira have 2 bonus points as winners of Apertura and Clausura

Round 1 (May 14)
Tachira        1-0 Estudiantes 
Caracas        0-0 Italchacao

Round 2 (May 17)
Italchacao     0-1 Tachira 
Estudiantes    2-2 Caracas

Round 3 (May 21)
Italchacao     2-1 Estudiantes 
Tachira        2-1 Caracas

Round 4 (May 24)
Estudiantes    1-0 Tachira
Italchacao     1-1 Caracas

Round 5 (May 28)
Caracas        1-1 Estudiantes
Tachira        1-1 Italchacao

Round 6 (Jun 18)
Caracas        0-2 Tachira
Estudiantes    0-0 Italchacao

Final Table:
 
 1.Deportivo Táchira       6  4  1  1   7- 3  15  Champions  [*]
 2.Deportivo ItalChacao    6  1  4  1   4- 4   7  [Caracas]
 3.Estudiantes de Mérida   6  1  3  2   5- 6   6
 4.Caracas FC              6  0  4  2   5- 8   4

[*] Deportivo Táchira have 2 bonus points as winners of Apertura and Clausura

Author: Roberto Lahsen
(rlahsen@entelchile.net)

Last updated: 27 Oct 2000

(C) Copyright Roberto Lahsen and RSSSF
1999/2000


  USO DE MEMORIA  
4,249,120 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1288
Total Execution Time  0.1306
  CADENA URL  
/clausura_venezuela2000
  GET DATOS  
$_GET['/clausura_venezuela2000']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0018  SELECT type FROM routes WHERE alias = 'clausura_venezuela2000'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clausura_venezuela' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2000 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0022  SELECT text_es as historical_text FROM leagues_text WHERE id=1703
0.0019  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 = 29970 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027  SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=113 ORDER BY l.group_code ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 14:11:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-01 14:11:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-01 14:11:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-01 14:11:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clausura_venezuela' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2000 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0021  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 131 AND l.year = 2000
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (29970) AND (e.action IN (1,2,11,12,13) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0025  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (29970) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 131 AND l.year = 2000
0.0021  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (29970) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0018  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (29970) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0021  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 131 AND l.year = 2000
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (29970) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0169  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (29970) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0121  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 131 AND l.year = 2000
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (29970) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0018  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (29970) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  SELECT SUM(rp.lineup) 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,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.category_id = 131 AND rp.year = 2000 AND rp.lineup > 0 GROUP BY p.id ORDER BY total DESC,p.pod DESC LIMIT 20
0.0018  SELECT SUM(rp.events) 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,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.category_id = 131 AND rp.year = 2000 AND rp.events > 0 GROUP BY p.id ORDER BY total DESC,p.pod DESC LIMIT 20
0.0024  SELECT rel.media_id, rel.team1, rel.team2, m.name, m.type, m.lang, m.location, rel.id AS rel_id, m.url FROM rel_media_match AS rel INNER JOIN media AS m ON m.id=rel.media_id WHERE (m.lang='es' OR m.language='spanish') AND rel.active=1 AND rel.league_id=29970 AND rel.round=22
0.0020  SELECT u.id,u.user_name, esl.points,up.name,up.surname,up.nick,u.changeA FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 29970 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0019  SELECT count(esl.user_id) as cuenta FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 29970 AND esl.points > 0
0.0020  SELECT fau.user_name, c.*, NOW() as difference_time,creation_date FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id LEFT JOIN fa_user fau ON fau.id = c.author_id WHERE c.creation_date > "2024-04-01" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 29970 ORDER BY creation_date DESC LIMIT 0, 10
0.0023  SELECT count(c.id) as cuenta FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id WHERE c.creation_date > "2024-04-01" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 29970
0.0020  SELECT c.isVideo, c.id,c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars2000` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 29970 AND c.`round` = 22 ORDER BY shedule ASC LIMIT 200
0.0018  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2000` e INNER JOIN calendars2000 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 22 AND e.real_date IS NOT NULL AND e.league_id = 29970 ORDER BY total DESC LIMIT 40
0.0020  SELECT c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2000` e INNER JOIN calendars2000 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.show_on = 1 AND e.real_date IS NOT NULL AND e.league_id = 29970 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
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 `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 = 29970 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  SELECT *,(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 = 29970 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 c.id, 2024 AS year, IF(l.tables = 1 AND t1.points>0,((t1.points / (l.current_round * 3)) + (t2.points / (l.current_round * 3)))/2 * ct.coefficient,0.7 * ct.coefficient) as fcoef FROM `calendars2024` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` LEFT JOIN tables2024 AS t1 ON t1.team = c.team1 AND t1.round = l.current_round LEFT JOIN tables2024 AS t2 ON t2.team = c.team2 AND t2.round = l.current_round WHERE c.`shedule` > '2024-05-01 00:00:00' AND c.`shedule` < '2024-05-05 23:59:59' AND l.id = 29970 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0021  SELECT data1, data2 FROM services_tags WHERE categoryId=131
0.0021  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 131 AND l.year = 2000 ORDER BY l.group_code ASC
0.0021  SELECT group_code, extraName from `leagues` WHERE categoryId=131 AND year=2000