Profesor Ernesto San Martín publica en revista Journal of the Royal Statistical Society

Ernesto SM

Un paper del académico e investigador de la Facultad de Educación Ernesto San Martín acaba de ser publicado en la Journal of the Royal Statistical Society Series A

El investigador del Centro de Estudios de Políticas y Prácticas en Educación CEPPE, y profesor asociado de la Facultad de Educación y de la Facultad de Matemáticas Ernesto San Martín, acaba de publicar un paper sobre valor agregado –que hace una extensión de la definición de este concepto- en la Journal of the Royal Statistical Society Series A.

El artículo referenciado como Page, San Martín, Orellana & González (2016) cuestiona si una escuela puede ser efectiva para un determinado subgrupo de estudiantes, y no para otros.

La pregunta, motivada por consideraciones teóricas, fue respondida extendiendo la definición model-free de valor agregado, definiendo así la noción de valor agregado quatile (quantile value-added), lo que permite describir la efectividad de una escuela en función de poblaciones de estudiantes definidas en términos del cuantil de la distribución del post-test condicional a un conjunto de co-variables (entre ellas, el puntaje previo).

El trabajo de Page, San Martín, Orellana & González discute el uso en política pública de este tipo de indicadores, y propone una ilustración de la metodología usando los datos del SIMCE 2007 y 2011. Además, muestra cómo esta nueva noción de valor agregado es pertinente para lo que la ley de Aseguramiento de la Calidad de la Educación persigue.

La Journal of the Royal Statistical Society es una de las revistas más prestigiosas en el área de la estadística social, y en sus páginas han sido publicados los papers más fundamentales de value added, incluyendo autores como Longford, Spiegelahter, Goldstein, Thomas y Skrondal, quienes han construido las bases de la investigación en efectividad escolar. La serie A de este journal está consagrada a las aplicaciones de la estadística en la sociedad.

El editor de la serie A de la mencionada revista es Hervy Goldstein, uno de los investigadores más importantes en efectividad escolar en UK (miembro de importantes comisiones para value added en ese país y director de un centro de investigación multinivel que se ha dedicado a VA en UK y otras latitudes).

Polo de desarrollo en la UC

Ernesto San Martín explica que “en la Pontificia Universidad Católica de Chile se ha ido creando un polo de desarrollo científico en torno a la efectividad escolar y los modelos de valor agregado”. Este desarrollo se ha llevado a cabo gracias a proyectos públicos como el proyecto ANILLO SOC 1107 Statistics for Public Policy in Education, en el que también participaron los profesores Verónica Santelices (Facultad de Educación), Alejandro Carrasco (Facultad de Educación), Jorge González (Facultad de Matemáticas) y Garrit Page (Facultad de Matemáticas, ahora en Brigham Young University, USA).

-La investigación que hemos ido desarrollando está caracterizada por un elemento básico: la necesidad de definir conceptos sustantivos en términos formales usando las herramientas de la teoría de probabilidad –explica-. Esto la hace diferente de la llamada investigación cuantitativa, que se caracteriza por aplicar modelos de valor agregado existentes a datos chilenos (entre otros), pero sin preguntarse por la noción teórica de efectividad escolar que subyace a dicha metodología.

San Martín destaca que uno de los primeros logros obtenidos en este polo de desarrollo es el haber propuesto una definición de los conceptos básicos de efectividad escolar, definición que es independiente de cualquier modelo estadístico y, por lo tanto, se caracterizó como model-free, en referencia a los conceptos de efecto escuela y de valor agregado.

-El primero se define como una variable no-observable que explica la heterogeneidad de los puntajes individuales que a su vez no es explicada por variables de contexto (socio-económicas, características individuales, incluyendo un puntaje previo). El segundo se define como la diferencia entre el puntaje esperado en una determinada escuela (condicional a un conjunto de co-variables) y el puntaje esperado en una escuela de referencia. Este último concepto se caracteriza por las co-variables que se incluyen, lo cual implica que la efectividad de una escuela no es un concepto universal (es decir, que una escuela no es efectiva en todo contexto) y por lo tanto la selección de co-variables no depende de criterio estadístico alguno, sino que depende exclusivamente de consideraciones de política educacional y que deben responder a la pregunta acerca de la finalidad política que se tiene para usar modelos de valor agregado.

Estas consideraciones ya fueron expuestas en un artículo publicado en una de las revistas más prestigiosas de psicometría, Psychometrika, por Manzi, San Martín & Van Bellegem (2014). También fueron incluidas en dos publicaciones sobre ordenación de escuela de la Agencia de la Calidad y en el Centro Políticas Públicas: Propuestas para Chile y Agenda Legislativa, respectivamente.

El profesor San Martín ha publicado en los últimos años varios artículos relacionados con valor agregado. Entre ellos: J. Milla, E. San Martín and S. Van Bellegem (2015). Higher Education Value Added using Multiple Outcomes; submitted. CORE Discussion Paper 2015/45, Universite Catholique de Louvain, Bélgica. E. San Martín and A. Carrasco (2012). Clasificación de Escuelas en la Nueva Institucionalidad Educativa: Contribución de Modelos de Valor-Agregado para una Responsabilización Justa. Serie Temas de la Agenda Pública, Centro de Políticas Públicas UC 7, No. 53. A. Carrasco and E. San Martín (2012). Voucher System and School Effectiveness: reassessing school performance difference and parental choice decision-making. Estudios de Economía 39, 123-141. E. San Martín y A. Carrasco (2013). Criterios para evaluar la metodología de clasificación de escuelas: ¿Un asunto técnico o conceptual? En: Propuestas para Chile UC, capítulo III.

Texto: Francisco Zabaleta, facultad de Educación UC

Consola de Joomla! Debug

Application 0.001 seconds (+0.001); 1.37 MB (+1.371) - afterLoad

Application 0.289 seconds (+0.288); 10.62 MB (+9.246) - afterInitialise

Application 0.366 seconds (+0.076); 12.29 MB (+1.669) - afterRoute

Application 0.543 seconds (+0.178); 14.75 MB (+2.462) - afterDispatch

Application 0.558 seconds (+0.014); 14.98 MB (+0.228) - beforeRenderModule mod_custom (Footer)

Application 0.567 seconds (+0.009); 15.02 MB (+0.044) - afterRenderModule mod_custom (Footer)

Application 0.567 seconds (+0.000); 15.02 MB (-0.001) - beforeRenderModule mod_menu (Sitios de Interés)

Application 0.584 seconds (+0.016); 15.10 MB (+0.078) - afterRenderModule mod_menu (Sitios de Interés)

Application 0.584 seconds (+0.000); 15.09 MB (-0.006) - beforeRenderModule mod_menu (Menú Más Eventos Right)

Application 0.597 seconds (+0.013); 15.44 MB (+0.349) - afterRenderModule mod_menu (Menú Más Eventos Right)

Application 0.598 seconds (+0.000); 15.49 MB (+0.046) - beforeRenderModule mod_news_pro_gk5 (Noticias)

Application 0.643 seconds (+0.046); 16.34 MB (+0.851) - afterRenderModule mod_news_pro_gk5 (Noticias)

Application 0.643 seconds (+0.000); 16.18 MB (-0.155) - beforeRenderModule mod_menu (Menú Más Noticias Right)

Application 0.650 seconds (+0.007); 16.19 MB (+0.009) - afterRenderModule mod_menu (Menú Más Noticias Right)

Application 0.650 seconds (+0.000); 16.19 MB (-0.006) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Application 0.661 seconds (+0.011); 16.21 MB (+0.025) - afterRenderModule mod_breadcrumbs (Breadcrumbs)

Application 0.662 seconds (+0.000); 16.20 MB (-0.006) - beforeRenderModule mod_menu (Menú Noticias)

Application 0.668 seconds (+0.007); 16.22 MB (+0.012) - afterRenderModule mod_menu (Menú Noticias)

Application 0.668 seconds (+0.000); 16.21 MB (-0.006) - beforeRenderModule mod_menu (Menú Información Para)

Application 0.681 seconds (+0.013); 16.23 MB (+0.018) - afterRenderModule mod_menu (Menú Información Para)

Application 0.682 seconds (+0.000); 16.22 MB (-0.004) - beforeRenderModule mod_jt_superfish_menu (Main Menú)

Application 0.834 seconds (+0.153); 16.49 MB (+0.266) - afterRenderModule mod_jt_superfish_menu (Main Menú)

Application 0.834 seconds (+0.000); 16.48 MB (-0.012) - beforeRenderModule mod_custom (Header - Título)

Application 0.836 seconds (+0.002); 16.48 MB (+0.004) - afterRenderModule mod_custom (Header - Título)

Application 0.836 seconds (+0.000); 16.48 MB (-0.003) - beforeRenderModule mod_custom (Header Interior)

Application 0.838 seconds (+0.002); 16.48 MB (+0.004) - afterRenderModule mod_custom (Header Interior)

Application 0.838 seconds (+0.000); 16.48 MB (-0.000) - beforeRenderModule mod_jt_superfish_menu (Menú UC)

Application 0.958 seconds (+0.120); 16.63 MB (+0.148) - afterRenderModule mod_jt_superfish_menu (Menú UC)

Application 0.958 seconds (+0.000); 16.62 MB (-0.014) - beforeRenderModule mod_custom (CSS)

Application 0.960 seconds (+0.002); 16.62 MB (+0.004) - afterRenderModule mod_custom (CSS)

Application 0.978 seconds (+0.018); 16.75 MB (+0.127) - afterRender

45 Registro Consultas

SELECT `data` FROM `educacion_session` WHERE `session_id` = '316df6b02a831c703b3151d0ce5d6780'
DELETE FROM `educacion_session` WHERE `time` < '1749351733'
SELECT `session_id` FROM `educacion_session` WHERE `session_id` = '316df6b02a831c703b3151d0ce5d6780' LIMIT 0, 1
INSERT INTO `educacion_session` (`session_id`, `client_id`, `time`) VALUES ('316df6b02a831c703b3151d0ce5d6780', 0, '1749352633')
SELECT extension_id AS id, element AS "option", params, enabled FROM educacion_extensions WHERE `type` = 'component' AND `element` = 'com_users'
SELECT b.id FROM educacion_usergroups AS a LEFT JOIN educacion_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 1
SELECT id, rules FROM `educacion_viewlevels`
SELECT folder AS type, element AS name, params FROM educacion_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1) ORDER BY ordering
SELECT extension_id AS id, element AS "option", params, enabled FROM educacion_extensions WHERE `type` = 'component' AND `element` = 'com_languages'
SELECT `path` FROM educacion_rsfirewall_ignored WHERE `type`='ignore_folder' OR `type`='ignore_file'
SELECT `file` FROM educacion_rsfirewall_hashes WHERE `type`='protect'
SELECT * FROM educacion_rsfirewall_configuration
SHOW FULL COLUMNS FROM `educacion_rsfirewall_logs`
SELECT * FROM educacion_languages WHERE published=1 ORDER BY ordering ASC
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 educacion_menu AS m LEFT JOIN educacion_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 `params` FROM educacion_extensions WHERE `element`='com_sh404sef' AND `type`='component';
SELECT extension_id AS id, element AS "option", params, enabled FROM educacion_extensions WHERE `type` = 'component' AND `element` = 'com_content'
SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM educacion_categories as c LEFT JOIN educacion_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 educacion_categories AS cat JOIN educacion_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=669 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 educacion_content WHERE id = 669
SELECT `id` FROM `educacion_usergroups`
SELECT a.rules FROM educacion_assets AS a WHERE (a.id = 1) GROUP BY a.id, a.rules, a.lft
SELECT DISTINCT(user_id) FROM educacion_usergroups as ug1 INNER JOIN educacion_usergroups AS ug2 ON ug2.lft>=ug1.lft AND ug1.rgt>=ug2.rgt INNER JOIN educacion_user_usergroup_map AS m ON ug2.id=m.group_id WHERE ug1.id='6'
SELECT DISTINCT(user_id) FROM educacion_usergroups as ug1 INNER JOIN educacion_usergroups AS ug2 ON ug2.lft>=ug1.lft AND ug1.rgt>=ug2.rgt INNER JOIN educacion_user_usergroup_map AS m ON ug2.id=m.group_id WHERE ug1.id='8'
SELECT DISTINCT(user_id) FROM educacion_usergroups as ug1 INNER JOIN educacion_usergroups AS ug2 ON ug2.lft>=ug1.lft AND ug1.rgt>=ug2.rgt INNER JOIN educacion_user_usergroup_map AS m ON ug2.id=m.group_id WHERE ug1.id='9'
SELECT u.* FROM educacion_users u WHERE u.id IN (365,367,369,371,375,376,361) ORDER BY u.username ASC
SELECT * FROM educacion_rsfirewall_hashes WHERE (`type`='2.5.27' OR `type`='protect') AND `flag`!='C'
SELECT * FROM educacion_rsfirewall_snapshots WHERE `type`='protect'
SELECT `ip`,`reason` FROM educacion_rsfirewall_lists WHERE (`ip`='216.73.216.206' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='1' AND `published`='1'
SELECT `ip`,`reason` FROM educacion_rsfirewall_lists WHERE (`ip`='216.73.216.206' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='0' AND `published`='1'
SELECT * FROM educacion_rsfirewall_exceptions WHERE `published`='1'
SELECT id, home, template, s.params FROM educacion_template_styles as s LEFT JOIN educacion_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 a.rules FROM educacion_assets AS a WHERE (a.id = 1) GROUP BY a.id, a.rules, a.lft
SELECT b.rules FROM educacion_assets AS a LEFT JOIN educacion_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content') 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, a.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,( SELECT MAX(contact.id) AS id FROM educacion_contact_details AS contact WHERE contact.published = 1 AND contact.user_id = a.created_by) 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 educacion_content AS a LEFT JOIN educacion_categories AS c on c.id = a.catid LEFT JOIN educacion_users AS u on u.id = a.created_by LEFT JOIN educacion_categories as parent ON parent.id = c.parent_id LEFT JOIN educacion_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM educacion_categories AS cat JOIN educacion_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 a.id = 669 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-06-08 03:17:13') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-06-08 03:17:13') 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 educacion_categories as c LEFT JOIN educacion_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 educacion_categories AS cat JOIN educacion_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=18 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 extension_id AS id, element AS "option", params, enabled FROM educacion_extensions WHERE `type` = 'component' AND `element` = 'com_jmap'
SELECT extension_id AS id, element AS "option", params, enabled FROM educacion_extensions WHERE `type` = 'component' AND `element` = 'com_phocagallery'
UPDATE educacion_content SET hits = hits + 1 WHERE id = 669
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM educacion_modules AS m LEFT JOIN educacion_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN educacion_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 <= '2025-06-08 03:17:13') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-06-08 03:17:13') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 346 OR mm.menuid <= 0) ORDER BY m.position, m.ordering
SELECT c.id AS CID FROM educacion_categories AS c LEFT JOIN educacion_content AS content ON c.id = content.catid WHERE ( c.id = 18 ) AND c.extension = 'com_content' AND c.published = 1
SELECT content.id AS iid FROM educacion_content AS content WHERE content.state = 1 AND content.access IN (1,1) AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2025-06-08 03:17:13' ) AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2025-06-08 03:17:13' ) AND ( content.catid = 18 ) ORDER BY content.created DESC LIMIT 0,3;
SELECT content.id AS iid, content.title AS title, content.introtext AS text, content.created AS date, content.publish_up AS date_publish, content.hits AS hits, content.images AS images, content.featured AS frontpage, content.access AS access, content.language AS lang, categories.title AS catname, users.email AS author_email, content.created_by_alias AS author_alias, users.name AS author_username, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count, CASE WHEN CHAR_LENGTH(content.alias) THEN CONCAT_WS(":", content.id, content.alias) ELSE content.id END as id, CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS(":", categories.id, categories.alias) ELSE categories.id END as cid FROM educacion_content AS content LEFT JOIN educacion_categories AS categories ON categories.id = content.catid LEFT JOIN educacion_users AS users ON users.id = content.created_by LEFT JOIN educacion_content_rating AS content_rating ON content_rating.content_id = content.id WHERE content.id = 1885 OR content.id = 1883 OR content.id = 1881 ORDER BY content.created DESC
SELECT extension_id AS id, element AS "option", params, enabled FROM educacion_extensions WHERE `type` = 'component' AND `element` = 'com_contact'
SELECT * FROM educacion_jmap_metainfo WHERE `linkurl` = 'https://www10.uc.cl/2jucext/educacion/listado-de-noticias/669-profesor-ernesto-san-martin-publica-en-revista-journal-of-the-royal-statistical-society' AND `published` = 1
UPDATE `educacion_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1749352633;s:18:\"session.timer.last\";i:1749352633;s:17:\"session.timer.now\";i:1749352633;s:24:\"session.client.forwarded\";s:14:\"216.73.216.206\";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;}s:20:\"com_rsfirewall.geoip\";s:2:\"US\";}' , `time` = '1749352634' WHERE `session_id` = '316df6b02a831c703b3151d0ce5d6780'

35 Tipos de consultas del registro, Ordenado por acontecimientos.

SELECCIONAR Tablas:

6 × SELECT extension_id AS id, element AS "option", params, enabled FROM educacion_extensions
3 × SELECT DISTINCT(user_id) FROM educacion_usergroups as ug1 INNER JOIN educacion_usergroups AS ug2 ON ug2.lft>=ug1.lft AND ug1.rgt>=ug2.rgt INNER JOIN educacion_user_usergroup_map AS m ON ug2.id=m.group_id
2 × SELECT `ip`,`reason` FROM educacion_rsfirewall_lists
2 × SELECT a.rules FROM educacion_assets AS a
2 × SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM educacion_categories as c LEFT JOIN educacion_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 educacion_categories AS cat JOIN educacion_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
1 × SELECT * FROM educacion_rsfirewall_exceptions
1 × SELECT * FROM educacion_rsfirewall_hashes
1 × SELECT id, home, template, s.params FROM educacion_template_styles as s LEFT JOIN educacion_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
1 × SELECT * FROM educacion_rsfirewall_snapshots
1 × SELECT b.rules FROM educacion_assets AS a LEFT JOIN educacion_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT content.id AS iid, content.title AS title, content.introtext AS text, content.created AS date, content.publish_up AS date_publish, content.hits AS hits, content.images AS images, content.featured AS frontpage, content.access AS access, content.language AS lang, categories.title AS catname, users.email AS author_email, content.created_by_alias AS author_alias, users.name AS author_username, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count, CASE WHEN CHAR_LENGTH(content.alias) THEN CONCAT_WS(":", content.id, content.alias) ELSE content.id END as id, CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS(":", categories.id, categories.alias) ELSE categories.id END as cid FROM educacion_content AS content LEFT JOIN educacion_categories AS categories ON categories.id = content.catid LEFT JOIN educacion_users AS users ON users.id = content.created_by LEFT JOIN educacion_content_rating AS content_rating ON content_rating.content_id = content.id
1 × SELECT * FROM educacion_jmap_metainfo
1 × SELECT content.id AS iid FROM educacion_content AS content
1 × SELECT c.id AS CID FROM educacion_categories AS c LEFT JOIN educacion_content AS content ON c.id = content.catid
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, a.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,( SELECT MAX(contact.id) AS id FROM educacion_contact_details AS contact
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM educacion_modules AS m LEFT JOIN educacion_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN educacion_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
1 × SELECT u.* FROM educacion_users u
1 × SELECT `id` FROM `educacion_usergroups
1 × SELECT folder AS type, element AS name, params FROM educacion_extensions
1 × SELECT `path` FROM educacion_rsfirewall_ignored
1 × SELECT id, rules FROM `educacion_viewlevels
1 × SELECT b.id FROM educacion_usergroups AS a LEFT JOIN educacion_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT `session_id` FROM `educacion_session`
1 × SELECT `file` FROM educacion_rsfirewall_hashes
1 × SELECT * FROM educacion_rsfirewall_configuratio
1 × SELECT alias, catid FROM educacion_content
1 × SELECT `params` FROM educacion_extensions
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 educacion_menu AS m LEFT JOIN educacion_extensions AS e ON m.component_id = e.extension_id
1 × SELECT * FROM educacion_languages
1 × SELECT `data` FROM `educacion_session`

OTRAS Tablas:

1 × UPDATE `educacion_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1749352633;s:18:\"session.timer.last\";i:1749352633;s:17:\"session.timer.now\";i:1749352633;s:24:\"session.client.forwarded\";s:14:\"216.73.216.206\";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;}s:20:\"com_rsfirewall.geoip\";s:2:\"US\";}' , `time` = '1749352634'
1 × UPDATE educacion_content SET hits = hits + 1
1 × SHOW FULL COLUMNS FROM `educacion_rsfirewall_logs
1 × INSERT INTO `educacion_session` (`session_id`, `client_id`, `time`) VALUES ('316df6b02a831c703b3151d0ce5d6780', 0, '1749352633'
1 × DELETE FROM `educacion_session`

Profesor Ernesto San Martín publica en revista Journal of the Royal Statistical Society

¿Qué se estudia en las carreras de Pedagogías UC?

Académicas y académicos de Educación UC realizan conversatorio sobre Metodología ABP

¿Qué es ser un profesor o una profesora?

Consola de Joomla! Debug

Sesión

__default

user

Información de Perfil

Uso de Memoria

Registro Database

45 Registro Consultas

35 Tipos de consultas del registro, Ordenado por acontecimientos.

SELECCIONAR Tablas:

OTRAS Tablas: