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

Sunshine Stars

Entrenador: Edith Agoye

TEMPORADA 2023/2024
PREMIER LEAGUE NIGERIA
Equipo PJ GF GC Puntos
1 Enugu Rangers Enugu 31 44 31 54
2 Remo Stars Remo Stars 31 38 27 53
3 Enyimba Enyimba 31 37 26 52
4 Lobi Stars Lobi Stars 31 34 28 52
5 Plateau United Plateau 31 46 31 50
6 Shooting Stars Shooting 31 37 29 49
7 Katsina United Katsina 31 32 29 48
8 Kano Pillars Kano Pillars 31 40 38 44
9 Bendel Insurance Bendel 31 27 25 42
10 Niger Tornadoes Niger 31 29 32 42
11 Abia Warriors Abia 30 32 34 41
12 Rivers United Rivers 26 32 23 40
13 Kwara United Kwara United 30 25 28 39
14 Sporting Lagos FC Sporting 31 29 32 38
15 Doma United FC Doma United 31 22 33 38
16 Sunshine Stars Sunshine 30 28 32 36
17 Bayelsa United Bayelsa 31 34 40 36
18 Akwa United Akwa United 31 31 35 34
19 Heartland Owerri Heartland 31 28 38 29
20 Gombe United Gombe United 31 22 56 25
TEMPORADA 2022/2023
PREMIER LEAGUE NIGERIA GRUPO 2
Equipo PJ GF GC Puntos
1 Enyimba Enyimba 5 8 4 9
2 Remo Stars Remo Stars 5 8 5 9
3 Rivers United Rivers 5 6 4 9
4 Sunshine Stars Sunshine 5 5 7 5
5 Bendel Insurance Bendel 5 3 5 3
6 Lobi Stars Lobi Stars 5 1 6 2
TEMPORADA 2021/2022
PREMIER LEAGUE NIGERIA
Equipo PJ GF GC Puntos
1 Rivers United Rivers 38 58 24 77
2 Plateau United Plateau 38 50 29 67
3 Remo Stars Remo Stars 38 43 26 62
4 Kwara United Kwara United 38 43 45 58
5 Enugu Rangers Enugu 38 41 30 56
6 Nasarawa United Nasarawa 38 42 48 53
7 Enyimba Enyimba 38 39 36 52
8 Gombe United Gombe United 38 39 39 52
9 Akwa United Akwa United 38 35 36 52
10 Wikki Tourist Wikki 38 34 35 52
11 Sunshine Stars Sunshine 38 30 30 51
12 Abia Warriors Abia 38 50 44 50
13 Niger Tornadoes Niger 38 32 38 49
14 Dakkada Dakkada 38 42 49 49
15 Lobi Stars Lobi Stars 38 36 48 49
16 Shooting Stars Shooting 38 41 45 48
17 Kano Pillars Kano Pillars 38 32 36 48
18 Katsina United Katsina 38 34 42 48
19 Heartland Owerri Heartland 38 32 48 47
20 MFM FC MFM FC 38 26 51 36
TEMPORADA 2020/2021
PREMIER LEAGUE NIGERIA
Equipo PJ GF GC Puntos
1 Akwa United Akwa United 38 53 24 71
2 Enyimba Enyimba 38 41 33 66
3 Kwara United Kwara United 38 48 28 65
4 Nasarawa United Nasarawa 38 55 38 65
5 Kano Pillars Kano Pillars 38 38 29 64
6 Rivers United Rivers 38 48 36 63
7 Enugu Rangers Enugu 38 43 31 62
8 Lobi Stars Lobi Stars 38 43 39 58
9 Plateau United Plateau 38 45 35 51
10 MFM FC MFM FC 38 35 35 51
11 Dakkada Dakkada 38 37 47 50
12 Katsina United Katsina 38 35 42 49
13 Heartland Owerri Heartland 38 43 50 48
14 Abia Warriors Abia 38 48 42 47
15 Wikki Tourist Wikki 38 40 47 45
16 Sunshine Stars Sunshine 38 28 39 45
17 Jigawa Golden Stars Jigawa 38 29 46 43
18 Warri Wolves FC Warri Wolves 38 30 45 41
19 Ifeanyi Ubah Ifeanyi Ubah 38 33 51 39
20 Adamawa United FC Adamawa 38 20 55 25
TEMPORADA 2019/2020
PREMIER LEAGUE NIGERIA
Equipo PJ GF GC Puntos
1 Plateau United Plateau 25 36 15 49
2 Enyimba Enyimba 20 30 20 36
3 Rivers United Rivers 25 28 15 45
4 Lobi Stars Lobi Stars 25 26 19 43
5 Enugu Rangers Enugu 24 25 20 37
6 Kano Pillars Kano Pillars 24 27 18 34
7 Katsina United Katsina 24 18 25 34
8 Akwa United Akwa United 25 23 22 35
9 Warri Wolves FC Warri Wolves 24 25 23 33
10 Sunshine Stars Sunshine 25 27 29 34
11 Ifeanyi Ubah Ifeanyi Ubah 25 25 28 33
12 Dakkada Dakkada 26 26 26 34
13 Heartland Owerri Heartland 25 21 21 32
14 Wikki Tourist Wikki 25 23 24 31
15 MFM FC MFM FC 25 19 19 31
16 Abia Warriors Abia 25 23 28 30
17 Nasarawa United Nasarawa 25 27 27 29
18 Jigawa Golden Stars Jigawa 25 25 35 29
19 Kwara United Kwara United 25 23 33 28
20 Adamawa United FC Adamawa 25 17 47 20
TEMPORADA 2018/2019
PREMIER LEAGUE NIGERIA GRUPO 1
Equipo PJ GF GC Puntos
1 Enugu Rangers Enugu 21 22 17 39
2 Lobi Stars Lobi Stars 21 22 15 35
3 Enyimba Enyimba 22 22 13 33
4 MFM FC MFM FC 22 22 20 32
5 Rivers United Rivers 22 18 17 31
6 Wikki Tourist Wikki 22 22 24 30
7 Katsina United Katsina 21 23 24 29
8 Bendel Insurance Bendel 22 13 13 28
9 Kwara United Kwara United 22 15 20 27
10 Sunshine Stars Sunshine 21 20 22 26
11 Niger Tornadoes Niger 22 14 21 21
12 Remo Stars Remo Stars 22 17 24 20
13 Akwa United Akwa United 22 32 24 38
14 Kano Pillars Kano Pillars 22 28 19 37
15 Ifeanyi Ubah Ifeanyi Ubah 22 18 18 36
16 Nasarawa United Nasarawa 22 30 28 33
17 Abia Warriors Abia 22 25 20 31
18 Heartland Owerri Heartland 22 25 22 31
19 Delta Force Delta Force 22 19 26 31
20 Plateau United Plateau 22 18 14 30
21 Gombe United Gombe United 22 19 19 30
22 El Kanemi Warriors Kanemi 22 21 25 30
23 Go Round Go Round 22 16 23 27
24 Yobe Stars Yobe Stars 22 11 24 15
TEMPORADA 2017/2018
PREMIER LEAGUE NIGERIA
Equipo PJ GF GC Puntos
1 Lobi Stars Lobi Stars 24 25 16 43
2 Akwa United Akwa United 24 27 17 41
3 Kano Pillars Kano Pillars 24 30 17 38
4 Enyimba Enyimba 24 23 16 38
5 Plateau United Plateau 24 27 20 37
6 Niger Tornadoes Niger 24 21 23 37
7 Katsina United Katsina 24 28 22 36
8 Abia Warriors Abia 24 20 16 34
9 Rivers United Rivers 24 22 22 34
10 Enugu Rangers Enugu 24 19 15 33
11 MFM FC MFM FC 24 22 24 30
12 Nasarawa United Nasarawa 24 26 29 29
13 El Kanemi Warriors Kanemi 24 17 21 29
14 Wikki Tourist Wikki 24 21 26 29
15 Kwara United Kwara United 24 21 28 29
16 Go Round Go Round 24 16 23 29
17 Ifeanyi Ubah Ifeanyi Ubah 24 23 26 28
18 Sunshine Stars Sunshine 24 22 27 28
19 Yobe Stars Yobe Stars 24 20 30 28
20 Heartland Owerri Heartland 24 15 27 20
TEMPORADA 2016/2017
PREMIER LEAGUE NIGERIA
Equipo PJ GF GC Puntos
1 Plateau United Plateau 38 49 25 66
2 MFM FC MFM FC 38 42 41 62
3 Enyimba Enyimba 38 43 28 61
4 Akwa United Akwa United 38 46 30 60
5 Nasarawa United Nasarawa 38 35 30 56
6 El Kanemi Warriors Kanemi 38 39 43 56
7 Lobi Stars Lobi Stars 38 43 39 54
8 Kano Pillars Kano Pillars 38 38 35 54
9 Ifeanyi Ubah Ifeanyi Ubah 38 39 38 54
10 Sunshine Stars Sunshine 38 41 43 54
11 Niger Tornadoes Niger 38 31 35 54
12 Abia Warriors Abia 38 44 36 53
13 Wikki Tourist Wikki 38 37 41 53
14 Enugu Rangers Enugu 38 39 44 53
15 Rivers United Rivers 38 34 33 52
16 Katsina United Katsina 38 37 38 52
17 Shooting Stars Shooting 38 32 38 50
18 ABS FC ABS FC 38 37 50 49
19 Gombe United Gombe United 38 32 49 43
20 Remo Stars Remo Stars 38 27 49 29
TEMPORADA 2015/2016
PREMIER LEAGUE NIGERIA
Equipo PJ GF GC Puntos
1 Enugu Rangers Enugu 36 53 37 63
2 Rivers United Rivers 36 38 29 60
3 Wikki Tourist Wikki 36 46 29 57
4 Ifeanyi Ubah Ifeanyi Ubah 36 37 33 56
5 Lobi Stars Lobi Stars 36 41 35 55
6 Sunshine Stars Sunshine 36 44 37 53
7 Kano Pillars Kano Pillars 36 47 40 52
8 El Kanemi Warriors Kanemi 36 37 42 51
9 Enyimba Enyimba 36 34 35 50
10 Nasarawa United Nasarawa 36 41 43 50
11 Niger Tornadoes Niger 36 40 42 49
12 Plateau United Plateau 36 34 37 49
13 Abia Warriors Abia 36 35 39 48
14 Akwa United Akwa United 36 45 46 47
15 Shooting Stars Shooting 36 42 49 47
16 MFM FC MFM FC 36 36 40 45
17 Warri Wolves FC Warri Wolves 36 29 38 45
18 Heartland Owerri Heartland 36 25 30 44
19 Ikorodu United Ikorodu 36 32 55 32
20 Giwa Giwa 0 0 0 0
TEMPORADA 2014/2015
PREMIER LEAGUE NIGERIA
Equipo PJ GF GC Puntos
1 Enyimba Enyimba 38 48 27 70
2 Warri Wolves FC Warri Wolves 38 62 29 66
3 Nasarawa United Nasarawa 38 47 35 63
4 Wikki Tourist Wikki 38 45 36 63
5 Giwa Giwa 38 44 42 63
6 Sunshine Stars Sunshine 38 58 38 61
7 Heartland Owerri Heartland 38 46 40 56
8 Kano Pillars Kano Pillars 38 45 39 55
9 Shooting Stars Shooting 38 39 39 53
10 Abia Warriors Abia 38 39 43 53
11 Ifeanyi Ubah Ifeanyi Ubah 38 37 40 50
12 Enugu Rangers Enugu 38 46 51 49
13 El Kanemi Warriors Kanemi 38 38 56 49
14 Lobi Stars Lobi Stars 38 34 39 47
15 Akwa United Akwa United 38 33 43 47
16 Dolphin Port Harcourt Dolphin Port 38 38 40 45
17 Sharks Sharks 38 28 39 42
18 Kwara United Kwara United 38 32 46 42
19 Taraba Taraba 38 30 47 37
20 Bayelsa United Bayelsa 38 28 48 34
TEMPORADA 2013/2014
PREMIER LEAGUE NIGERIA
Equipo PJ GF GC Puntos
1 Kano Pillars Kano Pillars 38 57 41 65
2 Enyimba Enyimba 38 50 27 64
3 Warri Wolves FC Warri Wolves 38 49 38 61
4 Nasarawa United Nasarawa 38 46 37 61
5 Giwa Giwa 38 44 37 59
6 Lobi Stars Lobi Stars 38 40 46 59
7 Abia Warriors Abia 38 51 40 58
8 Enugu Rangers Enugu 38 45 37 58
9 Dolphin Port Harcourt Dolphin Port 38 45 34 55
10 Heartland Owerri Heartland 38 36 27 55
11 Sunshine Stars Sunshine 38 51 47 54
12 Taraba Taraba 38 35 41 53
13 Sharks Sharks 38 42 39 52
14 El Kanemi Warriors Kanemi 38 43 35 51
15 Bayelsa United Bayelsa 38 50 54 51
16 Akwa United Akwa United 38 27 34 51
17 Gombe United Gombe United 38 42 41 50
18 Crown Crown 38 30 56 39
19 Kaduna United FC Kaduna 38 33 55 38
20 Nembe City FC Nembe City 38 23 73 28
TEMPORADA 2012/2013
PREMIER LEAGUE NIGERIA
Equipo PJ GF GC Puntos
1 Kano Pillars Kano Pillars 38 45 39 63
2 Enyimba Enyimba 38 32 19 62
3 Bayelsa United Bayelsa 38 42 39 61
4 El Kanemi Warriors Kanemi 38 41 33 60
5 Enugu Rangers Enugu 38 47 37 58
6 Warri Wolves FC Warri Wolves 38 42 33 55
7 Gombe United Gombe United 38 38 46 55
8 Sharks Sharks 38 35 32 53
9 Dolphin Port Harcourt Dolphin Port 38 32 33 53
10 Kaduna United FC Kaduna 38 37 45 53
11 Heartland Owerri Heartland 38 39 32 52
12 Sunshine Stars Sunshine 38 39 35 52
13 Nasarawa United Nasarawa 38 36 41 52
14 Lobi Stars Lobi Stars 38 35 40 52
15 Nembe City FC Nembe City 38 31 47 52
16 Akwa United Akwa United 38 40 46 51
17 Kwara United Kwara United 38 32 32 50
18 ABS FC ABS FC 38 35 43 50
19 Wikki Tourist Wikki 38 40 41 49
20 Shooting Stars Shooting 38 41 46 46
TEMPORADA 2011/2012
PREMIER LEAGUE NIGERIA
Equipo PJ GF GC Puntos
1 Kano Pillars Kano Pillars 36 43 25 61
2 Enugu Rangers Enugu 36 45 27 58
3 Lobi Stars Lobi Stars 36 38 30 57
4 Enyimba Enyimba 36 37 28 54
5 Sunshine Stars Sunshine 36 41 35 52
6 Kwara United Kwara United 36 35 36 52
7 Sharks Sharks 36 43 45 52
8 Heartland Owerri Heartland 36 32 31 51
9 Gombe United Gombe United 36 38 43 51
10 Wikki Tourist Wikki 36 34 44 51
11 Dolphin Port Harcourt Dolphin Port 36 38 40 50
12 Akwa United Akwa United 36 29 32 50
13 Shooting Stars Shooting 36 30 33 49
14 Kaduna United FC Kaduna 36 36 43 49
15 Bukola Babes Bukola Babes 36 43 40 48
16 Warri Wolves FC Warri Wolves 36 32 30 48
17 Niger Tornadoes Niger 36 37 42 48
18 Jigawa Golden Stars Jigawa 36 30 43 48
19 Rising Stars Rising Stars 36 22 36 39
20 Ocean Boys Ocean Boys 0 0 0 0
TEMPORADA 2010/2011
PREMIER LEAGUE NIGERIA
Equipo PJ GF GC Puntos
1 Dolphin Port Harcourt Dolphin Port 38 49 30 73
2 Sunshine Stars Sunshine 38 55 36 71
3 Warri Wolves FC Warri Wolves 38 43 28 66
4 Kano Pillars Kano Pillars 38 46 31 65
5 Enugu Rangers Enugu 38 46 29 63
6 Sharks Sharks 38 42 37 63
7 Enyimba Enyimba 38 44 28 61
8 Kaduna United FC Kaduna 38 42 39 56
9 Kwara United Kwara United 38 40 45 53
10 Heartland Owerri Heartland 38 38 35 52
11 Lobi Stars Lobi Stars 38 33 42 52
12 Bukola Babes Bukola Babes 38 35 37 51
13 Gombe United Gombe United 38 34 36 50
14 Niger Tornadoes Niger 38 35 43 50
15 Ocean Boys Ocean Boys 38 38 41 49
16 Shooting Stars Shooting 38 33 38 47
17 Plateau United Plateau 38 43 49 44
18 Crown Crown 38 33 48 37
19 Zamfara United Zamfara 38 25 58 37
20 JUTH FC JUTH FC 38 26 50 32
TEMPORADA 2009/2010
PREMIER LEAGUE NIGERIA
Equipo PJ GF GC Puntos
1 Enyimba Enyimba 38 43 25 70
2 Kano Pillars Kano Pillars 38 48 29 66
3 Sunshine Stars Sunshine 38 39 30 64
4 Kwara United Kwara United 38 43 34 60
5 Enugu Rangers Enugu 38 34 22 58
6 Warri Wolves FC Warri Wolves 38 50 43 58
7 Niger Tornadoes Niger 38 42 38 55
8 Heartland Owerri Heartland 38 37 33 54
9 Gombe United Gombe United 38 34 33 52
10 Kaduna United FC Kaduna 38 40 45 52
11 Shooting Stars Shooting 38 27 33 52
12 Dolphin Port Harcourt Dolphin Port 38 39 39 51
13 Lobi Stars Lobi Stars 38 34 37 51
14 Ocean Boys Ocean Boys 38 32 36 50
15 Zamfara United Zamfara 38 30 46 49
16 Sharks Sharks 38 45 41 48
17 Wikki Tourist Wikki 38 40 38 47
18 Bayelsa United Bayelsa 38 40 46 47
19 Gateway FC Gateway FC 38 33 46 40
20 Ranchers Bees Ranchers 38 23 59 36
TEMPORADA 2008/2009
PREMIER LEAGUE NIGERIA
Equipo PJ GF GC Puntos
1 Bayelsa United Bayelsa 38 50 27 70
2 Heartland Owerri Heartland 38 47 27 67
3 Enyimba Enyimba 38 38 29 64
4 Warri Wolves FC Warri Wolves 38 45 36 58
5 Niger Tornadoes Niger 38 37 31 56
6 Enugu Rangers Enugu 38 34 28 56
7 Kano Pillars Kano Pillars 38 35 35 54
8 Ocean Boys Ocean Boys 38 28 34 54
9 Sharks Sharks 38 41 37 53
10 Kaduna United FC Kaduna 38 32 43 53
11 Gateway FC Gateway FC 38 32 34 51
12 Gombe United Gombe United 38 28 35 51
13 Sunshine Stars Sunshine 38 34 32 50
14 Wikki Tourist Wikki 38 26 37 49
15 Zamfara United Zamfara 38 44 43 48
16 Akwa United Akwa United 38 41 42 48
17 JUTH FC JUTH FC 38 26 28 47
18 Lobi Stars Lobi Stars 38 33 38 47
19 Nasarawa United Nasarawa 38 27 47 39
20 Abuja FC Abuja FC 38 23 38 37
TEMPORADA 2007/2008
PREMIER LEAGUE NIGERIA
Equipo PJ GF GC Puntos
1 Kano Pillars Kano Pillars 38 43 28 64
2 Heartland Owerri Heartland 38 41 25 63
3 Bayelsa United Bayelsa 38 36 22 63
4 Sunshine Stars Sunshine 38 43 28 61
5 Niger Tornadoes Niger 38 45 38 60
6 Enyimba Enyimba 38 44 32 59
7 Lobi Stars Lobi Stars 38 46 36 58
8 Enugu Rangers Enugu 38 31 26 57
9 Wikki Tourist Wikki 37 43 42 53
10 Gombe United Gombe United 38 37 42 52
11 Zamfara United Zamfara 38 32 39 52
12 Sharks Sharks 38 46 42 50
13 Ocean Boys Ocean Boys 38 31 33 50
14 Akwa United Akwa United 38 35 44 48
15 JUTH FC JUTH FC 38 28 42 48
16 Nasarawa United Nasarawa 37 28 35 46
17 Kwara United Kwara United 38 33 43 46
18 Jigawa Golden Stars Jigawa 38 29 37 42
19 Prime FC Prime FC 38 21 39 41
20 Bendel Insurance Bendel 38 26 45 39

  USO DE MEMORIA  
7,557,560 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7293
Total Execution Time  0.7304
  CADENA URL  
/historico/Sunshine-Stars
  GET DATOS  
$_GET['/historico/Sunshine-Stars']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0154  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 = 'Sunshine-Stars' 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.0145  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=15887 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=15887 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0293  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 = 73889
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=15887 AND type_rel = 2
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=490 AND type_rel = 3
0.0147  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 490 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0149  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 (1162543,1162408,1154996,1008473,812430) ORDER BY n.cover_points DESC, update_date DESC
0.0149  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 = '15887' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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 = '15887' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147  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 = 73889 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148  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=15887 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145  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 (73889) 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.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 73889 AND teamId = 15887
0.0148  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 = '15887' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '15887' and rp.type = 4
0.0146  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 = '15887' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0157  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 = 73889 WHERE rp.league_id = 73889 AND rp.teamId = 15887 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.0155  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 = 73889 WHERE rp.league_id = 73889 AND rp.teamId = 15887 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0152  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 = 73889 WHERE rp.league_id = 73889 AND rp.teamId = 15887 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150  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 = 15887 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0152  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 = 73889 AND t.round = 32 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 70854 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.0147  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 = 71932 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.0150  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 = 66211 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.0151  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 = 60356 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.0150  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 = 51792 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.0151  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 = 48512 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 42068 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 37673 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 20383 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 10205 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 3764 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 3238 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 10754 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 10753 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 10752 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 10751 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 10750 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC