(mysql): SELECT * FROM sessions WHERE session_id = 'ikbdpm2u0gjs4vulvqbmq53f55'

(mysql): SELECT * FROM journals WHERE path = 'pendas'

(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 = '25') 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 = '25'

(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.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 = '18107' 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 = 18107

(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 = 18107 ORDER BY g.seq

(mysql): SELECT * FROM article_galley_settings WHERE galley_id = '6459'

(mysql): SELECT * FROM article_settings WHERE article_id = '18107'

(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 = 18107 ORDER BY s.seq

(mysql): SELECT * FROM article_supp_file_settings WHERE supp_id = '3377'

(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 = '645' ORDER BY i.issue_id

(mysql): SELECT i.* FROM issues i WHERE issue_id = 645

(mysql): SELECT * FROM issue_settings WHERE issue_id = '645'

(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 = '25' 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:10:38' >= s.date_start AND '2025-09-17 09:10:38' <= 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 = '25' 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:10:38' >= s.date_start AND '2025-09-17 09:10:38' <= 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 = '25' 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:10:38' >= s.date_start AND '2025-09-17 09:10:38' <= s.date_end))) AND (st.format = 1 OR st.format = 17)))

(mysql): SELECT * FROM article_galley_settings WHERE galley_id = '6459'

(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 = 18107

(mysql): SELECT * FROM article_galley_settings WHERE galley_id = '6459'

(mysql): SELECT * FROM article_settings WHERE article_id = '18107'

(mysql): SELECT * FROM article_supp_file_settings WHERE supp_id = '3377'

(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 = '18107'

(mysql): SELECT * FROM article_settings WHERE article_id = '18107'

(mysql): SELECT a.* FROM article_files a WHERE file_id = '46038' AND article_id = '18107' ORDER BY revision DESC LIMIT 1

(mysql): select version()