4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Unirea Dej

Unirea Dej

Entrenador: Dragos Militaru

Temporada 2023/2024
TEMPORADA 2023/2024
SEGUNDA RUMANÍA GRUPO 3
Equipo PJ GF GC Puntos
1 Unirea Dej Unirea Dej 4 5 1 10
2 Municipal Reşiţa Municipal 5 7 5 10
3 Metaloglobus Metaloglobus 5 5 4 7
4 FC Arges FC Arges 4 6 3 6
5 Alexandria Alexandria 4 3 7 4
6 FC Ceahlaul Piatra Neamt Ceahlaul 4 8 9 3
7 Dumbrăviţa Dumbrăviţa 4 2 7 3
8 Concordia Chiajna Concordia 4 7 3 12
9 CSA Steaua Bucuresti Steaua 4 8 1 10
10 Viitorul Pandurii Viitorul 5 5 7 6
11 Tunari Tunari 4 6 7 4
12 CSM Slatina CSM Slatina 4 5 6 4
13 Chindia Târgovişte Chindia 4 3 4 4
14 Progresul Spartac Progresul 3 2 8 0
TEMPORADA 2022/2023
SEGUNDA RUMANÍA GRUPO 1
Equipo PJ GF GC Puntos
1 CSA Steaua Bucuresti Steaua 19 37 18 40
2 Politehnica Iași Politehnica 19 30 14 40
3 Oțelul Galați Oțelul 19 21 12 36
4 Unirea Dej Unirea Dej 19 30 25 32
5 Unirea Slobozia Unirea 19 30 17 31
6 Dinamo Bucureşti Dinamo 19 27 18 31
7 FC Buzău FC Buzău 19 27 21 31
8 Concordia Chiajna Concordia 19 22 17 29
9 Brașov Steagul Renaște Brașov 19 26 20 28
10 CSM Slatina CSM Slatina 19 18 11 27
11 Csikszereda Csikszereda 19 25 18 26
12 Viitorul Pandurii Viitorul 19 22 28 25
13 CSC 1599 Selimbar 1599 19 19 22 24
14 Dumbrăviţa Dumbrăviţa 19 24 34 24
15 Metaloglobus Metaloglobus 19 18 22 21
16 Progresul Spartac Progresul 19 17 28 17
17 Ripensia Timisoara Ripensia 19 16 23 16
18 Minaur Baia Mare Minaur Baia 19 18 29 16
19 ASU Politehnica Timisoara Politehnica 19 13 29 13
20 Unirea Constanța Unirea 19 15 49 12
TEMPORADA 2021/2022
SEGUNDA RUMANÍA GRUPO 3
Equipo PJ GF GC Puntos
1 Csikszereda Csikszereda 6 22 6 48
2 CSC 1599 Selimbar 1599 6 17 4 37
3 Metaloglobus Metaloglobus 6 11 7 37
4 Politehnica Iași Politehnica 6 7 5 36
5 ASU Politehnica Timisoara Politehnica 6 10 11 28
6 Dunărea Călăraşi Dunărea 6 2 20 7
7 Dacia Unirea Brăila Dacia Unirea 6 4 20 5
8 FC Buzău FC Buzău 6 14 10 44
9 Unirea Dej Unirea Dej 6 13 4 43
10 Viitorul Pandurii Viitorul 6 15 8 34
11 Ripensia Timisoara Ripensia 6 7 11 31
12 Brașov Steagul Renaște Brașov 6 17 8 24
13 Unirea Constanța Unirea 6 9 14 18
14 FC Astra Giurgiu Astra 6 3 23 -1
TEMPORADA 2020/2021
TERCERA RUMANÍA GRUPO 9
Equipo PJ GF GC Puntos
1 Metalurgistul Cugir Metalurgistu 18 36 15 41
2 Unirea Dej Unirea Dej 18 42 22 41
3 Avântul Reghin Avântul 18 36 25 31
4 Arieşul Turda Arieşul 18 32 25 26
5 Unirea Ungheni Unirea 18 24 29 24
6 CS Hunedoara Hunedoara 18 19 21 23
7 FC Unirea Alba Iulia Unirea Alba 18 26 30 23
8 Sănătatea Cluj Sănătatea 18 29 36 21
9 Ocna Mureș Ocna Mureș 18 24 39 16
10 Industria Galda Industria 18 12 38 6
TEMPORADA 2019/2020
TERCERA RUMANÍA GRUPO 5
Equipo PJ GF GC Puntos
1 Dacia Maramureș Dacia 16 41 17 35
2 Minaur Baia Mare Minaur Baia 16 25 8 33
3 CSC 1599 Selimbar 1599 16 26 19 28
4 Metalurgistul Cugir Metalurgistu 16 22 17 27
5 Luceafărul Oradea Luceafărul 16 37 29 26
6 Sânmartin Sânmartin 16 31 30 25
7 Gloria Bistriţa Gloria 16 17 19 25
8 Avântul Reghin Avântul 16 27 21 22
9 Arieşul Turda Arieşul 16 19 22 22
10 Unirea Dej Unirea Dej 16 19 24 21
11 Sănătatea Cluj Sănătatea 16 22 21 20
12 FC Unirea Alba Iulia Unirea Alba 16 21 22 16
13 SCM Zalău SCM Zalău 16 21 32 15
14 CFR Cluj II CFR Cluj II 16 21 35 15
15 Industria Galda Industria 16 19 35 11
16 Odorheiu Odorheiu 16 11 28 10
TEMPORADA 2018/2019
TERCERA RUMANÍA GRUPO 5
Equipo PJ GF GC Puntos
1 Csikszereda Csikszereda 30 80 18 71
2 Dacia Maramureș Dacia 30 85 34 63
3 FC Baia Mare Baia Mare 30 46 22 57
4 Olimpic Cetate Olimpic 30 39 30 55
5 Sănătatea Cluj Sănătatea 30 52 32 53
6 Avântul Reghin Avântul 30 46 31 52
7 Arieşul Turda Arieşul 29 47 35 47
8 CFR Cluj II CFR Cluj II 29 62 43 46
9 Gloria Bistriţa Gloria 30 46 44 43
10 Odorheiu Odorheiu 30 41 40 38
11 Unirea Dej Unirea Dej 30 42 41 36
12 Hărman Hărman 30 42 43 35
13 Unirea Tășnad Unirea 30 47 67 30
14 MSE Târgu Mure Târgu Mure 30 26 86 22
15 Gaz Metan Medias II Metan Medias 30 26 81 12
16 Iernut Iernut 30 34 114 11
TEMPORADA 2017/2018
TERCERA RUMANÍA GRUPO 5
Equipo PJ GF GC Puntos
1 Universitatea Cluj Universitate 28 88 16 74
2 Dacia Maramureș Dacia 28 56 25 56
3 Performanța Ighiu Performanța 28 56 32 54
4 Metalurgistul Cugir Metalurgistu 28 47 30 51
5 Industria Galda Industria 28 47 37 50
6 FC Unirea Alba Iulia Unirea Alba 28 45 34 48
7 Sănătatea Cluj Sănătatea 28 49 25 45
8 CFR Cluj II CFR Cluj II 28 53 36 44
9 Unirea Tășnad Unirea 28 40 48 40
10 Avântul Reghin Avântul 28 36 43 35
11 Avrig Avrig 28 37 42 33
12 Gaz Metan Medias II Metan Medias 28 28 60 23
13 Iernut Iernut 28 39 73 19
14 Unirea Dej Unirea Dej 28 21 55 17
15 Viitorul Ghimbav Viitorul 28 15 101 3
TEMPORADA 2016/2017
TERCERA RUMANÍA GRUPO 5
Equipo PJ GF GC Puntos
1 Hermannstadt Hermannstadt 28 64 23 67
2 Metalurgistul Cugir Metalurgistu 28 62 27 55
3 Unirea Jucu Unirea Jucu 28 64 30 53
4 Sănătatea Cluj Sănătatea 28 42 21 53
5 Dacia Maramureș Dacia 28 53 32 50
6 Zalău Zalău 28 41 25 49
7 Avântul Reghin Avântul 28 46 29 46
8 Gaz Metan Medias II Metan Medias 28 60 49 46
9 Unirea Dej Unirea Dej 28 44 38 38
10 Viitorul Ulmeni Viitorul 28 39 47 33
11 Iernut Iernut 28 45 68 29
12 Târgu Mureş II Târgu 28 31 65 27
13 Oşorhei Oşorhei 28 33 56 22
14 Recolta Dorolt Recolta 28 29 71 17
15 FC Bistriţa Bistriţa 28 17 89 10
TEMPORADA 2015/2016
TERCERA RUMANÍA GRUPO 5
Equipo PJ GF GC Puntos
1 Luceafărul Oradea Luceafărul 26 63 15 65
2 Avântul Reghin Avântul 26 55 23 58
3 Industria Galda Industria 26 51 35 50
4 Unirea Jucu Unirea Jucu 26 46 24 49
5 Csikszereda Csikszereda 26 38 26 45
6 Sănătatea Cluj Sănătatea 26 51 46 41
7 Iernut Iernut 26 37 38 35
8 Dacia Maramureș Dacia 25 40 40 33
9 Oşorhei Oşorhei 26 34 39 31
10 Unirea Dej Unirea Dej 26 32 37 29
11 CSM Sighet CSM Sighet 25 27 49 26
12 Zalău Zalău 26 24 44 23
13 Odorheiu Odorheiu 25 27 56 22
14 Luceafărul Bălan Luceafărul 25 17 70 4
TEMPORADA 2014/2015
TERCERA RUMANÍA GRUPO 5
Equipo PJ GF GC Puntos
1 FC Baia Mare Baia Mare 26 53 13 57
2 Metalurgistul Cugir Metalurgistu 26 50 28 55
3 Zalău Zalău 26 52 32 49
4 CSM Sighet CSM Sighet 26 40 23 47
5 Arieşul 1907 Arieşul 26 37 33 41
6 Oşorhei Oşorhei 26 37 31 39
7 Sânmartin Sânmartin 26 35 36 36
8 Unirea Jucu Unirea Jucu 26 38 37 35
9 ACF Gloria Bistrita Gloria 26 37 35 33
10 Industria Galda Industria 26 42 46 33
11 Avântul Reghin Avântul 26 25 37 33
12 Iernut Iernut 26 42 67 26
13 Sănătatea Cluj Sănătatea 26 31 66 21
14 Unirea Dej Unirea Dej 26 19 54 11
TEMPORADA 2013/2014
TERCERA RUMANÍA GRUPO 5
Equipo PJ GF GC Puntos
1 Metalurgistul Cugir Metalurgistu 20 46 23 45
2 Naţional Sebiş Naţional 20 31 11 40
3 Şoimii Pâncota Şoimii 20 36 20 37
4 Oşorhei Oşorhei 20 24 23 31
5 FC Baia Mare Baia Mare 20 27 25 29
6 Ineu Ineu 20 27 18 28
7 Zalău Zalău 20 32 34 26
8 Sănătatea Cluj Sănătatea 20 22 32 25
9 Unirea Jucu Unirea Jucu 20 24 35 18
10 Arieşul 1907 Arieşul 20 18 35 15
11 Unirea Dej Unirea Dej 20 16 47 10
12 FC Maramureş Maramureş 0 0 0 0
TEMPORADA 2012/2013
TERCERA RUMANÍA GRUPO 5
Equipo PJ GF GC Puntos
1 FC Olimpia Satu Mare Olimpia Satu 24 44 15 58
2 CS Hunedoara Hunedoara 24 50 15 53
3 Oşorhei Oşorhei 24 45 23 52
4 Şoimii Pâncota Şoimii 24 44 24 45
5 Unirea Dej Unirea Dej 24 40 23 42
6 Zalău Zalău 24 57 37 33
7 Seso Câmpia Turzii Seso Câmpia 24 32 27 33
8 Naţional Sebiş Naţional 24 38 38 31
9 Sănătatea Cluj Sănătatea 24 37 37 31
10 Europa Alba Iulia Europa Alba 24 29 31 31
11 CSM Sighet CSM Sighet 24 18 69 12
12 Jiul Petrosani Jiul 23 13 48 11
13 Municipal Turda Municipal 23 8 68 6
TEMPORADA 2011/2012
TERCERA RUMANÍA GRUPO 6
Equipo PJ GF GC Puntos
1 Corona Braşov Corona 30 59 8 74
2 FC Olimpia Satu Mare Olimpia Satu 30 57 22 71
3 Unirea Tărlungeni Unirea 30 55 29 59
4 Zalău Zalău 30 44 39 52
5 Avântul Reghin Avântul 30 38 34 50
6 Seso Câmpia Turzii Seso Câmpia 30 43 33 49
7 Unirea Floreşti Unirea 30 47 40 48
8 Universitatea Cluj II Universitate 30 52 37 45
9 Unirea Ungheni Unirea 30 48 54 41
10 CFR Cluj II CFR Cluj II 30 48 43 39
11 Sănătatea Cluj Sănătatea 30 44 46 37
12 Unirea Dej Unirea Dej 30 34 52 33
13 Voinţa Livezile Voinţa 30 35 47 31
14 Zlatna Zlatna 30 25 61 23
15 Târgu Mureş II Târgu 30 24 69 16
16 Gloria Bistriţa II Gloria 30 32 71 15
TEMPORADA 2010/2011
TERCERA RUMANÍA GRUPO 6
Equipo PJ GF GC Puntos
1 FC Maramureş Maramureş 28 51 21 61
2 Arieşul 1907 Arieşul 28 44 15 57
3 Cisnădie Cisnădie 28 37 25 48
4 Corona Braşov Corona 28 33 28 46
5 Zalău Zalău 28 43 37 43
6 Unirea Tărlungeni Unirea 28 31 28 41
7 Unirea Ungheni Unirea 28 37 38 40
8 Sănătatea Cluj Sănătatea 28 25 40 37
9 Avântul Reghin Avântul 28 24 26 34
10 Municipal Turda Municipal 28 32 36 34
11 Gloria Progresul Gloria 28 42 48 32
12 Unirea Dej Unirea Dej 28 36 39 31
13 Gaz Metan Medias II Metan Medias 28 25 30 30
14 Zlatna Zlatna 28 37 58 27
15 Odorheiu Odorheiu 28 20 48 18
16 Voinţa Sibiu II Voinţa 0 0 0 0
TEMPORADA 2009/2010
TERCERA RUMANÍA GRUPO 6
Equipo PJ GF GC Puntos
1 Voinţa Sibiu Voinţa 34 66 21 78
2 Arieşul 1907 Arieşul 34 64 30 71
3 Cisnădie Cisnădie 34 55 38 55
4 Zalău Zalău 34 45 41 54
5 Luceafărul Oradea Luceafărul 34 64 40 53
6 Odorheiu Odorheiu 34 58 51 53
7 Bihorul Beiuş Bihorul 34 42 40 53
8 Gaz Metan Medias II Metan Medias 34 45 41 52
9 Unirea Dej Unirea Dej 34 49 42 51
10 Unirea Ungheni Unirea 34 51 43 49
11 Sănătatea Cluj Sănătatea 34 47 48 49
12 Sebes Sebes 34 44 44 48
13 Voinţa Livezile Voinţa 34 43 54 46
14 Gloria Progresul Gloria 34 49 51 38
15 Avântul Reghin Avântul 34 40 46 37
16 Zlatna Zlatna 34 48 63 36
17 CSM Sighet CSM Sighet 34 29 79 22
18 Turul Micula Turul Micula 34 24 91 15
TEMPORADA 2008/2009
TERCERA RUMANÍA GRUPO 6
Equipo PJ GF GC Puntos
1 FC Baia Mare Baia Mare 34 65 16 82
2 FC Silvania FC Silvania 33 83 45 61
3 CFR Cluj II CFR Cluj II 34 62 42 58
4 Caransebeş Caransebeş 34 46 33 56
5 Bihorul Beiuş Bihorul 34 55 37 55
6 Zalău Zalău 34 57 52 51
7 Unirea Ungheni Unirea 34 46 54 51
8 Avântul Reghin Avântul 34 51 44 48
9 Cisnădie Cisnădie 34 53 50 44
10 Sănătatea Cluj Sănătatea 34 48 59 44
11 Gaz Metan Targu Mures Metan Targu 34 51 58 43
12 Gloria Progresul Gloria 33 58 50 42
13 Seso Iara Seso Iara 34 47 47 42
14 Ena Inter Fagaras Inter 34 53 80 39
15 Unirea Dej Unirea Dej 33 39 55 37
16 Bihor Oradea II Bihor Oradea 34 37 57 35
17 Liberty Oradea II Liberty 33 32 54 31
18 CSM Sighet CSM Sighet 34 31 81 22
TEMPORADA 2007/2008
TERCERA RUMANÍA GRUPO 6
Equipo PJ GF GC Puntos
1 Avântul Reghin Avântul 34 69 27 79
2 Lotus Baile Felix Lotus Baile 34 68 34 79
3 FC Baia Mare Baia Mare 34 63 26 64
4 Someşul Satu Mare Someşul 34 57 35 58
5 Gloria Progresul Gloria 34 59 41 58
6 Tîrgu Mures Tîrgu Mures 34 52 30 53
7 Gaz Metan Targu Mures Metan Targu 34 55 51 49
8 Unirea Dej Unirea Dej 34 40 40 46
9 Lacul Ursu Mobila Sovata Lacul Ursu. 34 43 50 46
10 Turul Micula Turul Micula 33 52 59 44
11 Unirea Ungheni Unirea 34 42 54 43
12 Sănătatea Cluj Sănătatea 33 44 54 40
13 Bihorul Beiuş Bihorul 33 34 44 40
14 FC Olimpia Satu Mare Olimpia Satu 33 41 52 40
15 CSM Sighet CSM Sighet 34 42 58 38
16 Inter Blaj Inter Blaj 34 40 60 36
17 Bihor Oradea II Bihor Oradea 34 36 64 31
18 Universitatea Cluj II Universitate 34 19 77 14

  USO DE MEMORIA  
7,264,464 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1913
Total Execution Time  0.1925
  CADENA URL  
/historico/Unirea-Dej
  GET DATOS  
$_GET['/historico/Unirea-Dej']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (53)  
0.0032  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 = 'Unirea-Dej' 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=9034 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=9034 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=9034 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=9034 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=9034 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=9034 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0042  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 = 75661
0.0025  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 = 72232
0.0025  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 = 73515
0.0025  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 = 73672
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9034 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=242 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 242 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0024  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1145696,1008496,993818,969163,898033) ORDER BY n.cover_points DESC, update_date DESC
0.0027  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 = '9034' ORDER BY l.year DESC,cat.coefficient DESC
0.0026  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 = '9034' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0026  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 = '9034' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = 73672 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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 = 72232 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0029  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=9034 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (75661,73672,71432) 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.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 75661 AND teamId = 9034
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 73672 AND teamId = 9034
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 9034
0.0027  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 = 75661 AND t.round = 5 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0026  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 = '9034' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '9034' and rp.type = 4
0.0026  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 = '9034' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0048  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 = 75661 WHERE rp.league_id = 75661 AND rp.teamId = 9034 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.0045  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 = 75661 WHERE rp.league_id = 75661 AND rp.teamId = 9034 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 75661 WHERE rp.league_id = 75661 AND rp.teamId = 9034 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0037  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 = 9034 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0032  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 = 72232 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.0029  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 = 75661 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 71248 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 68106 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.0034  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 = 63225 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.0040  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 = 66963 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037  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 = 58688 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 51102 AND t.round = 16 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 = 44933 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 38958 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 37193 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 = 15889 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 8427 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 3532 AND t.round = 22 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 = 2198 AND t.round = 26 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 = 1860 AND t.round = 30 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 `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 = 25942 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 `tables2010` 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 = 25904 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 `tables2009` 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 = 25152 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 `tables2008` 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 = 25146 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC