(mysql): SELECT * FROM sessions WHERE session_id = '67kundous71arenl0utec1ntq2'
(mysql): SELECT * FROM journals WHERE path = 'DGSJ'
(mysql): SELECT * FROM journal_settings WHERE journal_id = '10'
(mysql): SELECT * FROM site
(mysql): SET time_zone = '+7:00'
(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 (context_id = '10' OR v.sitewide = 1)
WHERE v.current = 1 AND (ps.setting_value = '1' OR v.lazy_load <> 1)
(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.importexport.datacite.DataciteInfoSender'
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.doaj.DOAJInfoSender'
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.medra.MedraInfoSender'
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.crossref.CrossrefInfoSender'
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'lib.pkp.classes.task.ReviewReminder'
(mysql): 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 = '4600' ORDER BY ps.issue_id, s.submission_id
(mysql): 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 = '4600' ORDER BY ps.issue_id, s.submission_id
(mysql): 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 = 4600
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4600'
(mysql): 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 = 4600
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1244'
(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 = '91' ORDER BY i.issue_id
(mysql): SELECT i.* FROM issues i WHERE issue_id = 91
(mysql): SELECT * FROM issue_settings WHERE issue_id = '91'
(mysql): 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.galley_id = 0
AND nsf.file_id IS NULL AND g.submission_id = 4600
(mysql): SELECT * FROM journals WHERE path = 'DGSJ'
(mysql): SELECT * FROM journal_settings WHERE journal_id = '10'
(mysql): SELECT * FROM navigation_menus WHERE context_id = 10
(mysql): SELECT nmi.*
FROM navigation_menu_item_assignments as nmh
LEFT JOIN navigation_menu_items as nmi ON (nmh.navigation_menu_item_id = nmi.navigation_menu_item_id)
WHERE nmh.navigation_menu_id = 21
ORDER BY nmh.seq
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '250'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '253'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '251'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '254'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '252'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '255'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '256'
(mysql): SELECT nmi.*,nmh.navigation_menu_id,nmh.parent_id,nmh.seq, nmh.navigation_menu_item_assignment_id
FROM navigation_menu_item_assignments as nmh
LEFT JOIN navigation_menu_items as nmi ON (nmh.navigation_menu_item_id = nmi.navigation_menu_item_id)
WHERE nmh.navigation_menu_id = 21
ORDER BY nmh.seq
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2106'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2109'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2107'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2110'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2108'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2111'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2112'
(mysql): SELECT nmi.*
FROM navigation_menu_item_assignments as nmh
LEFT JOIN navigation_menu_items as nmi ON (nmh.navigation_menu_item_id = nmi.navigation_menu_item_id)
WHERE nmh.navigation_menu_id = 22
ORDER BY nmh.seq
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '311'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '317'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '314'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '315'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '316'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '318'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '313'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '257'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '258'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '262'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '259'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '319'
(mysql): SELECT nmi.*,nmh.navigation_menu_id,nmh.parent_id,nmh.seq, nmh.navigation_menu_item_assignment_id
FROM navigation_menu_item_assignments as nmh
LEFT JOIN navigation_menu_items as nmi ON (nmh.navigation_menu_item_id = nmi.navigation_menu_item_id)
WHERE nmh.navigation_menu_id = 22
ORDER BY nmh.seq
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2512'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2513'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2514'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2515'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2516'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2517'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2518'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2519'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2520'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2521'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2522'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2523'
(mysql): SELECT c.* FROM journals c
WHERE c.enabled = 1 ORDER BY seq
(mysql): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'webfeedblockplugin' AND context_id = 10
(mysql): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'webfeedblockplugin' AND context_id = 10
(mysql):
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('216.73.216.103', LENGTH('216.73.216.103')+1, '.'))) != 0
AND iss.domain != ''
AND s.journal_id = 10
AND s.status = 1
AND st.institutional = 1
AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2026-01-29 02:10:03' >= s.date_start AND '2026-01-29 02:10:03' <= s.date_end)))
AND (st.format = 1
OR st.format = 17)
(mysql): 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 '3628718183' >= isip.ip_start AND '3628718183' <= isip.ip_end
AND s.journal_id = 10
AND s.status = 1
AND st.institutional = 1
AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2026-01-29 02:10:03' >= s.date_start AND '2026-01-29 02:10:03' <= s.date_end)))
AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND '3628718183' = isip.ip_start
AND s.journal_id = 10
AND s.status = 1
AND st.institutional = 1
AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2026-01-29 02:10:03' >= s.date_start AND '2026-01-29 02:10:03' <= s.date_end)))
AND (st.format = 1
OR st.format = 17)))
(mysql): SELECT * FROM genres
WHERE enabled = 1 AND context_id = 10 AND dependent = 0 AND supplementary = 0
ORDER BY seq
(mysql): SELECT * FROM genre_settings WHERE genre_id = '109'
(mysql): SELECT * FROM genres
WHERE enabled = 1 AND context_id = 10 AND supplementary = 1
ORDER BY seq
(mysql): SELECT * FROM genre_settings WHERE genre_id = '110'
(mysql): SELECT * FROM genre_settings WHERE genre_id = '111'
(mysql): SELECT * FROM genre_settings WHERE genre_id = '112'
(mysql): SELECT * FROM genre_settings WHERE genre_id = '113'
(mysql): SELECT * FROM genre_settings WHERE genre_id = '114'
(mysql): SELECT * FROM genre_settings WHERE genre_id = '115'
(mysql): SELECT * FROM genre_settings WHERE genre_id = '116'
(mysql): SELECT * FROM genre_settings WHERE genre_id = '117'
(mysql): SELECT * FROM genre_settings WHERE genre_id = '120'
(mysql): SELECT DISTINCT
sf.file_id AS submission_file_id, sf.revision AS submission_revision,
af.file_id AS artwork_file_id, af.revision AS artwork_revision,
suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision,
s.locale AS submission_locale,
sf.*, af.*, suf.*
FROM submission_files sf
LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision
LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision
LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision
WHERE sf2.revision IS NULL AND sf.file_id = 9023 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9023'
(mysql): SELECT * FROM sections WHERE section_id = 12
(mysql): SELECT * FROM section_settings WHERE section_id = '12'
(mysql): INSERT INTO controlled_vocabs
(symbolic, assoc_type, assoc_id)
VALUES
('submissionKeyword', 1048585, 4600)
1062: Duplicate entry 'submissionKeyword-1048585-4600' for key 'controlled_vocab_symbolic'
ADOConnection._Execute(INSERT INTO controlled_vocabs (symbolic, assoc_type, assoc_id) VALUES ('submissionKeyword', 1048585, 4600)) % line 1032, file: adodb.inc.php
ADOConnection.Execute(INSERT INTO controlled_vocabs (symbolic, assoc_type, assoc_id) VALUES (?, ?, ?), Array[3]) % line 228, file: DAO.inc.php
DAO.update(INSERT INTO controlled_vocabs (symbolic, assoc_type, assoc_id) VALUES (?, ?, ?), Array[3], true, false) % line 110, file: ControlledVocabDAO.inc.php
ControlledVocabDAO.insertObject(Object:ControlledVocab, false) % line 60, file: ControlledVocabDAO.inc.php
ControlledVocabDAO._build(submissionKeyword, 1048585, 4600) % line 30, file: SubmissionKeywordDAO.inc.php
(mysql): SELECT * FROM controlled_vocabs WHERE symbolic = 'submissionKeyword' AND assoc_type = 1048585 AND assoc_id = 4600
(mysql): SELECT cve.* FROM controlled_vocab_entries cve WHERE cve.controlled_vocab_id = 19081 ORDER BY seq
(mysql): SELECT * FROM controlled_vocab_entry_settings WHERE controlled_vocab_entry_id = '13975'
(mysql): 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 = '4600' ORDER BY ps.issue_id, s.submission_id
(mysql): 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 = '4600' ORDER BY ps.issue_id, s.submission_id
(mysql): 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 = 4600
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4600'
(mysql): 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 = 4600
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1244'
(mysql):
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('216.73.216.103', LENGTH('216.73.216.103')+1, '.'))) != 0
AND iss.domain != ''
AND s.journal_id = 10
AND s.status = 1
AND st.institutional = 1
AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2026-01-29 02:10:03' >= s.date_start AND '2026-01-29 02:10:03' <= s.date_end)))
AND (st.format = 1
OR st.format = 17)
(mysql): 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 '3628718183' >= isip.ip_start AND '3628718183' <= isip.ip_end
AND s.journal_id = 10
AND s.status = 1
AND st.institutional = 1
AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2026-01-29 02:10:03' >= s.date_start AND '2026-01-29 02:10:03' <= s.date_end)))
AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND '3628718183' = isip.ip_start
AND s.journal_id = 10
AND s.status = 1
AND st.institutional = 1
AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2026-01-29 02:10:03' >= s.date_start AND '2026-01-29 02:10:03' <= s.date_end)))
AND (st.format = 1
OR st.format = 17)))
(mysql): SELECT a.*, ug.show_title
FROM authors a
JOIN user_groups ug ON (a.user_group_id=ug.user_group_id)
WHERE a.submission_id = 4600 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '6853'
(mysql): SELECT a.*, ug.show_title
FROM authors a
JOIN user_groups ug ON (a.user_group_id=ug.user_group_id)
WHERE a.submission_id = 4600 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '6853'
(mysql): INSERT INTO controlled_vocabs
(symbolic, assoc_type, assoc_id)
VALUES
('submissionKeyword', 1048585, 4600)
1062: Duplicate entry 'submissionKeyword-1048585-4600' for key 'controlled_vocab_symbolic'
ADOConnection._Execute(INSERT INTO controlled_vocabs (symbolic, assoc_type, assoc_id) VALUES ('submissionKeyword', 1048585, 4600)) % line 1032, file: adodb.inc.php
ADOConnection.Execute(INSERT INTO controlled_vocabs (symbolic, assoc_type, assoc_id) VALUES (?, ?, ?), Array[3]) % line 228, file: DAO.inc.php
DAO.update(INSERT INTO controlled_vocabs (symbolic, assoc_type, assoc_id) VALUES (?, ?, ?), Array[3], true, false) % line 110, file: ControlledVocabDAO.inc.php
ControlledVocabDAO.insertObject(Object:ControlledVocab, false) % line 60, file: ControlledVocabDAO.inc.php
ControlledVocabDAO._build(submissionKeyword, 1048585, 4600) % line 30, file: SubmissionKeywordDAO.inc.php
(mysql): SELECT * FROM controlled_vocabs WHERE symbolic = 'submissionKeyword' AND assoc_type = 1048585 AND assoc_id = 4600
(mysql): SELECT cve.* FROM controlled_vocab_entries cve WHERE cve.controlled_vocab_id = 19081 ORDER BY seq
(mysql): SELECT * FROM controlled_vocab_entry_settings WHERE controlled_vocab_entry_id = '13975'
(mysql): SELECT a.*, ug.show_title
FROM authors a
JOIN user_groups ug ON (a.user_group_id=ug.user_group_id)
WHERE a.submission_id = 4600 AND a.include_in_browse = 1 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '6853'
(mysql): INSERT INTO controlled_vocabs
(symbolic, assoc_type, assoc_id)
VALUES
('submissionKeyword', 1048585, 4600)
1062: Duplicate entry 'submissionKeyword-1048585-4600' for key 'controlled_vocab_symbolic'
ADOConnection._Execute(INSERT INTO controlled_vocabs (symbolic, assoc_type, assoc_id) VALUES ('submissionKeyword', 1048585, 4600)) % line 1032, file: adodb.inc.php
ADOConnection.Execute(INSERT INTO controlled_vocabs (symbolic, assoc_type, assoc_id) VALUES (?, ?, ?), Array[3]) % line 228, file: DAO.inc.php
DAO.update(INSERT INTO controlled_vocabs (symbolic, assoc_type, assoc_id) VALUES (?, ?, ?), Array[3], true, false) % line 110, file: ControlledVocabDAO.inc.php
ControlledVocabDAO.insertObject(Object:ControlledVocab, false) % line 60, file: ControlledVocabDAO.inc.php
ControlledVocabDAO._build(submissionKeyword, 1048585, 4600) % line 30, file: SubmissionKeywordDAO.inc.php
(mysql): SELECT * FROM controlled_vocabs WHERE symbolic = 'submissionKeyword' AND assoc_type = 1048585 AND assoc_id = 4600
(mysql): SELECT cve.* FROM controlled_vocab_entries cve WHERE cve.controlled_vocab_id = 19081 ORDER BY seq
(mysql): SELECT * FROM controlled_vocab_entry_settings WHERE controlled_vocab_entry_id = '13975'
(mysql): SELECT * FROM sections WHERE section_id = 12
(mysql): SELECT * FROM section_settings WHERE section_id = '12'
(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 (context_id = '10' OR v.sitewide = 1)
WHERE v.current = 1 AND (ps.setting_value = '1' OR v.lazy_load <> 1)
(mysql): SELECT i.* FROM issues i WHERE journal_id = 10 AND current = 1
(mysql): SELECT * FROM issue_settings WHERE issue_id = '91'
DINAMIKA GEOPOLITIK DAN IMPLIKASINYA: ANALISIS RIVALITAS AS-RRT DI LAUT CHINA SELATAN TERHADAP KEPENTINGAN INDONESIA
DINAMIKA GEOPOLITIK DAN IMPLIKASINYA: ANALISIS RIVALITAS AS-RRT DI LAUT CHINA SELATAN TERHADAP KEPENTINGAN INDONESIA
(mysql): SELECT a.*, ug.show_title
FROM authors a
JOIN user_groups ug ON (a.user_group_id=ug.user_group_id)
WHERE a.submission_id = 4600 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '6853'
(mysql): SELECT a.*, ug.show_title
FROM authors a
JOIN user_groups ug ON (a.user_group_id=ug.user_group_id)
WHERE a.submission_id = 4600 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '6853'
Putra Iman Didada
Universitas Jenderal Achmad Yani
Keywords:
Geopolitics, US-PRC Rivalry, South China Sea, Indonesia's Sovereignty, Maritime Security, Diplomatic Strategy, Exclusive Economic Zone (EEZ) of Natuna, Militarization of the South China Sea, Maritime Diplomacy.
Abstract
This study aims to analyze the geopolitical dynamics and rivalry between the United States (US) and the People's Republic of China (PRC) in the South China Sea and its implications for Indonesia's strategic interests. The South China Sea is a highly strategic area rich in natural resources, making it a focal point of power struggle between these two major powers. Although Indonesia is not directly involved in the territorial disputes in the South China Sea, the rivalry between the US and the PRC impacts Indonesia, particularly in terms of territorial sovereignty, maritime economy, and regional stability. This research uses a qualitative approach with a descriptive-analytical method, analyzing official documents, scholarly publications, and relevant reports. The primary focus of this study is to identify the military, economic, and diplomatic strategies employed by the US and the PRC in the region and their effects on Indonesia. This study also examines Indonesia's foreign policy response in maintaining neutrality and addressing the challenges posed by the rivalry between the two great powers. The findings of this research are expected to provide a deeper understanding of Indonesia's role in maintaining regional stability and strengthening its adaptive foreign policy in response to the evolving global geopolitical landscape.
(mysql): SELECT COUNT(*) FROM plugin_settings WHERE plugin_name = 'usagestatsplugin' AND context_id = 10 AND setting_name = 'displayStatistics'
(mysql): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'usagestatsplugin' AND context_id = 10
(mysql): SELECT a.*, ug.show_title
FROM authors a
JOIN user_groups ug ON (a.user_group_id=ug.user_group_id)
WHERE a.submission_id = 4600 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '6853'
References
Buku
Bungin, B. 2017. Metodologi Penelitian Kualitatif. Jakarta: Kencana
Creswell, J. W. 2018. Qualitative Methode Approaches.
Friedberg, A. L. 2022. Getting China Wrong. Polity Press.
Friedberg, A. L,. 2011. A Contest for Supremacy: China, America, and the Struggle for Mastery in Asia. W. W. Norton & Company.
Hadiwinata, B. S. (2018). Politik Luar Negeri Indonesia di Tengah Dinamika Global. Jakarta: Pustaka Pelajar.
Hadiwinata, B.S. 2018. Geopolitik Kawasan Asia Tenggara: Tantangan dan Peluang bagi Indonesia. Jakarta: Penerbit Nasional.
Hayton, B. 2018. The South China Sea: The Struggle for Power in Asia. Yale University Press.
Jackson, R., & Sørensen, G. 2016. Introduction to International Relations: Theories and Approaches (6th ed.). Oxford: Oxford University Press.
Kaplan, R. D. (2014). Asia's Cauldron: The South China Sea and the End of a Stable Pacific. Random House.
Mahan, A. T. 1890. The Influence of Sea Power upon History, 1660–1783. Boston: Little, Brown and Company.
Margesson, Rhoda. 2010. United Nations Assistance Mission in Afghanistan : Background and Policy Issue. Washington DC: CSR Report for Congress.
Mearsheimer, J. J. 2011. Tragedy of Great Power Politics. New York: W.W Norton & Company.
Mearsheimer, J.J. 2001. The Tragedy of Great Power Politics. New York: W. W. Norton & Company.
Miles, M. B., & Huberman, A. M. 1984. Qualitative Data Analysis: A Sourcebook of New Methods. Beverly Hills: Sage Publication.
Miles, M. B., & Huberman, A. M. 1984. Qualitative Data Analysis: A Sourcebook of New Methods. Beverly Hills: Sage Publication.
Moleong, L. J. 2017. Metodologi Penelitian Kualitatif. Bandung: Remaja Rosdakarya.
Neuman, W. L. 2014. Social Research Methods: Qualitative and Quantitative Approaches. Boston: Pearson.
Surwati, Basorwi dan. 2008. Memahami Penelitian Kualitatif. Jakarta: PT Rineka Cipta.
Tanner, Stephen. 2002. Afghanistan : A Military History From Alexander the Great ti the fall of the Taliban . Cambridge: Da Capo Press.
Waltz, K. N. (1979). Teory of International Politics. Reading. MA: Addison-Wesley.
Internet
Abou-Zahr, Sawssan. 2019. Peace Dispatch: March 2019. Maret 23. Accessed Januari 27, 2024. https://www.peaceinsight.org/en/articles/peace-dispatch-march-2019/?location=nigeria&theme=conflict-prevention-early-warning.
Adam, Chaesar. 2018. Respon Kebijakan Luar Negeri Australia terhadap Belt and Road Initiative (BRI) Tiongkok: Dilema Pemenuhan Kepentingan Ekonomi dan Keamanan Nasional. Yogyakarta: UGM.
Anwar, D. F. 2020. “Indonesia’s South China Sea Dilemma: Between Sovereignty and Economic Relations.”. ISEAS Perspective, No. 15.
Aoyama, Rumi. 2017. "One Belt, One Road: Tiongkok's New Global Strategy." Journal of Contemporary East Asia Studies Vol 5:2.
Arbitration, Permanent Court of. n.d. "(2016). Award: Philippines v. China (PCA Case No. 2013-19). Menggarisbawahi bahwa klaim "Historic rights" Tiongkok dalam nine dash line tidak memiliki dasar hukum berdasarkan UNCLOS."
Asean.org. 2021. ASEAN-Outlook-on-the-Indo-Pacific_FINAL. https://asean.org/wp-content/uploads/2021/01/ASEAN-Outlook-on-the-Indo-Pacific_FINAL_22062019.pdf?utm.
Aspistrategist.org. 2020. mapping-the-nine-dash-line-recent-incidents-involving-indonesia-in-the-south-china-sea. https://www.aspistrategist.org.au/mapping-the-nine-dash-line-recent-incidents-involving-indonesia-in-the-south-china-sea/?utm.
Ayoma, Rumi. 2017. "Onee Belt, One Road: Tiongkok’s New Global Strategy." Journal of Contemporary East Asia Studies, Vol 5:2.
BBC.com. 2020. Indonesia. https://www.bbc.com/indonesia/indonesia-50999466?utm.
Center for Strategic and International Studies (CSIS). 2020. "How Much Trade Transits the South China Sea?"
Chun, Chieng-Peng. 2022. Tiongkoks’s Multilateral Cooperation In Asia and the Pacific: institutionalizing ‘Good Neighbor Policy , (New York: Rutledge, 2010). Accessed 2025. di https://www.routledge.com/Tiongkoks-Multilateral-Co-operation-in-Asia-and-the-Pacific- Instititute.
Dupree, Louis, Nancy Hatch Dupree, and Victor Petrov. 2024. Afghanistan; Etnolinguistic Composition. Januari 12. Accessed Januari 27, 2024. https://www.britannica.com/place/Afghanistan.
Goh, E. 2019. "“ASEAN’s Role in the South China Sea Dispute.”." Asian Survey, Vol. 59, No. 3.
Green, M. J., et al. 2017. " Countering Coercion in Maritime Asia: The Theory and Practice of Gray Zone Deterrence." Center for Strategic and International Studies (CSIS).
Hartono, Willy. 2021. Perjanjian AS-Taliban Buka Jalan Perdamaian di Afghanistan. Maret 1. Accessed Januari 29, 2024. https://www.medcom.id/internasional/timur-tengah-afrika/yNLGE06K-perjanjian-as-taliban-buka-jalan-perdamaian-di-afghanistan.
Hayton, B. 2018. The South China Sea: The Struggle for Power in Asia. Yale University Press.
International Crisis Group. 2020. Afghanistan Peace Talk Since 2018: A Timeline. Agustus 11. Accessed Januari 30, 2024. https://www.crisisgroup.org/asia/south-asia/afghanistan/afghanistan-between-february-2019-and-august-2020-timeline.
Jurnal Politik. April 2023. "Keamanan dan Hubungan Internasional." Nomor eISSN : 2829-1794 Volume 2 No. 1 29-38.
Peaceful-competion.org. 2020. Peace. https://www.peaceful-competition.org/pub/brdt54wm/release/1?utm.
Permanent Court of Arbitration. (2016). "The South China Sea Arbitration Award."
Saaty, T. L. 2014. Analytic Hierarchy Process. ttps://doi.org/10.1002/9781118445112.stat05310.
Secretariat Cairo. 1995. "United Nation Congress On The Prevention Of Crime And The Treatment Of Offenders."
Shafitri, Desy Nur. 2024. "Respon ASEAN atas Keterlibatan Amerika Serikat di Laut." Jurnal Ilmu Politik Vol.15, No. 1.
Sinaga, Yuni Arisandy. 2019. Indonesia Siap Berkontribusi Proses Perdamaian di Afghanistan. Maret 15. Accessed Januari 30, 2024. https://www.antaranews.com/berita/810347/indonesia-siap-berkontribusi-proses-perdamaian-diafghanistan#.
Time.com. 2021. indonesia-china-jokowi-natuna-sovereignty-maritime-fishing-dispute. https://time.com/4379401/indonesia-china-jokowi-natuna-sovereignty-maritime-fishing-dispute/?utm.
Varano, John. 2020. The State of Victoria and China’s Belt and Road Initiative: Where Does it Leave Victorians? Accessed 2024. https://www.researchgate.net/publication/341359556_The_State_of_Victoria_and_China's_ Belt_and_Road.
Widyaningrum, Gita Laras. 2018. Kronologis Serangan 9/11, Runtuhnya Menara Kembar dan Osama Bin Laden. September 18. Accessed Januari 28, 2024. https://nationalgeographic.grid.id/read/13935227/kronologis-serangan-911-runtuhnya-menara-kembar-dan-osama-bin-laden.
Didada, P. I. (2025). DINAMIKA GEOPOLITIK DAN IMPLIKASINYA: ANALISIS RIVALITAS AS-RRT DI LAUT CHINA SELATAN TERHADAP KEPENTINGAN INDONESIA, 2(1), 842-857. https://doi.org/https://doi.org/10.36859/dgsj.v2i2.4600
(mysql): SELECT a.*, ug.show_title
FROM authors a
JOIN user_groups ug ON (a.user_group_id=ug.user_group_id)
WHERE a.submission_id = 4600 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '6853'
(mysql): SELECT DISTINCT
aa.submission_id
FROM authors aa
LEFT JOIN submissions a ON (aa.submission_id = a.submission_id)
LEFT JOIN author_settings asl ON (asl.author_id = aa.author_id AND asl.setting_name = 'affiliation')
WHERE aa.first_name = 'Putra Iman'
AND a.status = 3
AND (aa.middle_name = '' OR aa.middle_name IS NULL)
AND aa.last_name = 'Didada'
AND (asl.setting_value = 'Universitas Jenderal Achmad Yani')
AND (aa.country = 'ID')
(mysql): 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 = 4600
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4600'
(mysql): 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 = 4600
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1244'
(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 (context_id = 0 OR v.sitewide = 1)
WHERE v.current = 1 AND (ps.setting_value = '1' OR v.lazy_load <> 1)
(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 (context_id = 0 OR v.sitewide = 1)
WHERE v.current = 1 AND (ps.setting_value = '1' OR v.lazy_load <> 1)
(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 (context_id = 0 OR v.sitewide = 1)
WHERE v.current = 1 AND (ps.setting_value = '1' OR v.lazy_load <> 1)
(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 (context_id = 0 OR v.sitewide = 1)
WHERE v.current = 1 AND (ps.setting_value = '1' OR v.lazy_load <> 1)
(mysql): UPDATE sessions
SET
user_id = NULL,
ip_address = '216.73.216.103',
user_agent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)',
created = 1769627381,
last_used = 1769627403,
remember = 0,
data = 'csrf|a:2:{s:9:\"timestamp\";i:1769627403;s:5:\"token\";s:32:\"0a86c31921291b28c59798376dad90f6\";}',
domain = 'ejournal.fisip.unjani.ac.id'
WHERE session_id = '67kundous71arenl0utec1ntq2'