(mysqli): SELECT * FROM sessions WHERE session_id = 'fc76d16de227aa05961a7b2dd0a98773'
(mysqli): SELECT * FROM journals WHERE path = 'ajhse'
(mysqli): SELECT * FROM journal_settings WHERE journal_id = '1'
(mysqli): SELECT * FROM site
(mysqli): SET time_zone = '+0:00'
(mysqli): 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 (context_id = '1' OR v.sitewide = 1)
WHERE v.current = 1 AND (ps.setting_value = '1' OR v.lazy_load <> 1)
(mysqli): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'defaultthemeplugin' AND context_id = 1
(mysqli): SELECT * FROM journals WHERE path = 'ajhse'
(mysqli): SELECT * FROM journal_settings WHERE journal_id = '1'
(mysqli): SELECT c.* FROM journals c
WHERE c.enabled = 1 ORDER BY seq
(mysqli): SELECT * FROM navigation_menu_items WHERE path = 'issue/view/3' and context_id = 1 and type= 'NMI_TYPE_CUSTOM'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.generic.usageStats.UsageStatsLoader'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.generic.usageStats.UsageStatsLoader'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.doaj.DOAJInfoSender'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.crossref.CrossrefInfoSender'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.datacite.DataciteInfoSender'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.medra.MedraInfoSender'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.generic.usageStats.UsageStatsLoader'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.doaj.DOAJInfoSender'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.crossref.CrossrefInfoSender'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.datacite.DataciteInfoSender'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.medra.MedraInfoSender'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.generic.usageStats.UsageStatsLoader'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.doaj.DOAJInfoSender'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.crossref.CrossrefInfoSender'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.datacite.DataciteInfoSender'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.medra.MedraInfoSender'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.generic.usageStats.UsageStatsLoader'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.doaj.DOAJInfoSender'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.crossref.CrossrefInfoSender'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.datacite.DataciteInfoSender'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.medra.MedraInfoSender'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.generic.usageStats.UsageStatsLoader'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.doaj.DOAJInfoSender'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.crossref.CrossrefInfoSender'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.datacite.DataciteInfoSender'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.medra.MedraInfoSender'
(mysqli): SELECT last_run FROM scheduled_tasks WHERE class_name = 'lib.pkp.classes.task.ReviewReminder'
(mysqli): 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 = '3' AND i.journal_id = 1 ORDER BY i.issue_id
(mysqli): SELECT i.* FROM issues i WHERE issue_id = 3 AND journal_id = 1
(mysqli): SELECT * FROM issue_settings WHERE issue_id = '3'
(mysqli): SELECT * FROM genres
WHERE enabled = 1 AND context_id = 1 AND dependent = 0 AND supplementary = 0
ORDER BY seq
(mysqli): SELECT * FROM genre_settings WHERE genre_id = '13'
(mysqli): SELECT * FROM genre_settings WHERE genre_id = '14'
(mysqli): SELECT * FROM genre_settings WHERE genre_id = '15'
(mysqli): SELECT * FROM genre_settings WHERE genre_id = '16'
(mysqli): SELECT * FROM genre_settings WHERE genre_id = '17'
(mysqli): SELECT * FROM genre_settings WHERE genre_id = '18'
(mysqli): SELECT
g.*,
f.file_name,
f.original_file_name,
f.file_type,
f.file_size,
f.content_type,
f.date_uploaded,
f.date_modified
FROM issue_galleys g
LEFT JOIN issue_files f ON (g.file_id = f.file_id)
WHERE g.issue_id = 3 ORDER BY g.seq
(mysqli): SELECT DISTINCT
ps.*,
s.*,
se.abstracts_not_required AS abstracts_not_required,
se.hide_title AS section_hide_title,
se.hide_author AS section_hide_author,
COALESCE(o.seq, se.seq) AS section_seq,
ps.seq,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
LEFT JOIN custom_section_orders o ON (s.section_id = o.section_id AND ps.issue_id = o.issue_id)
WHERE ps.issue_id = 3
AND s.status <> 4
ORDER BY section_seq ASC, ps.seq ASC
(mysqli): SELECT * FROM submission_settings WHERE submission_id = '119'
(mysqli): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 119
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysqli): SELECT * FROM submission_galley_settings WHERE galley_id = '23'
(mysqli): SELECT * FROM submission_settings WHERE submission_id = '120'
(mysqli): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 120
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysqli): SELECT * FROM submission_galley_settings WHERE galley_id = '24'
(mysqli): SELECT * FROM submission_settings WHERE submission_id = '122'
(mysqli): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 122
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysqli): SELECT * FROM submission_galley_settings WHERE galley_id = '25'
(mysqli):
SELECT iss.subscription_id
FROM institutional_subscriptions iss
JOIN subscriptions s ON (iss.subscription_id = s.subscription_id)
JOIN subscription_types st ON (s.type_id = st.type_id)
WHERE POSITION(UPPER(LPAD(iss.domain, LENGTH(iss.domain)+1, '.')) IN UPPER(LPAD('ec2-18-189-141-81.us-east-2.compute.amazonaws.com', LENGTH('ec2-18-189-141-81.us-east-2.compute.amazonaws.com')+1, '.'))) != 0
AND iss.domain != ''
AND s.journal_id = 1
AND s.status = 1
AND st.institutional = 1
AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2024-10-22 12:40:24' >= s.date_start AND '2024-10-22 12:40:24' <= s.date_end)))
AND (st.format = 1
OR st.format = 17)
(mysqli): SELECT isip.subscription_id
FROM institutional_subscription_ip isip
JOIN subscriptions s ON (isip.subscription_id = s.subscription_id)
JOIN subscription_types st ON (s.type_id = st.type_id)
WHERE ((isip.ip_end IS NOT NULL
AND '314412369' >= isip.ip_start AND '314412369' <= isip.ip_end
AND s.journal_id = 1
AND s.status = 1
AND st.institutional = 1
AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2024-10-22 12:40:24' >= s.date_start AND '2024-10-22 12:40:24' <= s.date_end)))
AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND '314412369' = isip.ip_start
AND s.journal_id = 1
AND s.status = 1
AND st.institutional = 1
AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2024-10-22 12:40:24' >= s.date_start AND '2024-10-22 12:40:24' <= s.date_end)))
AND (st.format = 1
OR st.format = 17)))
(mysqli): SELECT i.* FROM issues i WHERE journal_id = 1 AND current = 1
(mysqli): SELECT * FROM issue_settings WHERE issue_id = '10'
Vol 2 No 1 (2021): AJHSE 2021 First Issue
| African Journal of Health, Safety and Environment
(mysqli): SELECT a.*, ug.show_title, s.locale
FROM authors a
JOIN user_groups ug ON (a.user_group_id=ug.user_group_id)
JOIN submissions s ON (s.submission_id = a.submission_id)
WHERE a.submission_id = 119 AND a.include_in_browse = 1 ORDER BY seq
(mysqli): SELECT * FROM author_settings WHERE author_id = '192'
(mysqli): SELECT * FROM author_settings WHERE author_id = '193'
N. E. Uwaibi, E. S. Omozuwa
(mysqli): SELECT a.*, ug.show_title, s.locale
FROM authors a
JOIN user_groups ug ON (a.user_group_id=ug.user_group_id)
JOIN submissions s ON (s.submission_id = a.submission_id)
WHERE a.submission_id = 120 AND a.include_in_browse = 1 ORDER BY seq
(mysqli): SELECT * FROM author_settings WHERE author_id = '194'
(mysqli): SELECT * FROM author_settings WHERE author_id = '195'
S. K. Alonge, A. Wadinga
(mysqli): SELECT a.*, ug.show_title, s.locale
FROM authors a
JOIN user_groups ug ON (a.user_group_id=ug.user_group_id)
JOIN submissions s ON (s.submission_id = a.submission_id)
WHERE a.submission_id = 122 AND a.include_in_browse = 1 ORDER BY seq
(mysqli): SELECT * FROM author_settings WHERE author_id = '196'
(mysqli): SELECT * FROM author_settings WHERE author_id = '197'
(mysqli): SELECT * FROM author_settings WHERE author_id = '198'
(mysqli): SELECT * FROM author_settings WHERE author_id = '199'
(mysqli): SELECT * FROM author_settings WHERE author_id = '200'
(mysqli): SELECT * FROM author_settings WHERE author_id = '201'
(mysqli): SELECT * FROM author_settings WHERE author_id = '202'
(mysqli): SELECT * FROM author_settings WHERE author_id = '203'
B. Ikhajiagbe, V. D. Odenore, E. O. Umeokeke, E. S. Ahanor, O. Amadin, I. D. Omoigui, J. P. Loveniers, G. O. Anoliefo