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

Big Bullets

Entrenador: Edington Ng'onamo

Temporada 2023/2024
TEMPORADA 2023/2024
LIGA MALAUI
Equipo PJ GF GC Puntos
1 Silver Strikers Silver 4 11 3 10
2 Ekwendeni Hammers Ekwendeni 4 5 3 9
3 Be Forward Wanderers Forward 4 7 1 8
4 Big Bullets Big Bullets 4 6 2 8
5 Kamuzu Barracks Kamuzu 4 7 4 8
6 Moyale Barracks Moyale 4 7 4 7
7 Karonga United Karonga 4 6 6 7
8 Creck Sporting Creck 4 7 8 6
9 FOMO FOMO 4 3 6 6
10 Azam Tigers Azam Tigers 4 3 6 4
11 CIVO United CIVO United 4 4 6 3
12 Chitipa United Chitipa 4 4 7 3
13 Dedza Dynamos Dedza 4 2 5 3
14 Bangwe All Stars Bangwe Stars 4 2 5 2
15 MAFCO MAFCO 4 3 8 2
16 Baka City Baka City 4 2 5 1
TEMPORADA 2022/2023
LIGA MALAUI
Equipo PJ GF GC Puntos
1 Big Bullets Big Bullets 30 49 19 60
2 Silver Strikers Silver 30 41 18 57
3 Be Forward Wanderers Forward 30 35 16 55
4 Chitipa United Chitipa 30 31 29 48
5 Kamuzu Barracks Kamuzu 30 32 23 46
6 Bangwe All Stars Bangwe Stars 30 37 36 42
7 Dedza Dynamos Dedza 30 30 38 38
8 CIVO United CIVO United 30 31 30 37
9 Karonga United Karonga 30 34 38 37
10 MAFCO MAFCO 30 29 36 37
11 Azam Tigers Azam Tigers 30 21 22 36
12 Ekwendeni Hammers Ekwendeni 30 26 36 36
13 Blue Eagles Blue Eagles 30 32 32 35
14 Moyale Barracks Moyale 30 32 32 35
15 Red Lions Red Lions 30 22 50 29
16 Extreme Extreme 30 16 43 18
TEMPORADA 2021/2022
LIGA MALAUI
Equipo PJ GF GC Puntos
1 Big Bullets Big Bullets 32 74 22 79
2 Kamuzu Barracks Kamuzu 33 40 20 63
3 Blue Eagles Blue Eagles 30 39 10 63
4 Be Forward Wanderers Forward 32 56 31 56
5 MAFCO MAFCO 31 54 26 53
6 Silver Strikers Silver 30 38 26 51
7 CIVO United CIVO United 31 39 28 48
8 Moyale Barracks Moyale 31 39 35 46
9 Dedza Dynamos Dedza 30 29 36 41
10 Ekwendeni Hammers Ekwendeni 31 34 35 37
11 Karonga United Karonga 32 28 49 33
12 Azam Tigers Azam Tigers 31 23 40 31
13 Red Lions Red Lions 30 27 38 29
14 Sable Farming Sable 30 24 44 24
15 TN Stars TN Stars 32 26 72 18
16 Rumphi United Rumphi 30 15 73 10
TEMPORADA 2020/2021
LIGA MALAUI
Equipo PJ GF GC Puntos
1 Big Bullets Big Bullets 30 51 18 62
2 Silver Strikers Silver 30 55 20 58
3 Be Forward Wanderers Forward 30 38 20 55
4 CIVO United CIVO United 30 37 26 48
5 Moyale Barracks Moyale 30 30 32 46
6 Karonga United Karonga 29 33 25 45
7 MAFCO MAFCO 29 31 27 42
8 TN Stars TN Stars 28 27 39 42
9 Kamuzu Barracks Kamuzu 30 29 31 41
10 Ekwendeni Hammers Ekwendeni 29 30 31 38
11 Red Lions Red Lions 30 27 31 35
12 Blue Eagles Blue Eagles 30 29 29 32
13 Azam Tigers Azam Tigers 30 24 32 32
14 Chitipa United Chitipa 29 22 41 29
15 Ntopwa Ntopwa 30 28 55 21
16 Mzuni FC Mzuni FC 30 18 52 18
TEMPORADA 2019/2020
LIGA MALAUI
Equipo PJ GF GC Puntos
1 Big Bullets Big Bullets 30 62 13 70
2 Be Forward Wanderers Forward 30 55 15 69
3 Blue Eagles Blue Eagles 30 48 34 53
4 Silver Strikers Silver 30 40 28 53
5 Civil Sporting Civil 30 38 32 44
6 Moyale Barracks Moyale 30 32 31 42
7 Kamuzu Barracks Kamuzu 30 22 22 42
8 TN Stars TN Stars 30 31 40 41
9 Azam Tigers Azam Tigers 30 24 24 38
10 Karonga United Karonga 30 36 45 37
11 Ntopwa Ntopwa 30 41 48 35
12 Mzuni FC Mzuni FC 30 27 37 32
13 Chitipa United Chitipa 30 31 47 32
14 Dwangwa United Dwangwa 30 31 52 30
15 Mponela United FC Mponela 30 25 45 23
16 Masters Security Masters 30 22 52 20
TEMPORADA 2018/2019
LIGA MALAUI
Equipo PJ GF GC Puntos
1 Big Bullets Big Bullets 30 55 13 71
2 Be Forward Wanderers Forward 30 48 18 63
3 Silver Strikers Silver 30 40 18 57
4 Masters Security Masters 30 30 32 42
5 Civil Sporting Civil 30 35 38 42
6 Kamuzu Barracks Kamuzu 30 26 33 38
7 Karonga United Karonga 30 34 36 37
8 Mzuni FC Mzuni FC 30 25 25 36
9 TN Stars TN Stars 30 37 45 36
10 Azam Tigers Azam Tigers 30 38 40 35
11 Blue Eagles Blue Eagles 30 31 33 35
12 Dwangwa United Dwangwa 30 35 44 35
13 Moyale Barracks Moyale 30 32 41 35
14 Red Lions Red Lions 30 28 37 33
15 MAFCO MAFCO 30 28 38 29
16 Nchalo United Nchalo 30 18 49 17
TEMPORADA 2017/2018
LIGA MALAUI
Equipo PJ GF GC Puntos
1 Be Forward Wanderers Forward 30 46 16 69
2 Big Bullets Big Bullets 30 41 10 67
3 Silver Strikers Silver 30 39 16 61
4 Civil Sporting Civil 30 47 29 48
5 Blue Eagles Blue Eagles 30 34 30 45
6 MAFCO MAFCO 30 31 31 44
7 Moyale Barracks Moyale 30 37 41 44
8 Kamuzu Barracks Kamuzu 30 40 40 42
9 Red Lions Red Lions 30 34 28 40
10 Mzuni FC Mzuni FC 30 32 34 37
11 Azam Tigers Azam Tigers 30 30 31 32
12 Masters Security Masters 30 38 50 31
13 Dwangwa United Dwangwa 30 31 46 31
14 Wizards Wizards 30 26 40 27
15 Blantyre United Blantyre 30 32 57 24
16 Chitipa United Chitipa 30 21 60 16
TEMPORADA 2016/2017
LIGA MALAUI
Equipo PJ GF GC Puntos
1 Kamuzu Barracks Kamuzu 30 55 29 61
2 Big Bullets Big Bullets 30 43 17 60
3 Silver Strikers Silver 30 45 23 56
4 Blue Eagles Blue Eagles 30 41 26 54
5 MAFCO MAFCO 30 45 33 50
6 Be Forward Wanderers Forward 30 51 33 49
7 Moyale Barracks Moyale 30 41 26 47
8 Azam Tigers Azam Tigers 30 35 21 43
9 Mzuni FC Mzuni FC 30 31 29 41
10 Red Lions Red Lions 30 33 36 40
11 Civil Sporting Civil 30 30 39 34
12 Dwangwa United Dwangwa 30 30 41 30
13 Wizards Wizards 30 17 43 30
14 Karonga United Karonga 30 28 64 27
15 CIVO United CIVO United 30 20 35 25
16 Max Bullets Max Bullets 30 15 65 8
TEMPORADA 2015/2016
LIGA MALAUI
Equipo PJ GF GC Puntos
1 Big Bullets Big Bullets 28 52 24 66
2 MAFCO MAFCO 28 42 29 50
3 Blue Eagles Blue Eagles 28 45 29 48
4 Be Forward Wanderers Forward 28 36 29 45
5 Silver Strikers Silver 28 37 26 44
6 Azam Tigers Azam Tigers 28 33 28 42
7 Red Lions Red Lions 28 42 39 41
8 Kamuzu Barracks Kamuzu 28 27 27 36
9 Moyale Barracks Moyale 28 28 27 34
10 CIVO United CIVO United 28 25 29 34
11 Civil Sporting Civil 28 31 47 30
12 Mzuni FC Mzuni FC 28 22 35 29
13 Dezda Young Soccer Dezda Young 28 28 48 29
14 Airbone Rangers Airbone 28 21 37 25
15 Surestream Surestream 28 25 40 21
TEMPORADA 2014/2015
LIGA MALAUI
Equipo PJ GF GC Puntos
1 Big Bullets Big Bullets 29 48 19 65
2 Moyale Barracks Moyale 28 44 25 53
3 Silver Strikers Silver 28 48 26 51
4 Blue Eagles Blue Eagles 28 51 30 50
5 CIVO United CIVO United 28 35 27 45
6 MTL Wanderers Wanderers 27 26 22 42
7 Red Lions Red Lions 28 31 30 42
8 MAFCO MAFCO 28 50 38 41
9 Azam Tigers Azam Tigers 28 34 26 41
10 Kamuzu Barracks Kamuzu 28 30 30 36
11 Airbone Rangers Airbone 28 36 48 30
12 Civil Sporting Civil 27 21 32 29
13 Blantyre United Blantyre 28 19 44 21
14 Chikwawa United Chikwawa 28 23 56 20
15 Karonga United Karonga 29 26 69 16
TEMPORADA 2013/2014
LIGA MALAUI
Equipo PJ GF GC Puntos
1 Moyale Barracks Moyale 28 47 23 50
2 MAFCO MAFCO 28 41 31 49
3 Kamuzu Barracks Kamuzu 28 42 29 47
4 Blue Eagles Blue Eagles 28 32 25 47
5 Silver Strikers Silver 28 38 16 44
6 Red Lions Red Lions 28 36 30 42
7 Big Bullets Big Bullets 28 34 25 41
8 MTL Wanderers Wanderers 28 26 22 39
9 Azam Tigers Azam Tigers 28 24 21 39
10 CIVO United CIVO United 28 28 22 36
11 Civil Sporting Civil 28 38 36 36
12 Blantyre United Blantyre 28 27 42 30
13 Mponela United FC Mponela 28 29 43 26
14 Evirom Evirom 28 22 47 20
15 Mzuni FC Mzuni FC 28 22 74 12
TEMPORADA 2012/2013
LIGA MALAUI
Equipo PJ GF GC Puntos
1 Silver Strikers Silver 28 64 27 58
2 Big Bullets Big Bullets 28 52 21 58
3 Blantyre United Blantyre 28 54 45 51
4 Be Forward Wanderers Forward 28 39 27 48
5 Red Lions Red Lions 28 32 30 46
6 CIVO United CIVO United 28 33 38 42
7 Blue Eagles Blue Eagles 28 33 31 41
8 Moyale Barracks Moyale 28 35 31 38
9 Civil Sporting Civil 28 39 36 38
10 MAFCO MAFCO 28 41 43 38
11 Azam Tigers Azam Tigers 28 32 32 37
12 Kamuzu Barracks Kamuzu 28 27 33 36
13 Bvumbwe Research Bvumbwe 28 34 53 24
14 ESCOM United ESCOM United 28 28 60 19
15 Kabwafu Kabwafu 28 20 56 14
TEMPORADA 2011/2012
LIGA MALAUI
Equipo PJ GF GC Puntos
1 Silver Strikers Silver 28 60 28 48
2 ESCOM United ESCOM United 28 38 26 47
3 Be Forward Wanderers Forward 28 29 19 45
4 CIVO United CIVO United 28 36 28 44
5 Moyale Barracks Moyale 28 51 34 43
6 Blantyre United Blantyre 28 40 33 42
7 Blue Eagles Blue Eagles 27 30 31 42
8 Red Lions Red Lions 28 30 24 41
9 Civil Sporting Civil 27 40 32 40
10 Azam Tigers Azam Tigers 28 41 39 40
11 Big Bullets Big Bullets 28 29 28 40
12 MAFCO MAFCO 28 20 31 39
13 Cobbe Barracks Cobbe 28 27 47 27
14 Zomba United Zomba United 28 21 51 22
15 Embangweni United Embangweni 28 17 58 19
TEMPORADA 2010/2011
LIGA MALAUI
Equipo PJ GF GC Puntos
1 ESCOM United ESCOM United 28 58 21 58
2 Silver Strikers Silver 28 45 23 54
3 Moyale Barracks Moyale 28 47 31 51
4 CIVO United CIVO United 28 34 19 50
5 Be Forward Wanderers Forward 28 43 32 46
6 Blue Eagles Blue Eagles 28 34 30 46
7 Big Bullets Big Bullets 28 29 26 41
8 Azam Tigers Azam Tigers 28 36 36 37
9 Zomba United Zomba United 28 36 42 35
10 Red Lions Red Lions 28 28 31 34
11 Blantyre United Blantyre 28 31 41 33
12 MAFCO MAFCO 28 31 45 28
13 Juke Box Juke Box 28 23 43 25
14 Blackpool Blackpool 28 22 39 24
15 Eagle Strikers Eagle 28 23 61 16

  USO DE MEMORIA  
6,701,232 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.1781
Total Execution Time  0.1795
  CADENA URL  
/historico/Bullets-Fc
  GET DATOS  
$_GET['/historico/Bullets-Fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0041  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 = 75728
0.0026  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 = 73329
0.0029  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 = 73331
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=15822 AND type_rel = 2
0.0046  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 15822 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0031  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 (254996,677601,1038875) ORDER BY n.cover_points DESC, update_date DESC
0.0053  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 = '15822' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 73331 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0031  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 = 75728 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0060  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=15822 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 (75728,73331) 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.0039  SELECT count(id) as num_players from rel_players WHERE league_id = 75728 AND teamId = 15822
0.0059  SELECT count(id) as num_players from rel_players WHERE league_id = 73331 AND teamId = 15822
0.0033  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 = 75728 AND t.round = 4 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0024  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 = '15822' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0022  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '15822' 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 = '15822' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 75728 WHERE rp.league_id = 75728 AND rp.teamId = 15822 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.0029  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 = 75728 WHERE rp.league_id = 75728 AND rp.teamId = 15822 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 75728 WHERE rp.league_id = 75728 AND rp.teamId = 15822 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0034  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 = 15822 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0036  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 = 75728 AND t.round = 4 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 = 71512 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038  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 = 66982 AND t.round = 31 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  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 = 55650 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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 `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 = 49427 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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 `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 = 43282 AND t.round = 30 ORDER BY team.conference 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 `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 = 38322 AND t.round = 27 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 `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 = 23638 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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 = 19458 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  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 = 14857 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038  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 = 3243 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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 = 24885 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0042  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 = 24887 AND t.round = 30 ORDER BY team.conference 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 `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 = 24889 AND t.round = 31 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC