4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 1997
Temporada Siguiente »
Publicidad 600x120.gif
Apertura Primera B Colombia 1997
1996/1997

Apertura Primera B Colombia 1997

  • Primera B
Información Histórica 
						
Colombia 1996/97

The season consists of the following stages:

1) Copa Mustang I: 32 rounds; first round 'clasicos regionales', 17th round
   their returns; in between two round robins of 15 rounds each.  Played from
   Sep 8, 1996 to Feb 23, 1997.  The winner of the Copa Mustang I gets 2
   bonus points, runners-up 1, third 0,5, fourth 0,25.  The winner is also
   assured of a place in the Copa Conmebol.

2) Copa Mustang II: 14 rounds, from Feb 26, 1997 to Apr 20, 1997.  The clubs
   are divided into two groups (odd-place finishers of C.M. I and even-place
   finishers, respectively), which each play a double round-robin.  There are
   no bonus points to earn; the results of both C.M.'s are added to obtain
   the Reclasificación (46 rounds); the top-4 of this qualify for the Gran 
   Final.

3) Cuadrangular Final: 6 rounds between the top-4 in the Reclasifición.  All
   clubs start with 0 points except for winner Reclasificación (1 bonus point).

NB: afterwards, it was decided to have another stage, the Torneo Adecuación,
    at the end of the season, to return to the spring/fall rhythm.  The winner
    of the Torneo Adecuación (Bucaramanga) will play the winner of the
    originally planned season (América) for the 1996/97 championship.

Copa Mustang I (First Stage)
==============

Final Table:

 1.América Cali           32 21  8  3  52-22  71
 2.Atl. Nacional          32 16 11  5  48-22  59
 3.Dep. Cali              32 16  9  7  52-37  57
 4.Atl. Junior            32 13  9 10  53-40  48
 5.Dep. Indep. Medellín   32 12 11  9  31-31  47
 6.Dep. Tolima            32 12 10 10  46-43  46
 7.Indep. Santa Fe        32 11 11 10  34-31  44
 8.Once Caldas            32 11 10 11  46-33  43
 9.Envigado FC            32 10 12 10  41-37  42
10.Atl. Bucaramanga       32 10 12 10  37-39  42
11.Un. Magdalena          32 11  7 15  35-46  40
12.Dep. Tuluá             32  7 16  9  29-34  37
13.Millonarios            32  6 10 16  30-41  28
14.Dep. Pereira           32  5 13 14  39-55  28
15.Dep. Quindío           32  5 13 14  34-62  28
16.Cúcuta Dep.            32  4 10 18  27-61  22

Round 1 [Sep 8]
Tulua       2-2 Quindio    
America     1-3 Cali       
Millonarios 0-1 Santa Fe   
Tolima      3-2 Envigado   
Pereira     3-2 Caldas     
Junior      1-0 Magdalena  
Bucaramanga 1-0 Cucuta     
Medellin    0-0 Nacional  

Round 2 [Sep 15]
Quindio     1-1 Bucaramanga
Cali        2-0 Junior     
Santa Fe    0-0 Pereira    
Envigado    3-0 Tolima     
Caldas      3-1 Millonarios
Magdalena   2-2 America    
Cucuta      1-2 Tulua      
Nacional    1-0 Medellin   

Round 3 [Sep 22]
Tulua       2-1 Magdalena  
America     2-1 Caldas     
Millonarios 0-0 Envigado   
Tolima      1-2 Santa Fe   
Pereira     0-0 Cali       
Junior      7-1 Quindio    
Bucaramanga 0-0 Medellin   
Nacional    3-0 Cucuta     

Round 4 [Sep 25]
Medellin    3-3 Junior     
Quindio     2-2 Pereira    
Cali        1-0 Tolima     
Santa Fe    1-1 Millonarios
Envigado    1-2 America    
Caldas      1-0 Tulua      
Magdalena   0-0 Cucuta     
Bucaramanga 1-0 Nacional   

Round 5 [Sep 29]
Cucuta      1-2 Caldas     
Tulua       2-2 Envigado   
America     1-0 Santa Fe   
Millonarios 1-1 Cali       
Tolima      2-2 Quindio    
Pereira     2-3 Medellin   
Junior      1-0 Bucaramanga 
Nacional    1-0 Magdalena  

Round 6 [Oct 2]
Bucaramanga 3-1 Pereira    
Medellin    1-3 Tolima     
Quindio     3-2 Millonarios
Cali        0-1 America    
Santa Fe    2-0 Tulua      
Envigado    3-0 Cucuta     
Caldas      3-0 Magdalena  
Junior      0-1 Nacional   

Round 7 [Oct 6]
Magdalena   1-0 Envigado   
Cucuta      2-2 Santa Fe   
Tulua       0-0 Cali       
America     2-0 Quindio    
Millonarios 0-1 Medellin   
Tolima      1-1 Bucaramanga
Pereira     0-1 Junior     
Nacional    0-0 Caldas     

Round 8 [Oct 13]
Junior      2-2 Tolima     
Bucaramanga 1-1 Millonarios
Medellin    0-1 America    
Quindio     1-0 Tulua      
Cali        2-1 Cucuta     
Santa Fe    4-0 Magdalena  
Envigado    0-0 Caldas     
Pereira     1-3 Nacional   

Round 9 [Oct 20,21]
Caldas      1-1 Santa Fe
Magdalena   2-0 Cali
Cucuta      1-1 Quindio
Tulua       0-0 Medellin
America     2-0 Bucaramanga
Nacional    2-2 Envigado
Millonarios 2-3 Junior
Tolima      0-1 Pereira

Round 10 [Oct 27]
Junior      0-1 America
Cali        2-1 Caldas
Pereira     1-1 Millonarios
Bucaramanga 2-1 Tulua
Medellin    0-0 Cucuta
Quindio     3-2 Magdalena
Santa Fe    3-2 Envigado
Tolima      1-3 Nacional

Round 11 [Nov 3]
Envigado    2-2 Cali
Magdalena   1-2 Medellin
Cucuta      1-2 Bucaramanga
Tulua       1-1 Junior
America     2-1 Pereira   
Millonarios 0-0 Tolima
Nacional    3-0 Santa Fe
Caldas      3-0 Quindio      [Nov 7]

Round 12 [Nov 14]
Junior      4-1 Cucuta
Millonarios 0-0 Nacional
Tolima      1-2 America
Medellin    2-1 Caldas
Pereira     1-1 Tulua
Bucaramanga 0-1 Magdalena
Quindio     0-0 Envigado
Cali        1-0 Sante Fe     [Nov 27]

Round 13 [Nov 16,17]
Nacional    1-1 Cali
Cucuta      2-2 Pereira
America     1-0 Millonarios
Tulua       1-0 Tolima
Sante Fe    0-0 Quindio
Magdalena   3-0 Junior
Caldas      3-1 Bucaramanga
Envigado    1-1 Medellin

Round 14 [Nov 24]
Tolima      1-1 Cucuta
Millonarios 1-2 Tulua
Pereira     1-2 Magdalena
Junior      3-1 Caldas
Quindio     2-6 Cali
Bucaramanga 3-1 Envigado
Medellin    1-1 Santa Fe
America     3-2 Nacional

Round 15 [Dec 1]
Envigado    1-2 Junior
Tulua       0-2 America
Magdalena   3-1 Tolima
Cali        4-2 Medellin
Nacional    3-1 Quindio
Santa Fe    0-2 Bucaramanga
Cucuta      2-0 Millonarios
Caldas      1-2 Pereira

Round 16 [Dec 4,5]
America     3-0 Cucuta
Tulua       0-0 Nacional
Millonarios 3-0 Magdalena
Tolima      1-0 Caldas       [played later]
Pereira     1-3 Envigado
Junior      4-1 Santa Fe
Bucaramanga 1-0 Cali
Medellin    1-0 Quindio

Round 17 [Dec 7,8]
Envigado    4-2 Tolima
Quindio     0-1 Tulua
Santa Fe    1-0 Millonarios
Magdalena   1-0 Junior
Cali        2-1 America
Caldas      0-0 Pereira
Cucuta      2-1 Bucaramanga
Nacional    0-2 Medellin

Round 18 [Dec 11]
Junior      5-3 Cali
Tolima      1-0 Envigado
Tulua       2-0 Cucuta
Bucaramanga 1-1 Quindio
Medellin    0-0 Nacional
Millonarios 0-0 Caldas
Pereira     0-0 Santa Fe
America     3-0 Magdalena

Round 19 [Dec 18]
Santa Fe    1-1 Tolima
Millonarios 1-2 Envigado
Caldas      1-2 America
Cucuta      1-3 Nacional
Quindio     2-2 Junior
Cali        3-0 Pereira
Magdalena   1-1 Tulua
Medellin    0-0 Bucaramanga

Round 20 [Dec 22]
America     1-1 Envigado
Nacional    0-0 Bucaramanga
Millonarios 2-1 Santa Fe
Cucuta      2-0 Magdalena
Pereira     2-0 Quindio
Tolima      1-1 Cali
Junior      1-0 Medellin
Tulua       1-1 Caldas

Round 21 [Jan 12]
Envigado    0-0 Tulua 
Santa Fe    0-0 America 
Cali        2-1 Millonarios 
Quindio     2-3 Tolima 
Medellin    2-0 Pereira 
Bucaramanga 2-2 Junior 
Caldas      7-0 Cucuta 
Magdalena   1-1 Nacional 

Round 22 [Jan 16]
Nacional    2-1 Junior
Pereira     4-2 Bucaramanga  [3-2?]
Tolima      3-2 Medellin
Millonarios 2-1 Quindio
America     1-1 Cali 
Tulua       0-1 Santa Fe 
Cucuta      0-1 Envigado
Magdalena   1-1 Caldas

Round 23 [Jan 18-20]
Cali        3-0 Tulua 
Medellin    1-0 Millonarios
Bucaramanga 1-5 Tolima 
Quindio     1-1 America
Junior      4-1 Pereira
Caldas      1-3 Nacional
Envigado    1-0 Magdalena
Santa Fe    3-1 Cucuta

Round 24 [Jan 22]
America     5-0 Medellin 
Cucuta      2-1 Cali
Tolima      2-0 Junior
Magdalena   1-1 Santa Fe
Caldas      2-0 Envigado
Tulua       2-2 Quindio
Nacional    2-0 Pereira 
Millonarios 0-0 Bucaramanga

Round 25 [Jan 25]
Junior      3-0 Millonarios
Envigado    1-0 Nacional
Medellin    1-1 Tulua
Bucaramanga 1-1 America
Pereira     1-1 Tolima
Quindio     2-2 Cucuta
Cali        2-1 Magdalena
Santa Fe    1-1 Caldas

Round 26 [Jan 29]
America     2-0 Junior 
Caldas      1-1 Cali
Millonarios 4-3 Pereira      [corrected from 4-1]
Tulua       1-1 Bucaramanga
Cucuta      0-0 Medellin   
Magdalena   3-1 Quindio
Envigado    1-0 Santa Fe
Nacional    1-2 Tolima

Round 27 [Feb 2]
Santa Fe    1-2 Nacional
Pereira     0-1 America
Cali        2-1 Envigado
Junior      1-1 Tulua
Quindio     2-1 Caldas
Medellin    2-0 Magdalena
Bucaramanga 3-1 Cucuta
Tolima      1-1 Millonarios

Round 28 [Feb 5]
Cucuta      0-0 Junior 
Santa Fe    3-1 Cali           
America     0-0 Tolima
Tulua       2-2 Pereira
Magdalena   2-1 Bucaramanga
Caldas      1-2 Medellin
Envigado    0-0 Quindio
Nacional    2-0 Millonarios

Round 29 [Feb 9]
Quindio     0-2 Santa Fe 
Medellin    1-0 Envigado 
Bucaramanga 0-1 Caldas 
Junior      1-1 Magdalena
Pereira     3-3 Cucuta 
Tolima      1-0 Tulua 
Cali        0-3 Nacional 
Millonarios 2-1 America 

Round 30 [Feb 16]
Santa Fe    0-1 Medellin
Tulua       1-0 Millonarios
Nacional    1-1 America
Envigado    3-2 Bucaramanga
Cucuta      0-2 Tolima
Cali        2-0 Quindio
Magdalena   2-1 Pereira
Caldas      1-0 Junior

Round 31 [Feb 19]
America     2-1 Tulua
Bucaramanga 1-0 Santa Fe
Medellin    0-1 Cali
Junior      1-1 Envigado
Tolima      4-1 Magdalena
Quindio     0-4 Nacional
Pereira     1-1 Caldas
Millonarios 3-0 Cucuta

Round 32 [Feb 23]
Cucuta      0-2 America
Nacional    1-1 Tulua
Cali        2-2 Bucaramanga
Santa Fe    1-0 Junior
Quindio     1-0 Medellin
Caldas      3-0 Tolima
Magdalena   2-1 Millonarios
Envigado    2-2 Pereira

Final Table Copa Mustang I:

 1.América Cali           32 21  8  3  52-22  71
 2.Atl. Nacional          32 16 11  5  48-22  59
 3.Dep. Cali              32 16  9  7  52-37  57
 4.Atl. Junior            32 13  9 10  53-40  48
 5.Dep. Indep. Medellín   32 12 11  9  31-31  47
 6.Dep. Tolima            32 12 10 10  46-43  46
 7.Indep. Santa Fe        32 11 11 10  34-31  44
 8.Once Caldas            32 11 10 11  46-33  43
 9.Envigado FC            32 10 12 10  41-37  42
10.Atl. Bucaramanga       32 10 12 10  37-39  42
11.Un. Magdalena          32 11  7 15  35-46  40
12.Dep. Tuluá             32  7 16  9  29-34  37
13.Millonarios            32  6 10 16  30-41  28
14.Dep. Pereira           32  5 13 14  39-55  28
15.Dep. Quindío           32  5 13 14  34-62  28
16.Cúcuta Dep.            32  4 10 18  27-61  22




Authors: Frank Ballesteros (fballesteros@colombia.com) and Juan Pablo Andrés (jpandres@tutopia.com) 
Last updated: 1 Feb 2006

(C) Copyright Frank Ballesteros, Juan Pablo Andrés and RSSSF 2005/06
You are free to copy this document in whole or part provided that proper acknowledgement is given to the authors. All rights reserved.

INFORMACIÓN

La Categoría Primera B, llamado oficialmente Torneo Postobón por motivos comerciales, es el torneo de segunda división de la División Mayor del Fútbol Colombiano (Dimayor), entidad dependiente de la Federación Colombiana de Fútbol. El torneo es de carácter profesional, comenzó a disputarse en 1991 y el primer torneo fue ganado por el Envigado Fútbol Club.

  USO DE MEMORIA  
4,306,040 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0027
Controller Execution Time ( Home / Category )  0.5248
Total Execution Time  0.5275
  CADENA URL  
/apertura_primera_b_colombia1997
  GET DATOS  
$_GET['/apertura_primera_b_colombia1997']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0105  SELECT type FROM routes WHERE alias = 'apertura_primera_b_colombia1997'
0.0212  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_primera_b_colombia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1997 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=196 AND type_rel = 3
0.0107  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 196 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0107  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 (1280990,1223665,1162446,1152331,1076557) ORDER BY n.cover_points DESC, update_date DESC
0.0110  SELECT text_es as historical_text FROM leagues_text WHERE id=5381
0.0105  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 = 33856 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0107  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=196 ORDER BY l.group_code ASC
0.0105  SELECT type,rule FROM rules WHERE categoryId = 196 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-23 11:05:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-23 11:05:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-23 11:05:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-23 11:05:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0111  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_primera_b_colombia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1997 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0105  SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (33856) 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.0105  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 (33856) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0106  SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (33856) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0108  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 (33856) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0106  SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (33856) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0106  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 (33856) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0112  SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (33856) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0108  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 (33856) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0109  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 = 33856 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0106  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 = 33856 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0106  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 196 GROUP BY l.categoryId
0.0105  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=196 GROUP BY l.year ORDER BY l.year DESC
0.0110  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=33856 AND rel.round=32
0.0110  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 = 33856 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0110  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 = 33856 AND esl.points > 0
0.0109  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-03-24" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 33856 ORDER BY creation_date DESC LIMIT 0, 10
0.0120  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-03-24" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 33856
0.0116  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 `calendars1997` 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` = 33856 AND c.`round` = 32 ORDER BY shedule ASC LIMIT 200
0.0108  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 `events1997` e INNER JOIN calendars1997 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 = 32 AND e.real_date IS NOT NULL AND e.league_id = 33856 ORDER BY total DESC LIMIT 40
0.0111  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 `events1997` e INNER JOIN calendars1997 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 = 33856 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0111  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 `tables1997` 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 = 33856 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1997` 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 = 33856 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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-04-23 00:00:00' AND c.`shedule` < '2024-04-27 23:59:59' AND l.id = 33856 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0111  SELECT data1, data2 FROM services_tags WHERE categoryId=196
0.0111  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 196 AND l.year = 1997 ORDER BY l.group_code ASC
0.0111  SELECT group_code, extraName from `leagues` WHERE categoryId=196 AND year=1997