4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Codru Călărași II
TEMPORADA 2023/2024
TERCERA MOLDAVIA GRUPO 2
Equipo PJ GF GC Puntos
1 Stăuceni Stăuceni 14 52 11 40
2 Chisinau Chisinau 14 30 13 28
3 Codru Călărași II Codru 14 35 25 25
4 La Familia La Familia 14 27 26 23
5 Socol Copceac Socol 14 27 25 21
6 CS Atletic CS Atletic 14 21 30 19
7 Constructorul Leova Constructoru 14 16 14 18
8 CSF Cricova CSF Cricova 14 32 28 17
9 FC Slobozia Mare Slobozia 14 21 29 16
10 Ghidighici Ghidighici 14 29 39 12
11 Congaz Congaz 14 15 39 9
12 Maiak Chirsova Maiak 14 20 46 5
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 1
Equipo PJ GF GC Puntos
1 Flacăra Făleşti Flacăra 24 82 29 58
2 Sîngerei Sîngerei 24 65 31 53
3 FC Edinet FC Edinet 24 46 22 52
4 Cruiz Cruiz 24 55 30 49
5 Inter Soroca Inter Soroca 24 52 45 40
6 EFA Visoca EFA Visoca 24 38 36 33
7 FC Olimpia FC Olimpia 24 46 52 30
8 Codru Călărași II Codru 24 53 54 28
9 Pepeni Pepeni 24 27 44 28
10 FC Visoca FC Visoca 24 33 49 18
11 Grănicerul Grănicerul 24 23 53 18
12 CF Riscani CF Riscani 24 33 67 16
13 Ocniţa Ocniţa 24 29 70 16
14 Teleneşti Teleneşti 0 0 0 0
TEMPORADA 2020/2021
TERCERA MOLDAVIA GRUPO 1
Equipo PJ GF GC Puntos
1 FCM Ungheni FCM Ungheni 22 93 13 54
2 Codru Călărași II Codru 22 49 19 49
3 Cruiz Cruiz 22 53 28 45
4 Sîngerei Sîngerei 22 64 34 43
5 FC Edinet FC Edinet 22 55 25 40
6 FC Olimpia FC Olimpia 22 38 44 32
7 Inter Soroca Inter Soroca 22 59 53 30
8 Pepeni Pepeni 22 39 57 27
9 Bogzesti Bogzesti 22 23 50 19
10 FC Visoca FC Visoca 22 33 62 16
11 CF Riscani CF Riscani 22 24 72 12
12 FC Mănoilești Mănoilești 22 23 96 7
TEMPORADA 2018/2019
TRANSICIÓN TERCERA MOLDAVIA GRUPO 1
Equipo PJ GF GC Puntos
1 Sucleia Sucleia 18 55 12 50
2 FCM Ungheni FCM Ungheni 18 78 18 44
3 Bogzesti Bogzesti 18 40 27 34
4 Fulger Fulger 18 49 31 28
5 CSF Cricova CSF Cricova 18 31 32 26
6 Fortuna Pleseni Fortuna 18 42 40 23
7 ARF Ialoveni Ialoveni 18 29 40 21
8 Sinteza Căuşeni Sinteza 18 33 50 16
9 Codru Călărași II Codru 18 31 81 12
10 Tighina II Tighina II 18 15 72 5
TEMPORADA 2017/2018
TRANSICIÓN TERCERA MOLDAVIA GRUPO 1
Equipo PJ GF GC Puntos
1 FC Tighina FC Tighina 18 80 11 45
2 Dacia Buiucani Dacia 18 59 15 36
3 FCM Ungheni FCM Ungheni 18 78 28 35
4 Sucleia Sucleia 18 55 23 35
5 Bogzesti Bogzesti 18 43 25 32
6 Sinteza Căuşeni Sinteza 18 29 45 22
7 Codru Călărași II Codru 18 41 58 18
8 CSF Cricova CSF Cricova 18 24 65 14
9 Fulger Fulger 18 24 69 13
10 ISM-2017 ISM-2017 18 29 123 5
TEMPORADA 2016/2017
TRANSICIÓN TERCERA MOLDAVIA GRUPO 1
Equipo PJ GF GC Puntos
1 Sireți Sireți 18 63 13 47
2 FC Tighina FC Tighina 18 59 13 47
3 Steaua 57 Steaua 57 18 60 21 38
4 Bogzesti Bogzesti 18 49 27 34
5 Fulger Fulger 18 37 22 32
6 Codru Călărași II Codru 18 28 37 21
7 CSF Cricova CSF Cricova 18 38 58 18
8 Sinteza Căuşeni Sinteza 18 18 62 13
9 Boldureşti Boldureşti 18 14 64 7
10 Anina-ŞS Anina-ŞS 18 16 65 6
TEMPORADA 2015/2016
TERCERA MOLDAVIA GRUPO 1
Equipo PJ GF GC Puntos
1 Bogzesti Bogzesti 14 34 12 33
2 Anina-ŞS Anina-ŞS 14 30 19 29
3 CFR Ialoveni Ialoveni 14 29 18 25
4 Sinteza Căuşeni Sinteza 14 24 20 21
5 Cruiz Cruiz 14 14 16 14
6 Codru Călărași II Codru 14 20 31 12
7 Politehnica Chişinău Politehnica 14 16 34 12
8 CSF Cricova CSF Cricova 14 16 33 10
TEMPORADA 2014/2015
TERCERA MOLDAVIA GRUPO 2
Equipo PJ GF GC Puntos
1 Ungheni Ungheni 18 58 21 44
2 Codru Lozova Codru Lozova 18 48 26 33
3 Codru Călărași II Codru 18 49 28 32
4 ŞSSRF ŞSSRF 18 39 32 32
5 Sinteza Căuşeni Sinteza 18 28 23 24
6 Anina-ŞS Anina-ŞS 18 30 30 24
7 CFR Ialoveni Ialoveni 18 35 37 23
8 CSF Cricova CSF Cricova 18 27 35 21
9 Olan Olănești Olan 18 18 46 14
10 Politehnica Chişinău Politehnica 18 16 70 8
TEMPORADA 2013/2014
TERCERA MOLDAVIA GRUPO 1
Equipo PJ GF GC Puntos
1 Nisporeni Nisporeni 16 43 16 36
2 CFR Ialoveni Ialoveni 16 37 18 36
3 Codru Călărași II Codru 16 30 16 30
4 Real-Succes II Real-Succes 16 42 28 29
5 Sinteza Căuşeni Sinteza 16 40 30 25
6 CSF Cricova CSF Cricova 16 27 27 24
7 Codru Lozova Codru Lozova 16 33 43 15
8 Olan Olănești Olan 16 11 46 6
9 Universitatea Agrară Universitate 16 18 57 5
10 FC Tighina FC Tighina 0 0 0 0
TEMPORADA 2012/2013
TERCERA MOLDAVIA GRUPO 1
Equipo PJ GF GC Puntos
1 CFR Ialoveni Ialoveni 18 39 16 43
2 Real-Succes II Real-Succes 18 40 20 38
3 Academia Chişinău II Academia 18 43 19 34
4 SS-2 Narubai SS-2 Narubai 18 30 20 26
5 Codru Lozova Codru Lozova 18 27 30 26
6 Codru Călărași II Codru 18 26 21 24
7 Sinteza Căuşeni Sinteza 18 35 38 24
8 CSF Cricova CSF Cricova 18 24 28 20
9 Universitatea Agrară Universitate 18 24 44 15
10 Olan Olănești Olan 18 12 64 4
TEMPORADA 2011/2012
TERCERA MOLDAVIA GRUPO 1
Equipo PJ GF GC Puntos
1 FC Victoria Bardar Victoria 18 57 9 47
2 CFR Ialoveni Ialoveni 18 60 16 41
3 CSF Cricova CSF Cricova 18 37 25 29
4 Universitatea Agrară Universitate 18 38 39 29
5 Sinteza Căuşeni Sinteza 18 42 26 27
6 Politehnica Chişinău Politehnica 18 52 34 26
7 Codru Călărași II Codru 18 27 39 23
8 Codru Lozova Codru Lozova 18 27 40 19
9 Olan Olănești Olan 18 19 67 11
10 Haiduc Haiduc 18 21 85 2
11 Nisporeni Nisporeni 0 0 0 0

  USO DE MEMORIA  
5,789,368 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.1107
Total Execution Time  0.1122
  CADENA URL  
/historico/Codru-Calarasi-Ii
  GET DATOS  
$_GET['/historico/Codru-Calarasi-Ii']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0034  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 = 'Codru-Calarasi-Ii' 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.0018  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=61697 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=61697 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=61697 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 73519
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61697 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1639 AND type_rel = 3
0.0023  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 = '61697' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '61697' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 73519 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=61697 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 73519 AND teamId = 61697
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 73520 AND teamId = 61697
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 20 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '61697' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '61697' and rp.type = 4
0.0020  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 = '61697' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  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 = 61697 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.0019  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 = 61697 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  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 = 61697 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 61697 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0021  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 = 20 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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.0022  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 = 64140 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 58559 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.0022  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 = 49571 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 43546 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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.0021  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 = 39919 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 15830 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 9506 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 24993 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 24996 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 24999 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 73519 ORDER BY nameShow LIMIT 100