4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 1998
Temporada Siguiente »
Publicidad 600x120.gif
Perú - Liga 1 Fase 2 1998
1997/1998

Perú - Liga 1 Fase 2 1998

Información Histórica 
						
Clausura
========


Round 1 [Jul 19]
Lawn Tennis        3-1 Unión Minas
  [Salazar 36' Bauzá 48' Montenegro (pk) 73' / Bergonzi 71']
Deportivo Pesquero 2-1 Municipal
  [Rodríguez (pk) 26' Gonzáles 52' / Amoako 87']
Alianza Atlético   2-3 Sporting Cristal
  [Abad 43' 60' / Mendoza 49' Nilson 61' Ferreyra 83']
Alianza Lima       4-1 Cienciano
  [Asprilla 25' 64' Chévez 45' 67'/ Vásquez (pk) 85']
Juan Aurich        0-4 Sport Boys
  [Pinillos (pk) 38' Silvera 39' Bica 51' Cavero 72']
Universitario      2-2 Melgar
  [Esidio 24' Portilla 59' / Ramírez 5' Sotomayor 79']

Round 2 [Jul 25,26]
Municipal          1-1 Juan Aurich
  [Calcaterra 66' / Rachumick 29']
Sport Boys         1-1 Universitario
  [Pinillos 11' / Falaschi 52']
Sporting Cristal   0-1 Pesquero
  [Gonzáles 45']
Unión Minas        2-1 Alianza Lima
  [Gallardo 55' Baldovino 60' / Jayo 44']
Cienciano          2-0 Alianza Atlético
  [Vásquez 30' Capreta 51']
Melgar             3-1 Lawn Tennis
  [Sotomayor 31' 90' Prado 73' / Bauzá 40'] 

Round 3 [Aug 1,2]
Alianza Lima       2-0 Melgar
  [Saavedra 6´ Asprilla 17´]
Alianza Atlético   3-0 Unión Minas
  [Abad 79´ 85´ Rickson 82´]
Lawn Tennis        0-1 Sport Boys
  [Bica 44´]
Deportivo Pesquero 0-0 Cienciano
Juan Aurich        2-1 Sporting Cristal
  [Reyes 20´ Mujica 90´ / P.Zegarra 66´]
Universitario      3-1 Municipal
  [Esidio 36´ Farfán 53´ Pereda (pk) 90´ / Calcaterra 81´]

Round 4 [Aug 08, 09]
Melgar             2-1 Alianza Atlético
  [Ramírez 29' Reyes 61' / Abad 90']
Sport Boys         0-0 Alianza Lima
Cienciano          1-0 Juan Aurich
  [Márquez (pk) 10']
Municipal          1-2 Lawn Tennis
  [Ciccia 55' / Salazar 60' Del Castillo 71']
Unión Minas        3-0 Deportivo Pesquero
  [Bergonzi 65' Baldovino 85' 90']
Sporting Cristal   2-0 Universitario
  [P.Zegarra 36' Jorge Soto 90']

Round 5 [Aug 15, 16]
Alianza Lima       2-1 Municipal
  [Baylón 68' 90' / Ciccia 75']
Deportivo Pesquero 0-0 Melgar
Alianza Atlético   0-0 Sport Boys
Lawn Tennis        1-1 Sporting Cristal
  [Bauzá (pk) 12' / Nilson 71']
Universitario      1-1 Cienciano
  [Grondona 67' / Cumapa 87']
Juan Aurich        2-1 Unión Minas
  [Reyes 10' 77' / Bergonzi 53']

Round 6 [Aug 22, 23]
Melgar             1-0 Juan Aurich
  [D.Ramírez 61']
Sport Boys         2-0 Deportivo Pesquero
  [Becerra 55' Ibarra 69']
Cienciano          4-0 Lawn Tennis
  [Chumpitaz 5' Rossel 58' Vásquez 63' Cumapa 79']
Municipal          0-1 Alianza Atlético
  [Soria 3']
Sporting Cristal   1-1 Alianza Lima
  [Julinho 1' / Asprilla 29']
Unión Minas        2-2 Universitario
  [Miñán 17' 46' / Carazas 9' Grondona 41']

Round 7 [Aug 29, 30]
Sporting Cristal   1-0 Cienciano
  [Asteggiano 48']
Melgar             1-0 Municipal
  [Sotomayor 76']
Lawn Tennis        0-0 Juan Aurich
Alianza Atlético   1-1 Alianza Lima
  [Ricardi (pk) 19'/ Saavedra 67']
Unión Minas        0-1 Sport Boys
  [Ibarra 35']
Universitario      1-1 Deportivo Pesquero
  [Falaschi 48' / Gonzáles 1']

Round 8 [Sep 5, 6]
Deportivo Pesquero 0-1 Lawn Tennis
  [Lobatón 83']
Municipal          2-3 Unión Minas
  [Calcaterra 6' Maldonado 37' / Quintana 60' D.Mendoza 81' Baldovino (pk) 89']
Sport Boys         2-0 Sporting Cristal
  [Valdiviezo 28' Cavero 84']
Juan Aurich        2-0 Alianza Atlético
  [Reyes 22' 42']
Cienciano          0-0 Melgar
Alianza Lima       1-0 Universitario
  [Gareca 77']

Round 9 [Sep 12, 13]
Unión Minas        1-0 Sporting Cristal
  [Miñán 5']
Municipal          1-2 Cienciano
  [Maldonado 39' / Rossel 5' López 88']
Lawn Tennis        2-0 Alianza Atlético
  [Salazar 33' Del Castillo 68']
Melgar             2-0 Sport Boys
  [P.Prado 23' A.Ramírez 63']
Universitario      1-0 Juan Aurich
  [Cotito 90']
Deportivo Pesquero 0-0 Alianza Lima

Round 10 [Sep 20]
Sporting Cristal   3-0 Melgar
  [Nilson 3' 34' Olcese 53']
Sport Boys         2-0 Municipal
  [Ibarra 42'(pk) 61']
Alianza Atlético   1-1 Universitario
  [Tavares 73' / Farfán 31']
Cienciano          0-0 Unión Minas
Juan Aurich        1-0 Deportivo Pesquero
  [Reyes 70']
Alianza Lima       1-1 Lawn Tennis
  [Baylón 76' / Lobatón 88']

Round 11 [Sep 27]
Municipal          2-1 Sporting Cristal
  [Amoako 5' 78' / Carty 56']
Sport Boys         2-0 Cienciano
  [Silvera 39' Canelo 90']
Deportivo Pesquero 2-0 Alianza Atlético
  [Chacón 53' Cruz 80']
Unión Minas        0-0 Melgar
Juan Aurich        0-0 Alianza Lima
Lawn Tennis        0-2 Universitario
  [Pajuelo 68' Esidio 84']

Round 12 [Oct 3,4]
Melgar             0-3 Universitario
  [Esidio 49' 64' Gallardo 69']
Municipal          0-3 Deportivo Pesquero
  [Cipriano 50' Gonzáles 61' Cruz 86']
Sport Boys         1-0 Juan Aurich
  [Valdiviezo 70']
Sporting Cristal   3-2 Alianza Atlético
  [Medina (og) 14' Jorge Soto 38' Mendoza 83' / Holsen 54' 57']
Unión Minas        2-0 Lawn Tennis
  [López 3' Quintana 77']
Cienciano          0-0 Alianza Lima

Round 13 [Oct 8,14]
Alianza Atlético   2-0 Cienciano
  [Holsen 16' Díaz (pk) 62']
Deportivo Pesquero 1-1 Sporting Cristal
  [Gonzáles 15' / Mendoza 90']
Juan Aurich        1-1 Municipal
  [Reyes 62' / Amoako 46']
Lawn Tennis        2-1 Melgar
  [López 58' 68' / Reyes 6']
Alianza Lima       0-0 Unión Minas
Universitario      3-0 Sport Boys
  [Farfán 24' 53' Esidio 68']

Round 14 [Oct 17,18]
Melgar             1-2 Alianza Lima
  [A.Ramírez (pk) 45' / Machaca 12' Jayo (pk) 37']
Municipal          1-1 Universitario
  [Olivares 69' / Gallardo 33']
Sporting Cristal   3-1 Juan Aurich
  [Nilson 45' Jorge Soto 68' 90' (pk) / Reyes 5']
Sport Boys         0-0 Lawn Tennis
Unión Minas        0-1 Alianza Atlético
  [Colchado 26']
Cienciano          2-0 Deportivo Pesquero
  [Rossel 10' Márquez 49']

Round 15 [Oct 25]
Deportivo Pesquero 3-0 Unión Minas
  [Cipriano 10' Gonzales 60' 79']
Alianza Atlético   2-2 Melgar
  [Colchado 13' Ricardi 30' / Sanjinez 23' A.Ramírez 35']
Juan Aurich        2-2 Cienciano
  [Mujica 46' Gamarra 74'/ Muñoz 61' 80']
Alianza Lima       3-1 Sport Boys
  [Silva 31' 34' Asprilla 69' (pk) / Ibarra 22']
Lawn Tennis        0-2 Municipal
  [Amoako 50' 90']
Universitario      0-2 Sporting Cristal
  [Carty 70' 80']

Round 16 [Oct 31, Nov 1]
Cienciano          0-0 Universitario
Melgar             2-0 Deportivo Pesquero
  [Cruvinel 4' Zeballos 45']
Sporting Cristal   2-1 Lawn Tennis
  [Nilson 17' 42' / Bauzá 39']
Municipal          1-1 Alianza Lima
  [Amoako 64' / Ribeiro 22']
Sport Boys         1-0 Alianza Atlético
  [Gil 84']
Unión Minas        1-1 Juan Aurich
  [Godoy 75' / Reyes 46']

Round 17 [Nov 7,8]
Alianza Lima       0-2 Sporting Cristal
  [Nilson 28' Mendoza 55']
Deportivo Pesquero 0-0 Sport Boys
Alianza Atlético   2-0 Municipal
  [Díaz 15' Abad 24']
Juan Aurich        3-2 Melgar
  [Chiquinho 26' Torres 34' 43' / Reyes 45' Arteaga 58']
Lawn Tennis        2-0 Cienciano
  [L.Rivas 11' Del Castillo 61']
Universitario      1-0 Unión Minas
  [Grondona 85']

Round 18 [Nov 15]
Alianza Lima       4-2 Alianza Atlético
  [Pizarro 17' 32' 42' Silva 81' / Díaz 9' Colchado 89']
Municipal          5-1 Melgar
  [Maldonado 13'(pk) Calcaterra 32' Baroni 51' Dulanto 77' Joya 87' / Lazo 7']
Deportivo Pesquero 2-2 Universitario
  [Gonzales 50' Cipriano 74' / Esidio 20' Grondona 35']
Sport Boys         2-1 Unión Minas
  [Villanueva 6' 57' / Baldovino 32'(pk)]
Juan Aurich        4-1 Lawn Tennis
  [Reyes 5' 66' 85'(pk) Chiquinho 39' / Salazar 54']
Cienciano          2-1 Sporting Cristal
  [Márquez 45' Cumapa 61' / Mendoza 37']

Round 19 [Nov 21, 22]
Unión Minas        2-1 Deportivo Municipal
  [Mori 20' Bergonzi 71' / Baroni 63']
Lawn Tennis        1-2 Deportivo Pesquero
  [Bauzá 57' / Portal 43' 74']
Universitario      0-3 Alianza Lima
  [Saavedra 34' Silva 55' Machaca 77']
Alianza Atlético   1-1 Juan Aurich
  [Abad 28' / Chiquinho 87']
Melgar             3-2 Cienciano
  [Lazo 18' 78' Sanjinez 61' / López 10' Márquez 56']
Sporting Cristal   2-0 Sport Boys     
  [Mendoza 49' Nilson 63']

Round 20 [Nov 28,29]
Alianza Lima       2-1 Deportivo Pesquero
  [Saavedra 18' Silva 55'(pk) / Cruz 64']
Sporting Cristal   4-2 Unión Minas
  [Mendoza 31' 43' Ferreira 47' Jorge Soto 50' / D.Mendoza 23' Valerio 40']
Alianza Atlético   2-1 Lawn Tennis
  [Holsen 62' Díaz 86'(pk) / Lobatón 88']
Sport Boys         3-0 Melgar
  [Gil 15' Becerra 42' Villanueva 43']
Juan Aurich        1-1 Universitario
  [Reyes 37' / Cantoro 53'(pk)]
Cienciano          4-1 Municipal
  [Takayama 26' Zegarra 31' Zúñiga 40' Márquez 84' / Ciccia 82']

Round 21 [Dec 5,6]
Unión Minas        0-0 Cienciano
Deportivo Pesquero 2-1 Juan Aurich
  [Cipriano 16' Fuentes 22' / Torres 88']
Melgar             0-1 Sporting Cristal
  [Rivera 75']
Municipal          0-1 Sport Boys
  [Becerra 37']
Lawn Tennis        1-5 Alianza Lima
  [Portilla 7' / Saavedra 17' 85'(pk) Asprilla 49' 52' Gareca 62']
Universitario      3-1 Alianza Atlético
  [Grondona 22' Portilla 23' Cantoro 31' / Soria 8']

Round 22 [Dec 8,12,13]
Melgar             3-1 Unión Minas
  [P.Prado 46' Valencia 80' A.Ramírez 85' / D.Mendoza 74']
Alianza Atlético   0-0 Deportivo Pesquero
Cienciano          0-0 Sport Boys
Sporting Cristal   7-2 Municipal
  [Jorge Soto 6' 25' 50' Nilson 37' Ferreira 56'(pk) Mendoza 60'
   Julinho 74' / Bustamante 76' Olivares 78']
Alianza Lima       2-1 Juan Aurich
  [Pizarro 57' 73' / Reyes 65']
Universitario      4-0 Lawn Tennis
  [Del Solar 42' Cotito 64' Barreto 77' Cordero 82']

Table:

 1.Sporting Cristal       22 13  3  6  41-23  42
 2.Alianza Lima           22 11  9  2  35-17  42
 3.Sport Boys             22 12  6  4  24-12  42
 4.Universitario          22  8 10  4  32-22  34
 5.Cienciano              22  7  9  6  23-20  29  [*]
 6.Deportivo Pesquero     22  7  8  7  20-20  29
 7.Melgar                 22  8  5  9  26-33  29
 8.Juan Aurich            22  6  8  8  24-27  26
 9.Alianza Atlético       22  6  6 10  24-30  24
10.Unión Minas            22  6  6 10  22-30  24
11.Lawn Tennis            22  6  4 12  20-38  22
12.Municipal              22  3  4 15  24-43  13

[*] Cienciano one point deducted for playing with 4 foreigners in 3rd round.

As three teams tied the first place, the two teams with the best goal
difference (Sporting Cristal and Alianza Lima) play off for the title.

Clausura Championship Playoff
December 16   Lima     Sporting Cristal - Alianza Lima              1-0
                         [Mendoza 42']

Sporting Cristal winners Clausura 1998.

Topscorer (Clausura 98)
---------
Martín Reyes (Juan Aurich)       14 goals
Nilson Esidio (Sporting Cristal) 10   “
Andres Mendoza (Sporting Cristal) 9   “
Jorge Soto (Sporting Cristal)     8   “
Alberto Ramirez (FBC Melgar)      8   “
Andres Gonzales (Dep. Pesquero)   8   “
 

Aggregate Table:

 1.Sport Boys             44 23 12  9  62-35  81
 2.Sporting Cristal       44 23 10 11  81-43  79  Clausura Champions
 3.Universitario          44 19 20  5  72-40  77  Apertura Champions
 4.Alianza Lima           44 21 15  9  70-38  75
 5.Deportivo Pesquero     44 17 14 13  53-49  65
 6.Unión Minas            44 17 10 17  55-60  61
 7.Juan Aurich            44 13 16 15  51-52  55
 8.Cienciano              44 13 16 15  47-47  54  [*]
 9.Alianza Atlético       44 12 14 18  57-66  50
10.Melgar                 44 15  7 22  46-69  52
 - - - - - - - - - - - - - - - - - - - - - - - -
11.Deportivo Municipal    44  9  8 27  47-91  35  Relegation Playoffs
------------------------------------------------
12.Lawn Tennis            44  9  6 29  36-87  33  Relegated

[*] Cienciano one point deducted


National Championship Playoff
December 20   Lima     Sporting Cristal - Universitario             2-1
                         [Nilson 30' Mendoza 40' / Guadalupe 62']
December 23   Lima     Universitario - Sporting Cristal             2-1  [4-2 pen]
                         [Farfán 40' 56' / Mendoza 74']
   Penalty shootout: Grondona (1-0), Ferreira (1-1), Casas (1-1), Jorge Soto (1-1),
                     Falaschi (2-1), Serrano (2-2), Gudalupe (3-2), Carty (3-2),
                     Esidio (4-2).
Universitario de Deportes are 1998 Champions of Peru.



Authors: José Luis Pierrend
(josepie@hotmail.com)
and Carlos Manuel Nieto Tarazona
(carmanieto@hotmail.com)

Last updated: 9 Jun 2006

(C) Copyright José Luis Pierrend,
Carlos Manuel Nieto Tarazona
and RSSSF 1999/2006


  USO DE MEMORIA  
4,269,336 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1006
Total Execution Time  0.1025
  CADENA URL  
/clausura_peru1998
  GET DATOS  
$_GET['/clausura_peru1998']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0018  SELECT type FROM routes WHERE alias = 'clausura_peru1998'
0.0043  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clausura_peru' 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.0023  SELECT text_es as historical_text FROM leagues_text WHERE id=1252
0.0019  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 29531 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026  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=45 ORDER BY l.group_code ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 05:48:09' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 05:48:09' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 05:48:09' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 05:48:09' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clausura_peru' 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.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events1998 e WHERE e.league_id IN (29531) 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.0019  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 (29531) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events1998 e WHERE e.league_id IN (29531) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0019  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 (29531) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events1998 e WHERE e.league_id IN (29531) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0019  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 (29531) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0024  SELECT e.action, count(e.action) as total, e.player_id FROM events1998 e WHERE e.league_id IN (29531) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0020  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 (29531) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0019  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 = 29531 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0018  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 = 29531 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0023  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=29531 AND rel.round=22
0.0021  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 = 29531 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0022  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 = 29531 AND esl.points > 0
0.0024  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` = 29531 ORDER BY creation_date DESC LIMIT 0, 10
0.0030  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` = 29531
0.0024  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` = 29531 AND c.`round` = 22 ORDER BY shedule ASC LIMIT 200
0.0018  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `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 = 22 AND e.real_date IS NOT NULL AND e.league_id = 29531 ORDER BY total DESC LIMIT 40
0.0022  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 = 29531 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0026  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 = 29531 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 29531 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 29531 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0026  SELECT data1, data2 FROM services_tags WHERE categoryId=53
0.0026  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 53 AND l.year = 1998 ORDER BY l.group_code ASC
0.0026  SELECT group_code, extraName from `leagues` WHERE categoryId=53 AND year=1998