4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Can Buxeres B
TEMPORADA 2022/2023
2ª CATALANA JUVENIL GRUPO 14
Equipo PJ GF GC Puntos
1 Horta C Horta C 24 151 28 63
2 Turó Peira Ccd A Turó Peira 24 161 38 60
3 Can Buxeres B Buxeres 23 202 29 56
4 Lloreda C Lloreda C 24 108 48 53
5 Congrés Club Esp B Congrés 24 114 25 49
6 Gran Pª Espany. Manigua B Gran Espany. 23 95 46 42
7 Poblet Nou A Poblet 24 104 52 41
8 Veterans Catalunya AF A Veterans 24 117 58 39
9 Vila Olimpica Club Esp. C Vila 23 75 72 33
10 Daumar Club A Daumar Club 24 105 130 29
11 Sant Ignasi C Sant Ignasi 25 47 105 20
12 Escola de Futbol Stoitchkov Escola 25 40 108 15
13 La Salle Bonanova CE B Salle 23 46 111 14
14 Montañesa D Montañesa 25 32 172 5
15 Hospitalense Atc B Hospitalense 23 11 255 1
TEMPORADA 2021/2022
1ª CATALANA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Vilanova Geltru CF A Vilanova 30 87 21 77
2 Can Buxeres B Buxeres 30 85 35 66
3 Castelldefels C Castelldefel 30 77 44 62
4 Sitges UE A Sitges UE A 28 68 41 52
5 Escola F Gava C B Escola Gava 27 59 49 48
6 Corbera A Corbera A 29 69 52 44
7 Fundacio E Atletic Vilafran Fundacio 26 62 52 41
8 San Mauro A San Mauro A 29 68 62 41
9 Sant Cugat Sesgarrigues Clu Sant Cugat. 28 61 65 39
10 Sant Vicenç Dels Horts Sant Vicenç 29 50 64 37
11 Base Marc Bartra A Base Marc B. 29 60 90 31
12 Ciudad Cooperativa A A Ciudad 29 61 88 27
13 Ribes A Ribes A 28 40 75 27
14 Sporting Gava 2013 Futbol A Sporting 28 41 59 24
15 Martorell B Martorell B 27 36 69 20
16 Arrabal Calaf Gramanet B Arrabal 27 50 108 14
TEMPORADA 2020/2021
1ª CATALANA JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Vista Alegre A Vista Alegre 1 4 2 3
2 Atletic Sant Just B Atletic Sant 1 2 0 3
3 Castelldefels B Castelldefel 1 3 2 3
4 Fundacio Unio Esportiva Cor Fundacio 1 2 1 3
5 Santfeliuenc A A Santfeliuenc 1 1 0 3
6 Viladecans A A Viladecans 1 1 1 1
7 Can Vidalet B B Vidalet 1 1 1 1
8 Fontsanta-Fatjo A Fontsanta-Fa 0 0 0 0
9 Espluguenc Fa A A Espluguenc 0 0 0 0
10 Palleja A Palleja A 0 0 0 0
11 Prat B B Prat B B 0 0 0 0
12 Sant Ildefons B B Sant 1 2 3 0
13 Martorelles A A Martorelles 1 1 2 0
14 Can Buxeres B Buxeres 1 0 1 0
15 Vinyets Moli-Vell A Vinyets 1 2 4 0
16 Barcelonista Terlenka CF Barcelonista 1 0 2 0
TEMPORADA 2019/2020
1ª CATALANA JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Sant Ildefons B B Sant 18 45 24 38
2 Martorelles A A Martorelles 18 56 34 36
3 Fundacio Unio Esportiva Cor Fundacio 18 51 33 33
4 Castelldefels B Castelldefel 18 35 26 32
5 Espluguenc Fa A A Espluguenc 18 36 23 31
6 Palleja A Palleja A 18 39 35 31
7 Prat B B Prat B B 18 38 28 29
8 Atletic Sant Just B Atletic Sant 18 28 32 26
9 Viladecans A A Viladecans 18 37 33 25
10 Corbera A Corbera A 18 38 37 23
11 Can Vidalet B B Vidalet 18 21 21 22
12 Barcelonista Terlenka CF Barcelonista 18 26 36 19
13 Vista Alegre A Vista Alegre 18 27 40 18
14 Santfeliuenc A A Santfeliuenc 18 21 45 17
15 Can Buxeres B Buxeres 18 33 51 15
16 Vinyets Moli-Vell A Vinyets 18 20 53 13
TEMPORADA 2018/2019
2ª CATALANA JUVENIL GRUPO 18
Equipo PJ GF GC Puntos
1 Turo Peira A Turo Peira 27 125 31 76
2 La Salut Pere Gol A Salut Pere 29 86 33 68
3 Bon Pastor Agrupacio Esport Pastor 29 93 44 60
4 Poblet Nou A Poblet 26 74 39 54
5 Arrabal Calaf Gramanet A Arrabal 25 76 38 50
6 Escuela Performance A Escuela 23 73 39 46
7 Young Talent Badalona Sud A Young Talent 29 75 63 46
8 Pª Barc Barcino B Pª Barc Ba. 29 58 56 38
9 Can Buxeres B Buxeres 27 40 48 31
10 Unificacio Ciutat Meridiana Unificacio 28 78 85 30
11 Santa Eulalia E Santa 27 49 82 28
12 Fundacio Jupiter E Fundacio 26 39 79 28
13 Cerro Club Deportivo A Cerro Club. 27 55 78 24
14 Valldoreix C Valldoreix 29 48 81 24
15 Sants D Sants D 28 44 115 22
16 Escola Ebrafa B Escola 27 24 126 7
TEMPORADA 2017/2018
2ª CATALANA JUVENIL GRUPO 15
Equipo PJ GF GC Puntos
1 Salesians Bosco-Horta A Salesians 26 81 28 64
2 Alzamora A Alzamora A 25 109 28 63
3 Can Buxeres B Buxeres 25 70 40 51
4 Sant Ignasi Club Esportiu B Sant Ignasi 26 77 49 49
5 Neurofutbol Club Futbol C Neurofutbol 26 68 53 43
6 Hospitalense Atc B Hospitalense 25 68 54 42
7 Trajana Penya Barc Sant Jus Trajana 26 70 52 35
8 Mercat Nou Magoria A Mercat 24 52 42 34
9 Barceloneta A Barceloneta 22 62 74 30
10 Poblet Nou A Poblet 24 40 75 25
11 Poble Sec Associació Futbol Poble 25 47 77 20
12 Parc C Parc C 25 31 79 19
13 EF Almogavers A Almogavers 25 28 100 15
14 Veterans Catalunya A Veterans 26 45 96 13
15 Bufala C Bufala C 4 9 10 4
16 Carmelo A Carmelo A 0 0 0 0
TEMPORADA 2016/2017
2ª CATALANA JUVENIL GRUPO 17
Equipo PJ GF GC Puntos
1 Neurofutbol Club Futbol A A Neurofutbol 26 152 17 78
2 Montañesa B Montañesa 26 102 36 65
3 Celtic A Celtic A 26 94 47 52
4 Sistrells A Sistrells A 25 76 51 51
5 Collblanc-Torrassa A Collblanc-To 26 69 57 45
6 Jupiter D Jupiter D 26 67 54 44
7 Fundacio Esport Hospitalet Fundacio 25 72 84 43
8 Can Buxeres B Buxeres 26 74 71 33
9 Santa Eulalia C Santa 25 69 74 28
10 Turo Peira B Turo Peira 26 70 76 27
11 La Florida La Florida 25 67 83 25
12 Unificació Ciutat Meridiana Unificació 26 74 125 19
13 Zona Franca A Zona Franca 26 28 127 9
14 Pujadas Pujadas 26 31 143 1
15 Piferrer A Piferrer A 0 0 0 0
16 Pubilla Casas C C Pubilla 0 0 0 0
TEMPORADA 2015/2016
2ª CATALANA JUVENIL GRUPO 17
Equipo PJ GF GC Puntos
1 Anguera B Anguera B 30 95 47 72
2 Sant Ildefons C Sant 29 113 45 70
3 L'hospitalet Centre Esports L'hospitalet 29 127 68 64
4 Manigua Manigua 30 123 74 58
5 Stoitchkov A Stoitchkov 30 102 65 58
6 Can Buxeres B Buxeres 29 68 52 57
7 Sistrells B Sistrells B 30 84 67 56
8 Collblanc-Torrassa B Collblanc-To 28 84 54 49
9 Trinidad A Trinidad A 27 82 67 38
10 Valldoreix B Valldoreix 29 84 93 32
11 Alzamora B Alzamora B 30 79 112 30
12 Parc C Parc C 29 66 97 29
13 La Florida La Florida 29 55 92 25
14 Piferrer A Piferrer A 29 60 108 20
15 Carmelo A Carmelo A 29 37 105 16
16 Bellvitge C Bellvitge C 25 14 127 3
TEMPORADA 2014/2015
2ª CATALANA JUVENIL GRUPO 14
Equipo PJ GF GC Puntos
1 Martinenc Sub 19 Martinenc 26 130 25 76
2 Sant Marti-Condal A Sant 26 104 37 63
3 Catalonia D Catalonia D 26 120 39 57
4 Sant Ignasi B Sant Ignasi 26 76 38 54
5 Collblanc-Torrassa B Collblanc-To 26 61 52 43
6 Parc B Parc B 26 62 40 40
7 La Salle Bonanova Salle 26 68 67 39
8 Can Buxeres B Buxeres 26 50 61 35
9 La Florida La Florida 26 54 88 28
10 Guinardo C Guinardo C 26 44 73 27
11 Barceloneta B Barceloneta 26 38 79 25
12 Cinc Copes B Cinc Copes 26 49 84 23
13 Montañesa B Montañesa 26 25 79 13
14 Hospitalense B Hospitalense 26 28 147 7
15 Hospitalet At. B Hospitalet 0 0 0 0
16 Pubilla Casas A Pubilla 0 0 0 0

  USO DE MEMORIA  
5,629,488 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.6787
Total Execution Time  0.6807
  CADENA URL  
/historico/Can-Buxeres-B-Juvenil
  GET DATOS  
$_GET['/historico/Can-Buxeres-B-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0152  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 = 'Can-Buxeres-B-Juvenil' 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.0160  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 = 'Can-Buxeres-B-Juvenil' 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.0146  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=24569 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  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=24569 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=24569 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149  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=24569 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=24569 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=24569 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0153  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=24569 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=24569 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=24569 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  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=24569 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0157  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 = 69798
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=24569 AND type_rel = 2
0.0147  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=746 AND type_rel = 3
0.0155  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 = '24569' ORDER BY l.year DESC,cat.coefficient DESC
0.0154  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 = '24569' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0163  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 = '24569' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0155  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 = 69798 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0161  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=24569 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0149  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 (69798,64549) 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_base WHERE league_id = 69798 AND teamId = 24569
0.0146  SELECT count(id) as num_players from rel_players_base WHERE league_id = 64549 AND teamId = 24569
0.0146  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 69798 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0147  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 = '24569' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '24569' 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 = '24569' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0154  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 = 24569 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0156  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_base` 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 = 69798 AND t.round = 26 ORDER BY team.conference ASC,t.position 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 `tables2022_base` 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 = 64549 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.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 `tables2021_base` 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 = 59232 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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_base` 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 = 52065 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.0165  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_base` 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 = 45762 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0171  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_base` 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 = 40192 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0175  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_base` 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 = 35536 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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_base` 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 = 17157 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 = 4791 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC