Publicidad 600x120.gif
Liga Aruba 2007
2006/2007

Liga Aruba 2007

Información Histórica
						
Division di Honor

First Stage

Final Table:

 1.SV Britannia                18  15  2  1  65-20  47  [Piedra Plat, Paradera]
 2.SV Racing Club Aruba        18  13  3  2  41- 5  42  [Solito, Oranjestad]
 3.SV Deportivo Nacional       18   9  5  4  53-17  32  [Palm Beach, Noord]
 4.SV La Fama                  18   8  7  3  49-18  31  [Savaneta, Savaneta]
 - - - - - - - - - - - - - - - - - - - - - - - - - - -
 5.SV Dakota                   18   7  4  7  44-29  25  [Dakota, Oranjestad] 
 6.SV Estrella                 18   7  4  7  39-38  25  [Papilon, Santa Cruz]
 7.SV Independiente Caravel    18   4  4 10  31-40  16  [Angochi, Santa Cruz]
 - - - - - - - - - - - - - - - - - - - - - - - - - - -
 8.SV Jong Aruba               18   5  1 12  20-70  16  [Seroe Jangi, Noord]
 9.SV Caiquetio                18   3  3 12  27-63  12  [Paradera, Paradera]
------------------------------------------------------
10.SV Juventud Tanki Leendert  18   2  1 15  16-85   7  [Tanki Leendert, Noord]

Round 1
[Sep 15]
Estrella       0-2 Britannia
[Sep 16]
Dakota         1-2 La Fama        
RCA            3-1 Nacional
[Sep 17]
Caravel        4-2 Caiquetio
Juventud TL    1-1 Jong Aruba     

Round 2 
[Sep 22]
Caravel        0-0 Dakota
[Sep 23]
RCA            3-0 Juventud TL
Britannia      2-1 La Fama
[Sep 24]
Caiquetio      2-4 Estrella
Jong Aruba     0-5 Nacional
 
Round 3
[Sep 29]
Juventud TL    1-5 Estrella
[Sep 30]
Dakota         2-3 Jong Aruba
Caravel        1-6 Britannia
[Oct 1]
Caiquetio      0-6 Nacional
La Fama        0-4 RCA

Round 4
[Oct 20]
La Fama        2-0 Juventud TL
[Oct 21]
Jong Aruba     1-0 Caravel
Estrella       1-1 Nacional
[Oct 22]
Britannia      1-1 Caiquetio
RCA            1-0 Dakota

Round 5
[Oct 27]
Nacional       2-2 La Fama
[Oct 28]
Juventud TL    1-6 Caravel
Dakota         6-0 Caiquetio
[Oct 29]
Estrella       3-1 Jong Aruba
Britannia      0-1 RCA

Round 6
[Nov 10]
Nacional       1-0 Caravel  
[Nov 11]
Jong Aruba     0-3 RCA 
Caiquetio      0-6 La Fama 
[Nov 12]
Britannia      3-1 Juventud TL 
Estrella       1-3 Dakota

Round 7
[Nov 17]
Jong Aruba     1-8 Britannia
[Nov 18]
Juventud TL    3-1 Caiquetio
RCA            4-1 Estrella
[Nov 19]
Nacional       3-2 Dakota
La Fama        2-2 Caravel

Round 8
[Dec 1]
RCA            8-0 Caiquetio 
[Dec 2]
Caravel        2-3 Estrella 
Nacional       0-0 Britannia 
[Dec 3]
Dakota         5-1 Juventud TL 
La Fama        6-0 Jong Aruba

Round 9
[Dec 8]
Caiquetio      2-3 Jong Aruba
[Dec 9]
La Fama        1-1 Estrella 
[Dec 10]
RCA            3-0 Caravel 
Juventud TL    0-2 Nacional
[Jan 22]
Dakota         1-2 Britannia

Round 10
[Jan 30]
Nacional       0-1 RCA
[Jan 31]
Britannia      3-1 Estrella        [inferred, reported 3-2]
[Feb 1]
La Fama        3-0 Dakota
[Feb 5]
Caiquetio      3-2 Caravel
[Feb 6]
Jong Aruba     1-3 Juventud TL

Round 11
[Feb 12]
La Fama        0-1 Britannia
[Feb 13]
Juventud TL    0-5 RCA
[Feb 14]
Nacional       8-0 Jong Aruba
[Feb 15]
Dakota         3-0 Caravel
[Feb 20]
Caiquetio      2-1 Estrella

Round 12
[Feb 23]
Jong Aruba     0-6 Dakota
Nacional       2-1 Caiquetio
RCA            0-0 La Fama
[Feb 25, inferred]
Estrella       3-2 Juventud TL
Britannia      4-2 Caravel

Round 13
[Mar 2]
Dakota         0-0 RCA
Caiquetio      3-5 Britannia   
Nacional       5-1 Estrella 
[Mar 3]
Caravel        1-2 Jong Aruba 
Juventud TL    0-8 La Fama

Round 14
[Mar 9]
La Fama        2-0 Nacional
[Mar 10]
Caravel        5-1 Juventud TL
Caiquetio      1-5 Dakota
[Mar 11]
Jong Aruba     1-5 Estrella
RCA            0-1 Britannia

Round 15
[Mar 23]
Juventud TL   0-13 Britannia
[Mar 24]
Caravel        1-1 Nacional
RCA            2-0 Jong Aruba
[Mar 25]
La Fama        2-2 Caiquetio
Dakota         2-2 Estrella

Round 16
[Mar 30]
Caiquetio      4-0 Juventud TL
[Mar 31]
Britannia      3-1 Jong Aruba
Caraval        1-1 La Fama
[Apr 1]
Dakota         0-0 Nacional
Estrella       0-2 RCA

Round 17
[Apr 14]
Juventud TL    1-3 Dakota
Jong Aruba    1-10 La Fama
[Apr 15]
Britannia      2-1 Nacional
Caiquetio      1-1 RCA
[Apr 27?]
Estrella       6-3 Caravel

Round 18
[Apr 20]
Caravel        1-0 RCA
[Apr 21]
Britannia      9-5 Dakota
Estrella       1-1 La Fama
[Apr 22]
Jong Aruba     4-2 Caiquetio
Nacional      15-1 Juventud TL

Final Table:

 1.SV Britannia                18  15  2  1  65-20  47  [Piedra Plat, Paradera]
 2.SV Racing Club Aruba        18  13  3  2  41- 5  42  [Solito, Oranjestad]
 3.SV Deportivo Nacional       18   9  5  4  53-17  32  [Palm Beach, Noord]
 4.SV La Fama                  18   8  7  3  49-18  31  [Savaneta, Savaneta]
 - - - - - - - - - - - - - - - - - - - - - - - - - - -
 5.SV Dakota                   18   7  4  7  44-29  25  [Dakota, Oranjestad] 
 6.SV Estrella                 18   7  4  7  39-38  25  [Papilon, Santa Cruz]
 7.SV Independiente Caravel    18   4  4 10  31-40  16  [Angochi, Santa Cruz]
 - - - - - - - - - - - - - - - - - - - - - - - - - - -
 8.SV Jong Aruba               18   5  1 12  20-70  16  [Seroe Jangi, Noord]
 9.SV Caiquetio                18   3  3 12  27-63  12  [Paradera, Paradera]
------------------------------------------------------
10.SV Juventud Tanki Leendert  18   2  1 15  16-85   7  [Tanki Leendert, Noord]


Championship Playoff

Final Table:

 1.SV Racing Club Aruba         6   3  2  1   8- 3  11  [Solito, Oranjestad]
 2.SV Deportivo Nacional        6   3  2  1   6- 4  11  [Palm Beach, Noord]
 - - - - - - - - - - - - - - - - - - - - - - - - - - -
 3.SV Britannia                 6   2  3  1  12- 7   9  [Piedra Plat, Paradera]
 4.SV La Fama                   6   0  1  5   2-14   1  [Savaneta, Savaneta]
 
Round 1
[May 9]
Britannia      4-2 La Fama
[May 10]
Nacional       1-0 RCA         

Round 2 [May 12]
RCA            3-0 La Fama
Britannia      2-2 Nacional
 
Round 3 [May 15]
RCA            1-1 Britannia
La Fama        0-0 Nacional
 
Round 4 [May 19]
La Fama        0-4 Britannia
RCA            2-0 Nacional

Round 5 
[May 22]
La Fama        0-1 RCA
[May 23]
Nacional       1-0 Britannia
 
Round 6 [May 26]
Nacional       2-0 La Fama
Britannia      1-1 RCA

Final Table:

 1.SV Racing Club Aruba         6   3  2  1   8- 3  11  [Solito, Oranjestad]
 2.SV Deportivo Nacional        6   3  2  1   6- 4  11  [Palm Beach, Noord]
 - - - - - - - - - - - - - - - - - - - - - - - - - - -
 3.SV Britannia                 6   2  3  1  12- 7   9  [Piedra Plat, Paradera]
 4.SV La Fama                   6   0  1  5   2-14   1  [Savaneta, Savaneta]
 

Finals

First Leg [Jun 2]
Nacional       1-0 RCA
  [Valdo Leocadio 51pen]

Second Leg [Jun 6]
RCA            4-0 Nacional
  [Jean Luc Bergen 5, Alberto Roldan Soto 14, Maurice Escalona 29, 41]

Third Leg [Jun 9, stadion Guillermo Trinidad]
RCA            0-1 Nacional
  [Valdo Leocadio 4]


Promotion/Relegation

[May 7]
Caiquetio      0-1 Arsenal
[May 8]
Jong Aruba     1-4 Estudiantes
[May 11]
Estudiantes    3-1 Caiquetio
[May 12]
Arsenal        1-3 Jong Aruba
[May 20]
Estudiantes    1-0 Arsenal
Caiquetio      1-2 Jong Aruba       
[May 24]
Arsenal        1-1 Caiquetio
[May 25]
Estudiantes    0-1 Jong Aruba
[May 27]
Caiquetio      awd Estudiantes       [awarded 0-0 win to Estudiantes]
Jong Aruba     1-3 Arsenal
[May 30]
Arsenal        1-0 Estudiantes
[May 31]
Jong Aruba     awd Caiquetio         [awarded 0-0 win to Jong Aruba]

Final Table:

 1.SV Estudiantes               6   4  0  2   8- 4  12  Promoted  [Solito, Oranjestad]
 2.SV Jong Aruba                6   4  0  2   8- 9  12  [Seroe Jangi, Noord]
------------------------------------------------------
 3.SV Arsenal                   6   3  1  2   7- 6  10  [Coba Lodo, Santa Cruz]
 4.SV Caiquetio                 6   0  1  5   3- 7   1  Relegated  [Paradera, Paradera]



Author:
Hans Schöggl
(hans.schoeggl@sbg.ac.at)

Last updated: 9 Oct 2007

(C) Copyright Hans Schöggl and RSSSF 2006/07
						

Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
4,292,024 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0028
Controller Execution Time ( Home / Category )  0.4789
Total Execution Time  0.4817
  CADENA URL  
/liga_aruba2007
  GET DATOS  
$_GET['/liga_aruba2007']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0111  SELECT type FROM routes WHERE alias = 'liga_aruba2007'
0.0226  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 = 2007 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0109  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1546 AND type_rel = 3
0.0110  SELECT text_es as historical_text FROM leagues_text WHERE id=2474
0.0111  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 = 30729 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0115  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='2007' WHERE c.parentId=1546 GROUP BY c.id ORDER BY c.order_id ASC
0.0110  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-29 11:11:07' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-29 11:11:07' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-29 11:11:07' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-29 11:11:07' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0121  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 = 2007 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0110  SELECT e.action, count(e.action) as total, e.player_id FROM events2007 e WHERE e.league_id IN (30729) 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.0111  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 (30729) 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 events2007 e WHERE e.league_id IN (30729) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0110  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 (30729) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0113  SELECT e.action, count(e.action) as total, e.player_id FROM events2007 e WHERE e.league_id IN (30729) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0113  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 (30729) 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 events2007 e WHERE e.league_id IN (30729) AND (e.action IN (22) ) 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 (30729) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0105  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 = 30729 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0105  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 = 30729 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0108  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=30729 AND rel.round=18
0.0116  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 = 30729 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0117  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 = 30729 AND esl.points > 0
0.0116  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-02-28" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 30729 ORDER BY creation_date DESC LIMIT 0, 10
0.0134  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-02-28" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 30729
0.0116  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 `calendars2007` 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` = 30729 AND c.`round` = 18 ORDER BY shedule ASC LIMIT 200
0.0107  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 `events2007` e INNER JOIN calendars2007 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 = 30729 ORDER BY total DESC LIMIT 40
0.0116  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 `events2007` e INNER JOIN calendars2007 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 = 30729 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0109  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 `tables2007` 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 = 30729 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2007` 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 = 30729 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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-03-29 00:00:00' AND c.`shedule` < '2024-04-02 23:59:59' AND l.id = 30729 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0109  SELECT data1, data2 FROM services_tags WHERE categoryId=1546
0.0109  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 1546 AND l.year = 2007 ORDER BY l.group_code ASC
0.0109  SELECT group_code, extraName from `leagues` WHERE categoryId=1546 AND year=2007