(mysqli): SELECT * FROM sessions WHERE session_id = 'abkmh0dm1nngfmmkucubrr1u45'
(mysqli): INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, domain)
VALUES
('abkmh0dm1nngfmmkucubrr1u45', '3.139.82.23', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 1713885789, 1713885789, 0, '', 'www.ambb.org.ar')
(mysqli): SELECT * FROM journals WHERE path = 'RCAMBB'
(mysqli): SELECT * FROM site
(mysqli): SELECT v.*
FROM versions v LEFT JOIN plugin_settings ps ON
lower(v.product_class_name) = ps.plugin_name
AND ps.setting_name = 'enabled' AND ((journal_id = '1') OR v.sitewide = 1)
WHERE v.current = 1 AND (ps.setting_value = '1' OR v.lazy_load <> 1)
(mysqli): select version()
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.generic.pln.classes.tasks.Depositor'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.generic.usageStats.UsageStatsLoader'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.crossref.CrossrefInfoSender'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.datacite.DataciteInfoSender'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.medra.MedraInfoSender'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.crossref.CrossrefInfoSender'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.crossref.CrossrefInfoSender'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'classes.tasks.ReviewReminder'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'classes.tasks.SubscriptionExpiryReminder'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'classes.tasks.OpenAccessNotification'
(mysqli): SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa
INNER JOIN articles a ON pa.article_id = a.article_id
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'es_ES')
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'es_ES')
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'es_ES')
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'es_ES') INNER JOIN article_settings ast ON a.article_id = ast.article_id
WHERE ast.setting_name = 'pub-id::publisher-id' AND ast.setting_value = '7' AND a.status <> 0 ORDER BY pa.issue_id, a.article_id
(mysqli): SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'es_ES')
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'es_ES')
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'es_ES')
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'es_ES')
WHERE pa.article_id = a.article_id
AND a.status <> 0
AND a.article_id = 7
(mysqli): SELECT g.*,
a.file_name, a.original_file_name, a.file_stage, a.file_type, a.file_size, a.date_uploaded, a.date_modified
FROM article_galleys g
LEFT JOIN article_files a ON (g.file_id = a.file_id)
WHERE g.article_id = 7 ORDER BY g.seq
(mysqli): SELECT * FROM article_galley_settings WHERE galley_id = '12'
(mysqli): SELECT * FROM article_settings WHERE article_id = '7'
(mysqli): SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 7 ORDER BY s.seq
(mysqli): SELECT i.*
FROM issues i INNER JOIN issue_settings ist ON i.issue_id = ist.issue_id
WHERE ist.setting_name = 'pub-id::publisher-id' AND ist.setting_value = '3' ORDER BY i.issue_id
(mysqli): SELECT i.* FROM issues i WHERE issue_id = 3
(mysqli): SELECT * FROM issue_settings WHERE issue_id = '3'
(mysqli):
SELECT iss.subscription_id
FROM
institutional_subscriptions iss,
subscriptions s,
subscription_types st
WHERE POSITION(UPPER(LPAD(iss.domain, LENGTH(iss.domain)+1, '.')) IN UPPER(LPAD('ec2-3-139-82-23.us-east-2.compute.amazonaws.com', LENGTH('ec2-3-139-82-23.us-east-2.compute.amazonaws.com')+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = '1'
AND s.status = 1
AND s.type_id = st.type_id
AND st.institutional = 1 AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2024-04-23 12:23:09' >= s.date_start AND '2024-04-23 12:23:09' <= s.date_end))) AND (st.format = 1
OR st.format = 17)
(mysqli):
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND '59462167' >= isip.ip_start AND '59462167' <= isip.ip_end
AND isip.subscription_id = s.subscription_id
AND s.journal_id = '1'
AND s.status = 1
AND s.type_id = st.type_id
AND st.institutional = 1 AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2024-04-23 12:23:09' >= s.date_start AND '2024-04-23 12:23:09' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND '59462167' = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = '1'
AND s.status = 1
AND s.type_id = st.type_id
AND st.institutional = 1 AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2024-04-23 12:23:09' >= s.date_start AND '2024-04-23 12:23:09' <= s.date_end))) AND (st.format = 1
OR st.format = 17)))
(mysqli): SELECT g.*,
af.file_name, af.original_file_name, af.file_stage, af.file_type, af.file_size, af.date_uploaded, af.date_modified
FROM article_galleys g
LEFT JOIN article_files af ON (g.file_id = af.file_id)
INNER JOIN articles a ON a.article_id = g.article_id
LEFT JOIN published_articles pa ON g.article_id = pa.article_id INNER JOIN article_galley_settings gs ON g.galley_id = gs.galley_id
WHERE gs.setting_name = 'pub-id::publisher-id' AND gs.setting_value = '12' AND g.article_id = 7 ORDER BY a.journal_id, pa.issue_id, g.galley_id
(mysqli): SELECT g.*,
a.file_name, a.original_file_name, a.file_stage, a.file_type, a.file_size, a.date_uploaded, a.date_modified
FROM article_galleys g
LEFT JOIN article_files a ON (g.file_id = a.file_id)
WHERE g.galley_id = 12 AND g.article_id = 7
(mysqli): SELECT * FROM article_galley_settings WHERE galley_id = '12'
(mysqli): SELECT v.*
FROM versions v LEFT JOIN plugin_settings ps ON
lower(v.product_class_name) = ps.plugin_name
AND ps.setting_name = 'enabled' AND ((journal_id = '1') OR v.sitewide = 1)
WHERE v.current = 1 AND (ps.setting_value = '1' OR v.lazy_load <> 1)
(mysqli): SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'es_ES')
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'es_ES')
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'es_ES')
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'es_ES')
WHERE article_id = '7'
(mysqli): SELECT * FROM article_settings WHERE article_id = '7'
(mysqli): SELECT a.* FROM article_files a WHERE file_id = '33' AND article_id = '7' ORDER BY revision DESC LIMIT 1
%PDF-1.6
%
21 0 obj
<>
endobj
42 0 obj
<>/Filter/FlateDecode/ID[<0F26F77C59262243929B024A48311DFE>]/Index[21 51]/Info 20 0 R/Length 108/Prev 205151/Root 22 0 R/Size 72/Type/XRef/W[1 3 1]>>stream
hbbd```b``z"dXfHE0i"yůEA|7"$.P"S@zU=L@7, mO w
endstream
endobj
startxref
0
%%EOF
71 0 obj
<>stream
hb```e``a`a`Heb@ !+s