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

Perú - Liga 1 Fase 2 1999

Información Histórica 
						

Clausura
========


Round 1
[Jul 24]
Alianza Lima         4-0 IMI F.C.
  [J.Hinostroza 41' Mafla 53' Baylón 76' Ascoy 82']
Universitario        2-0 Unión Minas
  [J.Del Solar 2' Farfán 6']
[Jul 25]
Juan Aurich          1-1 Sporting Cristal
  [Guido 60'(pk) / Olcese 49']
Cienciano            1-1 Sport Boys 
  [Begazo 47'(pk) / Tierradentro 36']
Deportivo Municipal  1-1 Deportivo Pesquero
  [Matamba 51' / Molina 32']
[Jul 26]
Alianza Atlético     1-0 Melgar
  [Prado 57']

Round 2 
[Jul 31]
Unión Minas          7-0 Deportivo Municipal
  [Castillo 6'(pk) 89' Berrío 15' 29' Mori 60' Lazo 78' Montenegro 85']
[Aug 1]
Sporting Cristal     1-3 Cienciano
  [Mendoza 52' / Rossel 77' Zegarra 84' Cruzate 89']
IMI F.C.             0-2 Alianza Atlético
  [Da Silva 71' Rivera 88']
Melgar               4-0 Juan Aurich
  [Baroni 8' 13' 64' Tempone 59']
Deportivo Pesquero   0-4 Alianza Lima
  [Salazar 23' Pizarro 31' Penalillo 35' Moreno 55']
Sport Boys           1-0 Universitario
  [Lobatón 49']

Round 3
[Aug 8]
Alianza Atlético     4-0 Deportivo Pesquero
  [Rodríguez 43' Ramírez 59' 70' Rivera 83']
Deportivo Municipal  1-2 Sport Boys
  [Alfaro 26' / Pinillos 20' Becerra 45']
Universitario        2-1 Sporting Cristal
  [Cantoro 15' Farfán 83' / Julinho 14']
Juan Aurich          3-1 IMI F.C.
  [A.Torres 31' Vassallo 62' Guido 83'(pk) / Aranda 67']
Alianza Lima         7-1 Unión Minas
  [Pizarro 16' 21' 39' 51'(pk) 57' Quinteros 34' P.Hinostroza 86' / Castillo 38'(pk)]
Cienciano            2-1 Melgar
  [Rossel 20' Varela 81' / Y.Zúñiga 48'(pk)]

Round 4
[Aug 13]
Melgar               2-0 Universitario
  [Y.Zúñiga 12' 61'(pk)]
[Aug 14]
Unión Minas          2-2 Alianza Atlético
  [Berrío 25' Lazo 74' / Soria 50' Díaz 73'(pk)]
[Aug 15]
Sporting Cristal     6-0 Deportivo Municipal
  [Olcese 15' 32' Silva 21' Sánchez 48' Zabárbulo 80' Prado 90']
IMI F.C.             0-0 Cienciano
Sport Boys           2-1 Alianza Lima
  [Pinillos 21' Marquinho 39'(pk) / Pizarro 29']
Deportivo Pesquero   0-2 Juan Aurich
  [Vassallo 23' 87']

Round 5
[Aug 21]
Alianza Lima         2-1 Sporting Cristal
  [Moreno 42' Baylón 52' / Olcese 45'(pk)]
[Aug 22]
Alianza Atlético     1-1 Sport Boys
  [Salinas 78' / Lobatón 72']
Deportivo Municipal  2-3 Melgar
  [Vásquez 17' 74'(pk) / C.Zúñiga 11' 49' Cavero 19']
Juan Aurich          1-1 Unión Minas
  [Sastoque 33' / Lazo 39']
Cienciano            0-0 Deportivo Pesquero
Universitario        6-1 IMI F.C.
  [Esidio 10' Cantoro 59'(pk) 73'(pk) Coria 79' 85' Maldonado 88' / Sandi 66'] 

Round 6
[Aug 28]
Sporting Cristal     3-2 Alianza Atlético
  [Sánchez 15' 30' 45' / Rodríguez 52' 63'(pk)]
[Aug 29]
IMI F.C.             0-0 Deportivo Municipal
Sport Boys           2-0 Juan Aurich
  [Marquinho 23'(pk) Lobatón 57']
Deportivo Pesquero   2-2 Universitario
  [Cipriano 32' 90' / Cantoro 60'(pk) Portilla 82']
Unión Minas          1-1 Cienciano
  [Lazo 26' / Flores 13']
Alianza Lima         1-0 Melgar
  [Reyes 67']

Round 7
[Sep 4]
Unión Minas          3-0 Sport Boys
  [Berrío 23' Montenegro 32' Castillo 55']
Universitario        2-2 Cienciano 
  [Esidio 27' Cantoro 67' / Rossel 45' Cumapa 68']
[Sep 5]
Sporting Cristal     4-0 IMI F.C.
  [Ferrari 20' Sánchez 48' Julinho 75' Silva 77']
Alianza Atlético     5-0 Deportivo Municipal
  [Medina 6' Soria 8' Prado 20' Salinas 50' Morán 65']
Melgar               5-2 Deportivo Pesquero 
  [Y.Zúñiga 1' Uehara 58' 77' Alcíbar 65' Zeballos 76' / Silvera 79'(pk) Cipriano 84']
Juan Aurich          0-1 Alianza Lima
  [Quinteros 38']

Round 8
[Sep 11]
Deportivo Municipal  0-1 Juan Aurich
  [Vassallo 24'(pk)]
Sport Boys           2-0 Melgar
  [Marquinho 65' Lobatón 85']
Alianza Lima         0-0 Universitario
[Sep 12]
IMI F.C.             4-3 Unión Minas
  [Rachumick 1' 76' Zapata 22' P.Peña 66' / Castillo 24' 53' 58']
Deportivo Pesquero   1-1 Sporting Cristal
  [Morote 90' / Holsen 74']
Cienciano            0-0 Alianza Atlético
 
Round 9
[Sep 15]
Sport Boys           1-0 Deportivo Pesquero
  [Gil 33']
Sporting Cristal     5-1 Unión Minas
  [Julinho 33' Sánchez 57' Silva 59' Zabárbulo 67' Holsen 75' / Castillo 41'(pk)]
Cienciano            2-0 Deportivo Municipal 
  [Miñán 10' 15']
Alianza Atlético     1-2 Alianza Lima
  [Díaz 34' / Moreno 8' 43']
Juan Aurich          0-1 Universitario 
  [Cantoro 66']
Melgar               2-0 IMI F.C.
  [Y.Zúñiga 47' Cavero 62']

Round 10
[Sep 18]
Alianza Lima         4-0 Deportivo Municipal
  [Moreno 57' Quinteros 63' Cominges 70' Sáenz 74']
[Sep 19]
IMI F.C.             1-1 Deportivo Pesquero
  [Rachumick 46' / Cipriano 20']
Sporting Cristal     2-1 Sport Boys
  [Mendoza 33' Ferreira 82' / Lobatón 6']
Unión Minas          1-1 Melgar
  [Ramírez 46' / Bermúdez 34']
Juan Aurich          3-0 Cienciano
  [Vassallo 9' 87' Tamashiro 30']
Universitario        2-0 Alianza Atlético
  [J.Del Solar 31' Farfán 38']

Round 11
[Sep 26]
Deportivo Pesquero   1-0 Unión Minas
  [Márquez 72']
Alianza Atlético     2-0 Juan Aurich
  [García 7' 22']
Sport Boys           2-0 IMI F.C.
  [Reátegui 30' Lobatón 81']
Cienciano            2-1 Alianza Lima
  [Zapata 32' Serrano 67' / Baylón 3']
Melgar               1-1 Sporting Cristal
  [Y.Zúñiga 37' / Olcese 7']
Deportivo Municipal  0-1 Universitario
  [J.Del Solar 22']

Round 12
[Oct 2]
Melgar               2-0 Alianza Atlético
  [Reyes 46' Uehara 79']
[Oct 3]
Sporting Cristal     2-1 Juan Aurich
  [Olcese 62' Silva 68' / Takayama 33']
Sport Boys           2-1 Cienciano
  [Marquinho 90'(pk) Martínez 91' / Zapata 15']
IMI F.C.             1-1 Alianza Lima
  [Peña 35' / Quinteros 73']
Deportivo Pesquero   0-1 Deportivo Municipal
  [Reyes 3']
Unión Minas          3-0 Universitario
  [Ramírez 9' Lazo 38' Fuentes 87']

Round 13
[Oct 10]
Alianza Atlético     7-0 IMI F.C.
  [Rodríguez 2' García 27' 32' 52' Prado 28' 77' Soria 34']
Deportivo Municipal  3-2 Unión Minas
  [Reyes 12' 70' Vásquez 55' / Berrío 37' 46']
Universitario        3-1 Sport Boys
  [Esidio 33' Farfán 53' Coria 85'(pk) / Pinillos 46']
Alianza Lima         1-0 Deportivo Pesquero
  [Nazarith 82']
Juan Aurich          3-0 Melgar
  [Vassallo 18' Takayama 59' Soto 65']
Cienciano            2-0 Sporting Cristal     
  [Varela 31' Zapata 34'] 
  Note: Cienciano fielded four foreigners against the rules; result stands for
        Cristal but it is changed to 0-2 for Cienciano which gets no points.

Round 14
[Oct 17]
IMI F.C.             0-1 Juan Aurich 
  [Arteaga 83']
Deportivo Pesquero   0-0 Alianza Atlético
Sport Boys           3-1 Deportivo Municipal
  [Lobatón 39' Becerra 73' Ibarra 82' / Carmona 58']
Unión Minas          0-0 Alianza Lima
Melgar               2-0 Cienciano
  [Y.Zúñiga 3'(pk) Cruvinel 88']
Sporting Cristal     2-2 Universitario
  [Ferreira 24' 45' / Portilla 64' Esidio 85'(pk)]

Round 15
[Oct 23]
Deportivo Municipal  1-3 Sporting Cristal
  [Reyes 83'(pk) / Ferreira 11. Hidalgo 57' Julinho 61']
Alianza Lima         abd Sport Boys         [abd at 1-1 in 28']
  [Sáenz 18' / Gil 6']
[Oct 24]
Alianza Atlético     1-1 Unión Minas
  [Ramírez 28' / Fuentes 82']
Juan Aurich          0-1 Deportivo Pesquero
  [Cipriano 30']
Cienciano            3-0 IMI F.C.
  [Zapata 29' 45' Cumapa 54']
Universitario        4-2 Melgar
  [J.Del Solar 19' Pajuelo 41' Esidio 50' Cantoro 86'(pk) / Y.Zúñiga 29' 48'(pk)]
[Oct 26]
Alianza Lima         1-1 Sport Boys         [remaining 62'; behind closed doors]

Round 16
[Oct 31]
Deportivo Pesquero   1-1 Cienciano
  [Márquez 52' / Miñán 85']
IMI F.C.             0-0 Universitario
Sport Boys           1-1 Alianza Atlético
  [Vegas 56' / García 86'(pk)]
Unión Minas          3-0 Juan Aurich  
  [Castillo 48' 85' Muñoz 80']
Melgar               4-2 Deportivo Municipal 
  [Cruvinel 19' Y.Zúñiga 48' 82' C.Zúñiga 78' / Torrejó 23' Da Costa 32']
Sporting Cristal     2-2 Alianza Lima
  [Ferreira 40' 68'(pk) / Sáenz 11' Flores 45'(pk)]
 
Round 17
[Nov 6]
Deportivo Municipal  2-0 IMI F.C.
  [Reyes 3' Céspedes 90']
Universitario        5-0 Deportivo Pesquero
  [Grondona 2' 32' J.Del Solar 44' Coria 50' Cantoro 85']
[Nov 7]
Alianza Atlético     1-3 Sporting Cristal
  [Prado 87' / Sánchez 21' Holsen 26' Ferreira 84']
Melgar               2-1 Alianza Lima
  [Y.Zúñiga 25' Uehara 85' / Quinteros 82']
Cienciano            2-2 Unión Minas
  [Begazo 38'(pk) 52'(pk) / Godoy 22' 39']
Juan Aurich          5-2 Sport Boys 
  [Tamashiro 22' 48' Flores 46' Vassallo 68'(pk) Torres 76' / Villanueva 24' Calcaterra 51']

Round 18 
[Nov 14]
Deportivo Pesquero   2-0 Melgar
  [Ricardi 7'(pk) Cruz 70']
IMI F.C.             0-2 Sporting Cristal 
  [Sánchez 45' Holsen 61']
Sport Boys           4-0 Unión Minas
  [Tierradentro 21' Villanueva 36' Calcaterra 39' Lobatón 54']
Deportivo Municipal  2-1 Alianza Atlético
  [Spontón 68' Carmona 85' / Ramírez 32']
Alianza Lima         2-1 Juan Aurich
  [Mafla 32' Moreno 50' / Vassallo 87']
Cienciano            2-2 Universitario
  [Begazo 35' Zapata 58' / Bernales 14' Esidio 61']

Round 19
[Nov 20]
Unión Minas          4-0 IMI F.C.
  [Berrío 8' Godoy 18' Castillo 33' F.Hernández 88']
Melgar               2-0 Sport Boys
  [Y.Zúñiga 59' Uehara 71']
[Nov 21]
Sporting Cristal     2-1 Deportivo Pesquero
  [Mendoza 37' 64' / Silvera 50']
Alianza Atlético     2-0 Cienciano
  [Rivera 37' 52']
Juan Aurich          1-1 Deportivo Municipal
  [Uribe 79' / Reyes 80']
Universitario        2-3 Alianza Lima
  [Farfán 2' Esidio 70' / Moreno 47' Sáenz 68'(pk) 86'(pk)]

Round 20
[Nov 26]
Alianza Lima         1-0 A. Atlético
  [Chacón 90']
[Nov 28]
Deportivo Pesquero   1-1 Sport Boys 
  [Silvera 81' / Calcaterra 30']
Unión Minas          3-0 Sporting Cristal
  [Castillo 50' 59' Lazo 53']
IMI F.C.             2-2 Melgar
  [Peña 58' Bello 64' / Y.Zúñiga 35' Cavero 67']
Deportivo Municipal  2-1 Cienciano
  [Reyes 47' Carmona 80' / Zapata 17']
Universitario        2-0 Juan Aurich  
  [Grondona 26' Alva 33']

Round 21
[Dec 5]
Deportivo Pesquero   3-2 IMI F.C.
  [Espinoza 37' Cruz 40' Ricardi 52' / Sanjinez 20' Bello 64']
Sport Boys           2-1 Sporting Cristal
  [Vegas 33'(pk) 61'(pk) / Julinho 15']
Alanza Atlético      2-5 Universitario
  [García 34'(pk) Habrahamshon 75' / Cantoro 5' Esidio 16' Bernales 29' Alva 62' Coria 77']
Deportivo Municipal  1-6 Alianza Lima
  [Domínguez 41' / Moreno 9' 34' Sáenz 58'(pk) 68' 71' Chévez 82']
Cienciano            3-0 Juan Aurich
  [Miñán 8' 26' Zapata 45']
Melgar               5-1 Unión Minas
  [Y.Zúñiga 8' 66' Cavero 20' 23' C.Zúñiga 64' / Berrío 26']

Round 22
[Dec 8]
Sporting Cristal     3-2 Melgar
  [Olcese 65' Silva 73' R.Salazar 87' / Y.Zúñiga 44' Cruvinel 90']  
Juan Aurich          3-1 Alianza Atlético
  [Tamashiro 28' 58' 80' / Rivera 69']
[Dec 11]
Universitario        1-0 Deportivo Municipal
  [Coria 13']
Alianza Lima         2-1 Cienciano
  [Cominges 54' Sáenz 58' / Begazo 55']
[Dec 12]
IMI F.C.             0-0 Sport Boys    
Unión Minas          4-0 Deportivo Pesquero
  [Lazo 3' 60' Castillo 17' Godoy 21']

Table:

 1. Alianza Lima           22 14  5  3  47-18  47  Clausura Champions
 2. Universitario          22 12  6  4  44-24  42
 3. Sport Boys             22 11  6  5  32-25  39
 4. Sporting Cristal       22 11  5  6  46-31  38
 5. Melgar                 22 11  3  8  44-30  36
 6. Unión Minas            22  7  7  8  43-39  28
 7. Alianza Atlético       22  7  6  9  36-28  27
 8. Cienciano              22  7  9  6  27-27  27  [*]
 9. Juan Aurich            22  8  3 11  26-32  27
10. Deportivo Pesquero     22  4  8 10  17-38  20
11. Deportivo Municipal    22  5  3 14  20-54  18
12. IMI F.C.               22  1  7 14  12-52  10

[*] Cienciano lost the points for the victory over Cristal in rd 13.
  
Topscorers:

Ysrael Zúñiga (Melgar)          17 
Harry Castillo (Unión Minas)    14 
Mauro Cantoro (Universitario)    9 
Jorge Lazo (Unión Minas)         9 
Tressor Moreno (Alianza Lima)    9 
Waldir Sáenz (Alianza Lima)      9 
Gustavo Vassallo (Juan Aurich)   9

Aggregate Table:

 1. Alianza Lima           44 28  9  7  98-38  93  Clausura Champions
 2. Universitario          44 27 11  6  79-39  92  Apertura Champions
 3. Sporting Cristal       44 22 13  9  96-54  79  Copa Libertadores
 4. Melgar                 44 20  9 15  79-57  69
 5. Sport Boys             44 18 15 11  61-55  69
 6. Cienciano              44 17 14 13  59-52  62  [*]
 7. Unión Minas            44 13 14 17  72-68  53
 8. Alianza Atlético       44 13 13 18  71-66  52
 9. Juan Aurich            44 12  9 23  47-70  45
10. Deportivo Municipal    44 10  9 25  42-90  39
- - - - - - - - - - - - - - - - - - - - - - - - -
11. Deportivo Pesquero     44  6 17 21  35-81  35  Relegation Playoff
-------------------------------------------------
12. IMI F.C.               44  6 11 27  34-107 29  Relegated

[*] Cienciano lost the points for the victory over Cristal in rd 13 Clausura.
  
Note: IMI F.C. is for [International Marine Inc.].


Relegation Playoff [Dec 18, Lima]

Pesquero      2-2 América Cochahuayco [aet, 4-3 pen]
 [Espinoza 60' Silvera 61' / Carrión 45' Ibarra 72']

Deportivo Pesquero remains in Primera Division for 2000.

Championship Playoff

First Leg [Dec 15]
Universitario 3-0 Alianza Lima   
  [Farfán 10' Esidio 49' J.Del Solar 73']

Second Leg [Dec 20]
Alianza Lima  1-0 Universitario     
  [Mafla 45']
 
Universitario de Deportes are 1999 Champions


Season Topscorers: 

Ysrael Zúñiga (Melgar)                                32 
Harry Castillo (Unión Minas)                          24 
Waldir Sáenz (Alianza Lima)                           22 
Roberto Holsen (Alianza Atlético / Sporting Cristal)  19 
Claudio Pizarro (Alianza Lima)                        19 



Author: José Luis Pierrend
(josepie@hotmail.com)

Last updated: 21 Feb 2000

(C) Copyright José Luis Pierrend and RSSSF 1999/2000


  USO DE MEMORIA  
4,272,608 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  2.2744
Total Execution Time  2.2764
  CADENA URL  
/clausura_peru1999
  GET DATOS  
$_GET['/clausura_peru1999']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0125  SELECT type FROM routes WHERE alias = 'clausura_peru1999'
0.0252  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 = 1999 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=53 AND type_rel = 3
0.0130  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 53 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  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 (1217683,1197918,1196384,1196209,1195528) ORDER BY n.cover_points DESC, update_date DESC
0.0130  SELECT text_es as historical_text FROM leagues_text WHERE id=1251
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 = 29530 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130  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.0125  SELECT type,rule FROM rules WHERE categoryId = 53 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 09:18:22' 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 09:18:22' 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 09:18:22' 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 09:18:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  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 = 1999 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0125  SELECT e.action, count(e.action) as total, e.player_id FROM events1999 e WHERE e.league_id IN (29530) 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.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 (29530) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0125  SELECT e.action, count(e.action) as total, e.player_id FROM events1999 e WHERE e.league_id IN (29530) AND (e.action IN (4,5) ) 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 (29530) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0125  SELECT e.action, count(e.action) as total, e.player_id FROM events1999 e WHERE e.league_id IN (29530) 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 (29530) 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 events1999 e WHERE e.league_id IN (29530) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0126  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 (29530) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0126  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 = 29530 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0125  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 = 29530 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0125  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 53 GROUP BY l.categoryId
1.6259  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=53 GROUP BY l.year ORDER BY l.year DESC
0.0160  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=29530 AND rel.round=22
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 = 29530 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0131  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 = 29530 AND esl.points > 0
0.0143  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` = 29530 ORDER BY creation_date DESC LIMIT 0, 10
0.0138  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` = 29530
0.0129  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 `calendars1999` 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` = 29530 AND c.`round` = 22 ORDER BY shedule ASC LIMIT 200
0.0124  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 `events1999` e INNER JOIN calendars1999 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 = 29530 ORDER BY total DESC LIMIT 40
0.0128  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 `events1999` e INNER JOIN calendars1999 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 = 29530 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0139  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 `tables1999` 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 = 29530 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1999` 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 = 29530 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139  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 = 29530 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0139  SELECT data1, data2 FROM services_tags WHERE categoryId=53
0.0139  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 53 AND l.year = 1999 ORDER BY l.group_code ASC
0.0139  SELECT group_code, extraName from `leagues` WHERE categoryId=53 AND year=1999