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
Liga Belice - Clausura 1999
1998/1999

Liga Belice - Clausura 1999

  • Liga Belice
Información Histórica 
						

Regular Season
==============

[No zonal qualifications this season.]

Final Table First Half:

 1.Juventus Pepsi (Orange Walk)                 9  6  3  0 22-10 21  [1]
 2.La Victoria Dolphins (Corozál)               9  6  2  1 16- 6 20  [2]
-------------------------------------------------------------------
 3.Sagitún (Independence)                       9  4  4  1 14- 9 16  [3]
 4.Yabra (Belize City)                          9  3  4  2 18-12 13
 5.Acros (Belize City)                          9  3  4  2 12- 7 13
 6.Builders Bandits (Belmopán)                  9  2  4  3 10-13 10
 7.Dangriga Jaguars                             9  3  0  6 11-19  9 
 8.Juventud Benqueña (Benque Viejo del Carmen)  9  2  2  5 11-21  8
 9.Real Verdes (Benque Viejo del Carmen)        9  2  1  6  7-14  7 
10.Southern United (Punta Gorda)                9  2  0  7  8-18  6 

Juventus Pepsi (Orange Walk) and La Victoria Dolphins (Corozál) qualified
for championship playoff.

[1] Juventus Pepsi is the new name of Juventus Caribbean; there were rumours 
    that Juventus have withdrawn from the league and dissolved the team
    over a rules dispute with the league.  They eventually remained in the
    league but under new ownership and having lost their best players.
[2] San Pedro Dolphins had problems with their home field, so they have
    moved to Corozal and will be known as La Victoria Dolphins.
[3] Midsouth FC is former Corozal FC, loaned out for a year.  After one
    round they were renamed Sagitún.

Round 1 (Sep 6)
Real Verdes      awd Juventud        [awarded to Juventud; originally 3-2 but
Yabra            0-0 Acros            Verdes fielded ineligible player]
Dangriga Jaguars 1-0 Midsouth FC
Southern United  1-0 Belmopan Bandits
Juventus         2-2 La Victoria     [played later]

Round 2 (Sep 13)
Dangriga Jaguars 1-2 Juventus  
La Victoria      awd Acros           [awarded to Acros; originally 2-2 but La
Belmopan Bandits 2-1 Juventud         Victoria fielded too many foreigners]
Sagitun          1-0 Southern United
Yabra            2-1 Real Verdes 

Round 3
Acros            1-2 Sagitun          
Juventus         3-2 Yabra
Juventud         0-1 La Victoria   
Southern United  3-0 Dangriga
Belmopan Bandits 0-0 Real Verdes     [1-1?]

Round 4
Real Verdes      1-0 Acros
Sagitun          1-1 Juventus
Yabra            4-0 Southern United
La Victoria      4-0 Belmopan Bandits
Dangriga         4-1 Juventud

Round 5 (Oct 3)
Juventus         5-1 Real Verdes
Belmopan Bandits 1-1 Sagitun
Southern United  1-2 La Victoria
Acros            4-1 Dangriga Jaguars
Juventud         1-1 Yabra

Round 6 (Oct 11)
Acros            1-1 Juventus
La Victoria      1-0 Yabra
Juventud         4-2 Southern United
Sagitun          1-0 Real Verdes
Belmopan         2-0 Dangriga Jaguars

Round 7 (Oct 18)
Yabra            3-3 Belmopan
Southern United  0-4 Acros
Dangriga         2-1 Real Verdes
Juventus         6-2 Juventud
La Victoria      1-1 Sagitun

Round 8 (Oct 25)
Juventus         1-0 Belmopan
Acros            0-0 Juventud        [awarded to Acros?]
Sagitun          2-2 Yabra
Dangriga         1-2 La Victoria
Real Verdes      2-1 Southern United

Round 9 (Nov 8)
Yabra            4-1 Dangriga
Juventus         1-0 Southern United
Sagitun          5-2 Juventud
La Victoria      3-1 Real Verdes
Belmopan         2-2 Acros

Final Table First Half:

 1.Juventus Pepsi (Orange Walk)                 9  6  3  0 22-10 21  [1]
 2.La Victoria Dolphins (Corozál)               9  6  2  1 16- 6 20  [2]
-------------------------------------------------------------------
 3.Sagitún (Independence)                       9  4  4  1 14- 9 16  [3]
 4.Yabra (Belize City)                          9  3  4  2 18-12 13
 5.Acros (Belize City)                          9  3  4  2 12- 7 13
 6.Builders Bandits (Belmopán)                  9  2  4  3 10-13 10
 7.Dangriga Jaguars                             9  3  0  6 11-19  9 
 8.Juventud Benqueña (Benque Viejo del Carmen)  9  2  2  5 11-21  8
 9.Real Verdes (Benque Viejo del Carmen)        9  2  1  6  7-14  7 
10.Southern United (Punta Gorda)                9  2  0  7  8-18  6 

Juventus Pepsi (Orange Walk) and La Victoria Dolphins (Corozál) qualified
for championship playoff.


Table Second Half (w/o goals rd 15):

 1.Sagitún (Independence)                       9  7  1  1 18- 8 22  [3]
 2.Juventus Pepsi (Orange Walk)                 9  5  3  1 17- 7 18  [1]
 3.Builders Bandits (Belmopán)                  9  5  1  3 15-14 16
-------------------------------------------------------------------
 4.La Victoria Dolphins (Corozál)               9  4  2  3 14-10 14  [2]
 5.Dangriga Jaguars                             9  4  2  3 10-20 14  [*12]
 6.Juventud Benqueña (Benque Viejo del Carmen)  9  3  4  2 15-13 13
 7.Southern United (Punta Gorda)                9  2  3  4  6-10  9  [*12]
 8.Yabra (Belize City)                          9  2  2  5 11-12  8
 9.Real Verdes (Benque Viejo del Carmen)        9  0  4  5 10-15  4
10.Acros (Belize City)                          9  0  4  5  5-12  4

[*12] w/o goals in rd 12

Sagitún (Independence) and Builders Bandits (Belmopán) qualified
for playoffs.

Round 10
La Victoria      0-0 Juventus
Yabra            2-0 Acros
Juventud         3-1 Real Verdes     [2-0?]
Belmopan         2-2 Southern United
Sagitun          3-1 Dangriga  

Round 11
Juventus        10-1 Dangriga
Acros            0-2 La Victoria
Juventud         2-1 Belmopan        [1-0?]
Southern U.      0-1 Sagitun
Real Verdes      1-1 Yabra

Round 12
Sagitun          3-1 Acros
Yabra            1-1 Juventus
La Victoria      3-2 Juventud
Real Verdes      2-3 Bandits
Jaguars          bt  Southern United

Round 13 [Dec 6]
Acros            1-1 Real Verdes 
Juventus         1-0 Sagitun 
Bandits          2-1 La Victoria 
Juventud         3-1 Dangriga    
Southern U.      2-1 Yabra

Round 14 [Dec 13]
Yabra            3-1 Juventud
Sagitun          6-2 Belmopan
Juventus         4-2 Real Verdes
La Victoria      5-1 Southern Utd
Acros            1-1 Dangriga

Round 15 
Juventus         bt  Acros        (4-1?)
Yabra            lt  La Victoria  (0-4?)
Southern U.      drw Juventud     (0-0?)
Real Verdes      lt  Sagitun      (1-4?)
Dangriga         bt  Belmopan   

Round 16
Sagitun          1-0 La Victoria
Belmopan         2-1 Yabra
Jaguars          1-1 Real Verdes
Acros            1-1 Southern United
[Jan 6]
Juventud         1-1 Juventus

Round 17
Sagitun          2-1 Yabra
Juventus         0-2 Belmopan  
Jaguars          2-1 La Victoria
Juventud         1-1 Acros
Southern U.      w/o Real Verdes     [Verdes dns due to transport problems]

Round 18 [Jan 10]
Sagitun          2-2 Juventud
Juventus         w/o Southern United [Juventus won by default]  
Real Verdes      2-2 La Victoria
Jaguars          3-1 Yabra
Acros            0-1 Belmopan

[all awarded matches apparently had a 0-0 score for the goal difference]

Table Second Half (w/o goals rd 15):

 1.Sagitún (Independence)                       9  7  1  1 18- 8 22  [3]
 2.Juventus Pepsi (Orange Walk)                 9  5  3  1 17- 7 18  [1]
 3.Builders Bandits (Belmopán)                  9  5  1  3 15-14 16
-------------------------------------------------------------------
 4.La Victoria Dolphins (Corozál)               9  4  2  3 14-10 14  [2]
 5.Dangriga Jaguars                             9  4  2  3 10-20 14  [*12]
 6.Juventud Benqueña (Benque Viejo del Carmen)  9  3  4  2 15-13 13
 7.Southern United (Punta Gorda)                9  2  3  4  6-10  9  [*12]
 8.Yabra (Belize City)                          9  2  2  5 11-12  8
 9.Real Verdes (Benque Viejo del Carmen)        9  0  4  5 10-15  4 
10.Acros (Belize City)                          9  0  4  5  5-12  4

[*12] w/o goals in rd 12

Sagitún (Independence) and Builders Bandits (Belmopán) qualified
for playoffs.

Overall Table (w/o goals rd 15):

 1.Juventus Pepsi (Orange Walk)                18 11  6  1 39-17 39  [1]
 2.Sagitún (Independence)                      18 11  5  2 32-17 38  [3]
 3.La Victoria Dolphins (Corozál)              18 10  4  4 30-16 34  [2]
 4.Builders Bandits (Belmopán)                 18  7  5  6 25-27 26
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 5.Dangriga Jaguars                            18  7  2  9 21-39 23  [*12]
 6.Yabra (Belize City)                         18  5  6  7 29-24 21
 7.Juventud Benqueña (Benque Viejo del Carmen) 18  5  6  7 26-34 21
 8.Acros (Belize City)                         18  3  8  7 17-19 17
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 9.Southern United (Punta Gorda)               18  4  3 11 14-28 15  [*12]
10.Real Verdes (Benque Viejo del Carmen)       18  2  5 11 17-29 11 

[*12] w/o goals in rd 12

[1] Juventus Pepsi is the new name of Juventus Caribbean; there were rumours 
    that Juventus have withdrawn from the league and dissolved the team
    over a rules dispute with the league.  They eventually remained in the
    league but under new ownership and having lost their best players.
[2] San Pedro Dolphins had problems with their home field, so they have
    moved to Corozal and will be known as La Victoria Dolphins.
[3] Midsouth FC is former Corozal FC, loaned out for a year.  After one
    round they were renamed Sagitún.

Juventus Pepsi (Orange Walk), Sagitún (Mango Creek), La Victoria Dolphins (Corozál)
and Builders Bandits (Belmopán) qualified for championship playoff.

Southern United (Punta Gorda) and Real Verdes (Benque Viejo del Carmen) to
relegation playoff.

NB: published table:

 1.Juventus Pepsi (Orange Walk)                18 11  6  1 43-18 39  
 2.Sagitún (Independence)                      18 11  5  2 36-18 38  
 3.La Victoria Dolphins (Corozál)              18 10  4  4 33-15 34 
 4.Builders Bandits (Belmopán)                 18  7  5  6 27-31 26
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 5.Dangriga Jaguars                            18  7  2  9 27-29 23
 6.Yabra (Belize City)                         18  5  6  7 29-28 21
 7.Juventud Benqueña (Benque Viejo del Carmen) 18  5  6  7 25-34 21
 8.Acros (Belize City)                         18  3  8  7 19-23 17
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 9.Southern United (Punta Gorda)               18  4  3 11 14-31 15  
10.Real Verdes (Benque Viejo del Carmen)       18  2  5 11 17-32 11

total GD is +11; there is an obvious mistake in the goals against for Dangriga
but some others must remain as well.


Championship Playoff
====================

[played with extra time after draws; an extra time win yields 2, a
 penalty shoot-out win following an extra time draw 1 point]

Table:

                                                P  W X wDl L X  F  A Pts
 1.Juventus Pepsi (Orange Walk)                 6  4/0 0/1 0/1 16- 4 12
 2.La Victoria Dolphins (Corozál)               6  2/1 1/0 0/2 13- 9  9
 3.Sagitún (Independence)                       6  1/2 0/0 3/0  8-12  7
 4.Builders Bandits (Belmopán)                  6  1/0 0/0 5/0  6-18  3 

[P: played; W: regulation wins; X: extra time wins; wDl: draws won/lost on 
 penalties; L: regulation losses; X: extra time losses]

Round 1 [Jan 17]
Juventus         2-0 Belmopan
Sagitun          2-1 La Victoria         [asdet]

Round 2 [Jan 24]
La Victoria      1-1 Juventus            [asdet, 4-3 pen]
Belmopan         2-3 Sagitun

Round 3 [Jan 31]
Belmopan         1-3 La Victoria
Sagitun          0-1 Juventus

Round 4 [Feb 7]
La Victoria      1-2 Sagitun             [asdet]
Belmopan         0-5 Juventus    

Round 5 [Feb 14]
Juventus         1-2 La Victoria         [asdet]
Belmopan         1-0 Sagitun

Round 6
[Feb 21]
La Victoria      5-2 Belmopan
[Feb 28]
Juventus         6-1 Sagitun

Table:

                                                P  W X wDl L X  F  A Pts
 1.Juventus Pepsi (Orange Walk)                 6  4/0 0/1 0/1 16- 4 12
 2.La Victoria Dolphins (Corozál)               6  2/1 1/0 0/2 13- 9  9
 3.Sagitún (Independence)                       6  1/2 0/0 3/0  8-12  7
 4.Builders Bandits (Belmopán)                  6  1/0 0/0 5/0  6-18  3 

[P: played; W: regulation wins; X: extra time wins; wDl: draws won/lost on 
 penalties; L: regulation losses; X: extra time losses]


Championship Playoff

First Leg [Mar 28, Orange Walk]
Juventus         2-1 La Victoria    
  [Ian Henry, Dean Flowers; Clifford Usher]

Second Leg [Apr 4, Corozál]
La Victoria      1-1 Juventus     

Juventus win 3-2 on aggregate and are champions of Belize 1998/99.


Promotion/Relegation Tournament (for one place in BFL):

Schedule:

Saturday, July 3 CYO: Verdes - Louisiana
Sunday, July 11 SP : San Pedro - Verdes
Sunday, July 18 OW : Louisiana - San Pedro
Sunday, July 25 CYO: Verdes - San Pedro
Sunday, Aug 1 OW : Louisiana - Verdes
Sunday, Aug 8 SP : San Pedro - Louisiana

Southern United, the last place BFL team, reportedly pulled out of the
relegation tournament.

Tournament was cancelled, all three teams will play in the first division 
1999/2000, which will have 12 teams.

Relegated: Southern United.
Promoted: Louisiana Area FC and San Pedro Turquoise.
Move: La Victoria back to San Pedro; Sagitún reclaimed by Corozál.
New franchise: Sagitún.


NB: new season to start Sep 5; Louisiana withdrew due to financial problems;
    Juventus Pepsi changed name (sponsor) to Juventus Esso.




Authors: Hans Schöggl
(hans.schoeggl@sbg.ac.at)
and James Goloboy
(james.goloboy@yale.edu)

Last updated: 30 Sep 2002

(C) Copyright Hans Schöggl, James Goloboy and RSSSF 1999/2002


  USO DE MEMORIA  
4,273,400 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.5788
Total Execution Time  0.5806
  CADENA URL  
/clausura_belice1999
  GET DATOS  
$_GET['/clausura_belice1999']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0126  SELECT type FROM routes WHERE alias = 'clausura_belice1999'
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_belice' 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=321 AND type_rel = 3
0.0126  SELECT text_es as historical_text FROM leagues_text WHERE id=363
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 = 28676 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=219 ORDER BY l.group_code ASC
0.0127  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=219 GROUP BY c.id ORDER BY c.order_id ASC
0.0125  SELECT type,rule FROM rules WHERE categoryId = 321 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 23:22:04' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 23:22:04' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 23:22:04' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 23:22:04' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0134  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clausura_belice' 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.0130  SELECT e.action, count(e.action) as total, e.player_id FROM events1999 e WHERE e.league_id IN (28676) 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.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 (28676) 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 (28676) 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 (28676) 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 (28676) AND (e.action IN (3,4) ) 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 (28676) 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 (28676) AND (e.action IN (22) ) 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 (28676) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0125  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 = 28676 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 = 28676 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0129  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=28676 AND rel.round=9
0.0135  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 = 28676 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0135  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 = 28676 AND esl.points > 0
0.0136  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-29" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 28676 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-29" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 28676
0.0133  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` = 28676 AND c.`round` = 9 ORDER BY shedule ASC LIMIT 200
0.0126  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 = 9 AND e.real_date IS NOT NULL AND e.league_id = 28676 ORDER BY total DESC LIMIT 40
0.0145  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 = 28676 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0141  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 = 28676 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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 = 28676 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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-28 00:00:00' AND c.`shedule` < '2024-05-02 23:59:59' AND l.id = 28676 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0141  SELECT data1, data2 FROM services_tags WHERE categoryId=321
0.0141  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 321 AND l.year = 1999 ORDER BY l.group_code ASC
0.0141  SELECT group_code, extraName from `leagues` WHERE categoryId=321 AND year=1999