(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 = '4578' 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 = '4578' 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 = 4578
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4578'
(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 = 4578
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1254'
(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 = 4578
(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:09:54' >= s.date_start AND '2026-01-29 02:09:54' <= 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:09:54' >= s.date_start AND '2026-01-29 02:09:54' <= 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:09:54' >= s.date_start AND '2026-01-29 02:09:54' <= 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 = 9044 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 = '9044'
(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, 4578)
1062: Duplicate entry 'submissionKeyword-1048585-4578' for key 'controlled_vocab_symbolic'
ADOConnection._Execute(INSERT INTO controlled_vocabs (symbolic, assoc_type, assoc_id) VALUES ('submissionKeyword', 1048585, 4578)) % 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, 4578) % line 30, file: SubmissionKeywordDAO.inc.php
(mysql): SELECT * FROM controlled_vocabs WHERE symbolic = 'submissionKeyword' AND assoc_type = 1048585 AND assoc_id = 4578
(mysql): SELECT cve.* FROM controlled_vocab_entries cve WHERE cve.controlled_vocab_id = 18971 ORDER BY seq
(mysql): SELECT * FROM controlled_vocab_entry_settings WHERE controlled_vocab_entry_id = '13953'
(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 = '4578' 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 = '4578' 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 = 4578
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4578'
(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 = 4578
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1254'
(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:09:54' >= s.date_start AND '2026-01-29 02:09:54' <= 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:09:54' >= s.date_start AND '2026-01-29 02:09:54' <= 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:09:54' >= s.date_start AND '2026-01-29 02:09:54' <= 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 = 4578 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '6831'
(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 = 4578 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '6831'
(mysql): INSERT INTO controlled_vocabs
(symbolic, assoc_type, assoc_id)
VALUES
('submissionKeyword', 1048585, 4578)
1062: Duplicate entry 'submissionKeyword-1048585-4578' for key 'controlled_vocab_symbolic'
ADOConnection._Execute(INSERT INTO controlled_vocabs (symbolic, assoc_type, assoc_id) VALUES ('submissionKeyword', 1048585, 4578)) % 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, 4578) % line 30, file: SubmissionKeywordDAO.inc.php
(mysql): SELECT * FROM controlled_vocabs WHERE symbolic = 'submissionKeyword' AND assoc_type = 1048585 AND assoc_id = 4578
(mysql): SELECT cve.* FROM controlled_vocab_entries cve WHERE cve.controlled_vocab_id = 18971 ORDER BY seq
(mysql): SELECT * FROM controlled_vocab_entry_settings WHERE controlled_vocab_entry_id = '13953'
(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 = 4578 AND a.include_in_browse = 1 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '6831'
(mysql): INSERT INTO controlled_vocabs
(symbolic, assoc_type, assoc_id)
VALUES
('submissionKeyword', 1048585, 4578)
1062: Duplicate entry 'submissionKeyword-1048585-4578' for key 'controlled_vocab_symbolic'
ADOConnection._Execute(INSERT INTO controlled_vocabs (symbolic, assoc_type, assoc_id) VALUES ('submissionKeyword', 1048585, 4578)) % 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, 4578) % line 30, file: SubmissionKeywordDAO.inc.php
(mysql): SELECT * FROM controlled_vocabs WHERE symbolic = 'submissionKeyword' AND assoc_type = 1048585 AND assoc_id = 4578
(mysql): SELECT cve.* FROM controlled_vocab_entries cve WHERE cve.controlled_vocab_id = 18971 ORDER BY seq
(mysql): SELECT * FROM controlled_vocab_entry_settings WHERE controlled_vocab_entry_id = '13953'
(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'
TNI DAN PENANGANAN KEJAHATAN TRANSNASIONAL: STUDI KASUS DI PERBATASAN INDONESIA-TIMOR LESTE
TNI DAN PENANGANAN KEJAHATAN TRANSNASIONAL: STUDI KASUS DI PERBATASAN INDONESIA-TIMOR LESTE
(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 = 4578 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '6831'
(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 = 4578 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '6831'
Keywords:
Indonesian National Army (TNI), Transnasional, Indonesia, Timor Leste
Abstract
This article discusses the role of the Indonesian National Army (TNI) in dealing with transnational crime in the Indonesia-Timor Leste border area. Using qualitative research methods, the author emphasizes analysis of the dynamics of interphenomena relationships, not testing statistical hypotheses. This approach allows for an in-depth understanding of the social complexities of social policies, policies, and practices in the field interpretively and contextually. The theoretical framework of the research includes a realism approach, the concept of transnational crime, bilateral cooperation, and national security to analyze security challenges at the border. Realism helps explain how the country—in this case Indonesia—prioritizes national security in the face of cross-border threats. Meanwhile, the concept of bilateral cooperation highlights the efforts of the TNI and the Timorese authorities in strengthening regional security. Through this study, the author hopes to make an academic contribution to the study of international relations, especially in understanding the role of military actors in tackling transnational crime. The findings of the study are expected to be input for policymakers in formulating more effective and sustainable border security strategies.
(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 = 4578 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '6831'
References
Buku:
Anak Agung Banyu Perwita dan Yanyan Mochmad Yani. Pengantar Ilmu Hubungan Internasional. ( Bandung : Rosda Karya, 2006 ).
Barry Buzan, 1983. People, State, and Fear : The National Security Problem in International Relations, Sussex: Wheat Sheat Books ltd.
Barry Buzan, People, State and Fear, 2nd Edition, Harvester Wheatsaf, London, 1991.
Dinas Sejarah TNI Angkatan Darat, PERANAN TNI AD DALAM PENGAMANAN PERBATASAN NKRI. (Bandung: Penerbit DISJARAHAD, 2012).
Jill Steans dan Llyold Pettiford. Hubungan Internasional Prespektif dan Tema ( Yogyakarta : Pustaka Pelajar, 2009 ).
Mohtar Mas`oed. Pengantar Ilmu Hubungan Internasional, Disiplin dan Metodologi ( Jakarta : LP3ES, 1991 ) .
Paul Viotti dan Mark V. Kauppi. 1999. International relations theory: realism, Pluralism, Globalism, and Beyong. Third Edition New York: MacMillan Publishing Company.
Pedoman Penulisan Tesis Fakultas Ilmu Sosial dan Ilmu Politik Unjani, Cimahi, 2006.
Raymond F Hopkins dan Richard W. Mansbach. 1979. Structure and Process in International Politics. New York: Harper and Row Publishers.
Saifudin Azwar, Metode Penelitian, Pustaka Pelajar, Yogyakarta, 2001.
Sugiyono, Metode Penelitian Kuantitatif Kualitatif dan R&D, Alfabeta, Bandung, 2007.
Vickers, 2005, A History of Modern Indonesia.
Jurnal:
Aprilia D. Mauk, Rina Luan, Adean Bano , Frouke Suhardjana , Yohanes Arman, “Strategi Pemerintah Republik Indonesia Dalam Penanganan Masalah Pelintas Batas Indonesia-Timor Leste”, Madani: Jurnal Ilmiah Multidisiplin, Vol. 1 No.7, (Agustus 2023). https://doi.org/10.5281/zenodo.8174816.
Dewa Gede Sudika Mangku. "Implementasi Joint Border Committee (Jbc) Untuk Penyelesaian Sengketa Perbatasan Darat Antara Indonesia-timor Leste." Jurnal Yuridis, vol. 5, no. 1, 2018, pp. 43-66, doi:10.35586/.v5i1.316.
Helga Hafterdorn. 1991.” The Security Puzzle: Theory building and Discipline in International Security” dalam International Studies Quarterly. Vol. 35. No.1.
Heribertus Binsasi, “Budaya Atoni Pah Metodalam ResolusiKonflik Masyarakat Perbatasan Indonesia dan Timor Leste”, Mandar: Social Science Journal, Vol. 1 No. 1 (2022).
Raymond F Hopkins dan Richard W. Mansbach. 1979. Structure and Process in International Politics. New York: Harper and Row Publishers.
Tobu E, Arman Y, Mamengko K, “Analisis Masalah Pengelolaan Kawasan Perbatasan Antara Provinsi Nusa Tenggara Timur (NTT) Dan Negara Timor Leste”, Jurnal Ilmiah Dan Karya Mahasiswa, Vol. 1 No. 5 (Oktober 2023).
Vinsensius Tamelab, Mericiana Fin Tae, Yohanes Arman, Yustinus Pedo, “Urgensi Kerja Sama Tentara Nasional Indonesia Dan Forcas Defese Timor Lorosae Dalam Penanggulangan Perdagangan Ilegal Lintas Batas Antara Indonesia Dan Timor Leste” Populer: Jurnal Penelitian Mahasiswa, Vol. 2 No.3 (September 2023), https://doi.org/10.58192/populer.v2i3.1208.
Zulkarnain, Irma Indrayani, “KERJASAMA PENANGGULANGAN KEJAHATAN TRANSNASIONAL DI ASEAN”, Laporan Penelitian STIMULUS, 2019.
Artikel Berita:
“Profil Indonesia,” dalam http://www.indonesia.go.id/id/index.php?option=com_content&task=view&id=112&Itemid=1722, akses 25 Agustus 2010.
Agus Subagyo. 2007. Diktat Mata Kuliah Studi Pertahanan. Cimahi: UNJANI.
Alif Mufida Ulya. (2023, Juli 22). “Jadi Akar Maraknya TPPO, Mensos Intensif Tangani Kemiskinan Ekstrem Terutama Kawasan 3T” [Halaman Web]. Diakses dari https://kemensos.go.id/berita-terkini/direktorat-jenderal-pemberdayaan-sosial/jadi-akar-maraknya-tppo-mensos-intensif-tangani-kemiskinan-ekstrem-terutama-kawasan-3t
Bagus Ahmad Rizaldi. (2024, Oktober 1). Anggota MPR RI 2024-2029 resmi dilantik setelah pelantikan DPR dan DPD [Halaman Web]. Diakses dari https://www.antaranews.com/berita/4368279/anggota-mpr-ri-2024-2029-resmi-dilantik-setelah-pelantikan-dpr-dan-dpd
Bantarto Bandoro. 1993. ASEAN dan Tantangan Satu Asia Tenggara, (Jakarta: CSIS).
Bernadus Tokan. (2021, Oktober 4). Satgas Pamtas RI-RDTL: Penyelundupan masih marak di perbatasan [Halaman Web]. Diakses dari https://www.antaranews.com/berita/2434789/satgas-pamtas-ri-rdtl-penyelundupan-masih-marak-di-perbatasan
Bey Sofyan. “Tinjauan ke Depan Hubungan Bilateral RI-TL”, makalah yang disampaikan pada diskusi terbatas Departemen Luar Negeri, Mei 2008.
BNPP. (2024, April 28). Masuk Secara Ilegal, 4 Warga Negara Timor Leste Diamankan di PLBN Motamasin [Halaman Web]. Diakses dari https://bnpp.go.id/berita/masuk-secara-ilegal-4-warga-negara-timor-leste-diamankan-di-plbn-motamasin
Carlson dalam Sri Hayati dan Ahmad Yani, Geografi Politik. ( Bandung : Refika Aditama, 2007 ).
Daniel j. Kaufmann. Et.al. (eds). 1986. US National Security, a Framework for Analysis, Lexington: Lexington Press.
Fahri Zulfikar. (2024, Maret 27). “Kapan Timor Leste Berpisah dari Indonesia? Ini Sejarahnya” [Halaman Web]. Diakses dari https://www.detik.com/edu/detikpedia/d-7264955/kapan-timor-leste-berpisah-dari-indonesia-ini-sejarahnya
Hamidin. (2025, Maret 15). “Memaknai Hubungan Bilateral Timor Leste dan Indonesia” [Halaman Web]. Diakses dari https://bnpp.go.id/berita/memaknai-hubungan-bilateral-timor-leste-dan-indonesia
http://id.wikipedia.org/w/index.php?title=Sejarah_Timor_Leste&action=edit§ion=1, akses 25 Nopember 2023.
Imam Hidayat dan Mardiyono. Geopolitik. ( Surabaya: Usaha Nasional, 1983 ).
Irene Amora. (2024, Agustus 30). Hari Timor Timur Nyatakan Pisah dari Indonesia, Begini Sejarahnya [Halaman Web]. Diakses dari https://www.rri.co.id/nasional/942618/hari-timor-timur-nyatakan-pisah-dari-indonesia-begini-sejarahnya#:~:text=Selanjutnya%20tanggal%2030%20Agustus%201999,negara%20sendiri%20bernama%20Timor%20Leste.
Lihat “Sejarah Timor Leste, “ dalam
Lihat dalam Bilveer Singh, 1998. “Integrasi Timor Timur ke dalam Indonesia: Dinamika Eksternal”, dalam Timor Timur, Indonesia dan Dunia: Mitos dan Kenyataan, terj., Jakarta, Institute of Policy Studies, hlm. 41-113.
Lihat misalnya dalam Bilveer Singh, 1998. “Dari Timor Portugis ke Timor Timur Indonesia”, dalam Timor Timur, Indonesia dan Dunia: Mitos dan Kenyataan, [terj.], Jakarta, Institute of Policy Studies, hlm. 1-40.; Downer, Alexander (Menteri Luar Negeri Australia). 2000. East Timor – looking back on 1999, Australian Journal of International Affairs, vol.54/1 , hal.5.
Maria Anitoda. (2021, Mei 27). “Begini Sistem Pemerintahan Timor Leste Ada Presiden dan Perdana Menteri, Kok Bisa? Ini Penjelasanya” [Halaman Web]. Diakses dari https://kupang.tribunnews.com/2021/05/27/begini-sistem-pemerintahan-timor-leste-ada-presiden-dan-perdana-menteri-kok-bisa-ini-penjelasanya
Marselinus Manek. (2025, Maret 6). “PLBN Motaain Jadi 'Jalur Tol' Penyelundupan Solar Subsidi. Sejumlah Kendaraan Ekspor Teridentifikasi” [Halaman Web], Diakses dari https://www.nusrainside.com/hukum-kriminal/85114701738/plbn-motaain-jadi-jalur-tol-penyelundupan-solar-subsidi-sejumlah-kendaraan-ekspor-teridentifikasi
Riyana Kristono. (2024, Agustus 30). “Timor Timur Lepas dari NKRI, 25 Tahun Silam” [Halaman Web]. Diakses dari https://rri.co.id/lain-lain/940653/timor-timur-lepas-dari-nkri-25-tahun-silam#:~:text=KBRN%2C%20Cirebon%3A%20Timor%2DLeste,1976%20hingga%2019%20Oktober%201999.
Ryan Nong. (2024, April 29). “Empat Warga Timor Leste Diamankan di PLBN Motamasin NTT” [Halaman Web]. Diakses dari https://kupang.tribunnews.com/2024/04/29/empat-warga-timor-leste-diamankan-di-plbn-motamasin-ntt
Timor-Leste Population and Housing Census 2022 Main Report. Diakses dari https://inetl-ip.gov.tl/wp-content/uploads/2023/05/Final-Main-Report_TLPHC-Census_18052023.pdf
Adiwisuda, B. (2025). TNI DAN PENANGANAN KEJAHATAN TRANSNASIONAL: STUDI KASUS DI PERBATASAN INDONESIA-TIMOR LESTE, 2(1), 1047-1064. https://doi.org/https://doi.org/10.36859/dgsj.v2i2.4578
(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 = 4578 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '6831'
(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 = 'Bayu'
AND a.status = 3
AND (aa.middle_name = '' OR aa.middle_name IS NULL)
AND aa.last_name = 'Adiwisuda'
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 = 4578
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4578'
(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 = 4578
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1254'
(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 = 1769627394,
remember = 0,
data = 'csrf|a:2:{s:9:\"timestamp\";i:1769627394;s:5:\"token\";s:32:\"0a86c31921291b28c59798376dad90f6\";}',
domain = 'ejournal.fisip.unjani.ac.id'
WHERE session_id = '67kundous71arenl0utec1ntq2'