• 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

Unión Deportiva Caucetera
Equipo
Ciudad : Caucete

Fundado el 29 de Enero de 1978. Tiempo atrás contaba con hockey femenino en competencias oficiales. En el 2009 lograron conformar la Primera División Masculina para participar en los distintos campeonatos oficiales provinciales y nacionales.

Dirección: Ruta 20 y General Acha, Caucete

Presidente Actual: Carlos Etchenique

Partidos
1º Fecha: 03-03-2017 00:00 Concepción Patín Club 3 : 1 Unión Deportiva Caucetera Detalles
2° Fecha: 08-03-2017 00:00 Unión Deportiva Caucetera 1 : 7 Sindicato Empleados de Comercio (SEC) Detalles
3° Fecha: 17-03-2017 00:00 Deportivo Unión Estudiantil 5 : 6 Unión Deportiva Caucetera Detalles
4º fecha: 21-03-2017 00:00 Unión Deportiva Caucetera 7 : 4 Deportivo Aberastain Detalles
5º Fecha : 31-03-2017 00:00 Olimpia Patín Club 7 : 4 Unión Deportiva Caucetera Detalles
6º Fecha: 05-04-2017 00:00 Unión Deportiva Caucetera 4 : 10 Centro Valenciano Detalles
7* Fecha: 12-04-2017 00:00 Unión Deportiva Caucetera 4 : 4 Unión Deportiva Bancaria 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 Caucetera 3 : 2 Club Atlético Unión 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 Caucetera 2 : 2 Club Sarmiento-Albardon Detalles
13º Fecha : 24-05-2017 00:00 Unión Deportiva Caucetera 5 : 2 Media Agua Detalles
14º Fecha: 31-05-2017 00:00 Hockey Club Huarpes 5 : 2 Unión Deportiva Caucetera Detalles
15º Fecha: 06-06-2017 00:00 Unión Deportiva Caucetera 2 : 3 Colón Jr Detalles
16° Fecha: 09-06-2017 00:00 Atlético Social San Juan 5 : 2 Unión Deportiva Caucetera Detalles
17º Fecha: 14-06-2017 00:00 Unión Deportiva Caucetera 4 : 5 Barrio Rivadavia Detalles
18º Fecha: 21-06-2017 00:00 Unión Vecinal de Trinidad 3 : 8 Unión Deportiva Caucetera Detalles
19º Fecha: 30-06-2017 00:00 Unión Deportiva Caucetera 2 : 2 Banco Hispano Detalles
Jugadores
JugadoresPosición
Federico Fernández
Franco Sirerol
Gastón Velardez
José Williner
Lucas Puentedura
Marco Elaskar
Martín Villegas
Mauricio Fullana
Nicolás Leiva
Pablo Leiva
Roberto López
Fernando RegaladoArquero
Jorge CastroArquero
Lucas NievasArquero
Miguel GarridoDirector Técnico
Fotos

Campeonatos


Quién está en línea?

Tenemos 22 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.056 seconds, 1.31 MB
Application afterRoute: 0.064 seconds, 2.57 MB
Application afterDispatch: 0.121 seconds, 2.90 MB
Application afterRender: 0.200 seconds, 3.71 MB

Memoria usada

3924144

57 queries identificadas

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'cmihnon5bso2etffr9qf8m2843'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1516187016' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'cmihnon5bso2etffr9qf8m2843'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'cmihnon5bso2etffr9qf8m2843','1516187916','','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 = 17
  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 = 17
  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 = 17 OR m.team2_id = 17)
      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 = 17
      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=76
      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=378
      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=222
      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=1110
      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=379
      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=522
      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=78
      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=1215
      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=218
      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=375
      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=1212
      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=214
      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=4
      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=215
      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=46
      WHERE ef.published=1
      AND ef.TYPE = '0'
      AND ef.e_table_view = '1'
      ORDER BY ef.ordering
  32. 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=17
      WHERE ef.published=1
      AND ef.TYPE = '1'
      ORDER BY ef.ordering
  33. SELECT cfg_value
      FROM jos_bl_config
      WHERE cfg_name='date_format'
  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 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
  52. 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:36" )  
      AND (a.publish_down = "0000-00-00 00:00:00" OR a.publish_down >= "2018-01-17 11:18:36" )
      AND cc.id = 106
      AND cc.SECTION = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
  53. SELECT guest, usertype, client_id
      FROM jos_session
      WHERE client_id = 0
  54. 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:36" )  
      AND (a.publish_down = "0000-00-00 00:00:00" OR a.publish_down >= "2018-01-17 11:18:36" )
      AND cc.id = 102
      AND cc.SECTION = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
  55. SELECT `id`
      FROM `jos_components`

      WHERE `option`='com_fpss'

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