(mysql): SELECT * FROM sessions WHERE session_id = 'c9j6tcg587v8qonm8g4qkmueq7'
(mysql): SELECT * FROM journals WHERE path = 'ijocs'
(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 = '56') 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 = '56'
(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 = '24501' 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 = 24501
(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 = 24501 ORDER BY g.seq
(mysql): SELECT * FROM article_galley_settings WHERE galley_id = '7547'
(mysql): SELECT * FROM article_settings WHERE article_id = '24501'
(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 = 24501 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 = '741' ORDER BY i.issue_id
(mysql): SELECT i.* FROM issues i WHERE issue_id = 741
(mysql): SELECT * FROM issue_settings WHERE issue_id = '741'
(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 = '56'
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 09:52:29' >= s.date_start AND '2025-09-17 09:52:29' <= 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 = '56'
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 09:52:29' >= s.date_start AND '2025-09-17 09:52:29' <= 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 = '56'
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 09:52:29' >= s.date_start AND '2025-09-17 09:52:29' <= 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 = 7547 AND g.article_id = 24501
(mysql): SELECT * FROM article_galley_settings WHERE galley_id = '7547'
(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 = '56') OR v.sitewide = 1)
WHERE v.current = 1 AND (ps.setting_value = '1' OR v.lazy_load <> 1)
(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 = '24501' 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 = 24501
(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 = 24501 ORDER BY g.seq
(mysql): SELECT * FROM article_galley_settings WHERE galley_id = '7547'
(mysql): SELECT * FROM article_settings WHERE article_id = '24501'
(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 = 24501 ORDER BY s.seq
(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 = '24501'
(mysql): SELECT * FROM article_settings WHERE article_id = '24501'
(mysql): SELECT a.* FROM article_files a WHERE file_id = '60952' AND article_id = '24501' ORDER BY revision DESC LIMIT 1
(mysql): select version()
%PDF-1.5
%
13 0 obj
<<
/Type /FontDescriptor
/FontName /Times#20New#20Roman,Bold
/Flags 32
/ItalicAngle 0
/Ascent 891
/Descent -216
/CapHeight 677
/AvgWidth 427
/MaxWidth 2558
/FontWeight 700
/XHeight 250
/Leading 42
/StemV 42
/FontBBox [-558 -216 2000 677]
>>
endobj
14 0 obj
[250 0 0 0 0 0 0 0 0 0 500 0 250 333 250 0 500 500 500 0 500 0 0 0 0 500 333 0 0 0 0 0 0 722 667 722 722 667 611 778 778 389 500 778 667 944 722 778 611 0 722 556 667 722 722 1000 0 0 0 0 0 0 0 0 0 500 556 444 556 444 333 500 556 278 333 556 278 833 556 500 556 556 444 389 333 556 500 722 0 500]
endobj
12 0 obj
<<
/Type /Font
/Subtype /TrueType
/Name /F1
/BaseFont /Times#20New#20Roman,Bold
/Encoding /WinAnsiEncoding
/FontDescriptor 13 0 R
/FirstChar 32
/LastChar 121
/Widths 14 0 R
>>
endobj
16 0 obj
<<
/Type /FontDescriptor
/FontName /Times#20New#20Roman
/Flags 32
/ItalicAngle 0
/Ascent 891
/Descent -216
/CapHeight 693
/AvgWidth 401
/MaxWidth 2614
/FontWeight 400
/XHeight 250
/Leading 42
/StemV 40
/FontBBox [-568 -216 2046 693]
>>
endobj
17 0 obj
[250 0 408 0 0 833 778 180 333 333 500 0 250 333 250 278 500 500 500 500 500 500 500 500 500 500 278 278 564 0 564 0 921 722 667 667 722 611 556 722 722 333 389 722 611 889 722 722 556 722 667 556 611 722 722 944 722 722 0 0 0 0 0 0 0 444 500 444 500 444 333 500 500 278 278 500 278 778 500 500 500 500 333 389 278 500 500 722 500 500 444 0 200 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 722 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 444 0 0 0 0 0 0 0 0 0 0 0 0 0 0 500 0 0 0 0 0 500]
endobj
15 0 obj
<<
/Type /Font
/Subtype /TrueType
/Name /F2
/BaseFont /Times#20New#20Roman
/Encoding /WinAnsiEncoding
/FontDescriptor 16 0 R
/FirstChar 32
/LastChar 252
/Widths 17 0 R
>>
endobj
19 0 obj
<<
/Type /FontDescriptor
/FontName /Times#20New#20Roman,BoldItalic
/Flags 32
/ItalicAngle -16.4
/Ascent 891
/Descent -216
/CapHeight 677
/AvgWidth 412
/MaxWidth 1948
/FontWeight 700
/XHeight 250
/Leading 42
/StemV 41
/FontBBox [-547 -216 1401 677]
>>
endobj
20 0 obj
[250 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 333 0 0 0 0 0 0 667 0 0 0 0 0 0 0 0 0 667 0 889 0 0 0 0 0 556 0 0 0 0 0 0 0 0 0 0 0 0 0 500 500 444 500 444 0 0 556 278 0 0 0 0 0 500 0 500 389 389 278 0 0 667 0 444]
endobj
18 0 obj
<<
/Type /Font
/Subtype /TrueType
/Name /F3
/BaseFont /Times#20New#20Roman,BoldItalic
/Encoding /WinAnsiEncoding
/FontDescriptor 19 0 R
/FirstChar 32
/LastChar 121
/Widths 20 0 R
>>
endobj
24 0 obj
<<
/Ordering (Identity)
/Registry (Adobe)
/Supplement 0
>>
endobj
26 0 obj
<<
/Filter /FlateDecode
/Length 95598
/Length1 343992
>>
stream
x `s}gg\
!\@8xԪZy_{U˦oŶ֣Uof/V $Y'y9yv e']x|Nwg}Q`; 9-{,;~+`S.oy|?Zo'e?@Ǔ \!)wn_ܵJx˩ݽ˗}|+(