• Previous
  • Next
  • Stop
  • Play
  • FSP
  • A2

SEMIFINALES Oficial
SEGUNDA Martes 14/11 Cancha Unión
20:15 Concepción vs Bco Hispano; 21:30 Estudiantil vs Richet
PRIMERA  Miercoles 15/11 Cancha Concepción
20:15 Richet vs Bco Hispano; 21:30 Valenciano vs Social

2° Final Liga A2
Domingo 12/11 20:00hs CANCHA OLIMPIA

BANCARIA vs HUARPES

Lomas de Rivadavia
Equipo
Ciudad : Rivadavia

(antes Loma Negra fundado el 13 de Abril de 1970) Como Lomas de Rivadavia a partir del 2007.

Solo se dedican al hockey masculino.

Pese a cambiar su denominación, siguen siendo conocidos como los “Cementeros”

Presidente Actual: Roberto Campodónico.

Secretario: Orlando Lahoz.

Dirección: Fortabat y Sarmiento, Rivadavia.

(Las fotos del equipo y de los jugadores fueron realizadas y proporcionadas por Emanuel Godoy y Miguel Cassini)

Partidos
1º Fecha: 01-03-2017 00:00 Atlético Social San Juan 9 : 4 Lomas de Rivadavia Detalles
2° Fecha: 10-03-2017 00:00 Lomas de Rivadavia 3 : 3 Barrio Rivadavia Detalles
3° Fecha: 15-03-2017 00:00 Unión Vecinal de Trinidad 5 : 3 Lomas de Rivadavia Detalles
4º fecha: 22-03-2017 00:00 Lomas de Rivadavia 2 : 5 Banco Hispano Detalles
5º Fecha : 02-04-2017 00:00 Concepción Patín Club 6 : 1 Lomas de Rivadavia Detalles
6º Fecha: 05-04-2017 00:00 Lomas de Rivadavia 0 : 7 Sindicato Empleados de Comercio (SEC) Detalles
7* Fecha: 12-04-2017 00:00 Deportivo Unión Estudiantil 3 : 0 Lomas de Rivadavia Detalles
8º Fecha : 21-04-2017 00:00 Lomas de Rivadavia 8 : 6 Deportivo Aberastain Detalles
9° Fecha: 02-05-2017 00:00 Olimpia Patín Club 9 : 5 Lomas de Rivadavia Detalles
10° Fecha: 05-05-2017 00:00 Lomas de Rivadavia 0 : 5 Unión Deportiva Caucetera Detalles
11º Fecha: 10-05-2017 00:00 Unión Deportiva Bancaria 7 : 5 Lomas de Rivadavia Detalles
12º Fecha: 17-05-2017 00:00 Lomas de Rivadavia 2 : 3 Colonias Unidas Richet y Zapata Detalles
13º Fecha : 26-05-2017 00:00 Club Atlético Unión 2 : 3 Lomas de Rivadavia Detalles
14º Fecha: 31-05-2017 00:00 Lomas de Rivadavia 2 : 9 Centro Valenciano Detalles
15º Fecha: 06-06-2017 00:00 Lomas de Rivadavia 3 : 2 Club Sarmiento-Albardon Detalles
17º Fecha: 14-06-2017 00:00 Lomas de Rivadavia 7 : 5 Media Agua Detalles
18º Fecha: 21-06-2017 00:00 Hockey Club Huarpes 2 : 5 Lomas de Rivadavia Detalles
19º Fecha: 28-06-2017 00:00 Lomas de Rivadavia 4 : 3 Colón Jr Detalles
Jugadores
JugadoresPosición
Brian Agüero
Fernando Aldeco
Gabriel Martinez
Guillermo Sosa
Javier Aviles
Jorge Leiva
Juan Navarro
Marcos Sarmiento
Matias Montaña
Mauro Arancibia
Maximiliano Aldeco
Roberto Sánchez
Fernando GonzálezArquero
Carlos MoretaDirector Técnico
Daniel GarcíaPreparador Físico
Fotos

Campeonatos


Quién está en línea?

Tenemos 26 invitados conectado(s)
VTR
VTR
Municipalidad San Juan

Perfíl de la información

Application afterLoad: 0.000 seconds, 0.28 MB
Application afterInitialise: 0.040 seconds, 1.31 MB
Application afterRoute: 0.048 seconds, 2.57 MB
Application afterDispatch: 0.109 seconds, 2.90 MB
Application afterRender: 0.189 seconds, 3.71 MB

Memoria usada

3926360

58 queries identificadas

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'fva01h9cjcl7drcf6hprsktdi5'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1516187032' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'fva01h9cjcl7drcf6hprsktdi5'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'fva01h9cjcl7drcf6hprsktdi5','1516187932','','0','1','0' )
  5. SELECT *
      FROM jos_components
      WHERE parent = 0
  6. SELECT folder AS TYPE, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  7. SELECT m.*, c.`option` AS component
      FROM jos_menu AS m
      LEFT JOIN jos_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  8. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 659)
      ORDER BY menuid DESC
      LIMIT 0, 1
  9. SELECT lang_file
      FROM jos_bl_languages
      WHERE is_default = 1
  10. SELECT *
      FROM jos_bl_teams
      WHERE id = 11
  11. SELECT *
      FROM jos_bl_seasons
      WHERE s_id = 132
  12. SELECT p.ph_name AS name,p.id AS id,p.ph_filename AS filename
      FROM jos_bl_assign_photos AS ap, jos_bl_photos AS p
      WHERE ap.photo_id = p.id
      AND cat_type = 2
      AND cat_id = 11
  13. SELECT ph_filename
      FROM  jos_bl_photos AS p
      WHERE p.id = 1378
  14. SELECT md.m_name,m.id AS mid,m.m_date,m.m_time, t1.t_name AS home, t2.t_name AS away, score1,score2,m.is_extra, m.m_played
      FROM jos_bl_matchday AS md, jos_bl_match AS m, jos_bl_teams AS t1, jos_bl_teams AS t2
      WHERE m.m_id = md.id
      AND md.s_id = 132
      AND m.published = 1
      AND (m.team1_id = 11 OR m.team2_id = 11)
      AND m.team1_id = t1.id
      AND m.team2_id = t2.id
      ORDER BY m.m_date
  15. SELECT *
      FROM jos_bl_players AS p
      LEFT JOIN jos_bl_positions AS ps
      ON p.position_id = ps.p_id
      WHERE p.team_id = 11
      ORDER BY p.position_id,p.first_name,p.last_name
  16. SELECT DISTINCT(ev.id),ev.*
      FROM jos_bl_events AS ev, jos_bl_match_events AS me, jos_bl_match AS m, jos_bl_matchday AS md
      WHERE ev.id = me.e_id
      AND me.match_id = m.id
      AND m.m_id=md.id
      AND md.s_id=132
      AND ev.player_event = 1  
      ORDER BY ev.id
  17. SELECT ef.name
      FROM jos_bl_extra_filds AS ef  
      WHERE ef.published=1
      AND ef.TYPE = '0'
      AND ef.e_table_view = '1'
      ORDER BY ef.ordering
  18. SELECT IF(ev.fvalue <> '',ev.fvalue,'&nbsp;')
      FROM jos_bl_extra_filds AS ef
      LEFT JOIN jos_bl_extra_values AS ev
      ON ef.id=ev.f_id
      AND ev.uid=178
      WHERE ef.published=1
      AND ef.TYPE = '0'
      AND ef.e_table_view = '1'
      ORDER BY ef.ordering
  19. SELECT IF(ev.fvalue <> '',ev.fvalue,'&nbsp;')
      FROM jos_bl_extra_filds AS ef
      LEFT JOIN jos_bl_extra_values AS ev
      ON ef.id=ev.f_id
      AND ev.uid=179
      WHERE ef.published=1
      AND ef.TYPE = '0'
      AND ef.e_table_view = '1'
      ORDER BY ef.ordering
  20. SELECT IF(ev.fvalue <> '',ev.fvalue,'&nbsp;')
      FROM jos_bl_extra_filds AS ef
      LEFT JOIN jos_bl_extra_values AS ev
      ON ef.id=ev.f_id
      AND ev.uid=180
      WHERE ef.published=1
      AND ef.TYPE = '0'
      AND ef.e_table_view = '1'
      ORDER BY ef.ordering
  21. SELECT IF(ev.fvalue <> '',ev.fvalue,'&nbsp;')
      FROM jos_bl_extra_filds AS ef
      LEFT JOIN jos_bl_extra_values AS ev
      ON ef.id=ev.f_id
      AND ev.uid=518
      WHERE ef.published=1
      AND ef.TYPE = '0'
      AND ef.e_table_view = '1'
      ORDER BY ef.ordering
  22. SELECT IF(ev.fvalue <> '',ev.fvalue,'&nbsp;')
      FROM jos_bl_extra_filds AS ef
      LEFT JOIN jos_bl_extra_values AS ev
      ON ef.id=ev.f_id
      AND ev.uid=172
      WHERE ef.published=1
      AND ef.TYPE = '0'
      AND ef.e_table_view = '1'
      ORDER BY ef.ordering
  23. SELECT IF(ev.fvalue <> '',ev.fvalue,'&nbsp;')
      FROM jos_bl_extra_filds AS ef
      LEFT JOIN jos_bl_extra_values AS ev
      ON ef.id=ev.f_id
      AND ev.uid=207
      WHERE ef.published=1
      AND ef.TYPE = '0'
      AND ef.e_table_view = '1'
      ORDER BY ef.ordering
  24. SELECT IF(ev.fvalue <> '',ev.fvalue,'&nbsp;')
      FROM jos_bl_extra_filds AS ef
      LEFT JOIN jos_bl_extra_values AS ev
      ON ef.id=ev.f_id
      AND ev.uid=143
      WHERE ef.published=1
      AND ef.TYPE = '0'
      AND ef.e_table_view = '1'
      ORDER BY ef.ordering
  25. SELECT IF(ev.fvalue <> '',ev.fvalue,'&nbsp;')
      FROM jos_bl_extra_filds AS ef
      LEFT JOIN jos_bl_extra_values AS ev
      ON ef.id=ev.f_id
      AND ev.uid=220
      WHERE ef.published=1
      AND ef.TYPE = '0'
      AND ef.e_table_view = '1'
      ORDER BY ef.ordering
  26. SELECT IF(ev.fvalue <> '',ev.fvalue,'&nbsp;')
      FROM jos_bl_extra_filds AS ef
      LEFT JOIN jos_bl_extra_values AS ev
      ON ef.id=ev.f_id
      AND ev.uid=175
      WHERE ef.published=1
      AND ef.TYPE = '0'
      AND ef.e_table_view = '1'
      ORDER BY ef.ordering
  27. SELECT IF(ev.fvalue <> '',ev.fvalue,'&nbsp;')
      FROM jos_bl_extra_filds AS ef
      LEFT JOIN jos_bl_extra_values AS ev
      ON ef.id=ev.f_id
      AND ev.uid=356
      WHERE ef.published=1
      AND ef.TYPE = '0'
      AND ef.e_table_view = '1'
      ORDER BY ef.ordering
  28. SELECT IF(ev.fvalue <> '',ev.fvalue,'&nbsp;')
      FROM jos_bl_extra_filds AS ef
      LEFT JOIN jos_bl_extra_values AS ev
      ON ef.id=ev.f_id
      AND ev.uid=724
      WHERE ef.published=1
      AND ef.TYPE = '0'
      AND ef.e_table_view = '1'
      ORDER BY ef.ordering
  29. SELECT IF(ev.fvalue <> '',ev.fvalue,'&nbsp;')
      FROM jos_bl_extra_filds AS ef
      LEFT JOIN jos_bl_extra_values AS ev
      ON ef.id=ev.f_id
      AND ev.uid=217
      WHERE ef.published=1
      AND ef.TYPE = '0'
      AND ef.e_table_view = '1'
      ORDER BY ef.ordering
  30. SELECT IF(ev.fvalue <> '',ev.fvalue,'&nbsp;')
      FROM jos_bl_extra_filds AS ef
      LEFT JOIN jos_bl_extra_values AS ev
      ON ef.id=ev.f_id
      AND ev.uid=171
      WHERE ef.published=1
      AND ef.TYPE = '0'
      AND ef.e_table_view = '1'
      ORDER BY ef.ordering
  31. SELECT IF(ev.fvalue <> '',ev.fvalue,'&nbsp;')
      FROM jos_bl_extra_filds AS ef
      LEFT JOIN jos_bl_extra_values AS ev
      ON ef.id=ev.f_id
      AND ev.uid=1098
      WHERE ef.published=1
      AND ef.TYPE = '0'
      AND ef.e_table_view = '1'
      ORDER BY ef.ordering
  32. SELECT IF(ev.fvalue <> '',ev.fvalue,'&nbsp;')
      FROM jos_bl_extra_filds AS ef
      LEFT JOIN jos_bl_extra_values AS ev
      ON ef.id=ev.f_id
      AND ev.uid=1099
      WHERE ef.published=1
      AND ef.TYPE = '0'
      AND ef.e_table_view = '1'
      ORDER BY ef.ordering
  33. SELECT ef.*,ev.fvalue AS fvalue
      FROM jos_bl_extra_filds AS ef
      LEFT JOIN jos_bl_extra_values AS ev
      ON ef.id=ev.f_id
      AND ev.uid=11
      WHERE ef.published=1
      AND ef.TYPE = '1'
      ORDER BY ef.ordering
  34. SELECT cfg_value
      FROM jos_bl_config
      WHERE cfg_name='date_format'
  35. SELECT cfg_value
      FROM jos_bl_config
      WHERE cfg_name='date_format'
  36. SELECT cfg_value
      FROM jos_bl_config
      WHERE cfg_name='date_format'
  37. SELECT cfg_value
      FROM jos_bl_config
      WHERE cfg_name='date_format'
  38. SELECT cfg_value
      FROM jos_bl_config
      WHERE cfg_name='date_format'
  39. SELECT cfg_value
      FROM jos_bl_config
      WHERE cfg_name='date_format'
  40. SELECT cfg_value
      FROM jos_bl_config
      WHERE cfg_name='date_format'
  41. SELECT cfg_value
      FROM jos_bl_config
      WHERE cfg_name='date_format'
  42. SELECT cfg_value
      FROM jos_bl_config
      WHERE cfg_name='date_format'
  43. SELECT cfg_value
      FROM jos_bl_config
      WHERE cfg_name='date_format'
  44. SELECT cfg_value
      FROM jos_bl_config
      WHERE cfg_name='date_format'
  45. SELECT cfg_value
      FROM jos_bl_config
      WHERE cfg_name='date_format'
  46. SELECT cfg_value
      FROM jos_bl_config
      WHERE cfg_name='date_format'
  47. SELECT cfg_value
      FROM jos_bl_config
      WHERE cfg_name='date_format'
  48. SELECT cfg_value
      FROM jos_bl_config
      WHERE cfg_name='date_format'
  49. SELECT cfg_value
      FROM jos_bl_config
      WHERE cfg_name='date_format'
  50. SELECT cfg_value
      FROM jos_bl_config
      WHERE cfg_name='date_format'
  51. SELECT cfg_value
      FROM jos_bl_config
      WHERE cfg_name='date_format'
  52. SELECT id, title, module, POSITION, content, showtitle, control, params
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      AND ( mm.menuid = 659 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  53. SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.name) THEN CONCAT_WS(":", cc.id, cc.name) ELSE cc.id END AS catslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      WHERE a.state = 1  
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = "0000-00-00 00:00:00" OR a.publish_up <= "2018-01-17 11:18:52" )  
      AND (a.publish_down = "0000-00-00 00:00:00" OR a.publish_down >= "2018-01-17 11:18:52" )
      AND cc.id = 106
      AND cc.SECTION = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
  54. SELECT guest, usertype, client_id
      FROM jos_session
      WHERE client_id = 0
  55. SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.name) THEN CONCAT_WS(":", cc.id, cc.name) ELSE cc.id END AS catslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      WHERE a.state = 1  
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = "0000-00-00 00:00:00" OR a.publish_up <= "2018-01-17 11:18:52" )  
      AND (a.publish_down = "0000-00-00 00:00:00" OR a.publish_down >= "2018-01-17 11:18:52" )
      AND cc.id = 102
      AND cc.SECTION = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
  56. SELECT `id`
      FROM `jos_components`

      WHERE `option`='com_fpss'

      LIMIT 1
  57. SELECT a.id, a.introtext, a.sectionid, a.title, s.title AS stitle, cc.title AS ctitle,
     CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,
     CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
     
      FROM jos_content AS a
     
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
     
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
     
      WHERE ( a.state = 1
      AND a.sectionid > 0 )
     
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-01-17 11:18:52' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-01-17 11:18:52' )
     
      AND a.id IN ( SELECT itemlink
      FROM jos_fpss_slides
      WHERE itemlink!=0 )
     
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
     
      AND s.published = 1
     
      AND cc.published = 1
     
      ORDER BY a.created DESC
  58. SELECT *
     
      FROM jos_fpss_slides
     
      WHERE state = 1
     
      AND registers <= 0
     
      AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2018-01-17 11:18:52' )
     
      AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2018-01-17 11:18:52' )
     
      AND catid IN ( 1 )
     
      ORDER BY ordering

0 legado de las queries identificadas

    Archivos de idioma cargados

    Sin traducir las cadenas de diagnóstico

    Ninguno

    Sin traducir las cadenas de diseñador

    Ninguno