4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Jornada 1
06 Ago 16 Dundee UnitedDundee 1 - 1 Queen of the SouthQueen South 1
06 Ago 16 Ayr UnitedAyr United 0 - 2 Raith RoversRaith 1
06 Ago 16 St. MirrenSt. Mirren 1 - 1 Greenock MortonGreenock 2
06 Ago 16 Dunfermline Athletic FCDunfermline 4 - 3 DumbartonDumbarton 1
06 Ago 16 FalkirkFalkirk 1 - 2 Hibernian FCHibernian 1
Jornada 2
13 Ago 16 Raith RoversRaith 3 - 1 St. MirrenSt. Mirren ...
13 Ago 16 Queen of the SouthQueen South 4 - 1 Ayr UnitedAyr United ...
13 Ago 16 Hibernian FCHibernian 2 - 1 Dunfermline Athletic FCDunfermline ...
13 Ago 16 DumbartonDumbarton 1 - 0 Dundee UnitedDundee ...
13 Ago 16 Greenock MortonGreenock 1 - 1 FalkirkFalkirk ...
Jornada 3
20 Ago 16 Queen of the SouthQueen South 2 - 0 FalkirkFalkirk ...
20 Ago 16 Dundee UnitedDundee 3 - 0 Ayr UnitedAyr United ...
20 Ago 16 Greenock MortonGreenock 1 - 1 DumbartonDumbarton ...
20 Ago 16 St. MirrenSt. Mirren 0 - 2 Hibernian FCHibernian ...
20 Ago 16 Raith RoversRaith 2 - 0 Dunfermline Athletic FCDunfermline ...
Jornada 4
27 Ago 16 Hibernian FCHibernian 4 - 0 Greenock MortonGreenock ...
27 Ago 16 FalkirkFalkirk 1 - 0 DumbartonDumbarton ...
27 Ago 16 Ayr UnitedAyr United 1 - 1 St. MirrenSt. Mirren ...
27 Ago 16 Dunfermline Athletic FCDunfermline 0 - 1 Queen of the SouthQueen South ...
27 Ago 16 Dundee UnitedDundee 2 - 2 Raith RoversRaith ...
Jornada 5
10 Sep 16 Ayr UnitedAyr United 2 - 1 Greenock MortonGreenock ...
10 Sep 16 Raith RoversRaith 0 - 2 FalkirkFalkirk ...
10 Sep 16 Dunfermline Athletic FCDunfermline 1 - 3 Dundee UnitedDundee ...
10 Sep 16 DumbartonDumbarton 0 - 1 Hibernian FCHibernian ...
10 Sep 16 St. MirrenSt. Mirren 1 - 3 Queen of the SouthQueen South ...
Jornada 6
17 Sep 16 DumbartonDumbarton 1 - 1 St. MirrenSt. Mirren ...
17 Sep 16 FalkirkFalkirk 3 - 1 Dundee UnitedDundee ...
17 Sep 16 Greenock MortonGreenock 2 - 1 Dunfermline Athletic FCDunfermline ...
17 Sep 16 Queen of the SouthQueen South 3 - 1 Raith RoversRaith ...
17 Sep 16 Hibernian FCHibernian 1 - 2 Ayr UnitedAyr United 1
Jornada 7
24 Sep 16 Dundee UnitedDundee 2 - 1 Greenock MortonGreenock ...
24 Sep 16 Dunfermline Athletic FCDunfermline 4 - 3 St. MirrenSt. Mirren ...
24 Sep 16 FalkirkFalkirk 2 - 0 Ayr UnitedAyr United ...
24 Sep 16 Queen of the SouthQueen South 0 - 0 Hibernian FCHibernian ...
24 Sep 16 Raith RoversRaith 3 - 2 DumbartonDumbarton ...
Jornada 8
01 Oct 16 St. MirrenSt. Mirren 1 - 1 FalkirkFalkirk ...
01 Oct 16 Ayr UnitedAyr United 0 - 0 Dunfermline Athletic FCDunfermline ...
01 Oct 16 DumbartonDumbarton 0 - 0 Queen of the SouthQueen South ...
02 Oct 16 Hibernian FCHibernian 1 - 1 Dundee UnitedDundee 2
01 Oct 16 Greenock MortonGreenock 1 - 0 Raith RoversRaith ...
Jornada 9
15 Oct 16 St. MirrenSt. Mirren 0 - 2 Dundee UnitedDundee ...
15 Oct 16 DumbartonDumbarton 0 - 3 Ayr UnitedAyr United ...
15 Oct 16 FalkirkFalkirk 2 - 1 Dunfermline Athletic FCDunfermline ...
15 Oct 16 Queen of the SouthQueen South 0 - 5 Greenock MortonGreenock ...
15 Oct 16 Raith RoversRaith 0 - 0 Hibernian FCHibernian ...
Jornada 10
01 Nov 16 Greenock MortonGreenock 3 - 1 St. MirrenSt. Mirren ...
22 Oct 16 Ayr UnitedAyr United 1 - 0 Queen of the SouthQueen South ...
22 Oct 16 Dundee UnitedDundee 2 - 1 DumbartonDumbarton ...
22 Oct 16 Dunfermline Athletic FCDunfermline 1 - 3 Hibernian FCHibernian ...
22 Oct 16 FalkirkFalkirk 2 - 4 Raith RoversRaith ...
Jornada 11
29 Oct 16 Greenock MortonGreenock 2 - 1 Ayr UnitedAyr United ...
29 Oct 16 Hibernian FCHibernian 2 - 0 St. MirrenSt. Mirren ...
29 Oct 16 DumbartonDumbarton 2 - 2 Dunfermline Athletic FCDunfermline ...
29 Oct 16 Dundee UnitedDundee 1 - 0 FalkirkFalkirk ...
29 Oct 16 Raith RoversRaith 1 - 0 Queen of the SouthQueen South ...
Jornada 12
05 Nov 16 Queen of the SouthQueen South 1 - 4 Dundee UnitedDundee ...
05 Nov 16 FalkirkFalkirk 1 - 1 Greenock MortonGreenock ...
05 Nov 16 St. MirrenSt. Mirren 0 - 1 DumbartonDumbarton ...
05 Nov 16 Ayr UnitedAyr United 0 - 3 Hibernian FCHibernian ...
05 Nov 16 Dunfermline Athletic FCDunfermline 0 - 0 Raith RoversRaith ...
Jornada 13
12 Nov 16 Hibernian FCHibernian 1 - 1 FalkirkFalkirk 7
12 Nov 16 DumbartonDumbarton 0 - 2 Greenock MortonGreenock ...
08 Nov 16 Dundee UnitedDundee 1 - 0 Dunfermline Athletic FCDunfermline 84
06 Dic 16 Queen of the SouthQueen South 2 - 3 St. MirrenSt. Mirren ...
22 Nov 16 Raith RoversRaith 1 - 1 Ayr UnitedAyr United ...
Jornada 14
19 Nov 16 St. MirrenSt. Mirren 0 - 1 Dunfermline Athletic FCDunfermline ...
19 Nov 16 Ayr UnitedAyr United 0 - 1 FalkirkFalkirk ...
19 Nov 16 DumbartonDumbarton 0 - 0 Raith RoversRaith ...
19 Nov 16 Hibernian FCHibernian 4 - 0 Queen of the SouthQueen South ...
19 Nov 16 Greenock MortonGreenock 0 - 0 Dundee UnitedDundee ...
Jornada 15
03 Dic 16 FalkirkFalkirk 3 - 1 St. MirrenSt. Mirren ...
02 Dic 16 Dundee UnitedDundee 1 - 0 Hibernian FCHibernian ...
03 Dic 16 Dunfermline Athletic FCDunfermline 1 - 1 Ayr UnitedAyr United ...
03 Dic 16 Queen of the SouthQueen South 1 - 2 DumbartonDumbarton ...
07 Feb 17 Raith RoversRaith 0 - 1 Greenock MortonGreenock 5
Jornada 16
10 Dic 16 St. MirrenSt. Mirren 1 - 0 Raith RoversRaith ...
10 Dic 16 Ayr UnitedAyr United 0 - 1 Dundee UnitedDundee ...
10 Dic 16 Dunfermline Athletic FCDunfermline 2 - 1 Greenock MortonGreenock ...
10 Dic 16 FalkirkFalkirk 2 - 2 Queen of the SouthQueen South ...
10 Dic 16 Hibernian FCHibernian 2 - 0 DumbartonDumbarton ...
Jornada 17
17 Dic 16 Queen of the SouthQueen South 2 - 2 Dunfermline Athletic FCDunfermline ...
17 Dic 16 Greenock MortonGreenock 1 - 1 Hibernian FCHibernian ...
17 Dic 16 DumbartonDumbarton 2 - 1 FalkirkFalkirk ...
17 Dic 16 St. MirrenSt. Mirren 1 - 1 Ayr UnitedAyr United ...
17 Dic 16 Raith RoversRaith 0 - 0 Dundee UnitedDundee ...
Jornada 18
24 Dic 16 Ayr UnitedAyr United 4 - 4 DumbartonDumbarton 3
24 Dic 16 Dundee UnitedDundee 2 - 1 St. MirrenSt. Mirren 3
26 Dic 16 Dunfermline Athletic FCDunfermline 1 - 1 FalkirkFalkirk 1
24 Dic 16 Hibernian FCHibernian 1 - 1 Raith RoversRaith 19
24 Dic 16 Greenock MortonGreenock 1 - 0 Queen of the SouthQueen South ...
Jornada 19
31 Dic 16 FalkirkFalkirk 1 - 2 Hibernian FCHibernian 3
31 Dic 16 St. MirrenSt. Mirren 1 - 1 Greenock MortonGreenock ...
31 Dic 16 DumbartonDumbarton 1 - 0 Dundee UnitedDundee 7
31 Dic 16 Queen of the SouthQueen South 0 - 0 Ayr UnitedAyr United 1
02 Ene 17 Raith RoversRaith 0 - 2 Dunfermline Athletic FCDunfermline 3
Jornada 20
07 Ene 17 Greenock MortonGreenock 2 - 1 DumbartonDumbarton ...
07 Ene 17 St. MirrenSt. Mirren 0 - 3 Queen of the SouthQueen South ...
07 Ene 17 Ayr UnitedAyr United 0 - 2 Dunfermline Athletic FCDunfermline ...
06 Ene 17 Hibernian FCHibernian 3 - 0 Dundee UnitedDundee 33
07 Ene 17 Raith RoversRaith 1 - 4 FalkirkFalkirk ...
Jornada 21
14 Ene 17 DumbartonDumbarton 0 - 1 Hibernian FCHibernian ...
14 Ene 17 Dundee UnitedDundee 3 - 3 Queen of the SouthQueen South 4
14 Ene 17 Dunfermline Athletic FCDunfermline 1 - 1 St. MirrenSt. Mirren ...
14 Ene 17 FalkirkFalkirk 1 - 1 Ayr UnitedAyr United ...
14 Ene 17 Greenock MortonGreenock 2 - 0 Raith RoversRaith ...
Jornada 22
28 Ene 17 Ayr UnitedAyr United 1 - 4 Greenock MortonGreenock ...
28 Ene 17 St. MirrenSt. Mirren 1 - 2 FalkirkFalkirk ...
28 Ene 17 Dunfermline Athletic FCDunfermline 1 - 1 Dundee UnitedDundee ...
28 Ene 17 Queen of the SouthQueen South 0 - 1 Hibernian FCHibernian ...
28 Ene 17 Raith RoversRaith 1 - 3 DumbartonDumbarton ...
Jornada 23
04 Feb 17 Dundee UnitedDundee 3 - 0 Raith RoversRaith ...
04 Feb 17 DumbartonDumbarton 2 - 2 St. MirrenSt. Mirren ...
04 Feb 17 FalkirkFalkirk 2 - 0 Dunfermline Athletic FCDunfermline ...
04 Feb 17 Hibernian FCHibernian 1 - 1 Ayr UnitedAyr United 3
04 Feb 17 Queen of the SouthQueen South 3 - 0 Greenock MortonGreenock ...
Jornada 24
18 Feb 17 Greenock MortonGreenock 2 - 2 FalkirkFalkirk ...
15 Mar 17 St. MirrenSt. Mirren 3 - 2 Dundee UnitedDundee 14
18 Feb 17 DumbartonDumbarton 2 - 2 Ayr UnitedAyr United ...
07 Mar 17 Dunfermline Athletic FCDunfermline 1 - 1 Queen of the SouthQueen South 1
18 Feb 17 Raith RoversRaith 1 - 1 Hibernian FCHibernian ...
Jornada 25
25 Feb 17 Hibernian FCHibernian 2 - 2 Dunfermline Athletic FCDunfermline ...
25 Feb 17 FalkirkFalkirk 2 - 2 DumbartonDumbarton ...
25 Feb 17 Ayr UnitedAyr United 0 - 2 St. MirrenSt. Mirren ...
25 Feb 17 Dundee UnitedDundee 1 - 1 Greenock MortonGreenock ...
25 Feb 17 Queen of the SouthQueen South 2 - 1 Raith RoversRaith ...
Jornada 26
01 Mar 17 St. MirrenSt. Mirren 2 - 0 Hibernian FCHibernian 8
28 Feb 17 Ayr UnitedAyr United 1 - 0 Raith RoversRaith ...
21 Ene 17 DumbartonDumbarton 1 - 2 Queen of the SouthQueen South ...
11 Feb 17 FalkirkFalkirk 3 - 0 Dundee UnitedDundee ...
25 Mar 17 Greenock MortonGreenock 0 - 1 Dunfermline Athletic FCDunfermline 1
Jornada 27
29 Mar 17 Hibernian FCHibernian 0 - 0 Greenock MortonGreenock 14
28 Mar 17 Dundee UnitedDundee 2 - 1 Ayr UnitedAyr United 7
04 Mar 17 Dunfermline Athletic FCDunfermline 5 - 1 DumbartonDumbarton ...
04 Mar 17 Queen of the SouthQueen South 0 - 2 FalkirkFalkirk ...
08 Mar 17 Raith RoversRaith 2 - 0 St. MirrenSt. Mirren 15
Jornada 28
11 Mar 17 St. MirrenSt. Mirren 0 - 0 Dunfermline Athletic FCDunfermline ...
11 Mar 17 Ayr UnitedAyr United 1 - 4 FalkirkFalkirk ...
11 Mar 17 DumbartonDumbarton 4 - 0 Raith RoversRaith ...
10 Mar 17 Dundee UnitedDundee 0 - 1 Hibernian FCHibernian 1
11 Mar 17 Greenock MortonGreenock 1 - 0 Queen of the SouthQueen South ...
Jornada 29
18 Mar 17 FalkirkFalkirk 0 - 1 Greenock MortonGreenock ...
18 Mar 17 Dunfermline Athletic FCDunfermline 0 - 1 Ayr UnitedAyr United ...
18 Mar 17 Hibernian FCHibernian 2 - 2 DumbartonDumbarton ...
18 Mar 17 Queen of the SouthQueen South 0 - 2 St. MirrenSt. Mirren ...
18 Mar 17 Raith RoversRaith 2 - 1 Dundee UnitedDundee 1
Jornada 30
11 Abr 17 Greenock MortonGreenock 1 - 4 St. MirrenSt. Mirren 10
25 Mar 17 Hibernian FCHibernian 2 - 1 FalkirkFalkirk 2
25 Mar 17 Ayr UnitedAyr United 2 - 1 DumbartonDumbarton ...
11 Abr 17 Dundee UnitedDundee 1 - 0 Dunfermline Athletic FCDunfermline 6
25 Mar 17 Raith RoversRaith 1 - 1 Queen of the SouthQueen South ...
Jornada 31
01 Abr 17 Dunfermline Athletic FCDunfermline 1 - 1 Hibernian FCHibernian ...
01 Abr 17 DumbartonDumbarton 1 - 0 Greenock MortonGreenock ...
01 Abr 17 St. MirrenSt. Mirren 6 - 2 Ayr UnitedAyr United ...
01 Abr 17 FalkirkFalkirk 1 - 0 Raith RoversRaith ...
01 Abr 17 Queen of the SouthQueen South 4 - 2 Dundee UnitedDundee ...
Jornada 32
08 Abr 17 Greenock MortonGreenock 1 - 1 Hibernian FCHibernian 1
08 Abr 17 St. MirrenSt. Mirren 1 - 1 DumbartonDumbarton ...
08 Abr 17 Ayr UnitedAyr United 0 - 2 Queen of the SouthQueen South ...
08 Abr 17 Dundee UnitedDundee 1 - 1 FalkirkFalkirk ...
08 Abr 17 Dunfermline Athletic FCDunfermline 1 - 0 Raith RoversRaith ...
Jornada 33
15 Abr 17 Hibernian FCHibernian 3 - 0 Queen of the SouthQueen South ...
15 Abr 17 FalkirkFalkirk 2 - 2 St. MirrenSt. Mirren ...
15 Abr 17 Ayr UnitedAyr United 0 - 0 Dundee UnitedDundee ...
15 Abr 17 DumbartonDumbarton 0 - 2 Dunfermline Athletic FCDunfermline ...
15 Abr 17 Raith RoversRaith 2 - 0 Greenock MortonGreenock ...
Jornada 34
22 Abr 17 Dundee UnitedDundee 3 - 2 St. MirrenSt. Mirren ...
22 Abr 17 Dunfermline Athletic FCDunfermline 1 - 2 FalkirkFalkirk ...
22 Abr 17 Queen of the SouthQueen South 1 - 2 DumbartonDumbarton ...
26 Abr 17 Hibernian FCHibernian 3 - 2 Raith RoversRaith 3
22 Abr 17 Greenock MortonGreenock 1 - 1 Ayr UnitedAyr United ...
Jornada 35
29 Abr 17 St. MirrenSt. Mirren 5 - 0 Raith RoversRaith ...
29 Abr 17 Ayr UnitedAyr United 0 - 4 Hibernian FCHibernian ...
29 Abr 17 Dundee UnitedDundee 2 - 2 DumbartonDumbarton ...
29 Abr 17 Dunfermline Athletic FCDunfermline 3 - 1 Greenock MortonGreenock ...
29 Abr 17 FalkirkFalkirk 2 - 2 Queen of the SouthQueen South 1
Jornada 36
06 May 17 Hibernian FCHibernian 1 - 1 St. MirrenSt. Mirren ...
06 May 17 DumbartonDumbarton 0 - 1 FalkirkFalkirk ...
06 May 17 Greenock MortonGreenock 1 - 1 Dundee UnitedDundee ...
06 May 17 Queen of the SouthQueen South 0 - 1 Dunfermline Athletic FCDunfermline ...
06 May 17 Raith RoversRaith 2 - 1 Ayr UnitedAyr United ...

Clasificación

Equipo PJ GF GC Puntos
1 Hibernian FC Hibernian 36 59 25 71
2 Falkirk Falkirk 36 58 40 60
3 Dundee United Dundee 36 50 42 57
4 Greenock Morton Greenock 36 44 41 52
5 Dunfermline Athletic FC Dunfermline 36 46 43 48
6 Queen of the South Queen South 36 46 52 43
7 St. Mirren St. Mirren 36 52 56 39
8 Dumbarton Dumbarton 36 46 56 39
9 Raith Rovers Raith Rovers 36 35 52 39
10 Ayr United Ayr United 36 33 62 33

  USO DE MEMORIA  
6,082,752 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4307
Total Execution Time  0.4326
  CADENA URL  
/first_division2017/grupo1/calendario
  GET DATOS  
$_GET['/first_division2017/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0150  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=23 AND type_rel = 3
0.0165  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 23 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0162  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 (1295871,1258541,1098388,1098049,908352) ORDER BY n.cover_points DESC, update_date DESC
0.0149  SELECT id,name,alias,stepParent FROM categories WHERE parentId=23 ORDER BY order_id ASC
0.0159  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 23 GROUP BY l.categoryId
0.0161  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=23 GROUP BY l.year ORDER BY l.year DESC
0.0322  SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2, dt1.stadium as stadium_name FROM calendars2017 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 33316 ORDER BY round ASC
0.0149  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-04 05:38:08' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-04 05:38:08' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0148  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-04 05:38:08' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0148  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-04 05:38:08' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0346  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2017 e ON e.player_id = p.id AND e.league_id = 33316 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 33316 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0219  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2017 e ON e.player_id = p.id AND e.league_id = 33316 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 33316 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0154  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2017 e ON e.player_id = p.id AND e.league_id = 33316 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 33316 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0158  SELECT *,(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 = 33316 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC