Sobre Isralega
Israel Marin Torrijos
Me gusta el futbol, soy del madrid y del leganes, vivo en leganes
Amigos 0
Isralega todavía no tiene amigos.
Grupos 0
Isralega aún no pertenece a ningún grupo
Comentarios 14 Más comentarios
  • Y tu eres un mierda y un hp hace 12 años en Badalona - Leganés
  • al lugo le han eliminado tolili hace 12 años en Badalona - Leganés
  • No te lo crees ni tu hace 12 años en Badalona - Leganés
  • Haber si la federación hace algo con la mierda de arbitros que hay en 2b. Se rien de la aficcion y de los jugadores, el hp del arbitro de las semana pasado habia cogerlo y explicarle cuatro cosasForza Lega. Badalona basura de mierda. hace 12 años en Badalona - Leganés
  • Que verguenza de equipo teneis, ojala el Eibar os de bien, un equipo de mierda como el vuestro no puede estar en 2. Aqui os beneficio el arbitro y allí solo sabeis marrullear. Ojala no os permitan jugar el año que viene con la mierda de campo que teneis hace 12 años en Badalona - Leganés
  • Vamos que ya lo tenemos lega hace 12 años en Badalona - Leganés
  • Un minusculo campo de cesped artificial le llamas buen campo, espero que en badalona haya alguno un poco mas listo que tu, porque como seais todos igual de tontos, mañana nos vamos a reir un rato. 0-1 leeeeega hace 12 años en Badalona - Leganés
  • Lo que esta haciendo aqui Raul, lo hara mañana Arrubarrena en Badalona hace 12 años en Badalona - Leganés
  • 0-1 Para el Leganes, no puedo ir la afición se tiene que volcar, esperemos que los arbitros piten justamente, no como en butarque que nos robaron el partido vamos leeeeeeeeeeeeeeeeeeeeeee eeeeeega hace 12 años en Badalona - Leganés
  • Haber si tenemos suerte que los cruces en play offs y al año que viene ascendemos, vamos lega hace 13 años en Leganés - Cerro de Reyes

Isralega todavía no tiene actividad

Estadísticas de Isralega
  • Comentarios creados: 14
  • Votos a favor: 2
  • Fotos subidas: 0
  • Videos subidos: 0
  • Usuario desde: 27 Feb 11 16:37
  • Último login: 01 Mar 11 17:06

  USO DE MEMORIA  
4,063,344 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Uprofile / Index )  0.7184
Total Execution Time  0.7198
  CADENA URL  
/usuario/Isralega
  GET DATOS  
$_GET['/usuario/Isralega']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0006  SELECT * FROM (`fa_user`) WHERE `user_name` = 'Isralega'
0.0132  SELECT rf.friendId FROM rel_friends rf INNER JOIN fa_user u ON u.id = rf.friendId WHERE rf.userId = 118698 AND rf.status = 1 LIMIT 5000
0.0133  SELECT *,rf.id as idmsg FROM privatemsg_profile rf INNER JOIN fa_user u ON u.id = rf.uidsent WHERE rf.uidto = 118698 ORDER BY rf.id DESC LIMIT 0,10
0.0134  SELECT COUNT(DISTINCT c.`id`) AS num_total FROM comments as c WHERE c.`author_id` = 118698
0.0134  SELECT c.* FROM `comments` c WHERE c.`author_id` = 118698 AND c.`active`= 1 AND c.`lang` = 1 ORDER BY creation_date DESC LIMIT 0, 10
0.0136  SELECT dt.nameShow, dt.basealias, t.name FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 1307
0.0136  SELECT dt.nameShow, dt.basealias, t.name FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 1101
0.0127  SELECT id, year FROM leagues WHERE id IN (1307,1307,1307,1307,1307,1307,1307,1307,1307,1101)
0.0127   SELECT c.id, c.league_id, dt1.nameShow AS team1_name, dt2.nameShow AS team2_name, dt1.basealias AS basealias1, dt2.basealias AS basealias2, c.extra FROM calendars2011 AS c INNER JOIN datateams AS dt1 ON c.datateam1=dt1.id INNER JOIN datateams AS dt2 ON c.datateam2=dt2.id WHERE c.id IN (101782,11498)
0.0135  SELECT id, comment_id, comment, author_name, author_id, votes_up, COUNT(id) AS responses FROM comments WHERE comment_id IN (947702,947518,947472,947466,947453,947091,943512,943497,943485,920223) GROUP BY comment_id
0.0127  SELECT fap.*,u.* FROM fa_user_profile fap LEFT JOIN user_stats u ON fap.id = u.id WHERE fap.id = 118698
0.0127  SELECT * FROM `rel_goals` as rg INNER JOIN goals as g ON g.id = rg.goal_id WHERE rg.userId = 118698 ORDER BY g.class DESC, rg.datetime DESC LIMIT 100
0.0126  SELECT SUM(votes_up) AS up,SUM(votes_down) AS down FROM comments WHERE `author_id` = 118698
0.0187  SELECT dt.nameShow,dt.basealias, c.name,c.logo, c.alias, l.group_code, l.total_group, l.id, dt.id as idTeam FROM datateams as dt INNER JOIN teams as t ON t.teamId = dt.id INNER JOIN leagues as l ON l.id = t.league_id INNER JOIN categories as c ON c.id = l.categoryId WHERE 0 OR dt.id = 1535 OR dt.id = 2107 GROUP BY dt.nameShow,l.year ORDER BY c.troncal DESC,c.main DESC,l.year DESC LIMIT 2
0.0128  SELECT l.id,l.year,t.id as teamId FROM leagues l INNER JOIN categories c ON l.categoryId = c.id INNER JOIN teams as t ON t.league_id = l.id WHERE c.alias = 'segunda' AND t.teamId = 1535 AND l.group_code = 1 ORDER BY l.year DESC LIMIT 1
0.0128  SELECT l.id,l.year,t.id as teamId FROM leagues l INNER JOIN categories c ON l.categoryId = c.id INNER JOIN teams as t ON t.league_id = l.id WHERE c.alias = 'primera' AND t.teamId = 2107 AND l.group_code = 1 ORDER BY l.year DESC LIMIT 1
0.0160  SELECT * FROM `g_totals` WHERE userId = 118698
0.0127  SELECT *,rf.id as idmsg FROM privatemsg_profile rf INNER JOIN fa_user u ON u.id = rf.uidsent WHERE rf.uidto = 118698 ORDER BY rf.id DESC LIMIT 0,3
0.0216  SELECT count(rf.id) as cuenta FROM privatemsg_profile rf INNER JOIN fa_user u ON u.id = 118698 WHERE 1 AND (rf.uidto = 118698) AND rf.del != 118698
0.0131  SELECT * FROM dreamteam_data dd WHERE dd.userId = 118698 ORDER BY profile DESC, creation_date DESC LIMIT 1
0.0245  SELECT rel.pos,rel.team_number,rel.player_id,dp.alias,dp.id,dp.nick,dp.last_name,dp.name FROM rel_dreamteam rel INNER JOIN dreamteam_data dd ON dd.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE dd.id = 36498
0.0302  SELECT COUNT(rd.id) as cuenta FROM dreamteam_data rd where userId = 118698
0.0129  SELECT name,id FROM dreamteam_data rd where userId = 118698 ORDER BY profile DESC, creation_date DESC LIMIT 3
0.0130  SELECT rf.friendId FROM rel_friends rf INNER JOIN fa_user u ON u.id = rf.friendId WHERE rf.userId = 118698 AND rf.status = 1 ORDER BY u.last_activity DESC LIMIT 20
0.0130  SELECT a.*,fa.user_name FROM activity a INNER JOIN fa_user fa ON fa.id = a.userId WHERE userId IN (118698) ORDER BY a.datetime DESC LIMIT 0,60
0.0130  SELECT a.*,fa.user_name FROM activity a INNER JOIN fa_user fa ON fa.id = a.userId WHERE userId = 118698 ORDER BY id DESC LIMIT 0,60
0.0135  SELECT 1 as typew,u.user_name,u.id as user_id,rf.date,rf.message,rf.votes_up,rf.id as idmsg,rf.replies,rf.picture_id,rf.video_id,rf.new_id,rf.link_txt,rf.name_txt,u.user_name as wall_name FROM privatemsg_profile rf INNER JOIN fa_user u ON u.id = rf.uidsent WHERE rf.reply_msg = 0 AND rf.uidto = 118698 ORDER BY rf.update_date DESC LIMIT 0,10
0.0133  SELECT g.id,g.name,rg.status,g.alias,g.members FROM rel_groups rg INNER JOIN groups g ON g.id = rg.group_id WHERE rg.status = 1 AND rg.user_id = 118698 GROUP BY rg.group_id ORDER BY rg.accuracy DESC LIMIT 4
0.0133  SELECT count(g.id) as cuenta FROM rel_groups rg INNER JOIN groups g ON g.id = rg.group_id WHERE rg.status = 1 AND rg.user_id = 118698 GROUP BY rg.user_id
0.0125  SELECT u.user_name,rf.friendId,rf.status,u.id,u.changeA FROM rel_friends rf INNER JOIN fa_user u ON u.id = rf.friendId WHERE rf.userId = 118698 AND rf.status = 1 ORDER BY status ASC, rf.accuracy DESC LIMIT 0,12
0.0172  SELECT COUNT(*) AS total FROM rel_friends WHERE userId=118698 AND status=1
0.0125  SELECT min(l.year) as min_year,max(l.year) as max_year,c.main,cou.Name,c.top,c.status,c.cat,c.ctype,c.CountryCode, c.class, c.main,c.coefficient, l.year,c.logo, l.id , c.name, c.alias,lp.c_playing,lp.c_recent,lp.c_played,lp.c_pending,lp.c_past,lp.c_future FROM (leagues l INNER JOIN categories c ON l.categoryId = c.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode LEFT JOIN leagues_play lp ON lp.categoryId = c.id AND lp.ini_date = '2024-05-21 05:30:00') WHERE l.group_code = 1 AND l.end_date > NOW() - INTERVAL 2 MONTH AND l.status = 1 group by l.categoryId ORDER BY c.coefficient DESC, c.name DESC LIMIT 200
0.0127  SELECT * FROM totals order by id ASC
0.0966  SELECT l.id,cat.alias,cat.name,l.total_group,l.group_code FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2009 as c ON c.league_id = l.id AND l.current_round = c.round WHERE l.status = 1 AND c.r1 < 95 AND c.r2 < 95 AND c.shedule > '2024/05/21 02:39' AND c.shedule < '2024/05/21 05:59' GROUP BY l.id ORDER BY cat.coefficient DESC,l.group_code ASC LIMIT 21
0.0126  SELECT l.id,cat.alias,cat.name,l.total_group,l.group_code FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId WHERE l.status = 1 AND l.group_code = 1 ORDER BY l.year DESC,cat.coefficient DESC,l.group_code ASC LIMIT 21
0.0126  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 1 AND p.author_id = 118698 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0126  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video WHERE 1 AND p.author_id = 118698 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0125  SELECT COUNT(DISTINCT `id`) AS num_total FROM videos WHERE `author_id` = 118698
0.0125  SELECT COUNT(DISTINCT `id`) AS num_total FROM pictures WHERE `author_id` = 118698