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 Level (Primera B) 1998

Table:
 
 1.Cobresal               30 19  8  3  79-22  65  Champions, Promoted
 2.O'Higgins              30 19  2  9  61-39  59  Promoted
------------------------------------------------
 3.Santiago Morning       30 17  7  6  40-23  58  Promotion Playoff
 4.Unión Española         30 17  5  8  60-44  56  Promotion Playoff
 - - - - - - - - - - - - - - - - - - - - - - - -
 5.Univ. de Concepción    30 16  4 10  59-44  52
 6.Everton                30 14  6 10  43-30  48
 7.Deportes Linares       30 12  8 10  47-52  44
 8.Deportes Melipilla     30 10 13  7  42-35  43
 9.Magallanes             30 10 10 10  37-41  40
10.Unión San Felipe       30 11  2 17  40-65  35
11.Deportes Ovalle        30  8 10 12  39-44  34
12.Antofagasta            30  6 11 13  30-45  29
13.Arturo Fernández Vial  30  5 12 13  36-53  27
14.Deportes Arica         30  5 10 15  24-47  25
15.Ñublense               30  5  8 17  28-54  23
------------------------------------------------
16.Regional Atacama       30  3 10 17  23-50  19  Relegated [*]

[*] Regional Atacama are from Copiapo, but this season played home matches
    in nearby Tierra Amarilla.

Round 1 (Apr 4,5)
Cobresal            2-1 Univ. de Concepcion
U. San Felipe       2-3 Dep. Melipilla
Stgo. Morning       2-0 Magallanes
Everton             0-1 O'Higgins
Dep. Linares        1-2 Nublense
Dep. Ovalle         1-2 Union Espanola
Dep. Arica          1-1 Antofagasta
Fernandez Vial      1-1 Reg. Atacama

Round 2 (Apr 11,12)
Dep. Melipilla      1-5 Univ. de Concepcion
O'Higgins           1-2 Stgo. Morning    
Nublense            0-1 Everton    
Antofagasta         0-0 Dep. Ovalle     
Fernandez Vial      0-2 Cobresal       
Magallanes          2-0 U. San Felipe 
Reg. Atacama        1-1 Dep. Arica  
Union Espanola      5-1 Dep. Linares         [Apr 14]

Round 3 (Apr 18,19)
Cobresal            2-0 Dep. Melipilla
Univ. de Concepcion 3-2 Magallanes
Everton             0-4 Union Espanola
U. San Felipe       3-0 O'Higgins
Dep. Linares        1-0 Antofagasta
Stgo. Morning       4-0 Nublense
Dep. Ovalle         1-1 Reg. Atacama
Dep. Arica          2-0 Fernandez Vial       [Apr 21]

Round 4 (Apr 25,26)
Magallanes          0-0 Dep. Melipilla       [May 21; originally abandoned due to rain]
Union Espanola      0-0 Stgo. Morning        [Apr 28]
Fernandez Vial      1-0 Dep. Ovalle    
O'Higgins           2-1 Univ. de Concepcion
Dep. Arica          2-2 Cobresal      
Reg. Atacama        0-1 Dep. Linares     
Antofagasta         0-1 Everton
Nublense            5-2 U. San Felipe

Round 5 (May 2,3)
U. San Felipe       2-3 Union Espanola
Stgo. Morning       1-0 Antofagasta
Everton             5-1 Reg. Atacama
Dep. Linares        2-0 Fernandez Vial 
Cobresal            3-0 Magallanes
Dep. Melipilla      1-0 O'Higgins
Univ. de Concepcion 1-0 Nublense
Dep. Ovalle         3-0 Dep. Arica

Round 6 (May 9,10)
Dep. Ovalle         0-0 Cobresal
Dep. Arica          1-4 Dep. Linares
Fernandez Vial      1-1 Everton
Reg. Atacama        0-0 Stgo. Morning        
Antofagasta         2-0 U. San Felipe
Nublense            1-1 Dep. Melipilla   
O'Higgins           4-1 Magallanes
Union Espanola      3-1 Univ. de Concepcion  [May 12]

Round 7 (May 16,17)
Cobresal            3-2 O'Higgins
Magallanes          1-2 Nublense
Dep. Melipilla      0-0 Union Espanola
Univ. de Concepcion 3-0 Antofagasta
U. San Felipe       2-0 Reg. Atacama
Stgo. Morning       3-1 Fernandez Vial
Everton             1-0 Dep. Arica
Dep. Linares        1-1 Dep. Ovalle

Round 8 (May 23,24)
Dep. Linares        1-1 Cobresal
Dep. Ovalle         1-2 Everton
Dep. Arica          3-3 Stgo. Morning
Fernandez Vial      5-0 U. San Felipe
Reg. Atacama        1-2 Univ. de Concepcion
Antofagasta         1-1 Dep. Melipilla
Nublense            1-4 O'Higgins
Union Espanola      1-2 Magallanes           [May 26]

Round 9 (May 30,31)
Dep. Melipilla      5-1 Reg. Atacama
Univ. de Concepcion 2-1 Fernandez Vial
Stgo. Morning       2-1 Dep. Ovalle
Everton             4-0 Dep. Linares
O'Higgins           3-2 Union Espanola
Cobresal            4-0 Nublense
Magallanes          3-1 Antofagasta
U. San Felipe       2-0 Dep. Arica

Round 10 (Jul 19?)
Everton             1-0 Cobresal
Antofagasta         2-4 O'Higgins
Union Espanola      3-0 Nublense
Dep. Ovalle         2-0 U. San Felipe
Dep. Arica          1-2 Univ. de Concepcion
Fernandez Vial      0-0 Dep. Melipilla
Reg. Atacama        0-1 Magallanes     
Dep. Linares        1-1 Stgo. Morning

Round 11 (Jul 26)
Cobresal            6-0 Union Espanola
Nublense            1-1 Antofagasta
O'Higgins           3-0 R. Atacama
Magallanes          2-1 Fernandez Vial
Dep. Melipilla      4-1 Dep. Arica
U. de Concepcion    2-2 Dep. Ovalle
U. San Felipe       1-1 Dep. Linares
Stgo. Morning       1-1 Everton

Round 12 (Aug 2)
Stgo. Morning       0-0 Cobresal
Antofagasta         1-0 U. Espanola
Everton             5-1 San Felipe
Fernandez Vial      2-1 O'Higgins 
Dep. Linares        0-1 U. de Concepcion
Dep. Arica          0-0 Magallanes
Dep. Ovalle         0-0 Dep. Melipilla
Reg. Atacama        0-0 Nublense

Round 13 (Aug 5)
U. Espanola         3-1 Reg. Atacama
U. de Concepcion    0-0 Everton
San Felipe          1-0 Stgo. Morning
Cobresal            3-1 Antofagasta 
Nublense            1-1 Fernandez Vial
O'Higgins           3-1 Dep. Arica
Magallanes          2-2 Dep. Ovalle
Dep. Melipilla      3-3 Dep. Linares

Round 14 (Aug 9)
San Felipe          2-1 Cobresal
Everton             0-1 Dep. Melipilla
Stgo. Morning       2-1 U. de Concepcion
Dep. Linares        1-1 Magallanes
Dep. Ovalle         2-2 O'Higgins
Dep. Arica          1-0 Nublense
Fernandez Vial      2-1 U. Espanola
Reg. Atacama        0-0 Antofagasta

Round 15
(Aug 15)
O'Higgins           1-0 Dep. Linares
(Aug 16)
Cobresal            4-1 Reg. Atacama
Antofagasta         3-3 Fernandez Vial
Nublense            3-4 Dep. Ovalle 
Magallanes          1-2 Everton
Dep. Melipilla      0-0 Stgo. Morning
U. de Concepcion    6-1 San Felipe
(Aug 18)
U. Espanola         1-2 Dep. Arica

Round 16
(Aug. 23)
U. de Concepcion    0-1 Cobresal
Dep. Melipilla      1-0 San Felipe
Magallanes          0-1 Stgo. Morning
O'Higgins           0-1 Everton
Nublense            0-0 Dep. Linares
Antofagasta         1-0 Dep. Arica
Atacama             2-2 Fernandez Vial
(Aug 25)
U. Espanola         2-1 Dep. Ovalle

Round 17 (Aug 29,30)
Cobresal            6-1 Fernandez Vial
Stgo. Morning       0-1 O'Higgins
Dep. Ovalle         3-0 Antofagasta
Dep. Arica          1-1 Atacama
Dep. Linares        6-2 U. Espanola
Everton             0-1 Nublense
San Felipe          0-1 Magallanes
U. de Concepcion    2-1 Dep. Melipilla

Round 18 (Sep 6)
Dep. Melipilla      1-1 Cobresal
Magallanes          3-0 U. de Concepcion
O'Higgins           4-0 San Felipe
Nublense            0-1 Stgo. Morning
U. Espanola         2-0 Everton
Antofagasta         3-0 Dep. Linares
Atacama             2-0 Dep. Ovalle
Fernandez Vial      1-1 Dep. Arica

Round 19 (Sep 13)
Cobresal            6-0 Dep. Arica
Dep. Ovalle         3-0 Fernandez Vial
Dep. Linares        2-1 Atacama
Everton             3-0 Antofagasta
Stgo. Morning       0-2 U. Espanola
San Felipe          1-0 Nublense
U. de Concepcion    2-3 O'Higgins
Dep. Melipilla      1-1 Magallanes

Round 20 
(Sep 17)
Dep. Arica          1-0 Dep. Ovalle
(Sep 18)
Magallanes          0-0 Cobresal
Reg. Atacama        1-0 Everton
Nublense            1-2 U. de Concepcion
(Sep 19)
O'Higgins           4-3 Dep. Melipilla
(Sep 20)
U. Espanola         3-1 San Felipe
Antofagasta         1-2 Stgo. Morning
Fernandez Vial      1-2 Dep. Linares

Round 21 (Sep 27)
Cobresal            4-1 Dep. Ovalle
Dep. Linares        1-0 Dep. Arica
Everton             2-1 Fernandez Vial
Stgo. Morning       1-0 Atacama
San Felipe          2-0 Antofagasta
U. de Concepcion    3-1 U. Espanola
Dep. Melipilla      1-0 Nublense
Magallanes          2-3 O'Higgins

Round 22
(Oct 3)
O'Higgins           1-0 Cobresal
(Oct 4)
Nublense            1-1 Magallanes
U. Espanola         3-0 Dep. Melipilla
Antofagasta         3-1 U. de Concepcion
Reg. Atacama        1-1 U. San Felipe
Fernandez Vial      1-2 Stgo. Morning
Dep. Arica          1-1 Everton
Dep. Ovalle         1-1 Dep. Linares

Round 23
(Oct 10)
Stgo. Morning       1-0 Dep. Arica
O'Higgins           4-0 Nublense
(Oct 11)
Everton             0-1 Dep. Ovalle
Cobresal            8-1 Dep. Linares
San Felipe          1-0 Fernandez Vial
Dep. Melipilla      4-2 Antofagasta
(Oct 12)  
Magallanes          2-3 U. Espanola
U. de Concepcion    4-2 Reg. Atacama

Round 24 (Oct 17,18)
Dep. Ovalle         1-2 Stgo. Morning
Dep. Linares        3-2 Everton
U. Espanola         3-2 O'Higgins
Dep. Arica          1-0 San Felipe
Fernandez Vial      2-2 U. de Concepcion
Reg. Atacama        1-1 Dep. Melipilla
Antofagasta         1-1 Magallanes 
Nublense            0-3 Cobresal

Round 25
(Oct 24)
O'Higgins           3-0 Antofagasta
(Oct 25)
Cobresal            3-0 Everton
Stgo. Morning       2-0 Dep. Linares
U. San Felipe       5-0 Dep. Ovalle
U. de Concepcion    2-0 Dep. Arica
Dep. Melipilla      4-0 Fernandez Vial
Magallanes          1-0 Reg. Atacama
Nublense            2-3 U. Espanola

Round 26 (Nov 1)
U. Espanola         2-2 Cobresal
Antofagasta         0-0 Nublense
R. Atacama          3-0 O'Higgins
Fernandez Vial      2-2 Magallanes
Dep. Arica          0-0 Dep. Melipilla
Dep. Ovalle         2-1 U. de Concepcion
Dep. Linares        4-2 U. San Felipe
Everton             3-1 Stgo. Morning

Round 27
(Nov 7)
U. Espanola         1-1 Antofagasta
Nublense            1-0 Reg. Atacama
O'Higgins           0-0 Fernandez Vial
(Nov 8)
Cobresal            2-1 Stgo. Morning
U. San Felipe       2-1 Everton
U. de Concepcion    2-1 Dep. Linares
Dep. Melipilla      2-0 Dep. Ovalle
Magallanes          2-1 Dep. Arica

Round 28
(Nov 14)
Dep. Arica          0-1 O'Higgins
Stgo. Morning       4-0 San Felipe
Dep. Ovalle         1-1 Magallanes
(Nov 15)
Fernandez Vial      3-2 Nublense
Reg. Atacama        0-2 U. Espanola 
Antofagasta         1-1 Cobresal
Everton             1-1 U. de Concepcion
Dep. Linares        3-2 Dep. Melipilla

Round 29
(Nov 21)
U. Espanola         1-1 Fernandez Vial
Dep. Melipilla      1-1 Everton
(Nov 22)
Cobresal            6-1 San Felipe
Antofagasta         2-0 Reg. Atacama
U. de Concepcion    2-0 Stgo. Morning
Magallanes          2-1 Dep. Linares
O'Higgins           2-0 Dep. Ovalle
Nublense            1-1 Dep. Arica

Round 30
(Nov 28)
Stgo. Morning       1-0 Dep. Melipilla
Dep. Ovalle         5-3 Nublense
(Nov 29)
Reg. Atacama        1-3 Cobresal
Dep. Arica          1-2 U. Espanola
Everton             4-0 Magallanes
Fernandez Vial      2-2 Antofagasta
San Felipe          5-4 U. de Concepcion
Dep. Linares        4-2 O'Higgins

Table:
 
 1.Cobresal               30 19  8  3  79-22  65  Champions, Promoted
 2.O'Higgins              30 19  2  9  61-39  59  Promoted
------------------------------------------------
 3.Santiago Morning       30 17  7  6  40-23  58  Promotion Playoff
 4.Unión Española         30 17  5  8  60-44  56  Promotion Playoff
 - - - - - - - - - - - - - - - - - - - - - - - -
 5.Univ. de Concepción    30 16  4 10  59-44  52
 6.Everton                30 14  6 10  43-30  48
 7.Deportes Linares       30 12  8 10  47-52  44
 8.Deportes Melipilla     30 10 13  7  42-35  43
 9.Magallanes             30 10 10 10  37-41  40
10.Unión San Felipe       30 11  2 17  40-65  35
11.Deportes Ovalle        30  8 10 12  39-44  34
12.Antofagasta            30  6 11 13  30-45  29
13.Arturo Fernández Vial  30  5 12 13  36-53  27
14.Deportes Arica         30  5 10 15  24-47  25
15.Ñublense               30  5  8 17  28-54  23
------------------------------------------------
16.Regional Atacama       30  3 10 17  23-50  19  Relegated [*]

[*] Regional Atacama are from Copiapo, but this season played home matches
    in nearby Tierra Amarilla.

Promoted from 3rd level: Deportes Colchagua

Topscorers:
Ruben Dundo             Argentina       Cobresal                19
Mario Nuñez             Chile           O'Higgins               19
Arturo Norambuena       Chile           U. de Concepcion        17
Wilson Fre              Chile           Cobresal                16
Luis Cueto              Chile           Dep. Melipilla          14

Promotion/Relegation Playoffs

First Legs [Dec 19]
Stgo. Morning   2-0 Prov. Osorno
U. Espanola     1-6 Coquimbo Unido

Second Legs [Dec 22]
Prov. Osorno    1-1 Stgo. Morning
Coquimbo Unido  1-3 U. Espanola

Prov. Osorno relegated, Santiago Morning promoted.


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,292,840 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.6081
Total Execution Time  0.6100
  CADENA URL  
/primera_b_apertura_fase_1_chile1998
  GET DATOS  
$_GET['/primera_b_apertura_fase_1_chile1998']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0125  SELECT type FROM routes WHERE alias = 'primera_b_apertura_fase_1_chile1998'
0.0252  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 = 1998 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=290 AND type_rel = 3
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 290 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 (350868,244378,241993,143444,97344) ORDER BY n.cover_points DESC, update_date DESC
0.0126  SELECT text_es as historical_text FROM leagues_text WHERE id=2405
0.0125  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 = 30651 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  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.0129  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='2017' WHERE c.parentId=1847 GROUP BY c.id ORDER BY c.order_id ASC
0.0125  SELECT type,rule FROM rules WHERE categoryId = 290 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 12:43:25' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 12:43:25' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 12:43:25' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 12:43:25' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0131  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 = 1998 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events1998 e WHERE e.league_id IN (30651) 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.0129  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 (30651) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0130  SELECT e.action, count(e.action) as total, e.player_id FROM events1998 e WHERE e.league_id IN (30651) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0130  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 (30651) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0132  SELECT e.action, count(e.action) as total, e.player_id FROM events1998 e WHERE e.league_id IN (30651) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0125  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 (30651) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events1998 e WHERE e.league_id IN (30651) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0131  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 (30651) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0130  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 = 30651 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0127  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 = 30651 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0137  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=30651 AND rel.round=30
0.0134  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 = 30651 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0136  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 = 30651 AND esl.points > 0
0.0137  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` = 30651 ORDER BY creation_date DESC LIMIT 0, 10
0.0152  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` = 30651
0.0132  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 `calendars1998` 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` = 30651 AND c.`round` = 30 ORDER BY shedule ASC LIMIT 200
0.0127  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 `events1998` e INNER JOIN calendars1998 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 = 30651 ORDER BY total DESC LIMIT 40
0.0130  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 `events1998` e INNER JOIN calendars1998 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 = 30651 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
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 `tables1998` 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 = 30651 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 *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1998` 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 = 30651 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 30651 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0131  SELECT data1, data2 FROM services_tags WHERE categoryId=290
0.0131  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 290 AND l.year = 1998 ORDER BY l.group_code ASC
0.0131  SELECT group_code, extraName from `leagues` WHERE categoryId=290 AND year=1998