4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Información Histórica 
						Final Table:

 1.Caracas FC         30  15  11   4   43-24   43    (*)  [Caracas]
 2.Trujillanos FC     30  14  11   5   53-29   40.25 (*)  [Valera]
 3.Minerven FC        30  15   8   7   53-34   39.75 (*)  [El Callao]
 4.UA Tachira FC      30  12  10   8   41-30   35.50 (*)  [San Cristobal]
 5.AD Mineros Guayana 30  12  10   8   48-34   34         [Ciudad Guayana]
 6.Deportivo Italia   30  12   8  10   43-37   32         [Caracas]
 7.Estudiantes FC     30  12   8  10   43-41   32         [Merida]
 8.Maritimo FC        30  12   5  13   44-37   29         [Caracas]
 9.Llaneros FC        30   9  11  10   31-31   29         [Guanare]
10.El Vigia FC        30  11   7  12   43-49   29         [El Vigia]
11.Univ. de los Andes 30   8  12  10   39-47   28         [Merida]
12.Monagas SC         30   9  10  11   39-47   28         [Maturin]
13.Maracaibo FC       30   8  10  12   33-56   26         [Maracaibo]
14.Valencia FC        30  10   5  15   24-37   25         [Valencia]
15.Atletico Zamora    30   6  12  12   24-35   24         [Barinas]
16.Anzoategui         30   3   6  21   33-66   12         [Puerto La Cruz]

(*) Bonus points from Copa Venezuela: 
    Caracas 2, Minerven 1.75, UA Tachira 1.5, Trujillanos 1.25.

NB: table not completely consistent with known scores

Round 1
Anzoategui        1-2 Estudiantes      
Atletico Zamora   2-1 Maracaibo         
El Vigia          2-2 Llaneros           
Maritimo          2-1 UD Tachira       
Mineros           4-0 Monagas           
Minerven          2-3 Deportivo Italia  
Trujillanos       1-1 Caracas            
Univ de Los Andes 0-3 Valencia          

Round 2
Caracas           0-0 Atletico Zamora  
Llaneros          1-0 Maritimo           
Maracaibo         1-1 Deportivo Italia  
Minerven          3-1 Mineros           
Monagas           1-4 El Vigia       
UD Tachira        4-0 Estudiantes       
Univ de Los Andes 2-1 Anzoategui         
Valencia          0-1 Trujillanos        

Round 3
Atletico Zamora   1-1 Valencia           
Deportivo Italia  3-0 Caracas             
El Vigia          0-0 Minerven           
Estudiantes       1-0 Llaneros            
Maritimo          3-2 Monagas            
Mineros           8-0 Maracaibo         
Trujillanos       4-0 Univ de Los Andes  
UD Tachira        1-1 Anzoategui        

Round 4
Caracas           3-0 Mineros            
Llaneros          1-0 UD Tachira       
Maracaibo         2-2 El Vigia           
Minerven          1-1 Maritimo           
Monagas           6-3 Estudiantes         
Trujillanos       2-0 Anzoategui         
Univ de Los Andes 2-1 Atletico Zamora    
Valencia          1-2 Deportivo Italia   

Round 5
Anzoategui        0-4 Llaneros           
Atletico Zamora   1-1 Trujillanos     
Deportivo Italia  2-0 Univ de Los Andes 
El Vigia          0-1 Caracas      
Estudiantes       4-1 Minerven        
Maritimo          3-0 Maracaibo       
Mineros           1-0 Valencia       
UD Tachira        1-0 Monagas         

Round 6
Atletico Zamora   3-1 Anzoategui          
Caracas           4-1 Maritimo            
Maracaibo         2-1 Estudiantes        
Minerven          0-1 UD Tachira       
Monagas           4-1 Llaneros            
Trujillanos       6-1 Deportivo Italia    
Univ de Los Andes 1-1 Mineros              
Valencia          1-0 El Vigia            

Round 7
Anzoategui        0-0 Monagas             
Deportivo Italia  0-0 Atletico Zamora     
El Vigia          2-1 Univ de Los Andes 
Estudiantes       1-1 Caracas            
Llaneros          2-2 Minerven          
Maritimo          3-0 Valencia           
Mineros           2-2 Trujillanos      
UD Tachira        1-1 Maracaibo     

Round 8
Atletico Zamora   0-1 Mineros            
Caracas           2-1 UD Tachira        
Deportivo Italia  2-0 Anzoategui          
Maracaibo         1-0 Llaneros           
Minerven          2-1 Monagas           
Trujillanos       1-0 El Vigia         
Univ de Los Andes 3-2 Maritimo           
Valencia          2-1 Estudiantes        

Round 9
Anzoategui        1-2 Minerven      
El Vigia          2-0 Atletico Zamora  
Estudiantes       1-3 Univ de Los Andes    
Llaneros          0-2 Caracas             
Maritimo          2-1 Trujillanos         
Mineros           4-1 Deportivo Italia    
Monagas           4-2 Maracaibo         
UD Tachira        1-0 Valencia           

Round 10
Caracas           1-1 Monagas        
Deportivo Italia  3-0 El Vigia          
Maracaibo         1-1 Minerven          
Maritimo          0-0 Atletico Zamora      
Mineros           3-1 Anzoategui           
Trujillanos       1-2 Estudiantes     
Univ de Los Andes 0-0 UD Tachira     
Valencia          1-0 Llaneros          

Round 11 
Estudiantes        -  Atletico Zamora 
Minerven           -  Caracas           
Univ de Los Andes  -  Llaneros  
Anzoategui         -  Maracaibo
Deportivo Italia   -  Maritimo
El Vigia           -  Mineros
Valencia           -  Monagas 
UD Tachira         -  Trujillanos

Round 12
Mineros Guayana   1-0 Maritimo         
Atletico Zamora   1-1 UD Tachira      
Caracas           5-1 Maracaibo        
Deportivo Italia  1-0 Estudiantes      
El Vigia          4-1 Anzoategui           
Trujillanos       1-1 Llaneros            
Univ de Los Andes 0-1 Monagas              
Valencia          1-0 Minerven            

Round 13
Anzoategui        2-2 Caracas          
Estudiantes       2-0 AD Mineros Guayana  
Llaneros          1-1 Atletico Zamora     
Maracaibo         1-0 Valencia           
Maritimo          1-2 El Vigia           
Minerven          2-1 Univ de Los Andes  
Monagas           2-2 Trujillanos        
UD Tachira        1-5 Deportivo Italia  

Round 14
Mineros Guayana   0-2 UD Tachira       
Atletico Zamora   0-1 Monagas          
Deportivo Italia  0-2 Llaneros            
El Vigia          1-0 Estudiantes     
Maritimo          4-3 Anzoategui         
Trujillanos       2-0 Minerven            
Univ de Los Andes 5-1 Maracaibo       
Valencia          0-2 Caracas           

Moved Match Round 22
Minerven          3-1 Llaneros        

Moved Match Round 20
Minerven          1-0 Estudiantes     

Round 15
Anzoategui        1-0 Valencia         
Caracas           1-2 Univ de Los Andes   
Estudiantes       2-1 Maritimo            
Llaneros          1-1 AD Mineros Guayana  
Maracaibo         1-1 Trujillanos        
Minerven          3-1 Atletico Zamora     
Monagas           0-0 Deportivo Italia    
UD Tachira        1-0 El Vigia          

Round 16
Caracas           2-1 Trujillanos        
Estudiantes       3-0 Anzoategui       
Llaneros          1-1 El Vigia            
Maracaibo         0-0 Atletico Zamora    
Minerven          2-3 Deportivo Italia     
Monagas           0-2 Mineros           
UD Tachira        0-1 Maritimo             
Valencia          0-0 Univ de Los Andes   

Round 17
Anzoategui        3-3 Univ de Los Andes    
Atletico Zamora   0-1 Caracas              
Deportivo Italia  2-0 Maracaibo          
El Vigia          0-0 Mineros          
Estudiantes       2-1 UD Tachira         
Maritimo          3-0 Llaneros            
Monagas           1-1 Minerven           
Trujillanos       3-0 Valencia           

Round 18
Caracas           1-0 Deportivo Italia    
Llaneros          0-2 Estudiantes        
Maracaibo         1-1 Mineros             
Minerven          3-0 El Vigia            
Monagas           0-3 Maritimo           
UD Tachira        1-1 Anzoategui          
Univ de Los Andes 2-2 Trujillanos          
Valencia          2-1 Atletico Zamora   

Round 19
Anzoategui        2-3 Trujillanos        
Atletico Zamora   2-2 Univ de Los Andes 
Deportivo Italia  0-0 Valencia          
El Vigia          1-0 Maracaibo          
Estudiantes       0-0 Monagas              
Maritimo          3-0 Minerven            
Mineros           0-0 Caracas             
UD Tachira        0-0 Llaneros         

Round 20
Caracas           3-1 El Vigia           
Llaneros          3-1 Anzoategui       
Maracaibo         0-0 Maritimo          
Monagas           0-0 UD Tachira      
Trujillanos       2-1 Atletico Zamora  
Univ de Los Andes 0-1 Deportivo Italia 
Valencia          2-1 Mineros           

Round 21
Anzoategui        1-1 Atletico Zamora 
Deportivo Italia  0-0 Trujillanos         
El Vigia          1-0 Valencia            
Estudiantes       1-1 Maracaibo          
Llaneros          1-1 Monagas             
Maritimo          1-1 Caracas            
Mineros           0-0 Univ de Los Andes   
UD Tachira        3-0 Minerven            

Round 22
Atletico Zamora   1-0 Deportivo Italia 
Caracas           2-0 Estudiantes         
Maracaibo         4-2 UD Tachira        
Monagas           2-0 Anzoategui   
Trujillanos       1-0 Mineros          
Valencia          1-0 Maritimo          
Univ de Los Andes  -  El Vigia 

Round 23
Anzoategui        2-2 Deportivo Italia   
El Vigia          1-2 Trujillanos         
Estudiantes       1-1 Valencia             
Llaneros          1-0 Maracaibo           
Maritimo          2-0 Univ de Los Andes   
Mineros           3-1 Atletico Zamora   
Minerven          2-1 Monagas            
UD Tachira        1-1 Caracas         

Round 24
Atletico Zamora   2-1 El Vigia         
Caracas           1-0 Llaneros            
Deportivo Italia  2-0 Mineros           
Maracaibo         0-0 Monagas            
Maritimo          2-1 Trujillanos        
Minerven          2-1 Anzoategui           
Univ de Los Andes 1-1 Estudiantes     
Valencia          2-1 UD Tachira          

Round 25
Caracas           0-0 Monagas            
El Vigia          2-1 Deportivo Italia   
Llaneros          1-0 Valencia           
Maritimo          awd Atletico Zamora      [awarded to Zamora, suspended due to
Mineros           1-0 Anzoategui            absence police]
Minerven          8-0 Maracaibo          
Trujillanos       1-0 Estudiantes         
Univ de Los Andes 1-1 UD Tachira          

Round 26
Atletico Zamora   1-1 Estudiantes     
Caracas           0-0 Minerven         
Llaneros          3-0 Univ de Los Andes    
Maracaibo         3-2 Anzoategui         
Maritimo          1-3 Deportivo Italia  
Mineros           8-2 El Vigia         
Monagas           2-1 Valencia         
Trujillanos       1-1 UD Tachira       

Round 27
Anzoategui        5-2 El Vigia           
Estudiantes       5-3 Deportivo Italia    
Llaneros          1-1 Trujillanos       
Maracaibo         1-2 Caracas             
Maritimo          2-2 Mineros             
Minerven          6-1 Valencia           
Monagas           1-3 Univ de Los Andes   
UD Tachira        1-0 Atletico Zamora      

Round 28
Atletico Zamora   0-1 Llaneros        
Caracas           2-0 Anzoategui       
Deportivo Italia  1-2 UD Tachira       
El Vigia          2-1 Maritimo            
Mineros           2-2 Estudiantes      
Trujillanos       5-0 Monagas             
Univ de Los Andes 2-2 Minerven            
Valencia          0-2 Maracaibo           

Round 29
Anzoategui        0-1 Maritimo          
Caracas           1-1 Valencia            
Estudiantes       2-1 El Vigia           
Llaneros          1-1 Deportivo Italia     
Maracaibo         3-0 Univ de Los Andes   
Minerven          2-1 Trujillanos        
Monagas           4-0 Atletico Zamora    
UD Tachira        4-0 Mineros         

Round 30
Atletico Zamora   1-1 Minerven          
Deportivo Italia  1-2 Monagas             
El Vigia          2-2 UD Tachira       
Maritimo          2-3 Estudiantes     
Mineros           awd Llaneros             [awarded to Mineros, suspended due to
                                            coach accident]
Trujillanos       2-0 Maracaibo       
Univ de Los Andes 2-1 Caracas          
Valencia          1-2 Anzoategui      

Final Table:

 1.Caracas FC         30  15  11   4   43-24   43    (*)  [Caracas]
 2.Trujillanos FC     30  14  11   5   53-29   40.25 (*)  [Valera]
 3.Minerven FC        30  15   8   7   53-34   39.75 (*)  [El Callao]
 4.UA Tachira FC      30  12  10   8   41-30   35.50 (*)  [San Cristobal]
 5.AD Mineros Guayana 30  12  10   8   48-34   34         [Ciudad Guayana]
 6.Deportivo Italia   30  12   8  10   43-37   32         [Caracas]
 7.Estudiantes FC     30  12   8  10   43-41   32         [Merida]
 8.Maritimo FC        30  12   5  13   44-37   29         [Caracas]
 9.Llaneros FC        30   9  11  10   31-31   29         [Guanare]
10.El Vigia FC        30  11   7  12   43-49   29         [El Vigia]
11.Univ. de los Andes 30   8  12  10   39-47   28         [Merida]
12.Monagas SC         30   9  10  11   39-47   28         [Maturin]
13.Maracaibo FC       30   8  10  12   33-56   26         [Maracaibo]
14.Valencia FC        30  10   5  15   24-37   25         [Valencia]
15.Atletico Zamora    30   6  12  12   24-35   24         [Barinas]
16.Anzoategui         30   3   6  21   33-66   12         [Puerto La Cruz]

(*) Bonus points from Copa Venezuela: 
    Caracas 2, Minerven 1.75, UA Tachira 1.5, Trujillanos 1.25.

NB: table not completely consistent with known scores


Authors: Josef Bobrowsky
(jrjb@teleweb.at)
and Ian King
(worldsoccer@btinternet.com)

Last updated: 16 Mar 2001

(C) Copyright Josef Bobrowsky, Ian King and RSSSF
1999/2001

INFORMACIÓN

El torneo de Primera División de Venezuela se juega con 18 equipos luego de la Copa America Realizada en nuestro pais (2007), el torneo se divide en dos uno llamado Apertura (Juegos de ida)y el siguiente es el Clausura (Juegos de Vuelta) al Campeón del Apertura y Clausura se le otorga el privilegio de Representar a Venezuela en la Copa Libertadores, y a los 2 siguientes que sumen mas puntos y que no hallan sido campeones ni del apertura ni clausura se les otorga el 3er cupo a la Copa Libertadores y al otro el cupo a la Copa Suramericana. para Explicarlo Mejor el 3 y 4 que acumule mas puntos en el Apertura y clausura se llevaran el Cupo a la Libertadores y a la Sudamerica, respectivamente.

  USO DE MEMORIA  
4,297,840 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.6764
Total Execution Time  0.6784
  CADENA URL  
/primera_venezuela1994
  GET DATOS  
$_GET['/primera_venezuela1994']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0145  SELECT type FROM routes WHERE alias = 'primera_venezuela1994'
0.0294  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_venezuela' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1994 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=113 AND type_rel = 3
0.0152  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.0147  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.0150  SELECT text_es as historical_text FROM leagues_text WHERE id=1638
0.0146  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 = 29907 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0151  SELECT c.id, c.name, c.alias, c.stepParent, l.year FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND l.year='1994' WHERE c.parentId=113 GROUP BY c.id ORDER BY c.order_id ASC
0.0148  SELECT type,rule FROM rules WHERE categoryId = 113 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0147  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-04 09:54:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0148  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-04 09:54:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0149  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-04 09:54:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0147  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-04 09:54:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0151  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_venezuela' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1994 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0146  SELECT e.action, count(e.action) as total, e.player_id FROM events1994 e WHERE e.league_id IN (29907) 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.0145  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 (29907) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events1994 e WHERE e.league_id IN (29907) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0147  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 (29907) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0153  SELECT e.action, count(e.action) as total, e.player_id FROM events1994 e WHERE e.league_id IN (29907) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0152  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 (29907) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0153  SELECT e.action, count(e.action) as total, e.player_id FROM events1994 e WHERE e.league_id IN (29907) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0145  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 (29907) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0145  SELECT 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.league_id = 29907 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0144  SELECT 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.league_id = 29907 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0147  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=29907 AND rel.round=30
0.0147  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 = 29907 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0146  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 = 29907 AND esl.points > 0
0.0146  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-04" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 29907 ORDER BY creation_date DESC LIMIT 0, 10
0.0150  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-04" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 29907
0.0146  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 `calendars1994` 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` = 29907 AND c.`round` = 30 ORDER BY shedule ASC LIMIT 200
0.0144  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 `events1994` e INNER JOIN calendars1994 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 = 30 AND e.real_date IS NOT NULL AND e.league_id = 29907 ORDER BY total DESC LIMIT 40
0.0147  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 `events1994` e INNER JOIN calendars1994 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 = 29907 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0147  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 `tables1994` 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 = 29907 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1994` 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 = 29907 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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-04 00:00:00' AND c.`shedule` < '2024-05-08 23:59:59' AND l.id = 29907 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0147  SELECT data1, data2 FROM services_tags WHERE categoryId=113
0.0147  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 113 AND l.year = 1994 ORDER BY l.group_code ASC
0.0147  SELECT group_code, extraName from `leagues` WHERE categoryId=113 AND year=1994