4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Buriram United Buriram 34 98 24 84
2 Muang Thong United Muang Thong 34 81 35 71
3 Suphanburi Suphanburi 34 60 39 59
4 Chonburi Chonburi 34 62 44 57
5 Bangkok United Bangkok 34 59 47 57
6 BG Pathum United Pathum 34 47 38 56
7 Ratchaburi Ratchaburi 34 48 50 55
8 Nakhon Ratchasima Nakhon 34 37 43 49
9 Chiangrai United Chiangrai 34 42 57 44
10 Royal Thai Fleet Royal Thai. 34 43 47 41
11 Super Power Samut Prakan Super Power 34 40 54 39
12 Chainat Hornbill Chainat 34 42 53 37
13 Sisaket Sisaket 34 30 47 36
14 Police Tero FC Police Tero 34 42 51 35
15 Saraburi Saraburi 34 41 56 35
16 Siam Navy Siam Navy 34 42 65 35
17 Port FC Port FC 34 31 49 33
18 TOT TOT 34 25 71 16
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Buriram United Buriram 38 69 26 79
2 Chonburi Chonburi 38 62 33 76
3 Police Tero FC Police Tero 38 66 41 68
4 Ratchaburi Ratchaburi 38 62 42 65
5 Muang Thong United Muang Thong 38 66 36 62
6 Suphanburi Suphanburi 38 55 49 59
7 Chiangrai United Chiangrai 38 55 47 55
8 Bangkok United Bangkok 38 55 56 54
9 Royal Thai Fleet Royal Thai. 38 52 55 53
10 BG Pathum United Pathum 38 70 65 49
11 Super Power Samut Prakan Super Power 38 53 49 48
12 Sisaket Sisaket 38 48 59 46
13 Port FC Port FC 38 44 52 45
14 Chainat Hornbill Chainat 38 43 50 44
15 TOT TOT 38 38 51 43
16 Police United Police 38 58 64 43
17 PTT Rayong PTT Rayong 38 49 60 42
18 Songkhla United Songkhla 38 39 72 32
19 Air Force Central Force 38 35 63 30
20 Samut Songkhram Samut 38 32 81 19
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Buriram United Buriram 32 73 23 78
2 Muang Thong United Muang Thong 32 61 33 71
3 Chonburi Chonburi 32 61 35 62
4 Suphanburi Suphanburi 32 40 31 51
5 BG Pathum United Pathum 32 40 31 50
6 Royal Thai Fleet Royal Thai. 32 48 40 48
7 Police Tero FC Police Tero 32 56 49 48
8 Super Power Samut Prakan Super Power 32 38 43 39
9 Police United Police 32 40 37 38
10 Chainat Hornbill Chainat 32 42 43 38
11 Chiangrai United Chiangrai 32 32 45 34
12 Songkhla United Songkhla 32 30 47 32
13 Bangkok United Bangkok 32 38 61 31
14 TOT TOT 32 27 54 31
15 Ratchaburi Ratchaburi 32 31 39 30
16 Samut Songkhram Samut 32 22 41 30
17 Samut Prakan City Samut Prakan 32 39 66 29
18 Sisaket Sisaket 0 0 0 0
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Muang Thong United Muang Thong 34 78 31 84
2 Chonburi Chonburi 34 65 33 70
3 Police Tero FC Police Tero 34 53 43 57
4 Buriram United Buriram 34 60 40 54
5 Super Power Samut Prakan Super Power 34 55 48 52
6 Sisaket Sisaket 34 41 42 47
7 Samut Songkhram Samut 34 37 39 46
8 BG Pathum United Pathum 34 53 39 45
9 Chiangrai United Chiangrai 34 40 47 44
10 Royal Thai Fleet Royal Thai. 34 34 38 43
11 Police United Police 34 37 38 42
12 TOT TOT 34 43 46 42
13 Songkhla United Songkhla 34 46 54 41
14 Chainat Hornbill Chainat 34 59 72 39
15 Samut Prakan City Samut Prakan 34 35 47 37
16 Port FC Port FC 34 32 48 33
17 BBCU BBCU 34 32 63 25
18 TTM Lopburi TTM Lopburi 34 25 57 18
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Buriram United Buriram 34 64 15 85
2 Chonburi Chonburi 34 60 30 69
3 Muang Thong United Muang Thong 34 54 32 60
4 Samut Prakan City Samut Prakan 34 38 27 53
5 BG Pathum United Pathum 34 55 41 53
6 Super Power Samut Prakan Super Power 34 47 32 51
7 Chiangrai United Chiangrai 36 49 55 47
8 Port FC Port FC 34 33 37 45
9 Police Tero FC Police Tero 34 38 35 45
10 Police United Police 34 36 40 44
11 TOT TOT 34 32 52 43
12 Royal Thai Fleet Royal Thai. 34 39 40 39
13 TTM Lopburi TTM Lopburi 32 35 51 37
14 Samut Songkhram Samut 34 31 45 36
15 Sisaket Sisaket 34 30 42 34
16 Siam Navy Siam Navy 34 29 51 34
17 Sriracha Sriracha 34 33 43 32
18 Khonkaen Khonkaen 34 33 68 27
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Muang Thong United Muang Thong 30 64 19 67
2 Buriram United Buriram 30 51 19 63
3 Chonburi Chonburi 30 57 28 60
4 Port FC Port FC 30 40 29 48
5 BG Pathum United Pathum 30 48 38 45
6 Samut Prakan City Samut Prakan 30 43 38 45
7 Super Power Samut Prakan Super Power 30 32 30 42
8 Samut Songkhram Samut 30 27 32 42
9 Police Tero FC Police Tero 30 39 42 35
10 Siam Navy Siam Navy 30 35 51 33
11 Police United Police 30 40 45 33
12 TOT TOT 30 23 42 33
13 TTM Lopburi TTM Lopburi 30 32 46 32
14 Sisaket Sisaket 30 35 54 26
15 Bangkok United Bangkok 30 25 52 24
16 Royal Thai Fleet Royal Thai. 30 27 53 22
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Muang Thong United Muang Thong 30 48 20 65
2 Chonburi Chonburi 30 50 30 62
3 BG Pathum United Pathum 30 45 31 56
4 Police Tero FC Police Tero 30 53 34 51
5 Super Power Samut Prakan Super Power 30 36 32 47
6 Port FC Port FC 30 33 30 44
7 TOT TOT 30 33 33 42
8 TTM Lopburi TTM Lopburi 30 29 32 37
9 Buriram United Buriram 30 37 41 36
10 Samut Songkhram Samut 30 22 31 34
11 Samut Prakan City Samut Prakan 30 27 33 32
12 Siam Navy Siam Navy 30 28 39 30
13 Bangkok United Bangkok 30 24 34 30
14 Sriracha Sriracha 30 28 34 30
15 BBCU BBCU 30 29 47 26
16 Nakhon Pathom Nakhon 30 32 53 25
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Buriram United Buriram 30 38 16 59
2 Chonburi Chonburi 30 32 14 57
3 Police Tero FC Police Tero 30 50 31 55
4 Super Power Samut Prakan Super Power 30 36 24 51
5 TOT TOT 30 36 27 50
6 Krung Thai Bank Krung Thai. 30 46 35 46
7 Samut Songkhram Samut 30 35 31 43
8 BBCU BBCU 30 47 41 39
9 Nakhon Pathom Nakhon 30 24 36 38
10 Bangkok United Bangkok 30 25 33 36
11 Samut Prakan City Samut Prakan 30 24 27 35
12 TTM Lopburi TTM Lopburi 30 19 24 33
13 Bangkok Bank Bangkok Bank 30 23 35 29
14 Port FC Port FC 30 27 44 29
15 Royal Thai Fleet Royal Thai. 30 19 42 25
16 Customs United Customs 30 18 39 20
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Chonburi Chonburi 30 50 25 63
2 Krung Thai Bank Krung Thai. 30 40 24 54
3 Police Tero FC Police Tero 30 47 29 51
4 Bangkok United Bangkok 30 39 36 47
5 Royal Thai Fleet Royal Thai. 30 40 33 47
6 TTM Lopburi TTM Lopburi 30 43 42 44
7 Bangkok Bank Bangkok Bank 30 28 23 44
8 Buriram United Buriram 30 35 40 42
9 Super Power Samut Prakan Super Power 30 38 36 40
10 TOT TOT 30 35 35 37
11 Nakhon Pathom Nakhon 30 30 29 37
12 Port FC Port FC 30 36 43 36
13 Suphanburi Suphanburi 30 37 45 35
14 Thai Honda Thai Honda 30 26 38 29
15 Siam Navy Siam Navy 30 21 35 27
16 Police United Police 30 19 51 19
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Bangkok United Bangkok 22 25 17 39
2 Osotsapa Osotsapa 22 35 20 38
3 Police Tero FC Police Tero 22 32 14 36
4 Chiangmai Chiangmai 22 30 24 35
5 Bangkok Bank Bangkok Bank 22 26 28 34
6 Royal Thai Fleet Royal Thai. 22 31 38 30
7 Thai Port Thai Port 22 21 28 28
8 Chonburi Chonburi 22 29 28 27
9 Krung Thai Bank Krung Thai. 22 22 26 25
10 Buriram United Buriram 22 23 32 22
11 Thai Honda Thai Honda 22 23 26 21
12 Suphanburi Suphanburi 22 18 34 16
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 Chiangmai Chiangmai 18 26 11 34
2 Osotsapa Osotsapa 18 34 20 32
3 Buriram United Buriram 18 23 19 32
4 Thai Port Thai Port 18 26 27 26
5 Krung Thai Bank Krung Thai. 18 24 22 25
6 Police Tero FC Police Tero 18 19 18 25
7 Bangkok United Bangkok 18 16 21 22
8 Bangkok Bank Bangkok Bank 18 25 28 20
9 TOT TOT 18 20 25 16
10 Siam Navy Siam Navy 18 11 33 10
Ver
TEMPORADA 2003/2004
Equipo PJ GF GC Puntos
1 Krung Thai Bank Krung Thai. 18 33 18 38
2 Police Tero FC Police Tero 18 33 22 34
3 Osotsapa Osotsapa 18 43 23 33
4 Bangkok United Bangkok 18 26 22 31
5 Thai Port Thai Port 18 29 28 28
6 Bangkok Bank Bangkok Bank 18 28 21 26
7 Chiangmai Chiangmai 20 19 19 23
8 Siam Navy Siam Navy 18 18 27 19
9 Air Force Central Force 18 14 38 16
10 BBCU BBCU 18 18 41 8
11 Royal Thai Fleet Royal Thai. 2 1 3 1
Ver
TEMPORADA 2002/2003
Equipo PJ GF GC Puntos
1 Krung Thai Bank Krung Thai. 18 29 15 36
2 Police Tero FC Police Tero 18 31 11 35
3 Thai Port Thai Port 18 25 19 33
4 Bangkok Bank Bangkok Bank 18 31 26 28
5 Chiangmai Chiangmai 20 23 25 25
6 Osotsapa Osotsapa 18 19 17 23
7 Air Force Central Force 18 26 29 23
8 BBCU BBCU 18 21 23 22
9 TOT TOT 18 18 29 11
10 Christian College Christian 18 16 44 9
11 Buriram United Buriram 2 0 1 1
Ver
TEMPORADA 2001/2002
Equipo PJ GF GC Puntos
1 Police Tero FC Police Tero 22 41 11 50
2 Osotsapa Osotsapa 22 34 21 44
3 Bangkok Bank Bangkok Bank 22 21 17 35
4 Air Force Central Force 22 23 21 32
5 BBCU BBCU 22 25 21 30
6 Thai Port Thai Port 22 26 23 28
7 Krung Thai Bank Krung Thai. 22 23 23 28
8 Chiangmai Chiangmai 22 24 35 26
9 TOT TOT 22 18 24 24
10 Siam Navy Siam Navy 22 14 31 21
11 Police United Police 22 16 24 19
12 RBAC Mittraphap RBAC 22 10 24 18
Ver
TEMPORADA 1999/2000
Equipo PJ GF GC Puntos
1 Police Tero FC Police Tero 22 48 14 49
2 Air Force Central Force 22 34 19 41
3 Thai Farmers Bank Thai Farmers 22 33 25 37
4 RBAC Mittraphap RBAC 22 39 29 35
5 Thai Port Thai Port 22 18 21 30
6 Siam Navy Siam Navy 22 21 22 26
7 Police United Police 22 25 27 26
8 Osotsapa Osotsapa 22 15 20 26
9 Bangkok Bank Bangkok Bank 22 14 23 25
10 Krung Thai Bank Krung Thai. 22 21 40 21
11 BBCU BBCU 22 20 32 20
12 TOT TOT 22 26 42 20

  USO DE MEMORIA  
6,857,840 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0034
Controller Execution Time ( Home / Category )  0.1883
Total Execution Time  0.1918
  CADENA URL  
/premier_league_tailandia2015/grupo1/historico
  GET DATOS  
$_GET['/premier_league_tailandia2015/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0017  SELECT type FROM routes WHERE alias = 'premier_league_tailandia2015'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_league_tailandia' 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=394 AND type_rel = 3
0.0022  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 394 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  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 (1015856,1010172,983319,814468,749631) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=394 ORDER BY order_id ASC
0.0021  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 394 GROUP BY l.categoryId
0.0019  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=394 GROUP BY l.year ORDER BY l.year DESC
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 = 9514 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 394 AND group_code = 1 and tables = 1 AND year <= 2015 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0025  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 = 9514 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 3568 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 2879 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 8673 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 8674 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 `tables2010` 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 = 8675 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables2009` 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 = 8676 AND t.round = 30 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 `tables2008` 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 = 8677 AND t.round = 30 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 `tables2007` 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 = 8678 AND t.round = 30 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 `tables2006` 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 = 23792 AND t.round = 22 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 `tables2005` 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 = 23793 AND t.round = 18 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 `tables2004` 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 = 23794 AND t.round = 19 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 `tables2003` 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 = 23795 AND t.round = 19 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 `tables2002` 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 = 23796 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 `tables2000` 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 = 23797 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-10 10:45:32' 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-10 10:45:32' 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-10 10:45:32' 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-10 10:45:32' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_league_tailandia' 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.0213  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 = 9514 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 9514 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.0421  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 = 9514 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 9514 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0079  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 = 9514 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 9514 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0047  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 = 9514 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC