(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 = '4593' 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 = '4593' 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 = 4593
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4593'
(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 = 4593
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1204'
(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 = 4593
(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:02' >= s.date_start AND '2026-01-29 02:10:02' <= 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:02' >= s.date_start AND '2026-01-29 02:10:02' <= 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:02' >= s.date_start AND '2026-01-29 02:10:02' <= 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 = 8915 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 = '8915'
(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, 4593)
1062: Duplicate entry 'submissionKeyword-1048585-4593' for key 'controlled_vocab_symbolic'
ADOConnection._Execute(INSERT INTO controlled_vocabs (symbolic, assoc_type, assoc_id) VALUES ('submissionKeyword', 1048585, 4593)) % 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, 4593) % line 30, file: SubmissionKeywordDAO.inc.php
(mysql): SELECT * FROM controlled_vocabs WHERE symbolic = 'submissionKeyword' AND assoc_type = 1048585 AND assoc_id = 4593
(mysql): SELECT cve.* FROM controlled_vocab_entries cve WHERE cve.controlled_vocab_id = 19046 ORDER BY seq
(mysql): SELECT * FROM controlled_vocab_entry_settings WHERE controlled_vocab_entry_id = '13968'
(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 = '4593' 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 = '4593' 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 = 4593
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4593'
(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 = 4593
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1204'
(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:02' >= s.date_start AND '2026-01-29 02:10:02' <= 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:02' >= s.date_start AND '2026-01-29 02:10:02' <= 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:02' >= s.date_start AND '2026-01-29 02:10:02' <= 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 = 4593 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '6846'
(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 = 4593 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '6846'
(mysql): INSERT INTO controlled_vocabs
(symbolic, assoc_type, assoc_id)
VALUES
('submissionKeyword', 1048585, 4593)
1062: Duplicate entry 'submissionKeyword-1048585-4593' for key 'controlled_vocab_symbolic'
ADOConnection._Execute(INSERT INTO controlled_vocabs (symbolic, assoc_type, assoc_id) VALUES ('submissionKeyword', 1048585, 4593)) % 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, 4593) % line 30, file: SubmissionKeywordDAO.inc.php
(mysql): SELECT * FROM controlled_vocabs WHERE symbolic = 'submissionKeyword' AND assoc_type = 1048585 AND assoc_id = 4593
(mysql): SELECT cve.* FROM controlled_vocab_entries cve WHERE cve.controlled_vocab_id = 19046 ORDER BY seq
(mysql): SELECT * FROM controlled_vocab_entry_settings WHERE controlled_vocab_entry_id = '13968'
(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 = 4593 AND a.include_in_browse = 1 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '6846'
(mysql): INSERT INTO controlled_vocabs
(symbolic, assoc_type, assoc_id)
VALUES
('submissionKeyword', 1048585, 4593)
1062: Duplicate entry 'submissionKeyword-1048585-4593' for key 'controlled_vocab_symbolic'
ADOConnection._Execute(INSERT INTO controlled_vocabs (symbolic, assoc_type, assoc_id) VALUES ('submissionKeyword', 1048585, 4593)) % 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, 4593) % line 30, file: SubmissionKeywordDAO.inc.php
(mysql): SELECT * FROM controlled_vocabs WHERE symbolic = 'submissionKeyword' AND assoc_type = 1048585 AND assoc_id = 4593
(mysql): SELECT cve.* FROM controlled_vocab_entries cve WHERE cve.controlled_vocab_id = 19046 ORDER BY seq
(mysql): SELECT * FROM controlled_vocab_entry_settings WHERE controlled_vocab_entry_id = '13968'
(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'
DAMPAK KUNJUNGAN WISATAWAN TIONGKOK TERHADAP EKONOMI LOKAL DI BALI DALAM PERSPEKTIF HUBUNGAN INTERNASIONAL
DAMPAK KUNJUNGAN WISATAWAN TIONGKOK TERHADAP EKONOMI LOKAL DI BALI DALAM PERSPEKTIF HUBUNGAN INTERNASIONAL
(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 = 4593 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '6846'
(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 = 4593 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '6846'
Anti Nurul Fitriyani
Universitas Jenderal Achmad Yani
Keywords:
Bali tourism, Chinese tourists, zero-dollar tourism, international relations, pentahelix.
Abstract
This study analyzes the impact of Chinese tourist visits on Bali’s local economy using a qualitative method through interviews with tourism business actors. Findings reveal that although Chinese arrivals increase travel volume, the distribution of economic benefits remains uneven. The practice of zero-dollar tourism directs tourists exclusively to services, shops, and restaurants controlled by foreign agencies. Consequently, small and medium enterprises are marginalized, while cross-border digital payment systems such as WeChat Pay and Alipay exacerbate economic leakage since transactions bypass local financial systems and regional tax contributions. From an international relations perspective, tourism should serve as an instrument of cultural and economic diplomacy. However, this research indicates that Chinese tourists show relatively low cultural engagement with Bali, treating local traditions more as exotic spectacles than meaningful experiences. As a result, interactions tend to be transactional rather than transformational, weakening tourism’s potential as a medium for inclusive cultural exchange. Therefore, Chinese tourism in Bali represents both opportunities and challenges. The government must implement stronger regulations and promote a pentahelix collaboration among state, businesses, communities, academics, and the private sector. Such synergy is essential to develop fair and sustainable tourism while strengthening Indonesia’s economic diplomacy within bilateral cooperation with China.
(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 = 4593 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '6846'
References
Buku:
Aji, R. B., & Hermawan, E. S. (2020). Dalam Perspektif Penguatan Nasion dan Nasionalisme.
Ginaya, G. (2023). Pergulatan Diskursus Kepariwisataan dan Pasar Rusia di Bali. Garudhawaca.
Harahap, A. M. (2022). Mengenal Hubungan Internasional Madani. Unida Gontor Press.
Hutajulu, H., Runtunuwu, P. C. H., Judijanto, L., Ilma, A. F. N., Ermanda, A. P., Fitriyana, F., ... & Wardhana, D. H. A. (2024). Sustainable Economic Development: Teori dan Landasan Pembangunan Ekonomi Berkelanjutan Multi Sektor di Indonesia. PT. Sonpedia Publishing Indonesia.
MUNANDAR, H., ST, S., & MFM, M. (2024). Optimalisasi Kerja Sama Sektor Keuangan Digital Guna Meningkatkan Ekonomi Makro Dalam Rangka Ketahanan Nasional.
Muttaqin, M. Z. (2019). Franceline Anggia, Etheldreda ELT Wongkar, Ichsan Rahmanto. Seri Studi Kebudayaan III.
Nugrahajati, S. D. (2021). BATAS PEMBERITAAN: BEBAS TETAPI TIDAK BEBAS.
Pugu, M. R. (2024). Diplomasi dan Negosiasi. PT. Sonpedia Publishing Indonesia.
Press, U. G. M. (2021). Pariwisata Indonesia Kontemporer. UGM Press.
Raksapati, A., Judijanto, L., Dethan, A. G., & Rusdi, M. (2025). Bisnis Pariwisata: Peluang Bisnis dan Masa Depan Sektor Pariwisata di Indonesia. PT. Sonpedia Publishing Indonesia.
Robinson, J. (2022). Comparative Urbanism: Tactics for Global Urban Studies. John Wiley & Sons.
Sarjito, I. A., Duarte, E. P., & Sos, S. (2023). Geopolitik dan Geostrategi Pertahanan: Tantangan Keamanan Global. Indonesia Emas Group.
Teguh, F. (2024). Tata Kelola Destinasi: Membangun Ekosistem Pariwisata. UGM Press.
Waltz, K. N. (2010). Theory of International Politics. Waveland Press.
Wirawan, P. E., & Octaviany, V. (2022). Pengantar Pariwisata. Nilacakra.
Wisnawa, I. (2025). Bisnis Pariwisata di Bali: Perhotelan, Restoran, dan Agen Perjalanan.
Yuliyanto, A., & Kom, M. (2025). IDENTITAS BUDAYA. Globalisasi dan Identitas Budaya.
Yunus, A. M. A., & Ardiansyah, M. (2024). EKONOMI POLITIK. Penerbit K-Media.
Yusa, I. M. M., Yasa, I. W. A. P., Mudra, I. W., Wisnu, I. W. G., Jayanegara, I. N., Yogantari, M. V., ... & Julianto, I. N. L. (2024). Branding Bali dan Budaya Populernya. SIDYANUSA.
Sugiyono, S., & Lestari, P. (2021). Metode penelitian komunikasi (Kuantitatif, kualitatif, dan cara mudah menulis artikel pada jurnal internasional).
Afandi, S. A., & Erdayani, R. (2022). Pengantar Teori Pembangunan.
Utama, I., & Krismawintari, N. P. D. (2025). Revitalizing Bali: Exploring the Growth of Health and Wellness Tourism.
Eddyono, F. (2021). Pengelolaan destinasi pariwisata. Uwais Inspirasi Indonesia.
Jurnal:
Anwar, M. (2022). Green economy sebagai strategi dalam menangani masalah ekonomi dan multilateral. Jurnal Pajak Dan Keuangan Negara (PKN), 4(1S), 343-356.
Buditiawan, K. (2020). Strategi Pengembangan Destinasi Pariwisata Kabupaten Jember. Jurnal Kebijakan Pembangunan, 15(1), 37-50.
Darma Putra, I. N., Verheijen, B., Ardika, I. W., & Yanthy, P. S. (2021). Affinity tourism and exotic tourism in Bali. The Chinese and Indian tourist gaze in the Garuda Wisnu Kencana Park. Journal of Tourism and Cultural Change, 19(4), 427-443.
Darmawan, D., Riya, R., & Parantika, A. (2023). Potensi Pengembangan Wisata Muslim Friendly di Pulau Bali. Jurnal Ilmiah Wahana Pendidikan, 9(7), 82-91.
Kartiko, N. D. (2020). Insentif pajak dalam merespons dampak pandemi covid-19 pada sektor pariwisata. Jurnal Pajak Dan Keuangan Negara (PKN), 2(1), 124-137.
Kurniawan, R., & Iriani, F. (2024). Dampak Pariwisata Terhadap Pertumbuhan Ekonomi Daerah Marginal di Indonesia. Journal of Economic Education and Entrepreneurship Studies, 5(2), 345-356.
Mahadewi, N. M. E., Utama, I. P., Widana, I. B. A., Wiarti, L. Y., & Arcana, I. N. (2024). Charting Bali’s sustainable tourism future post-COVID-19: Key interactions and mediating factors. FMDB Transactions on Sustainable Management Letters, 2(1), 14-28.
Picaulima, Z. S., Susiatiningsih, H., & Wahyudi, F. E. (2022). Pariwisata dan praktik ilegal “jaringan Tiongkok” di Bali. Journal of International Relations Diponegoro, 8(4), 1056-1070.
Pratama, M. A. (2023). SISTEMATIK LITERATURE REVIEW DINAMIKA TREND PUBLIKASI DIPLOMASI CHINA 2012-2023.
Riani, N. K. (2021). Pariwisata adalah pisau bermata dua. Jurnal Inovasi Penelitian, 2(5), 1469-1474.
Santosa, E., Soehadha, M., & Supriyanto, H. (2021). Pertahanan Negara, Realitas Sosial Keagamaan, dan Ancaman Non-Militer Di Yogyakarta. Asketik: Jurnal Agama dan Perubahan Sosial, 5(1), 43-64.
Sentanu, I. G. E. P. S., & Mahadiansar, M. (2020). Memperkuat peran pemerintah daerah: Mengelola pariwisata lokal yang berkelanjutan. Jurnal Ilmu Administrasi Negara (JUAN), 8(1), 1-20.
Sari, A. R. W. P., & Dewi, M. H. U. (2024). PENGARUH DAYA TARIK WISATA, KUNJUNGAN WISATAWAN DAN LAMA TINGGAL WISATAWAN TERHADAP PAD KABUPATEN/KOTA PROVINSI BALI. E-Jurnal Ekonomi dan Bisnis Universitas Udayana, 13(03).
Siregar, N. A., & Dewi, M. H. U. (2025). Pengaruh Daya Tarik Wisata, Kearifan Lokal dan Kualitas Lingkungan Terhadap Minat Wisatawan Ke Bali. JAMPARING: Jurnal Akuntansi Manajemen Pariwisata dan Pembelajaran Konseling, 3(1), 342-353.
Utami, V. Y., Yusuf, S. Y. M., & Mashuri, J. (2022). Penerapan Community Based Tourism Dalam Pengembangan Pariwisata Berkelanjutan Sebagai Upaya Pemberdayaan Sosial Ekonomi Masyarakat. JCOMENT (Journal of Community Empowerment), 3(3), 219-226.
Verena, M. R. H. B., Yudha, I. M. E. K., & Suprani, M. (2025). The Impact of Tourism Sector During The Covid-19 in Bali Province. Economic Reviews Journal, 4(2), 694-708.
Wardhani, B., Hara, A. E., & Dugis, V. (2021). Crafting Taiwan-Southeast Asian relations with halal tourism. Contemporary Chinese Political Economy and Strategic Relations, 7(1), 257-XVI.
Web:
Badan Pusat Statistik Provinsi Bali. (n.d.). Banyaknya Wisatawan Mancanegara ke Bali dan Indonesia 1969–2020. Retrieved from https://bali.bps.go.id/id/statistics-table/1/MjgjMQ%3D%3D/banyaknya-wisatawan-mancanegara-ke-bali-dan-indonesia-1969-2020.html?utm_source=
United Nations General Assembly Session 26 Resolution 2758. (n.d.). Restoration of the Lawful Rights of the People's Republic of China. United Nations General Assembly Session 26 Resolution 2758 A/RES/2578 (XXVI). United Nations General Assembly.
Fitriyani, A. N. (2025). DAMPAK KUNJUNGAN WISATAWAN TIONGKOK TERHADAP EKONOMI LOKAL DI BALI DALAM PERSPEKTIF HUBUNGAN INTERNASIONAL, 2(1), 300-323. https://doi.org/https://doi.org/10.36859/dgsj.v2i2.4593
(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 = 4593 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '6846'
(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 = 'Anti Nurul'
AND a.status = 3
AND (aa.middle_name = '' OR aa.middle_name IS NULL)
AND aa.last_name = 'Fitriyani'
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 = 4593
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4593'
(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 = 4593
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1204'
(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 = 1769627401,
remember = 0,
data = 'csrf|a:2:{s:9:\"timestamp\";i:1769627402;s:5:\"token\";s:32:\"0a86c31921291b28c59798376dad90f6\";}',
domain = 'ejournal.fisip.unjani.ac.id'
WHERE session_id = '67kundous71arenl0utec1ntq2'