• 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 (L)
Equipo
Ciudad : San Juan


Partidos
1° Fecha 1° Rueda: 24-07-2015 00:00 Colonias Unidas Richet y Zapata (L) 5 : 2 Club Atletico Unión (L) Detalles
4° Fecha 1° Rueda: 02-08-2015 00:00 Colonias Unidas Richet y Zapata (L) 9 : 0 Andes Talleres (L) Detalles
3° Fecha 1° Rueda: 07-08-2015 00:00 Banco Hispano (L) 4 : 4 Colonias Unidas Richet y Zapata (L) Detalles
7° Fecha 1° Rueda: 21-08-2015 00:00 Colonias Unidas Richet y Zapata (L) 6 : 5 Sindicato Empleados de Comercio (L) Detalles
6° Fecha 1° Rueda: 26-08-2015 00:00 Casa de Italia (L) 3 : 6 Colonias Unidas Richet y Zapata (L) Detalles
5° Fecha 1° Rueda: 29-08-2015 00:00 GEBA (L) 2 : 5 Colonias Unidas Richet y Zapata (L) Detalles
1° Fecha 2° Rueda: 05-09-2015 00:00 Club Atletico Unión (L) 2 : 2 Colonias Unidas Richet y Zapata (L) Detalles
3° Fecha 2° Rueda: 25-09-2015 00:00 Colonias Unidas Richet y Zapata (L) 4 : 4 Banco Hispano (L) Detalles
4° Fecha 2° Rueda: 10-10-2015 00:00 Andes Talleres (L) 6 : 6 Colonias Unidas Richet y Zapata (L) Detalles
5° Fecha 2° Rueda: 12-10-2015 00:00 Colonias Unidas Richet y Zapata (L) 5 : 5 GEBA (L) Detalles
6° Fecha 2° Rueda: 01-11-2015 00:00 Colonias Unidas Richet y Zapata (L) 12 : 2 Casa de Italia (L) Detalles
7° Fecha 2° Rueda: 06-11-2015 00:00 Sindicato Empleados de Comercio (L) 3 : 3 Colonias Unidas Richet y Zapata (L) Detalles
Jugadores

Campeonatos


Quién está en línea?

Tenemos 71 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.801 seconds, 1.31 MB
Application afterRoute: 0.809 seconds, 2.57 MB
Application afterDispatch: 0.841 seconds, 2.86 MB
Application afterRender: 0.919 seconds, 3.67 MB

Memoria usada

3875768

36 queries identificadas

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'lmeqrqjn8b9hmrv5jaqk4mcb75'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1516187158' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'lmeqrqjn8b9hmrv5jaqk4mcb75'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'lmeqrqjn8b9hmrv5jaqk4mcb75','1516188058','','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 = 632)
      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 = 107
  11. SELECT *
      FROM jos_bl_seasons
      WHERE s_id = 111
  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 = 107
  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 = 111
      AND m.published = 1
      AND (m.team1_id = 107 OR m.team2_id = 107)
      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 = 107
      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=111
      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 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=107
      WHERE ef.published=1
      AND ef.TYPE = '1'
      ORDER BY ef.ordering
  18. SELECT cfg_value
      FROM jos_bl_config
      WHERE cfg_name='date_format'
  19. SELECT cfg_value
      FROM jos_bl_config
      WHERE cfg_name='date_format'
  20. SELECT cfg_value
      FROM jos_bl_config
      WHERE cfg_name='date_format'
  21. SELECT cfg_value
      FROM jos_bl_config
      WHERE cfg_name='date_format'
  22. SELECT cfg_value
      FROM jos_bl_config
      WHERE cfg_name='date_format'
  23. SELECT cfg_value
      FROM jos_bl_config
      WHERE cfg_name='date_format'
  24. SELECT cfg_value
      FROM jos_bl_config
      WHERE cfg_name='date_format'
  25. SELECT cfg_value
      FROM jos_bl_config
      WHERE cfg_name='date_format'
  26. SELECT cfg_value
      FROM jos_bl_config
      WHERE cfg_name='date_format'
  27. SELECT cfg_value
      FROM jos_bl_config
      WHERE cfg_name='date_format'
  28. SELECT cfg_value
      FROM jos_bl_config
      WHERE cfg_name='date_format'
  29. SELECT cfg_value
      FROM jos_bl_config
      WHERE cfg_name='date_format'
  30. 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 = 632 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  31. 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:20:58" )  
      AND (a.publish_down = "0000-00-00 00:00:00" OR a.publish_down >= "2018-01-17 11:20:58" )
      AND cc.id = 106
      AND cc.SECTION = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
  32. SELECT guest, usertype, client_id
      FROM jos_session
      WHERE client_id = 0
  33. 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:20:58" )  
      AND (a.publish_down = "0000-00-00 00:00:00" OR a.publish_down >= "2018-01-17 11:20:58" )
      AND cc.id = 102
      AND cc.SECTION = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
  34. SELECT `id`
      FROM `jos_components`

      WHERE `option`='com_fpss'

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