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

Ehrenpromotion

Final Table:

 1.Etzella Ettelbruck      26 20  3  3  78-24 63  Champions, Promoted
 2.FC Rodange '91          26 19  3  4  61-23 60  Promoted
------------------------------------------------
 3.Young Boys Diekirch (P) 26 19  2  5  59-21 59
 4.Swift Hesperange        26 14  5  7  53-32 47
 5.CA Spora Luxembourg (R) 26 13  6  7  50-35 45
 6.Koeppchen Wormeldange   26  9  8  9  45-41 35
 7.CS Petange (R)          26  8  8 10  40-39 32
 8.FC Hamm                 26  8  8 10  42-52 32
 9.CS Hollerich            26  9  4 13  40-45 31
10.Progres Niedercorn      26  8  4 14  38-48 28
11.UN Kaerjheng            26  5  9 12  34-66 24
------------------------------------------------
12.Fola Esch/Alzette       26  4  6 16  25-62 18  Relegated
13.SC Tetange (P)          26  2 10 14  22-62 16  Relegated
14.RM '86 Luxembourg (P)   26  2  8 16  24-61 14  Relegated

(P) Promoted last year,   (R) Relegated last year

Round 1 [Aug 22]
CA Spora Luxembourg - CS Hollerich          3-1
Koeppchen Wormeldange - Young Boys Diekirch 0-3
Progres Niedercorn - Swift Hesperange       0-2
CS Petange - FC Rodange '91                 0-1
FC Hamm - UN Kaerjheng                      1-2
Etzella Ettelbruck - Fola Esch/Alzette      0-2
RM '86 Luxembourg - SC Tetange              1-1

Round 2 [Aug 25]
CA Spora Luxembourg - Koeppchen Wormeldange 2-0
Fola Esch/Alzette - SC Tetange              3-3
UN  Kaerjheng - RM '86 Luxembourg           3-3
FC Rodange '91 - FC Hamm                    1-1
Swift Hesperange - CS Petange               2-1
Young Boys Diekirch - Progres Niedercorn    1-0
CS Hollerich - Etzella Ettelbruck           1-2

Round 3 [Aug 29]
SC Tetange - UN Kaerjheng                   1-1
Koeppchen Wormeldange - CS Hollerich        2-1
Progres Niedercorn - CA Spora Luxembourg    0-0 [Oct 20]
CS Petange - Young Boys Diekirch            2-2
FC Hamm - Swift Hesperange                  2-0 [Oct 20]
Etzella Ettelbruck - FC Rodange '91         2-0 [Oct 20]
RM '86 Luxembourg - Fola Esch/Alzette       0-3

Round 4 [Sep 19]
CA Spora Luxembourg - RM '86 Luxembourg     1-1
Koeppchen Wormeldange - Progres Niedercorn  4-1
UN  Kaerjheng - Fola Esch/Alzette           2-2
FC Rodange '91 - SC Tetange                 5-1
Swift Hesperange - Etzella Ettelbruck       1-2
Young Boys Diekirch - FC Hamm               3-0
CS Hollerich - CS Petange                   1-0

Round 5 [Sep 22]
SC Tetange - Swift Hesperange               1-3
Fola Esch/Alzette - FC Rodange '91          0-1
Progres Niedercorn - CS Hollerich           2-4
CS Petange - CA Spora Luxembourg            2-3
FC Hamm - Koeppchen Wormeldange             3-1
Etzella Ettelbruck - UN Kaerjheng           6-0
RM '86 Luxembourg - Young Boys Diekirch     1-4

Round 6 [Sep 26]
CA Spora Luxembourg - FC Hamm               1-0
Koeppchen Wormeldange - CS Petange          0-0
Progres Niedercorn - Etzella Ettelbruck     0-1
FC Rodange '91 - UN Kaerjheng               5-0
Swift Hesperange - Fola Esch/Alzette        2-1
Young Boys Diekirch - SC Tetange            2-0
CS Hollerich - RM '86 Luxembourg            3-1

Round 7 [Oct 3]
SC Tetange - CA Spora Luxembourg            4-2
Fola Esch/Alzette - Koeppchen Wormeldange   1-5
UN Kaerjheng - Swift Hesperange             2-1
CS Petange - Progres Niedercorn             0-3
FC Hamm - CS Hollerich                      1-3
Etzella Ettelbruck - Young Boys Diekirch    1-2
RM '86 Luxembourg - FC Rodange '91          0-2

Round 8 [Oct 24]
CA Spora Luxembourg - Etzella Ettelbruck    1-2
Koeppchen Wormeldange - SC Tetange          0-1
Progres Niedercorn - FC Hamm                2-1
CS Petange - RM '86 Luxembourg              1-0
Swift Hesperange - FC Rodange '91           1-1
Young Boys Diekirch - UN Kaerjheng          2-0
CS Hollerich - Fola Esch/Alzette            3-1

Round 9 [Oct 31]
SC Tetange - CS Hollerich                   0-1
Fola Esch/Alzette - Progres Niedercorn      1-2
UN Kaerjheng - Spora Luxembourg             1-2
FC Rodange '91 - Young Boys Diekirch        2-1
FC Hamm - CS Petange                        0-3
Etzella Ettelbruck - Koeppchen Wormeldange  5-1
RM '86 Luxembourg - Swift Hesperange        0-4

Round 10 [Nov 7]
CA Spora Luxembourg - Fola Esch/Alzette     0-0
Koeppchen Wormeldange - UN Kaerjheng        2-2
Progres Niedercorn - SC Tetange             0-0
CS Petange - Etzella Ettelbruck             1-1
FC Hamm - RM '86 Luxembourg                 3-1
Young Boys Diekirch - Swift Hesperange      0-1
CS Hollerich - FC Rodange '91               1-2

Round 11 [Nov 14]
SC Tetange - CS Petange                     1-1
Fola Esch/Alzette - Yound Boys Diekirch     1-4
UN Kaerjheng - CS Hollerich                 3-3 [Nov 17]
FC Rodange '91 - CA Spora Luxembourg        5-0
Swift Hesperange - Koeppchen Wormeldange    0-3
Etzella Ettelbruck - FC Hamm                5-1
RM '86 Luxembourg - Progres Niedercorn      4-2

Round 12 [Nov 21]
CA Spora Luxembourg - Swift Hesperange      1-1
Koeppchen Wormeldange - FC Rodange '91      0-2
Progres Niedercorn - UN Kaerjheng           4-0
CS Petange - Fola Esch/Alzette              4-0
FC Hamm - SC Tetange                        2-0
Etzella Ettelbruck - RM '86 Luxembourg      3-1
CS Hollerich - Young Boys Diekirch          0-1

Round 13 [Nov 28]
SC Tetange - Etzella Ettelbruck             2-2
Fola Esch/Alzette - FC Hamm                 0-0
UN Kaerjheng - CS Petange                   2-3
FC Rodange '91 - Progres Niedercorn         2-0
Swift Hesperange - CS Hollerich             2-0
Young Boys Diekirch - Spora Luxembourg      2-0
RM '86 Luxembourg - Koeppchen Wormeldange   1-3

Round 14 [Dec 5]
Young Boys Diekirch - Koeppchen Wormeldange 4-1
Swift Hesperange - Progres Niedercorn       4-1
FC Rodange '91 - CS Petange                 2-0
UN Kaerjheng - FC Hamm                      2-2
Fola Esch/Alzette - Etzella Ettelbruck      2-5
SC Tetange - RM '86 Luxembourg              2-1
CS Hollerich - CA Spora Luxembourg          1-3

Round 15 [Feb 20]
Koeppchen Wormeldange - CA Spora Luxembourg 2-1
SC Tetange - Fola Esch/Alzette              0-1
RM '86 Luxembourg - UN Kaerjheng            2-1
FC Hamm - FC Rodange '91                    1-2
CS Petange - Swift Hesperange               0-2
Progres Niedercorn - Young Boys Diekirch    0-2
Etzella Ettelbruck - CS Hollerich           3-2

Round 16 [Feb 27]
Yound Boys Diekirch - CS Petange            3-1
Swift Hesperange - FC Hamm                  8-2
FC Rodange '91 - Etzella Ettelbruck         0-3
UN Kaerjheng - SC Tetange                   2-1
Fola Esch/Alzette - RM '86 Luxembourg       0-0
CA Spora Luxembourg - Progres Niedercorn    1-2
CS Hollerich - Koeppchen Wormeldange        2-3

Round 17 [Mar 12]
Koeppchen Wormeldange - CA Spora Luxembourg 2-1
SC Tetange - FC Rodange '91                 0-5
RM '86 Luxembourg - CA Spora Luxembourg     1-5
FC Hamm - Young Boys Diekirch               2-1
CS Petange - CS Hollerich                   0-1
Progres Niedercorn - Koeppchen Wormeldange  2-0
Etzella Ettelbruck - Swift Hesperange       5-0

Round 18 [Mar 19]
Young Boys Diekirch - RM '86 Luxembourg     2-0
Swift Hesperange - SC Tetange               0-0
FC Rodange '91 - Fola Esch/Alzette          2-0
UN Kaerjheng - Etzella Ettelbruck           0-2
Koeppchen Wormeldange - FC Hamm             1-1
CA Spora Luxembourg - CS Petange            1-1
CS Hollerich - Progres Niedercorn           3-2

Round 19 [Mar 26]
UN Kaerjheng - FC Rodange '91               0-6
SC Tetange - Young Boys Diekirch            0-4
RM '86 Luxembourg - CS Hollerich            1-1
FC Hamm - CA Spora Luxembourg               3-0
CS Petange - Koeppchen Wormeldange          1-1
Fola Esch/Alzette - Swift Hesperange        1-5
Etzella Ettelbruck - Progres Niedercorn     5-1

Round 20 [Apr 2]
Young Boys Diekirch - Etzella Ettelbruch    2-1
Swift Hesperange - UN Kaerjheng             5-0
FC Rodange '91 - RM '86 Luxembourg          3-3
Progres Niedercorn - CS Petange             1-2
Koeppchen Wormeldange - Fola Esch/Alzette   1-1
CA Spora Luxembourg - SC Tetange            4-1
CS Hollerich - FC Hamm                      2-2

Round 21 [Apr 9]
Etzella Ettelbruck - CA Spora Luxembourg    2-0
SC Tetange - Koeppchen Wormeldange          0-5
FC Hamm - Progres Niedercorn                3-1
RM '86 Luxembourg - CS Petange              0-0
FC Rodange '91 - Swift Hesperange           1-0
UN Kaerjheng - Young Boys Diekirch          1-0
Fola Esch/Alzette - CS Hollerich            1-0

Round 22 [Apr 16]
Young Boys Diekirch - RC Rodange '91        3-0
Swift Hesperange - RM '86 Luxembourg        2-0
CS Petange - FC Hamm                        3-3
Progres Niedercorn - Fola Esch/Alzette      6-0
Koeppchen Wormeldange - Etzella Ettelbruck  1-1
CA Spora Luxembourg - UN Kaerjheng          1-1
CS Hollerich - SC Tetange                   2-2

Round 23 [Apr 30]
Etzella Ettelbruck - CS Petange             5-0
SC Tetange - Progres Niederkorn             1-1
Swift Hesperange - Young Boys Diekirch      2-2
RM '86 Luxembourg - FC Hamm                 1-1
FC Rodange '91 - CS Hollerich               2-0
UN Kaerjheng - Koeppchen Wormeldange        2-2
Fola Esch/Alzette - CA Spora Luxembourg     0-4

Round 24 [May 7]
Young Boys Diekirch - Fola Esch/Alzette     5-0
FC Hamm - Etzella Ettelbruck                2-6
CS Petange - SC Tetange                     7-0
Progres Niedercorn - RM '86 Luxembourg      3-1
Koeppchen Wormeldange - Swift Hesperange    1-1
CA Spora Luxembourg - FC Rodange '91        4-2
CS Hollerich - UN Kaerjheng                 2-0

Round 25 [May 14-16]
Young Boys Diekirch - CS Hollerich          3-2
SC Tetange - FC Hamm                        1-1
Swift Hesperange - CA Spora Luxembourg      1-5
RM '86 Luxembourg - Etzella Ettelbruck      0-4
FC Rodange '91 - Koeppchen Wormeldange      3-2
UN Kaerjheng - Progres Niedercorn           2-2
Fola Esch/Alzette - CS Petange              1-2

Round 26 [May 21]
Etzella Ettelbruck - SC Tetange             4-1
FC Hamm - Fola Esch/Alzette                 4-2
CS Petange - UN Kaerjheng                   5-3
Progres Niedercorn - FC Rodange '91         0-4
Koeppchen Wormeldange - RM '86 Luxembourg   4-0
CA Spora Luxembourg - Young Boys Diekirch   3-1
CS Hollerich - Swift Hesperange             0-3

Final Table:

 1.Etzella Ettelbruck      26 20  3  3  78-24 63  Champions, Promoted
 2.FC Rodange '91          26 19  3  4  61-23 60  Promoted
------------------------------------------------
 3.Young Boys Diekirch (P) 26 19  2  5  59-21 59
 4.Swift Hesperange        26 14  5  7  53-32 47
 5.CA Spora Luxembourg (R) 26 13  6  7  50-35 45
 6.Koeppchen Wormeldange   26  9  8  9  45-41 35
 7.CS Petange (R)          26  8  8 10  40-39 32
 8.FC Hamm                 26  8  8 10  42-52 32
 9.CS Hollerich            26  9  4 13  40-45 31
10.Progres Niedercorn      26  8  4 14  38-48 28
11.UN Kaerjheng            26  5  9 12  34-66 24
------------------------------------------------
12.Fola Esch/Alzette       26  4  6 16  25-62 18  Relegated
13.SC Tetange (P)          26  2 10 14  22-62 16  Relegated
14.RM '86 Luxembourg (P)   26  2  8 16  24-61 14  Relegated

(P) Promoted after last season,   (R) Relegated after last season

Promoted from 1st Class :
Victoria Rosport, FC Mamer and Jeunesse Schieren 



Author: Jan Schoenmakers
(Jan.Schoenmakers@nl.origin-it.com)

Last updated: 18 Sep 2000

(C) Copyright Jan Schoenmakers and RSSSF 1999/2000


  USO DE MEMORIA  
4,334,456 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.5590
Total Execution Time  0.5610
  CADENA URL  
/division_d_honneur_luxemburgo2000
  GET DATOS  
$_GET['/division_d_honneur_luxemburgo2000']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0128  SELECT type FROM routes WHERE alias = 'division_d_honneur_luxemburgo2000'
0.0254  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 = 2000 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=349 AND type_rel = 3
0.0132  SELECT text_es as historical_text FROM leagues_text WHERE id=1212
0.0128  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 = 29476 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131  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='2000' WHERE c.parentId=349 GROUP BY c.id ORDER BY c.order_id ASC
0.0128  SELECT type,rule FROM rules WHERE categoryId = 349 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-24 22:21:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-24 22:21:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-24 22:21:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-24 22:21:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  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 = 2000 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0125  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (29476) 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.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 (29476) 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 events2000 e WHERE e.league_id IN (29476) 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 (29476) 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 events2000 e WHERE e.league_id IN (29476) 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 (29476) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0127  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (29476) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0127  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 (29476) 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 = 29476 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 = 29476 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0128  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=29476 AND rel.round=22
0.0127  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 = 29476 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0126  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 = 29476 AND esl.points > 0
0.0127  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-25" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 29476 ORDER BY creation_date DESC LIMIT 0, 10
0.0130  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-25" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 29476
0.0126  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 `calendars2000` 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` = 29476 AND c.`round` = 22 ORDER BY shedule ASC LIMIT 200
0.0125  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 `events2000` e INNER JOIN calendars2000 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 = 29476 ORDER BY total DESC LIMIT 40
0.0127  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 `events2000` e INNER JOIN calendars2000 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 = 29476 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0127  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 `tables2000` 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 = 29476 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2000` 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 = 29476 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 29476 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0127  SELECT data1, data2 FROM services_tags WHERE categoryId=349
0.0127  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 349 AND l.year = 2000 ORDER BY l.group_code ASC
0.0127  SELECT group_code, extraName from `leagues` WHERE categoryId=349 AND year=2000