(mysql): SELECT * FROM sessions WHERE session_id = '38r6bbldcf6ug0gjjfpqkkacq3'
(mysql): INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, domain)
VALUES
('38r6bbldcf6ug0gjjfpqkkacq3', '216.73.216.103', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 1769621978, 1769621978, 0, '', 'ejournal.fisip.unjani.ac.id')
(mysql): SELECT * FROM journals WHERE path = 'jurnal-academia-praja'
(mysql): SELECT * FROM journal_settings WHERE journal_id = '1'
(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 = '1' OR v.sitewide = 1)
WHERE v.current = 1 AND (ps.setting_value = '1' OR v.lazy_load <> 1)
(mysql): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'recommendbyauthorplugin' AND context_id = 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 setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'defaultthemeplugin' AND context_id = 1
(mysql): SELECT * FROM journals WHERE path = 'jurnal-academia-praja'
(mysql): SELECT * FROM journal_settings WHERE journal_id = '1'
(mysql): SELECT * FROM navigation_menus WHERE context_id = 1
(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 = 2
ORDER BY nmh.seq
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '8'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '11'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '9'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '12'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '10'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '13'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '14'
(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 = 2
ORDER BY nmh.seq
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '8'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '11'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '9'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '12'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '10'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '13'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '14'
(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 = 3
ORDER BY nmh.seq
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '68'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '69'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '115'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '116'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '117'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '118'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '119'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '120'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '121'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '122'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '123'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '124'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '70'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '71'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '72'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '73'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '74'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '67'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '15'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '16'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '20'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '163'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '164'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '165'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '166'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '17'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '183'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '66'
(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 = 3
ORDER BY nmh.seq
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '1838'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '1839'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '1840'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '1841'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '1842'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '1843'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '1844'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '1845'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '1846'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '1847'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '1848'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '1849'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '1850'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '1851'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '1852'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '1853'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '1854'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '1855'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '1856'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '1857'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '1858'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '1859'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '1860'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '1861'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '1862'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '1863'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '1864'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '1865'
(mysql): SELECT c.* FROM journals c
WHERE c.enabled = 1 ORDER BY seq
(mysql): SELECT * FROM static_pages WHERE context_id = 1 AND path = ''
(mysql): SELECT i.* FROM issues i WHERE journal_id = 1 AND current = 1
(mysql): SELECT * FROM issue_settings WHERE issue_id = '89'
(mysql): SELECT * FROM genres
WHERE enabled = 1 AND context_id = 1 AND dependent = 0 AND supplementary = 0
ORDER BY seq
(mysql): SELECT * FROM genre_settings WHERE genre_id = '1'
(mysql): SELECT
g.*,
f.file_name,
f.original_file_name,
f.file_type,
f.file_size,
f.content_type,
f.date_uploaded,
f.date_modified
FROM issue_galleys g
LEFT JOIN issue_files f ON (g.file_id = f.file_id)
WHERE g.issue_id = 89 ORDER BY g.seq
(mysql): SELECT DISTINCT
ps.*,
s.*,
se.abstracts_not_required AS abstracts_not_required,
se.hide_title AS section_hide_title,
se.hide_author AS section_hide_author,
COALESCE(o.seq, se.seq) AS section_seq,
ps.seq,
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')
LEFT JOIN custom_section_orders o ON (s.section_id = o.section_id AND ps.issue_id = o.issue_id)
WHERE ps.issue_id = 89
AND s.status <> 4
ORDER BY section_seq ASC, ps.seq ASC
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4417'
(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 = 4417
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1119'
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4040'
(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 = 4040
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1120'
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4051'
(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 = 4051
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1121'
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4545'
(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 = 4545
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1122'
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4546'
(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 = 4546
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1123'
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4547'
(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 = 4547
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1124'
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4549'
(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 = 4549
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1125'
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4550'
(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 = 4550
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1126'
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4551'
(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 = 4551
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1127'
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4552'
(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 = 4552
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1128'
(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 = 1
AND s.status = 1
AND st.institutional = 1
AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2026-01-29 00:39:38' >= s.date_start AND '2026-01-29 00:39:38' <= 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 = 1
AND s.status = 1
AND st.institutional = 1
AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2026-01-29 00:39:38' >= s.date_start AND '2026-01-29 00:39:38' <= 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 = 1
AND s.status = 1
AND st.institutional = 1
AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2026-01-29 00:39:38' >= s.date_start AND '2026-01-29 00:39:38' <= s.date_end)))
AND (st.format = 1
OR st.format = 17)))
(mysql): SELECT *
FROM announcements
WHERE assoc_type = 256
AND assoc_id = 1
AND (date_expire IS NULL OR DATE(date_expire) > CURRENT_DATE)
AND (DATE(date_posted) <= CURRENT_DATE)
ORDER BY date_posted DESC LIMIT 1
(mysql): SELECT i.* FROM issues i WHERE journal_id = 1 AND current = 1
(mysql): SELECT * FROM issue_settings WHERE issue_id = '89'
Jurnal Academia Praja
(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 = 4417 AND a.include_in_browse = 1 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '6521'
(mysql): SELECT * FROM author_settings WHERE author_id = '6687'
Tania Latifa Zahra, Hanantyo Sri Nugroho
196-210
(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 = 8638 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 = '8638'
(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 = 4040 AND a.include_in_browse = 1 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '6010'
(mysql): SELECT * FROM author_settings WHERE author_id = '6011'
Agus Romadhon, Harits Hijrah Wicaksana
211-227
(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 = 8640 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 = '8640'
(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 = 4051 AND a.include_in_browse = 1 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '6022'
(mysql): SELECT * FROM author_settings WHERE author_id = '6688'
(mysql): SELECT * FROM author_settings WHERE author_id = '6689'
(mysql): SELECT * FROM author_settings WHERE author_id = '6690'
(mysql): SELECT * FROM author_settings WHERE author_id = '6691'
Marzuki Marzuki, Muis Muis, M. Agmar Media, Usman Boini, Zulfikar Zulfikar
228-241
(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 = 8642 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 = '8642'
(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 = 4545 AND a.include_in_browse = 1 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '6692'
(mysql): SELECT * FROM author_settings WHERE author_id = '6693'
Riant Nugroho, Agustina Setiawan
242-259
(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 = 8645 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 = '8645'
(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 = 4546 AND a.include_in_browse = 1 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '6694'
(mysql): SELECT * FROM author_settings WHERE author_id = '6695'
Wawan Gunawan, Harky Ristala
260-274
(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 = 8648 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 = '8648'
(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 = 4547 AND a.include_in_browse = 1 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '6696'
Sukur Hermanto
275-285
(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 = 8651 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 = '8651'
(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 = 4549 AND a.include_in_browse = 1 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '6698'
(mysql): SELECT * FROM author_settings WHERE author_id = '6699'
Bayu Septiansyah, Toto Kushartono
286-299
(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 = 8654 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 = '8654'
(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 = 4550 AND a.include_in_browse = 1 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '6700'
Neneng Mastoah
300-312
(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 = 8657 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 = '8657'
(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 = 4551 AND a.include_in_browse = 1 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '6701'
(mysql): SELECT * FROM author_settings WHERE author_id = '6702'
(mysql): SELECT * FROM author_settings WHERE author_id = '6703'
Udaya Madjid, Layla Kurniawati, Indri Susiamti
313-325
(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 = 8660 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 = '8660'
(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 = 4552 AND a.include_in_browse = 1 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '6704'
(mysql): SELECT * FROM author_settings WHERE author_id = '6705'
Neneng Widya Amellia, Wawan Budi Darmawan
326-340
(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 = 8664 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 = '8664'
Magister Ilmu Pemerintahan Fakultas Ilmu Sosial dan Ilmu Politik Universitas Jenderal Achmad Yani Jl. Ters. Jenderal Sudirman 40531 Telepon: (022) 6650645 Email: academiapraja@unjani.ac.id
Principal Contact
Harky Ristala Magister Ilmu Pemerintahan Universitas Jenderal Achmad Yani Magister Ilmu Pemerintahan Fakultas Ilmu Sosial dan Ilmu Politik Universitas Jenderal Achmad Yani Jl. Ters. Jenderal Sudirman 40531 Telepon: (022) 6650645 Email: academiapraja@unjani.ac.id