4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
 
Temporada 2001
Temporada Siguiente »
Publicidad 600x120.gif
LPF Panamá - Clausura 2001
2000/2001

LPF Panamá - Clausura 2001

  • Liga Panamá
Información Histórica 
						
Torneo ANAPROF

Table:

 1.CD Árabe Unido     18 10  5  3  33-17  35
 2.Panamá Viejo FC    18 10  5  3  27-17  35 
 3.Tauro FC           18 10  4  4  42-25  34
 4.San Francisco FC   18  7  7  4  27-23  28  
 5.Atlético Nacional  18  6  6  6  26-24  24
 6.Alianza FC         18  6  5  7  19-23  23
 - - - - - - - - - - - - - - - - - - - - - - 
 7.CD Plaza Amador    18  6  4  8  25-22  22  
 8.Sporting '89       18  4  5  9  19-27  17      
 9.Chiriquí FC        18  4  5  9  22-40  17
--------------------------------------------
10.AFC Euro Kickers   18  2  4 12  26-48  10  Relegated   

Round 1
Tauro FC      0-1  Plaza Amador
Arabe Unido   0-1  Alianza
Euro Kickers  1-2  Panamá Viejo        [0-1?]
Sporting 89   0-1  San Francisco
Nacional      2-0  Chiriquí FC

Round 2
Arabe Unido   1-1  Tauro FC
Alianza       1-0  Plaza Amador
Nacional      2-0  Euro Kickers
San Francisco 2-0  Panamá Viejo
Sporting 89   3-1  Chiriquí FC

Round 3
Tauro FC      2-1  Alianza
Panamá Viejo  2-1  Plaza Amador
Nacional      1-0  Arabe Unido
Sporting 89   2-2  Euro Kickers
Chiriquí FC   2-3  San Francisco

Round 4
Euro Kickers  4-3  Tauro FC
Plaza Amador  1-3  Arabe Unido
San Francisco 0-1  Alianza
Chiriquí FC   1-1  Panamá Viejo
Nacional      0-1  Sporting 89

Round 5
Tauro FC      2-0  Panamá Viejo
Plaza Amador  1-1  Sporting 89
Arabe Unido   2-0  Chiriquí FC     
Alianza       1-0  Euro Kickers
San Francisco 1-1  Nacional    

Round 6
Sporting 89   0-4  Tauro FC
San Francisco 2-1  Plaza Amador
Euro Kickers  1-4  Arabe Unido
Chiriquí FC   2-1  Alianza
Panamá Viejo  3-0  Nacional     

Round 7
Tauro FC      3-0  San Francisco
Plaza Amador  2-1  Nacional
Arabe Unido   1-0  Panamá Viejo
Alianza       0-2  Sporting 89      
Euro Kickers  2-3  Chiriquí FC

Round 8
[Oct 1]
Nacional      3-4  Tauro FC
Chiriquí FC   1-0  Plaza Amador
Sporting 89   1-1  Arabe Unido
[Oct 8]
Euro Kickers  2-2  San Francisco
[Oct 18]
Panama Viejo  2-1  Alianza

Round 9
[Sep 28]
Arabe Unido   1-1  San Francisco
[Oct 6]
Panamá Viejo  2-0  Sporting 89
  [Phillips, Aparicio]
[Oct 8]
Tauro FC      1-0  Chiriquí FC
  [Guevara]
Alianza       1-5  Nacional
  [Mendieta; Gudiño, Marulanda, Zúñiga (2), Valdés]
[Oct 11]
Plaza Amador  3-0  Euro Kickers
  [Estrada, Hernández, Medina]

Round 10
[Oct 13]
Plaza Amador  abd  Tauro FC    [abandoned 1-0 after 45 minutes because of rain]
  [Tejada]
[Oct 14]
Sporting 89   1-3  San Francisco
  [Paz (pen); Garcés (2), Ortega]
Alianza FC    0-0  Arabe Unido
[Oct 15]
Panamá Viejo  2-0  Euro Kickers
  [Phillips, Martínez]
Nacional      3-3  Chiriquí FC
[Oct 24]
Plaza Amador  1-2  Tauro FC
  [Hernandez; Plua, Guevara]

Round 11
[Oct 20]
Plaza Amador  1-1  Alianza
  [Mendieta (pen); Medina]
Tauro FC      4-4  Arabe Unido
  [Plua (2), Nazarith, Serrano; Medina (2), Salinas, Cadena]
[Oct 22]
Chiriquí FC   2-1  Sporting 89
  [Navarro, Núñez; Dawson]
Euro Kickers  1-1  Atlético Nacional
  [Miranda; Zúñiga]
Panama Viejo  1-1  San Francisco
  [Hidalgo; Muñoz]

Round 12
[Oct 27]
Plaza Amador  1-1  Panamá Viejo FC
  [Correa; Muñoz]
Sporting 89   2-3  Euro Kickers
  [Cundumi, Dawson; Hilton, Samaniego (2)]
Nacional      1-3  Arabe Unido
  [Valdés; Cadena (3)]
[Oct 29]
Chiriquí FC   0-0  San Francisco
Alianza FC    2-2  Tauro FC
  [Mendieta, Brown; Tejada, Guevara]

Round 13
[Nov 1]
Tauro FC      2-1  Euro Kickers 
[Nov 3]
Arabe Unido   2-0  Plaza Amador
  [Cerezo (2)]
[Nov 5]
Nacional      0-0  Sporting 89
Panamá Viejo  2-2  Chiriquí
[Nov 8]
Alianza       1-1  San Francisco

Round 14
[Nov 10]
Euro Kickers  1-3  Alianza FC
  [Ardines; Brown, J.Arias, G.Arias]
Plaza Amador  2-1  Sporting 89
  [Ledezma, Medina]
Panama Viejo  3-1  Tauro FC
  [Canales (2), Martínez; Tejada]
Nacional      2-4  San Francisco
  [Marulanda, Díaz; Garcés, Calamaris, Arroyo, Hidalgo]
[Nov 12]
Arabe Unido   4-0  Chiriquí
  [Cerezo (3), Buchelli]

Round 15
[Nov 19]
San Francisco 0-0  Plaza Amador
[Nov 24]
Arabe Unido   2-1  Euro Kickers
  [Cerezo, Salinas; Baloy]
Nacional      1-1  Panama Viejo
  [Canales; Díaz]
[Nov 26]
Alianza       3-2  Chiriquí
  [Franco, López, Arias; Smith, Navarro]
[played later]
Tauro FC      2-3  Sporting 89

Round 16
[Nov 26]
Panama Viejo  2-1  Arabe Unido
  [Canales (2); Cerezo]
[Nov 27]
San Francisco 1-3  Tauro FC
  [Calamaris (pen); Tejada, Nazarith (2)]
[played later]
Nacional      2-0  Plaza Amador
Chiriquí FC   3-3  Euro Kickers
Sporting 89   0-0  Alianza

Round 17
Plaza Amador  3-0  Chiriquí FC
Tauro FC      0-0  Nacional
Alianza       1-2  Panamá Viejo
San Francisco 4-2  Euro Kickers
Arabe Unido   2-1  Sporting 89

Round 18
Nacional      1-0  Alianza
Chiriquí FC   0-6  Tauro FC
Sporting 89   0-1  Panama Viejo
San Francisco 1-2  Arabe Unido
Euro Kickers  2-7  Plaza Amador

Table:

 1.CD Árabe Unido     18 10  5  3  33-17  35
 2.Panamá Viejo FC    18 10  5  3  27-17  35 
 3.Tauro FC           18 10  4  4  42-25  34
 4.San Francisco FC   18  7  7  4  27-23  28  
 5.Atlético Nacional  18  6  6  6  26-24  24
 6.Alianza FC         18  6  5  7  19-23  23
 - - - - - - - - - - - - - - - - - - - - - - 
 7.CD Plaza Amador    18  6  4  8  25-22  22  
 8.Sporting '89       18  4  5  9  19-27  17      
 9.Chiriquí FC        18  4  5  9  22-40  17
--------------------------------------------
10.AFC Euro Kickers   18  2  4 12  26-48  10  Relegated          


Hexagonal Final

Table:

 1.Tauro FC            5  3  1  1  11- 7  10
 2.Panamá Viejo FC     5  2  1  2   8- 7   7
 3.Alianza FC          5  1  4  0   6- 5   7 
 4.San Francisco FC    5  2  1  2   4- 5   7
 - - - - - - - - - - - - - - - - - - - - - - 
 5.CD Arabe Unido      5  1  2  2   4- 6   5 
 6.Atlético Nacional   5  1  1  3   6- 9   4

Round 1
[Dec 15]
Nacional      1-3  Panama Viejo 
  [Paschall; Martínez, Canales (2)]
Alianza       1-1  San Francisco 
  [Mendieta; Piggot (pen)]
[Dec 17]
Arabe Unido   1-3  Tauro
  [Velásquez; Nazarith, Cubilla, Guevara]

Round 2
[Dec 21]
Alianza       0-0  Arabe Unido
[Dec 22]
Tauro FC      3-2  Panama Viejo
  [Nazarith, Parra, Guardia; Martínez, Canales]
San Francisco 1-0  Nacional
  [Hidalgo]

Round 3 [Dec 28]
San Francisco 2-1  Arabe Unido
  [Ortega, Garcés; Cerezo]
Tauro FC      2-3  Nacional
  [Parra (2); Zúñiga (3)]
Panama Viejo  1-2  Alianza
  [Canales; Mendieta, Solanilla]

Round 4
[Jan 5]
San Francisco 0-1  Panama Viejo
  [Aparicio]
Alianza       1-1  Tauro FC
  [Mendieta; Guevara]
[Jan 7]
Nacional      0-1  Arabe Unido    
  [Salinas]

Round 5
[Jan 12]
San Francisco 0-2  Tauro FC
  [Parra (2)]
[Jan 14]
Alianza FC    2-2  Nacional
  [Mendieta, Rentería; Galves (2)]
Arabe Unido   1-1  Panama Viejo
  [Cerezo; Phillips]

Table:

 1.Tauro FC            5  3  1  1  11- 7  10
 2.Panamá Viejo FC     5  2  1  2   8- 7   7
 3.Alianza FC          5  1  4  0   6- 5   7 
 4.San Francisco FC    5  2  1  2   4- 5   7
 - - - - - - - - - - - - - - - - - - - - - - 
 5.CD Arabe Unido      5  1  2  2   4- 6   5 
 6.Atlético Nacional   5  1  1  3   6- 9   4

Topscorers:

Alberto Cerezo     Arabe Unido          16
Ariel Canales      Panama Viejo FC      11
José Garcés        San Francisco        11
Luis Tejada        Tauro FC             11
José Ardines       Euro Kickers         10
Luis Parra         Tauro FC             10
Wilson Zúñiga      Atlético Nacional     9
Omar Navarro       Chiriquí FC           9
René Mendieta      Alianza FC            8
Jairo Cadena       Arabe Unido           8
Ricardo Phillips   Panamá Viejo          8
Alfredo Hernández  Plaza Amador          8


Semifinals

First Legs 
[Jan 21]
Panama Viejo  3-2  Alianza
  [Anel Canales 11, Ricardo Phillips 33, Blas Pérez 72; René Mendieta 77,
   Roberto Brown 90]
San Francisco abd  Tauro            [abandoned at 0-2 in 45' after pitch invasion]
  [Luis Parra (2)]
[Jan 24]
San Francisco 0-2  Tauro            [second half only]

Second Legs
[Jan 27]
Alianza       1-3  Panama Viejo
  [Ricardo Palomino 34; Marcos Aparicio 32, 52, Blas Pérez 75]
[Jan 28]
Tauro         3-2  San Francisco
  [Luis Parra 44, Frank Lozada 58, Rubén Guevara 62; Antonio Ortega 2,
   José Reyes 91]

Final  [Feb 4]
Panama Viejo  4-3  Tauro FC  (asdet)
  [Erick Martínez 36, 66, Ricardo Phillips 46, Rodney Ramos 102pen;
   Luis Parra 28, 68pen, Mario Méndez 71]



Topscorers:

Luis Parra         Tauro FC             16
Alberto Cerezo     Arabe Unido          16
Ariel Canales      Panama Viejo FC      11
José Garcés        San Francisco        11
Luis Tejada        Tauro FC             11
José Ardines       Euro Kickers         10
Wilson Zúñiga      Atlético Nacional     9
Omar Navarro       Chiriquí FC           9
Ricardo Phillips   Panamá Viejo          9



Author: Frank Ballesteros
(f-balles@uniandes.edu.co)

Last updated: 27 Mar 2001

(C) Copyright Frank Ballesteros and RSSSF 2000/01


  USO DE MEMORIA  
4,251,264 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0033
Controller Execution Time ( Home / Category )  0.7086
Total Execution Time  0.7119
  CADENA URL  
/clausura_panama2001
  GET DATOS  
$_GET['/clausura_panama2001']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0145  SELECT type FROM routes WHERE alias = 'clausura_panama2001'
0.0294  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clausura_panama' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2001 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=151 AND type_rel = 3
0.0151  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 151 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0148  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 (1261468,1215925,1201997,1201704,1194763) ORDER BY n.cover_points DESC, update_date DESC
0.0147  SELECT text_es as historical_text FROM leagues_text WHERE id=1076
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 = 29392 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=150 ORDER BY l.group_code ASC
0.0166  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='2024' WHERE c.parentId=150 GROUP BY c.id ORDER BY c.order_id ASC
0.0144  SELECT type,rule FROM rules WHERE categoryId = 151 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 18:01:40' 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 18:01:40' 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 18:01:40' 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 18:01:40' 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 = 'clausura_panama' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2001 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0146  SELECT e.action, count(e.action) as total, e.player_id FROM events2001 e WHERE e.league_id IN (29392) 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.0148  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 (29392) 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 events2001 e WHERE e.league_id IN (29392) AND (e.action IN (4,5) ) 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 (29392) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0146  SELECT e.action, count(e.action) as total, e.player_id FROM events2001 e WHERE e.league_id IN (29392) AND (e.action IN (3,4) ) 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 (29392) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0147  SELECT e.action, count(e.action) as total, e.player_id FROM events2001 e WHERE e.league_id IN (29392) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0147  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 (29392) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0147  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 = 29392 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0145  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 = 29392 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0147  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=29392 AND rel.round=18
0.0147  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 = 29392 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0147  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 = 29392 AND esl.points > 0
0.0149  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` = 29392 ORDER BY creation_date DESC LIMIT 0, 10
0.0170  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` = 29392
0.0159  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 `calendars2001` 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` = 29392 AND c.`round` = 18 ORDER BY shedule ASC LIMIT 200
0.0147  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 `events2001` e INNER JOIN calendars2001 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 = 18 AND e.real_date IS NOT NULL AND e.league_id = 29392 ORDER BY total DESC LIMIT 40
0.0158  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 `events2001` e INNER JOIN calendars2001 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 = 29392 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0150  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 `tables2001` 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 = 29392 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2001` 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 = 29392 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 29392 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0150  SELECT data1, data2 FROM services_tags WHERE categoryId=151
0.0150  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 151 AND l.year = 2001 ORDER BY l.group_code ASC
0.0150  SELECT group_code, extraName from `leagues` WHERE categoryId=151 AND year=2001