4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2004
Temporada Siguiente »
Publicidad 600x120.gif
Segunda Lituania 2004
2003/2004

Segunda Lituania 2004

Información Histórica 
						
Second Level 2004

LFF 1 LYGA

f FK Vilnius.


Round 1
[Apr 17]
Nevezis           1-0  Babrungas
Atletas           2-0  Lietava
Mazeikiai         3-0  Gel.Vilkas
Vilnius-2         0-1  Polonija
Tauras            0-2  Siauliai
Utenis            0-4  Vetra-2
Rodovitas         0-0  Alytis
LKKA              3-1  Ekranas-2

Round 2
[Apr 20]
Tauras            0-0  LKKA
Siauliai          2-0  Vilnius-2
Polonija          1-2  Mazeikiai
Alytis            0-0  Gel.Vilkas
Rodovitas         4-1  Utenis
[Apr 21]
Atletas           1-1  Ekranas-2
Babrungas         6-3  Lietava
Kauno Jegeriai    2-1  Nevezis

Round 3
[Apr 23]
Lietava           1-0  Kauno Jegeriai
[Apr 24]
Gel.Vilkas        3-0  Utenis
Nevezis           1-0  Vetra-2
LKKA              0-0  Atletas
Alytis            2-1  Polonija
Ekranas-2         2-0  Babrungas
Mazeikiai         1-3  Siauliai
Vilnius-2         1-2  Tauras

Round 4
[May 01]
LKKA              4-1  Vilnius-2
Mazeikiai         4-0  Tauras
Utenis            0-3  Polonija
Siauliai          1-0  Alytis
Rodovitas         0-3  Nevezis
Vetra-2           1-1  Lietava
Kauno Jegeriai    1-1  Ekranas-2
Babrungas         1-0  Atletas

Round 5
[May 04]
Kauno Jegeriai    1-0  Atletas
Ekranas-2         0-2  Vetra-2
Lietava           4-1  Rodovitas
Nevezis           2-1  Gel.Vilkas
Utenis            0-2  Siauliai
Alytis            0-1  Tauras
Vilnius-2         0-1  Mazeikiai
Babrungas         5-2  LKKA

Round 6
[May 08]
Vetra-2           1-1  Atletas
Kauno Jegeriai    5-0  Babrungas
Vilnius-2         0-0  Alytis
Tauras            1-0  Utenis
Lietava           1-0  Gel.Vilkas
Ekranas-2         2-2  Rodovitas
LKKA              0-3  Mazeikiai
Nevezis           2-1  Polonija

Round 7
[May 15]
Atletas           1-0  Rodovitas
Gel.Vilkas        4-0  Ekranas-2
Lietava           0-0  Polonija
Nevezis           1-0  Siauliai
Babrungas         4-1  Vetra-2
Utenis            1-0  Vilnius-2
[May 16]
Alytis            1-1  Mazeikiai
[Jun 08]
Kauno Jegeriai    4-1  LKKA

Round 8
[May 21]
Siauliai          5-2  Lietava
[May 22]
LKKA              2-0  Alytis
Tauras            0-1  Nevezis
Rodovitas         3-2  Babrungas
Polonija          2-1  Ekranas-2
[Jun 08]
Mazeikiai         6-0  Utenis
Gel.Vilkas        4-1  Atletas
[Aug 03]
Vetra-2           1-1  Kauno Jegeriai

Round 9
[May 18]
Vetra-2           2-4  LKKA
[May 29]
Atletas           0-2  Polonija
Utenis            4-1  Alytis
Lietava           1-0  Tauras
Nevezis           1-1  Vilnius-2
Ekranas-2         2-1  Siauliai
Gel.Vilkas        1-0  Babrungas
Kauno Jegeriai    1-1  Rodovitas

Round 10
[Jun 01]
Kauno Jegeriai    2-0  Gel.Vilkas
Babrungas         5-0  Polonija
LKKA              2-2  Utenis
Tauras            2-0  Ekranas-2
Siauliai          2-1  Atletas
Vilnius-2         1-2  Lietava
[Jun 08]
Rodovitas         1-1  Vetra-2
[Sep 28]
Mazeikiai         1-3  Nevezis

Round 11
[Jun 05]
Atletas           0-2  Tauras
Rodovitas         5-2  LKKA
Lietava           3-2  Mazeikiai
Babrungas         0-2  Siauliai
Ekranas-2         4-1  Vilnius-2
Nevezis           1-3  Alytis
[Jul 06]
Vetra-2           3-4  Gel.Vilkas
[Jul 30]
Polonija          1-4  Kauno Jegeriai

Round 12
[Jun 11]
Gel.Vilkas        2-0  Rodovitas
Utenis            0-2  Nevezis
Alytis            2-1  Lietava
Siauliai          0-0  Kauno Jegeriai
Mazeikiai         1-0  Ekranas-2
Tauras            3-1  Babrungas
Vilnius-2         1-1  Atletas
[Jun 12]
Polonija          2-0  Vetra-2

Round 13
[Jun 15]
Atletas           2-1  Mazeikiai
Gel.Vilkas        6-3  LKKA
Rodovitas         0-1  Polonija
Vetra-2           2-5  Siauliai
Babrungas         1-0  Vilnius-2
Ekranas-2         4-0  Alytis
Lietava           2-1  Utenis
[Jun 16]
Kauno Jegeriai    4-1  Tauras

Round 14
[Jun 18]
Mazeikiai         1-1  Babrungas
[Jun 19]
LKKA              2-1  Nevezis
Vilnius-2         0-2  Kauno Jegeriai
Alytis            0-2  Atletas
Tauras            2-3  Vetra-2
Siauliai          8-1  Rodovitas
Polonija          1-1  Gel.Vilkas
[Jun 20]
Utenis            0-2  Ekranas-2

Round 15
[Jun 26]
Gel.Vilkas        0-0  Siauliai
Babrungas         0-0  Alytis
Atletas           0-0  Utenis
Rodovitas         1-1  Tauras
Nevezis           3-1  Lietava
[Jul 06]
Kauno Jegeriai    2-0  Mazeikiai
[Aug 31]
Polonija          0-0  LKKA
Vetra-2           1-0  Vilnius-2

Round 16
[Jun 29]
LKKA              1-1  Lietava
Utenis            4-0  Babrungas
Mazeikiai         3-2  Vetra-2
Vilnius-2         0-4  Rodovitas
Nevezis           0-0  Ekranas-2
Alytis            0-6  Kauno Jegeriai
Tauras            2-0  Gel.Vilkas
Siauliai          1-0  Polonija

Round 17
[Jul 02]
Kauno Jegeriai    3-1  Utenis
Gel.Vilkas        3-0  Vilnius-2
Vetra-2           1-1  Alytis
Ekranas-2         5-2  Lietava
Siauliai          7-1  LKKA
Rodovitas         2-4  Mazeikiai
[Jul 03]
Atletas           0-1  Nevezis
[Jul 04]
Polonija          4-1  Tauras

Round 18
[Jul 31]
Vetra-2           0-1  Utenis
Lietava           0-2  Atletas
Babrungas         3-1  Nevezis
Alytis            1-1  Rodovitas
Siauliai          4-1  Tauras
Gel.Vilkas        2-0  Mazeikiai
[Aug 02]
Polonija          3-4  Vilnius-2

Round 19
[Aug 06]
Mazeikiai         1-0  Polonija
Ekranas-2         2-0  Atletas
[Aug 07]
Gel.Vilkas        1-0  Alytis
Utenis            0-2  Rodovitas
Nevezis           1-2  Kauno Jegeriai
Lietava           0-6  Babrungas
Vilnius-2         1-3  Siauliai
[Aug 17]
LKKA              0-1  Tauras

Round 20
[Aug 10]
Atletas           1-1  LKKA
Babrungas         4-0  Ekranas-2
Vetra-2           1-3  Nevezis
Utenis            1-3  Gel.Vilkas
Polonija          1-0  Alytis
Tauras            2-1  Vilnius-2
Siauliai          4-0  Mazeikiai
Kauno Jegeriai    2-1  Lietava

Round 21
[Aug 13]
Vilnius-2         2-0  LKKA
Tauras            0-3  Mazeikiai
[Aug 14]
Atletas           2-0  Babrungas
[Aug 15]
Alytis            1-2  Siauliai
Lietava           2-1  Vetra-2
Polonija          5-0  Utenis
Nevezis           6-0  Rodovitas
Ekranas-2         0-2  Kauno Jegeriai

Round 22
[Aug 20]
Vetra-2           5-3  Ekranas-2
[Aug 21]
Kauno Jegeriai    5-0  Atletas
Gel.Vilkas        3-2  Nevezis
Rodovitas         2-5  Lietava
Tauras            1-2  Alytis
Mazeikiai         2-1  Vilnius-2
Siauliai         10-0  Utenis
LKKA              2-1  Babrungas

Round 23
[Aug 24]
Atletas           2-6  Vetra-2
Mazeikiai         1-2  LKKA
Utenis            2-1  Tauras
Rodovitas         1-0  Ekranas-2
Babrungas         3-3  Kauno Jegeriai
Alytis            0-2  Vilnius-2
Polonija          0-3  Nevezis
Gel.Vilkas        3-0  Lietava

Round 24
[Aug 28]
Vilnius-2         1-1  Utenis
LKKA              1-3  Kauno Jegeriai
Polonija          3-0  Lietava
Rodovitas         5-0  Atletas
Ekranas-2         1-1  Gel.Vilkas
Mazeikiai         2-1  Alytis
Siauliai          0-1  Nevezis
Vetra-2           5-1  Babrungas

Round 25
[Sep 04]
Kauno Jegeriai    3-0  Vetra-2
[Sep 05]
Alytis            1-1  LKKA
Nevezis           5-1  Tauras
Lietava           1-0  Siauliai
Ekranas-2         0-3  Polonija
Babrungas         0-0  Rodovitas
Atletas           2-0  Gel.Vilkas
[Oct 26]
Utenis            4-2  Mazeikiai

Round 26
[Sep 11]
LKKA              2-0  Vetra-2
Polonija          3-0  Atletas
Siauliai          4-0  Ekranas-2
Alytis            2-0  Utenis
Babrungas         1-1  Gel.Vilkas
Tauras            1-5  Lietava
Rodovitas         2-0  Kauno Jegeriai
Vilnius-2         2-4  Nevezis

Round 27
[Sep 14]
Babrungas         1-0  Polonija
Vetra-2           2-2  Rodovitas
Atletas           0-0  Siauliai
Utenis            2-0  LKKA
Nevezis           1-1  Mazeikiai
Lietava           2-0  Vilnius-2
Ekranas-2         9-0  Tauras
Gel.Vilkas        2-2  Kauno Jegeriai

Round 28
[Sep 18]
Gel.Vilkas        2-3  Vetra-2
Kauno Jegeriai    1-3  Polonija
Mazeikiai         2-2  Lietava
Alytis            1-1  Nevezis
Tauras            0-3  Atletas
Vilnius-2         0-1  Ekranas-2
LKKA              0-2  Rodovitas
from Round 18
[Sep 21]
Ekranas-2         3-1  LKKA

Round 29
[Sep 25]
Atletas           0-0  Vilnius-2
Nevezis           0-0  Utenis
Ekranas-2         0-1  Mazeikiai
Vetra-2           0-6  Polonija
Lietava           1-0  Alytis
Babrungas         1-0  Tauras
Rodovitas         2-4  Gel.Vilkas
Kauno Jegeriai    1-1  Siauliai

Round 30
[Oct 02]
LKKA              0-3  Gel.Vilkas
Vilnius-2         4-2  Babrungas
Siauliai          5-0  Vetra-2
Mazeikiai         2-1  Atletas
Alytis            2-0  Ekranas-2
Tauras            1-3  Kauno Jegeriai
Utenis            1-0  Lietava
Polonija          2-1  Rodovitas
from Round 28
[Oct 05]
Siauliai          0-0  Babrungas

Round 31
[Oct 07]
Nevezis           7-3  LKKA
[Oct 09]
Gel.Vilkas        2-1  Polonija
Ekranas-2         0-1  Utenis
Babrungas         4-0  Mazeikiai
Rodovitas         1-3  Siauliai
Vetra-2           4-0  Tauras
[Oct 10]
Atletas           0-0  Alytis
[Oct 12]
Kauno Jegeriai    2-0  Vilnius-2

Round 32
[Oct 16]
LKKA              1-2  Polonija
Lietava           1-1  Nevezis
Siauliai          2-0  Gel.Vilkas
Tauras            1-4  Rodovitas
Vilnius-2         0-1  Vetra-2
Alytis            1-0  Babrungas
Utenis            2-0  Atletas
[Oct 28]
Mazeikiai         1-3  Kauno Jegeriai

Round 33
[Oct 23]
Kauno Jegeriai    0-1  Alytis
Gel.Vilkas        4-1  Tauras
Lietava           0-0  LKKA
Ekranas-2         1-1  Nevezis
Babrungas         2-0  Utenis
Vetra-2            -   Mazeikiai
Rodovitas         2-1  Vilnius-2
Polonija          0-1  Siauliai

Round 34
[Oct 30]
LKKA              3-1  Siauliai
Tauras            0-1  Polonija
Vilnius-2         1-1  Gel.Vilkas
Mazeikiai         2-3  Rodovitas
Alytis            0-3  Vetra-2
Utenis            0-3  Kauno Jegeriai
Nevezis           1-0  Atletas
Lietava           0-0  Ekranas-2

Final Table:

 1. KFK Siauliai             32  22  5  5  81-21   71   champion, promoted
 2. Kauno Jegeriai           32  21  7  4  73-26   70 *
 3. Nevezis Kedainiai        32  19  7  6  62-31   64   promoted
 ----------------------------------------------------
 4. Gelezinis Vilkas Vilnius 32  17  7  8  61-37   58
 5. Polonija Vilnius         32  17  3 12  53-34   54 *
 6. FK Mazeikiai             32  15  4 13  54-51   49
 7. Lietava Jonava           32  13  7 12  45-54   46
 8. Babrungas Plunge         32  13  6 13  55-47   45
 9. Rodovitas Klaipeda       32  12  8 12  55-60   44
10. Vetra-2 Vilnius          32  12  6 14  59-62   42 *
11. Ekranas-2 Panevezys      32  10  7 15  45-48   37 *
12. LKKA Kaunas              32   9  8 15  44-68   35
13. Utenis Utena             32  10  4 18  29-66   34
14. Alytis Alytus            32   8 10 14  23-41   34
15. Atletas Kaunas           32   8  9 15  25-44   33
16. Tauras Taurage           32   9  2 21  29-73   29
17. FK Vilnius-2             32   4  6 22  26-56   18 *

  Polonia is farm-team of Zalgiris Vilnius,
  Kauno Jegeriai is farm-team of FBK Kaunas,
  Vetra-2 is farm-team of Vetra Vilnius,
  Ekranas-2 is farm-team of Ekranas Panevezys,
  Vilnius-2 is farm-team of FK Vilnius.




Author: Almantas Lauzadis
(almis@post.omnitel.net)

Last updated: 14 Apr 2005

(C) Copyright Almantas Lauzadis and RSSSF 2004/05


  USO DE MEMORIA  
4,240,680 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0024
Controller Execution Time ( Home / Category )  0.5496
Total Execution Time  0.5520
  CADENA URL  
/1_league_lituania2004
  GET DATOS  
$_GET['/1_league_lituania2004']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0127  SELECT type FROM routes WHERE alias = '1_league_lituania2004'
0.0256  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = '1_league_lituania' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2004 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0133  SELECT text_es as historical_text FROM leagues_text WHERE id=1173
0.0129  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 = 29462 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  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='2004' WHERE c.parentId=373 GROUP BY c.id ORDER BY c.order_id ASC
0.0125  SELECT type,rule FROM rules WHERE categoryId = 373 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-05-02 14:43:19' 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-05-02 14:43:19' 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-05-02 14:43:19' 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-05-02 14:43:19' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = '1_league_lituania' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2004 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 events2004 e WHERE e.league_id IN (29462) 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 (29462) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0128  SELECT e.action, count(e.action) as total, e.player_id FROM events2004 e WHERE e.league_id IN (29462) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0128  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 (29462) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0134  SELECT e.action, count(e.action) as total, e.player_id FROM events2004 e WHERE e.league_id IN (29462) AND (e.action IN (3,4) ) 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 (29462) 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 events2004 e WHERE e.league_id IN (29462) AND (e.action IN (22) ) 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 (29462) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0126  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 = 29462 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0126  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 = 29462 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0132  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=29462 AND rel.round=28
0.0126  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 = 29462 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0127  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 = 29462 AND esl.points > 0
0.0128  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-04-02" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 29462 ORDER BY creation_date DESC LIMIT 0, 10
0.0137  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-04-02" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 29462
0.0131  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 `calendars2004` 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` = 29462 AND c.`round` = 28 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 `events2004` e INNER JOIN calendars2004 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 = 28 AND e.real_date IS NOT NULL AND e.league_id = 29462 ORDER BY total DESC LIMIT 40
0.0135  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 `events2004` e INNER JOIN calendars2004 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 = 29462 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0134  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 `tables2004` 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 = 29462 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2004` 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 = 29462 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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-05-02 00:00:00' AND c.`shedule` < '2024-05-06 23:59:59' AND l.id = 29462 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0134  SELECT data1, data2 FROM services_tags WHERE categoryId=373
0.0134  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 373 AND l.year = 2004 ORDER BY l.group_code ASC
0.0134  SELECT group_code, extraName from `leagues` WHERE categoryId=373 AND year=2004