4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Sîngerei
TEMPORADA 2022/2023
TERCERA MOLDAVIA GRUPO 1
Equipo PJ GF GC Puntos
1 Iskra Rîbniţa Iskra 24 57 21 57
2 Inter Soroca Inter Soroca 24 54 37 43
3 Ocniţa Ocniţa 24 39 23 42
4 Pepeni Pepeni 24 41 27 42
5 Sîngerei Sîngerei 24 48 40 40
6 Vulturii Cutezători Vulturii 24 42 28 39
7 FC Edinet FC Edinet 24 34 28 39
8 Tarigrad Tarigrad 24 37 40 35
9 FC Olimpia FC Olimpia 24 56 51 32
10 EFA Visoca EFA Visoca 24 38 39 30
11 FC Visoca FC Visoca 24 23 44 23
12 Grănicerul Grănicerul 24 22 54 14
13 CF Riscani CF Riscani 24 27 86 4
14 Cruiz Cruiz 0 0 0 0
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 2019/2020
SEGUNDA MOLDAVIA
Equipo PJ GF GC Puntos
1 Dacia Buiucani Dacia 28 68 17 69
2 FC Florești Florești 28 71 29 69
3 FC Tighina FC Tighina 28 84 31 60
4 Spartanii Selemet Spartanii 28 70 29 60
5 Cahul Cahul 28 60 34 48
6 FC Victoria Bardar Victoria 28 58 54 43
7 Speranța Drochia Speranța 28 44 37 41
8 Grănicerul Grănicerul 28 47 66 34
9 Sireți Sireți 28 48 83 33
10 FC Bălți FC Bălți 29 66 61 32
11 Real Succes Real Succes 28 60 61 32
12 Iskra Rîbniţa Iskra 29 52 63 32
13 Ungheni Ungheni 28 55 83 30
14 Sîngerei Sîngerei 28 38 72 21
15 CS Sparta CS Sparta 28 6 107 2
TEMPORADA 2018/2019
SEGUNDA MOLDAVIA
Equipo PJ GF GC Puntos
1 Codru Lozova Codru Lozova 22 53 20 48
2 FC Florești Florești 22 40 27 40
3 Sîngerei Sîngerei 22 47 42 36
4 FC Victoria Bardar Victoria 22 51 43 35
5 Grănicerul Grănicerul 22 43 35 34
6 Saksan Saksan 22 41 31 30
7 Ungheni Ungheni 22 50 65 28
8 Cahul Cahul 22 38 31 27
9 Sireți Sireți 22 36 47 23
10 Real Succes Real Succes 22 49 75 22
11 CS Sparta CS Sparta 22 34 51 21
12 Iskra Rîbniţa Iskra 22 27 42 20
TEMPORADA 2017/2018
SEGUNDA MOLDAVIA
Equipo PJ GF GC Puntos
1 FC Victoria Bardar Victoria 12 34 15 29
2 FC Sheriff II Sheriff 12 40 12 25
3 Spartanii Selemet Spartanii 12 29 18 23
4 Cahul Cahul 12 33 26 21
5 Grănicerul Grănicerul 12 22 11 21
6 Sîngerei Sîngerei 12 19 20 19
7 Zimbru II Zimbru II 12 29 18 18
8 Iskra Rîbniţa Iskra 12 18 24 16
9 Moldova 03 Ungheni Moldova 12 20 24 11
10 Saxan Ceadir-Lunga II Saxan 12 13 24 11
11 Real Succes Real Succes 12 11 35 7
12 Codru Lozova Codru Lozova 12 15 32 7
13 FC Edinet FC Edinet 12 7 31 4
TEMPORADA 2016/2017
SEGUNDA MOLDAVIA
Equipo PJ GF GC Puntos
1 FC Sheriff II Sheriff 28 94 19 68
2 FC Sfintul Gheorghe Sfintul 28 79 23 66
3 Spicul Chișcăreni Spicul 28 62 22 66
4 FC Victoria Bardar Victoria 28 78 26 64
5 Zimbru II Zimbru II 28 57 38 44
6 Spartanii Selemet Spartanii 28 51 61 41
7 Sîngerei Sîngerei 28 48 53 40
8 FC Edinet FC Edinet 28 55 57 36
9 Iskra Rîbniţa Iskra 28 39 50 35
10 Dacia Buiucani Dacia 28 39 45 34
11 Real Succes Real Succes 28 37 54 29
12 Oguzsport Comrat Oguzsport 28 51 74 29
13 Codru Lozova Codru Lozova 28 48 81 27
14 Intersport Aroma Intersport 28 20 50 22
15 Constructorul Leova Constructoru 28 19 124 7
TEMPORADA 2015/2016
TERCERA MOLDAVIA GRUPO 2
Equipo PJ GF GC Puntos
1 Sîngerei Sîngerei 18 63 21 43
2 FC Florești Florești 18 49 17 42
3 Intersport Sănătăuca Intersport 18 30 16 35
4 Grănicerul Grănicerul 18 39 16 34
5 Drochia Drochia 18 36 22 30
6 Flacăra Făleşti Flacăra 18 33 32 26
7 Dava Soroca Dava Soroca 18 25 53 17
8 Cotiujănii Mari Cotiujănii 18 19 56 14
9 CF Riscani CF Riscani 18 22 49 12
10 Teleneşti Teleneşti 18 7 41 6
TEMPORADA 2014/2015
TERCERA MOLDAVIA GRUPO 1
Equipo PJ GF GC Puntos
1 Spicul Chișcăreni Spicul 21 95 18 61
2 Iskra Rîbniţa Iskra 22 70 24 47
3 Sîngerei Sîngerei 22 48 28 46
4 Intersport Sănătăuca Intersport 22 35 31 41
5 FC Florești Florești 22 41 39 31
6 Flacăra Făleşti Flacăra 22 43 45 30
7 Dava Soroca Dava Soroca 22 40 53 28
8 Cotiujănii Mari Cotiujănii 22 44 73 26
9 Drochia Drochia 21 32 40 24
10 Grănicerul Grănicerul 22 22 42 18
11 Teleneşti Teleneşti 22 19 53 12
12 CF Riscani CF Riscani 22 24 67 9
TEMPORADA 2013/2014
TERCERA MOLDAVIA GRUPO 2
Equipo PJ GF GC Puntos
1 Budăi Budăi 18 43 11 43
2 Sîngerei Sîngerei 18 28 11 37
3 FC Florești Florești 18 33 28 29
4 Dava Soroca Dava Soroca 18 24 34 25
5 Iskra Iskra 18 30 32 24
6 Ungheni Ungheni 18 39 32 23
7 Flacăra Făleşti Flacăra 18 21 30 21
8 Teleneşti Teleneşti 18 15 20 16
9 Drochia Drochia 18 16 38 16
10 Grănicerul Grănicerul 18 29 42 14
TEMPORADA 2012/2013
TERCERA MOLDAVIA GRUPO 2
Equipo PJ GF GC Puntos
1 CF Riscani CF Riscani 16 43 16 36
2 Ungheni Ungheni 16 40 21 31
3 FC Florești Florești 16 27 27 26
4 Teleneşti Teleneşti 16 25 15 25
5 Flacăra Făleşti Flacăra 16 20 25 25
6 Drochia Drochia 16 23 19 21
7 Sîngerei Sîngerei 16 22 28 15
8 Dava Soroca Dava Soroca 16 20 40 12
9 Grănicerul Grănicerul 16 19 48 5
TEMPORADA 2011/2012
TERCERA MOLDAVIA GRUPO 2
Equipo PJ GF GC Puntos
1 Veris Veris 20 84 2 60
2 FC Edinet FC Edinet 20 41 22 38
3 Drochia Drochia 20 34 29 31
4 CF Riscani CF Riscani 20 36 41 30
5 Grănicerul Grănicerul 20 51 49 29
6 Dava Soroca Dava Soroca 20 24 26 28
7 FC Florești Florești 20 32 40 23
8 Flacăra Făleşti Flacăra 20 24 45 23
9 Teleneşti Teleneşti 20 22 31 19
10 Sîngerei Sîngerei 20 26 45 19
11 Moldova 03 Ungheni Moldova 20 24 68 12

  USO DE MEMORIA  
6,007,576 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.8763
Total Execution Time  0.8776
  CADENA URL  
/historico/Singerei
  GET DATOS  
$_GET['/historico/Singerei']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (60)  
0.0141  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 = 'Singerei' 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.0193  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 = 'Singerei' 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.0127  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=61674 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=61674 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=61674 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=61674 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=61674 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=61674 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=61674 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=61674 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=61674 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=61674 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=61674 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=61674 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=61674 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=61674 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=61674 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=61674 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=61674 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=61674 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=61674 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=61674 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=61674 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=61674 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=61674 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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 = 68585
0.0134  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 = 68581
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61674 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1639 AND type_rel = 3
0.0132  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 = '61674' ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '61674' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '61674' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  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 = '61674' 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,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 = 68581 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  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 = 68585 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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=61674 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (68585,68581) 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.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 68585 AND teamId = 61674
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 68581 AND teamId = 61674
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 68585 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127  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 = '61674' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '61674' and rp.type = 4
0.0126  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 = '61674' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 events2023 e ON e.player_id = p.id AND e.league_id = 68585 WHERE rp.league_id = 68585 AND rp.teamId = 61674 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 events2023 e ON e.player_id = p.id AND e.league_id = 68585 WHERE rp.league_id = 68585 AND rp.teamId = 61674 AND (e.action = 4 or e.action = 5) 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 events2023 e ON e.player_id = p.id AND e.league_id = 68585 WHERE rp.league_id = 68585 AND rp.teamId = 61674 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 = 61674 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 68585 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.0128  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.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 `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.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 `tables2020` 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 = 49426 AND t.round = 30 ORDER BY team.conference ASC,t.position 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 `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 = 43306 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 38878 AND t.round = 13 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 `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 = 33978 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 `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 = 15831 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 `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 = 9505 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 24994 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 24997 AND t.round = 18 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 = 25000 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  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 = 68585 ORDER BY nameShow LIMIT 100