4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Zakho
TEMPORADA 2023/2024
IRAQ STARS LEAGUE
Equipo PJ GF GC Puntos
1 Al Shorta Al Shorta 24 49 20 55
2 Al Quwa Al Jawiya Quwa Jawiya 23 45 19 52
3 Al Zawraa Al Zawraa 24 29 13 43
4 Zakho Zakho 23 19 9 40
5 Duhok Duhok 24 23 19 38
6 Al Naft Al Naft 24 30 26 37
7 Al Najaf Al Najaf 24 23 17 37
8 Newroz SC Newroz SC 23 37 24 36
9 Al Hudod Al Hudod 24 26 32 33
10 Naft Maysan Naft Maysan 24 26 21 32
11 Al Talaba Al Talaba 21 24 22 31
12 Al Kahrabaa Al Kahrabaa 23 30 29 27
13 Al Minaa Al Minaa 24 21 40 27
14 Al Karkh Al Karkh 24 21 28 24
15 Karbala Karbala 23 25 39 23
16 Erbil Erbil 22 26 29 23
17 Naft Al-Basra Naft 24 20 32 21
18 Al-Qasim Al-Qasim 24 24 35 20
19 Baghdad FC Baghdad FC 24 17 34 16
20 Naft Al-Wasat Naft 24 8 35 11
TEMPORADA 2022/2023
IRAQ STARS LEAGUE
Equipo PJ GF GC Puntos
1 Al Shorta Al Shorta 37 61 23 79
2 Al Quwa Al Jawiya Quwa Jawiya 38 62 26 78
3 Al Zawraa Al Zawraa 38 50 32 68
4 Al Talaba Al Talaba 38 52 39 66
5 Al Kahrabaa Al Kahrabaa 38 51 38 62
6 Erbil Erbil 38 44 39 58
7 Al Najaf Al Najaf 38 46 41 56
8 Karbala Karbala 38 39 34 56
9 Al Karkh Al Karkh 38 40 36 51
10 Newroz SC Newroz SC 38 45 43 51
11 Naft Maysan Naft Maysan 38 42 54 51
12 Duhok Duhok 38 34 39 50
13 Al Hudod Al Hudod 37 39 35 49
14 Naft Al-Basra Naft 38 34 40 43
15 Zakho Zakho 38 39 42 42
16 Al-Qasim Al-Qasim 38 31 40 40
17 Al Naft Al Naft 38 39 50 40
18 Naft Al-Wasat Naft 38 26 34 36
19 Al Sinaah Al Sinaah 38 26 54 28
20 Al Diwaniya Al Diwaniya 38 25 86 12
TEMPORADA 2021/2022
IRAQ STARS LEAGUE
Equipo PJ GF GC Puntos
1 Al Shorta Al Shorta 55 94 29 127
2 Naft Al-Wasat Naft 55 75 50 97
3 Al Talaba Al Talaba 52 76 44 96
4 Al Quwa Al Jawiya Quwa Jawiya 47 63 37 89
5 Al Naft Al Naft 53 49 31 82
6 Al Zawraa Al Zawraa 48 54 34 80
7 Al Najaf Al Najaf 51 53 48 76
8 Al Kahrabaa Al Kahrabaa 52 49 53 66
9 Naft Maysan Naft Maysan 55 44 52 66
10 Zakho Zakho 48 46 39 65
11 Newroz SC Newroz SC 53 53 64 65
12 Al Sinaah Al Sinaah 57 44 53 64
13 Erbil Erbil 54 51 62 64
14 Al-Qasim Al-Qasim 57 51 71 64
15 Naft Al-Basra Naft 50 51 52 63
16 Al Karkh Al Karkh 57 41 50 58
17 Baghdad FC Baghdad FC 53 43 57 52
18 Al Diwaniya Al Diwaniya 52 45 72 51
19 Al Minaa Al Minaa 46 40 60 35
20 Samarra Samarra 51 26 90 16
TEMPORADA 2020/2021
IRAQ STARS LEAGUE
Equipo PJ GF GC Puntos
1 Al Quwa Al Jawiya Quwa Jawiya 38 68 29 83
2 Al Zawraa Al Zawraa 38 46 19 75
3 Al Najaf Al Najaf 38 46 26 74
4 Al Shorta Al Shorta 38 60 27 72
5 Naft Al-Wasat Naft 38 46 31 63
6 Al Naft Al Naft 38 36 34 53
7 Baghdad FC Baghdad FC 38 30 32 50
8 Al Minaa Al Minaa 38 45 44 49
9 Zakho Zakho 38 35 40 46
10 Al Karkh Al Karkh 38 35 40 45
11 Naft Al-Janoob Naft 38 35 45 44
12 Naft Misan Naft Misan 38 38 48 43
13 Erbil Erbil 37 38 41 41
14 Al Kahrabaa Al Kahrabaa 38 36 39 41
15 Al-Qasim Al-Qasim 38 39 50 41
16 Al Diwaniya Al Diwaniya 38 22 36 41
17 Al Talaba Al Talaba 38 36 47 39
18 Alsinat Alkahrabaiya Alsinat 38 27 39 37
19 Al Hudod Al Hudod 37 32 47 31
20 Al Simawa Al Simawa 38 22 58 26
TEMPORADA 2019/2020
IRAQ STARS LEAGUE
Equipo PJ GF GC Puntos
1 Al Naft Al Naft 5 6 1 11
2 Al Quwa Al Jawiya Quwa Jawiya 4 7 2 10
3 Naft Al-Wasat Naft 5 3 2 9
4 Al Najaf Al Najaf 4 5 1 8
5 Al Simawa Al Simawa 3 2 0 7
6 Al Talaba Al Talaba 5 7 6 7
7 Al Diwaniya Al Diwaniya 4 3 3 7
8 Al Hudod Al Hudod 4 4 3 6
9 Erbil Erbil 5 5 6 6
10 Alsinat Alkahrabaiya Alsinat 5 6 11 6
11 Al Shorta Al Shorta 3 7 5 5
12 Naft Al-Janoob Naft 5 1 4 4
13 Baghdad FC Baghdad FC 5 2 5 3
14 Al Kahrabaa Al Kahrabaa 5 3 7 2
15 Naft Misan Naft Misan 4 2 7 0
TEMPORADA 2017/2018
IRAQ STARS LEAGUE
Equipo PJ GF GC Puntos
1 Al Zawraa Al Zawraa 38 66 26 88
2 Al Quwa Al Jawiya Quwa Jawiya 38 66 23 84
3 Al Naft Al Naft 38 59 20 84
4 Al Shorta Al Shorta 38 69 24 83
5 Al Kahrabaa Al Kahrabaa 38 39 30 58
6 Al Najaf Al Najaf 38 50 40 55
7 Baghdad FC Baghdad FC 38 31 34 53
8 Naft Maysan Naft Maysan 38 45 36 49
9 Naft Al-Wasat Naft 38 42 38 49
10 Naft Al-Janoob Naft 38 34 41 49
11 Alsinat Alkahrabaiya Alsinat 38 46 46 47
12 Al Simawa Al Simawa 38 42 50 44
13 Al Hudod Al Hudod 38 40 45 43
14 Al Talaba Al Talaba 38 43 59 43
15 Al Minaa Al Minaa 38 34 47 41
16 Al Bahri Al Bahri 38 41 55 38
17 Al Diwaniya Al Diwaniya 38 32 58 31
18 Al Hussein Al Hussein 38 26 58 27
19 Karbala Karbala 38 26 76 27
20 Zakho Zakho 38 27 52 25
TEMPORADA 2016/2017
IRAQ STARS LEAGUE
Equipo PJ GF GC Puntos
1 Al Quwa Al Jawiya Quwa Jawiya 36 59 23 81
2 Al Naft Al Naft 36 61 17 77
3 Al Shorta Al Shorta 36 55 26 75
4 Al Zawraa Al Zawraa 36 67 28 72
5 Naft Al-Wasat Naft 36 45 26 68
6 Al Minaa Al Minaa 36 40 24 66
7 Al Talaba Al Talaba 36 51 38 54
8 Baghdad FC Baghdad FC 36 26 21 51
9 Al Najaf Al Najaf 36 41 38 49
10 Naft Al-Janoob Naft 36 36 42 39
11 Naft Maysan Naft Maysan 36 28 36 39
12 Al Hudod Al Hudod 36 35 46 38
13 Al Kahrabaa Al Kahrabaa 36 24 36 38
14 Al Bahri Al Bahri 36 42 63 35
15 Karbala Karbala 36 24 46 33
16 Zakho Zakho 36 18 51 24
17 Al Hussein Al Hussein 36 23 52 23
18 Al Simawa Al Simawa 36 26 47 22
19 Al Karkh Al Karkh 36 24 65 20
20 Erbil Erbil 0 0 0 0
TEMPORADA 2015/2016
IRAQ STARS LEAGUE
Equipo PJ GF GC Puntos
1 Al Zawraa Al Zawraa 17 24 10 39
2 Naft Al-Wasat Naft 17 24 14 35
3 Al Naft Al Naft 17 21 10 32
4 Al Talaba Al Talaba 17 20 14 27
5 Naft Maysan Naft Maysan 17 16 16 24
6 Al Kahrabaa Al Kahrabaa 17 9 17 16
7 Naft Al-Janoob Naft 17 15 20 15
8 Al Karkh Al Karkh 17 11 20 12
9 Al Simawa Al Simawa 17 14 26 10
10 Duhok Duhok 9 8 15 7
11 Al Quwa Al Jawiya Quwa Jawiya 17 22 11 33
12 Al Minaa Al Minaa 18 27 17 32
13 Baghdad FC Baghdad FC 18 22 17 30
14 Al Shorta Al Shorta 18 20 19 29
15 Zakho Zakho 18 17 10 28
16 Erbil Erbil 17 19 17 23
17 Al Najaf Al Najaf 18 13 22 23
18 Karbala Karbala 18 17 16 22
19 Al Hudod Al Hudod 18 11 23 12
20 Al Sinaah Al Sinaah 18 8 24 10
TEMPORADA 2014/2015
IRAQ STARS LEAGUE GRUPO 1
Equipo PJ GF GC Puntos
1 Al Quwa Al Jawiya Quwa Jawiya 18 20 10 33
2 Al Zawraa Al Zawraa 18 21 16 33
3 Naft Al-Janoob Naft 18 20 17 30
4 Naft Al-Wasat Naft 18 16 12 28
5 Al Karkh Al Karkh 18 20 18 26
6 Erbil Erbil 18 21 17 25
7 Zakho Zakho 18 14 22 20
8 Karbala Karbala 18 12 18 19
9 Al Kahrabaa Al Kahrabaa 18 18 23 16
10 Al-Masafi Al-Masafi 18 16 25 14
11 Al Shorta Al Shorta 16 32 7 40
12 Al Minaa Al Minaa 16 22 18 25
13 Baghdad FC Baghdad FC 16 19 16 24
14 Duhok Duhok 17 19 21 24
15 Al Talaba Al Talaba 17 19 18 20
16 Al Hudod Al Hudod 17 16 21 19
17 Al Naft Al Naft 17 18 21 18
18 Naft Maysan Naft Maysan 16 14 20 17
19 Al Najaf Al Najaf 16 10 20 15
20 Al Sulimaniya Sulimaniya 4 0 7 0
TEMPORADA 2013/2014
IRAQ STARS LEAGUE
Equipo PJ GF GC Puntos
1 Al Shorta Al Shorta 20 28 11 43
2 Erbil Erbil 21 29 15 42
3 Baghdad FC Baghdad FC 23 33 22 40
4 Al Quwa Al Jawiya Quwa Jawiya 22 32 21 37
5 Al Zawraa Al Zawraa 22 31 25 33
6 Naft Al-Janoob Naft 22 24 21 33
7 Duhok Duhok 23 30 32 31
8 Al Talaba Al Talaba 22 28 30 31
9 Al Naft Al Naft 23 26 27 30
10 Zakho Zakho 21 21 26 29
11 Al Minaa Al Minaa 23 26 27 28
12 Al Karkh Al Karkh 22 20 25 25
13 Naft Maysan Naft Maysan 21 25 29 24
14 Karbala Karbala 22 12 27 16
15 Al Najaf Al Najaf 23 14 31 16
16 Al-Masafi Al-Masafi 22 18 28 14
TEMPORADA 2012/2013
IRAQ STARS LEAGUE
Equipo PJ GF GC Puntos
1 Al Shorta Al Shorta 34 62 29 72
2 Erbil Erbil 34 68 34 70
3 Al Quwa Al Jawiya Quwa Jawiya 34 60 33 69
4 Al Zawraa Al Zawraa 34 61 29 65
5 Duhok Duhok 34 54 35 58
6 Baghdad FC Baghdad FC 34 36 28 53
7 Zakho Zakho 34 48 41 52
8 Al Minaa Al Minaa 34 54 48 52
9 Al Naft Al Naft 34 43 43 46
10 Naft Al Junoob Naft Junoob 33 47 49 39
11 Al Najaf Al Najaf 34 34 43 38
12 Karbala Karbala 34 40 49 37
13 Al-Masafi Al-Masafi 34 27 39 37
14 Al Talaba Al Talaba 34 35 47 35
15 Al Kahrabaa Al Kahrabaa 33 30 49 34
16 Al Sulaimaniya Sulaimaniya 34 37 60 34
17 Al Sinaah Al Sinaah 34 23 46 25
18 Kirkuk Kirkuk 34 17 74 18
TEMPORADA 2011/2012
IRAQ STARS LEAGUE
Equipo PJ GF GC Puntos
1 Erbil Erbil 38 65 22 83
2 Duhok Duhok 38 56 21 76
3 Al Quwa Al Jawiya Quwa Jawiya 38 61 23 74
4 Al Talaba Al Talaba 38 45 29 68
5 Zakho Zakho 38 53 36 61
6 Baghdad FC Baghdad FC 38 41 26 60
7 Al Shorta Al Shorta 38 45 37 59
8 Al Zawraa Al Zawraa 38 54 35 56
9 Al Najaf Al Najaf 38 40 41 52
10 Al Naft Al Naft 38 39 37 51
11 Al Minaa Al Minaa 38 40 44 50
12 Kirkuk Kirkuk 38 37 46 49
13 Al Sinaah Al Sinaah 38 29 32 47
14 Al Kahrabaa Al Kahrabaa 38 50 55 46
15 Karbala Karbala 38 38 44 44
16 Al-Masafi Al-Masafi 38 24 44 39
17 Al Karkh Al Karkh 38 32 49 34
18 Al Taji Al Taji 38 37 66 34
19 Al Shirqat Al Shirqat 38 24 67 26
20 Al Hedood Al Hedood 38 26 82 10
TEMPORADA 2010/2011
IRAQ STARS LEAGUE
Equipo PJ GF GC Puntos
1 Erbil Erbil 26 54 21 56
2 Al Sinaah Al Sinaah 26 31 16 55
3 Zakho Zakho 26 38 21 53
4 Al Kahrabaa Al Kahrabaa 26 32 22 43
5 Duhok Duhok 26 36 28 40
6 Al Naft Al Naft 26 23 22 38
7 Al Shorta Al Shorta 26 29 23 37
8 Al Karkh Al Karkh 26 30 28 36
9 Al Mosul Al Mosul 26 29 29 35
10 Al Ramadi Al Ramadi 26 25 36 29
11 Peshmarga Peshmarga 26 21 31 24
12 Diyala FC Diyala FC 26 17 32 22
13 Samaraa FC Samaraa FC 26 23 43 19
14 Al Jaish Al Jaish 26 11 47 8
15 Al Zawraa Al Zawraa 26 43 15 62
16 Al Quwa Al Jawiya Quwa Jawiya 26 46 13 60
17 Baghdad FC Baghdad FC 26 37 19 48
18 Al Minaa Al Minaa 26 33 21 45
19 Karbala Karbala 26 23 17 45
20 Al Najaf Al Najaf 26 34 20 42
21 Al-Masafi Al-Masafi 26 22 28 41
22 Naft Al-Janoob Naft 26 28 24 37
23 Al Talaba Al Talaba 26 33 30 37
24 Naft Maysan Naft Maysan 26 19 28 25
25 Al Diwaniya Al Diwaniya 26 24 42 22
26 Al-Nasiriya Al-Nasiriya 26 12 36 14
27 Al Hasanain Al Hasanain 26 10 40 13
28 Al Hindiya Al Hindiya 26 16 47 10
TEMPORADA 2009/2010
IRAQ STARS LEAGUE
Equipo PJ GF GC Puntos
1 Erbil Erbil 33 66 14 80
2 Al Quwa Al Jawiya Quwa Jawiya 33 59 20 73
3 Duhok Duhok 33 53 23 64
4 Al Zawraa Al Zawraa 33 39 22 63
5 Baghdad FC Baghdad FC 33 38 26 51
6 Al Kahrabaa Al Kahrabaa 33 37 26 50
7 Al-Masafi Al-Masafi 33 39 37 46
8 Zakho Zakho 33 30 30 42
9 Al Mosul Al Mosul 33 23 28 38
10 Al Ramadi Al Ramadi 33 26 32 38
11 Diyala FC Diyala FC 33 27 47 37
12 Al Hindiya Al Hindiya 33 34 48 36
13 Kirkuk Kirkuk 33 38 55 32
14 Samaraa FC Samaraa FC 33 21 37 29
15 Al Shirqat Al Shirqat 34 20 45 29
16 Peris FC Peris FC 17 22 12 28
17 Salahaddin FC Salahaddin 33 24 49 25
18 Masafi Al-Junoob Masafi 34 18 63 19
19 Al Talaba Al Talaba 34 46 19 68
20 Al Sinaah Al Sinaah 34 48 29 68
21 Al Najaf Al Najaf 34 45 17 64
22 Karbala Karbala 34 36 18 64
23 Al Shorta Al Shorta 34 50 33 62
24 Naft Al-Janoob Naft 34 40 21 61
25 Al Minaa Al Minaa 34 35 22 59
26 Al Naft Al Naft 34 39 34 48
27 Naft Maysan Naft Maysan 34 39 38 44
28 Al Karkh Al Karkh 34 31 33 44
29 Al Diwaniya Al Diwaniya 34 37 44 43
30 Al Hasanain Al Hasanain 34 31 39 38
31 Al-Nasiriya Al-Nasiriya 34 33 39 37
32 Al Kufa Al Kufa 34 28 37 34
33 Al Hedood Al Hedood 34 17 38 30
34 Al Semawah Al Semawah 34 27 54 25
35 Al-Itesalat Al-Itesalat 34 22 48 20
36 Misan FC Misan FC 34 17 58 14
TEMPORADA 2007/2008
IRAQ STARS LEAGUE GRUPO 1
Equipo PJ GF GC Puntos
1 Al Shorta Al Shorta 22 40 14 47
2 Al Quwa Al Jawiya Quwa Jawiya 22 42 13 46
3 Al Kahrabaa Al Kahrabaa 22 30 10 38
4 Al Zawraa Al Zawraa 22 24 12 37
5 Al Talaba Al Talaba 22 25 17 36
6 Al Sinaah Al Sinaah 22 24 16 35
7 Al-Bareed Al-Bareed 22 25 29 30
8 Al Naft Al Naft 22 18 24 27
9 Al Ramadi Al Ramadi 22 26 42 21
10 Al Jaish Al Jaish 22 14 39 15
11 Al Shualah Al Shualah 22 14 44 13
12 Addala Addala 22 11 33 12
13 Erbil Erbil 14 21 6 31
14 Duhok Duhok 14 13 6 28
15 Kirkuk Kirkuk 13 16 16 18
16 Al Sulimaniya Sulimaniya 13 15 16 18
17 Pires Pires 13 17 17 17
18 Samaraa FC Samaraa FC 13 9 15 13
19 Sirwan Sulimaniya Sirwan 13 9 13 10
20 Zakho Zakho 13 5 16 6
21 Karbala Karbala 16 27 11 38
22 Al Najaf Al Najaf 16 22 9 32
23 Al Minaa Al Minaa 16 19 10 30
24 Naft Al-Janoob Naft 16 16 14 21
25 Maysan Umara Maysan Umara 16 16 16 19
26 Al Kufa Al Kufa 16 13 15 17
27 Al Simawa Al Simawa 16 11 18 16
28 Furat Furat 16 17 33 14
29 Shatra Dhi Qar Shatra 16 11 26 8
TEMPORADA 2005/2006
IRAQ STARS LEAGUE GRUPO 4
Equipo PJ GF GC Puntos
1 Al Talaba Al Talaba 10 16 4 21
2 Erbil Erbil 11 10 7 16
3 Duhok Duhok 9 6 4 13
4 Sirwan Sulimaniya Sirwan 10 10 13 13
5 Karkuk Karkuk 12 10 15 13
6 Ararat Ararat 9 5 9 10
7 Zakho Zakho 11 6 11 10
TEMPORADA 2004/2005
IRAQ STARS LEAGUE GRUPO 2
Equipo PJ GF GC Puntos
TEMPORADA 2002/2003
IRAQ STARS LEAGUE
Equipo PJ GF GC Puntos
1 Al Zawraa Al Zawraa 29 63 17 63
2 Al Shorta Al Shorta 27 60 24 62
3 Al Najaf Al Najaf 27 44 13 62
4 Al Talaba Al Talaba 24 56 15 59
5 Al Quwa Al Jawiya Quwa Jawiya 28 50 30 58
6 Al Minaa Al Minaa 27 30 23 45
7 Al Mosul Al Mosul 27 33 42 38
8 Erbil Erbil 27 44 33 37
9 Al Karkh Al Karkh 27 29 21 37
10 Duhok Duhok 27 31 39 37
11 Zakho Zakho 27 36 27 36
12 Al Defaa Al Defaa 27 27 37 29
13 Samarra Samarra 27 26 41 28
14 Al-Nasiriya Al-Nasiriya 27 27 55 27
15 Al Jaish Al Jaish 27 26 42 26
16 Al Sinaah Al Sinaah 26 17 29 23
17 Al Naft Al Naft 27 21 37 22
18 Al Simawa Al Simawa 27 22 52 22
19 Basra Basra 28 15 46 15
20 Karkuk Karkuk 27 14 48 15

  USO DE MEMORIA  
7,586,176 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1421
Total Execution Time  0.1434
  CADENA URL  
/historico/Zakho
  GET DATOS  
$_GET['/historico/Zakho']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0027  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 = 'Zakho' 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=15493 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=15493 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040  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 = 74409
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=15493 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=476 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 476 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0025  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 (1271137,950270,878752,380567,290691) ORDER BY n.cover_points DESC, update_date DESC
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 = '15493' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '15493' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 74409 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=15493 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 (74409) 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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 74409 AND teamId = 15493
0.0021  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 = '15493' 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 = '15493' 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 = '15493' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0025  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 = 74409 WHERE rp.league_id = 74409 AND rp.teamId = 15493 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.0022  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 = 74409 WHERE rp.league_id = 74409 AND rp.teamId = 15493 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 74409 WHERE rp.league_id = 74409 AND rp.teamId = 15493 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 = 15493 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 74409 AND t.round = 24 ORDER BY team.conference ASC,t.position 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 `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 = 70002 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0041  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 = 64316 AND t.round = 38 ORDER BY team.conference ASC,t.position 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 `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 = 59800 AND t.round = 38 ORDER BY team.conference ASC,t.position 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 `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 = 51287 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.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 `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 = 42074 AND t.round = 38 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 `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 = 36091 AND t.round = 37 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 `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 = 15621 AND t.round = 18 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 `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 = 12134 AND t.round = 18 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 `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 = 3626 AND t.round = 25 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 `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 = 3257 AND t.round = 34 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 = 10590 AND t.round = 38 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 = 10800 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0046  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 = 10802 AND t.round = 34 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 `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 = 16129 AND t.round = 19 ORDER BY team.conference 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 `tables2006` 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 = 27623 AND t.round = 12 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 `tables2005` 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 = 27633 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 `tables2003` 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 = 27645 AND t.round = 29 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC