{ "__default": { "session": { "counter": 1, "timer": { "start": 1580064865, "last": 1580064865, "now": 1580064865 }, "token": "ffgW9F4JQiFu4bBxOXvoWeeVOYgmstE0" }, "registry": { "com_jresearch": { "publications": { "123": { "list": { "start": 0 } } } } }, "user": { "id": 0, "name": null, "username": null, "email": null, "password": null, "password_clear": "", "block": null, "sendEmail": 0, "registerDate": null, "lastvisitDate": null, "activation": null, "params": null, "groups": [], "guest": 1, "lastResetTime": null, "resetCount": null, "requireReset": null, "aid": 0 } }, "__jresearch": { "citedRecords": [] } }
SELECT `data` FROM `jos_session` WHERE `session_id` = '0r6fca5hpc884hrb6d28lg3sq5'
SELECT `session_id` FROM `jos_session` WHERE `session_id` = '0r6fca5hpc884hrb6d28lg3sq5' LIMIT 1
INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('0r6fca5hpc884hrb6d28lg3sq5', 1, 1580064865, 0, '', 0)
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `jos_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
SELECT id, rules FROM `jos_viewlevels`
SELECT b.id FROM jos_usergroups AS a LEFT JOIN jos_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 9
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM jos_extensions WHERE enabled = 1 AND type = 'plugin' AND state IN (0,1) AND access IN (1,1,5) ORDER BY ordering
UPDATE jos_extensions SET enabled=1 WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'
SELECT m.id, m.menutype, m.title, m.alias, m.note, 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 jos_menu AS m LEFT JOIN jos_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft
SELECT id, home, template, s.params FROM jos_template_styles as s LEFT JOIN jos_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
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `jos_extensions` WHERE `type` = 'library' AND `element` = 'joomla'
UPDATE `jos_extensions` SET `params` = '{\"mediaversion\":\"a7c58e1141940aa9cf163eaf62ee937f\"}' WHERE `type` = 'library' AND `element` = 'joomla'
SELECT * FROM jos_languages WHERE published=1 ORDER BY ordering ASC
SELECT DISTINCT pub.* FROM jos_jresearch_publication pub LEFT JOIN jos_jresearch_publication_research_area AS ra ON pub.id = ra.id_publication LEFT JOIN jos_jresearch_all_publication_authors AS apa ON pub.id = apa.pid WHERE `published` = 1 AND `internal` = 1 AND `id` > 0 ORDER BY year DESC,STR_TO_DATE(month, '%M') DESC,STR_TO_DATE(day, '%d') DESC,created DESC LIMIT 25
SHOW FULL COLUMNS FROM `jos_jresearch_publication`
SELECT `name` FROM `jos_jresearch_publication_type`
SELECT `element` FROM `jos_extensions` WHERE folder = 'jresearch-pubtypes' AND `enabled` = 1
SELECT DISTINCT year FROM `jos_jresearch_publication` ORDER BY `year` DESC
SELECT DISTINCT mid, member_name FROM `jos_jresearch_all_publication_authors`
SELECT * FROM `jos_jresearch_research_area` WHERE published = '1'
SHOW FULL COLUMNS FROM `jos_jresearch_research_area`
SELECT COUNT(DISTINCT id) FROM jos_jresearch_publication pub LEFT JOIN jos_jresearch_publication_research_area AS ra ON pub.id = ra.id_publication LEFT JOIN jos_jresearch_all_publication_authors AS apa ON pub.id = apa.pid WHERE `published` = 1 AND `internal` = 1 AND `id` > 0
SELECT `id`,`name`,`rules`,`parent_id` FROM `jos_assets` WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djcatalog2','com_djimageslider','com_finder','com_installer','com_j2xml','com_jaextmanager','com_jce','com_joomailermailchimpintegration','com_joomlaupdate','com_jresearch','com_jsocialfeed','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_rsform','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')
SHOW FULL COLUMNS FROM `jos_jresearch_member`
SELECT * FROM jos_jresearch_member WHERE `id` = '81'
SELECT * FROM jos_jresearch_member WHERE `id` = '82'
SELECT * FROM jos_jresearch_member WHERE `id` = '4'
SELECT * FROM jos_jresearch_member WHERE `id` = '298'
SELECT * FROM jos_jresearch_member WHERE `id` = '2'
SELECT * FROM jos_jresearch_member WHERE `id` = '206'
GIGAPP
Grupo de Investigación en Gobierno, Administración y Políticas Públicas
GIGAPP
Grupo de Investigación en Gobierno, Administración y Políticas Públicas 