• 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

Colonias Unidas Richet y Zapata
Equipo
Ciudad : Santa Lucia

Fundado el 30 de Mayo de 1955. Solía haber hockey femenino pero de un tiempo a esta parte se practica solo masculino.

Son conocidos como el “Violeta de Santa Lucia”

Dirección: Benavidez y Angualasto, Santa Lucia.

Partidos
1º Fecha: 01-03-2017 00:00 Unión Vecinal de Trinidad 4 : 4 Colonias Unidas Richet y Zapata Detalles
2° Fecha: 10-03-2017 00:00 Colonias Unidas Richet y Zapata 4 : 4 Banco Hispano Detalles
3° Fecha: 15-03-2017 00:00 Concepción Patín Club 8 : 6 Colonias Unidas Richet y Zapata Detalles
4º fecha: 22-03-2017 00:00 Colonias Unidas Richet y Zapata 2 : 2 Sindicato Empleados de Comercio (SEC) Detalles
5º Fecha : 31-03-2017 00:00 Deportivo Unión Estudiantil 2 : 5 Colonias Unidas Richet y Zapata Detalles
6º Fecha: 05-04-2017 00:00 Colonias Unidas Richet y Zapata 10 : 2 Deportivo Aberastain Detalles
7* Fecha: 12-04-2017 00:00 Olimpia Patín Club 6 : 6 Colonias Unidas Richet y Zapata Detalles
8º Fecha : 19-04-2017 00:00 Colonias Unidas Richet y Zapata 1 : 2 Unión Deportiva Caucetera Detalles
9° Fecha: 02-05-2017 00:00 Unión Deportiva Bancaria 5 : 2 Colonias Unidas Richet y Zapata Detalles
10° Fecha: 07-05-2017 00:00 Colonias Unidas Richet y Zapata 6 : 6 Centro Valenciano Detalles
11º Fecha: 12-05-2017 00:00 Colonias Unidas Richet y Zapata 2 : 4 Club Atlético Unión 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 Colonias Unidas Richet y Zapata 4 : 0 Club Sarmiento-Albardon Detalles
15º Fecha: 06-06-2017 00:00 Colonias Unidas Richet y Zapata 9 : 3 Media Agua Detalles
16° Fecha: 09-06-2017 00:00 Hockey Club Huarpes 1 : 8 Colonias Unidas Richet y Zapata Detalles
17º Fecha: 14-06-2017 00:00 Colonias Unidas Richet y Zapata 9 : 3 Colón Jr Detalles
18º Fecha: 23-06-2017 00:00 Atlético Social San Juan 2 : 4 Colonias Unidas Richet y Zapata Detalles
19º Fecha: 28-06-2017 00:00 Colonias Unidas Richet y Zapata 5 : 3 Barrio Rivadavia Detalles
Jugadores
JugadoresPosición
Abel Chiconi
Alexis Pandolfini
Diego Leanez
Diego Pelicce
Emilio Suarez
Gabriel Montiel
Gabriel Muñoz
Geronimo Braganolo
Gustavo Chiconi
Jorge Ruiz
José Garay
José Rigazzio
Juan Pablo Sánchez
Luis Sánchez
Marcelo Meni
Mariano Romero
Pablo Alvarez
Roberto Barrera
Fabricio RoldánArquero
Fernando NuñezArquero
José BastanteArquero
Luis MárquezArquero
Fotos

Campeonatos


Quién está en línea?

Tenemos 24 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.041 seconds, 1.31 MB
Application afterRoute: 0.049 seconds, 2.57 MB
Application afterDispatch: 0.115 seconds, 2.91 MB
Application afterRender: 0.195 seconds, 3.72 MB

Memoria usada

3933888

64 queries identificadas

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'tclmb2olbbfcmv0fukg25vqit7'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1516187024' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'tclmb2olbbfcmv0fukg25vqit7'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'tclmb2olbbfcmv0fukg25vqit7','1516187924','','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 = 12
  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 = 12
  13. 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 = 12 OR m.team2_id = 12)
      AND m.team1_id = t1.id
      AND m.team2_id = t2.id
      ORDER BY m.m_date
  14. 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 = 12
      ORDER BY p.position_id,p.first_name,p.last_name
  15. 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
  16. 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
  17. 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=129
      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=1088
      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=54
      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=126
      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=131
      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=75
      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=516
      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=451
      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=133
      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=132
      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=74
      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=127
      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=361
      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=1116
      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=134
      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=135
      WHERE ef.published=1
      AND ef.TYPE = '0'
      AND ef.e_table_view = '1'
      ORDER BY ef.ordering
  33. 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=130
      WHERE ef.published=1
      AND ef.TYPE = '0'
      AND ef.e_table_view = '1'
      ORDER BY ef.ordering
  34. 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=316
      WHERE ef.published=1
      AND ef.TYPE = '0'
      AND ef.e_table_view = '1'
      ORDER BY ef.ordering
  35. 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=66
      WHERE ef.published=1
      AND ef.TYPE = '0'
      AND ef.e_table_view = '1'
      ORDER BY ef.ordering
  36. 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=125
      WHERE ef.published=1
      AND ef.TYPE = '0'
      AND ef.e_table_view = '1'
      ORDER BY ef.ordering
  37. 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=301
      WHERE ef.published=1
      AND ef.TYPE = '0'
      AND ef.e_table_view = '1'
      ORDER BY ef.ordering
  38. 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=65
      WHERE ef.published=1
      AND ef.TYPE = '0'
      AND ef.e_table_view = '1'
      ORDER BY ef.ordering
  39. 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=12
      WHERE ef.published=1
      AND ef.TYPE = '1'
      ORDER BY ef.ordering
  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 cfg_value
      FROM jos_bl_config
      WHERE cfg_name='date_format'
  53. SELECT cfg_value
      FROM jos_bl_config
      WHERE cfg_name='date_format'
  54. SELECT cfg_value
      FROM jos_bl_config
      WHERE cfg_name='date_format'
  55. SELECT cfg_value
      FROM jos_bl_config
      WHERE cfg_name='date_format'
  56. SELECT cfg_value
      FROM jos_bl_config
      WHERE cfg_name='date_format'
  57. SELECT cfg_value
      FROM jos_bl_config
      WHERE cfg_name='date_format'
  58. 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
  59. 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:44" )  
      AND (a.publish_down = "0000-00-00 00:00:00" OR a.publish_down >= "2018-01-17 11:18:44" )
      AND cc.id = 106
      AND cc.SECTION = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
  60. SELECT guest, usertype, client_id
      FROM jos_session
      WHERE client_id = 0
  61. 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:45" )  
      AND (a.publish_down = "0000-00-00 00:00:00" OR a.publish_down >= "2018-01-17 11:18:45" )
      AND cc.id = 102
      AND cc.SECTION = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
  62. SELECT `id`
      FROM `jos_components`

      WHERE `option`='com_fpss'

      LIMIT 1
  63. 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:45' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-01-17 11:18:45' )
     
      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
  64. 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:45' )
     
      AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2018-01-17 11:18:45' )
     
      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