(mysql): SELECT * FROM sessions WHERE session_id = 'pkdnq0nefas6eqvhj65vrf3g93'
(mysql): INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, domain)
VALUES
('pkdnq0nefas6eqvhj65vrf3g93', '216.73.216.103', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 1769626243, 1769626243, 0, '', 'ejournal.fisip.unjani.ac.id')
(mysql): SELECT * FROM journals WHERE path = 'jurnal-dinamika-global'
(mysql): SELECT * FROM journal_settings WHERE journal_id = '3'
(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 = '3' 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 * FROM journals WHERE path = 'jurnal-dinamika-global'
(mysql): SELECT * FROM journal_settings WHERE journal_id = '3'
(mysql): SELECT * FROM navigation_menus WHERE context_id = 3
(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 = 6
ORDER BY nmh.seq
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '38'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '41'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '39'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '42'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '40'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '43'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '44'
(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 = 6
ORDER BY nmh.seq
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '38'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '41'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '39'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '42'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '40'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '43'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '44'
(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 = 7
ORDER BY nmh.seq
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '53'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '57'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '149'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '150'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '151'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '152'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '153'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '154'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '155'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '156'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '157'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '158'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '60'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '51'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '63'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '61'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '62'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '64'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '58'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '45'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '46'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '50'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '162'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '159'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '160'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '161'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '47'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '218'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '59'
(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 = 7
ORDER BY nmh.seq
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2021'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2022'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2023'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2024'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2025'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2026'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2027'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2028'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2029'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2030'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2031'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2032'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2033'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2034'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2035'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2036'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2037'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2038'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2039'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2040'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2041'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2042'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2043'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2044'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2045'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2046'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2047'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2048'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2049'
(mysql): SELECT c.* FROM journals c
WHERE c.enabled = 1 ORDER BY seq
(mysql): SELECT * FROM static_pages WHERE context_id = 3 AND path = 'issue/view/61'
(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 = '61' AND i.journal_id = 3 ORDER BY i.issue_id
(mysql): SELECT i.* FROM issues i WHERE issue_id = 61 AND journal_id = 3
(mysql): SELECT * FROM issue_settings WHERE issue_id = '61'
(mysql): SELECT * FROM genres
WHERE enabled = 1 AND context_id = 3 AND dependent = 0 AND supplementary = 0
ORDER BY seq
(mysql): SELECT * FROM genre_settings WHERE genre_id = '25'
(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 = 61 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 = 61
AND s.status <> 4
ORDER BY section_seq ASC, ps.seq ASC
(mysql): SELECT * FROM submission_settings WHERE submission_id = '1972'
(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 = 1972
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '490'
(mysql): SELECT * FROM submission_settings WHERE submission_id = '1697'
(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 = 1697
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '491'
(mysql): SELECT * FROM submission_settings WHERE submission_id = '2264'
(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 = 2264
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '488'
(mysql): SELECT * FROM submission_settings WHERE submission_id = '2265'
(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 = 2265
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '493'
(mysql): SELECT * FROM submission_settings WHERE submission_id = '2266'
(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 = 2266
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '492'
(mysql): SELECT * FROM submission_settings WHERE submission_id = '2189'
(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 = 2189
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '489'
(mysql): SELECT * FROM submission_settings WHERE submission_id = '2111'
(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 = 2111
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '487'
(mysql): SELECT * FROM submission_settings WHERE submission_id = '2183'
(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 = 2183
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '494'
(mysql): SELECT * FROM submission_settings WHERE submission_id = '1986'
(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 = 1986
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '495'
(mysql): SELECT * FROM submission_settings WHERE submission_id = '2267'
(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 = 2267
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '496'
(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 = 3
AND s.status = 1
AND st.institutional = 1
AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2026-01-29 01:50:43' >= s.date_start AND '2026-01-29 01:50:43' <= 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 = 3
AND s.status = 1
AND st.institutional = 1
AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2026-01-29 01:50:43' >= s.date_start AND '2026-01-29 01:50:43' <= 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 = 3
AND s.status = 1
AND st.institutional = 1
AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2026-01-29 01:50:43' >= s.date_start AND '2026-01-29 01:50:43' <= s.date_end)))
AND (st.format = 1
OR st.format = 17)))
(mysql): SELECT i.* FROM issues i WHERE journal_id = 3 AND current = 1
(mysql): SELECT * FROM issue_settings WHERE issue_id = '125'
Vol 9 No 1 (2024): Dinamika Global : Jurnal Ilmu 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 = 1972 AND a.include_in_browse = 1 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '2821'
(mysql): SELECT * FROM author_settings WHERE author_id = '3286'
Adre Anggia Alir, Muhamad Adian Firnas
1-22
(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 = 4523 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 = '4523'
(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 = 1697 AND a.include_in_browse = 1 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '2397'
(mysql): SELECT * FROM author_settings WHERE author_id = '2399'
Zalwa Apriliana Sesa, Hartanto Hartanto
23-40
(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 = 4525 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 = '4525'
(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 = 2264 AND a.include_in_browse = 1 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '3280'
Sugeng Riyanto
41-58
(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 = 4519 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 = '4519'
(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 = 2265 AND a.include_in_browse = 1 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '3281'
Arief Prayitno
59-85
(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 = 4529 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 = '4529'
(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 = 2266 AND a.include_in_browse = 1 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '3282'
Yusep ginanjar
86-108
(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 = 4527 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 = '4527'
(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 = 2189 AND a.include_in_browse = 1 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '3283'
(mysql): SELECT * FROM author_settings WHERE author_id = '3177'
(mysql): SELECT * FROM author_settings WHERE author_id = '3284'
Merri Merliana, Angga Nurdin Rachmat, Jusmalia Oktaviani
109-124
(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 = 4521 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 = '4521'
(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 = 2111 AND a.include_in_browse = 1 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '3285'
(mysql): SELECT * FROM author_settings WHERE author_id = '3061'
Miftah Farid, Riska Luneto
125-148
(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 = 4517 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 = '4517'
(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 = 2183 AND a.include_in_browse = 1 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '3171'
(mysql): SELECT * FROM author_settings WHERE author_id = '3170'
Muh. Rizky Hikmatullah Idrus, Harisa Firdaus Pahlawan
149-164
(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 = 4531 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 = '4531'
(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 = 1986 AND a.include_in_browse = 1 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '2863'
Letisia Karina Soeryantoputri
165-180
(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 = 4533 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 = '4533'
(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 = 2267 AND a.include_in_browse = 1 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '3287'
Asep Kamaluddin Nashir
181-195
(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 = 4536 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 = '4536'