4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Unificació Llefià
TEMPORADA 2023/2024
PRIMERA CATALANA GRUPO 2
Equipo PJ GF GC Puntos
1 San Mauro San Mauro 27 59 19 64
2 Martinenc Martinenc 27 47 21 56
3 San Juan At. M. Juan 27 57 34 54
4 Pirinaica Pirinaica 27 30 20 45
5 Júpiter Júpiter 27 34 30 43
6 Castellar Castellar 27 48 43 39
7 Borges Blanques Borges 27 41 38 38
8 Sant Cugat Sant Cugat 27 41 31 37
9 Artesa de Segre Artesa Segre 27 22 41 35
10 Igualada Igualada 27 36 32 32
11 Artesa Lleida CF Artesa 27 29 31 31
12 Turó Peira Turó Peira 27 24 41 31
13 Joanenc Joanenc 27 36 49 29
14 Unificació Llefià Unificació 27 31 45 28
15 Tàrrega Tàrrega 27 24 50 20
16 Alguaire CE Alguaire CE 27 17 51 18
TEMPORADA 2022/2023
PRIMERA CATALANA GRUPO 2
Equipo PJ GF GC Puntos
1 CFJ Mollerussa Mollerussa 30 58 22 71
2 Rubí Rubí 30 66 39 63
3 Atlètic Lleida Atlètic 30 49 35 54
4 Sabadell B Sabadell B 30 57 39 50
5 Guineueta Guineueta 30 41 32 49
6 UA Horta UA Horta 30 37 43 45
7 Unificació Llefià Unificació 30 38 38 45
8 Sant Cugat Sant Cugat 30 55 55 40
9 Martinenc Martinenc 30 45 45 38
10 San Mauro San Mauro 30 45 43 37
11 Igualada Igualada 30 42 34 36
12 Pirinaica Pirinaica 30 35 48 32
13 Turó Peira Turó Peira 30 43 56 29
14 Tàrrega Tàrrega 30 33 73 26
15 Balaguer Balaguer 30 30 49 23
16 At. Alpicat At. Alpicat 30 31 54 23
TEMPORADA 2021/2022
PRIMERA CATALANA GRUPO 1
Equipo PJ GF GC Puntos
1 Montañesa Montañesa 26 48 25 53
2 Lloret Lloret 26 52 34 45
3 L'Escala L'Escala 26 47 33 42
4 Mollet Mollet 26 33 24 40
5 Mataró Mataró 26 38 32 40
6 Parets Parets 26 41 35 39
7 Bescanó Bescanó 26 32 36 38
8 Palamós Palamós 26 42 36 35
9 Unificació Llefià Unificació 26 36 36 35
10 Banyoles Banyoles 26 25 30 33
11 Martinenc Martinenc 26 26 33 32
12 Les Franqueses Franqueses 26 39 41 31
13 Llagostera B Llagostera 26 24 48 28
14 La Jonquera UE Jonquera 26 18 58 12
TEMPORADA 2020/2021
PRIMERA CATALANA GRUPO 2
Equipo PJ GF GC Puntos
1 Guineueta Guineueta 18 32 14 37
2 Sant Cugat Sant Cugat 18 32 13 34
3 Les Franqueses Franqueses 18 17 13 31
4 Mataró Mataró 18 25 22 28
5 Unificació Llefià Unificació 18 27 25 26
6 Mollet Mollet 18 25 19 25
7 Rubí Rubí 18 34 35 25
8 Júpiter Júpiter 18 20 32 17
9 Sabadell Nord Sabadell 18 18 35 17
10 Parets Parets 18 14 36 12
TEMPORADA 2019/2020
2ª CATALANA GRUPO 2
Equipo PJ GF GC Puntos
1 Unificació Llefià Unificació 23 43 23 49
2 At. Sant Pol Sant 23 47 22 45
3 San Juan At. M. Juan 23 31 22 44
4 Turó Peira Turó Peira 23 41 26 40
5 Europa B Europa B 23 39 30 39
6 Masnou Masnou 23 40 34 39
7 Premià Premià 23 48 31 38
8 Molletense Molletense 23 35 35 37
9 Parc Parc 23 35 35 35
10 Cirera Cirera 23 32 31 33
11 Racing Vallbona Racing 23 29 34 29
12 Argentona Argentona 23 45 42 28
13 UDA Gramanet Gramanet 23 32 39 28
14 UCF Santa Perpètua Santa 23 34 37 27
15 Sarrià Sarrià 23 31 38 26
16 Molinos Molinos 23 28 43 18
17 Montcada Montcada 23 23 57 13
18 Canyelles Canyelles 23 25 59 8
TEMPORADA 2018/2019
2ª CATALANA GRUPO 2
Equipo PJ GF GC Puntos
1 Mataró Mataró 34 83 37 75
2 Mollet Mollet 34 69 30 72
3 Turó Peira Turó Peira 34 75 37 68
4 Montcada Montcada 34 56 45 56
5 Europa B Europa B 34 53 37 52
6 Valldoreix Valldoreix 34 61 53 52
7 Premià Premià 34 56 40 51
8 Sarrià Sarrià 34 51 50 48
9 Unificació Llefià Unificació 34 55 57 48
10 Molletense Molletense 34 37 43 46
11 Parc Parc 34 41 54 44
12 Canyelles Canyelles 34 52 76 44
13 At. Sant Pol Sant 34 40 62 38
14 Pubilla Casas Pubilla 34 49 75 35
15 Young Talent Badalona Young Talent 34 42 60 32
16 Sant Andreu Atlètic Sant Andreu 34 44 57 32
17 Singuerlin CF Singuerlin 34 50 76 29
18 Besòs Barón de Viver Besòs 34 32 57 27
TEMPORADA 2017/2018
2ª CATALANA GRUPO 2
Equipo PJ GF GC Puntos
1 Guineueta Guineueta 34 69 26 75
2 Argentona Argentona 34 77 33 70
3 Mataró Mataró 34 78 34 69
4 Europa B Europa B 34 86 35 65
5 Unificació Llefià Unificació 34 61 42 62
6 At. Sant Pol Sant 34 59 32 61
7 Sarrià Sarrià 34 60 46 56
8 Masnou Masnou 34 52 42 55
9 Besòs Barón de Viver Besòs 34 55 51 50
10 Canyelles Canyelles 34 70 63 49
11 Sant Andreu Atlètic Sant Andreu 34 72 72 47
12 Parc Parc 34 45 50 41
13 Montcada Montcada 34 48 50 40
14 Sant Andreu de la Barca Sant Andreu 34 55 72 38
15 Hermes A Hermes A 34 56 76 32
16 Piferrer At. Piferrer 34 29 99 18
17 Llavaneres Llavaneres 34 30 94 16
18 Sant Adrià Sant Adrià 34 21 106 7
TEMPORADA 2016/2017
2ª CATALANA GRUPO 2
Equipo PJ GF GC Puntos
1 FE Grama FE Grama 34 79 30 71
2 Mataró Mataró 34 76 33 69
3 Guineueta Guineueta 34 85 47 63
4 Unificació Llefià Unificació 34 75 47 63
5 Europa B Europa B 34 57 45 54
6 Premià Premià 34 50 42 52
7 At. Sant Pol Sant 34 57 53 50
8 Sant Adrià Sant Adrià 34 57 57 50
9 Sarrià Sarrià 34 59 49 48
10 Canyelles Canyelles 34 54 66 48
11 Besòs Barón de Viver Besòs 34 66 61 47
12 Llavaneres Llavaneres 34 53 61 42
13 Lloreda Lloreda 34 46 70 38
14 Martinenc B Martinenc B 34 48 55 37
15 Cirera Cirera 34 41 50 34
16 Badia del Vallès Badia 34 46 77 33
17 Carmelo CD Carmelo CD 34 44 84 24
18 EJ Can Pi EJ Can Pi 34 42 108 19
TEMPORADA 2015/2016
2ª CATALANA GRUPO 2
Equipo PJ GF GC Puntos
1 San Juan At. M. Juan 34 78 36 72
2 Hermes A Hermes A 34 74 38 72
3 Premia CE Premia CE 34 65 27 68
4 Unificació Llefià Unificació 34 62 49 62
5 At. Sant Pol Sant 34 57 34 55
6 Besòs Barón de Viver Besòs 34 65 45 54
7 Guineueta Guineueta 34 63 66 51
8 Carmelo CD Carmelo CD 34 63 66 49
9 Europa B Europa B 34 56 51 48
10 Lloreda Lloreda 34 56 62 44
11 Canyelles Canyelles 34 55 55 43
12 Cirera Cirera 34 57 62 41
13 Martinenc B Martinenc B 34 40 62 40
14 Montcada Montcada 34 38 52 38
15 Mataronesa Mataronesa 34 49 64 36
16 La Llàntia La Llàntia 34 50 68 31
17 UDA Gramanet Gramanet 34 41 75 29
18 Ce Tecnofutbol Tecnofutbol 34 48 105 16
TEMPORADA 2014/2015
2ª CATALANA GRUPO 2
Equipo PJ GF GC Puntos
1 Mataró Mataró 34 84 35 80
2 Premia CE Premia CE 34 59 43 63
3 San Juan At. M. Juan 34 65 41 62
4 Ripollet Ripollet 34 65 49 62
5 Guineueta Guineueta 34 70 52 58
6 Unificació Llefià Unificació 34 53 38 56
7 Cirera Cirera 34 61 56 49
8 Equipo Ja CF Equipo 34 65 64 49
9 Olímpic Can Fatjó Olímpic 34 52 46 47
10 Lloreda Lloreda 34 49 49 46
11 Canyelles Canyelles 34 62 72 46
12 Carmelo CD Carmelo CD 34 46 55 40
13 At. Sant Pol Sant 34 47 48 39
14 Singuerlin CF Singuerlin 34 59 66 36
15 Catalonia UB Catalonia 34 43 71 36
16 Sarrià Sarrià 34 50 66 35
17 Catalana UD Catalana UD 34 31 68 22
18 Dinamic Batllo Esportiu Dinamic 34 23 65 17
TEMPORADA 2013/2014
PRIMERA CATALANA GRUPO 1
Equipo PJ GF GC Puntos
1 CF Peralada CF Peralada 34 63 21 78
2 Sabadell B Sabadell B 34 70 35 73
3 Girona FC B Girona FC B 34 61 35 63
4 UE Vic UE Vic 34 53 42 56
5 Farners Farners 34 51 47 51
6 EC Granollers Granollers 34 60 48 50
7 Júpiter Júpiter 34 57 56 46
8 Banyoles Banyoles 34 50 51 46
9 Montcada Montcada 34 37 45 46
10 Mollet Mollet 34 53 53 44
11 Avià Avià 34 39 48 42
12 Lloret Lloret 34 50 52 41
13 Vilassar Dalt Vilassar 34 45 51 41
14 La Jonquera UE Jonquera 34 33 51 40
15 Unificació Llefià Unificació 34 46 59 36
16 Guíxols Guíxols 34 48 56 34
17 Canyelles Canyelles 34 56 73 33
18 CP San Cristóbal Cristóbal 34 34 83 24

  USO DE MEMORIA  
6,169,232 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1040
Total Execution Time  0.1052
  CADENA URL  
/historico/Uni-Lleifia-Cf
  GET DATOS  
$_GET['/historico/Uni-Lleifia-Cf']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
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 = 'Uni-Lleifia-Cf' 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=11945 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=11945 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=11945 AND type_rel = 2
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 11945 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0020  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 (122029) ORDER BY n.cover_points DESC, update_date DESC
0.0022  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 = '11945' ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '11945' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '11945' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 72879 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=11945 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 (72879) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 72879 AND teamId = 11945
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 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 = 72879 AND t.round = 27 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 = '11945' 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 = '11945' and rp.type = 4
0.0019  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 = '11945' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0031  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 = 72879 WHERE rp.league_id = 72879 AND rp.teamId = 11945 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 = 72879 WHERE rp.league_id = 72879 AND rp.teamId = 11945 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 72879 WHERE rp.league_id = 72879 AND rp.teamId = 11945 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 11945 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0022  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 = 68553 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.0022  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 = 63408 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.0020  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 = 58715 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.0022  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 = 50600 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 44410 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 38994 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 33986 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 16673 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 3949 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 2673 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC