4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2006
Temporada Siguiente »
Publicidad 600x120.gif
Liga Aruba 2006
2005/2006

Liga Aruba 2006

Información Histórica 
						

Division di Honor 

Table:

 1.SV Dakota                   18  11  4  3  30-18  37  [31-18?]  [Dakota, Oranjestad] 
 2.SV Estrella                 18  11  3  4  34-19  36  [Papilon, Santa Cruz]
 3.SV Britannia                18   9  5  4  41-21  32  [Piedra Plat, Paradera]
 4.SV La Fama                  18   9  5  4  20-10  32  [Savaneta, Savaneta]
 - - - - - - - - - - - - - - - - - - - - - - - - - - -
 5.SV Racing Club Aruba        18   8  6  4  39-19  30  [Solito, Oranjestad]
 6.SV Deportivo Nacional       18   8  6  4  25-11  30  [Palm Beach, Noord]
 7.SV Independiente Caravel    18   5  8  5  21-20  23  [Angochi, Santa Cruz]
 8.SV Caiquetio                18   3  5 10  14-25  14  [Paradera, Paradera]
 9.SV Sportboys                18   2  2 14  12-60   8  [12-61?]  [Angochi, Santa Cruz]
10.SV Estudiantes              18   1  2 15  11-44   5  [Solito, Oranjestad]

Round 1
Britannia    3-0 RCA
Caiquetio    3-0 Estudiantes
Estrella     2-2 Caravel
Dakota       0-0 Nacional
Sportboys    0-1 La Fama

Round 2
Britannia    2-1 Caiquetio
Caravel      3-0 Sportboys
Estudiantes  2-0 Dakota
La Fama      2-3 Estrella
Nacional     1-1 RCA

Round 3
La Fama      2-0 Britannia
Caiquetio    0-0 Caravel
Sportboys    1-2 Dakota
Estrella     2-1 Nacional
RCA          1-1 Estudiantes

Round 4
Caravel      1-1 Britannia
Caiquetio    0-1 RCA
Dakota       1-1 Estrella
Estudiantes  awd Sportboys        [awarded 0-2]
Nacional     0-0 La Fama

Round 5
Sportboys    1-4 Britannia
Caiquetio    2-3 Dakota 
Estrella     2-1 RCA
Nacional     1-1 Caravel   
Estudiantes  1-4 La Fama 

Round 6
Nacional     0-1 Caiquetio 
La Fama      0-0 RCA
Estudiantes  0-1 Caravel
Estrella     3-0 Sportboys
[Jan 13]
Dakota       3-1 Britannia 

Round 7
RCA          7-0 Sportboys
Estrella     1-2 Britannia
Caiquetio    0-0 La Fama
Dakota       1-1 Caravel  
Estudiantes  1-2 Nacional    

Round 8
[Dec 3]
RCA          2-0 Caravel     
Britannia    5-1 Estudiantes
[Dec 4]
La Fama      2-1 Dakota
Sportboys    0-5 Nacional     
[Dec ?]
Caiquetio    0-2 Estrella

Round 9
[Dec 9]
Sportboys    1-1 Caiquetio 
[Dec 10]
Caravel      0-0 La Fama 
Britannia    0-0 Nacional 
[Dec 12]
RCA          3-1 Dakota      
[Dec 14]
Estudiantes  0-5 Estrella     

Round 10 
[Jan 20]
RCA          1-1 Britannia
[Jan 21]
Nacional     0-2 Dakota     
Estrella     1-0 Caravel
[Jan 22]
Caiquetio    1-0 Estudiantes
Sportboys    0-3 La Fama

Round 11
[Jan 27]
Estrella     1-0 La Fama
[Jan 28]
Estudiantes  1-2 Dakota      
[Jan 29]
Caiquetio    0-4 Britannia
Sportboys    0-1 Caravel
[Feb 3]
RCA          0-2 Nacional    

Round 12
[Feb 6]
Nacional     1-0 Estrella
[Feb 7]
Dakota       2-0 Sportboys        [3-0?]
[Feb 8]
Estudiantes  2-6 RCA          
[Feb 9]
Britannia    0-0 La Fama
[Feb 13]
Caiquetio    1-3 Caravel

Round 13
[Feb 14]
Estrella     1-3 Dakota
[Feb 15]
Nacional     0-1 La Fama
[Feb 16]
Sportboys    3-1 Estudiantes
[Feb 20]
RCA          2-0 Caiquetio
[Feb 21]
Britannia    3-0 Caravel

Round 14
[Mar 4]
RCA          1-1 Estrella 
Caravel      1-3 Nacional    
[Mar 5]
Dakota       3-2 Caiquetio
La Fama      1-0 Estudiantes
[Mar 6]
Britannia   12-2 Sportboys   

Round 15
[Mar 10]
Sportboys    1-4 Estrella
[Mar 11]
Caiquetio    0-0 Nacional  
[Mar 12]
RCA          2-1 La Fama 
Britannia    0-2 Dakota
[Mar 29]
Caravel      3-0 Estudiantes

Round 16
[Mar 24]
Britannia    2-1 Estrella
[Mar 25]
Sportboys    0-9 RCA
Caravel      1-1 Dakota
[Mar 26]
Nacional     3-0 Estudiantes
La Fama      1-0 Caiquetio 

Round 17
[Mar 31]
Dakota       1-0 La Fama 
[Apr 1]
Nacional     1-0 Sportboys
Estrella     2-1 Caiquetio
[Apr 2]
Caravel      2-2 RCA
Estudiantes  0-0 Britannia

Round 18
[Apr 4]
Caiquetio    1-1 Sportboys
[Apr 5]
La Fama      2-1 Caravel
[Apr 6]
Nacional     5-1 Britannia
[Apr 9]
Dakota       2-0 RCA
Estrella     2-1 Estudiantes
 
Table:

 1.SV Dakota                   18  11  4  3  30-18  37  [31-18?]  [Dakota, Oranjestad] 
 2.SV Estrella                 18  11  3  4  34-19  36  [Papilon, Santa Cruz]
 3.SV Britannia                18   9  5  4  41-21  32  [Piedra Plat, Paradera]
 4.SV La Fama                  18   9  5  4  20-10  32  [Savaneta, Savaneta]
 - - - - - - - - - - - - - - - - - - - - - - - - - - -
 5.SV Racing Club Aruba        18   8  6  4  39-19  30  [Solito, Oranjestad]
 6.SV Deportivo Nacional       18   8  6  4  25-11  30  [Palm Beach, Noord]
 7.SV Independiente Caravel    18   5  8  5  21-20  23  [Angochi, Santa Cruz]
 8.SV Caiquetio                18   3  5 10  14-25  14  [Paradera, Paradera]
 9.SV Sportboys                18   2  2 14  12-60   8  [12-61?]  [Angochi, Santa Cruz]
10.SV Estudiantes              18   1  2 15  11-44   5  [Solito, Oranjestad]

Top Scorers:
9 Frederick Gomez (RCA)
8 Glenroy L. Lake (Britannia)
7 Rodney G. Lake (Britannia)
  Leslie T. Felomina (La Fama)
5 Howart Hart (Caiquetio)
  Gleison DS Barros (Estrella)
  A. J. G. Felipa (La Fama)

Championship Playoff

Table:

 1.SV Britannia                 6   4  0  2  18-13  12  [Piedra Plat, Paradera]
 2.SV Estrella                  6   3  2  1  14-11  11  [Papilon, Santa Cruz]
 - - - - - - - - - - - - - - - - - - - - - - - - - - -
 3.SV Dakota                    6   1  2  3  11-12   5  [Dakota, Oranjestad] 
 4.SV La Fama                   6   1  2  3   6-13   5  [Savaneta, Savaneta]
 
Round 1
[May 9]
Estrella     1-1 Dakota
[May 10]
Britannia    2-1 La Fama

Round 2
[May 12]
Estrella     3-2 Britannia
[May 13]
La Fama      1-0 Dakota
 
Round 3
[May 16]
Estrella     4-1 La Fama
[May 17]
Dakota       1-3 Britannia
 
Round 4 [May 21]
Dakota       1-3 Estrella
La Fama      0-4 Britannia  
 
Round 5 
[May 23]
Britannia    5-2 Estrella
[May 24]
Dakota       2-2 La Fama
 
Round 6 
[May 27]
La Fama      1-1 Estrella
[May 28]
Britannia    2-6 Dakota 

Table:

 1.SV Britannia                 6   4  0  2  18-13  12  [Piedra Plat, Paradera]
 2.SV Estrella                  6   3  2  1  14-11  11  [Papilon, Santa Cruz]
 - - - - - - - - - - - - - - - - - - - - - - - - - - -
 3.SV Dakota                    6   1  2  3  11-12   5  [Dakota, Oranjestad] 
 4.SV La Fama                   6   1  2  3   6-13   5  [Savaneta, Savaneta]
 

First Final [May 31]
Estrella     1-0 Britannia
 
Second Final [Jun 3]
Britannia    4-1 Estrella
 
Third Final [Jun 6]
Britannia    1-2 Estrella

Champions: Estrella



Torneo Copa „Betico Croes“ 2006

Quarterfinals
Sportboys    1-2 Nacional
La Fama      2-3 RCA
Britannia    3-2 Estrella
Caiquetio    0-1 Estudiantes
 
Semifinals
Nacional     1-0 RCA
Britannia    0-0 Estudiantes      [2-3 pen]
 
Final
Nacional     0-1 Estudiantes


Second Level 2005/06


Division Uno

[Dec 8]
JTL          3-0 Brazil Jrs
[Jan 24]
Jong Aruba   2-2 Sporting 
[Jan 26]
Undesa       1-4 JTL
[Jan 28]
Unistars     0-7 Riverplate
SLD          2-0 Trupial 
[Jan 29]
Brazil Jrs   1-3 Atlantico
[Feb 5]
JTL          0-1 Jong Aruba 
[Feb 6]
Brazil Jrs   0-0 Unistars
[Feb 9]
Undesa       3-3 Sporting 
[Feb 22]
Unistars     1-4 Trupial
[Feb 23]
SLD          1-2 Brazil Jrs 
[Mar 4]
Jong Aruba   4-0 Undesa Estrella
[Mar 5]
SLD          0-1 JTL
[Mar 7]
Atlantico    4-1 Unistars 
[Mar 9]
Trupial      1-1 Riverplate 
[Mar 11]
JTL          4-0 Unistars
Undesa       2-2 Atlantico 
[Mar 13]
Sporting     3-1 Trupial 
[Mar 14]
SLD          0-0 Riverplate
[Mar 16]
Atlantico    1-2 Sporting
[Mar 17]
Unistars     0-1 Undesa 
[Mar 19]
Trupial      3-1 Brazil Jrs 
Jong Aruba   4-3 SLD
[Mar 21]
JTL          1-2 Riverplate 
[Mar 22]
Jong Aruba   3-1 Atlantico 
[Mar 23]
Unistars     1-5 Brazil Jrs
[Mar 25]
Undesa       0-2 Riverplate 
SLD          0-1 Sporting
[Mar 26]
Unistars     2-6 Jong Aruba
[Mar 28]
Brazil Jrs   1-5 Riverplate 
[Mar 30]
Trupial      3-2 Atlantico
[Apr 1]
JTL          1-1 Sporting
SLD          1-0 Unistars
[Apr 2]
Trupial      1-1 Jong Aruba
Brazil Jrs.  0-0 Undesa
[Apr 8]
Riverplate   1-2 Sporting
JTL          0-1 Atlantico
[Apr 9]
Undesa       1-2 Trupial
[Apr 11]
Unistars     0-4 Sporting 
[Apr 12]
Riverplate   1-2 Jong Aruba 
[Apr 19]
Brazil Jrs   3-1 JTL               [inferred; reported 1-3]
[Apr 20]
Sporting     0-2 Jong Aruba 
[Apr 22]
Brazil Jrs.  0-1 Jong Aruba
Riverplate   5-2 Atlantico
[Apr 24]
Riverplate   7-0 Unistars
[Apr 25]
Atlantico    0-2 Brazil Jrs.      
[Apr 26]
Undesa       1-2 SLD               [awarded 2-0?]
[Apr 27]
JTL          4-0 Trupial 
[Apr 28]
Brazil Jrs.  3-5 Sporting
[May 2]
Trupial      4-1 SLD               [inferred]
[May 5]
JTL          0-3 Undesa            [inferred]
[date?]
SLD          2-0 Atlantico         [possibly awarded]

Table:

 1.SV Juventud Tanki Leendert  18  12  1  5  37-18  37  Champions  [Tanki Leendert, Noord]
 2.SV Riverplate               18  10  4  4  46-17  34  [Madiki, Oranjestad]
 3.SV Jong Aruba               18  10  4  4  36-25  34  [Seroe Jangi, Noord]
 4.SV Sporting                 18   7  6  5  31-31  27  [Ayo, Paradera]
 5.Trupial                     18   6  7  5  37-31  25  [5 7 5 35-32?]
 6.SV San Luis Deportivo       18   7  4  7  24-22  25  [Savaneta, Savaneta]
 7.SV Brazil Juniors           18   6  5  7  31-33  23  [Brazil, San Nicolas]
 8.SV Undesa                   18   6  5  7  24-26  23  [7 5 7 25-25?] [Savaneta, Savaneta]
 9.SV Atlantico                18   4  4 10  24-35  16  [Rooi Bosal, Santa Cruz]
10.SV Unistars                 18   1  2 15  11-63   5  [Pos Chiquito, Savaneta]


 

Third Level 2005/06

Division Dos

[Jan 27?]
SV Arsenal   5-1 CDRA
[Feb 3]
Universal   1-11 CDRA 
Real Koyari  1-4 Indep.Hooib.

[Feb 6]
Universal    0-6 Indep.Hooib.

Round 12 [Feb 10]
Arikok       4-2 Indep.Hooib.
Dos Caminos  2-0 Ayo 
Bubali       0-1 Real Koyari
CDRA         awd Jong San Nicolas [awarded 2-0]
Arsenal      5-1 Universal 

Round 13 [Mar 3]
Dos Caminos  1-0 Arikok Estrella 
Indep.Hooib. 0-3 Jong San Nicolas
Universal    2-8 Bubali
CDRA         2-2 Real Koyari
Ayo          0-5 Arsenal

Round 14 [Mar 10]
Arsenal      1-0 Arikok 
Real Koyari  0-2 Dos Caminos 
Universal    0-2 Jong San Nicolas
CDRA         4-2 Indep. Hooiberg 
Bubali       1-1 Ayo 

[Mar 13]
Arsenal      5-0 Ayo

Round  15 [Mar 20]
Real Koyari  1-1 Arikok
Bubali       0-0 Dos Caminos 
CDRA         5-4 Ayo 
Indep.Hooib. 3-0 Universal 
Arsenal      3-0 Jong San Nicolas

Round 16 [Mar 24]
Universal    2-3 Arikok
Dos Caminos  2-1 CDRA
Indep.Hooib. 1-2 Arsenal 
Ayo          n/p Real Koyari
Jong San N.  n/p Bubali

Round 17 [Mar 31]
Universal    5-1 Dos Caminos 
CDRA         2-1 Arikok 
Indep.Hooib. n/p Real Koyari 
Jong San N.  n/p CD Ayo
Arsenal      1-2 Bubali 

Round 18 [Apr 7]
Arikok       1-1 Bubali 
Arsenal      5-0 Dos Caminos
CDRA         7-2 Universal 
Indep.Hooib. 2-2 Ayo 
Real Koyari  n/p Jong San Nicolas

Round 19 [Apr 10]
Jong San N.  n/p Arikok 
Dos Caminos  6-0 Indep. Hooiberg
CDRA         1-2 Bubali
Real Koyari  n/p Arsenal
Ayo          3-2 Universal 

Round 20 
[Apr 21]
Ayo          3-0 Arikok
Dos Caminos  n/p Jong San Nicolas 
Indep.Hooib. 2-0 Bubali 
Universal    n/p Real Koyari 
[tba]
CDRA          -  Arsenal 

Table:

 1.SV Arsenal                  13  12  0  1  54-11  36  [Coba Lodo, Santa Cruz]
 2.SV CDRA                     13  10  0  3  53-26  30  [Rooi Afo, Paradera]
 3.Dos Caminos                 14   9  2  3  33-28  29
 4.SV Bubali                   14   5  5  4  25-22  20  [Bubali, Noord]
 5.SV Independiente Hooiberg   14   4  3  7  23-30  15  (14?)  [Hooiberg, Santa Cruz]
 6.SV Arikok                   14   3  5  6  23-28  14  [Arikok, Santa Cruz]
 7.SV Centro Deportivo Ayo     14   3  3  8  27-40  12  [Ayo, Paradera]
 8.SV Universal                14   0  0 14  23-76   0  [Pos Chiquito, Savaneta]

 -.SV Real Koyari              13   6  4  3  22-21  22  [Koyari, Noord]
 -.SV Jong San Nicolas         14   5  1  8  31-38  16  [Weg Fontein, San Nicolas]
 -.SV Aparicio Stars            7   1  0  6   7-26   3  [Dakota, Oranjestad]

NB: Aparicio Stars excluded, matches annulled (last known record given);
    between Mar 28 and Apr 7 also Real Koyari and Jong San Nicolas
    were apparently excluded due to no-shows on Mar 24 and 31

NB: CDRA = Centro Deportivo Rooi Afo




Author:
 Randolf Laclé
(randolac@hotmail.com)

Last updated: 26 Sep 2006

(C) Copyright Randolf Laclé and RSSSF 2005/06


  USO DE MEMORIA  
4,286,904 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.4658
Total Execution Time  0.4678
  CADENA URL  
/liga_aruba2006
  GET DATOS  
$_GET['/liga_aruba2006']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0105  SELECT type FROM routes WHERE alias = 'liga_aruba2006'
0.0217  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_aruba' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2006 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1546 AND type_rel = 3
0.0107  SELECT text_es as historical_text FROM leagues_text WHERE id=38
0.0106  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 = 27750 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0106  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='2006' WHERE c.parentId=1546 GROUP BY c.id ORDER BY c.order_id ASC
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-25 10:09:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-25 10:09:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-25 10:09:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0107  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-25 10:09:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_aruba' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2006 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0109  SELECT e.action, count(e.action) as total, e.player_id FROM events2006 e WHERE e.league_id IN (27750) 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.0112  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 (27750) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0106  SELECT e.action, count(e.action) as total, e.player_id FROM events2006 e WHERE e.league_id IN (27750) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0105  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 (27750) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0110  SELECT e.action, count(e.action) as total, e.player_id FROM events2006 e WHERE e.league_id IN (27750) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0108  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 (27750) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0112  SELECT e.action, count(e.action) as total, e.player_id FROM events2006 e WHERE e.league_id IN (27750) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0107  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 (27750) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0107  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 = 27750 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0106  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 = 27750 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0110  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=27750 AND rel.round=18
0.0109  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 = 27750 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0108  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 = 27750 AND esl.points > 0
0.0111  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-26" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 27750 ORDER BY creation_date DESC LIMIT 0, 10
0.0115  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-26" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 27750
0.0109  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 `calendars2006` 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` = 27750 AND c.`round` = 18 ORDER BY shedule ASC LIMIT 200
0.0106  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 `events2006` e INNER JOIN calendars2006 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 = 27750 ORDER BY total DESC LIMIT 40
0.0112  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 `events2006` e INNER JOIN calendars2006 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 = 27750 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0117  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 `tables2006` 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 = 27750 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0117  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2006` 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 = 27750 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0117  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-25 00:00:00' AND c.`shedule` < '2024-04-29 23:59:59' AND l.id = 27750 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0117  SELECT data1, data2 FROM services_tags WHERE categoryId=1546
0.0117  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 1546 AND l.year = 2006 ORDER BY l.group_code ASC
0.0117  SELECT group_code, extraName from `leagues` WHERE categoryId=1546 AND year=2006