Centro por una Cultura de la Esperanza

Descripción

LogoEl Centro por una Cultura de la Esperanza (CPCE) es un programa que acompaña y promueve el ejercicio y exigibilidad de derechos a través de procesos de encuentro, intercambio, aprendizaje, socialización y capacitación.

El programa cuenta con un centro comunitario que sirve para que niños, niñas, adolescentes y jóvenes del sector de influencia (Soacha comunas 3 y 4) accedan a condiciones que favorezcan el ejercicio pleno de los derechos. Se adelantan procesos formativos que promueven el diálogo intercultural, la vida saludable, la productividad y autogestión. Además de los procesos de interlocución que favorecen acciones de incidencia en el municipio.

El CPCE cuenta con una oferta para la población infantil y juvenil que promueve acciones alternativas que favorezcan el ejercicio pleno de sus habilidades psicosociales, de sus derechos y de su expresión artística; todo esto entendido como estrategia de promoción de factores de protección en un contexto de violencia, marginación, exclusión y empobrecimiento. 
 

Objetivo General

Acompañar y promover el ejercicio y exigibilidad de derechos de la población joven del municipio de Soacha a través del desarrollo y fortalecimiento de habilidades individuales y comunitarias para el mejoramiento de su calidad de vida.

 

Población participante

La población participante en el programa son 160 niños, niñas, adolescentes y jóvenes, junto con sus familias.


Zona de influencia

La dinámica del conflicto armado en el municipio de Soacha, especialmente lo que se refiere a la llegada de familias en situación de desplazamiento y el riesgo de vinculación o reclutamiento de NNAJ por parte de grupos armado presentes en el territorio; las falencias de gobernabilidad representadas en la ausencia de programas y políticas que respondan a las problemáticas de la población; el crecimiento demográfico y la ubicación de un gran número de familias en zonas periféricas, marginales y excluyentes del municipio evidencian la compleja situación que enfrenta la población soachuna, la cual se resume en una evidente violación de los derechos económicos, sociales, culturales y ambientales, junto con limitada información para hacer exigible el ejercicio de los derechos.

Estas condiciones se evidencian con mayor claridad en algunas zonas del municipio, entre las cuales la Fundación MENCOLDES ha identificado dos zonas y en las cuales desarrolla este programa. EL Programa CPCE tienen influencia en la comuna 3 de Soacha barrios los Olivos I, II y II, igualmente en los barrios La Isla, Robles y Oasis de la Comuna 4 del mismo.

 

Ver galería de fotos

viñeta

.
hostgator coupon or play poker on party poker

Nos apoyan

Nos apoyan

Copyright 2011 Centro por una Cultura de la Esperanza. 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.028 seconds (+0.027); 3.46 MB (+2.890) - afterInitialise
Application 0.037 seconds (+0.009); 4.54 MB (+1.082) - afterRoute
Application 0.068 seconds (+0.031); 7.05 MB (+2.504) - afterDispatch
Application 0.072 seconds (+0.004); 7.22 MB (+0.172) - beforeRenderModule mod_banners (Nos apoyan)
Application 0.075 seconds (+0.004); 7.37 MB (+0.149) - afterRenderModule mod_banners (Nos apoyan)
Application 0.075 seconds (+0.000); 7.38 MB (+0.012) - beforeRenderModule mod_banners (Nos apoyan)
Application 0.077 seconds (+0.002); 7.39 MB (+0.013) - afterRenderModule mod_banners (Nos apoyan)
Application 0.078 seconds (+0.000); 7.40 MB (+0.012) - beforeRenderModule mod_login (Acceso)
Application 0.080 seconds (+0.002); 7.46 MB (+0.056) - afterRenderModule mod_login (Acceso)
Application 0.080 seconds (+0.000); 7.48 MB (+0.018) - beforeRenderModule mod_menu (Correo Institucional)
Application 0.082 seconds (+0.002); 7.56 MB (+0.084) - afterRenderModule mod_menu (Correo Institucional)
Application 0.083 seconds (+0.000); 7.58 MB (+0.015) - beforeRenderModule mod_banners (Enlaces Web)
Application 0.086 seconds (+0.003); 7.60 MB (+0.027) - afterRenderModule mod_banners (Enlaces Web)
Application 0.086 seconds (+0.000); 7.60 MB (+0.001) - beforeRenderModule mod_menu (Áreas estratégicos)
Application 0.088 seconds (+0.002); 7.62 MB (+0.015) - afterRenderModule mod_menu (Áreas estratégicos)
Application 0.088 seconds (+0.000); 7.63 MB (+0.015) - beforeRenderModule mod_menu (Proyectos)
Application 0.091 seconds (+0.003); 7.66 MB (+0.021) - afterRenderModule mod_menu (Proyectos)
Application 0.091 seconds (+0.000); 7.67 MB (+0.015) - beforeRenderModule mod_banners (Publicaciones Mencoldes)
Application 0.093 seconds (+0.002); 7.69 MB (+0.017) - afterRenderModule mod_banners (Publicaciones Mencoldes)
Application 0.093 seconds (+0.000); 7.70 MB (+0.009) - beforeRenderModule mod_menu (Institucional)
Application 0.096 seconds (+0.003); 7.72 MB (+0.023) - afterRenderModule mod_menu (Institucional)
Application 0.100 seconds (+0.003); 7.94 MB (+0.220) - afterRender

Uso de Memoria

7.96 MB (8,350,424 Bytes)

41 Registro Consultas

  1. SELECT `data`
      FROM `j17_session`
      WHERE `session_id` = '67pm23fi1o4q1qb29628lnrmi7'
  2. DELETE
      FROM `j17_session`
      WHERE `time` < 1506228057
  3. SELECT `session_id`
      FROM `j17_session`
      WHERE `session_id` = '67pm23fi1o4q1qb29628lnrmi7'
      LIMIT 0, 1
  4. INSERT INTO `j17_session` (`session_id`, `client_id`, `time`)
      VALUES ('67pm23fi1o4q1qb29628lnrmi7', 0, 1506228957)
  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 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
  11. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM j17_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  12. SELECT *
      FROM j17_languages
      WHERE published=1
      ORDER BY ordering ASC
  13. SELECT a.rules
      FROM j17_assets AS a
      WHERE a.id = 1
  14. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
      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
      LEFT JOIN `j17_content` AS i
      ON i.`catid` = c.id
      AND i.state = 1
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1)
      AND c.published = 1
      AND s.id=55
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  15. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,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,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
      FROM j17_content AS a
      LEFT JOIN j17_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN j17_categories AS c
      ON c.id = a.catid
      LEFT JOIN j17_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN j17_users AS uam
      ON uam.id = a.modified_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 != 1
      GROUP BY cat.id ) AS badcats
      ON badcats.id = c.id
      WHERE a.access IN (1,1)
      AND a.catid = 55
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-09-24 04:55:57')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-09-24 04:55:57')
      GROUP BY a.id
      ORDER BY c.lft, CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END , a.created
      LIMIT 0, 11
  16. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,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,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
      FROM j17_content AS a
      LEFT JOIN j17_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN j17_categories AS c
      ON c.id = a.catid
      LEFT JOIN j17_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN j17_users AS uam
      ON uam.id = a.modified_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 != 1
      GROUP BY cat.id ) AS badcats
      ON badcats.id = c.id
      WHERE a.access IN (1,1)
      AND a.catid = 55
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-09-24 04:55:57')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-09-24 04:55:57')
      GROUP BY a.id
      ORDER BY c.lft, CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END , a.created
  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=55
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  18. 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-09-24 04:55:57')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-09-24 04:55:57')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 145 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
  19. 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)
  20. 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
  21. 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
  22. UPDATE j17_banners
      SET impmade = (impmade + 1)
      WHERE id = 16
  23. 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)
  24. 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
  25. 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
  26. UPDATE j17_banners
      SET impmade = (impmade + 1)
      WHERE id = 15
  27. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM j17_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_contact'
  28. 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)
  29. 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
  30. 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
  31. UPDATE j17_banners
      SET impmade = (impmade + 1)
      WHERE id = 3
  32. UPDATE j17_banners
      SET impmade = (impmade + 1)
      WHERE id = 10
  33. UPDATE j17_banners
      SET impmade = (impmade + 1)
      WHERE id = 12
  34. UPDATE j17_banners
      SET impmade = (impmade + 1)
      WHERE id = 13
  35. UPDATE j17_banners
      SET impmade = (impmade + 1)
      WHERE id = 18
  36. 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)
  37. 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
  38. 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
  39. UPDATE j17_banners
      SET impmade = (impmade + 1)
      WHERE id = 17
  40. UPDATE j17_banners
      SET impmade = (impmade + 1)
      WHERE id = 11
  41. UPDATE `j17_session`
      SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1506228957;s:18:\"session.timer.last\";i:1506228957;s:17:\"session.timer.now\";i:1506228957;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:\"de3e78a60f58d855f32dc08de973e821\";}', `time` = 1506228957
      WHERE `session_id` = '67pm23fi1o4q1qb29628lnrmi7'

DESCRIPCION Tipos de consulta Conectados 19, 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 extension_id AS "id", element AS "option", params, enabled FROM j17_extensions
  3. 4 × SELECT * FROM j17_banners
  4. 2 × SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,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,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM j17_content AS a LEFT JOIN j17_content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN j17_categories AS c ON c.id = a.catid LEFT JOIN j17_users AS ua ON ua.id = a.created_by LEFT JOIN j17_users AS uam ON uam.id = a.modified_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
  5. 1 × SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems 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
  6. 1 × 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
  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 a.rules FROM j17_assets AS a
  9. 1 × SELECT * FROM j17_languages
  10. 1 × SELECT id, rules FROM `j17_viewlevels
  11. 1 × SELECT `session_id` FROM `j17_session`
  12. 1 × SELECT folder AS type, element AS name, params FROM j17_extensions
  13. 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
  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 `data` FROM `j17_session`
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:1506228957;s:18:\"session.timer.last\";i:1506228957;s:17:\"session.timer.now\";i:1506228957;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:\"de3e78a60f58d855f32dc08de973e821\";}', `time` = 1506228957
  3. 1 × INSERT INTO `j17_session` (`session_id`, `client_id`, `time`) VALUES ('67pm23fi1o4q1qb29628lnrmi7', 0, 1506228957
  4. 1 × DELETE FROM `j17_session`