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
Primera Rusia 2004
2003/2004

Primera Rusia 2004

  • Akhmat Grozny
  • Tom Tomsk
  • Sokol Saratov
  • KamAZ
  • FK Khimki
  • SKA-Khabarovsk
  • FC Oryol
  • Metallurg Lipetsk
  • Anzhi
  • FK Chita
  • Dynamo Makhachkala
  • Spartak Nalchik
  • Arsenal Tula
  • Luch Vladivostok
  • Dinamo Bryansk
  • FK Metallurg-Kuzbass
  • Chernomorets Novorossisk
  • Elista Uralan
  • Neftekhimik
  • Baltika Kaliningrad
  • Mordovia Saransk
  • FC Soyuz Izhevsk

Primera Rusia 2004

La temporada finalizó el Sábado, 06 Noviembre 2004.
Resultados
« Jornada Anterior
Jornada 42
 
 
06 Nov 04
Finalizado 		FK Khimki FK Khimki 2-0 Baltika Kaliningrad Baltika Kaliningrad más información ...
 
06 Nov 04
Finalizado 		Luch Vladivostok Luch Vladivostok 1-0 Akhmat Grozny Akhmat Grozny más información ...
 
06 Nov 04
Finalizado 		SKA-Khabarovsk SKA-Khabarovsk 2-1 Spartak Nalchik Spartak Nalchik más información ...
 
06 Nov 04
Finalizado 		Dynamo Makhachkala Dynamo Makhachkala 4-1 FC Soyuz Izhevsk FC Soyuz Izhevsk más información ...
 
06 Nov 04
Finalizado 		Metallurg Lipetsk Metallurg Lipetsk 2-0 Arsenal Tula Arsenal Tula más información ...
 
06 Nov 04
Finalizado 		Neftekhimik Neftekhimik 0-2 KamAZ KamAZ más información ...
 
06 Nov 04
Finalizado 		FC Oryol FC Oryol 3-0 Sokol Saratov Sokol Saratov más información ...
 
06 Nov 04
Finalizado 		Tom Tomsk Tom Tomsk 4-2 Anzhi Anzhi más información ...
 
06 Nov 04
Finalizado 		FK Metallurg-Kuzbass FK Metallurg-Kuzbass 2-1 Chernomorets Novorossisk Chernomorets Novorossisk más información ...
 
06 Nov 04
Finalizado 		Elista Uralan Elista Uralan 3-0 Mordovia Saransk Mordovia Saransk más información ...
 
06 Nov 04
Finalizado 		FK Chita FK Chita 3-1 Dinamo Bryansk Dinamo Bryansk más información ...
Clasificación
« Jornada Anterior
Jornada 42
 
Equipos Puntos J. G. E. P. F. C. Forma
1 Akhmat Grozny Akhmat Grozny 100 42 32 4 6 70 22
  • DERROTA
  • Anzhi 2
  • Akhmat Grozny 1
  • VICTORIA
  • Akhmat Grozny 2
  • Tom Tomsk 1
  • DERROTA
  • Akhmat Grozny 3
  • FK Metallurg-Kuzba. 4
  • DERROTA
  • SKA-Khabarovsk 1
  • Akhmat Grozny 0
  • DERROTA
  • Luch Vladivostok 1
  • Akhmat Grozny 0
2 Tom Tomsk Tom Tomsk 86 42 27 5 10 71 40
  • VICTORIA
  • Tom Tomsk 2
  • Dinamo Bryansk 0
  • DERROTA
  • Akhmat Grozny 2
  • Tom Tomsk 1
  • VICTORIA
  • Spartak Nalchik 1
  • Tom Tomsk 2
  • VICTORIA
  • Tom Tomsk 3
  • Chernomorets Novor. 2
  • VICTORIA
  • Tom Tomsk 4
  • Anzhi 2
3 Sokol Saratov Sokol Saratov 83 42 25 8 9 71 39
  • VICTORIA
  • Sokol Saratov 3
  • Spartak Nalchik 1
  • EMPATE
  • Chernomorets Novor. 0
  • Sokol Saratov 0
  • EMPATE
  • Anzhi 1
  • Sokol Saratov 1
  • DERROTA
  • Sokol Saratov 0
  • Arsenal Tula 1
  • DERROTA
  • FC Oryol 3
  • Sokol Saratov 0
4 KamAZ KamAZ 69 42 19 12 11 52 49
  • VICTORIA
  • FK Khimki 0
  • KamAZ 1
  • VICTORIA
  • FK Chita 2
  • KamAZ 4
  • EMPATE
  • KamAZ 1
  • Elista Uralan 1
  • EMPATE
  • KamAZ 1
  • Dynamo Makhachkala 1
  • VICTORIA
  • Neftekhimik 0
  • KamAZ 2
5 FK Khimki FK Khimki 61 42 17 10 15 39 33
  • EMPATE
  • FK Khimki 0
  • Neftekhimik 0
  • EMPATE
  • FC Soyuz Izhevsk 1
  • FK Khimki 1
  • VICTORIA
  • Mordovia Saransk 0
  • FK Khimki 1
  • DERROTA
  • FK Khimki 1
  • Dinamo Bryansk 2
  • VICTORIA
  • FK Khimki 2
  • Baltika Kaliningra. 0
6 SKA-Khabarovsk SKA-Khabarovsk 61 42 16 13 13 42 37
  • VICTORIA
  • SKA-Khabarovsk 2
  • FC Soyuz Izhevsk 1
  • VICTORIA
  • Baltika Kaliningra. 1
  • SKA-Khabarovsk 3
  • EMPATE
  • Dinamo Bryansk 1
  • SKA-Khabarovsk 1
  • VICTORIA
  • SKA-Khabarovsk 1
  • Akhmat Grozny 0
  • VICTORIA
  • SKA-Khabarovsk 2
  • Spartak Nalchik 1
7 FC Oryol FC Oryol 61 42 16 13 13 37 34
  • EMPATE
  • FC Oryol 0
  • Anzhi 0
  • EMPATE
  • FC Oryol 2
  • Chernomorets Novor. 2
  • DERROTA
  • Arsenal Tula 4
  • FC Oryol 0
  • DERROTA
  • Metallurg Lipetsk 2
  • FC Oryol 0
  • VICTORIA
  • FC Oryol 3
  • Sokol Saratov 0
8 Metallurg Lipetsk Metallurg 60 42 15 15 12 48 43
  • EMPATE
  • Metallurg Lipetsk 1
  • Akhmat Grozny 1
  • EMPATE
  • Anzhi 0
  • Metallurg Lipetsk 0
  • EMPATE
  • Chernomorets Novor. 1
  • Metallurg Lipetsk 1
  • VICTORIA
  • Metallurg Lipetsk 2
  • FC Oryol 0
  • VICTORIA
  • Metallurg Lipetsk 2
  • Arsenal Tula 0
9 Anzhi Anzhi 60 42 16 12 14 50 53
  • VICTORIA
  • Anzhi 2
  • Akhmat Grozny 1
  • EMPATE
  • Anzhi 0
  • Metallurg Lipetsk 0
  • EMPATE
  • Anzhi 1
  • Sokol Saratov 1
  • VICTORIA
  • FK Metallurg-Kuzba. 0
  • Anzhi 1
  • DERROTA
  • Tom Tomsk 4
  • Anzhi 2
10 FK Chita FK Chita 59 42 17 8 17 47 48
  • DERROTA
  • FK Chita 2
  • KamAZ 4
  • VICTORIA
  • Mordovia Saransk 0
  • FK Chita 1
  • DERROTA
  • FC Soyuz Izhevsk 1
  • FK Chita 0
  • EMPATE
  • FK Chita 1
  • Baltika Kaliningra. 1
  • VICTORIA
  • FK Chita 3
  • Dinamo Bryansk 1
11 Dynamo Makhachkala Dynamo 59 42 16 11 15 44 48
  • DERROTA
  • Dynamo Makhachkala 1
  • Elista Uralan 2
  • EMPATE
  • Neftekhimik 1
  • Dynamo Makhachkala 1
  • EMPATE
  • KamAZ 1
  • Dynamo Makhachkala 1
  • EMPATE
  • Dynamo Makhachkala 1
  • Mordovia Saransk 1
  • VICTORIA
  • Dynamo Makhachkala 4
  • FC Soyuz Izhevsk 1
12 Spartak Nalchik Spartak Nalchik 58 42 16 10 16 53 46
  • DERROTA
  • Sokol Saratov 3
  • Spartak Nalchik 1
  • VICTORIA
  • Spartak Nalchik 3
  • FK Metallurg-Kuzba. 2
  • DERROTA
  • Spartak Nalchik 1
  • Tom Tomsk 2
  • EMPATE
  • Luch Vladivostok 0
  • Spartak Nalchik 0
  • DERROTA
  • SKA-Khabarovsk 2
  • Spartak Nalchik 1
13 Arsenal Tula Arsenal Tula 58 42 15 13 14 39 32
  • VICTORIA
  • Arsenal Tula 2
  • Chernomorets Novor. 0
  • DERROTA
  • Arsenal Tula 1
  • Anzhi 2
  • VICTORIA
  • Arsenal Tula 4
  • FC Oryol 0
  • VICTORIA
  • Sokol Saratov 0
  • Arsenal Tula 1
  • DERROTA
  • Metallurg Lipetsk 2
  • Arsenal Tula 0
14 Luch Vladivostok Luch Vladivostok 56 42 15 11 16 50 50
  • VICTORIA
  • Luch Vladivostok 3
  • Mordovia Saransk 0
  • EMPATE
  • Dinamo Bryansk 0
  • Luch Vladivostok 0
  • DERROTA
  • Baltika Kaliningra. 3
  • Luch Vladivostok 2
  • EMPATE
  • Luch Vladivostok 0
  • Spartak Nalchik 0
  • VICTORIA
  • Luch Vladivostok 1
  • Akhmat Grozny 0
15 Dinamo Bryansk Dinamo Bryansk 55 42 14 13 15 49 51
  • DERROTA
  • Tom Tomsk 2
  • Dinamo Bryansk 0
  • EMPATE
  • Dinamo Bryansk 0
  • Luch Vladivostok 0
  • EMPATE
  • Dinamo Bryansk 1
  • SKA-Khabarovsk 1
  • VICTORIA
  • FK Khimki 1
  • Dinamo Bryansk 2
  • DERROTA
  • FK Chita 3
  • Dinamo Bryansk 1
16 FK Metallurg-Kuzbass Metallurg-Kuzbas 52 42 14 10 18 53 53
  • VICTORIA
  • FK Metallurg-Kuzba. 3
  • Baltika Kaliningra. 1
  • DERROTA
  • Spartak Nalchik 3
  • FK Metallurg-Kuzba. 2
  • VICTORIA
  • Akhmat Grozny 3
  • FK Metallurg-Kuzba. 4
  • DERROTA
  • FK Metallurg-Kuzba. 0
  • Anzhi 1
  • VICTORIA
  • FK Metallurg-Kuzba. 2
  • Chernomorets Novor. 1
17 Chernomorets Novorossisk Chernomorets 51 42 13 12 17 47 44
  • EMPATE
  • FC Oryol 2
  • Chernomorets Novor. 2
  • EMPATE
  • Chernomorets Novor. 0
  • Sokol Saratov 0
  • EMPATE
  • Chernomorets Novor. 1
  • Metallurg Lipetsk 1
  • DERROTA
  • Tom Tomsk 3
  • Chernomorets Novor. 2
  • DERROTA
  • FK Metallurg-Kuzba. 2
  • Chernomorets Novor. 1
18 Elista Uralan Elista Uralan 50 42 13 11 18 48 57
  • VICTORIA
  • Dynamo Makhachkala 1
  • Elista Uralan 2
  • EMPATE
  • KamAZ 1
  • Elista Uralan 1
  • DERROTA
  • Neftekhimik 1
  • Elista Uralan 0
  • VICTORIA
  • Elista Uralan 1
  • FC Soyuz Izhevsk 0
  • VICTORIA
  • Elista Uralan 3
  • Mordovia Saransk 0
19 Neftekhimik Neftekhimik 45 42 11 12 19 38 57
  • DERROTA
  • FK Chita 1
  • Neftekhimik 0
  • EMPATE
  • FK Khimki 0
  • Neftekhimik 0
  • EMPATE
  • Neftekhimik 1
  • Dynamo Makhachkala 1
  • VICTORIA
  • Neftekhimik 1
  • Elista Uralan 0
  • DERROTA
  • Neftekhimik 0
  • KamAZ 2
20 Baltika Kaliningrad Baltika 39 42 10 9 23 37 60
  • DERROTA
  • FK Metallurg-Kuzba. 3
  • Baltika Kaliningra. 1
  • DERROTA
  • Baltika Kaliningra. 1
  • SKA-Khabarovsk 3
  • VICTORIA
  • Baltika Kaliningra. 3
  • Luch Vladivostok 2
  • EMPATE
  • FK Chita 1
  • Baltika Kaliningra. 1
  • DERROTA
  • FK Khimki 2
  • Baltika Kaliningra. 0
21 Mordovia Saransk Mordovia Saransk 26 42 5 11 26 24 62
  • DERROTA
  • Luch Vladivostok 3
  • Mordovia Saransk 0
  • DERROTA
  • Mordovia Saransk 0
  • FK Chita 1
  • DERROTA
  • Mordovia Saransk 0
  • FK Khimki 1
  • EMPATE
  • Dynamo Makhachkala 1
  • Mordovia Saransk 1
  • DERROTA
  • Elista Uralan 3
  • Mordovia Saransk 0
22 FC Soyuz Izhevsk Soyuz Izhevsk 22 42 5 7 30 40 91
  • DERROTA
  • SKA-Khabarovsk 2
  • FC Soyuz Izhevsk 1
  • EMPATE
  • FC Soyuz Izhevsk 1
  • FK Khimki 1
  • VICTORIA
  • FC Soyuz Izhevsk 1
  • FK Chita 0
  • DERROTA
  • Elista Uralan 1
  • FC Soyuz Izhevsk 0
  • DERROTA
  • Dynamo Makhachkala 4
  • FC Soyuz Izhevsk 1


  USO DE MEMORIA  
5,558,192 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.0745
Total Execution Time  0.0767
  CADENA URL  
/rusia_1_division2004/grupo1
  GET DATOS  
$_GET['/rusia_1_division2004/grupo1']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 06:21:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 06:21:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 06:21:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 06:21:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  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=12953 AND rel.round=42
0.0042  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` = 12953 AND c.`round` = 42 ORDER BY shedule ASC LIMIT 200
0.0025  SELECT ev.match_id,dp.alias,ev.minute,ev.action,ev.player_id,e.name,e.classf,dp.nick,rel.squadNumber,rel.player_id as playerId,rel.team_id,rel.teamId FROM events2004 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2004 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 12953 AND (ev.team1id=rel.team_id OR ev.team2id=rel.team_id) INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE ev.match_id IN (34498,34499,34500,34501,34502,34503,34504,34505,34506,34507,34508) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0022  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 = 42 AND e.real_date IS NOT NULL AND e.league_id = 12953 ORDER BY total DESC LIMIT 40
0.0045  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 = 12953 AND t.round = 41 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0055  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 = 12953 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  SELECT distinct(shedule), round FROM `calendars2004` as c WHERE c.`league_id` = 12953 AND shedule >= '2004/11/01' AND shedule < '2004/12/01' ORDER BY shedule ASC
0.0018  SELECT data1, data2 FROM services_tags WHERE categoryId=317
0.0023  SELECT group_code, extraName from `leagues` WHERE categoryId=317 AND year=2004