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

Chile Second Division (Primera B) 1996

Table:

 1.Deportes La Serena      30 19  5  6  55-36  62  Champions and Promoted
 2.Deportivo Puerto Montt  30 16  7  7  51-43  55  Promoted   
-------------------------------------------------
 3.Cobresal                30 16  7  7  78-43  52 [*] Promotion/Relegation 
 4.Deportes Iquique        30 14  7  9  49-37  49  Promotion/Relegation 
- - - - - - - - - - - - - - - - - - - - - - - - -
 5.Rangers                 30 13  7 10  61-45  46
 6.A. Fernández Vial       30 13  5 12  50-50  44
 7.Everton                 30 12  7 11  55-34  43
 8.Melipilla               30 11  8 11  38-43  41
 9.Ñublense                30 12  5 13  40-47  41
10.Magallanes              30 11  7 12  50-58  40
11.Unión Santa Cruz        30 10  6 14  27-49  36
12.Deportes Linares        30  8 10 12  42-55  34
13.Unión San Felipe        30  8  7 15  37-56  31   
14.Deportes Arica          30  7  9 14  43-57  30
15.Deportes Ovalle         30  6 11 13  35-47  29
-------------------------------------------------
16.Deportes Colchagua      30  7  6 17  40-49  27  Relegated

[*] Cobresal had 3 points deducted for fielding an ineligible player.

Santiago Morning promoted to 1B.

Round 1
Colchagua    2-1 Ovalle
Arica        2-2 La Serena
Melipilla    1-0 Iquique
A.F.Vial     4-2 Puerto Montt
San Felipe   2-0 Linares
Everton      1-1 Magallanes
Cobresal     4-0 Santa Cruz
Rangers      5-0 Nublense

Round 2
Iquique      2-0 Arica
Puerto Montt 2-1 Rangers
A.F.Vial     1-5 Everton
Nublense     3-0 Cobresal
Linares      0-0 Magallanes
Ovalle       2-3 San Felipe
Santa Cruz   0-2 Melipilla
La Serena    2-1 Colchagua

Round 3
San Felipe   1-3 La Serena
Arica        3-1 Santa Cruz
Magallanes   3-4 Ovalle
Everton      2-2 Linares
Cobresal     6-1 Puerto Montt
Melipilla    0-2 Nublense
Rangers      1-1 A.F.Vial
Colchagua    3-3 Iquique

Round 4
Iquique      2-0 San Felipe
Santa Cruz   0-2 Colchagua
Puerto Montt 2-1 Melipilla
La Serena    3-2 Magallanes
Nublense     4-2 Arica
Ovalle       1-0 Linares
Rangers      3-1 Everton
A.F.Vial     1-3 Cobresal

Round 5
Everton      2-1 Ovalle      
Linares      3-1 La Serena   
Magallanes   2-2 Iquique     
San Felipe   0-1 Santa Cruz  
Colchagua    1-0 Nublense    
Puerto Montt 2-0 Arica
Melipilla    2-2 A.F.Vial    
Cobresal     1-1 Rangers     

Round 6
Cobresal     2-0 Everton     
Rangers      3-1 Melipilla   
A.F.Vial     5-0 Arica       
Puerto Montt 2-1 Colchagua  
Nublense     2-0 San Felipe  
Santa Cruz   2-0 Magallanes  
Iquique      0-2 Linares     
La Serena    1-0 Ovalle      

Round 7
Everton      1-1 La Serena   
Ovalle       1-1 Iquique     
Linares      2-2 Santa Cruz  
Magallanes   3-2 Nublense    
San Felipe   1-1 Puerto Montt  
Colchagua    1-2 A.F.Vial    
Arica        3-3 Rangers     
Melipilla    2-2 Cobresal    

Round 8
Melipilla    1-0 Everton     
Cobresal     3-2 Arica       
Rangers      3-1 Colchagua   
A.F.Vial     0-2 San Felipe  
Puerto Montt 2-1 Magallanes  
Nublense     0-3 Linares     
Santa Cruz   0-0 Ovalle      
Iquique      1-0 La Serena   

Round 9
Colchagua    1-2 Cobresal    
Linares      0-1 Puerto Montt  
La Serena    3-1 Santa Cruz  
Everton      0-3 Iquique     
Arica        0-1 Melipilla   
San Felipe   3-2 Rangers     
Magallanes   3-1 A.F.Vial    
Ovalle       0-0 Nublense    

Round 10
Cobresal     2-1 San Felipe
A.F.Vial     1-2 Linares
Santa Cruz   2-1 Iquique 
Nublense     0-2 La Serena
Puerto Montt 1-1 Ovalle
Rangers      2-2 Magallanes
Melipilla    2-2 Colchagua
Arica        0-0 Everton

Round 11
Magallanes   1-4 Cobresal    
Iquique      0-2 Nublense    
Everton      4-0 Santa Cruz  
Ovalle       2-3 A.F.Vial    
La Serena    2-2 Puerto Montt   
Colchagua    5-0 Arica       
Linares      2-0 Rangers     
San Felipe   1-0 Melipilla   

Round 12
Colchagua    0-2 Everton     
Melipilla    3-0 Magallanes  
Cobresal     7-3 Linares     
Rangers      4-0 Ovalle     
A.F.Vial     1-2 La Serena   
Puerto Montt 3-2 Iquique     
Nublense     0-0 Santa Cruz  
Arica        3-0 San Felipe  

Round 13
Everton      6-0 Nublense    
Santa Cruz   1-0 Puerto Montt  
San Felipe   1-0 Colchagua   
Iquique      2-1 A.F.Vial    
Magallanes   3-2 Arica       
La Serena    3-0 Rangers     
Ovalle       1-1 Cobresal    
Linares      2-1 Melipilla   

Round 14
Cobresal     6-0 La Serena  
Colchagua    1-2 Magallanes 
Pto.Montt    2-3 Nublense   
Melipilla    2-1 Ovalle      
Rangers      0-0 Iquique    
San Felipe   3-2 Everton    
A.F.Vial     0-0 Santa Cruz 
Arica        1-2 Linares     

Round 15
Everton      0-2 Pto.Montt  
Nublense     0-0 A.F.Vial   
Santa Cruz   1-4 Rangers     
Iquique      3-1 Cobresal    
La Serena    2-0 Melipilla   
Ovalle       0-0 Arica      
Linares      0-0 Colchagua  
Magallanes   2-1 San Felipe  

Round 16
Magallanes   1-0 Everton     
Linares      3-0 San Felipe  
Ovalle       1-0 Colchagua   
La Serena    1-1 Arica       
Iquique      2-1 Melipilla   
Santa Cruz   2-1 Cobresal    
Nublense     1-0 Rangers     
Puerto Montt 4-1 A.F.Vial    

Round 17
Everton      4-0 A.F.Vial   
Rangers      0-0 Puerto Montt   
Cobresal     2-1 Nublense    
Melipilla    1-0 Santa Cruz  
Arica        0-0 Iquique     
Colchagua    1-2 La Serena   
San Felipe   0-1 Ovalle      
Magallanes   3-1 Linares     

Round 18
Linares      1-3 Everton     
Ovalle       1-2 Magallanes  
La Serena    2-0 San Felipe  
Iquique      1-1 Colchagua   
Santa Cruz   1-3 Arica       
Nublense     4-0 Melipilla   
Puerto Montt 1-0 Cobresal    
A.F.Vial     5-2 Rangers     

Round 19
Everton      2-0 Rangers     
Cobresal     2-1 A.F.Vial    
Melipilla    2-1 Puerto Montt   
Arica        3-0 Nublense    
Colchagua    0-0 Santa Cruz  
San Felipe   2-1 Iquique     
Magallanes   1-2 La Serena   
Linares      0-0 Ovalle      

Round 20
Arica        2-5 Puerto Montt
La Serena    4-1 Linares
Santa Cruz   2-1 San Felipe
Rangers      2-1 Cobresal
Iquique      3-0 Magallanes
Ovalle       3-2 Everton
A.F.Vial     2-1 Melipilla
Nublense     2-1 Colchagua

Round 21
Everton      2-2 Cobresal 
Melipilla    3-2 Rangers 
Arica        2-3 A.F.Vial 
Colchagua    0-1 Puerto Montt 
San Felipe   1-1 Nublense 
Magallanes   1-1 Santa Cruz 
Linares      1-2 Iquique 
Ovalle       0-4 La Serena 

Round 22
La Serena    1-1 Everton
Santa Cruz   3-1 Linares
Nublense     4-0 Magallanes
Puerto Montt 1-1 San Felipe
A.F.Vial     2-1 Colchagua
Rangers      2-1 Arica
Cobresal     2-2 Melipilla
Iquique      2-2 Ovalle

Round 23
Everton      0-1 Melipilla   
Arica        3-1 Cobresal    
Colchagua    1-4 Rangers     
San Felipe   1-3 A.F.Vial    
Magallanes   4-1 Pto.Montt   
Linares      2-2 Nublense    
Ovalle       1-2 Santa Cruz  
La Serena    2-0 Iquique     

Round 24
Iquique      2-1 Everton 
Santa Cruz   1-3 La Serena 
Nublense     2-1 Ovalle 
Puerto Montt 2-0 Linares 
Rangers      4-2 San Felipe 
A.F.Vial     2-1 Magallanes 
Cobresal     2-0 Colchagua 
Melipilla    1-2 Arica 

Round 25
Everton      3-0 Arica
Colchagua    1-1 Melipilla
San Felipe   2-2 Cobresal
Magallanes   3-0 Rangers
Linares      1-1 A.F.Vial
Ovalle       2-2 Puerto Montt
La Serena    2-0 Nublense
Iquique      4-0 Santa Cruz         [4-2?]

Round 26
Santa Cruz   1-0 Everton
Nublense     1-2 Iquique
Puerto Montt 2-1 La Serena
A.F.Vial     3-1 Ovalle
Rangers      4-1 Linares
Cobresal     5-0 Magallanes
Melipilla    1-1 San Felipe
Arica        0-1 Colchagua

Round 27
Everton      3-0 Colchagua
San Felipe   2-2 Arica
Magallanes   0-0 Melipilla
Linares      3-3 Cobresal
Ovalle       0-0 Rangers
La Serena    1-0 A.F.Vial
Iquique      3-0 Puerto Montt
Santa Cruz   2-0 Nublense

Round 28
Nublense     1-3 Everton
Puerto Montt 2-1 Santa Cruz
A.F.Vial     1-0 Iquique
Rangers      5-1 La Serena
Cobresal     2-1 Ovalle
Melipilla    2-2 Linares
Arica        3-1 Magallanes
Colchagua    4-2 San Felipe

Round 29
Everton      4-0 San Felipe
Magallanes   5-2 Colchagua
Linares      1-1 Arica
Ovalle       4-1 Melipilla
La Serena    1-0 Cobresal
Iquique      3-0 Rangers
Santa Cruz   0-2 A.F.Vial
Nublense     1-3 Puerto Montt

Round 30
Rangers      4-0 Santa Cruz
A.F.Vial     1-2 Nublense
Cobresal     7-2 Iquique
Melipilla    2-1 La Serena
Puerto Montt 1-1 Everton
Arica        2-2 Ovalle
Colchagua    6-1 Linares
San Felipe   3-3 Magallanes

Table:

 1.Deportes La Serena      30 19  5  6  55-36  62  Champions and Promoted
 2.Deportivo Puerto Montt  30 16  7  7  51-43  55  Promoted   
-------------------------------------------------
 3.Cobresal                30 16  7  7  78-43  52 [*] Promotion/Relegation 
 4.Deportes Iquique        30 14  7  9  49-37  49  Promotion/Relegation 
- - - - - - - - - - - - - - - - - - - - - - - - -
 5.Rangers                 30 13  7 10  61-45  46
 6.A. Fernández Vial       30 13  5 12  50-50  44
 7.Everton                 30 12  7 11  55-34  43
 8.Melipilla               30 11  8 11  38-43  41
 9.Ñublense                30 12  5 13  40-47  41
10.Magallanes              30 11  7 12  50-58  40
11.Unión Santa Cruz        30 10  6 14  27-49  36
12.Deportes Linares        30  8 10 12  42-55  34
13.Unión San Felipe        30  8  7 15  37-56  31   
14.Deportes Arica          30  7  9 14  43-57  30
15.Deportes Ovalle         30  6 11 13  35-47  29
-------------------------------------------------
16.Deportes Colchagua      30  7  6 17  40-49  27  Relegated

[*] Cobresal had 3 points deducted for fielding an ineligible player.

Santiago Morning promoted to 1B.

TOP SCORER
Sergio Salgado          (Chile)         Cobresal                27
Ruben Dundo             (Argentina)     Fernández Vial          18
Richard Alvarez         (Uruguay)       Deportes Iquique        15
Mario Araya             (Chile)         Deportes La Serena      13
Francisco Pinto         (Chile)         Deportes La Serena      13
Alberto Chilindrón      (Argentina)     Rangers                 13
Luis Zambrano           (Chile)         Ñublense                13
Walter Otta             (Argentina)     Puerto Montt            13


LIGUILLA DE PROMOCION (promotion/relegation play-off)

December 1
Cobresal        3-1 Temuco
Iquique         1-0 Palestino

December 8
Temuco          2-0 Cobresal
Palestino       5-1 Iquique

Temuco and Palestino remain in 1A.



Authors: Juan Pablo Andrés
(jpandres@tutopia.com)
and Luis Antonio Reyes
(luchoasis@yahoo.es)
Last updated: 13 Aug 2001

(C) Copyright Juan Pablo Andrés and RSSSF 1999/2001

INFORMACIÓN

La Primera B del fútbol chileno u oficialmente a partir del 2009, Campeonato Nacional de Primera B del Fútbol Profesional Chileno, corresponde a la segunda categoría del fútbol profesional en Chile, por debajo de la Primera División. Es organizada por la Asociación Nacional de Fútbol Profesional (ANFP), perteneciente a la Federación de Fútbol de Chile y corresponde a una de las 3 categorías profesionales del Fútbol en Chile. Fue fundada en 1952 como continuadora del torneo DIVHA (División de Honor Amateur) y como vía deportiva para equipos regionales que buscan un lugar en la Primera División. Han participado en ella un total de 74 instituciones a lo largo de sus 61 temporadas Actualmente 14 equipos conforman esta categoría. En este certamen se otorgan 2 ascensos directos y 2 promociones a Primera División, por contraparte el equipo peor ubicado desciende a Segunda División

  USO DE MEMORIA  
4,284,584 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.6234
Total Execution Time  0.6253
  CADENA URL  
/primera_b_apertura_fase_1_chile1996
  GET DATOS  
$_GET['/primera_b_apertura_fase_1_chile1996']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0144  SELECT type FROM routes WHERE alias = 'primera_b_apertura_fase_1_chile1996'
0.0292  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_b_apertura_fase_1_chile' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1996 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0148  SELECT text_es as historical_text FROM leagues_text WHERE id=2407
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 = 30653 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146  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=1847 ORDER BY l.group_code ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 09:29:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 09:29:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 09:29:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 09:29:34' 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_b_apertura_fase_1_chile' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1996 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events1996 e WHERE e.league_id IN (30653) 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 (30653) 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 events1996 e WHERE e.league_id IN (30653) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0146  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 (30653) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0150  SELECT e.action, count(e.action) as total, e.player_id FROM events1996 e WHERE e.league_id IN (30653) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0151  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 (30653) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0154  SELECT e.action, count(e.action) as total, e.player_id FROM events1996 e WHERE e.league_id IN (30653) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0150  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 (30653) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0146  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 = 30653 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0149  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 = 30653 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0163  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=30653 AND rel.round=30
0.0155  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 = 30653 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0156  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 = 30653 AND esl.points > 0
0.0158  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-28" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 30653 ORDER BY creation_date DESC LIMIT 0, 10
0.0172  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-28" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 30653
0.0157  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 `calendars1996` 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` = 30653 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 `events1996` e INNER JOIN calendars1996 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 = 30653 ORDER BY total DESC LIMIT 40
0.0148  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 `events1996` e INNER JOIN calendars1996 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 = 30653 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0154  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 `tables1996` 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 = 30653 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1996` 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 = 30653 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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-27 00:00:00' AND c.`shedule` < '2024-05-01 23:59:59' AND l.id = 30653 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0154  SELECT data1, data2 FROM services_tags WHERE categoryId=290
0.0154  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 290 AND l.year = 1996 ORDER BY l.group_code ASC
0.0154  SELECT group_code, extraName from `leagues` WHERE categoryId=290 AND year=1996