(mysql): SELECT * FROM sessions WHERE session_id = 'tpv8co46u5rordtr00ug077rm1'
(mysql): SELECT * FROM journals WHERE path = 'lics4'
(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 = '922') 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 = '922'
(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 DISTINCT
CAST('' AS CHAR) AS url,
0 AS author_id,
0 AS submission_id,
CAST('' AS CHAR) AS email,
0 AS primary_contact,
0 AS seq,
aa.first_name,
aa.middle_name,
aa.last_name,
CASE WHEN asl.setting_value = '' THEN NULL ELSE SUBSTRING(asl.setting_value FROM 1 FOR 255) END AS affiliation_l,
CASE WHEN asl.setting_value = '' THEN NULL ELSE asl.locale END AS locale,
CASE WHEN aspl.setting_value = '' THEN NULL ELSE SUBSTRING(aspl.setting_value FROM 1 FOR 255) END AS affiliation_pl,
CASE WHEN aspl.setting_value = '' THEN NULL ELSE aspl.locale END AS primary_locale,
CASE WHEN aa.country = '' THEN NULL ELSE aa.country END AS country
FROM authors aa
LEFT JOIN author_settings aspl ON (aa.author_id = aspl.author_id AND aspl.setting_name = 'affiliation' AND aspl.locale = 'en_US')
LEFT JOIN author_settings asl ON (aa.author_id = asl.author_id AND asl.setting_name = 'affiliation' AND asl.locale = 'en_US')
JOIN articles a ON (a.article_id = aa.submission_id AND a.status = 3)
JOIN published_articles pa ON (pa.article_id = a.article_id)
JOIN issues i ON (pa.issue_id = i.issue_id AND i.published = 1)
JOIN sections s ON (a.section_id = s.section_id)
JOIN journals j ON (a.journal_id = j.journal_id)
WHERE a.journal_id = '922'
AND (aa.last_name IS NOT NULL AND aa.last_name <> '')
AND ((s.hide_author = 0 AND a.hide_author = 0) OR a.hide_author = 2)
AND LOWER(aa.last_name) LIKE LOWER('o%')
(mysql): SELECT DISTINCT
CAST('' AS CHAR) AS url,
0 AS author_id,
0 AS submission_id,
CAST('' AS CHAR) AS email,
0 AS primary_contact,
0 AS seq,
aa.first_name,
aa.middle_name,
aa.last_name,
CASE WHEN asl.setting_value = '' THEN NULL ELSE SUBSTRING(asl.setting_value FROM 1 FOR 255) END AS affiliation_l,
CASE WHEN asl.setting_value = '' THEN NULL ELSE asl.locale END AS locale,
CASE WHEN aspl.setting_value = '' THEN NULL ELSE SUBSTRING(aspl.setting_value FROM 1 FOR 255) END AS affiliation_pl,
CASE WHEN aspl.setting_value = '' THEN NULL ELSE aspl.locale END AS primary_locale,
CASE WHEN aa.country = '' THEN NULL ELSE aa.country END AS country
FROM authors aa
LEFT JOIN author_settings aspl ON (aa.author_id = aspl.author_id AND aspl.setting_name = 'affiliation' AND aspl.locale = 'en_US')
LEFT JOIN author_settings asl ON (aa.author_id = asl.author_id AND asl.setting_name = 'affiliation' AND asl.locale = 'en_US')
JOIN articles a ON (a.article_id = aa.submission_id AND a.status = 3)
JOIN published_articles pa ON (pa.article_id = a.article_id)
JOIN issues i ON (pa.issue_id = i.issue_id AND i.published = 1)
JOIN sections s ON (a.section_id = s.section_id)
JOIN journals j ON (a.journal_id = j.journal_id)
WHERE a.journal_id = '922'
AND (aa.last_name IS NOT NULL AND aa.last_name <> '')
AND ((s.hide_author = 0 AND a.hide_author = 0) OR a.hide_author = 2)
AND LOWER(aa.last_name) LIKE LOWER('o%')
ORDER BY aa.last_name, aa.first_name LIMIT 0,25
(mysql): SELECT i.* FROM issues i WHERE journal_id = 922 AND current = 1
(mysql): SELECT * FROM issue_settings WHERE issue_id = '667'
(mysql): select version()
Browse Author Index
