4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Jornada 1
26 Ago 14 SamguraliSamgurali 5 - 1 AdeliAdeli ...
25 Ago 14 LazikaLazika 4 - 2 Sakartvelos TUSakartvelos ...
25 Ago 14 Locomotive TbilisiLocomotive 2 - 0 ChkherimelaChkherimela ...
25 Ago 14 ChiaturaChiatura 0 - 1 Sasco TiblisiSasco ...
25 Ago 14 FC Iberia 1999Iberia 1999 4 - 1 MatchakhelaMatchakhela ...
Jornada 2
30 Ago 14 AdeliAdeli 0 - 7 FC Iberia 1999Iberia 1999 ...
31 Ago 14 Sakartvelos TUSakartvelos 3 - 2 ChiaturaChiatura ...
31 Ago 14 Locomotive TbilisiLocomotive 3 - 2 SamguraliSamgurali ...
31 Ago 14 MatchakhelaMatchakhela 1 - 5 LazikaLazika ...
31 Ago 14 ChkherimelaChkherimela 0 - 0 Sasco TiblisiSasco ...
Jornada 3
05 Sep 14 ChiaturaChiatura 3 - 1 MatchakhelaMatchakhela ...
17 Sep 14 FC Iberia 1999Iberia 1999 3 - 0 Locomotive TbilisiLocomotive ...
05 Sep 14 Sasco TiblisiSasco 1 - 3 Sakartvelos TUSakartvelos ...
05 Sep 14 LazikaLazika 1 - 0 AdeliAdeli ...
05 Sep 14 SamguraliSamgurali 2 - 0 ChkherimelaChkherimela ...
Jornada 4
11 Sep 14 SamguraliSamgurali 1 - 2 FC Iberia 1999Iberia 1999 ...
11 Sep 14 AdeliAdeli 2 - 3 ChiaturaChiatura ...
11 Sep 14 ChkherimelaChkherimela 1 - 2 Sakartvelos TUSakartvelos ...
11 Sep 14 Locomotive TbilisiLocomotive 0 - 0 LazikaLazika ...
11 Sep 14 MatchakhelaMatchakhela 1 - 1 Sasco TiblisiSasco ...
Jornada 5
22 Sep 14 ChiaturaChiatura 3 - 1 Locomotive TbilisiLocomotive ...
22 Sep 14 FC Iberia 1999Iberia 1999 2 - 0 ChkherimelaChkherimela ...
22 Sep 14 Sakartvelos TUSakartvelos 2 - 1 MatchakhelaMatchakhela ...
21 Sep 14 LazikaLazika 1 - 0 SamguraliSamgurali ...
21 Sep 14 Sasco TiblisiSasco 2 - 2 AdeliAdeli ...
Jornada 6
26 Sep 14 SamguraliSamgurali 2 - 1 ChiaturaChiatura ...
01 Oct 14 AdeliAdeli 2 - 0 Sakartvelos TUSakartvelos ...
26 Sep 14 FC Iberia 1999Iberia 1999 2 - 0 LazikaLazika ...
26 Sep 14 Locomotive TbilisiLocomotive 3 - 2 Sasco TiblisiSasco ...
26 Sep 14 ChkherimelaChkherimela 1 - 0 MatchakhelaMatchakhela ...
Jornada 7
06 Oct 14 MatchakhelaMatchakhela 2 - 1 AdeliAdeli 1
06 Oct 14 Sasco TiblisiSasco 4 - 2 SamguraliSamgurali 1
06 Oct 14 LazikaLazika 5 - 0 ChkherimelaChkherimela 1
06 Oct 14 Sakartvelos TUSakartvelos 2 - 0 Locomotive TbilisiLocomotive 1
24 Nov 14 ChiaturaChiatura 1 - 0 FC Iberia 1999Iberia 1999 1
Jornada 8
24 Oct 14 FC Iberia 1999Iberia 1999 5 - 1 Sasco TiblisiSasco ...
10 Oct 14 Locomotive TbilisiLocomotive 0 - 2 MatchakhelaMatchakhela ...
10 Oct 14 LazikaLazika 1 - 1 ChiaturaChiatura ...
10 Oct 14 SamguraliSamgurali 5 - 0 Sakartvelos TUSakartvelos ...
10 Oct 14 ChkherimelaChkherimela 2 - 1 AdeliAdeli ...
Jornada 9
15 Oct 14 ChiaturaChiatura 1 - 0 ChkherimelaChkherimela ...
15 Oct 14 MatchakhelaMatchakhela 3 - 1 SamguraliSamgurali ...
15 Oct 14 Sasco TiblisiSasco 1 - 1 LazikaLazika ...
15 Oct 14 AdeliAdeli 0 - 6 Locomotive TbilisiLocomotive ...
16 Oct 14 Sakartvelos TUSakartvelos 2 - 3 FC Iberia 1999Iberia 1999 ...
Jornada 10
19 Oct 14 Sasco TiblisiSasco 2 - 5 ChiaturaChiatura ...
20 Oct 14 MatchakhelaMatchakhela 1 - 2 FC Iberia 1999Iberia 1999 ...
21 Oct 14 ChkherimelaChkherimela 0 - 6 Locomotive TbilisiLocomotive ...
21 Oct 14 Sakartvelos TUSakartvelos 3 - 2 LazikaLazika ...
21 Oct 14 AdeliAdeli 3 - 2 SamguraliSamgurali ...
Jornada 11
28 Oct 14 FC Iberia 1999Iberia 1999 6 - 0 AdeliAdeli ...
27 Oct 14 ChiaturaChiatura 4 - 0 Sakartvelos TUSakartvelos ...
27 Oct 14 SamguraliSamgurali 3 - 3 Locomotive TbilisiLocomotive ...
27 Oct 14 LazikaLazika 4 - 1 MatchakhelaMatchakhela ...
28 Oct 14 Sasco TiblisiSasco 7 - 0 ChkherimelaChkherimela ...
Jornada 12
24 Nov 14 ChkherimelaChkherimela 1 - 3 SamguraliSamgurali ...
08 Dic 14 MatchakhelaMatchakhela 0 - 3 ChiaturaChiatura ...
03 Nov 14 Locomotive TbilisiLocomotive 1 - 3 FC Iberia 1999Iberia 1999 ...
03 Nov 14 Sakartvelos TUSakartvelos 2 - 1 Sasco TiblisiSasco ...
03 Nov 14 AdeliAdeli 0 - 1 LazikaLazika ...
Jornada 13
08 Nov 14 FC Iberia 1999Iberia 1999 1 - 1 SamguraliSamgurali ...
08 Nov 14 ChiaturaChiatura 2 - 2 AdeliAdeli ...
08 Nov 14 Sakartvelos TUSakartvelos 3 - 1 ChkherimelaChkherimela ...
08 Nov 14 LazikaLazika 1 - 1 Locomotive TbilisiLocomotive ...
08 Nov 14 Sasco TiblisiSasco 3 - 2 MatchakhelaMatchakhela ...
Jornada 14
12 Nov 14 AdeliAdeli 2 - 1 Sasco TiblisiSasco ...
12 Nov 14 SamguraliSamgurali 1 - 0 LazikaLazika ...
12 Nov 14 MatchakhelaMatchakhela 2 - 2 Sakartvelos TUSakartvelos ...
12 Nov 14 Locomotive TbilisiLocomotive 1 - 0 ChiaturaChiatura ...
12 Nov 14 ChkherimelaChkherimela 0 - 5 FC Iberia 1999Iberia 1999 ...
Jornada 15
16 Nov 14 Sasco TiblisiSasco 3 - 1 Locomotive TbilisiLocomotive ...
16 Nov 14 MatchakhelaMatchakhela 1 - 3 ChkherimelaChkherimela ...
16 Nov 14 ChiaturaChiatura 2 - 1 SamguraliSamgurali ...
16 Nov 14 Sakartvelos TUSakartvelos 1 - 1 AdeliAdeli ...
16 Nov 14 LazikaLazika 0 - 0 FC Iberia 1999Iberia 1999 ...
Jornada 16
20 Nov 14 AdeliAdeli 0 - 3 MatchakhelaMatchakhela ...
20 Nov 14 SamguraliSamgurali 0 - 2 Sasco TiblisiSasco ...
20 Nov 14 ChkherimelaChkherimela 0 - 0 LazikaLazika ...
20 Nov 14 Locomotive TbilisiLocomotive 5 - 1 Sakartvelos TUSakartvelos ...
20 Nov 14 FC Iberia 1999Iberia 1999 1 - 0 ChiaturaChiatura ...
Jornada 17
28 Nov 14 Sasco TiblisiSasco 1 - 2 FC Iberia 1999Iberia 1999 ...
28 Nov 14 MatchakhelaMatchakhela 2 - 0 Locomotive TbilisiLocomotive ...
28 Nov 14 ChiaturaChiatura 1 - 0 LazikaLazika ...
28 Nov 14 Sakartvelos TUSakartvelos 3 - 2 SamguraliSamgurali ...
28 Nov 14 AdeliAdeli 1 - 2 ChkherimelaChkherimela ...
Jornada 18
03 Dic 14 FC Iberia 1999Iberia 1999 5 - 0 Sakartvelos TUSakartvelos ...
03 Dic 14 SamguraliSamgurali 3 - 0 MatchakhelaMatchakhela ...
03 Dic 14 LazikaLazika 5 - 2 Sasco TiblisiSasco ...
03 Dic 14 Locomotive TbilisiLocomotive 6 - 1 AdeliAdeli ...
03 Dic 14 ChiaturaChiatura 2 - 0 ChkherimelaChkherimela ...
Jornada 19
21 Feb 15 Locomotive TbilisiLocomotive 2 - 0 ChkherimelaChkherimela ...
21 Feb 15 SamguraliSamgurali 2 - 0 AdeliAdeli ...
30 Abr 15 ChiaturaChiatura 3 - 4 Sasco TiblisiSasco ...
21 Feb 15 FC Iberia 1999Iberia 1999 3 - 0 MatchakhelaMatchakhela ...
23 Feb 15 LazikaLazika 6 - 1 Sakartvelos TUSakartvelos ...
Jornada 20
28 Feb 15 ChkherimelaChkherimela 1 - 0 Sasco TiblisiSasco ...
28 Feb 15 Sakartvelos TUSakartvelos 1 - 2 ChiaturaChiatura ...
28 Feb 15 MatchakhelaMatchakhela 0 - 1 LazikaLazika ...
28 Feb 15 Locomotive TbilisiLocomotive 5 - 2 SamguraliSamgurali ...
01 Mar 15 FC Iberia 1999Iberia 1999 1 - 1 AdeliAdeli ...
Jornada 21
04 Mar 15 SamguraliSamgurali 5 - 1 ChkherimelaChkherimela ...
04 Mar 15 ChiaturaChiatura 0 - 2 MatchakhelaMatchakhela ...
04 Mar 15 Sasco TiblisiSasco 3 - 1 Sakartvelos TUSakartvelos ...
05 Mar 15 FC Iberia 1999Iberia 1999 3 - 2 Locomotive TbilisiLocomotive ...
05 Mar 15 LazikaLazika 1 - 0 AdeliAdeli ...
Jornada 22
09 Mar 15 ChkherimelaChkherimela 3 - 1 Sakartvelos TUSakartvelos ...
09 Mar 15 MatchakhelaMatchakhela 0 - 0 Sasco TiblisiSasco ...
09 Mar 15 AdeliAdeli 0 - 3 ChiaturaChiatura ...
09 Mar 15 Locomotive TbilisiLocomotive 1 - 0 LazikaLazika ...
09 Mar 15 FC Iberia 1999Iberia 1999 3 - 0 SamguraliSamgurali ...
Jornada 23
13 Mar 15 FC Iberia 1999Iberia 1999 1 - 0 ChkherimelaChkherimela ...
13 Mar 15 LazikaLazika 1 - 6 SamguraliSamgurali ...
13 Mar 15 ChiaturaChiatura 0 - 1 Locomotive TbilisiLocomotive ...
13 Mar 15 Sasco TiblisiSasco 1 - 0 AdeliAdeli ...
13 Mar 15 Sakartvelos TUSakartvelos 2 - 4 MatchakhelaMatchakhela ...
Jornada 24
17 Mar 15 ChkherimelaChkherimela 1 - 0 MatchakhelaMatchakhela ...
17 Mar 15 AdeliAdeli 6 - 0 Sakartvelos TUSakartvelos ...
17 Mar 15 Locomotive TbilisiLocomotive 0 - 0 Sasco TiblisiSasco ...
17 Mar 15 SamguraliSamgurali 1 - 0 ChiaturaChiatura ...
17 Mar 15 FC Iberia 1999Iberia 1999 3 - 1 LazikaLazika 1
Jornada 25
22 Mar 15 Sasco TiblisiSasco 1 - 1 SamguraliSamgurali ...
21 Mar 15 Sakartvelos TUSakartvelos 0 - 1 Locomotive TbilisiLocomotive ...
22 Mar 15 MatchakhelaMatchakhela 2 - 1 AdeliAdeli ...
23 Mar 15 LazikaLazika 2 - 0 ChkherimelaChkherimela ...
22 Mar 15 FC Iberia 1999Iberia 1999 5 - 0 ChiaturaChiatura ...
Jornada 26
28 Mar 15 ChkherimelaChkherimela 2 - 0 AdeliAdeli ...
19 Abr 15 Locomotive TbilisiLocomotive 6 - 0 MatchakhelaMatchakhela ...
28 Mar 15 SamguraliSamgurali 2 - 0 Sakartvelos TUSakartvelos ...
19 Abr 15 FC Iberia 1999Iberia 1999 2 - 3 Sasco TiblisiSasco ...
28 Mar 15 LazikaLazika 1 - 0 ChiaturaChiatura ...
Jornada 27
02 Abr 15 Sasco TiblisiSasco 3 - 5 LazikaLazika ...
02 Abr 15 Sakartvelos TUSakartvelos 2 - 5 FC Iberia 1999Iberia 1999 ...
02 Abr 15 MatchakhelaMatchakhela 0 - 2 SamguraliSamgurali ...
02 Abr 15 AdeliAdeli 0 - 3 Locomotive TbilisiLocomotive ...
02 Abr 15 ChkherimelaChkherimela 0 - 1 ChiaturaChiatura ...
Jornada 28
06 Abr 15 ChkherimelaChkherimela 2 - 2 Locomotive TbilisiLocomotive ...
06 Abr 15 AdeliAdeli 0 - 2 SamguraliSamgurali ...
06 Abr 15 MatchakhelaMatchakhela 1 - 0 FC Iberia 1999Iberia 1999 ...
06 Abr 15 Sakartvelos TUSakartvelos 1 - 6 LazikaLazika ...
06 Abr 15 Sasco TiblisiSasco 1 - 1 ChiaturaChiatura ...
Jornada 29
17 May 15 Sasco TiblisiSasco 1 - 1 ChkherimelaChkherimela ...
10 Abr 15 ChiaturaChiatura 1 - 0 Sakartvelos TUSakartvelos ...
10 Abr 15 LazikaLazika 2 - 0 MatchakhelaMatchakhela ...
10 Abr 15 SamguraliSamgurali 0 - 1 Locomotive TbilisiLocomotive ...
11 May 15 AdeliAdeli 1 - 0 FC Iberia 1999Iberia 1999 ...
Jornada 30
15 Abr 15 ChkherimelaChkherimela 3 - 2 SamguraliSamgurali ...
15 Abr 15 Locomotive TbilisiLocomotive 0 - 1 FC Iberia 1999Iberia 1999 ...
15 Abr 15 AdeliAdeli 0 - 2 LazikaLazika ...
15 Abr 15 MatchakhelaMatchakhela 3 - 0 ChiaturaChiatura ...
15 Abr 15 Sakartvelos TUSakartvelos 0 - 1 Sasco TiblisiSasco ...
Jornada 31
23 Abr 15 Sakartvelos TUSakartvelos 3 - 0 ChkherimelaChkherimela ...
23 Abr 15 Sasco TiblisiSasco 2 - 3 MatchakhelaMatchakhela ...
23 Abr 15 ChiaturaChiatura 4 - 1 AdeliAdeli ...
23 Abr 15 LazikaLazika 2 - 0 Locomotive TbilisiLocomotive ...
23 Abr 15 SamguraliSamgurali 0 - 1 FC Iberia 1999Iberia 1999 ...
Jornada 32
27 Abr 15 ChkherimelaChkherimela 3 - 0 FC Iberia 1999Iberia 1999 ...
27 Abr 15 SamguraliSamgurali 3 - 2 LazikaLazika ...
27 Abr 15 Locomotive TbilisiLocomotive 2 - 1 ChiaturaChiatura ...
27 Abr 15 AdeliAdeli 2 - 1 Sasco TiblisiSasco ...
27 Abr 15 MatchakhelaMatchakhela 2 - 1 Sakartvelos TUSakartvelos ...
Jornada 33
04 May 15 MatchakhelaMatchakhela 3 - 0 ChkherimelaChkherimela ...
04 May 15 Sakartvelos TUSakartvelos 2 - 0 AdeliAdeli ...
04 May 15 Sasco TiblisiSasco 3 - 5 Locomotive TbilisiLocomotive ...
04 May 15 ChiaturaChiatura 0 - 4 SamguraliSamgurali ...
04 May 15 LazikaLazika 1 - 3 FC Iberia 1999Iberia 1999 ...
Jornada 34
08 May 15 ChkherimelaChkherimela 2 - 0 LazikaLazika ...
08 May 15 SamguraliSamgurali 2 - 1 Sasco TiblisiSasco ...
08 May 15 Locomotive TbilisiLocomotive 6 - 0 Sakartvelos TUSakartvelos ...
08 May 15 AdeliAdeli 3 - 4 MatchakhelaMatchakhela ...
08 May 15 ChiaturaChiatura 0 - 5 FC Iberia 1999Iberia 1999 ...
Jornada 35
15 May 15 AdeliAdeli 3 - 4 ChkherimelaChkherimela ...
15 May 15 MatchakhelaMatchakhela 0 - 3 Locomotive TbilisiLocomotive ...
15 May 15 ChiaturaChiatura 1 - 2 LazikaLazika ...
15 May 15 Sakartvelos TUSakartvelos 1 - 5 SamguraliSamgurali ...
15 May 15 Sasco TiblisiSasco 0 - 1 FC Iberia 1999Iberia 1999 ...
Jornada 36
19 May 15 ChkherimelaChkherimela 1 - 2 ChiaturaChiatura ...
19 May 15 LazikaLazika 3 - 1 Sasco TiblisiSasco ...
19 May 15 FC Iberia 1999Iberia 1999 2 - 0 Sakartvelos TUSakartvelos ...
19 May 15 SamguraliSamgurali 1 - 0 MatchakhelaMatchakhela ...
19 May 15 Locomotive TbilisiLocomotive 8 - 0 AdeliAdeli ...

Clasificación

Equipo PJ GF GC Puntos
1 FC Iberia 1999 Iberia 1999 36 92 25 87
2 Locomotive Tbilisi Locomotive 36 87 42 68
3 Lazika Lazika 36 69 41 66
4 Samgurali Samgurali 36 76 50 60
5 Chiatura Chiatura 36 53 52 54
6 Matchakhela Matchakhela 36 48 66 45
7 Sasco Tiblisi Sasco 36 61 67 42
8 Chkherimela Chkherimela 36 35 71 40
9 Sakartvelos TU Sakartvelos 36 47 97 35
10 Adeli Adeli 36 37 94 22

  USO DE MEMORIA  
6,023,600 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1340
Total Execution Time  0.1358
  CADENA URL  
/pirveli_liga_georgia2015/grupo1/calendario
  GET DATOS  
$_GET['/pirveli_liga_georgia2015/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0018  SELECT type FROM routes WHERE alias = 'pirveli_liga_georgia2015'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'pirveli_liga_georgia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2015 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=397 AND type_rel = 3
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=397 ORDER BY order_id ASC
0.0020  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 4175 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0029  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 calendars2015 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 4175 ORDER BY round ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-04 11:53:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-04 11:53:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-04 11:53:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-04 11:53:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'pirveli_liga_georgia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2015 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0185  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 events2015 e ON e.player_id = p.id AND e.league_id = 4175 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 4175 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.0134  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 events2015 e ON e.player_id = p.id AND e.league_id = 4175 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 4175 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0026  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 events2015 e ON e.player_id = p.id AND e.league_id = 4175 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 4175 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0035  SELECT *,(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 = 4175 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC