<hr>
(mysql): SELECT * FROM sessions WHERE session_id = 'g951ohbmd3o8f8e9o66q7qh067' &nbsp; 
<hr>
<hr>
(mysql): SELECT * FROM journals WHERE path = 'JGSS' &nbsp; 
<hr>
<hr>
(mysql): SELECT * FROM journal_settings WHERE journal_id = '4' &nbsp; 
<hr>
<hr>
(mysql): SELECT * FROM site &nbsp; 
<hr>
<hr>
(mysql): SET time_zone = '+7:00' &nbsp; 
<hr>
<hr>
(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 = '4' OR v.sitewide = 1)
			WHERE v.current = 1 AND (ps.setting_value = '1' OR v.lazy_load &lt;&gt; 1) &nbsp; 
<hr>
<hr>
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.generic.usageStats.UsageStatsLoader' &nbsp; 
<hr>
<hr>
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.datacite.DataciteInfoSender' &nbsp; 
<hr>
<hr>
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.doaj.DOAJInfoSender' &nbsp; 
<hr>
<hr>
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.medra.MedraInfoSender' &nbsp; 
<hr>
<hr>
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.crossref.CrossrefInfoSender' &nbsp; 
<hr>
<hr>
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'lib.pkp.classes.task.ReviewReminder' &nbsp; 
<hr>
<hr>
(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 = '5090' ORDER BY ps.issue_id, s.submission_id &nbsp; 
<hr>
<hr>
(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 = '5090' ORDER BY ps.issue_id, s.submission_id &nbsp; 
<hr>
<hr>
(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 = 5090 &nbsp; 
<hr>
<hr>
(mysql): SELECT * FROM submission_settings WHERE submission_id = '5090' &nbsp; 
<hr>
<hr>
(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 &gt; sf.revision)
				WHERE g.submission_id = 5090
					AND nsf.file_id IS NULL
					
				ORDER BY g.seq &nbsp; 
<hr>
<hr>
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1628' &nbsp; 
<hr>
<hr>
(mysql): SELECT i.* FROM issues i WHERE issue_id = 123 AND journal_id = 4 &nbsp; 
<hr>
<hr>
(mysql): SELECT * FROM issue_settings WHERE issue_id = '123' &nbsp; 
<hr>
<hr>
(mysql): SELECT i.* FROM issues i WHERE issue_id = 123 &nbsp; 
<hr>
<hr>
(mysql): SELECT * FROM issue_settings WHERE issue_id = '123' &nbsp; 
<hr>
<hr>
(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 = 5090  ORDER BY seq &nbsp; 
<hr>
<hr>
(mysql): SELECT * FROM author_settings WHERE author_id = '7742' &nbsp; 
<hr>
<hr>
(mysql): SELECT * FROM author_settings WHERE author_id = '7746' &nbsp; 
<hr>
<hr>
(mysql): SELECT * FROM author_settings WHERE author_id = '7747' &nbsp; 
<hr>
<hr>
(mysql): SELECT * FROM author_settings WHERE author_id = '7748' &nbsp; 
<hr>
<div class="csl-bib-body">
  <div class="csl-entry">Nursanto, Gunawan, Sunarto Sunarto, Pandji Sukmana, and Gatot Djatmiko. 2025. “Policy Diffusion, Digitalisation, and Governance Gaps in the Implementation of Indonesia’s Golden Visa Programme” 5 (2), 114-30. https://doi.org/https://doi.org/10.36859/jgss.v5i2.5090.</div>
</div><hr>
(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 = 1769625894,
					last_used = 1769625899,
					remember = 0,
					data = '',
					domain = 'ejournal.fisip.unjani.ac.id'
				WHERE session_id = 'g951ohbmd3o8f8e9o66q7qh067' &nbsp; 
<hr>