SELECT `id`,`name`,`rules`,`parent_id` FROM `d852h_assets` WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')

SELECT `id`,`name`,`rules`,`parent_id` FROM `d852h_assets` WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

SHOW FULL COLUMNS FROM `d852h_content`

UPDATE d852h_content SET `hits` = (`hits` + 1) WHERE `id` = '8319'

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as 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.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,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, 0) AS rating, v.rating_count as rating_count FROM d852h_content AS a INNER JOIN d852h_categories AS c on c.id = a.catid LEFT JOIN d852h_users AS u on u.id = a.created_by LEFT JOIN d852h_categories as parent ON parent.id = c.parent_id LEFT JOIN d852h_content_rating AS v ON a.id = v.content_id WHERE a.id = 8319 AND c.published > 0 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-12-28 06:28:39') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-28 06:28:39') AND (a.state = 1 OR a.state =2)

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM `d852h_categories` AS `s` INNER JOIN `d852h_categories` AS `c` ON (s.lft <= c.lft AND c.lft < s.rgt) OR (c.lft < s.lft AND s.rgt < c.rgt) WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,5) AND c.published = 1 AND s.id = 12 ORDER BY c.lft

SELECT `m`.`tag_id`,`t`.* FROM `d852h_contentitem_tag_map` AS m INNER JOIN `d852h_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 8319 AND `t`.`published` = 1 AND t.access IN (1,1,5)

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM d852h_fields AS a LEFT JOIN `d852h_languages` AS l ON l.lang_code = a.language LEFT JOIN d852h_users AS uc ON uc.id=a.checked_out LEFT JOIN d852h_viewlevels AS ag ON ag.id = a.access LEFT JOIN d852h_users AS ua ON ua.id = a.created_user_id LEFT JOIN d852h_fields_groups AS g ON g.id = a.group_id LEFT JOIN `d852h_fields_categories` AS fc ON fc.field_id = a.id WHERE a.context = 'com_content.article' AND (fc.category_id IS NULL OR fc.category_id IN (12,0)) AND a.access IN (1,1,5) AND (a.group_id = 0 OR g.access IN (1,1,5)) AND a.state = 1 AND (a.group_id = 0 OR g.state = 1) ORDER BY a.ordering ASC

SELECT `field_id`,`value` FROM `d852h_fields_values` WHERE `field_id` IN (2) AND `item_id` = '8319'


Notice: Only variables should be assigned by reference in /var/www/html/components/com_content/views/article/tmpl/default.php on line 20
SELECT `id`,`alias` FROM `d852h_categories` WHERE `alias` = 'academia'

UPAEP y Ayuda en Acción, de la mano para el fomento del bien común
20/10/2021
Autor: Juan Méndez

Para la UPAEP es una prioridad establecer alianzas con otras organizaciones que persiguen fines comunes, como es su compromiso con el desarrollo social y promover el bien común de las personas, misión que también distingue a Ayuda en Acción.

UPAEP será sede del inicio de actividades que sostendrá la organización Ayuda en Acción/ México por el estado de Puebla y que comenzará el día de mañana jueves 21 de octubre en las instalaciones de la universidad, con un ciclo de mesas de trabajo.

Para la UPAEP es una prioridad establecer alianzas con otras organizaciones que persiguen fines comunes, como es su compromiso con el desarrollo social y promover el bien común de las personas, señaló Herminio Sánchez de la Barquera y Arroyo, Decano de Ciencias Sociales de la UPAEP.

Dijo que este tipo de acciones son producto de la firma de un acuerdo estratégico que sostuvo la institución con Ayuda en Acción/México en meses pasados y que ambas instituciones buscan trabajar de manera local en cada región de país, porque los grandes problemas nacionales se tienen que atender de manera local.

Ayuda en Acción/ México busca generar espacios de encuentro para poblaciones vulnerables de la región Sierra Nevada en Puebla, mediante las colaboraciones multiactorales para el bien colectivo, además, busca promover un desarrollo territorial, justo, equitativo y sostenible y que se identifican también con los principios y valores de esta casa de estudios que es la UPAEP, manifestó Fernando Mudarra Ruíz, Director General de Ayuda en Acción.

Asimismo, comentó que la organización busca llevar a la práctica el diálogo y análisis de estrategias sustentadas en ejes clave como son la seguridad y soberanía alimentaria, infancia, economía social, solidaria y circular, migración e innovación.

En su intervención, Fernando Méndez Sánchez, Director de la Facultad de Derecho de la UPAEP, expresó que la universidad al trabajar de manera colaborativa con Ayuda en Acción México, reitera una vez más lo que es la universidad, “un compromiso humano, un compromiso transformador con la sociedad y un compromiso con la formación de líderes y ahora de la mano con Ayuda en Acción México, establecer un convenio en plena pandemia que ahora ya comienza a rendir sus frutos y a través de las diferentes facultades de la institución se ha logrado apoyar a Ayuda en Acción para poner en marcha diferente proyectos de impacto social en diferentes puntos de las regiones de Puebla, como es la misma Sierra del estado y las comunidades que requieren de algún tipo de apoyos”.

Fernando Méndez enfatizó que ambas instituciones llevarán a cabo diversas mesas de trabajo para abordar diferentes temáticas sociales, para que junto con otros líderes empresariales y del sector público, se puedan crear algunas estrategias para las mejoras de las condiciones de los productores en Puebla, misión que tiene en manos Ayuda en Acción México.

Por su parte, Tania Rodríguez Zafra, Directora Nacional de Ayuda en Acción México, dijo que es importante convertir los problemas en oportunidades, y en este caso, para resolver situaciones como la “Incidencia y colaboración multiactoral para impulsar la estrategia de desarrollo territorial en la región de la Sierra Nevada, en Puebla”, se requiere de la colaboración de varios actores, de gente que se sume a la causa de los diferentes sectores de la sociedad, públicos y privados, que con sus conocimientos y experiencias, pueden contribuir a estas causas.   

Mientras que María Luisa Salvador Cuautle, Responsable de Programas de Ayuda en Acción México, habló de los diferentes días de trabajo que tiene esta organización por Puebla, en diferentes instituciones educativas y de investigación, comenzando este jueves 21 de octubre en la UPAEP con mesas de trabajo en donde se abordarán temas como seguridad y soberanía alimentaria, infancia, economía social, solidaria y circular, migración e innovación.

Asimismo, refirió que el día viernes estarán visitando las instalaciones del Colegio de Postgraduados, en donde se llevará a cabo la entrega de reconocimientos de la Validación del Sistema MIAF., y el sábado 23 de octubre, se realizará la sesión de “colaborar para multiplicar” y un recorrido con productores de Tochimizolco, Puebla, en el municipio de Tochimilco, Puebla.

Por último, enfatizó que Ayuda en Acción México tiene varios proyectos con UPAEP que están en marcha y que son programas de largo alcance que irán caminando para beneficio de las comunidades de Puebla.

Ayuda en Acción es una organización que impulsa la dignidad y la solidaridad para la construcción de un mundo justo, además cuenta con presencia en América Latina, Asia, África, en España y Portugal.

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM d852h_modules AS m LEFT JOIN d852h_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN d852h_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 <= '2024-12-28 06:28:39') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-12-28 06:28:39') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 112 OR mm.menuid <= 0) ORDER BY m.position, m.ordering

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN c.published = 2 AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias FROM d852h_content AS a LEFT JOIN d852h_categories AS c ON c.id = a.catid LEFT JOIN d852h_users AS ua ON ua.id = a.created_by LEFT JOIN d852h_users AS uam ON uam.id = a.modified_by LEFT JOIN d852h_categories as parent ON parent.id = c.parent_id WHERE a.access IN (1,1,5) AND c.access IN (1,1,5) AND c.published = 1 AND a.state = 1 AND a.catid IN (12) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-12-28 06:28:39') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-28 06:28:39') ORDER BY a.hits ASC LIMIT 3

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM d852h_fields AS a LEFT JOIN `d852h_languages` AS l ON l.lang_code = a.language LEFT JOIN d852h_users AS uc ON uc.id=a.checked_out LEFT JOIN d852h_viewlevels AS ag ON ag.id = a.access LEFT JOIN d852h_users AS ua ON ua.id = a.created_user_id LEFT JOIN d852h_fields_groups AS g ON g.id = a.group_id WHERE a.context = 'mod_articles_category.content' AND a.access IN (1,1,5) AND (a.group_id = 0 OR g.access IN (1,1,5)) AND a.state = 1 AND (a.group_id = 0 OR g.state = 1) ORDER BY a.ordering ASC

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN c.published = 2 AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias FROM d852h_content AS a LEFT JOIN d852h_categories AS c ON c.id = a.catid LEFT JOIN d852h_users AS ua ON ua.id = a.created_by LEFT JOIN d852h_users AS uam ON uam.id = a.modified_by LEFT JOIN d852h_categories as parent ON parent.id = c.parent_id WHERE a.access IN (1,1,5) AND c.access IN (1,1,5) AND c.published = 1 AND a.state = 1 AND a.catid IN (8,9,10,11,12,13,14,15,16,17,23,26,27) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-12-28 06:28:39') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-28 06:28:39') AND (a.created >= '2024-11-01 00:00:00' AND a.created <= '2024-11-30 11:59:00') ORDER BY a.hits DESC LIMIT 10

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM `d852h_categories` AS `s` INNER JOIN `d852h_categories` AS `c` ON (s.lft <= c.lft AND c.lft < s.rgt) OR (c.lft < s.lft AND s.rgt < c.rgt) WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,5) AND c.published = 1 AND s.id = 9 ORDER BY c.lft

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM `d852h_categories` AS `s` INNER JOIN `d852h_categories` AS `c` ON (s.lft <= c.lft AND c.lft < s.rgt) OR (c.lft < s.lft AND s.rgt < c.rgt) WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,5) AND c.published = 1 AND s.id = 13 ORDER BY c.lft

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM `d852h_categories` AS `s` INNER JOIN `d852h_categories` AS `c` ON (s.lft <= c.lft AND c.lft < s.rgt) OR (c.lft < s.lft AND s.rgt < c.rgt) WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,5) AND c.published = 1 AND s.id = 23 ORDER BY c.lft

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM `d852h_categories` AS `s` INNER JOIN `d852h_categories` AS `c` ON (s.lft <= c.lft AND c.lft < s.rgt) OR (c.lft < s.lft AND s.rgt < c.rgt) WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,5) AND c.published = 1 AND s.id = 14 ORDER BY c.lft