ACT- Emergencias

Breve descripción

La propuesta de acompañamiento de Mencoldes se enmarca en la propuesta nacional que desarrolla la Alianza ACT que tiene como finalidad “Mitigar los efectos de la emergencia invernal del último bimestre de 2010 en 34 comunidades rurales en riesgo y/o en situación de desplazamiento y en comunidades urbanas desplazadas de los departamento de Cundinamarca, Valle del Cauca, Chocó, Córdoba, Atlántico y Bolívar, donde miembros del Foro ACT Colombia tienen trabajo permanente”.

Mencoldes ejecuta el proyecto de emergencia desde una perspectiva de desarrollo a través de la estrategia de formación y organización comunitaria orientada a un proceso de promoción, fortalecimiento y consolidación comunitaria, por medio del acompañamiento intencional e integral en el que se incluye el análisis de la realidad, el desarrollo de capacidades individuales y colectivas y la construcción de condiciones relacionales propicias con el propósito de alcanzar objetivos, satisfacer necesidades y resolver problemas colectivos.

Objetivo General

Fortalecer la capacidad de organización comunitaria de las familias afectadas por la emergencia invernal en los barrios El Progreso, El Arroyo y Nueva Unión para disminuir su nivel de vulnerabilidad.

Población participante

89 familias de 3 comunidades urbanas, algunas en situación de desplazamiento de los barrios El Progreso, El Arroyo y Nueva Unión de la comuna 4 del municipio de Soacha.

El proyecto acompaña familias en doble afectación: violación de derechos por los efectos del conflicto armado (condición de desplazamiento, riesgo de vinculación a grupos armados, control del territorio) y la emergencia invernal.

Zona de influencia

El municipio de Soacha está caracterizado por un alto número de familias en situación de desplazamiento por el conflicto armado y un crecimiento demográfico acelerado, que ha complejizado las condiciones de vida digna y el goce efectivo de los derechos de sus habitantes. Lo anterior, ligado a inadecuadas políticas de ordenamiento territorial ha favorecido la venta de lotes y la construcción de viviendas por parte de urbanizadores piratas, el 50% corresponde a viviendas ilegales y el 30% se ubican en zonas de alto riesgo natural.

Otro factor que complezija la situación en Soacha es la ola invernal, la cual ha tenido efectos en el municipio acelerando deslizamientos de tierra, situación que es constante especialmente por las condiciones topográficas de la zona. Esta situación de emergencia ha afectado la infraestructura de viviendas y zonas comunes, además de limitar el acceso a servicios básicos.

.
hostgator coupon or play poker on party poker

Nos apoyan

Nos apoyan

Copyright 2011 ACT- Emergencias. Fundación Mencoldes Cra 15 No 32-78 tel 3200314, 2880409 Bogotá - Colombia
Joomla Templates by Wordpress themes free

Información de Perfil

Application 0.000 seconds (+0.000); 0.57 MB (+0.570) - afterLoad
Application 0.027 seconds (+0.027); 3.46 MB (+2.890) - afterInitialise
Application 0.039 seconds (+0.012); 4.70 MB (+1.240) - afterRoute
Application 0.061 seconds (+0.022); 6.65 MB (+1.951) - afterDispatch
Application 0.065 seconds (+0.004); 6.83 MB (+0.179) - beforeRenderModule mod_banners (Nos apoyan)
Application 0.069 seconds (+0.004); 7.03 MB (+0.202) - afterRenderModule mod_banners (Nos apoyan)
Application 0.069 seconds (+0.000); 7.04 MB (+0.012) - beforeRenderModule mod_banners (Nos apoyan)
Application 0.071 seconds (+0.002); 7.06 MB (+0.014) - afterRenderModule mod_banners (Nos apoyan)
Application 0.071 seconds (+0.000); 7.07 MB (+0.012) - beforeRenderModule mod_login (Acceso)
Application 0.074 seconds (+0.002); 7.13 MB (+0.056) - afterRenderModule mod_login (Acceso)
Application 0.074 seconds (+0.000); 7.14 MB (+0.018) - beforeRenderModule mod_menu (Correo Institucional)
Application 0.076 seconds (+0.002); 7.23 MB (+0.084) - afterRenderModule mod_menu (Correo Institucional)
Application 0.077 seconds (+0.000); 7.24 MB (+0.015) - beforeRenderModule mod_banners (Enlaces Web)
Application 0.080 seconds (+0.003); 7.27 MB (+0.027) - afterRenderModule mod_banners (Enlaces Web)
Application 0.080 seconds (+0.000); 7.27 MB (+0.001) - beforeRenderModule mod_menu (Áreas estratégicos)
Application 0.082 seconds (+0.002); 7.28 MB (+0.015) - afterRenderModule mod_menu (Áreas estratégicos)
Application 0.082 seconds (+0.000); 7.30 MB (+0.015) - beforeRenderModule mod_menu (Proyectos)
Application 0.084 seconds (+0.002); 7.32 MB (+0.021) - afterRenderModule mod_menu (Proyectos)
Application 0.085 seconds (+0.000); 7.34 MB (+0.015) - beforeRenderModule mod_banners (Publicaciones Mencoldes)
Application 0.087 seconds (+0.002); 7.35 MB (+0.017) - afterRenderModule mod_banners (Publicaciones Mencoldes)
Application 0.087 seconds (+0.000); 7.36 MB (+0.009) - beforeRenderModule mod_menu (Institucional)
Application 0.090 seconds (+0.003); 7.38 MB (+0.023) - afterRenderModule mod_menu (Institucional)
Application 0.093 seconds (+0.003); 7.60 MB (+0.218) - afterRender

Uso de Memoria

7.62 MB (7,995,248 Bytes)

44 Registro Consultas

  1. SELECT `data`
      FROM `j17_session`
      WHERE `session_id` = '8mjj8vlpr4hrq05bm7d84ndq42'
  2. DELETE
      FROM `j17_session`
      WHERE `time` < 1513585905
  3. SELECT `session_id`
      FROM `j17_session`
      WHERE `session_id` = '8mjj8vlpr4hrq05bm7d84ndq42'
      LIMIT 0, 1
  4. INSERT INTO `j17_session` (`session_id`, `client_id`, `time`)
      VALUES ('8mjj8vlpr4hrq05bm7d84ndq42', 0, 1513586805)
  5. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM j17_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  6. SELECT id, rules
      FROM `j17_viewlevels`
  7. SELECT folder AS type, element AS name, params
      FROM j17_extensions
      WHERE enabled >= 1
      AND type ='plugin'
      AND state >= 0
      AND access IN (1,1)
      ORDER BY ordering
  8. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM j17_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  9. SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
      FROM j17_menu AS m
      LEFT JOIN j17_extensions AS e
      ON m.component_id = e.extension_id
      WHERE m.published = 1
      AND m.parent_id > 0
      AND m.client_id = 0
      AND m.access IN (1,1)
      ORDER BY m.lft
  10. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM j17_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  11. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
      FROM j17_categories as c
      LEFT JOIN j17_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      LEFT JOIN (SELECT cat.id as id
      FROM j17_categories AS cat JOIN j17_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1)
      AND c.published = 1
      AND s.id=95
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  12. SELECT alias, catid
      FROM j17_content
      WHERE id = 95
  13. SELECT id, home, template, s.params
      FROM j17_template_styles as s
      LEFT JOIN j17_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
      WHERE s.client_id = 0
      AND e.enabled = 1
  14. SELECT *
      FROM j17_languages
      WHERE published=1
      ORDER BY ordering ASC
  15. SELECT a.rules
      FROM j17_assets AS a
      WHERE a.id = 1
  16. SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count
      FROM j17_content AS a
      LEFT JOIN j17_categories AS c
      on c.id = a.catid
      LEFT JOIN j17_users AS u
      on u.id = a.created_by
      LEFT JOIN j17_contact_details AS contact
      on contact.user_id = a.created_by
      LEFT JOIN j17_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN j17_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM j17_categories AS cat JOIN j17_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published <= 0
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE a.id = 95
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-12-18 08:46:46')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-12-18 08:46:46')
  17. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
      FROM j17_categories as c
      LEFT JOIN j17_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      LEFT JOIN (SELECT cat.id as id
      FROM j17_categories AS cat JOIN j17_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1)
      AND c.published = 1
      AND s.id=78
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  18. SELECT a.id, 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 j17_content AS a
      LEFT JOIN j17_categories AS cc
      ON cc.id = a.catid
      WHERE a.catid = 78
      AND a.state = 1
      AND (a.state = 1 OR a.state = -1)
      AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2017-12-18 08:46:46')
      AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2017-12-18 08:46:46')
      ORDER BY a.created
  19. UPDATE j17_content
      SET hits = hits + 1
      WHERE id = 95
  20. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
      FROM j17_modules AS m
      LEFT JOIN j17_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN j17_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
      WHERE m.published = 1
      AND e.enabled = 1
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2017-12-18 08:46:46')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-12-18 08:46:46')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 175 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
  21. SELECT *
      FROM j17_banners
      WHERE NOW() >= `reset`
      AND `reset` != '0000-00-00 00:00:00'
      AND `reset`!=NULL
      AND (`checked_out` = 0 OR `checked_out` = 0)
  22. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
      FROM j17_banners as a
      LEFT JOIN j17_banner_clients AS cl
      ON cl.id = a.cid
      LEFT JOIN j17_categories as cat
      ON a.catid = cat.id
      WHERE a.state=1
      AND (NOW() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
      AND (NOW() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
      AND a.cid = 1
      AND cl.state = 1
      AND a.catid IN (69)
      ORDER BY a.sticky DESC,a.ordering
  23. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
      FROM j17_banners as a
      LEFT JOIN j17_banner_clients AS cl
      ON cl.id = a.cid
      LEFT JOIN j17_categories as cat
      ON a.catid = cat.id
      WHERE a.state=1
      AND (NOW() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
      AND (NOW() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
      AND a.cid = 1
      AND cl.state = 1
      AND a.catid IN (69)
      ORDER BY a.sticky DESC,a.ordering
      LIMIT 0, 5
  24. UPDATE j17_banners
      SET impmade = (impmade + 1)
      WHERE id = 16
  25. SELECT *
      FROM j17_banners
      WHERE NOW() >= `reset`
      AND `reset` != '0000-00-00 00:00:00'
      AND `reset`!=NULL
      AND (`checked_out` = 0 OR `checked_out` = 0)
  26. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
      FROM j17_banners as a
      LEFT JOIN j17_banner_clients AS cl
      ON cl.id = a.cid
      LEFT JOIN j17_categories as cat
      ON a.catid = cat.id
      WHERE a.state=1
      AND (NOW() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
      AND (NOW() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
      AND a.cid = 1
      AND cl.state = 1
      AND a.catid IN (67)
      ORDER BY a.sticky DESC,a.ordering
  27. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
      FROM j17_banners as a
      LEFT JOIN j17_banner_clients AS cl
      ON cl.id = a.cid
      LEFT JOIN j17_categories as cat
      ON a.catid = cat.id
      WHERE a.state=1
      AND (NOW() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
      AND (NOW() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
      AND a.cid = 1
      AND cl.state = 1
      AND a.catid IN (67)
      ORDER BY a.sticky DESC,a.ordering
      LIMIT 0, 5
  28. UPDATE j17_banners
      SET impmade = (impmade + 1)
      WHERE id = 15
  29. SELECT alias, catid
      FROM j17_content
      WHERE id = 95
  30. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM j17_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_contact'
  31. SELECT *
      FROM j17_banners
      WHERE NOW() >= `reset`
      AND `reset` != '0000-00-00 00:00:00'
      AND `reset`!=NULL
      AND (`checked_out` = 0 OR `checked_out` = 0)
  32. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
      FROM j17_banners as a
      LEFT JOIN j17_banner_clients AS cl
      ON cl.id = a.cid
      LEFT JOIN j17_categories as cat
      ON a.catid = cat.id
      WHERE a.state=1
      AND (NOW() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
      AND (NOW() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
      AND a.cid = 2
      AND cl.state = 1
      AND a.catid IN (40)
      ORDER BY a.sticky DESC,a.ordering
  33. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
      FROM j17_banners as a
      LEFT JOIN j17_banner_clients AS cl
      ON cl.id = a.cid
      LEFT JOIN j17_categories as cat
      ON a.catid = cat.id
      WHERE a.state=1
      AND (NOW() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
      AND (NOW() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
      AND a.cid = 2
      AND cl.state = 1
      AND a.catid IN (40)
      ORDER BY a.sticky DESC,a.ordering
      LIMIT 0, 8
  34. UPDATE j17_banners
      SET impmade = (impmade + 1)
      WHERE id = 3
  35. UPDATE j17_banners
      SET impmade = (impmade + 1)
      WHERE id = 10
  36. UPDATE j17_banners
      SET impmade = (impmade + 1)
      WHERE id = 12
  37. UPDATE j17_banners
      SET impmade = (impmade + 1)
      WHERE id = 13
  38. UPDATE j17_banners
      SET impmade = (impmade + 1)
      WHERE id = 18
  39. SELECT *
      FROM j17_banners
      WHERE NOW() >= `reset`
      AND `reset` != '0000-00-00 00:00:00'
      AND `reset`!=NULL
      AND (`checked_out` = 0 OR `checked_out` = 0)
  40. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
      FROM j17_banners as a
      LEFT JOIN j17_banner_clients AS cl
      ON cl.id = a.cid
      LEFT JOIN j17_categories as cat
      ON a.catid = cat.id
      WHERE a.state=1
      AND (NOW() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
      AND (NOW() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
      AND a.cid = 2
      AND cl.state = 1
      AND a.catid IN (39)
      ORDER BY a.sticky DESC,a.ordering
  41. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
      FROM j17_banners as a
      LEFT JOIN j17_banner_clients AS cl
      ON cl.id = a.cid
      LEFT JOIN j17_categories as cat
      ON a.catid = cat.id
      WHERE a.state=1
      AND (NOW() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
      AND (NOW() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
      AND a.cid = 2
      AND cl.state = 1
      AND a.catid IN (39)
      ORDER BY a.sticky DESC,a.ordering
      LIMIT 0, 5
  42. UPDATE j17_banners
      SET impmade = (impmade + 1)
      WHERE id = 17
  43. UPDATE j17_banners
      SET impmade = (impmade + 1)
      WHERE id = 11
  44. UPDATE `j17_session`
      SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1513586805;s:18:\"session.timer.last\";i:1513586805;s:17:\"session.timer.now\";i:1513586805;s:22:\"session.client.browser\";s:39:\"CCBot/2.0 (http://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"02bd3cf52382fac663accea3e430d3c6\";}', `time` = 1513586806
      WHERE `session_id` = '8mjj8vlpr4hrq05bm7d84ndq42'

DESCRIPCION Tipos de consulta Conectados 21, por orden de suceso

SELECCIONAR Tablas:
  1. 8 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions FROM j17_banners as a LEFT JOIN j17_banner_clients AS cl ON cl.id = a.cid LEFT JOIN j17_categories as cat ON a.catid = cat.id
  2. 4 × SELECT * FROM j17_banners
  3. 4 × SELECT extension_id AS "id", element AS "option", params, enabled FROM j17_extensions
  4. 2 × SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug FROM j17_categories as c LEFT JOIN j17_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM j17_categories AS cat JOIN j17_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  5. 2 × SELECT alias, catid FROM j17_content
  6. 1 × SELECT a.id, 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 j17_content AS a LEFT JOIN j17_categories AS cc ON cc.id = a.catid
  7. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM j17_modules AS m LEFT JOIN j17_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN j17_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
  8. 1 × SELECT id, rules FROM `j17_viewlevels
  9. 1 × SELECT `session_id` FROM `j17_session`
  10. 1 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count FROM j17_content AS a LEFT JOIN j17_categories AS c on c.id = a.catid LEFT JOIN j17_users AS u on u.id = a.created_by LEFT JOIN j17_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN j17_categories as parent ON parent.id = c.parent_id LEFT JOIN j17_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM j17_categories AS cat JOIN j17_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  11. 1 × SELECT a.rules FROM j17_assets AS a
  12. 1 × SELECT folder AS type, element AS name, params FROM j17_extensions
  13. 1 × SELECT `data` FROM `j17_session`
  14. 1 × SELECT id, home, template, s.params FROM j17_template_styles as s LEFT JOIN j17_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
  15. 1 × SELECT * FROM j17_languages
  16. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM j17_menu AS m LEFT JOIN j17_extensions AS e ON m.component_id = e.extension_id
OTRAS Tablas:
  1. 9 × UPDATE j17_banners SET impmade = (impmade + 1)
  2. 1 × UPDATE `j17_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1513586805;s:18:\"session.timer.last\";i:1513586805;s:17:\"session.timer.now\";i:1513586805;s:22:\"session.client.browser\";s:39:\"CCBot/2.0 (http://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"02bd3cf52382fac663accea3e430d3c6\";}', `time` = 1513586806
  3. 1 × UPDATE j17_content SET hits = hits + 1
  4. 1 × INSERT INTO `j17_session` (`session_id`, `client_id`, `time`) VALUES ('8mjj8vlpr4hrq05bm7d84ndq42', 0, 1513586805
  5. 1 × DELETE FROM `j17_session`