(mysqli): SELECT * FROM sessions WHERE session_id = '31f6ff85c35421e7de742d3dc38536f5'
(mysqli): INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, domain)
VALUES
('31f6ff85c35421e7de742d3dc38536f5', '3.144.110.253', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 1729609187, 1729609187, 0, '', 'ajhse.org')
(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 = 'citationstylelanguage/get/acs-nano' and context_id = 1 and type= 'NMI_TYPE_CUSTOM'
(mysqli): SELECT ps.*,
s.*,
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')INNER JOIN submission_settings sst ON s.submission_id = sst.submission_id
WHERE sst.setting_name = 'pub-id::publisher-id' AND sst.setting_value = '466' ORDER BY ps.issue_id, s.submission_id
(mysqli): SELECT ps.*,
s.*,
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')
WHERE s.submission_id = 466
(mysqli): SELECT * FROM submission_settings WHERE submission_id = '466'
(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 = 466
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysqli): SELECT * FROM submission_galley_settings WHERE galley_id = '159'
(mysqli): SELECT i.* FROM issues i WHERE issue_id = 10 AND journal_id = 1
(mysqli): SELECT * FROM issue_settings WHERE issue_id = '10'
(mysqli): SELECT i.* FROM issues i WHERE issue_id = 10
(mysqli): SELECT * FROM issue_settings WHERE issue_id = '10'
(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 = 466 ORDER BY seq
(mysqli): SELECT * FROM author_settings WHERE author_id = '966'
(mysqli): SELECT * FROM author_settings WHERE author_id = '967'
(mysqli): SELECT * FROM author_settings WHERE author_id = '968'
(mysqli): SELECT * FROM author_settings WHERE author_id = '969'
(1)
UKPENE, A.; IGBORGBOR, J.; ODUMA, E.; KONYEME, T. ENVIRONMENTAL IMPACTS OF OIL SPILLS ON MARINE ECOSYSTEMS: A CASE STUDY OF THE NIGER-DELTA ENVIRONMENT. AJHSE2024, 5, 103-113.
(mysqli): UPDATE sessions
SET
user_id = NULL,
ip_address = '3.144.110.253',
user_agent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)',
created = 1729609187,
last_used = 1729609187,
remember = 0,
data = '',
domain = 'ajhse.org'
WHERE session_id = '31f6ff85c35421e7de742d3dc38536f5'