(mysqli): SELECT * FROM sessions WHERE session_id = 'fc76d16de227aa05961a7b2dd0a98773'
(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/291/87' 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 = '291' 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 = 291
(mysqli): SELECT * FROM submission_settings WHERE submission_id = '291'
(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 = 291
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysqli): SELECT * FROM submission_galley_settings WHERE galley_id = '87'
(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 = '8' ORDER BY i.issue_id
(mysqli): SELECT i.* FROM issues i WHERE issue_id = 8
(mysqli): SELECT * FROM issue_settings WHERE issue_id = '8'
(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 = '87' AND g.submission_id = 291 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 = 87
AND nsf.file_id IS NULL AND g.submission_id = 291
(mysqli): SELECT * FROM submission_galley_settings WHERE galley_id = '87'
(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-189-141-81.us-east-2.compute.amazonaws.com', LENGTH('ec2-18-189-141-81.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 12:40:40' >= s.date_start AND '2024-10-22 12:40:40' <= 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 '314412369' >= isip.ip_start AND '314412369' <= 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 12:40:40' >= s.date_start AND '2024-10-22 12:40:40' <= s.date_end)))
AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND '314412369' = 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 12:40:40' >= s.date_start AND '2024-10-22 12:40:40' <= 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 = 1220 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 = '1220'
(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 = 1220 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 = '1220'
(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 = 1220 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 = '1220'
(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 = 291
(mysqli): SELECT * FROM submission_settings WHERE submission_id = '291'
(mysqli): SELECT * FROM genres WHERE genre_id = 17 ORDER BY seq
(mysqli): SELECT * FROM genre_settings WHERE genre_id = '17'
%PDF-1.5
%
1 0 obj
<>
endobj
2 0 obj
<>
endobj
3 0 obj
<>/ExtGState<>/XObject<>/ProcSet[/PDF/Text/ImageB/ImageC/ImageI] >>/Annots[ 25 0 R] /MediaBox[ 0 0 612 792] /Contents 4 0 R/Group<>/Tabs/S>>
endobj
4 0 obj
<>
stream
x=r8?iV8q#\k;Nt55EVbֶl/\ [1~Tl$s铲(_#M,>铽OBdBN>>}"]VEY
N.c}1OtUOc'lu4A~)cQP)
t
# AFTHB7HMYTȊB\OfrWxg~Nr5&B,Mј.
Ǽ|*(r)''TND>xM~[ wV|D$k& A>&aJN;@?g@G S&zPYn'7 9!~2_$C`0=YA59^\!:[-CKgYP\NZGAcO)=r%fA
Ǘ)ۗ,opax:~fB];ĆA|
-1oe|LfK"E/V,
. :xq]R^k7˝D9v b3@cq,C,1"^Fx𨳈0@i)T3V8W(NNzuu7Ii>8#
>N~vI=a9l^G"j4J
H1t:"IsǡȰVA( =lRJ,Ԓ
vjv\Y%TzbS]MHdӠL-iuW=SuQly:zZBEմm_y#j)B t
$@ak&b 35XY4M#ꦵ)8{f+ &\n38rd/@,tI70bjtϡOǖCd!gHlyzI$VeM%`D<p\)+!ȁ*~#D\#4PU>k!]x>Uh2K?hi]pom[-V)M]jIAgjg:8Lbe)X}`Nј8ͦX6eBы˟-Z#nuFV, 3QdZ-t/[Y*UZ(hwr?Ojuc~ěcxLE]r0೮`l##L*٩c<ؽhvR#ʣ%E艝j[z|
7ߺtɖ,rZE+b4Cw}(!]olhgЭh*pĀڣe"2pC{GX28aOB *YKؼpT;~|XZ/ ʲ LZ _yL
2٥,_IAOcFaBpl|$?o:hLC&C卞qFg14!up3Q<6/gМ0xZpնWEm,^*VgNmWwC!fӪnuZ*r/\5~-ↆWn&2d(
<{HD{yеlqNֱ=vLuFFc&<&r\=kpIvet^$6ڡ}pX/\*jtQ>KuRnEs#CAx.P%iaG
?產/_;"ELzbt~턊Lg6~WI7LFCyMN̋S
xcOyuG` byX6DU2`[gԺu.XYDvgc:l6M=BR+R1Z}F';mc+-,wS^Y:zizg)/}*x`!3EJ1PᔎSvdmwvHg%\F,zPmE6eR2YJybcG>){C˟MR::e;Y*]s? &$^2BERD-}:ұ2f)ލLUHOq7XniѪ.fԹX^$[V"ne
0mC_4 #TAQl[-5Sb6ݔ&Uia7,{dZob;1ziFG꺱5=CUcIw_"F--OQ J>MNA+c
L/*ĩQءE7Aw6&!1."V~:#씣`6D1؞2EݯPBv#*ޣ@C;?+ЛFj2@{6WۮJ
vhep{ehTj1?C<Б,{ê[U((|=N[oCҹKTpJ͵I,Eap+͗+)㷁WYQ6SAtRDa?䫧UTӹDuRsIY[jy6:Eqqmd~*-m検\p6AڮI0|Ir(DF,OG #LՈƂ}w((CѺ7W5VI]