4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Información Histórica 
						Second Level 2000/01

Ehrenpromotion

Final Table:

 1. Swift Hesperange      26 21  2  3  74-21  65  Champions, promoted
 2. Progres Niedercorn    26 16  3  7  42-31  51  Promoted
------------------------------------------------
 3. Spora Luxembourg      26 15  2  9  54-33  47
 4. Victoria Rosport      26 12  6  8  37-28  42
 5. FC Hamm               26 13  3 10  37-32  42
 6. CS Petange            26 10  5 11  38-43  35
 7. CS Hollerich          26  9  5 12  32-44  32
 8. UN Kaerjheng          26  7 10  9  44-42  31
 9. Young Boys Diekirch   26  8  6 12  41-41  30
10. Jeunesse Schieren     26  8  6 12  22-35  30
11. Aris Bonnevoie        26  9  3 14  33-52  30
------------------------------------------------
12. Koeppchen Wormeldange 26  7  6 13  30-36  27  Relegated
13. FC Schifflange '95    26  5  9 12  28-49  24  Relegated
14. FC Mamer '32          26  5  8 13  32-57  23  Relegated

Round 1
[Aug 20]
Diekirch       1-2 Mamer
Hamm           0-4 Kaerjheng
Niedercorn     1-3 Hesperange
Petange        1-5 Spora
Rosport        2-0 Hollerich
Schifflange    0-5 Wormeldange
Schieren       0-4 Aris

Round 2
[Aug 23]
Aris           1-2 Rosport
Hesperange     8-0 Hollerich
Mamer          2-0 Petange
Kaerjheng      2-2 Schieren
Schifflange    0-0 Diekirch
Spora          1-0 Hamm
Wormeldange    1-2 Niedercorn

Round 3
[Sep 10]
Diekirch       1-2 Wormeldange
Hamm           1-0 Mamer
Hollerich      2-0 Aris
Niedercorn     2-0 Kaerjheng
Petange        4-2 Schifflange
Rosport        3-1 Hesperange
Schieren       1-3 Spora

Round 4
[Sep 13]
Aris           0-6 Hesperange
Diekirch       1-2 Petange
Mamer          1-2 Schieren
Kaerjheng      2-2 Hollerich
Schifflange    2-1 Rosport
Spora          1-0 Niedercorn
Wormeldange    2-0 Hamm

Round 5
[Sep 17]
Hamm           3-4 Schifflange
Hesperange     4-1 Kaerjheng
Hollerich      2-1 Spora
Niedercorn     2-0 Aris
Petange        1-1 Wormeldange
Rosport        1-0 Mamer
Schieren       0-2 Diekirch

Round 6
[Sep 24]
Diekirch       2-5 Hamm
Kaerjheng      2-2 Aris
Mamer          1-1 Hollerich
Petange        1-1 Niedercorn
Schifflange    0-1 Schieren
Spora          0-2 Hesperange
Wormeldange    2-0 Rosport

Round 7
[Oct 22]
Diekirch       3-0 Hollerich
Mamer          1-0 Aris
Petange        3-0 Schieren
Schifflange    1-3 Niederkorn
Spora          4-2 Kaerjheng
Wormeldange    1-3 Hesperange
Hamm           0-3 Rosport

Round 8
[Oct 29]
Kaerjheng      2-2 Mamer
Hesperange     3-1 Petange
Hollerich      1-0 Wormeldange
Niedercorn     3-1 Diekirch
Aris           0-2 Schifflanmge
Rosport        1-2 Spora
Schieren       0-2 Hamm

Round 9
[Nov 5]
Diekirch       0-1 Aris
Mamer          2-4 Spora
Petange        2-0 Hollerich
Schifflange    1-1 Hesperabge
Schieren       1-1 Rosport
Wormeldange    0-4 Kaerjheng
Hamm           1-0 Niedercorn

Round 10
[Nov 12]
Kaerjheng      0-0 Schifflange
Hesperange     2-1 Mamer
Hollerich      0-2 Hamm        [Mar 28]
Niedercorn     1-0 Schieren
Aris           3-5 Wormeldange
Rosport        3-0 Petange
Spora          1-3 Diekirch

Round 11
[Nov 26]
Hamm           3-1 Petange     [Febr 18]
Hesperange     1-0 Diekirch
Hollerich      2-2 Schifflange [Febr 18]
Niedercorn     3-4 Mamer       [Febr 18]
Aris           0-0 Spora       [Febr 18]
Rosport        0-0 Kaerjheng   [Febr 18]
Schieren       2-0 Wormeldange [Febr 18]

Round 12
[Dec 3]
Diekirch       3-8 Kaerjheng
Niedercorn     5-2 Rosport
Petange        2-0 Aris
Schifflange    2-3 Spora
Schieren       1-2 Hollerich
Wormeldange    1-1 Mamer
Hamm           2-0 Hesperange  [Febr 11]

Round 13
[Dec 6]
Kaerjheng      1-1 Petange
Hesperange     2-0 Schieren
Hollerich      0-2 Niedercorn  [Apr 11]
Mamer          2-2 Schifflange [Mar 28]
Aris           0-3 Hamm
Rosport        2-1 Diekirch    [Apr 11]
Spora          1-1 Wormeldange

Round 14
[Mar 11]
Diekirch       3-2 Schifflange
Niedercorn     1-0 Wormeldange
Hollerich      0-3 Hesperange
Rosport        4-0 Aris
Schieren       0-3 Kaerjheng
Petange        4-0 Mamer
Hamm           0-2 Spora       [Apr 22]

Round 15
[Mar 17]
Kaerjheng      0-1 Niedercorn
Hesperange     4-0 Rosport     [Apr 4]
Wormeldange    0-2 Diekirch    [Apr 4]
Mamer          0-1 Hamm
Aris           3-1 Hollerich
Schifflange    3-1 Petange
Spora          0-1 Schieren

Round 16
[Apr 1]
Rosport        0-0 Schifflange
Hamm           2-0 Wormeldange
Hesperange     4-0 Aris
Hollerich      3-0 Kaerjheng
Petange        1-0 Diekirch
Schieren       1-1 Mamer
Niedercorn     1-5 Spora

Round 17
[Apr 8]
Kaerjheng      1-3 Hamm
Hesperange     1-1 Niedercorn
Wormeldange    1-1 Schifflange
Mamer          0-5 Diekirch
Aris           1-4 Schieren
Hollerich      0-2 Rosport
Spora          1-2 Petange

Round 18
[Apr 15]
Schifflange    0-0 Hamm
Kaerjheng      2-1 Hesperange
Wormeldange    0-0 Petange
Mamer          0-2 Rosport
Aris           3-1 Niedercorn
Diekirch       0-0 Schieren
Spora          2-1 Hollerich

Round 19
[Apr 18]
Rosport        0-0 Wormeldange
Hamm           1-1 Diekirch
Hesperange     3-1 Spora
Hollerich      1-1 Mamer
Aris           2-0 Kaerjheng
Schieren       1-0 Schifflange
Niedercorn     2-0 Petange

Round 20
[Apr 25]
Schifflange    0-2 Hollerich
Kaerjheng      2-0 Rosport
Wormeldange    0-1 Schieren
Mamer          3-4 Niedercorn
Petange        3-1 Hamm
Diekirch       1-2 Hesperange
Spora          2-0 Aris

Round 21
[Apr 29]
Rosport        2-3 FC Hamm
Kaerjheng      3-1 Spora
Hesperange     2-0 Wormeldange
Hollerich      1-1 Diekirch     [May 9]
Aris           3-3 Mamer
Schieren       1-0 Petange
Niedercorn     0-0 Schifflange

Round 22
[May 2]
Schifflange    0-1 Aris
Wormeldange    2-0 Hollerich
Hamm           0-0 Schieren
Mamer          1-1 Kaerjheng
Petange        1-4 Hesperange
Diekirch       0-1 Niedercorn
Spora          0-2 Rosport      [May 9]

Round 23
[May 5]
Hesperange     3-0 Schifflange
Kaerjheng      3-1 Wormeldange
Rosport        2-1 Schieren
Hollerich      4-1 Petange
Niedercorn     1-0 Hamm
Aris           2-4 Diekirch
Spora          3-0 Mamer

Round 24
[May 13]
Schifflange    2-1 Kaerjheng
Wormeldange    2-0 Aris
Hamm           1-0 Hollerich
Mamer          0-4 Hesperange
Petange        0-0 Rosport
Schieren       0-1 Niedercorn
Diekirch       2-0 Spora

Round 25
[May 19]
Hesperange     3-2 Hamm
Kaerjheng      2-2 Diekirch
Rosport        0-1 Niederkorn
Hollerich      3-0 Schieren
Mamer          0-4 Wormeldange
Aris           3-1 Petange
Spora          8-0 Schifflange

Round 26
[May 24]
Schifflange    2-3 Mamer
Wormeldange    1-3 Spora
Hamm           1-2 Aris
Niedercorn     2-4 Hollerich
Petange        3-1 Kaerjeng
Schieren       2-4 Hesperange
Diekirch       2-2 Rosport

Final Table:

 1. Swift Hesperange      26 21  2  3  74-21  65  Champions, promoted
 2. Progres Niedercorn    26 16  3  7  42-31  51  Promoted
------------------------------------------------
 3. Spora Luxembourg      26 15  2  9  54-33  47
 4. Victoria Rosport      26 12  6  8  37-28  42
 5. FC Hamm               26 13  3 10  37-32  42
 6. CS Petange            26 10  5 11  38-43  35
 7. CS Hollerich          26  9  5 12  32-44  32
 8. UN Kaerjheng          26  7 10  9  44-42  31
 9. Young Boys Diekirch   26  8  6 12  41-41  30
10. Jeunesse Schieren     26  8  6 12  22-35  30
11. Aris Bonnevoie        26  9  3 14  33-52  30
------------------------------------------------
12. Koeppchen Wormeldange 26  7  6 13  30-36  27  Relegated
13. FC Schifflange '95    26  5  9 12  28-49  24  Relegated
14. FC Mamer '32          26  5  8 13  32-57  23  Relegated


Author: Jan Schoenmakers
(Jan.Schoenmakers@atosorigin.com)

Last updated: 10 Nov 2001

(C) Copyright Jan Schoenmakers and RSSSF 2000/01


  USO DE MEMORIA  
4,306,080 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3429
Total Execution Time  0.3448
  CADENA URL  
/division_d_honneur_luxemburgo2001
  GET DATOS  
$_GET['/division_d_honneur_luxemburgo2001']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0105  SELECT type FROM routes WHERE alias = 'division_d_honneur_luxemburgo2001'
0.0212  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'division_d_honneur_luxemburgo' 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.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=349 AND type_rel = 3
0.0106  SELECT text_es as historical_text FROM leagues_text WHERE id=1213
0.0105  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 = 29477 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='2001' WHERE c.parentId=349 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-26 18:52:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-26 18:52:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-26 18:52:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-26 18:52:43' 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 = 'division_d_honneur_luxemburgo' 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.0107  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=29477 AND rel.round=22
0.0106  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 = 29477 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0105  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 = 29477 AND esl.points > 0
0.0105  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-27" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 29477 ORDER BY creation_date DESC LIMIT 0, 10
0.0108  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-27" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 29477
0.0106  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` = 29477 AND c.`round` = 22 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 `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 = 22 AND e.real_date IS NOT NULL AND e.league_id = 29477 ORDER BY total DESC LIMIT 40
0.0107  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 = 29477 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0113  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 = 29477 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 29477 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0105  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-26 00:00:00' AND c.`shedule` < '2024-04-30 23:59:59' AND l.id = 29477 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0120  SELECT data1, data2 FROM services_tags WHERE categoryId=349
0.0120  SELECT group_code, extraName from `leagues` WHERE categoryId=349 AND year=2001