4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del V-Varen Nagasaki

V-Varen Nagasaki

Entrenador: Takahiro Shimotaira

Temporada 2018/2019
TEMPORADA 2018/2019
SEGUNDA JAPONESA J2
Equipo PJ GF GC Puntos
1 Kashiwa Reysol Kashiwa 42 85 33 84
2 Yokohama Yokohama 42 66 40 79
3 Omiya Ardija Omiya Ardija 42 62 40 75
4 Tokushima Vortis Tokushima 42 67 45 73
5 Ventforet Kofu Ventforet 42 64 40 71
6 Montedio Yamagata Montedio 42 59 40 70
7 Mito Hollyhock Mito 42 56 37 70
8 Kyoto Sanga Kyoto Sanga 42 59 56 68
9 Fagiano Okayama Fagiano 42 49 47 65
10 Albirex Niigata Albirex 42 71 52 62
11 Zweigen Kanazawa Zweigen 42 58 46 61
12 V-Varen Nagasaki V-Varen 42 57 61 56
13 Tokyo Verdy Tokyo Verdy 42 59 59 55
14 Ryūkyū Ryūkyū 42 57 80 49
15 Renofa Yamaguchi Renofa 42 54 70 47
16 Avispa Fukuoka Avispa 42 39 62 44
17 JEF United JEF United 42 46 64 43
18 Machida Zelvia Machida 42 36 59 43
19 Ehime Ehime 42 46 62 42
20 Tochigi Tochigi 42 33 53 40
21 Kagoshima United Kagoshima 42 41 73 40
22 Gifu Gifu 42 33 78 30
TEMPORADA 2017/2018
LIGA JAPONESA J1
Equipo PJ GF GC Puntos
1 Kawasaki Frontale Kawasaki 34 57 27 69
2 Sanfrecce Hiroshima Sanfrecce 34 47 35 57
3 Kashima Antlers Kashima 34 50 39 56
4 Consadole Sapporo Consadole 34 48 48 55
5 Urawa Reds Urawa Reds 34 51 39 51
6 FC Tokyo FC Tokyo 34 39 34 50
7 Cerezo Osaka Cerezo Osaka 34 39 38 50
8 Shimizu S-Pulse Shimizu 34 56 48 49
9 Gamba Osaka Gamba Osaka 34 41 46 48
10 Vissel Kobe Vissel Kobe 34 45 52 45
11 Vegalta Sendai Vegalta 34 44 54 45
12 Yokohama F. Marinos Yokohama 34 56 56 41
13 Shonan Bellmare Shonan 34 38 43 41
14 Sagan Tosu Sagan Tosu 34 29 34 41
15 Nagoya Grampus Nagoya 34 52 59 41
16 Júbilo Iwata Júbilo 34 35 48 41
17 Kashiwa Reysol Kashiwa 34 47 54 39
18 V-Varen Nagasaki V-Varen 34 39 59 30
TEMPORADA 2016/2017
SEGUNDA JAPONESA J2
Equipo PJ GF GC Puntos
1 Shonan Bellmare Shonan 42 58 36 83
2 V-Varen Nagasaki V-Varen 42 59 41 80
3 Nagoya Grampus Nagoya 42 85 65 75
4 Avispa Fukuoka Avispa 42 54 36 74
5 Tokyo Verdy Tokyo Verdy 42 64 49 70
6 JEF United JEF United 42 70 58 68
7 Tokushima Vortis Tokushima 42 71 45 67
8 Matsumoto Yamaga Matsumoto 42 61 45 66
9 Oita Trinita Oita Trinita 42 58 50 64
10 Yokohama Yokohama 42 60 49 63
11 Montedio Yamagata Montedio 42 45 47 59
12 Kyoto Sanga Kyoto Sanga 42 55 47 57
13 Fagiano Okayama Fagiano 42 44 49 55
14 Mito Hollyhock Mito 42 45 48 54
15 Ehime Ehime 42 54 68 51
16 Machida Zelvia Machida 42 53 53 50
17 Zweigen Kanazawa Zweigen 42 49 67 49
18 Gifu Gifu 42 56 68 46
19 Kamatamare Sanuki Kamatamare 42 41 61 38
20 Renofa Yamaguchi Renofa 42 48 69 38
21 Roasso Kumamoto Roasso 42 36 59 37
22 Thespa Gunma Thespa Gunma 42 32 88 20
TEMPORADA 2015/2016
SEGUNDA JAPONESA J2
Equipo PJ GF GC Puntos
1 Consadole Sapporo Consadole 42 65 33 85
2 Shimizu S-Pulse Shimizu 42 85 37 84
3 Matsumoto Yamaga Matsumoto 42 62 32 84
4 Cerezo Osaka Cerezo Osaka 42 62 46 78
5 Kyoto Sanga Kyoto Sanga 42 50 37 69
6 Fagiano Okayama Fagiano 42 58 44 65
7 Machida Zelvia Machida 42 53 44 65
8 Yokohama Yokohama 42 50 51 59
9 Tokushima Vortis Tokushima 42 46 42 57
10 Ehime Ehime 42 41 40 56
11 JEF United JEF United 42 52 53 53
12 Renofa Yamaguchi Renofa 42 55 63 53
13 Mito Hollyhock Mito 42 45 49 48
14 Montedio Yamagata Montedio 42 43 49 47
15 V-Varen Nagasaki V-Varen 42 39 51 47
16 Roasso Kumamoto Roasso 42 38 53 46
17 Thespa Gunma Thespa Gunma 42 52 66 45
18 Tokyo Verdy Tokyo Verdy 42 43 61 43
19 Kamatamare Sanuki Kamatamare 42 43 62 43
20 Gifu Gifu 42 47 71 43
21 Zweigen Kanazawa Zweigen 42 36 60 39
22 Giravanz Kitakyushu Giravanz 42 43 64 38
TEMPORADA 2014/2015
SEGUNDA JAPONESA J2
Equipo PJ GF GC Puntos
1 Omiya Ardija Omiya Ardija 42 72 37 86
2 Júbilo Iwata Júbilo 42 72 43 82
3 Avispa Fukuoka Avispa 42 63 37 82
4 Cerezo Osaka Cerezo Osaka 42 57 40 67
5 Ehime Ehime 42 47 39 65
6 V-Varen Nagasaki V-Varen 42 42 33 60
7 Giravanz Kitakyushu Giravanz 42 59 58 59
8 Tokyo Verdy Tokyo Verdy 42 42 41 58
9 JEF United JEF United 42 50 45 57
10 Consadole Sapporo Consadole 42 47 43 57
11 Fagiano Okayama Fagiano 42 40 35 54
12 Zweigen Kanazawa Zweigen 42 46 43 54
13 Roasso Kumamoto Roasso 42 42 45 53
14 Tokushima Vortis Tokushima 42 35 44 53
15 Yokohama Yokohama 42 33 58 52
16 Kamatamare Sanuki Kamatamare 42 30 33 51
17 Kyoto Sanga Kyoto Sanga 42 45 51 50
18 Thespa Gunma Thespa Gunma 42 34 55 48
19 Mito Hollyhock Mito 42 40 47 46
20 Gifu Gifu 42 37 71 43
21 Oita Trinita Oita Trinita 42 41 51 38
22 Tochigi Tochigi 42 39 64 35
TEMPORADA 2013/2014
SEGUNDA JAPONESA J2
Equipo PJ GF GC Puntos
1 Shonan Bellmare Shonan 42 86 25 101
2 Matsumoto Yamaga Matsumoto 42 65 35 83
3 JEF United JEF United 42 55 44 68
4 Júbilo Iwata Júbilo 42 67 55 67
5 Giravanz Kitakyushu Giravanz 42 50 50 65
6 Montedio Yamagata Montedio 42 57 44 64
7 Oita Trinita Oita Trinita 42 52 55 63
8 Fagiano Okayama Fagiano 42 52 48 61
9 Kyoto Sanga Kyoto Sanga 42 57 52 60
10 Consadole Sapporo Consadole 42 48 44 59
11 Yokohama Yokohama 42 49 47 55
12 Tochigi Tochigi 42 52 58 55
13 Roasso Kumamoto Roasso 42 45 53 54
14 V-Varen Nagasaki V-Varen 42 45 42 52
15 Mito Hollyhock Mito 42 46 46 50
16 Avispa Fukuoka Avispa 42 52 60 50
17 Gifu Gifu 42 54 61 49
18 Thespa Gunma Thespa Gunma 42 45 54 49
19 Ehime Ehime 42 54 58 48
20 Tokyo Verdy Tokyo Verdy 42 31 48 42
21 Kamatamare Sanuki Kamatamare 42 34 71 33
22 Kataller Toyama Kataller 42 28 74 23
TEMPORADA 2012/2013
SEGUNDA JAPONESA J2
Equipo PJ GF GC Puntos
1 Gamba Osaka Gamba Osaka 42 99 46 87
2 Vissel Kobe Vissel Kobe 42 78 41 83
3 Kyoto Sanga Kyoto Sanga 42 68 46 70
4 Tokushima Vortis Tokushima 42 56 51 67
5 JEF United JEF United 42 68 49 66
6 V-Varen Nagasaki V-Varen 42 48 40 66
7 Matsumoto Yamaga Matsumoto 42 54 54 66
8 Consadole Sapporo Consadole 42 60 49 64
9 Tochigi Tochigi 42 61 55 63
10 Montedio Yamagata Montedio 42 74 61 59
11 Yokohama Yokohama 42 49 46 58
12 Fagiano Okayama Fagiano 42 52 48 56
13 Tokyo Verdy Tokyo Verdy 42 52 58 56
14 Avispa Fukuoka Avispa 42 47 54 56
15 Mito Hollyhock Mito 42 50 58 55
16 Giravanz Kitakyushu Giravanz 42 50 60 49
17 Ehime Ehime 42 43 52 47
18 Kataller Toyama Kataller 42 45 59 44
19 Roasso Kumamoto Roasso 42 40 70 43
20 Thespa Gunma Thespa Gunma 42 43 61 40
21 Gifu Gifu 42 37 80 37
22 Gainare Tottori Gainare 42 38 74 31
TEMPORADA 2011/2012
LIGA FÚTBOL JAPÓN - 1ª FASE
Equipo PJ GF GC Puntos
1 V-Varen Nagasaki V-Varen 32 57 24 67
2 Parceiro Nagano Parceiro 32 57 34 58
3 Sagawa Shiga Sagawa Shiga 32 61 37 57
4 Kamatamare Sanuki Kamatamare 32 49 29 53
5 Honda Honda 32 55 39 53
6 YSCC YSCC 32 58 50 49
7 Sagawa Printing Sagawa 32 43 43 45
8 MIO Biwako Kusatsu Biwako 32 53 52 43
9 Ryūkyū Ryūkyū 32 58 62 43
10 Yokogawa Musashino Yokogawa 32 35 50 41
11 Fujieda MYFC Fujieda MYFC 32 39 48 40
12 Sony Sendai Sony Sendai 32 27 29 39
13 Blaublitz Akita Blaublitz 32 33 41 37
14 Zweigen Kanazawa Zweigen 32 33 41 36
15 Hoyo Oita Hoyo Oita 32 40 57 35
16 Minebea Mitsumi Minebea 32 28 56 28
17 Tochigi Uva Tochigi Uva 32 36 70 22
TEMPORADA 2010/2011
LIGA FÚTBOL JAPÓN - 1ª FASE
Equipo PJ GF GC Puntos
1 Sagawa Shiga Sagawa Shiga 33 60 34 70
2 Parceiro Nagano Parceiro 33 51 27 63
3 Machida Zelvia Machida 33 61 28 61
4 Matsumoto Yamaga Matsumoto 33 60 38 59
5 V-Varen Nagasaki V-Varen 33 61 44 56
6 Honda Honda 33 40 36 52
7 Zweigen Kanazawa Zweigen 33 49 40 47
8 Minebea Mitsumi Minebea 33 47 45 47
9 Ryūkyū Ryūkyū 33 47 51 46
10 Tochigi Uva Tochigi Uva 33 40 43 45
11 Kamatamare Sanuki Kamatamare 33 39 49 40
12 Sagawa Printing Sagawa 33 43 61 38
13 Reilac Shiga Reilac Shiga 33 43 65 38
14 Blaublitz Akita Blaublitz 33 38 52 37
15 Yokogawa Musashino Yokogawa 33 33 37 36
16 Arte Takasaki Arte 33 39 55 34
17 JEF United II United 33 27 63 19
18 Sony Sendai Sony Sendai 17 14 24 16
TEMPORADA 2009/2010
LIGA FÚTBOL JAPÓN - 1ª FASE
Equipo PJ GF GC Puntos
1 Gainare Tottori Gainare 34 64 31 77
2 Sagawa Shiga Sagawa Shiga 34 69 35 62
3 Machida Zelvia Machida 34 71 44 61
4 Honda Honda 34 52 43 59
5 V-Varen Nagasaki V-Varen 34 50 38 53
6 Sagawa Printing Sagawa 34 54 46 53
7 Matsumoto Yamaga Matsumoto 34 48 41 52
8 Blaublitz Akita Blaublitz 34 54 41 51
9 Zweigen Kanazawa Zweigen 34 46 41 50
10 Ryūkyū Ryūkyū 34 51 51 48
11 Reilac Shiga Reilac Shiga 34 51 56 46
12 Yokogawa Musashino Yokogawa 34 34 38 44
13 Minebea Mitsumi Minebea 34 36 39 42
14 Sony Sendai Sony Sendai 34 34 42 42
15 Tochigi Uva Tochigi Uva 34 41 75 31
16 JEF United II United 34 31 55 30
17 Arte Takasaki Arte 34 28 51 29
18 Ryutsu Keizai University Ryutsu 34 33 80 19
TEMPORADA 2008/2009
LIGA FÚTBOL JAPÓN - 1ª FASE
Equipo PJ GF GC Puntos
1 Sagawa Shiga Sagawa Shiga 34 62 36 66
2 Yokogawa Musashino Yokogawa 34 48 34 60
3 Sony Sendai Sony Sendai 34 49 30 59
4 Giravanz Kitakyushu Giravanz 34 49 31 58
5 Gainare Tottori Gainare 34 65 37 56
6 Machida Zelvia Machida 34 38 30 54
7 Honda Honda 34 49 38 51
8 Reilac Shiga Reilac Shiga 34 51 43 48
9 Sagawa Printing Sagawa 34 56 46 47
10 Blaublitz Akita Blaublitz 34 39 54 46
11 V-Varen Nagasaki V-Varen 34 38 43 44
12 JEF United II United 34 26 37 41
13 Minebea Mitsumi Minebea 34 34 38 40
14 Arte Takasaki Arte 34 34 46 40
15 Ryutsu Keizai University Ryutsu 34 41 55 40
16 Ryūkyū Ryūkyū 34 42 57 38
17 FC Kariya FC Kariya 34 26 51 31
18 Mizushima Mizushima 34 28 69 18

  USO DE MEMORIA  
7,185,296 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1681
Total Execution Time  0.1694
  CADENA URL  
/historico/V-Varen-Nagasaki/2019
  GET DATOS  
$_GET['/historico/V-Varen-Nagasaki/2019']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (45)  
0.0037  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 = 'V-Varen-Nagasaki' AND l.year = 2019 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.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=7417 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=7417 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=7417 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=7417 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=7417 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=7417 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0024  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 = 48768
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 = 48791
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 = 49831
0.0023  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 = 49698
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7417 AND type_rel = 2
0.0025  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 7417 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023  SELECT /*35 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 (945,969,6018,156840) ORDER BY n.cover_points DESC, update_date DESC
0.0028  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 = '7417' AND l.year = 2019 ORDER BY l.year DESC,cat.coefficient DESC
0.0030  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 = '7417' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 49831 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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 = 49698 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 48768 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0034  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=7417 AND l.year in (2018,2019,2020) ORDER BY l.id DESC, l.year DESC ;
0.0021  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 (55275,49831,49698,49506,42417) 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.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 42417 AND teamId = 7417
0.0036  SELECT count(id) as num_players from rel_players WHERE league_id = 55275 AND teamId = 7417
0.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 49831 AND teamId = 7417
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 49698 AND teamId = 7417
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 49506 AND teamId = 7417
0.0043  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 48768 AND t.round = 42 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '7417' 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 = '7417' and rp.type = 4
0.0021  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 = '7417' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0044  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 events2019 e ON e.player_id = p.id AND e.league_id = 48768 WHERE rp.league_id = 48768 AND rp.teamId = 7417 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.0038  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 events2019 e ON e.player_id = p.id AND e.league_id = 48768 WHERE rp.league_id = 48768 AND rp.teamId = 7417 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  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 events2019 e ON e.player_id = p.id AND e.league_id = 48768 WHERE rp.league_id = 48768 AND rp.teamId = 7417 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 = 7417 AND l.year <= 2019 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 48768 AND t.round = 42 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 `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 = 42417 AND t.round = 34 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 `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 = 37765 AND t.round = 42 ORDER BY team.conference 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 `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 = 20246 AND t.round = 42 ORDER BY team.conference 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 `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 = 10157 AND t.round = 42 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 `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 = 3562 AND t.round = 42 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 = 2299 AND t.round = 42 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 `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 = 1732 AND t.round = 34 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 `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 = 49989 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 `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 = 49990 AND t.round = 34 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 `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 = 49991 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC