Contexto Víctimas en Colombia

DesplazadosTeniendo en cuenta que este fenómeno social presenta un matiz político, económico e histórico, basado en las relaciones de poder y relacionado con el uso ilegítimo e ilegal de la fuerza y de la violencia, en este periodo reciente de tiempo se han mantenido este tipo de prácticas, lo que ha profundizado las grandes desigualdades sociales y económicas del país.

.

Centro de Atención Integral a Población Desplazada



caidBreve descripción

El proyecto CAID parte de reconocer que el conflicto social político y armado que ha vivido el país durante más de cincuenta años sigue dejando víctimas y aumentando de manera exponencial los índices de pobreza y marginalidad en Bogotá y Soacha.

La población en situación de desplazamiento ha sido víctima no solo del conflicto y sus actores armados, sino que al llegar a las ciudades receptoras no ha habido una respuesta efectiva por parte del Estado que permita que las situación de emergencia cese, siendo doblemente vulnerados sus derechos fundamentales.

En este sentido se hace necesario apoyar a la población en situación de desplazamiento para que le exijan al Estado la restitución de sus derechos y logre estabilizarse socio económicamente. Este apoyo debe estar enmarcado desde un análisis psicosocial que evidencie la complejidad del ser humano y sus múltiples dimensiones que se ven afectadas por el desplazamiento y que al mismo tiempo deben ser tenidas en cuenta para una atención con calidad a cada caso particular.

 

Zona de influencia

Bogotá (En las localidades Usme y Ciudad Bolivar ), Soacha e Ibagué.

 

Población

El proyecto atiende a familias víctimas de desplazamiento forzado por conflicto armado, provenientes de diferentes regiones del país y que llegan a Bogotá, Soacha e Ibagué, que siguen presentando altas condiciones de vulnerabilidad social y económica porque el Gobierno no fue ni está siendo garante de sus derechos. Cuya permanencia en éstas sectores no supere un año. Este tiempo se contempla intencionalmente porque durante el primer año de llegada a las ciudades se toman las decisiones y se construyen las redes sociales necesarias para re construir la vida familiar en el nuevo contexto.

 

Objetivo en Bogotá

100 Familias en situación de desplazamiento ubicadas en Bogotá y Soacha, desarrollan y fortalecen herramientas que contribuyen en su estabilización económica y psicosocial desde un enfoque integral.

 

Objetivo en Ibagué

Brindar protección y ayuda humanitaria de emergencia a 250 familias desplazadas, afectadas por el conflicto armado en Colombia.


Ver galería de fotos
fotos

.
hostgator coupon or play poker on party poker

Nos apoyan

Nos apoyan

Copyright 2011 Centro de Atención Integral a Población en Situación de Desplazamiento. 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.571) - afterLoad
Application 0.025 seconds (+0.025); 3.46 MB (+2.890) - afterInitialise
Application 0.035 seconds (+0.009); 4.54 MB (+1.082) - afterRoute
Application 0.069 seconds (+0.035); 7.08 MB (+2.535) - afterDispatch
Application 0.073 seconds (+0.004); 7.25 MB (+0.172) - beforeRenderModule mod_banners (Nos apoyan)
Application 0.077 seconds (+0.004); 7.40 MB (+0.149) - afterRenderModule mod_banners (Nos apoyan)
Application 0.077 seconds (+0.000); 7.41 MB (+0.012) - beforeRenderModule mod_banners (Nos apoyan)
Application 0.079 seconds (+0.002); 7.43 MB (+0.013) - afterRenderModule mod_banners (Nos apoyan)
Application 0.080 seconds (+0.000); 7.44 MB (+0.012) - beforeRenderModule mod_login (Acceso)
Application 0.082 seconds (+0.002); 7.49 MB (+0.056) - afterRenderModule mod_login (Acceso)
Application 0.082 seconds (+0.000); 7.51 MB (+0.018) - beforeRenderModule mod_menu (Correo Institucional)
Application 0.084 seconds (+0.002); 7.59 MB (+0.084) - afterRenderModule mod_menu (Correo Institucional)
Application 0.084 seconds (+0.000); 7.61 MB (+0.015) - beforeRenderModule mod_banners (Enlaces Web)
Application 0.088 seconds (+0.003); 7.64 MB (+0.027) - afterRenderModule mod_banners (Enlaces Web)
Application 0.088 seconds (+0.000); 7.64 MB (+0.001) - beforeRenderModule mod_menu (Áreas estratégicos)
Application 0.090 seconds (+0.002); 7.65 MB (+0.015) - afterRenderModule mod_menu (Áreas estratégicos)
Application 0.090 seconds (+0.000); 7.67 MB (+0.015) - beforeRenderModule mod_menu (Proyectos)
Application 0.092 seconds (+0.003); 7.69 MB (+0.021) - afterRenderModule mod_menu (Proyectos)
Application 0.093 seconds (+0.000); 7.70 MB (+0.015) - beforeRenderModule mod_banners (Publicaciones Mencoldes)
Application 0.095 seconds (+0.002); 7.72 MB (+0.017) - afterRenderModule mod_banners (Publicaciones Mencoldes)
Application 0.095 seconds (+0.000); 7.73 MB (+0.009) - beforeRenderModule mod_menu (Institucional)
Application 0.098 seconds (+0.003); 7.75 MB (+0.023) - afterRenderModule mod_menu (Institucional)
Application 0.101 seconds (+0.003); 7.97 MB (+0.220) - afterRender

Uso de Memoria

8 MB (8,384,312 Bytes)

40 Registro Consultas

  1. SELECT `data`
      FROM `j17_session`
      WHERE `session_id` = '13k87s1rcpvhj2a6st7pdj3ae3'
  2. SELECT `session_id`
      FROM `j17_session`
      WHERE `session_id` = '13k87s1rcpvhj2a6st7pdj3ae3'
      LIMIT 0, 1
  3. INSERT INTO `j17_session` (`session_id`, `client_id`, `time`)
      VALUES ('13k87s1rcpvhj2a6st7pdj3ae3', 0, 1511019260)
  4. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM j17_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  5. SELECT id, rules
      FROM `j17_viewlevels`
  6. 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
  7. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM j17_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  8. 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
  9. 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
  10. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM j17_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  11. SELECT *
      FROM j17_languages
      WHERE published=1
      ORDER BY ordering ASC
  12. SELECT a.rules
      FROM j17_assets AS a
      WHERE a.id = 1
  13. 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=75
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  14. 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 = 75
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-11-18 15:34:20')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-11-18 15:34:20')
      GROUP BY a.id
      ORDER BY c.lft, CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END DESC , a.created
      LIMIT 0, 11
  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 = 75
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-11-18 15:34:20')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-11-18 15:34:20')
      GROUP BY a.id
      ORDER BY c.lft, CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END DESC , a.created
  16. 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=75
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  17. 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-11-18 15:34:20')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-11-18 15:34:20')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 171 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
  18. 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)
  19. 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
  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
      LIMIT 0, 5
  21. UPDATE j17_banners
      SET impmade = (impmade + 1)
      WHERE id = 16
  22. 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)
  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 (67)
      ORDER BY a.sticky DESC,a.ordering
  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
      LIMIT 0, 5
  25. UPDATE j17_banners
      SET impmade = (impmade + 1)
      WHERE id = 15
  26. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM j17_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_contact'
  27. 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)
  28. 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
  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
      LIMIT 0, 8
  30. UPDATE j17_banners
      SET impmade = (impmade + 1)
      WHERE id = 3
  31. UPDATE j17_banners
      SET impmade = (impmade + 1)
      WHERE id = 10
  32. UPDATE j17_banners
      SET impmade = (impmade + 1)
      WHERE id = 12
  33. UPDATE j17_banners
      SET impmade = (impmade + 1)
      WHERE id = 13
  34. UPDATE j17_banners
      SET impmade = (impmade + 1)
      WHERE id = 18
  35. 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)
  36. 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
  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
      LIMIT 0, 5
  38. UPDATE j17_banners
      SET impmade = (impmade + 1)
      WHERE id = 17
  39. UPDATE j17_banners
      SET impmade = (impmade + 1)
      WHERE id = 11
  40. UPDATE `j17_session`
      SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1511019260;s:18:\"session.timer.last\";i:1511019260;s:17:\"session.timer.now\";i:1511019260;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:\"99bed2f2adc4136e306dc3e25d8379a8\";}', `time` = 1511019260
      WHERE `session_id` = '13k87s1rcpvhj2a6st7pdj3ae3'

DESCRIPCION Tipos de consulta Conectados 18, 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:1511019260;s:18:\"session.timer.last\";i:1511019260;s:17:\"session.timer.now\";i:1511019260;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:\"99bed2f2adc4136e306dc3e25d8379a8\";}', `time` = 1511019260
  3. 1 × INSERT INTO `j17_session` (`session_id`, `client_id`, `time`) VALUES ('13k87s1rcpvhj2a6st7pdj3ae3', 0, 1511019260