(mysqli): SELECT * FROM sessions WHERE session_id = '5216b4bdc321f5aa3cb7e39646513d0c'
(mysqli): INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, domain)
VALUES
('5216b4bdc321f5aa3cb7e39646513d0c', '18.118.0.42', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 1729608624, 1729608624, 0, '', 'ajhse.org')
(mysqli): SELECT * FROM journals WHERE path = 'ajhse'
(mysqli): SELECT * FROM journal_settings WHERE journal_id = '1'
(mysqli): SELECT * FROM site
(mysqli): SET time_zone = '+0:00'
(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 (context_id = '1' OR v.sitewide = 1)
WHERE v.current = 1 AND (ps.setting_value = '1' OR v.lazy_load <> 1)
(mysqli): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'defaultthemeplugin' AND context_id = 1
(mysqli): SELECT * FROM journals WHERE path = 'ajhse'
(mysqli): SELECT * FROM journal_settings WHERE journal_id = '1'
(mysqli): SELECT c.* FROM journals c
WHERE c.enabled = 1 ORDER BY seq
(mysqli): SELECT * FROM navigation_menu_items WHERE path = 'article/download/433/147' and context_id = 1 and type= 'NMI_TYPE_CUSTOM'
(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.generic.usageStats.UsageStatsLoader'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.doaj.DOAJInfoSender'
(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.generic.usageStats.UsageStatsLoader'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.doaj.DOAJInfoSender'
(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.generic.usageStats.UsageStatsLoader'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.doaj.DOAJInfoSender'
(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.generic.usageStats.UsageStatsLoader'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.doaj.DOAJInfoSender'
(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.generic.usageStats.UsageStatsLoader'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.doaj.DOAJInfoSender'
(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 = 'lib.pkp.classes.task.ReviewReminder'
(mysqli): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON ps.submission_id = s.submission_id
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')INNER JOIN submission_settings sst ON s.submission_id = sst.submission_id
WHERE sst.setting_name = 'pub-id::publisher-id' AND sst.setting_value = '433' ORDER BY ps.issue_id, s.submission_id
(mysqli): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 433
(mysqli): SELECT * FROM submission_settings WHERE submission_id = '433'
(mysqli): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 433
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysqli): SELECT * FROM submission_galley_settings WHERE galley_id = '147'
(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 = '10' ORDER BY i.issue_id
(mysqli): SELECT i.* FROM issues i WHERE issue_id = 10
(mysqli): SELECT * FROM issue_settings WHERE issue_id = '10'
(mysqli): SELECT g.*
FROM submission_galleys g
INNER JOIN submissions a ON a.submission_id = g.submission_id
LEFT JOIN published_submissions pa ON g.submission_id = pa.submission_id INNER JOIN submission_galley_settings gs ON g.galley_id = gs.galley_id
WHERE gs.setting_name = 'pub-id::publisher-id' AND gs.setting_value = '147' AND g.submission_id = 433 ORDER BY a.context_id, pa.issue_id, g.galley_id
(mysqli): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.galley_id = 147
AND nsf.file_id IS NULL AND g.submission_id = 433
(mysqli): SELECT * FROM submission_galley_settings WHERE galley_id = '147'
(mysqli):
SELECT iss.subscription_id
FROM institutional_subscriptions iss
JOIN subscriptions s ON (iss.subscription_id = s.subscription_id)
JOIN subscription_types st ON (s.type_id = st.type_id)
WHERE POSITION(UPPER(LPAD(iss.domain, LENGTH(iss.domain)+1, '.')) IN UPPER(LPAD('ec2-18-118-0-42.us-east-2.compute.amazonaws.com', LENGTH('ec2-18-118-0-42.us-east-2.compute.amazonaws.com')+1, '.'))) != 0
AND iss.domain != ''
AND s.journal_id = 1
AND s.status = 1
AND st.institutional = 1
AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2024-10-22 14:50:24' >= s.date_start AND '2024-10-22 14:50:24' <= s.date_end)))
AND (st.format = 1
OR st.format = 17)
(mysqli): SELECT isip.subscription_id
FROM institutional_subscription_ip isip
JOIN subscriptions s ON (isip.subscription_id = s.subscription_id)
JOIN subscription_types st ON (s.type_id = st.type_id)
WHERE ((isip.ip_end IS NOT NULL
AND '309723178' >= isip.ip_start AND '309723178' <= isip.ip_end
AND s.journal_id = 1
AND s.status = 1
AND st.institutional = 1
AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2024-10-22 14:50:24' >= s.date_start AND '2024-10-22 14:50:24' <= s.date_end)))
AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND '309723178' = isip.ip_start
AND s.journal_id = 1
AND s.status = 1
AND st.institutional = 1
AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2024-10-22 14:50:24' >= s.date_start AND '2024-10-22 14:50:24' <= s.date_end)))
AND (st.format = 1
OR st.format = 17)))
(mysqli): SELECT DISTINCT
sf.file_id AS submission_file_id, sf.revision AS submission_revision,
af.file_id AS artwork_file_id, af.revision AS artwork_revision,
suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision,
s.locale AS submission_locale,
sf.*, af.*, suf.*
FROM submission_files sf
LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision
LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision
LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision
WHERE sf2.revision IS NULL AND sf.file_id = 1653 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysqli): SELECT * FROM submission_file_settings WHERE file_id = '1653'
(mysqli): SELECT DISTINCT
sf.file_id AS submission_file_id, sf.revision AS submission_revision,
af.file_id AS artwork_file_id, af.revision AS artwork_revision,
suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision,
s.locale AS submission_locale,
sf.*, af.*, suf.*
FROM submission_files sf
LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision
LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision
LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision
WHERE sf2.revision IS NULL AND sf.file_id = 1653 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysqli): SELECT * FROM submission_file_settings WHERE file_id = '1653'
(mysqli): SELECT DISTINCT
sf.file_id AS submission_file_id, sf.revision AS submission_revision,
af.file_id AS artwork_file_id, af.revision AS artwork_revision,
suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision,
s.locale AS submission_locale,
sf.*, af.*, suf.*
FROM submission_files sf
LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision
LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision
LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision
WHERE sf2.revision IS NULL AND sf.file_id = 1653 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysqli): SELECT * FROM submission_file_settings WHERE file_id = '1653'
(mysqli): SELECT s.*, ps.date_published,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM submissions s
LEFT JOIN published_submissions ps ON (s.submission_id = ps.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 433
(mysqli): SELECT * FROM submission_settings WHERE submission_id = '433'
(mysqli): SELECT * FROM genres WHERE genre_id = 17 ORDER BY seq
(mysqli): SELECT * FROM genre_settings WHERE genre_id = '17'
%PDF-1.7
%
1 0 obj
<>/Metadata 786 0 R/ViewerPreferences 787 0 R>>
endobj
2 0 obj
<>
endobj
3 0 obj
<>/ExtGState<>/XObject<>/ProcSet[/PDF/Text/ImageB/ImageC/ImageI] >>/Annots[ 23 0 R] /MediaBox[ 0 0 612 792] /Contents 4 0 R/Group<>/Tabs/S/StructParents 0>>
endobj
4 0 obj
<>
stream
x=r۸?43q!95Zv2sb眝"+6gekjhr8H˦*H{h@˓"駗'wy2-v>_J^%Yfy%U̞?קϟ|#!L%_?.KDR*Ub*29voOL骴Wo?}39ϟ%%*p,T*HmQTiɧ(z*2%am<FF6O5`T(#aҢ0RNvzzF'c3 xc5t`!T<&nX"**F9UK+AbG-`'7۱-;jtO?}d9}fxQWx';+qw'snz3ޑ5~Al_t>f@dyWj4Y Fg
;_/I5>ؽE0{"vJo5/Nfp>:ů3B蛨nkq"#Xbƍ3F]YID镂"Ka[?,
G+y50vj@-791/ ylZY0|Fϓs}3.W01.(x;kd˚%
K-]gtD:v@'?AHd]^RwYV[H-#YcZW FP)#Fvc<ʀ6OjQp:ydK3dJ-j[]W]pi i~2YS~(Na셪ﺰ"_mHz%dDn^Q=e{7VY~c:D*n]=ٮzhdk~mGk
,a{jDE<\ƬX9#^m04K&h[چ2d
KfCXc ƌ= dq2
BaIdG9mGZ0(B;y@O>.цdw1cGkQX+S8v@gvI-5>[AIߐ&g?ƢOMcC &-k$IJDa4"ꯄ#s\}!`*S`".3`DauGe(H䱃5i<&bYaxlaCxg0oӱۻgxiƅCҪ*B0);IiWR31x)5~[PۓR?%,><4sF9,-b^(L\ha\{T0o/gZW6)TZ-w81SSBv3H֡TnnuF
55˲DXq#u?QWn5j͜ՊN/Onة|x&U䳟b4p?DXqc"n9/Y4.mb]r|O}Z.v@V^Ozɂ38-GqLpH|/Kʟ!#DBU*nIg!Ib5">SDn$Ntv.FI2ur8W"ͫkKw;-|fm|]ppRzpJn{#IZB FRP{pD(;v4|
fY?jOhc^a#[!hŁ7
($j%nYϸlrk,\FZ\WpॷH^ Z=K0Tyg7-9>ǂk3nzٗˈSv/q:epo9h`416Y~LYTvw'PxO%7g?n ՍHRtJEgnxc)iO3gׂ
컐@׆$WeZ%4$8~QA͌Y\]A:QBnflvV},)6*ҪʳrZU-2
ЛW3h/eXnR>WO !cmQ(
[V^e?1|DiRU͏U؎?J~(
^?Q|rm['[>A|