El papel del deporte en todas las políticas públicas, tanto municipales como supramunicipales, está más que contrastado. En algunos países, según estudios de la U.E. el deporte representa alrededor de un 3% del PIB, y el número de personas empleadas en el sector del deporte va en aumento. Existen diferentes estudios que evalúan la mejora de vida de los ciudadanos a través del deporte, con objetivos sociales, de salud, relacionales, de implicación del urbanismo, de implementación de políticas económicas, de impacto político, de impacto social, etc. Por ello sería interesante abordar esta temática, completamente nueva como tal, pero con ponencias de contenido presentes en diferentes grupos de trabajo creados en años anteriores del GIGAPP.
{ "__default": { "session": { "counter": 1, "timer": { "start": 1576223668, "last": 1576223668, "now": 1576223668 }, "token": "vCFt9bjdRv806PhNND3qHhkSSj7XNfd7" }, "registry": {}, "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": [] }, "__com_jresearch": { "project": { "235": { "visited": true } } } }
SELECT `data` FROM `jos_session` WHERE `session_id` = '7c2jb4oiv0affmh1e15ssmmv42'
SELECT `session_id` FROM `jos_session` WHERE `session_id` = '7c2jb4oiv0affmh1e15ssmmv42' LIMIT 1
INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('7c2jb4oiv0affmh1e15ssmmv42', 1, 1576223668, 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\":\"8683e29fb3fe04b2ad37e2475cb04ee6\"}' WHERE `type` = 'library' AND `element` = 'joomla'
SELECT * FROM jos_languages WHERE published=1 ORDER BY ordering ASC
SHOW FULL COLUMNS FROM `jos_jresearch_project`
SELECT * FROM jos_jresearch_project WHERE `id` = '235'
UPDATE jos_jresearch_project SET `hits` = (`hits` + 1) WHERE `id` = '235'
SELECT p.* FROM `jos_jresearch_publication` p JOIN `jos_jresearch_project_publication` pp WHERE p.id = pp.id_publication AND p.published = 1 AND p.internal = 1 AND pp.id_project = '235' ORDER BY p.year DESC, p.created DESC LIMIT 0, 10
SHOW FULL COLUMNS FROM `jos_jresearch_publication`
SELECT count(pp.id_publication) FROM `jos_jresearch_publication` p JOIN `jos_jresearch_project_publication` pp WHERE p.id = pp.id_publication AND p.published = 1 AND p.internal = 1 AND pp.id_project = '235'
SELECT id, name, published FROM jos_jresearch_research_area WHERE id IN (4) AND id > 1
SHOW FULL COLUMNS FROM `jos_jresearch_member`
SELECT * FROM jos_jresearch_member WHERE `id` = '361'
SELECT `element` FROM `jos_extensions` WHERE folder = 'jresearch-pubtypes' AND `enabled` = 1
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN jos_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 <= '2019-12-13 07:54:28') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-12-13 07:54:28') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 206 OR mm.menuid <= 0) ORDER BY m.position, m.ordering
SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name FROM jos_fields_values fv LEFT JOIN jos_fields f ON fv.field_id = f.id LEFT JOIN jos_fields_groups fg ON fg.id = f.group_id WHERE fv.item_id = 22 AND f.context = "com_content.categories" AND f.language IN ("*", "es-ES") AND f.access = 1
SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name FROM jos_fields_values fv LEFT JOIN jos_fields f ON fv.field_id = f.id LEFT JOIN jos_fields_groups fg ON fg.id = f.group_id WHERE fv.item_id = 16 AND f.context = "com_content.categories" AND f.language IN ("*", "es-ES") AND f.access = 1
SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name FROM jos_fields_values fv LEFT JOIN jos_fields f ON fv.field_id = f.id LEFT JOIN jos_fields_groups fg ON fg.id = f.group_id WHERE fv.item_id = 25 AND f.context = "com_content.categories" AND f.language IN ("*", "es-ES") AND f.access = 1
SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name FROM jos_fields_values fv LEFT JOIN jos_fields f ON fv.field_id = f.id LEFT JOIN jos_fields_groups fg ON fg.id = f.group_id WHERE fv.item_id = 26 AND f.context = "com_content.categories" AND f.language IN ("*", "es-ES") AND f.access = 1
SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name FROM jos_fields_values fv LEFT JOIN jos_fields f ON fv.field_id = f.id LEFT JOIN jos_fields_groups fg ON fg.id = f.group_id WHERE fv.item_id = 45 AND f.context = "com_content.categories" AND f.language IN ("*", "es-ES") AND f.access = 1
SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name FROM jos_fields_values fv LEFT JOIN jos_fields f ON fv.field_id = f.id LEFT JOIN jos_fields_groups fg ON fg.id = f.group_id WHERE fv.item_id = 40 AND f.context = "com_content.categories" AND f.language IN ("*", "es-ES") AND f.access = 1
SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name FROM jos_fields_values fv LEFT JOIN jos_fields f ON fv.field_id = f.id LEFT JOIN jos_fields_groups fg ON fg.id = f.group_id WHERE fv.item_id = 30 AND f.context = "com_content.categories" AND f.language IN ("*", "es-ES") AND f.access = 1
SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name FROM jos_fields_values fv LEFT JOIN jos_fields f ON fv.field_id = f.id LEFT JOIN jos_fields_groups fg ON fg.id = f.group_id WHERE fv.item_id = 46 AND f.context = "com_content.categories" AND f.language IN ("*", "es-ES") AND f.access = 1
SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name FROM jos_fields_values fv LEFT JOIN jos_fields f ON fv.field_id = f.id LEFT JOIN jos_fields_groups fg ON fg.id = f.group_id WHERE fv.item_id = 18 AND f.context = "com_content.categories" AND f.language IN ("*", "es-ES") AND f.access = 1
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params FROM jos_modules AS m WHERE m.id = 135 AND m.published = 1 AND m.access IN (1,1,5)
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')
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,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count FROM jos_content AS a LEFT JOIN jos_categories AS c ON c.id = a.catid LEFT JOIN jos_users AS ua ON ua.id = a.created_by LEFT JOIN jos_users AS uam ON uam.id = a.modified_by LEFT JOIN jos_categories as parent ON parent.id = c.parent_id LEFT JOIN jos_content_rating AS v ON a.id = v.content_id WHERE c.published = 1 AND a.state = 1 AND a.featured = 0 AND a.catid IN (46) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-12-13 07:54:28') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-12-13 07:54:28') ORDER BY a.publish_up DESC LIMIT 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 `jos_categories` AS `s` INNER JOIN `jos_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 = 46 ORDER BY c.lft
9 × SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name FROM jos_fields_values fv LEFT JOIN jos_fields f ON fv.field_id = f.id LEFT JOIN jos_fields_groups fg ON fg.id = f.group_id
7 × SELECT `element` FROM `jos_extensions`
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `jos_extensions`
2 × 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,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count FROM jos_content AS a LEFT JOIN jos_categories AS c ON c.id = a.catid LEFT JOIN jos_users AS ua ON ua.id = a.created_by LEFT JOIN jos_users AS uam ON uam.id = a.modified_by LEFT JOIN jos_categories as parent ON parent.id = c.parent_id LEFT JOIN jos_content_rating AS v ON a.id = v.content_id
2 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params FROM jos_modules AS m
2 × SELECT * FROM jos_jresearch_member
1 × SELECT `data` FROM `jos_session`
1 × SELECT id, name, published FROM jos_jresearch_research_area
1 × SELECT `id`,`name`,`rules`,`parent_id` FROM `jos_assets`
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN jos_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
1 × SELECT p.* FROM `jos_jresearch_publication` p JOIN `jos_jresearch_project_publication` pp
1 × SELECT count(pp.id_publication) FROM `jos_jresearch_publication` p JOIN `jos_jresearch_project_publication` pp
1 × SELECT `session_id` FROM `jos_session`
1 × SELECT * FROM jos_jresearch_project
1 × SELECT * FROM jos_languages
1 × 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
1 × 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
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM jos_extensions
1 × SELECT b.id FROM jos_usergroups AS a LEFT JOIN jos_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT id, rules FROM `jos_viewlevels
1 × 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 `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (s.lft <= c.lft AND c.lft < s.rgt) OR (c.lft < s.lft AND s.rgt < c.rgt)
1 × INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('7c2jb4oiv0affmh1e15ssmmv42', 1, 1576223668, 0, '', 0
1 × UPDATE jos_extensions SET enabled=1
1 × UPDATE `jos_extensions` SET `params` = '{\"mediaversion\":\"8683e29fb3fe04b2ad37e2475cb04ee6\"}'
1 × SHOW FULL COLUMNS FROM `jos_jresearch_project
1 × UPDATE jos_jresearch_project SET `hits` = (`hits` + 1)
1 × SHOW FULL COLUMNS FROM `jos_jresearch_publication
1 × SHOW FULL COLUMNS FROM `jos_jresearch_member
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 