- Details
-
Hits: 6649
Ante el Anteproyecto de Ley que modifica la Ley de Saude de Galicia desde la Asociación Galega para a Defensa da Sanidade Pública queremos comunicar que:
1- Se pretense crear la Agencia Galega del Conocimiento para ampliar y dar cobertura a la participación privada en las actividades de Investigación y Desarrollo que ahora se amplia a la innovación. A través de esta actividad y de la llamada Compra Pública Innovadora, las empresas reciben dinero público para investigación aunque las patentes se las reservan para su comercialización, siguiendo la estrategia de Gobierno de Feijoo de considera la atención de salud como un negocio.
2- Los cambios en la organización territorial del sistema (Áreas Sanitarias ) pretenden recortar y eliminar a medio plazo las áreas sanitarias de los hospitales comarcales. Esta política supone alejar a la ciudadanía (que vive áreas más alejadas de los centros de área) como parte de la estrategia de recortar el sistema sanitario para reducir gasto y potenciar la atención privada.
3- La modificación de los instrumentos de participación social en la sanidad, es la enésima vez que se cambian, aunque la realidad muestra que nunca se hacen operativos. Llama la atención que la misma se circunscriba a ayuntamiento y organizaciones de enfermos dejando fuera a importantes colectivos como las Federaciones Vecinales
Por todo ello desde nuestra Asociacion exigimos la:
· Retirada do Anteproyecto a supresión da Gerencias Únicas de Área (EOXI responsables do deterioro y marginación dos servizos de atención primaria
· Recuperación da Xerencia deste Nivel asistencial.
· Recuperación dos recursos eliminados dos hospitales comarcales
· Participación vecinal en la gestión e control dios sistema de salud
Asociación Galega para a Defensa da Sanidade Pública
2 de agosto 2017
PLG_DEBUG_TITLE
session.counter ⇒ 1
session.timer.start ⇒ 1713582179
session.timer.last ⇒ 1713582179
session.timer.now ⇒ 1713582179
session.client.browser ⇒ Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
registry ⇒ {}
id ⇒ 0
name ⇒
username ⇒
email ⇒
password ⇒
password_clear ⇒
usertype ⇒
block ⇒
sendEmail ⇒ 0
registerDate ⇒
lastvisitDate ⇒
activation ⇒
params ⇒
groups ⇒
guest ⇒ 1
lastResetTime ⇒
resetCount ⇒
aid ⇒ 0
10.82 MB (11,341,848 Bytes)
19 Registro Consultas
SELECT `data`
FROM `hdr5j_session`
WHERE `session_id` = 'kt6nuruvaqv0cuqbuvlun52bv1'
DELETE
FROM `hdr5j_session`
WHERE `time` < '1713581579'
SELECT `session_id`
FROM `hdr5j_session`
WHERE `session_id` = 'kt6nuruvaqv0cuqbuvlun52bv1'
LIMIT 0, 1
INSERT INTO `hdr5j_session`
(`session_id`, `client_id`, `time`)
VALUES
('kt6nuruvaqv0cuqbuvlun52bv1', 0, '1713582179')
SELECT b.id
FROM hdr5j_usergroups AS a
LEFT JOIN hdr5j_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
SELECT id, rules
FROM `hdr5j_viewlevels`
SELECT `enabled`
FROM `hdr5j_extensions`
WHERE `element` = 'com_akeeba'
AND `type` = 'component'
SELECT time
FROM hdr5j_vvisit_counter USE INDEX(time)
ORDER BY time DESC
LIMIT 1;
UPDATE hdr5j_vvisit_counter
SET visits=visits+1, bots=bots+1
WHERE time=1713582600;
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 hdr5j_menu AS m
LEFT JOIN hdr5j_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 c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM hdr5j_categories as c
LEFT JOIN hdr5j_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 hdr5j_categories AS cat JOIN hdr5j_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=1517
AND badcats.id is null
GROUP BY 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
ORDER BY c.lft
SELECT alias, catid
FROM hdr5j_content
WHERE id = 1517
SELECT a.rules
FROM hdr5j_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
SELECT b.rules
FROM hdr5j_assets AS a
LEFT JOIN hdr5j_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content' OR a.parent_id=0)
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, m.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, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, 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,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, 0) AS rating, v.rating_count as rating_count
FROM hdr5j_content AS a
LEFT JOIN hdr5j_multicategories AS m
on m.aid = a.id
LEFT JOIN hdr5j_categories AS c
on c.id = m.catid
LEFT JOIN hdr5j_users AS u
on u.id = a.created_by
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM hdr5j_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact
ON contact.user_id = a.created_by
LEFT JOIN hdr5j_categories as parent
ON parent.id = c.parent_id
LEFT JOIN hdr5j_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM hdr5j_categories AS cat JOIN hdr5j_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE m.catid = 78
AND a.id = 1517
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-20 03:02:59')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-20 03:02:59')
AND (a.state = 1 OR a.state =2)
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM hdr5j_categories as c
LEFT JOIN hdr5j_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 hdr5j_categories AS cat JOIN hdr5j_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=78
AND badcats.id is null
GROUP BY 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
ORDER BY c.lft
UPDATE hdr5j_content
SET hits = hits + 1
WHERE id = 1517
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
FROM hdr5j_categories as c
LEFT JOIN hdr5j_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 hdr5j_categories AS cat JOIN hdr5j_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=78
AND badcats.id is null
GROUP BY c.id
ORDER BY c.lft
UPDATE `hdr5j_session`
SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1713582179;s:18:\"session.timer.last\";i:1713582179;s:17:\"session.timer.now\";i:1713582179;s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;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:13:\"lastResetTime\";N;s:10:\"resetCount\";N;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;}}'
, `time` = '1713582179'
WHERE `session_id` = 'kt6nuruvaqv0cuqbuvlun52bv1'
DESCRIPCION Tipos de consulta Conectados 18, por orden de suceso
SELECCIONAR Tablas:
2 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM hdr5j_categories as c
LEFT JOIN hdr5j_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 hdr5j_categories AS cat JOIN hdr5j_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
1 × SELECT alias, catid
FROM hdr5j_content
1 × SELECT a.rules
FROM hdr5j_assets AS a
1 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, m.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, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, 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,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, 0) AS rating, v.rating_count as rating_count
FROM hdr5j_content AS a
LEFT JOIN hdr5j_multicategories AS m
on m.aid = a.id
LEFT JOIN hdr5j_categories AS c
on c.id = m.catid
LEFT JOIN hdr5j_users AS u
on u.id = a.created_by
LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM hdr5j_contact_details AS contact
1 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
FROM hdr5j_categories as c
LEFT JOIN hdr5j_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 hdr5j_categories AS cat JOIN hdr5j_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
1 × SELECT b.rules
FROM hdr5j_assets AS a
LEFT JOIN hdr5j_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
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 hdr5j_menu AS m
LEFT JOIN hdr5j_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT b.id
FROM hdr5j_usergroups AS a
LEFT JOIN hdr5j_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `session_id`
FROM `hdr5j_session`
1 × SELECT id, rules
FROM `hdr5j_viewlevels
1 × SELECT `enabled`
FROM `hdr5j_extensions`
1 × SELECT time
FROM hdr5j_vvisit_counter USE INDEX(time)
1 × SELECT `data`
FROM `hdr5j_session`
OTRAS Tablas:
1 × UPDATE `hdr5j_session`
SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1713582179;s:18:\"session.timer.last\";i:1713582179;s:17:\"session.timer.now\";i:1713582179;s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;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:13:\"lastResetTime\";N;s:10:\"resetCount\";N;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;}}' , `time` = '1713582179'
1 × UPDATE hdr5j_content
SET hits = hits + 1
1 × UPDATE hdr5j_vvisit_counter
SET visits=visits+1, bots=bots+1
1 × INSERT INTO `hdr5j_session` (`session_id`, `client_id`, `time`)
VALUES ('kt6nuruvaqv0cuqbuvlun52bv1', 0, '1713582179'
1 × DELETE
FROM `hdr5j_session`