Enlaces | Notícias | Inicio | Bienvenida!

Menú principal Bienvenida! Quiénes Somos Mapas y Datos Planes de Desarrollo Agentes de Planificación Biblioteca SINPET Prototipo IDE Acceso Usuarios Usuario clave Recordarme ¿Recuperar clave?   Bienvenida! Bienvenido al módulo de Control de Agentes de Planificación! Miércoles, 14 de Octubre de 2009 Tanto a nivel local como central, existe una diversidad de actores individuales e institucionales que trabajan en el tema de la planificación territorial. Con el fin de conocerlos, dentro del Sistema Nacional de Planificación –SNP- se ha dedicado un espacio específico para este fin; el  registro de AGENTES DE PLANIFICACION, que permite identificar, almacenar y consultar información acerca de los agentes de planificación.  Este Registro contempla: Registro de Personas, donde se almacena la información individual de cada uno de los agentes de planificación. Registro de Instituciones, donde se podrá encontrar los datos de todas las instituciones centrales (ministerios, secretarias, etc), locales (municipalidades, consejos, etc), internacionales (agencias de cooperación internacional, ONG’s, etc), académicas (universidades, centros de estudios, etc), y privadas, relacionadas al tema de planificación estratégica territorial. Registro de Capacitaciones, en el cual se identificarán los eventos de capacitación organizados por SEGEPLAN. Leer más...   Cartelera   ::: Bienvenido al módulo de Control de Agentes de Planificación!   ::: Mapas Indice de Marginación por Municipio y Lugar Poblado   ::: cuadros excel de indice de marginación por lugar poblado y municipal   ::: Informe Anual: Política Desarrollo Social y Población 2007   ::: Indice de Marginación para Guatemala, documento completo   ::: Resumen Ejecutivo Indice de Marginación para Guatemala   ::: Resumen Marco Conceptual   ::: Análisis Territorial   ::: Planificación Estratégica Territorial   ::: Información General   ::: Análisis Territorial   ::: Modelo de Desarrollo Territorial Futuro   ::: Planificación Estratégica Territorial   ::: Modelo de Desarrollo Territorial Futuro   ::: Información General   ::: Resumen Ejecutivo de la PET   ::: Proyectos Identificados   ::: Modelo de Desarrollo Territorial Futuro   ::: Análisis Territorial   ::: Planificación Estratégica Territorial Encuestas La información de SINPET ha sido... Sumamente informativa Razonablemente clara Un poco complicada He tenido que accesar a otras paginas de referencia Falta información No encontré lo que buscaba

1
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
2
SELECT id, link
 FROM jos_menu
 WHERE menutype = 'mainmenu'
 AND published = 1
 ORDER BY parent, ordering LIMIT 1
3
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 1 )
 ORDER BY menuid DESC
 LIMIT 1
4
DELETE FROM jos_session
 WHERE ( time < '1337351564' )
 AND guest = 0 
 AND gid > 0
5
DELETE FROM jos_session
 WHERE ( time < '1337352464' )
 AND guest = 1 
 AND userid = 0
6
SELECT access
 FROM jos_menu
 WHERE id = 1
7
SELECT *
 FROM jos_menu
 WHERE id = '1'
8
SELECT a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, 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.ordering, a.metakey, a.metadesc, a.access, a.hits,
 CHAR_LENGTH( a.fulltext ) AS readmore,
 ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
 FROM jos_content AS a
 INNER JOIN jos_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN jos_categories AS cc ON cc.id = a.catid
 INNER JOIN jos_sections AS s ON s.id = a.sectionid
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_content_rating AS v ON a.id = v.content_id
 LEFT JOIN jos_groups AS g ON a.access = g.id
 WHERE a.state = 1
 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2012-05-18 10:02:44'  )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2012-05-18 10:02:44' )
 AND s.published = 1
 AND cc.published = 1
 ORDER BY cc.ordering,  a.created DESC
9
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
10
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_blog_category'
 AND published = 1
11
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
12
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
13
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 717
14
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_blog_section'
 AND m.published = 1
 AND i.id = 717
15
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS m ON m.componentid = c.id 
 WHERE m.type = 'content_blog_category'
 AND m.published = 1
 AND i.id = 717
16
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_categories AS cc ON i.catid = cc.id
 LEFT JOIN jos_menu AS m ON m.componentid = cc.id 
 WHERE m.type = 'content_category'
 AND m.published = 1
 AND i.id = 717
17
SELECT a.*
 FROM jos_components AS a
 WHERE a.name = 'Syndicate'
18
SELECT id, title, module, position, content, showtitle, params
 FROM jos_modules AS m
 INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id
 WHERE m.published = 1
 AND m.access <= '0'
 AND m.client_id != 1
 AND ( mm.menuid = '1' OR mm.menuid = 0 )
 ORDER BY ordering
19
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
20
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=1'
21
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=1'
22
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
23
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
24
SELECT id, name, link, parent, type, menutype
 FROM jos_menu
 WHERE published = 1
 ORDER BY menutype, parent, ordering
25
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
26
SELECT a.id, a.title, a.sectionid, a.catid
 FROM jos_content AS a
 LEFT JOIN jos_content_frontpage AS f ON f.content_id = a.id
 WHERE ( a.state = '1' AND a.checked_out = '0' AND a.sectionid > '0' )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-18 09:02:44' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-18 09:02:44' )
 AND a.access <= '0'
 ORDER BY a.created DESC LIMIT 20
27
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 706
28
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_blog_section'
 AND m.published = 1
 AND i.id = 706
29
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 705
30
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 613
31
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 607
32
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 603
33
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 602
34
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 631
35
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 630
36
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 620
37
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 619
38
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 617
39
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 643
40
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 642
41
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 645
42
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 646
43
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 641
44
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 648
45
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 644
46
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 649
47
SELECT p.id, p.title
 FROM jos_polls AS p
 INNER JOIN jos_poll_menu AS pm ON  pm.pollid = p.id
 WHERE ( pm.menuid = 1 OR pm.menuid = 0 )
 AND p.published = 1
48
SELECT id, text
 FROM jos_poll_data
 WHERE pollid = 14
 AND text != ''
 ORDER BY id