(mysql): SELECT * FROM sessions WHERE session_id = 'rlql87dl6u4v1jej1k2qja0l21'
(mysql): SELECT * FROM journals WHERE path = 'odj'
(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 = '27') 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 = '27'
(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 LEAST(a.date_submitted, COALESCE(pa.date_published, NOW()), COALESCE(i.date_published, NOW())) AS first_date
FROM articles a
LEFT JOIN published_articles pa ON (a.article_id = pa.article_id)
LEFT JOIN issues i ON (pa.issue_id = i.issue_id)
LEFT JOIN articles a2 ON (a2.article_id < a.article_id AND a2.date_submitted IS NOT NULL AND a2.journal_id = 27)
WHERE a2.article_id IS NULL AND
a.date_submitted IS NOT NULL AND
a.journal_id = 27
(mysql): SELECT MIN(u.date_registered) AS first_date FROM users u JOIN roles r ON (u.user_id = r.user_id) WHERE r.journal_id = 27
(mysql): SELECT a.article_id,
a.date_submitted,
pa.date_published,
pa.published_article_id,
d.decision,
a.status
FROM articles a
LEFT JOIN published_articles pa ON (a.article_id = pa.article_id)
LEFT JOIN edit_decisions d ON (d.article_id = a.article_id)
WHERE a.journal_id = '27' AND a.date_submitted >= '2016-01-01 00:00:00' AND a.date_submitted <= '2016-12-31 23:59:59' ORDER BY a.article_id, d.date_decided DESC
(mysql): SELECT a.article_id,
a.date_submitted,
pa.date_published,
pa.published_article_id,
d.decision,
a.status
FROM articles a
LEFT JOIN published_articles pa ON (a.article_id = pa.article_id)
LEFT JOIN edit_decisions d ON (d.article_id = a.article_id)
WHERE a.journal_id = '27' AND a.date_submitted >= '2016-01-01 00:00:00' AND a.date_submitted <= '2016-12-31 23:59:59' ORDER BY a.article_id, d.date_decided DESC
(mysql): SELECT * FROM sections WHERE journal_id = '27' ORDER BY seq
(mysql): SELECT * FROM section_settings WHERE section_id = '27'
(mysql): SELECT * FROM section_settings WHERE section_id = '177'
(mysql): SELECT * FROM section_settings WHERE section_id = '64'
(mysql): SELECT COUNT(*) AS count, published FROM issues WHERE journal_id = '27' AND date_published >= '2016-01-01 00:00:00' AND date_published <= '2016-12-31 23:59:59' GROUP BY published
(mysql): SELECT a.article_id,
af.date_uploaded AS date_rv_uploaded,
r.review_id,
u.date_registered,
r.reviewer_id,
r.quality,
r.date_assigned,
r.date_completed
FROM articles a,
article_files af,
review_assignments r
LEFT JOIN users u ON (u.user_id = r.reviewer_id)
WHERE a.journal_id = '27'
AND r.submission_id = a.article_id
AND af.article_id = a.article_id
AND af.file_id = a.review_file_id
AND af.revision = 1 AND a.date_submitted >= '2016-01-01 00:00:00' AND a.date_submitted <= '2016-12-31 23:59:59'
(mysql): SELECT COUNT(DISTINCT r.user_id) FROM roles r, users u WHERE r.user_id = u.user_id AND r.journal_id = '27' AND u.date_registered <= '2016-12-31 23:59:59'
(mysql): SELECT r.role_id, COUNT(r.user_id) AS role_count FROM roles r LEFT JOIN users u ON (r.user_id = u.user_id) WHERE r.journal_id = '27' AND u.date_registered <= '2016-12-31 23:59:59' GROUP BY r.role_id
(mysql): SELECT COUNT(DISTINCT r.user_id) FROM roles r, users u WHERE r.user_id = u.user_id AND r.journal_id = '27' AND u.date_registered >= '2016-01-01 00:00:00' AND u.date_registered <= '2016-12-31 23:59:59'
(mysql): SELECT r.role_id, COUNT(r.user_id) AS role_count FROM roles r LEFT JOIN users u ON (r.user_id = u.user_id) WHERE r.journal_id = '27' AND u.date_registered >= '2016-01-01 00:00:00' AND u.date_registered <= '2016-12-31 23:59:59' GROUP BY r.role_id
(mysql): SELECT i.* FROM issues i WHERE journal_id = 27 AND current = 1
(mysql): SELECT * FROM issue_settings WHERE issue_id = '1211'
(mysql): select version()
(mysql): SELECT * FROM plugin_settings ps WHERE plugin_name = 'garuda2xblockplugin' AND setting_name = 'context' AND journal_id = '27'
(mysql): SELECT * FROM plugin_settings ps WHERE plugin_name = 'garuda2xblockplugin' AND setting_name = 'enabled' AND journal_id = '27'
(mysql): SELECT * FROM plugin_settings ps WHERE plugin_name = 'garuda2xblockplugin' AND setting_name = 'seq' AND journal_id = '27'
Statistics
