4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
7 jugadores
Olympiakos Nicosia Olympiakos
K. Samaras K. Samaras 39 años 183cm DEF
Mashinya Mashinya 40 años MED
Antoniou Antoniou 33 años MED
Mario Martos Mario Martos 32 años 175cm 64kg MED
A. Christofidis A. Christofidis 31 años 183cm MED
Furtado Furtado 41 años 181cm 78kg DEL
M. Mguni M. Mguni 41 años 195cm 79kg DEL
5 jugadores
Enosis Neon Paralimni Enosis Neon Par.
D. Oikonomou D. Oikonomou 31 años DEF
Thomas Präger Thomas Präger 38 años 174cm MED
S. Cojocnean S. Cojocnean 36 años 180cm 71kg DEL
Bruno Moraes Bruno Moraes 39 años 180cm 72kg DEL
T. Josephides T. Josephides 27 años DEL
6 jugadores
Pafos Pafos
Andys Nikolaou Andys Nikolaou 28 años 193cm DEF
C. Charalambous C. Charalambous 42 años DEF
Paulo Sérgio Paulo Sérgio 42 años 182cm 84kg MED
C. Nicolaou C. Nicolaou MED
Leonel Alves Leonel Alves 35 años 174cm 67kg MED
A. Pătulea A. Pătulea 39 años DEL
5 jugadores
Ayia Napa Ayia Napa
J. Embalo J. Embalo
M. Panagiotou M. Panagiotou 31 años POR
G. Loizou G. Loizou 32 años 185cm POR
A. Ronga A. Ronga 42 años 181cm 83kg DEF
G. Panagidis G. Panagidis MED
1 jugadores
Akritas Chlorakas Akritas
Ayayi Ayayi MED
9 jugadores
PAEEK PAEEK
Joaquin Caserza Joaquin Caserza 28 años 191cm 83kg POR
Achilleos Achilleos MED
G. Pechlivanopoulos G. Pechlivanopoulos 29 años 177cm 70kg MED
T. Tsitas T. Tsitas 32 años 190cm 81kg MED
K. Vasiliou K. Vasiliou 31 años MED
Emmanouil Emmanouil 31 años 187cm MED
Opongk Opongk MED
Y. Rahman Y. Rahman 31 años MED
B. Odwong B. Odwong 34 años DEL
10 jugadores
Omonia Aradippou Omonia Aradippou
O. Nikolopoulos O. Nikolopoulos 32 años 192cm DEF
S. Tsiakkas S. Tsiakkas 39 años MED
A. Panagi A. Panagi 40 años MED
L. Alampritis L. Alampritis 26 años MED
L. Rodriguez L. Rodriguez 34 años MED
M. Manoli M. Manoli MED
D. Theofanous D. Theofanous 32 años DEL
Giannis Andreou Giannis Andreou 24 años 177cm DEL
Kevin Levis Kevin Levis 31 años DEL
G. Kakalov G. Kakalov 39 años 180cm 75kg DEL
11 jugadores
Othellos Athienou Othellos
Vasiliou Vasiliou MED
A. Livingstone A. Livingstone 35 años 165cm 77kg MED
C. Djamas C. Djamas 28 años MED
Galin Galin MED
Koumouris Koumouris MED
Petrovich Petrovich MED
Sassi Sassi MED
A. Adorno A. Adorno 42 años 175cm 70kg DEL
D. Olcina D. Olcina 35 años 179cm 77kg DEL
E. Grigalashvili E. Grigalashvili 34 años 178cm DEL
Luis Morán Luis Morán 36 años 173cm 68kg DEL
8 jugadores
ASIL Lysi ASIL Lysi
F. Gbedinyessi F. Gbedinyessi 35 años MED
H. Chirouf H. Chirouf 35 años MED
A. Vasiliou A. Vasiliou 30 años MED
D. Kyriakou D. Kyriakou 37 años MED
A. Nikolaou A. Nikolaou 31 años MED
A. Ciocalteu A. Ciocalteu 34 años 179cm DEL
Kostadin Bashov Kostadin Bashov 41 años 178cm 78kg DEL
A. Pittaras A. Pittaras 33 años DEL
6 jugadores
Alki Oroklini Alki Oroklini
J. Pierazzi J. Pierazzi 38 años 185cm 74kg MED
Y. Tribeau Y. Tribeau 36 años 180cm 72kg MED
Willy Semedo Willy Semedo 30 años 185cm 70kg DEL
A. Pătulea A. Pătulea 39 años DEL
A. Papathanasiou A. Papathanasiou 40 años 189cm DEL
P. Loizides P. Loizides 29 años 180cm DEL
7 jugadores
EN THOI Lakatamia THOI Lakatamia
P. Kastanas P. Kastanas 34 años DEF
Diallo Diallo MED
Chatzipantelidis Chatzipantelidis MED
Sotiroglou Sotiroglou MED
Nando Nando MED
F. Henrique F. Henrique 33 años 182cm 83kg DEL
D. Theofanous D. Theofanous 32 años DEL
4 jugadores
ENAD ENAD
Zé Eduardo Zé Eduardo 43 años MED
Paulo Sérgio Paulo Sérgio 42 años 182cm 84kg MED
Ioannou Ioannou MED
Vasiliou Vasiliou MED
6 jugadores
EN Parekklisias EN Parekklisias
A. Theofanous A. Theofanous 38 años MED
L. Kakogiannis L. Kakogiannis 42 años MED
K. Zarnas K. Zarnas 34 años MED
Palmer Palmer MED
M. Sikas M. Sikas 34 años MED
N. Pitsillides N. Pitsillides 30 años DEL

JUGADORES DESTACADOS

Clasificación

Equipo PJ GF GC Puntos
1 Alki Oroklini Alki 26 60 16 64
2 Pafos Pafos 26 51 24 57
3 Olympiakos Nicosia Olympiakos 26 44 23 54
4 Othellos Athienou Othellos 26 53 33 49
5 Ayia Napa Ayia Napa 26 52 28 46
6 Enosis Neon Paralimni Enosis Neon 26 41 32 44
7 EN THOI Lakatamia THOI 26 32 34 33
8 ASIL Lysi ASIL Lysi 26 27 33 30
9 PAEEK PAEEK 26 26 38 24
10 Ethnikos Assias Ethnikos 26 24 52 23
11 Omonia Aradippou Omonia 26 16 30 22
12 Akritas Chlorakas Akritas 26 24 45 19
13 ENAD ENAD 26 26 52 19
14 EN Parekklisias Parekklisias 26 28 64 19

  USO DE MEMORIA  
5,170,032 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0865
Total Execution Time  0.0885
  CADENA URL  
/2_division_chipre2017/grupo1/jugadores
  GET DATOS  
$_GET['/2_division_chipre2017/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0020  SELECT type FROM routes WHERE alias = '2_division_chipre2017'
0.0047  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = '2_division_chipre' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2017 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=708 AND type_rel = 3
0.0033  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 708 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0037  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 (1267270,1252536,262172,90198,9789) ORDER BY n.cover_points DESC, update_date DESC
0.0021  SELECT id,name,alias,stepParent FROM categories WHERE parentId=708 ORDER BY order_id ASC
0.0028  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 = 33687 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0033  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 33687 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0121  SELECT dp.nick,dp.alias,dp.role,p.id,p.teamId,dp.height,dp.weight,p.team_id,p.player_id,p.squadNumber,dp.CountryCode,dp.age FROM rel_players p INNER JOIN dataplayers dp ON dp.id = p.player_id INNER JOIN datateams dt ON dt.id = p.teamId WHERE p.league_id = 33687 AND dt.id IN (1862,5863,9300,10082,17249,5435,19175,12528,12549,65803,17255,17252,17253,12551) ORDER BY dt.relations DESC,dp.role ASC
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 06:57:58' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-01 06:57:58' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-01 06:57:58' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-01 06:57:58' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0026  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = '2_division_chipre' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2017 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0033  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 = 33687 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 33687 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.0021  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 = 33687 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 33687 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0025  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 = 33687 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 33687 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0039  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 = 33687 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC