4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Maiak Chirsova
TEMPORADA 2023/2024
TERCERA MOLDAVIA GRUPO 2
Equipo PJ GF GC Puntos
1 Stăuceni Stăuceni 18 62 15 47
2 Chisinau Chisinau 19 53 19 40
3 Constructorul Leova Constructoru 19 30 18 31
4 Socol Copceac Socol 19 35 29 31
5 La Familia La Familia 19 37 33 31
6 Codru Călărași II Codru 19 42 33 29
7 CS Atletic CS Atletic 19 27 39 25
8 CSF Cricova CSF Cricova 19 36 36 24
9 FC Slobozia Mare Slobozia 19 27 38 22
10 Congaz Congaz 18 21 54 13
11 Ghidighici Ghidighici 19 29 54 12
12 Maiak Chirsova Maiak 19 25 56 10
TEMPORADA 2022/2023
TERCERA MOLDAVIA GRUPO 2
Equipo PJ GF GC Puntos
1 Zimbru II Zimbru II 21 87 20 50
2 Oguzsport Comrat Oguzsport 21 75 16 50
3 Stăuceni Stăuceni 21 68 25 46
4 La Familia La Familia 21 50 30 39
5 Cimişlia Cimişlia 21 25 29 27
6 CSF Cricova CSF Cricova 21 30 34 26
7 Congaz Congaz 21 27 51 24
8 FC Slobozia Mare Slobozia 21 24 70 23
9 Codru Călărași II Codru 21 30 42 22
10 CS Atletic CS Atletic 21 30 40 20
11 Socol Copceac Socol 21 22 60 12
12 Maiak Chirsova Maiak 21 19 70 11
TEMPORADA 2021/2022
TERCERA MOLDAVIA GRUPO 2
Equipo PJ GF GC Puntos
1 Văsieni Văsieni 22 73 20 53
2 Stăuceni Stăuceni 22 61 19 52
3 CSF Cricova CSF Cricova 22 46 25 41
4 FC Slobozia Mare Slobozia 22 54 37 37
5 CS Atletic CS Atletic 22 54 33 35
6 Cimişlia Cimişlia 22 53 37 34
7 Oguzsport Comrat Oguzsport 22 49 43 34
8 Saksan Saksan 22 50 45 33
9 Congaz Congaz 22 37 45 28
10 Maiak Chirsova Maiak 22 40 67 16
11 Socol Copceac Socol 22 23 56 15
12 Dinamo Plus Dinamo Plus 22 12 125 0
TEMPORADA 2020/2021
TERCERA MOLDAVIA GRUPO 2
Equipo PJ GF GC Puntos
1 Speranis Nisporeni Speranis 22 92 7 59
2 Saksan Saksan 22 93 26 57
3 CSF Cricova CSF Cricova 23 43 33 42
4 FC Slobozia Mare Slobozia 22 53 54 40
5 ARF Ialoveni Ialoveni 23 51 38 39
6 Socol Copceac Socol 22 35 42 32
7 Maiak Chirsova Maiak 22 42 40 27
8 Văsieni Văsieni 22 28 39 26
9 Cimişlia Cimişlia 22 27 40 23
10 Congaz Congaz 22 33 50 22
11 Sinteza Căuşeni Sinteza 22 25 64 10
12 Academia Viitorul Academia 22 12 101 4
TEMPORADA 2018/2019
TRANSICIÓN TERCERA MOLDAVIA GRUPO 3
Equipo PJ GF GC Puntos
1 Olimp Comrat Olimp Comrat 14 33 8 33
2 Speranis Nisporeni Speranis 13 37 10 27
3 Maiak Chirsova Maiak 14 28 13 27
4 Congaz Congaz 13 17 12 23
5 Saksan Saksan 14 27 25 17
6 FC Slobozia Mare Slobozia 14 16 37 15
7 Văsieni Văsieni 14 18 33 14
8 Flacăra Mingir Flacăra 14 10 48 1
TEMPORADA 2017/2018
TRANSICIÓN TERCERA MOLDAVIA GRUPO 3
Equipo PJ GF GC Puntos
1 CSF Spartani Spartani 12 36 16 30
2 Fortuna Pleseni Fortuna 12 31 13 27
3 Olimp Comrat Olimp Comrat 12 28 23 22
4 Congaz Congaz 12 15 17 16
5 Maiak Chirsova Maiak 12 14 19 16
6 Flacăra Mingir Flacăra 12 11 21 8
7 FC Slobozia Mare Slobozia 12 6 32 3
8 Trachia Taraclia Trachia 0 0 0 0
TEMPORADA 2016/2017
TRANSICIÓN TERCERA MOLDAVIA GRUPO 3
Equipo PJ GF GC Puntos
1 CS Sparta CS Sparta 16 47 9 42
2 Fortuna Pleseni Fortuna 16 39 22 32
3 Fîrlădeni Fîrlădeni 16 39 13 28
4 Olimp Comrat Olimp Comrat 16 37 34 26
5 Maiak Chirsova Maiak 16 22 25 22
6 Congaz Congaz 16 27 27 21
7 FC Slobozia Mare Slobozia 16 26 34 17
8 Constructorul Leova Constructoru 16 22 59 11
9 Socol Copceac Socol 16 19 55 6
10 Saksan Saksan 0 0 0 0
TEMPORADA 2015/2016
TERCERA MOLDAVIA GRUPO 3
Equipo PJ GF GC Puntos
1 Spartanii Selemet Spartanii 14 39 15 32
2 Cahul Cahul 14 39 13 30
3 Sireți Sireți 14 27 22 25
4 Congaz Congaz 14 22 37 19
5 FC Slobozia Mare Slobozia 14 29 31 18
6 Boldureşti Boldureşti 14 20 31 14
7 Trachia Taraclia Trachia 14 19 35 13
8 Maiak Chirsova Maiak 14 23 34 10
TEMPORADA 2014/2015
TERCERA MOLDAVIA GRUPO 3
Equipo PJ GF GC Puntos
1 Cahul Cahul 18 52 12 45
2 Constructorul Leova Constructoru 18 42 23 37
3 Universitatea Agrară Universitate 18 40 22 35
4 Congaz Congaz 18 34 35 34
5 Maiak Chirsova Maiak 18 44 30 28
6 Boldureşti Boldureşti 18 29 32 26
7 Spartanii Selemet Spartanii 18 34 28 23
8 SŞ Ialoveni Ialoveni 18 15 56 13
9 FC Slobozia Mare Slobozia 18 20 36 10
10 Trachia Taraclia Trachia 18 17 53 9
TEMPORADA 2013/2014
TERCERA MOLDAVIA GRUPO 3
Equipo PJ GF GC Puntos
1 Petrocub Hîncești Petrocub 16 45 12 39
2 Comrat Chirsova Comrat 16 46 16 38
3 Cahul Cahul 16 38 18 32
4 Dinamo-Auto II Dinamo-Auto 16 26 22 27
5 Constructorul Leova Constructoru 16 26 23 24
6 Anina-ŞS Anina-ŞS 16 25 34 16
7 Spartanii Selemet Spartanii 15 15 36 12
8 Maiak Chirsova Maiak 15 31 40 9
9 Congaz Congaz 16 17 68 8
TEMPORADA 2012/2013
SEGUNDA MOLDAVIA
Equipo PJ GF GC Puntos
1 Veris Veris 28 103 5 74
2 FC Sheriff II Sheriff 28 79 21 64
3 Dinamo-Auto Cioburciu Dinamo-Auto 28 51 23 56
4 Saksan Saksan 28 55 27 53
5 Dacia Buiucani Dacia 28 54 27 50
6 Intersport Aroma Intersport 28 41 31 45
7 Zimbru II Zimbru II 28 48 26 42
8 FC Sfintul Gheorghe Sfintul 28 38 51 40
9 Locomotiv Balti Locomotiv 28 54 57 37
10 FC Victoria Bardar Victoria 28 33 46 35
11 Oguzsport Comrat Oguzsport 28 37 59 33
12 FC Edinet FC Edinet 28 30 65 22
13 FC Tighina FC Tighina 28 35 90 20
14 Real Succes Real Succes 28 26 67 16
15 Maiak Chirsova Maiak 28 34 123 11
16 Olimpia 2 Tiligul Olimpia 0 0 0 0
TEMPORADA 2011/2012
TERCERA MOLDAVIA GRUPO 3
Equipo PJ GF GC Puntos
1 Maiak Chirsova Maiak 18 44 23 42
2 Comrat Chirsova Comrat 18 42 16 35
3 FC Slobozia Mare Slobozia 18 42 21 34
4 Spicul Copceac Spicul 18 31 21 34
5 Constructorul Leova Constructoru 18 28 28 23
6 Trachia Taraclia Trachia 18 17 26 21
7 Cimişlia Cimişlia 18 30 32 20
8 Speranţa Crihana V. II Speranţa 18 22 35 20
9 Congaz Congaz 18 21 52 13
10 Spartanii Selemet Spartanii 18 20 43 10
TEMPORADA 2010/2011
TERCERA MOLDAVIA GRUPO 3
Equipo PJ GF GC Puntos
1 Saksan Saksan 18 42 19 40
2 Maiak Chirsova Maiak 18 38 27 35
3 Trachia Taraclia Trachia 18 26 12 33
4 Comrat Chirsova Comrat 18 18 14 33
5 FC Slobozia Mare Slobozia 18 53 27 28
6 Constructorul Leova Constructoru 18 29 16 26
7 Congaz Congaz 18 17 32 20
8 Spicul Copceac Spicul 18 22 34 16
9 Alifomix Alifomix 18 22 37 15
10 Vulcăneşti Vulcăneşti 18 16 65 6

  USO DE MEMORIA  
5,886,680 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.5663
Total Execution Time  0.5683
  CADENA URL  
/historico/Maiak-Chirsova
  GET DATOS  
$_GET['/historico/Maiak-Chirsova']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0135  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Maiak-Chirsova' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=61706 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=61706 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=61706 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0124  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61706 AND type_rel = 2
0.0124  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1639 AND type_rel = 3
0.0141  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '61706' ORDER BY l.year DESC,cat.coefficient DESC
0.0129  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '61706' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0130  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '61706' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=61706 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0127  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (73520,73519) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 73519 AND teamId = 61706
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 73520 AND teamId = 61706
0.0129  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '61706' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '61706' and rp.type = 4
0.0127  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '61706' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0127  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73519 WHERE rp.league_id = 73519 AND rp.teamId = 61706 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73519 WHERE rp.league_id = 73519 AND rp.teamId = 61706 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0127  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73519 WHERE rp.league_id = 73519 AND rp.teamId = 61706 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0157  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 61706 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0131  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 `tables2024` 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 = 73519 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 `tables2023` 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 = 68586 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 `tables2022` 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 = 64141 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 `tables2021` 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 = 58560 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 `tables2019` 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 = 49573 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables2018` 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 = 43548 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 `tables2017` 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 = 34771 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables2017` 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 = 39921 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 `tables2016` 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 = 15832 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  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 `tables2015` 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 = 9507 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 `tables2014` 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 = 24995 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 `tables2013` 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 = 15224 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables2012` 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 = 25001 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138  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 `tables2011` 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 = 25004 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC