(mysql): SELECT * FROM sessions WHERE session_id = 'c7847grtou07eb7un62paufab7'
(mysql): SELECT * FROM journals WHERE path = 'ippi'
(mysql): SELECT * FROM site
(mysql): 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 = '44') OR v.sitewide = 1)
WHERE v.current = 1 AND (ps.setting_value = '1' OR v.lazy_load <> 1)
(mysql): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'objectsforreviewplugin' AND journal_id = '44'
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.generic.usageStats.UsageStatsLoader'
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.generic.pln.classes.tasks.Depositor'
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.crossref.CrossrefInfoSender'
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.crossref.CrossrefInfoSender'
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.datacite.DataciteInfoSender'
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'classes.tasks.ReviewReminder'
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'classes.tasks.SubscriptionExpiryReminder'
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'classes.tasks.OpenAccessNotification'
(mysql): 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 = 'en_US')
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US') INNER JOIN article_settings ast ON a.article_id = ast.article_id
WHERE ast.setting_name = 'pub-id::publisher-id' AND ast.setting_value = '2180' ORDER BY pa.issue_id, a.article_id
(mysql): 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 = 'en_US')
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE pa.article_id = a.article_id
AND a.article_id = 2180
(mysql): 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 = 2180 ORDER BY g.seq
(mysql): SELECT * FROM article_galley_settings WHERE galley_id = '1643'
(mysql): SELECT * FROM article_settings WHERE article_id = '2180'
(mysql): 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 = 2180 ORDER BY s.seq
(mysql): 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 = '221' ORDER BY i.issue_id
(mysql): SELECT i.* FROM issues i WHERE issue_id = 221
(mysql): SELECT * FROM issue_settings WHERE issue_id = '221'
(mysql):
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('216.73.216.3', LENGTH('216.73.216.3')+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = '44'
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 ('2025-09-17 07:21:41' >= s.date_start AND '2025-09-17 07:21:41' <= s.date_end))) AND (st.format = 1
OR st.format = 17)
(mysql):
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND '3628718083' >= isip.ip_start AND '3628718083' <= isip.ip_end
AND isip.subscription_id = s.subscription_id
AND s.journal_id = '44'
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 ('2025-09-17 07:21:41' >= s.date_start AND '2025-09-17 07:21:41' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND '3628718083' = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = '44'
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 ('2025-09-17 07:21:41' >= s.date_start AND '2025-09-17 07:21:41' <= s.date_end))) AND (st.format = 1
OR st.format = 17)))
(mysql): 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 = 1643 AND g.article_id = 2180
(mysql): SELECT * FROM article_galley_settings WHERE galley_id = '1643'
(mysql): 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 = '44') OR v.sitewide = 1)
WHERE v.current = 1 AND (ps.setting_value = '1' OR v.lazy_load <> 1)
(mysql): 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 = 'en_US')
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE article_id = '2180'
(mysql): SELECT * FROM article_settings WHERE article_id = '2180'
(mysql): SELECT a.* FROM article_files a WHERE file_id = '4595' AND article_id = '2180' ORDER BY revision DESC LIMIT 1
(mysql): select version()
%PDF-1.4
%
1 0 obj
<<
/Type /Catalog
/Pages 2 0 R
/PageLayout /OneColumn
/PageMode /UseNone
>>
endobj
2 0 obj
<<
/Type /Pages
/Kids [3 0 R 5 0 R 7 0 R 9 0 R 11 0 R 13 0 R 15 0 R 17 0 R 19 0 R 21 0 R 23 0 R 25 0 R 27 0 R 29 0 R 31 0 R 33 0 R ]
/Count 16
>>
endobj
3 0 obj
<<
/Type /Page
/Parent 2 0 R
/Resources <<
/ProcSet [/PDF /Text ]
/Font <<
/F1 37 0 R
/F2 40 0 R
/F3 43 0 R
/F4 46 0 R
/F5 49 0 R
/F6 52 0 R
/F7 55 0 R
>>
/XObject <<
/Img1 36 0 R
>>
>>
/MediaBox [0 0 612 792]
/Contents 4 0 R
>>
endobj
4 0 obj
<<
/Filter /FlateDecode
/Length 6440
>>
stream
x^=rGr
lČC=u1zZRԮiD @A!^WfU=q
CtWuVVޙ?Ow:v3nf\ۿܜ<}u翺Sn0ޝ'f^ ̫':]髿|Lp.MfOC7R%@#.!m7nq.7~n&uݸ/pyvq~~m t*kW翮]3?V'0<43pJ_4JqI}L(WD)ACz(z ͧ%=M+"~ޠ۲b.cx&Og?mn'?(WkV$Na'7py]X]kp.͐'B[f\̗n[a|ؠu! v3 t7~5:µq{t}'/D{ا
=ïK'XaE!Mʳr0t~lE~`l7h6G%fرZ6dMU:n3x҃n|X6JɅV&g8_DPKrNh{x ~iHfP81lzRoLm@Xv:F<|WO=[}FƺXZX]mA
>2YGc(0 ]С
D-V*PI^g!fTj@
.ib¹[ 蛏'aܸnMf=;}v6Iz֎7C6"vt`л@)p'X7L7
`AoNC7h5}/Kp,#lv?'淋/Oݭ%D:@B^4i\;*kqOHwN_}s3. zLЀ>r}7v)15z/`ohm{ȶ*敻%πP %_NɡΘ3 ~GN_s ! -ޡD-[v%mH]/syW0CNLނDQĘk-]r(T<}8#R(Jʒ{EUՙq^9[KbjSÔR"9zLg0n?alڿ d#ܼ]4(6*x$돠5p`BI
-%]pk"05~Aibt/L87BL$L$kɉmx*oa5?owrC/ۢ9@VL":/967@٫hu
]B/i'8&ɈF~\ \I
߬ )]39i|,hJhȏ
.eݕj6]H=Ge BRќOKw\!1)[ft[][ҳ\сPi;AI :e@r`b 0-0kTe.6`% 0?C#h^Аv_0
#{O
$+